The ID is a unique fingerprint that is calculated based on the values of all non-Fusionbase specific columns.

fb_id

land

administrative_region

administrative_district

municipality

year

month

hour

1 = sunday
2 = monday
3 = tuesday
4 = wednesday
5 = thursday
6 = friday
7 = saturday

day_of_week

1 = Accident with persons killed
2 = Accident with seriously injured
3 = Accident with slightly injured 

kind

1 = Driving accident
2 = Accident caused by turning off the road
3 = Accident caused by turning into a road or by crossing it
4 = Accident caused by crossing the road
5 = Accident involving stationary
6 = Accident between vehicles moving along in carriageway
7 = Other accident

type

light_conditions

0 = dry
1 = wet/damp/slippery
2 = slippery (winter)

road_surface_conditions

0 = Accident without any bicycle involved
1 = accident in which at least one bicycle was involved

accident_with_bicycle

0 = Accident without any passenger car involved
1 = accident in which at least one passenger car was involved

accident_with_passenger_car

0 = Accident without any pedestrian involved
1 = accident in which at least one pedestrian was involved

accident_with_pedestrian

0 = Accident without any motorcycle involved
1 = accident in which at least one motorcycle was involved

accident_with_motorcycle

Accident involving at least one truck with a normal body and a total weight of more than 3.5 t, a truck with a tanker body or a special special superstructure, a semitrailer tractor or another tractor other tractor was involved.
This category is included in 2016 and 2017 in 'Accident with others'

0 = Accident without any goods road vehicle involved
1 = accident in which at least one goods road vehicle was involved

accident_with_goods_road_vehicle

0 = Accident without any other means of transport involved
1 = accident in which at least one other means of transport was involved

accident_with_others

linref_x and linref_y are the coordinates of the place of accident in the road section (UTM coordinates of the reference system ETRS89, zone 32N)

linref_x

linref_y

reference_year

The ISO-8601 timestamp of when the record was added to the data stream.

fb_datetime

Each new set of records that is added to the data stream gets automatically versioned by Fusionbase.

fb_data_version

This dataset provides a comprehensive overview of accidents across Germany, including details about accident locations, causes, and outcomes. It's a valuable resource for safety analysts, traffic planners, and researchers.
Potential use cases:
Traffic safety departments can use this data to identify accident-prone areas and implement safety measures.

Germany: National Accident Atlas

Germany: National Accident Atlas

Attributes

Related Streams