Dataset: Indian Railway Safety Budget And Accidents

About this Dataset

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

Tables

Indian Railway Safety Budget And Accidents Version 2

@kaggle.joeljosehubert_indian_railway_safety_budget_and_accidents.indian_railway_safety_budget_and_accidents_version_2

18.51 KB
17 rows
21 columns


CREATE TABLE indian_railway_safety_budget_and_accidents_version_2 (
  "year" VARCHAR,
  "railway_safety_fund_total_grant_cr" DOUBLE,
  "railway_safety_fund_actual_expenditure_cr" DOUBLE,
  "depreciation_reserve_fund_drf" DOUBLE,
  "depreciation_reserve_fund_actual_utilisation_cr" DOUBLE,
  "total_working_expenditure_cr" DOUBLE,
  "total_working_expenditure_actual_expenditure_cr" DOUBLE,
  "ordinary_working_expense_cr" DOUBLE,
  "actual_ordinary_working_expense_cr" DOUBLE,
  "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
);