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

2 rows where bill_id = "99-hr-4792"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
99-hr-4792,Armed forces reserves A bill to amend title 10, United States Code, to prescribe the period for eligibility for use of commissary stores attributable to performance of active duty for training by members of the Selected Reserve. 99-hr-4792 Armed forces reserves
99-hr-4792,Post exchanges A bill to amend title 10, United States Code, to prescribe the period for eligibility for use of commissary stores attributable to performance of active duty for training by members of the Selected Reserve. 99-hr-4792 Post exchanges

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