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

7 rows where package_id = "CHRG-113hhrg93646" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
69277 EBOLA IN THE HOMELAND: THE IMPORTANCE OF EFFECTIVE INTERNATIONAL, FEDERAL, STATE, AND LOCAL COORDINATION CHRG-113hhrg93646 Dr. Brett P. Giroir Executive Vice President and CEO, and Director Texas A&M Health Science Center, Texas Task Force on Infectious Disease Preparedness and Response: TEXAS A&M HEALTH SCIENCE CENTER, TEXAS TASK FORCE ON INFECTIOUS DISEASE PREPAREDNESS AND RESPONSE:  
69276 EBOLA IN THE HOMELAND: THE IMPORTANCE OF EFFECTIVE INTERNATIONAL, FEDERAL, STATE, AND LOCAL COORDINATION CHRG-113hhrg93646 Dr. David Lakey Commissioner of Health, Texas Department of State Health Services:      
69274 EBOLA IN THE HOMELAND: THE IMPORTANCE OF EFFECTIVE INTERNATIONAL, FEDERAL, STATE, AND LOCAL COORDINATION CHRG-113hhrg93646 Dr. Kathryn Brinsfield Acting Assistant Secretary and Chief Medical Officer Office of Health Affairs, U.S. Department of Homeland Security: OFFICE OF HEALTH AFFAIRS, U.S. DEPARTMENT OF HOMELAND SECURITY:  
69273 EBOLA IN THE HOMELAND: THE IMPORTANCE OF EFFECTIVE INTERNATIONAL, FEDERAL, STATE, AND LOCAL COORDINATION CHRG-113hhrg93646 Dr. Toby Merlin Director, U.S. Department of Health and Human Services: Division of Preparedness and Emerging Infection, National Center for Emerging and Zoonotic Infectious Diseases, Centers for Disease Control and Prevention DIVISION OF PREPAREDNESS AND EMERGING INFECTION, NATIONAL CENTER FOR EMERGING AND ZOONOTIC INFECTIOUS DISEASES, CENTERS FOR DISEASE CONTROL AND PREVENTION  
69278 EBOLA IN THE HOMELAND: THE IMPORTANCE OF EFFECTIVE INTERNATIONAL, FEDERAL, STATE, AND LOCAL COORDINATION CHRG-113hhrg93646 Hon. Clay Lewis Jenkins   Judge, Dallas County, Texas: JUDGE, DALLAS COUNTY, TEXAS:  
69275 EBOLA IN THE HOMELAND: THE IMPORTANCE OF EFFECTIVE INTERNATIONAL, FEDERAL, STATE, AND LOCAL COORDINATION CHRG-113hhrg93646 Mr. John Wagner Acting Assistant Commisioner Office of Field Operations, U.S. Customs and Border Protection, U.S. Department of Homeland Security: OFFICE OF FIELD OPERATIONS, U.S. CUSTOMS AND BORDER PROTECTION, U.S. DEPARTMENT OF HOMELAND SECURITY:  
69279 EBOLA IN THE HOMELAND: THE IMPORTANCE OF EFFECTIVE INTERNATIONAL, FEDERAL, STATE, AND LOCAL COORDINATION CHRG-113hhrg93646 Ms. Catherine L. Troisi Ph.D., Associate Professor Division of Management, Policy, and Community Health Center for Infectious Diseases, The University of Texas: DIVISION OF MANAGEMENT, POLICY, AND COMMUNITY HEALTH CENTER FOR INFECTIOUS DISEASES, THE UNIVERSITY OF TEXAS:  

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;