COVID_Johns_Hopkins_time_series

Data source: Big Local News · About: big-local-datasette

Custom SQL query returning 1 row (hide)

select 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] from time_series_covid19_recovered_global where "2/7/20" = :p0 order by [8/15/20] limit 101

Query parameters

This data as json, copyable, CSV

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
62	Jilin	China	43.6661	126.1923	0	0	0	0	0	0	0	0	1	1	1	1	1	1	2	4	4	4	12	13	18	22	24	25	26	30	34	36	37	43	45	52	54	60	63	65	67	73	75	78	83	83	86	88	90	90	90	91	91	91	91	91	91	91	92	92	92	92	92	92	92	92	92	92	92	92	92	92	92	92	92	92	92	92	92	92	92	93	93	95	96	96	96	96	96	96	97	97	97	97	97	98	99	99	99	99	99	99	99	101	102	102	103	103	103	103	104	104	105	105	105	108	108	108	108	113	122	123	123	123	123	128	128	128	128	128	133	136	142	144	144	147	147	148	149	150	151	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	153	154	154	154	154	154	154	154	154	154	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155	155