Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SK case data should be updated with "previous week data" in weekly report #64

Closed
jeanpaulrsoucy opened this issue Jun 23, 2022 · 4 comments
Labels
data New data sources or updates to existing data sources. enhancement New feature or request P3 - Long-term Very low priority updates and/or long-term considerations

Comments

@jeanpaulrsoucy
Copy link
Member

The SK weekly case report contains a column with the current week's case counts as well as the previous week's case counts.

Screenshot 2022-06-23 at 15-59-17 Integrated Epi Sit Report June 12-18 pdf

Often, data reported for the previous week is slightly different from the data reported reported for the same period in the previous week's report. For example, today's report gives 392 cases for last week, whereas last week 394 cases were reported. These are clearly the result of minor cleanup/fixes to the underlying data.

Since both the current and previous week's columns are transcribed in covid19_reports, we should take advantage of these more accurate retrospective data. This would require a more complex process for SK cases in Covid19CanadaETL.

@jeanpaulrsoucy jeanpaulrsoucy added enhancement New feature or request data New data sources or updates to existing data sources. labels Jun 23, 2022
@jeanpaulrsoucy
Copy link
Member Author

Note that the first monthly report may have some "previous 7 days" data for the final weekly report.

@jeanpaulrsoucy
Copy link
Member Author

I've added all of the historical hospitalization data from the reports, but the historical case data still haven't been added.

@jeanpaulrsoucy jeanpaulrsoucy added the P3 - Long-term Very low priority updates and/or long-term considerations label Dec 9, 2022
@jeanpaulrsoucy
Copy link
Member Author

The historical hospitalization data don't seem to be strictly necessary, since they only seem to disagree with the previously reported values in two cases:

The first week (disagreeing with the time series value for 2022-02-02 of 372):

image

I will prioritize the daily time series value here, so no change.

And report from 2022-03-17:

image

This contradicts the previous week's 339. However, this is clearly a typo: the "difference from last week: -40" supports the original value.

The ICU data have no contradictions, not even to the time series value in the first week.

jeanpaulrsoucy added a commit to ccodwg/Covid19CanadaETL that referenced this issue Sep 23, 2023
- Update hospitalization/ICU data (ccodwg/CovidTimelineCanada#82)
- Remove covid19tracker.ca hosp/ICU data for NU, NT, YT (unreliable)
- Remove covid19tracker.ca hosp/ICU data for SK (captured in weekly report data)
- Update SK hosp/ICU data to use weekly report data (ccodwg/CovidTimelineCanada#64)
- Update YT with hosp admission time series (ccodwg/CovidTimelineCanada#111)
jeanpaulrsoucy added a commit that referenced this issue Sep 23, 2023
- Update hospitalization/ICU data (#82)
- Remove covid19tracker.ca hosp/ICU data for NU, NT, YT (unreliable)
- Remove covid19tracker.ca hosp/ICU data for SK (captured in weekly report data)
- Update SK hosp/ICU data to use weekly report data (#64)
- Update YT with hosp admission time series (#111)
@jeanpaulrsoucy
Copy link
Member Author

Should probably repeat this for the new admissions stat.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
data New data sources or updates to existing data sources. enhancement New feature or request P3 - Long-term Very low priority updates and/or long-term considerations
Projects
None yet
Development

No branches or pull requests

1 participant