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

8 rows where package_id = "CHRG-113hhrg91742" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title

id package_id name ▼ title organization organization_normalized location
69055 IMPACT ON LOCAL COMMUNITIES OF THE RELEASE OF UNACCOMPANIED ALIEN MINORS AND THE NEED FOR CONSULTATION AND NOTIFICATION CHRG-113hhrg91742 Jessica M. Vaughan Director of Policy Studies Center for Immigration Studies CENTER FOR IMMIGRATION STUDIES  
69057 IMPACT ON LOCAL COMMUNITIES OF THE RELEASE OF UNACCOMPANIED ALIEN MINORS AND THE NEED FOR CONSULTATION AND NOTIFICATION CHRG-113hhrg91742 Kristyn Peck Associate Director of Children's Services U.S. Conference of Catholic Bishops U.S. CONFERENCE OF CATHOLIC BISHOPS  
69054 IMPACT ON LOCAL COMMUNITIES OF THE RELEASE OF UNACCOMPANIED ALIEN MINORS AND THE NEED FOR CONSULTATION AND NOTIFICATION CHRG-113hhrg91742 Leonard Scarcella   Mayor of Stafford, Texas MAYOR OF STAFFORD, TEXAS  
69051 IMPACT ON LOCAL COMMUNITIES OF THE RELEASE OF UNACCOMPANIED ALIEN MINORS AND THE NEED FOR CONSULTATION AND NOTIFICATION CHRG-113hhrg91742 The Honorable Adrian Smith   a Representative in Congress from the State of Nebraska A REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEBRASKA  
69053 IMPACT ON LOCAL COMMUNITIES OF THE RELEASE OF UNACCOMPANIED ALIEN MINORS AND THE NEED FOR CONSULTATION AND NOTIFICATION CHRG-113hhrg91742 The Honorable Joseph Crowley   a Representative in Congress from the State of New York A REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEW YORK  
69050 IMPACT ON LOCAL COMMUNITIES OF THE RELEASE OF UNACCOMPANIED ALIEN MINORS AND THE NEED FOR CONSULTATION AND NOTIFICATION CHRG-113hhrg91742 The Honorable Lou Barletta   a Representative in Congress from the State of Pennsylvania A REPRESENTATIVE IN CONGRESS FROM THE STATE OF PENNSYLVANIA  
69052 IMPACT ON LOCAL COMMUNITIES OF THE RELEASE OF UNACCOMPANIED ALIEN MINORS AND THE NEED FOR CONSULTATION AND NOTIFICATION CHRG-113hhrg91742 The Honorable Pete Olson   a Representative in Congress from the State of Texas A REPRESENTATIVE IN CONGRESS FROM THE STATE OF TEXAS  
69056 IMPACT ON LOCAL COMMUNITIES OF THE RELEASE OF UNACCOMPANIED ALIEN MINORS AND THE NEED FOR CONSULTATION AND NOTIFICATION CHRG-113hhrg91742 Thomas M. Hodgson Sheriff of Bristol County Massachusetts MASSACHUSETTS  

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;