Find Accidents Trends in inter-urban roads and junctions

[atalyaalon]

1st Challenge:
Find trends (that are statistically significant) of increase, decrease and outliers in accidents in Israel over time.
The goal is to identify specific locations, like streets, junctions, roads sections, that experienced these trends and create a dashboard presenting these patterns with indications for locations with significant outliers (of increase or decrease).

In inter-urban roads and junctions
Relevant columns: road1, km (km is in hundreds of meters), road2

road2 column appears only in junctions.
Suggestion: separate the following cases:

• accidents on roads
• accident on junctions