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

10 rows where package_id = "CHRG-106shrg70527" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
7163 USDA CIVIL RIGHTS CHRG-106shrg70527 Alexander Pires Esq. Conlon, Frantz, Phelan and Pires CONLON, FRANTZ, PHELAN AND PIRES Washington, DC
7155 USDA CIVIL RIGHTS CHRG-106shrg70527 Bob Robertson Associate Director, Assistant Director General Accounting Office, Washington, DC, accompanied by Jerilynn B. Hoy, Resources, Community, and Economic Development Division, General Accounting Office GENERAL ACCOUNTING OFFICE, WASHINGTON, DC, ACCOMPANIED BY JERILYNN B. HOY, RESOURCES, COMMUNITY, AND ECONOMIC DEVELOPMENT DIVISION, GENERAL ACCOUNTING OFFICE  
7158 USDA CIVIL RIGHTS CHRG-106shrg70527 Charles R. Rawls General Counsel USDA USDA Washington, DC
7161 USDA CIVIL RIGHTS CHRG-106shrg70527 Harold Connor Esq Upper Marlboro, Maryland, accompanied by Joseph D. Gebhardt UPPER MARLBORO, MARYLAND, ACCOMPANIED BY JOSEPH D. GEBHARDT  
7159 USDA CIVIL RIGHTS CHRG-106shrg70527 John Boyd President National Black Farmers Association, Baskerville, Virginia NATIONAL BLACK FARMERS ASSOCIATION, BASKERVILLE, VIRGINIA  
7164 USDA CIVIL RIGHTS CHRG-106shrg70527 John Zippert Director of Operations, Federation of Southern Cooperatives, and Chairman of the Board the Rural Coalition, Epes, Alabama THE RURAL COALITION, EPES, ALABAMA  
7160 USDA CIVIL RIGHTS CHRG-106shrg70527 Juanita Carranza   Lambert, Montana LAMBERT, MONTANA  
7162 USDA CIVIL RIGHTS CHRG-106shrg70527 Lawrence Lucas   USDA Coalition of Minority Employees USDA COALITION OF MINORITY EMPLOYEES Washington, DC
7157 USDA CIVIL RIGHTS CHRG-106shrg70527 Paul Fiddick USDA Assistant Secretary for Administration, Director, Chief Operating Officer Washington, DC, accompanied by Rosalind Gray, Office of Civil Rights, and David Winningham, Office of Civil Rights WASHINGTON, DC, ACCOMPANIED BY ROSALIND GRAY, OFFICE OF CIVIL RIGHTS, AND DAVID WINNINGHAM, OFFICE OF CIVIL RIGHTS  
7156 USDA CIVIL RIGHTS CHRG-106shrg70527 Richard Viadero Inspector General, Assistant Inspector General USDA, Washington, DC, accompanied by James R. Ebbitt, USDA USDA, WASHINGTON, DC, ACCOMPANIED BY JAMES R. EBBITT, USDA  

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;