...
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 here for an example. The script also ranks the age, income, and education demographics for each state or county into low, medium, or high based on their tertiles. This is so these demographics can be used with charte.ca's grouping feature.
Results
US
Motion chart of deaths vs Covid-19 deaths vs Confirmed cases with bubbles sized by population for US states and colored by political leaning
...
CA
Notes
Demographic correlations for CA
...
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. Otherwise here is little correlation between other metrics. The excel spreadsheet of the analysis of the above demographics can be found here.
...