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

16 rows where bill_id = "110-s-1473"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-s-1473,Agriculture and Food Madera Water Supply Enhancement Act 110-s-1473 Agriculture and Food
110-s-1473,California Madera Water Supply Enhancement Act 110-s-1473 California
110-s-1473,Construction costs Madera Water Supply Enhancement Act 110-s-1473 Construction costs
110-s-1473,Economics and Public Finance Madera Water Supply Enhancement Act 110-s-1473 Economics and Public Finance
110-s-1473,Environmental Protection Madera Water Supply Enhancement Act 110-s-1473 Environmental Protection
110-s-1473,Environmental assessment Madera Water Supply Enhancement Act 110-s-1473 Environmental assessment
110-s-1473,Federal aid to water resources development Madera Water Supply Enhancement Act 110-s-1473 Federal aid to water resources development
110-s-1473,Federal-local relations Madera Water Supply Enhancement Act 110-s-1473 Federal-local relations
110-s-1473,Government Operations and Politics Madera Water Supply Enhancement Act 110-s-1473 Government Operations and Politics
110-s-1473,Governmental investigations Madera Water Supply Enhancement Act 110-s-1473 Governmental investigations
110-s-1473,Infrastructure Madera Water Supply Enhancement Act 110-s-1473 Infrastructure
110-s-1473,Intergovernmental fiscal relations Madera Water Supply Enhancement Act 110-s-1473 Intergovernmental fiscal relations
110-s-1473,Irrigation Madera Water Supply Enhancement Act 110-s-1473 Irrigation
110-s-1473,Irrigation districts Madera Water Supply Enhancement Act 110-s-1473 Irrigation districts
110-s-1473,Water storage Madera Water Supply Enhancement Act 110-s-1473 Water storage
110-s-1473,Water supply Madera Water Supply Enhancement Act 110-s-1473 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 1.292ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy