Goals of the reports Coronavirus in the world and Coronavirus in Spain
The reports I saw before doing those reports with Jupyter where static, long and cumbersome. The goals of those reports are:
- To make interactive reports with controls.
- To get the report always actualised.
- To be able to send it with a link.
Coronavirus in the world
This report uses three datasets that are online:
- The main dataset retrieves data in format json with number of cases and deaths by country and date. It is external and gets actualised many times during the day.
- There is dataset created by me to provide population to the countries that missed it.
- There is dataset created by me to shorten the name of some countries.
First it retrieves a table and a plot. It uses summarized dataset by country where are added the measures/population with a scale of 100.000. Those are the parameters:
- Metric to be ordered by (string) : It orders by the metric chosen.
- Min pop/country (int) : It filters by the countries with a minimum population
- Top n rows (int) : It filters by the number of top countries
Afterwards it retrieves a plot. It uses a dataset with a granularity of country and date. From the beginning it is filtered by the countries selected in the first dataset. Those are the parameters:
- Metric (string) : Metric to get analyzed.
- From Date (date) : From the date it will be showed the data. By dafault is minimum date when data is above 0 in any country for the selected metric
- To Date (date) : To the date it will be showed the data. By dafault is maximum date when data is above 0 in any country for the selected metric
- Plot Kind (string) : Plot kind applied to plot.
- Countries (string) : Countries to be analyzed. It is restricted to the countries selected in the previous table and plot.
Sum means the sum in all the days.
Last means the data of the last day.
The countries selected in this dataset will be also pre-filtered in the next graphic.
The report can be seen in Binder.
Coronavirus in Spain
This report returns the evolution in Spain of the measures
- cases
- recovered
- hospitalized
- icu
- deaths
- active
- new_cases/active
related to coronavirus. Each measure represent the number of individuals in each situation per 100000 people.
Granularity is day and data is also shown by CA (different autonomous communities of Spain).
Each measure is ordered in a descending order
- to compare in the graphics autonomous comunities with similar values of measures
- and to identify easily which autonomous comunities have higher or lower measure values
The autonomies in the autonomic graphic are showed by descending order in the measure.
The report can be seen in Binder.