openregs: legislation_subjects: 6 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

6 rows where bill_id = "112-sres-331"

descending

Link	bill_id	subject
112-sres-331,Budget deficits and national debt	A resolution expressing the sense of the Senate that Congress should "Go Big" in its attempts toward deficit reduction. 112-sres-331	Budget deficits and national debt
112-sres-331,Competitiveness, trade promotion, trade deficits	A resolution expressing the sense of the Senate that Congress should "Go Big" in its attempts toward deficit reduction. 112-sres-331	Competitiveness, trade promotion, trade deficits
112-sres-331,Economic performance and conditions	A resolution expressing the sense of the Senate that Congress should "Go Big" in its attempts toward deficit reduction. 112-sres-331	Economic performance and conditions
112-sres-331,Financial services and investments	A resolution expressing the sense of the Senate that Congress should "Go Big" in its attempts toward deficit reduction. 112-sres-331	Financial services and investments
112-sres-331,Tax reform and tax simplification	A resolution expressing the sense of the Senate that Congress should "Go Big" in its attempts toward deficit reduction. 112-sres-331	Tax reform and tax simplification
112-sres-331,Unemployment	A resolution expressing the sense of the Senate that Congress should "Go Big" in its attempts toward deficit reduction. 112-sres-331	Unemployment

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