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

21 rows where package_id = "CHRG-110shrg48815" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized, location

id package_id name ▼ title organization organization_normalized location
40168 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Barbara Griffin Pro Bono Coordinator Allegheny County Bar Foundation, Pittsburgh, Pennsylvania ALLEGHENY COUNTY BAR FOUNDATION, PITTSBURGH, PENNSYLVANIA  
40180 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Brian Hudson CEO Pennsylvania Housing Finance Agency PENNSYLVANIA HOUSING FINANCE AGENCY  
40182 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 C. Darnell Jones President Judge First Judicial District of Pennsylvania Court of Common Pleas of Philadelphia County      
40183 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Curtis Jones Jr., Member Philadelphia City Council, Philadelphia Pennsylvania PHILADELPHIA CITY COUNCIL, PHILADELPHIA PENNSYLVANIA  
40179 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Cynthia Henderson   Homeowner HOMEOWNER  
40172 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Dan Sullivan   Mortgage Foreclosure Prevention Specialist, ACTION-Housing, Inc., Pittsburgh, Pennsylvania MORTGAGE FORECLOSURE PREVENTION SPECIALIST, ACTION-HOUSING, INC., PITTSBURGH, PENNSYLVANIA  
40173 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Dawn T. Williams Director of Housing Urban League of Greater Pittsburgh, Pittsburgh, Pennsylvania URBAN LEAGUE OF GREATER PITTSBURGH, PITTSBURGH, PENNSYLVANIA  
40181 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Deborah Jackson-Smith   Homeowner HOMEOWNER  
40184 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Eric Rhaney   Homeowner HOMEOWNER  
40177 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 George Gould Housing and Energy Unit Community Legal Services Managing Attorney MANAGING ATTORNEY Philadelphia, PA
40174 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Hiram Carmona Assistant Contract Administrator Housing Counseling      
40185 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Hon. Annette M. Rizzo   Judge, First Judicial District of Pennsylvania Court of Common Pleas of Philadelphia County JUDGE, FIRST JUDICIAL DISTRICT OF PENNSYLVANIA COURT OF COMMON PLEAS OF PHILADELPHIA COUNTY  
40175 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Hon. Bob Casey Jr. a U.S. Senator from the State of Pennsylvania A U.S. SENATOR FROM THE STATE OF PENNSYLVANIA  
40167 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Hon. Robert P. Casey Jr. a U.S. Senator from the State of Pennsylvania A U.S. SENATOR FROM THE STATE OF PENNSYLVANIA  
40176 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 John Dodds Director Philadelphia Unemployment Project PHILADELPHIA UNEMPLOYMENT PROJECT  
40169 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Joseph M. James President Judge Court of Common Pleas of Allegheny County, Pittsburgh, Pennsylvania COURT OF COMMON PLEAS OF ALLEGHENY COUNTY, PITTSBURGH, PENNSYLVANIA  
40170 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Michael T. McKeever   Partner, Goldbeck, McCafferty and McKeever, PC, Philadelphia, Pennsylvania PARTNER, GOLDBECK, MCCAFFERTY AND MCKEEVER, PC, PHILADELPHIA, PENNSYLVANIA  
40187 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Michael White   Pennsylvania Bankers Association city of Philadelphia PENNSYLVANIA BANKERS ASSOCIATION CITY OF PHILADELPHIA  
40171 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Sheriff William P. Mullen   Allegheny County, Pittsburgh, Pennsylvania ALLEGHENY COUNTY, PITTSBURGH, PENNSYLVANIA  
40186 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Stefhanie Seldin   Managing Attorney, Philadelphia Law Works/ Philadelphia VIP MANAGING ATTORNEY, PHILADELPHIA LAW WORKS/ PHILADELPHIA VIP  
40178 KEEPING FAMILIES IN THEIR HOMES: HOW TO PREVENT FORECLOSURES CHRG-110shrg48815 Tania Harrigan   Homeowner HOMEOWNER  

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;