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

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

✎ View and edit SQL

This data as json, CSV (advanced)

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

policy_area 1

  • Environmental Protection · 3 ✖

congress 1

bill_type 1

  • hjres · 3 ✖
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
103-hjres-350 103 hjres 350 Designating April 1994 as "National Buy Recycled Materials and Products Month". Environmental Protection 1994-04-12 1994-04-12 Referred to the House Committee on Post Office and Civil Service. House Rep. Moran, James P. [D-VA-8] VA D M000933 15 Designates April 1994 as National Buy Recycled Materials and Products Month. 2024-02-06T20:04:02Z  
103-hjres-242 103 hjres 242 Designating the week beginning October 17, 1993, as "National Radon Action Week". Environmental Protection 1993-07-28 1993-07-28 Referred to the House Committee on Post Office and Civil Service. House Rep. Markey, Edward J. [D-MA-7] MA D M000133 102 Designates the week beginning October 17, 1993, as National Radon Action Week. 2024-02-06T20:04:02Z  
103-hjres-222 103 hjres 222 Authorizing the President to proclaim 1993 as "America-the-Beautiful Year". Environmental Protection 1993-06-30 1993-06-30 Referred to the House Committee on Post Office and Civil Service. House Rep. Studds, Gerry E. [D-MA-10] MA D S001040 0 Authorizes the President to issue a proclamation designating the year 1993 as the America-the-Beautiful Year, commemorating the 100th anniversary of the writing of the poem or hymn, "America the Beautiful." 2024-02-06T20:04:02Z  

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