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

13 rows where package_id = "CHRG-107shrg88460" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized, location

id package_id name ▼ title organization organization_normalized location
14441 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Articles: Road to Revolution Coming?   Bond Buyer BOND BUYER  
14443 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Bond Buyer Leftovers        
14450 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 David Seltzer   Distinguished Practitioner, Mercator Advisors, Philadelphia, PA, on behalf of the University of Southern California Los Angeles, CA National Center for Innovations in Public Finance DISTINGUISHED PRACTITIONER, MERCATOR ADVISORS, PHILADELPHIA, PA, ON BEHALF OF THE UNIVERSITY OF SOUTHERN CALIFORNIA LOS ANGELES, CA NATIONAL CENTER FOR INNOVATIONS IN PUBLIC FINANCE  
14451 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Findings and Recommendations for Innovative Financing Report   National Center for Innovations in Public Finance NATIONAL CENTER FOR INNOVATIONS IN PUBLIC FINANCE  
14445 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Hon. Janice Hahn   Councilwoman, City of Los Angeles, Los Angeles, CA, on behalf of the Alameda Corridor Transportation Authority COUNCILWOMAN, CITY OF LOS ANGELES, LOS ANGELES, CA, ON BEHALF OF THE ALAMEDA CORRIDOR TRANSPORTATION AUTHORITY  
14448 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Hon. Peter Rahn Secretary New Mexico Department of Transportation NEW MEXICO DEPARTMENT OF TRANSPORTATION Santa Fe, NM
14446 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 JayEtta Hecker Director of Physical Infrastructure Issues General Accounting Office GENERAL ACCOUNTING OFFICE  
14440 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Jeff Carey managing director Merrill Lynch & Co., Inc. MERRILL LYNCH & CO., INC. New York, NY
14447 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 John Horsley Executive Director American Association of State Highway and Transportation Officials AMERICAN ASSOCIATION OF STATE HIGHWAY AND TRANSPORTATION OFFICIALS Washington, DC
14452 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Key Drivers on Innovative Finance Table        
14449 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Phyllis Scheinberg Deputy Assistant Secretary for Budget and Programs Department of Transportation DEPARTMENT OF TRANSPORTATION  
14442 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Senate Panel Leaders Lobby DOT to Use Innovation in Its Funding   Bond Buyer BOND BUYER  
14444 INNOVATIVE FINANCING: BEYOND THE HIGHWAY TRUST FUND CHRG-107shrg88460 Transportation for Upcoming Reauthorization of TEA-21   Transportation Watch TRANSPORTATION WATCH  

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;