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

131 rows where fips = 53063 sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
294685	294685	2020-07-03	Spokane	Washington	53063	1533	41
291602	291602	2020-07-02	Spokane	Washington	53063	1489	41
288526	288526	2020-07-01	Spokane	Washington	53063	1420	41
285452	285452	2020-06-30	Spokane	Washington	53063	1385	40
282379	282379	2020-06-29	Spokane	Washington	53063	1306	39
279310	279310	2020-06-28	Spokane	Washington	53063	1197	39
276242	276242	2020-06-27	Spokane	Washington	53063	1183	39
273173	273173	2020-06-26	Spokane	Washington	53063	1171	39
270104	270104	2020-06-25	Spokane	Washington	53063	1126	38
267044	267044	2020-06-24	Spokane	Washington	53063	1085	38
263989	263989	2020-06-23	Spokane	Washington	53063	1055	38
260938	260938	2020-06-22	Spokane	Washington	53063	1002	39
257889	257889	2020-06-21	Spokane	Washington	53063	978	38
254842	254842	2020-06-20	Spokane	Washington	53063	958	38
251795	251795	2020-06-19	Spokane	Washington	53063	940	37
248756	248756	2020-06-18	Spokane	Washington	53063	897	37
245721	245721	2020-06-17	Spokane	Washington	53063	881	37
242689	242689	2020-06-16	Spokane	Washington	53063	864	37
239656	239656	2020-06-15	Spokane	Washington	53063	846	37
236624	236624	2020-06-14	Spokane	Washington	53063	824	37
233596	233596	2020-06-13	Spokane	Washington	53063	808	37
230569	230569	2020-06-12	Spokane	Washington	53063	806	37
227543	227543	2020-06-11	Spokane	Washington	53063	796	37
224519	224519	2020-06-10	Spokane	Washington	53063	792	37
221498	221498	2020-06-09	Spokane	Washington	53063	778	37
218482	218482	2020-06-08	Spokane	Washington	53063	767	35
215470	215470	2020-06-07	Spokane	Washington	53063	740	35
212460	212460	2020-06-06	Spokane	Washington	53063	717	35
209453	209453	2020-06-05	Spokane	Washington	53063	711	35
206447	206447	2020-06-04	Spokane	Washington	53063	652	34
203446	203446	2020-06-03	Spokane	Washington	53063	633	34
200447	200447	2020-06-02	Spokane	Washington	53063	619	34
197451	197451	2020-06-01	Spokane	Washington	53063	606	33
194459	194459	2020-05-31	Spokane	Washington	53063	600	32
191470	191470	2020-05-30	Spokane	Washington	53063	586	32
188485	188485	2020-05-29	Spokane	Washington	53063	574	32
185502	185502	2020-05-28	Spokane	Washington	53063	544	31
182524	182524	2020-05-27	Spokane	Washington	53063	530	31
179551	179551	2020-05-26	Spokane	Washington	53063	507	31
176585	176585	2020-05-25	Spokane	Washington	53063	498	31
173619	173619	2020-05-24	Spokane	Washington	53063	481	31
170655	170655	2020-05-23	Spokane	Washington	53063	467	31
167693	167693	2020-05-22	Spokane	Washington	53063	454	31
164736	164736	2020-05-21	Spokane	Washington	53063	436	31
161786	161786	2020-05-20	Spokane	Washington	53063	423	31
158838	158838	2020-05-19	Spokane	Washington	53063	416	31
155894	155894	2020-05-18	Spokane	Washington	53063	412	30
152957	152957	2020-05-17	Spokane	Washington	53063	404	30
150026	150026	2020-05-16	Spokane	Washington	53063	400	30
147097	147097	2020-05-15	Spokane	Washington	53063	400	30
144173	144173	2020-05-14	Spokane	Washington	53063	398	30
141255	141255	2020-05-13	Spokane	Washington	53063	390	29
138338	138338	2020-05-12	Spokane	Washington	53063	390	29
135426	135426	2020-05-11	Spokane	Washington	53063	390	29
132515	132515	2020-05-10	Spokane	Washington	53063	386	28
129604	129604	2020-05-09	Spokane	Washington	53063	386	28
126693	126693	2020-05-08	Spokane	Washington	53063	386	28
123787	123787	2020-05-07	Spokane	Washington	53063	386	25
120886	120886	2020-05-06	Spokane	Washington	53063	384	23
118001	118001	2020-05-05	Spokane	Washington	53063	379	23
115121	115121	2020-05-04	Spokane	Washington	53063	378	22
112242	112242	2020-05-03	Spokane	Washington	53063	373	22
109372	109372	2020-05-02	Spokane	Washington	53063	371	22
106507	106507	2020-05-01	Spokane	Washington	53063	371	22
103647	103647	2020-04-30	Spokane	Washington	53063	366	22
100796	100796	2020-04-29	Spokane	Washington	53063	357	20
97950	97950	2020-04-28	Spokane	Washington	53063	354	20
95109	95109	2020-04-27	Spokane	Washington	53063	353	19
92283	92283	2020-04-26	Spokane	Washington	53063	351	19
89469	89469	2020-04-25	Spokane	Washington	53063	345	19
86657	86657	2020-04-24	Spokane	Washington	53063	330	19
83853	83853	2020-04-23	Spokane	Washington	53063	326	19
81055	81055	2020-04-22	Spokane	Washington	53063	321	19
78265	78265	2020-04-21	Spokane	Washington	53063	319	19
75485	75485	2020-04-20	Spokane	Washington	53063	317	17
72712	72712	2020-04-19	Spokane	Washington	53063	311	17
69945	69945	2020-04-18	Spokane	Washington	53063	306	17
67186	67186	2020-04-17	Spokane	Washington	53063	302	17
64441	64441	2020-04-16	Spokane	Washington	53063	297	17
61711	61711	2020-04-15	Spokane	Washington	53063	290	17
58995	58995	2020-04-14	Spokane	Washington	53063	282	17
56292	56292	2020-04-13	Spokane	Washington	53063	280	15
53605	53605	2020-04-12	Spokane	Washington	53063	278	14
50933	50933	2020-04-11	Spokane	Washington	53063	255	14
48278	48278	2020-04-10	Spokane	Washington	53063	255	14
45653	45653	2020-04-09	Spokane	Washington	53063	246	14
43060	43060	2020-04-08	Spokane	Washington	53063	231	13
40494	40494	2020-04-07	Spokane	Washington	53063	231	13
37962	37962	2020-04-06	Spokane	Washington	53063	226	12
35481	35481	2020-04-05	Spokane	Washington	53063	219	11
33043	33043	2020-04-04	Spokane	Washington	53063	209	10
30643	30643	2020-04-03	Spokane	Washington	53063	194	7
28290	28290	2020-04-02	Spokane	Washington	53063	186	5
25999	25999	2020-04-01	Spokane	Washington	53063	145	4
23781	23781	2020-03-31	Spokane	Washington	53063	140	4
21632	21632	2020-03-30	Spokane	Washington	53063	140	4
19565	19565	2020-03-29	Spokane	Washington	53063	140	4
17600	17600	2020-03-28	Spokane	Washington	53063	108	2
15720	15720	2020-03-27	Spokane	Washington	53063	86	1
13951	13951	2020-03-26	Spokane	Washington	53063	67	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
);