openregs: legislation_subjects: 7 rows where bill

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 = "102-s-2003"

descending

Link	bill_id	subject
102-s-2003,Local officials and employees	A bill to provide an exception to the coverage of State and local employees under Social Security. 102-s-2003	Local officials and employees
102-s-2003,Old age, survivors and disability insurance	A bill to provide an exception to the coverage of State and local employees under Social Security. 102-s-2003	Old age, survivors and disability insurance
102-s-2003,Part-time employment	A bill to provide an exception to the coverage of State and local employees under Social Security. 102-s-2003	Part-time employment
102-s-2003,Seasonal labor	A bill to provide an exception to the coverage of State and local employees under Social Security. 102-s-2003	Seasonal labor
102-s-2003,Social security eligibility	A bill to provide an exception to the coverage of State and local employees under Social Security. 102-s-2003	Social security eligibility
102-s-2003,State officials and employees	A bill to provide an exception to the coverage of State and local employees under Social Security. 102-s-2003	State officials and employees
102-s-2003,Temporary employment	A bill to provide an exception to the coverage of State and local employees under Social Security. 102-s-2003	Temporary employment

Advanced export

JSON shape: default, array, newline-delimited, object

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