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

11 rows where bill_id = "114-hr-6208"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
114-hr-6208,Cemeteries and funerals Combating European Anti-Semitism Act of 2016 114-hr-6208 Cemeteries and funerals
114-hr-6208,Congressional oversight Combating European Anti-Semitism Act of 2016 114-hr-6208 Congressional oversight
114-hr-6208,Diplomacy, foreign officials, Americans abroad Combating European Anti-Semitism Act of 2016 114-hr-6208 Diplomacy, foreign officials, Americans abroad
114-hr-6208,Educational facilities and institutions Combating European Anti-Semitism Act of 2016 114-hr-6208 Educational facilities and institutions
114-hr-6208,Europe Combating European Anti-Semitism Act of 2016 114-hr-6208 Europe
114-hr-6208,Human rights Combating European Anti-Semitism Act of 2016 114-hr-6208 Human rights
114-hr-6208,International organizations and cooperation Combating European Anti-Semitism Act of 2016 114-hr-6208 International organizations and cooperation
114-hr-6208,Law enforcement administration and funding Combating European Anti-Semitism Act of 2016 114-hr-6208 Law enforcement administration and funding
114-hr-6208,Racial and ethnic relations Combating European Anti-Semitism Act of 2016 114-hr-6208 Racial and ethnic relations
114-hr-6208,Religion Combating European Anti-Semitism Act of 2016 114-hr-6208 Religion
114-hr-6208,Teaching, teachers, curricula Combating European Anti-Semitism Act of 2016 114-hr-6208 Teaching, teachers, curricula

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