Closed jeanpaulrsoucy closed 11 months ago
Step 1 for mitigation could be to freeze the QC data in place, only reporting up to the previous week of data for now (while allowing all other provinces to update as normal).
Note that this also causes problems with the Canada-level data since it now excludes Quebec. The vaccine administration dataset from PHAC has updates to the number of total doses administered by Quebec but not the individual doses (in fact, the total vaccine dose numbers have been uncoupled from the individual dose numbers for some time, perhaps representing 5th doses?).
Could look into this dataset from Quebec for replacing vaccination data: https://www.donneesquebec.ca/recherche/dataset/covid-19-portrait-quotidien-de-la-vaccination
Would have to check which regions to exclude (e.g., Hors Québec, as in cases).
In the dataset above, we have three columns:
RSS99_DOSES_Total_cumu
: Total administered in QuebecRSSHQ_DOSES_Total_cumu
: Total administered outside of QuebecRSSAL_DOSES_Total_cumu
: Total administered inside and outside out QuebecIt might make sense to include doses administered outside of Quebec (especially since we are using province-level data), whereas it may make less sense to do it for cases (these are presently excluded).
We have reports that QC vaccine data (from frozen PHAC dataset) is broken again, will have to check out.
QC vaccine administration dataset for 2023-09-10: 23128180 (RSS99_DOSES_Total_cumu
), 23513045 (RSSAL_DOSES_Total_cumu
)
New PHAC vaccine administration dataset for 2023-09-10: 23127054
Should use RSS99
to be consistent.
As of the most recent vaccination coverage data update, QC is no longer providing data compatible with the other provinces. Some explanations are given on the notes page.
I will have to look into alternative data from QC and if it can be made compatible with the federal government data.