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

10 rows where bill_id = "100-hconres-333"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-hconres-333,Administration of criminal justice A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 Administration of criminal justice
100-hconres-333,Conferences A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 Conferences
100-hconres-333,Crime prevention A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 Crime prevention
100-hconres-333,Genocide A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 Genocide
100-hconres-333,Human rights A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 Human rights
100-hconres-333,International agencies A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 International agencies
100-hconres-333,International courts A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 International courts
100-hconres-333,Terrorism A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 Terrorism
100-hconres-333,Torture A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 Torture
100-hconres-333,Treaties A concurrent resolution calling for the creation of an International Criminal Court with jurisdiction over internationally recognized crimes of terrorism, genocide, and torture, as those crimes are defined in various international conventions. 100-hconres-333 Treaties

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