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

10 rows where bill_id = "116-s-4530"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
116-s-4530,Advanced technology and technological innovations Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Advanced technology and technological innovations
116-s-4530,Atmospheric science and weather Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Atmospheric science and weather
116-s-4530,Congressional oversight Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Congressional oversight
116-s-4530,Environmental assessment, monitoring, research Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Environmental assessment, monitoring, research
116-s-4530,Environmental technology Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Environmental technology
116-s-4530,Hydrology and hydrography Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Hydrology and hydrography
116-s-4530,Lakes and rivers Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Lakes and rivers
116-s-4530,Water resources funding Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Water resources funding
116-s-4530,Water use and supply Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Water use and supply
116-s-4530,Watersheds Snow Water Supply Forecasting Program Authorization Act 116-s-4530 Watersheds

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