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

6 rows where bill_id = "105-s-2016"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-2016,Commerce A bill to suspend temporarily the duty on shadow mask steel. 105-s-2016 Commerce
105-s-2016,Iron and steel industry A bill to suspend temporarily the duty on shadow mask steel. 105-s-2016 Iron and steel industry
105-s-2016,Science, Technology, Communications A bill to suspend temporarily the duty on shadow mask steel. 105-s-2016 Science, Technology, Communications
105-s-2016,Steel A bill to suspend temporarily the duty on shadow mask steel. 105-s-2016 Steel
105-s-2016,Tariff A bill to suspend temporarily the duty on shadow mask steel. 105-s-2016 Tariff
105-s-2016,Video display terminals A bill to suspend temporarily the duty on shadow mask steel. 105-s-2016 Video display terminals

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