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

38 rows where package_id = "CHRG-105hhrg58852" 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
2023 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 American Chamber of Commerce in Vietnam-Hanoi Chapter   Thomas O'Dore THOMAS O'DORE  
2024 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 American Legion   John F. Sommer, Jr JOHN F. SOMMER, JR  
2034 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Ann Mills Griffiths   National League of POW/MIA Families NATIONAL LEAGUE OF POW/MIA FAMILIES  
2025 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Asia Pacific Council of American Chambers   Greig Craft GREIG CRAFT  
2026 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Boat People S.O.S.   Nguyen Dinh Thang NGUYEN DINH THANG  
2038 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Bradley Lalonde   Vietnam Citibank VIETNAM CITIBANK  
2035 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Bruce Harder   Veterans of Foreign Wars of the United States, presenting statement of John E. Moon VETERANS OF FOREIGN WARS OF THE UNITED STATES, PRESENTING STATEMENT OF JOHN E. MOON  
2028 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 CIGNA International   Thomas O'Dore THOMAS O'DORE  
2029 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Coalition Against Jackson-Vanik Waiver   Diem Hoang Do DIEM HOANG DO  
2031 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Diem Hoang Do   Coalition Against Jackson-Vanik Waiver COALITION AGAINST JACKSON-VANIK WAIVER  
2039 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Filong Levan   Vietnamese-American Voters' Coalition VIETNAMESE-AMERICAN VOTERS' COALITION  
2032 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 George C. Duggins   Vietnam Veterans of America VIETNAM VETERANS OF AMERICA  
2030 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Greig Craft   Asia Pacific Council of American Chambers ASIA PACIFIC COUNCIL OF AMERICAN CHAMBERS  
2052 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Hon. Christopher H. Smith   a Representative in Congress from the State of New Jersey A REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEW JERSEY  
2051 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Hon. Dana Rohrabacher   a Representative in Congress from the State of California A REPRESENTATIVE IN CONGRESS FROM THE STATE OF CALIFORNIA  
2037 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Hon. John F. Kerry   a U.S. Senator from the State of Massachusetts A U.S. SENATOR FROM THE STATE OF MASSACHUSETTS  
2027 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 J. Thomas Burch Jr. National Vietnam & Gulf War Veterans Coalition NATIONAL VIETNAM & GULF WAR VETERANS COALITION  
2036 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Joel D. Joseph   Made in the USA Foundation MADE IN THE USA FOUNDATION  
2043 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 John E. Moon   Veterans of Foreign Wars of the United States, as presented by Bruce Harder VETERANS OF FOREIGN WARS OF THE UNITED STATES, AS PRESENTED BY BRUCE HARDER  
2053 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 John F. Sommer Jr. American Legion AMERICAN LEGION  
2050 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Lynn M. O'Shea National Alliance of Families for the Return of America's Missing Servicemen Bellevue, Washington BELLEVUE, WASHINGTON  
2040 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Made in the USA Foundation   Joel D. Joseph JOEL D. JOSEPH  
2041 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Montagnard Dega Association   Inc., Y Hin Nie INC., Y HIN NIE  
2042 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Montagnard Human Rights Committee   Rong Nay RONG NAY  
2044 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 National Alliance of Families for the Return of America's Missing Servicemen   Lynn M. O'Shea LYNN M. O'SHEA  
2045 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 National League of POW/MIA Families   Ann Mills Griffiths ANN MILLS GRIFFITHS  
2046 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 National Vietnam & Gulf War Veterans Coalition   J. Thomas Burch, Jr J. THOMAS BURCH, JR  
2054 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Nguyen Dinh Thang   Boat People S.O.S BOAT PEOPLE S.O.S  
2047 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Rong Nay   Montagnard Human Rights Committee MONTAGNARD HUMAN RIGHTS COMMITTEE  
2049 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Thomas O'Dore   American Chamber of Commerce in Vietnam-Hanoi Chapter and CIGNA International AMERICAN CHAMBER OF COMMERCE IN VIETNAM-HANOI CHAPTER AND CIGNA INTERNATIONAL  
2022 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 U.S. Department of State Deputy Assistant Secretary of State Hon. Douglas ``Pete'' Peterson, U.S. Ambassador to Vietnam; accompanied by Chuck Kartman HON. DOUGLAS ``PETE'' PETERSON, U.S. AMBASSADOR TO VIETNAM; ACCOMPANIED BY CHUCK KARTMAN  
2055 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 U.S.-Vietnam Trade Council   Virginia B. Foote VIRGINIA B. FOOTE  
2056 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Veterans of Foreign Wars of the United States   John E. Moon, as presented by Bruce Harder JOHN E. MOON, AS PRESENTED BY BRUCE HARDER  
2057 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Vietnam Citibank   Bradley Lalonde BRADLEY LALONDE  
2059 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Vietnam Veterans of America   George C. Duggins GEORGE C. DUGGINS  
2058 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Vietnamese-American Voters' Coalition   Filong Levan FILONG LEVAN  
2033 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Virginia B. Foote   U.S.-Vietnam Trade Council U.S.-VIETNAM TRADE COUNCIL  
2048 U.S.-VIETNAM TRADE RELATIONS CHRG-105hhrg58852 Y Hin Nie   Montagnard Dega Association, Inc MONTAGNARD DEGA ASSOCIATION, INC  

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;