hearing_witnesses

Witnesses who testified at committee hearings, with parsed name, title, organization, and location.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

44 rows where package_id = "CHRG-105shrg42369" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
2558 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 1995 Status of the Nation's Surface Transportation System: Condition and Performance Report        
2560 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Alan E. Pisarski   author AUTHOR  
2556 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Andrew H. Card Jr., president and CEO American Automobile Manufacturers Association AMERICAN AUTOMOBILE MANUFACTURERS ASSOCIATION  
2561 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Commuting in America................................119-169 Rensink Report president Darrel, American Association of State Highway and Transportation Officials DARREL, AMERICAN ASSOCIATION OF STATE HIGHWAY AND TRANSPORTATION OFFICIALS  
2559 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Damian Kulash president and CEO ENO Transportation Foundation, Inc ENO TRANSPORTATION FOUNDATION, INC  
2567 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Daniel V. Flanagan Jr., chairman Commission to Promote Investment in America's Infrastructure COMMISSION TO PROMOTE INVESTMENT IN AMERICA'S INFRASTRUCTURE  
2589 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 David M. Gardiner Assistant Administrator for Policy Planning, and Evaluation, Environmental Protection Agency PLANNING, AND EVALUATION, ENVIRONMENTAL PROTECTION AGENCY  
2592 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Florida Highway Travel Demand--Current and Future Article        
2570 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Gerald S. Pfeffer senior vice president United Infrastructure Company UNITED INFRASTRUCTURE COMPANY  
2597 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Guillermo Vidal executive director Department of Transportation, State of Colorado DEPARTMENT OF TRANSPORTATION, STATE OF COLORADO  
2593 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Hal Hiemstra vice president of National Policy Rails to Trails RAILS TO TRAILS  
2562 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Hank Dittmar executive director Surface Transportation Policy Project SURFACE TRANSPORTATION POLICY PROJECT  
2588 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Hank Dittmar executive director Surface Transportation Policy Project SURFACE TRANSPORTATION POLICY PROJECT  
2579 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Hon. James M. Jeffords   U.S. Senator from the State of Vermont U.S. SENATOR FROM THE STATE OF VERMONT  
2581 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Hon. John McCain   U.S. Senator from the State of Arizona U.S. SENATOR FROM THE STATE OF ARIZONA  
2578 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Hon. Michael Huerta Associate Deputy Secretary Department of Transportation DEPARTMENT OF TRANSPORTATION  
2557 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Hon. Mortimer L. Downey Deputy Secretary Department of Transportation DEPARTMENT OF TRANSPORTATION  
2564 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Hon. Rodney E. Slater Secretary U.S. Department of Transportation U.S. DEPARTMENT OF TRANSPORTATION  
2566 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Hon. Rosa L. DeLauro   U.S. Representative from the State of Connecticut U.S. REPRESENTATIVE FROM THE STATE OF CONNECTICUT  
2598 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 ISTEA reauthorization principles List        
2565 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 James Costantino president and CEO ITS America ITS AMERICA  
2591 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Jane F. Garvey Acting Administrator Federal Highway Administration FEDERAL HIGHWAY ADMINISTRATION  
2574 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Jr. Biden   Hon. Joseph R., U.S. Senator from the State of Delaware HON. JOSEPH R., U.S. SENATOR FROM THE STATE OF DELAWARE  
2583 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Jr. Roth   Hon. William V., U.S. Senator from the State of Delaware HON. WILLIAM V., U.S. SENATOR FROM THE STATE OF DELAWARE  
2582 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Karen B. Phillips senior vice president Association of American Railroads ASSOCIATION OF AMERICAN RAILROADS  
2586 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Lawrence Dahms D., executive director Metropolitan Transportation Commission METROPOLITAN TRANSPORTATION COMMISSION  
2594 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Leon Kenison S., Commissioner Department of Transportation, State of New Hampshire DEPARTMENT OF TRANSPORTATION, STATE OF NEW HAMPSHIRE  
2584 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Leslie White   chairperson, American Public Transit Association, on Behalf of the Clark County Public Transportation Benefit Area Authority CHAIRPERSON, AMERICAN PUBLIC TRANSIT ASSOCIATION, ON BEHALF OF THE CLARK COUNTY PUBLIC TRANSPORTATION BENEFIT AREA AUTHORITY  
2569 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 List of Principles   ITS of America ITS OF AMERICA  
2585 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 M. Michael Cooke Board of County Commissioners chair CHAIR Douglas County, CO
2595 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Meg Maguire president Scenic America SCENIC AMERICA  
2568 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Mortimer Downey Deputy Secretary, Deputy Federal Highway Administrator and Christine Johnson, Director Department of Transportation; accompanied by Jane Garvey, Joint Program Office, Intelligent Transportation Systems DEPARTMENT OF TRANSPORTATION; ACCOMPANIED BY JANE GARVEY, JOINT PROGRAM OFFICE, INTELLIGENT TRANSPORTATION SYSTEMS  
2571 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Phyllis F. Scheinberg Associate Director, Assistant Director, Senior Evaluator Transportation and Telecommunications Issues, General Accounting Office; accompanied by Joseph Christoff, and Yvonne Pufahl TRANSPORTATION AND TELECOMMUNICATIONS ISSUES, GENERAL ACCOUNTING OFFICE; ACCOMPANIED BY JOSEPH CHRISTOFF, AND YVONNE PUFAHL  
2587 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Recommendations to amend title 23 U.S.C      
2573 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Robert E. Skinner Jr., executive director Transportation Research Board, National Academy of Sciences TRANSPORTATION RESEARCH BOARD, NATIONAL ACADEMY OF SCIENCES  
2590 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 The Emission Reduction Potential of the Congestion Mitigation and Air Quality Program Article        
2575 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Thomas J. Donohue president and chief executive officer American Trucking Associations, Inc AMERICAN TRUCKING ASSOCIATIONS, INC  
2577 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Thomas M. Downs chairman, president and chief executive officer National Railroad Passenger Corporation (Amtrak) NATIONAL RAILROAD PASSENGER CORPORATION (AMTRAK)  
2599 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Thomas Walker executive director Wisconsin Road Builders Association, on behalf of the American Road and Transportation Builders Association WISCONSIN ROAD BUILDERS ASSOCIATION, ON BEHALF OF THE AMERICAN ROAD AND TRANSPORTATION BUILDERS ASSOCIATION  
2596 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Timothy S. Stowe vice president, Anderson and Associates Incorporated; on behalf of American Consulting Engineers Council INCORPORATED; ON BEHALF OF AMERICAN CONSULTING ENGINEERS COUNCIL  
2572 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 Urban Transportation--Challenges to Widespread Deployment of Intelligent Transportation Systems Report   General Accounting Office GENERAL ACCOUNTING OFFICE  
2563 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 William D. Fay president and CEO American Highway Users Alliance AMERICAN HIGHWAY USERS ALLIANCE  
2580 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 William E. Loftus president American Short Line Railroad AMERICAN SHORT LINE RAILROAD  
2576 REAUTHORIZATION OF THE INTERMODAL SURFACE TRANSPORTATION EFFICIENCY ACT CHRG-105shrg42369 response to chart used at hearing Letter        

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE hearing_witnesses (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    package_id TEXT NOT NULL REFERENCES hearings(package_id),
    name TEXT,
    title TEXT,
    organization TEXT,
    organization_normalized TEXT,
    location TEXT
);
CREATE INDEX idx_hw_package ON hearing_witnesses(package_id);
CREATE INDEX idx_hw_name ON hearing_witnesses(name);
CREATE INDEX idx_hw_org ON hearing_witnesses(organization) WHERE organization IS NOT NULL AND organization != '';
CREATE INDEX idx_hw_org_norm ON hearing_witnesses(organization_normalized) WHERE organization_normalized IS NOT NULL;