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

7 rows where bill_id = "107-hr-5108"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-hr-5108,California To authorize leases for terms not to exceed 99 years on lands held in trust for the Yurok Tribe and the Hopland Band of Pomo Indians. 107-hr-5108 California
107-hr-5108,Commerce To authorize leases for terms not to exceed 99 years on lands held in trust for the Yurok Tribe and the Hopland Band of Pomo Indians. 107-hr-5108 Commerce
107-hr-5108,Federal-Indian relations To authorize leases for terms not to exceed 99 years on lands held in trust for the Yurok Tribe and the Hopland Band of Pomo Indians. 107-hr-5108 Federal-Indian relations
107-hr-5108,Government Operations and Politics To authorize leases for terms not to exceed 99 years on lands held in trust for the Yurok Tribe and the Hopland Band of Pomo Indians. 107-hr-5108 Government Operations and Politics
107-hr-5108,Indian lands To authorize leases for terms not to exceed 99 years on lands held in trust for the Yurok Tribe and the Hopland Band of Pomo Indians. 107-hr-5108 Indian lands
107-hr-5108,Leases To authorize leases for terms not to exceed 99 years on lands held in trust for the Yurok Tribe and the Hopland Band of Pomo Indians. 107-hr-5108 Leases
107-hr-5108,Minorities To authorize leases for terms not to exceed 99 years on lands held in trust for the Yurok Tribe and the Hopland Band of Pomo Indians. 107-hr-5108 Minorities

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