COVID Deaths Worldwide Evolution Dashboard - Architecture et Performance

This dashboard show main key figures for COVID deaths wordwide and the evolution of number of deaths.

Filtering data using continent/area and country map to see the evolution of number of deaths and letality for the whole area selected

For the moment data are refreshed weekly

sources data from google public dataset : they made a pivot of John Hopkins University covid csse data.

Select statement made on the Google Big Query public dataset

SELECT  
  covid.country_name AS country_region,
  covid.date,
  MAX(cumulative_confirmed) AS confirmed,
  MAX(cumulative_deceased) AS deaths,
  MAX(cumulative_recovered) AS recovered,
  SUM(new_deceased) as new_deceased,
  SUM(new_recovered) as new_recovered,
  SUM(new_confirmed) as new_confirmed
FROM
  `bigquery-public-data.covid19_open_data.covid19_open_data` covid
WHERE covid.subregion1_name IS NULL
GROUP BY 
  covid.country_name,
  covid.date