hearing_witnesses
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
13 rows where package_id = "CHRG-118hhrg56360" sorted by name
This data as json, CSV (advanced)
Suggested facets: title, location
organization 13
- Co-Chair, St. Mary Rehabilitation Working Group, Malta, Montana, prepared statement of 1
- Crow Tribe of Indians, Crow Agency, Montana 1
- David, Bureau of Reclamation, Department of the Interior 1
- Department of the Interior 1
- Fort Belknap Indian Community, Harlem, Montana 1
- Governor, Ohkay Owingeh Pueblo, Ohkay Owingeh, New Mexico 1
- Governor, Pueblo of Acoma, Acoma, New Mexico 1
- Governor, Pueblo of Taos, Taos, New Mexico, prepared statement of 1
- Governor, Pueblo of Zuni, Zuni, New Mexico 1
- Hopi Tribe, Kykotsmovi, Arizona 1
- Navajo Nation, Window Rock, Arizona 1
- Tule River Indian Tribe of California, Porterville, California 1
- Yavapai-Apache Nation, Upper Verde Valley, Arizona 1
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;