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

11 rows where package_id = "CHRG-105shrg52634" 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
3127 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 EDA Investment History by State Tables        
3126 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 EDA Success Story Report   North Little Rock, Arkansas NORTH LITTLE ROCK, ARKANSAS  
3120 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 EDA activities Letter   by Phillip Singerman BY PHILLIP SINGERMAN  
3123 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 Eric P. Thompson Executive Director, Lower Savannah Council of Governments and President National Association of Development Organizations, on behalf of the Coalition for Economic Development NATIONAL ASSOCIATION OF DEVELOPMENT ORGANIZATIONS, ON BEHALF OF THE COALITION FOR ECONOMIC DEVELOPMENT  
3124 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 Floyd G. Villines Judge/Executive Pulaski County, Arkansas, on behalf of the Coalition for Economic Development PULASKI COUNTY, ARKANSAS, ON BEHALF OF THE COALITION FOR ECONOMIC DEVELOPMENT Little Rock, AR
3125 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 Membership list   Coalition for Economic Development COALITION FOR ECONOMIC DEVELOPMENT  
3121 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 National Academy of Public Administration Report        
3122 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 Phillip Singerman Assistant Secretary for Economic Development Department of Commerce DEPARTMENT OF COMMERCE  
3119 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 R. Scott Fosler President National Academy of Public Administration NATIONAL ACADEMY OF PUBLIC ADMINISTRATION  
3117 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 Robert W. Burchell   Center for Urban Policy Research, Rutgers University CENTER FOR URBAN POLICY RESEARCH, RUTGERS UNIVERSITY New Brunswick, NJ
3118 ECONOMIC DEVELOPMENT PARTNERSHIP ACT CHRG-105shrg52634 William Daley Secretary Department of Commerce DEPARTMENT OF COMMERCE  

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;