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

13 rows where package_id = "CHRG-105hhrg48751" 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
959 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 A. Alan Moghissi President Institute for Regulatory Science, Columbia, Maryland INSTITUTE FOR REGULATORY SCIENCE, COLUMBIA, MARYLAND  
956 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Bill Gaines   California Waterfowl Association CALIFORNIA WATERFOWL ASSOCIATION  
960 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Bill Pauli   California Farm Bureau Federation, Sacramento, California CALIFORNIA FARM BUREAU FEDERATION, SACRAMENTO, CALIFORNIA  
964 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 David Yardas Senior Analyst Environmental Defense Fund, California ENVIRONMENTAL DEFENSE FUND, CALIFORNIA  
955 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Dick Dickerson President Regional Council of Rural Counties, Redding, California REGIONAL COUNCIL OF RURAL COUNTIES, REDDING, CALIFORNIA  
953 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Gary Bobker   The Bay Institute THE BAY INSTITUTE  
963 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Lester Snow Executive Director CALFED Bay-Delta Program CALFED BAY-DELTA PROGRAM  
954 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Martha Davis Board Member Mono Lake Committee Sierra Nevada Alliance MONO LAKE COMMITTEE SIERRA NEVADA ALLIANCE  
957 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Richard Golb   Northern California Water Association NORTHERN CALIFORNIA WATER ASSOCIATION  
961 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Robert Potter Chief Deputy Director Department of Water Resources, State of California DEPARTMENT OF WATER RESOURCES, STATE OF CALIFORNIA  
958 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Stephen Hall   Association of California Water Agencies, Sacramento, California ASSOCIATION OF CALIFORNIA WATER AGENCIES, SACRAMENTO, CALIFORNIA  
962 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Timothy Quinn Deputy General Manager Metropolitan Water District of Southern California METROPOLITAN WATER DISTRICT OF SOUTHERN CALIFORNIA  
952 OVERSIGHT HEARING ON THE FUTURE WATER NEEDS OF CALIFORNIA UNDER CALFED, CALFED FINANCING, THE MONITORING AND PERFORMANCE STANDARDS OF CALFED, AND CALFED PUBLIC PARTICIPATION CHRG-105hhrg48751 Tom Berliner   City Attorney Office, San Francisco, California CITY ATTORNEY OFFICE, SAN FRANCISCO, CALIFORNIA  

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;