openregs: legislation_subjects: 5 rows where bill

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

5 rows where bill_id = "109-hres-706"

descending

Link	bill_id	subject
109-hres-706,Agricultural subsidies	Expressing the sense of the House of Representatives that Congress should enact legislation to provide direct emergency assistance to American farmers who were adversely affected by natural disasters and unforeseen production costs during the 2005 crop year. 109-hres-706	Agricultural subsidies
109-hres-706,Congress	Expressing the sense of the House of Representatives that Congress should enact legislation to provide direct emergency assistance to American farmers who were adversely affected by natural disasters and unforeseen production costs during the 2005 crop year. 109-hres-706	Congress
109-hres-706,Disaster relief	Expressing the sense of the House of Representatives that Congress should enact legislation to provide direct emergency assistance to American farmers who were adversely affected by natural disasters and unforeseen production costs during the 2005 crop year. 109-hres-706	Disaster relief
109-hres-706,Emergency Management	Expressing the sense of the House of Representatives that Congress should enact legislation to provide direct emergency assistance to American farmers who were adversely affected by natural disasters and unforeseen production costs during the 2005 crop year. 109-hres-706	Emergency Management
109-hres-706,Legislation	Expressing the sense of the House of Representatives that Congress should enact legislation to provide direct emergency assistance to American farmers who were adversely affected by natural disasters and unforeseen production costs during the 2005 crop year. 109-hres-706	Legislation

Advanced export

JSON shape: default, array, newline-delimited, object

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