Data Visualization26 August 20211 min de lectureArticle en anglais

COVID Deaths Worldwide Evolution Dashboard

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…

Romain FERRATON

Expert en Performance IT

#Business Intelligence#Dataviz#Santé

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