JohannesBorgen Profile picture
Oct 26, 2020 57 tweets 14 min read Read on X
Last Friday, Macron floated the idea of a new general lockdown in France. Ouch. And because I’m fed up with reading so much garbage and contradictory stuff on Covid, I decided to have a hard look at the French data. A (long but important) thread.
The questions I want to answer:
How bad is the 2nd wave?
How fast is it growing?
Does it affect only young people as some claim?
Is Covid really treated better?
Is the fatality rate really going down?
Can the government stop the 2nd wave quickly enough?
All important questions.
BTW this is French data but I suspect the data looks the same all over Western Europe, with time lags.
FIRST QUESTION.
How bad is the 2nd wave? The most important thing to know is this: forget cases data, they are useless because the first wave was grossly underestimated (a factor between 10x and 20x imo).
So what can we use? Hospital data, which is consistent, homogenous, and objective. But how? There are so many data series to look at. Let’s start simply with ICU+Hospitalisations for all age groups. Image
It looks like we’re still quite away from the peak, but growing fast. Is this biased by a specific age group or another effect?
To double-check I used a PCA to identify the main factor in all hospital time series. It turns out one factor explains 80% of the variance (of 40 series!) so this is clearly the pandemic factor, and here’s what it looks like over time. Image
We’re growing dangerously fast towards the previous peak.

But how fast? That’s QUESTION 2.
You’ve all heard about R, the famous reproduction number…that no one can reproduce because it’s so complex to estimate!
See e.g. the recent thread of @gro_tsen. One main problem is again the shitty case data. Here’s what R estimates look like with EpiEstim, (state of the art) Image
If you really believe the left part of the chart I have a bridge to sell to you. How can we get around this problem? By using hospital data, again.
Sure, it’s not a proper “epidemic incidence data” per se, but if the % of people going in ICU or hospital is more or less constant, the curves have the same shape and R are the same. Here are the R estimates we get using hospital incidence data.
Daily hospital arrivals Image
Daily ICU arrivals Image
Daily deaths Image
Very interestingly, all estimates are consistent, as you can see below with a comparison of current R estimates for all series. (sorry, I’m lazy, labels still in French “réanimations” = ICU) Image
So that’s our answer: R is approximately 1.2, which means numbers double every 20 days and we should get to the (dramatic) ICU peak in 25 days.
QUESTION 3: does Covid hit mostly the young now? Short answer: No, that’s bullshit. Detailed answer now.
First clue, let’s look, for each age group, at its share of total Covid ICU, Hospi, Deaths data, compared to the demographic share. No big surprise there, except the ICU share of the very old which is important and I’ll discuss later. Image
Did that change over time? I split in three groups: all data, data before first peak and data since September. I get this.

