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

31 rows where bill_id = "112-s-3473"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
112-s-3473,Advisory bodies Sequestration Prevention Act of 2012 112-s-3473 Advisory bodies
112-s-3473,Alternative dispute resolution, mediation, arbitration Sequestration Prevention Act of 2012 112-s-3473 Alternative dispute resolution, mediation, arbitration
112-s-3473,Budget process Sequestration Prevention Act of 2012 112-s-3473 Budget process
112-s-3473,Civil actions and liability Sequestration Prevention Act of 2012 112-s-3473 Civil actions and liability
112-s-3473,Climate change and greenhouse gases Sequestration Prevention Act of 2012 112-s-3473 Climate change and greenhouse gases
112-s-3473,Competition and antitrust Sequestration Prevention Act of 2012 112-s-3473 Competition and antitrust
112-s-3473,Disaster relief and insurance Sequestration Prevention Act of 2012 112-s-3473 Disaster relief and insurance
112-s-3473,Drug safety, medical device, and laboratory regulation Sequestration Prevention Act of 2012 112-s-3473 Drug safety, medical device, and laboratory regulation
112-s-3473,Emergency medical services and trauma care Sequestration Prevention Act of 2012 112-s-3473 Emergency medical services and trauma care
112-s-3473,Environmental regulatory procedures Sequestration Prevention Act of 2012 112-s-3473 Environmental regulatory procedures
112-s-3473,Evidence and witnesses Sequestration Prevention Act of 2012 112-s-3473 Evidence and witnesses
112-s-3473,Federal preemption Sequestration Prevention Act of 2012 112-s-3473 Federal preemption
112-s-3473,Food assistance and relief Sequestration Prevention Act of 2012 112-s-3473 Food assistance and relief
112-s-3473,Government employee pay, benefits, personnel management Sequestration Prevention Act of 2012 112-s-3473 Government employee pay, benefits, personnel management
112-s-3473,Health care costs and insurance Sequestration Prevention Act of 2012 112-s-3473 Health care costs and insurance
112-s-3473,Health care coverage and access Sequestration Prevention Act of 2012 112-s-3473 Health care coverage and access
112-s-3473,Health care quality Sequestration Prevention Act of 2012 112-s-3473 Health care quality
112-s-3473,Health facilities and institutions Sequestration Prevention Act of 2012 112-s-3473 Health facilities and institutions
112-s-3473,Health personnel Sequestration Prevention Act of 2012 112-s-3473 Health personnel
112-s-3473,Health promotion and preventive care Sequestration Prevention Act of 2012 112-s-3473 Health promotion and preventive care
112-s-3473,Health technology, devices, supplies Sequestration Prevention Act of 2012 112-s-3473 Health technology, devices, supplies
112-s-3473,Insurance industry and regulation Sequestration Prevention Act of 2012 112-s-3473 Insurance industry and regulation
112-s-3473,Intergovernmental relations Sequestration Prevention Act of 2012 112-s-3473 Intergovernmental relations
112-s-3473,Judicial procedure and administration Sequestration Prevention Act of 2012 112-s-3473 Judicial procedure and administration
112-s-3473,Lawyers and legal services Sequestration Prevention Act of 2012 112-s-3473 Lawyers and legal services
112-s-3473,Medicaid Sequestration Prevention Act of 2012 112-s-3473 Medicaid
112-s-3473,Medicare Sequestration Prevention Act of 2012 112-s-3473 Medicare
112-s-3473,Prescription drugs Sequestration Prevention Act of 2012 112-s-3473 Prescription drugs
112-s-3473,Product safety and quality Sequestration Prevention Act of 2012 112-s-3473 Product safety and quality
112-s-3473,Social work, volunteer service, charitable organizations Sequestration Prevention Act of 2012 112-s-3473 Social work, volunteer service, charitable organizations
112-s-3473,State and local finance Sequestration Prevention Act of 2012 112-s-3473 State and local finance

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