global-power-plants

Table actions

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

45 rows where owner = "MidAmerican Energy Co"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: other_fuel1, generation_gwh_2013, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017

primary_fuel 5

owner 1

  • MidAmerican Energy Co · 45 ✖

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_gwh_2018 generation_gwh_2019 generation_data_source estimated_generation_gwh_2013 estimated_generation_gwh_2014 estimated_generation_gwh_2015 estimated_generation_gwh_2016 estimated_generation_gwh_2017 estimated_generation_note_2013 estimated_generation_note_2014 estimated_generation_note_2015 estimated_generation_note_2016 estimated_generation_note_2017
24838 24838 USA United States of America Adair Wind Farm USA0056810 174.8 41.4236 -94.665 Wind       2009.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 60535 2019 523.247 490.31 470.368 485.613 471.946 414.15 393.032 U.S. Energy Information Administration 596.75 558.58 501.28 520.03 517.28 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
24846 24846 USA United States of America Adams Wind USA0059637 154.3 40.92 -94.6717 Wind       2015.688917692806 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 55940 2019     34.999 483.943 485.774 459.96 457.394 U.S. Energy Information Administration       546.0 536.94 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION WIND-V1 WIND-V1
25050 25050 USA United States of America Anderson Erickson USA0056138 2.0 41.6014 -93.5765 Oil       2000.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 60534 2019 -0.045 -0.04 0.01 0.008 0.012 0.008 0.039 U.S. Energy Information Administration         1.17 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
25120 25120 USA United States of America Arbor Hill Wind Farm USA0062132 250.0 41.4042 -94.2614 Wind       2019.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019           55.104 846.8050000000001 U.S. Energy Information Administration         734.18 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
25426 25426 USA United States of America Beaver Creek Wind USA0061079 340.0 42.107 -94.1646 Wind       2018.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019         41.394 647.988 1201.802 U.S. Energy Information Administration         998.48 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
26202 26202 USA United States of America Carroll Wind Farm USA0056809 159.1 42.1622 -94.93 Wind       2009.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 60536 2019 533.811 517.495 507.127 515.448 491.02 434.528 402.551 U.S. Energy Information Administration 528.49 528.1 481.03 526.27 508.85 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
26313 26313 USA United States of America Century USA0056252 201.2 42.5644 -93.6369 Wind       2005.7634194831012 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 53859 2019 565.559 589.0840000000001 510.234 436.707 408.278 529.756 536.289 U.S. Energy Information Administration 656.59 666.48 591.72 546.37 630.85 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
26344 26344 USA United States of America Charles City Wind Farm USA0056677 80.0 43.0003 -92.62 Wind       2008.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 58380 2019 233.922 240.82 230.23187 211.333 216.311 206.113 236.902 U.S. Energy Information Administration 257.51 250.85 219.76 234.53 222.28 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
26673 26673 USA United States of America Coralville GT USA0001079 72.0 41.6719 -91.564 Gas       1970.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26311 2019 -0.492 -0.223 -0.754 0.165 0.715 0.271 -0.716 U.S. Energy Information Administration         253.9 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
27334 27334 USA United States of America Eclipse Wind Farm USA0057873 200.1 41.5547 -94.685 Wind       2012.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 57109 2019 727.261 757.385 740.444 747.511 716.95 638.893 633.4 U.S. Energy Information Administration 805.9 788.91 690.61 708.63 676.87 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
27382 27382 USA United States of America Electrifarm USA0006063 264.1 42.4407 -92.4205 Gas Oil     1977.1912154486936 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26317 2019 0.0 23.785 8.773 10.865 8.009 0.0 1.023 U.S. Energy Information Administration         931.34 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
28043 28043 USA United States of America George Neal North USA0001091 584.1 42.2998 -96.3617 Coal Gas     1975.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26318 2019 3664.009017 3342.1369640000003 2526.065954 1851.675036 2155.9239689999995 2277.961042 1628.4319730000002 U.S. Energy Information Administration         2698.06 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
28044 28044 USA United States of America George Neal South USA0007343 695.9 42.3006 -96.3617 Coal       1979.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 3087.652043 4323.333046 4229.531037000001 2710.452999 2442.1529640000003 3090.593039 1543.5159620000002 U.S. Energy Information Administration         3214.48 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
28260 28260 USA United States of America Greater Des Moines USA0007985 576.3 41.5563 -93.5283 Gas       2003.678466076696 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 50467 2019 215.258 79.271 176.418 507.176 337.38800000000003 638.9480000000001 438.64200000000005 U.S. Energy Information Administration         2032.31 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
28628 28628 USA United States of America Highland Wind Project (IA) USA0058883 502.0 43.0803 -95.6561 Wind       2015.0093625498007 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 63894 2019     549.863 1809.682 1726.146 1545.24 1461.072 U.S. Energy Information Administration       1798.33 1751.29 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION WIND-V1 WIND-V1
28855 28855 USA United States of America Ida Grove II USA0062795 201.0 42.3269 -95.4588 Wind       2020.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019             24.079 U.S. Energy Information Administration         590.28 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
28856 28856 USA United States of America Ida Grove Wind USA0060342 301.1 42.3557 -95.4204 Wind       2016.705413483892 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 70275 2019       215.994 1194.675 1129.072 1043.794 U.S. Energy Information Administration         1054.44 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION WIND-V1
28974 28974 USA United States of America Intrepid USA0056251 175.5 42.5539 -95.3283 Wind       2005.08547008547 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 50889 2019 546.999 537.302 403.619 419.389 353.999 488.239 488.16 U.S. Energy Information Administration 553.12 606.53 500.11 502.44 437.43 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
29001 29001 USA United States of America Ivester Wind Farm USA0061911 90.8 42.3333 -92.9464 Wind       2019.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019           9.579 257.012 U.S. Energy Information Administration         266.65 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
29373 29373 USA United States of America Knoxville Battery Energy Storage USA0062569 1.1 41.316 -93.061 Storage       2019.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019           0.0 -0.094 U.S. Energy Information Administration           NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION
29374 29374 USA United States of America Knoxville Industrial USA0007849 16.0 41.316 -93.061 Oil       2000.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 48110 2019 -0.25 0.088 0.17 0.312 0.155 0.069 0.177 U.S. Energy Information Administration         9.37 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
29557 29557 USA United States of America Laurel Wind Farm USA0057500 119.6 41.8833 -92.9333 Wind       2012.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 62831 2019 396.992 371.366 384.276 375.045 379.728 334.862 340.36 U.S. Energy Information Administration 441.29 449.92 407.35 388.05 401.24 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
29771 29771 USA United States of America Louisa USA0006664 811.9 41.3181 -91.0931 Coal       1983.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26327 2019 4701.403022 4970.028953999999 3995.922027 3371.451016 3520.888045 4878.998979999999 3346.357976 U.S. Energy Information Administration         3750.3 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
29805 29805 USA United States of America Lundgren Wind Project USA0058884 251.0 42.3347 -94.1708 Wind       2014.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 67234 2019   259.803 928.899 934.315 896.654 795.965 720.8720000000001 U.S. Energy Information Administration     982.48 944.15 893.42 NO-ESTIMATION NO-ESTIMATION WIND-V1 WIND-V1 WIND-V1
29876 29876 USA United States of America Macksburg Wind Project USA0058885 119.6 41.2092 -94.1036 Wind       2015.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 67536 2019   19.682 388.857 374.541 367.493 340.762 336.094 U.S. Energy Information Administration       412.2 389.57 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION WIND-V1 WIND-V1
30150 30150 USA United States of America Merl Parr USA0001097 36.0 43.0563 -92.6932 Gas       1969.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26330 2019 0.0 0.0 0.0 0.0 0.0 0.0 -0.27 U.S. Energy Information Administration         126.95 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
30337 30337 USA United States of America Moline USA0000899 75.60000000000002 41.51 -90.534 Gas Hydro     1968.6666666666652 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26332 2019 3.585 1.936 -1.125 2.851 8.969 14.738 8.241000000000001 U.S. Energy Information Administration         266.6 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
30426 30426 USA United States of America Morning Light Wind Farm USA0057875 101.2 41.4542 -94.5751 Wind       2012.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 64924 2019 367.355 379.766 356.603 361.493 351.791 312.508 304.932 U.S. Energy Information Administration 421.83 404.58 341.88 360.61 350.77 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
30781 30781 USA United States of America North English USA0062133 340.0 41.6428 -92.4991 Wind       2019.4117647058824 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019           57.556 837.4300000000001 U.S. Energy Information Administration         998.48 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
30866 30866 USA United States of America O'Brien Wind USA0060326 250.3 43.2004 -95.6243 Wind       2016.752696763883 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 69358 2019       224.923 895.821 814.576 750.527 U.S. Energy Information Administration         954.11 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION WIND-V1
31040 31040 USA United States of America Orient Wind Farm USA0061077 500.8 41.2024 -94.4172 Wind       2019.7963258785944 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019             683.846 U.S. Energy Information Administration         1470.71 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
31498 31498 USA United States of America Pleasant Hill USA0007145 179.8 41.5572 -93.5242 Gas Oil     1992.157953281424 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26335 2019 12.734 7.784000000000001 14.088 23.963000000000005 11.803 0.0 2.01 U.S. Energy Information Administration         634.06 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
31526 31526 USA United States of America Pomeroy Wind Farm USA0056501 286.4 42.5842 -94.7467 Wind       2008.517458100559 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 56029 2019 918.97 935.484 886.9830000000001 886.488 845.511 711.268 714.45 U.S. Energy Information Administration 939.95 980.4 838.37 861.87 808.68 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
31609 31609 USA United States of America Prairie Wind Farm USA0060873 168.0 41.4369 -92.7038 Wind       2018.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019           546.3290000000001 536.616 U.S. Energy Information Administration         493.37 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
31961 31961 USA United States of America River Hills USA0001084 128.0 41.5902 -93.6195 Gas       1966.75 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26338 2019 0.482 0.551 -0.671 -0.092 -1.237 -0.77 -0.755 U.S. Energy Information Administration         451.39 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
31974 31974 USA United States of America Riverside USA0001081 136.0 41.54 -90.4481 Gas       1961.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 708.961001 635.836005 179.20100000000002 5.513000000000001 1.766 -1.973 -0.846 U.S. Energy Information Administration         479.6 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
32066 32066 USA United States of America Rolling Hills Wind Farm USA0057501 443.9 41.1973 -94.7744 Wind       2012.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2019 1418.433 1403.006 1335.713 1341.387 1290.492 1186.959 1173.711 U.S. Energy Information Administration 1620.75 1587.83 1314.56 1387.01 1434.17 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
32516 32516 USA United States of America Shenandoah USA0007850 20.0 40.7707 -95.3768 Oil       2000.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 48111 2019 -0.47 0.084 0.105 0.267 0.083 0.154 0.462 U.S. Energy Information Administration         11.72 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
33172 33172 USA United States of America Sycamore (IA) USA0008029 157.6 41.6722 -93.6769 Gas Oil     1974.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26341 2019 0.0 2.8160000000000003 1.522 7.6 0.0 4.618 1.327 U.S. Energy Information Administration         555.77 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
33818 33818 USA United States of America Victory Wind Farm USA0056379 105.0 42.1169 -95.1292 Wind       2007.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 55615 2019 378.079 362.419 361.085 369.592 294.27500000000003 364.441 344.998 U.S. Energy Information Administration 331.44 323.62 288.23 343.66 314.87 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
33821 33821 USA United States of America Vienna Wind Farm USA0057874 150.2 42.1594 -92.7761 Wind       2012.5938748335552 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 64763 2019 331.794 524.207 518.594 485.754 501.6 440.955 384.805 U.S. Energy Information Administration 548.41 583.33 513.11 508.4 525.28 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
33946 33946 USA United States of America Walnut Wind Farm USA0056811 165.2 41.4517 -95.2383 Wind       2009.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 58415 2019 511.041 474.368 472.72 497.238 469.286 431.516 403.583 U.S. Energy Information Administration 522.41 562.8 469.74 500.33 473.39 WIND-V1 WIND-V1 WIND-V1 WIND-V1 WIND-V1
33952 33952 USA United States of America Walter Scott Jr Energy Center USA0001082 1648.3 41.18 -95.8408 Coal       1994.670691014985 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26312 2019 10947.151713 10799.462388 9586.255047 8695.387014 8563.352037 10039.865033 8014.202951 U.S. Energy Information Administration         7613.78 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
34041 34041 USA United States of America Waterloo Lundquist USA0007851 18.0 42.5062 -92.3456 Oil       2000.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 48112 2019 -0.414 -0.017 0.108 0.233 0.106 0.171 0.111 U.S. Energy Information Administration         10.54 NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION NO-ESTIMATION CAPACITY-FACTOR-V1
34099 34099 USA United States of America Wellsburg Wind Project USA0058886 140.8 42.3908 -92.9667 Wind       2015.0 MidAmerican Energy Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 64764 2019   32.07 510.817 503.778 490.333 431.123 403.277 U.S. Energy Information Administration     547.19 521.05 541.27 NO-ESTIMATION NO-ESTIMATION WIND-V1 WIND-V1 WIND-V1

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_gwh_2018" REAL,
  "generation_gwh_2019" REAL,
  "generation_data_source" TEXT,
  "estimated_generation_gwh_2013" REAL,
  "estimated_generation_gwh_2014" REAL,
  "estimated_generation_gwh_2015" REAL,
  "estimated_generation_gwh_2016" REAL,
  "estimated_generation_gwh_2017" REAL,
  "estimated_generation_note_2013" TEXT,
  "estimated_generation_note_2014" TEXT,
  "estimated_generation_note_2015" TEXT,
  "estimated_generation_note_2016" TEXT,
  "estimated_generation_note_2017" TEXT
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");