cloud_regions_metadata

9 rows where cfe-region = "CAISO" and provider-carbon-intensity-market-annual = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: year, cloud-provider, cloud-region, wt-region-id, location, geolocation, provider-cfe-hourly, provider-cfe-annual, power-usage-effectiveness, water-usage-effectiveness, 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
21 21 2024 Amazon Web Services us-west-1 CAISO US-CAL-CISO CAISO_NORTH US West (N. California) 36.7783,-119.417931     1.18 0.51 0.0   261.28 381.37 239.67              
61 61 2024 Google Cloud us-west2 CAISO US-CAL-CISO LDWP Los Angeles 34.1141,-118.4068 0.55 0.63     0.0 198.0 169.28 535.56 239.67              
94 94 2023 Amazon Web Services us-west-1 CAISO US-CAL-CISO CAISO_NORTH US West (N. California) 36.7783,-119.417931     1.17 0.18 0.0   261.28 381.37 239.67              
132 132 2023 Google Cloud us-west2 CAISO US-CAL-CISO LDWP Los Angeles 34.1141,-118.4068 0.55       0.0 198.0 261.28 535.56 239.67              
193 193 2022 Amazon Web Services us-west-1 CAISO US-CAL-CISO CAISO_NORTH US West (N. California) 36.7783,-119.417931   1.0 1.17 0.19 0.0   264.4 392.7840553 247.55 393.0            
228 228 2022 Google Cloud us-west2 CAISO US-CAL-CISO LDWP Los Angeles 34.1141,-118.4068 0.56       0.0 202.0 264.4 501.0230748 247.55 501.0            
320 320 2021 Google Cloud us-west2 CAISO US-CAL-CISO LDWP Los Angeles   0.53       0.0 190.0 274.9   254.26              
347 347 2020 Google Cloud us-west2 CAISO US-CAL-CISO LDWP Los Angeles   0.54       0.0 253.0 270.13   253.12              
371 371 2019 Google Cloud us-west2 CAISO US-CAL-CISO LDWP Los Angeles   0.55       0.0 248.0 253.75   223.36              

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