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 = "hres", congress = 97 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

  • 97 · 2 ✖

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
97-hres-531 97 hres 531 A resolution expressing the sense of the House with respect to the continuation of the Environmental Protection Agency's requirements concerning the maximum allowable lead content of leaded grades of gasoline. Environmental Protection 1982-07-21 1982-07-27 Referred to Subcommittee on Health and the Environment. House Rep. Bedell, Berkley W. [D-IA-6] IA D B000298 20 Expresses the sense of the House of Representatives that the Environmental Protection Agency's current requirements respecting the average lead content of gasoline manufactured by refiners (including small refiners) should be retained in their present form and should not be made less stringent. 2024-02-05T14:30:09Z  
97-hres-252 97 hres 252 Commitment to the Clean Air Act Resolution of the Ninety-Seventh Congress Environmental Protection 1981-10-21 1981-11-20 Referred to Subcommittee on Health and the Environment. House Rep. Vento, Bruce F. [D-MN-4] MN D V000087 120 Commitment to the Clean Air Act resolution of the Ninety-seventh Congress - Expresses the sense of the House of Representatives that: (1) clean air is fundamentally important for the health and well-being of the citizens, economy, and environment of the United States; and (2) the existing Clean Air Act should be maintained and strengthened subject only to changes that will improve its administration and effectiveness. 2025-08-29T19:47:26Z  

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 1027.027ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API