• About

home / cloud_regions

cloud_regions_metadata

2 rows where power-usage-effectiveness = "1.2"

✎ 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
107 107 2022 Google Cloud asia-southeast1 Singapore SG SGP Singapore 1.3,103.8 0.04   1.2   0 372   409.1860208   409              
180 180 2022 Microsoft Azure taiwannorth Taiwan TW TW Taiwan 25.0375,121.5625     1.2 1.0                          

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] INTEGER,
   [provider-carbon-intensity-average-consumption-hourly] INTEGER,
   [grid-carbon-intensity-average-consumption-annual] INTEGER,
   [grid-carbon-intensity-marginal-consumption-annual] FLOAT,
   [grid-carbon-intensity-average-production-annual] INTEGER,
   [grid-carbon-intensity] INTEGER,
   [total-ICT-energy-consumption-annual] INTEGER,
   [total-water-input] INTEGER,
   [renewable-energy-consumption] INTEGER,
   [renewable-energy-consumption-goe] INTEGER,
   [renewable-energy-consumption-ppa] INTEGER,
   [] INTEGER,
   [renewable-energy-consumption-onsite] INTEGER
);
Powered by Datasette · Queries took 73.251ms