Meet the Other Phone. Protection built in.

Meet the Other Phone.
Protection built in.

Buy now

Please or to access all these features

Covid

Mumsnet doesn't verify the qualifications of users. If you have medical concerns, please consult a healthcare professional.

Daily numbers, graphs, analysis thread 11

982 replies

BigChocFrenzy · 24/06/2020 16:05

Welcome to thread 11 of the daily updates

Resource links:

Slides & data UK govt pressers
NHS England stats including breakdown by Hospital Trust
ONS UK statistics for CV related deaths outside hospitals, released weekly each Tuesday
Financial Times Daily updates and graphs
HSJ Coronavirus updates
Worldometer UK page
Covidly.com to filter graphs using selected data filters ONS statistics for CV related deaths outside hospitals, released weekly each Tuesday
Plot COVID Graphs Our World in Data

We welcome factual, data driven, and civil discussions from all contributors 💐

OP posts:
Thread gallery
90
Choux · 05/07/2020 10:55

I just realized you can add a 7 day rolling average to the graphs so am reposting them.

Upward trend most visible in Arizona and Texas.

Daily numbers, graphs, analysis thread 11
Daily numbers, graphs, analysis thread 11
Daily numbers, graphs, analysis thread 11
Choux · 05/07/2020 11:03

www.texastribune.org/2020/07/04/texas-coronavirus-rio-grande-valley-hospitals/

"In San Antonio, Alan Harris, president and CEO of Methodist Health Care System, said coronavirus cases in its hospitals have more than quadrupled over the past two weeks — an increase that he called “unsustainable.”

And in the Rio Grande Valley cases in hospital have tripled over the last two weeks.

In terms of reducing the spread The governor has statewide executive order to limit outdoor events to 10 people and mandated that Texans to wear a face covering in businesses and indoor public spaces.

Humphriescushion · 05/07/2020 12:17

Just to be clear France does still record and count care home deaths but only on a tuesday now. This is quite recent and numbers have been quite low. Also worth bearing in mind that shops opened on the 11th of may and that was effectively the end of lockdown in most of France. ( interesting to see if cases went up a few weeks after).
Also i saw something yesterday that cases in France include Guyane and Mayotte - two overseas territories which are still on alert and have not been put in the green zone yet. I had not been realised this. I will so some digging on this later.

Baytreemum · 05/07/2020 12:41

Thank you for this brilliant thread. It is such a relief to be able to see up-to-date data and to read your clear interpretation and assessment of this. I was wondering if you had a view on the recent study of covid transfer in a bus, a restaurant and an open plan office, all enclosed spaces with airco and no opening windows. It was suggested that microscopic viral particles could remain airborne for days. Do you think we should be worried about this?

Fairineouf · 05/07/2020 13:14

@SummerBreeze23

Just worked this out quickly based on the date Italy, France and Spain opened their bars.

Italy May 18th cases 675 deaths 99.
France: 11th June cases 425 deaths 27
Spain: June 8th cases 167 deaths 12.

So on a parr with Italy but quite a bit higher than the other two.

I think we should exclude Spain from any comparison as we know they are manipulating their data regarding both deaths and infection rates.

According to this article HERE they had more than 15,000 unexplained additional deaths (date of article 5 June).

Choux · 05/07/2020 13:27

@Baytreemum personally I am assuming it is airborne and wearing a mask in any shop. Plus avoiding crowds.

"The W.H.O. has resisted mounting evidence that viral particles floating indoors are infectious, some scientists say. The agency maintains the research is still inconclusive."

"If airborne transmission is a significant factor in the pandemic, especially in crowded spaces with poor ventilation..,. Masks will be needed in indoor settings even if socially distanced".

www.google.co.uk/amp/s/www.nytimes.com/2020/07/04/health/239-experts-with-1-big-claim-the-coronavirus-is-airborne.amp.html

PumpkinPie2016 · 05/07/2020 16:22

516 cases and 22 deaths today.
814 cases and 36 deaths 28/6 (last Sun)
1103 cases and 43 deaths 21/6
1368 cases and 36 deaths 14/6
1198 cases and 77 deaths 7/6

PumpkinPie2016 · 05/07/2020 16:26

Just been looking back and that's the lowest figures since March 18th.

I think back then was only pillar 1 testing as well and far fewer tests being carried out.

Littlebelina · 05/07/2020 16:35

Where did you find that @PumpkinPie2016? The gov.uk website hasn't been updated yet (I understand and sort of agree with the decision to stop the twitter table but I did like it)

Littlebelina · 05/07/2020 16:36

Got it! Had to click another link

itsgettingweird · 05/07/2020 16:57

Still great results.

Let's hope it continues that was now we are more up and running in society and track and trace continues to work well and also monitoring if local outbreaks.

BBCONEANDTWO · 05/07/2020 18:07

That's fantastic news (obviously not to the new deaths and condolences to the families).

BigChocFrenzy · 05/07/2020 18:14

This was yesterday - 137 deaths and 544 positives - but I haven't seen today's breakdown yet

Daily numbers, graphs, analysis thread 11
OP posts:
Frazzled2207 · 05/07/2020 18:41

22 deaths
515 cases.

BruceAndNosh · 05/07/2020 18:54

@Frazzled2207

22 deaths 515 cases.
Gov.uk site says 67 deaths
torydeathdrug · 05/07/2020 19:02

@BruceAndNosh that's yesterday's figures - from the beta site which hasn't been updated yet (coronavirus-staging.data.gov.uk/)

Today's figures are here coronavirus.data.gov.uk/

516
Number of additional cases on Sunday 5 July 2020

22
Number of additional deaths on Sunday 5 July 2020

BruceAndNosh · 05/07/2020 19:14

[quote torydeathdrug]@BruceAndNosh that's yesterday's figures - from the beta site which hasn't been updated yet (coronavirus-staging.data.gov.uk/)

Today's figures are here coronavirus.data.gov.uk/

516
Number of additional cases on Sunday 5 July 2020

22
Number of additional deaths on Sunday 5 July 2020[/quote]
Thanks, I'd didn't realise I'd bookmarked the beta version

Littlebelina · 05/07/2020 19:24

I thought this was a good way to present the data (seen on Twitter mobile.twitter.com/LawrenceGilder/status/1279811880719200259) if you prefer numbers to graphs

The rolling 7 day average for hospital deaths is now just under 40

Daily numbers, graphs, analysis thread 11
itsgettingweird · 05/07/2020 19:29

@Littlebelina

I thought this was a good way to present the data (seen on Twitter mobile.twitter.com/LawrenceGilder/status/1279811880719200259) if you prefer numbers to graphs

The rolling 7 day average for hospital deaths is now just under 40

I agree. That is good.

I'm really pleased we've had great numbers people doing this here since day dot. It's good to see previous weeks and days.

BigChocFrenzy · 05/07/2020 20:15

BBC: UK hardest hit by virus among leading G7 nations

https://www.bbc.com/news/business-53222182

The BBC has worked with the Health Foundation, an independent health analysis charity,
and economists at Oxford University's Institute for New Economic Thinking
on comparable analyses between countries.
.....
The research compared 11-week periods for each nation as the virus hit its peak in each country.

The analysis of Covid-19 deaths and excess deaths - which compared countries in three different ways - showed the UK worse off than the US, Germany, France, Italy, Canada, and Japan.
......
A separate analysis of European nations, by Oxford University economists,
has England just above Spain in terms of the proportion of deaths over and above what would be normal.
.....
On all three measures of the G7 nations

  • recorded Covid-19 deaths per 100,000 people, excess deaths per 100,000 people, and excess deaths as a proportion of the usual level of deaths

- the UK has been the hardest hit.

Of the G7 nations, Germany, Canada, and Japan, have seen comparatively few deaths.

OP posts:
BigChocFrenzy · 05/07/2020 20:16

.

Daily numbers, graphs, analysis thread 11
Daily numbers, graphs, analysis thread 11
Daily numbers, graphs, analysis thread 11
OP posts:
ShootsFruitsAndLeaves · 05/07/2020 22:11

Some countries are doing a very bad job of handling covid-19.

For example in Indonesia the prices for testing are set on a local level.

So-called rapid tests test for antibodies and will not show up at all for recent infections

theconversation.com/why-cant-we-use-antibody-tests-for-diagnosing-covid-19-yet-138519

However in Indonesia they are a cornerstone.

To get on a plane must have either a (shit) rapid test or (good) real-time PCR test newsroom.airasia.com/news/2020/5/26/indonesia-domestic-and-international-travel-requirements and for arrival real-time PCR only.

