cloud_regions_metadata

10 rows where cfe-region = "New South Wales"

✎ 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
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              
53 53 2023 Amazon Web Services ap-southeast-2 New South Wales AU-NSW NEM_NSW Asia Pacific (Sydney) -33.8678,151.21     1.15 0.18     545.01   546.1              
78 78 2023 Microsoft Azure australiaeast New South Wales AU-NSW NEM_NSW Australia East -33.889, 151.067             545.01   546.1              
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            
149 149 2022 Amazon Web Services ap-southeast-2 New South Wales AU-NSW NEM_NSW Asia Pacific (Sydney) -33.8678,151.21     1.15 0.19     586.3 770.3638355 585.48 770.0            
174 174 2022 Microsoft Azure australiaeast New South Wales AU-NSW NEM_NSW Australia East -33.889, 151.067   0.28 1.12 0.012     586.3   585.48              
205 205 2021 Google Cloud australia-southeast1 New South Wales AU-NSW NEM_NSW Sydney   0.21       0.0 598.0 654.6   652.27              
243 243 2021 Amazon Web Services ap-southeast-2 New South Wales AU-NSW NEM_NSW Asia Pacific (Sydney)               654.6   652.27              
269 269 2020 Google Cloud australia-southeast1 New South Wales AU-NSW NEM_NSW Sydney   0.11       0.0 727.0 692.71   692.61              
295 295 2019 Google Cloud australia-southeast1 New South Wales AU-NSW NEM_NSW Sydney   0.11       0.0 725.0 711.83   711.82              

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