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

49.22 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_2020" DOUBLE,
  "accidents_per_lakh_population_2017" DOUBLE,
  "total_number_of_accidents_per_lakh_population_2018" DOUBLE,
  "total_number_of_accidents_per_lakh_population_2019" DOUBLE,
  "total_number_of_accidents_per_lakh_population_2020" DOUBLE,
  "accidents_per_10_000_vehicles_2017" DOUBLE,
  "accidents_per_10_000_vehicles_2018" DOUBLE,
  "accidents_per_10_000_vehicles_2019" DOUBLE,
  "accidents_per_10_000_km_of_roads_2017" DOUBLE,
  "accidents_per_10_000_km_of_roads_2018" DOUBLE,
  "persons_killed_2017" BIGINT,
  "persons_killed_2018" BIGINT,
  "persons_killed_2019" BIGINT,
  "persons_killed_2020" DOUBLE,
  "share_in_death_2017" DOUBLE,
  "share_in_death_2018" DOUBLE,
  "share_in_death_2019" DOUBLE,
  "share_in_death_2020" DOUBLE,
  "persons_killed_per_lakh_population_2017" DOUBLE,
  "persons_killed_per_lakh_population_2018" DOUBLE,
  "persons_killed_per_lakh_population_2019" DOUBLE,
  "persons_killed_per_lakh_population_2020" DOUBLE,
  "persons_killed_per_10_000_vehicles_2017" DOUBLE,
  "persons_killed_per_10_000_vehicles_2018" DOUBLE,
  "persons_killed_per_10_000_vehicles_2019" DOUBLE,
  "persons_killed_per_10_000_km_of_roads_2017" DOUBLE,
  "persons_killed_per_10_000_km_of_roads_2018" DOUBLE,
  "persons_injured_2017" BIGINT,
  "persons_injured_2018" BIGINT,
  "persons_injured_2019" BIGINT,
  "persons_injured_2020" DOUBLE,
  "injury_per_lakh_population_2017" DOUBLE,
  "injury_per_lakh_population_2018" DOUBLE,
  "injury_per_lakh_population_2019" DOUBLE,
  "injury_per_lakh_population_2020" DOUBLE,
  "road_accidents_per_10_000_vehicles_2016" DOUBLE,
  "road_accidents_per_10_000_vehicles_2017" DOUBLE,
  "road_accidents_per_10_000_vehicles_2018" DOUBLE,
  "road_accidents_per_10_000_vehicles_2019" DOUBLE,
  "injury_per_10_000_km_of_roads_2016" DOUBLE,
  "injury_per_10_000_km_of_roads_2017" DOUBLE,
  "injury_per_10_000_km_of_roads_2018" DOUBLE
);