global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
8 rows where estimated_generation_note_2016 = "HYDRO-V1", owner = "Mercury Energy" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: latitude, commissioning_year
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17757 | 17757 | NZL | New Zealand | Arapuni | WRI1000316 | 192.0 | -38.0714 | 175.6433 | Hydro | 1929.0 | Mercury Energy | Mercury Energy | https://www.mercury.co.nz/About/Renewable-Energy/Hydro-Generation.aspx | GEODB | 1015208 | 809.95 | 839.77 | 647.05 | 670.64 | 804.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17758 | 17758 | NZL | New Zealand | Aratiatia | WRI1000323 | 78.0 | -38.6158 | 176.1425 | Hydro | 1964.0 | Mercury Energy | Mercury Energy | https://www.mercury.co.nz/About/Renewable-Energy/Hydro-Generation.aspx | GEODB | 1015209 | 355.98 | 337.18 | 277.7 | 271.03 | 286.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17759 | 17759 | NZL | New Zealand | Atiamuri | WRI1000321 | 74.0 | -38.3918 | 176.0222 | Hydro | Mercury Energy | Mercury Energy | https://www.mercury.co.nz/About/Renewable-Energy/Hydro-Generation.aspx | GEODB | 1015211 | 341.73 | 331.48 | 255.94 | 273.99 | 335.12 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17770 | 17770 | NZL | New Zealand | Karapiro | WRI1000315 | 96.0 | -37.9243 | 175.5393 | Hydro | 1947.0 | Mercury Energy | Mercury Energy | https://www.mercury.co.nz/About/Renewable-Energy/Hydro-Generation.aspx | GEODB | 1015222 | 431.29 | 445.15 | 345.6 | 364.81 | 431.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17774 | 17774 | NZL | New Zealand | Maraetai | WRI1000318 | 352.0 | -38.3521 | 175.7465 | Hydro | Mercury Energy | Mercury Energy | https://www.mercury.co.nz/About/Renewable-Energy/Hydro-Generation.aspx | GEODB | 1015225 | 1270.07 | 1256.4 | 1000.93 | 982.96 | 1347.45 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
17779 | 17779 | NZL | New Zealand | Ohakuri | WRI1000322 | 106.0 | -38.408 | 176.0886 | Hydro | 1961.0 | Mercury Energy | Mercury Energy | https://www.mercury.co.nz/About/Renewable-Energy/Hydro-Generation.aspx | GEODB | 1015232 | 498.95 | 484.27 | 375.79 | 401.67 | 489.2 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17791 | 17791 | NZL | New Zealand | Waipapa | WRI1000317 | 54.0 | -38.292 | 175.6835 | Hydro | 1961.0 | Mercury Energy | Mercury Energy | https://www.mercury.co.nz/About/Renewable-Energy/Hydro-Generation.aspx | GEODB | 1015243 | 241.89 | 236.89 | 199.2 | 205.81 | 243.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
17796 | 17796 | NZL | New Zealand | Whakamaru | WRI1000319 | 98.0 | -38.3918 | 175.8082 | Hydro | 1956.0 | Mercury Energy | Mercury Energy | https://www.mercury.co.nz/About/Renewable-Energy/Hydro-Generation.aspx | GEODB | 1015246 | 452.83 | 439.25 | 338.96 | 362.86 | 443.81 | 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");