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

27 rows where bill_id = "110-s-3554"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-s-3554,Access to health care Affordable Coverage for Small Employers Act of 2008 110-s-3554 Access to health care
110-s-3554,Advice and consent of the Senate Affordable Coverage for Small Employers Act of 2008 110-s-3554 Advice and consent of the Senate
110-s-3554,Commerce Affordable Coverage for Small Employers Act of 2008 110-s-3554 Commerce
110-s-3554,Comprehensive health care Affordable Coverage for Small Employers Act of 2008 110-s-3554 Comprehensive health care
110-s-3554,Congress Affordable Coverage for Small Employers Act of 2008 110-s-3554 Congress
110-s-3554,Congressional investigations Affordable Coverage for Small Employers Act of 2008 110-s-3554 Congressional investigations
110-s-3554,Congressional reporting requirements Affordable Coverage for Small Employers Act of 2008 110-s-3554 Congressional reporting requirements
110-s-3554,Consumer education Affordable Coverage for Small Employers Act of 2008 110-s-3554 Consumer education
110-s-3554,Employee health benefits Affordable Coverage for Small Employers Act of 2008 110-s-3554 Employee health benefits
110-s-3554,Executive reorganization Affordable Coverage for Small Employers Act of 2008 110-s-3554 Executive reorganization
110-s-3554,Finance and Financial Sector Affordable Coverage for Small Employers Act of 2008 110-s-3554 Finance and Financial Sector
110-s-3554,Government Operations and Politics Affordable Coverage for Small Employers Act of 2008 110-s-3554 Government Operations and Politics
110-s-3554,Government paperwork Affordable Coverage for Small Employers Act of 2008 110-s-3554 Government paperwork
110-s-3554,Health insurance Affordable Coverage for Small Employers Act of 2008 110-s-3554 Health insurance
110-s-3554,Income tax Affordable Coverage for Small Employers Act of 2008 110-s-3554 Income tax
110-s-3554,Insurance premiums Affordable Coverage for Small Employers Act of 2008 110-s-3554 Insurance premiums
110-s-3554,Labor and Employment Affordable Coverage for Small Employers Act of 2008 110-s-3554 Labor and Employment
110-s-3554,Presidential appointments Affordable Coverage for Small Employers Act of 2008 110-s-3554 Presidential appointments
110-s-3554,Preventive medicine Affordable Coverage for Small Employers Act of 2008 110-s-3554 Preventive medicine
110-s-3554,Quality of care Affordable Coverage for Small Employers Act of 2008 110-s-3554 Quality of care
110-s-3554,Regionalism Affordable Coverage for Small Employers Act of 2008 110-s-3554 Regionalism
110-s-3554,Small business Affordable Coverage for Small Employers Act of 2008 110-s-3554 Small business
110-s-3554,Standards Affordable Coverage for Small Employers Act of 2008 110-s-3554 Standards
110-s-3554,State laws Affordable Coverage for Small Employers Act of 2008 110-s-3554 State laws
110-s-3554,Tax credits Affordable Coverage for Small Employers Act of 2008 110-s-3554 Tax credits
110-s-3554,Tax returns Affordable Coverage for Small Employers Act of 2008 110-s-3554 Tax returns
110-s-3554,Taxation Affordable Coverage for Small Employers Act of 2008 110-s-3554 Taxation

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