The cost of such tests are set locally, for example in one city

www.mistar.id/siantar/warga-siantar-keluhkan-harga-rapid-tes-covid-19/

the official prices are 335,000 IDR (about £20, or 3 day's wages) for a rapid test and 1,940,000 IDR for a RT-PCR test (£110, or 3 week's wages for low-paid people)

Meanwhile there is a nice little trick with the rapid tests (useless) vs. the RT-PCR

If we look at the data for Jakarta

corona.jakarta.go.id/id/data-pemantauan

we see

248,724 rapid tests for Jakarta, of which 8598 'reaktif'

meanwhile
338,306 pcr tests on 166,993 distinct people, of which 12,313 people positive.

If we look at the test results, 3.5% of the rapid tests were reactive, 7.4% of the PCR patients positive, and 7.7% of the PCR tests.

That's in Jakarta, where the lab facilities are obviously the best in the country.

Meanwhile if we look at somewhere slightly more remote, we can see a news report of 38 out of 345 market traders tested with rapid test in Palangkaraya Central Kalimantan were reactive. This is 11%

If we look on the government website rapid tests aren't even mentioned

corona.kalteng.go.id/

Instead if we look carefully we can spot a few numbers:

+13 cases (this refers to RT-PCR positive), to 1029 total, and +1000 RT-PCR tests to 4647.

So the positive rate is 21.5%, but only 4647 tests out of 2.2 million people (1 per 500 people).

Compared with Jakarta, where there has been 1 test per 30 people.

The rapid tests appear to be 20-40% false negative www.sciencedaily.com/releases/2020/06/200610094112.htm

So in summary:

  1. if you take a (much cheaper) rapid test, then you will often falsely found negative
  2. if you are found reactive, then you should be further tested by RT-PCR, but until that happens you won't be counted as positive at all in the Indonesian statistics.
  3. as in the example above, the cost of testing is a deterrent, and this is likely political, as for example I know an old woman who works in the market who has possible symptoms, but when she visited the doctor no test was offered, and even if she had taken a rapid test then this might falsely find her negative for covid-19, and if reactive she would not be counted positive till if/when tested properly.
  4. the testing outcomes determine whether an area is allowed to open up for business, but if people aren't being tested or not counted then this might give false results [note that there are two alternative statuses, 'ODP' and 'PDP' which refer to 'person under monitoring' and 'patient in treatment' respectively, which are tracked locally, but won't make it into international numbers until if/when they are found RT-PCR positive]
  5. It follows that the CFR and total fatalities are total bollocks compared to, say, the UK. For example in the UK we know how many people die each week, and recently doctors have simply said 'dead from corona' when old people have died with relevant symptoms. This is not going to happen Indonesia. So for example, the '3171' dead will be totally bollocks and the true figure will be many times higher. How much higher? No idea whatsoever. Maybe excess deaths can be calculated somehow at some point? And then the IFR should be a small fraction of 1%, due to a young population, so the total infections should be well into the millions, not the ridiculous 63,749 claimed (and no figure for those nationally rapid-test-reactive).
ShootsFruitsAndLeaves · 05/07/2020 22:21

that should say
"+13 cases (this refers to RT-PCR positive), to 1029 total, and +100 RT-PCR tests to 4647."

not +1000 RT-PCR tests.

And if we look at the small print it's actually far, far worse:

corona.kalteng.go.id/konten/images/data.jpeg

That says

1029 positive
1250 negative
2368 still in processing

That is to say the positivity rate is in fact 45.2%, which is ludicrously bad, considering this is an 'outdoors' area with a small capital city of only 275,000, not with major offices/malls/ lots of air con like you'd get in a more densely populated area. Also the population density is just 17/square km, though much of that is dense jungle.

ShootsFruitsAndLeaves · 05/07/2020 22:30

Just to add, it's probably quite effective to perform rapid tests as a low-cost testing method, as statistically if you have a false positive and a false negative rate, then it simply means that your results have a wider confidence interval than those conducted by more effective means.

So it's good as a crude method of surveillance, but not good if you have symptoms and want to find out if you are infected.

BigChocFrenzy · 05/07/2020 23:25

Tests are very useful to estimate infection over a population,
but some are not suitable for an individual to base decisions on, or to receive privileges
e.g. immunity passport, or entry into a country

OP posts:
Swipe left for the next trending thread