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 = "96-hr-7635"

descending

Link	bill_id	subject
96-hr-7635,Agriculture and Rural Affairs	A bill terminating the restrictions imposed by the President on exports of agricultural commodities to the Soviet Union. 96-hr-7635	Agriculture and Rural Affairs
96-hr-7635,Agriculture in foreign trade	A bill terminating the restrictions imposed by the President on exports of agricultural commodities to the Soviet Union. 96-hr-7635	Agriculture in foreign trade
96-hr-7635,Export controls	A bill terminating the restrictions imposed by the President on exports of agricultural commodities to the Soviet Union. 96-hr-7635	Export controls
96-hr-7635,Foreign Trade and Investments	A bill terminating the restrictions imposed by the President on exports of agricultural commodities to the Soviet Union. 96-hr-7635	Foreign Trade and Investments
96-hr-7635,U.S.S.R.	A bill terminating the restrictions imposed by the President on exports of agricultural commodities to the Soviet Union. 96-hr-7635	U.S.S.R.

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