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

19 rows where bill_id = "102-s-2016"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
102-s-2016,Anadromous fishes Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Anadromous fishes
102-s-2016,Biological research Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Biological research
102-s-2016,California Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 California
102-s-2016,Central Valley Reclamation Project (California) Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Central Valley Reclamation Project (California)
102-s-2016,Cost effectiveness Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Cost effectiveness
102-s-2016,Costs Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Costs
102-s-2016,Dams Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Dams
102-s-2016,Environmental Protection Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Environmental Protection
102-s-2016,Estuaries Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Estuaries
102-s-2016,Federal advisory bodies Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Federal advisory bodies
102-s-2016,Federal aid to research Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Federal aid to research
102-s-2016,Federal aid to water resources development Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Federal aid to water resources development
102-s-2016,Federally-guaranteed loans Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Federally-guaranteed loans
102-s-2016,Fish culture Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Fish culture
102-s-2016,Fishery management Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Fishery management
102-s-2016,Groundwater Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Groundwater
102-s-2016,Irrigation Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Irrigation
102-s-2016,Mine wastes Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 Mine wastes
102-s-2016,State laws Central Valley Project Fish and Wildlife Act of 1991 102-s-2016 State laws

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