johanley/covid-19-canada

COVID-19 stats reported by Canadian governments. Supporting screenshots. CSV, JSON. Three months of data, from 2020-03-31 to 2020-06-30 inclusive.

covid-19-canada's Issues

Errors from github when viewing stored images

Example

500: Internal Server Error
https://raw.githubusercontent.com/johanley/covid-19-canada/master/data/screenshots/2020-03-31_22h00mADT/ab.png

It seemed fine yesterday.

Hospitalized: add this new data-stream to the github-pages section

Suppress the link if there's no supporting screenshot.

Most data has a supporting screenshot, but there are exceptions.
If the screenshot doesn't support the data, then no link to the screenshot should be generated.

The following should not have a link to a screenshot.

Tests-performed :

• NB from 2020-03-31 to 2020-04-16 (inclusive). This exception occurred because of my error in collecting the data.

Hospitalizations (all date ranges are inclusive; all of these occurred because I started collecting this statistic late, about mid-April):

• ON 2020-03-31 to 2020-04-01
• QC 2020-03-31 to 2020-04-06
• NB 2020-03-31 to 2020-04-05
• NS 2020-03-31 to 2020-04-06
• NL 2020-03-31 to 2020-04-03

Markdown only: bar charts render poorly when screen-width is small.

In markdown world, the bar charts are truncated/maxed out when the screen-width is small.

(This issue applies only to the simplistic charts implemented in markdown; it doesn't apply to the better charts implemented with plotly.js)

This is a result of the implementation in github's markdown. That tool has no fine control over the CSS, as far as I can see. I have no means of changing the style of the table.

Mitigate: hold the device in landscape mode.

Create a starting version of the database schema.

Maria DB, CREATE TABLE statements.

Markdown: daily-change bar charts render erroneously if the change is negative.

Current hospitalizations has been added.
This stat is not cumulative, so it can decrease over time.

The daily-change renders poorly when the value is negative: it's rendered the same as if it was positive.

Simpler: change the color for negative values.

Harder: change the zero-point of the graph.

CA time series - daily change - reporting artifacts

Daily-change time series for CA on the home page is very spiky. This is very likely an artifact of the timing of reporting. ON and QC are two large jurisdictions. If the timing of reporting is not uniform, then this is exactly the kind of wild variation in the daily values for CA you would expect.

These large swings are reporting-artifacts. They should be removed because they are pretty meaningless, and downright misleading.

Instead, for the daily changes for CA, show a running average value. This will give a much more realistic picture of what's really going on.