Global Power-Plants

Dataset shows list of 35K powerplants with their generation capacity.

@kaggle.ramjasmaurya_global_powerplants

Table List

1 table(1.44 MB)

Powerplants Global Global Power Plants

@kaggle.ramjasmaurya_global_powerplants.powerplants_global_global_power_plants

1.44 MB
34936 rows
15 columns

country_code Country Code	country_long Country Long	name_of_powerplant Name Of Powerplant	capacity_in_mw Capacity In MW	latitude Latitude	longitude Longitude	primary_fuel Primary Fuel	secondary_fuel Secondary Fuel	other_fuel2 Other Fuel2	other_fuel3 Other Fuel3	start_date Start Date	owner_of_plant Owner Of Plant	geolocation_source Geolocation Source	estimated_generation_gwh_2021 Estimated 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
);