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

8 rows where bill_id = "99-s-1122"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
99-s-1122,Flood control A bill to modify the project for flood protection on the Chariton River, Iowa and Missouri, to direct the Secretary of the Army to sell storage space in Rathbun Lake, Iowa, to the Rathbun Regional Water Association, and for other purposes. 99-s-1122 Flood control
99-s-1122,Iowa A bill to modify the project for flood protection on the Chariton River, Iowa and Missouri, to direct the Secretary of the Army to sell storage space in Rathbun Lake, Iowa, to the Rathbun Regional Water Association, and for other purposes. 99-s-1122 Iowa
99-s-1122,Lakes A bill to modify the project for flood protection on the Chariton River, Iowa and Missouri, to direct the Secretary of the Army to sell storage space in Rathbun Lake, Iowa, to the Rathbun Regional Water Association, and for other purposes. 99-s-1122 Lakes
99-s-1122,Missouri A bill to modify the project for flood protection on the Chariton River, Iowa and Missouri, to direct the Secretary of the Army to sell storage space in Rathbun Lake, Iowa, to the Rathbun Regional Water Association, and for other purposes. 99-s-1122 Missouri
99-s-1122,Rivers A bill to modify the project for flood protection on the Chariton River, Iowa and Missouri, to direct the Secretary of the Army to sell storage space in Rathbun Lake, Iowa, to the Rathbun Regional Water Association, and for other purposes. 99-s-1122 Rivers
99-s-1122,Water and Water Resources Development A bill to modify the project for flood protection on the Chariton River, Iowa and Missouri, to direct the Secretary of the Army to sell storage space in Rathbun Lake, Iowa, to the Rathbun Regional Water Association, and for other purposes. 99-s-1122 Water and Water Resources Development
99-s-1122,Water storage A bill to modify the project for flood protection on the Chariton River, Iowa and Missouri, to direct the Secretary of the Army to sell storage space in Rathbun Lake, Iowa, to the Rathbun Regional Water Association, and for other purposes. 99-s-1122 Water storage
99-s-1122,Water supply A bill to modify the project for flood protection on the Chariton River, Iowa and Missouri, to direct the Secretary of the Army to sell storage space in Rathbun Lake, Iowa, to the Rathbun Regional Water Association, and for other purposes. 99-s-1122 Water supply

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