csse_covid_19_daily_reports

Custom SQL query returning 76 rows (hide)

rowidProvince/StateCountry/RegionLast UpdateConfirmedDeathsRecovered
1 Hubei Mainland China 2020-02-19T23:23:02 62031 2029 10337
2 Guangdong Mainland China 2020-02-19T10:23:02 1331 5 606
3 Henan Mainland China 2020-02-19T12:13:08 1262 19 573
4 Zhejiang Mainland China 2020-02-19T11:33:02 1174 0 604
5 Hunan Mainland China 2020-02-19T11:33:02 1008 4 561
6 Anhui Mainland China 2020-02-19T14:13:03 986 6 413
7 Jiangxi Mainland China 2020-02-19T01:23:07 934 1 362
8 Jiangsu Mainland China 2020-02-19T12:13:08 631 0 318
9 Diamond Princess cruise ship Others 2020-02-19T20:33:02 621 0 1
10 Chongqing Mainland China 2020-02-19T23:23:02 560 5 274
11 Shandong Mainland China 2020-02-19T12:03:07 544 3 231
12 Sichuan Mainland China 2020-02-19T13:53:02 514 3 188
13 Heilongjiang Mainland China 2020-02-19T11:03:08 470 12 120
14 Beijing Mainland China 2020-02-19T04:53:02 393 4 145
15 Shanghai Mainland China 2020-02-19T04:43:02 333 2 186
16 Hebei Mainland China 2020-02-19T13:23:02 306 4 152
17 Fujian Mainland China 2020-02-19T11:53:02 293 0 112
18 Guangxi Mainland China 2020-02-19T09:13:12 244 2 86
19 Shaanxi Mainland China 2020-02-19T10:23:02 242 0 102
20 Yunnan Mainland China 2020-02-19T23:33:02 172 1 60
21 Hainan Mainland China 2020-02-19T23:43:02 168 4 84
22 Guizhou Mainland China 2020-02-19T10:53:02 146 2 70
23 Shanxi Mainland China 2020-02-19T23:53:02 131 0 68
24 Tianjin Mainland China 2020-02-19T13:03:03 130 3 54
25 Liaoning Mainland China 2020-02-19T01:23:07 121 1 55
26 Gansu Mainland China 2020-02-19T13:53:02 91 2 65
27 Jilin Mainland China 2020-02-19T06:03:08 90 1 37
28   Japan 2020-02-19T20:33:02 84 1 18
29   Singapore 2020-02-19T22:13:08 84 0 34
30 Xinjiang Mainland China 2020-02-19T07:03:07 76 1 20
31 Inner Mongolia Mainland China 2020-02-19T11:03:08 75 0 10
32 Ningxia Mainland China 2020-02-19T01:53:02 71 0 42
33 Hong Kong Hong Kong 2020-02-19T12:13:08 63 2 5
34   Thailand 2020-02-17T07:33:02 35 0 15
35   South Korea 2020-02-18T03:43:02 31 0 12
36 Taiwan Taiwan 2020-02-19T07:53:02 23 1 2
37   Malaysia 2020-02-19T09:33:03 22 0 15
38 Qinghai Mainland China 2020-02-19T04:53:02 18 0 16
39   Germany 2020-02-18T17:03:03 16 0 12
40   Vietnam 2020-02-13T06:33:02 16 0 7
41   France 2020-02-15T20:53:02 12 1 4
42 Macau Macau 2020-02-16T12:03:06 10 0 5
43   UK 2020-02-16T16:23:06 9 0 8
44   United Arab Emirates 2020-02-16T20:43:02 9 0 4
45 Queensland Australia 2020-02-09T19:33:02 5 0 0
46 British Columbia Canada 2020-02-17T08:03:07 5 0 0
47 New South Wales Australia 2020-02-13T17:53:03 4 0 4
48 Victoria Australia 2020-02-13T17:53:03 4 0 4
49   India 2020-02-16T07:43:02 3 0 3
50   Italy 2020-02-07T17:53:02 3 0 0
51   Philippines 2020-02-12T07:43:02 3 1 1
52 South Australia Australia 2020-02-17T08:13:09 2 0 2
53 Toronto, ON Canada 2020-02-04T00:13:06 2 0 0
54   Iran 2020-02-19T23:43:02 2 2 0
55   Russia 2020-02-12T14:43:03 2 0 2
56   Spain 2020-02-15T17:23:04 2 0 2
57 Chicago, IL US 2020-02-09T19:03:03 2 0 2
58 San Benito, CA US 2020-02-03T03:53:02 2 0 0
59 San Diego County, CA US 2020-02-13T03:13:08 2 0 0
60 Santa Clara, CA US 2020-02-03T00:43:02 2 0 0
61   Belgium 2020-02-17T04:23:06 1 0 1
62   Cambodia 2020-02-12T07:43:02 1 0 1
63 London, ON Canada 2020-02-12T18:53:03 1 0 1
64   Egypt 2020-02-14T23:53:02 1 0 0
65   Finland 2020-02-12T00:03:12 1 0 1
66 Tibet Mainland China 2020-02-12T06:43:02 1 0 1
67   Nepal 2020-02-12T14:43:03 1 0 1
68   Sri Lanka 2020-02-08T03:43:03 1 0 1
69   Sweden 2020-02-01T02:13:26 1 0 0
70 Boston, MA US 2020-02-01T19:43:03 1 0 0
71 Los Angeles, CA US 2020-02-01T19:53:03 1 0 0
72 Madison, WI US 2020-02-05T21:53:02 1 0 0
73 Orange, CA US 2020-02-01T19:53:03 1 0 0
74 San Antonio, TX US 2020-02-13T18:53:02 1 0 0
75 Seattle, WA US 2020-02-09T07:03:04 1 0 1
76 Tempe, AZ US 2020-02-01T19:43:03 1 0 0
Powered by Datasette · Query took 1.102ms