Widget: Total accidents involving pedestrians comparison - city vs specific street per accident severity #1647

Name
Percentage of severe and fatal accidents involving pedestrians on a certain road compared to the rest of the city.

Title
Total accidents involving Pedestrians by accident severity - street ___ vs city

____ השוואת מספר התאונות עם הולך רגל לפי חומרה - רחוב _____ בהשוואה לעיר

Visualization

Visualization explanation
Explain visualization content.

Use case
When the percentage of severe and fatal accidents on road_x is greater than 1.5 times the percentage of severe and fatal accidents in the city.

SQL query
query on redash
modified parameters:
street1,street2, accident_yishuv_symbol.
Additional context