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-s-2001"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-2001,Courts and Civil Procedure Voluntary School Prayer Act 100-s-2001 Courts and Civil Procedure
100-s-2001,District courts Voluntary School Prayer Act 100-s-2001 District courts
100-s-2001,Education Voluntary School Prayer Act 100-s-2001 Education
100-s-2001,Jurisdiction Voluntary School Prayer Act 100-s-2001 Jurisdiction
100-s-2001,Prayer in the public schools Voluntary School Prayer Act 100-s-2001 Prayer in the public schools
100-s-2001,Religion Voluntary School Prayer Act 100-s-2001 Religion
100-s-2001,Religion and Clergy Voluntary School Prayer Act 100-s-2001 Religion and Clergy
100-s-2001,Religion in the public schools Voluntary School Prayer Act 100-s-2001 Religion in the public schools
100-s-2001,Supreme Court Voluntary School Prayer Act 100-s-2001 Supreme Court
100-s-2001,Supreme Court jurisdiction Voluntary School Prayer Act 100-s-2001 Supreme Court jurisdiction

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