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

28 rows where bill_id = "113-s-2016"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
113-s-2016,Agricultural conservation and pollution California Emergency Drought Relief Act of 2014 113-s-2016 Agricultural conservation and pollution
113-s-2016,Agricultural practices and innovations California Emergency Drought Relief Act of 2014 113-s-2016 Agricultural practices and innovations
113-s-2016,Appropriations California Emergency Drought Relief Act of 2014 113-s-2016 Appropriations
113-s-2016,Aquaculture California Emergency Drought Relief Act of 2014 113-s-2016 Aquaculture
113-s-2016,Atmospheric science and weather California Emergency Drought Relief Act of 2014 113-s-2016 Atmospheric science and weather
113-s-2016,California California Emergency Drought Relief Act of 2014 113-s-2016 California
113-s-2016,Department of Agriculture California Emergency Drought Relief Act of 2014 113-s-2016 Department of Agriculture
113-s-2016,Disaster relief and insurance California Emergency Drought Relief Act of 2014 113-s-2016 Disaster relief and insurance
113-s-2016,Ecology California Emergency Drought Relief Act of 2014 113-s-2016 Ecology
113-s-2016,Emergency planning and evacuation California Emergency Drought Relief Act of 2014 113-s-2016 Emergency planning and evacuation
113-s-2016,Endangered and threatened species California Emergency Drought Relief Act of 2014 113-s-2016 Endangered and threatened species
113-s-2016,Environmental assessment, monitoring, research California Emergency Drought Relief Act of 2014 113-s-2016 Environmental assessment, monitoring, research
113-s-2016,Executive agency funding and structure California Emergency Drought Relief Act of 2014 113-s-2016 Executive agency funding and structure
113-s-2016,Farmland California Emergency Drought Relief Act of 2014 113-s-2016 Farmland
113-s-2016,Fires California Emergency Drought Relief Act of 2014 113-s-2016 Fires
113-s-2016,Fishes California Emergency Drought Relief Act of 2014 113-s-2016 Fishes
113-s-2016,Forests, forestry, trees California Emergency Drought Relief Act of 2014 113-s-2016 Forests, forestry, trees
113-s-2016,Insects California Emergency Drought Relief Act of 2014 113-s-2016 Insects
113-s-2016,Lakes and rivers California Emergency Drought Relief Act of 2014 113-s-2016 Lakes and rivers
113-s-2016,Licensing and registrations California Emergency Drought Relief Act of 2014 113-s-2016 Licensing and registrations
113-s-2016,Livestock California Emergency Drought Relief Act of 2014 113-s-2016 Livestock
113-s-2016,Migrant, seasonal, agricultural labor California Emergency Drought Relief Act of 2014 113-s-2016 Migrant, seasonal, agricultural labor
113-s-2016,Natural disasters California Emergency Drought Relief Act of 2014 113-s-2016 Natural disasters
113-s-2016,Water resources funding California Emergency Drought Relief Act of 2014 113-s-2016 Water resources funding
113-s-2016,Water storage California Emergency Drought Relief Act of 2014 113-s-2016 Water storage
113-s-2016,Water use and supply California Emergency Drought Relief Act of 2014 113-s-2016 Water use and supply
113-s-2016,Watersheds California Emergency Drought Relief Act of 2014 113-s-2016 Watersheds
113-s-2016,Wilderness and natural areas, wildlife refuges, wild rivers, habitats California Emergency Drought Relief Act of 2014 113-s-2016 Wilderness and natural areas, wildlife refuges, wild rivers, habitats

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