cloud_regions_metadata

5 rows where cloud-provider = "Google Cloud" and em-zone-id = "US-NW-PACE"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geolocation, provider-cfe-hourly, grid-carbon-intensity-marginal-consumption-annual, grid-carbon-intensity

Link rowid ▼ year cloud-provider cloud-region cfe-region em-zone-id wt-region-id location geolocation provider-cfe-hourly provider-cfe-annual power-usage-effectiveness water-usage-effectiveness provider-carbon-intensity-market-annual provider-carbon-intensity-average-consumption-hourly grid-carbon-intensity-average-consumption-annual grid-carbon-intensity-marginal-consumption-annual grid-carbon-intensity-average-production-annual grid-carbon-intensity total-ICT-energy-consumption-annual total-water-input renewable-energy-consumption renewable-energy-consumption-goe renewable-energy-consumption-ppa renewable-energy-consumption-onsite
38 38 2023 Google Cloud us-west3 PACE US-NW-PACE PACE Salt Lake City 40.7776,-111.9311 0.29       0.0 588.0 647.78   657.95              
134 134 2022 Google Cloud us-west3 PACE US-NW-PACE PACE Salt Lake City 40.7776,-111.9311 0.31       0.0 606.0 658.67 664.0421037 676.5 664.0            
228 228 2021 Google Cloud us-west3 PACE US-NW-PACE PACE Salt Lake City   0.31       0.0 448.0 633.54   669.78              
285 285 2020 Google Cloud us-west3 PACE US-NW-PACE PACE Salt Lake City   0.28       0.0 533.0 675.84   732.5              
309 309 2019 Google Cloud us-west3 PACE US-NW-PACE PACE Salt Lake City   0.25       0.0 561.0 704.22   772.14              

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cloud_regions_metadata" (
   [year] INTEGER,
   [cloud-provider] TEXT,
   [cloud-region] TEXT,
   [cfe-region] TEXT,
   [em-zone-id] TEXT,
   [wt-region-id] TEXT,
   [location] TEXT,
   [geolocation] TEXT,
   [provider-cfe-hourly] FLOAT,
   [provider-cfe-annual] FLOAT,
   [power-usage-effectiveness] FLOAT,
   [water-usage-effectiveness] FLOAT,
   [provider-carbon-intensity-market-annual] FLOAT,
   [provider-carbon-intensity-average-consumption-hourly] FLOAT,
   [grid-carbon-intensity-average-consumption-annual] FLOAT,
   [grid-carbon-intensity-marginal-consumption-annual] FLOAT,
   [grid-carbon-intensity-average-production-annual] FLOAT,
   [grid-carbon-intensity] FLOAT,
   [total-ICT-energy-consumption-annual] INTEGER,
   [total-water-input] INTEGER,
   [renewable-energy-consumption] INTEGER,
   [renewable-energy-consumption-goe] INTEGER,
   [renewable-energy-consumption-ppa] INTEGER,
   [renewable-energy-consumption-onsite] INTEGER
);