02-27-2020

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: README

105 rows sorted by Last Update

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State Country/Region Last Update ▼ Confirmed Deaths Recovered
95 95 Boston, MA US 2020-02-01T19:43:03 1 0 0
97 97 Los Angeles, CA US 2020-02-01T19:53:03 1 0 0
99 99 Orange, CA US 2020-02-01T19:53:03 1 0 0
74 74 San Benito, CA US 2020-02-03T03:53:02 2 0 0
98 98 Madison, WI US 2020-02-05T21:53:02 1 0 0
94 94   Sri Lanka 2020-02-08T03:43:03 1 0 1
101 101 Seattle, WA US 2020-02-09T07:03:04 1 0 1
72 72 Chicago, IL US 2020-02-09T19:03:03 2 0 2
87 87 Tibet Mainland China 2020-02-12T06:43:02 1 0 1
66 66   Philippines 2020-02-12T07:43:02 3 1 1
81 81   Cambodia 2020-02-12T07:43:02 1 0 1
71 71   Russia 2020-02-12T14:43:03 2 0 2
88 88   Nepal 2020-02-12T14:43:03 1 0 1
82 82 London, ON Canada 2020-02-12T18:53:03 1 0 1
58 58 New South Wales Australia 2020-02-13T17:53:03 4 0 4
59 59 Victoria Australia 2020-02-13T17:53:03 4 0 4
100 100 San Antonio, TX US 2020-02-13T18:53:02 1 0 0
64 64   India 2020-02-16T07:43:02 3 0 3
79 79   Belgium 2020-02-17T04:23:06 1 0 1
67 67 South Australia Australia 2020-02-17T08:13:09 2 0 2
45 45 Qinghai Mainland China 2020-02-21T04:43:02 18 0 18
96 96 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0
76 76 Santa Clara, CA US 2020-02-21T05:23:04 2 0 1
56 56 Queensland Australia 2020-02-21T05:43:02 5 0 1
75 75 San Diego County, CA US 2020-02-21T05:43:02 2 0 1
84 84   Egypt 2020-02-21T18:53:02 1 0 0
49 49   United Arab Emirates 2020-02-22T14:53:02 13 0 4
77 77   Afghanistan 2020-02-24T23:33:02 1 0 0
103 103 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0
104 104 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0
105 105 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0
46 46   Vietnam 2020-02-25T08:53:02 16 0 16
102 102 Tempe, AZ US 2020-02-25T21:23:03 1 0 1
78 78   Algeria 2020-02-25T23:43:03 1 0 0
60 60   Oman 2020-02-26T04:53:02 4 0 0
40 40   Thailand 2020-02-26T07:23:03 40 0 24
43 43 Taiwan Taiwan 2020-02-26T12:23:04 32 1 5
33 33 Gansu Mainland China 2020-02-26T14:13:10 91 2 81
68 68   Finland 2020-02-26T19:03:08 2 0 1
10 10 Diamond Princess cruise ship Others 2020-02-26T19:33:02 705 4 10
31 31   Singapore 2020-02-26T19:33:02 93 0 62
69 69   Lebanon 2020-02-26T19:33:02 2 0 0
39 39 Unassigned Location (From Diamond Princess) US 2020-02-26T20:03:06 42 0 0
62 62   Croatia 2020-02-26T20:03:06 3 0 0
42 42   Bahrain 2020-02-26T21:03:07 33 0 0
70 70   Pakistan 2020-02-26T23:53:02 2 0 0
80 80   Brazil 2020-02-26T23:53:02 1 0 0
26 26 Guizhou Mainland China 2020-02-27T00:43:02 146 2 112
8 8 Jiangxi Mainland China 2020-02-27T01:43:02 934 1 754
16 16 Beijing Mainland China 2020-02-27T02:23:13 410 5 248
51 51 From Diamond Princess Australia 2020-02-27T03:33:06 8 0 0
53 53 British Columbia Canada 2020-02-27T03:33:06 7 0 3
17 17 Shanghai Mainland China 2020-02-27T04:03:12 337 3 276
3 3 Guangdong Mainland China 2020-02-27T09:53:02 1347 7 890
32 32 Hong Kong Hong Kong 2020-02-27T09:53:02 92 2 24
19 19 Fujian Mainland China 2020-02-27T10:03:07 296 1 228
20 20 Guangxi Mainland China 2020-02-27T10:03:07 252 2 161
24 24 Yunnan Mainland China 2020-02-27T10:03:07 174 2 150
25 25 Hainan Mainland China 2020-02-27T10:03:07 168 5 131
36 36 Ningxia Mainland China 2020-02-27T10:03:07 72 0 68
2 2   South Korea 2020-02-27T12:03:04 1766 13 22
21 21   Iran 2020-02-27T12:03:04 245 26 49
1 1 Hubei Mainland China 2020-02-27T12:13:14 65596 2641 23383
5 5 Zhejiang Mainland China 2020-02-27T12:43:02 1205 1 932
6 6 Hunan Mainland China 2020-02-27T12:43:02 1017 4 804
14 14 Sichuan Mainland China 2020-02-27T12:43:02 534 3 321
15 15 Heilongjiang Mainland China 2020-02-27T12:43:02 480 13 270
18 18 Hebei Mainland China 2020-02-27T12:43:02 317 6 274
22 22 Shaanxi Mainland China 2020-02-27T12:43:02 245 1 195
30 30 Jilin Mainland China 2020-02-27T12:43:02 93 1 67
34 34 Xinjiang Mainland China 2020-02-27T12:43:02 76 2 43
50 50 Macau Macau 2020-02-27T12:43:02 10 0 8
47 47   Spain 2020-02-27T13:23:02 15 0 2
48 48   UK 2020-02-27T13:23:02 15 0 8
38 38   Kuwait 2020-02-27T13:33:03 43 0 0
61 61   Austria 2020-02-27T14:03:03 3 0 0
63 63   Greece 2020-02-27T14:03:03 3 0 0
65 65   Israel 2020-02-27T14:03:03 3 0 0
7 7 Anhui Mainland China 2020-02-27T14:13:06 989 6 792
9 9 Shandong Mainland China 2020-02-27T14:13:06 756 6 387
12 12 Jiangsu Mainland China 2020-02-27T14:13:06 631 0 498
29 29 Liaoning Mainland China 2020-02-27T14:13:06 121 1 93
4 4 Henan Mainland China 2020-02-27T15:03:11 1272 20 1068
44 44   Malaysia 2020-02-27T15:13:13 23 0 18
83 83   Denmark 2020-02-27T16:23:03 1 0 0
85 85   Estonia 2020-02-27T16:23:03 1 0 0
86 86   Georgia 2020-02-27T16:23:03 1 0 0
90 90   North Macedonia 2020-02-27T16:23:03 1 0 0
91 91   Norway 2020-02-27T16:23:03 1 0 0
92 92   Romania 2020-02-27T16:23:03 1 0 0
55 55   Sweden 2020-02-27T20:33:02 7 0 0
73 73 Sacramento County, CA US 2020-02-27T20:33:02 2 0 0
89 89   Netherlands 2020-02-27T21:13:10 1 0 0
93 93   San Marino 2020-02-27T21:13:10 1 0 0
41 41   France 2020-02-27T22:13:10 38 2 11
54 54   Iraq 2020-02-27T22:23:11 7 0 0
57 57 Toronto, ON Canada 2020-02-27T22:43:02 5 0 2
52 52   Switzerland 2020-02-27T23:03:11 8 0 0
27 27 Tianjin Mainland China 2020-02-27T23:13:04 136 3 102
28 28 Shanxi Mainland China 2020-02-27T23:13:04 133 0 107

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [02-27-2020] (
   [Province/State] TEXT,
   [Country/Region] TEXT,
   [Last Update] TEXT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER
);