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

4 rows where bill_type = "sjres", congress = 115 and policy_area = "Environmental Protection" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

policy_area 1

  • Environmental Protection · 4 ✖

congress 1

bill_type 1

  • sjres · 4 ✖
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
115-sjres-38 115 sjres 38 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Environmental Protection Agency relating to "Approval, Disapproval and Promulgation of Air Quality Implementation Plans; Partial Approval and Partial Disapproval of Air Quality Implementation Plans and Federal Implementation Plan; Utah; Revisions to Regional Haze State Implementation Plan; Federal Implementation Plan for Regional Haze". Environmental Protection 2017-03-13 2017-03-13 Read twice and referred to the Committee on Environment and Public Works. (Sponsor introductory remarks on measure: CR S1781) Senate Sen. Lee, Mike [R-UT] UT R L000577 1 This joint resolution nullifies the rule issued by the Environmental Protection Agency on July 5, 2016, relating to a revised state implementation plan for regional haze that was submitted by Utah under the Clean Air Act. 2023-01-11T13:36:09Z  
115-sjres-28 115 sjres 28 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Administrator of the Environmental Protection Agency relating to accidental release prevention requirements of risk management programs under the Clean Air Act. Environmental Protection 2017-03-02 2017-03-02 Read twice and referred to the Committee on Environment and Public Works. Senate Sen. Inhofe, James M. [R-OK] OK R I000024 16 This joint resolution nullifies the Environmental Protection Agency's rule entitled, "Accidental Release Prevention Requirements: Risk Management Programs under the Clean Air Act." The rule addresses safety at facilities that use and distribute hazardous chemicals. It was published on January 13, 2017. 2023-01-11T13:36:09Z  
115-sjres-21 115 sjres 21 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Environmental Protection Agency relating to Cross-State Air Pollution Rule Update for the 2008 Ozone NAAQS. Environmental Protection 2017-02-03 2017-02-03 Read twice and referred to the Committee on Environment and Public Works. Senate Sen. Toomey, Patrick [R-PA] PA R T000461 0 This joint resolution nullifies the Cross-State Air Pollution Rule Update finalized by the Environmental Protection Agency on October 26, 2016. The rule addresses interstate transport of ozone pollution with respect to the 2008 ozone National Ambient Air Quality Standards under the Clean Air Act. 2023-01-11T13:35:50Z  
115-sjres-10 115 sjres 10 A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the final rule submitted by the Secretary of the Interior relating to stream protection. Environmental Protection 2017-01-30 2017-01-30 Read twice and referred to the Committee on Energy and Natural Resources. Senate Sen. McConnell, Mitch [R-KY] KY R M000355 29 This joint resolution nullifies the Stream Protection Rule finalized by the Department of the Interior on December 20, 2016. The rule addresses the impacts of surface coal mining operations on surface water, groundwater, and the productivity of mining operation sites. 2023-01-11T13:35:16Z  

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