openregs: legislation: 4 rows where bill_type = "hconres", congress = 106 and policy_area = "Transportation and Public Works" 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

4 rows where bill_type = "hconres", congress = 106 and policy_area = "Transportation and Public Works" 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
106-hconres-388	106	hconres	388	Recognizing the historic significance of the 100th anniversary of the AAA Ohio Motorists Association, and extending best wishes for the continued success of the organization.	Transportation and Public Works	2000-07-27	2000-07-27	Referred to the Subcommittee on Ground Transportation.	House	Rep. Jones, Stephanie Tubbs [D-OH-11]	OH	D	J000284	18	Recognizes the historic significance of the 100th anniversary of the AAA Ohio Motorists Association.	2025-01-02T17:07:49Z	https://www.congress.gov/bill/106th-congress/house-concurrent-resolution/388
106-hconres-306	106	hconres	306	Expressing the sense of Congress in support of the freeze on longer combination vehicles and current Federal limitations on truck size and weight.	Transportation and Public Works	2000-04-12	2000-04-14	Referred to the Subcommittee on Ground Transportation.	House	Rep. McGovern, James P. [D-MA-3]	MA	D	M000312	138	Safe Highways Resolution - Expresses the sense of Congress that certain statutory proscriptions and restrictions: (1) on longer combination vehicles should not be amended so as to weaken the current "freeze" on those vehicles or result in any less restrictive prohibition or restrictions upon them; and (2) should not be amended so as to permit operation of commercial motor vehicles with a gross vehicle weight greater than that currently allowed under Federal law.	2025-01-02T17:07:35Z	https://www.congress.gov/bill/106th-congress/house-concurrent-resolution/306
106-hconres-219	106	hconres	219	Expressing the sense of Congress regarding the preservation of full and open competition for contracts for the transportation of United States military cargo between the United States and the Republic of Iceland.	Transportation and Public Works	1999-11-02	1999-11-17	Referred to the Subcommittee on Military Readiness.	House	Rep. Frelinghuysen, Rodney P. [R-NJ-11]	NJ	R	F000372	0	Expresses the sense of Congress that the President should ensure that full and open competition continues in the selection of companies to transport U.S. military cargo between the United States and Iceland in accordance with the Treaty Between the United States of America and the Republic of Iceland to Facilitate Their Defense Relationship and Related Memorandum of Understanding in Implementation of the Treaty, signed September 24, 1986.Declares that neither the Secretary of State nor any other official of the United States should, without the advice and consent of the Senate, seek to amend, interpret, or alter the administration of the treaty or memorandum of understanding in any manner (through limitations on eligibility or otherwise) that: (1) would preclude companies qualified to conduct business under the laws of the United States or the Republic of Iceland from submitting offers for, being awarded, or performing such a transportation contract; or (2) would otherwise defeat the purpose of enhancing competition among United States-flag carriers or among Icelandic shipping companies under the treaty or memorandum.	2025-06-06T14:17:56Z	https://www.congress.gov/bill/106th-congress/house-concurrent-resolution/219
106-hconres-187	106	hconres	187	Expressing the sense of Congress regarding the European Council noise rule affecting hushkitted and reengined aircraft.	Transportation and Public Works	1999-09-22	1999-09-28	Received in the Senate and referred to the Committee on Commerce.	House	Rep. Shuster, Bud [R-PA-9]	PA	R	S000394	5	Expresses the sense of Congress that: (1) if European Council Regulation No. 925-1999 (banning certain aircraft from flying in Europe) is not rescinded by the European Council at the earliest possible date, the Secretaries of Transportation and State should take all appropriate actions to ensure that a petition regarding the regulation is filed with the International Civil Aviation Organization under Article 84 of the Chicago Convention; and (2) the Secretaries of Commerce, State, and Transportation and other appropriate parties should use all reasonable means available to ensure that such regulation is rescinded.	2025-04-07T13:47:06Z	https://www.congress.gov/bill/106th-congress/house-concurrent-resolution/187

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