ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 85 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636253 | 636253 | 2020-10-16 | Mahnomen | Minnesota | 27087 | 85 | 1 |
626529 | 626529 | 2020-10-13 | Norman | Minnesota | 27107 | 85 | 0 |
623271 | 623271 | 2020-10-12 | Lake | Minnesota | 27075 | 85 | 0 |
620028 | 620028 | 2020-10-11 | Lake | Minnesota | 27075 | 85 | 0 |
594135 | 594135 | 2020-10-03 | Wadena | Minnesota | 27159 | 85 | 0 |
558436 | 558436 | 2020-09-22 | Hubbard | Minnesota | 27057 | 85 | 1 |
529307 | 529307 | 2020-09-13 | Kanabec | Minnesota | 27065 | 85 | 8 |
526113 | 526113 | 2020-09-12 | Stevens | Minnesota | 27149 | 85 | 1 |
484084 | 484084 | 2020-08-30 | Yellow Medicine | Minnesota | 27173 | 85 | 1 |
467870 | 467870 | 2020-08-25 | Koochiching | Minnesota | 27071 | 85 | 3 |
464641 | 464641 | 2020-08-24 | Koochiching | Minnesota | 27071 | 85 | 3 |
461410 | 461410 | 2020-08-23 | Koochiching | Minnesota | 27071 | 85 | 3 |
461422 | 461422 | 2020-08-23 | Mille Lacs | Minnesota | 27095 | 85 | 3 |
458183 | 458183 | 2020-08-22 | Koochiching | Minnesota | 27071 | 85 | 3 |
454955 | 454955 | 2020-08-21 | Koochiching | Minnesota | 27071 | 85 | 3 |
448495 | 448495 | 2020-08-19 | Jackson | Minnesota | 27063 | 85 | 0 |
445269 | 445269 | 2020-08-18 | Jackson | Minnesota | 27063 | 85 | 0 |
425949 | 425949 | 2020-08-12 | Rock | Minnesota | 27133 | 85 | 0 |
422727 | 422727 | 2020-08-11 | Rock | Minnesota | 27133 | 85 | 0 |
419505 | 419505 | 2020-08-10 | Rock | Minnesota | 27133 | 85 | 0 |
416264 | 416264 | 2020-08-09 | Meeker | Minnesota | 27093 | 85 | 2 |
416284 | 416284 | 2020-08-09 | Rock | Minnesota | 27133 | 85 | 0 |
413044 | 413044 | 2020-08-08 | Meeker | Minnesota | 27093 | 85 | 2 |
409799 | 409799 | 2020-08-07 | Faribault | Minnesota | 27043 | 85 | 0 |
409826 | 409826 | 2020-08-07 | Morrison | Minnesota | 27097 | 85 | 1 |
406604 | 406604 | 2020-08-06 | Meeker | Minnesota | 27093 | 85 | 2 |
406606 | 406606 | 2020-08-06 | Morrison | Minnesota | 27097 | 85 | 1 |
403347 | 403347 | 2020-08-05 | Brown | Minnesota | 27015 | 85 | 2 |
403386 | 403386 | 2020-08-05 | Meeker | Minnesota | 27093 | 85 | 2 |
400130 | 400130 | 2020-08-04 | Brown | Minnesota | 27015 | 85 | 2 |
396916 | 396916 | 2020-08-03 | Brown | Minnesota | 27015 | 85 | 2 |
358353 | 358353 | 2020-07-22 | Becker | Minnesota | 27005 | 85 | 0 |
332809 | 332809 | 2020-07-14 | Murray | Minnesota | 27101 | 85 | 0 |
301015 | 301015 | 2020-07-04 | Carlton | Minnesota | 27017 | 85 | 0 |
297852 | 297852 | 2020-07-03 | Carlton | Minnesota | 27017 | 85 | 0 |
294730 | 294730 | 2020-07-02 | McLeod | Minnesota | 27085 | 85 | 0 |
291576 | 291576 | 2020-07-01 | McLeod | Minnesota | 27085 | 85 | 0 |
272701 | 272701 | 2020-06-25 | Otter Tail | Minnesota | 27111 | 85 | 1 |
269564 | 269564 | 2020-06-24 | Otter Tail | Minnesota | 27111 | 85 | 1 |
266431 | 266431 | 2020-06-23 | Otter Tail | Minnesota | 27111 | 85 | 1 |
263305 | 263305 | 2020-06-22 | Otter Tail | Minnesota | 27111 | 85 | 1 |
260176 | 260176 | 2020-06-21 | Otter Tail | Minnesota | 27111 | 85 | 1 |
257050 | 257050 | 2020-06-20 | Otter Tail | Minnesota | 27111 | 85 | 1 |
244620 | 244620 | 2020-06-16 | Winona | Minnesota | 27169 | 85 | 15 |
222883 | 222883 | 2020-06-09 | Winona | Minnesota | 27169 | 85 | 15 |
219721 | 219721 | 2020-06-08 | Crow Wing | Minnesota | 27035 | 85 | 6 |
219788 | 219788 | 2020-06-08 | Winona | Minnesota | 27169 | 85 | 15 |
216696 | 216696 | 2020-06-07 | Winona | Minnesota | 27169 | 85 | 15 |
204355 | 204355 | 2020-06-03 | Unknown | Minnesota | 85 | 11 | |
182868 | 182868 | 2020-05-27 | Pine | Minnesota | 27115 | 85 | 0 |
179822 | 179822 | 2020-05-26 | Pine | Minnesota | 27115 | 85 | 0 |
176778 | 176778 | 2020-05-25 | Pine | Minnesota | 27115 | 85 | 0 |
173735 | 173735 | 2020-05-24 | Pine | Minnesota | 27115 | 85 | 0 |
143532 | 143532 | 2020-05-14 | Steele | Minnesota | 27147 | 85 | 0 |
68565 | 68565 | 2020-04-18 | Anoka | Minnesota | 27003 | 85 | 2 |
46963 | 46963 | 2020-04-10 | Dakota | Minnesota | 27037 | 85 | 4 |
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);