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

17 rows where package_id = "CHRG-106shrg70294" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
7136 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Alan Kennett President and General Manager Gay & Robinson, Inc., Kaumakani GAY & ROBINSON, INC., KAUMAKANI Kauai, HI
7131 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Arthur Jaeger S., Assistant Director Consumer Federation of America CONSUMER FEDERATION OF AMERICA Washington, DC
7126 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Carol Brick-Turin   CBT Consulting CBT CONSULTING Annandale, VA
7139 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 David Orden   Agricultural and Applied Economics, Virginia Polytechnic Institute and State University AGRICULTURAL AND APPLIED ECONOMICS, VIRGINIA POLYTECHNIC INSTITUTE AND STATE UNIVERSITY Blacksburg, VA
7127 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Hon. August Schumacher Jr., Under Secretary for Farm and Foreign Agricultural Services, DC., Chief Economist U.S. Department of Agriculture, Washington, accompanied by, Keith Collins, U.S. Department of Agriculture U.S. DEPARTMENT OF AGRICULTURE, WASHINGTON, ACCOMPANIED BY, KEITH COLLINS, U.S. DEPARTMENT OF AGRICULTURE  
7125 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Hon. Dan Miller   a U.S. Representative from Florida A U.S. REPRESENTATIVE FROM FLORIDA  
7134 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Hon. Ira Shapiro   Coalition for Sugar Reform COALITION FOR SUGAR REFORM Washington, DC
7124 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Hon. Patsy Mink   a U.S. Representative from Hawaii A U.S. REPRESENTATIVE FROM HAWAII  
7137 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Jack Lay President, NY., Director of Economics and Policy Analysis Refined Sugars, Inc., Yonkers, accompanied by Jack Roney, American Sugar Alliance REFINED SUGARS, INC., YONKERS, ACCOMPANIED BY JACK RONEY, AMERICAN SUGAR ALLIANCE  
7135 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 James J. Horvath President and Chief Executive Officer American Crystal Sugar Company AMERICAN CRYSTAL SUGAR COMPANY Moorhead, MN
7129 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 John E. Frydenlund Director Center for International Food and Agriculture Policy, Citizens Against Government Waste CENTER FOR INTERNATIONAL FOOD AND AGRICULTURE POLICY, CITIZENS AGAINST GOVERNMENT WASTE Washington, DC
7138 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Lindsay McLaughlin Legislative Director International Longshore and Warehouse Union INTERNATIONAL LONGSHORE AND WAREHOUSE UNION Washington, DC
7133 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Mark Perry Executive Director Florida Oceanographic Society, Stuart, Florida FLORIDA OCEANOGRAPHIC SOCIETY, STUART, FLORIDA  
7132 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Nicholas Kominus President U.S. Cane Sugar Refiners' Association U.S. CANE SUGAR REFINERS' ASSOCIATION Washington, DC
7140 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Ray VanDreissche President American Sugarbeet Growers Association AMERICAN SUGARBEET GROWERS ASSOCIATION Bay City, MI
7128 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Shannon Estenoz   on behalf of the World Wildlife Fund and the Everglades Coalition ON BEHALF OF THE WORLD WILDLIFE FUND AND THE EVERGLADES COALITION Washington, DC
7130 FEDERAL SUGAR PROGRAM CHRG-106shrg70294 Tom Hammer President Sweetner Users Association SWEETNER USERS ASSOCIATION Falls Church, VA

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;