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 = "109-hr-4049"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
109-hr-4049,Ecological surveys Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Ecological surveys
109-hr-4049,Economics and Public Finance Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Economics and Public Finance
109-hr-4049,Environmental Protection Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Environmental Protection
109-hr-4049,Environmental monitoring Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Environmental monitoring
109-hr-4049,Exotic plants Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Exotic plants
109-hr-4049,Federal-local relations Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Federal-local relations
109-hr-4049,Federal-state relations Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Federal-state relations
109-hr-4049,Federal-territorial relations Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Federal-territorial relations
109-hr-4049,Government Operations and Politics Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Government Operations and Politics
109-hr-4049,Government paperwork Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Government paperwork
109-hr-4049,Grants-in-aid Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Grants-in-aid
109-hr-4049,Non-native species Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Non-native species
109-hr-4049,Pest control Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Pest control
109-hr-4049,Public Lands and Natural Resources Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Public Lands and Natural Resources
109-hr-4049,Risk Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Risk
109-hr-4049,Weeds Early Pest Detection and Surveillance Improvement Act 109-hr-4049 Weeds

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