Data, Stats & Daily Numbers started 27th Feb

[boys3]

UK govt pressers Slides & data //www.gov.uk/government/collections/slides-and-datasets-to-accompany-coronavirus-press-conferences#history
R estimates UK & English regions //www.gov.uk/guidance/the-r-number-in-the-uk
Imperial UK weekly LAs, cases / 100k, table, map, hotspots statistics Attendance explore-education-statistics. service.gov.uk/find-statistics/attendance-in-education-and-early-years-settings-during-the-coronavirus-covid-19-outbreak
NHS England Hospital activity //www.england.nhs.uk/statistics/statistical-work-areas/covid-19-hospital-activity/
NHs England Daily deaths //www.england.nhs.uk/statistics/statistical-work-areas/covid-19-daily-deaths/
Cases Tracker England Local Government lginform.local.gov.uk/reports/view/lga-research/covid-19-case-tracker
ONS MSAO Map English deaths //www.england.nhs.uk/statistics/statistical-work-areas/covid-19-daily-deaths/
CovidMessenger live update by council district in England //www.covidmessenger.com/
Scot gov Daily data //www.gov.scot/publications/coronavirus-covid-19-daily-data-for-scotland/
Scotland TravellingTabby LAs, care homes, hospitals, tests, t&t //www.travellingtabby.com/scotland-coronavirus-tracker/
PH Wales LAs, tests, ONS deaths Dashboard app.powerbi.com/view?r=eyJrIjoiZGYxNjYzNmUtOTlmZS00ODAxLWE1YTEtMjA0NjZhMzlmN2JmIiwidCI6IjljOWEzMGRlLWQ4ZDctNGFhNC05NjAwLTRiZTc2MjVmZjZjNSIsImMiOjh9
ICNRC Intensive Care National Audit & Research reports //www.icnarc.org/Our-Audit/Audits/Cmp/Reports
NHS t&t England & UK testing Weekly stats //www.gov.uk/government/collections/nhs-test-and-trace-statistics-england-weekly-reports
PHE Surveillance reports & LA Local Watchlist Maps by LSOA //www.gov.uk/government/collections/nhs-test-and-trace-statistics-england-weekly-reports
ONS England infection surveillance report each Friday //www.ons.gov.uk/peoplepopulationandcommunity/healthandsocialcare/conditionsanddiseases/bulletins/coronaviruscovid19infectionsurveypilot/previousReleases
Datasets for ONS surveillance reports //www.ons.gov.uk/peoplepopulationandcommunity/healthandsocialcare/conditionsanddiseases/datasets/coronaviruscovid19infectionsurveydata/2020
ONS Roundup deaths, infections & economic reports //www.ons.gov.uk/peoplepopulationandcommunity/healthandsocialcare/conditionsanddiseases/articles/coronaviruscovid19roundup/2020-03-26
Zoe Uk data covid.joinzoe.com/data#interactive-map
ECDC rolling 14-day incidence EEA & UK read https_www.ecdc.europa.eu/?url=https%3A%2F%2Fwww.ecdc.europa.eu%2Fen%2Fcases-2019-ncov-eueea
Worldometer UK page //www.worldometers.info/coronavirus/country/uk/
Our World in Data GB test positivity etc, DIY country graphs ourworldindata.org/coronavirus/country/united-kingdom?country=~GBR
FT DIY graphs compare deaths, cases, raw / million pop ig.ft.com/coronavirus-chart/?areas=gbr&areas=fra&areas=esp&areas=ita&areas=deu&areas=swe&areasRegional=usny&areasRegional=usnj&byDate=1&cumulative=1&logScale=1&per100K=1&values=deaths
Alama Personal COVID risk assessment alama.org.uk/covid-19-medical-risk-assessment/
Local Mobility Reports for countries //www.google.com/covid19/mobility/
UK Highstreet Tracker for cities & large towns Footfall, spend index, workers, visitors, economic recovery //www.centreforcities.org/data/high-streets-recovery-tracker/

⏭ Our STUDIES Corner ⏮www.mumsnet.com/Talk/coronavirus/3869571-Studies-corner?msgid=99913434

We welcome factual, data driven and analytical contributions
Please try to keep discussion focused on these

[JanFebAnyMonth]

Thanks @boys3

[boys3]

to get the ball rolling specimen dates for England for the cases reported today.

Friday 26th

1083 added as compared with 1232 last week.

Thursday 25th

4297 cases added today, two day total 5491; 26% lower than equivalent last week.

Wednesday 24th

873 added today, three day total 7036; also 26% lower than equivalent last week.

Tuesday 23rd

172 added today, four day total 8124; 24% lower than equivalent last week.

Monday 22nd

48 added, remains under 10,000 at 9920; 20% lower than equivalent last week.

[MargaretThursday]

Thank you!

[wintertravel1980]

Thanks for the new thread and the specimen date analysis, boys3.

[boys3]

51 Council areas in England showing rising cases in the most recent 7 days (using a 4 day reporting lag).

