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-106shrg71374" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location

id package_id name ▼ title organization organization_normalized location
7165 HOW SHOULD OUR FOOD SAFETY SYSTEM ADDRESS MICROBIAL CONTAMINATION? CHRG-106shrg71374 Hon. Dan Glickman Secretary, DC., Under Secretary for Food Safety, Food Safety and Inspection Service Administrator U.S. Department of Agriculture, Washington, accompanied by Catherine E. Woteki, and Thomas J. Bill U.S. DEPARTMENT OF AGRICULTURE, WASHINGTON, ACCOMPANIED BY CATHERINE E. WOTEKI, AND THOMAS J. BILL  
7166 HOW SHOULD OUR FOOD SAFETY SYSTEM ADDRESS MICROBIAL CONTAMINATION? CHRG-106shrg71374 Joseph A. Esq. Levitt Director center for Food Safety and Applied Nutrition, Food and Drug Administration CENTER FOR FOOD SAFETY AND APPLIED NUTRITION, FOOD AND DRUG ADMINISTRATION Washington, DC
7168 HOW SHOULD OUR FOOD SAFETY SYSTEM ADDRESS MICROBIAL CONTAMINATION? CHRG-106shrg71374 Lawrence Dyckman Director, DC., Assistant Director, Senior Analyst Food and Agriculture Issues Resources, Community, and Economic Development Division, U.S. General Accounting Office, Washington, accompanied by Keith Oleson, and Brad Dobbins FOOD AND AGRICULTURE ISSUES RESOURCES, COMMUNITY, AND ECONOMIC DEVELOPMENT DIVISION, U.S. GENERAL ACCOUNTING OFFICE, WASHINGTON, ACCOMPANIED BY KEITH OLESON, AND BRAD DOBBINS  
7169 HOW SHOULD OUR FOOD SAFETY SYSTEM ADDRESS MICROBIAL CONTAMINATION? CHRG-106shrg71374 Michael Doyle Dr., Director, GA. Center for Food Safety and Quality Enhancement, University of Georgia, Griffin, on behalf of the Council for Agricultural Science and Technology CENTER FOR FOOD SAFETY AND QUALITY ENHANCEMENT, UNIVERSITY OF GEORGIA, GRIFFIN, ON BEHALF OF THE COUNCIL FOR AGRICULTURAL SCIENCE AND TECHNOLOGY  
7167 HOW SHOULD OUR FOOD SAFETY SYSTEM ADDRESS MICROBIAL CONTAMINATION? CHRG-106shrg71374 Stephen M. Dr. Ostroff Associate Director for Epidemiologic Science National Center for Infectious Diseases, centers for Disease Control and Prevention NATIONAL CENTER FOR INFECTIOUS DISEASES, CENTERS FOR DISEASE CONTROL AND PREVENTION Atlanta, GA

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;