openregs: legislation: 1 row where bill_type = "sconres", congress = 108 and policy_area = "Housing and Community Development" sorted by introduced

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 = "sconres", congress = 108 and policy_area = "Housing and Community Development" sorted by introduced_date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
108-sconres-43	108	sconres	43	A concurrent resolution expressing the sense of Congress that Congress should participate in and support activities to provide decent homes for the people of the United States.	Housing and Community Development	2003-05-06	2003-06-17	Motion to reconsider laid on the table Agreed to without objection.	Senate	Sen. Brownback, Sam [R-KS]	KS	R	B000953	13	(This measure has not been amended since it was introduced in the Senate on May 6, 2003. The expanded summary of the Senate passed version is repeated here.)Expresses the sense of Congress that: (1) everyone in the United States should have a decent home; (2) Members of the Senate and the House of Representatives should demonstrate the importance of volunteerism; (3) during the 108th and 109th sessions of Congress, Members, Habitat for Humanity, and contributing organizations, should sponsor and construct two homes in the Washington, D.C., metro area each as part of the "Congress Building America" program; (4) each "Congress Building America" house should be constructed primarily by Members, their families and staffs, and the staffs of sponsoring organizations working with local volunteers involving and symbolizing the partnership of the public, private, and nonprofit sectors of society; (5) each "Congress Building America" house should be constructed with the family that will own the home; (6) in the future, Members, their families, and their staff should participate in similar house building activities in their own States as part of National Homeownership Month; and (7) these occasions should be used to emphasize the importance of providing decent homes for all of the people in the United States.	2023-01-15T16:03:45Z	https://www.congress.gov/bill/108th-congress/senate-concurrent-resolution/43

Advanced export

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

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