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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
292294	292294	2020-07-03	Warren	Georgia	13301	25	0
292445	292445	2020-07-03	Warren	Illinois	17187	143	0
292539	292539	2020-07-03	Warren	Indiana	18171	15	1
292637	292637	2020-07-03	Warren	Iowa	19181	267	1
292855	292855	2020-07-03	Warren	Kentucky	21227	1583	15
293228	293228	2020-07-03	Warren	Mississippi	28149	496	18
293346	293346	2020-07-03	Warren	Missouri	29219	45	0
293519	293519	2020-07-03	Warren	New Jersey	34041	1257	161
293603	293603	2020-07-03	Warren	New York	36113	266	31
293701	293701	2020-07-03	Warren	North Carolina	37185	161	5
293842	293842	2020-07-03	Warren	Ohio	39165	814	21
294019	294019	2020-07-03	Warren	Pennsylvania	42123	7	1
294226	294226	2020-07-03	Warren	Tennessee	47177	72	0
294646	294646	2020-07-03	Warren	Virginia	51187	294	7
289217	289217	2020-07-02	Warren	Georgia	13301	23	0
289366	289366	2020-07-02	Warren	Illinois	17187	139	0
289460	289460	2020-07-02	Warren	Indiana	18171	15	1
289558	289558	2020-07-02	Warren	Iowa	19181	258	1
289776	289776	2020-07-02	Warren	Kentucky	21227	1563	15
290149	290149	2020-07-02	Warren	Mississippi	28149	463	17
290267	290267	2020-07-02	Warren	Missouri	29219	44	0
290438	290438	2020-07-02	Warren	New Jersey	34041	1254	160
290522	290522	2020-07-02	Warren	New York	36113	264	31
290620	290620	2020-07-02	Warren	North Carolina	37185	160	5
290762	290762	2020-07-02	Warren	Ohio	39165	757	21
290939	290939	2020-07-02	Warren	Pennsylvania	42123	7	1
291145	291145	2020-07-02	Warren	Tennessee	47177	69	0
291563	291563	2020-07-02	Warren	Virginia	51187	292	6
286142	286142	2020-07-01	Warren	Georgia	13301	23	0
286291	286291	2020-07-01	Warren	Illinois	17187	138	0
286385	286385	2020-07-01	Warren	Indiana	18171	15	1
286483	286483	2020-07-01	Warren	Iowa	19181	252	1
286701	286701	2020-07-01	Warren	Kentucky	21227	1547	14
287074	287074	2020-07-01	Warren	Mississippi	28149	443	17
287192	287192	2020-07-01	Warren	Missouri	29219	43	0
287362	287362	2020-07-01	Warren	New Jersey	34041	1252	159
287446	287446	2020-07-01	Warren	New York	36113	263	31
287544	287544	2020-07-01	Warren	North Carolina	37185	160	5
287685	287685	2020-07-01	Warren	Ohio	39165	757	21
287862	287862	2020-07-01	Warren	Pennsylvania	42123	7	0
288069	288069	2020-07-01	Warren	Tennessee	47177	65	0
288487	288487	2020-07-01	Warren	Virginia	51187	290	5
283069	283069	2020-06-30	Warren	Georgia	13301	22	0
283219	283219	2020-06-30	Warren	Illinois	17187	136	0
283313	283313	2020-06-30	Warren	Indiana	18171	15	1
283411	283411	2020-06-30	Warren	Iowa	19181	245	2
283629	283629	2020-06-30	Warren	Kentucky	21227	1533	14
284002	284002	2020-06-30	Warren	Mississippi	28149	425	17
284120	284120	2020-06-30	Warren	Missouri	29219	43	0
284289	284289	2020-06-30	Warren	New Jersey	34041	1244	158
284373	284373	2020-06-30	Warren	New York	36113	263	31
284471	284471	2020-06-30	Warren	North Carolina	37185	161	5
284612	284612	2020-06-30	Warren	Ohio	39165	738	21
284789	284789	2020-06-30	Warren	Pennsylvania	42123	6	0
284995	284995	2020-06-30	Warren	Tennessee	47177	62	0
285413	285413	2020-06-30	Warren	Virginia	51187	284	5
280000	280000	2020-06-29	Warren	Georgia	13301	20	0
280147	280147	2020-06-29	Warren	Illinois	17187	135	0
280241	280241	2020-06-29	Warren	Indiana	18171	15	1
280339	280339	2020-06-29	Warren	Iowa	19181	243	2
280557	280557	2020-06-29	Warren	Kentucky	21227	1514	14
280929	280929	2020-06-29	Warren	Mississippi	28149	409	17
281047	281047	2020-06-29	Warren	Missouri	29219	40	0
281216	281216	2020-06-29	Warren	New Jersey	34041	1241	156
281300	281300	2020-06-29	Warren	New York	36113	263	31
281398	281398	2020-06-29	Warren	North Carolina	37185	159	5
281539	281539	2020-06-29	Warren	Ohio	39165	731	20
281715	281715	2020-06-29	Warren	Pennsylvania	42123	5	0
281922	281922	2020-06-29	Warren	Tennessee	47177	58	0
282340	282340	2020-06-29	Warren	Virginia	51187	285	5
276932	276932	2020-06-28	Warren	Georgia	13301	19	0
277080	277080	2020-06-28	Warren	Illinois	17187	135	0
277174	277174	2020-06-28	Warren	Indiana	18171	15	1
277272	277272	2020-06-28	Warren	Iowa	19181	237	2
277488	277488	2020-06-28	Warren	Kentucky	21227	1491	14
277861	277861	2020-06-28	Warren	Mississippi	28149	398	17
277979	277979	2020-06-28	Warren	Missouri	29219	40	0
278148	278148	2020-06-28	Warren	New Jersey	34041	1239	156
278232	278232	2020-06-28	Warren	New York	36113	263	31
278330	278330	2020-06-28	Warren	North Carolina	37185	159	5
278471	278471	2020-06-28	Warren	Ohio	39165	725	20
278647	278647	2020-06-28	Warren	Pennsylvania	42123	5	0
278853	278853	2020-06-28	Warren	Tennessee	47177	55	0
279271	279271	2020-06-28	Warren	Virginia	51187	285	5
273863	273863	2020-06-27	Warren	Georgia	13301	19	0
274010	274010	2020-06-27	Warren	Illinois	17187	133	0
274104	274104	2020-06-27	Warren	Indiana	18171	15	1
274202	274202	2020-06-27	Warren	Iowa	19181	231	2
274418	274418	2020-06-27	Warren	Kentucky	21227	1481	14
274791	274791	2020-06-27	Warren	Mississippi	28149	392	17
274909	274909	2020-06-27	Warren	Missouri	29219	40	0
275079	275079	2020-06-27	Warren	New Jersey	34041	1238	156
275164	275164	2020-06-27	Warren	New York	36113	263	31
275262	275262	2020-06-27	Warren	North Carolina	37185	157	5
275403	275403	2020-06-27	Warren	Ohio	39165	708	20
275579	275579	2020-06-27	Warren	Pennsylvania	42123	5	0
275785	275785	2020-06-27	Warren	Tennessee	47177	55	0
276203	276203	2020-06-27	Warren	Virginia	51187	278	5
270794	270794	2020-06-26	Warren	Georgia	13301	19	0
270941	270941	2020-06-26	Warren	Illinois	17187	133	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
);