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

3 rows where bill_id = "115-hres-1145"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
115-hres-1145,Air quality Expressing the need for bold climate action in response to the release of the United Nations report titled "Global Warming of 1.5 degrees Celsius, an IPCC special report on the impacts of global warming of 1.5 degrees Celsius above pre-industrial levels and related global greenhouse gas emission pathways in the context of strengthening the global response to the threat of climate change, sustainable development, and efforts to eradicate poverty". 115-hres-1145 Air quality
115-hres-1145,Climate change and greenhouse gases Expressing the need for bold climate action in response to the release of the United Nations report titled "Global Warming of 1.5 degrees Celsius, an IPCC special report on the impacts of global warming of 1.5 degrees Celsius above pre-industrial levels and related global greenhouse gas emission pathways in the context of strengthening the global response to the threat of climate change, sustainable development, and efforts to eradicate poverty". 115-hres-1145 Climate change and greenhouse gases
115-hres-1145,International organizations and cooperation Expressing the need for bold climate action in response to the release of the United Nations report titled "Global Warming of 1.5 degrees Celsius, an IPCC special report on the impacts of global warming of 1.5 degrees Celsius above pre-industrial levels and related global greenhouse gas emission pathways in the context of strengthening the global response to the threat of climate change, sustainable development, and efforts to eradicate poverty". 115-hres-1145 International organizations and cooperation

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