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 = "105-s-1332"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-1332,Administrative remedies State Environmental Audit Protection Act 105-s-1332 Administrative remedies
105-s-1332,Commerce State Environmental Audit Protection Act 105-s-1332 Commerce
105-s-1332,Confidential communications State Environmental Audit Protection Act 105-s-1332 Confidential communications
105-s-1332,Consent decrees State Environmental Audit Protection Act 105-s-1332 Consent decrees
105-s-1332,Crime and Law Enforcement State Environmental Audit Protection Act 105-s-1332 Crime and Law Enforcement
105-s-1332,Delegation of powers State Environmental Audit Protection Act 105-s-1332 Delegation of powers
105-s-1332,Discovery (Law) State Environmental Audit Protection Act 105-s-1332 Discovery (Law)
105-s-1332,Environmental assessment State Environmental Audit Protection Act 105-s-1332 Environmental assessment
105-s-1332,Environmental law enforcement State Environmental Audit Protection Act 105-s-1332 Environmental law enforcement
105-s-1332,Evidence (Law) State Environmental Audit Protection Act 105-s-1332 Evidence (Law)
105-s-1332,Federal-local relations State Environmental Audit Protection Act 105-s-1332 Federal-local relations
105-s-1332,Federal-state relations State Environmental Audit Protection Act 105-s-1332 Federal-state relations
105-s-1332,Fines (Penalties) State Environmental Audit Protection Act 105-s-1332 Fines (Penalties)
105-s-1332,Government Operations and Politics State Environmental Audit Protection Act 105-s-1332 Government Operations and Politics
105-s-1332,Government paperwork State Environmental Audit Protection Act 105-s-1332 Government paperwork
105-s-1332,Law State Environmental Audit Protection Act 105-s-1332 Law
105-s-1332,Licenses State Environmental Audit Protection Act 105-s-1332 Licenses
105-s-1332,Management audit State Environmental Audit Protection Act 105-s-1332 Management audit
105-s-1332,Performance measurement State Environmental Audit Protection Act 105-s-1332 Performance measurement

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