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

101 rows sorted by Province/State

View and edit SQL

Suggested facets: Deaths, Last Update (date)

Link rowid Province/State ▼ Country/Region Last Update Confirmed Deaths Recovered
4   South Korea 2020-02-26T11:03:11 1261 12 22
15   Italy 2020-02-26T23:43:03 453 12 3
22   Japan 2020-02-26T23:43:03 189 2 22
26   Iran 2020-02-26T23:43:03 139 19 49
31   Singapore 2020-02-26T19:33:02 93 0 62
38   Thailand 2020-02-26T07:23:03 40 0 24
39   Bahrain 2020-02-26T21:03:07 33 0 0
41   Germany 2020-02-26T23:43:03 27 0 15
42   Kuwait 2020-02-26T19:23:04 26 0 0
43   Malaysia 2020-02-24T11:53:02 22 0 18
44   France 2020-02-26T20:03:06 18 2 11
46   Vietnam 2020-02-25T08:53:02 16 0 16
47   Spain 2020-02-26T20:43:02 13 0 2
48   UK 2020-02-24T08:33:02 13 0 8
49   United Arab Emirates 2020-02-22T14:53:02 13 0 4
54   Iraq 2020-02-26T04:53:02 5 0 0
57   Oman 2020-02-26T04:53:02 4 0 0
59   Croatia 2020-02-26T20:03:06 3 0 0
60   India 2020-02-16T07:43:02 3 0 3
61   Philippines 2020-02-12T07:43:02 3 1 1
63   Austria 2020-02-26T00:13:06 2 0 0
64   Finland 2020-02-26T19:03:08 2 0 1
65   Israel 2020-02-26T20:33:02 2 0 0
66   Lebanon 2020-02-26T19:33:02 2 0 0
67   Pakistan 2020-02-26T23:53:02 2 0 0
68   Russia 2020-02-12T14:43:03 2 0 2
69   Sweden 2020-02-26T18:53:02 2 0 0
74   Afghanistan 2020-02-24T23:33:02 1 0 0
75   Algeria 2020-02-25T23:43:03 1 0 0
76   Belgium 2020-02-17T04:23:06 1 0 1
77   Brazil 2020-02-26T23:53:02 1 0 0
78   Cambodia 2020-02-12T07:43:02 1 0 1
80   Egypt 2020-02-21T18:53:02 1 0 0
81   Georgia 2020-02-26T19:03:08 1 0 0
82   Greece 2020-02-26T15:53:05 1 0 0
84   Nepal 2020-02-12T14:43:03 1 0 1
85   North Macedonia 2020-02-26T19:03:08 1 0 0
86   Norway 2020-02-26T20:23:12 1 0 0
87   Romania 2020-02-26T23:43:03 1 0 0
88   Sri Lanka 2020-02-08T03:43:03 1 0 1
89   Switzerland 2020-02-25T19:13:21 1 0 0
7 Anhui Mainland China 2020-02-26T10:13:11 989 6 744
16 Beijing Mainland China 2020-02-26T00:53:02 400 4 235
90 Boston, MA US 2020-02-01T19:43:03 1 0 0
52 British Columbia Canada 2020-02-25T02:23:05 7 0 0
70 Chicago, IL US 2020-02-09T19:03:03 2 0 2
12 Chongqing Mainland China 2020-02-26T23:43:02 576 6 384
10 Diamond Princess cruise ship Others 2020-02-26T19:33:02 705 4 10
51 From Diamond Princess Australia 2020-02-22T17:03:05 7 0 0
19 Fujian Mainland China 2020-02-26T10:33:02 294 1 218
33 Gansu Mainland China 2020-02-26T14:13:10 91 2 81
2 Guangdong Mainland China 2020-02-26T10:33:02 1347 7 851
20 Guangxi Mainland China 2020-02-26T14:13:10 252 2 147
25 Guizhou Mainland China 2020-02-25T08:03:07 146 2 104
24 Hainan Mainland China 2020-02-26T12:43:02 168 5 129
18 Hebei Mainland China 2020-02-26T10:33:02 312 6 261
14 Heilongjiang Mainland China 2020-02-26T10:33:02 480 12 249
3 Henan Mainland China 2020-02-26T10:33:02 1271 19 1033
32 Hong Kong Hong Kong 2020-02-26T23:43:02 91 2 24
1 Hubei Mainland China 2020-02-26T14:13:10 65187 2615 20969
91 Humboldt County, CA US 2020-02-21T05:13:09 1 0 0
6 Hunan Mainland China 2020-02-26T10:13:11 1016 4 783
35 Inner Mongolia Mainland China 2020-02-26T15:03:05 75 0 38
11 Jiangsu Mainland China 2020-02-26T10:13:11 631 0 478
8 Jiangxi Mainland China 2020-02-26T01:13:04 934 1 719
30 Jilin Mainland China 2020-02-26T14:13:10 93 1 65
99 Lackland, TX (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0
29 Liaoning Mainland China 2020-02-26T00:13:05 121 1 88
79 London, ON Canada 2020-02-12T18:53:03 1 0 1
92 Los Angeles, CA US 2020-02-01T19:53:03 1 0 0
50 Macau Macau 2020-02-25T15:23:04 10 0 7
93 Madison, WI US 2020-02-05T21:53:02 1 0 0
55 New South Wales Australia 2020-02-13T17:53:03 4 0 4
36 Ningxia Mainland China 2020-02-26T03:53:01 71 0 65
100 Omaha, NE (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0
94 Orange, CA US 2020-02-01T19:53:03 1 0 0
45 Qinghai Mainland China 2020-02-21T04:43:02 18 0 18
53 Queensland Australia 2020-02-21T05:43:02 5 0 1
95 Sacramento County, CA US 2020-02-21T23:13:16 1 0 0
96 San Antonio, TX US 2020-02-13T18:53:02 1 0 0
71 San Benito, CA US 2020-02-03T03:53:02 2 0 0
72 San Diego County, CA US 2020-02-21T05:43:02 2 0 1
73 Santa Clara, CA US 2020-02-21T05:23:04 2 0 1
97 Seattle, WA US 2020-02-09T07:03:04 1 0 1
21 Shaanxi Mainland China 2020-02-26T14:13:10 245 1 192
9 Shandong Mainland China 2020-02-26T12:43:02 756 6 377
17 Shanghai Mainland China 2020-02-26T23:53:01 337 3 272
28 Shanxi Mainland China 2020-02-26T14:13:10 133 0 104
13 Sichuan Mainland China 2020-02-26T10:13:11 531 3 307
62 South Australia Australia 2020-02-17T08:13:09 2 0 2
40 Taiwan Taiwan 2020-02-26T12:23:04 32 1 5
98 Tempe, AZ US 2020-02-25T21:23:03 1 0 1
27 Tianjin Mainland China 2020-02-26T12:43:02 135 3 96
83 Tibet Mainland China 2020-02-12T06:43:02 1 0 1
58 Toronto, ON Canada 2020-02-24T14:43:03 3 0 2
101 Travis, CA (From Diamond Princess) US 2020-02-24T23:33:02 0 0 0
37 Unassigned Location (From Diamond Princess) US 2020-02-26T20:03:06 42 0 0
56 Victoria Australia 2020-02-13T17:53:03 4 0 4
34 Xinjiang Mainland China 2020-02-26T14:23:03 76 2 34
23 Yunnan Mainland China 2020-02-26T05:13:16 174 2 144

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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