openregs: legislation: 2 rows where bill_type = "hres", congress = 112 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

2 rows where bill_type = "hres", congress = 112 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	url
112-hres-835	112	hres	835	Expressing the sense of the House of Representatives that the United States should adopt a target of 350 parts per million of atmospheric carbon dioxide by which to evaluate domestic and international climate change policies, and for other purposes.	Environmental Protection	2012-12-18	2012-12-18	Referred to the Committee on Energy and Commerce, and in addition to the Committee on Foreign Affairs, for a period to be subsequently determined by the Speaker, in each case for consideration of such provisions as fall within the jurisdiction of the committee concerned.	House	Rep. Kucinich, Dennis J. [D-OH-10]	OH	D	K000336	0	Expresses the sense of the House of Representatives that the United States should: (1) adopt a target of 350 parts per million of atmospheric carbon dioxide by which to evaluate domestic and international climate change policies, and (2) develop domestic and international policies that are sufficiently flexible to accommodate advancing science in the event that a change in that target becomes warranted.	2019-11-15T21:15:56Z
112-hres-672	112	hres	672	Expressing the sense of the House of Representatives that the energy, environmental, and foreign policies of the United States should reflect appropriate understanding and sensitivity concerning issues related to climate change, as documented by credible scientific findings and as evidenced by the extreme weather events of recent years.	Environmental Protection	2012-05-31	2012-06-01	Referred to the Subcommittee on Energy and Power.	House	Rep. Moran, James P. [D-VA-8]	VA	D	M000933	10	Acknowledges scientific findings confirming that climate change is happening and that human activities are a primary cause. Recognizes that climate change poses unacceptable risks to the health, safety, and welfare of current and future generations of the United States. Accepts responsibility to safeguard the welfare of the people of the United States and acknowledges that such welfare is best protected by policies that: (1) reduce energy consumption and increase energy efficiency; (2) shift power supply strategy from oil, coal, and natural gas to wind, solar, geothermal, and other renewable energy sources to reduce dependence on fossil fuels; (3) capture and store carbon by planting and greening of urban landscapes and improving land and forest management practice; and (4) help people prepare for and withstand the significant impacts of climate change. Pledges that the House of Representatives will promptly introduce and enact legislation to achieve such goals.	2019-11-15T21:19:00Z

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