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 = "93-hr-17677"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
93-hr-17677,Conservation of natural resources A bill to amend the Land and Water Conservation Fund Act of 1965 to require payments by States to local jurisdictions in lieu of taxes, to increase the authorization of appropriation for the Land and Water Conservation Fund. 93-hr-17677 Conservation of natural resources
93-hr-17677,Government Operations and Politics A bill to amend the Land and Water Conservation Fund Act of 1965 to require payments by States to local jurisdictions in lieu of taxes, to increase the authorization of appropriation for the Land and Water Conservation Fund. 93-hr-17677 Government Operations and Politics
93-hr-17677,Intergovernmental relations A bill to amend the Land and Water Conservation Fund Act of 1965 to require payments by States to local jurisdictions in lieu of taxes, to increase the authorization of appropriation for the Land and Water Conservation Fund. 93-hr-17677 Intergovernmental relations
93-hr-17677,Intergovernmental tax relations A bill to amend the Land and Water Conservation Fund Act of 1965 to require payments by States to local jurisdictions in lieu of taxes, to increase the authorization of appropriation for the Land and Water Conservation Fund. 93-hr-17677 Intergovernmental tax relations
93-hr-17677,Real property A bill to amend the Land and Water Conservation Fund Act of 1965 to require payments by States to local jurisdictions in lieu of taxes, to increase the authorization of appropriation for the Land and Water Conservation Fund. 93-hr-17677 Real property
93-hr-17677,States A bill to amend the Land and Water Conservation Fund Act of 1965 to require payments by States to local jurisdictions in lieu of taxes, to increase the authorization of appropriation for the Land and Water Conservation Fund. 93-hr-17677 States
93-hr-17677,Water Resources Development A bill to amend the Land and Water Conservation Fund Act of 1965 to require payments by States to local jurisdictions in lieu of taxes, to increase the authorization of appropriation for the Land and Water Conservation Fund. 93-hr-17677 Water Resources Development

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