Vaccination, Population and some of #dodosgyaan

#TLDR

Put something together looking at absolute numbers of population, vaccinations done and how far away the finish line is. 

You can access the findings here. 

Or. Read on. 

----------------------------
The Story

It has been a LONG while since I wrote a blog post. I have been saying I will for a while now, but never got around to it. It's just this whole #Covid scene that is depressing enough as it is, why add my writing to it huh?

This is NOT a blog post about:

#Oxygen
#DeadBodies
#Covid19
#Politics

This IS about:

#Vaccinations
#Statistics
#Data

And about how far away the finish line is. About how there is an end to the tunnel where there is light indeed, but it's really far away and I don't know how many of us realise that. 

I cannot stress more on how you should first get vaccinated before doing anything, especially those of you who are able to and yet being lazy, stupid or not bothered - please go and #JustDoIT. 

Recently, I have been privy to a lot of discussions / statements / arguments even on how effective our vaccination drive in India is. 

Regardless of the fact that we have exported a lot of vaccines, we still need to see how we are faring in both absolute numbers as well percentages. 

I was trying to just get the data that was required and found it pretty hard to find some good data on this. 

There are of course, some good dashboards out there:

The Official CoWin one, or the crowdsourced Covid19India.org one but nothing I could find that had some good population numbers as well. This one from Harvard is pretty interesting. 

So I decided to do some homework and managed to come up with something just for fun!!

Population data: 

• Last census was in 2011.
• There are multiple sites and even statistical formulas that use a projected factor of increase in population to arrive at some number of what the population would be in a particular year. 
• I decided to look closer to home, I used the famous #Aadhar card information. I mean they are assigning cards every day and the Aadhar is the ID Proof that is generally being used at vaccination centres - so why not?
• It also nicely split the population up into <5 years old, <18 Years old and All. So it was easy to get what I wanted which was primarily all eligible people who can be vaccinated. 
• Note: this data is as assumption as of Dec 2020. 

Vaccination data

• This is out there by the dozen. All the sites I mentioned above have it as well. 
• I sourced my date from the official Ministry of Health and Family Welfare site. 
• Note this is as of 25th May, 2021. 

What did I do?

• Dumped data into a google sheet. 
• Did some basic analysis. 
• Fell off my chair, seeing the numbers. 
• Put it into a graphical format with some bells and whistles 
• Learnt how to use Data Studio from Google (needed to look at this for work as well - so 2 mangoes, one stone types :))

SO, if you want to see it - click here and you can see many many details broken down state-wise. Like an interactive thingy... ;)

or...

Here are some statistics to make you think. 

So, the next time you see a slot open up for say a 1000 doses in a pin code - do the math!

Upwards and Onwards.