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

19 rows where bill_id = "105-hr-1805"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-hr-1805,California Auburn Indian Restoration Amendment Act 105-hr-1805 California
105-hr-1805,Commerce Auburn Indian Restoration Amendment Act 105-hr-1805 Commerce
105-hr-1805,Commercial arbitration Auburn Indian Restoration Amendment Act 105-hr-1805 Commercial arbitration
105-hr-1805,Environmental Protection Auburn Indian Restoration Amendment Act 105-hr-1805 Environmental Protection
105-hr-1805,Environmental assessment Auburn Indian Restoration Amendment Act 105-hr-1805 Environmental assessment
105-hr-1805,Government Operations and Politics Auburn Indian Restoration Amendment Act 105-hr-1805 Government Operations and Politics
105-hr-1805,Government publicity Auburn Indian Restoration Amendment Act 105-hr-1805 Government publicity
105-hr-1805,Housing and Community Development Auburn Indian Restoration Amendment Act 105-hr-1805 Housing and Community Development
105-hr-1805,Housing codes Auburn Indian Restoration Amendment Act 105-hr-1805 Housing codes
105-hr-1805,Indian gambling operations Auburn Indian Restoration Amendment Act 105-hr-1805 Indian gambling operations
105-hr-1805,Indian lands Auburn Indian Restoration Amendment Act 105-hr-1805 Indian lands
105-hr-1805,Injunctions Auburn Indian Restoration Amendment Act 105-hr-1805 Injunctions
105-hr-1805,Intergovernmental relations Auburn Indian Restoration Amendment Act 105-hr-1805 Intergovernmental relations
105-hr-1805,Land transfers Auburn Indian Restoration Amendment Act 105-hr-1805 Land transfers
105-hr-1805,Land use Auburn Indian Restoration Amendment Act 105-hr-1805 Land use
105-hr-1805,Law Auburn Indian Restoration Amendment Act 105-hr-1805 Law
105-hr-1805,Local finance Auburn Indian Restoration Amendment Act 105-hr-1805 Local finance
105-hr-1805,Minorities Auburn Indian Restoration Amendment Act 105-hr-1805 Minorities
105-hr-1805,Public Lands and Natural Resources Auburn Indian Restoration Amendment Act 105-hr-1805 Public Lands and Natural Resources

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