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

6 rows where package_id = "CHRG-105hhrg51943" 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
1506 COMPACTS OF FREE ASSOCIATION WITH THE MARSHALL ISLANDS, FEDERATED STATES OF MICRONESIA, AND PALAU CHRG-105hhrg51943 Allen P. Stayman Director Office of Insular Affairs, U.S. Department of the Interior OFFICE OF INSULAR AFFAIRS, U.S. DEPARTMENT OF THE INTERIOR  
1503 COMPACTS OF FREE ASSOCIATION WITH THE MARSHALL ISLANDS, FEDERATED STATES OF MICRONESIA, AND PALAU CHRG-105hhrg51943 Hersey Kyota   Palau Ambassador to the United States PALAU AMBASSADOR TO THE UNITED STATES  
1507 COMPACTS OF FREE ASSOCIATION WITH THE MARSHALL ISLANDS, FEDERATED STATES OF MICRONESIA, AND PALAU CHRG-105hhrg51943 Hon. Asterio R. Takesy Executive Director Joint Committee on Compact Economic Negotiations, Federated States of Micronesia, accompanied by Jesse Marehalau, Federated States of Micronesia, Ambassador to the United States JOINT COMMITTEE ON COMPACT ECONOMIC NEGOTIATIONS, FEDERATED STATES OF MICRONESIA, ACCOMPANIED BY JESSE MAREHALAU, FEDERATED STATES OF MICRONESIA, AMBASSADOR TO THE UNITED STATES  
1502 COMPACTS OF FREE ASSOCIATION WITH THE MARSHALL ISLANDS, FEDERATED STATES OF MICRONESIA, AND PALAU CHRG-105hhrg51943 Kurt M. Campbell Deputy Assistant Secretary of Defense for Asian and Pacific Affairs      
1504 COMPACTS OF FREE ASSOCIATION WITH THE MARSHALL ISLANDS, FEDERATED STATES OF MICRONESIA, AND PALAU CHRG-105hhrg51943 Phillip Muller   Minister of Foreign Affairs and Trade, Republic of the Marshall Islands; Tony DeBrum, Republic of the Marshall Islands, Ambassador to the United States MINISTER OF FOREIGN AFFAIRS AND TRADE, REPUBLIC OF THE MARSHALL ISLANDS; TONY DEBRUM, REPUBLIC OF THE MARSHALL ISLANDS, AMBASSADOR TO THE UNITED STATES  
1505 COMPACTS OF FREE ASSOCIATION WITH THE MARSHALL ISLANDS, FEDERATED STATES OF MICRONESIA, AND PALAU CHRG-105hhrg51943 Stanley Roth Assistant Secretary for East Asian and Pacific Affairs U.S. Department of State U.S. DEPARTMENT OF STATE  

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;