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

4 rows where bill_id = "93-sconres-101"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
93-sconres-101,Cemeteries and funerals Resolved by the House of Representatives that the Architect of the Capitol is authorized and directed to transfer to the custody of the Chief Justice of the United States the catafalque which is presently situated in the crypt beneath the rotunda of the Capitol. 93-sconres-101 Cemeteries and funerals
93-sconres-101,Judges Resolved by the House of Representatives that the Architect of the Capitol is authorized and directed to transfer to the custody of the Chief Justice of the United States the catafalque which is presently situated in the crypt beneath the rotunda of the Capitol. 93-sconres-101 Judges
93-sconres-101,Supreme Court Resolved by the House of Representatives that the Architect of the Capitol is authorized and directed to transfer to the custody of the Chief Justice of the United States the catafalque which is presently situated in the crypt beneath the rotunda of the Capitol. 93-sconres-101 Supreme Court
93-sconres-101,U.S. Capitol Resolved by the House of Representatives that the Architect of the Capitol is authorized and directed to transfer to the custody of the Chief Justice of the United States the catafalque which is presently situated in the crypt beneath the rotunda of the Capitol. 93-sconres-101 U.S. Capitol

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