global-power-plants

Table actions

11 rows where owner = "CHI Energy Inc"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, commissioning_year

primary_fuel 2

owner 1

  • CHI Energy Inc · 11 ✖

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
25169 25169 USA United States of America Beaver Valley Patterson Dam USA0010546 1.2000000000000002 40.7441 -80.3178 Hydro       1982.0 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 17369 2017 3.978 3.398 3.3240000000000003 3.1210000000000004 3.719 U.S. Energy Information Administration  
25329 25329 USA United States of America Black River Hydro Associates USA0010687 5.7 43.5912 -75.3442 Hydro       1984.0 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 9.925 14.882 7.484 8.277999999999999 10.3 U.S. Energy Information Administration  
26272 26272 USA United States of America Copenhagen Plant USA0010545 3.3 43.8997 -75.6603 Hydro       1984.0 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 17374 2017 12.087 10.485999999999999 9.479 8.116 11.395999999999999 U.S. Energy Information Administration  
26638 26638 USA United States of America Dexter Plant USA0010538 4.2 44.004 -76.0413 Hydro       1972.8095238095239 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 17384 2017 10.209 11.748 16.473 20.347 22.171 U.S. Energy Information Administration  
26642 26642 USA United States of America Diamond Island Plant USA0010540 1.2000000000000002 43.9786 -75.8861 Hydro       1914.0 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27801 2017 5.843 6.316 4.801 5.257000000000001 7.066 U.S. Energy Information Administration  
27125 27125 USA United States of America Fenner Wind USA0055790 30.0 42.989 -75.7625 Wind       2001.0 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27828 2017 68.252 67.944 67.35 62.451 44.448 U.S. Energy Information Administration  
27590 27590 USA United States of America Goodyear Lake Plant USA0050079 1.4 42.5025 -74.9836 Hydro       1980.0 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 17392 2017 5.775 5.662999999999999 3.3989999999999996 5.194 4.648 U.S. Energy Information Administration  
27796 27796 USA United States of America Hailesboro 4 Plant USA0010544 1.4 44.3117 -75.445 Hydro       1922.0 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 4.296 11.669 10.024 9.951 13.203 U.S. Energy Information Administration  
30726 30726 USA United States of America Pyrites Plant USA0010547 8.2 44.522 -75.1881 Hydro       1980.5853658536587 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 17428 2017 31.746 29.173 23.069000000000003 24.686 35.131 U.S. Energy Information Administration  
32210 32210 USA United States of America Theresa Plant USA0010539 1.3 44.2174 -75.7952 Hydro       1928.5384615384612 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27863 2017 7.622999999999999 7.491 6.273 6.086 8.779 U.S. Energy Information Administration  
32962 32962 USA United States of America Wethersfield Wind Farm USA0055368 6.6 42.6788 -78.2438 Wind       2000.0 CHI Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 45904 2017 9.479 9.408999999999999 13.442 12.527999999999999 7.729 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");