Daily numbers, graphs, analysis thread 14

[BigChocFrenzy]

Welcome to thread 14 of the daily updates

Resource links:

Uk dashboard deaths, cases, hospitals, tests - 4 nations, LAs, English regions
Slides & data UK govt pressers
[[https://www.gov.uk/guidance/coronavi
rus-covid-19-information-for-the-public UK stats]] list of reports added daily by PHE & DHSC
PHE Surveillance report infections & deaths released every Thursday with sep. infographic
ONS England infection surveillance report ONS UK statistics for CV related deaths, released weekly each Tuesday
Daily ECDC report UK & EEA
Worldometer UK page
Plot FT graphs compare countries deaths, cases, raw / million pop
Covidly.com world summary & graphs
Plot COVID Graphs Our World in Data additional data

We welcome factual, data driven, and civil discussions from all contributors 📈 📉 📊 👍

Luton has had 19 cases in a day recently, so it's testing strategy is working. Oadby looks as if it may have got on top of its problem. Bradford still needs to ramp up testing as it is still finding significant numbers and Oldham still has rapidly increasing numbers of cases and needs to up it's game if it wants schools reopened. coronavirus.data.gov.uk/cases?areaType=ltla&areaName=Oldham

Cases remain concentrated in a limited number of areas but that doesnt mean everyone else can relax. Coventry has gone from 7 a week to around 50. Leicester is still finding 25 cases a day.

Just discovered this really interesting webpage lginform.local.gov.uk/reports/view/lga-research/covid-19-case-tracker

I'm so delighted to find this forum - I thought I was the only one pouring over the data!

I got totally fed up with the media. I can get the national picture in the national news but I want to know the risk where I work and where I live and where my elderly mum in law lives.

So I set up a data/stats service

www.covidmessenger.com

I send a summary of whats happening in your local area straight to your inbox each morning - number of new cases, whether cases rising/falling etc.

It's free - I was going to charge people £1/month to pay for the server costs etc but the thought that someone who wanted the information but couldn't afford it felt so horribly wrong to me.

So I'm paying for it all myself and hoping to get local companies to sponsor us to keep it going.

It has been sooo much work, I'm totally shattered, but I'm really proud of it and i feel its really worthwhile.

Anyone can register for any council in England at www.covidmessenger.com

Your website looks very professional @littleowl ! How do you get it to do daily alerts when the local cases are usually attributed to the day of the test having been taken, a few days previously? (This caught me out at first when looking at cases in my local area which were always zero on the most recent day) Is there some means of downloading them by date posted? Or do you compare one day with the next?

Owl that looks fab!

Thank you! The website was a lot of work, but I am really pleased with it.

We use the 4-day lagged data by test sample date - if you monitor and analyse the daily stats, it takes about 3-4 days for the bulk of test results to be recorded and published. Which is understandable - testing takes time and so does reporting. There is always a little bit of retrospective corrections from the government - which I think is understandable given the speed with which they are required to publish these figures. But I have found 4 day lagged data gives a good representative insight into what is occurring in individual areas.

Great link @alreadytaken, seeing the small number of councils responsible for most of the cases is really useful for perspective. Also there are a lot more cases in Kent and Essex than I'd realised; because they're relatively low per 100,000 it had passed me by that their absolute numbers are not tiny like the rest of the South East (I had been vaguely wondering where the South East cases were, as I never see them).

@littleowl1 - that's a great site. You could request voluntary donations when people have been using it for a week or so, and then more likely to pay? It might be good to provide the details to newspapers as well so you can get sign-ups and funding.

Well done LittleOwl it looks great

@littleowl1 well done.

You could advertise on here for limited time free sign up

Not the banner advert, but I think mn has a paid for thread section

Although this thread is a good start

@MRex yes that's a great idea about the donation option - I hadn't thought of that.

I have tried to get in touch with the newspapers / journalists but I've found it pretty hard. I'm sure there is probably a media etiquette that I am getting totally wrong! But I am going to keep trying!

It's shame to have built it and not have people realise it's available.

Trying to get the site to appear on Google searches is so hard!!!! I hadn't realised that would be so difficult.

Well done on the site. Great lay out and simple to navigate.

Little owl, you are so clever. Thank you.

Looks great! Only slight niggle is I had to guess where Bristol might be (Gloucestershire! ). It appears in varying existing and non-existent counties when you do auto-address lookups on different websites so I'm used to it!

That's fab little owl! I have signed up. Is it okay to share on SM?

I’ve signed up too. Should I have received a welcome email? (Since you’re here ;)

Oh amazing! That's great! That's a great point - I haven't a welcome email set up. But your email alerts will start tomorrow.

Add to list: set up welcome email...

I will try and do that today. Thank you for that feedback. That's an oversight on my part.

It’s really good, simple, easy and clear messaging. I think you’ll do well. I’d never usually just sign up to something linked here so it shows you’re on to something. I wonder if LAs would be interested in paying to then supply.

Im not sure what SM is but yes please share!

I've had a few councils that are across counties and I'm trying to list them in both. So if anyone spots any please message me so I can fix it!

Brilliant I had no idea. I will check that out.

SM = social media!

There shouldn't be any local authority areas that are in more than one country @littleowl. That's not how local government boundaries work. I suspect the issue might be with looking up postcodes, which do cross administrative boundaries.

That's so helpful. Thank you very much. I will review.

I meant county not country obviously!