hearing_witnesses
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
4 rows where package_id = "CHRG-115shrg32635" sorted by name
This data as json, CSV (advanced)
| id | package_id | name ▼ | title | organization | organization_normalized | location |
|---|---|---|---|---|---|---|
| 87441 | OUTSIDE PERSPECTIVES ON RUSSIA SANCTIONS: CURRENT EFFECTIVENESS AND POTENTIAL FOR NEXT STEPS CHRG-115shrg32635 | Daniel Fried | Former Coordinator for Sanctions Policy, and former Assistant Secretary of State for European and Asian Affairs (2005-09) | Department of State (2013-17) | DEPARTMENT OF STATE (2013-17) | |
| 87443 | OUTSIDE PERSPECTIVES ON RUSSIA SANCTIONS: CURRENT EFFECTIVENESS AND POTENTIAL FOR NEXT STEPS CHRG-115shrg32635 | Heather A. Conley | Senior Vice President for Europe, and former Deputy Assistant Secretary of State for Eurasian Affairs (2001-05) | Eurasia, and the Arctic, Center for Strategic and International Studies | EURASIA, AND THE ARCTIC, CENTER FOR STRATEGIC AND INTERNATIONAL STUDIES | |
| 87440 | OUTSIDE PERSPECTIVES ON RUSSIA SANCTIONS: CURRENT EFFECTIVENESS AND POTENTIAL FOR NEXT STEPS CHRG-115shrg32635 | Michael A. McFaul | the Peter and Helen Bing Senior Fellow at the Hoover Institution, and Professor of Political Science, Director and Senior Fellow at the Freeman Spogli Institute for International Studies at Stanford University, and Former U.S. Ambassador to the Russian Federation (2012-14) | |||
| 87442 | OUTSIDE PERSPECTIVES ON RUSSIA SANCTIONS: CURRENT EFFECTIVENESS AND POTENTIAL FOR NEXT STEPS CHRG-115shrg32635 | Rachel Ziemba | Adjunct Senior Fellow | Energy, Economics, and Security Program, Center for a New American Security | ENERGY, ECONOMICS, AND SECURITY PROGRAM, CENTER FOR A NEW AMERICAN SECURITY |
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;