ccodwg / CovidTimelineCanada

A definitive dataset for COVID-19 in Canada
https://opencovid.ca/
Other
26 stars 8 forks source link

Truncate PHAC testing time series #57

Closed jeanpaulrsoucy closed 2 years ago

jeanpaulrsoucy commented 2 years ago

Similar to the case/death time series (#52), the PHAC testing time series should be truncated to the most recent update date. Since we cannot rely on the update column for this, there are two possible solutions:

  1. The daily epidemiology update contains a note like this that could be extracted for an "as of" date:

We update these sections Monday to Friday at 9:00 AM EST: Key updates, Current situation and National overview. Laboratory data represents specimens received by labs up to May 28, 2022 to allow time to process results.

  1. However, realistically, some places update less frequently (e.g., Alberta updates once per week and will use that same value for 7 days). Thus, a better solution would be to simply truncate each province's testing time series to the most recent date with the maximum value of the series.