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 = "103-hr-4557"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
103-hr-4557,Alien labor Social Security Account Number Anti-Fraud Act 103-hr-4557 Alien labor
103-hr-4557,California Social Security Account Number Anti-Fraud Act 103-hr-4557 California
103-hr-4557,Congress Social Security Account Number Anti-Fraud Act 103-hr-4557 Congress
103-hr-4557,Congressional reporting requirements Social Security Account Number Anti-Fraud Act 103-hr-4557 Congressional reporting requirements
103-hr-4557,Crime and Law Enforcement Social Security Account Number Anti-Fraud Act 103-hr-4557 Crime and Law Enforcement
103-hr-4557,Crime prevention Social Security Account Number Anti-Fraud Act 103-hr-4557 Crime prevention
103-hr-4557,Electronic data processing Social Security Account Number Anti-Fraud Act 103-hr-4557 Electronic data processing
103-hr-4557,Fines (Penalties) Social Security Account Number Anti-Fraud Act 103-hr-4557 Fines (Penalties)
103-hr-4557,Florida Social Security Account Number Anti-Fraud Act 103-hr-4557 Florida
103-hr-4557,Fraud Social Security Account Number Anti-Fraud Act 103-hr-4557 Fraud
103-hr-4557,Government Operations and Politics Social Security Account Number Anti-Fraud Act 103-hr-4557 Government Operations and Politics
103-hr-4557,Government paperwork Social Security Account Number Anti-Fraud Act 103-hr-4557 Government paperwork
103-hr-4557,Identification devices Social Security Account Number Anti-Fraud Act 103-hr-4557 Identification devices
103-hr-4557,Illegal aliens Social Security Account Number Anti-Fraud Act 103-hr-4557 Illegal aliens
103-hr-4557,Illinois Social Security Account Number Anti-Fraud Act 103-hr-4557 Illinois
103-hr-4557,Immigration Social Security Account Number Anti-Fraud Act 103-hr-4557 Immigration
103-hr-4557,Information services Social Security Account Number Anti-Fraud Act 103-hr-4557 Information services
103-hr-4557,Labor and Employment Social Security Account Number Anti-Fraud Act 103-hr-4557 Labor and Employment
103-hr-4557,Michigan Social Security Account Number Anti-Fraud Act 103-hr-4557 Michigan

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 1.273ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy