Global Power-Plants
Dataset shows list of 35K powerplants with their generation capacity.
@kaggle.ramjasmaurya_global_powerplants
Powerplants Global Global Power Plants
@kaggle.ramjasmaurya_global_powerplants.powerplants_global_global_power_plants
- 1.44 MB
- 34936 rows
- 15 columns
country_codeCountry Code | country_longCountry Long | name_of_powerplantName Of Powerplant | capacity_in_mwCapacity In MW | latitudeLatitude | longitudeLongitude | primary_fuelPrimary Fuel | secondary_fuelSecondary Fuel | other_fuel2Other Fuel2 | other_fuel3Other Fuel3 | start_dateStart Date | owner_of_plantOwner Of Plant | generation_gwh_2021Generation Gwh 2021 | geolocation_sourceGeolocation Source | estimated_generation_gwh_2021Estimated Generation Gwh 2021 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AFG | Afghanistan | Kajaki Hydroelectric Power Plant Afghanistan | 33 | 32.322 | 65.119 | Hydro | nan | nan | nan | nan | GEODB | 123.77 | ||
| AFG | Afghanistan | Kandahar DOG | 10 | 31.67 | 65.795 | Solar | nan | nan | nan | nan | Wiki-Solar | 18.43 | ||
| AFG | Afghanistan | Kandahar JOL | 10 | 31.623 | 65.792 | Solar | nan | nan | nan | nan | Wiki-Solar | 18.64 | ||
| AFG | Afghanistan | Mahipar Hydroelectric Power Plant Afghanistan | 66 | 34.556 | 69.4787 | Hydro | nan | nan | nan | nan | GEODB | 225.06 | ||
| AFG | Afghanistan | Naghlu Dam Hydroelectric Power Plant Afghanistan | 100 | 34.641 | 69.717 | Hydro | nan | nan | nan | nan | GEODB | 406.16 | ||
| AFG | Afghanistan | Nangarhar (Darunta) Hydroelectric Power Plant Afghanistan | 11.55 | 34.4847 | 70.3633 | Hydro | nan | nan | nan | nan | GEODB | 58.77 | ||
| AFG | Afghanistan | Northwest Kabul Power Plant Afghanistan | 42 | 34.5638 | 69.1134 | Gas | nan | nan | nan | nan | GEODB | |||
| AFG | Afghanistan | Pul-e-Khumri Hydroelectric Power Plant Afghanistan | 6 | 35.9416 | 68.71 | Hydro | nan | nan | nan | nan | GEODB | 21.99 | ||
| AFG | Afghanistan | Sarobi Dam Hydroelectric Power Plant Afghanistan | 22 | 34.5865 | 69.7757 | Hydro | nan | nan | nan | nan | GEODB | 123.23 | ||
| ALB | Albania | Bistrica 1 | 27 | 39.9116 | 20.1047 | Hydro | nan | nan | nan | 1965 | nan | GEODB | 105.17 |
CREATE TABLE powerplants_global_global_power_plants (
"country_code" VARCHAR,
"country_long" VARCHAR,
"name_of_powerplant" VARCHAR,
"capacity_in_mw" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"primary_fuel" VARCHAR,
"secondary_fuel" VARCHAR,
"other_fuel2" VARCHAR,
"other_fuel3" VARCHAR,
"start_date" DOUBLE,
"owner_of_plant" VARCHAR,
"generation_gwh_2021" DOUBLE,
"geolocation_source" VARCHAR,
"estimated_generation_gwh_2021" DOUBLE
);