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 = "105-hr-4792"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-hr-4792,Adoption District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Adoption
105-hr-4792,Competitive bidding District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Competitive bidding
105-hr-4792,Congress District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Congress
105-hr-4792,Congressional reporting requirements District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Congressional reporting requirements
105-hr-4792,Data banks District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Data banks
105-hr-4792,District of Columbia District of Columbia Adoption Improvement Act of 1998 105-hr-4792 District of Columbia
105-hr-4792,Government Operations and Politics District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Government Operations and Politics
105-hr-4792,Government paperwork District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Government paperwork
105-hr-4792,Government service contracts District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Government service contracts
105-hr-4792,Municipal politics and government District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Municipal politics and government
105-hr-4792,Science, Technology, Communications District of Columbia Adoption Improvement Act of 1998 105-hr-4792 Science, Technology, Communications

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