home / openregs

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-116hhrg43500" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title

organization 9

  • Office of Minority and Women Inclusion (OMWI), Board of Governors of the Federal Reserve System (Fed) 1
  • Office of Minority and Women Inclusion (OMWI), Consumer Financial Protection Bureau (CFPB) 1
  • Office of Minority and Women Inclusion (OMWI), Federal Deposit Insurance Corporation (FDIC) 1
  • Office of Minority and Women Inclusion (OMWI), Federal Housing Finance Agency (FHFA) 1
  • Office of Minority and Women Inclusion (OMWI), Federal Reserve Bank of New York (FRBNY) 1
  • Office of Minority and Women Inclusion (OMWI), National Credit Union Administration (NCUA) 1
  • Office of Minority and Women Inclusion (OMWI), Office of the Comptroller of the Currency (OCC) 1
  • Office of Minority and Women Inclusion (OMWI), U.S. Department of the Treasury (Treasury) 1
  • Office of Minority and Women Inclusion (OMWI), U.S. Securities and Exchange Commission (SEC) 1
id package_id name ▼ title organization organization_normalized location
92557 HOLDING FINANCIAL REGULATORS ACCOUNTABLE FOR DIVERSITY AND INCLUSION: PERSPECTIVES FROM THE OFFICES OF MINORITY AND WOMEN INCLUSION CHRG-116hhrg43500 Joyce Cofield Executive Director Office of Minority and Women Inclusion (OMWI), Office of the Comptroller of the Currency (OCC) OFFICE OF MINORITY AND WOMEN INCLUSION (OMWI), OFFICE OF THE COMPTROLLER OF THE CURRENCY (OCC)  
92560 HOLDING FINANCIAL REGULATORS ACCOUNTABLE FOR DIVERSITY AND INCLUSION: PERSPECTIVES FROM THE OFFICES OF MINORITY AND WOMEN INCLUSION CHRG-116hhrg43500 Lacey Dingman Director Office of Minority and Women Inclusion (OMWI), Federal Reserve Bank of New York (FRBNY) OFFICE OF MINORITY AND WOMEN INCLUSION (OMWI), FEDERAL RESERVE BANK OF NEW YORK (FRBNY)  
92563 HOLDING FINANCIAL REGULATORS ACCOUNTABLE FOR DIVERSITY AND INCLUSION: PERSPECTIVES FROM THE OFFICES OF MINORITY AND WOMEN INCLUSION CHRG-116hhrg43500 Lora McCray Director Office of Minority and Women Inclusion (OMWI), Consumer Financial Protection Bureau (CFPB) OFFICE OF MINORITY AND WOMEN INCLUSION (OMWI), CONSUMER FINANCIAL PROTECTION BUREAU (CFPB)  
92558 HOLDING FINANCIAL REGULATORS ACCOUNTABLE FOR DIVERSITY AND INCLUSION: PERSPECTIVES FROM THE OFFICES OF MINORITY AND WOMEN INCLUSION CHRG-116hhrg43500 Lorraine Cole Director Office of Minority and Women Inclusion (OMWI), U.S. Department of the Treasury (Treasury) OFFICE OF MINORITY AND WOMEN INCLUSION (OMWI), U.S. DEPARTMENT OF THE TREASURY (TREASURY)  
92559 HOLDING FINANCIAL REGULATORS ACCOUNTABLE FOR DIVERSITY AND INCLUSION: PERSPECTIVES FROM THE OFFICES OF MINORITY AND WOMEN INCLUSION CHRG-116hhrg43500 Monica Davy Director Office of Minority and Women Inclusion (OMWI), National Credit Union Administration (NCUA) OFFICE OF MINORITY AND WOMEN INCLUSION (OMWI), NATIONAL CREDIT UNION ADMINISTRATION (NCUA)  
92564 HOLDING FINANCIAL REGULATORS ACCOUNTABLE FOR DIVERSITY AND INCLUSION: PERSPECTIVES FROM THE OFFICES OF MINORITY AND WOMEN INCLUSION CHRG-116hhrg43500 Nikita Pearson Acting Director Office of Minority and Women Inclusion (OMWI), Federal Deposit Insurance Corporation (FDIC) OFFICE OF MINORITY AND WOMEN INCLUSION (OMWI), FEDERAL DEPOSIT INSURANCE CORPORATION (FDIC)  
92561 HOLDING FINANCIAL REGULATORS ACCOUNTABLE FOR DIVERSITY AND INCLUSION: PERSPECTIVES FROM THE OFFICES OF MINORITY AND WOMEN INCLUSION CHRG-116hhrg43500 Pamela Gibbs Director Office of Minority and Women Inclusion (OMWI), U.S. Securities and Exchange Commission (SEC) OFFICE OF MINORITY AND WOMEN INCLUSION (OMWI), U.S. SECURITIES AND EXCHANGE COMMISSION (SEC)  
92562 HOLDING FINANCIAL REGULATORS ACCOUNTABLE FOR DIVERSITY AND INCLUSION: PERSPECTIVES FROM THE OFFICES OF MINORITY AND WOMEN INCLUSION CHRG-116hhrg43500 Sharron Levine Director Office of Minority and Women Inclusion (OMWI), Federal Housing Finance Agency (FHFA) OFFICE OF MINORITY AND WOMEN INCLUSION (OMWI), FEDERAL HOUSING FINANCE AGENCY (FHFA)  
92556 HOLDING FINANCIAL REGULATORS ACCOUNTABLE FOR DIVERSITY AND INCLUSION: PERSPECTIVES FROM THE OFFICES OF MINORITY AND WOMEN INCLUSION CHRG-116hhrg43500 Sheila Clark Director Office of Minority and Women Inclusion (OMWI), Board of Governors of the Federal Reserve System (Fed) OFFICE OF MINORITY AND WOMEN INCLUSION (OMWI), BOARD OF GOVERNORS OF THE FEDERAL RESERVE SYSTEM (FED)  

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;
Powered by Datasette · Queries took 226.21ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API