cloud_regions_metadata

8 rows where wt-region-id = "UK"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: year, cloud-provider, cloud-region, location, geolocation, provider-cfe-hourly, provider-cfe-annual, 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

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
17 17 2023 Google Cloud europe-west2 Great Britain GB UK London 51.726,-0.3 0.92       0.0 136.0 187.89   200.18              
58 58 2023 Amazon Web Services eu-west-2 Great Britain GB UK Europe (London) 51.726,-0.3       0.18 0.0   187.89   200.18              
115 115 2022 Google Cloud europe-west2 Great Britain GB UK London 51.726,-0.3 0.85       0.0 166.0 220.45 427.7283704 223.87 428.0            
154 154 2022 Amazon Web Services eu-west-2 Great Britain GB UK Europe (London) 51.726,-0.3   1.0   0.19 0.0   220.45 427.7283704 223.87 428.0            
211 211 2021 Google Cloud europe-west2 Great Britain GB UK London   0.57       0.0 172.0 226.12   235.87              
248 248 2021 Amazon Web Services eu-west-2 Great Britain GB UK Europe (London)     0.95         226.12   235.87              
273 273 2020 Google Cloud europe-west1 Great Britain GB UK Belgium   0.79       0.0 212.0 206.99   209.32              
298 298 2019 Google Cloud europe-west2 Great Britain GB UK London   0.54       0.0 257.0 230.3   233.65              

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