global-power-plants

Table actions

29 rows where owner = "Ceylon Electricity Board"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, source, url, estimated_generation_gwh

primary_fuel 3

owner 1

  • Ceylon Electricity Board · 29 ✖

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