Category Archives: data

Getting through Covid-19

India has 341 confirmed cases of the Corona virus infection (344 as per this) as I write this, we are having a Junta Curfew across India and even had a 5 Baje 5 Min Clapping and Banging Thali session.

In 10 days since I wrote “Covid-19 Outbreak – Do You See The Risk?” the number of cases has increased more than 5 fold.

It took 17 days for cases to reach first 100 confirmed cases, 5 days for the next 100 and under 3 days for the next 100. Digest that for a second.

Was this unanticipated? Not really. Given the rate of spread of virus across the world especially China, Italy, Iran & USA this shouldn’t come as a surprise.

While authorities might not have been that pro-active at taking measures to control the spread and planning to prepare for the pandemic they are still a bit early (if you go by number of confirmed reported cases) to act.

Countrywide Shutdown Status

Source: Hindustan Times. Not sure why Delhi is missing from this though

As you can see in the infographic above states across the country have shut down education institutes, cinema halls/malls, religious gatherings, restaurants, weddings and parks.

While the developments above have been unfolding over the last few days, just today the following major developments were announced

Today’s Announcements

  1. Interstate Passenger Transport Suspended till 31st March (Train and Buses)
  2. All Metro & Mumbai Local Trains to be Suspended till 31st March
  3. 75 Districts (including Delhi) across the country to have a lockdown
Update: J&K is also under a lockdown

These enforcements are unprecedented but absolutely essential to control the spread of virus.

I’m not an expert by any means but IMHO there are the following aspects to the corona pandemic

  1. Data: Sharing detailed information to create awareness and dispel myths.
  2. Prevention: Controlling the spread or ‘Flattening the curve’ as now it’s called.
  3. Treatment: Upgrading and Scaling up Healthcare Infrastructure to ensure the best possible facilities for treatment.
  4. Rebuilding: Trying to mitigate damage to economy and taking measures to rebuild it.
  5. Preparation: Ensure that all learnings from this pandemic are built upon for such calamity in future.

Data: Ministry of Health and Family Welfare launched a section on their portal for Corona Data and some advisories issued by the government.

Snapshot of Corona Data from the MOHFW portal

While the data is good, it’d be great to have more details around the same and most importantly around testing. Singapore for example shares patient level data which enables creating detailed dashboards like this one

This not only helps in analysis but also tracing and creating awareness about spread of virus across demographics/regions. Sharing data around tests being done across cities would clear up a lot of things. Perhaps the criteria for testing could have been relaxed and private sector roped in a bit earlier.

Prevention: I support all the initiatives taken to prevent ‘community spread’. The sooner we take drastic steps, the better. Now that we are officially under lockdown, it should run for at least 6-8 weeks (April end) given that there’s a months gap between lockdown and peak in confirmed cases. In parallel, we must continue to spread awareness on hygiene, social distancing etc, test aggressively and ensure strong quarantine measures for confirmed cases.

Treatment: This is the part where currently there’s as much information out there as should be. While we limited confirmed cases, this is the best time to learn from other countries and scale up our healthcare infrastructure to accommodate a spike in patients. From adding more hospital beds, converting buildings to hospitals, providing protective gear for healthcare professionals, expediting research & development, inducting more people in the medical workforce, arranging medicine, ICU beds and ventilators. A lot needs to be done across states in this departments. This should be done on priority and information shared with publick

This interview by Dr Ramanan Laxminarayan with Karan Thapar is quite informative

Rebuilding: While the impact on lives will be massive, a lot of effort will have to be put on the economic front. The entire machinery has come to a grinding halt. Some industries like Airlines, Hospitality, Entertainment are seeing never before drop in business activity. Those along with the people at the bottom of the pyramid and micro business owners will need a lot more help in getting by till normalcy returns and some support after things normalize (France suspended utility bills, rent for struggling SMBs)

A lot many concrete steps should be announced asap to avoid cascading events of the drop in the economic activity.

In addition to this, a lot of initiatives should be taken to ensure minimal disruption in supply chain for critical good.

Preparation: While we were caught by surprise this time and given that viral outbreaks aren’t going to go anywhere soon, it’d be wise to learn from this experience and prepare for future outbreaks once we are able to contain Covid-19. Setting up dedicated departments/teams supported with funding and other assistance to enable them to gear up for coming years.

At an individual level, you only have one job, Stay the *** home.

Hope over the coming weeks we make progress on above mentioned lines, minimize the damage and get past this disaster.

Delhi Elections: Exit Polls vs Results

The results are out and the winner is ‘Aam Aadmi Party’. A start-up that growth hacked itself to become the second highest seat winner. Here is how 2 exist polls compared to the results



While Today’s Chanakya Exit Polls data were closest to the results, Times Now (except for their spot on BJP Exist Poll data) are way away from the results. Good Job ‘Chanakya’ !!

Now to take a macro view of the Chanakya exit polls and results


Fifteen Quotes on Data

Here are some of my favorite quotes for anyone fascinated by data

  1. “A point of view can be a dangerous luxury when substituted for insight and understanding” – Marshall McLuhan
  2. “Anything that is measured and watched improves.” – Bob Parsons
  3. “Data beats emotions.” – Sean Rad, founder of
  4. “True genius resides in the capacity for evaluation of uncertain, hazardous, and conflicting information.” – Winston Churchill
  5. “Data is a precious thing and will last longer than the systems themselves.” – Tim Berners-Lee
  6. “Facts do not cease to exist because they are ignored.” – Aldous Huxley
  7. “For every two degrees the temperature goes up, check-ins at ice cream shops go up by 2%.” – Andrew Hogue, Foursquare
  8. “If you don not know how to ask the right question, you discover nothing” – W. Edward Deming
  9. “If the statistics are boring, you’ve got the wrong numbers” – Edward Tufte
  10. “In God we trust. All others must bring data.” – W. Edwards Deming
  11. “If you torture the data long enough, it will confess” – Ronald Coase
  12. “Without big data analytics, companies are blind and deaf, wandering out onto the web like deer on a freeway.” – Geoffrey Moore 
  13. “Let the data set change your mindset” – Hans Rosling
  14. “Data is the new Oil” – Clive Humby

    and my favorite

    If we have data, let’s look at data. If all we have are opinions, let’s go with mine. – Jim Barksdale

PS: Top 15 is the new top 10