The two graphs shows the last 7 day rate per 100,000 on the x-axis and then one graph shows the percentage week on week increase; and then the other the increase in terms of the absolute number of cases. Both to be viewed in the context of the median rate in England being around (in reality just below) the 95 cases per 100,000 mark.

Rother in East Sussex has a 50% week on week increase as one graph shows, and the second that this in an increase of 14 cases. Rother's rate still below 50 per 100,000.

Sheffield has an increase of just over 11%; relating to 79 cases - current rate around 132 per 100,000.

Clearly Rother and Sheffield have very different populations. However as rates start to get lower the risk is that percentage increases can become increasingly misleading, hence a fuller context is needed.

The third attachments lists all 51 councils with rates, percentage increase and case increase

[FATEdestiny]

Thanks boys3

[ATieLikeRichardGere]

Thank you!

[Hardbackwriter]

Thank you for the thread and also the analysis of the increases, @boys3!

[Quarantino]

Thanks for the new thread!

[MRex]

Ditto!

[boys3]

Given cases are still important (imo) putting them together with other key metrics just for England, and using an indexed reduction from the point of the peak seven day average in each instance. So deaths peaked 22nd Jan; hospitalisations 12th Jan etc. Given a longer reporting lag for date of death the line end a little earlier.

Very positive direction for all of them.

[Duckchick]

Thanks boys3

[twolittleboysonetiredmum]

I’ve not been able to find this thread for weeks and it doesn’t keep me on when I ask to watch it. So sorry if this has been asked repeatedly!
Does the data look like it’s dropping quicker compared to previous lockdowns - which would be a result of vaccination? I can’t figure it out but I’m not great at comparing stats hence why I’m glad this popped up in active!

[PurpleWh1teGreen]

Thank You Boys. Really good to see the continued improvement in the numbers, and hopefully 20 millions vaccinated by the end of tomorrow.

[MRex]

@PurpleWh1teGreen - if you want to feel even more positive, the extras have actually already been vaccinated today, you just get the figures tomorrow to say over 20 m (hopefully). (Vaccination figures run a day behind.)

[PurpleWh1teGreen]

Yay! I’ve gone back to work at as mass vac centre & today has certainly been full on - in a good way. We have been doing people born in the mid 50s along with some group 6 and H & SC workers.

I’m really enjoying being a part of this.

[sirfredfredgeorge]

Does the data look like it’s dropping quicker compared to previous lockdowns - which would be a result of vaccination?

It wouldn't even necessarily be due to vaccination, it could just be due to the much higher level of immunity in the population from having had it, so we can't know. It's not falling that much differently though, but the "kent" variant is likely more infectious so more restrictions would normally be required for it to drop the same speed.

It's likely that vaccination and past infection are having an effect on reduction, the thing about lockdowns is though, that huge parts of the population are completely removed from having any chance of catching it, so it could just be that the groups who could still catch it (e.g. factory and supermarket workers who've likely already had it, and care home/medical care needed people who are likely vaccinated) are well protected, when the general population of "work from home" are not protected, so the rebound in cases upon opening could be as fast as before. Or there's more protection, we don't know for sure yet.

[NoGoodPunsLeft]

Thank you for the new thread @boys3

[Firefliess]

I helped out at our local vaccination centre too yesterday @purple. It was really fun seeing everyone so positive about getting their vaccine. We were working through group 6 mainly, included quite a number of people with learning difficulties who came with their carers or family member - Some of them were really nervous, but they all went in . And a fair few older people too who'd missed out thus far for to being in hospital, illness, etc.

[Frazzled2207]

Another long time lurker and occasional poster..
I have a question for you data experts. On the government website the hospital admissions and inpatients nationally and for regions is updated daily- but the info for individual hospitals- at least the ones I’ve looked at- it does not. Does that mean we can trust the admissions data? Why would nhs regions know how many people have been admitted overall but not the individual hospitals?

If my local hospital has not posted data since the 14th feb, is admissions since then missed off the stats? Data would obviously be very misleading if so.
Thanks

[lurker101]

Thanks @boys3 your daily analysis is one of the highlights of my day 😊

[Firefliess]

@Frazzled. I've wondered that and am not sure of the answer, though wonder whether it might be to do with trying not to double count people who are admitted to one hospital and then transferred to another?

[Firefliess]

Or it could be that the numbers "admitted" yesterday are actually the numbers of recent admissions reported yesterday, who were in fact admitted at different times over the last week or so?

[ceeveebee]

The “about this data” section tells you how the hospital reporting works - reported daily by region and nation, but only updated weekly by trust.

“ England

Data include all hospitals and are reported daily by trusts to NHS England and NHS Improvement......
......Daily data at NHS Trust level is reported weekly on Thursdays, in line with NHS England reporting”

[ceeveebee]

And the data is also published here on the nhs website daily by region, weekly by trust
www.england.nhs.uk/statistics/statistical-work-areas/covid-19-hospital-activity/