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

31 rows where package_id = "CHRG-105hhrg60940" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized

id package_id name ▼ title organization organization_normalized location
2281 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Acton Institute for the Study of Religion and Liberty   Father Robert A. Sirico FATHER ROBERT A. SIRICO  
2282 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 American Federation of Labor and Congress of Industrial Organizations   Barbara Shailor BARBARA SHAILOR  
2283 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Amway Corporation   Richard Holwill RICHARD HOLWILL  
2301 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Barbara Shailor   American Federation of Labor and Congress of Industrial Organizations AMERICAN FEDERATION OF LABOR AND CONGRESS OF INDUSTRIAL ORGANIZATIONS  
2291 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Christopher Hall   Cincinnati Milacron, and Society of the Plastics Industry, Inc CINCINNATI MILACRON, AND SOCIETY OF THE PLASTICS INDUSTRY, INC  
2285 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Cincinnati Milacron   Christopher Hall CHRISTOPHER HALL  
2294 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Clark A. Johnson   Pier 1 Imports, Inc., and National Retail Federation PIER 1 IMPORTS, INC., AND NATIONAL RETAIL FEDERATION  
2289 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Emergency Committee for American Trade   Ernest S. Micek ERNEST S. MICEK  
2296 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Ernest S. Micek   Cargill, Incorporated, and Emergency Committee for American Trade CARGILL, INCORPORATED, AND EMERGENCY COMMITTEE FOR AMERICAN TRADE  
2290 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Family Research Council   Martin J. Dannenfelser, Jr MARTIN J. DANNENFELSER, JR  
2302 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Father Robert A. Sirico Acton Institute for the Study of Religion and Liberty      
2288 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Hon. Calvin M. Dooley   a Representative in Congress from the State of California A REPRESENTATIVE IN CONGRESS FROM THE STATE OF CALIFORNIA  
2303 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Hon. Christopher H. Smith   a Representative in Congress from the State of New Jersey A REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEW JERSEY  
2309 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Hon. Curt Weldon   a Representative in Congress from the State of Pennsylvania A REPRESENTATIVE IN CONGRESS FROM THE STATE OF PENNSYLVANIA  
2306 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Hon. Fortney Pete Stark   a Representative in Congress from the State of California A REPRESENTATIVE IN CONGRESS FROM THE STATE OF CALIFORNIA  
2305 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Hon. Gerald B. Solomon   a Representative in Congress from the State of New York A REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEW YORK  
2299 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Hon. Nancy Pelosi   a Representative in Congress from the State of California A REPRESENTATIVE IN CONGRESS FROM THE STATE OF CALIFORNIA  
2284 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Incorporated Cargill   Ernest S. Micek ERNEST S. MICEK  
2293 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 International Republican Institute   Lorne W. Craner LORNE W. CRANER  
2286 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Lorne W. Craner   International Republican Institute INTERNATIONAL REPUBLICAN INSTITUTE  
2287 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Martin J. Dannenfelser Jr. Family Research Council FAMILY RESEARCH COUNCIL  
2297 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 National Retail Federation   Clark A. Johnson CLARK A. JOHNSON  
2279 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Office of the U.S. Trade Representative General Counsel Susan Esserman SUSAN ESSERMAN  
2300 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Pier 1 Imports   Inc., Clark A. Johnson INC., CLARK A. JOHNSON  
2292 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Richard Holwill   Amway Corporation, and U.S. Chamber of Commerce AMWAY CORPORATION, AND U.S. CHAMBER OF COMMERCE  
2295 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Robert A. Kapp   United States-China Business Council UNITED STATES-CHINA BUSINESS COUNCIL  
2304 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 Society of the Plastics Industry   Inc., Christopher Hall INC., CHRISTOPHER HALL  
2308 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 U.S. Chamber of Commerce   Richard Holwill RICHARD HOLWILL  
2280 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 U.S. Department of State Assistant Secretary Hon. Stanley O. Roth, East Asian and Pacific Affairs HON. STANLEY O. ROTH, EAST ASIAN AND PACIFIC AFFAIRS  
2307 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 United States-China Business Council   Robert A. Kapp ROBERT A. KAPP  
2298 U.S.-CHINA TRADE RELATIONS AND RENEWAL OF CHINA'S MOST-FAVORED-NATION STATUS CHRG-105hhrg60940 William R. O'Brien   Global Center, Samford University GLOBAL CENTER, SAMFORD UNIVERSITY  

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;