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-111shrg53064" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, title, location

id package_id name ▼ title organization organization_normalized location
50407 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 1LT Tulsi Gabbard Tamayo   Hawaii Army National Guard HAWAII ARMY NATIONAL GUARD  
50413 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 BG Gary M. Ishikawa Deputy Adjutant General State of Hawaii STATE OF HAWAII  
50417 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 CDR Larry Helm   Molokai Veterans Caring for Veterans MOLOKAI VETERANS CARING FOR VETERANS  
50418 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Clarence Kamai Jr. Molokai Representative, Veterans Caring for Veterans MOLOKAI REPRESENTATIVE, VETERANS CARING FOR VETERANS  
50419 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Danny Kanahele VA Advisory Council Member      
50415 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Karl Calleon   Vietnam Veteran and Commander, DAV, Chapter 2 VIETNAM VETERAN AND COMMANDER, DAV, CHAPTER 2 Maiu, HI
50427 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Linda Halliday Deputy Assistant Inspector General for Audits and Evaluations, Office of Inspector General U.S. Department of Veterans Affairs U.S. DEPARTMENT OF VETERANS AFFAIRS  
50423 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Lloyd K. Sodetani Hawaii Office of Veterans Services Maui Representative MAUI REPRESENTATIVE  
50422 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Mitch Skaggerberg President Vietnam Veterans of Maui County VIETNAM VETERANS OF MAUI COUNTY  
50420 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Paul Laub President Maui County Veterans Council MAUI COUNTY VETERANS COUNCIL  
50414 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Raymond Jefferson Assistant Secretary Veterans' Employment and Training, U.S. Department of Labor VETERANS' EMPLOYMENT AND TRAINING, U.S. DEPARTMENT OF LABOR  
50425 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Response to request arising during the hearing by Hon. Daniel K. Akaka.................................................128        
50416 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Rogelio G. Evangelista Advisory Board Member VA Pacific Islands Health Care System VA PACIFIC ISLANDS HEALTH CARE SYSTEM  
50408 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 SFC Sualauvi Tuimalealiifano   III, Hawaii III, HAWAII  
50410 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Shannon Tuimalealiifano   veteran and wife of SFC Sualauvi Tuimalealiifano VETERAN AND WIFE OF SFC SUALAUVI TUIMALEALIIFANO  
50412 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Sheila Cullen Director, Veterans Integrated Service Network (VISN) 21, M.D., Director, M.D., Chief Consultant for Care Coordination U.S. Department of Veterans Affairs; accompanied by James Hastings, VA Pacific Islands Health Care System; and Adam W. Darkins, Veterans Health Administration U.S. DEPARTMENT OF VETERANS AFFAIRS; ACCOMPANIED BY JAMES HASTINGS, VA PACIFIC ISLANDS HEALTH CARE SYSTEM; AND ADAM W. DARKINS, VETERANS HEALTH ADMINISTRATION  
50426 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Sheila Cullen Director VA Sierra Pacific Network (VISN 21), Veterans Health Administration, U.S. Department of Veterans Affairs VA SIERRA PACIFIC NETWORK (VISN 21), VETERANS HEALTH ADMINISTRATION, U.S. DEPARTMENT OF VETERANS AFFAIRS  
50421 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Terry Poaipuni   Wife of a Vietnam Veteran WIFE OF A VIETNAM VETERAN  
50411 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Tracey Betts Honolulu Regional Office Director Veterans Benefits Administration, U.S. Department of Veterans Affairs VETERANS BENEFITS ADMINISTRATION, U.S. DEPARTMENT OF VETERANS AFFAIRS  
50424 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 Tracey Betts Director Honolulu VA Regional Office, U.S. Department of Veterans Affairs HONOLULU VA REGIONAL OFFICE, U.S. DEPARTMENT OF VETERANS AFFAIRS  
50409 FIELD HEARING ON VA OUTREACH TO RETURNING GUARD UNITS CHRG-111shrg53064 ``Clay'' William Clayton Sam Park Veterans Program Director Papa Ola Lokahi PAPA OLA LOKAHI  

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;