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 = "107-s-1587"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-s-1587,Administrative procedure Port Threat and Security Act 107-s-1587 Administrative procedure
107-s-1587,Appropriations Port Threat and Security Act 107-s-1587 Appropriations
107-s-1587,Congress Port Threat and Security Act 107-s-1587 Congress
107-s-1587,Congressional reporting requirements Port Threat and Security Act 107-s-1587 Congressional reporting requirements
107-s-1587,Crime and Law Enforcement Port Threat and Security Act 107-s-1587 Crime and Law Enforcement
107-s-1587,Department of Transportation Port Threat and Security Act 107-s-1587 Department of Transportation
107-s-1587,EBB Terrorism Port Threat and Security Act 107-s-1587 EBB Terrorism
107-s-1587,Economics and Public Finance Port Threat and Security Act 107-s-1587 Economics and Public Finance
107-s-1587,Emergency communication systems Port Threat and Security Act 107-s-1587 Emergency communication systems
107-s-1587,Environmental Protection Port Threat and Security Act 107-s-1587 Environmental Protection
107-s-1587,Federal law enforcement officers Port Threat and Security Act 107-s-1587 Federal law enforcement officers
107-s-1587,Flammable materials Port Threat and Security Act 107-s-1587 Flammable materials
107-s-1587,Foreign Trade and International Finance Port Threat and Security Act 107-s-1587 Foreign Trade and International Finance
107-s-1587,Fraud Port Threat and Security Act 107-s-1587 Fraud
107-s-1587,Freight Port Threat and Security Act 107-s-1587 Freight
107-s-1587,Government Operations and Politics Port Threat and Security Act 107-s-1587 Government Operations and Politics
107-s-1587,Government publicity Port Threat and Security Act 107-s-1587 Government publicity
107-s-1587,Harbors Port Threat and Security Act 107-s-1587 Harbors
107-s-1587,Identification devices Port Threat and Security Act 107-s-1587 Identification devices

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