hearing_witnesses
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
4 rows where package_id = "CHRG-106hhrg68483" sorted by name
This data as json, CSV (advanced)
| id | package_id | name ▼ | title | organization | organization_normalized | location |
|---|---|---|---|---|---|---|
| 5773 | THE INTERNATIONAL CRIMINAL COURT CHRG-106hhrg68483 | Page Part 1: A Threat to American Military Personnel? The Honorable John R. Bolton | Senior Vice President | Esquire, American Enterprise Institute | ESQUIRE, AMERICAN ENTERPRISE INSTITUTE | |
| 5775 | THE INTERNATIONAL CRIMINAL COURT CHRG-106hhrg68483 | Part 2: Recent Developments The Honorable David J. Scheffer | Ambassador-at-Large for War Crimes Issues, U.S. Department of State | AMBASSADOR-AT-LARGE FOR WAR CRIMES ISSUES, U.S. DEPARTMENT OF STATE | ||
| 5774 | THE INTERNATIONAL CRIMINAL COURT CHRG-106hhrg68483 | The Honorable Lawrence S. Eagleburger | Senior Foreign Policy Advisor | Baker, Donelson, Bearman, and Caldwell | BAKER, DONELSON, BEARMAN, AND CALDWELL | |
| 5776 | THE INTERNATIONAL CRIMINAL COURT CHRG-106hhrg68483 | The Honorable Walter Slocombe | Under Secretary of Defense for Policy | U.S. Department of Defense | U.S. DEPARTMENT OF DEFENSE |
Advanced export
JSON shape: default, array, newline-delimited, object
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;