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 = "116-s-613"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
116-s-613,Agricultural research DEER Act 116-s-613 Agricultural research
116-s-613,Animal and plant health DEER Act 116-s-613 Animal and plant health
116-s-613,Congressional oversight DEER Act 116-s-613 Congressional oversight
116-s-613,Department of Agriculture DEER Act 116-s-613 Department of Agriculture
116-s-613,Education programs funding DEER Act 116-s-613 Education programs funding
116-s-613,Executive agency funding and structure DEER Act 116-s-613 Executive agency funding and structure
116-s-613,Government studies and investigations DEER Act 116-s-613 Government studies and investigations
116-s-613,Higher education DEER Act 116-s-613 Higher education
116-s-613,Infectious and parasitic diseases DEER Act 116-s-613 Infectious and parasitic diseases
116-s-613,Mammals DEER Act 116-s-613 Mammals
116-s-613,Medical research DEER Act 116-s-613 Medical research
116-s-613,Neurological disorders DEER Act 116-s-613 Neurological disorders
116-s-613,Research administration and funding DEER Act 116-s-613 Research administration and funding
116-s-613,State and local government operations DEER Act 116-s-613 State and local government operations
116-s-613,Veterinary medicine and animal diseases DEER Act 116-s-613 Veterinary medicine and animal diseases
116-s-613,Wildlife conservation and habitat protection DEER Act 116-s-613 Wildlife conservation and habitat protection

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