...
This is an attempt to use motion charts to visualize the daily growth, since January 2020, in US Covid-19 cases (confirmed and deaths) by State and by California county showing the state population by bubble size and color by median age, education or income.
The vizualization tool is https://www.charte.ca/, a Motion graphics chart tool. In particular we use it to visualize the growth in time of Covid-19 cases, using the bubble size for population or population density and colors for education, age, political leaning, income etc.
In particular, try out the motion charts in the Results section. There is a slider at the bottom of each chart to move backward and forward in time, and one can move the mouse over a bubble to find more details.
Method
The Covid-19 statistics are from the Johns Hopkins University (JHU). There are raw data for confirmed cases and deaths by date for each county in each US state. For the US state analysis, the data from the counties are aggregated into the values for each state.
For each state or California (CA) county, we extracted various demographics including the ISO 2 character label for the US or the Abbreviation for CA, population, area, population density, education, income, median age, political leaning. The demographics were obtained from the following sources for the US.
For CA they were obtained from here:
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 of the output of covid-us.pl. 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.
...