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-2002"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-2002,Clothing industry A bill to modify the marking of certain silk products and their containers. 105-s-2002 Clothing industry
105-s-2002,Commerce A bill to modify the marking of certain silk products and their containers. 105-s-2002 Commerce
105-s-2002,Imports A bill to modify the marking of certain silk products and their containers. 105-s-2002 Imports
105-s-2002,Labeling A bill to modify the marking of certain silk products and their containers. 105-s-2002 Labeling
105-s-2002,Silk industry A bill to modify the marking of certain silk products and their containers. 105-s-2002 Silk industry
105-s-2002,Textile fabrics A bill to modify the marking of certain silk products and their containers. 105-s-2002 Textile fabrics

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