Johns_Hopkins_COVID_data_-_time_series: time_series_covid19_recovered

Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are time series reports which provide cases, deaths and recovered for global locations as well as United States counties. Each file covers from Jan 22 to the present. For the United States there is one file for cases and one for deaths. For the global locations, there is one file for cases, one for deaths and one for recovered cases. The entire set of CSV files are refreshed daily. The zipped archives contain previous time series 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: big-local-datasette

1 row where 2/4/20 = 27

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid ▼	Province/State	Country/Region	Lat	Long	1/22/20	1/23/20	1/24/20	1/25/20	1/26/20	1/27/20	1/28/20	1/29/20	1/30/20	1/31/20	2/1/20	2/2/20	2/3/20	2/4/20	2/5/20	2/6/20	2/7/20	2/8/20	2/9/20	2/10/20	2/11/20	2/12/20	2/13/20	2/14/20	2/15/20	2/16/20	2/17/20	2/18/20	2/19/20	2/20/20	2/21/20	2/22/20	2/23/20	2/24/20	2/25/20	2/26/20	2/27/20	2/28/20	2/29/20	3/1/20	3/2/20	3/3/20	3/4/20	3/5/20	3/6/20	3/7/20	3/8/20	3/9/20	3/10/20	3/11/20	3/12/20	3/13/20	3/14/20	3/15/20	3/16/20	3/17/20	3/18/20	3/19/20	3/20/20	3/21/20	3/22/20	3/23/20	3/24/20	3/25/20	3/26/20	3/27/20	3/28/20	3/29/20	3/30/20	3/31/20	4/1/20	4/2/20	4/3/20	4/4/20	4/5/20	4/6/20	4/7/20	4/8/20	4/9/20	4/10/20	4/11/20	4/12/20	4/13/20	4/14/20	4/15/20	4/16/20	4/17/20	4/18/20	4/19/20	4/20/20	4/21/20	4/22/20	4/23/20	4/24/20	4/25/20	4/26/20	4/27/20	4/28/20	4/29/20	4/30/20	5/1/20	5/2/20	5/3/20	5/4/20	5/5/20	5/6/20	5/7/20	5/8/20	5/9/20	5/10/20	5/11/20	5/12/20	5/13/20	5/14/20	5/15/20	5/16/20	5/17/20	5/18/20	5/19/20	5/20/20	5/21/20	5/22/20	5/23/20	5/24/20	5/25/20	5/26/20	5/27/20	5/28/20	5/29/20	5/30/20	5/31/20	6/1/20	6/2/20	6/3/20	6/4/20	6/5/20	6/6/20	6/7/20	6/8/20	6/9/20	6/10/20	6/11/20	6/12/20	6/13/20	6/14/20	6/15/20	6/16/20	6/17/20	6/18/20	6/19/20	6/20/20	6/21/20	6/22/20	6/23/20	6/24/20	6/25/20	6/26/20	6/27/20	6/28/20	6/29/20	6/30/20	7/1/20	7/2/20	7/3/20	7/4/20	7/5/20	7/6/20	7/7/20	7/8/20	7/9/20	7/10/20	7/11/20	7/12/20	7/13/20	7/14/20	7/15/20	7/16/20	7/17/20	7/18/20	7/19/20	7/20/20	7/21/20	7/22/20	7/23/20	7/24/20	7/25/20	7/26/20	7/27/20	7/28/20	7/29/20	7/30/20	7/31/20	8/1/20	8/2/20	8/3/20	8/4/20	8/5/20	8/6/20	8/7/20	8/8/20	8/9/20	8/10/20	8/11/20	8/12/20	8/13/20	8/14/20	8/15/20	8/16/20	8/17/20	8/18/20	8/19/20	8/20/20	8/21/20	8/22/20	8/23/20	8/24/20	8/25/20	8/26/20	8/27/20	8/28/20	8/29/20	8/30/20	8/31/20	9/1/20	9/2/20	9/3/20	9/4/20	9/5/20	9/6/20	9/7/20	9/8/20	9/9/20	9/10/20	9/11/20	9/12/20	9/13/20	9/14/20	9/15/20	9/16/20	9/17/20	9/18/20	9/19/20	9/20/20	9/21/20	9/22/20	9/23/20	9/24/20	9/25/20	9/26/20	9/27/20	9/28/20	9/29/20	9/30/20	10/1/20	10/2/20	10/3/20	10/4/20	10/5/20	10/6/20	10/7/20	10/8/20	10/9/20	10/10/20	10/11/20	10/12/20	10/13/20	10/14/20	10/15/20	10/16/20	10/17/20	10/18/20	10/19/20	10/20/20	10/21/20	10/22/20	10/23/20	10/24/20	10/25/20	10/26/20	10/27/20	10/28/20	10/29/20	10/30/20	10/31/20	11/1/20	11/2/20	11/3/20	11/4/20	11/5/20	11/6/20	11/7/20	11/8/20	11/9/20	11/10/20	11/11/20	11/12/20	11/13/20	11/14/20	11/15/20	11/16/20	11/17/20	11/18/20	11/19/20	11/20/20	11/21/20	11/22/20	11/23/20	11/24/20	11/25/20	11/26/20	11/27/20	11/28/20	11/29/20	11/30/20	12/1/20	12/2/20	12/3/20	12/4/20	12/5/20	12/6/20	12/7/20	12/8/20	12/9/20	12/10/20	12/11/20	12/12/20	12/13/20	12/14/20	12/15/20	12/16/20	12/17/20	12/18/20	12/19/20	12/20/20	12/21/20	12/22/20	12/23/20	12/24/20	12/25/20	12/26/20	12/27/20	12/28/20	12/29/20	12/30/20	12/31/20	1/1/21	1/2/21	1/3/21	1/4/21	1/5/21	1/6/21	1/7/21	1/8/21	1/9/21	1/10/21	1/11/21	1/12/21	1/13/21	1/14/21	1/15/21	1/16/21	1/17/21	1/18/21	1/19/21	1/20/21	1/21/21	1/22/21	1/23/21	1/24/21	1/25/21	1/26/21	1/27/21	1/28/21	1/29/21	1/30/21	1/31/21	2/1/21	2/2/21	2/3/21	2/4/21	2/5/21	2/6/21	2/7/21	2/8/21	2/9/21	2/10/21	2/11/21	2/12/21	2/13/21	2/14/21	2/15/21	2/16/21	2/17/21	2/18/21	2/19/21	2/20/21	2/21/21	2/22/21	2/23/21	2/24/21	2/25/21	2/26/21	2/27/21	2/28/21
55	55	Henan	China	33.882	113.614	0	0	0	0	0	0	0	1	2	3	3	10	16	27	47	56	86	116	153	191	218	246	296	357	391	440	509	522	573	637	736	830	868	943	1002	1033	1068	1112	1170	1198	1205	1231	1234	1239	1244	1244	1247	1247	1247	1249	1249	1249	1250	1250	1250	1250	1250	1250	1250	1250	1250	1250	1250	1250	1250	1250	1251	1251	1251	1251	1251	1251	1251	1251	1251	1252	1252	1252	1252	1252	1252	1253	1253	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1254	1255	1255	1255	1255	1255	1255	1255	1255	1256	1256	1256	1256	1256	1256	1256	1256	1257	1257	1257	1257	1257	1257	1257	1257	1258	1258	1258	1258	1258	1258	1258	1258	1258	1258	1258	1258	1258	1259	1259	1259	1259	1259	1259	1260	1261	1261	1261	1261	1261	1261	1261	1261	1261	1261	1261	1261	1262	1263	1263	1265	1265	1266	1266	1266	1266	1266	1266	1266	1266	1266	1266	1266	1267	1267	1268	1269	1269	1270	1270	1270	1270	1270	1270	1270	1270	1270	1270	1270	1270	1270	1270	1270	1271	1271	1273	1273	1273	1273	1273	1273	1273	1273	1273	1273	1273	1275	1276	1276	1276	1277	1277	1277	1277	1278	1278	1278	1278	1278	1280	1280	1280	1280	1280	1280	1280	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281	1281

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [time_series_covid19_recovered_global] (
   [Province/State] TEXT,
   [Country/Region] TEXT,
   [Lat] FLOAT,
   [Long] FLOAT,
   [1/22/20] INTEGER,
   [1/23/20] INTEGER,
   [1/24/20] INTEGER,
   [1/25/20] INTEGER,
   [1/26/20] INTEGER,
   [1/27/20] INTEGER,
   [1/28/20] INTEGER,
   [1/29/20] INTEGER,
   [1/30/20] INTEGER,
   [1/31/20] INTEGER,
   [2/1/20] INTEGER,
   [2/2/20] INTEGER,
   [2/3/20] INTEGER,
   [2/4/20] INTEGER,
   [2/5/20] INTEGER,
   [2/6/20] INTEGER,
   [2/7/20] INTEGER,
   [2/8/20] INTEGER,
   [2/9/20] INTEGER,
   [2/10/20] INTEGER,
   [2/11/20] INTEGER,
   [2/12/20] INTEGER,
   [2/13/20] INTEGER,
   [2/14/20] INTEGER,
   [2/15/20] INTEGER,
   [2/16/20] INTEGER,
   [2/17/20] INTEGER,
   [2/18/20] INTEGER,
   [2/19/20] INTEGER,
   [2/20/20] INTEGER,
   [2/21/20] INTEGER,
   [2/22/20] INTEGER,
   [2/23/20] INTEGER,
   [2/24/20] INTEGER,
   [2/25/20] INTEGER,
   [2/26/20] INTEGER,
   [2/27/20] INTEGER,
   [2/28/20] INTEGER,
   [2/29/20] INTEGER,
   [3/1/20] INTEGER,
   [3/2/20] INTEGER,
   [3/3/20] INTEGER,
   [3/4/20] INTEGER,
   [3/5/20] INTEGER,
   [3/6/20] INTEGER,
   [3/7/20] INTEGER,
   [3/8/20] INTEGER,
   [3/9/20] INTEGER,
   [3/10/20] INTEGER,
   [3/11/20] INTEGER,
   [3/12/20] INTEGER,
   [3/13/20] INTEGER,
   [3/14/20] INTEGER,
   [3/15/20] INTEGER,
   [3/16/20] INTEGER,
   [3/17/20] INTEGER,
   [3/18/20] INTEGER,
   [3/19/20] INTEGER,
   [3/20/20] INTEGER,
   [3/21/20] INTEGER,
   [3/22/20] INTEGER,
   [3/23/20] INTEGER,
   [3/24/20] INTEGER,
   [3/25/20] INTEGER,
   [3/26/20] INTEGER,
   [3/27/20] INTEGER,
   [3/28/20] INTEGER,
   [3/29/20] INTEGER,
   [3/30/20] INTEGER,
   [3/31/20] INTEGER,
   [4/1/20] INTEGER,
   [4/2/20] INTEGER,
   [4/3/20] INTEGER,
   [4/4/20] INTEGER,
   [4/5/20] INTEGER,
   [4/6/20] INTEGER,
   [4/7/20] INTEGER,
   [4/8/20] INTEGER,
   [4/9/20] INTEGER,
   [4/10/20] INTEGER,
   [4/11/20] INTEGER,
   [4/12/20] INTEGER,
   [4/13/20] INTEGER,
   [4/14/20] INTEGER,
   [4/15/20] INTEGER,
   [4/16/20] INTEGER,
   [4/17/20] INTEGER,
   [4/18/20] INTEGER,
   [4/19/20] INTEGER,
   [4/20/20] INTEGER,
   [4/21/20] INTEGER,
   [4/22/20] INTEGER,
   [4/23/20] INTEGER,
   [4/24/20] INTEGER,
   [4/25/20] INTEGER,
   [4/26/20] INTEGER,
   [4/27/20] INTEGER,
   [4/28/20] INTEGER,
   [4/29/20] INTEGER,
   [4/30/20] INTEGER,
   [5/1/20] INTEGER,
   [5/2/20] INTEGER,
   [5/3/20] INTEGER,
   [5/4/20] INTEGER,
   [5/5/20] INTEGER,
   [5/6/20] INTEGER,
   [5/7/20] INTEGER,
   [5/8/20] INTEGER,
   [5/9/20] INTEGER,
   [5/10/20] INTEGER,
   [5/11/20] INTEGER,
   [5/12/20] INTEGER,
   [5/13/20] INTEGER,
   [5/14/20] INTEGER,
   [5/15/20] INTEGER,
   [5/16/20] INTEGER,
   [5/17/20] INTEGER,
   [5/18/20] INTEGER,
   [5/19/20] INTEGER,
   [5/20/20] INTEGER,
   [5/21/20] INTEGER,
   [5/22/20] INTEGER,
   [5/23/20] INTEGER,
   [5/24/20] INTEGER,
   [5/25/20] INTEGER,
   [5/26/20] INTEGER,
   [5/27/20] INTEGER,
   [5/28/20] INTEGER,
   [5/29/20] INTEGER,
   [5/30/20] INTEGER,
   [5/31/20] INTEGER,
   [6/1/20] INTEGER,
   [6/2/20] INTEGER,
   [6/3/20] INTEGER,
   [6/4/20] INTEGER,
   [6/5/20] INTEGER,
   [6/6/20] INTEGER,
   [6/7/20] INTEGER,
   [6/8/20] INTEGER,
   [6/9/20] INTEGER,
   [6/10/20] INTEGER,
   [6/11/20] INTEGER,
   [6/12/20] INTEGER,
   [6/13/20] INTEGER,
   [6/14/20] INTEGER,
   [6/15/20] INTEGER,
   [6/16/20] INTEGER,
   [6/17/20] INTEGER,
   [6/18/20] INTEGER,
   [6/19/20] INTEGER,
   [6/20/20] INTEGER,
   [6/21/20] INTEGER,
   [6/22/20] INTEGER,
   [6/23/20] INTEGER,
   [6/24/20] INTEGER,
   [6/25/20] INTEGER,
   [6/26/20] INTEGER,
   [6/27/20] INTEGER,
   [6/28/20] INTEGER,
   [6/29/20] INTEGER,
   [6/30/20] INTEGER,
   [7/1/20] INTEGER,
   [7/2/20] INTEGER,
   [7/3/20] INTEGER,
   [7/4/20] INTEGER,
   [7/5/20] INTEGER,
   [7/6/20] INTEGER,
   [7/7/20] INTEGER,
   [7/8/20] INTEGER,
   [7/9/20] INTEGER,
   [7/10/20] INTEGER,
   [7/11/20] INTEGER,
   [7/12/20] INTEGER,
   [7/13/20] INTEGER,
   [7/14/20] INTEGER,
   [7/15/20] INTEGER,
   [7/16/20] INTEGER,
   [7/17/20] INTEGER,
   [7/18/20] INTEGER,
   [7/19/20] INTEGER,
   [7/20/20] INTEGER,
   [7/21/20] INTEGER,
   [7/22/20] INTEGER,
   [7/23/20] INTEGER,
   [7/24/20] INTEGER,
   [7/25/20] INTEGER,
   [7/26/20] INTEGER,
   [7/27/20] INTEGER,
   [7/28/20] INTEGER,
   [7/29/20] INTEGER,
   [7/30/20] INTEGER,
   [7/31/20] INTEGER,
   [8/1/20] INTEGER,
   [8/2/20] INTEGER,
   [8/3/20] INTEGER,
   [8/4/20] INTEGER,
   [8/5/20] INTEGER,
   [8/6/20] INTEGER,
   [8/7/20] INTEGER,
   [8/8/20] INTEGER,
   [8/9/20] INTEGER,
   [8/10/20] INTEGER,
   [8/11/20] INTEGER,
   [8/12/20] INTEGER,
   [8/13/20] INTEGER,
   [8/14/20] INTEGER,
   [8/15/20] INTEGER,
   [8/16/20] INTEGER,
   [8/17/20] INTEGER,
   [8/18/20] INTEGER,
   [8/19/20] INTEGER,
   [8/20/20] INTEGER,
   [8/21/20] INTEGER,
   [8/22/20] INTEGER,
   [8/23/20] INTEGER,
   [8/24/20] INTEGER,
   [8/25/20] INTEGER,
   [8/26/20] INTEGER,
   [8/27/20] INTEGER,
   [8/28/20] INTEGER,
   [8/29/20] INTEGER,
   [8/30/20] INTEGER,
   [8/31/20] INTEGER,
   [9/1/20] INTEGER,
   [9/2/20] INTEGER,
   [9/3/20] INTEGER,
   [9/4/20] INTEGER,
   [9/5/20] INTEGER,
   [9/6/20] INTEGER,
   [9/7/20] INTEGER,
   [9/8/20] INTEGER,
   [9/9/20] INTEGER,
   [9/10/20] INTEGER,
   [9/11/20] INTEGER,
   [9/12/20] INTEGER,
   [9/13/20] INTEGER,
   [9/14/20] INTEGER,
   [9/15/20] INTEGER,
   [9/16/20] INTEGER,
   [9/17/20] INTEGER,
   [9/18/20] INTEGER,
   [9/19/20] INTEGER,
   [9/20/20] INTEGER,
   [9/21/20] INTEGER,
   [9/22/20] INTEGER,
   [9/23/20] INTEGER,
   [9/24/20] INTEGER,
   [9/25/20] INTEGER,
   [9/26/20] INTEGER,
   [9/27/20] INTEGER,
   [9/28/20] INTEGER,
   [9/29/20] INTEGER,
   [9/30/20] INTEGER,
   [10/1/20] INTEGER,
   [10/2/20] INTEGER,
   [10/3/20] INTEGER,
   [10/4/20] INTEGER,
   [10/5/20] INTEGER,
   [10/6/20] INTEGER,
   [10/7/20] INTEGER,
   [10/8/20] INTEGER,
   [10/9/20] INTEGER,
   [10/10/20] INTEGER,
   [10/11/20] INTEGER,
   [10/12/20] INTEGER,
   [10/13/20] INTEGER,
   [10/14/20] INTEGER,
   [10/15/20] INTEGER,
   [10/16/20] INTEGER,
   [10/17/20] INTEGER,
   [10/18/20] INTEGER,
   [10/19/20] INTEGER,
   [10/20/20] INTEGER,
   [10/21/20] INTEGER,
   [10/22/20] INTEGER,
   [10/23/20] INTEGER,
   [10/24/20] INTEGER,
   [10/25/20] INTEGER,
   [10/26/20] INTEGER,
   [10/27/20] INTEGER,
   [10/28/20] INTEGER,
   [10/29/20] INTEGER,
   [10/30/20] INTEGER,
   [10/31/20] INTEGER,
   [11/1/20] INTEGER,
   [11/2/20] INTEGER,
   [11/3/20] INTEGER,
   [11/4/20] INTEGER,
   [11/5/20] INTEGER,
   [11/6/20] INTEGER,
   [11/7/20] INTEGER,
   [11/8/20] INTEGER,
   [11/9/20] INTEGER,
   [11/10/20] INTEGER,
   [11/11/20] INTEGER,
   [11/12/20] INTEGER,
   [11/13/20] INTEGER,
   [11/14/20] INTEGER,
   [11/15/20] INTEGER,
   [11/16/20] INTEGER,
   [11/17/20] INTEGER,
   [11/18/20] INTEGER,
   [11/19/20] INTEGER,
   [11/20/20] INTEGER,
   [11/21/20] INTEGER,
   [11/22/20] INTEGER,
   [11/23/20] INTEGER,
   [11/24/20] INTEGER,
   [11/25/20] INTEGER,
   [11/26/20] INTEGER,
   [11/27/20] INTEGER,
   [11/28/20] INTEGER,
   [11/29/20] INTEGER,
   [11/30/20] INTEGER,
   [12/1/20] INTEGER,
   [12/2/20] INTEGER,
   [12/3/20] INTEGER,
   [12/4/20] INTEGER,
   [12/5/20] INTEGER,
   [12/6/20] INTEGER,
   [12/7/20] INTEGER,
   [12/8/20] INTEGER,
   [12/9/20] INTEGER,
   [12/10/20] INTEGER,
   [12/11/20] INTEGER,
   [12/12/20] INTEGER,
   [12/13/20] INTEGER,
   [12/14/20] INTEGER,
   [12/15/20] INTEGER,
   [12/16/20] INTEGER,
   [12/17/20] INTEGER,
   [12/18/20] INTEGER,
   [12/19/20] INTEGER,
   [12/20/20] INTEGER,
   [12/21/20] INTEGER,
   [12/22/20] INTEGER,
   [12/23/20] INTEGER,
   [12/24/20] INTEGER,
   [12/25/20] INTEGER,
   [12/26/20] INTEGER,
   [12/27/20] INTEGER,
   [12/28/20] INTEGER,
   [12/29/20] INTEGER,
   [12/30/20] INTEGER,
   [12/31/20] INTEGER,
   [1/1/21] INTEGER,
   [1/2/21] INTEGER,
   [1/3/21] INTEGER,
   [1/4/21] INTEGER,
   [1/5/21] INTEGER,
   [1/6/21] INTEGER,
   [1/7/21] INTEGER,
   [1/8/21] INTEGER,
   [1/9/21] INTEGER,
   [1/10/21] INTEGER,
   [1/11/21] INTEGER,
   [1/12/21] INTEGER,
   [1/13/21] INTEGER,
   [1/14/21] INTEGER,
   [1/15/21] INTEGER,
   [1/16/21] INTEGER,
   [1/17/21] INTEGER,
   [1/18/21] INTEGER,
   [1/19/21] INTEGER,
   [1/20/21] INTEGER,
   [1/21/21] INTEGER,
   [1/22/21] INTEGER,
   [1/23/21] INTEGER,
   [1/24/21] INTEGER,
   [1/25/21] INTEGER,
   [1/26/21] INTEGER,
   [1/27/21] INTEGER,
   [1/28/21] INTEGER,
   [1/29/21] INTEGER,
   [1/30/21] INTEGER,
   [1/31/21] INTEGER,
   [2/1/21] INTEGER,
   [2/2/21] INTEGER,
   [2/3/21] INTEGER,
   [2/4/21] INTEGER,
   [2/5/21] INTEGER,
   [2/6/21] INTEGER,
   [2/7/21] INTEGER,
   [2/8/21] INTEGER,
   [2/9/21] INTEGER,
   [2/10/21] INTEGER,
   [2/11/21] INTEGER,
   [2/12/21] INTEGER,
   [2/13/21] INTEGER,
   [2/14/21] INTEGER,
   [2/15/21] INTEGER,
   [2/16/21] INTEGER,
   [2/17/21] INTEGER,
   [2/18/21] INTEGER,
   [2/19/21] INTEGER,
   [2/20/21] INTEGER,
   [2/21/21] INTEGER,
   [2/22/21] INTEGER,
   [2/23/21] INTEGER,
   [2/24/21] INTEGER,
   [2/25/21] INTEGER,
   [2/26/21] INTEGER,
   [2/27/21] INTEGER,
   [2/28/21] INTEGER
);