COVID-19 National SARS-CoV-2 waste water surveillance National daily figures
Description
This stock contains, per day, the national average number of SARS-CoV-2 virus particles per 100.000 inhabitants, as calculated from measurements of the number of virus particles per sewage treatment plant (RWZI).
The file is structured as follows:
For each date since 2020-09-07, the average national number of virus particles per 100.000 inhabitants has been calculated. This number is a weighted average of all RWZIs of which recent measurements are available.
For each date, the most recent measurement of all RWZIs shall be weighted by the number of inhabitants using the RWZI concerned, provided that the most recent measurement is not older than eight days.
These values are reputed over all RWZIs, and divided by the number of observed inhabitants (i.e., the number of inhabitants connected to the RWZIs that have a measurement less than eight days old). This results in a weighted average expressed per inhabitant. Multiplying by 100.000 gives the average number of virus particles, per date, per 100.000 inhabitant equivalents.
If none of the WWTPs are available that are more recent than 8 days, the record is “NA”.
The file contains all days from 2020-09-07 to the most recent date for which a value can be calculated.
The information on populations per RWZI can be found in a turnover table provided by the Central Bureau of Statistics (CBS).
The 2020-2021 version:
https://www.cbs.nl/nl-nl/maatwerk/2021/06/inwoners-per-rioolwaterzuiveringsinstallatie-1-1-2021
The 2022 version:
https://www.cbs.nl/nl-nl/maatwerk/2022/42/inwoners-per-rioolwaterzuiveringsinstallatie-1-1-2022
All measurements of individual RWZIs on which the national figure is based can be found in the open data set at RWZI record level (https://data.rivm.nl/meta/srv/dut/catalog.search#/metadata/a2960b68-9d3f-4dc3-9485-600570cd52b9).
Description of variables
Version: Version number of the dataset. If the content of the dataset is structurally changed (i.e. not the daily update or a correction at record level), the version number will be changed (+ 1) and also the corresponding metadata in RIVMdata (data.rivm.nl).
Date_of_report: Date on which the file was created (format: YYYY-mm-dd).
Date_measurement: Date to which the calculation of the average number of virus particles per 100.000 inhabitants (format: YYYY-mm-dd).
RNA_flow_per_100000: The calculated number of SARS-CoV-2 RNA particles measured in sewage water, based on a weighted average of the measurements in WWTPs, per 100.000 inhabitants.
Because not all measurements are available at the same time, the most recently reported values are subject to change. This may result in differences in the date of publication of the data. It is also possible that earlier dates are corrected as a result of new laboratory results or corrections in source stocks of the Water Boards. This file is always based on the most up-to-date data.
Resources
| Name |
Format |
Description |
Link |
|
0 |
|
https://data.rivm.nl/data/covid-19/COVID-19_rioolwaterdata_landelijk.csv |
Tags
- sewage
- coronavirus
- sars-cov-2
- rioolwater
- infectieziekten
- gezondheid
- covid-19
- afvalwater
- riool