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

10 rows where package_id = "CHRG-107shrg83683" 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
13230 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 A Layman's Guide to the General Circulation Models Used in the National Assessment...........................106-125 Responses to additional questions from: Senator Campbell Report        
13231 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 Addendum #1 Summary executive director, Clean Air-Cool Planet Theoretical and Applied Climatology, 41, 11-21 (1990), by Springer-Verlag, Mean Seasonal and Spatial Variability in Global Surface Air Temperature...........................................134-145 Markham, Adam THEORETICAL AND APPLIED CLIMATOLOGY, 41, 11-21 (1990), BY SPRINGER-VERLAG, MEAN SEASONAL AND SPATIAL VARIABILITY IN GLOBAL SURFACE AIR TEMPERATURE...........................................134-145 MARKHAM, ADAM Portsmouth, NH
13234 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 Climate Change Science Report   An Analysis of Some Key Questions, National Academy Press.......................... 47-82 Responses to additional questions from: Senator Jeffords AN ANALYSIS OF SOME KEY QUESTIONS, NATIONAL ACADEMY PRESS.......................... 47-82 RESPONSES TO ADDITIONAL QUESTIONS FROM: SENATOR JEFFORDS  
13227 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 Climate Research Report   Vol. 18:259-275, 2001, Modeling climatic effects of anthropogenic carbon dioxide emissions: unknown uncertainties.....................................162-178 Responses to additional questions from: Senator Campbell VOL. 18:259-275, 2001, MODELING CLIMATIC EFFECTS OF ANTHROPOGENIC CARBON DIOXIDE EMISSIONS: UNKNOWN UNCERTAINTIES.....................................162-178 RESPONSES TO ADDITIONAL QUESTIONS FROM: SENATOR CAMPBELL  
13229 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 David R. Legates director Center for Climatic Research, University of Delaware CENTER FOR CLIMATIC RESEARCH, UNIVERSITY OF DELAWARE Newark, DE
13228 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 Jack D. Cogen president Natsource NATSOURCE New York, NY
13235 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 Martin Whittaker managing director Innovest, Richmond Hill, Ontario, Canada INNOVEST, RICHMOND HILL, ONTARIO, CANADA  
13232 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 Roger A. Pielke Jr., associate professor, University of Colorado/ Cooperative Institute for Research in Environmental Sciences Center for Science and Technology Policy Research CENTER FOR SCIENCE AND TECHNOLOGY POLICY RESEARCH Boulder, CO
13226 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 Sallie Baliunas   astrophysicist, Harvard-Smithsonian Center for Astrophysics ASTROPHYSICIST, HARVARD-SMITHSONIAN CENTER FOR ASTROPHYSICS Cambridge, MA
13233 CLEAN AIR ACT: RISKS FROM GREENHOUSE GAS EMISSIONS CHRG-107shrg83683 Sherwood F. Rowland Donald Bren research professor of chemistry and earth science University of California Irvine UNIVERSITY OF CALIFORNIA IRVINE Irvine, CA

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;