ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
743 rows where fips = 27065 and state = "Minnesota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
105134 | 105134 | 2020-05-01 | Kanabec | Minnesota | 27065 | 1 | 0 |
107999 | 107999 | 2020-05-02 | Kanabec | Minnesota | 27065 | 1 | 0 |
110870 | 110870 | 2020-05-03 | Kanabec | Minnesota | 27065 | 1 | 0 |
113749 | 113749 | 2020-05-04 | Kanabec | Minnesota | 27065 | 1 | 0 |
116630 | 116630 | 2020-05-05 | Kanabec | Minnesota | 27065 | 2 | 0 |
119590 | 119590 | 2020-05-06 | Kanabec | Minnesota | 27065 | 2 | 0 |
122563 | 122563 | 2020-05-07 | Kanabec | Minnesota | 27065 | 4 | 0 |
125545 | 125545 | 2020-05-08 | Kanabec | Minnesota | 27065 | 5 | 0 |
128532 | 128532 | 2020-05-09 | Kanabec | Minnesota | 27065 | 9 | 0 |
131522 | 131522 | 2020-05-10 | Kanabec | Minnesota | 27065 | 9 | 0 |
134513 | 134513 | 2020-05-11 | Kanabec | Minnesota | 27065 | 10 | 0 |
137503 | 137503 | 2020-05-12 | Kanabec | Minnesota | 27065 | 10 | 0 |
140497 | 140497 | 2020-05-13 | Kanabec | Minnesota | 27065 | 10 | 0 |
143492 | 143492 | 2020-05-14 | Kanabec | Minnesota | 27065 | 10 | 0 |
146492 | 146492 | 2020-05-15 | Kanabec | Minnesota | 27065 | 9 | 0 |
149497 | 149497 | 2020-05-16 | Kanabec | Minnesota | 27065 | 9 | 0 |
152508 | 152508 | 2020-05-17 | Kanabec | Minnesota | 27065 | 9 | 0 |
155522 | 155522 | 2020-05-18 | Kanabec | Minnesota | 27065 | 9 | 0 |
158540 | 158540 | 2020-05-19 | Kanabec | Minnesota | 27065 | 9 | 1 |
161566 | 161566 | 2020-05-20 | Kanabec | Minnesota | 27065 | 9 | 1 |
164595 | 164595 | 2020-05-21 | Kanabec | Minnesota | 27065 | 10 | 1 |
167631 | 167631 | 2020-05-22 | Kanabec | Minnesota | 27065 | 11 | 1 |
170669 | 170669 | 2020-05-23 | Kanabec | Minnesota | 27065 | 11 | 1 |
173711 | 173711 | 2020-05-24 | Kanabec | Minnesota | 27065 | 11 | 1 |
176754 | 176754 | 2020-05-25 | Kanabec | Minnesota | 27065 | 11 | 1 |
179798 | 179798 | 2020-05-26 | Kanabec | Minnesota | 27065 | 11 | 1 |
182844 | 182844 | 2020-05-27 | Kanabec | Minnesota | 27065 | 11 | 1 |
185899 | 185899 | 2020-05-28 | Kanabec | Minnesota | 27065 | 11 | 1 |
188957 | 188957 | 2020-05-29 | Kanabec | Minnesota | 27065 | 11 | 1 |
192021 | 192021 | 2020-05-30 | Kanabec | Minnesota | 27065 | 11 | 1 |
195089 | 195089 | 2020-05-31 | Kanabec | Minnesota | 27065 | 11 | 1 |
198160 | 198160 | 2020-06-01 | Kanabec | Minnesota | 27065 | 11 | 1 |
201233 | 201233 | 2020-06-02 | Kanabec | Minnesota | 27065 | 12 | 1 |
204310 | 204310 | 2020-06-03 | Kanabec | Minnesota | 27065 | 12 | 1 |
207391 | 207391 | 2020-06-04 | Kanabec | Minnesota | 27065 | 12 | 1 |
210472 | 210472 | 2020-06-05 | Kanabec | Minnesota | 27065 | 12 | 1 |
213556 | 213556 | 2020-06-06 | Kanabec | Minnesota | 27065 | 12 | 1 |
216644 | 216644 | 2020-06-07 | Kanabec | Minnesota | 27065 | 12 | 1 |
219736 | 219736 | 2020-06-08 | Kanabec | Minnesota | 27065 | 12 | 1 |
222831 | 222831 | 2020-06-09 | Kanabec | Minnesota | 27065 | 12 | 1 |
225929 | 225929 | 2020-06-10 | Kanabec | Minnesota | 27065 | 12 | 1 |
229031 | 229031 | 2020-06-11 | Kanabec | Minnesota | 27065 | 13 | 1 |
232135 | 232135 | 2020-06-12 | Kanabec | Minnesota | 27065 | 13 | 1 |
235241 | 235241 | 2020-06-13 | Kanabec | Minnesota | 27065 | 13 | 1 |
238348 | 238348 | 2020-06-14 | Kanabec | Minnesota | 27065 | 13 | 1 |
241457 | 241457 | 2020-06-15 | Kanabec | Minnesota | 27065 | 13 | 1 |
244568 | 244568 | 2020-06-16 | Kanabec | Minnesota | 27065 | 13 | 1 |
247681 | 247681 | 2020-06-17 | Kanabec | Minnesota | 27065 | 13 | 1 |
250793 | 250793 | 2020-06-18 | Kanabec | Minnesota | 27065 | 13 | 1 |
253908 | 253908 | 2020-06-19 | Kanabec | Minnesota | 27065 | 13 | 1 |
257028 | 257028 | 2020-06-20 | Kanabec | Minnesota | 27065 | 13 | 1 |
260154 | 260154 | 2020-06-21 | Kanabec | Minnesota | 27065 | 13 | 1 |
263283 | 263283 | 2020-06-22 | Kanabec | Minnesota | 27065 | 13 | 1 |
266409 | 266409 | 2020-06-23 | Kanabec | Minnesota | 27065 | 13 | 1 |
269542 | 269542 | 2020-06-24 | Kanabec | Minnesota | 27065 | 13 | 1 |
272679 | 272679 | 2020-06-25 | Kanabec | Minnesota | 27065 | 13 | 1 |
275822 | 275822 | 2020-06-26 | Kanabec | Minnesota | 27065 | 13 | 1 |
278970 | 278970 | 2020-06-27 | Kanabec | Minnesota | 27065 | 13 | 1 |
282118 | 282118 | 2020-06-28 | Kanabec | Minnesota | 27065 | 13 | 1 |
285263 | 285263 | 2020-06-29 | Kanabec | Minnesota | 27065 | 14 | 1 |
288413 | 288413 | 2020-06-30 | Kanabec | Minnesota | 27065 | 14 | 1 |
291564 | 291564 | 2020-07-01 | Kanabec | Minnesota | 27065 | 14 | 1 |
294718 | 294718 | 2020-07-02 | Kanabec | Minnesota | 27065 | 14 | 1 |
297876 | 297876 | 2020-07-03 | Kanabec | Minnesota | 27065 | 14 | 1 |
301039 | 301039 | 2020-07-04 | Kanabec | Minnesota | 27065 | 14 | 1 |
304203 | 304203 | 2020-07-05 | Kanabec | Minnesota | 27065 | 14 | 1 |
307370 | 307370 | 2020-07-06 | Kanabec | Minnesota | 27065 | 14 | 1 |
310538 | 310538 | 2020-07-07 | Kanabec | Minnesota | 27065 | 15 | 1 |
313708 | 313708 | 2020-07-08 | Kanabec | Minnesota | 27065 | 15 | 1 |
316882 | 316882 | 2020-07-09 | Kanabec | Minnesota | 27065 | 16 | 1 |
320057 | 320057 | 2020-07-10 | Kanabec | Minnesota | 27065 | 16 | 1 |
323236 | 323236 | 2020-07-11 | Kanabec | Minnesota | 27065 | 17 | 1 |
326419 | 326419 | 2020-07-12 | Kanabec | Minnesota | 27065 | 17 | 1 |
329605 | 329605 | 2020-07-13 | Kanabec | Minnesota | 27065 | 18 | 1 |
332792 | 332792 | 2020-07-14 | Kanabec | Minnesota | 27065 | 18 | 1 |
335985 | 335985 | 2020-07-15 | Kanabec | Minnesota | 27065 | 18 | 1 |
339181 | 339181 | 2020-07-16 | Kanabec | Minnesota | 27065 | 18 | 1 |
342377 | 342377 | 2020-07-17 | Kanabec | Minnesota | 27065 | 19 | 1 |
345577 | 345577 | 2020-07-18 | Kanabec | Minnesota | 27065 | 19 | 1 |
348778 | 348778 | 2020-07-19 | Kanabec | Minnesota | 27065 | 19 | 1 |
351978 | 351978 | 2020-07-20 | Kanabec | Minnesota | 27065 | 19 | 1 |
355180 | 355180 | 2020-07-21 | Kanabec | Minnesota | 27065 | 19 | 1 |
358383 | 358383 | 2020-07-22 | Kanabec | Minnesota | 27065 | 20 | 1 |
361588 | 361588 | 2020-07-23 | Kanabec | Minnesota | 27065 | 22 | 1 |
364795 | 364795 | 2020-07-24 | Kanabec | Minnesota | 27065 | 22 | 1 |
368002 | 368002 | 2020-07-25 | Kanabec | Minnesota | 27065 | 22 | 1 |
371212 | 371212 | 2020-07-26 | Kanabec | Minnesota | 27065 | 23 | 1 |
374424 | 374424 | 2020-07-27 | Kanabec | Minnesota | 27065 | 23 | 1 |
377639 | 377639 | 2020-07-28 | Kanabec | Minnesota | 27065 | 23 | 1 |
380856 | 380856 | 2020-07-29 | Kanabec | Minnesota | 27065 | 23 | 1 |
384073 | 384073 | 2020-07-30 | Kanabec | Minnesota | 27065 | 23 | 1 |
387291 | 387291 | 2020-07-31 | Kanabec | Minnesota | 27065 | 23 | 1 |
390508 | 390508 | 2020-08-01 | Kanabec | Minnesota | 27065 | 27 | 1 |
393725 | 393725 | 2020-08-02 | Kanabec | Minnesota | 27065 | 28 | 1 |
396941 | 396941 | 2020-08-03 | Kanabec | Minnesota | 27065 | 29 | 1 |
400155 | 400155 | 2020-08-04 | Kanabec | Minnesota | 27065 | 28 | 1 |
403372 | 403372 | 2020-08-05 | Kanabec | Minnesota | 27065 | 30 | 1 |
406590 | 406590 | 2020-08-06 | Kanabec | Minnesota | 27065 | 32 | 1 |
409810 | 409810 | 2020-08-07 | Kanabec | Minnesota | 27065 | 34 | 1 |
413030 | 413030 | 2020-08-08 | Kanabec | Minnesota | 27065 | 34 | 1 |
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 ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);