01-31-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

62 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Country/Region, Deaths, Recovered

Link rowid ▼ Province/State Country/Region Last Update Confirmed Deaths Recovered
1 1 Hubei Mainland China 1/31/2020 23:59 5806 204 141
2 2 Zhejiang Mainland China 1/31/2020 23:59 538   14
3 3 Guangdong Mainland China 1/31/2020 23:59 436   11
4 4 Henan Mainland China 1/31/2020 23:59 352 2 3
5 5 Hunan Mainland China 1/31/2020 23:59 332   2
6 6 Jiangxi Mainland China 1/31/2020 23:59 240   7
7 7 Anhui Mainland China 1/31/2020 23:59 237   3
8 8 Chongqing Mainland China 1/31/2020 23:59 211   1
9 9 Shandong Mainland China 1/31/2020 23:59 184   2
10 10 Sichuan Mainland China 1/31/2020 23:59 177 1 1
11 11 Jiangsu Mainland China 1/31/2020 23:59 168   5
12 12 Beijing Mainland China 1/31/2020 23:59 139 1 5
13 13 Shanghai Mainland China 1/31/2020 23:59 135 1 9
14 14 Fujian Mainland China 1/31/2020 23:59 120    
15 15 Guangxi Mainland China 1/31/2020 23:59 87   2
16 16 Shaanxi Mainland China 1/31/2020 23:59 87    
17 17 Yunnan Mainland China 1/31/2020 23:59 83   1
18 18 Hebei Mainland China 1/31/2020 23:59 82 1  
19 19 Heilongjiang Mainland China 1/31/2020 23:59 59 2  
20 20 Hainan Mainland China 1/31/2020 23:59 52 1 1
21 21 Liaoning Mainland China 1/31/2020 23:59 48   1
22 22 Shanxi Mainland China 1/31/2020 23:59 39   1
23 23 Tianjin Mainland China 1/31/2020 23:59 32    
24 24 Guizhou Mainland China 1/31/2020 23:59 29   2
25 25 Gansu Mainland China 1/31/2020 23:59 29    
26 26 Ningxia Mainland China 1/31/2020 23:59 21    
27 27 Inner Mongolia Mainland China 1/31/2020 23:59 20   1
28 28 Xinjiang Mainland China 1/31/2020 23:59 17    
29 29 Jilin Mainland China 1/31/2020 23:59 14   1
30 30 Hong Kong Hong Kong 1/31/2020 23:59 12    
31 31 Taiwan Taiwan 1/31/2020 23:59 10    
32 32 Qinghai Mainland China 1/31/2020 23:59 8    
33 33 Macau Macau 1/31/2020 23:59 7    
34 34 Tibet Mainland China 1/31/2020 23:59 1    
35 35   Thailand 1/31/2020 23:59 19 0 8
36 36   Japan 1/31/2020 23:59 15   1
37 37   Singapore 1/31/2020 23:59 13    
38 38   South Korea 1/31/2020 23:59 11    
39 39   Malaysia 1/31/2020 23:59 8    
40 40   France 1/31/2020 23:59 5    
41 41 Bavaria Germany 1/31/2020 23:59 5    
42 42 New South Wales Australia 1/31/2020 23:59 4   2
43 43   United Arab Emirates 1/31/2020 23:59 4    
44 44 Victoria Australia 1/31/2020 23:59 3    
45 45 Illinois US 1/31/2020 23:59 2    
46 46 California US 1/31/2020 23:59 2    
47 47   Vietnam 1/31/2020 23:59 2    
48 48 Ontario Canada 1/31/2020 23:59 2    
49 49 Queensland Australia 1/31/2020 23:59 2    
50 50   Italy 1/31/2020 23:59 2    
51 51   UK 1/31/2020 23:59 2    
52 52   Russia 1/31/2020 23:59 2    
53 53 Washington US 1/31/2020 23:59 1    
54 54 Arizona US 1/31/2020 23:59 1    
55 55   Nepal 1/31/2020 23:59 1    
56 56 British Columbia Canada 1/31/2020 23:59 1    
57 57   Cambodia 1/31/2020 23:59 1    
58 58   Sri Lanka 1/31/2020 23:59 1    
59 59   Finland 1/31/2020 23:59 1    
60 60   Philippines 1/31/2020 23:59 1    
61 61   India 1/31/2020 23:59 1    
62 62   Sweden 1/31/2020 23:59 1    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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