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

4 rows where package_id = "CHRG-116hhrg42326" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
92085 LEGISLATIVE HEARING ON OCEAN CLIMATE ACTION: SOLUTIONS TO THE CLIMATE CRISIS CHRG-116hhrg42326 Jane Lubchenco University Distinguished Professor, Wayne and Gladys Valley Professor of Marine Biology, Marine Studies Advisor to the President of Oregon State University Corvallis, Oregon CORVALLIS, OREGON  
92083 LEGISLATIVE HEARING ON OCEAN CLIMATE ACTION: SOLUTIONS TO THE CLIMATE CRISIS CHRG-116hhrg42326 Kelly Kryc Director of Ocean Policy New England Aquarium, Boston, Massachusetts NEW ENGLAND AQUARIUM, BOSTON, MASSACHUSETTS  
92084 LEGISLATIVE HEARING ON OCEAN CLIMATE ACTION: SOLUTIONS TO THE CLIMATE CRISIS CHRG-116hhrg42326 Kelsey Leonard Steering Committee Member Mid-Atlantic Committee on the Ocean, Enrolled Citizen Shinnecock Indian Nation, Long Island, New York MID-ATLANTIC COMMITTEE ON THE OCEAN, ENROLLED CITIZEN SHINNECOCK INDIAN NATION, LONG ISLAND, NEW YORK  
92082 LEGISLATIVE HEARING ON OCEAN CLIMATE ACTION: SOLUTIONS TO THE CLIMATE CRISIS CHRG-116hhrg42326 Ray Hilborn Professor School of Aquatic and Fishery Sciences, University of Washington, Seattle, Washington SCHOOL OF AQUATIC AND FISHERY SCIENCES, UNIVERSITY OF WASHINGTON, SEATTLE, 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;