legislation
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where bill_type = "sres", congress = 117 and policy_area = "Environmental Protection" sorted by introduced_date descending
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 | url |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117-sres-807 | 117 | sres | 807 | A resolution designating November 5, 2022, as "National Bison Day". | Environmental Protection | 2022-09-28 | 2022-09-28 | Submitted in the Senate, considered, and agreed to without amendment and with a preamble by Unanimous Consent. (consideration: CR S5164-5165; text: CR S5231) | Senate | Sen. Hoeven, John [R-ND] | ND | R | H001061 | 14 | This resolution designates November 5, 2022, as National Bison Day. | 2022-11-01T04:18:35Z | https://www.congress.gov/bill/117th-congress/senate-resolution/807 |
| 117-sres-779 | 117 | sres | 779 | A resolution designating the week of September 17 through September 24, 2022, as "National Estuaries Week". | Environmental Protection | 2022-09-20 | 2022-09-20 | Submitted in the Senate, considered, and agreed to without amendment and with a preamble by Unanimous Consent. (consideration: CR S4878; text: CR S4860) | Senate | Sen. Whitehouse, Sheldon [D-RI] | RI | D | W000802 | 22 | This resolution designates the week of September 17-September 24, 2022, as National Estuaries Week. | 2022-11-01T04:18:04Z | https://www.congress.gov/bill/117th-congress/senate-resolution/779 |
| 117-sres-697 | 117 | sres | 697 | A resolution designating July 2022 as "Plastic Pollution Action Month". | Environmental Protection | 2022-06-23 | 2022-06-23 | Referred to the Committee on the Judiciary. (text: CR S3167) | Senate | Sen. Merkley, Jeff [D-OR] | OR | D | M001176 | 1 | This resolution designates July 2022 as Plastic Pollution Action Month. | 2022-12-29T17:48:32Z | https://www.congress.gov/bill/117th-congress/senate-resolution/697 |
| 117-sres-374 | 117 | sres | 374 | A resolution designating the week of September 19 through September 25, 2021, as "National Estuaries Week". | Environmental Protection | 2021-09-21 | 2021-09-21 | Referred to the Committee on the Judiciary. (text: CR S6590-6591) | Senate | Sen. Whitehouse, Sheldon [D-RI] | RI | D | W000802 | 18 | This resolution designates the week of September 19-September 25, 2021, as National Estuaries Week. | 2023-09-25T16:00:32Z | https://www.congress.gov/bill/117th-congress/senate-resolution/374 |
| 117-sres-304 | 117 | sres | 304 | A resolution designating July 2021 as "Plastic Pollution Action Month". | Environmental Protection | 2021-07-15 | 2021-07-15 | Referred to the Committee on the Judiciary. (text: CR S4930-4931) | Senate | Sen. Merkley, Jeff [D-OR] | OR | D | M001176 | 1 | This resolution designates July 2021 as Plastic Pollution Action Month. | 2023-01-01T23:42:07Z | https://www.congress.gov/bill/117th-congress/senate-resolution/304 |
| 117-sres-166 | 117 | sres | 166 | A resolution recognizing the duty of the Federal Government to create a Green New Deal. | Environmental Protection | 2021-04-20 | 2021-04-20 | Referred to the Committee on Environment and Public Works. (text: CR S2086-2087) | Senate | Sen. Markey, Edward J. [D-MA] | MA | D | M000133 | 12 | This resolution calls for the creation of a Green New Deal with the goals of achieving greenhouse gas and toxic emissions reductions needed to stay under 1.5 degrees Celsius of warming; establishing millions of high-wage union jobs and ensuring economic security for all; investing in infrastructure and industry; securing clean air and water, climate and community resiliency, healthy food, access to nature, and a sustainable environment for all; and promoting justice and equality. The resolution calls for accomplishment of these goals through a 10-year national mobilization effort. The resolution also enumerates the goals and projects of the mobilization effort, including building smart power grids (i.e., power grids that enable customers to reduce their power use during peak demand periods); upgrading all existing buildings and constructing new buildings to achieve maximum energy and water efficiency; removing pollution and greenhouse gas emissions from the transportation and agricultural sectors; cleaning up existing hazardous waste and abandoned sites; ensuring businesspersons are free from unfair competition; and providing higher education, high-quality health care, and affordable, safe, and adequate housing to all. | 2023-01-11T13:49:02Z | https://www.congress.gov/bill/117th-congress/senate-resolution/166 |
| 117-sres-17 | 117 | sres | 17 | A resolution expressing the sense of the Senate that clean water is a national priority and that the April 21, 2020, Navigable Waters Protection Rule should not be withdrawn or vacated. | Environmental Protection | 2021-01-27 | 2021-01-27 | Referred to the Committee on Environment and Public Works. (text: CR S178) | Senate | Sen. Ernst, Joni [R-IA] | IA | R | E000295 | 27 | This resolution expresses the sense of the Senate that (1) clean water is a national priority, and (2) the 2020 final rule titled The Navigable Waters Protection Rule: Definition of "Waters of the United States" should not be withdrawn or vacated. | 2023-01-11T13:47:27Z | https://www.congress.gov/bill/117th-congress/senate-resolution/17 |
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);