Data, Stats Thread June 11

[PatriciaHolm]

UK govt pressers Slides & data

www.gov.uk/government/collections/slides-and-datasets-to-accompany-coronavirus-press-conferences#history

Data Dashboard coronavirus.data.gov.uk/
Covid 19 Genomics www.cogconsortium.uk/tools-analysis/public-data-analysis-2/
Covid 19 Variant Mapping Sanger Institute covid19.sanger.ac.uk/lineages/raw
NHS Vaccination data www.england.nhs.uk/statistics/statistical-work-areas/covid-19-vaccinations/
Global vaccination data ourworldindata.org/covid-vaccinations
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 imperialcollegelondon.github.io/covid19local/#map
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 area 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, cases, tests, deaths Dashboard public.tableau.com/profile/public.health.wales.health.protection#!/vizhome/RapidCOVID-19virology-Public/Headlinesummary
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 (from last summer) 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 (European Centre for Disease Control rolling 14-day incidence EEA & UK www.ecdc.europa.eu/en/cases-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=eur&areas=usa&areas=bra&areas=gbr&areas=cze&areas=hun&areasRegional=usny&areasRegional=usnj&areasRegional=usaz&areasRegional=usca&areasRegional=usnd&areasRegional=ussd&cumulative=0&logScale=0&per100K=1&startDate=2020-09-01&values=deaths
PHE local health data fingertips.phe.org.uk/profile/health-profiles
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

The "admitted with" Vs "caught it in hospital" split is a different thing from whether or not someone's reason for being in hospital is Covid though. Some admissions may be with Covid rather than because of it, and some of those who catch it there may become very ill from it so stay longer for that reason. The NHS were supposed to be getting data sorted to distinguish who is in hospital because of it, but AFAIK that's not been done yet.

They test everyone every 2 days during a hospital stay, these people could be asymptomatic for all we know.

Obviously it'll still be a burden managing a covid + person, having to isolate etc but they may not be actually ill with covid.

@EndoplasmicReticulum

Interesting about the hospital transmission

"About a third of the patients are thought to have caught the virus after being admitted, the Local Democracy Reporting Service said."

Has that been the case throughout, do we know? Figures for people "admitted with something else but also have covid, or catch it once in" as compared with "admitted because of covid".

Can only give one data point - my mum had stopped eating and her organs were failing last November, was admitted to hospital testing negative for covid.

Within 2 days she tested positive having caught it in hospital, showed no symptoms and had no respiratory distress. She later passed away due to her existing condition and the cause of death on her certificate is covid 19.

We never quite knew how to parse that, but were told it was a frequent thing. She didn't die 'of covid' at all, but went into the figures regardless.

Obviously due to this being a personal loss for us, we have been curious to what extent this happens.

Yes the hospital data is frustrating.

During the initial wave there wasn't sufficient testing to test everyone in hospital regularly so only people with classic COVID symptoms would have been tested but I'm assuming the numbers we have are likely to be a significant underestimate.

Now with mass testing there will be people admitted to hospital because they are ill from covid, people who are admitted to hospital for a completely unrelated reason and then test positive but remain asymptomatic/are only mildly unwell, people who are admitted for some other reason and then test positive and subsequently become unwell due to covid etc, etc.

I suspect the second category could make up more of the total now more people are vaccinated.

I'm not sure that a nebulous figure that lumps together all the various permutations is that helpful at all unless I'm missing something (which is entirely possible!)

@Firefliess

The "admitted with" Vs "caught it in hospital" split is a different thing from whether or not someone's reason for being in hospital is Covid though. Some admissions may be with Covid rather than because of it, and some of those who catch it there may become very ill from it so stay longer for that reason. The NHS were supposed to be getting data sorted to distinguish who is in hospital because of it, but AFAIK that's not been done yet.

How do they know caught it in hospital means actually caught it in hospital though? Obviously if you get one positive case and then watch the outbreak spread round the ward then it's different. Similarly if the patient has been in hospital for weeks. But the definition of 'caught it in hospital' can't possibly be tested negative on admission, but subsequently tested positive. That would be ludicrous.

Rates in Durham city are crazy.

Something like 1600 ish per 100,000

My fault, I missed the crucial sentence. It's 7 days. I'd guess that's still a slight overcount on the number of cases that are acquired in hospital.

It's 7 days. I'd guess that's still a slight overcount on the number of cases that are acquired in hospital

I don't think it's many, particularly as anyone ill enough to be in hospital for 7 days probably weren't spending their previous days widely mixing.

@WarriorN

Rates in Durham city are crazy.

Something like 1600 ish per 100,000

Anecdata but lots of students are testing positive in Durham at the moment, we've heard the same about Bristol.

Some updated graphs on latest 7 day rate and the movement as compared with the previous 7 day period. The movement is the absolute change in the rate not a percentage change. Thus somewhere that was 5 per 100,000 and is now 10; has a movement of 5 as opposed to 100%; and somewhere that has moved from 200 to 300 has a movement of 100, as opposed to 50%.

The x axis is therefore the latest rate and the y axis the extent of the movement.

Based on a 2 day lag, which with spec dats starting to stretch out a little, I may need to consider reviewing. But that's what it is for now.

After the wholly unacceptable aberration last time round first up is East of England UTLAs - which have quite a few downward moves. They do not however set the tone for all that will follow.

One for England overall showing the ^delta plume*

English regions

@WarriorN

Rates in Durham city are crazy.

Something like 1600 ish per 100,000

Message from Durham University:-

"We have a significant outbreak of the Delta variant amongst our student community."

www.dur.ac.uk/coronavirus/students/latestnews/

Looking at the map for Leeds, it's like the autumn again. The areas of Leeds that house students in halls and houses are purple.

counties in England - eg all those with lots of district councils. Don't worry the council level detail will follow.

Outer London boroughs; few starting too dip; not by much; but a dip all the same.

Inner London

East of England district councils in Cambridgeshire, Norwich and Suffolk

East of England completes with Essex and Hertfordshire councils

East Midlands Derbyshire; Lincolnshire and Leicestershire

East Midlands Northants, Notts plus UTLAs

North West UTLAs -Bolton and Blackburn both with falling rates

North West with districts in Cumbria

North West districts in Lancashire

North East