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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
334425	334425	2020-07-15	Monroe	Alabama	1099	292	4
334532	334532	2020-07-15	Monroe	Arkansas	5095	26	0
334737	334737	2020-07-15	Monroe	Florida	12087	670	6
334863	334863	2020-07-15	Monroe	Georgia	13207	261	20
335034	335034	2020-07-15	Monroe	Illinois	17133	171	13
335123	335123	2020-07-15	Monroe	Indiana	18105	387	30
335230	335230	2020-07-15	Monroe	Iowa	19135	54	7
335450	335450	2020-07-15	Monroe	Kentucky	21171	53	2
335664	335664	2020-07-15	Monroe	Michigan	26115	693	23
335825	335825	2020-07-15	Monroe	Mississippi	28095	491	39
335930	335930	2020-07-15	Monroe	Missouri	29137	7	0
336209	336209	2020-07-15	Monroe	New York	36055	4282	264
336452	336452	2020-07-15	Monroe	Ohio	39111	89	17
336640	336640	2020-07-15	Monroe	Pennsylvania	42089	1482	113
336919	336919	2020-07-15	Monroe	Tennessee	47123	162	6
337449	337449	2020-07-15	Monroe	West Virginia	54063	15	0
337514	337514	2020-07-15	Monroe	Wisconsin	55081	145	1
331234	331234	2020-07-14	Monroe	Alabama	1099	286	4
331341	331341	2020-07-14	Monroe	Arkansas	5095	27	0
331546	331546	2020-07-14	Monroe	Florida	12087	641	6
331672	331672	2020-07-14	Monroe	Georgia	13207	240	20
331843	331843	2020-07-14	Monroe	Illinois	17133	170	13
331932	331932	2020-07-14	Monroe	Indiana	18105	377	30
332039	332039	2020-07-14	Monroe	Iowa	19135	54	7
332259	332259	2020-07-14	Monroe	Kentucky	21171	53	2
332473	332473	2020-07-14	Monroe	Michigan	26115	673	23
332634	332634	2020-07-14	Monroe	Mississippi	28095	472	39
332739	332739	2020-07-14	Monroe	Missouri	29137	6	0
333017	333017	2020-07-14	Monroe	New York	36055	4248	264
333260	333260	2020-07-14	Monroe	Ohio	39111	89	17
333448	333448	2020-07-14	Monroe	Pennsylvania	42089	1474	111
333727	333727	2020-07-14	Monroe	Tennessee	47123	156	6
334256	334256	2020-07-14	Monroe	West Virginia	54063	15	0
334321	334321	2020-07-14	Monroe	Wisconsin	55081	139	1
328050	328050	2020-07-13	Monroe	Alabama	1099	275	4
328157	328157	2020-07-13	Monroe	Arkansas	5095	22	0
328361	328361	2020-07-13	Monroe	Florida	12087	611	6
328487	328487	2020-07-13	Monroe	Georgia	13207	232	19
328658	328658	2020-07-13	Monroe	Illinois	17133	165	13
328747	328747	2020-07-13	Monroe	Indiana	18105	363	30
328854	328854	2020-07-13	Monroe	Iowa	19135	52	7
329074	329074	2020-07-13	Monroe	Kentucky	21171	50	2
329288	329288	2020-07-13	Monroe	Michigan	26115	671	21
329449	329449	2020-07-13	Monroe	Mississippi	28095	460	36
329554	329554	2020-07-13	Monroe	Missouri	29137	5	0
329829	329829	2020-07-13	Monroe	New York	36055	4201	264
330070	330070	2020-07-13	Monroe	Ohio	39111	89	17
330258	330258	2020-07-13	Monroe	Pennsylvania	42089	1473	111
330537	330537	2020-07-13	Monroe	Tennessee	47123	156	6
331065	331065	2020-07-13	Monroe	West Virginia	54063	15	0
331130	331130	2020-07-13	Monroe	Wisconsin	55081	137	1
324866	324866	2020-07-12	Monroe	Alabama	1099	264	4
324973	324973	2020-07-12	Monroe	Arkansas	5095	21	0
325177	325177	2020-07-12	Monroe	Florida	12087	572	6
325303	325303	2020-07-12	Monroe	Georgia	13207	225	19
325474	325474	2020-07-12	Monroe	Illinois	17133	159	13
325563	325563	2020-07-12	Monroe	Indiana	18105	350	30
325670	325670	2020-07-12	Monroe	Iowa	19135	52	7
325890	325890	2020-07-12	Monroe	Kentucky	21171	50	2
326104	326104	2020-07-12	Monroe	Michigan	26115	661	21
326265	326265	2020-07-12	Monroe	Mississippi	28095	461	35
326370	326370	2020-07-12	Monroe	Missouri	29137	5	0
326644	326644	2020-07-12	Monroe	New York	36055	4178	264
326885	326885	2020-07-12	Monroe	Ohio	39111	89	17
327074	327074	2020-07-12	Monroe	Pennsylvania	42089	1471	111
327353	327353	2020-07-12	Monroe	Tennessee	47123	155	6
327881	327881	2020-07-12	Monroe	West Virginia	54063	15	0
327946	327946	2020-07-12	Monroe	Wisconsin	55081	134	1
321687	321687	2020-07-11	Monroe	Alabama	1099	258	4
321794	321794	2020-07-11	Monroe	Arkansas	5095	20	0
321998	321998	2020-07-11	Monroe	Florida	12087	544	6
322124	322124	2020-07-11	Monroe	Georgia	13207	229	19
322295	322295	2020-07-11	Monroe	Illinois	17133	155	13
322384	322384	2020-07-11	Monroe	Indiana	18105	342	30
322491	322491	2020-07-11	Monroe	Iowa	19135	52	7
322709	322709	2020-07-11	Monroe	Kentucky	21171	48	2
322923	322923	2020-07-11	Monroe	Michigan	26115	659	21
323084	323084	2020-07-11	Monroe	Mississippi	28095	456	35
323189	323189	2020-07-11	Monroe	Missouri	29137	5	0
323462	323462	2020-07-11	Monroe	New York	36055	4154	263
323702	323702	2020-07-11	Monroe	Ohio	39111	89	17
323891	323891	2020-07-11	Monroe	Pennsylvania	42089	1470	111
324170	324170	2020-07-11	Monroe	Tennessee	47123	155	6
324697	324697	2020-07-11	Monroe	West Virginia	54063	15	0
324762	324762	2020-07-11	Monroe	Wisconsin	55081	130	1
318510	318510	2020-07-10	Monroe	Alabama	1099	257	4
318617	318617	2020-07-10	Monroe	Arkansas	5095	19	0
318821	318821	2020-07-10	Monroe	Florida	12087	470	6
318947	318947	2020-07-10	Monroe	Georgia	13207	229	19
319118	319118	2020-07-10	Monroe	Illinois	17133	150	13
319207	319207	2020-07-10	Monroe	Indiana	18105	331	30
319314	319314	2020-07-10	Monroe	Iowa	19135	51	7
319532	319532	2020-07-10	Monroe	Kentucky	21171	44	2
319746	319746	2020-07-10	Monroe	Michigan	26115	655	21
319907	319907	2020-07-10	Monroe	Mississippi	28095	439	35
320012	320012	2020-07-10	Monroe	Missouri	29137	5	0
320284	320284	2020-07-10	Monroe	New York	36055	4121	263
320524	320524	2020-07-10	Monroe	Ohio	39111	89	17
320713	320713	2020-07-10	Monroe	Pennsylvania	42089	1462	111
320991	320991	2020-07-10	Monroe	Tennessee	47123	152	6

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