ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
310 rows where cases = 5 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Traverse 30
- Hubbard 25
- Renville 25
- Mahnomen 15
- Beltrami 14
- Lyon 12
- Pope 12
- Stearns 12
- Red Lake 11
- Cottonwood 10
- Lincoln 10
- Cass 9
- Houston 8
- Lake 6
- Rock 6
- Steele 6
- Cook 5
- Yellow Medicine 5
- Anoka 4
- Chisago 4
- Koochiching 4
- Unknown 4
- Blue Earth 3
- Chippewa 3
- Clearwater 3
- Faribault 3
- Grant 3
- Lac qui Parle 3
- Roseau 3
- St. Louis 3
- …
state 1
- Minnesota · 310 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
429122 | 429122 | 2020-08-13 | Cook | Minnesota | 27031 | 5 | 0 |
425898 | 425898 | 2020-08-12 | Cook | Minnesota | 27031 | 5 | 0 |
422676 | 422676 | 2020-08-11 | Cook | Minnesota | 27031 | 5 | 0 |
419454 | 419454 | 2020-08-10 | Cook | Minnesota | 27031 | 5 | 0 |
416233 | 416233 | 2020-08-09 | Cook | Minnesota | 27031 | 5 | 0 |
361617 | 361617 | 2020-07-23 | Red Lake | Minnesota | 27125 | 5 | 0 |
358412 | 358412 | 2020-07-22 | Red Lake | Minnesota | 27125 | 5 | 0 |
355209 | 355209 | 2020-07-21 | Red Lake | Minnesota | 27125 | 5 | 0 |
352007 | 352007 | 2020-07-20 | Red Lake | Minnesota | 27125 | 5 | 0 |
348807 | 348807 | 2020-07-19 | Red Lake | Minnesota | 27125 | 5 | 0 |
345606 | 345606 | 2020-07-18 | Red Lake | Minnesota | 27125 | 5 | 0 |
342406 | 342406 | 2020-07-17 | Red Lake | Minnesota | 27125 | 5 | 0 |
339210 | 339210 | 2020-07-16 | Red Lake | Minnesota | 27125 | 5 | 0 |
336014 | 336014 | 2020-07-15 | Red Lake | Minnesota | 27125 | 5 | 0 |
332821 | 332821 | 2020-07-14 | Red Lake | Minnesota | 27125 | 5 | 0 |
329609 | 329609 | 2020-07-13 | Lac qui Parle | Minnesota | 27073 | 5 | 0 |
329634 | 329634 | 2020-07-13 | Red Lake | Minnesota | 27125 | 5 | 0 |
326423 | 326423 | 2020-07-12 | Lac qui Parle | Minnesota | 27073 | 5 | 0 |
323240 | 323240 | 2020-07-11 | Lac qui Parle | Minnesota | 27073 | 5 | 0 |
310579 | 310579 | 2020-07-07 | Stevens | Minnesota | 27149 | 5 | 0 |
310582 | 310582 | 2020-07-07 | Traverse | Minnesota | 27155 | 5 | 0 |
301083 | 301083 | 2020-07-04 | Traverse | Minnesota | 27155 | 5 | 0 |
297920 | 297920 | 2020-07-03 | Traverse | Minnesota | 27155 | 5 | 0 |
294714 | 294714 | 2020-07-02 | Hubbard | Minnesota | 27057 | 5 | 0 |
294762 | 294762 | 2020-07-02 | Traverse | Minnesota | 27155 | 5 | 0 |
291560 | 291560 | 2020-07-01 | Hubbard | Minnesota | 27057 | 5 | 0 |
291608 | 291608 | 2020-07-01 | Traverse | Minnesota | 27155 | 5 | 0 |
288409 | 288409 | 2020-06-30 | Hubbard | Minnesota | 27057 | 5 | 0 |
288457 | 288457 | 2020-06-30 | Traverse | Minnesota | 27155 | 5 | 0 |
285259 | 285259 | 2020-06-29 | Hubbard | Minnesota | 27057 | 5 | 0 |
285307 | 285307 | 2020-06-29 | Traverse | Minnesota | 27155 | 5 | 0 |
282114 | 282114 | 2020-06-28 | Hubbard | Minnesota | 27057 | 5 | 0 |
282162 | 282162 | 2020-06-28 | Traverse | Minnesota | 27155 | 5 | 0 |
278966 | 278966 | 2020-06-27 | Hubbard | Minnesota | 27057 | 5 | 0 |
278975 | 278975 | 2020-06-27 | Lake | Minnesota | 27075 | 5 | 0 |
279014 | 279014 | 2020-06-27 | Traverse | Minnesota | 27155 | 5 | 0 |
275818 | 275818 | 2020-06-26 | Hubbard | Minnesota | 27057 | 5 | 0 |
275827 | 275827 | 2020-06-26 | Lake | Minnesota | 27075 | 5 | 0 |
275866 | 275866 | 2020-06-26 | Traverse | Minnesota | 27155 | 5 | 0 |
272675 | 272675 | 2020-06-25 | Hubbard | Minnesota | 27057 | 5 | 0 |
272684 | 272684 | 2020-06-25 | Lake | Minnesota | 27075 | 5 | 0 |
272723 | 272723 | 2020-06-25 | Traverse | Minnesota | 27155 | 5 | 0 |
269538 | 269538 | 2020-06-24 | Hubbard | Minnesota | 27057 | 5 | 0 |
269547 | 269547 | 2020-06-24 | Lake | Minnesota | 27075 | 5 | 0 |
269586 | 269586 | 2020-06-24 | Traverse | Minnesota | 27155 | 5 | 0 |
266405 | 266405 | 2020-06-23 | Hubbard | Minnesota | 27057 | 5 | 0 |
266414 | 266414 | 2020-06-23 | Lake | Minnesota | 27075 | 5 | 0 |
266453 | 266453 | 2020-06-23 | Traverse | Minnesota | 27155 | 5 | 0 |
263279 | 263279 | 2020-06-22 | Hubbard | Minnesota | 27057 | 5 | 0 |
263288 | 263288 | 2020-06-22 | Lake | Minnesota | 27075 | 5 | 0 |
263327 | 263327 | 2020-06-22 | Traverse | Minnesota | 27155 | 5 | 0 |
260150 | 260150 | 2020-06-21 | Hubbard | Minnesota | 27057 | 5 | 0 |
260198 | 260198 | 2020-06-21 | Traverse | Minnesota | 27155 | 5 | 0 |
257024 | 257024 | 2020-06-20 | Hubbard | Minnesota | 27057 | 5 | 0 |
257072 | 257072 | 2020-06-20 | Traverse | Minnesota | 27155 | 5 | 0 |
253904 | 253904 | 2020-06-19 | Hubbard | Minnesota | 27057 | 5 | 0 |
253952 | 253952 | 2020-06-19 | Traverse | Minnesota | 27155 | 5 | 0 |
250789 | 250789 | 2020-06-18 | Hubbard | Minnesota | 27057 | 5 | 0 |
250837 | 250837 | 2020-06-18 | Traverse | Minnesota | 27155 | 5 | 0 |
247677 | 247677 | 2020-06-17 | Hubbard | Minnesota | 27057 | 5 | 0 |
247725 | 247725 | 2020-06-17 | Traverse | Minnesota | 27155 | 5 | 0 |
244550 | 244550 | 2020-06-16 | Clearwater | Minnesota | 27029 | 5 | 0 |
244563 | 244563 | 2020-06-16 | Houston | Minnesota | 27055 | 5 | 0 |
244564 | 244564 | 2020-06-16 | Hubbard | Minnesota | 27057 | 5 | 0 |
244612 | 244612 | 2020-06-16 | Traverse | Minnesota | 27155 | 5 | 0 |
241439 | 241439 | 2020-06-15 | Clearwater | Minnesota | 27029 | 5 | 0 |
241452 | 241452 | 2020-06-15 | Houston | Minnesota | 27055 | 5 | 0 |
241453 | 241453 | 2020-06-15 | Hubbard | Minnesota | 27057 | 5 | 0 |
241501 | 241501 | 2020-06-15 | Traverse | Minnesota | 27155 | 5 | 0 |
238330 | 238330 | 2020-06-14 | Clearwater | Minnesota | 27029 | 5 | 0 |
238343 | 238343 | 2020-06-14 | Houston | Minnesota | 27055 | 5 | 0 |
238344 | 238344 | 2020-06-14 | Hubbard | Minnesota | 27057 | 5 | 0 |
238392 | 238392 | 2020-06-14 | Traverse | Minnesota | 27155 | 5 | 0 |
235236 | 235236 | 2020-06-13 | Houston | Minnesota | 27055 | 5 | 0 |
235237 | 235237 | 2020-06-13 | Hubbard | Minnesota | 27057 | 5 | 0 |
235285 | 235285 | 2020-06-13 | Traverse | Minnesota | 27155 | 5 | 0 |
232130 | 232130 | 2020-06-12 | Houston | Minnesota | 27055 | 5 | 0 |
232131 | 232131 | 2020-06-12 | Hubbard | Minnesota | 27057 | 5 | 0 |
232179 | 232179 | 2020-06-12 | Traverse | Minnesota | 27155 | 5 | 0 |
229026 | 229026 | 2020-06-11 | Houston | Minnesota | 27055 | 5 | 0 |
229027 | 229027 | 2020-06-11 | Hubbard | Minnesota | 27057 | 5 | 0 |
229075 | 229075 | 2020-06-11 | Traverse | Minnesota | 27155 | 5 | 0 |
225924 | 225924 | 2020-06-10 | Houston | Minnesota | 27055 | 5 | 0 |
225925 | 225925 | 2020-06-10 | Hubbard | Minnesota | 27057 | 5 | 0 |
225963 | 225963 | 2020-06-10 | Roseau | Minnesota | 27135 | 5 | 0 |
225973 | 225973 | 2020-06-10 | Traverse | Minnesota | 27155 | 5 | 0 |
222824 | 222824 | 2020-06-09 | Grant | Minnesota | 27051 | 5 | 0 |
222826 | 222826 | 2020-06-09 | Houston | Minnesota | 27055 | 5 | 0 |
222827 | 222827 | 2020-06-09 | Hubbard | Minnesota | 27057 | 5 | 0 |
222865 | 222865 | 2020-06-09 | Roseau | Minnesota | 27135 | 5 | 0 |
222875 | 222875 | 2020-06-09 | Traverse | Minnesota | 27155 | 5 | 0 |
219729 | 219729 | 2020-06-08 | Grant | Minnesota | 27051 | 5 | 0 |
219732 | 219732 | 2020-06-08 | Hubbard | Minnesota | 27057 | 5 | 0 |
219770 | 219770 | 2020-06-08 | Roseau | Minnesota | 27135 | 5 | 0 |
219780 | 219780 | 2020-06-08 | Traverse | Minnesota | 27155 | 5 | 0 |
216637 | 216637 | 2020-06-07 | Grant | Minnesota | 27051 | 5 | 0 |
216688 | 216688 | 2020-06-07 | Traverse | Minnesota | 27155 | 5 | 0 |
213600 | 213600 | 2020-06-06 | Traverse | Minnesota | 27155 | 5 | 0 |
204341 | 204341 | 2020-06-03 | Renville | Minnesota | 27129 | 5 | 0 |
201264 | 201264 | 2020-06-02 | Renville | Minnesota | 27129 | 5 | 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);