csse_covid_19_daily_reports

Custom SQL query returning 94 rows (hide)

rowidProvince/StateCountry/RegionLast UpdateConfirmedDeathsRecovered
1 Hubei Mainland China 2020-02-25T15:23:04 64786 2563 18971
2 Guangdong Mainland China 2020-02-25T08:53:02 1347 7 822
3 Henan Mainland China 2020-02-25T12:43:02 1271 19 1002
4 Zhejiang Mainland China 2020-02-25T09:13:05 1205 1 808
5 Hunan Mainland China 2020-02-25T15:03:05 1016 4 768
6 Anhui Mainland China 2020-02-25T06:33:02 989 6 712
7   South Korea 2020-02-25T08:13:19 977 10 22
8 Jiangxi Mainland China 2020-02-25T15:03:05 934 1 683
9 Shandong Mainland China 2020-02-25T12:53:02 756 6 355
10 Diamond Princess cruise ship Others 2020-02-23T22:33:03 691 3 0
11 Jiangsu Mainland China 2020-02-25T00:53:02 631 0 458
12 Chongqing Mainland China 2020-02-25T23:23:03 576 6 372
13 Sichuan Mainland China 2020-02-25T15:03:05 529 3 289
14 Heilongjiang Mainland China 2020-02-25T15:23:04 480 12 243
15 Beijing Mainland China 2020-02-25T01:33:02 400 4 215
16 Shanghai Mainland China 2020-02-25T06:33:02 336 3 268
17   Italy 2020-02-25T18:55:32 322 10 1
18 Hebei Mainland China 2020-02-25T12:43:02 311 6 248
19 Fujian Mainland China 2020-02-25T10:03:07 294 1 199
20 Guangxi Mainland China 2020-02-25T10:03:07 252 2 134
21 Shaanxi Mainland China 2020-02-25T15:23:04 245 1 186
22 Yunnan Mainland China 2020-02-25T04:53:02 174 2 129
23   Japan 2020-02-25T14:53:03 170 1 22
24 Hainan Mainland China 2020-02-25T12:53:02 168 5 124
25 Guizhou Mainland China 2020-02-25T08:03:07 146 2 104
26 Tianjin Mainland China 2020-02-25T15:23:04 135 3 91
27 Shanxi Mainland China 2020-02-25T23:13:03 133 0 98
28 Liaoning Mainland China 2020-02-25T00:23:03 121 1 83
29   Iran 2020-02-25T14:53:03 95 16 0
30 Jilin Mainland China 2020-02-25T15:23:04 93 1 63
31 Gansu Mainland China 2020-02-24T15:13:07 91 2 80
32   Singapore 2020-02-25T18:55:32 91 0 53
33 Hong Kong Hong Kong 2020-02-25T09:43:02 84 2 19
34 Xinjiang Mainland China 2020-02-24T15:03:05 76 2 30
35 Inner Mongolia Mainland China 2020-02-25T23:53:02 75 0 35
36 Ningxia Mainland China 2020-02-25T03:53:02 71 0 61
37   Thailand 2020-02-25T08:53:02 37 0 22
38 Unassigned Location (From Diamond Princess) US 2020-02-25T21:23:03 36 0 0
39 Taiwan Taiwan 2020-02-25T06:53:02 31 1 5
40   Bahrain 2020-02-25T18:55:32 23 0 0
41   Malaysia 2020-02-24T11:53:02 22 0 18
42 Qinghai Mainland China 2020-02-21T04:43:02 18 0 18
43   Germany 2020-02-25T21:33:02 17 0 14
44   Vietnam 2020-02-25T08:53:02 16 0 16
45   France 2020-02-25T21:23:03 14 1 11
46   UK 2020-02-24T08:33:02 13 0 8
47   United Arab Emirates 2020-02-22T14:53:02 13 0 4
48   Kuwait 2020-02-25T23:43:03 11 0 0
49 Macau Macau 2020-02-25T15:23:04 10 0 7
50 From Diamond Princess Australia 2020-02-22T17:03:05 7 0 0
51 British Columbia Canada 2020-02-25T02:23:05 7 0 0
52   Spain 2020-02-25T21:33:02 6 0 2
53 Queensland Australia 2020-02-21T05:43:02 5 0 1
54 New South Wales Australia 2020-02-13T17:53:03 4 0 4
55 Victoria Australia 2020-02-13T17:53:03 4 0 4
56 Toronto, ON Canada 2020-02-24T14:43:03 3 0 2
57   India 2020-02-16T07:43:02 3 0 3
58   Philippines 2020-02-12T07:43:02 3 1 1
59 South Australia Australia 2020-02-17T08:13:09 2 0 2
60 None Austria 2020-02-25T18:55:32 2 0 0
61   Oman 2020-02-25T01:13:09 2 0 0
62   Russia 2020-02-12T14:43:03 2 0 2
63 Chicago, IL US 2020-02-09T19:03:03 2 0 2
64 San Benito, CA US 2020-02-03T03:53:02 2 0 0
65 San Diego County, CA US 2020-02-21T05:43:02 2 0 1
66 Santa Clara, CA US 2020-02-21T05:23:04 2 0 1
67   Afghanistan 2020-02-24T23:33:02 1 0 0
68   Algeria 2020-02-25T23:43:03 1 0 0
69   Belgium 2020-02-17T04:23:06 1 0 1
70   Cambodia 2020-02-12T07:43:02 1 0 1
71 London, ON Canada 2020-02-12T18:53:03 1 0 1
72   Croatia 2020-02-25T18:55:32 1 0 0
73   Egypt 2020-02-21T18:53:02 1 0 0
74   Finland 2020-02-12T00:03:12 1 0 1
75   Iraq 2020-02-24T23:33:02 1 0 0
76 From Diamond Princess Israel 2020-02-22T20:53:02 1 0 0
77   Lebanon 2020-02-22T20:53:02 1 0 0
78 Tibet Mainland China 2020-02-12T06:43:02 1 0 1
79   Nepal 2020-02-12T14:43:03 1 0 1
80   Sri Lanka 2020-02-08T03:43:03 1 0 1
81   Sweden 2020-02-01T02:13:26 1 0 0
82   Switzerland 2020-02-25T19:13:21 1 0 0
83 Boston, MA US 2020-02-01T19:43:03 1 0 0
84 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0
85 Los Angeles, CA US 2020-02-01T19:53:03 1 0 0
86 Madison, WI US 2020-02-05T21:53:02 1 0 0
87 Orange, CA US 2020-02-01T19:53:03 1 0 0
88 Sacramento County, CA US 2020-02-21T23:13:16 1 0 0
89 San Antonio, TX US 2020-02-13T18:53:02 1 0 0
90 Seattle, WA US 2020-02-09T07:03:04 1 0 1
91 Tempe, AZ US 2020-02-25T21:23:03 1 0 1
92 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0
93 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0
94 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0
Powered by Datasette · Query took 1.357ms