global-power-plants

Table actions

11 rows where owner = "Snowy Hydro Ltd"

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 2

owner 1

  • Snowy Hydro Ltd · 11 ✖

country_long 1

Link rowid ▼ country country_long name gppd_idnr capacity_mw latitude longitude primary_fuel other_fuel1 other_fuel2 other_fuel3 commissioning_year owner source url geolocation_source wepp_id year_of_capacity_data generation_gwh_2013 generation_gwh_2014 generation_gwh_2015 generation_gwh_2016 generation_gwh_2017 generation_data_source estimated_generation_gwh
367 367 AUS Australia Blowering AUS0000267 70.0 -35.3986 148.2463 Hydro         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1029076               61.57523263498189
493 493 AUS Australia Guthega AUS0000303 80.0 -36.3501 148.4135 Hydro         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1029077               70.3716944399793
518 518 AUS Australia Jindabyne Dam Mini Hydro AUS0000021 1.1 -36.4351 148.6333 Hydro         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1029078               0.9676107985497154
520 520 AUS Australia Jounama AUS0000038 14.0 -35.562 148.3055 Hydro         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1066821               12.315046526996374
561 561 AUS Australia Laverton North AUS0000090 312.0 -37.8416 144.7887 Gas         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1053207   14.818888888888885 15.807777777777776 1.1441666666666668 22.43138888888889 79.52083333333333 Australia Clean Energy Regulator  
622 622 AUS Australia Murray 1 AUS0000107 950.0 -36.2467 148.1901 Hydro         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1029079               835.663871474754
623 623 AUS Australia Murray 2 AUS0000106 552.0 -36.2423 148.1362 Hydro         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1029080               485.5646916358572
755 755 AUS Australia Tumut 1 (Upper Tumut) AUS0000292 616.0 -35.9517 148.3637 Hydro         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1029081               541.8620471878405
756 756 AUS Australia Tumut 2 (Upper Tumut) AUS0000293 336.0 -35.8814 148.3672 Hydro         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1060516               295.56111664791314
757 757 AUS Australia Tumut 3 AUS0000031 1500.0 -35.6112 148.2917 Hydro         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1029082               1319.4692707496115
765 765 AUS Australia Valley (Peaking Facility) AUS0000098 300.0 -38.2536 146.5892 Gas         Snowy Hydro Ltd Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure     11.844722222222224 8.896666666666668 5.198611111111111 10.677777777777775 4.109444444444445 Australia Clean Energy Regulator  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "global-power-plants" (
"country" TEXT,
  "country_long" TEXT,
  "name" TEXT,
  "gppd_idnr" TEXT,
  "capacity_mw" REAL,
  "latitude" REAL,
  "longitude" REAL,
  "primary_fuel" TEXT,
  "other_fuel1" TEXT,
  "other_fuel2" TEXT,
  "other_fuel3" TEXT,
  "commissioning_year" REAL,
  "owner" TEXT,
  "source" TEXT,
  "url" TEXT,
  "geolocation_source" TEXT,
  "wepp_id" TEXT,
  "year_of_capacity_data" INTEGER,
  "generation_gwh_2013" REAL,
  "generation_gwh_2014" REAL,
  "generation_gwh_2015" REAL,
  "generation_gwh_2016" REAL,
  "generation_gwh_2017" REAL,
  "generation_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");