Road Accident Severity In India

This data set is collected from Indian city police departments for Master's

@kaggle.s3programmer_road_accident_severity_in_india

Table List

1 table(115.55 KB)

Road

@kaggle.s3programmer_road_accident_severity_in_india.road

115.55 KB
12316 rows
32 columns

time Time	day_of_week Day Of Week	age_band_of_driver Age Band Of Driver	sex_of_driver Sex Of Driver	educational_level Educational Level	vehicle_driver_relation Vehicle Driver Relation	driving_experience Driving Experience	type_of_vehicle Type Of Vehicle	owner_of_vehicle Owner Of Vehicle	service_year_of_vehicle Service Year Of Vehicle	defect_of_vehicle Defect Of Vehicle	area_accident_occured Area Accident Occured	lanes_or_medians Lanes Or Medians	road_allignment Road Allignment	types_of_junction Types Of Junction	road_surface_type Road Surface Type	road_surface_conditions Road Surface Conditions	light_conditions Light Conditions	weather_conditions Weather Conditions	type_of_collision Type Of Collision	number_of_vehicles_involved Number Of Vehicles Involved	number_of_casualties Number Of Casualties	vehicle_movement Vehicle Movement	casualty_class Casualty Class	sex_of_casualty Sex Of Casualty	age_band_of_casualty Age Band Of Casualty	casualty_severity Casualty Severity	work_of_casuality Work Of Casuality	fitness_of_casuality Fitness Of Casuality	pedestrian_movement Pedestrian Movement	cause_of_accident Cause Of Accident	accident_severity Accident Severity
17:02:00	Monday	18-30	Male	Above high school	Employee	1-2yr	Automobile	Owner	Above 10yr	No defect	Residential areas	nan	Tangent road with flat terrain	No junction	Asphalt roads	Dry	Daylight	Normal	Collision with roadside-parked vehicles	2	2	Going straight	na	na	na	na	nan	nan	Not a Pedestrian	Moving Backward	Slight Injury
17:02:00	Monday	31-50	Male	Junior high school	Employee	Above 10yr	Public (> 45 seats)	Owner	5-10yrs	No defect	Office areas	Undivided Two way	Tangent road with flat terrain	No junction	Asphalt roads	Dry	Daylight	Normal	Vehicle with vehicle collision	2	2	Going straight	na	na	na	na	nan	nan	Not a Pedestrian	Overtaking	Slight Injury
17:02:00	Monday	18-30	Male	Junior high school	Employee	1-2yr	Lorry (41?100Q)	Owner	nan	No defect	Recreational areas	other	nan	No junction	Asphalt roads	Dry	Daylight	Normal	Collision with roadside objects	2	2	Going straight	Driver or rider	Male	31-50	3	Driver	nan	Not a Pedestrian	Changing lane to the left	Serious Injury
1:06:00	Sunday	18-30	Male	Junior high school	Employee	5-10yr	Public (> 45 seats)	Governmental	nan	No defect	Office areas	other	Tangent road with mild grade and flat terrain	Y Shape	Earth roads	Dry	Darkness - lights lit	Normal	Vehicle with vehicle collision	2	2	Going straight	Pedestrian	Female	18-30	3	Driver	Normal	Not a Pedestrian	Changing lane to the right	Slight Injury
1:06:00	Sunday	18-30	Male	Junior high school	Employee	2-5yr	nan	Owner	5-10yrs	No defect	Industrial areas	other	Tangent road with flat terrain	Y Shape	Asphalt roads	Dry	Darkness - lights lit	Normal	Vehicle with vehicle collision	2	2	Going straight	na	na	na	na	nan	nan	Not a Pedestrian	Overtaking	Slight Injury
14:15:00	Friday	31-50	Male	nan	Unknown	nan	nan	nan	nan	nan	nan	nan	nan	Y Shape	nan	Dry	Daylight	Normal	Vehicle with vehicle collision	1	1	U-Turn	Driver or rider	Male	31-50	3	Driver	Normal	Not a Pedestrian	Overloading	Slight Injury
17:30:00	Wednesday	18-30	Male	Junior high school	Employee	2-5yr	Automobile	Owner	nan	No defect	Residential areas	Undivided Two way	Tangent road with flat terrain	Crossing	nan	Dry	Daylight	Normal	Vehicle with vehicle collision	1	1	Moving Backward	Driver or rider	Female	18-30	3	Driver	Normal	Not a Pedestrian	Other	Slight Injury
17:20:00	Friday	18-30	Male	Junior high school	Employee	2-5yr	Automobile	Governmental	Above 10yr	No defect	Residential areas	other	Tangent road with flat terrain	Y Shape	Asphalt roads	Dry	Daylight	Normal	Vehicle with vehicle collision	2	1	U-Turn	na	na	na	na	nan	Normal	Not a Pedestrian	No priority to vehicle	Slight Injury
17:20:00	Friday	18-30	Male	Junior high school	Employee	Above 10yr	Lorry (41?100Q)	Owner	1-2yr	No defect	Industrial areas	other	Tangent road with flat terrain	Y Shape	Earth roads	Dry	Daylight	Normal	Collision with roadside-parked vehicles	2	1	Going straight	Pedestrian	Male	Under 18	3	Driver	Normal	Crossing from driver's nearside	Changing lane to the right	Slight Injury
17:20:00	Friday	18-30	Male	Junior high school	Employee	1-2yr	Automobile	Owner	2-5yrs	No defect	Residential areas	Undivided Two way	Tangent road with flat terrain	Y Shape	Asphalt roads	Dry	Daylight	Normal	Collision with roadside-parked vehicles	2	1	U-Turn	Passenger	Male	18-30	3	Driver	Normal	Not a Pedestrian	Moving Backward	Serious Injury


CREATE TABLE road (
  "time" VARCHAR,
  "day_of_week" VARCHAR,
  "age_band_of_driver" VARCHAR,
  "sex_of_driver" VARCHAR,
  "educational_level" VARCHAR,
  "vehicle_driver_relation" VARCHAR,
  "driving_experience" VARCHAR,
  "type_of_vehicle" VARCHAR,
  "owner_of_vehicle" VARCHAR,
  "service_year_of_vehicle" VARCHAR,
  "defect_of_vehicle" VARCHAR,
  "area_accident_occured" VARCHAR,
  "lanes_or_medians" VARCHAR,
  "road_allignment" VARCHAR,
  "types_of_junction" VARCHAR,
  "road_surface_type" VARCHAR,
  "road_surface_conditions" VARCHAR,
  "light_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "type_of_collision" VARCHAR,
  "number_of_vehicles_involved" BIGINT,
  "number_of_casualties" BIGINT,
  "vehicle_movement" VARCHAR,
  "casualty_class" VARCHAR,
  "sex_of_casualty" VARCHAR,
  "age_band_of_casualty" VARCHAR,
  "casualty_severity" VARCHAR,
  "work_of_casuality" VARCHAR,
  "fitness_of_casuality" VARCHAR,
  "pedestrian_movement" VARCHAR,
  "cause_of_accident" VARCHAR,
  "accident_severity" VARCHAR
);