global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
134 rows where country_long = "Australia" and primary_fuel = "Gas" sorted by generation_data_source
This data as json, CSV (advanced)
owner 23
- NT Government 5
- Origin Energy 4
- International Power - GDF Suez Australia 2
- Rio Tinto Australia Pty Ltd 2
- AGL Energy Pty Ltd 1
- Alinta Energy 1
- Aurora Energy (Tamar Valley) 1
- CS Energy 1
- Energy Developments Ltd 1
- EnviroGen Pty Ltd 1
- EnvironGen (Oaky) Pty Ltd 1
- Industry Funds Management 1
- Marubeni Australia Power Services 1
- NGD (NT) / Cosmo Power 1
- NT Power and Water 1
- Oakey Power Pty Ltd 1
- RATCH Australia 1
- Rio Tinto 1
- Santos 1
- Snowy Hydro Ltd 1
- Symex Holding Ltd 1
- TRUenergy 1
- Verve Energy 1
primary_fuel 1
- Gas · 34 ✖
geolocation_source 1 ✖
country_long 1
- Australia · 34 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
629 | 629 | AUS | Australia | Newport | AUS0000094 | 500.0 | -37.8415 | 144.8942 | Gas | Industry Funds Management | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1030172 | 185.345 | 219.15694444444443 | 95.24805555555557 | 332.32194444444445 | 322.2108333333333 | 1018.5566666666666 | Australia Clean Energy Regulator | 1386.71 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
642 | 642 | AUS | Australia | Oakey | AUS0000166 | 282.0 | -27.4183 | 151.6797 | Gas | Oakey Power Pty Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1024617 | 27.4475 | 57.74055555555555 | 499.1413888888889 | 520.2791666666667 | 133.205 | 74.58194444444445 | Australia Clean Energy Regulator | 782.1 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
647 | 647 | AUS | Australia | Oaky Creek | AUS0000167 | 20.0 | -22.9878 | 148.5817 | Gas | EnvironGen (Oaky) Pty Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1053495 | 107.60666666666668 | 90.25694444444444 | 133.6536111111111 | 129.62027777777777 | Australia Clean Energy Regulator | 55.46 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
648 | 648 | AUS | Australia | Onslow | AUS0000411 | 3.6 | -21.6582 | 115.099 | Gas | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1030213 | 14.885277777777778 | 13.282222222222222 | 14.453055555555556 | Australia Clean Energy Regulator | 9.98 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
650 | 650 | AUS | Australia | Osborne | AUS0000235 | 180.0 | -34.798 | 138.5079 | Gas | Origin Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1080968 | 1350.6038888888888 | 1455.608611111111 | 0.0 | 1184.0425 | 966.9333333333332 | 1319.6225 | Australia Clean Energy Regulator | 499.21 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
651 | 651 | AUS | Australia | Owen Springs | AUS0000255 | 36.0 | -23.8636 | 133.8255 | Gas | NT Government | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1075622 | 62.74722222222222 | 53.36611111111111 | 79.60305555555556 | 92.04416666666668 | 85.23277777777778 | 74.67611111111111 | Australia Clean Energy Regulator | 99.84 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
653 | 653 | AUS | Australia | Paraburdoo | AUS0000229 | 155.0 | -23.2233 | 117.6133 | Gas | Rio Tinto Australia Pty Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1034635 | 569.9175 | 572.2866666666666 | 545.5266666666666 | 524.895 | Australia Clean Energy Regulator | 429.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
657 | 657 | AUS | Australia | Pelican Point | AUS0000237 | 478.0 | -34.765 | 138.5053 | Gas | International Power - GDF Suez Australia | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1044465 | 2989.9266666666667 | 1867.9583333333333 | 1030.1158333333333 | 304.40166666666664 | 1209.6244444444444 | 2732.4211111111117 | Australia Clean Energy Regulator | 1325.69 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
661 | 661 | AUS | Australia | Pine Creek | AUS0000258 | 34.76 | -13.7856 | 131.8624 | Gas | NGD (NT) / Cosmo Power | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1024450 | 158.79777777777778 | 173.06722222222223 | 181.08166666666668 | 191.08055555555555 | 181.01638888888888 | 165.10805555555555 | Australia Clean Energy Regulator | 96.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
662 | 662 | AUS | Australia | Pinjar | AUS0000200 | 576.0 | -31.5568 | 115.8204 | Gas | Verve Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1030214 | 627.3311111111111 | 447.62888888888887 | 464.0411111111111 | 610.4527777777778 | 511.1247222222222 | 570.2186111111112 | Australia Clean Energy Regulator | 1597.49 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
663 | 663 | AUS | Australia | Pinjarra Bauxite Mine and Alumina Refinery | AUS0000201 | 280.0 | -32.6473 | 115.9469 | Gas | Alinta Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1354.5655555555556 | 1277.3963888888889 | 1639.0922222222223 | 2057.255833333333 | 2271.889166666667 | 2155.606111111111 | Australia Clean Energy Regulator | 776.55 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||
673 | 673 | AUS | Australia | Quarantine | AUS0000239 | 224.0 | -34.7793 | 138.5224 | Gas | Origin Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1051507 | 150.19333333333333 | 230.5105555555556 | 215.24666666666667 | 135.15694444444443 | 264.0280555555556 | 190.82833333333332 | Australia Clean Energy Regulator | 621.24 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
687 | 687 | AUS | Australia | Roma | AUS0000147 | 80.0 | -26.5772 | 148.8402 | Gas | Origin Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1029598 | 38.22166666666666 | 66.63166666666666 | 207.27444444444444 | 109.24361111111112 | 41.73916666666667 | 31.63111111111111 | Australia Clean Energy Regulator | 221.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
688 | 688 | AUS | Australia | Ron Goodin | AUS0000254 | 44.6 | -23.7091 | 133.8912 | Gas | NT Government | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1024451 | 123.045 | 123.08305555555556 | 93.04805555555556 | 88.70611111111111 | 113.87805555555556 | 126.02805555555555 | Australia Clean Energy Regulator | 123.69 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
699 | 699 | AUS | Australia | Smithfield Energy | AUS0000286 | 170.9 | -33.85 | 150.9495 | Gas | Marubeni Australia Power Services | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1028917 | 1001.0275 | 989.0983333333334 | 968.5383333333332 | 970.9952777777778 | 979.3944444444444 | 71.99416666666667 | Australia Clean Energy Regulator | 473.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
702 | 702 | AUS | Australia | Snuggery | AUS0000245 | 63.0 | -37.6646 | 140.4156 | Gas | International Power - GDF Suez Australia | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1014359 | 0.3097222222222222 | 0.0875 | 0.375 | 0.9858333333333332 | 3.1969444444444446 | 0.7438888888888889 | Australia Clean Energy Regulator | 174.72 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
703 | 703 | AUS | Australia | Solomon Iron Ore Mine | AUS0000458 | 125.0 | -22.1581 | 117.9849 | Gas | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 143.2263888888889 | 240.18527777777777 | 263.75166666666667 | 273.5775 | 277.89694444444444 | Australia Clean Energy Regulator | 346.67 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
704 | 704 | AUS | Australia | Somerton | AUS0000096 | 160.0 | -37.6318 | 144.9531 | Gas | AGL Energy Pty Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1055703 | 16.20916666666667 | 11.363055555555556 | 10.463611111111112 | 11.646666666666668 | 29.14388888888889 | 85.41833333333334 | Australia Clean Energy Regulator | 443.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
721 | 721 | AUS | Australia | Swanbank E | AUS0000149 | 385.0 | -27.6554 | 152.8179 | Gas | CS Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1010526 | 1408.2130555555557 | 2314.516944444445 | 952.8858333333334 | 671.1580555555555 | Australia Clean Energy Regulator | 1067.76 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
722 | 722 | AUS | Australia | Symex Port Melbourne | AUS0000097 | 5.9 | -37.8298 | 144.9444 | Gas | Symex Holding Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1032356 | 17.278333333333332 | Australia Clean Energy Regulator | 16.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
724 | 724 | AUS | Australia | Tahmoor | AUS0000287 | 7.0 | -34.2482 | 150.5808 | Gas | EnviroGen Pty Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1061458 | 29.754722222222224 | 34.265277777777776 | 46.45583333333333 | 38.91555555555556 | 28.237222222222226 | 32.95861111111111 | Australia Clean Energy Regulator | 19.41 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
726 | 726 | AUS | Australia | Tallawarra | AUS0000288 | 460.0 | -34.5228 | 150.8081 | Gas | TRUenergy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1014217 | 2840.058611111111 | 3283.508611111111 | 2082.391666666667 | 1866.0408333333328 | 803.0308333333334 | 1468.602777777778 | Australia Clean Energy Regulator | 1275.77 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
728 | 728 | AUS | Australia | Tamar Valley | AUS0000138 | 390.0 | -41.1401 | 146.9036 | Gas | Aurora Energy (Tamar Valley) | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1067600 | 1686.3722222222225 | 871.6247222222222 | 17.671944444444446 | 780.8641666666666 | 793.8358333333333 | 846.5272222222222 | Australia Clean Energy Regulator | 1081.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
737 | 737 | AUS | Australia | Tennant Creek | AUS0000253 | 16.7 | -19.6549 | 134.1753 | Gas | NT Government | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1024454 | 31.775277777777777 | 32.055 | 30.32888888888889 | 30.66888888888889 | 29.4025 | 29.155 | Australia Clean Energy Regulator | 46.31 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
748 | 748 | AUS | Australia | Tower Mine | AUS0000291 | 41.2 | -34.2207 | 150.7179 | Gas | Energy Developments Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 209.52083333333331 | 245.06222222222223 | 202.03527777777776 | 235.03027777777777 | 269.09027777777777 | 187.70833333333331 | Australia Clean Energy Regulator | 114.26 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||
749 | 749 | AUS | Australia | Townsville | AUS0000172 | 220.0 | -19.2011 | 146.6187 | Gas | RATCH Australia | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1031996 | 605.6180555555555 | 271.47083333333336 | 80.77194444444444 | 174.80805555555557 | 524.5472222222222 | 243.7161111111111 | Australia Clean Energy Regulator | 610.15 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
760 | 760 | AUS | Australia | Uranquinty | AUS0000294 | 664.0 | -35.1794 | 147.2157 | Gas | Origin Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1063281 | 427.1616666666667 | 783.0105555555556 | 636.3991666666667 | 556.1280555555555 | Australia Clean Energy Regulator | 1841.55 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
764 | 764 | AUS | Australia | Valley (Peaking Facility) | AUS0000098 | 300.0 | -38.2536 | 146.5892 | Gas | Snowy Hydro Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 11.844722222222222 | 8.896666666666667 | 5.198611111111111 | 10.677777777777775 | 4.109444444444445 | 22.880277777777778 | Australia Clean Energy Regulator | 832.02 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||
768 | 768 | AUS | Australia | Wadeye | AUS0000480 | 6.8 | -14.2602 | 129.5368 | Gas | NT Government | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 9.546111111111111 | 9.42 | 9.449166666666668 | Australia Clean Energy Regulator | 18.85 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
780 | 780 | AUS | Australia | Weddell | AUS0000260 | 86.0 | -12.5771 | 130.9502 | Gas | NT Power and Water | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1079369 | 325.4352777777778 | 345.68305555555554 | 437.9311111111112 | 430.55805555555554 | 380.06305555555554 | 364.0241666666666 | Australia Clean Energy Regulator | 238.51 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
782 | 782 | AUS | Australia | West Angelas Mine | AUS0000451 | 86.0 | -23.1546 | 118.7245 | Gas | Rio Tinto | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1100981 | 0.6241666666666666 | 179.95 | 380.22083333333336 | 457.1091666666667 | Australia Clean Energy Regulator | 238.51 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
792 | 792 | AUS | Australia | Wilga Park | AUS0000302 | 16.0 | -30.3634 | 149.6772 | Gas | Santos | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1058845 | 1.507777777777778 | 54.01805555555556 | 88.78305555555555 | 89.63083333333333 | 84.47111111111111 | Australia Clean Energy Regulator | 44.37 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||
821 | 821 | AUS | Australia | Yulara | AUS0000257 | 10.95 | -25.2323 | 130.9912 | Gas | NT Government | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1024458 | 21.9475 | 22.775 | 24.086111111111112 | 23.04388888888889 | 19.885 | 19.558055555555555 | Australia Clean Energy Regulator | 30.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
822 | 822 | AUS | Australia | Yurralyi Maya (Karratha Seven Mile) | AUS0000218 | 180.0 | -20.762 | 116.742 | Gas | Rio Tinto Australia Pty Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1074516 | 977.2269444444444 | 945.5577777777778 | 756.2191666666666 | 597.4116666666666 | Australia Clean Energy Regulator | 499.21 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 |
Advanced export
JSON shape: default, array, newline-delimited
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");