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

12 rows where package_id = "CHRG-108hhrg92983" 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
17554 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 A.W. III Pickel President National Association of Mortgage Brokers NATIONAL ASSOCIATION OF MORTGAGE BROKERS  
17550 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Allen J. Fishbein Director of Housing and Credit Policy Consumer Federation of America CONSUMER FEDERATION OF AMERICA  
17548 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Cameron ``Cam'' L. Esq. Cowan   Chair, Legislative and Judicial Subcommittee, American Securitization Forum CHAIR, LEGISLATIVE AND JUDICIAL SUBCOMMITTEE, AMERICAN SECURITIZATION FORUM  
17555 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Frank L. Raiter Managing Director, Standard & Poor's Credit Market Services      
17546 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 George Brown Senior Vice President Self Help, on behalf of North Carolina Coalition for Responsible Lending SELF HELP, ON BEHALF OF NORTH CAROLINA COALITION FOR RESPONSIBLE LENDING  
17552 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Hon. Thomas J. Miller   Attorney General, State of Iowa ATTORNEY GENERAL, STATE OF IOWA  
17549 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Kurt Eggert Associate Professor of Law Chapman University School of Law CHAPMAN UNIVERSITY SCHOOL OF LAW  
17556 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Margot Saunders   Managing Attorney, National Consumer Law Center MANAGING ATTORNEY, NATIONAL CONSUMER LAW CENTER  
17551 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Micah S. Green President The Bond Market Association THE BOND MARKET ASSOCIATION  
17557 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Reverend William Somplatsky-Jarman   Presbyterian USA, on behalf of the Interfaith Center on Corporate Responsibility PRESBYTERIAN USA, ON BEHALF OF THE INTERFAITH CENTER ON CORPORATE RESPONSIBILITY  
17547 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Robert C. Couch President and CEO New South Federal Savings Bank, Chairman Mortgage Bankers Association MORTGAGE BANKERS ASSOCIATION  
17553 PROTECTING HOMEOWNERS: PREVENTING ABUSIVE LENDING WHILE PRESERVING ACCESS TO CREDIT CHRG-108hhrg92983 Steve Nadon Chief Operating Officer and Executive Vice President, Chairman Option One, Coalition for Fair and Affordable Lending OPTION ONE, COALITION FOR FAIR AND AFFORDABLE LENDING  

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;