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 = "96-s-3192"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
96-s-3192,Congress Carl Albert Congressional Research and Studies Center Endowment Act 96-s-3192 Congress
96-s-3192,Congress and Congressmen Carl Albert Congressional Research and Studies Center Endowment Act 96-s-3192 Congress and Congressmen
96-s-3192,Educational facilities Carl Albert Congressional Research and Studies Center Endowment Act 96-s-3192 Educational facilities
96-s-3192,Higher education Carl Albert Congressional Research and Studies Center Endowment Act 96-s-3192 Higher education
96-s-3192,Oklahoma Carl Albert Congressional Research and Studies Center Endowment Act 96-s-3192 Oklahoma
96-s-3192,Political science research Carl Albert Congressional Research and Studies Center Endowment Act 96-s-3192 Political science research
96-s-3192,Research Carl Albert Congressional Research and Studies Center Endowment Act 96-s-3192 Research
96-s-3192,Research and development Carl Albert Congressional Research and Studies Center Endowment Act 96-s-3192 Research and development
96-s-3192,Research centers Carl Albert Congressional Research and Studies Center Endowment Act 96-s-3192 Research centers

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