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

16 rows where bill_id = "116-s-2802"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
116-s-2802,Alaska Marine Mammal Research and Response Act of 2019 116-s-2802 Alaska
116-s-2802,Animal and plant health Marine Mammal Research and Response Act of 2019 116-s-2802 Animal and plant health
116-s-2802,Animal protection and human-animal relationships Marine Mammal Research and Response Act of 2019 116-s-2802 Animal protection and human-animal relationships
116-s-2802,Aquatic ecology Marine Mammal Research and Response Act of 2019 116-s-2802 Aquatic ecology
116-s-2802,Arctic and polar regions Marine Mammal Research and Response Act of 2019 116-s-2802 Arctic and polar regions
116-s-2802,Congressional oversight Marine Mammal Research and Response Act of 2019 116-s-2802 Congressional oversight
116-s-2802,Government information and archives Marine Mammal Research and Response Act of 2019 116-s-2802 Government information and archives
116-s-2802,Government liability Marine Mammal Research and Response Act of 2019 116-s-2802 Government liability
116-s-2802,Government studies and investigations Marine Mammal Research and Response Act of 2019 116-s-2802 Government studies and investigations
116-s-2802,Government trust funds Marine Mammal Research and Response Act of 2019 116-s-2802 Government trust funds
116-s-2802,Health information and medical records Marine Mammal Research and Response Act of 2019 116-s-2802 Health information and medical records
116-s-2802,Mammals Marine Mammal Research and Response Act of 2019 116-s-2802 Mammals
116-s-2802,Marine and coastal resources, fisheries Marine Mammal Research and Response Act of 2019 116-s-2802 Marine and coastal resources, fisheries
116-s-2802,Marine pollution Marine Mammal Research and Response Act of 2019 116-s-2802 Marine pollution
116-s-2802,Veterinary medicine and animal diseases Marine Mammal Research and Response Act of 2019 116-s-2802 Veterinary medicine and animal diseases
116-s-2802,Wildlife conservation and habitat protection Marine Mammal Research and Response Act of 2019 116-s-2802 Wildlife conservation and habitat protection

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