openregs: legislation_subjects: 14 rows where bill

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

14 rows where bill_id = "112-s-2154"

descending

Link	bill_id	subject
112-s-2154,Alaska	Arctic Science Endowment Act 112-s-2154	Alaska
112-s-2154,Arctic Ocean	Arctic Science Endowment Act 112-s-2154	Arctic Ocean
112-s-2154,Climate change and greenhouse gases	Arctic Science Endowment Act 112-s-2154	Climate change and greenhouse gases
112-s-2154,Ecology	Arctic Science Endowment Act 112-s-2154	Ecology
112-s-2154,Environmental assessment, monitoring, research	Arctic Science Endowment Act 112-s-2154	Environmental assessment, monitoring, research
112-s-2154,Fishes	Arctic Science Endowment Act 112-s-2154	Fishes
112-s-2154,Government trust funds	Arctic Science Endowment Act 112-s-2154	Government trust funds
112-s-2154,Mammals	Arctic Science Endowment Act 112-s-2154	Mammals
112-s-2154,Marine and coastal resources, fisheries	Arctic Science Endowment Act 112-s-2154	Marine and coastal resources, fisheries
112-s-2154,Marine and inland water transportation	Arctic Science Endowment Act 112-s-2154	Marine and inland water transportation
112-s-2154,Navigation, waterways, harbors	Arctic Science Endowment Act 112-s-2154	Navigation, waterways, harbors
112-s-2154,Research administration and funding	Arctic Science Endowment Act 112-s-2154	Research administration and funding
112-s-2154,Sales and excise taxes	Arctic Science Endowment Act 112-s-2154	Sales and excise taxes
112-s-2154,Wildlife conservation and habitat protection	Arctic Science Endowment Act 112-s-2154	Wildlife conservation and habitat protection

Advanced export

JSON shape: default, array, newline-delimited, object

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