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

4 rows where bill_id = "113-hjres-27"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
113-hjres-27,Constitution and constitutional amendments Proposing an amendment to the Constitution of the United States prohibiting the Federal Government from using the power of taxation to compel someone to engage in commercial activity. 113-hjres-27 Constitution and constitutional amendments
113-hjres-27,Health care costs and insurance Proposing an amendment to the Constitution of the United States prohibiting the Federal Government from using the power of taxation to compel someone to engage in commercial activity. 113-hjres-27 Health care costs and insurance
113-hjres-27,Health care coverage and access Proposing an amendment to the Constitution of the United States prohibiting the Federal Government from using the power of taxation to compel someone to engage in commercial activity. 113-hjres-27 Health care coverage and access
113-hjres-27,Tax administration and collection, taxpayers Proposing an amendment to the Constitution of the United States prohibiting the Federal Government from using the power of taxation to compel someone to engage in commercial activity. 113-hjres-27 Tax administration and collection, taxpayers

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