home / openregs

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 = "hconres", congress = 103 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 · 3 ✖

congress 1

  • 103 · 3 ✖

bill_type 1

  • hconres · 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-hconres-307 103 hconres 307 Expressing the sense of Congress regarding the United States position on the disinsection of aircraft at the 11th meeting of the Facilitation Division of the International Civil Aviation Organization. Transportation and Public Works 1994-10-05 1994-10-17 Referred to the Subcommittee on Aviation. House Rep. DeFazio, Peter A. [D-OR-4] OR D D000191 0 Expresses the sense of the Congress that the U.S. delegation to the spring 1995 meeting of the facilitation division of the International Civil Aviation Organization should seek: (1) to amend the Convention on International Civil Aviation to end aircraft disinsection practices that threaten the health of aircraft passengers and crew; and (2) the support and cosponsorship of other member nations of the organization for that amendment. 2024-02-07T16:02:17Z https://www.congress.gov/bill/103rd-congress/house-concurrent-resolution/307
103-hconres-241 103 hconres 241 Expressing the sense of the Congress with respect to the railroad retirement system. Transportation and Public Works 1994-04-20 1994-04-26 Referred to the Subcommittee on Transportation and Hazardous Materials. House Rep. Geren, Pete [D-TX-12] TX D G000134 0 Expresses the sense of the Congress that: (1) continued Federal commitment to the railroad retirement system is essential to assure the integrity of railroad retirees' benefits; and (2) preservation of such system's present structure, including the administrative framework of the Railroad Retirement Board, is necessary to fulfill the Federal Government's time-honored responsibility. 2024-02-05T14:30:09Z https://www.congress.gov/bill/103rd-congress/house-concurrent-resolution/241
103-hconres-107 103 hconres 107 Expressing the sense of Congress that United States truck safety standards not be compromised incident to the implementation of the North American Free Trade Agreement. Transportation and Public Works 1993-05-27 1993-06-10 Referred to the Subcommittee on Surface Transportation. House Rep. Brown, Sherrod [D-OH-13] OH D B000944 141 Declares that it is the Congress' intent that the Secretary of Transportation, in negotiating under the auspices of the Land Transportation Standards Committee established under the North American Free Trade Agreement (NAFTA), shall not weaken U.S. truck safety standards by increasing truck sizes and weights or by compromising such standards as truck driver hours of service, front brake and other safety equipment requirements, and the truck driver record system. 2025-01-02T17:20:49Z https://www.congress.gov/bill/103rd-congress/house-concurrent-resolution/107

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);
Powered by Datasette · Queries took 18.719ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy