Name: Road Accidents In The Czech Republic
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Road Accidents In The Czech Republic

The police of Czech Republic regularly gathers and releases detailed data on traffic incidents throughout the nation, typically on an monthly basis. This dataset covers various aspects such as geographic locations, weather conditions, vehicle types, casualty counts, and vehicle maneuvers. The wealth of information makes it a compelling and extensive dataset for analysis and research purposes.

Most coded variables in the data have been translated into text strings using lookup tables, making the analysis more efficient and user-friendly.
After analyzing the dataset, I've filled in the majority of NaN values.

Content
The data come from the police of Czech Republic

The dataset comprises of two csv files:

road_accidents_czechia_2016_2022.csv: every line in the file represents a unique traffic accident, featuring various properties related to the accident as columns
pedestrian.csv: Each line in the file corresponds to a distinct pedestrian-involved traffic incident, with various incident-related attributes captured as columns.

Tables

Pedestrian

@kaggle.pereprosov_road_accidents_in_the_czech_republic.pedestrian

322.95 kB
22,945 rows
6 columns

CREATE TABLE pedestrian (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "pedestrian_category" VARCHAR,
  "pedestrian_condition" VARCHAR,
  "pedestrian_behaviour" VARCHAR,
  "situation_at_the_point_of_accident" VARCHAR
);

Road Accidents Czechia 2016–2022

@kaggle.pereprosov_road_accidents_in_the_czech_republic.road_accidents_czechia_2016_2022

20.16 MB
707,027 rows
46 columns

CREATE TABLE road_accidents_czechia_2016_2022 (
  "id" DOUBLE,
  "communication_kind" VARCHAR,
  "date" TIMESTAMP,
  "time" DOUBLE,
  "accident_kind" VARCHAR,
  "crash_kind" VARCHAR,
  "fixed_precaution_kind" VARCHAR,
  "injury" DOUBLE,
  "cause_of_accident" VARCHAR,
  "alcohol" VARCHAR,
  "main_cause_of_accident" VARCHAR,
  "killed_persons" DOUBLE,
  "severely_injured_persons" DOUBLE,
  "slightly_injured_persons" DOUBLE,
  "total_material_damage" DOUBLE,
  "road_surface_type" VARCHAR,
  "condition_of_vehicle_surface" VARCHAR,
  "condition_of_communication" VARCHAR,
  "weather_conditions_at_the_time_of_accident" VARCHAR,
  "visibility" VARCHAR,
  "visibility_ratios" VARCHAR,
  "communication_division" VARCHAR,
  "communication_accident_situation" VARCHAR,
  "traffic_control_at_the_time_of_an_accident" VARCHAR,
  "local_administration_priority_in_traffic" VARCHAR,
  "specific_location_and_objects_in_the_location_of_the_accident" VARCHAR,
  "directional_rates" VARCHAR,
  "number_of_vehicles_involved" DOUBLE,
  "location_of_the_traffic_accident" VARCHAR,
  "vehicle_type" VARCHAR,
  "vehicle_brand" VARCHAR,
  "year_of_manufacture" DOUBLE,
  "vehicle_owner" VARCHAR,
  "skid" VARCHAR,
  "vehicle_sequel" VARCHAR,
  "leakage_of_transported_materials" VARCHAR,
  "way_of_releasing_persons_from_the_vehicle" VARCHAR,
  "direction_of_movement" VARCHAR,
  "damage_to_the_vehicle_in_hundred_crowns" DOUBLE  -- Damage To The Vehicle(in Hundred Crowns),
  "driver_category" VARCHAR,
  "driver_condition" VARCHAR,
  "driver_external_influence" VARCHAR,
  "city" VARCHAR,
  "street" VARCHAR,
  "road_type" VARCHAR,
  "location" VARCHAR
);