First in hospital Image
In ICU Image
And deaths Image
If you can spot a change there… you’re good, and it’s only in ICU data for the very old. The rest is almost perfectly stable.
If you still don’t believe it, here’s a chart showing the (rescaled) hospitalization data for all age groups vs. the 20-29-year-old, per 100k. The two curves are almost perfectly superposed which means there’s no real difference in 1st wave and second wave. Image
You can use all statistics (hospitalisations, deaths, ICU) and age groups and you will get to a similar conclusion. Except one: ICU for 80+. This is the most horrible chart I know. Older people are now getting A LOT in ICU. Image
In a way it’s good, it means they get treatment, but unfortunately, what it also means is that hospitals were so swamped in the 1st wave that they had to make horrible ethical choices and had to let the oldest die without any possibility of intensive care. Grim.
What it also explains is the fact that hospitalizations grow less quickly than ICU in the second wave: that’s because we have more older people going into ICU than before.
Another relevant question: do older people in hospitals lag younger ones? In other terms, is it the young who infect the old? Here’s a cross autocorrelogram of 20-29 yo vs 80-89 yo. Image
Yes, it’s not symmetrical so the young get in the hospital first, but the effect is small (correlation weighed- lag is 2.7 days)
FOURTH QUESTION.
How bad is the disease now compared to the first wave?
It’s impossible to use fatality rates or hospitalization rates to answer that question because (AGAIN) cases data from the first wave are USELESS.
So let’s look at the other possible "transition": the share of people in the hospital going to ICU (but we have to be careful with the oldest age groups, see above). That’s what I get with all age groups. Image
The very good news is that for the same hospitalization rate, we have now approx. 25% less ICU. Clearly, hospital doctors are better equipped to deal with the disease. But it’s not true for everyone. The effect is strong for younger age groups. Image
But fades away for older age groups. Image
FIFTH QUESTION.
Does Covid kill less? I’m not a big fan of that question, because it makes the disease a kind of binary thing (you die or not) and ignores possibly long-lasting consequences.
Still, I can't deny it’s an important question.
If you look at a representative age group (70-79, other curves are similar) we get the same message as earlier: you die less (almost half less !) going to the hospital now than in the first wave. Image
However, this effect is also fading away as you’re older. Image
The reverse is true for ICU! There is no improvement in the fatality rates in ICU for the 60-69 age group, but it’s getting better for older people (which I suspect is due to the very different ICU admission policy for older people) ImageImage
The daily mortality rates in hospitals and ICU confirm this view (here for the 70-79 age group). ImageImage
Those curves also show a worrying trend: the daily mortality in hospitals is increasing, suggesting a lower quality of care as some hospitals get swamped again. (There is also obviously a lagging effect)
SIXTH QUESTION: can the government stop it quickly enough?

Yeah, I’d really like to know the answer to that one.
First, it’s clear that the incidence data (hospi, ICU or deaths) is strongly autocorrelated as the auto correlogram below shows. You’re not stopping this overnight. Image
The best approach to see what’s going on with autocorrelated data is to use an ARIMA model, and here’s the 1-week forecast of hospital incidence taking into account the weekly seasonality. Image
The problem with that kind of model is obviously that it misses the bigger point: how does R move over time? There are two main drivers imo: the number of social contacts and precautionary measures taken during those contacts.
Hard to have a view on the second topic, but the first can be measured using Google mobility data. When I correlate GMD with rolling estimates of R I find that the key variable is “transit” (but “Home” is also very useful.)
Indeed, if you plot Transit vs R with a 12-day lag, you get this (yeah, I know, borderline chart crime, but this is not an easy thing to estimate!) Image
I’ve used another approach which is to fit an optimized VARMA model on both series and to measure the so-called impulse function, i.e. how long does it take for the changes in one variable to feed into the second variable. Image
14 days are necessary to get a full effect, 8 days will get you half the job done.
What’s the general conclusion of this?

In France, 2nd wave is like 25th march on 1st wave, growing fast (R=1.2, doubling every 20 days, ICU peak in 25 days.)

There’s no difference in the age split of the pandemic in 1st and 2nd wave expect that now older people go into ICU
Hospital care is better (25% better) but deteriorating.

There’s no big difference for older people.
Based on Google mobility data, any measure will feed into hospital data with a 10-14 lag.

We should (could?) see the impact of curfew soon in the data.

If we don’t, the government will have a week (more or less) to decide new measures.
@phl43 @Sime0nStylites @DavidKeo @spignal

(Tagging a few poor souls stranded in our forsaken land)
With better resolution sorry Image
With better resolution Image
With better resolution Image
(I should point out that all charts comparing age groups are rescaled for a size effect among each group!)
Thanks to @BiasedStats for spotting an error in this chart (and another one); I plotted the wrong column of data for deaths (the conclusion is exactly the same, though). Image
And this one had the same error Image

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with JohannesBorgen

JohannesBorgen Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @jeuasommenulle

Jun 11
If you're following French politics, you'll probably hear about a weird theory soon, as it's likely to go mainstream: Macron could resign, call for new presidential elections and run again, effectively bypassing the 2-term limit.

