global-power-plants

Table actions

12 rows where country_long = "Macedonia"

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 2

country_long 1

  • Macedonia · 12 ✖

owner 0

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
17164 17164 MKD Macedonia Bitola Coal Power Plant Macedonia GEODB0042700 675.0 41.058 21.4832 Coal           GEODB http://globalenergyobservatory.org GEODB 1014452 2017             3153.09375
17165 17165 MKD Macedonia Globocica (Crn Drim) Hydroelectric Power Plant Macedonia GEODB0042704 42.0 41.3371 20.6347 Hydro           GEODB http://globalenergyobservatory.org GEODB 1014456 2017             90.1066477070743
17166 17166 MKD Macedonia Kalimantsi Hydroelectric Power Plant Macedonia GEODB0044852 12.6 41.9712 22.5781 Hydro           GEODB http://globalenergyobservatory.org GEODB   2017             27.031994312122286
17167 17167 MKD Macedonia Kozjak Hydroelectric Power Plant Macedonia GEODB0042705 80.0 41.8792 21.1921 Hydro           GEODB http://globalenergyobservatory.org GEODB 1014468 2017             171.63170991823682
17168 17168 MKD Macedonia Matka Hydroelectric Power Plant Macedonia GEODB0044851 9.6 41.9528 21.2982 Hydro           GEODB http://globalenergyobservatory.org GEODB 1052114 2017             20.59580519018841
17169 17169 MKD Macedonia Oslomej Coal Power Plant Macedonia GEODB0042701 125.0 41.5824 21.0006 Coal           GEODB http://globalenergyobservatory.org GEODB 1039351 2017             583.90625
17170 17170 MKD Macedonia Raven Hydroelectric Power Plant Macedonia GEODB0042709 19.2 41.7791 20.8563 Hydro           GEODB http://globalenergyobservatory.org GEODB 1014462 2017             41.19161038037682
17171 17171 MKD Macedonia Spilje Hydroelectric Power Plant Macedonia GEODB0042703 84.0 41.4936 20.5054 Hydro           GEODB http://globalenergyobservatory.org GEODB 1014464 2017             180.2132954141486
17172 17172 MKD Macedonia Sveta Peka Hydroelectric Power Plant Macedonia GEODB0044849 36.4 41.9249 21.2647 Hydro           GEODB http://globalenergyobservatory.org GEODB   2017             78.09242801279774
17173 17173 MKD Macedonia Tikves Hydroelectric Power Plant Macedonia GEODB0042706 116.0 41.4035 21.9373 Hydro           GEODB http://globalenergyobservatory.org GEODB 1014465 2017             248.86597938144337
17174 17174 MKD Macedonia Vrben Hydroelectric Power Plant Macedonia GEODB0042707 12.8 41.7166 20.7219 Hydro           GEODB http://globalenergyobservatory.org GEODB 1014467 2017             27.46107358691789
17175 17175 MKD Macedonia Vrutok Hydroelectric Power Plant Macedonia GEODB0042708 150.0 41.7707 20.8377 Hydro           GEODB http://globalenergyobservatory.org GEODB 1014460 2017             321.809456096694

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