The Center for Systems Science and Engineering (CSSE) at Johns Hopkins University provides the famous Corona Dashboard and Map (ESRI ArcGIS Online App) and an ArcGIS Feature Service with the recent data (and a GIT Repo with the raw data). The ArcGIS Feature Server support of QGIS makes it easy to have „some fun“ with QGIS and the provided datasets.
Add the data to QGIS
Recent releases of QGIS allow adding data from ArcGIS Feature Servers. CSSE provides the data used for the worldwide dashboard as a Feature Service.
To add the layers to QGIS just open the data source manager and add a new ArcGIS Feature Server connection with the provided service URL provided by CSSE.
The service URL: https://services1.arcgis.com/0MSEUqKaxRlEPj5g/ArcGIS/rest/services/ncov_cases/FeatureServer
After connecting to the service, the 3 layers are provided.
Some simple first steps…
Scaled circles based on the number of confirmed cases
Change the symbology to „graduated“ (method: size) and choose the options (classes, mode,…) based on your needs
Change the color of datapoints with cases of death
QGIS expressions allow some nice and simple styling options – in this case the scaled circles should be red in countries where people already died. This could be done by a rule-based symbology or „quick & dirty(?)“ with an expression on the used color:
Defining the color by an expression
if(("Deaths" = 0),'#ec8927','#ff0000')
Label the percentage of cases of death
Expressions can also be used within the labeling options – in my case I just wanted the number of confirmed cases and the percentage of cases of death labeled inside the circles (datapoints).
Label the attribute „confirmed“, concatenate (||) a line-break (\n), in the next line start labeling with a ‚[‚ and add the calculated percentage ((„Deaths“ / „Confirmed“) * 100 )) with just one decimal place (round(…),1) and finish with the label with a ‚]‘
Global case numbers are reported by the World Health Organization (WHO) in their coronavirus disease 2019 (COVID-19) situation reportexternal icon. For U.S. information, visit CDC’s COVID-19 in the U.S.
Locations with Confirmed COVID-19 Cases, by WHO Region
This page will be updated regularly at noon Mondays through Fridays. Numbers close out at 4 p.m. the day before reporting.
CDC is responding to an outbreak of respiratory illness caused by a novel (new) coronavirus. The outbreak first started in Wuhan, China, but cases have been identified in a growing number of other locations internationally, including the United States.
COVID-19: U.S. at a Glance*
Total cases: 423
Total deaths: 19
States reporting cases: 35 (includes District of Columbia)
* Data include both confirmed and presumptive positive cases of COVID-19 reported to CDC or tested at CDC since January 21, 2020, with the exception of testing results for persons repatriated to the United States from Wuhan, China and Japan. State and local public health departments are now testing and publicly reporting their cases. In the event of a discrepancy between CDC cases and cases reported by state and local public health officials, data reported by states should be considered the most up to date.
COVID-19: Cases in the United States Reported to CDC*†‡
COVID-19: Cases in the United States Reported to CDC*†
Travel-related72
Person-to-person spread29
Under Investigation322
Total cases423
* Data include both confirmed and presumptive positive cases of COVID-19 reported to CDC or tested at CDC since January 21, 2020, with the exception of testing results for persons repatriated to the United States from Wuhan, China and Japan. State and local public health departments are now testing and publicly reporting their cases. In the event of a discrepancy between CDC cases and cases reported by state and local public health officials, data reported by states should be considered the most up to date.
† CDC is no longer reporting the number of persons under investigation (PUIs) that have been tested, as well as PUIs that have tested negative. Now that states are testing and reporting their own results, CDC’s numbers are not representative of all testing being done nationwide.
‡ As of March 8, 2020 1,707 patients had been tested at CDC. This does not include testing being done at state and local public health laboratories, which began this week.
