global-power-plants

Table actions

18 rows where owner = "Brookfield White Pine Hydro LLC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: wepp_id

primary_fuel 1

owner 1

  • Brookfield White Pine Hydro LLC · 18 ✖

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
24851 24851 USA United States of America Androscoggin 3 USA0001480 3.6 44.1353 -70.2015 Hydro       1928.0 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15881 2017 26.22 31.136 14.652 0.0 0.0 U.S. Energy Information Administration  
25016 25016 USA United States of America Aziscohos Hydroelectric Project USA0050999 6.7 44.9439 -70.9975 Hydro       1988.0 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 17368 2017 30.624 32.025 33.236000000000004 28.703000000000003 35.46 U.S. Energy Information Administration  
25081 25081 USA United States of America Bar Mills USA0001481 4.0 43.6136 -70.5525 Hydro       1956.0 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15882 2017 13.433 11.522 4.973 6.332999999999999 5.246 U.S. Energy Information Administration  
25406 25406 USA United States of America Bonny Eagle USA0001482 7.2 43.6877 -70.6116 Hydro       1910.0 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15886 2017 44.27 47.051 38.064 39.288 40.847 U.S. Energy Information Administration  
25543 25543 USA United States of America Brunswick Hydro USA0001483 19.6 43.9205 -69.9678 Hydro       1982.3571428571427 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15885 2017 91.351 99.631 86.96600000000002 78.718 83.70100000000002 U.S. Energy Information Administration  
25881 25881 USA United States of America Cataract Hydro USA0001486 6.6 43.4956 -70.4472 Hydro       1937.0 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 33.143 37.579 30.686999999999998 23.381 25.529 U.S. Energy Information Administration  
25975 25975 USA United States of America Charles E Monty USA0000805 28.4 44.0995 -70.2209 Hydro       1990.0 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15890 2017 120.772 152.599 137.998 125.39399999999999 134.48 U.S. Energy Information Administration  
26565 26565 USA United States of America Deer Rips USA0001488 6.5 44.1346 -70.2037 Hydro       1913.292307692308 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15893 2017 33.192 37.602 39.69 35.569 27.674 U.S. Energy Information Administration  
27760 27760 USA United States of America Gulf Island USA0001491 19.200000000000006 44.1529 -70.2094 Hydro       1926.0 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15898 2017 125.82799999999999 141.869 130.20600000000002 121.35799999999999 134.951 U.S. Energy Information Administration  
27865 27865 USA United States of America Harris Hydro USA0001492 76.4 45.4592 -69.8658 Hydro       1954.4109947643976 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15897 2017 211.024 207.99200000000002 195.368 181.609 244.278 U.S. Energy Information Administration  
28038 28038 USA United States of America Hiram USA0001493 10.5 43.8525 -70.7969 Hydro       1969.4571428571426 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15899 2017 44.23 49.619 42.501000000000005 40.798 39.053000000000004 U.S. Energy Information Administration  
29952 29952 USA United States of America North Gorham USA0001501 2.2 43.8025 -70.4499 Hydro       1925.0 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15907 2017 8.812999999999999 10.404000000000002 8.273 9.712 10.383 U.S. Energy Information Administration  
31451 31451 USA United States of America Shawmut USA0001504 8.8 44.6295 -69.5835 Hydro       1948.3181818181815 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15912 2017 52.802 54.169 55.096 42.791 49.897 U.S. Energy Information Administration  
31567 31567 USA United States of America Skelton USA0001505 16.8 43.5708 -70.5583 Hydro       1948.0 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15913 2017 26.221999999999998 66.764 96.12700000000001 92.90100000000001 100.13 U.S. Energy Information Administration  
32869 32869 USA United States of America West Buxton USA0001508 7.7 43.6669 -70.6021 Hydro       1930.6623376623374 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15914 2017 28.263 28.93 23.04 25.919 27.773000000000003 U.S. Energy Information Administration  
32948 32948 USA United States of America Weston Hydro USA0001509 12.0 44.7639 -69.7183 Hydro       1921.25 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15915 2017 80.008 86.94200000000002 89.104 71.70400000000002 78.37 U.S. Energy Information Administration  
33060 33060 USA United States of America Williams Hydro USA0001510 13.0 44.9589 -69.8703 Hydro       1944.0769230769229 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 90.881 94.155 94.51899999999999 83.21900000000002 92.98 U.S. Energy Information Administration  
33185 33185 USA United States of America Wyman Hydro USA0001511 72.0 45.0703 -69.9064 Hydro       1933.666666666667 Brookfield White Pine Hydro LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 15897 2017 383.434 384.448 369.298 298.687 412.731 U.S. Energy Information Administration  

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