COVID-19

Charting the Carnage of Covid-19 (data via NYTimes)

Michael Data & Graphics, Interactive, Photo July 17, 2020

Total reported cases and deaths in the U.S. (and by states/counties)

As New York Governor Andrew Cuomo likes to say, we have climbed a monstrous mountain. Even though we are on the other side of it, and for quite a few weeks, there’s still no place for complacency and chance-taking.

Here below is just a chart where you could filter any states and/or counties of your interest and see how the pandemic has been wreaking the havoc. A big shout out to the New York Times COVID-19 data team, who have offered all the data for free here.

Bear Markets: S&P 500 in Historical Perspective

Michael Data & Graphics, Photo, Photo editing May 4, 2020

It’s quite a sight to witness the stock market dropping by 35% in 33 days (S&P 500) thanks to the COVID-19 pandemic, beating the 1929 record in velocity with a drop of 45% in 58 days. See slide 6 and 12:

Notes:

  • The red bars indicate the S&P 500 peak and trough prices during the bear markets, background reading by James A. Kostohryz on seekingalpha.com
  • Top image from morningstar.com by Paul D. Kaplan [The chart shows that over this period of almost 150 years, $1 (in 1870 U.S. dollars) invested in a hypothetical U.S. stock market index in 1871 would have grown to $15,303 by the end of March 2020.]
  • Slide 12 might be a work in progress…

COVID-19 First Wave Flashback in New York

Michael Data & Graphics, Interactive March 14, 2020

The “mountain” New Yorkers climbed over for the first wave (Data updated until Sept. 18, 2020)

Data sources:

Notes/disclaimers:

  • NYC data cycles from 5/6pm to 5/6pm the following day, so the two sets of data between NYS and NYC might be slightly out of sync.
  • NYC’s newly reported “probably deaths” are not included in the graphs here.
  • There are some data gaps in the Hubei-Wuhan datasets.
  • On April 17, China revised Wuhan’s toll from COVID-19 up by 50%; so take the data with a grain of salt!
Read More