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

2,425 rows where county = "Lincoln" sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
316595	316595	2020-07-11	Lincoln	Arkansas	5079	1048	11
316724	316724	2020-07-11	Lincoln	Colorado	8073	4	0
316921	316921	2020-07-11	Lincoln	Georgia	13181	62	2
317025	317025	2020-07-11	Lincoln	Idaho	16063	43	0
317383	317383	2020-07-11	Lincoln	Kansas	20105	1	0
317501	317501	2020-07-11	Lincoln	Kentucky	21137	51	1
317583	317583	2020-07-11	Lincoln	Louisiana	22061	432	19
317625	317625	2020-07-11	Lincoln	Maine	23015	26	0
317798	317798	2020-07-11	Lincoln	Minnesota	27081	17	0
317888	317888	2020-07-11	Lincoln	Mississippi	28085	529	35
317986	317986	2020-07-11	Lincoln	Missouri	29113	112	1
318064	318064	2020-07-11	Lincoln	Montana	30053	13	1
318131	318131	2020-07-11	Lincoln	Nebraska	31111	66	2
318173	318173	2020-07-11	Lincoln	Nevada	32017	2	0
318227	318227	2020-07-11	Lincoln	New Mexico	35027	22	0
318359	318359	2020-07-11	Lincoln	North Carolina	37109	390	2
318584	318584	2020-07-11	Lincoln	Oklahoma	40081	43	2
318641	318641	2020-07-11	Lincoln	Oregon	41041	361	5
318815	318815	2020-07-11	Lincoln	South Dakota	46083	390	1
318891	318891	2020-07-11	Lincoln	Tennessee	47103	86	0
319380	319380	2020-07-11	Lincoln	Washington	53043	4	0
319418	319418	2020-07-11	Lincoln	West Virginia	54043	9	0
319486	319486	2020-07-11	Lincoln	Wisconsin	55069	21	0
319536	319536	2020-07-11	Lincoln	Wyoming	56023	41	0
313497	313497	2020-07-10	Lincoln	Arkansas	5079	1048	11
313626	313626	2020-07-10	Lincoln	Colorado	8073	4	0
313823	313823	2020-07-10	Lincoln	Georgia	13181	59	1
313927	313927	2020-07-10	Lincoln	Idaho	16063	40	0
314285	314285	2020-07-10	Lincoln	Kansas	20105	1	0
314403	314403	2020-07-10	Lincoln	Kentucky	21137	48	1
314485	314485	2020-07-10	Lincoln	Louisiana	22061	401	19
314527	314527	2020-07-10	Lincoln	Maine	23015	26	0
314700	314700	2020-07-10	Lincoln	Minnesota	27081	13	0
314790	314790	2020-07-10	Lincoln	Mississippi	28085	519	35
314888	314888	2020-07-10	Lincoln	Missouri	29113	110	1
314966	314966	2020-07-10	Lincoln	Montana	30053	12	1
315033	315033	2020-07-10	Lincoln	Nebraska	31111	66	2
315074	315074	2020-07-10	Lincoln	Nevada	32017	2	0
315128	315128	2020-07-10	Lincoln	New Mexico	35027	19	0
315259	315259	2020-07-10	Lincoln	North Carolina	37109	360	2
315484	315484	2020-07-10	Lincoln	Oklahoma	40081	41	2
315541	315541	2020-07-10	Lincoln	Oregon	41041	362	5
315715	315715	2020-07-10	Lincoln	South Dakota	46083	384	1
315790	315790	2020-07-10	Lincoln	Tennessee	47103	84	0
316279	316279	2020-07-10	Lincoln	Washington	53043	4	0
316317	316317	2020-07-10	Lincoln	West Virginia	54043	10	0
316385	316385	2020-07-10	Lincoln	Wisconsin	55069	20	0
316435	316435	2020-07-10	Lincoln	Wyoming	56023	41	0
310405	310405	2020-07-09	Lincoln	Arkansas	5079	1046	11
310534	310534	2020-07-09	Lincoln	Colorado	8073	4	0
310731	310731	2020-07-09	Lincoln	Georgia	13181	56	1
310835	310835	2020-07-09	Lincoln	Idaho	16063	40	0
311309	311309	2020-07-09	Lincoln	Kentucky	21137	42	1
311391	311391	2020-07-09	Lincoln	Louisiana	22061	383	19
311433	311433	2020-07-09	Lincoln	Maine	23015	26	0
311606	311606	2020-07-09	Lincoln	Minnesota	27081	11	0
311696	311696	2020-07-09	Lincoln	Mississippi	28085	509	35
311794	311794	2020-07-09	Lincoln	Missouri	29113	110	1
311872	311872	2020-07-09	Lincoln	Montana	30053	11	1
311939	311939	2020-07-09	Lincoln	Nebraska	31111	65	2
311979	311979	2020-07-09	Lincoln	Nevada	32017	2	0
312033	312033	2020-07-09	Lincoln	New Mexico	35027	18	0
312163	312163	2020-07-09	Lincoln	North Carolina	37109	347	2
312388	312388	2020-07-09	Lincoln	Oklahoma	40081	40	2
312444	312444	2020-07-09	Lincoln	Oregon	41041	363	4
312618	312618	2020-07-09	Lincoln	South Dakota	46083	381	1
312693	312693	2020-07-09	Lincoln	Tennessee	47103	80	0
313181	313181	2020-07-09	Lincoln	Washington	53043	4	0
313219	313219	2020-07-09	Lincoln	West Virginia	54043	10	0
313287	313287	2020-07-09	Lincoln	Wisconsin	55069	21	0
313337	313337	2020-07-09	Lincoln	Wyoming	56023	39	0
307310	307310	2020-07-08	Lincoln	Arkansas	5079	1044	11
307439	307439	2020-07-08	Lincoln	Colorado	8073	4	0
307636	307636	2020-07-08	Lincoln	Georgia	13181	53	1
307741	307741	2020-07-08	Lincoln	Idaho	16063	38	0
308215	308215	2020-07-08	Lincoln	Kentucky	21137	42	1
308297	308297	2020-07-08	Lincoln	Louisiana	22061	366	19
308339	308339	2020-07-08	Lincoln	Maine	23015	25	0
308512	308512	2020-07-08	Lincoln	Minnesota	27081	11	0
308602	308602	2020-07-08	Lincoln	Mississippi	28085	492	34
308700	308700	2020-07-08	Lincoln	Missouri	29113	106	1
308778	308778	2020-07-08	Lincoln	Montana	30053	9	1
308845	308845	2020-07-08	Lincoln	Nebraska	31111	63	2
308885	308885	2020-07-08	Lincoln	Nevada	32017	2	0
308939	308939	2020-07-08	Lincoln	New Mexico	35027	16	0
309069	309069	2020-07-08	Lincoln	North Carolina	37109	341	1
309296	309296	2020-07-08	Lincoln	Oklahoma	40081	38	2
309352	309352	2020-07-08	Lincoln	Oregon	41041	349	4
309526	309526	2020-07-08	Lincoln	South Dakota	46083	376	1
309601	309601	2020-07-08	Lincoln	Tennessee	47103	78	0
310089	310089	2020-07-08	Lincoln	Washington	53043	4	0
310127	310127	2020-07-08	Lincoln	West Virginia	54043	10	0
310195	310195	2020-07-08	Lincoln	Wisconsin	55069	18	0
310245	310245	2020-07-08	Lincoln	Wyoming	56023	37	0
304220	304220	2020-07-07	Lincoln	Arkansas	5079	1044	11
304349	304349	2020-07-07	Lincoln	Colorado	8073	4	0
304546	304546	2020-07-07	Lincoln	Georgia	13181	53	1
304651	304651	2020-07-07	Lincoln	Idaho	16063	37	0
305125	305125	2020-07-07	Lincoln	Kentucky	21137	39	1
305207	305207	2020-07-07	Lincoln	Louisiana	22061	354	19

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