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

20 rows where bill_id = "111-hr-6224"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
111-hr-6224,Advanced technology and technological innovations 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Advanced technology and technological innovations
111-hr-6224,Cancer 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Cancer
111-hr-6224,Child health 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Child health
111-hr-6224,Drug safety, medical device, and laboratory regulation 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Drug safety, medical device, and laboratory regulation
111-hr-6224,Drug therapy 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Drug therapy
111-hr-6224,Drug, alcohol, tobacco use 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Drug, alcohol, tobacco use
111-hr-6224,Health care coverage and access 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Health care coverage and access
111-hr-6224,Health information and medical records 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Health information and medical records
111-hr-6224,Health programs administration and funding 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Health programs administration and funding
111-hr-6224,Health promotion and preventive care 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Health promotion and preventive care
111-hr-6224,Long-term, rehabilitative, and terminal care 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Long-term, rehabilitative, and terminal care
111-hr-6224,Medicaid 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Medicaid
111-hr-6224,Medical education 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Medical education
111-hr-6224,Medical research 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Medical research
111-hr-6224,Medical tests and diagnostic methods 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Medical tests and diagnostic methods
111-hr-6224,Medicare 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Medicare
111-hr-6224,Minority health 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Minority health
111-hr-6224,Research administration and funding 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Research administration and funding
111-hr-6224,Research and development 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Research and development
111-hr-6224,Right of privacy 21st Century Cancer ALERT (Access to Life-Saving Early detection, Research and Treatment) Act 111-hr-6224 Right of privacy

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