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 = "97-s-2808"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2808,Advisory bodies A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Advisory bodies
97-s-2808,Animals and Animal Protection A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Animals and Animal Protection
97-s-2808,California A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 California
97-s-2808,Federal advisory bodies A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Federal advisory bodies
97-s-2808,Fishing A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Fishing
97-s-2808,Rivers A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Rivers
97-s-2808,Sports and Athletics A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Sports and Athletics
97-s-2808,Water and Water Resources Development A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Water and Water Resources Development
97-s-2808,Watershed management A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Watershed management
97-s-2808,Watersheds A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Watersheds
97-s-2808,Wildlife conservation A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Wildlife conservation
97-s-2808,Wildlife management A bill to provide for the restoration of the fish and wildlife in the Trinity River Basin, California, and for other purposes. 97-s-2808 Wildlife management

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