time_series_covid19_recovered_global

Table actions
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 1/25/20 = 32

✎ 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
57 57 Hubei China 30.9756 112.2707 28 28 31 32 42 45 80 88 90 141 168 295 386 522 633 817 1115 1439 1795 2222 2639 2686 3459 4774 5623 6639 7862 9128 10337 11788 11881 15299 15343 16748 18971 20969 23383 26403 28993 31536 33934 36208 38557 40592 42033 43500 45235 46488 47743 49134 50318 51553 52960 54288 55142 56003 56927 57682 58382 58946 59433 59879 60324 60811 61201 61732 62098 62570 62889 63153 63326 63471 63612 63762 63945 64014 64073 64142 64187 64236 64264 64281 64338 64363 64402 64435 63487 63494 63507 63511 63514 63519 63569 63593 63604 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63616 63617 63617 63618 63618 63618 63619 63619 63620 63620 63620 63620 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63623 63625 63625 63625 63625 63626 63626 63626 63626 63626 63626 63626 63626 63626 63626 63626 63626 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63627 63628 63628 63628 63628 63628 63628 63628 63628 63629 63629 63630 63630 63633 63633 63633 63633 63633 63633 63633 63633 63635 63635 63635 63636 63636 63636 63636 63636 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63637 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63638 63639 63639 63639 63639

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);