global-power-plants

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

46 rows where owner = "Duke Energy Carolinas LLC"

View and edit SQL

Suggested facets: estimated_generation_gwh

primary_fuel

owner

  • Duke Energy Carolinas LLC · 46

country_long

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
20882 USA United States of America 99 Islands USA0003272 18.0 35.0314 -81.4936 Hydro       1910.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18698 2017 91.59200000000001 78.81700000000002 61.397 45.196000000000005 50.585  
21334 USA United States of America Bad Creek USA0007125 1296.0 35.0075 -82.9975 Hydro       1991.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18699 2017 -449.973 -493.746 -531.6759999999999 -572.6519999999999 -623.3870000000002  
21430 USA United States of America Bear Creek Dam USA0002741 9.0 35.2427 -83.072 Hydro       1954.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27072 2017 37.843 21.206999999999997 27.553 18.298 1.229  
21470 USA United States of America Belews Creek USA0008042 2491.2 36.2811 -80.0603 Coal Oil     1975.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18700 2017 12535.533937 13431.669044999999 12498.932783 10731.176347 9608.222017000002  
21774 USA United States of America Bridgewater USA0002719 27.7 35.7428 -81.8372 Hydro       1924.646209386281 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18704 2017 98.25 56.492 68.71600000000001 48.345 51.905  
21842 USA United States of America Buck USA0002720 697.9000000000002 35.7133 -80.3767 Gas Oil     2011.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18703 2017 0.0 0.0 0.0 0.0 5118.736000000001  
22169 USA United States of America Catawba USA0006036 2410.2 35.0514 -81.0694 Nuclear       1985.5 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18709 2017 19165.965 18711.509 18377.461 19558.264 19706.683  
22182 USA United States of America Cedar Cliff USA0002743 6.4 35.2531 -83.0983 Hydro       1952.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27074 2017 27.471 17.842 9.484 15.833 15.207  
22183 USA United States of America Cedar Creek USA0003255 45.0 34.5414 -80.8756 Hydro       1926.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 199.668 156.153 146.249 120.759 113.07  
22653 USA United States of America Cowans Ford USA0002722 350.0 35.4346 -80.9588 Hydro       1964.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18711 2017 258.09000000000003 148.025 156.06 140.58 120.382  
22749 USA United States of America DE Solar 10240 Old Dowd Rd USA0057334 1.9 35.2458 -80.9967 Solar       2010.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 2.847 2.713 2.7119999999999997 2.477 2.541  
22750 USA United States of America DE Solar 1725 Drywall Dr USA0057336 1.0 35.3261 -80.9967 Solar       2010.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 1.5430000000000001 1.545 1.545 1.666 1.546  
22751 USA United States of America DE Solar 657 Brigham Rd USA0057335 1.3 36.1053 -79.9692 Solar       2010.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 2.12 2.069 1.705 1.895 2.066  
22779 USA United States of America Dan River USA0002723 697.9000000000002 36.4862 -79.7208 Gas       2013.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18715 2017 0.0 0.0 0.0 0.0 4892.4259999999995  
22832 USA United States of America Dearborn USA0003256 45.0 34.5583 -80.8914 Hydro       1923.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18716 2017 202.824 138.262 145.29 141.752 135.57399999999998  
23445 USA United States of America Fishing Creek USA0003257 42.3 34.6 -80.8928 Hydro       1916.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18718 2017 202.021 156.44899999999998 135.239 112.094 111.618  
23583 USA United States of America Franklin (NC) USA0002745 1.0 35.2194 -83.3708 Hydro       1925.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27076 2017 5.284 4.127 1.8730000000000002 1.746 3.0439999999999996  
23649 USA United States of America G G Allen USA0002718 1148.4 35.1897 -81.0122 Coal       1959.147335423197 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18697 2017 2004.449021 2398.805021 1656.996026 1391.0679680000005 994.305001  
23722 USA United States of America Gaston Shoals USA0003258 6.699999999999998 35.1381 -81.5975 Hydro       1915.0895522388062 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18719 2017 17.101 9.943999999999999 8.985 10.048 5.789  
23967 USA United States of America Great Falls (SC) USA0003259 24.0 34.5592 -80.8917 Hydro       1907.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18721 2017 14.652 2.272 5.952999999999999 0.165 -0.016  
24686 USA United States of America James E. Rogers Energy Complex USA0002721 1530.5 35.22 -81.7594 Coal Oil     1996.3642600457367 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18712 2017 6220.236026000001 6053.808024 4082.512978 3681.967972 5825.790031  
24727 USA United States of America Jocassee USA0003262 774.0 34.9594 -82.9147 Hydro       1974.5 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18724 2017 -169.743 -238.367 -248.787 -206.937 -249.972  
24875 USA United States of America Keowee USA0006517 157.6 34.7981 -82.8872 Hydro       1971.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18725 2017 72.872 58.482 61.534 53.797 31.968000000000004  
25202 USA United States of America Lincoln Combustion USA0007277 1753.5999999999995 35.4317 -81.0347 Gas Oil     1995.3750000000007 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18726 2017 58.433 70.38600000000001 48.618 46.111999999999995 17.602999999999998  
25288 USA United States of America Lookout Shoals USA0002726 25.8 35.7575 -81.0894 Hydro       1916.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18727 2017 124.442 95.959 96.889 86.77799999999999 87.427  
25516 USA United States of America Marshall (NC) USA0002727 2119.0 35.5975 -80.9658 Coal       1968.1842850401133 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18731 2017 8360.043031000001 9408.050045999998 7658.909984999999 9754.371993 9224.649050000002  
25587 USA United States of America McGuire USA0006038 2440.6 35.4331 -80.9486 Nuclear       1982.5 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18730 2017 18897.606 17586.205 19536.002 19884.289 18795.536  
25741 USA United States of America Mill Creek (SC) USA0007981 799.1999999999998 35.1597 -81.4306 Gas Oil     2003.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.0 25.15 83.36500000000002 0.0 46.843  
25795 USA United States of America Mission USA0002746 1.7999999999999998 35.0647 -83.9258 Hydro       1931.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27078 2017 -0.036000000000000004 3.2539999999999996 5.171 3.683 3.64  
25812 USA United States of America Mocksville Solar USA0059570 15.4 35.8339 -80.5744 Solar       2017.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 69949 2017       0.6930000000000001 26.54 6.867286086724883
25843 USA United States of America Monroe Solar Facility USA0060383 60.0 34.9299 -80.6256 Solar       2017.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         87.404 26.755660078148896
25936 USA United States of America Mountain Island USA0002728 60.0 35.3339 -80.9867 Hydro       1924.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18732 2017 173.669 108.212 110.891 101.821 90.428  
26057 USA United States of America Nantahala USA0002747 43.2 35.2715 -83.6762 Hydro       1942.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27077 2017 287.58099999999996 191.771 219.296 150.384 186.479  
26357 USA United States of America Oconee USA0003265 2666.7 34.7939 -82.8986 Nuclear       1974.002474969063 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18733 2017 21021.244 21193.381 21939.74 21177.103 21798.744  
26524 USA United States of America Oxford Dam USA0002729 36.0 35.8214 -81.1922 Hydro       1928.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18734 2017 141.055 107.244 94.443 75.181 59.387  
27023 USA United States of America Queens Creek USA0006438 1.4 35.2713 -83.676 Hydro       1949.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27079 2017 5.178 2.772 3.2920000000000003 2.068 2.822  
27204 USA United States of America Rhodhiss USA0002730 25.5 35.7742 -81.4378 Hydro       1925.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18739 2017 96.62 62.36 71.077 58.221 61.738  
27323 USA United States of America Rockingham County CT Station USA0055116 977.5 36.3297 -79.8297 Gas Oil     2000.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 41386 2017 0.0 244.55299700000003 806.8550039999999 1290.466998 678.1709999999998  
27336 USA United States of America Rocky Creek USA0003266 28.0 34.54 -80.8778 Hydro       1909.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18738 2017 -0.541 -0.226 -0.187 -0.213 -0.16399999999999998  
28461 USA United States of America Tennessee Creek USA0002749 10.8 35.2139 -83.0028 Hydro       1955.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27080 2017 24.613000000000003 28.301 22.29 25.840999999999998 28.96  
28519 USA United States of America Thorpe USA0002750 21.6 35.234 -83.1254 Hydro       1941.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27081 2017 77.70700000000002 70.135 57.912 49.869 65.193  
28634 USA United States of America Tuckasegee USA0002751 3.0 35.247 -83.1281 Hydro       1950.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 27082 2017 7.01 5.675 4.62 2.4419999999999997 4.188  
28666 USA United States of America Tuxedo USA0002736 5.0 35.245 -82.3894 Hydro       1920.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 32.738 17.125 19.660999999999998 18.557 14.694  
28932 USA United States of America W S Lee USA0003264 271.2 34.6022 -82.435 Gas Oil     1978.115044247788 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 59.74 344.728 0.0 284.118001 127.39299999999999  
29079 USA United States of America Wateree Hydro USA0003270 76.7 34.3355 -80.7021 Hydro       1919.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18747 2017 303.92400000000004 232.80599999999998 238.425 187.824 170.321  
29469 USA United States of America Wylie USA0003271 60.0 35.0218 -81.0078 Hydro       1925.0 Duke Energy Carolinas LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 18749 2017 208.80599999999998 143.153 143.06900000000005 124.836 98.272  

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