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

12 rows where bill_id = "116-s-4841"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
116-s-4841,Business records AIM Act of 2020 116-s-4841 Business records
116-s-4841,Crimes against property AIM Act of 2020 116-s-4841 Crimes against property
116-s-4841,Criminal justice information and records AIM Act of 2020 116-s-4841 Criminal justice information and records
116-s-4841,Department of Justice AIM Act of 2020 116-s-4841 Department of Justice
116-s-4841,Evidence and witnesses AIM Act of 2020 116-s-4841 Evidence and witnesses
116-s-4841,Executive agency funding and structure AIM Act of 2020 116-s-4841 Executive agency funding and structure
116-s-4841,Firearms and explosives AIM Act of 2020 116-s-4841 Firearms and explosives
116-s-4841,Freedom of information AIM Act of 2020 116-s-4841 Freedom of information
116-s-4841,Historical and cultural resources AIM Act of 2020 116-s-4841 Historical and cultural resources
116-s-4841,Judicial review and appeals AIM Act of 2020 116-s-4841 Judicial review and appeals
116-s-4841,Law enforcement administration and funding AIM Act of 2020 116-s-4841 Law enforcement administration and funding
116-s-4841,Licensing and registrations AIM Act of 2020 116-s-4841 Licensing and registrations

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