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

10 rows where bill_id = "112-s-2147"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
112-s-2147,Alaska Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 Alaska
112-s-2147,Arctic Ocean Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 Arctic Ocean
112-s-2147,Climate change and greenhouse gases Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 Climate change and greenhouse gases
112-s-2147,Ecology Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 Ecology
112-s-2147,Environmental assessment, monitoring, research Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 Environmental assessment, monitoring, research
112-s-2147,Fishes Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 Fishes
112-s-2147,Mammals Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 Mammals
112-s-2147,Marine and coastal resources, fisheries Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 Marine and coastal resources, fisheries
112-s-2147,Research administration and funding Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 Research administration and funding
112-s-2147,Wildlife conservation and habitat protection Arctic Ocean Research, Monitoring, and Observing Act of 2012 112-s-2147 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);