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

14 rows where package_id = "CHRG-115shrg57909" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized

id package_id name ▼ title organization organization_normalized location
88160 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Hon. Dan Rivera   Mayor, City of Lawrence MAYOR, CITY OF LAWRENCE  
88149 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Hon. Elizabeth Warren   U.S. Senator from Massachusetts U.S. SENATOR FROM MASSACHUSETTS  
88152 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Hon. Lori Trahan   U.S. Representative-Elect from Massachusetts U.S. REPRESENTATIVE-ELECT FROM MASSACHUSETTS  
88155 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Hon. Matthew A. Beaton Secretary, Massachusetts Executive Office of Energy and Environmental Affairs      
88150 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Hon. Niki Tsongas   U.S. Representative from Massachusetts U.S. REPRESENTATIVE FROM MASSACHUSETTS  
88154 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Hon. Robert L. Sumwalt III Chairman National Transportation Safety Board NATIONAL TRANSPORTATION SAFETY BOARD  
88151 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Hon. Seth Moulton   U.S. Representative from Massachusetts U.S. REPRESENTATIVE FROM MASSACHUSETTS  
88157 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Joe Hamrock President and Chief Executive Officer NiSource NISOURCE  
88153 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Lucyannie Rondon   Sister of Leonel Rondon SISTER OF LEONEL RONDON  
88162 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Michael B. Mansfield Fire Chief Andover Fire Rescue ANDOVER FIRE RESCUE  
88159 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Paul Roberti Chief Counsel Pipeline and Hazardous Materials Safety Administration PIPELINE AND HAZARDOUS MATERIALS SAFETY ADMINISTRATION  
88158 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Richard B. Kuprewicz President Accufacts, Incorporated ACCUFACTS, INCORPORATED  
88156 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Steve Bryant President Columbia Gas of Massachusetts COLUMBIA GAS OF MASSACHUSETTS  
88161 PIPELINE SAFETY IN THE MERRIMACK VALLEY: INCIDENT PREVENTION AND RESPONSE CHRG-115shrg57909 Tina Messina   Owner, Wine Connextion OWNER, WINE CONNEXTION  

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;