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 = "94-hr-8716"

descending

Link	bill_id	subject
94-hr-8716,Agriculture and Food	A bill to amend the Food Stamp Act of 1964 for the purpose of prohibiting any alien who has not been lawfully admitted into the United States for permanent residence from participating in the food stamp program. 94-hr-8716	Agriculture and Food
94-hr-8716,Aliens	A bill to amend the Food Stamp Act of 1964 for the purpose of prohibiting any alien who has not been lawfully admitted into the United States for permanent residence from participating in the food stamp program. 94-hr-8716	Aliens
94-hr-8716,Food stamps	A bill to amend the Food Stamp Act of 1964 for the purpose of prohibiting any alien who has not been lawfully admitted into the United States for permanent residence from participating in the food stamp program. 94-hr-8716	Food stamps
94-hr-8716,Illegal aliens	A bill to amend the Food Stamp Act of 1964 for the purpose of prohibiting any alien who has not been lawfully admitted into the United States for permanent residence from participating in the food stamp program. 94-hr-8716	Illegal aliens
94-hr-8716,Poverty	A bill to amend the Food Stamp Act of 1964 for the purpose of prohibiting any alien who has not been lawfully admitted into the United States for permanent residence from participating in the food stamp program. 94-hr-8716	Poverty
94-hr-8716,Social Welfare	A bill to amend the Food Stamp Act of 1964 for the purpose of prohibiting any alien who has not been lawfully admitted into the United States for permanent residence from participating in the food stamp program. 94-hr-8716	Social Welfare

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