cloud_regions_metadata

27 rows where year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: wt-region-id, provider-cfe-hourly

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
323 323 2020 Google Cloud asia-east1 Taiwan TW TWN Taiwan   0.18       0.0 540.0 540.14   540.17              
324 324 2020 Google Cloud asia-east2 Hong Kong HK HKG Hong Kong   0.0       0.0 453.0 435.36   435.36              
325 325 2020 Google Cloud asia-northeast1 Tokyo JP-TK JP_TK Tokyo   0.12       0.0 554.0 558.18   564.61              
326 326 2020 Google Cloud asia-northeast2 Kansai JP-KN JP_KN Osaka   0.0       0.0 442.0 472.07   478.86              
327 327 2020 Google Cloud asia-northeast3 South Korea KR KOR Seoul   0.31       0.0 457.0 490.0   490.0              
328 328 2020 Google Cloud asia-south1 Maharashtra IN-WE IND Mumbai   0.12       0.0 721.0 686.92   698.28              
329 329 2020 Google Cloud asia-south2 Uttar Pradesh IN-NO IND Delhi   0.0       0.0 657.0 502.51   507.31              
330 330 2020 Google Cloud asia-southeast1 Singapore SG SGP Singapore   0.04       0.0 493.0 492.5   491.94              
331 331 2020 Google Cloud asia-southeast2 Indonesia ID IDN Jakarta   0.0       0.0 647.0 652.36   652.36              
332 332 2020 Google Cloud australia-southeast1 New South Wales AU-NSW NEM_NSW Sydney   0.11       0.0 727.0 692.71   692.61              
333 333 2020 Google Cloud australia-southeast2 Victoria AU-VIC NEM_VIC Melbourne   0.0       0.0 691.0 633.0   633.0              
334 334 2020 Google Cloud europe-central2 Poland PL PL Warsaw   0.0       0.0 622.0 828.05   900.97              
335 335 2020 Google Cloud europe-north1 Belgium BE BE Finland   0.94       0.0 133.0 221.1   214.14              
336 336 2020 Google Cloud europe-west1 Great Britain GB UK Belgium   0.79       0.0 212.0 206.99   209.32              
337 337 2020 Google Cloud europe-west2 Germany DE DE London   0.59       0.0 231.0 385.61   399.25              
338 338 2020 Google Cloud europe-west3 Netherlands NL NL Frankfurt   0.63       0.0 293.0 372.07   403.44              
339 339 2020 Google Cloud europe-west4 Switzerland CH CH Netherlands   0.6       0.0 410.0 108.24   68.73              
340 340 2020 Google Cloud europe-west6 North Italy IT-NO IT Zurich   0.0       0.0 87.0 305.91   364.44              
341 341 2020 Google Cloud northamerica-northeast1 Quebec CA-QC HQ Montréal   0.0       0.0 27.0 28.48   28.52              
342 342 2020 Google Cloud southamerica-east1 Central Brazil BR-CS BRA São Paulo   0.88       0.0 103.0 147.68   98.67              
343 343 2020 Google Cloud us-central1 MISO US-MIDW-MISO MISO_MASON_CITY Iowa   0.93       0.0 454.0 525.69   552.43              
344 344 2020 Google Cloud us-east1 SC US-CAR-SC SC South Carolina   0.27       0.0 480.0 597.85   752.21              
345 345 2020 Google Cloud us-east4 PJM US-MIDA-PJM PJM_DC Northern Virginia   0.58       0.0 361.0 420.99   421.62              
346 346 2020 Google Cloud us-west1 BPA US-NW-BPAT BPA Oregon   0.9       0.0 78.0 68.35   56.64              
347 347 2020 Google Cloud us-west2 CAISO US-CAL-CISO LDWP Los Angeles   0.54       0.0 253.0 270.13   253.12              
348 348 2020 Google Cloud us-west3 PACE US-NW-PACE PACE Salt Lake City   0.28       0.0 533.0 675.84   732.5              
349 349 2020 Google Cloud us-west4 NVE US-NW-NEVP NEVP Las Vegas   0.19       0.0 455.0 501.39   543.8              

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
);