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

9 rows where package_id = "CHRG-111hhrg62689" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
48203 THE FUTURE OF HOUSING FINANCE--A REVIEW OF PROPOSALS TO ADDRESS MARKET STRUCTURE AND TRANSITION CHRG-111hhrg62689 Christopher Papagianis Managing Director & Policy Director Economics21 ECONOMICS21  
48204 THE FUTURE OF HOUSING FINANCE--A REVIEW OF PROPOSALS TO ADDRESS MARKET STRUCTURE AND TRANSITION CHRG-111hhrg62689 Edward J. Pinto Real Estate Financial Services Consultant      
48198 THE FUTURE OF HOUSING FINANCE--A REVIEW OF PROPOSALS TO ADDRESS MARKET STRUCTURE AND TRANSITION CHRG-111hhrg62689 Hon. Kenneth E. Bentsen Jr., Executive Vice President Public Policy and Advocacy, Securities Industry and Financial Markets Association (SIFMA) PUBLIC POLICY AND ADVOCACY, SECURITIES INDUSTRY AND FINANCIAL MARKETS ASSOCIATION (SIFMA)  
48205 THE FUTURE OF HOUSING FINANCE--A REVIEW OF PROPOSALS TO ADDRESS MARKET STRUCTURE AND TRANSITION CHRG-111hhrg62689 Hon. Phillip L. Swagel   McDonough School of Business, Georgetown University MCDONOUGH SCHOOL OF BUSINESS, GEORGETOWN UNIVERSITY  
48206 THE FUTURE OF HOUSING FINANCE--A REVIEW OF PROPOSALS TO ADDRESS MARKET STRUCTURE AND TRANSITION CHRG-111hhrg62689 Hon. Susan M. Wachter Richard B. Worley Professor of Financial Management The Wharton School, University of Pennsylvania THE WHARTON SCHOOL, UNIVERSITY OF PENNSYLVANIA  
48201 THE FUTURE OF HOUSING FINANCE--A REVIEW OF PROPOSALS TO ADDRESS MARKET STRUCTURE AND TRANSITION CHRG-111hhrg62689 Michael A.J. Farrell Chairman, CEO, and President Annaly Capital Management, Inc., on behalf of Annaly Capital Management and the National Association of Real Estate Investment Trusts' Mortgage REIT Council ANNALY CAPITAL MANAGEMENT, INC., ON BEHALF OF ANNALY CAPITAL MANAGEMENT AND THE NATIONAL ASSOCIATION OF REAL ESTATE INVESTMENT TRUSTS' MORTGAGE REIT COUNCIL  
48199 THE FUTURE OF HOUSING FINANCE--A REVIEW OF PROPOSALS TO ADDRESS MARKET STRUCTURE AND TRANSITION CHRG-111hhrg62689 Michael Bodaken President National Housing Trust NATIONAL HOUSING TRUST  
48202 THE FUTURE OF HOUSING FINANCE--A REVIEW OF PROPOSALS TO ADDRESS MARKET STRUCTURE AND TRANSITION CHRG-111hhrg62689 Michael J. Heid Co-President, and Chairman, the Financial Services Roundtable Wells Fargo Home Mortgage, Housing Policy Council WELLS FARGO HOME MORTGAGE, HOUSING POLICY COUNCIL  
48200 THE FUTURE OF HOUSING FINANCE--A REVIEW OF PROPOSALS TO ADDRESS MARKET STRUCTURE AND TRANSITION CHRG-111hhrg62689 Tom Deutsch Executive Director American Securitization Forum AMERICAN SECURITIZATION FORUM  

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;