Name: Road Accidents India : 2017 - 2020
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Road Accidents India : 2017 - 2020

The dataset is taken from the GOI site for Road and Transport Ministry for public safety.
It reflects the number of accidents , their nature and the fatalities . It also looks into the numbers , shares and unit wise distribution of the calamity.
The time span is from 2017 - 2020

Tables

India Injury Road Accident Fatality 2017–2020

@kaggle.zsinghrahulk_road_accidents_india_2017_2020.india_injury_road_accident_fatality_2017_2020

50.4 kB
37 rows
45 columns

CREATE TABLE india_injury_road_accident_fatality_2017_2020 (
  "state" VARCHAR,
  "road_accidents_during_2018" BIGINT,
  "n__road_accidents_during_2019" BIGINT  -- Road Accidents During 2019,
  "road_accidents_during_2020" DOUBLE,
  "accidents_per_lakh_population_2017" DOUBLE  -- Accidents Per Lakh Population - 2017,
  "total_number_of_accidents_per_lakh_population_2018" DOUBLE  -- Total Number Of Accidents Per Lakh Population - 2018,
  "total_number_of_accidents_per_lakh_population_2019" DOUBLE  -- Total Number Of Accidents Per Lakh Population - 2019,
  "total_number_of_accidents_per_lakh_population_2020" DOUBLE  -- Total Number Of Accidents Per Lakh Population - 2020,
  "accidents_per_10_000_vehicles_2017" DOUBLE  -- Accidents Per 10,000 Vehicles - 2017,
  "accidents_per_10_000_vehicles_2018" DOUBLE  -- Accidents Per 10,000 Vehicles - 2018,
  "accidents_per_10_000_vehicles_2019" DOUBLE  -- Accidents Per 10,000 Vehicles - 2019,
  "accidents_per_10_000_km_of_roads_2017" DOUBLE  -- Accidents Per 10,000 Km Of Roads - 2017,
  "accidents_per_10_000_km_of_roads_2018" DOUBLE  -- Accidents Per 10,000 Km Of Roads - 2018,
  "persons_killed_2017" BIGINT,
  "persons_killed_2018" BIGINT,
  "persons_killed_2019" BIGINT,
  "persons_killed_2020" DOUBLE,
  "share_in_death_2017" DOUBLE  -- Share In Death- 2017,
  "share_in_death_2018" DOUBLE  -- Share In Death- 2018,
  "share_in_death_2019" DOUBLE  -- Share In Death- 2019,
  "share_in_death_2020" DOUBLE  -- Share In Death- 2020,
  "persons_killed_per_lakh_population_2017" DOUBLE  -- Persons Killed Per Lakh Population - 2017,
  "persons_killed_per_lakh_population_2018" DOUBLE  -- Persons Killed Per Lakh Population - 2018,
  "persons_killed_per_lakh_population_2019" DOUBLE  -- Persons Killed Per Lakh Population - 2019,
  "persons_killed_per_lakh_population_2020" DOUBLE  -- Persons Killed Per Lakh Population - 2020,
  "persons_killed_per_10_000_vehicles_2017" DOUBLE  -- Persons Killed Per 10,000 Vehicles - 2017,
  "persons_killed_per_10_000_vehicles_2018" DOUBLE  -- Persons Killed Per 10,000 Vehicles - 2018,
  "persons_killed_per_10_000_vehicles_2019" DOUBLE  -- Persons Killed Per 10,000 Vehicles - 2019,
  "persons_killed_per_10_000_km_of_roads_2017" DOUBLE  -- Persons Killed Per 10,000 Km Of Roads - 2017,
  "persons_killed_per_10_000_km_of_roads_2018" DOUBLE  -- Persons Killed Per 10,000 Km Of Roads - 2018,
  "persons_injured_2017" BIGINT  -- Persons Injured - 2017,
  "persons_injured_2018" BIGINT  -- Persons Injured - 2018,
  "persons_injured_2019" BIGINT  -- Persons Injured - 2019,
  "persons_injured_2020" DOUBLE  -- Persons Injured - 2020,
  "injury_per_lakh_population_2017" DOUBLE  -- Injury Per Lakh Population - 2017,
  "injury_per_lakh_population_2018" DOUBLE  -- Injury Per Lakh Population - 2018,
  "injury_per_lakh_population_2019" DOUBLE  -- Injury Per Lakh Population - 2019,
  "injury_per_lakh_population_2020" DOUBLE  -- Injury Per Lakh Population - 2020,
  "road_accidents_per_10_000_vehicles_2016" DOUBLE  -- Road Accidents Per 10,000 Vehicles- 2016,
  "road_accidents_per_10_000_vehicles_2017" DOUBLE  -- Road Accidents Per 10,000 Vehicles- 2017,
  "road_accidents_per_10_000_vehicles_2018" DOUBLE  -- Road Accidents Per 10,000 Vehicles- 2018,
  "road_accidents_per_10_000_vehicles_2019" DOUBLE  -- Road Accidents Per 10,000 Vehicles- 2019,
  "injury_per_10_000_km_of_roads_2016" DOUBLE  -- Injury Per 10,000 Km Of Roads - 2016,
  "injury_per_10_000_km_of_roads_2017" DOUBLE  -- Injury Per 10,000 Km Of Roads - 2017,
  "injury_per_10_000_km_of_roads_2018" DOUBLE  -- Injury Per 10,000 Km Of Roads - 2018
);