Page History

...

For each state, we extracted various demographics including the ISO 2 character label, population, area, population density, education, income, median age, political leaning. The demographics were obtained from the following sources for the US.

Demographic	Origin	Extracted file
Population, Area	https://en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States_by_population_density	us-states.csv
ISO2	https://en.wikipedia.org/wiki/ISO_3166-2:US	us-states.csv
Education	https://en.wikipedia.org/wiki/List_of_U.S._states_and_territories_by_educational_attainment	us-education.csv
Income	https://en.wikipedia.org/wiki/List_of_U.S._states_and_territories_by_income	us-income.csv
Median age	https://en.wikipedia.org/wiki/List_of_U.S._states_and_territories_by_median_age	us-age.csv
Political leaning	https://www.270towin.com/	us-politics.csv
Area	https://en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States_by_population_density	us-states.csv
Race/Ethnicity	#https://www.governing.com/gov-data/census/state-minority-population-data-estimates.html	us-race.csv

A Perl script covid-us.pl was developed to gather the above information and cast it in a suitable form for the www.charte.ca motion charts and correlation data. See:

...

We investigated the correlations between the demographics and the confirmed Covid-19 cases for California. We used the R squared coefficient of determination to characterize the degree of correlation between the various demographics using a linear fit.

...

Demographic	Income	Education	Cases	Politics	Age	Population density	Population
Per capita income	*	0.81	0.0032	.28	0.008	0.12	0.19
% of people completing college education for CA	0.81	*	0.016	0.43	0.009	0.20	0.043
Covid-19 confirmed cases	0.0032	0.016	*	0.34	0.012	0.14	0.77
% of Registered voters who are registered as Democratic	0.28	0.43	0.034	*	0.089	0.15	0.081
Median age	0.008	0.008	0.012	0.0089	*	0.0029	0.084
Population density (people/sq mile)	0.12	0.20	0.14	0.25	0.0029	*


Population	0.19	0.043	0.77	0.081	0.084

*

It is seen that there is a strong correlation between the per capita income and education and between confirmed cases and population, a medium correlation between registered voter political leaning and education. The excel spreadsheet of the analysis of the above demographics and their correlations can be found here.

...

We tend to use a log log chart which provides greater visibility of a wide range of data (compare the two charts below), and since both the confirmed data and deaths are exponential in their behavior for most states. Also note that with a logarithmic scale: a straight line means exponential growth, and the steeper a line, the faster the total number of confirmed coronavirus cases or deaths is doubling.
Linear plot
Log Log plot
Image Modified
Image Modified

.
The first confirmed cases were seen by WA 1/22/20, IL a day later and AZ & CA on 1/25/20
.
First deaths reported for Washington State were at the start of March
.
Deaths start to really increase in the second week in March
.
By the start of April, NY followed by NJ were leading the way in both deaths and confirmed cases
.
By the end of the second week in April, SD and UT are noticeably below the general line followed by other states
.
On 3/30/20 WV was the last state to record a Covid-19 death
At the end of the second week in April, WY appears to be the last state to have greater than one Corona-19 death.
.

Deaths/Million Population vs Confirmed cases/Million Population

The leading states in terms of deaths per million population are: NY, NJ, CT, MA, LA, MI, DE,DC, RI.
The leading states in terms of confirmed per million of population are: NY, NJ, MA, DE, CT,RI, LA, DC, MI

If one does not normalize by population the NY and NJ standout followed by the top of the bunch being MA and MI
.
Looking at a log vs log plot the trailing states one sees the lowest deaths are for AK SD, HI, MT, WY, ND. The lowest Confirmed cases are for AK, SD, SD,HI, MT, WY, ND.
Note that since it is a log-log scale no bubble appears for a state until there is at least 1 confirmed case and 1 death for the state.
% Confirmed and deaths both low for AK, VT, NH, ID
Cluster of DE, DC and RI with low deaths compared to the % confirmed cases
NY, NJ, MA, DE, CT, LA, RI, DC have the highest % confirmed cases.
By March 14th, WA, NY, CA, FL were reporting deaths.

...

If we color the bubbles by each state's political leaning the chart appears below. It is apparent that Covid-19 is impacting democratic states the hardest, followed by the swing states.