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

17 rows where package_id = "CHRG-107hhrg82504" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, title, organization_normalized, location

id package_id name ▼ title organization organization_normalized location
10752 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Adriana Grippa President Master Research & Manufacturing, Inc. MASTER RESEARCH & MANUFACTURING, INC. Norwalk, CA
10760 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Anita Huseth President Mace Metal Sales MACE METAL SALES Los Angeles, CA
10762 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Bart Alcamo President RBK Tool & Die Company, on behalf of The Society of The Plastics Industry, Inc RBK TOOL & DIE COMPANY, ON BEHALF OF THE SOCIETY OF THE PLASTICS INDUSTRY, INC  
10748 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Bruce Thompson Regional Administrator Region 9, SBA REGION 9, SBA  
10755 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Bruce Thompson Regional Administrator SBA SBA  
10753 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 David Bearden Deputy Assistant Secretary and Chief Operating Officer Economic Development Administration (EDA), U.S. Department of Commerce ECONOMIC DEVELOPMENT ADMINISTRATION (EDA), U.S. DEPARTMENT OF COMMERCE  
10754 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 David Holbert Executive Director Western Trade Adjustment Assistance Center (TAAC) WESTERN TRADE ADJUSTMENT ASSISTANCE CENTER (TAAC) Los Angeles, CA
10750 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Deborah Cabreira-Johnson Program Manager Los Angeles County Procurement Technical Assistance Center (PTAC) LOS ANGELES COUNTY PROCUREMENT TECHNICAL ASSISTANCE CENTER (PTAC)  
10751 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Eric Espinoza   Owner, Stitches Uniforms OWNER, STITCHES UNIFORMS Montebello, CA
10749 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Frank Ramos Director, Office of the Under Secretary of Defense Office of Small & Disadvantaged Business Utilization OFFICE OF SMALL & DISADVANTAGED BUSINESS UTILIZATION  
10759 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Hugh Loftus Director Community Adjustment and Investment Program, North American Development (NAD) Bank COMMUNITY ADJUSTMENT AND INVESTMENT PROGRAM, NORTH AMERICAN DEVELOPMENT (NAD) BANK City of Industry, CA
10761 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 John Reynolds General Manager Mace Metal Sales MACE METAL SALES Los Angeles, CA
10756 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Mary Delmege Senior Advisor, Trade Promotion Coordinating Committee (TPCC)     San Diego, CA
10758 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Raul Hinojosa Research Director North American Integration & Development Center, School of Public Policy & Social Research, University of California Los Angeles (UCLA) NORTH AMERICAN INTEGRATION & DEVELOPMENT CENTER, SCHOOL OF PUBLIC POLICY & SOCIAL RESEARCH, UNIVERSITY OF CALIFORNIA LOS ANGELES (UCLA) Los Angeles, CA
10763 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Terry Bonds Director District 12, United Steel Workers of America (USWA) DISTRICT 12, UNITED STEEL WORKERS OF AMERICA (USWA) Albuquerque, NM
10764 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 Tom Martin   Chair, Government Affairs, Small Manufacturers Association (SMA) CHAIR, GOVERNMENT AFFAIRS, SMALL MANUFACTURERS ASSOCIATION (SMA) Pomona, CA
10757 FEDERAL PROCUREMENT AND INTERNATIONAL TRADE: ASSESSING THE FEDERAL GOVERNMENT'S EFFORTS TO MEET THE NEEDS OF LOCAL SMALL BUSINESSES CHRG-107hhrg82504 William Redway Group Vice President Small and New Business Group, Export-Import Bank of the United States (Ex-Im) SMALL AND NEW BUSINESS GROUP, EXPORT-IMPORT BANK OF THE UNITED STATES (EX-IM) Washington, DC

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;