Skip to content

Latest commit

 

History

History
 
 

data-misc

Codebook data-misc - CoronaWatchNL

Data update

All datasets are updated on a daily base. Availability depends on the publication by RIVM.

Data format

Test

Directory: data-misc/data-test
Daily file format: RIVM_NL_test_yyyy-mm-dd.csv
Latest file format: RIVM_NL_test_latest.csv
Deprecated file(s): RIVM_NL_test_depr_2020-04-20.csv

Column name Translation Description Format Example
Jaar Year Year of notification YYYY (ISO 8601) 2020
Week Week number* Week of notification numeric 11
BeginDatum Start date Beginning of the week (Monday) of notification YYYY-MM-DD (ISO 8601) 2020-03-09
EindDatum End date End of the week (Sunday) of notification YYYY-MM-DD (ISO 8601) 2020-03-15
AantalLaboratoria Number of laboratories Number of Dutch laboratories that have performed diagnostics for SARS-CoV-2 in said week character 30
Type Type Type of test measurement (i.e., Totaal, Positief) character Totaal
Aantal Count Number of people tested for COVID-19 (Totaal), and number of positively tested people for COVID-19 (Positief**) per week*** numeric (integer) 17080

* Before the 21st of April, RIVM reports did not use weeks but seperate dates to report test counts. This format can be found in the RIVM_NL_test_depr_2020-04-20.csv dataset. Note that, due to this change in format, this specific file could not be updated after the 20th of April.
** The number of people positively tested on COVID-19 differs from the number of patients reported by the GGDs, as some people might have been tested more than once.
*** The data is updated every day, except for weekends and holidays.

Reproduction

Directory: data-misc/data-reproduction
Complete file format: RIVM_NL_reproduction_index.csv

Column name Translation Description Format Example
Datum Date* Date of calculated reproduction index YYYY-MM-DD (ISO 8601) 2020-04-11
Type Type Type of reproduction measure (i.e., Reproductie index, Minimum, Maximum) character Reproductie index
Waarde Value** The (minimum and maximum) reproduction index (Reproductie index) per day, indicating how quickly the virus is spreading numeric 0.69

* As the reproduction index is calculated in retrospect, the date shown here lies further in the past than the date of notification.
** The reproduction index is an estimate made by RIVM based on various data sources. The exact number is unknown. The reproduction index is an average for the entire Netherlands.

Contagious

Directory: data-misc/data-contagious
Complete file format: RIVM_NL_contagious_estimate.csv
Latest file format: RIVM_NL_contagious_estimate_latest.csv

Column name Translation Description Format Example
Datum Date Date of calculated contagious count YYYY-MM-DD (ISO 8601) 2020-05-29
Type Type Type of measure (i.e., Geschat aantal besmettelijke mensen, Minimum aantal besmettelijke mensen, Maximum aantal besmettelijke mensen) character Geschat aantal besmettelijke mensen
Waarde Value* The (minimum and maximum) estimate of contagious people per 100.000 inhabitants (Geschat aantal besmettelijke mensen) numeric 9.9

* This calculated value estimates how many people infected with COVID-19 per 100.000 inhabitants are contagious for others. This value is calculated by RIVM.

Nursery

Directory: data-misc/data-nursery
Complete file format: RIVM_NL_nursery_counts.csv

Column name Translation Description Format Example
Datum Date Date of notification YYYY-MM-DD (ISO 8601) 2020-04-11
Type Type Type of measurment: Positief geteste bewoners (Positively tested residents), Overleden besmette bewoners (Deceased residents) character Positief geteste bewoners
Aantal Count Number of newly reported (deceased) COVID-19 cases of nursery home residents on the date of notification in the last 24 hours numeric (integer) 160
AantalCumulatief Total count Number of (deceased) COVID-19 cases of nursery home residents on the date of notification since the start of the outbreak numeric (integer) 4017

Underlying

For deceased COVID-19 cases younger than 70, RIVM reported whether or not they suffered from underlying conditions and/or were pregnant. The number of deceased patients with and without underlying disorders and/or pregnancy are listed in data-underlying_statistics. The number of detected underlying conditions and/or pregnancies can be found in data-underlying_conditions.

Underlying statistics

Directory: data-misc/data-underlying/data-underlying_statistics
Daily file format: RIVM_NL_deceased_under70_statistics_yyyy-mm-dd.csv
Latest file format: RIVM_NL_deceased_under70_statistics_latest.csv
Complete file format: RIVM_NL_deceased_under70_statistics.csv

Column name Translation Description Format Example
Datum Date Date of notification YYYY-MM-DD (ISO 8601) 2020-04-11
Type Type Type of test measurement (i.e., Totaal gemeld, Onderliggende aandoeningen en/of zwangerschap, Geen onderliggende aandoening, Niet vermeld) character Onderliggende aandoening en/of zwangerschap
AantalCumulatief Cumulative count The cumulative number of deceased COVID-19 cases younger than 70 (Totaal gemeld) with (Onderliggende aandoening en/of zwangerschap) or without (Geen onderliggende aandoening) an underlying condition and/or pregnancy, and the cumulative count of cases where it was unknown whether they had an underlying condition and/or were pregnant (Niet vermeld) 218

Underlying conditions

Directory: data-misc/data-underlying/data-underlying_conditions
Daily file format: RIVM_NL_deceased_under70_conditions_yyyy-mm-dd.csv
Latest file format: RIVM_NL_deceased_under70_conditions_latest.csv
Complete file format: RIVM_NL_deceased_under70_conditions.csv

Column name Translation Description Format Example
Datum Date Date of notification YYYY-MM-DD (ISO 8601) 2020-04-11
Type Type Type of test measurement (i.e., Zwangerschap, Cardio-vasculaire aandoeningen en hypertensie, Diabetes, Leveraandoening, Chronische neurologische of neuromusculaire aandoeningen, Immuundeficientie, Nieraandoening, Chronische longaandoeningen, Maligniteit, Overig) character Nieraandoening
AantalCumulatief* Cumulative count The cumulative number of deceased COVID-19 cases younger than 70 that suffered from cardio vascular conditions and hypertension (Cardio-vasculaire aandoeningen en hypertensie), Diabetes, Liver condition (Leveraandoening), Chronic neurological or neuromuscular conditions (Chronische neurologische of neuromusculaire aandoeningen), Immunodeficiency (Immuundeficientie), Kidney conditions (Nieraandoening), Chronic lung conditions (Chronische longaandoeningen), Malignancy (Magligniteit), or other conditions (Overig), or that were pregnant (Zwangerschap) 12

* Note that one patient can have multiple conditions. Therefore, the sum of the cumulatives per condition is higher than the cumulative number of deceased patients with a known underlying condition and/or pregnancy as mentioned in data-underlying_statistics.

Measures

Directory: data-misc/data-measures
Daily file format: NLD_measures.csv
Latest file format: NLD_measures_latest.csv

Column name Description Format Example
measureID Measure ID numeric 1
measureDescription Description of the enforced measure character Schools/Univ. closure
lastMeasureUpdate Date on which the measure was last updated YYYY-MM-DD (ISO 8601) 2020-03-23
area The area in which the measure is/was enforced character National
status Restriction status of the enforced measure (i.e., 'events' can be: Closed, Partially closed, Partially banned, Banned, or Partially cancelled) character Closed
restrictiveMeasures Adherence level of the measure (i.e., measure can be: Recommended or Mandatory) numeric (integer) Mandatory
startDate Date on which the measure was first enforced YYYY-MM-DD (ISO 8601) 2020-03-16
endDate Date on which the measure was no longer enforced YYYY-MM-DD (ISO 8601) 2020-04-06
notes Notes about the measure character string Child care facilities open only for childrens of parents working in crucial departments (doctors, police etc...). Restriction valid until April 6th