global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
17 rows where country_long = "Italy", primary_fuel = "Hydro" and url = "https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show" sorted by wepp_id
This data as json, CSV (advanced)
Suggested facets: capacity_mw
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16073 | 16073 | ITA | Italy | ACCEGLIO | WRI1021706 | 19.0 | 44.4742 | 7.0183 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1015906 | 36.22 | 49.22 | 46.09 | 55.36 | 36.73 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16079 | 16079 | ITA | Italy | ARDENNO | WRI1021354 | 56.0 | 46.1507 | 9.6301 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1015926 | 160.44 | 213.1 | 173.14 | 184.96 | 118.15 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16104 | 16104 | ITA | Italy | BASCHI | WRI1021310 | 80.0 | 42.6564 | 12.2358 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1015938 | 203.67 | 280.02 | 248.28 | 275.49 | 137.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16147 | 16147 | ITA | Italy | COGOLO | WRI1021291 | 98.0 | 46.3371 | 10.6129 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1015979 | 265.12 | 313.27 | 250.36 | 298.17 | 159.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16212 | 16212 | ITA | Italy | GUADALAMI C.LE | WRI1021309 | 80.0 | 37.9544 | 13.2808 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1016013 | 183.17 | 236.11 | 216.95 | 256.71 | 161.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16224 | 16224 | ITA | Italy | ISOLA SERAFINI | WRI1021316 | 76.0 | 45.0911 | 9.9052 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1016017 | 197.04 | 288.41 | 271.51 | 256.65 | 257.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16249 | 16249 | ITA | Italy | MAGISANO | WRI1021318 | 75.0 | 39.0095 | 16.6206 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1016046 | 171.73 | 221.35 | 203.39 | 240.67 | 151.27 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16105 | 16105 | ITA | Italy | BOAZZO | WRI1021297 | 95.0 | 45.9955 | 10.5229 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1016047 | 250.58 | 274.51 | 259.61 | 306.83 | 203.48 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16253 | 16253 | ITA | Italy | MONASTERO | WRI1021355 | 56.0 | 46.1556 | 9.6439 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1016062 | 159.3 | 200.04 | 162.92 | 198.04 | 100.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16134 | 16134 | ITA | Italy | CASTELBELLO | WRI1021303 | 87.0 | 46.6253 | 10.9159 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1042077 | 254.7 | 299.17 | 257.14 | 302.45 | 152.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16128 | 16128 | ITA | Italy | CADARESE | WRI1021327 | 68.0 | 46.2921 | 8.3038 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1047085 | 188.36 | 201.41 | 192.1 | 225.92 | 144.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16135 | 16135 | ITA | Italy | CASTROCUCCO | WRI1021307 | 83.0 | 39.9888 | 15.8085 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1061665 | 190.04 | 244.96 | 225.09 | 266.34 | 176.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16143 | 16143 | ITA | Italy | CHIAVENNA | WRI1021342 | 60.0 | 46.3128 | 9.3963 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1064971 | 163.97 | 201.44 | 151.65 | 202.65 | 76.48 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16457 | 16457 | ITA | Italy | VILLA S.MARIA | WRI1021344 | 60.0 | 42.0154 | 14.3535 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1072029 | 134.16 | 194.3 | 164.46 | 155.55 | 80.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16327 | 16327 | ITA | Italy | PONTE MORASCO | WRI1021299 | 92.0 | 44.9121 | 9.3444 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1081767|1081775 | 259.92 | 300.19 | 232.43 | 251.37 | 127.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16426 | 16426 | ITA | Italy | TORRITE | WRI1021328 | 67.0 | 44.1264 | 10.3934 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1081921 | 139.68 | 196.26 | 178.34 | 191.74 | 92.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
16106 | 16106 | ITA | Italy | BRESSANONE | WRI1021300 | 89.0 | 46.7782 | 11.6321 | Hydro | Ghella | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | WRI | 1081924 | 224.09 | 283.01 | 228.03 | 288.5 | 124.24 | 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");