global-power-plants

Table actions

26 rows where owner = "Alabama Power Co"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: other_fuel1, commissioning_year, generation_gwh_2016

primary_fuel 5

owner 1

  • Alabama Power Co · 26 ✖

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
24630 24630 USA United States of America ANAD Solar Array USA0060680 7.4 33.6267 -85.9695 Solar       2017.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         7.667999999999999 U.S. Energy Information Administration 3.289408879474575
25078 25078 USA United States of America Bankhead Dam USA0000002 53.9 33.4587 -87.3568 Hydro       1963.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12576 2017 211.342 47.391000000000005 25.92 -0.325 -0.29100000000000004 U.S. Energy Information Administration  
25098 25098 USA United States of America Barry USA0000003 2569.4999999999995 31.0069 -88.0103 Gas Coal     1980.9023545436855 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12578 2017 12897.137040000001 12981.028968 11387.561999 12770.891035999999 11864.55405 U.S. Energy Information Administration  
26774 26774 USA United States of America E C Gaston USA0000026 2034.0 33.2442 -86.4581 Gas Coal Oil   1967.0312684365783 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12580 2017 7011.767013 6432.760961999999 6578.897982 4280.42 4916.6010000000015 U.S. Energy Information Administration  
27252 27252 USA United States of America Fort Rucker Solar Array USA0060679 10.6 31.3311 -85.7302 Solar       2017.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         16.206 U.S. Energy Information Administration 4.711855962490606
27394 27394 USA United States of America Gadsden USA0000007 138.0 34.0128 -85.9708 Gas       1949.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12582 2017 182.004 216.75000099999997 214.655003 0.0 193.273 U.S. Energy Information Administration  
27467 27467 USA United States of America General Electric Plastic USA0007698 97.0 32.3102 -86.5254 Gas       1999.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 490.995 537.102 539.8380000000001 477.109 511.7240000000001 U.S. Energy Information Administration  
27598 27598 USA United States of America Gorgas USA0000008 1166.7 33.6443 -87.1965 Coal       1967.1439101739948 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12581 2017 3455.632041 5247.4330180000015 4652.041981 5494.440985 4515.102986999999 U.S. Energy Information Administration  
27717 27717 USA United States of America Greene County USA0000010 1288.4 32.6017 -87.7811 Gas Oil     1982.2222912139086 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12585 2017 2499.0690470000004 2857.924032000001 2249.285002 0.0 884.809 U.S. Energy Information Administration  
27772 27772 USA United States of America H Neely Henry Dam USA0000011 72.9 33.7845 -86.0524 Hydro       1966.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12587 2017 297.81 198.56799999999998 198.745 154.855 176.239 U.S. Energy Information Administration  
27863 27863 USA United States of America Harris Dam USA0006188 135.0 33.2583 -85.616 Hydro       1983.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12584 2017 201.884 147.97799999999998 157.611 114.934 136.982 U.S. Energy Information Administration  
28067 28067 USA United States of America Holt Dam USA0000012 46.9 33.2553 -87.4495 Hydro       1968.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12588 2017 193.247 72.223 30.241999999999997 129.325 154.683 U.S. Energy Information Administration  
28402 28402 USA United States of America James H Miller Jr USA0006002 2822.0 33.6319 -87.0597 Coal       1985.75 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12595 2017 0.0 0.0 0.0 0.0 19029.94745 U.S. Energy Information Administration  
28479 28479 USA United States of America Jordan Dam USA0000013 100.0 32.6189 -86.2548 Hydro       1929.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12589 2017 477.075 294.067 336.47900000000004 269.244 211.90599999999998 U.S. Energy Information Administration  
28483 28483 USA United States of America Joseph M Farley USA0006001 1776.4 31.2231 -85.1116 Nuclear       1979.5 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 33231 2017 14098.021999999999 14505.389 14281.688 13687.256 14804.094 U.S. Energy Information Administration  
28846 28846 USA United States of America Lay Dam USA0000015 177.0 32.9633 -86.5187 Hydro       1967.5 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12592 2017 774.445 561.938 557.768 404.62300000000005 499.66900000000004 U.S. Energy Information Administration  
28887 28887 USA United States of America Lewis Smith Dam USA0000018 181.0 33.9406 -87.1077 Hydro       1961.5 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12590 2017 321.245 243.605 241.085 233.85299999999998 202.916 U.S. Energy Information Administration  
28978 28978 USA United States of America Logan Martin Dam USA0000014 128.10000000000002 33.4259 -86.3375 Hydro       1964.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12591 2017 495.981 346.035 358.55699999999996 266.305 310.88599999999997 U.S. Energy Information Administration  
29252 29252 USA United States of America Martin Dam USA0000016 210.6 32.6804 -85.9114 Hydro       1934.122507122507 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12593 2017 412.885 348.048 289.985 304.289 318.416 U.S. Energy Information Administration  
29517 29517 USA United States of America Mitchell Dam USA0000017 170.0 32.806 -86.4449 Hydro       1980.764705882353 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12594 2017 673.1850000000002 466.344 465.039 372.569 428.126 U.S. Energy Information Administration  
32209 32209 USA United States of America Theodore Cogen Facility USA0007721 317.4 30.5254 -88.1285 Gas       2001.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 38581 2017 1567.6 1525.9620000000002 1484.9920000000002 1272.6589999999999 1522.6770000000001 U.S. Energy Information Administration  
32245 32245 USA United States of America Thurlow Dam USA0000019 91.0 32.5354 -85.8876 Hydro       1931.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12596 2017 277.802 228.345 193.62400000000002 200.64 217.582 U.S. Energy Information Administration  
32715 32715 USA United States of America Walter Bouldin Dam USA0000004 225.0 32.5839 -86.2831 Hydro       1967.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12597 2017 812.071 590.121 560.467 468.96 628.655 U.S. Energy Information Administration  
32760 32760 USA United States of America Washington County Cogeneration Facility USA0007697 122.5 31.2504 -88.0156 Gas       1999.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 45690 2017 827.043 828.885 833.574 718.6060000000001 828.5120000000002 U.S. Energy Information Administration  
32844 32844 USA United States of America Weiss Dam USA0000020 87.6 34.1721 -85.7538 Hydro       1961.333333333333 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12598 2017 317.61 209.892 212.172 164.092 177.87900000000002 U.S. Energy Information Administration  
33210 33210 USA United States of America Yates Dam USA0000021 50.5 32.5743 -85.8901 Hydro       1928.0 Alabama Power Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 12600 2017 158.284 138.401 117.27799999999999 116.654 125.786 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");