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

137 rows where fips = 6001 sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
334561	334561	2020-07-15	Alameda	California	6001	8499	154
331370	331370	2020-07-14	Alameda	California	6001	8342	152
328186	328186	2020-07-13	Alameda	California	6001	8077	148
325002	325002	2020-07-12	Alameda	California	6001	7866	148
321823	321823	2020-07-11	Alameda	California	6001	7746	148
318646	318646	2020-07-10	Alameda	California	6001	7506	147
315475	315475	2020-07-09	Alameda	California	6001	7428	146
312302	312302	2020-07-08	Alameda	California	6001	7266	142
309134	309134	2020-07-07	Alameda	California	6001	6991	140
305968	305968	2020-07-06	Alameda	California	6001	6908	140
302806	302806	2020-07-05	Alameda	California	6001	6876	140
299644	299644	2020-07-04	Alameda	California	6001	6577	140
296484	296484	2020-07-03	Alameda	California	6001	6493	140
293330	293330	2020-07-02	Alameda	California	6001	6405	138
290178	290178	2020-07-01	Alameda	California	6001	6177	136
287029	287029	2020-06-30	Alameda	California	6001	5985	135
283884	283884	2020-06-29	Alameda	California	6001	5783	133
280739	280739	2020-06-28	Alameda	California	6001	5691	133
277593	277593	2020-06-27	Alameda	California	6001	5523	130
274447	274447	2020-06-26	Alameda	California	6001	5514	130
271309	271309	2020-06-25	Alameda	California	6001	5403	128
268176	268176	2020-06-24	Alameda	California	6001	5296	122
265048	265048	2020-06-23	Alameda	California	6001	5161	121
261921	261921	2020-06-22	Alameda	California	6001	5028	120
258796	258796	2020-06-21	Alameda	California	6001	4826	119
255671	255671	2020-06-20	Alameda	California	6001	4826	118
252554	252554	2020-06-19	Alameda	California	6001	4723	118
249441	249441	2020-06-18	Alameda	California	6001	4659	117
246331	246331	2020-06-17	Alameda	California	6001	4554	116
243220	243220	2020-06-16	Alameda	California	6001	4502	112
240111	240111	2020-06-15	Alameda	California	6001	4394	112
237005	237005	2020-06-14	Alameda	California	6001	4341	112
233900	233900	2020-06-13	Alameda	California	6001	4237	110
230796	230796	2020-06-12	Alameda	California	6001	4237	110
227694	227694	2020-06-11	Alameda	California	6001	4140	110
224594	224594	2020-06-10	Alameda	California	6001	4054	110
221500	221500	2020-06-09	Alameda	California	6001	4006	110
218407	218407	2020-06-08	Alameda	California	6001	3966	104
215318	215318	2020-06-07	Alameda	California	6001	3895	104
212233	212233	2020-06-06	Alameda	California	6001	3826	104
209150	209150	2020-06-05	Alameda	California	6001	3746	104
206071	206071	2020-06-04	Alameda	California	6001	3662	104
202994	202994	2020-06-03	Alameda	California	6001	3569	104
199921	199921	2020-06-02	Alameda	California	6001	3536	104
196851	196851	2020-06-01	Alameda	California	6001	3491	104
193784	193784	2020-05-31	Alameda	California	6001	3411	103
190720	190720	2020-05-30	Alameda	California	6001	3310	103
187658	187658	2020-05-29	Alameda	California	6001	3216	102
184605	184605	2020-05-28	Alameda	California	6001	3118	97
181554	181554	2020-05-27	Alameda	California	6001	3070	97
178513	178513	2020-05-26	Alameda	California	6001	3007	93
175472	175472	2020-05-25	Alameda	California	6001	2895	93
172431	172431	2020-05-24	Alameda	California	6001	2868	93
169393	169393	2020-05-23	Alameda	California	6001	2788	92
166360	166360	2020-05-22	Alameda	California	6001	2729	90
163331	163331	2020-05-21	Alameda	California	6001	2630	90
160306	160306	2020-05-20	Alameda	California	6001	2581	88
157283	157283	2020-05-19	Alameda	California	6001	2543	88
154270	154270	2020-05-18	Alameda	California	6001	2478	85
151261	151261	2020-05-17	Alameda	California	6001	2413	85
148255	148255	2020-05-16	Alameda	California	6001	2372	85
145254	145254	2020-05-15	Alameda	California	6001	2321	84
142258	142258	2020-05-14	Alameda	California	6001	2202	80
139265	139265	2020-05-13	Alameda	California	6001	2199	80
136277	136277	2020-05-12	Alameda	California	6001	2154	75
133290	133290	2020-05-11	Alameda	California	6001	2122	75
130303	130303	2020-05-10	Alameda	California	6001	2085	75
127316	127316	2020-05-09	Alameda	California	6001	2044	72
124334	124334	2020-05-08	Alameda	California	6001	1982	70
121357	121357	2020-05-07	Alameda	California	6001	1938	69
118394	118394	2020-05-06	Alameda	California	6001	1884	69
115439	115439	2020-05-05	Alameda	California	6001	1830	66
112560	112560	2020-05-04	Alameda	California	6001	1797	65
109689	109689	2020-05-03	Alameda	California	6001	1770	63
106824	106824	2020-05-02	Alameda	California	6001	1726	63
103963	103963	2020-05-01	Alameda	California	6001	1657	63
101112	101112	2020-04-30	Alameda	California	6001	1624	63
98266	98266	2020-04-29	Alameda	California	6001	1589	59
95425	95425	2020-04-28	Alameda	California	6001	1554	59
92597	92597	2020-04-27	Alameda	California	6001	1519	56
89782	89782	2020-04-26	Alameda	California	6001	1489	52
86968	86968	2020-04-25	Alameda	California	6001	1458	52
84163	84163	2020-04-24	Alameda	California	6001	1422	48
81366	81366	2020-04-23	Alameda	California	6001	1350	48
78575	78575	2020-04-22	Alameda	California	6001	1260	43
75794	75794	2020-04-21	Alameda	California	6001	1260	43
73021	73021	2020-04-20	Alameda	California	6001	1212	42
70255	70255	2020-04-19	Alameda	California	6001	1185	42
67496	67496	2020-04-18	Alameda	California	6001	1135	41
64751	64751	2020-04-17	Alameda	California	6001	1084	40
62021	62021	2020-04-16	Alameda	California	6001	1069	40
59305	59305	2020-04-15	Alameda	California	6001	983	36
56600	56600	2020-04-14	Alameda	California	6001	908	23
53911	53911	2020-04-13	Alameda	California	6001	907	23
51235	51235	2020-04-12	Alameda	California	6001	864	23
48576	48576	2020-04-11	Alameda	California	6001	827	21
45949	45949	2020-04-10	Alameda	California	6001	766	20
43352	43352	2020-04-09	Alameda	California	6001	734	17
40783	40783	2020-04-08	Alameda	California	6001	695	16
38242	38242	2020-04-07	Alameda	California	6001	655	15

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