Global COVID-19 Dashboard: A New Feature for Pandemic Analysis

Image for post
Image for post

Bolster the growth and digital transformation of your business amid the outbreak through the Anti COVID-19 SME Enablement Program. Get a $300 coupon package for all new SME customers or a $500 coupon for paying customers.

By Lingsheng from Alibaba Cloud Storage

Introduction

If you want to learn more about the COVID-19 pandemic analysis application, please visit the following article: Alibaba Cloud documentation of the COVID-19 pandemic analysis application

With the outbreak of COVID-19 around the world, SLS recently released a new feature that tracks and analyzes the pandemic outbreak situation around the globe through a dashboard. Compared with the dashboard that displays the pandemic statistics in mainland China with data sources from CCTV News, People’s Daily, and the announcements of the provincial and municipal health committees of China, the global pandemic analysis dashboard tracks and focuses on the outbreak situation around the world. The data used by the global dashboard comes from the open-source data sets provided by the Center for Systems Science and Engineering (CSSE) of Johns Hopkins University, which is widely referenced all over the world.

Log Service (SLS)

Image for post
Image for post

As the log analysis mid-end, SLS provides an all-in-one service that supports data collection, processing, query, analysis, artificial intelligence (AI)-based computing, and visualization. It can also be integrated with other services.

Image for post
Image for post

Highlights

1) Standardized Data and Regular Updates on a Daily Basis

2) Predefined Rich Chart Types with the Support for Customization

Overview of the Global Pandemic Trend

Image for post
Image for post
Image for post
Image for post

Pandemic Details of Each Country or Region

Image for post
Image for post
Image for post
Image for post

3. Support for Connections to Various Data Sources

Image for post
Image for post

4. Free of Charge

Data

Import and Standardization

Sample Data

type:  Country/Region Cases
version: v2020-04-17T11:55:36
Last Update: 2020-04-09 01:12:20
Country/Region: China
Country/Region (ch): 中国
LatLng: 35.000074,104.999927
Confirmed: 83798
Confirmed Hist: [644, 923, 1409, 2079, 2882]
Confirmed Trend: {"2020-01-23": 644, "2020-01-24": 923, "2020-01-25": 1409, "2020-01-26": 2079, "2020-01-27": 2882}
New Confirmed Hist: [95, 279, 486, 670, 803]
New Confirmed Trend: {"2020-01-23": 95, "2020-01-24": 279, "2020-01-25": 486, "2020-01-26": 670, "2020-01-27": 803}
Deaths: 3352
Deaths Hist: [18, 26, 42, 56, 82]
Deaths Trend: {"2020-01-23": 18, "2020-01-24": 26, "2020-01-25": 42, "2020-01-26": 56, "2020-01-27": 82}
Recovered: 78556
Recovered Hist: [30, 36, 39, 49, 58]
Recovered Trend: {"2020-01-23": 30, "2020-01-24": 36, "2020-01-25": 39, "2020-01-26": 49, "2020-01-27": 58}

Data Format

The following table lists the data fields.

Image for post
Image for post

Analysis and Display

  • Real-time: Logs can be analyzed once they are written.
  • Fast: Up to one billion log entries can be queried (with five query conditions) within one second. Hundreds of millions of log entries can be aggregated and analyzed (with five aggregation methods + GroupBy statements) within one second.
  • Flexible: Search and analysis conditions can be changed as required, and the results are returned in real time.
  • All-in-one: Reports and dashboards are available in the console for quick analysis. In addition to these features, SLS can work together with Grafana, DataV, Jaeger, and other services. It also supports RESTful APIs, Java Database Connectivity (JDBC) APIs, and other APIs.

As mentioned above, SLS uses the version field to mark the version of the COVID-19 pandemic data. To query the data of the latest version, you can run the following SQL statement:

type : "Province/State Cases" | select .... from log l right join (select max(version) as version from log) r on  l.version =  r.version

In the predefined charts, each chart corresponds to a SQL query result. Take the chart named Global Cases Trend, which displays global COVID-19 cases, as an example. You can run the following SQL statement to query the globally confirmed cases, deaths, recoveries, and the trend of existing cases, and save the result as a chart in the dashboard, which is convenient and quick.

type : "Global Cases" | select date_format(date_parse(l.a, '%Y-%m-%d'), '%b %e') as "Date", l.b as "Confirmed", l.b - r2.b - r6.b as "Active Confirmed", r2.b as "Deaths", r6.b as "Recovered"  from  (select  a,b    from log l right join (select max(version) as version from log) r on  l.version =  r.version, unnest( cast( json_parse("Confirmed Trend")   as map(varchar, bigint) ) ) as  t(a,b)) l left join (select  a,b    from log l right join (select max(version) as version from log) r on  l.version =  r.version, unnest( cast( json_parse("New Confirmed Trend")   as map(varchar, bigint) ) ) as  t(a,b)) r on l.a = r.a left join (select  a, b    from log l right join (select max(version) as version from log) r on  l.version =  r.version, unnest( cast( json_parse("Deaths Trend")   as map(varchar, bigint) ) ) as  t(a, b)) r2 on l.a = r2.a left join (select  a, b    from log l right join (select max(version) as version from log) r on  l.version =  r.version, unnest( cast( json_parse("Recovered Trend")   as map(varchar, bigint) ) ) as  t(a, b)) r6 on l.a = r6.a  order by l.a

Procedure

Image for post
Image for post

Click the application and configure it. You only need to configure the application once, and data will be automatically synchronized after the configuration. After you complete the configuration, the multiple types of charts provided by SLS as well as the features of interactive analysis and visualization become available for you.

While continuing to wage war against the worldwide outbreak, Alibaba Cloud will play its part and will do all it can to help others in their battles with the coronavirus. Learn how we can support your business continuity at https://www.alibabacloud.com/campaign/fight-coronavirus-covid-19

Original Source:

Follow me to keep abreast with the latest technology news, industry insights, and developer trends.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store