This topic describes the details of the COVID-19 Pandemic Analysis application, including the overview, assets, limits, data description, and usage notes.

Overview

Note The COVID-19 Pandemic Analysis application is being upgraded. You cannot create related resources.
  • The first time you use the application, you must initialize it. The initialization process takes approximately two minutes.
  • Data is automatically updated every day.
  • Data sources: Novel Coronavirus (COVID-19) Cases, provided by JHU CSSE.
  • Update frequency: Once a day around 23:59 (UTC).
  • Data is collected from multiple sources that update at different times and may not always align.
  • You are not charged for data storage or data analysis.
  • If you do not use the free resources of the application for a long time, the resources may be reclaimed. To continue using the free resources, you must re-initialize the application.

Assets

The following free resources are provided in the application:
  • Project: ncp-{Alibaba Cloud account UID}-cn-chengdu
  • Logstore: ncp
  • Dashboards: covid-19_global and covid-19_detail.

Limits

  • You cannot modify or delete the ncp Logstore, the indexes created for the Logstore, or the data written to the Logstore. Other than these limits, you can perform the same operations on the Logstore as on normal Logstores.
  • You can create Logstores in the dedicated project that is automatically created in the application and write data to the Logstores. You are charged when you use the Logstores.
  • Modifications to the dedicated dashboards are overwritten during updates. We recommend that you do not modify the dashboards. You can copy the dedicated dashboards to another project and modify the copies. For more information, see How do I copy an existing dashboard to create a dashboard?

Dashboards

The COVID-19 Pandemic Analysis application provides multiple built-in dashboards. The dashboards are created based on the log data in the ncp Logstore. You can also create custom dashboards.

Dashboard ID Description
COVID-19 Global covid-19_global Displays various metrics, trend charts, and the COVID-19 pandemic situation of each country and region around the world.
COVID-19 Detail covid-19_detail Displays various metrics, trend charts, and the COVID-19 pandemic situation of each province or state in all countries and regions around the world.

Data description

  • Data updates and usage notes

    COVID-19 pandemic datasets are stored in the ncp Logstore. Data updates are automatically synchronized to the Logstore every day. Each update is represented by a value in the Version field, for example, v2020-01-26T12:30:00.

    Every update contains full data. You can query and analyze the most recent update to obtain the data that you want.

    You can specify a value for the Version field to query and analyze the data in the specified update, as shown in the following query statement.
    Version: "v2020-01-26T12:30:00" and Type : "Province/State Cases" | select .... from log
    We recommend that you execute the following query statement to query and analyze data. This ensures that you can query the most recent update.
    Type : "Province/State Cases" | select .... from log l right join (select max(Version) as Version from log) r on  l.Version =  r.Version
    Note
    • The code that precedes | is a search statement. In most cases, you can specify a value for the Type field to filter specific types of log data. For more information about the search syntax, see Search syntax.
    • The code that follows | is an analytic statement that uses the SQL-92 syntax. The from log clause is used to query log data from the current Logstore. You can specify a JOIN clause to query data from multiple Logstores. In addition, you can specify a JOIN clause to query data from external data sources, such as IP geolocation databases and the external tables of Object Storage Service (OSS) or ApsaraDB RDS for MySQL. For more information, see SQL syntax and functions.
    • Data is automatically updated every day. You can set the time range to 1 Day(Relative) for your queries.
  • Overview

    COVID-19 pandemic datasets are stored in the ncp Logstore and can be identified based on value of the Type field. The valid values of the Type field include Global Cases, Country/Region Cases, and Province/State Cases.

  • Global Cases
    Note Hist data is displayed in mini-charts in the table. Trend data is displayed in trend charts.
    Field Description Example
    Type Type Valid value: Global Cases.
    Version The version of the data update. v2020-01-26T12:30:00
    Last Update The time when the most recent update was released. 2020-01-26 18:23
    Confirmed The most recent total number of confirmed cases. 1058
    Confirmed Hist The total number of confirmed COVID-19 cases since January 23, 2020. The value of this field is an array. [270, 444, 444, 549, 729, 1058]
    Confirmed Trend The total number of confirmed COVID-19 cases since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 3}
    Recovered The most recent total number of recoveries. 42
    Recovered Hist The total number of COVID-19 recoveries since January 23, 2020. The value of this field is an array. [0, 28, 28, 31, 32, 42]
    Recovered Trend The total number of COVID-19 recoveries since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 3}
    Deaths The most recent total number of deaths. 52
    Deaths Hist The total number of COVID-19 deaths since January 23, 2020. The value of this field is an array. [3, 17, 17, 24, 39, 52]
    Deaths Trend The total number of COVID-19 deaths since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 3}
    New Confirmed Hist The total number of suspected COVID-19 cases since January 23, 2020. The value of this field is an array. [11, 0, 41, 0, 56, 127]
    New Confirmed Trend The total number of suspected COVID-19 cases since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 7}
  • Country/Region Cases
    Note Hist data is displayed in mini-charts in the table. Trend data is displayed in trend charts.
    Field Description Example
    Type Type Valid value: Country/Region Cases.
    Version The version of the data update. v2020-01-26T12:30:00
    Last Update The time when the most recent update was released. 2020-01-26 18:23
    Country/Region The name of the country or region. China, US
    LatLng The longitude and latitude of the country or region. The value is a string in the <latitude>,<longitude> format. 51.7283857,-2.2085499
    Confirmed The most recent total number of confirmed cases. 1058
    Confirmed Hist The total number of confirmed COVID-19 cases since January 23, 2020. The value of this field is an array. [270, 444, 444, 549, 729, 1058]
    Confirmed Trend The total number of confirmed COVID-19 cases since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 3}
    Recovered The most recent total number of recoveries. 42
    Recovered Hist The total number of COVID-19 recoveries since January 23, 2020. The value of this field is an array. [0, 28, 28, 31, 32, 42]
    Recovered Trend The total number of COVID-19 recoveries since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 3}
    Deaths The most recent total number of deaths. 52
    Deaths Hist The total number of COVID-19 deaths since January 23, 2020. The value of this field is an array. [3, 17, 17, 24, 39, 52]
    Deaths Trend The total number of COVID-19 deaths since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 3}
    New Confirmed Hist The total number of suspected COVID-19 cases since January 23, 2020. The value of this field is an array. [11, 0, 41, 0, 56, 127]
    New Confirmed Trend The total number of suspected COVID-19 cases since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 7}
  • Province/State Cases
    Note
    • If the source data does not specify the province or state information, the value of the Province/State field is Unspecified *.
    • Hist data is displayed in mini-charts in the table. Trend data is displayed in trend charts.
    Field Description Example
    Type Type Valid value: Province/State Cases.
    Version The version of the data update. v2020-01-26T12:30:00
    Last Update The time when the most recent update was released. 2020-01-26 18:23
    Country/Region The name of the country or region. China, US
    Province/State The name of the province or state. Shanghai, New York
    LatLng The longitude and latitude of the country or region. The value is a string in the <latitude>,<longitude> format. 51.7283857,-2.2085499
    Confirmed The most recent total number of confirmed cases. 1058
    Confirmed Hist The total number of confirmed COVID-19 cases since January 23, 2020. The value of this field is an array. [270, 444, 444, 549, 729, 1058]
    Confirmed Trend The total number of confirmed COVID-19 cases since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 3}
    Recovered The most recent total number of recoveries. 42
    Recovered Hist The total number of COVID-19 recoveries since January 23, 2020. The value of this field is an array. [0, 28, 28, 31, 32, 42]
    Recovered Trend The total number of COVID-19 recoveries since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 3}
    Deaths The most recent total number of deaths. 52
    Deaths Hist The total number of COVID-19 deaths since January 23, 2020. The value of this field is an array. [3, 17, 17, 24, 39, 52]
    Deaths Trend The total number of COVID-19 deaths since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 3}
    New Confirmed Hist The total number of suspected COVID-19 cases since January 23, 2020. The value of this field is an array. [11, 0, 41, 0, 56, 127]
    New Confirmed Trend The total number of suspected COVID-19 cases since January 23, 2020. The value of this field is a dictionary. {"2020-01-21": 1, "2020-01-22": 1, "2020-01-23": 1, "2020-01-24": 2, "2020-01-25": 2, "2020-01-26": 7}

