ccodwg / CovidTimelineCanada

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

Add historical NS hospital and ICU data from weekly dashboard data #54

Closed jeanpaulrsoucy closed 1 year ago

jeanpaulrsoucy commented 2 years ago

Weekly NS data (from the dashboard) has hospitalization and ICU data. Should go back and add this retroactively to the report data, if possible.

jeanpaulrsoucy commented 2 years ago

Added historical hospital and ICU data using the 5d37261a-fcb0-46aa-ab53-9f86dccb2902 dashboard dataset using datasets dated between 2022-04-14 to 2022-05-26 (today). With the exception of today's data, the "date" of the hosp/ICU data was assumed to be two days prior to the date of the dataset (whereas the case data is from three days prior to the date of the dataset).

Hospitalization and ICU data from prior to 2022-04-14 is available in the 5d37261a-fcb0-46aa-ab53-9f86dccb2902 dataset, but the date structure of the weekly reports was different (additionally, some dates prior to this already have hospitalization data, but none have ICU data).

jeanpaulrsoucy commented 2 years ago

Note that today's hospitalization data update broke the date trend. Instead of being current date - 2, it was current date - 1 (in this case, June 15, 2022).

jeanpaulrsoucy commented 1 year ago

Note: The daily news release dataset has hospitalization numbers (7b7be246-cd65-4f35-b354-faa705cacecc). The current datasets for hospitalization and ICU numbers goes from 2021-01-19 to 2022-01-18, ending on 58 and 15. However, the daily news release for that date has 73 and 15, respectively. This suggests that the ICU time series should be added to the hospitalization time series to maintain the standard definition (non-ICU + ICU). Can verify with a few more spot comparisons with the daily news releases. Update: The correct column to grab was tot_hos rather than cur_hos (tot_hos is equivalent to cur_hos + cur_hosicu).

The rest of the values can be extracted from later daily news releases.