Covid-19 National SARS-CoV-2 Wastewater Surveillance National Daily Figures
Description
This file 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 (WWTP).
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 WWTPs for which recent measurements are available.
For each date, the most recent measurement of all WWTPs shall be weighted according to the number of inhabitants using the WWTP concerned, provided that the most recent measurement is not older than eight days.
These values are summed across all WWTPs and divided by the number of inhabitants observed (i.e. the number of inhabitants connected to the WWTPs having a measurement less than eight days old). This results in a weighted average expressed per inhabitant. Multiplying this by 100,000 gives the average number of virus particles, per date, per 100,000 inhabitant equivalents.
If measurements more recent than 8 days are not available from any of the WWTPs, the record shall be ‘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 population numbers per WWTP can be found in a turnover table, which is provided by the Central Bureau of Statistics (CBS).
The 2020-2021 version:
https://www.cbs.nl/en-nl/maatwerk/2021/06/inhabitants-per-sewage treatment plant-1-1-2021
The 2022 version:
https://www.cbs.nl/en-nl/maatwerk/2022/42/residents-per-sewage treatment plant-1-1-2022
All measurements of individual WWTPs on which the national figure is based can be found in the open data set at WWTP 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. When 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 adjusted (+1) and also the corresponding metadata in RIVMdata (data.rivm.nl).
Date_of_report: Date the file was created (format: yyyy-mm-dd).
Date_measurement: Date covered by 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 the sewage water, based on a weighted average of the measurements at WWTPs, shown 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 per publication date of the data. It is also possible that earlier dates are corrected as a result of new laboratory results or corrections in source files of the Water Boards. This file is always based on the most up-to-date data.
Resources
| Name |
Format |
Description |
Link |
|
8 |
|
https://data.rivm.nl/data/covid-19/COVID-19_rioolwaterdata_landelijk.csv |
|
23 |
|
https://data.rivm.nl/covid-19/COVID-19_rioolwaterdata_landelijk.json |
|
8 |
|
https://data.rivm.nl/data/covid-19/COVID-19_rioolwaterdata_landelijk.csv |
|
23 |
|
https://data.rivm.nl/covid-19/COVID-19_rioolwaterdata_landelijk.json |
Tags
- sewage
- coronavirus
- sars-cov-2
- rioolwater
- infectieziekten
- gezondheid
- covid-19
- afvalwater
- riool