home / openregs

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

10 rows where bill_id = "116-hr-8024"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
116-hr-8024,Blood and blood diseases WIC Waiver Extension Act of 2020 116-hr-8024 Blood and blood diseases
116-hr-8024,Cardiovascular and respiratory health WIC Waiver Extension Act of 2020 116-hr-8024 Cardiovascular and respiratory health
116-hr-8024,Child health WIC Waiver Extension Act of 2020 116-hr-8024 Child health
116-hr-8024,Emergency medical services and trauma care WIC Waiver Extension Act of 2020 116-hr-8024 Emergency medical services and trauma care
116-hr-8024,Food assistance and relief WIC Waiver Extension Act of 2020 116-hr-8024 Food assistance and relief
116-hr-8024,Infectious and parasitic diseases WIC Waiver Extension Act of 2020 116-hr-8024 Infectious and parasitic diseases
116-hr-8024,Medical tests and diagnostic methods WIC Waiver Extension Act of 2020 116-hr-8024 Medical tests and diagnostic methods
116-hr-8024,Nutrition and diet WIC Waiver Extension Act of 2020 116-hr-8024 Nutrition and diet
116-hr-8024,Poverty and welfare assistance WIC Waiver Extension Act of 2020 116-hr-8024 Poverty and welfare assistance
116-hr-8024,Women's health WIC Waiver Extension Act of 2020 116-hr-8024 Women's health

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);
Powered by Datasette · Queries took 105.696ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API