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

11 rows where bill_id = "98-s-458"

descending

Link	bill_id	subject
98-s-458,Agricultural labor	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Agricultural labor
98-s-458,Agriculture and Rural Affairs	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Agriculture and Rural Affairs
98-s-458,Alien labor	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Alien labor
98-s-458,Crime and Law Enforcement	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Crime and Law Enforcement
98-s-458,Criminal investigation	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Criminal investigation
98-s-458,Criminal procedure and sentencing	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Criminal procedure and sentencing
98-s-458,Department of Justice	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Department of Justice
98-s-458,Farms	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Farms
98-s-458,Illegal aliens	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Illegal aliens
98-s-458,Labor and Employment	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Labor and Employment
98-s-458,Searches and seizures	A bill to require a properly executed warrant before an officer or employee of the Immigration and Naturalization Service may enter a farm or other agricultural operation. 98-s-458	Searches and seizures

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