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

17 rows where bill_id = "100-s-2124"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-s-2124,Business and social problems Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Business and social problems
100-s-2124,Child health Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Child health
100-s-2124,Child nutrition Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Child nutrition
100-s-2124,Children and youth Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Children and youth
100-s-2124,Day care Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Day care
100-s-2124,Education Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Education
100-s-2124,Employer incentives Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Employer incentives
100-s-2124,Federal aid to day care centers Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Federal aid to day care centers
100-s-2124,Food and Food Industry Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Food and Food Industry
100-s-2124,Food relief Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Food relief
100-s-2124,Income tax Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Income tax
100-s-2124,Labor and Employment Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Labor and Employment
100-s-2124,Research Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Research
100-s-2124,School lunch program Child Care and Nutrition Enhancement Act of 1988 100-s-2124 School lunch program
100-s-2124,State finance Child Care and Nutrition Enhancement Act of 1988 100-s-2124 State finance
100-s-2124,States Child Care and Nutrition Enhancement Act of 1988 100-s-2124 States
100-s-2124,Tax credits Child Care and Nutrition Enhancement Act of 1988 100-s-2124 Tax credits

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 48.38ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API