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-107hhrg82578" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
10782 SMALL BUSINESS HELPING THE DISABLED LEAD PRODUCTIVE LIVES CHRG-107hhrg82578 Guillermo ``Bill Vidal '' Executive Director Denver Regional Council of Governments (DRCOG) DENVER REGIONAL COUNCIL OF GOVERNMENTS (DRCOG)  
10777 SMALL BUSINESS HELPING THE DISABLED LEAD PRODUCTIVE LIVES CHRG-107hhrg82578 Hon. Roy Grizzard Assistant Secretary Office of Disability Employment Policy, U.S. Department of Labor OFFICE OF DISABILITY EMPLOYMENT POLICY, U.S. DEPARTMENT OF LABOR  
10778 SMALL BUSINESS HELPING THE DISABLED LEAD PRODUCTIVE LIVES CHRG-107hhrg82578 Hon. Tony Coehlo       Alexandria, VA
10784 SMALL BUSINESS HELPING THE DISABLED LEAD PRODUCTIVE LIVES CHRG-107hhrg82578 Jane Anderson Executive Director Midwest Institute for Telecommuting Education MIDWEST INSTITUTE FOR TELECOMMUTING EDUCATION  
10779 SMALL BUSINESS HELPING THE DISABLED LEAD PRODUCTIVE LIVES CHRG-107hhrg82578 Janet Fiore CEO The Sierra Group, Inc., The King of Prussia Medical Center THE SIERRA GROUP, INC., THE KING OF PRUSSIA MEDICAL CENTER  
10780 SMALL BUSINESS HELPING THE DISABLED LEAD PRODUCTIVE LIVES CHRG-107hhrg82578 Phil Kosak President Carolina Fine Snacks CAROLINA FINE SNACKS  
10781 SMALL BUSINESS HELPING THE DISABLED LEAD PRODUCTIVE LIVES CHRG-107hhrg82578 Sanford Lupovitz President RIBI Security RIBI SECURITY  
10783 SMALL BUSINESS HELPING THE DISABLED LEAD PRODUCTIVE LIVES CHRG-107hhrg82578 Tim Kane President International Telework Association and Council (ITAC) INTERNATIONAL TELEWORK ASSOCIATION AND COUNCIL (ITAC)  

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;