Is it credible? I don't think so and here's why.
The Constitution bans more than two consecutive terms.

Everyone pretty straightforwardly understands this as "Macron can't run again in 2027" (but could pull a Putin & come back in 2032.)
However the exact wording mentions "mandats consécutifs" which, some suggest, implies that if someone is a temporary president after Macron resigns (even for a few weeks) then a 3rd Macron term wouldn't be "consecutive." Image
Read 6 tweets
Jun 10
By now you've probably read 10 times that Macron called parliamentary elections to put RN/Le Pen in power & wait for them to mess up so much that Macron's heir will win in 2027.

I think that's a possible scenario but not his goal at all. It misses Macron's real target.

Thread.
Many reasons why it's probably not his goal.

1.- The main negative for Le Pen is that she (&her father) have always been seen as incapable of governing. They’re a protest party, nothing more. Break that taboo and you could actually help them.
2. A majority for Le Pen not certain. They've got 88 MPs, majority is 289. They scored 19% at last parliamentary elections vs 33% yesterday but were at 23% previous European elections. The two-round system makes the votes/ seats relationship highly non linear. Forecast is v hard.
Read 15 tweets
May 30
The headlines that grabbed attention yesterday was this: "ECB to Impose First-Ever Fines on Banks for Climate Failures."

But the climate and bank headline that was actually important is a totally different one.

An (important?) thread.
An “ECB” working paper (so in theory just academic work, but, errr.) published 2 days ago discussed capital buffers for climate risks. T

he basic idea makes sense: an increased pace in energy transition is good for the climate but could hurt the credit profile of some companies.
How is this assessed?
The ECB has built a macro model that’s mostly based on energy prices, spillovers & leverage / profitability that ultimately leads to probabilities of default. A neat model but tbh I’m always dubious – unfortunately macro models can’t even forecast 6mo infla
Read 10 tweets
May 13
Is another (what ?! not again!) Italian bank going to be bust?

The price action of BFF certainly doesn’t inspire much confidence.

What happened? Simple: the Bank of Italy did an inspection and suspended dividends (but not AT1 coupons.)

But why? Now, that’s a funny story. Image
The bank’s called BFF – no, it’s not your teenager’s best friend, it’s the old Banca Farma Factoring.

They have a very odd business model: they buy commercial claims on public administrations.

Because PA are so late in payments, cash strapped SME go to BFF to get their money.
On average, the Italian situation doesn’t look THAT bad (chart below). But this hide huge differences & peak delays can be extremely high.

In fact, it was so bad that the European commission decided to refer Italy to the court of justice because of it (in 2017.) Image
Read 14 tweets
Feb 20
Interesting note this morning from DB about ECB policy review and money market rates. Let me summarize it.

ECB has de facto moved from a corridor system to a floor system with unlimited MRO + QE.

But as QE etc unwind, there’s a big risk lurking. A thread
For those unfamiliar with the jargon, a corridor means that the market rate (EONIA) is stuck between two policy rates, the deposit facility rate (DLF) and the marginal lending rate (MLF.)

That’s what it looked like before 2008 & the GFC.

(Market rate is yellow) Image
After all hell broke loose in '08, the ECB flooded the market with money and this is what it looked like: market rates were stuck at ECB deposit rates because there was too much money in the system and it had to be deposited back at the ECB (ECB money is just doing round trips). Image
Read 10 tweets
Nov 24, 2023
My 2 favorite docs are the Jap & Ger financial stability reports because they give a glimpse at the horror of small unlisted banks😁(don’t sue me, I’m just kidding).

What did we get from the new German one ?

Buckle up, as they say in 10,000$ a year doomsday newsletters.
You won’t believe it: CRE is in trouble – but tbh office is surprisingly resilient so far. Image
Ok, CRE is fun, but have you tried interest rates risk and bn of securities unrealized losses in the balances sheet?

Realised is 25.8bn so total is around 70bn€. Tbh this is also not that much compared to the US shitshow. Image
Read 14 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us!

:(