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-118hhrg56828" 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
104987 H.R. 1479, H.R. 1504, H.R. 8931, H.R. 8946, H.R. 9159, H.R. 9492, H.R. 9516, AND S. 612 CHRG-118hhrg56828 Gabriella Kubinyi Member Gold Star Spouses of America, Inc. GOLD STAR SPOUSES OF AMERICA, INC. Washington, DC
104982 H.R. 1479, H.R. 1504, H.R. 8931, H.R. 8946, H.R. 9159, H.R. 9492, H.R. 9516, AND S. 612 CHRG-118hhrg56828 Julie W. Regan Executive Director Tahoe Regional Planning Agency, Stateline, Nevada TAHOE REGIONAL PLANNING AGENCY, STATELINE, NEVADA  
104984 H.R. 1479, H.R. 1504, H.R. 8931, H.R. 8946, H.R. 9159, H.R. 9492, H.R. 9516, AND S. 612 CHRG-118hhrg56828 Justine Jimmie Deputy Attorney General San Carlos Apache Tribe, San Carlos, Arizona SAN CARLOS APACHE TRIBE, SAN CARLOS, ARIZONA  
104981 H.R. 1479, H.R. 1504, H.R. 8931, H.R. 8946, H.R. 9159, H.R. 9492, H.R. 9516, AND S. 612 CHRG-118hhrg56828 Mike Caldwell Associate Director, National Park Service Park Planning, Facilities, and Lands PARK PLANNING, FACILITIES, AND LANDS Washington, DC
104985 H.R. 1479, H.R. 1504, H.R. 8931, H.R. 8946, H.R. 9159, H.R. 9492, H.R. 9516, AND S. 612 CHRG-118hhrg56828 Monica Preston President Willcox Chamber of Commerce and Agriculture, Willcox, Arizona WILLCOX CHAMBER OF COMMERCE AND AGRICULTURE, WILLCOX, ARIZONA  
104986 H.R. 1479, H.R. 1504, H.R. 8931, H.R. 8946, H.R. 9159, H.R. 9492, H.R. 9516, AND S. 612 CHRG-118hhrg56828 Pamela Goynes-Brown   Mayor, City of North Las Vegas, North Las Vegas, Nevada MAYOR, CITY OF NORTH LAS VEGAS, NORTH LAS VEGAS, NEVADA  
104980 H.R. 1479, H.R. 1504, H.R. 8931, H.R. 8946, H.R. 9159, H.R. 9492, H.R. 9516, AND S. 612 CHRG-118hhrg56828 Panel II: Emanuel Associate Deputy Chief, U.S. Forest Service Jacqueline, National Forest System JACQUELINE, NATIONAL FOREST SYSTEM Washington, DC
104983 H.R. 1479, H.R. 1504, H.R. 8931, H.R. 8946, H.R. 9159, H.R. 9492, H.R. 9516, AND S. 612 CHRG-118hhrg56828 Sandra Marra President and CEO Appalachian Trail Conservancy, Harpers Ferry, West Virginia APPALACHIAN TRAIL CONSERVANCY, HARPERS FERRY, WEST 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;