Road Accidents In The Czech Republic
Detailed dataset of road accidents in the Czech Republic (2016-2022)
@kaggle.pereprosov_road_accidents_in_the_czech_republic
Detailed dataset of road accidents in the Czech Republic (2016-2022)
@kaggle.pereprosov_road_accidents_in_the_czech_republic
CREATE TABLE pedestrian (
"unnamed_0" BIGINT,
"id" BIGINT,
"pedestrian_category" VARCHAR,
"pedestrian_condition" VARCHAR,
"pedestrian_behaviour" VARCHAR,
"situation_at_the_point_of_accident" VARCHAR
);
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
);
Anyone who has the link will be able to view this.