ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
940 rows where cases = 1 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Kittson 69
- Roseau 51
- Lac qui Parle 42
- Lake 40
- Koochiching 39
- Cook 38
- Mahnomen 34
- Big Stone 33
- Sibley 33
- Benton 32
- Houston 32
- Jackson 28
- Pennington 27
- Red Lake 27
- Redwood 24
- Aitkin 21
- Douglas 21
- Stevens 21
- Swift 21
- Renville 19
- Cass 15
- Lake of the Woods 13
- Pipestone 13
- Marshall 12
- Mille Lacs 12
- Polk 12
- Carver 10
- Lincoln 10
- Meeker 10
- Morrison 10
- …
state 1
- Minnesota · 940 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
406596 | 406596 | 2020-08-06 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
403378 | 403378 | 2020-08-05 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
400161 | 400161 | 2020-08-04 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
396947 | 396947 | 2020-08-03 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
393731 | 393731 | 2020-08-02 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
390514 | 390514 | 2020-08-01 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
387297 | 387297 | 2020-07-31 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
384079 | 384079 | 2020-07-30 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
380862 | 380862 | 2020-07-29 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
377645 | 377645 | 2020-07-28 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
374430 | 374430 | 2020-07-27 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
371218 | 371218 | 2020-07-26 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
368008 | 368008 | 2020-07-25 | Lake of the Woods | Minnesota | 27077 | 1 | 0 |
351961 | 351961 | 2020-07-20 | Cook | Minnesota | 27031 | 1 | 0 |
348761 | 348761 | 2020-07-19 | Cook | Minnesota | 27031 | 1 | 0 |
345560 | 345560 | 2020-07-18 | Cook | Minnesota | 27031 | 1 | 0 |
342360 | 342360 | 2020-07-17 | Cook | Minnesota | 27031 | 1 | 0 |
339164 | 339164 | 2020-07-16 | Cook | Minnesota | 27031 | 1 | 0 |
335968 | 335968 | 2020-07-15 | Cook | Minnesota | 27031 | 1 | 0 |
332775 | 332775 | 2020-07-14 | Cook | Minnesota | 27031 | 1 | 0 |
329588 | 329588 | 2020-07-13 | Cook | Minnesota | 27031 | 1 | 0 |
326402 | 326402 | 2020-07-12 | Cook | Minnesota | 27031 | 1 | 0 |
323219 | 323219 | 2020-07-11 | Cook | Minnesota | 27031 | 1 | 0 |
320040 | 320040 | 2020-07-10 | Cook | Minnesota | 27031 | 1 | 0 |
316865 | 316865 | 2020-07-09 | Cook | Minnesota | 27031 | 1 | 0 |
313691 | 313691 | 2020-07-08 | Cook | Minnesota | 27031 | 1 | 0 |
310521 | 310521 | 2020-07-07 | Cook | Minnesota | 27031 | 1 | 0 |
307353 | 307353 | 2020-07-06 | Cook | Minnesota | 27031 | 1 | 0 |
304186 | 304186 | 2020-07-05 | Cook | Minnesota | 27031 | 1 | 0 |
301022 | 301022 | 2020-07-04 | Cook | Minnesota | 27031 | 1 | 0 |
297859 | 297859 | 2020-07-03 | Cook | Minnesota | 27031 | 1 | 0 |
294701 | 294701 | 2020-07-02 | Cook | Minnesota | 27031 | 1 | 0 |
291547 | 291547 | 2020-07-01 | Cook | Minnesota | 27031 | 1 | 0 |
288396 | 288396 | 2020-06-30 | Cook | Minnesota | 27031 | 1 | 0 |
285246 | 285246 | 2020-06-29 | Cook | Minnesota | 27031 | 1 | 0 |
282101 | 282101 | 2020-06-28 | Cook | Minnesota | 27031 | 1 | 0 |
278953 | 278953 | 2020-06-27 | Cook | Minnesota | 27031 | 1 | 0 |
275805 | 275805 | 2020-06-26 | Cook | Minnesota | 27031 | 1 | 0 |
272662 | 272662 | 2020-06-25 | Cook | Minnesota | 27031 | 1 | 0 |
272681 | 272681 | 2020-06-25 | Kittson | Minnesota | 27069 | 1 | 0 |
269525 | 269525 | 2020-06-24 | Cook | Minnesota | 27031 | 1 | 0 |
269544 | 269544 | 2020-06-24 | Kittson | Minnesota | 27069 | 1 | 0 |
266392 | 266392 | 2020-06-23 | Cook | Minnesota | 27031 | 1 | 0 |
266411 | 266411 | 2020-06-23 | Kittson | Minnesota | 27069 | 1 | 0 |
263266 | 263266 | 2020-06-22 | Cook | Minnesota | 27031 | 1 | 0 |
263285 | 263285 | 2020-06-22 | Kittson | Minnesota | 27069 | 1 | 0 |
260137 | 260137 | 2020-06-21 | Cook | Minnesota | 27031 | 1 | 0 |
260156 | 260156 | 2020-06-21 | Kittson | Minnesota | 27069 | 1 | 0 |
257011 | 257011 | 2020-06-20 | Cook | Minnesota | 27031 | 1 | 0 |
257030 | 257030 | 2020-06-20 | Kittson | Minnesota | 27069 | 1 | 0 |
253891 | 253891 | 2020-06-19 | Cook | Minnesota | 27031 | 1 | 0 |
253910 | 253910 | 2020-06-19 | Kittson | Minnesota | 27069 | 1 | 0 |
250776 | 250776 | 2020-06-18 | Cook | Minnesota | 27031 | 1 | 0 |
250795 | 250795 | 2020-06-18 | Kittson | Minnesota | 27069 | 1 | 0 |
250834 | 250834 | 2020-06-18 | Stevens | Minnesota | 27149 | 1 | 0 |
247664 | 247664 | 2020-06-17 | Cook | Minnesota | 27031 | 1 | 0 |
247683 | 247683 | 2020-06-17 | Kittson | Minnesota | 27069 | 1 | 0 |
247722 | 247722 | 2020-06-17 | Stevens | Minnesota | 27149 | 1 | 0 |
244551 | 244551 | 2020-06-16 | Cook | Minnesota | 27031 | 1 | 0 |
244570 | 244570 | 2020-06-16 | Kittson | Minnesota | 27069 | 1 | 0 |
244609 | 244609 | 2020-06-16 | Stevens | Minnesota | 27149 | 1 | 0 |
241440 | 241440 | 2020-06-15 | Cook | Minnesota | 27031 | 1 | 0 |
241459 | 241459 | 2020-06-15 | Kittson | Minnesota | 27069 | 1 | 0 |
241462 | 241462 | 2020-06-15 | Lake | Minnesota | 27075 | 1 | 0 |
241498 | 241498 | 2020-06-15 | Stevens | Minnesota | 27149 | 1 | 0 |
238331 | 238331 | 2020-06-14 | Cook | Minnesota | 27031 | 1 | 0 |
238350 | 238350 | 2020-06-14 | Kittson | Minnesota | 27069 | 1 | 0 |
238353 | 238353 | 2020-06-14 | Lake | Minnesota | 27075 | 1 | 0 |
238389 | 238389 | 2020-06-14 | Stevens | Minnesota | 27149 | 1 | 0 |
235224 | 235224 | 2020-06-13 | Cook | Minnesota | 27031 | 1 | 0 |
235243 | 235243 | 2020-06-13 | Kittson | Minnesota | 27069 | 1 | 0 |
235246 | 235246 | 2020-06-13 | Lake | Minnesota | 27075 | 1 | 0 |
235282 | 235282 | 2020-06-13 | Stevens | Minnesota | 27149 | 1 | 0 |
232137 | 232137 | 2020-06-12 | Kittson | Minnesota | 27069 | 1 | 0 |
232140 | 232140 | 2020-06-12 | Lake | Minnesota | 27075 | 1 | 0 |
232176 | 232176 | 2020-06-12 | Stevens | Minnesota | 27149 | 1 | 0 |
229033 | 229033 | 2020-06-11 | Kittson | Minnesota | 27069 | 1 | 0 |
229036 | 229036 | 2020-06-11 | Lake | Minnesota | 27075 | 1 | 0 |
229072 | 229072 | 2020-06-11 | Stevens | Minnesota | 27149 | 1 | 0 |
225931 | 225931 | 2020-06-10 | Kittson | Minnesota | 27069 | 1 | 0 |
225934 | 225934 | 2020-06-10 | Lake | Minnesota | 27075 | 1 | 0 |
225970 | 225970 | 2020-06-10 | Stevens | Minnesota | 27149 | 1 | 0 |
222833 | 222833 | 2020-06-09 | Kittson | Minnesota | 27069 | 1 | 0 |
222836 | 222836 | 2020-06-09 | Lake | Minnesota | 27075 | 1 | 0 |
222872 | 222872 | 2020-06-09 | Stevens | Minnesota | 27149 | 1 | 0 |
219738 | 219738 | 2020-06-08 | Kittson | Minnesota | 27069 | 1 | 0 |
219741 | 219741 | 2020-06-08 | Lake | Minnesota | 27075 | 1 | 0 |
219777 | 219777 | 2020-06-08 | Stevens | Minnesota | 27149 | 1 | 0 |
216646 | 216646 | 2020-06-07 | Kittson | Minnesota | 27069 | 1 | 0 |
216649 | 216649 | 2020-06-07 | Lake | Minnesota | 27075 | 1 | 0 |
216685 | 216685 | 2020-06-07 | Stevens | Minnesota | 27149 | 1 | 0 |
213558 | 213558 | 2020-06-06 | Kittson | Minnesota | 27069 | 1 | 0 |
213561 | 213561 | 2020-06-06 | Lake | Minnesota | 27075 | 1 | 0 |
213597 | 213597 | 2020-06-06 | Stevens | Minnesota | 27149 | 1 | 0 |
210474 | 210474 | 2020-06-05 | Kittson | Minnesota | 27069 | 1 | 0 |
210477 | 210477 | 2020-06-05 | Lake | Minnesota | 27075 | 1 | 0 |
210513 | 210513 | 2020-06-05 | Stevens | Minnesota | 27149 | 1 | 0 |
207393 | 207393 | 2020-06-04 | Kittson | Minnesota | 27069 | 1 | 0 |
207396 | 207396 | 2020-06-04 | Lake | Minnesota | 27075 | 1 | 0 |
207432 | 207432 | 2020-06-04 | Stevens | Minnesota | 27149 | 1 | 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 ); 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);