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

5 rows where package_id = "CHRG-105hhrg51714" 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
1462 OVERSIGHT HEARING ON THE GENERAL ACCOUNTING OFFICE STUDY ON FOREST HEALTH CHRG-105hhrg51714 Barry Hill Associate Director, Senior Evaluator Energy, Resources and Science Issues, General Accounting Office, Washington, DC; accompanied by Chester Joy, Energy, Resources and Science Issues, General Accounting Office, Washington, DC; Ryan Coles, and Ross Campbell ENERGY, RESOURCES AND SCIENCE ISSUES, GENERAL ACCOUNTING OFFICE, WASHINGTON, DC; ACCOMPANIED BY CHESTER JOY, ENERGY, RESOURCES AND SCIENCE ISSUES, GENERAL ACCOUNTING OFFICE, WASHINGTON, DC; RYAN COLES, AND ROSS CAMPBELL  
1463 OVERSIGHT HEARING ON THE GENERAL ACCOUNTING OFFICE STUDY ON FOREST HEALTH CHRG-105hhrg51714 Earl Marcellus Chelan County Commissioner Wenatchee, Washington WENATCHEE, WASHINGTON  
1465 OVERSIGHT HEARING ON THE GENERAL ACCOUNTING OFFICE STUDY ON FOREST HEALTH CHRG-105hhrg51714 Gordon Ross Coos County Commissioner Coquille, Oregon COQUILLE, OREGON  
1464 OVERSIGHT HEARING ON THE GENERAL ACCOUNTING OFFICE STUDY ON FOREST HEALTH CHRG-105hhrg51714 Janice McDougle Associate Deputy Chief for State and Private Forestry, Forest Service, Acting Director, Forest Service U.S. Department of Agriculture, Washington, DC; accompanied by Harry Croft, Fire and Aviation Management, U.S. Department of Agriculture U.S. DEPARTMENT OF AGRICULTURE, WASHINGTON, DC; ACCOMPANIED BY HARRY CROFT, FIRE AND AVIATION MANAGEMENT, U.S. DEPARTMENT OF AGRICULTURE Washington, DC
1466 OVERSIGHT HEARING ON THE GENERAL ACCOUNTING OFFICE STUDY ON FOREST HEALTH CHRG-105hhrg51714 Neil Sampson President The Sampson Group, Inc., Alexandria, Virginia THE SAMPSON GROUP, INC., ALEXANDRIA, VIRGINIA  

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;