• About

home / cloud_regions

cloud_regions_metadata

8 rows where provider-cfe-hourly = "0.0" and year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

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
261 261 2020 Google Cloud asia-east2 Hong Kong HK HK Hong Kong   0.0       0.0 453.0 435.36   435.36              
263 263 2020 Google Cloud asia-northeast2 Kansai JP-KN JP_KN Osaka   0.0       0.0 442.0 472.07   478.86              
266 266 2020 Google Cloud asia-south2 Uttar Pradesh IN-NO IND Delhi   0.0       0.0 657.0 502.51   507.31              
268 268 2020 Google Cloud asia-southeast2 Indonesia ID ID Jakarta   0.0       0.0 647.0 652.36   652.36              
270 270 2020 Google Cloud australia-southeast2 Victoria AU-VIC NEM_VIC Melbourne   0.0       0.0 691.0 633.0   633.0              
271 271 2020 Google Cloud europe-central2 Poland PL PL Warsaw   0.0       0.0 622.0 828.05   900.97              
277 277 2020 Google Cloud europe-west6 North Italy IT-NO IT Zurich   0.0       0.0 87.0 305.91   364.44              
278 278 2020 Google Cloud northamerica-northeast1 Quebec CA-QC HQ Montréal   0.0       0.0 27.0 28.48   28.52              

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
);
Powered by Datasette · Queries took 62.633ms