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

12 rows where package_id = "CHRG-106shrg71522" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title

id package_id name ▼ title organization organization_normalized location
7277 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Bob Proud Commissioner Clermont County, Ohio CLERMONT COUNTY, OHIO  
7274 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Daniel L. Neff Director Ohio Mid-Eastern Governments Association OHIO MID-EASTERN GOVERNMENTS ASSOCIATION  
7269 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Eugene Collins President of the Board Portsmouth Inner City Development Corporation PORTSMOUTH INNER CITY DEVELOPMENT CORPORATION  
7280 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Hidden Valley Ranch Letter        
7271 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Hon. Nancy Hollister   Representative, Ohio House of Representatives REPRESENTATIVE, OHIO HOUSE OF REPRESENTATIVES  
7278 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Jesse L. White Jr., Federal Co-Chairman Appalachian Regional Commission APPALACHIAN REGIONAL COMMISSION  
7275 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Joy Padgett Director Governor's Office of Appalachia, on behalf of Hon. Bob Taft, Governor, State of Ohio GOVERNOR'S OFFICE OF APPALACHIA, ON BEHALF OF HON. BOB TAFT, GOVERNOR, STATE OF OHIO  
7270 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 June Holley President Appalachian Center for Economic Networks (ACENET) APPALACHIAN CENTER FOR ECONOMIC NETWORKS (ACENET)  
7273 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Larry Merry Executive Director Zanesville-Muskingum County Port Authority ZANESVILLE-MUSKINGUM COUNTY PORT AUTHORITY  
7272 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Leslie Lilly President and Chief Executive Officer Foundation for Appalachian Ohio FOUNDATION FOR APPALACHIAN OHIO  
7276 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Richard J. Platt Executive Director Alliance 2000 ALLIANCE 2000  
7279 OVERSIGHT OF THE APPALACHIAN REGIONAL COMMISSION CHRG-106shrg71522 Wayne F. White Executive Director Ohio Appalachian Center for Higher Education, Shawnee State University OHIO APPALACHIAN CENTER FOR HIGHER EDUCATION, SHAWNEE STATE UNIVERSITY  

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;