Car Accident Dataset

Road Accident Records in Kensington and Chelsea (January 2021)

@kaggle.nextmillionaire_car_accident_dataset

Table List

1 table(8.95 MB)

Road Accident Data

@kaggle.nextmillionaire_car_accident_dataset.road_accident_data

8.95 MB
307973 rows
21 columns

accident_index Accident Index	accident_date Accident Date	day_of_week Day Of Week	junction_control Junction Control	junction_detail Junction Detail	accident_severity Accident Severity	latitude Latitude	light_conditions Light Conditions	local_authority_district Local Authority (District)	carriageway_hazards Carriageway Hazards	longitude Longitude	number_of_casualties Number Of Casualties	number_of_vehicles Number Of Vehicles	police_force Police Force	road_surface_conditions Road Surface Conditions	road_type Road Type	speed_limit Speed Limit	time Time	urban_or_rural_area Urban Or Rural Area	weather_conditions Weather Conditions	vehicle_type Vehicle Type
200901BS70001	Fri Jan 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thursday	Give way or uncontrolled	T or staggered junction	Serious	51.512273	Daylight	Kensington and Chelsea	nan	-0.201349	1	2	Metropolitan Police	Dry	One way street	30	15:11	Urban	Fine no high winds	Car
200901BS70002	Tue Jan 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	Give way or uncontrolled	Crossroads	Serious	51.514399	Daylight	Kensington and Chelsea	nan	-0.199248	11	2	Metropolitan Police	Wet or damp	Single carriageway	30	10:59	Urban	Fine no high winds	Taxi/Private hire car
200901BS70003	Mon Jan 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sunday	Give way or uncontrolled	T or staggered junction	Slight	51.486668	Daylight	Kensington and Chelsea	nan	-0.179599	1	2	Metropolitan Police	Dry	Single carriageway	30	14:19	Urban	Fine no high winds	Taxi/Private hire car
200901BS70004	Tue Jan 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Monday	Auto traffic signal	T or staggered junction	Serious	51.507804	Daylight	Kensington and Chelsea	nan	-0.20311	1	2	Metropolitan Police	Frost or ice	Single carriageway	30	8:10	Urban	Other	Motorcycle over 500cc
200901BS70005	Wed Jan 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Tuesday	Auto traffic signal	Crossroads	Serious	51.482076	Darkness - lights lit	Kensington and Chelsea	nan	-0.173445	1	2	Metropolitan Police	Dry	Single carriageway	30	17:25	Urban	Fine no high winds	Car
200901BS70006	Fri Jan 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thursday	Give way or uncontrolled	T or staggered junction	Slight	51.493415	Daylight	Kensington and Chelsea	nan	-0.185525	3	2	Metropolitan Police	Dry	Single carriageway	30	11:48	Urban	Fine no high winds	Car
200901BS70007	Fri Jan 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thursday	Give way or uncontrolled	T or staggered junction	Serious	51.480177	Daylight	Kensington and Chelsea	nan	-0.178561	1	2	Metropolitan Police	Dry	Single carriageway	30	13:58	Urban	Fine no high winds	Motorcycle over 500cc
200901BS70008	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Friday	Auto traffic signal	Crossroads	Slight	51.491957	Daylight	Kensington and Chelsea	nan	-0.178524	1	1	Metropolitan Police	Dry	Dual carriageway	30	13:18	Urban	Fine no high winds	Car
200901BS70009	Thu Jan 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wednesday	Give way or uncontrolled	T or staggered junction	Slight	51.49646	Daylight	Kensington and Chelsea	nan	-0.167395	2	1	Metropolitan Police	Dry	Single carriageway	30	12:15	Urban	Fine no high winds	Van / Goods 3.5 tonnes mgw or under
200901BS70010	Sun Jan 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Saturday	Auto traffic signal	Crossroads	Slight	51.48115	Daylight	Kensington and Chelsea	nan	-0.183275	1	1	Metropolitan Police	Wet or damp	Single carriageway	30	9:52	Urban	Other	Car


CREATE TABLE road_accident_data (
  "accident_index" VARCHAR,
  "accident_date" TIMESTAMP,
  "day_of_week" VARCHAR,
  "junction_control" VARCHAR,
  "junction_detail" VARCHAR,
  "accident_severity" VARCHAR,
  "latitude" DOUBLE,
  "light_conditions" VARCHAR,
  "local_authority_district" VARCHAR,
  "carriageway_hazards" VARCHAR,
  "longitude" DOUBLE,
  "number_of_casualties" BIGINT,
  "number_of_vehicles" BIGINT,
  "police_force" VARCHAR,
  "road_surface_conditions" VARCHAR,
  "road_type" VARCHAR,
  "speed_limit" BIGINT,
  "time" VARCHAR,
  "urban_or_rural_area" VARCHAR,
  "weather_conditions" VARCHAR,
  "vehicle_type" VARCHAR
);