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

139 rows where fips = 41067 sorted by date descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid	date ▲	county	state	fips	cases	deaths
336594	336594	2020-07-15	Washington	Oregon	41067	1995	21
333402	333402	2020-07-14	Washington	Oregon	41067	1946	21
330212	330212	2020-07-13	Washington	Oregon	41067	1892	21
327028	327028	2020-07-12	Washington	Oregon	41067	1847	21
323845	323845	2020-07-11	Washington	Oregon	41067	1815	20
320667	320667	2020-07-10	Washington	Oregon	41067	1764	20
317491	317491	2020-07-09	Washington	Oregon	41067	1720	20
314320	314320	2020-07-08	Washington	Oregon	41067	1676	20
311150	311150	2020-07-07	Washington	Oregon	41067	1645	20
307983	307983	2020-07-06	Washington	Oregon	41067	1620	20
304818	304818	2020-07-05	Washington	Oregon	41067	1586	20
301657	301657	2020-07-04	Washington	Oregon	41067	1534	20
298495	298495	2020-07-03	Washington	Oregon	41067	1491	20
295338	295338	2020-07-02	Washington	Oregon	41067	1446	20
292184	292184	2020-07-01	Washington	Oregon	41067	1379	20
289034	289034	2020-06-30	Washington	Oregon	41067	1331	20
285884	285884	2020-06-29	Washington	Oregon	41067	1315	20
282740	282740	2020-06-28	Washington	Oregon	41067	1287	20
279595	279595	2020-06-27	Washington	Oregon	41067	1258	20
276449	276449	2020-06-26	Washington	Oregon	41067	1252	20
273304	273304	2020-06-25	Washington	Oregon	41067	1175	20
270167	270167	2020-06-24	Washington	Oregon	41067	1151	20
267035	267035	2020-06-23	Washington	Oregon	41067	1120	20
263908	263908	2020-06-22	Washington	Oregon	41067	1078	20
260782	260782	2020-06-21	Washington	Oregon	41067	1051	20
257657	257657	2020-06-20	Washington	Oregon	41067	1029	20
254533	254533	2020-06-19	Washington	Oregon	41067	992	20
251420	251420	2020-06-18	Washington	Oregon	41067	975	20
248307	248307	2020-06-17	Washington	Oregon	41067	950	20
245196	245196	2020-06-16	Washington	Oregon	41067	928	20
242086	242086	2020-06-15	Washington	Oregon	41067	891	20
238979	238979	2020-06-14	Washington	Oregon	41067	876	20
235873	235873	2020-06-13	Washington	Oregon	41067	863	20
232770	232770	2020-06-12	Washington	Oregon	41067	849	19
229666	229666	2020-06-11	Washington	Oregon	41067	828	18
226564	226564	2020-06-10	Washington	Oregon	41067	821	18
223465	223465	2020-06-09	Washington	Oregon	41067	815	18
220372	220372	2020-06-08	Washington	Oregon	41067	800	18
217282	217282	2020-06-07	Washington	Oregon	41067	798	18
214194	214194	2020-06-06	Washington	Oregon	41067	790	18
211110	211110	2020-06-05	Washington	Oregon	41067	775	18
208030	208030	2020-06-04	Washington	Oregon	41067	755	18
204952	204952	2020-06-03	Washington	Oregon	41067	752	18
201878	201878	2020-06-02	Washington	Oregon	41067	747	18
198806	198806	2020-06-01	Washington	Oregon	41067	743	17
195736	195736	2020-05-31	Washington	Oregon	41067	739	17
192670	192670	2020-05-30	Washington	Oregon	41067	734	17
189608	189608	2020-05-29	Washington	Oregon	41067	722	17
186550	186550	2020-05-28	Washington	Oregon	41067	715	17
183496	183496	2020-05-27	Washington	Oregon	41067	703	17
180449	180449	2020-05-26	Washington	Oregon	41067	698	17
177409	177409	2020-05-25	Washington	Oregon	41067	695	17
174368	174368	2020-05-24	Washington	Oregon	41067	690	17
171329	171329	2020-05-23	Washington	Oregon	41067	673	17
168293	168293	2020-05-22	Washington	Oregon	41067	669	17
165260	165260	2020-05-21	Washington	Oregon	41067	659	17
162234	162234	2020-05-20	Washington	Oregon	41067	658	17
159210	159210	2020-05-19	Washington	Oregon	41067	644	15
156192	156192	2020-05-18	Washington	Oregon	41067	638	15
153178	153178	2020-05-17	Washington	Oregon	41067	628	15
150170	150170	2020-05-16	Washington	Oregon	41067	628	15
147166	147166	2020-05-15	Washington	Oregon	41067	620	15
144168	144168	2020-05-14	Washington	Oregon	41067	616	15
141175	141175	2020-05-13	Washington	Oregon	41067	614	14
138182	138182	2020-05-12	Washington	Oregon	41067	601	13
135195	135195	2020-05-11	Washington	Oregon	41067	587	13
132207	132207	2020-05-10	Washington	Oregon	41067	573	12
129221	129221	2020-05-09	Washington	Oregon	41067	562	12
126235	126235	2020-05-08	Washington	Oregon	41067	556	12
123255	123255	2020-05-07	Washington	Oregon	41067	548	12
120282	120282	2020-05-06	Washington	Oregon	41067	537	12
117324	117324	2020-05-05	Washington	Oregon	41067	531	12
114447	114447	2020-05-04	Washington	Oregon	41067	526	11
111569	111569	2020-05-03	Washington	Oregon	41067	516	11
108699	108699	2020-05-02	Washington	Oregon	41067	509	11
105836	105836	2020-05-01	Washington	Oregon	41067	500	11
102977	102977	2020-04-30	Washington	Oregon	41067	491	11
100128	100128	2020-04-29	Washington	Oregon	41067	481	11
97283	97283	2020-04-28	Washington	Oregon	41067	474	11
94447	94447	2020-04-27	Washington	Oregon	41067	475	11
91623	91623	2020-04-26	Washington	Oregon	41067	466	10
88810	88810	2020-04-25	Washington	Oregon	41067	459	10
85999	85999	2020-04-24	Washington	Oregon	41067	451	10
83198	83198	2020-04-23	Washington	Oregon	41067	443	10
80402	80402	2020-04-22	Washington	Oregon	41067	425	10
77615	77615	2020-04-21	Washington	Oregon	41067	415	10
74836	74836	2020-04-20	Washington	Oregon	41067	408	8
72064	72064	2020-04-19	Washington	Oregon	41067	399	8
69300	69300	2020-04-18	Washington	Oregon	41067	387	7
66545	66545	2020-04-17	Washington	Oregon	41067	383	7
63802	63802	2020-04-16	Washington	Oregon	41067	376	7
61079	61079	2020-04-15	Washington	Oregon	41067	364	7
58367	58367	2020-04-14	Washington	Oregon	41067	365	7
55667	55667	2020-04-13	Washington	Oregon	41067	360	7
52985	52985	2020-04-12	Washington	Oregon	41067	348	6
50315	50315	2020-04-11	Washington	Oregon	41067	330	6
47661	47661	2020-04-10	Washington	Oregon	41067	320	6
45047	45047	2020-04-09	Washington	Oregon	41067	311	6
42464	42464	2020-04-08	Washington	Oregon	41067	295	6
39907	39907	2020-04-07	Washington	Oregon	41067	282	6

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