For English, see below This file contains, in addition to a column with the version number and a column with the date of creation of the file, the following characteristics per sampled sewage treatment plant (WWTP) in the Netherlands: Date of sample, WWTP code, WWTP name, Virus load per 100,000 inhabitants The file is structured as follows: For each treatment plant, a sample is taken from the sewage water for 24 hours. These samples are analyzed by RIVM researchers for the number of virus particles present. A record contains the average number of virus particles in the sewage water for each waste/sewage treatment plant (WWTP) sampled, corrected for the daily amount of sewage water (flow rate) and shown per 100,000 inhabitants. The file is refreshed from Monday to Friday (before 2:00 PM). The information on population numbers per WWTP can be found in a turnover table, which is supplied by Statistics Netherlands (CBS). (The version for 2021:) (https://www.cbs.nl/nl-nl/maatwerk/2021/06/inwoners-per-sewage treatment plant-1-1-2021) (The version for 2022:) (https: //www.cbs.nl/nl-nl/maatwerk/2022/42/inwoners-per-sewage treatment plant-1-1-2022) As of March 4, 2021, a number of changes have been implemented for the WWTPs below. - As of October 8, 2020, WWTP Aalst has been closed. The associated catchment area has been added to that of WWTP Zaltbommel. The values for the RNA_flow_per_100000 for Zaltbommel have been changed in the database from March 4, 2021 with retroactive effect to the aforementioned date of suspension. For the values reported before the closure date, the individual population numbers for WWTP Aalst and WWTP Zaltbommel that applied before the closure of WWTP Aalst were used. - As of December 9, 2020, WWTP Lienden has been closed. The associated catchment area has been added to that of WWTP Tiel. The values for RNA_flow_per_100000 for WWTP Tiel have been changed in the database from March 4, 2021 with retroactive effect to the above-mentioned lifting date. For the values reported before the closure date, the individual population numbers for WWTP Lienden and WWTP Tiel that applied before the closure of WWTP Lienden were used. Changes from 1 January 2021 have been incorporated in the CBS turnover table. From September 30, 2021, changes in the CBS turnover table will be processed as soon as they become known. As of September 30, the column RNA_per_ml has been removed from the open data file. Values reported in this column have been converted to RNA_flow_per_100000 and reported in that column where possible. In addition, all values for 2021 and 2020 were retroactively recalculated on September 30, 2021 with the population numbers in the CBS table published on September 30, 2021. All values for 2022 have been retroactively recalculated on December 30, 2022 using the CBS table published on October 19, 2022. Description of the variables: Version: Version number of the dataset. When the content of the dataset is structurally changed (so 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 on which the file was created. (format: yyyy-mm-dd) Date_measurement: Date on which the sampling of the 24-hour influent (raw waste/sewage) sample started (format: yyyy-mm-dd). WWTP_WWTP_code: Code of sewage treatment plant (WWTP) or waste water treatment plant (WWTP). WWTP_WWZI_name: Name of sewage treatment plant (WWTP) or waste water treatment plant (WWTP). RNA_flow_per_100000: The average concentration of SARS-CoV-2 RNA, converted to daily amount of sewage (flow rate) and displayed per 100,000 inhabitants. -------------------------------------------------- --------------------------------------------- Covid-19 National SARS-CoV-2 sewage surveillance This file contains, in addition to a column with the version number and a column with the date of creation of the file, the following characteristics per sampled sewage treatment plant (STP) in the Netherlands: Sample date, STP code, STP name, Virus load per 100,000 inhabitants The file is structured as follows: A sample of the sewage water is taken for 24 hours per treatment plant. These samples are analyzed by RIVM researchers for the number of virus particles present. A record contains the average number of virus particles in the sewage water for each waste/sewage treatment plant (STP) sampled, corrected for the daily amount of sewage water (flow rate) and shown per 100,000 inhabitants. The file is refreshed from Monday to Friday (before 2:00 PM). The information on population numbers per STP can be found in a conversion table, which is supplied by Statistics Netherlands (CBS). (The version for 2021:) (https://www.cbs.nl/nl-nl/maatwerk/2021/06/inwoners-per-rioolwaterzuiveringsinstallatie-1-1-2021) (The version for 2022:) (https://www.cbs.nl/nl-nl/maatwerk/2022/42/inwoners-per-rioolwaterzuiveringsinstallatie-1-1-2022) As of March 4, 2021, a number of changes have been implemented for the STPs below. - As of October 8, 2020, STP Aalst has been closed. The associated catchment area has been added to the STP of Zaltbommel. The values for the RNA_flow_per_100000 for Zaltbommel have been changed in the database from March 4, 2021 retroactively to the aforementioned date of suspension. For the values reported before the closure date, the individual population numbers for STP Aalst and STP Zaltbommel that applied before the closure of STP Aalst were used. - As of December 9, 2020, STP Lienden has been closed. The associated catchment area has been added to the STP of Tiel. The values for RNA_flow_per_100000 for STP Tiel have been changed in the database from March 4, 2021 retroactively to the aforementioned date of suspension. For the values reported before the closure date, the individual population numbers for STP Lienden and STP Tiel that applied before the closure of STP Lienden were used. Changes from 1 January 2021 have been incorporated in the CBS conversion table. From September 30, 2021, changes in the CBS conversion table will be processed as soon as they become known. As of September 30, the column RNA_per_ml has been removed from the open data file. Values reported in this column have been converted to RNA_flow_per_100000 and reported in that column where possible. In addition, all values for 2021 and 2020 were retroactively recalculated on September 30, 2021 with the population numbers in the CBS table published on September 30, 2021. All values for 2022 have been retroactively recalculated on December 30, 2022 using the CBS table published on October 19, 2022. Description of the variables: Version: Version number of the dataset. When the content of the dataset is structurally changed (so 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 on which the file was created. (format: yyyy-mm-dd) Date_measurement: Date on which the sampling of the 24-hour influent (raw waste/sewage) sample started (format: yyyy-mm-dd). RWZI_AWZI_code: Code of sewage treatment plant (RWZI in Dutch abbreviation) or waste water treatment plant (AWZI in Dutch abbreviation). RWZI_AWZI_name: Name of sewage treatment plant (RWZI in Dutch abbreviation) or waste water treatment plant (AWZI in Dutch abbreviation). RNA_flow_per_100000: The average concentration of SARS-CoV-2 RNA, converted to daily amount of sewage (flow rate) and displayed per 100,000 inhabitants.
