global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette

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 generation_data_source estimated_generation_gwh
3638 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
3639 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
3680 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
3681 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
3686 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
3730 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
3770 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
3832 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
3836 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
3855 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
3862 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
3881 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
3894 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
3909 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
3913 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
3930 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
3953 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
4018 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
4025 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
4028 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
4032 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
4079 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
4166 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
4167 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
4169 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
4172 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
4182 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
4206 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
4225 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
4235 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
4242 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
4270 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
4281 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
4327 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
4329 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
4348 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
4372 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
4416 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
4430 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
4451 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
4460 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
4479 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
4524 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
4619 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
4622 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
4623 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
4626 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
4627 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
4652 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
4667 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
4671 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
4689 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
4708 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
4712 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
4725 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
4727 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
4730 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
4731 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,
  "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 · Query took 1570.006ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette