Widget: Severe and fatal accidents on a certain day compared to other years.

galraij commented 3 years ago

Name Severe and fatal accidents on a certain day compared to other years.

Title Infographic name to be used in FE.

Visualization weekly_presentation_weekly_presentation_20201206

Visualization explanation Explain visualization content.

Use case When this infographic should be displayed

SQL query Sql clause and usage guidance. In addition to query, detail which parameters should be modified when executing it and which output fields are language specific When creating the query and filtering CBS data - it's better to use the numeric values of the categorical fields (accident_severity = 1 is better than accident_severity_hebrew = 'תאונה קטלנית'). For code redeablity - one can create constants and dictionaries.

Additional context

Definition will be used by BE team to generate a Json response to FE
Definition will be provided by Data team, after internal review
Definition will be written in English and should use language agnostic definitions and data structures (e.g. SQL columns) as much as possible.

ChayneAzriel commented 3 years ago

redash query

below are options for presenting this info 1

2 fatal_sep

3 severe_fatal_avg

ChayneAzriel commented 3 years ago

if we are still creating this kind of infographics this one is waiting for comments

data-for-change / anyway

Widget: Severe and fatal accidents on a certain day compared to other years. #1629