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,669 rows where county = "Marion" sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
291806	291806	2020-07-03	Marion	Alabama	1093	218	13
291913	291913	2020-07-03	Marion	Arkansas	5089	11	0
292117	292117	2020-07-03	Marion	Florida	12083	817	12
292240	292240	2020-07-03	Marion	Georgia	13197	86	2
292408	292408	2020-07-03	Marion	Illinois	17121	68	0
292502	292502	2020-07-03	Marion	Indiana	18097	11630	730
292608	292608	2020-07-03	Marion	Iowa	19125	68	0
292697	292697	2020-07-03	Marion	Kansas	20115	12	1
292816	292816	2020-07-03	Marion	Kentucky	21155	52	0
293199	293199	2020-07-03	Marion	Mississippi	28091	270	11
293299	293299	2020-07-03	Marion	Missouri	29127	25	0
293810	293810	2020-07-03	Marion	Ohio	39101	2730	38
293946	293946	2020-07-03	Marion	Oregon	41047	1595	47
294064	294064	2020-07-03	Marion	South Carolina	45067	234	8
294193	294193	2020-07-03	Marion	Tennessee	47115	71	4
294382	294382	2020-07-03	Marion	Texas	48315	28	1
294715	294715	2020-07-03	Marion	West Virginia	54049	66	2
288730	288730	2020-07-02	Marion	Alabama	1093	210	13
288836	288836	2020-07-02	Marion	Arkansas	5089	11	0
289040	289040	2020-07-02	Marion	Florida	12083	789	10
289163	289163	2020-07-02	Marion	Georgia	13197	83	2
289330	289330	2020-07-02	Marion	Illinois	17121	66	0
289423	289423	2020-07-02	Marion	Indiana	18097	11560	727
289529	289529	2020-07-02	Marion	Iowa	19125	68	0
289618	289618	2020-07-02	Marion	Kansas	20115	11	1
289737	289737	2020-07-02	Marion	Kentucky	21155	52	0
290120	290120	2020-07-02	Marion	Mississippi	28091	263	11
290220	290220	2020-07-02	Marion	Missouri	29127	20	0
290729	290729	2020-07-02	Marion	Ohio	39101	2731	38
290866	290866	2020-07-02	Marion	Oregon	41047	1564	47
290984	290984	2020-07-02	Marion	South Carolina	45067	214	7
291112	291112	2020-07-02	Marion	Tennessee	47115	67	4
291300	291300	2020-07-02	Marion	Texas	48315	28	1
291632	291632	2020-07-02	Marion	West Virginia	54049	63	2
285656	285656	2020-07-01	Marion	Alabama	1093	208	12
285761	285761	2020-07-01	Marion	Arkansas	5089	6	0
285965	285965	2020-07-01	Marion	Florida	12083	727	10
286088	286088	2020-07-01	Marion	Georgia	13197	82	2
286255	286255	2020-07-01	Marion	Illinois	17121	66	0
286348	286348	2020-07-01	Marion	Indiana	18097	11513	727
286454	286454	2020-07-01	Marion	Iowa	19125	67	0
286543	286543	2020-07-01	Marion	Kansas	20115	11	1
286662	286662	2020-07-01	Marion	Kentucky	21155	52	0
287045	287045	2020-07-01	Marion	Mississippi	28091	248	11
287145	287145	2020-07-01	Marion	Missouri	29127	19	0
287653	287653	2020-07-01	Marion	Ohio	39101	2731	38
287789	287789	2020-07-01	Marion	Oregon	41047	1539	47
287907	287907	2020-07-01	Marion	South Carolina	45067	212	7
288035	288035	2020-07-01	Marion	Tennessee	47115	67	4
288224	288224	2020-07-01	Marion	Texas	48315	28	1
288556	288556	2020-07-01	Marion	West Virginia	54049	61	2
282583	282583	2020-06-30	Marion	Alabama	1093	205	12
282688	282688	2020-06-30	Marion	Arkansas	5089	6	0
282892	282892	2020-06-30	Marion	Florida	12083	672	10
283015	283015	2020-06-30	Marion	Georgia	13197	79	2
283183	283183	2020-06-30	Marion	Illinois	17121	65	0
283276	283276	2020-06-30	Marion	Indiana	18097	11451	726
283382	283382	2020-06-30	Marion	Iowa	19125	67	0
283472	283472	2020-06-30	Marion	Kansas	20115	11	1
283591	283591	2020-06-30	Marion	Kentucky	21155	51	0
283973	283973	2020-06-30	Marion	Mississippi	28091	240	11
284073	284073	2020-06-30	Marion	Missouri	29127	17	0
284580	284580	2020-06-30	Marion	Ohio	39101	2726	38
284716	284716	2020-06-30	Marion	Oregon	41047	1514	46
284834	284834	2020-06-30	Marion	South Carolina	45067	208	7
284962	284962	2020-06-30	Marion	Tennessee	47115	64	4
285150	285150	2020-06-30	Marion	Texas	48315	26	1
285482	285482	2020-06-30	Marion	West Virginia	54049	59	2
279514	279514	2020-06-29	Marion	Alabama	1093	202	12
279619	279619	2020-06-29	Marion	Arkansas	5089	4	0
279823	279823	2020-06-29	Marion	Florida	12083	655	10
279946	279946	2020-06-29	Marion	Georgia	13197	78	2
280111	280111	2020-06-29	Marion	Illinois	17121	65	0
280204	280204	2020-06-29	Marion	Indiana	18097	11401	724
280310	280310	2020-06-29	Marion	Iowa	19125	64	0
280400	280400	2020-06-29	Marion	Kansas	20115	11	1
280519	280519	2020-06-29	Marion	Kentucky	21155	51	0
280900	280900	2020-06-29	Marion	Mississippi	28091	233	11
281000	281000	2020-06-29	Marion	Missouri	29127	16	0
281507	281507	2020-06-29	Marion	Ohio	39101	2724	37
281642	281642	2020-06-29	Marion	Oregon	41047	1489	43
281760	281760	2020-06-29	Marion	South Carolina	45067	193	7
281888	281888	2020-06-29	Marion	Tennessee	47115	61	4
282077	282077	2020-06-29	Marion	Texas	48315	26	1
282409	282409	2020-06-29	Marion	West Virginia	54049	55	2
276446	276446	2020-06-28	Marion	Alabama	1093	194	12
276551	276551	2020-06-28	Marion	Arkansas	5089	4	0
276755	276755	2020-06-28	Marion	Florida	12083	631	10
276878	276878	2020-06-28	Marion	Georgia	13197	78	2
277044	277044	2020-06-28	Marion	Illinois	17121	65	0
277137	277137	2020-06-28	Marion	Indiana	18097	11358	724
277243	277243	2020-06-28	Marion	Iowa	19125	60	0
277332	277332	2020-06-28	Marion	Kansas	20115	10	1
277450	277450	2020-06-28	Marion	Kentucky	21155	49	0
277832	277832	2020-06-28	Marion	Mississippi	28091	228	11
277932	277932	2020-06-28	Marion	Missouri	29127	16	0
278439	278439	2020-06-28	Marion	Ohio	39101	2721	37
278574	278574	2020-06-28	Marion	Oregon	41047	1475	41
278692	278692	2020-06-28	Marion	South Carolina	45067	191	7
278820	278820	2020-06-28	Marion	Tennessee	47115	57	4

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