legislation_subjects

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

19 rows where bill_id = "95-hr-9268"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
95-hr-9268,Administrative procedure Illegal Alien Control Act 95-hr-9268 Administrative procedure
95-hr-9268,Aid to dependent children Illegal Alien Control Act 95-hr-9268 Aid to dependent children
95-hr-9268,Aircraft Illegal Alien Control Act 95-hr-9268 Aircraft
95-hr-9268,Alien labor Illegal Alien Control Act 95-hr-9268 Alien labor
95-hr-9268,Aliens Illegal Alien Control Act 95-hr-9268 Aliens
95-hr-9268,Aviation Illegal Alien Control Act 95-hr-9268 Aviation
95-hr-9268,Business and commerce Illegal Alien Control Act 95-hr-9268 Business and commerce
95-hr-9268,Crime and Law Enforcement Illegal Alien Control Act 95-hr-9268 Crime and Law Enforcement
95-hr-9268,Department of Justice Illegal Alien Control Act 95-hr-9268 Department of Justice
95-hr-9268,Department of Labor Illegal Alien Control Act 95-hr-9268 Department of Labor
95-hr-9268,Forfeiture Illegal Alien Control Act 95-hr-9268 Forfeiture
95-hr-9268,Forgery Illegal Alien Control Act 95-hr-9268 Forgery
95-hr-9268,Identification devices Illegal Alien Control Act 95-hr-9268 Identification devices
95-hr-9268,Illegal aliens Illegal Alien Control Act 95-hr-9268 Illegal aliens
95-hr-9268,Income tax Illegal Alien Control Act 95-hr-9268 Income tax
95-hr-9268,Labor and Employment Illegal Alien Control Act 95-hr-9268 Labor and Employment
95-hr-9268,Medicaid Illegal Alien Control Act 95-hr-9268 Medicaid
95-hr-9268,Motor vehicles Illegal Alien Control Act 95-hr-9268 Motor vehicles
95-hr-9268,Passenger ships Illegal Alien Control Act 95-hr-9268 Passenger ships

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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