global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
34 rows where commissioning_year = "1990.0", country_long = "United States of America" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2017
owner 26
- Snow Mountain Hydro LLC 4
- BP Hydro Associates 3
- Boralex Hydro Operations Inc 2
- Pelzer Hydro Co Inc 2
- Thunder Bay Power Co LLC 2
- Brookfield White Pine Hydro LLC 1
- CHI West Inc 1
- CHI-West Inc 1
- D/R Hydro Co 1
- First National Bank-Commerce 1
- Frederickson Power LP 1
- Fulcrum Inc 1
- Kaweah River Power Authority 1
- Lower Saranac Hydro Partner LP 1
- Lower Tule River Irrgtn Dist 1
- North Side Energy Company 1
- Olsen Power Partners 1
- PUD No 2 of Grant County 1
- Quinebaug Associates LLC 1
- STS Hydropower LLC 1
- Silverstreet Hydro 1
- Slate Creek Hydro Assoc LP 1
- Smith Creek Hydro LLC 1
- TransAlta Centralia Gen LLC 1
- Twin Falls Hydro Associates LP 1
- USACE-Fort Worth District 1
primary_fuel 1
- Hydro · 34 ✖
country_long 1
- United States of America · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25335 | 25335 | USA | United States of America | Barber Dam | USA0010735 | 4.1 | 43.561 | -116.1213 | Hydro | 1990.0 | Fulcrum Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17366 | 2019 | 8.96 | 10.35 | 9.424 | 12.163 | 13.271 | 12.068 | 13.08 | U.S. Energy Information Administration | 14.76 | 14.8 | 14.04 | 15.08 | 13.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25404 | 25404 | USA | United States of America | Bear Creek | USA0050156 | 3.2 | 40.5345 | -121.9591 | Hydro | 1990.0 | CHI-West Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 1.715 | 2.781 | 0.71 | 6.078 | 8.28 | 3.518 | 6.234 | U.S. Energy Information Administration | 6.65 | 6.65 | 6.56 | 6.67 | 5.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
25927 | 25927 | USA | United States of America | Burney Creek | USA0010706 | 3.0 | 40.8579 | -121.7225 | Hydro | 1990.0 | Snow Mountain Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 38125 | 2019 | 2.03 | 1.873 | 0.394 | 7.147 | 10.717 | 3.366 | 8.869 | U.S. Energy Information Administration | 6.24 | 6.24 | 6.15 | 6.25 | 5.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26346 | 26346 | USA | United States of America | Charles E Monty | USA0000805 | 28.4 | 44.0995 | -70.2209 | Hydro | 1990.0 | Brookfield White Pine Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15890 | 2019 | 120.772 | 152.599 | 137.998 | 125.394 | 134.48 | 139.221 | 154.253 | U.S. Energy Information Administration | 111.91 | 111.89 | 82.94 | 104.54 | 96.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26764 | 26764 | USA | United States of America | Cove Hydroelectric | USA0010707 | 5.0 | 40.8713 | -121.9487 | Hydro | 1990.0 | Snow Mountain Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29498 | 2019 | 9.489 | 7.047 | 3.117 | 16.568 | 18.241 | 9.957 | 18.022 | U.S. Energy Information Administration | 17.55 | 18.27 | 14.24 | 21.31 | 17.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27107 | 27107 | USA | United States of America | Dietrich Drop | USA0010807 | 4.8 | 42.836 | -114.268 | Hydro | 1990.0 | BP Hydro Associates | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17379 | 2019 | 11.953 | 15.142 | 14.527 | 13.946 | 6.966 | 14.32 | 17.756 | U.S. Energy Information Administration | 10.34 | 10.34 | 10.27 | 10.36 | 8.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28642 | 28642 | USA | United States of America | Hillsborough Hosiery | USA0010036 | 1.2 | 43.1139 | -71.894 | Hydro | 1990.0 | Silverstreet Hydro | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33649 | 2019 | 0.0 | 1.011 | 1.855 | 2.397 | 4.074 | 4.955 | 4.212 | U.S. Energy Information Administration | 3.39 | 3.93 | 4.17 | 3.39 | 3.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29248 | 29248 | USA | United States of America | Kekawaka Power House | USA0054654 | 4.9 | 40.0941 | -123.509 | Hydro | 1990.0 | STS Hydropower LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 1.461 | 5.828 | 3.055 | 12.54 | 4.025 | 7.587 | 0.0 | U.S. Energy Information Administration | 18.86 | 17.97 | 15.62 | 20.42 | 17.39 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
29380 | 29380 | USA | United States of America | Koma Kulshan Associates | USA0054267 | 12.0 | 48.6802 | -121.7233 | Hydro | 1990.0 | Frederickson Power LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29337 | 2019 | 40.515 | 48.909 | 36.658 | 46.654 | 42.817 | 42.411 | 30.191 | U.S. Energy Information Administration | 31.4 | 31.4 | 28.13 | 31.48 | 27.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29763 | 29763 | USA | United States of America | Lost Creek I | USA0010708 | 1.1 | 40.7576 | -121.4145 | Hydro | 1990.0 | Snow Mountain Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.893 | 4.772 | 4.284 | 4.032 | 5.393 | 5.551 | 6.497 | U.S. Energy Information Administration | 3.63 | 3.51 | 3.42 | 4.36 | 3.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
29777 | 29777 | USA | United States of America | Low Line Rapids | USA0010808 | 2.8 | 42.4771 | -114.3801 | Hydro | 1990.0 | BP Hydro Associates | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17409 | 2019 | 9.273 | 7.654 | 10.236 | 8.238 | 9.459 | 9.765 | 1.866 | U.S. Energy Information Administration | 7.3 | 7.32 | 7.36 | 7.47 | 6.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29792 | 29792 | USA | United States of America | Lower Saranac Hydroelectric Facility | USA0010214 | 6.7 | 44.6694 | -73.5075 | Hydro | 1990.0 | Lower Saranac Hydro Partner LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17407 | 2019 | 32.25 | 25.613 | 18.204 | 24.125 | 32.594 | 22.486 | 33.018 | U.S. Energy Information Administration | 25.73 | 27.08 | 22.59 | 26.37 | 23.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30686 | 30686 | USA | United States of America | New York State Dam Hydro | USA0010221 | 11.4 | 42.7818 | -73.6961 | Hydro | 1990.0 | Boralex Hydro Operations Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12375 | 2019 | 48.867 | 53.131 | 42.027 | 43.843 | 58.449 | 53.584 | 53.012 | U.S. Energy Information Administration | 50.2 | 50.93 | 40.85 | 47.9 | 43.79 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30733 | 30733 | USA | United States of America | Ninth Street Hydropower Project | USA0054342 | 1.2000000000000002 | 45.0717 | -83.4381 | Hydro | 1990.0 | Thunder Bay Power Co LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34649 | 2019 | 6.9430000000000005 | 7.858 | 6.831 | 6.855 | 8.115 | 7.298 | 7.743 | U.S. Energy Information Administration | 4.96 | 5.21 | 4.15 | 5.08 | 4.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30842 | 30842 | USA | United States of America | Norway Point Hydropower Project | USA0054340 | 4.0 | 45.1025 | -83.5189 | Hydro | 1990.0 | Thunder Bay Power Co LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34650 | 2019 | 15.696 | 18.082 | 15.422 | 15.882 | 19.991 | 17.406 | 20.341 | U.S. Energy Information Administration | 15.76 | 16.53 | 12.58 | 16.1 | 14.41 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30978 | 30978 | USA | United States of America | Olsen | USA0050180 | 5.0 | 40.6705 | -121.8906 | Hydro | 1990.0 | Olsen Power Partners | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34075 | 2019 | 4.961 | 3.881 | 1.314 | 12.003 | 2.541 | 6.106 | 14.168 | U.S. Energy Information Administration | 11.42 | 12.33 | 11.31 | 13.99 | 13.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31131 | 31131 | USA | United States of America | PEC Headworks | USA0007113 | 6.6 | 47.1596 | -119.8963 | Hydro | 1990.0 | PUD No 2 of Grant County | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21316 | 2019 | 20.739 | 23.476 | 22.532 | 21.28 | 14.94603 | 19.58418 | 19.717 | U.S. Energy Information Administration | 27.27 | 27.04 | 30.81 | 28.01 | 24.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31329 | 31329 | USA | United States of America | Pelzer Lower | USA0010800 | 3.3 | 34.6165 | -82.4479 | Hydro | 1990.0 | Pelzer Hydro Co Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17426 | 2019 | 14.045 | 11.335 | 8.762 | 5.995 | 5.466 | 10.229 | 10.323 | U.S. Energy Information Administration | 9.9 | 10.87 | 10.26 | 11.11 | 8.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31331 | 31331 | USA | United States of America | Pelzer Upper | USA0010799 | 2.0 | 34.6424 | -82.4544 | Hydro | 1990.0 | Pelzer Hydro Co Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17425 | 2019 | 14.045 | 11.335 | 8.762 | 5.995 | 5.466 | 10.229 | 5.724 | U.S. Energy Information Administration | 6.92 | 7.66 | 7.33 | 7.82 | 6.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31529 | 31529 | USA | United States of America | Ponderosa Bailey Creek | USA0010709 | 1.1 | 40.4579 | -121.8427 | Hydro | 1990.0 | Snow Mountain Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22119 | 2019 | 0.799 | 0.632 | 0.318 | 3.515 | 5.273 | 1.771 | 3.808 | U.S. Energy Information Administration | 2.45 | 2.46 | 2.61 | 2.47 | 2.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31700 | 31700 | USA | United States of America | Quinebaug Lower Project | USA0055860 | 2.5 | 41.7987 | -71.8868 | Hydro | 1990.0 | Quinebaug Associates LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 6.537 | 6.739 | 4.8500000000000005 | 5.0 | 7.415 | 9.49 | 8.615 | U.S. Energy Information Administration | 8.85 | 8.13 | 8.71 | 8.15 | 8.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31997 | 31997 | USA | United States of America | Robert D Willis | USA0007200 | 8.0 | 30.7975 | -94.1756 | Hydro | 1990.0 | USACE-Fort Worth District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35587 | 2019 | 27.758 | 21.253 | 9.565 | 0.0 | 5.928 | U.S. Energy Information Administration | 29.33 | 26.5 | 31.64 | 35.33 | 28.77 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||
32014 | 32014 | USA | United States of America | Rock Creek II | USA0010809 | 1.9 | 42.6207 | -114.5315 | Hydro | 1990.0 | BP Hydro Associates | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17433 | 2019 | 5.5360000000000005 | 6.829 | 6.303 | 7.291 | 8.86 | 4.729 | 1.028 | U.S. Energy Information Administration | 5.02 | 5.03 | 5.06 | 5.13 | 4.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32140 | 32140 | USA | United States of America | S E Hazelton A | USA0050896 | 8.399999999999999 | 42.5867 | -114.0675 | Hydro | 1990.0 | North Side Energy Company | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 23.007 | 26.682 | 24.159 | 22.657 | 21.984 | 23.972 | 23.073 | U.S. Energy Information Administration | 22.3 | 20.8 | 20.89 | 21.17 | 18.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
32563 | 32563 | USA | United States of America | Sidney A Murray Jr Hydroelectric | USA0054678 | 192.0 | 31.088 | -91.6189 | Hydro | 1990.0 | First National Bank-Commerce | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15714 | 2019 | 1044.561 | 1090.038 | 999.036 | 1103.023 | 906.237 | 1179.855 | 1365.664 | U.S. Energy Information Administration | 694.05 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32610 | 32610 | USA | United States of America | Sissonville Hydro | USA0010220 | 3.0 | 44.6856 | -75.0029 | Hydro | 1990.0 | Boralex Hydro Operations Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12381 | 2019 | 15.235 | 14.536 | 12.876 | 11.278 | 18.166 | 13.778 | 17.022000000000002 | U.S. Energy Information Administration | 12.87 | 13.01 | 11.56 | 12.18 | 11.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32618 | 32618 | USA | United States of America | Skookumchuck | USA0007259 | 1.0 | 46.7844 | -122.7197 | Hydro | 1990.0 | TransAlta Centralia Gen LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 55630 | 2019 | 6.768 | 6.469 | 4.849 | 4.4510000000000005 | 6.32 | 3.28 | 2.318 | U.S. Energy Information Administration | 2.22 | 2.23 | 2.35 | 2.24 | 1.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32625 | 32625 | USA | United States of America | Slate Creek | USA0050961 | 4.2 | 40.9769 | -122.4563 | Hydro | 1990.0 | Slate Creek Hydro Assoc LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17441 | 2019 | 5.4830000000000005 | 4.377 | 3.221 | 10.643 | 8.913 | 2.458 | 0.0 | U.S. Energy Information Administration | 13.02 | 14.23 | 14.15 | 16.26 | 13.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32640 | 32640 | USA | United States of America | Smith Falls Hydro Project | USA0054249 | 38.1 | 48.9595 | -116.5574 | Hydro | 1990.0 | Smith Creek Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 78.697 | 81.047 | 63.939 | 89.33200000000001 | 69.396 | 56.031 | 50.328 | U.S. Energy Information Administration | 111.73 | 111.73 | 100.72 | 112.04 | 95.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33312 | 33312 | USA | United States of America | Terminus Hydroelectric Project | USA0054343 | 20.1 | 36.4156 | -119.0069 | Hydro | 1990.0 | Kaweah River Power Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 10.529 | 5.432 | 5.357 | 29.869 | 82.289 | 28.34766 | 66.652 | U.S. Energy Information Administration | 50.54 | 52.61 | 42.51 | 55.85 | 56.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33511 | 33511 | USA | United States of America | Tulare Success Power Project | USA0010222 | 1.4 | 36.0586 | -118.9241 | Hydro | 1990.0 | Lower Tule River Irrgtn Dist | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25183 | 2019 | 0.279 | 0.062 | 0.0 | 0.615 | 4.896 | 0.49 | 3.824 | U.S. Energy Information Administration | 3.35 | 3.37 | 3.35 | 3.48 | 4.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33550 | 33550 | USA | United States of America | Twin Falls Hydro | USA0050827 | 24.0 | 47.4446 | -121.6878 | Hydro | 1990.0 | Twin Falls Hydro Associates LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17445 | 2019 | 83.58800000000001 | 92.559 | 52.626 | 79.845 | 77.77 | 78.31 | 53.198 | U.S. Energy Information Administration | 71.1 | 71.1 | 62.41 | 71.3 | 61.13 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34086 | 34086 | USA | United States of America | Weeks Falls | USA0054387 | 4.3 | 47.4335 | -121.6483 | Hydro | 1990.0 | CHI West Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17449 | 2019 | 14.707 | 16.407 | 8.512 | 11.111 | 13.647 | 14.593 | 9.494 | U.S. Energy Information Administration | 9.64 | 9.64 | 9.44 | 9.67 | 8.22 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34522 | 34522 | USA | United States of America | Yough Hydro Power | USA0052036 | 12.2 | 39.8016 | -79.3682 | Hydro | 1990.0 | D/R Hydro Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 47.827 | 44.183 | 43.906 | 33.709 | 53.524 | 65.246 | 43.619 | U.S. Energy Information Administration | 36.28 | 47.78 | 43.95 | 48.08 | 34.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-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");