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 = "sjres", congress = 112 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

bill_type 1

  • sjres · 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
112-sjres-37 112 sjres 37 A joint resolution to disapprove a rule promulgated by the Administrator of the Environmental Protection Agency relating to emission standards for certain steam generating units. Environmental Protection 2012-02-16 2012-06-20 Motion to proceed to consideration of measure rejected in Senate by Yea-Nay Vote. 46 - 53. Record Vote Number: 139. (consideration: CR S4334) Senate Sen. Inhofe, James M. [R-OK] OK R I000024 1 Disapproves and nullifies the rule submitted by the Administrator of the Environmental Protection Agency (EPA) relating to national emission standards for hazardous air pollutants from coal- and oil-fired electric utility steam generating units and standards of performance for fossil-fuel-fired electric utility, industrial-commercial-institutional, and small industrial-commercial-institutional steam generating units. 2022-02-03T05:54:26Z  
112-sjres-27 112 sjres 27 A joint resolution disapproving a rule submitted by the Environmental Protection Agency relating to the mitigation by States of cross-border air pollution under the Clean Air Act. Environmental Protection 2011-09-08 2011-11-10 Motion to proceed to consideration of measure rejected in Senate by Yea-Nay Vote. 41 - 56. Record Vote Number: 201. Senate Sen. Paul, Rand [R-KY] KY R P000603 3 Disapproves the rule submitted by the Environmental Protection Agency (EPA) on July 11, 2011, entitled "Federal Implementation Plans: Interstate Transport of Fine Particulate Matter and Ozone and Correction of SIP Approvals," relating to the mitigation by states of cross-border air pollution under the Clean Air Act. 2023-01-11T13:22:14Z  

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