ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,409 rows where county = "Carroll" sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
316563	316563	2020-07-11	Carroll	Arkansas	5015	225	6
316853	316853	2020-07-11	Carroll	Georgia	13045	1024	40
317045	317045	2020-07-11	Carroll	Illinois	17015	20	2
317148	317148	2020-07-11	Carroll	Indiana	18015	114	2
317246	317246	2020-07-11	Carroll	Iowa	19027	113	1
317453	317453	2020-07-11	Carroll	Kentucky	21041	77	1
317641	317641	2020-07-11	Carroll	Maryland	24013	1212	115
317853	317853	2020-07-11	Carroll	Mississippi	28015	181	11
317944	317944	2020-07-11	Carroll	Missouri	29033	26	0
318182	318182	2020-07-11	Carroll	New Hampshire	33003	66	0
318465	318465	2020-07-11	Carroll	Ohio	39019	67	3
318848	318848	2020-07-11	Carroll	Tennessee	47017	52	1
319247	319247	2020-07-11	Carroll	Virginia	51035	245	9
313465	313465	2020-07-10	Carroll	Arkansas	5015	220	6
313755	313755	2020-07-10	Carroll	Georgia	13045	1008	40
313947	313947	2020-07-10	Carroll	Illinois	17015	21	2
314050	314050	2020-07-10	Carroll	Indiana	18015	113	2
314148	314148	2020-07-10	Carroll	Iowa	19027	110	1
314355	314355	2020-07-10	Carroll	Kentucky	21041	69	1
314543	314543	2020-07-10	Carroll	Maryland	24013	1202	115
314755	314755	2020-07-10	Carroll	Mississippi	28015	174	11
314846	314846	2020-07-10	Carroll	Missouri	29033	25	0
315083	315083	2020-07-10	Carroll	New Hampshire	33003	66	0
315365	315365	2020-07-10	Carroll	Ohio	39019	64	3
315747	315747	2020-07-10	Carroll	Tennessee	47017	52	1
316146	316146	2020-07-10	Carroll	Virginia	51035	244	9
310373	310373	2020-07-09	Carroll	Arkansas	5015	212	5
310663	310663	2020-07-09	Carroll	Georgia	13045	946	40
310855	310855	2020-07-09	Carroll	Illinois	17015	21	2
310958	310958	2020-07-09	Carroll	Indiana	18015	112	2
311056	311056	2020-07-09	Carroll	Iowa	19027	104	1
311261	311261	2020-07-09	Carroll	Kentucky	21041	65	1
311449	311449	2020-07-09	Carroll	Maryland	24013	1192	114
311661	311661	2020-07-09	Carroll	Mississippi	28015	173	11
311752	311752	2020-07-09	Carroll	Missouri	29033	25	0
311988	311988	2020-07-09	Carroll	New Hampshire	33003	65	0
312269	312269	2020-07-09	Carroll	Ohio	39019	60	3
312650	312650	2020-07-09	Carroll	Tennessee	47017	51	1
313048	313048	2020-07-09	Carroll	Virginia	51035	241	9
307278	307278	2020-07-08	Carroll	Arkansas	5015	200	5
307568	307568	2020-07-08	Carroll	Georgia	13045	916	40
307761	307761	2020-07-08	Carroll	Illinois	17015	21	2
307864	307864	2020-07-08	Carroll	Indiana	18015	110	2
307962	307962	2020-07-08	Carroll	Iowa	19027	104	1
308167	308167	2020-07-08	Carroll	Kentucky	21041	63	1
308355	308355	2020-07-08	Carroll	Maryland	24013	1190	114
308567	308567	2020-07-08	Carroll	Mississippi	28015	171	11
308658	308658	2020-07-08	Carroll	Missouri	29033	20	0
308894	308894	2020-07-08	Carroll	New Hampshire	33003	64	0
309177	309177	2020-07-08	Carroll	Ohio	39019	60	3
309558	309558	2020-07-08	Carroll	Tennessee	47017	49	1
309956	309956	2020-07-08	Carroll	Virginia	51035	239	9
304188	304188	2020-07-07	Carroll	Arkansas	5015	197	5
304478	304478	2020-07-07	Carroll	Georgia	13045	881	40
304671	304671	2020-07-07	Carroll	Illinois	17015	21	2
304774	304774	2020-07-07	Carroll	Indiana	18015	110	2
304872	304872	2020-07-07	Carroll	Iowa	19027	99	1
305077	305077	2020-07-07	Carroll	Kentucky	21041	63	1
305265	305265	2020-07-07	Carroll	Maryland	24013	1184	114
305477	305477	2020-07-07	Carroll	Mississippi	28015	168	11
305568	305568	2020-07-07	Carroll	Missouri	29033	20	0
305803	305803	2020-07-07	Carroll	New Hampshire	33003	64	0
306085	306085	2020-07-07	Carroll	Ohio	39019	59	3
306464	306464	2020-07-07	Carroll	Tennessee	47017	49	1
306861	306861	2020-07-07	Carroll	Virginia	51035	235	9
301100	301100	2020-07-06	Carroll	Arkansas	5015	195	5
301390	301390	2020-07-06	Carroll	Georgia	13045	864	40
301583	301583	2020-07-06	Carroll	Illinois	17015	21	2
301686	301686	2020-07-06	Carroll	Indiana	18015	110	2
301784	301784	2020-07-06	Carroll	Iowa	19027	99	1
301989	301989	2020-07-06	Carroll	Kentucky	21041	61	1
302177	302177	2020-07-06	Carroll	Maryland	24013	1166	114
302389	302389	2020-07-06	Carroll	Mississippi	28015	166	11
302480	302480	2020-07-06	Carroll	Missouri	29033	19	0
302715	302715	2020-07-06	Carroll	New Hampshire	33003	63	0
302996	302996	2020-07-06	Carroll	Ohio	39019	59	3
303375	303375	2020-07-06	Carroll	Tennessee	47017	48	1
303772	303772	2020-07-06	Carroll	Virginia	51035	233	9
298016	298016	2020-07-05	Carroll	Arkansas	5015	190	5
298306	298306	2020-07-05	Carroll	Georgia	13045	846	40
298498	298498	2020-07-05	Carroll	Illinois	17015	21	2
298601	298601	2020-07-05	Carroll	Indiana	18015	110	2
298699	298699	2020-07-05	Carroll	Iowa	19027	99	1
298902	298902	2020-07-05	Carroll	Kentucky	21041	42	1
299090	299090	2020-07-05	Carroll	Maryland	24013	1160	114
299302	299302	2020-07-05	Carroll	Mississippi	28015	165	11
299393	299393	2020-07-05	Carroll	Missouri	29033	16	0
299628	299628	2020-07-05	Carroll	New Hampshire	33003	60	0
299909	299909	2020-07-05	Carroll	Ohio	39019	59	3
300287	300287	2020-07-05	Carroll	Tennessee	47017	47	1
300684	300684	2020-07-05	Carroll	Virginia	51035	232	9
294932	294932	2020-07-04	Carroll	Arkansas	5015	187	5
295222	295222	2020-07-04	Carroll	Georgia	13045	813	40
295414	295414	2020-07-04	Carroll	Illinois	17015	22	2
295517	295517	2020-07-04	Carroll	Indiana	18015	110	2
295615	295615	2020-07-04	Carroll	Iowa	19027	96	1
295818	295818	2020-07-04	Carroll	Kentucky	21041	42	1
296006	296006	2020-07-04	Carroll	Maryland	24013	1158	114
296218	296218	2020-07-04	Carroll	Mississippi	28015	164	11
296309	296309	2020-07-04	Carroll	Missouri	29033	16	0

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);