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

21 rows where bill_id = "109-s-4100"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
109-s-4100,Administrative fees Secure Travel and Counterterrorism Partnership Act 109-s-4100 Administrative fees
109-s-4100,Admission of nonimmigrants Secure Travel and Counterterrorism Partnership Act 109-s-4100 Admission of nonimmigrants
109-s-4100,Congress Secure Travel and Counterterrorism Partnership Act 109-s-4100 Congress
109-s-4100,Congressional investigations Secure Travel and Counterterrorism Partnership Act 109-s-4100 Congressional investigations
109-s-4100,Congressional reporting requirements Secure Travel and Counterterrorism Partnership Act 109-s-4100 Congressional reporting requirements
109-s-4100,Counterfeiting Secure Travel and Counterterrorism Partnership Act 109-s-4100 Counterfeiting
109-s-4100,Crime and Law Enforcement Secure Travel and Counterterrorism Partnership Act 109-s-4100 Crime and Law Enforcement
109-s-4100,Economics and Public Finance Secure Travel and Counterterrorism Partnership Act 109-s-4100 Economics and Public Finance
109-s-4100,Electronic data interchange Secure Travel and Counterterrorism Partnership Act 109-s-4100 Electronic data interchange
109-s-4100,Fraud Secure Travel and Counterterrorism Partnership Act 109-s-4100 Fraud
109-s-4100,Identification devices Secure Travel and Counterterrorism Partnership Act 109-s-4100 Identification devices
109-s-4100,International Affairs Secure Travel and Counterterrorism Partnership Act 109-s-4100 International Affairs
109-s-4100,International cooperation Secure Travel and Counterterrorism Partnership Act 109-s-4100 International cooperation
109-s-4100,Law Secure Travel and Counterterrorism Partnership Act 109-s-4100 Law
109-s-4100,Passports Secure Travel and Counterterrorism Partnership Act 109-s-4100 Passports
109-s-4100,Science, Technology, Communications Secure Travel and Counterterrorism Partnership Act 109-s-4100 Science, Technology, Communications
109-s-4100,Standards Secure Travel and Counterterrorism Partnership Act 109-s-4100 Standards
109-s-4100,Strategic planning Secure Travel and Counterterrorism Partnership Act 109-s-4100 Strategic planning
109-s-4100,Technical assistance Secure Travel and Counterterrorism Partnership Act 109-s-4100 Technical assistance
109-s-4100,Terrorism Secure Travel and Counterterrorism Partnership Act 109-s-4100 Terrorism
109-s-4100,Visas Secure Travel and Counterterrorism Partnership Act 109-s-4100 Visas

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