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
Daily power generation from all power stations in India 2017-9-1 to 2023-01-22
@kaggle.arvindnagaonkar_power_generation_data
There are two files with the same content but different file formats. Files contain daily reports of all Power stations (regional-wise) with Expected power generation, actual power generation, Deviation, etc. in unit MU ( A million units, designated MU, is a gigawatt-hour ) and MW (megawatt)
1.Date : Power Generation for each power station from 2017-09-01 to 2023-01-19,
Missing Data for this dates : [2017-10-02, 2017-11-19, 2017-11-26, 2018-04-03, 2018-04-04,
2020-03-19 to 2020-05-31]
2.Power Station: Power Stations names.
3.Programme (MW): Estimate this much power needed to generate.
4.Actual (MW): Actual Power generated in the station.
5.Excess(+) / Shortfall (-) (MW) : Over-produce or Under-produce power
Don't forget to give an upvote, if you liked it :)
CREATE TABLE powergeneration (
"date" VARCHAR,
"power_station" VARCHAR,
"monitored_cap_mw" DOUBLE -- Monitored Cap.(MW),
"total_cap_under_maintenace_mw" DOUBLE -- Total Cap. Under Maintenace (MW),
"planned_maintanence_mw" DOUBLE -- Planned Maintanence (MW),
"forced_maintanence_mw" DOUBLE -- Forced Maintanence(MW),
"other_reasons_mw" DOUBLE -- Other Reasons (MW),
"programme_mw" DOUBLE -- Programme (MW),
"actual_mw" DOUBLE -- Actual (MW),
"excess_shortfall_mw" DOUBLE -- Excess(+) / Shortfall (-) (MW),
"deviation_mw" DOUBLE -- Deviation (MW)
);Anyone who has the link will be able to view this.