cloud_regions_metadata
207 rows where power-usage-effectiveness = ""
This data as json, CSV (advanced)
Suggested facets: year, cloud-provider, provider-cfe-annual, water-usage-effectiveness, provider-carbon-intensity-market-annual, grid-carbon-intensity-marginal-consumption-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2023 | Google Cloud | africa-south1 | South Africa | ZA | ZA | Johannesburg | 0.16 | 646.0 | 702.03 | 701.92 | |||||||||||||
| 3 | 3 | 2023 | Google Cloud | asia-east2 | Hong Kong | HK | HK | Hong Kong | 22.3,114.2 | 0.28 | 0.0 | 360.0 | 435.36 | 435.36 | |||||||||||
| 4 | 4 | 2023 | Google Cloud | asia-northeast1 | Tokyo | JP-TK | JP_TK | Tokyo | 35.6897,139.692 | 0.16 | 0.0 | 459.0 | 536.06 | 545.67 | |||||||||||
| 5 | 5 | 2023 | Google Cloud | asia-northeast2 | Kansai | JP-KN | JP_KN | Osaka | 34.6939,135.502 | 0.3 | 0.0 | 385.0 | 370.3 | 357.05 | |||||||||||
| 6 | 6 | 2023 | Google Cloud | asia-northeast3 | South Korea | KR | KOR | Seoul | 37.56,126.99 | 0.35 | 0.0 | 378.0 | 443.05 | 443.01 | |||||||||||
| 7 | 7 | 2023 | Google Cloud | asia-south1 | Maharashtra | IN-WE | IND | Mumbai | 19.0761,72.8775 | 0.14 | 0.0 | 648.0 | 746.98 | 762.24 | |||||||||||
| 8 | 8 | 2023 | Google Cloud | asia-south2 | Uttar Pradesh | IN-NO | IND | Delhi | 28.6092,76.9798 | 0.29 | 0.0 | 529.0 | 563.1 | 562.0 | |||||||||||
| 10 | 10 | 2023 | Google Cloud | asia-southeast2 | Indonesia | ID | ID | Jakarta | -6.2507,106.869 | 0.13 | 0.0 | 580.0 | 652.36 | 652.36 | |||||||||||
| 11 | 11 | 2023 | Google Cloud | australia-southeast1 | New South Wales | AU-NSW | NEM_NSW | Sydney | -33.8678,151.21 | 0.33 | 0.0 | 501.0 | 545.01 | 546.1 | |||||||||||
| 12 | 12 | 2023 | Google Cloud | australia-southeast2 | Victoria | AU-VIC | NEM_VIC | Melbourne | -37.8142,144.963 | 0.4 | 0.0 | 456.0 | 498.19 | 514.1 | |||||||||||
| 13 | 13 | 2023 | Google Cloud | europe-central2 | Poland | PL | PL | Warsaw | 52.23,21.0111 | 0.31 | 0.0 | 723.0 | 749.28 | 794.76 | |||||||||||
| 15 | 15 | 2023 | Google Cloud | europe-southwest1 | Spain | ES | ES | Madrid | 40.3333,-3.8667 | 0.76 | 0.0 | 131.0 | 153.86 | 154.56 | |||||||||||
| 17 | 17 | 2023 | Google Cloud | europe-west2 | Great Britain | GB | UK | London | 51.726,-0.3 | 0.92 | 0.0 | 136.0 | 187.89 | 200.18 | |||||||||||
| 18 | 18 | 2023 | Google Cloud | europe-west3 | Germany | DE | DE | Frankfurt | 50.1106,8.6822 | 0.9 | 0.0 | 345.0 | 370.93 | 394.14 | |||||||||||
| 20 | 20 | 2023 | Google Cloud | europe-west6 | Switzerland | CH | CH | Zurich | 47.3744,8.5411 | 0.92 | 0.0 | 59.0 | 83.8 | 52.58 | |||||||||||
| 21 | 21 | 2023 | Google Cloud | europe-west8 | North Italy | IT-NO | IT | Milan | 45.4669,9.19 | 0.52 | 0.0 | 249.0 | 298.62 | 379.97 | |||||||||||
| 22 | 22 | 2023 | Google Cloud | europe-west9 | France | FR | FR | Paris | 48.8567,2.3522 | 0.94 | 0.0 | 34.0 | 52.87 | 45.21 | |||||||||||
| 23 | 23 | 2023 | Google Cloud | europe-west12 | North Italy | IT-NO | IT | Turin | 45.0792,7.6761 | 0.52 | 0.0 | 249.0 | 298.62 | 379.97 | |||||||||||
| 24 | 24 | 2023 | Google Cloud | me-central1 | United Arab Emirates | AE | Doha | 0.0 | 575.0 | 381.54 | 381.54 | ||||||||||||||
| 25 | 25 | 2023 | Google Cloud | me-central2 | Saudi Arabia | SA | Damman | 0.0 | 569.0 | ||||||||||||||||
| 26 | 26 | 2023 | Google Cloud | me-west1 | Israel | IL | IL | Tel Aviv | 32.0167,34.7667 | 0.05 | 0.0 | 463.0 | 533.04 | 533.04 | |||||||||||
| 27 | 27 | 2023 | Google Cloud | northamerica-northeast1 | Quebec | CA-QC | HQ | Montréal | 45.5089,-73.5617 | 1.0 | 0.0 | 2.0 | 30.51 | 28.68 | |||||||||||
| 28 | 28 | 2023 | Google Cloud | northamerica-northeast2 | Ontario | CA-ON | IESO_NORTH | Toronto | 43.7417,-79.3733 | 0.87 | 0.0 | 47.0 | 76.42 | 75.79 | |||||||||||
| 29 | 29 | 2023 | Google Cloud | southamerica-east1 | Central Brazil | BR-CS | BRA | São Paulo | -3.45,-68.95 | 0.9 | 0.0 | 56.0 | 89.55 | 90.41 | |||||||||||
| 37 | 37 | 2023 | Google Cloud | us-west2 | CAISO | US-CAL-CISO | LDWP | Los Angeles | 34.1141,-118.4068 | 0.55 | 0.0 | 198.0 | 261.28 | 239.67 | |||||||||||
| 38 | 38 | 2023 | Google Cloud | us-west3 | PACE | US-NW-PACE | PACE | Salt Lake City | 40.7776,-111.9311 | 0.29 | 0.0 | 588.0 | 647.78 | 657.95 | |||||||||||
| 45 | 45 | 2023 | Amazon Web Services | ap-east-1 | Hong Kong | HK | HK | Asia Pacific (Hong Kong) | 22.3,114.2 | 0.18 | 435.36 | 435.36 | |||||||||||||
| 50 | 50 | 2023 | Amazon Web Services | ap-northeast-3 | Kansai | JP-KN | JP_KN | Asia Pacific (Osaka) | 34.6939,135.502 | 0.18 | 0.0 | 370.3 | 357.05 | ||||||||||||
| 51 | 51 | 2023 | Amazon Web Services | ap-northeast-2 | South Korea | KR | KOR | Asia Pacific (Seoul) | 37.56,126.99 | 0.18 | 443.05 | 443.01 | |||||||||||||
| 58 | 58 | 2023 | Amazon Web Services | eu-west-2 | Great Britain | GB | UK | Europe (London) | 51.726,-0.3 | 0.18 | 0.0 | 187.89 | 200.18 | ||||||||||||
| 59 | 59 | 2023 | Amazon Web Services | eu-south-1 | North Italy | IT-NO | IT | Europe (Milan) | 45.4669,9.19 | 0.18 | 0.0 | 298.62 | 379.97 | ||||||||||||
| 60 | 60 | 2023 | Amazon Web Services | eu-west-3 | France | FR | FR | Europe (Paris) | 48.8567,2.3522 | 0.18 | 0.0 | 52.87 | 45.21 | ||||||||||||
| 63 | 63 | 2023 | Amazon Web Services | eu-central-2 | Switzerland | CH | CH | Europe (Zurich) | 47.3744,8.5411 | 0.18 | 0.0 | 83.8 | 52.58 | ||||||||||||
| 64 | 64 | 2023 | Amazon Web Services | il-central-1 | Israel | IL | IL | Israel (Tel Aviv) | 32.0167,34.7667 | 0.18 | 533.04 | 533.04 | |||||||||||||
| 68 | 68 | 2023 | Amazon Web Services | us-gov-east-1 | PJM | US-MIDA-PJM | PJM_DC | GovCloud (US East) | 39.1057,-77.5544 | 0.18 | 0.0 | 396.25 | 396.77 | ||||||||||||
| 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 | ||||||||||||
| 70 | 70 | 2023 | Amazon Web Services | cn-north-1 | China (Beijing) | 39.904,116.4075 | 0.18 | 0.0 | |||||||||||||||||
| 73 | 73 | 2023 | Microsoft Azure | brazilsouth | Brazil | BR-CS | BRA | Brazil | -22.939, -47.045 | 89.55 | 90.41 | ||||||||||||||
| 74 | 74 | 2023 | Microsoft Azure | northeurope | Finland | FI | FI | Finland | 60.2065, 24.6753 | 82.34 | 89.24 | ||||||||||||||
| 75 | 75 | 2023 | Microsoft Azure | asiapacific | Indonesia | ID | ID | Indonesia | -6.219, 106.867 | 652.36 | 652.36 | ||||||||||||||
| 76 | 76 | 2023 | Microsoft Azure | newzealandnorth | New Zealand | NZ | NZ | New Zealand | -36.867, 174.751 | 96.81 | 96.81 | ||||||||||||||
| 78 | 78 | 2023 | Microsoft Azure | australiaeast | New South Wales | AU-NSW | NEM_NSW | Australia East | -33.889, 151.067 | 545.01 | 546.1 | ||||||||||||||
| 79 | 79 | 2023 | Microsoft Azure | australiasoutheast | Victoria | AU-VIC | NEM_VIC | Australia Southeast | -37.725, 145.067 | 498.19 | 514.1 | ||||||||||||||
| 80 | 80 | 2023 | Microsoft Azure | denmarkeast | Denmark | DK-DK2 | DK | Denmark | 55.685, 12.584 | 136.81 | 184.21 | ||||||||||||||
| 81 | 81 | 2023 | Microsoft Azure | greececentral | Greece | GR | GR | Greece Central | 37.987, 23.745 | 368.75 | 342.79 | ||||||||||||||
| 82 | 82 | 2023 | Microsoft Azure | italynorth | North Italy | IT-NO | IT | Italy North | 45.4669,9.19 | 298.62 | 379.97 | ||||||||||||||
| 83 | 83 | 2023 | Microsoft Azure | polandcentral | Poland | PL | PL | Poland Central | 52.23,21.0111 | 749.28 | 794.76 | ||||||||||||||
| 84 | 84 | 2023 | Microsoft Azure | taiwannorth | Taiwan | TW | TW | Taiwan | 25.0375,121.5625 | 537.64 | 537.76 | ||||||||||||||
| 85 | 85 | 2023 | Microsoft Azure | austriaeast | Austria | AT | AT | Austria East | 48.217, 16.493 | 160.36 | 81.79 | ||||||||||||||
| 88 | 88 | 2023 | Microsoft Azure | indiasouthcentral | India | IN-SO | IND | India South Central | 17.385,78.4867 | 551.31 | 549.72 | ||||||||||||||
| 89 | 89 | 2023 | Microsoft Azure | mexicocentral | Mexico | MX | MX_SIN | Mexico Central | 20.631, -100.428 | ||||||||||||||||
| 90 | 90 | 2023 | Microsoft Azure | spaincentral | Spain | ES | ES | Spain Central | 40.44,-3.679 | 153.86 | 154.56 | ||||||||||||||
| 92 | 92 | 2023 | Microsoft Azure | eastus3 | SOCO | US-SE-SOCO | SOCO | Georgia: East US 3 | 33.76,-84.401 | 435.76 | 440.35 | ||||||||||||||
| 101 | 101 | 2022 | Google Cloud | asia-east2 | Hong Kong | HK | HK | Hong Kong | 22.3,114.2 | 0.28 | 0.0 | 360.0 | 435.36 | 435.36 | |||||||||||
| 102 | 102 | 2022 | Google Cloud | asia-northeast1 | Tokyo | JP-TK | JP_TK | Tokyo | 35.6897,139.692 | 0.16 | 0.0 | 463.0 | 546.82 | 535.9531592 | 554.76 | 536.0 | |||||||||
| 103 | 103 | 2022 | Google Cloud | asia-northeast2 | Kansai | JP-KN | JP_KN | Osaka | 34.6939,135.502 | 0.32 | 0.0 | 383.0 | 420.67 | 550.5322311 | 410.06 | 551.0 | |||||||||
| 104 | 104 | 2022 | Google Cloud | asia-northeast3 | South Korea | KR | KOR | Seoul | 37.56,126.99 | 0.31 | 0.0 | 425.0 | 455.53 | 686.0136038 | 455.52 | 686.0 | |||||||||
| 105 | 105 | 2022 | Google Cloud | asia-south1 | Maharashtra | IN-WE | IND | Mumbai | 19.0761,72.8775 | 0.24 | 0.0 | 555.0 | 747.67 | 679.4097431 | 760.68 | 679.0 | |||||||||
| 106 | 106 | 2022 | Google Cloud | asia-south2 | Uttar Pradesh | IN-NO | IND | Delhi | 28.6092,76.9798 | 0.23 | 0.0 | 632.0 | 552.52 | 679.4097431 | 552.19 | 679.0 | |||||||||
| 108 | 108 | 2022 | Google Cloud | asia-southeast2 | Indonesia | ID | ID | Jakarta | -6.2507,106.869 | 0.13 | 0.0 | 580.0 | 652.36 | 652.36 | |||||||||||
| 109 | 109 | 2022 | Google Cloud | australia-southeast1 | New South Wales | AU-NSW | NEM_NSW | Sydney | -33.8678,151.21 | 0.27 | 0.0 | 538.0 | 586.3 | 770.3638355 | 585.48 | 770.0 | |||||||||
| 110 | 110 | 2022 | Google Cloud | australia-southeast2 | Victoria | AU-VIC | NEM_VIC | Melbourne | -37.8142,144.963 | 0.34 | 0.0 | 490.0 | 534.85 | 664.5903366 | 534.85 | 665.0 | |||||||||
| 111 | 111 | 2022 | Google Cloud | europe-central2 | Poland | PL | PL | Warsaw | 52.23,21.0111 | 0.24 | 0.0 | 738.0 | 882.36 | 852.3941505 | 936.01 | 852.0 | |||||||||
| 113 | 113 | 2022 | Google Cloud | europe-southwest1 | Spain | ES | ES | Madrid | 40.3333,-3.8667 | 0.67 | 0.0 | 160.0 | 220.63 | 370.288102 | 220.31 | 370.0 | |||||||||
| 115 | 115 | 2022 | Google Cloud | europe-west2 | Great Britain | GB | UK | London | 51.726,-0.3 | 0.85 | 0.0 | 166.0 | 220.45 | 427.7283704 | 223.87 | 428.0 | |||||||||
| 116 | 116 | 2022 | Google Cloud | europe-west3 | Germany | DE | DE | Frankfurt | 50.1106,8.6822 | 0.96 | 0.0 | 413.0 | 474.46 | 741.7175367 | 488.94 | 742.0 | |||||||||
| 118 | 118 | 2022 | Google Cloud | europe-west6 | Switzerland | CH | CH | Zurich | 47.3744,8.5411 | 0.85 | 0.0 | 118.0 | 148.39 | 49.5 | |||||||||||
| 119 | 119 | 2022 | Google Cloud | europe-west8 | North Italy | IT-NO | IT | Milan | 45.4669,9.19 | 0.42 | 0.0 | 323.0 | 369.48 | 385.8847276 | 445.96 | 386.0 | |||||||||
| 120 | 120 | 2022 | Google Cloud | europe-west9 | France | FR | FR | Paris | 48.8567,2.3522 | 0.87 | 0.0 | 71.0 | 91.23 | 383.7390836 | 72.0 | 384.0 | |||||||||
| 121 | 121 | 2022 | Google Cloud | europe-west12 | North Italy | IT-NO | IT | Turin | 45.0792,7.6761 | 0.42 | 0.0 | 323.0 | 369.48 | 385.8847276 | 445.96 | 386.0 | |||||||||
| 122 | 122 | 2022 | Google Cloud | me-west1 | Israel | IL | IL | Tel Aviv | 32.0167,34.7667 | 0.02 | 0.0 | 476.0 | 541.78 | 541.78 | |||||||||||
| 123 | 123 | 2022 | Google Cloud | northamerica-northeast1 | Quebec | CA-QC | HQ | Montréal | 45.5089,-73.5617 | 1.0 | 0.0 | 0.0 | 28.22 | 462.2451779 | 27.92 | 462.0 | |||||||||
| 124 | 124 | 2022 | Google Cloud | northamerica-northeast2 | Ontario | CA-ON | IESO_NORTH | Toronto | 43.7417,-79.3733 | 0.9 | 0.0 | 36.0 | 63.01 | 356.8894651 | 63.46 | 357.0 | |||||||||
| 125 | 125 | 2022 | Google Cloud | southamerica-east1 | Central Brazil | BR-CS | BRA | São Paulo | -3.45,-68.95 | 0.89 | 0.0 | 65.0 | 99.93 | 571.4267992 | 103.92 | 571.0 | |||||||||
| 133 | 133 | 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 | |||||||||
| 134 | 134 | 2022 | Google Cloud | us-west3 | PACE | US-NW-PACE | PACE | Salt Lake City | 40.7776,-111.9311 | 0.31 | 0.0 | 606.0 | 658.67 | 664.0421037 | 676.5 | 664.0 | |||||||||
| 141 | 141 | 2022 | Amazon Web Services | ap-east-1 | Hong Kong | HK | HK | Asia Pacific (Hong Kong) | 22.3,114.2 | 0.19 | 435.36 | 435.36 | |||||||||||||
| 142 | 142 | 2022 | Amazon Web Services | ap-south-2 | Hyderabad | IN-SO | IND | Asia Pacific (Hyderabad) | 17.385,78.4867 | 1.0 | 0.19 | 0.0 | 504.69 | 679.4097431 | 501.99 | 679.0 | |||||||||
| 144 | 144 | 2022 | Amazon Web Services | ap-southeast-4 | Victoria | AU-VIC | NEM_VIC | Asia Pacific (Melbourne) | -37.8142,144.963 | 0.19 | 534.85 | 664.5903366 | 534.85 | 665.0 | |||||||||||
| 146 | 146 | 2022 | Amazon Web Services | ap-northeast-3 | Kansai | JP-KN | JP_KN | Asia Pacific (Osaka) | 34.6939,135.502 | 0.19 | 420.67 | 550.5322311 | 410.06 | 551.0 | |||||||||||
| 147 | 147 | 2022 | Amazon Web Services | ap-northeast-2 | South Korea | KR | KOR | Asia Pacific (Seoul) | 37.56,126.99 | 0.19 | 455.53 | 686.0136038 | 455.52 | 686.0 | |||||||||||
| 154 | 154 | 2022 | Amazon Web Services | eu-west-2 | Great Britain | GB | UK | Europe (London) | 51.726,-0.3 | 1.0 | 0.19 | 0.0 | 220.45 | 427.7283704 | 223.87 | 428.0 | |||||||||
| 155 | 155 | 2022 | Amazon Web Services | eu-south-1 | North Italy | IT-NO | IT | Europe (Milan) | 45.4669,9.19 | 1.0 | 0.19 | 0.0 | 369.48 | 385.8847276 | 445.96 | 386.0 | |||||||||
| 156 | 156 | 2022 | Amazon Web Services | eu-west-3 | France | FR | FR | Europe (Paris) | 48.8567,2.3522 | 1.0 | 0.19 | 0.0 | 91.23 | 383.7390836 | 72.0 | 384.0 | |||||||||
| 157 | 157 | 2022 | Amazon Web Services | eu-south-2 | Spain | ES | ES | Europe (Spain) | 40.3333,-3.8667 | 1.0 | 0.19 | 0.0 | 220.63 | 370.288102 | 220.31 | 370.0 | |||||||||
| 159 | 159 | 2022 | Amazon Web Services | eu-central-2 | Switzerland | CH | CH | Europe (Zurich) | 47.3744,8.5411 | 1.0 | 0.19 | 0.0 | 148.39 | 778.7844238 | 49.5 | 779.0 | |||||||||
| 160 | 160 | 2022 | Amazon Web Services | il-central-1 | Israel | IL | IL | Israel (Tel Aviv) | 32.0167,34.7667 | 0.19 | 541.78 | 541.78 | |||||||||||||
| 162 | 162 | 2022 | Amazon Web Services | me-central-1 | United Arab Emirates | AE | AE | Middle East (UAE) | 25.2631,55.2972 | 0.19 | 325.52 | 325.52 | |||||||||||||
| 163 | 163 | 2022 | Amazon Web Services | sa-east-1 | Central Brazil | BR-CS | BRA | South America (São Paulo) | -3.45,-68.95 | 0.19 | 99.93 | 571.4267992 | 103.92 | 571.0 | |||||||||||
| 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.0 | 429.84 | 565.3840343 | 430.11 | 565.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 | |||||||||
| 166 | 166 | 2022 | Amazon Web Services | cn-north-1 | China (Beijing) | 39.904,116.4075 | 1.0 | 0.19 | 0.0 | ||||||||||||||||
| 196 | 196 | 2021 | Google Cloud | asia-east1 | Taiwan | TW | TW | Taiwan | 0.17 | 0.0 | 456.0 | 542.08 | 542.09 | ||||||||||||
| 197 | 197 | 2021 | Google Cloud | asia-east2 | Hong Kong | HK | HK | Hong Kong | 0.28 | 0.0 | 360.0 | 435.36 | 435.36 | ||||||||||||
| 198 | 198 | 2021 | Google Cloud | asia-northeast1 | Tokyo | JP-TK | JP_TK | Tokyo | 0.16 | 0.0 | 464.0 | 549.03 | 557.48 | ||||||||||||
| 199 | 199 | 2021 | Google Cloud | asia-northeast2 | Kansai | JP-KN | JP_KN | Osaka | 0.31 | 0.0 | 384.0 | 402.94 | 394.06 | ||||||||||||
| 200 | 200 | 2021 | Google Cloud | asia-northeast3 | South Korea | KR | KOR | Seoul | 0.31 | 0.0 | 425.0 | 489.38 | 489.38 | ||||||||||||
| 201 | 201 | 2021 | Google Cloud | asia-south1 | Maharashtra | IN-WE | IND | Mumbai | 0.1 | 0.0 | 670.0 | 744.77 | 761.97 | ||||||||||||
| 202 | 202 | 2021 | Google Cloud | asia-south2 | Uttar Pradesh | IN-NO | IND | Delhi | 0.08 | 0.0 | 671.0 | 525.89 | 525.92 | ||||||||||||
| 203 | 203 | 2021 | Google Cloud | asia-southeast1 | Singapore | SG | SGP | Singapore | 0.04 | 0.0 | 372.0 | 491.36 | 491.21 |
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 );