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.

Sign up for GitHub

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

Jump to bottom

Publish case numbers for Wales by Local Authority or Health Board? #33

Open
tomwhite opened this issue Apr 9, 2020 · 4 comments
Open

Publish case numbers for Wales by Local Authority or Health Board? #33

tomwhite opened this issue Apr 9, 2020 · 4 comments

Comments

@tomwhite
Copy link
Owner

tomwhite commented Apr 9, 2020

The new PHW dashboard at https://public.tableau.com/profile/public.health.wales.health.protection#!/vizhome/RapidCOVID-19virology-Public/Headlinesummary breaks down case numbers by local authority again.

To summarize:

  • Before 21 March, cases numbers were by LA.
  • From 21 March to 5 April, case numbers were by HB.
  • From 6 April, case numbers were by LA.

Unfortunately we don't have LA case numbers for the period 21 March to 5 April (unless someone knows a source).

I'm thinking of publishing LA case numbers again. Consumers of the data can then either

  • Aggregate at the HB level to show numbers for the whole time period with no gaps.
  • Use the finer-grained LA number, but with a two week gap (from 21 March to 5 April). Depending on the application this may be OK - e.g. show gaps in the visualization.

Thoughts?
@tomwhite tomwhite mentioned this issue Apr 9, 2020
Closed
Copy link

Apr 9, 2020 •
edited
Loading

If you include the LA level again I can make use of it. Thanks Tom. I'm using https://github.com/tomwhite/covid-19-uk-data/blob/master/data/covid-19-cases-uk.csv Is it possible to also have a trimmed down version of that file without the country name and area name columns to help keep file size down?

@robchallen
Copy link

I aggregate downstream for the cases before 21 March anyway, so doesn't really matter.
The smaller areas don't have enough numbers to be useful anyway.

@tomwhite
Copy link
Owner Author

tomwhite commented May 1, 2020

I still need to sync Wales revised case numbers for Wales from the historical spreadsheet. When I do that I will likely switch to making the whole timeseries use one or the other area type.

(BTW @robchallen I recognised your name and realized we were at college together. Hope you are well.)

@robchallen
Copy link

How funny! I hadn't made the connection. Good to hear from you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@tomwhite @robchallen