csse_covid_19_daily_reports

Custom SQL query returning 101 rows (hide)

rowidProvince/StateCountry/RegionLast UpdateConfirmedDeathsRecovered
1 Hubei Mainland China 2020-02-28T00:43:01 65914 2682 26403
2   South Korea 2020-02-28T08:53:03 2337 13 22
3 Guangdong Mainland China 2020-02-28T08:53:03 1348 7 935
4 Henan Mainland China 2020-02-28T09:23:02 1272 20 1112
5 Zhejiang Mainland China 2020-02-28T10:03:12 1205 1 975
6 Hunan Mainland China 2020-02-28T09:13:10 1017 4 830
7 Anhui Mainland China 2020-02-28T04:43:02 990 6 821
8 Jiangxi Mainland China 2020-02-28T01:13:11 935 1 790
9   Italy 2020-02-28T20:13:09 888 21 46
10 Shandong Mainland China 2020-02-28T09:23:02 756 6 405
11 Diamond Princess cruise ship Others 2020-02-28T20:53:02 705 6 10
12 Jiangsu Mainland China 2020-02-28T08:53:03 631 0 515
13 Chongqing Mainland China 2020-02-28T23:23:03 576 6 422
14 Sichuan Mainland China 2020-02-28T09:23:02 538 3 338
15 Heilongjiang Mainland China 2020-02-28T04:43:02 480 13 283
16 Beijing Mainland China 2020-02-28T02:23:05 410 7 257
17   Iran 2020-02-28T15:43:03 388 34 73
18 Shanghai Mainland China 2020-02-28T04:53:03 337 3 279
19 Hebei Mainland China 2020-02-28T08:53:03 318 6 277
20 Fujian Mainland China 2020-02-28T09:13:10 296 1 235
21 Guangxi Mainland China 2020-02-28T09:13:10 252 2 168
22 Shaanxi Mainland China 2020-02-28T08:53:03 245 1 199
23   Japan 2020-02-28T12:43:02 228 4 22
24 Yunnan Mainland China 2020-02-28T05:03:09 174 2 156
25 Hainan Mainland China 2020-02-28T08:53:03 168 5 133
26 Guizhou Mainland China 2020-02-27T00:43:02 146 2 112
27 Tianjin Mainland China 2020-02-27T23:13:04 136 3 102
28 Shanxi Mainland China 2020-02-28T23:23:03 133 0 112
29 Liaoning Mainland China 2020-02-27T14:13:06 121 1 93
30 Hong Kong Hong Kong 2020-02-28T10:03:12 94 2 30
31 Jilin Mainland China 2020-02-28T08:53:03 93 1 73
32   Singapore 2020-02-26T19:33:02 93 0 62
33 Gansu Mainland China 2020-02-28T02:33:02 91 2 82
34 Xinjiang Mainland China 2020-02-28T07:43:02 76 3 52
35 Inner Mongolia Mainland China 2020-02-28T07:23:03 75 0 45
36 Ningxia Mainland China 2020-02-27T10:03:07 72 0 68
37   France 2020-02-28T20:13:09 57 2 11
38   Germany 2020-02-28T00:13:18 48 0 16
39   Kuwait 2020-02-28T16:23:03 45 0 0
40 Unassigned Location (From Diamond Princess) US 2020-02-28T20:03:03 44 0 0
41   Thailand 2020-02-28T07:53:02 41 0 28
42   Bahrain 2020-02-28T15:33:03 36 0 0
43 Taiwan Taiwan 2020-02-28T07:13:08 34 1 6
44   Spain 2020-02-28T15:33:03 32 0 2
45   Malaysia 2020-02-27T15:13:13 23 0 18
46   UK 2020-02-28T20:13:09 20 0 8
47   United Arab Emirates 2020-02-28T04:13:09 19 0 5
48 Qinghai Mainland China 2020-02-21T04:43:02 18 0 18
49   Vietnam 2020-02-25T08:53:02 16 0 16
50 Macau Macau 2020-02-27T12:43:02 10 0 8
51 From Diamond Princess Australia 2020-02-27T03:33:06 8 0 0
52   Switzerland 2020-02-27T23:03:11 8 0 0
53 British Columbia Canada 2020-02-27T03:33:06 7 0 3
54   Iraq 2020-02-27T22:23:11 7 0 0
55   Sweden 2020-02-27T20:33:02 7 0 0
56   Norway 2020-02-28T21:03:02 6 0 0
57 Queensland Australia 2020-02-21T05:43:02 5 0 1
58 Toronto, ON Canada 2020-02-27T22:43:02 5 0 2
59   Croatia 2020-02-28T15:43:03 5 0 0
60 New South Wales Australia 2020-02-13T17:53:03 4 0 4
61 Victoria Australia 2020-02-13T17:53:03 4 0 4
62   Greece 2020-02-28T15:33:03 4 0 0
63   Israel 2020-02-28T15:53:03 4 0 1
64   Oman 2020-02-26T04:53:02 4 0 0
65   Austria 2020-02-27T14:03:03 3 0 0
66   India 2020-02-16T07:43:02 3 0 3
67   Philippines 2020-02-12T07:43:02 3 1 1
68   Romania 2020-02-28T15:33:03 3 0 0
69 South Australia Australia 2020-02-17T08:13:09 2 0 2
70   Finland 2020-02-26T19:03:08 2 0 1
71   Lebanon 2020-02-26T19:33:02 2 0 0
72   Pakistan 2020-02-26T23:53:02 2 0 0
73   Russia 2020-02-12T14:43:03 2 0 2
74 Chicago, IL US 2020-02-09T19:03:03 2 0 2
75 Sacramento County, CA US 2020-02-27T20:33:02 2 0 0
76 San Benito, CA US 2020-02-03T03:53:02 2 0 0
77 San Diego County, CA US 2020-02-21T05:43:02 2 0 1
78 Santa Clara, CA US 2020-02-21T05:23:04 2 0 1
79   Azerbaijan 2020-02-28T15:03:26 1 0 0
80   Afghanistan 2020-02-24T23:33:02 1 0 0
81   Algeria 2020-02-25T23:43:03 1 0 0
82   Belarus 2020-02-28T16:23:03 1 0 0
83   Belgium 2020-02-17T04:23:06 1 0 1
84   Brazil 2020-02-26T23:53:02 1 0 0
85   Cambodia 2020-02-12T07:43:02 1 0 1
86 Montreal, QC Canada 2020-02-28T05:23:07 1 0 0
87 London, ON Canada 2020-02-12T18:53:03 1 0 1
88   Denmark 2020-02-27T16:23:03 1 0 0
89   Egypt 2020-02-28T04:13:09 1 0 1
90   Estonia 2020-02-27T16:23:03 1 0 0
91   Georgia 2020-02-27T16:23:03 1 0 0
92   Iceland 2020-02-28T15:33:03 1 0 0
93   Lithuania 2020-02-28T16:23:03 1 0 0
94 Tibet Mainland China 2020-02-12T06:43:02 1 0 1
95   Mexico 2020-02-28T15:03:26 1 0 0
96   Nepal 2020-02-12T14:43:03 1 0 1
97   Netherlands 2020-02-28T01:23:03 1 0 0
98   New Zealand 2020-02-28T16:23:03 1 0 0
99   Nigeria 2020-02-28T16:23:03 1 0 0
100   North Ireland 2020-02-28T05:43:02 1 0 0
101   North Macedonia 2020-02-27T16:23:03 1 0 0
Powered by Datasette · Query took 1.281ms