home / openregs

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

23 rows where bill_id = "110-s-2802"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-s-2802,Anniversaries Civil War Sesquicentennial Commission Act 110-s-2802 Anniversaries
110-s-2802,Armed Forces and National Security Civil War Sesquicentennial Commission Act 110-s-2802 Armed Forces and National Security
110-s-2802,Arts, Culture, Religion Civil War Sesquicentennial Commission Act 110-s-2802 Arts, Culture, Religion
110-s-2802,Auditing Civil War Sesquicentennial Commission Act 110-s-2802 Auditing
110-s-2802,Black history Civil War Sesquicentennial Commission Act 110-s-2802 Black history
110-s-2802,Blacks Civil War Sesquicentennial Commission Act 110-s-2802 Blacks
110-s-2802,Civil War Civil War Sesquicentennial Commission Act 110-s-2802 Civil War
110-s-2802,Colleges Civil War Sesquicentennial Commission Act 110-s-2802 Colleges
110-s-2802,Congress Civil War Sesquicentennial Commission Act 110-s-2802 Congress
110-s-2802,Congressional reporting requirements Civil War Sesquicentennial Commission Act 110-s-2802 Congressional reporting requirements
110-s-2802,Economics and Public Finance Civil War Sesquicentennial Commission Act 110-s-2802 Economics and Public Finance
110-s-2802,Education Civil War Sesquicentennial Commission Act 110-s-2802 Education
110-s-2802,Federal advisory bodies Civil War Sesquicentennial Commission Act 110-s-2802 Federal advisory bodies
110-s-2802,Federal aid to education Civil War Sesquicentennial Commission Act 110-s-2802 Federal aid to education
110-s-2802,Gifts Civil War Sesquicentennial Commission Act 110-s-2802 Gifts
110-s-2802,Government Operations and Politics Civil War Sesquicentennial Commission Act 110-s-2802 Government Operations and Politics
110-s-2802,Higher education Civil War Sesquicentennial Commission Act 110-s-2802 Higher education
110-s-2802,History Civil War Sesquicentennial Commission Act 110-s-2802 History
110-s-2802,Military history Civil War Sesquicentennial Commission Act 110-s-2802 Military history
110-s-2802,Minorities Civil War Sesquicentennial Commission Act 110-s-2802 Minorities
110-s-2802,Museums Civil War Sesquicentennial Commission Act 110-s-2802 Museums
110-s-2802,Social Welfare Civil War Sesquicentennial Commission Act 110-s-2802 Social Welfare
110-s-2802,Volunteer workers Civil War Sesquicentennial Commission Act 110-s-2802 Volunteer workers

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);
Powered by Datasette · Queries took 405.746ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API