Data, Stats & Daily Numbers started 5th August 2021

[boys3]

This is the DATA thread. We welcome factual, data driven and analytical contributions
Please try to keep discussion focused on these
UK govt press conferences slides & data www.gov.uk/government/collections/slides-and-datasets-to-accompany-coronavirus-press-conferences#history
PHE Variants of Concern Technical Briefings www.gov.uk/government/publications/investigation-of-novel-sars-cov-2-variant-variant-of-concern-20201201
PHE Vaccine efficacy www.gov.uk/government/publications/phe-monitoring-of-the-effectiveness-of-covid-19-vaccination
SAGE : Minutes and Models www.gov.uk/government/collections/scientific-evidence-supporting-the-government-response-to-coronavirus-covid-19
Data Dashboard coronavirus.data.gov.uk/
Dashboard Vaccine Map to MSOA level coronavirus.data.gov.uk/details/interactive-map/vaccinations
Covid 19 Genomics www.cogconsortium.uk/tools-analysis/public-data-analysis-2/
Sanger Genome Maps & Data covid19.sanger.ac.uk/lineages/raw
UCL Virus Watch ucl-virus-watch.net/
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 MSOA Map English deaths www.england.nhs.uk/statistics/statistical-work-areas/covid-19-daily-deaths/

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

North West no sign of any unwelcome bounce back here either,

Bolton has second lowest rate in region and in the lowest ten in England.

Blackburn slight uptick but still in the lowest 10% of councils

South East bitt of a mixed picture.

After a jump in cases Isle of Wight may have flattened, and relative to the Lincolns and Sedgemoors its sudden upward lurch was at a much lower level.

Thanet another rapid rise in the week to Sunday but signs that is starting to fall back somewhat.

Remainder of the South East Swale continues amongst the lowest rates in England, as indeed do many of the Kent districts and boroughs.

Interesting tables, boys3.

In fact, it looks like in many areas we are close to endemic equilibrium - so cases may go up and down but they are unlikely to skyrocket as they did in prior waves. I am also thinking that human behaviour now matters less than with older variants (as we see in Australia and NZ). It is much harder to control the spread. Our primary tools are now vaccines (thank you, modern science!) and acquired immunity.

The weekend festivals (Leeds, Reading, etc) might push cases up but, hopefully, like with Boardmasters the spillover into vulnerable population groups will be limited.

Not wholly for the data thread but from the document that jangly posted when did the the transformational change in funding and resourcing for NHS mental health services happen? Must be a really recent thing

I think you will be right about there being some likely impacts from Leeds and Reading winter, although I wonder whether they will be to similar levels or not?

What is the age profile (and the transport choices ) for Reading and Leeds compared with Boardmasters? Hopefully the publicity around toilets will mean this weekend’s festivals focus on that area, but I imagine the level of infection will also depend on he ratoo between older, vaccinated age groups and the age groups not yet fully vaccinated, and whether there are packed coaches of younger people stick onsite for hoirs ar the end.

Reading and Leeds are a tiny bit older than Boardmasters, but not much. It's mainly year 12s/13s. I'd imagine many of them went off to get jabbed pronto last week. But I doubt this has conferred much immunity.

Speaking of which, I am still suffering. No sleep last night and (slight)temperature back. Just having a grumble. Feel free to ignore me. It becomes extraordinarily hard to know whether this is something else.

Sorry to hear that piggy.

sorry you are still suffering piggy, hoping you recover soon.

Interesting article attempting to look at transmission in hospital in the early stages of the pandemic elifesciences.org/articles/67308 concludes that it was mainly patient to patient. Also that you get superspreaders in hospital too. Pity there was not more comment on the superspreaders but that would be difficult without breaching confidentiality.

Really sorry you are still not feeling well, Piggy. I have heard many times Covid comes in waves and sometimes it is two steps forward - one step backwards:(. Hope you will only get better from now on.

Quick query - what is the highest level of detail at which one can get infections by age (as a time series) and what is the best source for this? Happy to do some Excel work if needed.

Sorry, enquiry could have been clearer - highest level of geographical detail ie national / regional / county etc.

@cantkeepawayforever
The gov.uk dashboard gives you an age heatmap for each local authority under the 'cases' tab.

Thanks!

@alreadytaken

sorry you are still suffering piggy, hoping you recover soon.

Interesting article attempting to look at transmission in hospital in the early stages of the pandemic elifesciences.org/articles/67308 concludes that it was mainly patient to patient. Also that you get superspreaders in hospital too. Pity there was not more comment on the superspreaders but that would be difficult without breaching confidentiality.

Very interesting. I do think the HCW transmission should have been presented as two figures, with one excluding the only "superspreader" because the report says they actually lived with the people they infected. Yes, of course it has some relevance if it's provided nursing accommodation, but it isn't how most of us would consider "hospital acquired infections" and bare numbers from including it suggest the risk from HCW at work is vastly larger than it therefore actually is.

Get well soon Piggy! You might be picking up other infections due to being a bit weaker, so don't rule that out if you might need to see a doctor or pharmacist. Waves of fatigue and coughing are both common from people I know, unfortunately you really will need a LOT of rest over the coming weeks to let your body recover. It may be worth talking to the school ahead of time if full time might be a bit too much for you in just 1.5 weeks.

@cantkeepawayforever the download section also allows you to access data down to council level, plus by region, nation and uk overall, by day back to the start of the pandemic (if you really wanted to go that far back). I used the data from these for example for those age case profiles by region I posted a few days back. Just a case of downloading the regions file. The files show for each age band cases for each day (by specimen date), the rolling seven day total, and the rolling seven day rate, plus totals for under and over 60s which is perhaps a bit of a less meaningful split.

Have fun :)

Thanks! I'm interested in a restricted range of dates, want to answer a very specific question, and have a DH who loves Excel, so that should be OK.

Hi,

Where can I find a daily UK vaccination rate?
The figures I have read show the total vaccinations ( by millions) since the beginning of the roll out. It would be great to clearly see the total first doses (and second) administered at the end of each day without having to use my calculator! (am lazy)..
Thanks

@Lico coronavirus.data.gov.uk/details/vaccinations then scroll down the page a bit and you'll see left hand cumulative uptake and right hand a graph showing daily progression.

Get well soon Piggy!

Thanks for all your lovely kind words . I like that no one here judges, even though we all hold a range of views. I have spoken to GP who told me to keep taking nausea meds and may investigate issues with health when I am feeling a bit better but blood results OK.

I am a person who is never unwell - migraines and bouts of insomnia adide-so its hard, mentally.

The data on the thread is a blessed distraction.

Boys: thanks. I had not seen the tab ‘daily dose’.
Last figures are dated 22 August

Can someone help me with something? I've been googling to see if theres a number they think of people who have ever had covid.

Google says Jan/Feb it was 1 in 7 or 1 on 9 depending which source.

I can find lots of references to say 1-2% who had covid in a given week but I was wondering cumulatively when we get to the point that over half the population will have had covid?