Usage notes

  1. Log on to the Log Service console.
  2. On the Social Welfare tab of the Log Application section, click COVID-19 Epidemic Analysis.
  3. Use the COVID-19 Epidemic Analysis application as prompted.

FAQ

  • How do I delete the dedicated project of COVID-19 Pandemic Analysis?
    If you want to delete the ncp-{Alibab Cloud account UID}-cn-chengdu project, run the following command in Cloud Shell:
    aliyunlog log delete_project --project_name=ncp-$ALICLOUD_ACCOUNT_ID-cn-chengdu --region-endpoint=cn-chengdu.log.aliyuncs.com
    Notice If you delete the dedicated project, the Logstores that you created in the project are also deleted.
  • How do I copy an existing dashboard to create a dashboard?
    1. In the upper-right corner of the Alibaba Cloud console, click the Cloud Shell icon.
    2. Copy the following configurations of the dashboard to the local host:
      aliyunlog log get_dashboard --project=ncp-$ALICLOUD_ACCOUNT_ID-cn-chengdu --entity=covid-19_global --region-endpoint=cn-chengdu.log.aliyuncs.com > covid-19_global.json
      aliyunlog log get_dashboard --project=ncp-$ALICLOUD_ACCOUNT_ID-cn-chengdu --entity=covid-19_detail --region-endpoint=cn-chengdu.log.aliyuncs.com > covid-19_detail.json
      sed -i "s/\"dashboardName\": \"/\"dashboardName\": \"v2/g" covid-19_global.json
      sed -i "s/\"description\": \"\", \"displayName\": \"/\"description\": \"\", \"displayName\": \"v2/g" covid-19_global.json
      sed -i "s/\"dashboardName\": \"/\"dashboardName\": \"v2/g" covid-19_detail.json
      sed -i "s/\"description\": \"\", \"displayName\": \"/\"description\": \"\", \"displayName\": \"v2/g" covid-19_detail.json
      aliyunlog log create_dashboard --project=ncp-$ALICLOUD_ACCOUNT_ID-cn-chengdu --detail=file://./covid-19_global.json --region-endpoint=cn-chengdu.log.aliyuncs.com
      aliyunlog log create_dashboard --project=ncp-$ALICLOUD_ACCOUNT_ID-cn-chengdu --detail=file://./covid-19_detail.json --region-endpoint=cn-chengdu.log.aliyuncs.com
    3. View the created dashboard.

      In the left-side navigation pane of the COVID-19 Pandemic Analysis page, click Setup. On the page that appears, click Go to Overview Page. In left-side navigation pane of the page that appears, click Dashboard to view the created dashboard.

References