openregs: legislation: 18 rows where bill_type = "sjres", congress = 101 and policy_area = "Environmental Protection" 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

18 rows where bill_type = "sjres", congress = 101 and policy_area = "Environmental Protection" 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
101-sjres-338	101	sjres	338	A joint resolution to designate July 1, 1990 as "National Ducks and Wetlands Day".	Environmental Protection	1990-06-21	1990-07-10	Held at the desk.	Senate	Sen. Boschwitz, Rudy [R-MN]	MN	R	B000647	52	Designates July 1, 1990, as National Ducks and Wetlands Day.	2025-07-21T19:32:26Z
101-sjres-317	101	sjres	317	A joint resolution to designate the week of October 14, 1990, through October 20, 1990, as "National Radon Action Week".	Environmental Protection	1990-05-16	1990-10-22	Became Public Law No: 101-451.	Senate	Sen. Lautenberg, Frank R. [D-NJ]	NJ	D	L000123	56	Designates the week of October 14 through October 20, 1990, as National Radon Action Week.	2025-07-21T19:32:26Z
101-sjres-299	101	sjres	299	A joint resolution to designate the period October 1, 1990, through October 1, 1991, as the "Year of the Wetlands".	Environmental Protection	1990-04-24	1990-06-20	Referred to the House Committee on Post Office and Civil Service.	Senate	Sen. Johnston, J. Bennett [D-LA]	LA	D	J000189	52	Designates October 1, 1990, to October 1, 1991, as Year of the Wetlands.	2025-07-21T19:32:26Z
101-sjres-258	101	sjres	258	A joint resolution to authorize the President to proclaim the last Friday of April 1990 as "National Arbor Day".	Environmental Protection	1990-02-20	1990-05-01	Became Public Law No: 101-279.	Senate	Sen. Bradley, Bill [D-NJ]	NJ	D	B001225	53	Authorizes and requests the President to designate the last Friday of April 1990 as National Arbor Day.	2025-07-21T19:32:26Z
101-sjres-250	101	sjres	250	A joint resolution designating April 1990 as "National Recycling Month".	Environmental Protection	1990-02-05	1990-04-04	Became Public Law No: 101-264.	Senate	Sen. Chafee, John H. [R-RI]	RI	R	C000269	58	Designates April 1990 as National Recycling Month.	2025-07-21T19:32:26Z
101-sjres-230	101	sjres	230	A joint resolution to designate the period commencing on May 6, 1990 and ending on May 12, 1990 as "National Drinking Water Week".	Environmental Protection	1989-11-20	1990-05-09	Became Public Law No: 101-285.	Senate	Sen. DeConcini, Dennis [D-AZ]	AZ	D	D000185	54	Designates the week of May 6 through May 12, 1990, as National Drinking Water Week.	2025-07-21T19:32:26Z
101-sjres-206	101	sjres	206	A joint resolution calling for the United States to encourage immediate negotiations toward a new agreement among Antarctic Treaty Consultative parties, for the full protection of Antarctica as a global ecological commons.	Environmental Protection	1989-09-26	1990-11-16	Became Public Law No: 101-620.	Senate	Sen. Gore, Albert, Jr. [D-TN]	TN	D	G000321	24	Declares that: (1) Antarctica is a global ecological commons and should be subject to new agreements or protocols which supplement the Antarctic Treaty of 1959 providing for comprehensive environmental protection of Antarctica and which should, for an indefinite period, establish Antarctica as a region closed to commercial minerals development and related activities; (2) under such new agreements, information about minerals or other resources in Antarctica should be obtained under strictly controlled arrangements and should be openly shared in the international scientific community; (3) the Convention on the Regulation of Antarctic Mineral Resource Activities does not guarantee protection of the environment of Antarctica and could stimulate commercial exploitation; (4) pending the negotiations and entry into force of new agreements or protocols ensuring the full protection of Antarctica as a global ecological commons, the Convention should not be presented to the the Senate for advice and consent to ratification; (5) until such new agreements enter into force, the United States should support the interim restraint measures presently in force among the Consultative Parties to the Treaty; and (6) the negotiation of such new agreements or protocols should be supported by the United States at the November 1990 meeting of the Antarctic Treaty Consultative Parties in Santiago, Chile.	2025-01-14T19:00:46Z
101-sjres-181	101	sjres	181	A joint resolution to establish calendar year 1992 as the "Year of Clean Water".	Environmental Protection	1989-07-19	1990-10-12	Became Public Law No: 101-424.	Senate	Sen. Mitchell, George J. [D-ME]	ME	D	M000811	52	Designates 1992 as the Year of Clean Water and October 1992 as Clean Water Month.	2025-07-21T19:32:26Z
101-sjres-162	101	sjres	162	A joint resolution to urge the Nobel Commission to consider awarding Nobel Prize recognition for achievements in preservation of the world environment.	Environmental Protection	1989-06-22	1989-10-03	Indefinitely postponed by Senate by Unanimous Consent.	Senate	Sen. Gore, Albert, Jr. [D-TN]	TN	D	G000321	10	Urges the Nobel Commission to consider awarding Nobel Prize recognition for achievements in the preservation of the world environment.	2025-01-14T19:00:46Z
101-sjres-166	101	sjres	166	A joint resolution to designate the period of September 16 through October 9, 1989, as "Coastweeks '89".	Environmental Protection	1989-06-22	1989-09-13	Referred to the Subcommittee on Census and Population.	Senate	Sen. Kerry, John F. [D-MA]	MA	D	K000148	54	Designates the period of September 16 through October 9, 1989, as Coastweeks '89, recognizing the importance of coastal zones. Designates September 16, 1989, as National Estuaries Day and September 23, 1989, as National Beach Cleanup Day.	2025-07-21T19:32:26Z
101-sjres-159	101	sjres	159	A joint resolution to designate April 22, 1990 as Earth Day, and to set aside the day for public activities promoting preservation of the global environment.	Environmental Protection	1989-06-20	1989-11-28	Became Public Law No: 101-186.	Senate	Sen. Gore, Albert, Jr. [D-TN]	TN	D	G000321	58	Designates April 22, 1990, as Earth Day for public activities that promote global environmental preservation.	2025-07-21T19:32:26Z
101-sjres-139	101	sjres	139	A joint resolution to approve the designation of the Cordell Bank National Marine Sanctuary, to disapprove a term of that designation, and to direct the Secretary of Commerce to revise regulations implementing that designation to prohibit certain activities in the Sanctuary.	Environmental Protection	1989-05-18	1989-05-18	Read twice and referred to the Committee on Commerce.	Senate	Sen. Cranston, Alan [D-CA]	CA	D	C000877	1	Declares that the Congress approves, with certain exceptions, the designation of the Cordell Bank National Marine Sanctuary, California. Disapproves the designation of hydrocarbon (oil and gas) activities as activities which may be regulated within the Sanctuary. Directs the Secretary of Commerce to: (1) within 120 days revise regulations to prohibit hydrocarbon activities in the Sanctuary; and (2) pending implementation of such revised regulations, prohibit such hydrocarbon activities.	2025-01-14T18:51:33Z
101-sjres-141	101	sjres	141	A joint resolution approving the national marine sanctuary designation entitled "Cordell Bank National Marine Sanctuary".	Environmental Protection	1989-05-18	1989-05-18	Read twice and referred to the Committee on Commerce.	Senate	Sen. Wilson, Pete [R-CA]	CA	R	W000607	1	Declares that the Congress approves, with certain exceptions, the designation of the Cordell Bank National Marine Sanctuary, California. Disapproves the designation of hydrocarbon (oil and gas) activities as activities which may be regulated within the Sanctuary. Directs the Secretary of Commerce to: (1) within 120 days revise regulations to prohibit hydrocarbon activities in the Sanctuary; and (2) pending implementation of such revised regulations, prohibit such hydrocarbon activities.	2025-01-14T18:51:33Z
101-sjres-90	101	sjres	90	A joint resolution to require the President to submit proposals to prevent, and disperse oil spills on the seas, coasts, and waterways of the United States.	Environmental Protection	1989-04-04	1989-04-04	Read twice and referred to the Committee on Environment and Public Works.	Senate	Sen. Heinz, John [R-PA]	PA	R	H000456	0	Requires the President to submit to the Congress proposals to prevent, contain, and disperse oil spills on U.S. seas, coasts, and inland waterways.	2025-01-14T17:12:38Z
101-sjres-88	101	sjres	88	National Global Warming Policy Act	Environmental Protection	1989-03-16	1990-09-13	Indefinitely postponed by Senate by Unanimous Consent.	Senate	Sen. Wirth, Timothy [D-CO]	CO	D	W000647	16	National Global Warming Policy Act - Declares that it is U.S. policy to: (1) reduce the generation of greenhouse gases in the United States, with an initial goal of reducing carbon dioxide emissions from 1988 levels by 20 percent by the end of the year 2000; (2) host, in 1989, an international summit meeting on global warming and environmental concerns; (3) encourage, and develop multilateral agreements with, other nations to reduce the generation of such gases; (4) assist in the worldwide protection of tropical rainforests; (5) require Federal agencies to determine the impacts of global warming on their activities and propose greenhouse gas reduction policies; and (6) develop technologies that will provide reliable energy and services while reducing the generation of such gases.	2025-08-26T17:24:50Z
101-sjres-60	101	sjres	60	A joint resolution to designate the period commencing on May 1, 1989, and ending on May 7, 1989, as "National Drinking Water Week".	Environmental Protection	1989-02-09	1989-05-02	Became Public Law No: 101-21.	Senate	Sen. DeConcini, Dennis [D-AZ]	AZ	D	D000185	53	Designates the period commencing on May 1, 1989, as National Drinking Water Week.	2025-07-21T19:32:26Z
101-sjres-61	101	sjres	61	A joint resolution to designate April 1989 as "National Recycling Month".	Environmental Protection	1989-02-09	1989-04-24	Referred to the Subcommittee on Census and Population.	Senate	Sen. Chafee, John H. [R-RI]	RI	R	C000269	38	Designates the month of April 1989 as National Recycling Month.	2025-07-21T19:32:26Z
101-sjres-40	101	sjres	40	A joint resolution to authorize the President to proclaim the last Friday of April 1989 as "National Arbor Day".	Environmental Protection	1989-01-31	1989-03-09	Referred to the Subcommittee on Census and Population.	Senate	Sen. Bradley, Bill [D-NJ]	NJ	D	B001225	57	Authorizes and requests the President to designate the last Friday of April 1989 as National Arbor Day.	2025-07-21T19:32:26Z

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