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

6 rows where bill_type = "hjres", congress = 95 and policy_area = "Environmental Protection" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, latest_action_text, sponsor_name, sponsor_state, sponsor_party, sponsor_bioguide_id, cosponsor_count, summary_text, update_date, introduced_date (date), latest_action_date (date), update_date (date)

policy_area 1

  • Environmental Protection · 6 ✖

congress 1

bill_type 1

  • hjres · 6 ✖
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
95-hjres-929 95 hjres 929 A resolution calling for protection of international waters from further pollution. Environmental Protection 1978-05-19 1978-05-19 Referred to House Committee on International Relations. House Rep. Whitehurst, G. William [R-VA-2] VA R W000406 1 Directs the President to seek an international agreement to prevent pollution of the oceans by establishing tanker safety criteria. 2024-08-01T19:57:28Z  
95-hjres-849 95 hjres 849 A resolution calling for protection of international waters from further pollution. Environmental Protection 1978-04-12 1978-04-12 Referred to House Committee on International Relations. House Rep. Whitehurst, G. William [R-VA-2] VA R W000406 1 Directs the President to seek an international agreement to prevent pollution of the oceans by establishing tanker safety criteria. 2024-08-01T19:57:23Z  
95-hjres-843 95 hjres 843 Joint resolution calling for protection of international waters from further pollution. Environmental Protection 1978-04-11 1978-04-11 Referred to House Committee on International Relations. House Rep. Whitehurst, G. William [R-VA-2] VA R W000406 7 Directs the President to seek an international agreement to prevent pollution of the oceans by establishing tanker safety criteria. 2024-08-01T19:57:23Z  
95-hjres-313 95 hjres 313 Joint resolution calling for protection of international waters from further pollution. Environmental Protection 1977-03-09 1977-03-09 Referred to House Committee on International Relations. House Rep. Whitehurst, G. William [R-VA-2] VA R W000406 3 Directs the President to seek an international agreement to prevent pollution of the oceans by establishing tanker safety criteria. 2024-08-01T19:57:03Z  
95-hjres-284 95 hjres 284 Joint resolution calling for protection of international waters from further pollution. Environmental Protection 1977-02-24 1977-02-24 Referred to House Committee on International Relations. House Rep. Whitehurst, G. William [R-VA-2] VA R W000406 13 Proposes that the President seek a treaty or appropriate international agreement to establish criteria for tanker safety and to take whatever other steps may be necessary to protect international waters from further pollution. 2024-08-01T19:57:04Z  
95-hjres-174 95 hjres 174 Joint resolution designating National Coaches' Day. Environmental Protection 1977-01-19 1977-01-19 Referred to House Committee on Post Office and Civil Service. House Rep. Roe, Robert A. [D-NJ-8] NJ D R000383 0 Authorizes the President of the United States to designate October 1, 1977, as "National Coaches' Day." 2024-08-01T19:57:01Z  

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