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

6 rows where package_id = "CHRG-108hhrg85966" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
15558 OVERSIGHT HEARING ON THE STATUS OF THE NATIONAL PARK SERVICE CONCESSIONS MANAGEMENT PROGRAM AND IMPLEMENTING REGULATIONS CHRG-108hhrg85966 A. Durand Jones Deputy Director, National Park Service, D.C U.S. Department of the Interior, Washington U.S. DEPARTMENT OF THE INTERIOR, WASHINGTON  
15560 OVERSIGHT HEARING ON THE STATUS OF THE NATIONAL PARK SERVICE CONCESSIONS MANAGEMENT PROGRAM AND IMPLEMENTING REGULATIONS CHRG-108hhrg85966 Andrew N. Todd Chairman, and President and CEO National Park Hospitality Association, Xanterra Parks & Resorts, Aurora, Colorado NATIONAL PARK HOSPITALITY ASSOCIATION, XANTERRA PARKS & RESORTS, AURORA, COLORADO  
15557 OVERSIGHT HEARING ON THE STATUS OF THE NATIONAL PARK SERVICE CONCESSIONS MANAGEMENT PROGRAM AND IMPLEMENTING REGULATIONS CHRG-108hhrg85966 Bruce W. Fears President Delaware North Companies Parks and Resorts, Inc., Buffalo, New York DELAWARE NORTH COMPANIES PARKS AND RESORTS, INC., BUFFALO, NEW YORK  
15562 OVERSIGHT HEARING ON THE STATUS OF THE NATIONAL PARK SERVICE CONCESSIONS MANAGEMENT PROGRAM AND IMPLEMENTING REGULATIONS CHRG-108hhrg85966 David B. Woodside Vice-Chairman, and President and General Manager National Park Hospitality Association, The Acadia Corporation, Bar Harbor, Maine NATIONAL PARK HOSPITALITY ASSOCIATION, THE ACADIA CORPORATION, BAR HARBOR, MAINE  
15559 OVERSIGHT HEARING ON THE STATUS OF THE NATIONAL PARK SERVICE CONCESSIONS MANAGEMENT PROGRAM AND IMPLEMENTING REGULATIONS CHRG-108hhrg85966 Jennifer Lamb Public Policy Director National Outdoor Leadership School, Lander, Wyoming NATIONAL OUTDOOR LEADERSHIP SCHOOL, LANDER, WYOMING  
15561 OVERSIGHT HEARING ON THE STATUS OF THE NATIONAL PARK SERVICE CONCESSIONS MANAGEMENT PROGRAM AND IMPLEMENTING REGULATIONS CHRG-108hhrg85966 Philip H. Voorhees Vice President, D.C Park Funding and Management, National Parks Conservation Association, Washington PARK FUNDING AND MANAGEMENT, NATIONAL PARKS CONSERVATION ASSOCIATION, WASHINGTON  

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;