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

[tomwhite]

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]

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]

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]

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]

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