hearing_witnesses
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where package_id = "CHRG-116hhrg42740" sorted by name
This data as json, CSV (advanced)
| id | package_id | name ▼ | title | organization | organization_normalized | location |
|---|---|---|---|---|---|---|
| 92309 | VOTING SAFELY IN A PANDEMIC CHRG-116hhrg42740 | Hon. Alex Padilla | Secretary of State | State of California | STATE OF CALIFORNIA | |
| 92313 | VOTING SAFELY IN A PANDEMIC CHRG-116hhrg42740 | Hon. Donald L. Palmer | Commissioner | U.S. Election Assistance Commission | U.S. ELECTION ASSISTANCE COMMISSION | |
| 92311 | VOTING SAFELY IN A PANDEMIC CHRG-116hhrg42740 | Ms. Amber McReynolds | Chief Executive Officer | National Vote at Home Institute | NATIONAL VOTE AT HOME INSTITUTE | |
| 92310 | VOTING SAFELY IN A PANDEMIC CHRG-116hhrg42740 | Ms. Julie Wise | King County Director of Elections | State of Washington | STATE OF WASHINGTON | |
| 92312 | VOTING SAFELY IN A PANDEMIC CHRG-116hhrg42740 | Ms. Vanita Gupta | President and Chief Executive Officer | The Leadership Conference on Civil and Human Rights | THE LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS |
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;