Skip to content

tdamsma/CoronaWatchNL

 
 

Repository files navigation

corona_artwork.jpg

Dataset: COVID-19 case counts in The Netherlands

CoronaWatchNL collects COVID-19 disease count cases in The Netherlands. Numbers are collected from the RIVM (National Institute for Public Health and the Environment) website on a daily basis. This project standardizes, and publishes data and makes it Findable, Accessible, Interoperable, and Reusable (FAIR). We aim to collect a complete time series and prepare a dataset for reproducible analysis and academic use.

Dutch:

CoronalWatchNL verzamelt ziektecijfers over COVID-19 in Nederland. Dagelijks worden de cijfers verzameld van de website van het RIVM. Dit project standaardiseert en publiceert de gegevens en maakt ze vindbaar, toegankelijk, interoperabel en herbruikbaar (FAIR). We streven ernaar om een dataset beschikbaar te stellen voor reproduceerbare analyses en wetenschappelijk gebruik.

Datasets

The datasets available on CoronaWatchNL are updated on a daily base. Availability depends on the publication by RIVM. The datasets are organized into four main categories:

For (visual) applications based on these datasets, have a look at the applications folder.

Geographical datasets

These datasets describe the new and cumulative number of confirmed, hospitalized and deceased COVID-19 cases per day. The datasets are categorized by their geographical level (national, provincial, municipal).

The following datasets contain newly reported cases.

Dataset Source Variables
Newly reported case counts by date in NL* RIVM Date, Type (Total, hopitalized and deceased patients), (Cumulative) Count
Newly reported case counts by date in NL per province* RIVM Date, Type (Total, hopitalized and deceased patients), Province, (Cumulative) Count
Newly reported case counts by date in NL per municipality* RIVM Date, Type (Total, hopitalized and deceased patients), Municipality, (Cumulative) Count
Newly reported relative case counts by date in NL per municipality (PDF maps)** RIVM Date, Type, Number of positive COVID-19 disease cases, hospitalizations and fatalities per 100.000 people, Municipality, Province

* For more detail about the specific structure of the geographical datasets, have a look at the data-geocodebook.
** This dataset is extracted from the maps in the PDF's. The values are relative counts per 100.000 residents in the municipality.

The following datasets contain the actual case counts on the given date.

Dataset Source Variables
Case counts by date in NL RIVM Date, Type (Total, hopitalized and deceased patients), (Cumulative) Count

Visualizations geographical data

To get a better picture of the content of the geographical datasets, have a look at the following visuals. These visuals show the development of the COVID-19 disease outbreak on a national level.

plots/map_province.png

Descriptive datasets

The datasets in this section contains variables like age and sex.

Dataset Source Variables
Case counts in NL per age RIVM Date, Age group, Type, Number of positive COVID-19 disease cases in NL
Case counts in NL per gender RIVM Date, Gender group, Type, Number of positive COVID-19 disease cases in NL

Visualizations descriptive data

The graphs displayed below visualize the impact of age and sex on the development of the COVID-19 disease outbreak.

Intensive care datasets

The IC datasets describe the new and cumulative number of hospitalized COVID-19 cases per day. The datasets are categorized by their source.

Dataset Source Variables
COVID-19 intensive care patient counts in NL Stichting NICE Date, New intake of positive IC patients, Total of positive patients currently in IC, Total of positive patients ever in IC, Total of ICUs with currently at least one positive patient, Total of fatal IC cases, Total of survived IC cases
COVID-19 intensive care patient counts in NL LCPS Date, Total of positive Dutch patients currently in IC
COVID-19 intensive care patient counts with country of hospitalisation LCPS Date, Country of Hospitalization, Total of positive Dutch patients currently in IC

Visualizations intensive care

The first two graphs show the number of newly (Nieuw), currently (Huidig), cumulative (Cumulatief), deceased (Overleden), and survived (Overleefd) hospitalized COVID-19 cases per day, as declared by NICE. The number of currently hospitalized patients per day as reported by LCPS can be seen in the third graph.

