global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette

33,643 rows sorted by owner

View and edit SQL

country_long

primary_fuel

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
1 AFG Afghanistan Kajaki Hydroelectric Power Plant Afghanistan GEODB0040538 33.0 32.322 65.119 Hydro           GEODB http://globalenergyobservatory.org GEODB 1009793 2017              
2 AFG Afghanistan Kandahar DOG WKS0070144 10.0 31.67 65.795 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                  
3 AFG Afghanistan Kandahar JOL WKS0071196 10.0 31.623 65.792 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                  
4 AFG Afghanistan Mahipar Hydroelectric Power Plant Afghanistan GEODB0040541 66.0 34.556 69.4787 Hydro           GEODB http://globalenergyobservatory.org GEODB 1009795 2017              
5 AFG Afghanistan Naghlu Dam Hydroelectric Power Plant Afghanistan GEODB0040534 100.0 34.641 69.717 Hydro           GEODB http://globalenergyobservatory.org GEODB 1009797 2017              
6 AFG Afghanistan Nangarhar (Darunta) Hydroelectric Power Plant Afghanistan GEODB0040536 11.55 34.4847 70.3633 Hydro           GEODB http://globalenergyobservatory.org GEODB 1009787 2017              
7 AFG Afghanistan Northwest Kabul Power Plant Afghanistan GEODB0040540 42.0 34.5638 69.1134 Gas           GEODB http://globalenergyobservatory.org GEODB   2017              
8 AFG Afghanistan Pul-e-Khumri Hydroelectric Power Plant Afghanistan GEODB0040537 6.0 35.9416 68.71 Hydro           GEODB http://globalenergyobservatory.org GEODB   2017              
9 AFG Afghanistan Sarobi Dam Hydroelectric Power Plant Afghanistan GEODB0040535 22.0 34.5865 69.7757 Hydro           GEODB http://globalenergyobservatory.org GEODB 1009799 2017              
10 ALB Albania Bistrica 1 WRI1002169 27.0 39.9116 20.1047 Hydro       1965.0   Energy Charter Secretariat http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Albania_2013_en.pdf GEODB 1021225               89.13207547169813
11 ALB Albania Fierza WRI1002170 500.0 42.2514 20.0431 Hydro       1978.0   Energy Charter Secretariat http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Albania_2013_en.pdf GEODB 1021231               1650.5939902166315
12 ALB Albania Koman WRI1002171 600.0 42.1033 19.8224 Hydro       1985.0   Energy Charter Secretariat http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Albania_2013_en.pdf GEODB 1021233               1980.712788259958
13 ALB Albania Lanabregas WRI1002172 5.0 41.3428 19.8964 Hydro       1951.0   Energy Charter Secretariat http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Albania_2013_en.pdf GEODB 1021236               16.505939902166322
14 ALB Albania Shkopet WRI1002173 24.0 41.6796 19.8305 Hydro       1963.0   Energy Charter Secretariat http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Albania_2013_en.pdf GEODB 1021238               79.22851153039831
15 ALB Albania Ulez WRI1002174 25.0 41.6796 19.8936 Hydro       1958.0   Energy Charter Secretariat http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Albania_2013_en.pdf GEODB 1021241               82.52969951083159
16 ALB Albania Vau i Dijes WRI1002175 250.0 42.0137 19.6359 Hydro       1971.0   Energy Charter Secretariat http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Albania_2013_en.pdf GEODB 1021242               825.2969951083159
17 ALB Albania Vlora WRI1002176 98.0 40.4874 19.434 Other           Energy Charter Secretariat http://www.energycharter.org/fileadmin/DocumentsMedia/IDEER/IDEER-Albania_2013_en.pdf GEODB 1021244               0.0
18 DZA Algeria Adrar WKS0068905 20.0 27.908 -0.317 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
19 DZA Algeria Ain Azel WKS0065285 20.0 35.88 5.475 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
21 DZA Algeria Ain Sekhouna WKS0068919 20.0 34.532 0.804 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
22 DZA Algeria Ain el Ibel I WKS0068916 20.0 34.346 3.164 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
23 DZA Algeria Ain el Ibel II WKS0073479 53.0 34.342 3.169 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
24 DZA Algeria Ain el Melh WKS0068915 20.0 34.861 4.204 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
25 DZA Algeria Algerie Sud-Ouest WKS0068912 43.5 27.908 -0.317 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
27 DZA Algeria Aoulef WKS0068908 5.0 26.9989 1.3351 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
29 DZA Algeria Bir Rebaa WKS0072833 10.0 31.285 8.565 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
30 DZA Algeria Boufarik 1 WRI1023792 100.0 36.5914 2.9223 Gas       1980.0   Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 GEODB 1029484               413.89419592858565
31 DZA Algeria Boufarik 2 WRI1023793 450.0 36.596 2.878 Gas       2016.0   Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 KTH 1029484               1862.523881678635
32 DZA Algeria Boutelilis WRI1023781 450.0 35.5658 -0.9386 Gas       2016.0   Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 GEODB 1099563               1862.523881678635
33 DZA Algeria Chelghoum El Aïd WKS0065282 15.0 36.225 6.11 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
34 DZA Algeria El Kheneg WKS0068917 60.0 33.727 2.811 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
36 DZA Algeria HPC Ouargla WKS0068918 30.0 32.602 5.834 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
43 DZA Algeria Hassi R'mel ISCC WKS0071083 20.0 33.123 3.356 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
44 DZA Algeria Hauts Plateaux Centre WKS0068911 106.6 34.342 3.169 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
45 DZA Algeria Hauts Plateaux Est WKS0065280 73.8 35.68 5.9861 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
47 DZA Algeria In Salah WKS0068914 5.0 27.183 2.504 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
48 DZA Algeria Jijel WRI1023775 588.0 36.8139 5.876 Gas Oil         Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 GEODB 1029500               2433.6978720600832
49 DZA Algeria Kahrama IPP WRI1023784 345.0 35.8064 -0.2476 Gas           Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 GEODB 1051834               1427.93497595362
51 DZA Algeria Labiodh Sidi Cheikh WKS0068921 20.0 32.945 0.555 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
52 DZA Algeria Labreg WRI1023815 396.0 34.5056 6.9848 Gas       2015.0   Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 KTH 1099562               1639.0210158771988
53 DZA Algeria Marsat WRI1023772 840.0 35.8 -0.1924 Gas Oil         Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 GEODB 1029503               3476.711245800119
56 DZA Algeria Naâma WKS0068920 19.9 33.274 -0.372 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
57 DZA Algeria Oued El Kebrit WKS0065281 15.0 35.919 7.87 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
58 DZA Algeria Oued el Ma WKS0065283 20.0 35.68 5.9861 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
59 DZA Algeria Ras Djinet WRI1023774 672.0 36.8509 3.6983 Gas Oil         Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 GEODB 1029505               2781.3689966400952
60 DZA Algeria Ras el Oued WKS0065284 20.0 36.01 5.035 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
61 DZA Algeria Ravin Blanc WRI1023791 73.0 35.7095 -0.6319 Gas Oil     1974.0   Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 GEODB 1029506               302.1427630278675
62 DZA Algeria Reggane WKS0068907 5.0 26.768 0.137 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
67 DZA Algeria Skikda WRI1023786 262.0 36.88 6.935 Gas Oil     1975.0   Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 GEODB 1029507               1084.402793332894
68 DZA Algeria Tamanrasset WKS0068926 13.0 22.849 5.45 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
70 DZA Algeria Tiaret WRI1023782 300.0 35.3396 1.3562 Gas           Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 GEODB 1029509               1241.6825877857566
72 DZA Algeria Tilghemt 2 WRI1023788 600.0 33.1377 3.3678 Gas       2016.0   Arab Union of Electricity http://www.auptde.org/NewsDetails.aspx?lang=en&NID=283 KTH                 2483.365175571513
73 DZA Algeria Timimoun WKS0068909 9.0 29.22 0.223 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
74 DZA Algeria Tindouf WKS0068925 9.0 27.752 -8.154 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
75 DZA Algeria Télagh WKS0068922 12.0 34.692 -0.601 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
76 DZA Algeria Zaouiet Kounta WKS0068906 6.0 27.241 -0.174 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.0
77 AGO Angola Biopio WRI1023002 22.8 -12.4706 13.7319 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1014555               739.2929145361577
78 AGO Angola Biopio (hydro) WRI1023001 14.6 -12.4706 13.7319 Hydro           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1014555               95.50817544770308
79 AGO Angola Cambambe WRI1023003 180.0 -9.7523 14.4809 Hydro           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 1177.4980534648325
80 AGO Angola Capanda WRI1023004 520.0 -9.7955 15.4672 Hydro           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1014558               3401.6610433428496
81 AGO Angola Cazenga WRI1023005 132.0 -8.8383 13.2344 Gas           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1014567               0.0
82 AGO Angola Huambo WRI1023006 16.26 -12.76 15.75 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 527.2325785244706
83 AGO Angola Lobito WRI1023007 20.0 -12.37 13.57 Gas           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1014566               0.0
84 AGO Angola Luanda Diesel WRI1023008 58.0 -8.8383 13.2344 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1104965               1880.657414170928
85 AGO Angola Luanda Refinery WRI1023009 18.5 -8.8383 13.2344 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1017037               599.8648648648649
86 AGO Angola Malongo WRI1023010 10.0 -5.55 12.2 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 324.2512783053324
87 AGO Angola Matala WRI1023011 40.0 -14.7333 15.0333 Hydro           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1014569               261.66623410329606
88 AGO Angola Namibe WRI1023012 11.68 -15.1961 12.1522 Gas           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 0.0
89 AGO Angola Rio Luachimo WRI1023013 16.0 -7.3 20.85 Hydro           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa                 104.66649364131844
90 AGO Angola Xitoto WRI1023014 11.34 -15.3333 15.0 Oil           African Development Bank Group http://powerafrica.opendataforafrica.org Power Africa 1020267               367.70094959824684
91 ATA Antarctica McMurdo Station Generator WRI1023843 6.6 -77.847 166.6605 Oil       1981.0   Antarctica Australia http://www.antarctica.gov.au/__data/assets/pdf_file/0007/21949/ml_385474997916667_atcm28_att067_rev1_e.pdf WRI 1109648                
219 ARG Argentina Cafayate WKS0071212 80.0 -26.04 -65.93 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.4820632150475084
220 ARG Argentina Caldenes del Oeste WKS0072494 30.0 -33.61 -65.445 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.9307737056428156
221 ARG Argentina Cauchari WKS0068701 300.0 -23.8 -66.8 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 9.307737056428156
249 ARG Argentina Iglesia-Guañizuil WKS0072502 80.0 -30.34 -69.27 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 2.4820632150475084
318 ARG Argentina Saujil WKS0071209 22.5 -28.165 -66.225 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 0.6980802792321116
351 AUS Australia Bannerton WKS0069929 88.0 -34.66 142.785 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 127.45130425938021
353 AUS Australia Barcaldine KDB WKS0065252 20.0 -23.549 145.318 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 28.96620551349549
354 AUS Australia Barcaldine YD WKS0069521 10.9 -23.5388 145.2732 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.786582004855047
364 AUS Australia Beryl AU WKS0069215 87.0 -32.353 149.468 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 126.00299398370542
378 AUS Australia Brisbane BNE WKS0070137 6.0 -27.404 153.11 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 8.68986165404865
388 AUS Australia Bungala I WKS0066021 110.0 -32.427 137.838 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 159.31413032422526
389 AUS Australia Bungala II WKS0070392 110.0 -32.408 137.841 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 159.31413032422526
412 AUS Australia Carnarvon AUS0000386 15.0 -24.8692 113.6754 Gas           Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure 1030183   49.04416666666667 47.90805555555556 46.08027777777777 44.69055555555556 41.24111111111111 Australia Clean Energy Regulator  
415 AUS Australia Cawse Nickel Mine AUS0000415 21.0 -30.3808 121.1635 Gas           Australian Renewable Energy Mapping Infrastructure http://services.ga.gov.au/site_3/rest/services/Electricity_Infrastructure/MapServer Australian Renewable Energy Mapping Infrastructure                 52.95674358735643
420 AUS Australia Childers WKS0068499 75.0 -25.28 152.38 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 108.62327067560813
422 AUS Australia Clare WKS0066602 100.0 -19.838 147.206 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 144.8310275674775
425 AUS Australia Clermont WKS0072176 89.0 -22.84 147.58 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 128.89961453505495
434 AUS Australia Collinsville WKS0062502 42.5 -20.54 147.8 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 61.55318671617794
447 AUS Australia Darling Downs WKS0067791 200.0 -27.1 150.9 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 289.662055134955
450 AUS Australia Darwin DRW WKS0068285 4.0 -12.4157 130.8908 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 5.7932411026991
451 AUS Australia DeGrussa WKS0065085 10.6 -25.55 119.317 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 15.352088922152614
457 AUS Australia Dubbo WKS0064626 30.0 -32.273 148.658 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 43.44930827024325
464 AUS Australia Emerald WKS0069477 68.0 -23.495 148.135 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 98.4850987458847
465 AUS Australia Emu Downs WKS0068582 20.0 -30.489 115.416 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 28.96620551349549
476 AUS Australia Gannawarra WKS0065077 50.0 -35.732 143.784 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 72.41551378373875
483 AUS Australia Goondiwindi WKS0069520 4.5 -28.325 150.375 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 6.517396240536487
489 AUS Australia Griffith WKS0064627 60.0 -34.317 146.119 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 86.8986165404865
490 AUS Australia Gullen WKS0068350 10.0 -34.61 149.476 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.48310275674775
500 AUS Australia Hamilton QLD WKS0069201 57.5 -20.468 147.743 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 83.27784085129954

Next page

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");
Powered by Datasette · Query took 3555.719ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette