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

6 rows where bill_id = "118-hconres-68"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
118-hconres-68,Domestic violence and child abuse Expressing support for the recognition of September 26, 2023, as "World Contraception Day" and expressing the sense of the House of Representatives regarding global and domestic access to contraception. 118-hconres-68 Domestic violence and child abuse
118-hconres-68,Family planning and birth control Expressing support for the recognition of September 26, 2023, as "World Contraception Day" and expressing the sense of the House of Representatives regarding global and domestic access to contraception. 118-hconres-68 Family planning and birth control
118-hconres-68,Foreign aid and international relief Expressing support for the recognition of September 26, 2023, as "World Contraception Day" and expressing the sense of the House of Representatives regarding global and domestic access to contraception. 118-hconres-68 Foreign aid and international relief
118-hconres-68,Health care coverage and access Expressing support for the recognition of September 26, 2023, as "World Contraception Day" and expressing the sense of the House of Representatives regarding global and domestic access to contraception. 118-hconres-68 Health care coverage and access
118-hconres-68,Sex and reproductive health Expressing support for the recognition of September 26, 2023, as "World Contraception Day" and expressing the sense of the House of Representatives regarding global and domestic access to contraception. 118-hconres-68 Sex and reproductive health
118-hconres-68,Sex, gender, sexual orientation discrimination Expressing support for the recognition of September 26, 2023, as "World Contraception Day" and expressing the sense of the House of Representatives regarding global and domestic access to contraception. 118-hconres-68 Sex, gender, sexual orientation discrimination

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