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

14 rows where bill_id = "100-hr-4927"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-hr-4927,Cytology Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Cytology
100-hr-4927,Freedom of information Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Freedom of information
100-hr-4927,Government records, documents, and information Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Government records, documents, and information
100-hr-4927,Health facilities Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Health facilities
100-hr-4927,Licenses Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Licenses
100-hr-4927,Medical fees Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Medical fees
100-hr-4927,Medical laboratories Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Medical laboratories
100-hr-4927,Medical research Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Medical research
100-hr-4927,Medical tests Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Medical tests
100-hr-4927,Physicians Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Physicians
100-hr-4927,Quality control Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Quality control
100-hr-4927,Standards Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 Standards
100-hr-4927,State laws Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 State laws
100-hr-4927,States Clinical Laboratory Improvement Amendments of 1988 100-hr-4927 States

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