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

9 rows where bill_id = "104-hjres-159"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
104-hjres-159,Congress Proposing an amendment to the Constitution of the United States to require two-thirds majorities for bills increasing taxes. 104-hjres-159 Congress
104-hjres-159,Congressional voting Proposing an amendment to the Constitution of the United States to require two-thirds majorities for bills increasing taxes. 104-hjres-159 Congressional voting
104-hjres-159,Constitutional amendments Proposing an amendment to the Constitution of the United States to require two-thirds majorities for bills increasing taxes. 104-hjres-159 Constitutional amendments
104-hjres-159,Government Operations and Politics Proposing an amendment to the Constitution of the United States to require two-thirds majorities for bills increasing taxes. 104-hjres-159 Government Operations and Politics
104-hjres-159,Income tax Proposing an amendment to the Constitution of the United States to require two-thirds majorities for bills increasing taxes. 104-hjres-159 Income tax
104-hjres-159,Law Proposing an amendment to the Constitution of the United States to require two-thirds majorities for bills increasing taxes. 104-hjres-159 Law
104-hjres-159,Legislation Proposing an amendment to the Constitution of the United States to require two-thirds majorities for bills increasing taxes. 104-hjres-159 Legislation
104-hjres-159,Record votes Proposing an amendment to the Constitution of the United States to require two-thirds majorities for bills increasing taxes. 104-hjres-159 Record votes
104-hjres-159,Tax rates Proposing an amendment to the Constitution of the United States to require two-thirds majorities for bills increasing taxes. 104-hjres-159 Tax rates

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 0.929ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy