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

6 rows where package_id = "CHRG-107shrg89958" 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
14905 THE IMPORTANCE OF FINANCIAL LITERACY AMONG COLLEGE STUDENTS CHRG-107shrg89958 Ellen Frishberg Director, Student Financial Services Johns Hopkins University JOHNS HOPKINS UNIVERSITY  
14908 THE IMPORTANCE OF FINANCIAL LITERACY AMONG COLLEGE STUDENTS CHRG-107shrg89958 Jonathan Miller   Treasurer, The Commonwealth of Kentucky TREASURER, THE COMMONWEALTH OF KENTUCKY  
14903 THE IMPORTANCE OF FINANCIAL LITERACY AMONG COLLEGE STUDENTS CHRG-107shrg89958 Louise Slaughter   a U.S. Representative in Congress from the State of New York A U.S. REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEW YORK  
14907 THE IMPORTANCE OF FINANCIAL LITERACY AMONG COLLEGE STUDENTS CHRG-107shrg89958 Michael E. Staten Director Credit Research Center, McDonough School of Business, Georgetown University CREDIT RESEARCH CENTER, MCDONOUGH SCHOOL OF BUSINESS, GEORGETOWN UNIVERSITY  
14906 THE IMPORTANCE OF FINANCIAL LITERACY AMONG COLLEGE STUDENTS CHRG-107shrg89958 Natala K. Hart Director Student Financial Aid, The Ohio State University STUDENT FINANCIAL AID, THE OHIO STATE UNIVERSITY  
14904 THE IMPORTANCE OF FINANCIAL LITERACY AMONG COLLEGE STUDENTS CHRG-107shrg89958 Robert D. Manning Ph.D., Caroline Werner Gannett Professor of the Humanities Rochester Institute of Technology ROCHESTER INSTITUTE OF TECHNOLOGY  

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;