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 = "94-sjres-122"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
94-sjres-122,Government Operations and Politics A joint resolution proposing an amendment to the Constitution of the United States with respect on the length of the term of office of the President and Vice President and the number of terms a President may serve. 94-sjres-122 Government Operations and Politics
94-sjres-122,Law A joint resolution proposing an amendment to the Constitution of the United States with respect on the length of the term of office of the President and Vice President and the number of terms a President may serve. 94-sjres-122 Law
94-sjres-122,Term limits A joint resolution proposing an amendment to the Constitution of the United States with respect on the length of the term of office of the President and Vice President and the number of terms a President may serve. 94-sjres-122 Term limits
94-sjres-122,Vice Presidents A joint resolution proposing an amendment to the Constitution of the United States with respect on the length of the term of office of the President and Vice President and the number of terms a President may serve. 94-sjres-122 Vice Presidents

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