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

173 rows where fips = 53061 sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
319389	319389	2020-07-11	Snohomish	Washington	53061	4438	178
316288	316288	2020-07-10	Snohomish	Washington	53061	4438	178
313190	313190	2020-07-09	Snohomish	Washington	53061	4386	177
310098	310098	2020-07-08	Snohomish	Washington	53061	4339	177
307003	307003	2020-07-07	Snohomish	Washington	53061	4318	175
303914	303914	2020-07-06	Snohomish	Washington	53061	4273	175
300826	300826	2020-07-05	Snohomish	Washington	53061	4178	174
297742	297742	2020-07-04	Snohomish	Washington	53061	4143	172
294658	294658	2020-07-03	Snohomish	Washington	53061	4112	172
291576	291576	2020-07-02	Snohomish	Washington	53061	4112	170
288501	288501	2020-07-01	Snohomish	Washington	53061	4063	170
285428	285428	2020-06-30	Snohomish	Washington	53061	4018	170
282357	282357	2020-06-29	Snohomish	Washington	53061	3996	169
279290	279290	2020-06-28	Snohomish	Washington	53061	3903	167
276223	276223	2020-06-27	Snohomish	Washington	53061	3893	167
273155	273155	2020-06-26	Snohomish	Washington	53061	3893	166
270087	270087	2020-06-25	Snohomish	Washington	53061	3862	164
267027	267027	2020-06-24	Snohomish	Washington	53061	3833	164
263973	263973	2020-06-23	Snohomish	Washington	53061	3813	163
260923	260923	2020-06-22	Snohomish	Washington	53061	3747	163
257874	257874	2020-06-21	Snohomish	Washington	53061	3678	162
254827	254827	2020-06-20	Snohomish	Washington	53061	3678	162
251780	251780	2020-06-19	Snohomish	Washington	53061	3678	161
248741	248741	2020-06-18	Snohomish	Washington	53061	3656	159
245706	245706	2020-06-17	Snohomish	Washington	53061	3641	158
242674	242674	2020-06-16	Snohomish	Washington	53061	3614	157
239641	239641	2020-06-15	Snohomish	Washington	53061	3595	155
236610	236610	2020-06-14	Snohomish	Washington	53061	3566	155
233582	233582	2020-06-13	Snohomish	Washington	53061	3566	155
230555	230555	2020-06-12	Snohomish	Washington	53061	3566	155
227529	227529	2020-06-11	Snohomish	Washington	53061	3541	155
224505	224505	2020-06-10	Snohomish	Washington	53061	3532	154
221484	221484	2020-06-09	Snohomish	Washington	53061	3524	154
218468	218468	2020-06-08	Snohomish	Washington	53061	3504	152
215456	215456	2020-06-07	Snohomish	Washington	53061	3471	151
212446	212446	2020-06-06	Snohomish	Washington	53061	3472	152
209439	209439	2020-06-05	Snohomish	Washington	53061	3471	151
206434	206434	2020-06-04	Snohomish	Washington	53061	3442	152
203433	203433	2020-06-03	Snohomish	Washington	53061	3427	150
200435	200435	2020-06-02	Snohomish	Washington	53061	3412	149
197440	197440	2020-06-01	Snohomish	Washington	53061	3379	148
194448	194448	2020-05-31	Snohomish	Washington	53061	3349	147
191459	191459	2020-05-30	Snohomish	Washington	53061	3341	147
188474	188474	2020-05-29	Snohomish	Washington	53061	3341	147
185491	185491	2020-05-28	Snohomish	Washington	53061	3323	147
182514	182514	2020-05-27	Snohomish	Washington	53061	3318	145
179543	179543	2020-05-26	Snohomish	Washington	53061	3297	143
176579	176579	2020-05-25	Snohomish	Washington	53061	3249	135
173614	173614	2020-05-24	Snohomish	Washington	53061	3240	134
170651	170651	2020-05-23	Snohomish	Washington	53061	3212	134
167690	167690	2020-05-22	Snohomish	Washington	53061	3212	134
164734	164734	2020-05-21	Snohomish	Washington	53061	3198	132
161785	161785	2020-05-20	Snohomish	Washington	53061	3162	131
158837	158837	2020-05-19	Snohomish	Washington	53061	3153	131
155893	155893	2020-05-18	Snohomish	Washington	53061	3125	125
152956	152956	2020-05-17	Snohomish	Washington	53061	3082	125
150025	150025	2020-05-16	Snohomish	Washington	53061	3071	125
147096	147096	2020-05-15	Snohomish	Washington	53061	3065	125
144172	144172	2020-05-14	Snohomish	Washington	53061	3048	121
141254	141254	2020-05-13	Snohomish	Washington	53061	3009	119
138337	138337	2020-05-12	Snohomish	Washington	53061	2998	119
135425	135425	2020-05-11	Snohomish	Washington	53061	2970	118
132514	132514	2020-05-10	Snohomish	Washington	53061	2932	116
129603	129603	2020-05-09	Snohomish	Washington	53061	2917	114
126692	126692	2020-05-08	Snohomish	Washington	53061	2917	114
123786	123786	2020-05-07	Snohomish	Washington	53061	2889	114
120885	120885	2020-05-06	Snohomish	Washington	53061	2830	112
118000	118000	2020-05-05	Snohomish	Washington	53061	2807	110
115120	115120	2020-05-04	Snohomish	Washington	53061	2784	110
112241	112241	2020-05-03	Snohomish	Washington	53061	2737	108
109371	109371	2020-05-02	Snohomish	Washington	53061	2492	108
106506	106506	2020-05-01	Snohomish	Washington	53061	2466	108
103646	103646	2020-04-30	Snohomish	Washington	53061	2446	108
100795	100795	2020-04-29	Snohomish	Washington	53061	2416	106
97949	97949	2020-04-28	Snohomish	Washington	53061	2370	106
95108	95108	2020-04-27	Snohomish	Washington	53061	2355	106
92282	92282	2020-04-26	Snohomish	Washington	53061	2311	104
89468	89468	2020-04-25	Snohomish	Washington	53061	2297	103
86656	86656	2020-04-24	Snohomish	Washington	53061	2267	102
83852	83852	2020-04-23	Snohomish	Washington	53061	2239	99
81054	81054	2020-04-22	Snohomish	Washington	53061	2208	98
78264	78264	2020-04-21	Snohomish	Washington	53061	2162	98
75484	75484	2020-04-20	Snohomish	Washington	53061	2162	96
72711	72711	2020-04-19	Snohomish	Washington	53061	2142	92
69944	69944	2020-04-18	Snohomish	Washington	53061	2092	92
67185	67185	2020-04-17	Snohomish	Washington	53061	2055	87
64440	64440	2020-04-16	Snohomish	Washington	53061	2031	85
61710	61710	2020-04-15	Snohomish	Washington	53061	1987	80
58994	58994	2020-04-14	Snohomish	Washington	53061	1949	77
56291	56291	2020-04-13	Snohomish	Washington	53061	1907	73
53604	53604	2020-04-12	Snohomish	Washington	53061	1866	69
50932	50932	2020-04-11	Snohomish	Washington	53061	1834	67
48277	48277	2020-04-10	Snohomish	Washington	53061	1801	66
45652	45652	2020-04-09	Snohomish	Washington	53061	1701	63
43059	43059	2020-04-08	Snohomish	Washington	53061	1694	61
40493	40493	2020-04-07	Snohomish	Washington	53061	1658	60
37961	37961	2020-04-06	Snohomish	Washington	53061	1602	57
35480	35480	2020-04-05	Snohomish	Washington	53061	1558	48
33042	33042	2020-04-04	Snohomish	Washington	53061	1502	44
30642	30642	2020-04-03	Snohomish	Washington	53061	1449	41

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