Note: LCPS also includes Dutch COVID-19 cases hospitalized in Germany. NICE only reports Dutch COVID-19 cases hospitalized in the Netherlands.

Miscellaneous datasets

This dataset shows the total number of tested people and the corresponding number of positively tested COVID-19 cases per day.

Dataset Source Variables
COVID-19 tests in NL by date (NEW) RIVM Publication Date, Date, Included labs, Type (Total and positive tests), Number of tests
RIVM press releases RIVM Date and Time, Content of press release

Visualizations miscellaneous data

These graphs display the number of (positively) tested people per day.

Inactive/deprecated datasets

Deprecated (pending)

The following datasets are awaiting deprecation. They are replaced by new datasets.

Dataset URL Source Variables Alternative
COVID-19 disease case counts in NL RIVM Date, Number of positive COVID-19 disease cases in NL rivm_NL_covid19_national.csv COVID-19 case counts in NL
COVID-19 fatalities in NL RIVM Date, Number of COVID-19 fatalities in NL rivm_NL_covid19_national.csv COVID-19 case counts in NL
COVID-19 hospitalizations in NL RIVM Date, Number of COVID-19 hospitalized patients in NL rivm_NL_covid19_national.csv COVID-19 case counts in NL

Inactive

The following datasets are no longer appended with new data (because RIVM is no longer providing the data).

Dataset URL Source Variables Expire date
COVID-19 disease case counts in NL* [long format] [wide format] RIVM Date, Number of positive COVID-19 disease cases in NL, Municipality of residence, Municipality code (2019), Province 2020-03-30

* Nowadays, the data is published again. Please use dataset data-geo#municipal.

Raw data

CoronaWatchNL collects copies of the raw data such that data collection is verifiable. Copies of the collected data can be found in the folder raw_data/. The data isn't standardised.

Data collection sources

The following sources are used for data collection.

Source Institute Collected variables
https://www.rivm.nl/nieuws/actuele-informatie-over-coronavirus RIVM Positively tested patients, Fatalities (total), Hospitalized (total)
https://www.rivm.nl/coronavirus-kaart-van-nederland-per-gemeente RIVM Positive tests per municipality
https://www.rivm.nl/nieuws/actuele-informatie-over-coronavirus/data RIVM Epidemiological reports
https://www.stichting-nice.nl/ Stichting NICE Postively tested patients admitted to IC, Number of ICUs with positively tested patient(s), Number of fatal IC cases, Number of survived IC cases

Remarks

Since 3 March 2020, RIVM reports the number of diagnoses with the coronavirus and their municipality of residence on a daily base. The data contains the total number of positively tested patients. It is not a dataset with the current number of sick people in the Netherlands. The RIVM does not currently provide data on people who have been cured.

License and academic use

The graphs and data are licensed CC0. The original data is copyright RIVM.

For academic use, use presistent data from DOI. This is a persistent copy of the data. Version number refer to the date. Please cite:

De Bruin, J. (2020). Number of diagnoses with coronavirus disease (COVID-19) in The Netherlands (Version v2020.3.15) [Data set]. Zenodo. http://doi.org/10.5281/zenodo.3711575

Image from iXimus via Pixabay

CoronaWatchNL

CoronaWatchNL is collective of researchers and volunteers in The Netherlands. We aim to make the reported number on COVID-19 disease in The Netherlands FAIR. The project is initiated and maintained by Utrecht University Research Data Management Support and receives support from Utrecht University Applied Data Science.

Help on this project is appreciated. We are looking for new datasets, data updates, graphs and maps. Please report issues in the Issue Tracker. Want to contribute? Please check out the help wanted tag in the Issue Tracker. Do you wish to share an application based on these datasets? Have a look at the applications folder.

For more descriptive charts, forecasts and maps displaying the (development of) COVID-19 cases in the Netherlands, have a look at the parallel repository CoronaWatchNL Contrib.

Please send an email to jonathandebruinos@gmail.com and/or r.voorvaart@uu.nl

About

RIVM reported numbers on the Coronavirus outbreak in The Netherlands

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Jupyter Notebook 78.4%
  • HTML 16.2%
  • Python 3.9%
  • R 1.5%