Introduction
Method
The CiovidCovid-19 statistics are from Johns Hopkins University (JHU) . There are raw data for confirmed cases and deaths by date for each county in each state. The data from the counties are aggregated into the values for the state.
For each state, we extracted various demographics including Internet Top Level Domain (TLD)the ISO 2 character label, population, area, population density, education, income, median age, political leaning.
| Demographic | Origin | Extracted file |
|---|---|---|
| Population, Area, TLD | usstates.csv | |
| ISO2 | https://en.wikipedia.org/wiki/ISO_3166-2:US | usstates.csv |
| Education | https://en.wikipedia.org/wiki/List_of_U.S._states_and_territories_by_educational_attainmen | 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 |
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.
...
- 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.
- Wide dispersion (not all states on line as seen in the log-log plot)
- % 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.
...
Look at the California counties data from JHU using the same analysis and visualization.Maybe look at red states vs blue states (e.g. see https://en.wikipedia.org/wiki/Red_states_and_blue_states)..