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

21 rows where package_id = "CHRG-107shrg88056" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, title

id package_id name ▼ title organization organization_normalized location
14382 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Andrew J. Imparato President and Chief Executive Officer American Association of People with Disabilities AMERICAN ASSOCIATION OF PEOPLE WITH DISABILITIES  
14367 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Beverly A. Scott General Manager PhD, Rhode Island Public Transit Authority PHD, RHODE ISLAND PUBLIC TRANSIT AUTHORITY  
14373 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Carl Guardino President and Chief Executive Officer Silicon Valley Manufacturing Group SILICON VALLEY MANUFACTURING GROUP  
14369 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Carolyn Cheeks Kilpatrick   a U.S. Representative in Congress from the State of Michigan A U.S. REPRESENTATIVE IN CONGRESS FROM THE STATE OF MICHIGAN  
14366 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Faye L. Moore General Manager Southeastern Pennsylvania Transportation Authority SOUTHEASTERN PENNSYLVANIA TRANSPORTATION AUTHORITY  
14380 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Faye Thompson   Kenova, West Virginia KENOVA, WEST VIRGINIA  
14379 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Gloria McKenzie   Albany, New York ALBANY, NEW YORK  
14371 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 H. Brent Coles   Mayor, Boise, Idaho MAYOR, BOISE, IDAHO  
14376 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Hank Dittmar President The Great American Station Foundation, on behalf of the Surface Transportation Policy Project THE GREAT AMERICAN STATION FOUNDATION, ON BEHALF OF THE SURFACE TRANSPORTATION POLICY PROJECT  
14374 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Herschel L. Abbott Jr., Vice President- Governmental Affairs BellSouth Corporation BELLSOUTH CORPORATION  
14365 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Jennifer L. Dorn Administrator Federal Transit Administration, U.S. Department of Transportation FEDERAL TRANSIT ADMINISTRATION, U.S. DEPARTMENT OF TRANSPORTATION  
14384 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Jennifer L. Dorn Administrator Federal Transit Administration FEDERAL TRANSIT ADMINISTRATION  
14378 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Jessie Tehranchi   Birmingham, Alabama BIRMINGHAM, ALABAMA  
14383 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 John D. Porcari Secretary Maryland Department of Transportation MARYLAND DEPARTMENT OF TRANSPORTATION  
14372 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Kenneth Mayfield County Commissioner Dallas County, Texas DALLAS COUNTY, TEXAS  
14370 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Kwame M. Kilpatrick   Mayor, Detroit, Michigan MAYOR, DETROIT, MICHIGAN  
14368 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Larry Worth Executive Director Northeastern Colorado Association of Local Governments NORTHEASTERN COLORADO ASSOCIATION OF LOCAL GOVERNMENTS  
14381 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Lavada E. DeSalles Member, Board of Directors AARP AARP  
14377 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Michael A. Replogle Transportation Director Environmental Defense ENVIRONMENTAL DEFENSE  
14385 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Peter Guerrero Director, Senior Analyst; and Susan Fleming, Assistant Director Physical Infrastructure Issues, accompanied by: Nikki Clowers, Physical Infrastructure Issues, U.S. General Accounting Office PHYSICAL INFRASTRUCTURE ISSUES, ACCOMPANIED BY: NIKKI CLOWERS, PHYSICAL INFRASTRUCTURE ISSUES, U.S. GENERAL ACCOUNTING OFFICE  
14375 REAUTHORIZATION OF THE TRANSPORTATION EQUITY ACT OF THE 21ST CENTURY (TEA-21) CHRG-107shrg88056 Robert Broadbent Manager Las Vegas Monorail Company LAS VEGAS MONORAIL COMPANY  

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;