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

38 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Country/Region, Confirmed

Link rowid ▼ Province/State Country/Region Last Update Confirmed Deaths Recovered
1 1 Anhui Mainland China 1/22/2020 17:00 1    
2 2 Beijing Mainland China 1/22/2020 17:00 14    
3 3 Chongqing Mainland China 1/22/2020 17:00 6    
4 4 Fujian Mainland China 1/22/2020 17:00 1    
5 5 Gansu Mainland China 1/22/2020 17:00      
6 6 Guangdong Mainland China 1/22/2020 17:00 26    
7 7 Guangxi Mainland China 1/22/2020 17:00 2    
8 8 Guizhou Mainland China 1/22/2020 17:00 1    
9 9 Hainan Mainland China 1/22/2020 17:00 4    
10 10 Hebei Mainland China 1/22/2020 17:00 1    
11 11 Heilongjiang Mainland China 1/22/2020 17:00      
12 12 Henan Mainland China 1/22/2020 17:00 5    
13 13 Hong Kong Hong Kong 1/22/2020 17:00      
14 14 Hubei Mainland China 1/22/2020 17:00 444 17 28
15 15 Hunan Mainland China 1/22/2020 17:00 4    
16 16 Inner Mongolia Mainland China 1/22/2020 17:00      
17 17 Jiangsu Mainland China 1/22/2020 17:00 1    
18 18 Jiangxi Mainland China 1/22/2020 17:00 2    
19 19 Jilin Mainland China 1/22/2020 17:00      
20 20 Liaoning Mainland China 1/22/2020 17:00 2    
21 21 Macau Macau 1/22/2020 17:00 1    
22 22 Ningxia Mainland China 1/22/2020 17:00 1    
23 23 Qinghai Mainland China 1/22/2020 17:00      
24 24 Shaanxi Mainland China 1/22/2020 17:00      
25 25 Shandong Mainland China 1/22/2020 17:00 2    
26 26 Shanghai Mainland China 1/22/2020 17:00 9    
27 27 Shanxi Mainland China 1/22/2020 17:00 1    
28 28 Sichuan Mainland China 1/22/2020 17:00 5    
29 29 Taiwan Taiwan 1/22/2020 17:00 1    
30 30 Tianjin Mainland China 1/22/2020 17:00 4    
31 31 Tibet Mainland China 1/22/2020 17:00      
32 32 Washington US 1/22/2020 17:00 1    
33 33 Xinjiang Mainland China 1/22/2020 17:00      
34 34 Yunnan Mainland China 1/22/2020 17:00 1    
35 35 Zhejiang Mainland China 1/22/2020 17:00 10    
36 36   Japan 1/22/2020 17:00 2    
37 37   Thailand 1/22/2020 17:00 4 0 2
38 38   South Korea 1/22/2020 17:00 1    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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