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

17 rows where package_id = "CHRG-110hhrg42334" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, title, organization_normalized

id package_id name ▼ title organization organization_normalized location
34220 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 '' from the San Rafael Raid   CA, Independent Journal, April 26, 2007 CA, INDEPENDENT JOURNAL, APRIL 26, 2007  
34219 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 '' from the San Rafael Raids   CA, Independent Journal, April 5, 2007 CA, INDEPENDENT JOURNAL, APRIL 5, 2007  
34209 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 Additional submissions: ``ICE Raids on Homes Panic Schools   Politicians, '' from the San Francisco Chronicle, Wednesday, May 7, 2008 POLITICIANS, '' FROM THE SAN FRANCISCO CHRONICLE, WEDNESDAY, MAY 7, 2008  
34222 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 America's Children   '' published by the Urban Institute '' PUBLISHED BY THE URBAN INSTITUTE  
34217 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 CA Marin   Independent Journal, March 14, 2007 INDEPENDENT JOURNAL, MARCH 14, 2007  
34214 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 CA Rafael   Independent Journal, March 9, 2007 INDEPENDENT JOURNAL, MARCH 9, 2007  
34215 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 CA Rafael   Independent Journal, March 9, 2007 INDEPENDENT JOURNAL, MARCH 9, 2007  
34218 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 Congresswoman Says   '' from the San Rafael, CA, Independent Journal, March 15, 2007 '' FROM THE SAN RAFAEL, CA, INDEPENDENT JOURNAL, MARCH 15, 2007  
34224 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 Hon. James C. Spero Deputy Assistant Director Office of Investigations, U.S. Immigration and Customs Enforcement, Department of Homeland Security OFFICE OF INVESTIGATIONS, U.S. IMMIGRATION AND CUSTOMS ENFORCEMENT, DEPARTMENT OF HOMELAND SECURITY  
34213 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 Independent Journal CA   March 8, 2007 MARCH 8, 2007  
34221 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 Janet Murguia president and CEO National Council of La Raza NATIONAL COUNCIL OF LA RAZA  
34208 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 Kathryn M. Gibney   San Pedro Elementary School principal SAN PEDRO ELEMENTARY SCHOOL PRINCIPAL  
34210 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 Neighborhood Raid   '' from the San Rafael, CA, Independent Journal, March 7, 2007 '' FROM THE SAN RAFAEL, CA, INDEPENDENT JOURNAL, MARCH 7, 2007  
34212 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 San Rafael   '' from the Marin, CA, Independent Journal, March 8, 2007 '' FROM THE MARIN, CA, INDEPENDENT JOURNAL, MARCH 8, 2007  
34223 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 Simon Romo chief counsel, New Mexico Child Protective Services      
34211 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 from the San Rafael   CA, Independent Journal, March 8, 2007 CA, INDEPENDENT JOURNAL, MARCH 8, 2007  
34216 ICE WORKPLACE RAIDS: THEIR IMPACT ON U.S. CHILDREN, FAMILIES AND COMMUNITIES CHRG-110hhrg42334 the San Rafael   CA, Independent Journal, March 13, 2007 CA, INDEPENDENT JOURNAL, MARCH 13, 2007  

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;