legislation
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
3 rows where bill_type = "hconres", congress = 107 and policy_area = "Transportation and Public Works" sorted by introduced_date descending
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107-hconres-506 | 107 | hconres | 506 | Urging the States to include in their driver's license exams at least one question about highway-rail grade crossings safety by fiscal year 2005. | Transportation and Public Works | 2002-10-08 | 2002-10-08 | Referred to the House Committee on Transportation and Infrastructure. | House | Rep. Shuster, Bill [R-PA-9] | PA | R | S001154 | 0 | Urges the States by FY 2005 to include in their driver's license exams (including commercial driver's license exams) at least one question regarding highway-rail grade crossings safety. | 2025-01-02T16:42:02Z | https://www.congress.gov/bill/107th-congress/house-concurrent-resolution/506 |
| 107-hconres-238 | 107 | hconres | 238 | Expressing the sense of Congress that States should require candidates for driver's licenses to demonstrate an ability to exercise greatly increased caution when driving in the proximity of potentially visually impaired individuals. | Transportation and Public Works | 2001-10-02 | 2001-10-03 | Referred to the Subcommittee on Highways and Transit. | House | Rep. Evans, Lane [D-IL-17] | IL | D | E000250 | 24 | Expresses the sense of Congress that each State should require, as a condition of obtaining a driver's license, that a candidate demonstrate an ability to recognize a white cane, associate the use of a white cane with a visually impaired individual, and exercise increased caution when driving in proximity to a potentially visually impaired individual. | 2025-01-02T16:41:14Z | https://www.congress.gov/bill/107th-congress/house-concurrent-resolution/238 |
| 107-hconres-171 | 107 | hconres | 171 | Expressing the sense of Congress regarding graduated driver's license programs. | Transportation and Public Works | 2001-06-20 | 2001-06-22 | Referred to the Subcommittee on Highways and Transit. | House | Rep. Smith, Christopher H. [R-NJ-4] | NJ | R | S000522 | 0 | Expresses the sense of Congress that: (1) each State should examine the benefits of establishing a graduated driver's license program if it does not have one, and if it does, to fully monitor, review, and improve it; (2) the National Highway Traffic Safety Administration should continue its studies and programs regarding the effects of such programs on improving automobile safety; and (3) specified entities and groups should be praised for their successful efforts to educate the public regarding the benefits of graduated driver's license programs and to establish such programs in many States. | 2025-01-02T16:41:14Z | https://www.congress.gov/bill/107th-congress/house-concurrent-resolution/171 |
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);