home / openregs

legislation

Congressional bills and resolutions from Congress.gov, filtered to policy areas relevant to environmental, health, agriculture, and wildlife regulation.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

2 rows where bill_type = "sres", congress = 118 and policy_area = "Housing and Community Development" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Housing and Community Development · 2 ✖

congress 1

  • 118 · 2 ✖

bill_type 1

  • sres · 2 ✖
bill_id congress bill_type bill_number title policy_area introduced_date ▲ latest_action_date latest_action_text origin_chamber sponsor_name sponsor_state sponsor_party sponsor_bioguide_id cosponsor_count summary_text update_date url
118-sres-920 118 sres 920 A resolution designating November 2024 as "National Homeless Children and Youth Awareness Month". Housing and Community Development 2024-12-03 2024-12-03 Submitted in the Senate, considered, and agreed to without amendment and with a preamble by Unanimous Consent. (consideration: CR S6789; text: CR S6782-6783) Senate Sen. Manchin, Joe, III [I-WV] WV I M001183 8   2025-12-05T08:39:22Z https://www.congress.gov/bill/118th-congress/senate-resolution/920
118-sres-479 118 sres 479 A resolution designating November 2023 as "National Homeless Children and Youth Awareness Month". Housing and Community Development 2023-11-29 2023-11-29 Submitted in the Senate, considered, and agreed to without amendment and with a preamble by Unanimous Consent. (consideration: CR S5676; text: CR S5677) Senate Sen. Manchin, Joe, III [D-WV] WV D M001183 12   2024-12-10T17:54:41Z https://www.congress.gov/bill/118th-congress/senate-resolution/479

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE legislation (
    bill_id TEXT PRIMARY KEY,
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    title TEXT,
    policy_area TEXT,
    introduced_date TEXT,
    latest_action_date TEXT,
    latest_action_text TEXT,
    origin_chamber TEXT,
    sponsor_name TEXT,
    sponsor_state TEXT,
    sponsor_party TEXT,
    sponsor_bioguide_id TEXT,
    cosponsor_count INTEGER DEFAULT 0,
    summary_text TEXT,
    update_date TEXT,
    url TEXT
);
CREATE INDEX idx_leg_congress ON legislation(congress);
CREATE INDEX idx_leg_type ON legislation(bill_type);
CREATE INDEX idx_leg_policy ON legislation(policy_area);
CREATE INDEX idx_leg_date ON legislation(introduced_date);
CREATE INDEX idx_leg_sponsor ON legislation(sponsor_name);
CREATE INDEX idx_leg_sponsor_bioguide ON legislation(sponsor_bioguide_id);
Powered by Datasette · Queries took 16.826ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy