J535D165/CoronaWatchNL

Amsterdam and Eindhoven always have the same number of infected

wouterbeek opened this issue · 2 comments

In https://raw.githubusercontent.com/J535D165/CoronaWatchNL/master/data/rivm_NL_covid19_municipality_range.csv the number of infections for Amsterdam and Eindhoven is always the same. Even though these numbers are reported in ranges, this still seems a bit suspicious.

These are the rows for the last couple of days, the values in the last two columns are always the same:

Datum,Gemeentenaam,Gemeentecode,Provincienaam,Type,Aantal_min,Aantal_max
2020-04-07,Amsterdam,363,Noord-Holland,Totaal,70.0,115.0
2020-04-07,Eindhoven,772,Noord-Brabant,Totaal,70.0,115.0
2020-04-08,Eindhoven,772,Noord-Brabant,Totaal,70.0,115.0
2020-04-09,Amsterdam,363,Noord-Holland,Totaal,70.0,115.0
2020-04-09,Eindhoven,772,Noord-Brabant,Totaal,70.0,115.0
2020-04-10,Amsterdam,363,Noord-Holland,Totaal,115.0,185.0
2020-04-10,Eindhoven,772,Noord-Brabant,Totaal,115.0,185.0
2020-04-11,Amsterdam,363,Noord-Holland,Totaal,115.0,185.0
2020-04-11,Eindhoven,772,Noord-Brabant,Totaal,115.0,185.0
2020-04-12,Amsterdam,363,Noord-Holland,Totaal,115.0,185.0
2020-04-12,Eindhoven,772,Noord-Brabant,Totaal,115.0,185.0
2020-04-13,Amsterdam,363,Noord-Holland,Totaal,90.0,160.0
2020-04-13,Eindhoven,772,Noord-Brabant,Totaal,90.0,160.0
2020-04-14,Amsterdam,363,Noord-Holland,Totaal,90.0,160.0
2020-04-14,Eindhoven,772,Noord-Brabant,Totaal,90.0,160.0
2020-04-15,Amsterdam,363,Noord-Holland,Totaal,90.0,160.0
2020-04-15,Eindhoven,772,Noord-Brabant,Totaal,90.0,160.0

Hmmm. I will have a look at the PDF files. Did you have a look at the PDFs files? Any findings?

RVoor commented

We had a look at the RIVM reports of that specific period (2020/04/07 - 2020/04/15), and (luckily) the similar ranges do check out. Even though Eindhoven and Amsterdam have varying absolute numbers (https://github.com/J535D165/CoronaWatchNL/blob/master/data/rivm_NL_covid19_total_municipality.csv), they have similar relative numbers (incidents per 100.000 inhabitants) and, thus, similar ranges. For a nice overview I would recommend having a look at this super inclusive dashboard: https://corona-map-nl.web.app/