csse_covid_19_daily_reports

Custom SQL query returning 101 rows (hide)

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