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

17 rows where bill_id = "111-hr-6543"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
111-hr-6543,Administrative law and regulatory procedures Drug Safety Enhancement Act of 2011 111-hr-6543 Administrative law and regulatory procedures
111-hr-6543,Administrative remedies Drug Safety Enhancement Act of 2011 111-hr-6543 Administrative remedies
111-hr-6543,Business records Drug Safety Enhancement Act of 2011 111-hr-6543 Business records
111-hr-6543,Civil actions and liability Drug Safety Enhancement Act of 2011 111-hr-6543 Civil actions and liability
111-hr-6543,Criminal procedure and sentencing Drug Safety Enhancement Act of 2011 111-hr-6543 Criminal procedure and sentencing
111-hr-6543,Department of Health and Human Services Drug Safety Enhancement Act of 2011 111-hr-6543 Department of Health and Human Services
111-hr-6543,Drug safety, medical device, and laboratory regulation Drug Safety Enhancement Act of 2011 111-hr-6543 Drug safety, medical device, and laboratory regulation
111-hr-6543,Employment discrimination and employee rights Drug Safety Enhancement Act of 2011 111-hr-6543 Employment discrimination and employee rights
111-hr-6543,Evidence and witnesses Drug Safety Enhancement Act of 2011 111-hr-6543 Evidence and witnesses
111-hr-6543,Executive agency funding and structure Drug Safety Enhancement Act of 2011 111-hr-6543 Executive agency funding and structure
111-hr-6543,Government information and archives Drug Safety Enhancement Act of 2011 111-hr-6543 Government information and archives
111-hr-6543,Government studies and investigations Drug Safety Enhancement Act of 2011 111-hr-6543 Government studies and investigations
111-hr-6543,Jurisdiction and venue Drug Safety Enhancement Act of 2011 111-hr-6543 Jurisdiction and venue
111-hr-6543,Licensing and registrations Drug Safety Enhancement Act of 2011 111-hr-6543 Licensing and registrations
111-hr-6543,Manufacturing Drug Safety Enhancement Act of 2011 111-hr-6543 Manufacturing
111-hr-6543,Trade restrictions Drug Safety Enhancement Act of 2011 111-hr-6543 Trade restrictions
111-hr-6543,User charges and fees Drug Safety Enhancement Act of 2011 111-hr-6543 User charges and fees

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