• About

home / cloud_regions

cloud_regions_metadata_dev

3 rows where cfe-region = "PJM" and provider-cfe-annual = "1.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: wt-region-id, geolocation, grid-carbon-intensity-marginal-consumption-annual

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
136 136 2022 Amazon Web Services us-east-2 PJM US-MIDA-PJM PJM_SOUTHWEST_OH US East (Ohio) 39.8689,-84.3292   1.0 1.12 0.19 0     565.1671385   565              
137 137 2022 Amazon Web Services us-east-1 PJM US-MIDA-PJM PJM_DC US East (N. Virginia) 39.1057,-77.5544   1.0 1.16 0.19 0     565.3840343   565              
164 164 2022 Amazon Web Services us-gov-east-1 PJM US-MIDA-PJM PJM_DC GovCloud (US East) 39.1057,-77.5544   1.0   0.19 0     565.3840343   565              

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "cloud_regions_metadata_dev" (
   [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 51.415ms