home / global-power-plants

Menu
  • GraphQL API

global-power-plants

Table actions
  • GraphQL API for global-power-plants

13 rows where owner = "Landsvirkjun"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commissioning_year

primary_fuel 2

  • Hydro 11
  • Geothermal 2

owner 1

  • Landsvirkjun · 13 ✖

country_long 1

  • Iceland 13
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
14033 14033 ISL Iceland Bjarnarflag WRI1002788 3.0 65.6408 -16.8565 Geothermal       1969.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1021789               27.47202797202797
14034 14034 ISL Iceland Blanda WRI1002790 150.0 65.4158 -19.8198 Hydro       1991.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1021790               1009.5942695806757
14035 14035 ISL Iceland Búrfell WRI1002792 270.0 64.1052 -19.8335 Hydro       1969.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1021791               1817.2696852452161
14036 14036 ISL Iceland Búðarháls WRI1002791 95.0 64.2355 -19.3707 Hydro         Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1053246               639.4097040677611
14037 14037 ISL Iceland Fljótsdalsvirkjun (Kárahnjúkar ) WRI1002794 690.0 64.9471 -15.7931 Hydro       2008.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1050261               4644.133640071108
14039 14039 ISL Iceland Hrauneyjafoss WRI1002797 210.0 64.2009 -19.2406 Hydro       1981.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1021792               1413.4319774129458
14040 14040 ISL Iceland Krafla WRI1002800 60.0 65.7035 -16.7735 Geothermal       1977.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1021794               549.4405594405595
14042 14042 ISL Iceland Laxárvirkjun 3 WRI1002802 14.0 65.8182 -17.314 Hydro       1973.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI                 94.22879849419638
14043 14043 ISL Iceland Ljósafossvirkjun WRI1002803 14.6 64.0944 -21.0107 Hydro       1937.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1021796               98.2671755725191
14047 14047 ISL Iceland Steingrímsstöð WRI1002808 26.0 64.129 -21.0266 Hydro       1959.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1021798               174.99634006065045
14048 14048 ISL Iceland Sultartangi WRI1002809 120.0 64.1672 -19.6212 Hydro       1999.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1040191               807.6754156645405
14050 14050 ISL Iceland Vatnsfell WRI1002811 90.0 64.1966 -19.0341 Hydro       2001.0 Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1046120               605.7565617484054
14051 14051 ISL Iceland Írafoss WRI1002799 48.0 64.0875 -21.0077 Hydro         Landsvirkjun Iceland Energy Portal http://gilslaug.orkugardur.is/vefsja/orkuvefsja_en.html WRI 1021793               323.07016626581617

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 · How this site works · Code of conduct