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

7 rows where bill_id = "105-sres-231"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-sres-231,Computers and government A resolution to make a technical amendment to Senate Resolution 208. 105-sres-231 Computers and government
105-sres-231,Congressional committees (Senate) A resolution to make a technical amendment to Senate Resolution 208. 105-sres-231 Congressional committees (Senate)
105-sres-231,Congressional investigations A resolution to make a technical amendment to Senate Resolution 208. 105-sres-231 Congressional investigations
105-sres-231,Congressional reorganization A resolution to make a technical amendment to Senate Resolution 208. 105-sres-231 Congressional reorganization
105-sres-231,Government Operations and Politics A resolution to make a technical amendment to Senate Resolution 208. 105-sres-231 Government Operations and Politics
105-sres-231,Science, Technology, Communications A resolution to make a technical amendment to Senate Resolution 208. 105-sres-231 Science, Technology, Communications
105-sres-231,Year 2000 computer problem A resolution to make a technical amendment to Senate Resolution 208. 105-sres-231 Year 2000 computer problem

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