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

5 rows where package_id = "CHRG-110shrg43987" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
39656 ROGUE ONLINE PHARMACIES: THE GROWING PROBLEM OF INTERNET DRUG TRAFFICKING CHRG-110shrg43987 A. Thomas McLellan Chief Executive Officer Treatment Research Institute, Philadelphia, Pennsylvania, statement TREATMENT RESEARCH INSTITUTE, PHILADELPHIA, PENNSYLVANIA, STATEMENT  
39654 ROGUE ONLINE PHARMACIES: THE GROWING PROBLEM OF INTERNET DRUG TRAFFICKING CHRG-110shrg43987 Francine H. Haight Founder of RYAN's Cause Laguna Niguel, California LAGUNA NIGUEL, CALIFORNIA  
39653 ROGUE ONLINE PHARMACIES: THE GROWING PROBLEM OF INTERNET DRUG TRAFFICKING CHRG-110shrg43987 Joseph A. Califano Jr., Chairman and President, and former Secretary The National Center on Addiction and Substance Abuse at Columbia University, Department of Health, Education, and Welfare, New York, New York THE NATIONAL CENTER ON ADDICTION AND SUBSTANCE ABUSE AT COLUMBIA UNIVERSITY, DEPARTMENT OF HEALTH, EDUCATION, AND WELFARE, NEW YORK, NEW YORK  
39657 ROGUE ONLINE PHARMACIES: THE GROWING PROBLEM OF INTERNET DRUG TRAFFICKING CHRG-110shrg43987 Joseph T. Rannazzisi Deputy Assistant Administrator, D.C. Office of Diversion Control, Drug Enforcement Administration, Department of Justice, Washington, statement OFFICE OF DIVERSION CONTROL, DRUG ENFORCEMENT ADMINISTRATION, DEPARTMENT OF JUSTICE, WASHINGTON, STATEMENT  
39655 ROGUE ONLINE PHARMACIES: THE GROWING PROBLEM OF INTERNET DRUG TRAFFICKING CHRG-110shrg43987 Philip B. Heymann James Barr Ames Professor of Law, and Former Deputy U.S. Attorney General Harvard Law School, Cambridge, Massachusetts HARVARD LAW SCHOOL, CAMBRIDGE, 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;