All Products
Search
Document Center

Simple Log Service:Application operation and management

Last Updated:Aug 11, 2023

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
    Important

    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