cloud_regions_metadata

13 rows where cfe-region = "BPA"

✎ 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, 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

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
36 36 2023 Google Cloud us-west1 BPA US-NW-BPAT BPA Oregon 45.5372,-122.3955 0.84   1.07   0.0 94.0 119.76   68.82              
43 43 2023 Amazon Web Services us-west-2 BPA US-NW-BPAT BPA US West (Oregon) 45.5371,-122.65     1.13 0.18 0.0   119.76   68.82              
69 69 2023 Amazon Web Services us-gov-west-1 BPA US-NW-BPAT BPA GovCloud (US West) 45.5371,-122.65       0.18 0.0   119.76   68.82              
98 98 2023 Microsoft Azure westus BPA US-NW-BPAT BPA Washington: West US 47.247,-119.82     1.15       119.76   68.82              
132 132 2022 Google Cloud us-west1 BPA US-NW-BPAT BPA Oregon 45.5372,-122.3955 0.89   1.1   0.0 67.0 86.61 427.1886293 58.5 427.0            
139 139 2022 Amazon Web Services us-west-2 BPA US-NW-BPAT BPA US West (Oregon) 45.5371,-122.65   1.0 1.13 0.19 0.0   86.61 427.1886293 58.5 427.0            
165 165 2022 Amazon Web Services us-gov-west-1 BPA US-NW-BPAT BPA GovCloud (US West) 45.5371,-122.65   1.0   0.19 0.0   86.61 427.1886293 58.5 427.0            
194 194 2022 Microsoft Azure westus BPA US-NW-BPAT BPA Washington: West US 47.247,-119.82   0.47 1.156 1.09     86.61 427.1886293 58.5 427.0            
226 226 2021 Google Cloud us-west1 BPA US-NW-BPAT BPA Oregon   0.88       0.0 60.0 90.95   67.69              
233 233 2021 Amazon Web Services us-west-2 BPA US-NW-BPAT BPA US West (Oregon)     0.95         90.95   67.69              
257 257 2021 Amazon Web Services us-gov-west-1 BPA US-NW-BPAT BPA GovCloud (US West)     0.95         90.95   67.69              
283 283 2020 Google Cloud us-west1 BPA US-NW-BPAT BPA Oregon   0.9       0.0 78.0 68.35   56.64              
307 307 2019 Google Cloud us-west1 BPA US-NW-BPAT BPA Oregon   0.89       0.0 117.0 115.03   74.15              

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