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 = "hres", congress = 108 and policy_area = "Transportation and Public Works" sorted by introduced_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

policy_area 1

  • Transportation and Public Works · 2 ✖

congress 1

bill_type 1

  • hres · 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
108-hres-236 108 hres 236 Expressing the sense of the House of Representatives that United States air carriers should establish for all members of the Armed Forces on active duty reduced air fares that are comparable to the lowest airfare for ticketed flights, and for other purposes. Transportation and Public Works 2003-05-15 2003-05-16 Referred to the Subcommittee on Aviation. House Rep. Honda, Michael M. [D-CA-15] CA D H001034 3 Expresses the sense of the House of Representatives that each U.S. air carrier should: (1) establish for all members of the Armed Forces on active duty reduced air fares that are comparable to the lowest airfare for ticketed flights; and (2) offer flexible terms that allow such members to purchase, modify, or cancel tickets without time restrictions, fees, and penalties. 2023-01-15T15:48:22Z https://www.congress.gov/bill/108th-congress/house-resolution/236
108-hres-156 108 hres 156 Recognizing the goals and objectives of the Intelligent Transportation Systems Caucus. Transportation and Public Works 2003-03-20 2003-03-21 Referred to the Subcommittee on Highways, Transit and Pipelines. House Rep. Rogers, Mike J. [R-MI-8] MI R R000572 1 Recognizes specified goals and objectives of the Intelligent Transportation Systems Caucus. 2023-01-15T22:48:23Z https://www.congress.gov/bill/108th-congress/house-resolution/156

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