cloud_regions_metadata
2 rows where power-usage-effectiveness = "1.17"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42 | 42 | 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 | 239.67 | |||||||||||
| 138 | 138 | 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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );