legislation_subjects

CRS legislative subject terms assigned to bills, useful for filtering by topic.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

15 rows where bill_id = "105-sres-313"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-sres-313,Churches A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Churches
105-sres-313,Civil Rights and Liberties, Minority Issues A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Civil Rights and Liberties, Minority Issues
105-sres-313,Congress A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Congress
105-sres-313,Crime and Law Enforcement A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Crime and Law Enforcement
105-sres-313,Gays A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Gays
105-sres-313,Hate crimes A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Hate crimes
105-sres-313,Members of Congress A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Members of Congress
105-sres-313,Minorities A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Minorities
105-sres-313,Murder A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Murder
105-sres-313,Prejudice A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Prejudice
105-sres-313,Religion A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Religion
105-sres-313,Synagogues A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Synagogues
105-sres-313,Torture A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Torture
105-sres-313,Violence A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Violence
105-sres-313,Wyoming A resolution expressing the sense of the Senate with respect to the brutal killing of Mr. Matthew Shepard. 105-sres-313 Wyoming

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE legislation_subjects (
    bill_id TEXT REFERENCES legislation(bill_id),
    subject TEXT,
    PRIMARY KEY (bill_id, subject)
);
CREATE INDEX idx_legsub_subject ON legislation_subjects(subject);