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_gwh_2015
This data as json, CSV (advanced)
owner 22
- Origin Energy 6
- Alinta Energy 3
- Energy Developments Ltd 2
- Rio Tinto Australia Pty Ltd 2
- Southern Cross Energy 2
- Verve Energy 2
- APA Group and AGL Energy Ltd 1
- ATCO Power 1
- Arrow Energy 1
- CS Energy 1
- Energy Development Projects (Australia) Pty Ltd 1
- Energy Developments CSM (Qld) Pty Ltd 1
- International Power - GDF Suez Australia 1
- International Power Plc & Mitsui & Co Ltd & Transfield 1
- Marubeni Australia Power Services 1
- NT Government 1
- NT Power and Water 1
- Newgen Power Kwinana Partnership 1
- Oakey Power Pty Ltd 1
- Queensland Gas Company 1
- Stanwell Corporation 1
- TRUenergy 1
primary_fuel 1
- Gas · 34 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
545 | 545 | AUS | Australia | Ladbroke Grove | AUS0000244 | 80.0 | -37.4567 | 140.7827 | Gas | Origin Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1045441 | 91.68388888888887 | 231.32194444444443 | 184.4061111111111 | 204.39083333333332 | 211.14666666666668 | 183.30666666666667 | Australia Clean Energy Regulator | 221.87 | 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 | |||||||||||
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 | ||||||||||
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 | ||||||||||
628 | 628 | AUS | Australia | Newman Iron Ore Mine | AUS0000199 | 170.0 | -23.3443 | 119.7086 | Gas | Alinta Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 567.7341666666666 | 555.4222222222222 | 231.335 | 121.98944444444444 | 187.1486111111111 | 244.33805555555557 | Australia Clean Energy Regulator | 471.48 | 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 | |||||||||||||
560 | 560 | AUS | Australia | Leinster Nickel Mine | AUS0000212 | 59.0 | -27.8141 | 120.699 | Gas | Southern Cross Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1033314 | 316.80444444444447 | 302.5083333333333 | 280.8511111111111 | 295.87111111111113 | 313.84277777777777 | 250.02694444444444 | Australia Clean Energy Regulator | 163.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
586 | 586 | AUS | Australia | McArthur River Mine | AUS0000424 | 78.0 | -16.4335 | 136.0935 | Gas | Energy Developments Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1016477 | 159.93333333333334 | 179.60444444444445 | 285.7841666666667 | 260.9147222222222 | 247.70388888888888 | 279.81944444444446 | Australia Clean Energy Regulator | 216.32 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
475 | 475 | AUS | Australia | German Creek | AUS0000157 | 45.2 | -22.9281 | 148.5515 | Gas | Energy Developments CSM (Qld) Pty Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1053501 | 248.355 | 305.60777777777776 | 305.9630555555556 | 323.0588888888889 | 319.7855555555556 | 303.19194444444446 | Australia Clean Energy Regulator | 125.35 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
603 | 603 | AUS | Australia | Mount Keith Nickel Mine | AUS0000213 | 112.0 | -27.2146 | 120.548 | Gas | Southern Cross Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1033315 | 386.9952777777778 | 355.73805555555555 | 307.24055555555555 | 338.9313888888889 | 378.0163888888889 | 428.6555555555556 | Australia Clean Energy Regulator | 310.62 | 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 | ||||||||||||
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 | ||||||||||
598 | 598 | AUS | Australia | Moranbah North | AUS0000054 | 45.7 | -21.8967 | 147.9507 | Gas | Energy Development Projects (Australia) Pty Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1071497 | 321.8525 | 317.6022222222222 | 439.4063888888889 | 466.2394444444444 | 490.2294444444444 | 507.84472222222223 | Australia Clean Energy Regulator | 126.74 | 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 | ||||||||||
530 | 530 | AUS | Australia | Karratha | AUS0000189 | 86.0 | -20.7626 | 116.8375 | Gas | ATCO Power | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1075751 | 493.5102777777778 | 446.5397222222222 | 474.165 | 452.0519444444444 | 345.4705555555556 | 78.92444444444445 | Australia Clean Energy Regulator | 238.51 | 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 | ||||||||||
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 | ||||||||||||
592 | 592 | AUS | Australia | Mica Creek | AUS0000446 | 325.0 | -20.7776 | 139.4906 | Gas | Stanwell Corporation | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1023156 | 1776.2222222222222 | 1570.7702777777777 | 643.4019444444444 | 197.22666666666663 | 5.021944444444444 | 121.08583333333333 | Australia Clean Energy Regulator | 901.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
425 | 425 | AUS | Australia | Cockburn | AUS0000183 | 240.0 | -32.2001 | 115.7737 | Gas | Verve Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1055737 | 496.62416666666667 | 1122.4647222222222 | 658.15 | 638.1805555555555 | 363.93055555555554 | 118.035 | Australia Clean Energy Regulator | 665.62 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
433 | 433 | AUS | Australia | Condamine A | AUS0000154 | 144.0 | -26.6682 | 150.27 | Gas | Queensland Gas Company | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 573.1630555555555 | 617.9230555555556 | 765.1002777777778 | 723.5783333333334 | 960.7911111111111 | 849.4619444444445 | Australia Clean Energy Regulator | 399.37 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||
541 | 541 | AUS | Australia | Kwinana Cogeneration | AUS0000193 | 123.0 | -32.2225 | 115.7661 | Gas | International Power Plc & Mitsui & Co Ltd & Transfield | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 811.845 | 884.2316666666667 | 892.2663888888889 | 878.0797222222222 | 854.565 | 859.2527777777777 | Australia Clean Energy Regulator | 341.13 | 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 | ||||||||||||
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 | ||||||||||
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 | ||||||||||||
414 | 414 | AUS | Australia | Channel Island | AUS0000261 | 310.0 | -12.555 | 130.8666 | Gas | NT Government | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1024439 | 1040.7402777777777 | 1068.0919444444444 | 978.0472222222222 | 1068.4391666666668 | 1039.4716666666666 | 1062.7872222222222 | Australia Clean Energy Regulator | 859.76 | 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 | ||||||||||
601 | 601 | AUS | Australia | Mortlake | AUS0000108 | 566.0 | -38.0632 | 142.6675 | Gas | Origin Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1061737 | 1709.266111111111 | 1673.4494444444445 | 1163.4769444444444 | 487.0838888888889 | 1102.9175 | 1278.8608333333334 | Australia Clean Energy Regulator | 1569.75 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
453 | 453 | AUS | Australia | Diamantina | AUS0000459 | 242.0 | -20.7837 | 139.4833 | Gas | APA Group and AGL Energy Ltd | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1088740 | 252.57666666666665 | 1502.9666666666667 | 1716.8830555555555 | 1649.3 | 1601.4577777777777 | Australia Clean Energy Regulator | 671.16 | 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 | |||||||||||
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 | ||||||||||
543 | 543 | AUS | Australia | Kwinana NewGen | AUS0000196 | 320.0 | -32.202 | 115.7728 | Gas | Newgen Power Kwinana Partnership | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1067030 | 1791.0088888888888 | 1997.0055555555557 | 2152.8866666666668 | 1932.0355555555557 | 2159.6969444444444 | 2074.119166666667 | Australia Clean Energy Regulator | 887.49 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
371 | 371 | AUS | Australia | Braemar 1 | AUS0000152 | 504.0 | -27.1109 | 150.9053 | Gas | Alinta Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1087315 | 1549.1319444444443 | 1631.3680555555557 | 2196.658055555556 | 1264.0997222222222 | 649.7466666666667 | 424.4166666666667 | Australia Clean Energy Regulator | 1397.8 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
372 | 372 | AUS | Australia | Braemar 2 | AUS0000153 | 519.0 | -27.1128 | 150.9049 | Gas | Arrow Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1087314 | 1003.6286111111112 | 1236.1830555555557 | 2602.9819444444443 | 1161.2019444444445 | 460.4822222222222 | 257.19916666666666 | Australia Clean Energy Regulator | 1439.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
443 | 443 | AUS | Australia | Darling Downs | AUS0000156 | 644.0 | -27.1169 | 150.8942 | Gas | Origin Energy | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1062112 | 2881.408055555556 | 3322.8125 | 4337.818611111111 | 3674.545 | 3342.9466666666667 | 2245.3141666666666 | Australia Clean Energy Regulator | 1786.08 | 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");