home / openregs

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

14 rows where bill_id = "97-s-2114"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2114,Agriculture and Rural Affairs Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Agriculture and Rural Affairs
97-s-2114,Arizona Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Arizona
97-s-2114,Department of the Treasury Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Department of the Treasury
97-s-2114,Dry farming Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Dry farming
97-s-2114,Farms Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Farms
97-s-2114,Government liability Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Government liability
97-s-2114,Government trust funds Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Government trust funds
97-s-2114,Indian claims Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Indian claims
97-s-2114,Indian lands Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Indian lands
97-s-2114,Indian water rights Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Indian water rights
97-s-2114,Irrigation Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Irrigation
97-s-2114,Public Lands and Real Property Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Public Lands and Real Property
97-s-2114,Water and Water Resources Development Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 Water and Water Resources Development
97-s-2114,Water supply Southern Arizona Water Rights Settlement Act of 1982 97-s-2114 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);
Powered by Datasette · Queries took 4.141ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API