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-109hhrg29627" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title

id package_id name ▼ title organization organization_normalized location
24328 EXAMINING THE RETIREMENT SECURITY OF STATE AND LOCAL GOVERNMENT EMPLOYEES CHRG-109hhrg29627 '' and accompanying letters 0593        
24327 EXAMINING THE RETIREMENT SECURITY OF STATE AND LOCAL GOVERNMENT EMPLOYEES CHRG-109hhrg29627 Article from Governing.com   Management Insights column, ``Paying for Tomorrow'' MANAGEMENT INSIGHTS COLUMN, ``PAYING FOR TOMORROW''  
24330 EXAMINING THE RETIREMENT SECURITY OF STATE AND LOCAL GOVERNMENT EMPLOYEES CHRG-109hhrg29627 Irene Jinks president Illinois Retired Teachers Association ILLINOIS RETIRED TEACHERS ASSOCIATION  
24329 EXAMINING THE RETIREMENT SECURITY OF STATE AND LOCAL GOVERNMENT EMPLOYEES CHRG-109hhrg29627 J. Fred Giertz professor Institute of Government and Public Affairs, University of Illinois INSTITUTE OF GOVERNMENT AND PUBLIC AFFAIRS, UNIVERSITY OF ILLINOIS  
24331 EXAMINING THE RETIREMENT SECURITY OF STATE AND LOCAL GOVERNMENT EMPLOYEES CHRG-109hhrg29627 Joanna Webb-Gauvin director of retiree programs Council 31, American Federation of State, County and Municipal Employees (AFSCME) COUNCIL 31, AMERICAN FEDERATION OF STATE, COUNTY AND MUNICIPAL EMPLOYEES (AFSCME)  
24326 EXAMINING THE RETIREMENT SECURITY OF STATE AND LOCAL GOVERNMENT EMPLOYEES CHRG-109hhrg29627 John Filan director Governor's Office of Management and Budget, State of Illinois GOVERNOR'S OFFICE OF MANAGEMENT AND BUDGET, STATE OF ILLINOIS  
24325 EXAMINING THE RETIREMENT SECURITY OF STATE AND LOCAL GOVERNMENT EMPLOYEES CHRG-109hhrg29627 Keith Brainard research director, National Association of State Retirement Administrators (NASRA)      
24332 EXAMINING THE RETIREMENT SECURITY OF STATE AND LOCAL GOVERNMENT EMPLOYEES CHRG-109hhrg29627 Lance Weiss   consulting actuary, Deloitte Consulting, LLP CONSULTING ACTUARY, DELOITTE CONSULTING, LLP  

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;