Daily Power Generation Data

Daily power generation from all power stations in India 2017-9-1 to 2023-01-22

@kaggle.arvindnagaonkar_power_generation_data

Table List

1 table(3.78 MB)

Powergeneration

@kaggle.arvindnagaonkar_power_generation_data.powergeneration

3.78 MB
334994 rows
11 columns

date Date	power_station Power Station	monitored_cap_mw Monitored Cap.(MW)	total_cap_under_maintenace_mw Total Cap. Under Maintenace (MW)	forced_maintanence_mw Forced Maintanence(MW)	other_reasons_mw Other Reasons (MW)	programme_mw Programme (MW)	actual_mw Actual (MW)	excess_shortfall_mw Excess(+) / Shortfall (-) (MW)	deviation_mw Deviation (MW)
01-09-2017	Delhi	2235.4	135	135		13.29	18.29	5	37.62
01-09-2017	STPL	1350	1350	1350
01-09-2017	SPPL	150	150	150
01-09-2017	SPL	3960				92.13	96.16	4.03	4.37
01-09-2017	SKS	600	300	300		6.84	7.18	0.34	4.97
01-09-2017	SCPL	100				1.81	2.28	0.47	25.97
01-09-2017	RKMPPL	1440	720	720		9.59	16.5	6.91	72.05
01-09-2017	RGPPL	1967.08	1303.54		1303.54	6.98	10.35	3.37	48.28
01-09-2017	SVPPL	63	63	63
01-09-2017	RELIANCE	48	48		48


CREATE TABLE powergeneration (
  "date" VARCHAR,
  "power_station" VARCHAR,
  "monitored_cap_mw" DOUBLE,
  "total_cap_under_maintenace_mw" DOUBLE,
  "planned_maintanence_mw" DOUBLE,
  "forced_maintanence_mw" DOUBLE,
  "other_reasons_mw" DOUBLE,
  "programme_mw" DOUBLE,
  "actual_mw" DOUBLE,
  "excess_shortfall_mw" DOUBLE,
  "deviation_mw" DOUBLE
);