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

16 rows where bill_id = "104-s-2003"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
104-s-2003,Accident prevention Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Accident prevention
104-s-2003,Criminal justice information Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Criminal justice information
104-s-2003,Emergency Management Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Emergency Management
104-s-2003,Employee training Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Employee training
104-s-2003,Federal preemption Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Federal preemption
104-s-2003,Firearms Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Firearms
104-s-2003,Firearms control Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Firearms control
104-s-2003,Government Operations and Politics Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Government Operations and Politics
104-s-2003,Government paperwork Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Government paperwork
104-s-2003,Interstate relations Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Interstate relations
104-s-2003,Labor and Employment Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Labor and Employment
104-s-2003,Law Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Law
104-s-2003,Licenses Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Licenses
104-s-2003,Police training Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Police training
104-s-2003,Private police Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 Private police
104-s-2003,State laws Armored Car Industry Reciprocity Improvement Act of 1996 104-s-2003 State laws

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