This topic describes the details of the COVID-19 Pandemic Analysis application, including the overview, assets, limits, data description, and usage notes.
Overview
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
NoteThe 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
NoteHist 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
NoteHist 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
NoteIf 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
- Log on to the Log Service console.
On the Social Welfare tab of the Log Application section, click COVID-19 Epidemic Analysis.
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
ImportantIf 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?
In the upper-right corner of the Alibaba Cloud console, click the Cloud Shell icon.
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
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.