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

6 rows where bill_id = "118-sjres-107"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
118-sjres-107,Homeland security A joint resolution to authorize the use of military force against the Islamic Republic of Iran if the President determines that the Islamic Republic of Iran is planning or conducts an attack against any former, current, or incoming United States Government official or senior military personnel. 118-sjres-107 Homeland security
118-sjres-107,Iran A joint resolution to authorize the use of military force against the Islamic Republic of Iran if the President determines that the Islamic Republic of Iran is planning or conducts an attack against any former, current, or incoming United States Government official or senior military personnel. 118-sjres-107 Iran
118-sjres-107,Middle East A joint resolution to authorize the use of military force against the Islamic Republic of Iran if the President determines that the Islamic Republic of Iran is planning or conducts an attack against any former, current, or incoming United States Government official or senior military personnel. 118-sjres-107 Middle East
118-sjres-107,Nuclear weapons A joint resolution to authorize the use of military force against the Islamic Republic of Iran if the President determines that the Islamic Republic of Iran is planning or conducts an attack against any former, current, or incoming United States Government official or senior military personnel. 118-sjres-107 Nuclear weapons
118-sjres-107,Presidents and presidential powers, Vice Presidents A joint resolution to authorize the use of military force against the Islamic Republic of Iran if the President determines that the Islamic Republic of Iran is planning or conducts an attack against any former, current, or incoming United States Government official or senior military personnel. 118-sjres-107 Presidents and presidential powers, Vice Presidents
118-sjres-107,War and emergency powers A joint resolution to authorize the use of military force against the Islamic Republic of Iran if the President determines that the Islamic Republic of Iran is planning or conducts an attack against any former, current, or incoming United States Government official or senior military personnel. 118-sjres-107 War and emergency powers

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