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

8 rows where package_id = "CHRG-111hhrg61758" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location

id package_id name ▼ title organization organization_normalized location
47914 VETERANS HEALTH ADMINISTRATION CONTRACTING AND PROCUREMENT PRACTICES CHRG-111hhrg61758 Frederick Downs Jr., Chief Procurement and Logistics Officer Veterans Health Administration VETERANS HEALTH ADMINISTRATION  
47915 VETERANS HEALTH ADMINISTRATION CONTRACTING AND PROCUREMENT PRACTICES CHRG-111hhrg61758 Goold Health Systems M.P.A., M.S., Chief Executive Officer Augusta, ME, James A. Clair AUGUSTA, ME, JAMES A. CLAIR  
47916 VETERANS HEALTH ADMINISTRATION CONTRACTING AND PROCUREMENT PRACTICES CHRG-111hhrg61758 Mobile Medical International Corporation Senior Vice President St. Johnsbury, VT, Mark T. Munroe, Sales and Marketing ST. JOHNSBURY, VT, MARK T. MUNROE, SALES AND MARKETING  
47917 VETERANS HEALTH ADMINISTRATION CONTRACTING AND PROCUREMENT PRACTICES CHRG-111hhrg61758 Modular Building Institute Senior Vice President and Chief Operating Officer Lincoln Moss, Ramtech Building Systems, Inc. LINCOLN MOSS, RAMTECH BUILDING SYSTEMS, INC. Mansfield, TX
47918 VETERANS HEALTH ADMINISTRATION CONTRACTING AND PROCUREMENT PRACTICES CHRG-111hhrg61758 Robert Bosch Healthcare MPA., President Palo Alto, CA, Derek Newell, MPH PALO ALTO, CA, DEREK NEWELL, MPH  
47913 VETERANS HEALTH ADMINISTRATION CONTRACTING AND PROCUREMENT PRACTICES CHRG-111hhrg61758 U.S. Department of Veterans Affairs: Belinda J. Finn Assistant Inspector General for Audits and Evaluations, Office of Inspector General      
47912 VETERANS HEALTH ADMINISTRATION CONTRACTING AND PROCUREMENT PRACTICES CHRG-111hhrg61758 U.S. Government Accountability Office Ph.D., M.S.H.A., Director Debra A. Draper, Health Care DEBRA A. DRAPER, HEALTH CARE  
47919 VETERANS HEALTH ADMINISTRATION CONTRACTING AND PROCUREMENT PRACTICES CHRG-111hhrg61758 Wise Knowledge Systems Ph.D., Chief Executive Officer Inc., Piper Creek, TX, Jay Wise INC., PIPER CREEK, TX, JAY WISE  

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;