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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: introduced_date (date), latest_action_date (date), update_date (date)

policy_area 1

  • Environmental Protection · 2 ✖

congress 1

bill_type 1

  • hres · 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
100-hres-254 100 hres 254 A resolution expressing the sense of the House regarding the critical need to include the use of oxygenated fuels such as ethanol, produced from our abundant stocks of surplus grain, and methanol, which can be produced from our vast coal reserves, in air pollution control strategies required by the Federal Environmental Protection Agency for carbon monoxide and ozone nonattainment. Environmental Protection 1987-08-07 1987-10-06 Referred to Subcommittee on Health and the Environment. House Rep. Dorgan, Byron L. [D-ND-At Large] ND D D000432 6 Expresses the sense of the House of Representatives that the Environmental Protection Agency strongly encourage nonattainment cities to include in their State Implementation Plans, as a cost effective and preferred pollution control strategy in meeting Clean Air Act standards, the required use of ethanol blended fuels and other oxygenated/gasoline blends in carbon monoxide nonattainment areas, and neat alcohol fuels in commercial transportation fleets in ozone nonattainment areas. 2024-02-05T14:30:09Z  
100-hres-193 100 hres 193 A resolution expressing the sense of the House with respect to the use of ethanol, methanol, and other oxygenated fuels as an accepted air pollution control strategy in non-attainment areas designated by the Environmental Protection Agency. Environmental Protection 1987-06-11 1987-07-20 Referred to Subcommittee on Health and the Environment. House Rep. Daub, Hal [R-NE-2] NE R D000065 5 States that the Environmental Protection Agency should encourage States to mandate the use of fuel alcohol and other oxygenate/gasoline blends in CO nonattainment areas, and neat alcohols or other clean burning alternative transportation fuels in commercial fleets in ozone nonattainment areas as optional pollution control strategies in their State Implementation Plans under the Clean Air Act. 2024-02-05T14:30:09Z  

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