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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
291904	291904	2020-07-03	Johnson	Arkansas	5071	253	0
292227	292227	2020-07-03	Johnson	Georgia	13167	100	2
292394	292394	2020-07-03	Johnson	Illinois	17087	21	0
292494	292494	2020-07-03	Johnson	Indiana	18081	1283	126
292597	292597	2020-07-03	Johnson	Iowa	19103	1243	8
292688	292688	2020-07-03	Johnson	Kansas	20091	2066	88
292799	292799	2020-07-03	Johnson	Kentucky	21115	10	0
293285	293285	2020-07-03	Johnson	Missouri	29101	151	0
293432	293432	2020-07-03	Johnson	Nebraska	31097	7	0
294183	294183	2020-07-03	Johnson	Tennessee	47091	39	0
294356	294356	2020-07-03	Johnson	Texas	48251	526	4
294829	294829	2020-07-03	Johnson	Wyoming	56019	20	1
288827	288827	2020-07-02	Johnson	Arkansas	5071	251	0
289150	289150	2020-07-02	Johnson	Georgia	13167	92	2
289316	289316	2020-07-02	Johnson	Illinois	17087	21	0
289415	289415	2020-07-02	Johnson	Indiana	18081	1272	126
289518	289518	2020-07-02	Johnson	Iowa	19103	1231	8
289609	289609	2020-07-02	Johnson	Kansas	20091	1870	88
289720	289720	2020-07-02	Johnson	Kentucky	21115	9	0
290206	290206	2020-07-02	Johnson	Missouri	29101	141	0
290352	290352	2020-07-02	Johnson	Nebraska	31097	7	0
291102	291102	2020-07-02	Johnson	Tennessee	47091	38	0
291275	291275	2020-07-02	Johnson	Texas	48251	478	4
291746	291746	2020-07-02	Johnson	Wyoming	56019	20	1
285752	285752	2020-07-01	Johnson	Arkansas	5071	236	0
286075	286075	2020-07-01	Johnson	Georgia	13167	90	2
286241	286241	2020-07-01	Johnson	Illinois	17087	20	0
286340	286340	2020-07-01	Johnson	Indiana	18081	1263	126
286443	286443	2020-07-01	Johnson	Iowa	19103	1186	8
286534	286534	2020-07-01	Johnson	Kansas	20091	1870	87
286645	286645	2020-07-01	Johnson	Kentucky	21115	9	0
287131	287131	2020-07-01	Johnson	Missouri	29101	124	0
287276	287276	2020-07-01	Johnson	Nebraska	31097	7	0
288025	288025	2020-07-01	Johnson	Tennessee	47091	37	0
288199	288199	2020-07-01	Johnson	Texas	48251	448	4
288670	288670	2020-07-01	Johnson	Wyoming	56019	20	1
282679	282679	2020-06-30	Johnson	Arkansas	5071	227	0
283002	283002	2020-06-30	Johnson	Georgia	13167	90	2
283169	283169	2020-06-30	Johnson	Illinois	17087	20	0
283268	283268	2020-06-30	Johnson	Indiana	18081	1260	126
283371	283371	2020-06-30	Johnson	Iowa	19103	1150	8
283462	283462	2020-06-30	Johnson	Kansas	20091	1722	86
283574	283574	2020-06-30	Johnson	Kentucky	21115	10	0
284059	284059	2020-06-30	Johnson	Missouri	29101	124	0
284203	284203	2020-06-30	Johnson	Nebraska	31097	7	0
284952	284952	2020-06-30	Johnson	Tennessee	47091	36	0
285125	285125	2020-06-30	Johnson	Texas	48251	436	4
285596	285596	2020-06-30	Johnson	Wyoming	56019	20	1
279610	279610	2020-06-29	Johnson	Arkansas	5071	211	0
279933	279933	2020-06-29	Johnson	Georgia	13167	88	2
280097	280097	2020-06-29	Johnson	Illinois	17087	20	0
280196	280196	2020-06-29	Johnson	Indiana	18081	1259	125
280299	280299	2020-06-29	Johnson	Iowa	19103	1119	8
280390	280390	2020-06-29	Johnson	Kansas	20091	1722	86
280502	280502	2020-06-29	Johnson	Kentucky	21115	10	0
280986	280986	2020-06-29	Johnson	Missouri	29101	120	0
281130	281130	2020-06-29	Johnson	Nebraska	31097	6	0
281878	281878	2020-06-29	Johnson	Tennessee	47091	35	0
282052	282052	2020-06-29	Johnson	Texas	48251	436	4
282523	282523	2020-06-29	Johnson	Wyoming	56019	20	1
276542	276542	2020-06-28	Johnson	Arkansas	5071	210	0
276865	276865	2020-06-28	Johnson	Georgia	13167	87	2
277030	277030	2020-06-28	Johnson	Illinois	17087	20	0
277129	277129	2020-06-28	Johnson	Indiana	18081	1255	125
277232	277232	2020-06-28	Johnson	Iowa	19103	1033	8
277323	277323	2020-06-28	Johnson	Kansas	20091	1613	86
277433	277433	2020-06-28	Johnson	Kentucky	21115	10	0
277918	277918	2020-06-28	Johnson	Missouri	29101	113	0
278062	278062	2020-06-28	Johnson	Nebraska	31097	6	0
278810	278810	2020-06-28	Johnson	Tennessee	47091	34	0
278983	278983	2020-06-28	Johnson	Texas	48251	372	4
279454	279454	2020-06-28	Johnson	Wyoming	56019	20	1
273473	273473	2020-06-27	Johnson	Arkansas	5071	207	0
273796	273796	2020-06-27	Johnson	Georgia	13167	85	2
273960	273960	2020-06-27	Johnson	Illinois	17087	20	0
274059	274059	2020-06-27	Johnson	Indiana	18081	1248	125
274162	274162	2020-06-27	Johnson	Iowa	19103	1016	8
274253	274253	2020-06-27	Johnson	Kansas	20091	1550	85
274363	274363	2020-06-27	Johnson	Kentucky	21115	10	0
274848	274848	2020-06-27	Johnson	Missouri	29101	112	0
274992	274992	2020-06-27	Johnson	Nebraska	31097	6	0
275742	275742	2020-06-27	Johnson	Tennessee	47091	34	0
275915	275915	2020-06-27	Johnson	Texas	48251	372	4
276386	276386	2020-06-27	Johnson	Wyoming	56019	20	1
270404	270404	2020-06-26	Johnson	Arkansas	5071	188	0
270727	270727	2020-06-26	Johnson	Georgia	13167	84	2
270891	270891	2020-06-26	Johnson	Illinois	17087	20	0
270990	270990	2020-06-26	Johnson	Indiana	18081	1240	125
271093	271093	2020-06-26	Johnson	Iowa	19103	964	8
271184	271184	2020-06-26	Johnson	Kansas	20091	1545	83
271294	271294	2020-06-26	Johnson	Kentucky	21115	10	0
271779	271779	2020-06-26	Johnson	Missouri	29101	101	0
271923	271923	2020-06-26	Johnson	Nebraska	31097	6	0
272673	272673	2020-06-26	Johnson	Tennessee	47091	30	0
272846	272846	2020-06-26	Johnson	Texas	48251	328	4
273317	273317	2020-06-26	Johnson	Wyoming	56019	20	1
267343	267343	2020-06-25	Johnson	Arkansas	5071	175	0
267666	267666	2020-06-25	Johnson	Georgia	13167	84	2
267828	267828	2020-06-25	Johnson	Illinois	17087	20	0
267927	267927	2020-06-25	Johnson	Indiana	18081	1233	125

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