Widget: accidents up to a certain date compared to other years by age

[galraij]

Name accidents up to a certain date compared to other years by age

Title Infographic name to be used in FE.

Visualization @galraij please update visualization when ready

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.

[atalyaalon]

@MichalOren since we'll create an implementation of this graph implementation per segment/street - there is no need to create a redash new query - just to clarify in the text above differences between this Widget (which is per segment / street): https://github.com/hasadna/anyway/issues/1645 to the current one which includes the whole country

Also it's important to clarity that the years in which the data is filtered are determined by the FrontEnd (as in all Widgets)