global-power-plants
>10,000 rows count all
This data as json, CSV (advanced)
country_long >30
- United States of America 8,688
- China 4,235
- United Kingdom 2,603
- Brazil 2,360
- France 2,155
- India 1,590
- Germany 1,309
- Canada 1,159
- Spain 829
- Russia 545
- Japan 522
- Australia 485
- Portugal 469
- Czech Republic 462
- Italy 396
- Chile 315
- Norway 306
- Mexico 277
- Vietnam 236
- Argentina 228
- Thailand 196
- Poland 189
- Finland 185
- Indonesia 178
- Sweden 168
- Switzerland 168
- Turkey 163
- South Korea 132
- Philippines 123
- Iran 107
- …
owner >30
- Lightsource Renewable Energy 120
- Cypress Creek Renewables 109
- Sustainable Power Group LLC 85
- Verbund 83
- Pacific Gas & Electric Co. 81
- Erie Boulevard Hydropower LP 71
- CFE 66
- 100% Vattenfall 65
- Southern California Edison Co 62
- WM Renewable Energy LLC 61
- PacifiCorp 59
- Hydro-Québec 58
- Tesla Inc. 58
- Avangrid Renewables LLC 57
- EDF 57
- ENDESA GENERACION S.A. 57
- U S Bureau of Reclamation 57
- Fortum 55
- Tennessee Valley Authority 55
- PJSC "RusHydro" 53
- Saudi Electricity Company (SEC) 53
- PJSC "TGC-1" 48
- Scottish and Southern Energy (SSE) 48
- Consolidated Edison Development Inc. 47
- Southern Power Co 47
- Anesco 46
- Duke Energy Carolinas LLC 46
- Waste Recycling Group 45
- China Guodian Group Corporation 42
- Dominion Renewable Energy 42
- …
primary_fuel 15
- Solar 9,633
- Hydro 7,133
- Wind 5,187
- Gas 3,885
- Coal 2,390
- Oil 2,281
- Biomass 1,396
- Waste 1,087
- Nuclear 198
- Geothermal 189
- Storage 58
- Other 42
- Cogeneration 41
- Petcoke 13
- Wave and Tidal 10
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_data_source" TEXT,
"estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");