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

18 rows where package_id = "CHRG-105shrg51562" 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
3028 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Carol Tucker Foreman Coordinator, Director of Food Safety for the Center for Science in the Public Interest on behalf of the Food Safety Coalition Safe Food Coalition, accompanied by Carolina Smith DeWaal SAFE FOOD COALITION, ACCOMPANIED BY CAROLINA SMITH DEWAAL  
3025 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Dane T. Bernard Vice President Food Safety Programs, National Food Processors Association FOOD SAFETY PROGRAMS, NATIONAL FOOD PROCESSORS ASSOCIATION  
3016 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Hon. Barbara Mikulski   a U.S. Senator from the State of Maryland A U.S. SENATOR FROM THE STATE OF MARYLAND  
3017 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Hon. Edward Kennedy   a U.S. Senator from the State of Massachusetts A U.S. SENATOR FROM THE STATE OF MASSACHUSETTS  
3015 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Hon. Paul Coverdell   a U.S. Senator from the State of Georgia A U.S. SENATOR FROM THE STATE OF GEORGIA  
3019 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Hon. Raymond W. Kelly Commissioner, U.S. Customs Service Department of the Treasury DEPARTMENT OF THE TREASURY  
3018 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Hon. Tom Harkin   a U.S. Senator from the State of Iowa A U.S. SENATOR FROM THE STATE OF IOWA  
3013 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Lawrence J. Dyckman Director Food and Agriculture Issues, Resources, Community, and Economic Development Division, U.S. General Accounting Office, accompanied by Keith Oleson and Dennis Richards, San Francisco Regional Office, U.S. General Accounting Office FOOD AND AGRICULTURE ISSUES, RESOURCES, COMMUNITY, AND ECONOMIC DEVELOPMENT DIVISION, U.S. GENERAL ACCOUNTING OFFICE, ACCOMPANIED BY KEITH OLESON AND DENNIS RICHARDS, SAN FRANCISCO REGIONAL OFFICE, U.S. GENERAL ACCOUNTING OFFICE  
3026 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Nancy Nagle Ph.D., Senior Advisor for Food Safety United Fresh Fruit and Vegetable Association UNITED FRESH FRUIT AND VEGETABLE ASSOCIATION  
3014 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Richard J. Hoglund Deputy Assistant Commissioner, U.S. Customs Service, U.S. Customs Service Office of Investigations, accompanied by Philip Metzger, Office of Field Operations OFFICE OF INVESTIGATIONS, ACCOMPANIED BY PHILIP METZGER, OFFICE OF FIELD OPERATIONS  
3027 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Richard Levinson M.D., Associate Executive Director for Programs and Policy American Public Health Association AMERICAN PUBLIC HEALTH ASSOCIATION  
3030 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Robert Hahn Director Legal Affairs and Research, Public Voice for Food and Health Policy LEGAL AFFAIRS AND RESEARCH, PUBLIC VOICE FOR FOOD AND HEALTH POLICY  
3029 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Ruth Kava Ph.D., R.D., Director of Nutrition American Council on Science and Health AMERICAN COUNCIL ON SCIENCE AND HEALTH  
3022 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Sanford A. Miller Member Committee to Ensure Safe Food From Production to Consumption, National Academy of Sciences COMMITTEE TO ENSURE SAFE FOOD FROM PRODUCTION TO CONSUMPTION, NATIONAL ACADEMY OF SCIENCES  
3024 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Stacey A. Zawel Ph.D., Director Scientific and Regulatory Affairs, Grocery Manufacturers of America SCIENTIFIC AND REGULATORY AFFAIRS, GROCERY MANUFACTURERS OF AMERICA  
3020 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Thomas J. Billy Administrator, Food Safety and Inspection Service, Deputy Administrator for Field Operations, Deputy Administrator Department of Agriculture, accompanied by Mark Mina, and Margaret Glavin, Office of Policy, Development and Evaluation DEPARTMENT OF AGRICULTURE, ACCOMPANIED BY MARK MINA, AND MARGARET GLAVIN, OFFICE OF POLICY, DEVELOPMENT AND EVALUATION  
3023 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 Timothy M. Hammonds President and CEO Food Marketing Institute FOOD MARKETING INSTITUTE  
3021 THE SAFETY OF FOOD IMPORTS: FRAUD AND DECEPTION IN THE FOOD IMPORT PROCESS CHRG-105shrg51562 William B. Schultz Deputy Commissioner for Policy, Department of Health and Human Services, Director, Deputy Associate Administrator Food and Drug Administration, accompanied by Joseph Levitt, Center for Food and Applied Nutrition, and Gary Dykstra, Office of Regulatory Affairs FOOD AND DRUG ADMINISTRATION, ACCOMPANIED BY JOSEPH LEVITT, CENTER FOR FOOD AND APPLIED NUTRITION, AND GARY DYKSTRA, OFFICE OF REGULATORY AFFAIRS  

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;