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

13 rows where bill_type = "hjres", congress = 102 and policy_area = "Environmental Protection" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, latest_action_text, sponsor_name, sponsor_state, sponsor_party, sponsor_bioguide_id, cosponsor_count, summary_text, update_date, introduced_date (date), latest_action_date (date), update_date (date)

policy_area 1

  • Environmental Protection · 13 ✖

congress 1

  • 102 · 13 ✖

bill_type 1

  • hjres · 13 ✖
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
102-hjres-550 102 hjres 550 Designating the week beginning October 18, 1992, as "National Radon Action Week". Environmental Protection 1992-09-15 1992-09-18 Referred to the Subcommittee on Census and Population. House Rep. Towns, Edolphus [D-NY-11] NY D T000326 223 Designates the week beginning October 18, 1992, as National Radon Action Week. 2024-02-06T20:04:02Z  
102-hjres-519 102 hjres 519 Proposing a constitutional amendment to protect natural resources and the environment. Environmental Protection 1992-06-29 1992-07-27 Referred to the Subcommittee on Civil and Constitutional Rights. House Rep. Pallone, Frank, Jr. [D-NJ-3] NJ D P000034 0 Constitutional Amendment - Prohibits the Congress and the States from making or enforcing any law that would cause or contribute to the reckless pollution or degradation of the environment. 2021-06-02T14:03:54Z  
102-hjres-428 102 hjres 428 To authorize the President to proclaim the last Friday of April 1992 as "National Arbor Day". Environmental Protection 1992-02-27 1992-03-03 Referred to the Subcommittee on Census and Population. House Rep. Dingell, John D. [D-MI-16] MI D D000355 0 Authorizes and requests the President to designate the last Friday of April 1992 as National Arbor Day. 2024-02-06T20:04:02Z  
102-hjres-421 102 hjres 421 Designating April 22, 1992, as "Earth Day". Environmental Protection 1992-02-25 1992-04-23 Referred to the Subcommittee on Census and Population. House Rep. Roybal, Edward R. [D-CA-25] CA D R000485 153 Designates April 22, 1992, as Earth Day. 2024-02-06T20:04:02Z  
102-hjres-403 102 hjres 403 To authorize the President to proclaim the last Friday of April 1992 as "National Arbor Day". Environmental Protection 1992-02-04 1992-02-05 Referred to the Subcommittee on Census and Population. House Rep. Roe, Robert A. [D-NJ-8] NJ D R000383 81 Authorizes and requests the President to designate the last Friday of April 1992 as National Arbor Day. 2024-02-06T20:04:02Z  
102-hjres-396 102 hjres 396 Designating April 15, 1992 as "National Recycling Day". Environmental Protection 1992-01-30 1992-04-15 For Further Action See S.J.Res.246. House Rep. Waxman, Henry A. [D-CA-24] CA D W000215 221 Designates April 15, 1992, as National Recycling Day. 2024-02-06T20:04:02Z  
102-hjres-352 102 hjres 352 To designate 1992 as the "Year of the Wetlands". Environmental Protection 1991-10-16 1991-10-21 Referred to the Subcommittee on Census and Population. House Rep. Jefferson, William J. [D-LA-2] LA D J000070 28 Designates 1992 as Year of the Wetlands. 2024-02-06T20:04:02Z  
102-hjres-338 102 hjres 338 To designate 1991 as the "Year of the Bay". Environmental Protection 1991-10-01 1991-10-04 Referred to the Subcommittee on Census and Population. House Rep. Panetta, Leon [D-CA-16] CA D P000047 0 Designates 1991 as the Year of the Bay. 2024-02-06T20:04:02Z  
102-hjres-327 102 hjres 327 Designating 1992 as the "Year of the Gulf of Mexico". Environmental Protection 1991-09-17 1991-12-02 Became Public Law No: 102-178. House Rep. Laughlin, Greg [D-TX-14] TX D L000119 221 Designates 1992 as the Year of the Gulf of Mexico. Directs all Federal and State agencies which have responsibility for matters affecting the Gulf to work to increase public awareness regarding the immeasurable value of this resource and current conditions which threaten its aesthetic and economic value. 2025-07-21T19:32:26Z  
102-hjres-188 102 hjres 188 Designating the month of June 1991 as "Augustus F. Hawkins National Recycling Month". Environmental Protection 1991-03-13 1991-03-20 Referred to the Subcommittee on Census and Population. House Rep. Dreier, David [R-CA-33] CA R D000492 161 Designates June 1991 as Augustus F. Hawkins National Recycling Month. 2024-02-06T20:04:02Z  
102-hjres-169 102 hjres 169 To designate April 15, 1991, as "National Recycling Day". Environmental Protection 1991-03-04 1991-03-06 Referred to the Subcommittee on Census and Population. House Rep. Torricelli, Robert G. [D-NJ-9] NJ D T000317 125 Designates April 15, 1991, as National Recycling Day. 2024-02-06T20:04:02Z  
102-hjres-144 102 hjres 144 To designate April 22, 1991, as "Earth Day". Environmental Protection 1991-02-21 1991-02-27 Referred to the Subcommittee on Census and Population. House Rep. Obey, David R. [D-WI-7] WI D O000007 226 Designates April 22, 1991, as Earth Day. 2024-02-06T20:04:02Z  
102-hjres-67 102 hjres 67 To designate the week of October 13, 1991, through October 19, 1991, as "National Radon Action Week". Environmental Protection 1991-01-10 1991-10-10 For Further Action See S.J.Res.132. House Rep. Roe, Robert A. [D-NJ-8] NJ D R000383 219 Designates the week of October 13 through 19, 1991, as National Radon Action Week. 2024-02-06T20:04:02Z  

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