In[]:=
ds=ResourceData["Epidemic Data for Novel Coronavirus 2019-nCoV from Wuhan, China"];
CloudConnect
:Connecting to a cloud running an earlier version of the Wolfram Engine: 12.0
In[]:=
ts=ds[Select[#Country["Name"]==="China"&],<|"region"First@StringSplit[#AdministrativeDivision["Name"],", "],"cases"#ConfirmedCases["LastValue"]|>&];
In[]:=
cases=ts[ReverseSortBy[#cases&]]
Out[]=
region
cases
Hubei
27100
Guangdong
1131
Zhejiang
1075
Henan
1033
Hunan
838
Anhui
779
Jiangxi
740
Jiangsu
468
Chongqing
450
Shandong
444
Sichuan
386
Beijing
326
Heilongjiang
307
Shanghai
293
Fujian
250
Shaanxi
208
Hebei
206
Guangxi
195
Yunnan
141
Hainan
131
rows 1–20 of 31
In[]:=
Export["D:\\git\\wolfram-coronavirus\\docs\\cases.csv",cases,"TextDelimiters"""]
Out[]=
D:\git\wolfram-coronavirus\docs\cases.csv
In[]:=
ds
In[]:=
ts=ds[Select[(#Country["Name"]=!="China"&&Not[MissingQ[#Country]])&],<|"country"First@StringSplit[#Country["Name"],", "],"cases"#ConfirmedCases["LastValue"]|>&];
In[]:=
ts2=ts[GroupBy[#country&],<|"country"First[#]["country"],"cases"Total[Map[#["cases"]&,#]]|>&]
Out[]=
country
cases
Singapore
Singapore
40
Thailand
Thailand
32
Hong Kong
Hong Kong
29
Japan
Japan
26
South Korea
South Korea
25
Taiwan
Taiwan
18
Malaysia
Malaysia
16
Germany
Germany
14
Vietnam
Vietnam
13
France
France
11
Macau
Macau
10
United Arab Emirates
United Arab Emirates
7
Australia
Australia
15
Canada
Canada
6
United Kingdom
United Kingdom
3
Philippines
Philippines
3
Italy
Italy
3
India
India
3
Russia
Russia
2
United States
United States
7
rows 1–20 of 27
In[]:=
cases=ts2[ReverseSortBy[#cases&]]
Out[]=
country
cases
Singapore
Singapore
40
Thailand
Thailand
32
Hong Kong
Hong Kong
29
Japan
Japan
26
South Korea
South Korea
25
Taiwan
Taiwan
18
Malaysia
Malaysia
16
Australia
Australia
15
Germany
Germany
14
Vietnam
Vietnam
13
France
France
11
Macau
Macau
10
United States
United States
7
United Arab Emirates
United Arab
Emirates
7
Canada
Canada
6
United Kingdom
United Kingdom
3
Philippines
Philippines
3
Italy
Italy
3
India
India
3
Russia
Russia
2
rows 1–20 of 27
In[]:=
Export["D:\\git\\wolfram-coronavirus\\docs\\cases-by-country.csv",c2,"TextDelimiters"""]
Out[]=
D:\git\wolfram-coronavirus\docs\cases-by-country.csv
In[]:=
c2=cases[Values]
Out[]=
country
cases
Singapore
40
Thailand
32
Hong Kong
29
Japan
26
South Korea
25
Taiwan
18
Malaysia
16
Australia
15
Germany
14
Vietnam
13
France
11
Macau
10
United States
7
United Arab
Emirates
7
Canada
6
United Kingd
om
3
Philippines
3
Italy
3
India
3
Russia
2
rows 1–20 of 27
In[]:=
ExportString[c2,"TextDelimiters"""]
ExportString
:ExportString called with 1 argument; 2 arguments are expected.
In[]:=
ds[Select[#Country["Name"]==="Australia"&]]
Out[]=
AdministrativeDivision
Country
GeoPosition
ConfirmedCases
RecoveredCases
Deaths
Queensland, Australia
Australia
27.47°S 153.0°E
TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 36

TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 35

TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 36

Victoria, Australia
Australia
37.81°S 145.0°E
TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 36

TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 35

TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 36

New South Wales, Australia
Australia
33.87°S 151.2°E
TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 36

TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 35

TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 36

South Australia, Australia
Australia
34.93°S 138.6°E
TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 36

TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 35

TimeSeries
Time: 21 Jan 2020 to 09 Feb 2020
Data points: 36
