global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute

58 rows where year_of_capacity_data = 2000

View and edit SQL

primary_fuel

year_of_capacity_data

  • 2000 · 58

country_long

other_fuel1

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 estimated_generation_gwh
3483 CAN Canada Avon 1 CAN0007635 4.6 44.8815 -64.2173 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           21.81178686960077
3484 CAN Canada Avon 2 CAN0007636 3.5 44.8732 -64.2288 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           16.595924792087544
3525 CAN Canada Big Eddy Inco CAN0007672 27.6 46.3839 -81.5781 Hydro         Vale Canada Limited/Vale Canada Limi Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 22926 2000           130.87072121760463
3526 CAN Canada Big Falls CAN0007673 10.6 44.138 -64.9353 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28480 2000           50.26194365603656
3531 CAN Canada Bishops Falls CAN0007678 14.4 49.0154 -55.4722 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 49151 2000           68.28037628744589
3574 CAN Canada Buchans CAN0007711 1.8 48.822 -56.8314 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           8.535047035930736
3614 CAN Canada Catalyst Paper Port Alberni CAN0007738 17.0 49.2474 -124.8112 Biomass           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 25341 2000           31.558408402932287
3676 CAN Canada Cowie Falls CAN0007786 7.4 44.0744 -64.7707 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28483 2000           35.08852670327081
3680 CAN Canada Crowe Bay CAN0007789 2.0 44.3353 -77.7723 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 15454 2000           9.483385595478595
3699 CAN Canada Deep Brook CAN0007802 9.1 44.0805 -64.7909 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28485 2000           43.149404459427615
3706 CAN Canada Dickie Brook CAN0007808 2.6 45.3492 -61.5032 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28484 2000           12.328401274122177
3725 CAN Canada Eagle River CAN0007825 1.8 49.7911 -93.1969 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 33958 2000           8.535047035930736
3738 CAN Canada Eddy Ottawa (Powerhouses 2 & 3) CAN0007837 9.2 45.4208 -75.7185 Hydro         Energy Ottawa Inc Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 18963 2000           43.62357373920154
3753 CAN Canada Espanola Mill CAN0007849 25.0 46.2691 -81.7672 Biomass           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 18966 2000           46.40942412195924
3757 CAN Canada Fenelon Falls CAN0007853 2.6 44.5356 -78.7373 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 55361 2000           12.328401274122177
3774 CAN Canada Fourth Lake CAN0007865 2.2 44.3696 -65.7193 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28489 2000           10.431724155026457
3797 CAN Canada Gisborne CAN0007884 3.5 46.5677 -60.5252 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28487 2000           16.595924792087544
3862 CAN Canada Hells Gate CAN0007937 6.8 45.0466 -64.4121 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28490 2000           32.243511024627225
3869 CAN Canada High Falls (Worthington) CAN0007944 19.3 46.3792 -81.5696 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           91.51467099636845
3872 CAN Canada Hinton Pulp CAN0007947 52.0 53.4153 -117.5717 Biomass           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           96.5316021736752
3876 CAN Canada Hollow Bridge CAN0007951 5.3 45.0036 -64.3764 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28493 2000           25.13097182801828
3923 CAN Canada Kapuskasing CAN0007992 2.8 49.4131 -82.4299 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           13.276739833670035
4010 CAN Canada Lower Great Brook CAN0008068 3.9 44.09 -64.848 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28498 2000           18.492601911183268
4011 CAN Canada Lower Lake Falls CAN0008069 7.2 44.1577 -64.9772 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28499 2000           34.140188143722945
4013 CAN Canada Lower St Croix CAN0008071 3.0 44.9613 -64.0331 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           14.225078393217895
4015 CAN Canada Lumsden CAN0008073 2.8 45.0275 -64.3967 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28495 2000           13.276739833670035
4025 CAN Canada Malay Falls CAN0008081 3.0 44.9877 -62.4841 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28501 2000           14.225078393217895
4049 CAN Canada McKenzie Falls CAN0008104 1.1 49.8047 -93.1887 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 33960 2000           5.215862077513228
4068 CAN Canada Methals CAN0008118 3.0 44.9397 -64.4315 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28502 2000           14.225078393217895
4077 CAN Canada Mill Lake CAN0008126 2.2 44.7116 -63.8962 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28503 2000           10.431724155026457
4084 CAN Canada Miramichi CAN0008132 42.0 46.9697 -65.5943 Biomass           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 26540 2000           77.96783252489152
4112 CAN Canada Nairn CAN0008153 4.5 46.344 -81.5734 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 22928 2000           21.337617589826838
4122 CAN Canada Nictaux CAN0008163 7.2 44.9091 -65.0299 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28504 2000           34.140188143722945
4168 CAN Canada Outlet Works CAN0008206 20.5 52.9626 -115.5891 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 34865 2000           97.20470235365562
4170 CAN Canada Paradise CAN0008208 4.2 44.8117 -65.2186 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           19.915109750505053
4189 CAN Canada Peterborough Robert G. Lake CAN0008226 8.0 44.3653 -78.2928 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           37.93354238191439
4213 CAN Canada Port Alice CAN0008241 26.1 50.3839 -127.4509 Biomass         Neucel Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 36715 2000           48.451438783325436
4257 CAN Canada Rattle Brook CAN0008276 4.0 49.8876 -56.8359 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 12856 2000           18.966771190957196
4271 CAN Canada Ridge CAN0008290 3.5 44.5538 -65.583 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28509 2000           16.595924792087544
4292 CAN Canada Ruth Falls CAN0008312 7.1 44.9341 -62.5005 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28511 2000           33.66601886394901
4301 CAN Canada Saint John CAN0008317 29.7 45.2589 -66.0945 Biomass           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           55.13439585688757
4320 CAN Canada Sandy Lake CAN0008334 3.6 44.7116 -63.896 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28510 2000           17.070094071861472
4365 CAN Canada Sissiboo Falls CAN0008371 5.3 44.4308 -65.8722 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28512 2000           25.13097182801828
4459 CAN Canada Taylor Lumber CAN0008458 1.2 45.0447 -63.1389 Biomass           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           2.2276523578540437
4462 CAN Canada Tennant Lake CAN0008461 3.1 49.5674 -125.6215 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 36782 2000           14.699247672991824
4463 CAN Canada Terrace Bay CAN0008462 20.0 48.7975 -87.1066 Biomass           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 61576 2000           37.12753929756739
4466 CAN Canada The Pas Mill CAN0008465 22.8 53.8615 -101.2175 Biomass           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           42.32539479922683
4467 CAN Canada Thelwood CAN0008466 8.2 49.5424 -125.5642 Hydro         Boliden Westmin Ltd Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 36783 2000           38.88188094146224
4492 CAN Canada Tusket CAN0008487 2.7 43.8821 -65.9778 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           12.802570553896105
4507 CAN Canada Upper Lake Falls CAN0008499 5.4 44.1574 -64.9984 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28516 2000           25.60514110779221
4511 CAN Canada Upper St Croix CAN0008502 2.0 44.9267 -64.0394 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           9.483385595478595
4529 CAN Canada Wainwright Falls CAN0008516 1.1 49.8217 -92.8763 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 33961 2000           5.215862077513228
4548 CAN Canada Wawatay CAN0008534 13.5 48.6604 -86.2325 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 17591 2000           64.01285276948052
4552 CAN Canada Welland CAN0008538 12.0 43.1547 -79.1924 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 33509 2000           56.90031357287158
4565 CAN Canada Weymouth Falls CAN0008550 19.2 44.4075 -65.9491 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28522 2000           91.04050171659452
4567 CAN Canada Whistler CAN0008552 7.6 50.1062 -122.9458 Hydro         Rockford Energy Corp Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2000           36.036865262818665
4570 CAN Canada White River CAN0008554 7.5 48.594 -85.3008 Biomass           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 48116 2000           13.922827236587773
4571 CAN Canada White Rock CAN0008555 2.9 45.0623 -64.3807 Hydro           Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 28523 2000           13.750909113443965

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,
  "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 1683.89ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute