global-power-plants

Table actions

48 rows where country_long = "Sri Lanka"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, capacity_mw, longitude, source, url, geolocation_source, wepp_id, estimated_generation_gwh

primary_fuel 5

country_long 1

  • Sri Lanka · 48 ✖
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
20965 20965 LKA Sri Lanka Ambewela Aitken Spence WRI1030392 3.0 6.8432 80.813 Wind         Ace Wind Power Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI 1097894               6.325581395348836
20966 20966 LKA Sri Lanka Asia Power Sapugaskanda WRI1030443 51.0 6.9561 79.9483 Oil         Ceylon Electricity Board Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI 1010411               185.12365145228213
20967 20967 LKA Sri Lanka Bowatenna WRI1030424 40.0 7.6642 80.6772 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1012076               126.29534577235208
20968 20968 LKA Sri Lanka Broadlands WRI1030426 35.0 6.9788 80.4546 Hydro       2017.0 Ceylon Electricity Board Ceylon Electricity Board https://web.archive.org/web/20131004212909/http://www.bhpceb.lk/index_files/Page379.htm WRI                 110.50842755080808
20969 20969 LKA Sri Lanka CEB Kelantitissa WRI1030436 382.0 6.9522 79.8789 Oil       1982.0 Ceylon Electricity Board Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI                 1386.6124481327802
20970 20970 LKA Sri Lanka Canyon WRI1030420 60.0 6.8691 80.5277 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1012077               189.4430186585281
20971 20971 LKA Sri Lanka Colombo Port WRI1030442 60.0 6.9533 79.8558 Oil         Ceylon Electricity Board Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI 1039867               217.79253112033194
20972 20972 LKA Sri Lanka Deduru Oya WRI1030432 1.5 7.7183 80.2744 Hydro         Ceylon Electricity Board Sunday Observer https://web.archive.org/web/20160304112703/http://www.sundayobserver.lk/2014/05/18/fea04.asp WRI                 4.736075466463203
20973 20973 LKA Sri Lanka Hambantota WRI1030408 20.0 6.2312 81.0853 Solar         LAUGFS Holdings Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI                 9.00900900900901
20974 20974 LKA Sri Lanka Hambantota WRI1030393 3.0 6.1461 81.1131 Wind         CEB Wind Energy Resource Atlas of Sri Lanka http://www.nation.lk/2008/12/14/eyefea7.htm WRI 1023824               6.325581395348836
20975 20975 LKA Sri Lanka Hambantota I WKS0064145 14.4 6.23 81.08 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 6.486486486486488
20976 20976 LKA Sri Lanka Inginiyagala WRI1030428 11.0 7.6674 80.6668 Hydro       1951.0 Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1012080               34.73122008739682
20977 20977 LKA Sri Lanka Kotmale WRI1030412 201.0 7.0611 80.5971 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1022224               634.6341125060693
20978 20978 LKA Sri Lanka Kukule Ganga WRI1030418 80.0 6.617 80.2757 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI                 252.59069154470416
20979 20979 LKA Sri Lanka Lakdhanavi WRI1030447 24.0 6.9573 79.9526 Oil         Ceylon Electricity Board Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI                 87.11701244813277
20980 20980 LKA Sri Lanka Lakvijaya WRI1030452 900.0 8.0178 79.7232 Coal       2013.0 Ceylon Electricity Board Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI                 3202.0
20981 20981 LKA Sri Lanka Madurankuliya WRI1030394 12.0 8.0128 79.7269 Wind         Daily Life Renewable Energy Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI                 25.302325581395344
20982 20982 LKA Sri Lanka Mampuri-I WRI1030395 10.0 8.0074 79.7243 Wind         Senok Wind Power Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI 1051030               21.08527131782945
20983 20983 LKA Sri Lanka Mampuri-II WRI1030396 10.5 7.9764 79.7316 Wind         Senok Wind Energy Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI 1051030               22.139534883720927
20984 20984 LKA Sri Lanka Mampuri-III WRI1030397 10.5 8.0055 79.7308 Wind         Senok Wind Resource Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI 1051030               22.139534883720927
20985 20985 LKA Sri Lanka Maskelioya WRI1030431 2.0 6.9768 80.4553 Hydro         Renewgen RenewGen http://www.renewgen.lk/upcoming-projects/ WRI 1112839               6.314767288617603
20986 20986 LKA Sri Lanka Moragahakanda WRI1030427 25.0 7.6994 80.7699 Hydro         Ceylon Electricity Board Sri Lanka Foundation https://srilankafoundation.org/newsfeed/moragahakanda-hydro-electricity-plant-ready-to-generate-electricity/ WRI                 78.93459110772005
20987 20987 LKA Sri Lanka Nala Danavi WRI1030399 4.8 8.0897 79.7092 Wind         Nala Danavi Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI                 10.120930232558138
20988 20988 LKA Sri Lanka New Laxapana WRI1030417 100.0 6.9181 80.4949 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1012085               315.7383644308802
20989 20989 LKA Sri Lanka Nilambe WRI1030430 3.2 7.1966 80.6121 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1012086               10.103627661788169
20990 20990 LKA Sri Lanka Nirmalapura WRI1030400 10.5 7.9544 79.7411 Wind         Nirmalapura Wind Power Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI 1083744               22.139534883720927
20991 20991 LKA Sri Lanka Northern Power WRI1030444 36.0 9.7387 80.0346 Oil         Ceylon Electricity Board Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI                 130.67551867219922
20992 20992 LKA Sri Lanka Old Laxapana WRI1030423 50.0 9.919 80.4894 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1012084               157.8691822154401
20993 20993 LKA Sri Lanka Pawan Danavi WRI1030401 10.2 8.049 79.719 Wind         Pawan Danavi Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI                 21.50697674418604
20994 20994 LKA Sri Lanka Pollupalai WRI1030402 12.0 9.5778 80.32 Wind         Joule Power Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI                 25.302325581395344
20995 20995 LKA Sri Lanka Polpitiya WRI1030419 75.0 6.5842 80.8081 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1012087               236.80377332316016
20996 20996 LKA Sri Lanka Randenigala WRI1030414 126.0 7.2024 80.9259 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1022226               397.8303391829089
20997 20997 LKA Sri Lanka Rantembe WRI1030421 52.0 7.2013 80.9506 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1022227               164.1839495040577
20998 20998 LKA Sri Lanka Sagasolar WKS0068796 10.0 6.232 81.087 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 4.504504504504505
20999 20999 LKA Sri Lanka Samanala WRI1030415 124.0 6.9778 80.4567 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1044345               391.5155718942914
21000 21000 LKA Sri Lanka Sapugaskanda WRI1030439 160.0 6.961 79.9608 Oil       1984.0 Ceylon Electricity Board Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI 1012088               580.7800829875519
21001 21001 LKA Sri Lanka Seguwantivu WRI1030403 9.6 8.0538 79.8083 Wind         Seguwantivu Wind Power Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI 1079790               20.241860465116275
21002 21002 LKA Sri Lanka Sojitz Kelanitissa WRI1030437 168.0 6.9523 79.8789 Oil       2005.0 Sojitz Corporation Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI 1012082               609.8190871369295
21003 21003 LKA Sri Lanka Udawalawe WRI1030429 6.0 6.4319 80.8506 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1012089               18.944301865852808
21004 21004 LKA Sri Lanka Ukuwela WRI1030425 40.0 7.3989 80.6522 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1022228               126.29534577235208
21005 21005 LKA Sri Lanka Upper Kotmale WRI1030413 150.0 7.0433 80.658 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1022229               473.6075466463203
21006 21006 LKA Sri Lanka Uppudaluwa WRI1030404 10.5 7.9811 79.7758 Wind         PowerGen Lanka Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI                 22.139534883720927
21007 21007 LKA Sri Lanka Uthuru Janani WRI1030448 24.0 9.7411 80.0333 Oil         Ceylon Electricity Board Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI                 87.11701244813277
21008 21008 LKA Sri Lanka Vallimunai WRI1030405 12.0 9.5675 80.3367 Wind         Beta Power Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI                 25.302325581395344
21009 21009 LKA Sri Lanka Victoria WRI1030411 210.0 7.1999 80.8069 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1022230               663.0505653048484
21010 21010 LKA Sri Lanka Vidatamunai WRI1030406 10.4 8.0667 79.7939 Wind         Vidatamunai Wind Power Public Utilities Commission of Sri Lanka http://www.pucsl.gov.lk/english/industries/electricity/license-applications/#tab3 WRI 1079789               21.928682170542636
21011 21011 LKA Sri Lanka Wimalasurendra WRI1030422 50.0 6.9083 80.5247 Hydro         Ceylon Electricity Board Ministry of Power and Renewable Energy http://powermin.gov.lk/english/?page_id=1507 WRI 1012090               157.8691822154401
21012 21012 LKA Sri Lanka Yugadanavi WRI1030438 300.0 7.0122 79.874 Oil       2007.0 Ceylon Electricity Board Ceylon Electricity Board http://www.ceb.lk/knowledge-center/#tab-1442494805846-7-1 WRI 1053869               1088.9626556016597

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