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

tomwhite commented 4 years ago

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?

slowe commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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

tomwhite / covid-19-uk-data

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