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

13 rows where package_id = "CHRG-110hhrg49881" 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
37009 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 Alan Viard Ph.D. Resident Scholar, American Enterprise Institute RESIDENT SCHOLAR, AMERICAN ENTERPRISE INSTITUTE  
37006 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 Christine Owens Executive Director National Employment Law Project NATIONAL EMPLOYMENT LAW PROJECT  
37001 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 David Mongan President American Society of Civil Engineers AMERICAN SOCIETY OF CIVIL ENGINEERS  
37002 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 Dennis Van Roekel President National Education Association NATIONAL EDUCATION ASSOCIATION  
37004 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 Jared Bernstein Ph.D., Director Living Standards Program, Economic Policy Institute LIVING STANDARDS PROGRAM, ECONOMIC POLICY INSTITUTE  
37007 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 Jeanne Lambrew Ph.D., Associate Professor, Senior Fellow LBJ School of Public Affairs, University of Texas at Austin, Center for American Progress, Action Fund, Austin, Texas LBJ SCHOOL OF PUBLIC AFFAIRS, UNIVERSITY OF TEXAS AT AUSTIN, CENTER FOR AMERICAN PROGRESS, ACTION FUND, AUSTIN, TEXAS  
37008 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 Martella A. Turner-Joseph Vice President Joseph & Turner Consulting Actuaries, LLC, New York, New York JOSEPH & TURNER CONSULTING ACTUARIES, LLC, NEW YORK, NEW YORK  
37003 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 Randi Weingarten President American Federation of Teachers AMERICAN FEDERATION OF TEACHERS  
37005 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 Robert Greenstein Executive Director Center on Budget and Policy Priorities CENTER ON BUDGET AND POLICY PRIORITIES  
36997 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 The Honorable David Paterson   Governor, State of New York GOVERNOR, STATE OF NEW YORK  
36999 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 The Honorable Douglas Palmer   Mayor, City of Trenton, New Jersey MAYOR, CITY OF TRENTON, NEW JERSEY  
36998 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 The Honorable Mark Sanford   Governor, State of South Carolina GOVERNOR, STATE OF SOUTH CAROLINA  
37000 ECONOMIC RECOVERY AND JOB CREATION THROUGH INVESTMENT IN AMERICA CHRG-110hhrg49881 Timothy Firestine Chief Operating Officer, Montgomery County Executive Rockville, Maryland ROCKVILLE, MARYLAND  

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;