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

3 rows where bill_id = "93-s-3824"

descending

Link	bill_id	subject
93-s-3824,Agriculture and Food	A bill to amend section 8e of the Agricultural Adjustment Act of 1953, as reenacted and amended by the Agriculture Marketing Agreement Act of 1937, to subject imported tomatoes to restrictions comparable to those applicable to domestic tomatoes. 93-s-3824	Agriculture and Food
93-s-3824,Imports	A bill to amend section 8e of the Agricultural Adjustment Act of 1953, as reenacted and amended by the Agriculture Marketing Agreement Act of 1937, to subject imported tomatoes to restrictions comparable to those applicable to domestic tomatoes. 93-s-3824	Imports
93-s-3824,Tomatoes	A bill to amend section 8e of the Agricultural Adjustment Act of 1953, as reenacted and amended by the Agriculture Marketing Agreement Act of 1937, to subject imported tomatoes to restrictions comparable to those applicable to domestic tomatoes. 93-s-3824	Tomatoes

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