Several faculty and I are collaborating on analysis of this data and related collegiate COVID-19 data, you can view the analysis COVID-19 trends at in our Data-Forward Collegiate COVID-19 Analysis website.
This visualization was built on the 91-DIVOC platform that I developed to create data-forward interactive visualizations to help myself and others understand the spread of COVID-19 across the world, across the United States, and each state’s contribution to the spread of COVID-19. Instead of using data from Johns Hopkins (as I do on 91-DIVOC), this visualization sources data from the publicly available dashboards from Big Ten conference universities:
Each day, I am updating the data for this visualization between 6:00pm and 8:00am (central time zone) to publish a new version of this page each day with the latest data. The latest raw data is also always provided on my github.
This visualization currently shows the total number of cases among all members of each campus – students, faculty, and staff. Some dashboards split this data into various segments (ex: students and faculty/staff individually) and, in those cases, the data from all groups are added together. Indiana University only reports the number of tests processed by their hospital system, which certainly includes far more than just the campus, and is not included in this visualization.
The collection of data for this visualization started on Wednesday, Aug. 26. Some schools (ex: Ohio State) only appear in the raw data and will appear in the visualization when at least two data points become available.
Due to the technology and "data privacy" settings used by many of the dashboards, there is no easy/reliable/robust automation of downloading of raw data files. Therefore, all data was recorded by hand. I double check each data point, as well as verify the previous week of entries each time the data is updated (both for correctness and to update any cases that may have been added), but please notify me if you spot any errors. As noted earlier, the data is updated once daily and collected between 12:00am-8:00am (central time).
If you have any ideas for this data visualization or know of other sources of data, feel free to reach out to me at firstname.lastname@example.org! :)
Other colleagues and faculty at the University of Illinois are also exploring COVID-19 data at University. Here is a short list of links to some of their work: