We're trying something a bit experimental for visualizing the progression of the coronavirus pandemic within the United States, where we've combined Johns Hopkins' available time series data for the viral infection, which begins on 10 March 2020 for individual U.S. states, with the "tower" format the South China Morning Post developed to illustrate the relative speed of spread and scope of COVID-19 cases, recoveries, and deaths occurring within Hong Kong since its first case was detected.
Unlike the SCMP's presentation, we've indexed the relative size of the tower elements to correspond to the percentage of each state's population, which should make it very easy to visually compare the relative severity of coronavirus infections between individual states, since all charts can share the same scale.
We're taking this "skyline" chart concept for a test drive for the six U.S. states or territories reporting the highest percentage of cases among their populations, showing all the daily data for each through 18 March 2020. The following charts cover Colorado, Louisiana, Massachusetts, New Jersey, New York, Washington, and the District of Columbia.
   |
   |
We recognize that at this point in time, the data isn't communicating the rate of spread of the coronavirus so much as it is indicating the rate at which testing is being expanded and capturing already existing cases within the population, which you can certainly see with New York's data. Meanwhile, the number of confirmed cases doesn't always grow each day, where the cumulative total may be adjusted if cases are reclassified, perhaps because of errors, as appears to have happened with Washington's data between 17 March 2020 and 18 March 2020.
Since the U.S. is still in the early phase of tracking coronavirus cases, there aren't yet many reports of recovered patients among the confirmed cases. As these numbers grow, they will 'fill out' each state's tower from the center outward. Deaths will be treated similarly, which are only large enough as a percent of the state's population to be visible in Washington's tower chart at this time.
As the number of confirmed cases grows, we will periodically adjust the scaling of the charts to accommodate the data in future posts on the topic.
Data Sources
2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE.CSSE COVID-19 Time Series Data: Confirmed. [CSV File].
2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE. CSSE COVID-19 Time Series Data: Recovered. [CSV File].
2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE. CSSE COVID-19 Time Series Data: Deaths. [CSV File].
Labels: coronavirus, data visualization, health
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
CSS Validation
RSS Site Feed
JavaScript
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.
Other Cool Resources
Blog Roll
