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

7 rows where package_id = "CHRG-111hhrg61756" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
47899 EXAMINING TRAINING REQUIREMENTS OF VETERANS BENEFITS ADMINISTRATION CLAIMS PROCESSING PERSONNEL CHRG-111hhrg61756 American Federation of Government Employees (AFL-CIO) Jr., and Rating Veterans Service Representative Jimmy F. Sims, Shop Steward, Local 1738, and AFGE National Veterans Affairs Council, Winston-Salem, NC, Regional Office, Veterans Benefits Administration JIMMY F. SIMS, SHOP STEWARD, LOCAL 1738, AND AFGE NATIONAL VETERANS AFFAIRS COUNCIL, WINSTON-SALEM, NC, REGIONAL OFFICE, VETERANS BENEFITS ADMINISTRATION  
47900 EXAMINING TRAINING REQUIREMENTS OF VETERANS BENEFITS ADMINISTRATION CLAIMS PROCESSING PERSONNEL CHRG-111hhrg61756 American Legion Deputy Director Ian C. de Planque, Veterans Affairs and Rehabilitation Commission IAN C. DE PLANQUE, VETERANS AFFAIRS AND REHABILITATION COMMISSION  
47901 EXAMINING TRAINING REQUIREMENTS OF VETERANS BENEFITS ADMINISTRATION CLAIMS PROCESSING PERSONNEL CHRG-111hhrg61756 Disabled American Veterans Assistant National Legislative Director Jeffrey C. Hall JEFFREY C. HALL  
47902 EXAMINING TRAINING REQUIREMENTS OF VETERANS BENEFITS ADMINISTRATION CLAIMS PROCESSING PERSONNEL CHRG-111hhrg61756 Institute for Defense Analyses (IDA) Ph.D., Assistant Director David E. Hunter, Cost Analysis and Research Division DAVID E. HUNTER, COST ANALYSIS AND RESEARCH DIVISION  
47903 EXAMINING TRAINING REQUIREMENTS OF VETERANS BENEFITS ADMINISTRATION CLAIMS PROCESSING PERSONNEL CHRG-111hhrg61756 National Veterans Legal Services Program Esq., Senior Staff Attorney Meg Bartley MEG BARTLEY  
47898 EXAMINING TRAINING REQUIREMENTS OF VETERANS BENEFITS ADMINISTRATION CLAIMS PROCESSING PERSONNEL CHRG-111hhrg61756 U.S. Department of Veterans Affairs Acting Deputy Under Secretary for Benefits Michael Cardarelli, Veterans Benefits Administration MICHAEL CARDARELLI, VETERANS BENEFITS ADMINISTRATION  
47897 EXAMINING TRAINING REQUIREMENTS OF VETERANS BENEFITS ADMINISTRATION CLAIMS PROCESSING PERSONNEL CHRG-111hhrg61756 U.S. Government Accountability Office Director Daniel Bertoni, Education, Workforce, and Income Security DANIEL BERTONI, EDUCATION, WORKFORCE, AND INCOME SECURITY  

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;