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

11 rows where bill_id = "118-s-2385"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
118-s-2385,Government lending and loan guarantees Tribal Access to Clean Water Act of 2023 118-s-2385 Government lending and loan guarantees
118-s-2385,Health programs administration and funding Tribal Access to Clean Water Act of 2023 118-s-2385 Health programs administration and funding
118-s-2385,Indian lands and resources rights Tribal Access to Clean Water Act of 2023 118-s-2385 Indian lands and resources rights
118-s-2385,Indian social and development programs Tribal Access to Clean Water Act of 2023 118-s-2385 Indian social and development programs
118-s-2385,Minority health Tribal Access to Clean Water Act of 2023 118-s-2385 Minority health
118-s-2385,Rural conditions and development Tribal Access to Clean Water Act of 2023 118-s-2385 Rural conditions and development
118-s-2385,Solid waste and recycling Tribal Access to Clean Water Act of 2023 118-s-2385 Solid waste and recycling
118-s-2385,State and local finance Tribal Access to Clean Water Act of 2023 118-s-2385 State and local finance
118-s-2385,Water quality Tribal Access to Clean Water Act of 2023 118-s-2385 Water quality
118-s-2385,Water resources funding Tribal Access to Clean Water Act of 2023 118-s-2385 Water resources funding
118-s-2385,Water use and supply Tribal Access to Clean Water Act of 2023 118-s-2385 Water use and 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);