ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
481 rows where cases = 3 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Yellow Medicine 37
- Kittson 34
- Lac qui Parle 32
- Waseca 32
- Red Lake 29
- Clearwater 28
- Redwood 27
- Traverse 25
- Renville 18
- Nicollet 13
- Lincoln 12
- Big Stone 10
- Meeker 10
- McLeod 9
- Todd 8
- Stevens 7
- Faribault 6
- Hubbard 6
- Rice 6
- Cass 5
- Fillmore 5
- Murray 5
- Roseau 5
- Stearns 5
- Wright 5
- Chisago 4
- Koochiching 4
- Lyon 4
- Mahnomen 4
- Rock 4
- …
state 1
- Minnesota · 481 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
474331 | 474331 | 2020-08-27 | Kittson | Minnesota | 27069 | 3 | 0 |
471099 | 471099 | 2020-08-26 | Kittson | Minnesota | 27069 | 3 | 0 |
467869 | 467869 | 2020-08-25 | Kittson | Minnesota | 27069 | 3 | 0 |
464640 | 464640 | 2020-08-24 | Kittson | Minnesota | 27069 | 3 | 0 |
461409 | 461409 | 2020-08-23 | Kittson | Minnesota | 27069 | 3 | 0 |
458182 | 458182 | 2020-08-22 | Kittson | Minnesota | 27069 | 3 | 0 |
454954 | 454954 | 2020-08-21 | Kittson | Minnesota | 27069 | 3 | 0 |
451726 | 451726 | 2020-08-20 | Kittson | Minnesota | 27069 | 3 | 0 |
448498 | 448498 | 2020-08-19 | Kittson | Minnesota | 27069 | 3 | 0 |
445272 | 445272 | 2020-08-18 | Kittson | Minnesota | 27069 | 3 | 0 |
442046 | 442046 | 2020-08-17 | Kittson | Minnesota | 27069 | 3 | 0 |
438819 | 438819 | 2020-08-16 | Kittson | Minnesota | 27069 | 3 | 0 |
435594 | 435594 | 2020-08-15 | Kittson | Minnesota | 27069 | 3 | 0 |
432368 | 432368 | 2020-08-14 | Kittson | Minnesota | 27069 | 3 | 0 |
429141 | 429141 | 2020-08-13 | Kittson | Minnesota | 27069 | 3 | 0 |
425917 | 425917 | 2020-08-12 | Kittson | Minnesota | 27069 | 3 | 0 |
422695 | 422695 | 2020-08-11 | Kittson | Minnesota | 27069 | 3 | 0 |
419473 | 419473 | 2020-08-10 | Kittson | Minnesota | 27069 | 3 | 0 |
416252 | 416252 | 2020-08-09 | Kittson | Minnesota | 27069 | 3 | 0 |
413013 | 413013 | 2020-08-08 | Cook | Minnesota | 27031 | 3 | 0 |
413032 | 413032 | 2020-08-08 | Kittson | Minnesota | 27069 | 3 | 0 |
409793 | 409793 | 2020-08-07 | Cook | Minnesota | 27031 | 3 | 0 |
409812 | 409812 | 2020-08-07 | Kittson | Minnesota | 27069 | 3 | 0 |
406592 | 406592 | 2020-08-06 | Kittson | Minnesota | 27069 | 3 | 0 |
403374 | 403374 | 2020-08-05 | Kittson | Minnesota | 27069 | 3 | 0 |
400157 | 400157 | 2020-08-04 | Kittson | Minnesota | 27069 | 3 | 0 |
390510 | 390510 | 2020-08-01 | Kittson | Minnesota | 27069 | 3 | 0 |
387293 | 387293 | 2020-07-31 | Kittson | Minnesota | 27069 | 3 | 0 |
384075 | 384075 | 2020-07-30 | Kittson | Minnesota | 27069 | 3 | 0 |
380858 | 380858 | 2020-07-29 | Kittson | Minnesota | 27069 | 3 | 0 |
377641 | 377641 | 2020-07-28 | Kittson | Minnesota | 27069 | 3 | 0 |
374426 | 374426 | 2020-07-27 | Kittson | Minnesota | 27069 | 3 | 0 |
371214 | 371214 | 2020-07-26 | Kittson | Minnesota | 27069 | 3 | 0 |
368004 | 368004 | 2020-07-25 | Kittson | Minnesota | 27069 | 3 | 0 |
364797 | 364797 | 2020-07-24 | Kittson | Minnesota | 27069 | 3 | 0 |
361590 | 361590 | 2020-07-23 | Kittson | Minnesota | 27069 | 3 | 0 |
307399 | 307399 | 2020-07-06 | Red Lake | Minnesota | 27125 | 3 | 0 |
304232 | 304232 | 2020-07-05 | Red Lake | Minnesota | 27125 | 3 | 0 |
301068 | 301068 | 2020-07-04 | Red Lake | Minnesota | 27125 | 3 | 0 |
297905 | 297905 | 2020-07-03 | Red Lake | Minnesota | 27125 | 3 | 0 |
294747 | 294747 | 2020-07-02 | Red Lake | Minnesota | 27125 | 3 | 0 |
291593 | 291593 | 2020-07-01 | Red Lake | Minnesota | 27125 | 3 | 0 |
288442 | 288442 | 2020-06-30 | Red Lake | Minnesota | 27125 | 3 | 0 |
285292 | 285292 | 2020-06-29 | Red Lake | Minnesota | 27125 | 3 | 0 |
285304 | 285304 | 2020-06-29 | Stevens | Minnesota | 27149 | 3 | 0 |
282147 | 282147 | 2020-06-28 | Red Lake | Minnesota | 27125 | 3 | 0 |
282159 | 282159 | 2020-06-28 | Stevens | Minnesota | 27149 | 3 | 0 |
278999 | 278999 | 2020-06-27 | Red Lake | Minnesota | 27125 | 3 | 0 |
279011 | 279011 | 2020-06-27 | Stevens | Minnesota | 27149 | 3 | 0 |
275851 | 275851 | 2020-06-26 | Red Lake | Minnesota | 27125 | 3 | 0 |
275863 | 275863 | 2020-06-26 | Stevens | Minnesota | 27149 | 3 | 0 |
272708 | 272708 | 2020-06-25 | Red Lake | Minnesota | 27125 | 3 | 0 |
272720 | 272720 | 2020-06-25 | Stevens | Minnesota | 27149 | 3 | 0 |
269571 | 269571 | 2020-06-24 | Red Lake | Minnesota | 27125 | 3 | 0 |
269583 | 269583 | 2020-06-24 | Stevens | Minnesota | 27149 | 3 | 0 |
266438 | 266438 | 2020-06-23 | Red Lake | Minnesota | 27125 | 3 | 0 |
266450 | 266450 | 2020-06-23 | Stevens | Minnesota | 27149 | 3 | 0 |
263312 | 263312 | 2020-06-22 | Red Lake | Minnesota | 27125 | 3 | 0 |
260183 | 260183 | 2020-06-21 | Red Lake | Minnesota | 27125 | 3 | 0 |
257057 | 257057 | 2020-06-20 | Red Lake | Minnesota | 27125 | 3 | 0 |
253937 | 253937 | 2020-06-19 | Red Lake | Minnesota | 27125 | 3 | 0 |
250797 | 250797 | 2020-06-18 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
247685 | 247685 | 2020-06-17 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
244572 | 244572 | 2020-06-16 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
241461 | 241461 | 2020-06-15 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
238352 | 238352 | 2020-06-14 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
235223 | 235223 | 2020-06-13 | Clearwater | Minnesota | 27029 | 3 | 0 |
235245 | 235245 | 2020-06-13 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
232118 | 232118 | 2020-06-12 | Clearwater | Minnesota | 27029 | 3 | 0 |
232139 | 232139 | 2020-06-12 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
229014 | 229014 | 2020-06-11 | Clearwater | Minnesota | 27029 | 3 | 0 |
229035 | 229035 | 2020-06-11 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
225912 | 225912 | 2020-06-10 | Clearwater | Minnesota | 27029 | 3 | 0 |
225933 | 225933 | 2020-06-10 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
222814 | 222814 | 2020-06-09 | Clearwater | Minnesota | 27029 | 3 | 0 |
222835 | 222835 | 2020-06-09 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
219719 | 219719 | 2020-06-08 | Clearwater | Minnesota | 27029 | 3 | 0 |
219740 | 219740 | 2020-06-08 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
216627 | 216627 | 2020-06-07 | Clearwater | Minnesota | 27029 | 3 | 0 |
216639 | 216639 | 2020-06-07 | Houston | Minnesota | 27055 | 3 | 0 |
216648 | 216648 | 2020-06-07 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
213539 | 213539 | 2020-06-06 | Clearwater | Minnesota | 27029 | 3 | 0 |
213551 | 213551 | 2020-06-06 | Houston | Minnesota | 27055 | 3 | 0 |
213552 | 213552 | 2020-06-06 | Hubbard | Minnesota | 27057 | 3 | 0 |
213560 | 213560 | 2020-06-06 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
213590 | 213590 | 2020-06-06 | Roseau | Minnesota | 27135 | 3 | 0 |
210455 | 210455 | 2020-06-05 | Clearwater | Minnesota | 27029 | 3 | 0 |
210467 | 210467 | 2020-06-05 | Houston | Minnesota | 27055 | 3 | 0 |
210468 | 210468 | 2020-06-05 | Hubbard | Minnesota | 27057 | 3 | 0 |
210476 | 210476 | 2020-06-05 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
210506 | 210506 | 2020-06-05 | Roseau | Minnesota | 27135 | 3 | 0 |
207374 | 207374 | 2020-06-04 | Clearwater | Minnesota | 27029 | 3 | 0 |
207387 | 207387 | 2020-06-04 | Hubbard | Minnesota | 27057 | 3 | 0 |
207395 | 207395 | 2020-06-04 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
207425 | 207425 | 2020-06-04 | Roseau | Minnesota | 27135 | 3 | 0 |
204293 | 204293 | 2020-06-03 | Clearwater | Minnesota | 27029 | 3 | 0 |
204306 | 204306 | 2020-06-03 | Hubbard | Minnesota | 27057 | 3 | 0 |
204314 | 204314 | 2020-06-03 | Lac qui Parle | Minnesota | 27073 | 3 | 0 |
204344 | 204344 | 2020-06-03 | Roseau | Minnesota | 27135 | 3 | 0 |
201216 | 201216 | 2020-06-02 | Clearwater | Minnesota | 27029 | 3 | 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);