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

12 rows where bill_id = "108-hr-2425"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
108-hr-2425,Auditing Quinault Permanent Fisheries Fund Act 108-hr-2425 Auditing
108-hr-2425,Economics and Public Finance Quinault Permanent Fisheries Fund Act 108-hr-2425 Economics and Public Finance
108-hr-2425,Finance and Financial Sector Quinault Permanent Fisheries Fund Act 108-hr-2425 Finance and Financial Sector
108-hr-2425,Fisheries Quinault Permanent Fisheries Fund Act 108-hr-2425 Fisheries
108-hr-2425,Fishery management Quinault Permanent Fisheries Fund Act 108-hr-2425 Fishery management
108-hr-2425,Government trust funds Quinault Permanent Fisheries Fund Act 108-hr-2425 Government trust funds
108-hr-2425,Indian claims Quinault Permanent Fisheries Fund Act 108-hr-2425 Indian claims
108-hr-2425,Interest Quinault Permanent Fisheries Fund Act 108-hr-2425 Interest
108-hr-2425,Investments Quinault Permanent Fisheries Fund Act 108-hr-2425 Investments
108-hr-2425,Marine and coastal resources, fisheries Quinault Permanent Fisheries Fund Act 108-hr-2425 Marine and coastal resources, fisheries
108-hr-2425,Minorities Quinault Permanent Fisheries Fund Act 108-hr-2425 Minorities
108-hr-2425,Washington State Quinault Permanent Fisheries Fund Act 108-hr-2425 Washington State

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