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

12 rows where bill_id = "104-hconres-216"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
104-hconres-216,Anniversaries Providing for relocation of the Portrait Monument. 104-hconres-216 Anniversaries
104-hconres-216,Arts, Culture, Religion Providing for relocation of the Portrait Monument. 104-hconres-216 Arts, Culture, Religion
104-hconres-216,Capitol (Washington, D.C.) Providing for relocation of the Portrait Monument. 104-hconres-216 Capitol (Washington, D.C.)
104-hconres-216,Civil Rights and Liberties, Minority Issues Providing for relocation of the Portrait Monument. 104-hconres-216 Civil Rights and Liberties, Minority Issues
104-hconres-216,Commemorations Providing for relocation of the Portrait Monument. 104-hconres-216 Commemorations
104-hconres-216,Federal advisory bodies Providing for relocation of the Portrait Monument. 104-hconres-216 Federal advisory bodies
104-hconres-216,Government Operations and Politics Providing for relocation of the Portrait Monument. 104-hconres-216 Government Operations and Politics
104-hconres-216,Monuments and memorials Providing for relocation of the Portrait Monument. 104-hconres-216 Monuments and memorials
104-hconres-216,Rights of women Providing for relocation of the Portrait Monument. 104-hconres-216 Rights of women
104-hconres-216,Sculpture Providing for relocation of the Portrait Monument. 104-hconres-216 Sculpture
104-hconres-216,Women Providing for relocation of the Portrait Monument. 104-hconres-216 Women
104-hconres-216,Women's voting Providing for relocation of the Portrait Monument. 104-hconres-216 Women's voting

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);