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

1 row where bill_type = "hres", congress = 105 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 · 1 ✖

congress 1

bill_type 1

  • hres · 1 ✖
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
105-hres-147 105 hres 147 Expressing the sense of the House of Representatives that the House of Representatives should participate in and support activities to provide decent homes for the people of the United States, and for other purposes. Housing and Community Development 1997-05-13 1997-05-30 Referred to the Subcommittee on Housing and Community Opportunity. House Rep. Lewis, Jerry [R-CA-40] CA R L000274 6 Expresses the sense of the House of Representatives that: (1) the Members of the House of Representatives and Habitat for Humanity, with support from the National Partners in Homeownership, should sponsor and construct, commencing on June 5, 1997, two homes in the Anacostia neighborhood of the District of Columbia, each to be known as a "House That Congress Built"; (2) each house should be constructed primarily by Members and their families and staffs with the participation of the family that will own the home, involving and symbolizing the partnership of the public, private, and nonprofit sectors of society; (3) upon completion and initial occupancy of the homes in the fall of 1997, the Members, their families and staffs, each family that will own each house, and local and national leaders from the public and private nonprofit sectors of society should participate in an event to celebrate the occasion; (4) the Members and their families and staff should participate in similar house building activities of Habitat for Humanity in their own districts as part of National Homeownership Week; and (5) these occasions should be used to emphasize the importance of providing safe, clean, and healthy homes for all of the people in the United States. 2025-04-07T15:23:38Z https://www.congress.gov/bill/105th-congress/house-resolution/147

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