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

19 rows where bill_id = "100-s-1968"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-1968,Advisory bodies Public Health Service Amendments Act of 1988 100-s-1968 Advisory bodies
100-s-1968,Child health Public Health Service Amendments Act of 1988 100-s-1968 Child health
100-s-1968,Child safety Public Health Service Amendments Act of 1988 100-s-1968 Child safety
100-s-1968,Children and youth Public Health Service Amendments Act of 1988 100-s-1968 Children and youth
100-s-1968,Civil Rights and Liberties Public Health Service Amendments Act of 1988 100-s-1968 Civil Rights and Liberties
100-s-1968,Emergency medical personnel Public Health Service Amendments Act of 1988 100-s-1968 Emergency medical personnel
100-s-1968,Emergency medical services Public Health Service Amendments Act of 1988 100-s-1968 Emergency medical services
100-s-1968,Emergency medicine Public Health Service Amendments Act of 1988 100-s-1968 Emergency medicine
100-s-1968,Federal advisory bodies Public Health Service Amendments Act of 1988 100-s-1968 Federal advisory bodies
100-s-1968,Federal aid to health facilities Public Health Service Amendments Act of 1988 100-s-1968 Federal aid to health facilities
100-s-1968,Federal aid to medical education Public Health Service Amendments Act of 1988 100-s-1968 Federal aid to medical education
100-s-1968,Federal aid to medical research Public Health Service Amendments Act of 1988 100-s-1968 Federal aid to medical research
100-s-1968,Geriatrics Public Health Service Amendments Act of 1988 100-s-1968 Geriatrics
100-s-1968,Health education Public Health Service Amendments Act of 1988 100-s-1968 Health education
100-s-1968,Health facilities Public Health Service Amendments Act of 1988 100-s-1968 Health facilities
100-s-1968,Medical centers Public Health Service Amendments Act of 1988 100-s-1968 Medical centers
100-s-1968,Medical education Public Health Service Amendments Act of 1988 100-s-1968 Medical education
100-s-1968,Medical personnel Public Health Service Amendments Act of 1988 100-s-1968 Medical personnel
100-s-1968,Physicians Public Health Service Amendments Act of 1988 100-s-1968 Physicians

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