COVID-19 update in Virginia, US
(Updated: 2020-07-20 12:07:15 EST)
This is for my friends in Virginia, replicating some of the dataviz in COVID-19 in Maryland, US: Daily Updates and Insights with Granular Local Data. The MD version has more data, sorry! :)
The first confirmed COVID-19 case was reported in Fairfax county on 2020-03-07.
As of 2020-07-19, 77430 confirmed cases have been reported in 133 counties. This means there are 907 people with confirmed COVID-19 per 100,000 population in the state. Below figure shows number of confirmed cases by county. There are 133 counties in Virginia (compared to only 24 in Maryland!), the figure shows only top 40 counties in terms of the confirmed cases.
Hover over each figure to see values and more options.
(Source: New York Times’ Coronavirus in the U.S.: Latest Map and Case Count)Below shows infection rates (i.e., number of confirmed cases per 100,000 population) by county. Again, only top 40 counties in terms of the cumulative incidence rates. Incidence is 1154 per 100,000 population in Arlington and 1297 in Fairfax.
Hover over each figure to see values and more options.
(Source: New York Times’ Coronavirus in the U.S.: Latest Map and Case Count, US Census Bureau’s County Population Totals: 2010-2019)Since testing capacity has been low, we cannot confidently answer this question. Nevertheless, we can see the number of NEW confirmed cases each day. The first figure is for the entire state. We want to see the number of new infections to be stable more or less, without sudden and large increases.
Hover over each figure to see values and more options.
(Source: New York Times’ Coronavirus in the U.S.: Latest Map and Case Count) Note: May 6th data are likely a data error of duplication from May 5th data.Now, among 41 counties with 300 or more confirmed cases, below shows the trends of daily number of NEW confirmed cases for each of the county, with 7-day rolling averages in black lines.
Hover over each figure to see values and more options.
(Source: New York Times’ Coronavirus in the U.S.: Latest Map and Case Count)
Below figure shows mortality by county - in terms of both absolute number (blue bars) and rate (orange bars) as of 2020-07-19. Top 40 counties are presented.
(Source: New York Times’ Coronavirus in the U.S.: Latest Map and Case Count, US Census Bureau’s County Population Totals: 2010-2019)Below chart shows the mortality trends for the state, since the first reported death.
(Source: New York Times’ Coronavirus in the U.S.: Latest Map and Case Count)Data sources:
1. All data on COVID cases and deaths come from New York Times’ Coronavirus in the U.S.: Latest Map and Case Count. Accessed on 2020-07-20.
2. All data on population come from US Census Bureau’s County Population Totals: 2010-2019. Accessed on March 29, 2020.
See GitHub for data, code, and more information. For typos, errors, and questions, contact me at www.isquared.global.
Making Data Delicious, One Byte at a Time, in good times and bad times.