Indian Railway Safety Budget And Accidents
Provides data on Indian Railways, accidents, deaths and budget
@kaggle.joeljosehubert_indian_railway_safety_budget_and_accidents
Provides data on Indian Railways, accidents, deaths and budget
@kaggle.joeljosehubert_indian_railway_safety_budget_and_accidents
The motivation to create this dataset stemmed from the recent (6th June 2023) train derailment in Odisha, India which resulted in reportedly 288 deaths. This is the deadliest train accident in India of this century and brought back focus on the safety of Indian Railways. While the train accident itself triggered political commentary on the state of safety of Indian Railways and resulted in salvos and ripostes across the political spectrum, I consciously decided to remove myself from the discourse and publish it once the sensationalism surrounding the tragedy subsides.
Challenges encountered to compile this dataset
CREATE TABLE indian_railway_safety_budget_and_accidents_version_2 (
"year" VARCHAR,
"railway_safety_fund_total_grant_cr" DOUBLE -- Railway Safety Fund- Total Grant (cr),
"railway_safety_fund_actual_expenditure_cr" DOUBLE -- Railway Safety Fund-Actual Expenditure (cr),
"depreciation_reserve_fund_drf" DOUBLE -- Depreciation Reserve Fund (DRF),
"depreciation_reserve_fund_actual_utilisation_cr" DOUBLE -- Depreciation Reserve Fund- Actual Utilisation (cr),
"total_working_expenditure_cr" DOUBLE -- Total Working Expenditure(cr),
"total_working_expenditure_actual_expenditure_cr" DOUBLE -- Total Working Expenditure- Actual Expenditure (cr),
"ordinary_working_expense_cr" DOUBLE -- Ordinary Working Expense (cr),
"actual_ordinary_working_expense_cr" DOUBLE -- Actual Ordinary Working Expense (cr),
"collisions" BIGINT,
"collision_casualties" DOUBLE,
"derailments" BIGINT,
"derailment_casualties" DOUBLE,
"lc_accidents" BIGINT,
"lc_casualties" DOUBLE,
"fire_accidents" BIGINT,
"fire_casualties" DOUBLE,
"miscellaneous" BIGINT,
"miscellaneous_casualties" DOUBLE,
"total_casualties" BIGINT,
"number_of_passengers_millions" DOUBLE -- Number Of Passengers (millions)
);
Anyone who has the link will be able to view this.