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

5 rows where bill_id = "95-s-2001"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
95-s-2001,Authorization An Act authorizing additional appropriations for prosecution of projects in certain comprehensive river basin plans for flood control, water conservation, recreation, and hydroelectric power, and for other purposes. 95-s-2001 Authorization
95-s-2001,Economics and Public Finance An Act authorizing additional appropriations for prosecution of projects in certain comprehensive river basin plans for flood control, water conservation, recreation, and hydroelectric power, and for other purposes. 95-s-2001 Economics and Public Finance
95-s-2001,Public works An Act authorizing additional appropriations for prosecution of projects in certain comprehensive river basin plans for flood control, water conservation, recreation, and hydroelectric power, and for other purposes. 95-s-2001 Public works
95-s-2001,River basin commissions An Act authorizing additional appropriations for prosecution of projects in certain comprehensive river basin plans for flood control, water conservation, recreation, and hydroelectric power, and for other purposes. 95-s-2001 River basin commissions
95-s-2001,Rivers An Act authorizing additional appropriations for prosecution of projects in certain comprehensive river basin plans for flood control, water conservation, recreation, and hydroelectric power, and for other purposes. 95-s-2001 Rivers

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