home / openregs

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 = "97-s-1663"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-1663,Administrative procedure Immigration and Nationality Act Amendments of 1981 97-s-1663 Administrative procedure
97-s-1663,Adoption Immigration and Nationality Act Amendments of 1981 97-s-1663 Adoption
97-s-1663,Aircraft Immigration and Nationality Act Amendments of 1981 97-s-1663 Aircraft
97-s-1663,Airlines Immigration and Nationality Act Amendments of 1981 97-s-1663 Airlines
97-s-1663,Aliens Immigration and Nationality Act Amendments of 1981 97-s-1663 Aliens
97-s-1663,Aviation Immigration and Nationality Act Amendments of 1981 97-s-1663 Aviation
97-s-1663,Children and youth Immigration and Nationality Act Amendments of 1981 97-s-1663 Children and youth
97-s-1663,Citizenship Immigration and Nationality Act Amendments of 1981 97-s-1663 Citizenship
97-s-1663,Civil procedure Immigration and Nationality Act Amendments of 1981 97-s-1663 Civil procedure
97-s-1663,Courts and Civil Procedure Immigration and Nationality Act Amendments of 1981 97-s-1663 Courts and Civil Procedure
97-s-1663,Crime and Law Enforcement Immigration and Nationality Act Amendments of 1981 97-s-1663 Crime and Law Enforcement
97-s-1663,Crime prevention Immigration and Nationality Act Amendments of 1981 97-s-1663 Crime prevention
97-s-1663,Criminal procedure and sentencing Immigration and Nationality Act Amendments of 1981 97-s-1663 Criminal procedure and sentencing
97-s-1663,Deportation Immigration and Nationality Act Amendments of 1981 97-s-1663 Deportation
97-s-1663,Drugs and narcotics Immigration and Nationality Act Amendments of 1981 97-s-1663 Drugs and narcotics
97-s-1663,Education Immigration and Nationality Act Amendments of 1981 97-s-1663 Education
97-s-1663,Employment and training programs Immigration and Nationality Act Amendments of 1981 97-s-1663 Employment and training programs
97-s-1663,Fees Immigration and Nationality Act Amendments of 1981 97-s-1663 Fees
97-s-1663,Foreign students Immigration and Nationality Act Amendments of 1981 97-s-1663 Foreign students

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);
Powered by Datasette · Queries took 464.662ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API