All About Numbers
Ever
since COVID broke ground, Nations, states within federal structures, local
governing bodies and various organisations collect, collate and publish numbers
relating to the pandemic. Covid performance is now about numbers; number infected,
hospitalised, recovered, dead etc. These are available in the public domain. Each
of these can be used the way one wants to. When performance is about numbers, it
can also be contested. Here numbers in the public domain are considered,
uncontested.
Data Base
The daily
numbers reported are in absolute terms. However, to even out spikes, a moving seven-day
average is considered. It provides better understanding of the trend. Linking
confirmed cases to deaths as percentages gives the prevailing covid mortality. Details
with respect to three states, Maharashtra, Karnataka and Kerala are given below
was collated. ‘Death/Case’ has been calculated from data available. Increase in
cases and deaths as percentage growth from the previous day has also been plotted
for each state.
|
Maharashtra |
Karnataka |
Kerala |
||||||||
Date |
Cases 7 -Day Avg |
Death 7 -Day Avg |
Death to Case Ratio |
Cases 7 -Day Avg |
Death 7 -Day Avg |
Death to Case Ratio |
Cases 7 -Day Avg |
Death 7 -Day Avg |
Death to Case Ratio |
||
16-May |
34,404 |
941 |
2.74% |
36,209 |
427 |
1.18% |
31,791 |
93 |
0.29% |
||
17-May |
32,594 |
909 |
2.79% |
35,291 |
420 |
1.19% |
30,439 |
96 |
0.32% |
||
18-May |
31,125 |
928 |
2.98% |
33,925 |
449 |
1.32% |
29,721 |
100 |
0.34% |
||
19-May |
29,880 |
1,009 |
3.38% |
32,428 |
446 |
1.38% |
29,228 |
107 |
0.37% |
||
20-May |
28,778 |
970 |
3.37% |
31,635 |
461 |
1.46% |
29,133 |
119 |
0.41% |
||
21-May |
29,138 |
969 |
3.33% |
30,473 |
470 |
1.54% |
31,066 |
124 |
0.40% |
||
22-May |
29,278 |
963 |
3.29% |
30,506 |
469 |
1.54% |
30,360 |
131 |
0.43% |
||
Linearity
Test
positivity Rate (TPR), represents the ratio of those found infected against the
numbers tested. Higher TPR means more infected people amongst those tested. Ideally,
number of cases, TPR and number of deaths are linearly related. Conversely, as afflictions
fall, TPR must fall and death must recede. Fortunately, TPR has been on the
decrease for some time. It means that daily infections and therefore deaths should
be coming down. But data suggests that even as TPR and daily confirmed cases were
coming down ‘Death-to-Cases’ was behaving differently.
Cases To Death Ratio |
||||
DATE |
INDIA |
MAHARASHTRA |
KARNATAKA |
KERALA |
28-Feb |
0.71% |
0.65% |
1.24% |
0.48% |
05-Mar |
0.58% |
0.48% |
0.73% |
0.60% |
10-Mar |
0.53% |
0.37% |
0.71% |
0.69% |
15-Mar |
0.50% |
0.36% |
0.37% |
0.72% |
20-Mar |
0.45% |
0.32% |
0.48% |
0.81% |
25-Mar |
0.45% |
0.33% |
0.35% |
0.60% |
30-Mar |
0.51% |
0.38% |
0.47% |
0.58% |
04-Apr |
0.52% |
0.51% |
0.43% |
0.46% |
09-Apr |
0.51% |
0.52% |
0.47% |
0.33% |
14-Apr |
0.50% |
0.52% |
0.43% |
0.21% |
19-Apr |
0.59% |
0.68% |
0.52% |
0.13% |
24-Apr |
0.73% |
0.99% |
0.56% |
0.10% |
29-Apr |
0.89% |
1.33% |
0.58% |
0.12% |
04-May |
0.94% |
1.40% |
0.60% |
0.15% |
09-May |
1.07% |
1.57% |
1.06% |
0.17% |
14-May |
1.26% |
2.12% |
1.14% |
0.26% |
19-May |
1.59% |
3.38% |
1.38% |
0.37% |
Note: The second wave commenced
in March, hence data from March
Data indicates that through
March 2021, death to cases ratio decreased, stabilised in April and then increased.
Though interstate differences are significant, the increasing pattern is
similar.
Kerala stood out different. Through February to mid-March Kerala posted growing death rates but controlled it and brought it down by mid-April. Obviously, there was something at work. It had to be identified and addressed to control deaths.
Discounting
Lag
A comparison
of daily numbers and deaths show the difference. On 05th May, ‘All
India’ number of daily cases hit the highest at 4,12,262 (39,1280, 7-day
average). The deaths reported that day was 3,784 (3770, 7-day average). Considering
the incubation period of 2 to 14 days, once contacted one can test positive within
14 days. The patient’s condition could deteriorate during this time or later. Therefore,
a lag between daily confirmed cases and death is inevitable. This also could also
range between 7 to 14 days. Thus, number of dead could continue rising for 7 to
14 days after the cases peak but should ideally fall thereafter in line with
the decrease in cases. If cases peaked on 5th May, death should have
peaked latest by 19th or 20th May and then descend.
The Mystery
Progress
of cases and deaths, plotted as percentage growth from the previous measure
mark, gives a clearer picture. The graph clearly debunks linearity between
cases and deaths. Even as number of cases decreased more people were dying!
Another intriguing aspect is that, though
growth of ‘death’ generally overtook growth of ‘cases’ during the period, end
march - early April, there has been no uniformity in the difference. Each state
shows different patterns, strongly suggesting regional influence. However,
clearly the increase in death shows an upward trend compared to the downward
trend of cases.
Solving the Mystery
Is increasing
death rate driven by shortages? Oxygen, hospital beds, medicines?
The second
wave acceleration commenced in March. It peaked by end- April. Hospital beds
and oxygen ran short. Many deaths could have been avoided but for such inadequacies.
Soon facilities were augmented and situation declared eased. Since infrastructural
inadequacies impact linearly, death should have increased when oxygen, beds and
medicines were running short and eased when these were addressed. Moreover, with
cases falling, load on infrastructure should have eased and deaths should have
fallen even further. Vaccination, despite what it is, should also have had some
impact. The graph gives a different picture.
Believing
numbers available, all India growth in rate of death crossed growth in cases around
26 March. It fell back only to run away in the third week of April. Soon it
started showing congruence to the drop in cases. This may correspond to the
period when shortages were addressed. However, by second way of May, even as
oxygen and bed shortages were addressed, gap in rates between the two started
increasing. Clearly more people amongst the infected were dying compared to the
previous periods even when medicines and oxygen were being made available. Why?
Deadly Second Wave?
Is the
second wave virus deadlier?
The primary
aim of the virus is replication, for which virus needs to spread. Spread depends
on virulence. Scientists have confirmed enhanced virulence of the mutated
strain. Though people die from covid, dead body is ‘dead end’ for the virus. After
all, herd immunity is the ecological equilibrium between the virus and its
host. No proof has emerged for enhanced lethality. With no scientific basis to
prove, we cannot attribute increasing deaths to enhanced lethality. The second
wave virus may not be deadlier than the first.
Comorbidity?
It is said that those with underlying medical conditions are more likely to succumb
to covid than others. Since comorbidity is common to both the waves, it cannot
be causing such a dissonance in linearity of relations.
What
else could be the reason?
Have
we missed something about virulence? Are we doing something differently this
time from what we did earlier - something impacting management or treatment
protocol?
Plausible
Argument?
During
the first wave people who contracted the virus were isolated early and treated
at medical facilities. This time around, people testing positive are advised to
stay home till, they have real difficulties. This has been done primarily to reduce the
load on medical facilities. Now consider these: -
1. Almost everyone with some means is now in possession of a pulse oximeter and a covid treatment kit.
2. Most have managed oxygen concentrators or cylinders and if they haven’t, they at least have the promise of one.
3. Almost everybody believes that there is no treatment for corona and treatment is required only for complications that develop from it.
4. The confusion about which medicines to be administered or not as well as the shifting stands on treatment protocols, publicly aired on National Television also seem to suggest elements of incoherence in how covid is managed.
5. Under such circumstances people prefer staying home as long as they can.
6. Most of them report to hospitals when they are critical.
7.Are the increasing deaths attributable to worsening complications that could have been avoided if they had accessed medical care earlier?
Is the policy shift, allowing people
to stay home till conditions worsen, silently pushing the death rate up?
Kerala Model
Despite the surge and
continuing influx of overseas Indians, Kerala continues to have very low
mortality rate.
The public health
infrastructure of Kerala is at par with that of Europe or America. Citizens have
access to professional medical care close at hand. Most primary health centres are manned by
qualified medical and paramedical professionals. Despite rising infections and high
incidence of hypertension and diabetes even in rural areas, death rate of the
state remains the lowest. The increase in death rate and surge in numbers of
cases are within the lag period of incubation and deterioration. The continued hike
in cases in April especially in the last week, seems to push up death rate. The
rate shows fall in line with cases. Could early access to professional medical
care be the factor?
Vigil - The Need
Early access to professional
medical care may just be one reason. There could be one or more of it. But there
is a need to identify it as soon as possible.
With the third wave imminent,
there is no way it can be wished away. Law makers, administrators, medical professionals
and citizens need to put their heads together and find that cause. It may help us
save lives. Confusion is inherent to pandemics, but getting over it, the
lifeline to millions, faster the better.
[1] All
these data has been picked up from the public domain (Coronavirus
statistics - Bing ). It has been rechecked
as on 25 may 1718 hrs. The data used is only for discussion purposes and is NOT
from any government officials
Well researched, data driven inferences! Enigma eludes. Something is happening. Is truth slightly far away?
ReplyDeleteAre we seeing the truth that coronavirus, post-coronavirus illness & related/consequential illnesses etc, takes humanity to another orbit!
Thank you for the response.
DeleteTruth unfortunately is the first fatal casualty in data centric performance evaluation. when humanity is reduced to mere statistics truth is always out of sight. I genuinely feel that our survival is more out of the ned for the virus to keep us alive. we have enough to keep us down.
Excellent write up supported by analytical tools. Facts and figures justify the reasoning of the auther. The Kerala model must be emulated by other states, if not immediately but well before the third wave sets in. Outstanding article
ReplyDeleteKerala Model is NOT a foolproof one. it just happens to work. it has its own issues.
DeleteI agree with the contention that the Second Wave is deadlier than the First. One reason for the higher mortality rates is due to the mutant variety of virus capablity of being air borne over a longer distance spreading infection at a higher and faster rate. The medical infrastructure available be it hospital beds, oxygen ,vaccines,etc is not adequate to contain this variant of the pandemic.Urgent ramping up of medixal facilities coupled with decision to go in for more effective vaccines like Covaxin or Sputnik V may help in better containment of the virus and it's effect.
ReplyDeleteNow that the Second Wave is predicted to plateau and graph to go down by Early July one cannot rest on one' s oars as there is a likelihood of a third wave by October this ywar.Timely imposition of lockdown in.the early stages would effectively nip the new strain in the bud.Hopefully ,by the beginning of next year most people would also have been vaccinated and this would be the ultimate comfotting factor.
Nicely researched article.
Thank you sir, for the detailed response. sir, there is NO conclusive proof that the mutated virus is deadlier. yes it has higher virulence. If responses are rolled out sans politicking things will work out easier , faster and better.
DeleteThe reason given at serial 5 and 6 seem more plausible. And there are states that don't report the number of cases correctly, but it is difficult to hide the number of deaths. Telangana was even passing off deaths due to Covid also as normal deaths till HC ordered to investigate each death. Talk about Kerala model only proves that the states have to acknowledge that health is a state subject and they have to do everything that they can and not shift the blame of their failure to centre.
ReplyDeleteBut there is no denying that the second variant was too strong and fatal.
A well researched blog..great
it is generally believed that the data available is fudged. I have relied on what is available. but yes investigative journalism has suggested massive under reporting. whether state or central subject we are dealing with lives. if that was purely state, the centre should leave the vaccination programme including sourcing and control to them. politics apart then credit and blame must go to them too.
DeleteThorough and objective analysis of data. Provides unbiased insights into the problem. Hope and pray for the well being of humanity and that the third wave never comes. In case there’s one, it is tackled well and minimise loss of precious lives.
ReplyDeleteThank you very much. let us hope virus is kinder and our machinery more coherent.
DeleteBeautiful scientific research meeting the purpose of analysis of existing pandemic. systematic collection, interpretation of data in planned manner.Solving the death mystery had meaningful conclusion.Govt and media should learn, improve and support health care system in next wave.
ReplyDeleteThank you very much for the response. death remains an enigma but the way we react even more intriguing. hope better sense prevails on all of us
DeleteThe conclusions drawn with limited data which is not trustworthy has very serious repercussions. Good attempt at trying to decipher the real cause but I am certain with the kind of data available we cannot reach at correct conclusions.
ReplyDeleteYou are correct about need for large data. With inadequacy of data one may reach different and incorrect destinations. That is why politicians and information managers choose data base wisely to suit their own needs. here i had NO such compulsions nor any motives. being accustomed to handling data at large scales, the first thing i do is to ensure adequate volumes to start analysis.
DeleteAs regards data for this article , i considered the entire available covid data of the country from the beginning and took state wise date where the spread was high. i also considered the low impact states too.
as always i also applied Bedford's law!! ( Try it. it may be an interesting exercise to do!!)
you also understand that the public has limited patience to read and attention span is fast depleting across the board. its only exposes that can garner eyeballs for long.
so a blog of this nature has to choose brevity. but topics like this automatically consume words.
So in this blog i could NOT put all that vast data. i also deliberately chose NOT to contest any data. since contesting official versions was not the aim of the piece.
As a student of public administration, my idea was to highlight the relation between an innocuous looking administrative order to mortality rate!
While everybody has their own interpretation about the increasing time gap between two doses of vaccine, people haven't fathomed the consequences of going late to hospital.
could that be a reason for the increasing mortality rate?
Very much an excellent typical JTC analytics sir. Statistics and data reveal that there have been slippages in our response, whether wilful or otherwise, is a matter of debate,although in a country many factors like polity and religiosity override the national interests, these things should be expected. I believe that education of the masses also have a tremendous impact on the response to such calamities. In a country where opportunist profiteering is rampant, with little or nil accountability of the executive and politico, this situation was bound to happen. I am sure we have learnt collectively as a nation,and if and when there is a reoccurrence, we will be better placed for a improved response. My blood group remains, as always, B+ive.
ReplyDeleteYou are being kind. Thank you. while i agree with almost everything you wrote, I reserve my comments on your assertion that " we have learnt a lesson" . interestingly my blood group is 'A+, and i remain positive too.
Deletethank you once again.
Exhaustive and we'll researched sir
ReplyDeleteThank you very much sir
DeleteTo the point and supported my ample data and analysis. Worth looking into..
ReplyDeleteThank you very much
DeleteVery Informative article Sir. Gives us a better insight to the statistics and how we should perceive it. States should also provide accurate data to IMA and other relevant bodies so that they could better understand the nature of virus and its new strains. More tests need to be done in semi urban and rural areas where people are hesitant to have RTPCR test done due to fear and panic.
ReplyDeleteCOVID is an once in life time experience for humanity. i am reminded of Tagore's' poem or prayer, " where the mind is without fear ... into that heaven my father let my country awake". it sums up all!!!
DeleteThought-provoking study. I work in Kolkata for a Psychiatric Hospital. We are one among the very few Psychiatric Hospitals in Kolkata that admits covid positive psychiatric patients.
ReplyDeleteDuring past one year, we admitted 79 covid positive patients. 11 In-patients and 26 staff members (Total - 116) persons got treated for covid. 22 persons had received two doses of vaccination. Others were not vaccinated.
All of them recovered from covid with mild symptoms. Our experience proves that covid patients recover well with proper care and medication. Severe suffering and death are avoidable. People die due to lack of facilities, delay in treatment & care and may be also due to wrong treatment.
You said it all. COVID is NOT unsurmountable. You have done a creditable job. congratulations. More power to you.
DeleteThis comment has been removed by the author.
ReplyDeleteSir, a thought provoking article which has been well researched and backed up with lots of data. Probably, as alleged many a times before, it must be under reporting of TPR or reduced testing the reason for increased "case to death" ratio. Test results can be fudged but not the death figures.
ReplyDeleteThank you.
DeleteReport, under report, misreport - for each dead there are many grieving!
there lies the truth.
its but natural to be critical or cynical in such times. many people who should have by their actions seem to have let us drift too. I agree with you there are many who made a fast buck amidst these trying times. But for every such heartless wretch there are many angels who did some divine service. As much as we do that much short we find ourselves. you are right. there is so much to be done.
ReplyDeleteLies, damned lies and statistics!
ReplyDeleteRead with interest the Covid data from India, which stood out from the rest of the world, and the comparative stats between states.
Linearity: TPR-ratio of those found infected against the numbers tested is like a line drawn in the sand. Interestingly, the chart shows case-to-death ratio in Kerala was high before the second lockdown which could suggest that testing was carried out in the early stages of 2021 only in seriously ill patients and later on the testing was increased to a wider group of the population including those with less severer infections affecting the denominator at different time points. Or was the stable door shut after the horse has bolted? In the UK, very early in the pandemic when the number of tests available was only 10,000 per day which later increased to a million a day affecting the denominator. Similarly, if tests are done in a suspected population versus people going to the hospital for other treatments who are not suspected to have the infection is expected to produce a lower TPR and lower case to death ratio as it will pick up asymptomatic patients who form around 30% of cases. Did we have the same testing criteria and facility throughout?
Comparability of data: India being a large country with diverse geography, politics and health infrastructure, the incidence of infection and the rigour and standardisation of data collected in different parts of India would have been so variable that it is non-standardised data for the purpose of statistical comparison.
Case fatality ratio is affected by several variables, the strongest being age. Death being a well-defined endpoint, interesting to note the difference in the case to death ratio over time between Kerala and other states which appears to be consistent and therefore one can speculate that other population risk factors, including health awareness and access to health-care, or inherent differences in the process of data collection may be significant and needs further research.
The lag period of 4-6 weeks between diagnosis of infection, hospital admission and death is another factor that made data comparison difficult. When the lag period is superimposed over the wave of infection which peaked at different times in different parts of India, the peak death rate also may have varied in different states.
The delta virus mutation which originated in India has shown to be more infectious and therefore affected more people leading to a proportionate increase in death rate but not shown to be more deadly. It is usually not in the interest of the virus to kill the host who provided a home!
Health Service Infrastructure: As the pandemic progressed systems and hospitals adapted to deal with the influx of patients and improved the infrastructure to deal with the increasing caseload. So healthcare access would have improved the outcome of a large proportion of patients whose needs were fairly basic like oxygen therapy and steroids, unlike patients who require intensive care beds which would have been too few proportionate to the population. This essential level of care would have been available for most patients who required hospital care in Kerala. It would be interesting to compare the number of hospital beds per 100,000 population in Kerala and other states.
The management of patients beyond the essential emergency care in a non-academic set-up in India to my knowledge was less than evidence-based and patients were often treated with a cocktail of polypharmacy of medications, many of them of unproven effectiveness and not used elsewhere in the world. This may only compound the problem due to the toxicity of the treatment.
In this age of big data and data-driven decision-making, the data collection systems have to be robust to justify decisions that will have a major impact on the life of the population. Even if we have a reasonably reliable database, the stats can be used to support one viewpoint whatever one may want to believe -lies damned lies and statistics! Imagine if we don't have one!