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 = "hconres", congress = 110 and policy_area = "Environmental Protection" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Environmental Protection · 2 ✖

congress 1

bill_type 1

  • hconres · 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
110-hconres-252 110 hconres 252 Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. Environmental Protection 2007-11-09 2007-11-13 Referred to the Subcommittee on Economic Development, Public Buildings and Emergency Management. House Rep. Burgess, Michael C. [R-TX-26] TX R B001248 0 Expresses the sense of Congress that no federal or state requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize lighting that contains mercury. 2023-01-11T20:19:00Z https://www.congress.gov/bill/110th-congress/house-concurrent-resolution/252
110-hconres-96 110 hconres 96 Expressing the sense of the Congress that there should be enacted a mandatory national program to slow, stop and reverse emissions of greenhouse gases. Environmental Protection 2007-03-21 2007-03-22 Referred to the Subcommittee on Energy and Air Quality. House Rep. Dicks, Norman D. [D-WA-6] WA D D000327 25 Expresses the sense of Congress that there should be enacted a national program of mandatory, market-based limits and incentives on emissions of greenhouse gases that slow, stop, and reverse the growth of such emissions at a rate and in a manner that will: (1) not significantly harm the U.S. economy; and (2) encourage comparable action by other nations that are major trading partners and key contributors to global emissions. 2023-01-11T19:56:54Z https://www.congress.gov/bill/110th-congress/house-concurrent-resolution/96

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