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

19 rows where bill_id = "104-s-2016"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
104-s-2016,Agriculture and Food NAFTA Accountability Act 104-s-2016 Agriculture and Food
104-s-2016,Agriculture in foreign trade NAFTA Accountability Act 104-s-2016 Agriculture in foreign trade
104-s-2016,Air pollution control NAFTA Accountability Act 104-s-2016 Air pollution control
104-s-2016,Bacterial diseases NAFTA Accountability Act 104-s-2016 Bacterial diseases
104-s-2016,Balance of payments NAFTA Accountability Act 104-s-2016 Balance of payments
104-s-2016,Barley NAFTA Accountability Act 104-s-2016 Barley
104-s-2016,Birth defects NAFTA Accountability Act 104-s-2016 Birth defects
104-s-2016,Boundaries NAFTA Accountability Act 104-s-2016 Boundaries
104-s-2016,Bus drivers NAFTA Accountability Act 104-s-2016 Bus drivers
104-s-2016,Canada NAFTA Accountability Act 104-s-2016 Canada
104-s-2016,Child health NAFTA Accountability Act 104-s-2016 Child health
104-s-2016,Cholera NAFTA Accountability Act 104-s-2016 Cholera
104-s-2016,Civil Rights and Liberties, Minority Issues NAFTA Accountability Act 104-s-2016 Civil Rights and Liberties, Minority Issues
104-s-2016,Clothing industry NAFTA Accountability Act 104-s-2016 Clothing industry
104-s-2016,Commerce NAFTA Accountability Act 104-s-2016 Commerce
104-s-2016,Congress NAFTA Accountability Act 104-s-2016 Congress
104-s-2016,Congress and foreign policy NAFTA Accountability Act 104-s-2016 Congress and foreign policy
104-s-2016,Congressional oversight NAFTA Accountability Act 104-s-2016 Congressional oversight
104-s-2016,Congressional reporting requirements NAFTA Accountability Act 104-s-2016 Congressional reporting requirements

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