Dataset: Road Accidents In The Czech Republic

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

315.38 KB
22945 rows
6 columns


CREATE TABLE pedestrian (
  "unnamed_0" BIGINT,
  "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

19.23 MB
707027 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,
  "driver_category" VARCHAR,
  "driver_condition" VARCHAR,
  "driver_external_influence" VARCHAR,
  "city" VARCHAR,
  "street" VARCHAR,
  "road_type" VARCHAR,
  "location" VARCHAR
);