ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where cases = 13 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Aitkin 21
- Kanabec 18
- Big Stone 6
- Wabasha 6
- Cass 5
- Fillmore 5
- Lac qui Parle 5
- Stevens 5
- Chisago 4
- Kittson 4
- Lake 4
- Mahnomen 4
- Norman 4
- Sherburne 4
- St. Louis 4
- Swift 4
- Carver 3
- Crow Wing 3
- Faribault 3
- Pope 3
- Clay 2
- Dodge 2
- Houston 2
- Hubbard 2
- Lake of the Woods 2
- Pipestone 2
- Roseau 2
- Sibley 2
- Becker 1
- Beltrami 1
- …
state 1
- Minnesota · 156 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
662189 | 662189 | 2020-10-24 | Cook | Minnesota | 27031 | 13 | 0 |
597330 | 597330 | 2020-10-04 | Kittson | Minnesota | 27069 | 13 | 0 |
545490 | 545490 | 2020-09-18 | Kittson | Minnesota | 27069 | 13 | 0 |
542253 | 542253 | 2020-09-17 | Kittson | Minnesota | 27069 | 13 | 0 |
535780 | 535780 | 2020-09-15 | Kittson | Minnesota | 27069 | 13 | 0 |
496969 | 496969 | 2020-09-03 | Lake of the Woods | Minnesota | 27077 | 13 | 1 |
493736 | 493736 | 2020-09-02 | Lake of the Woods | Minnesota | 27077 | 13 | 0 |
477566 | 477566 | 2020-08-28 | Lac qui Parle | Minnesota | 27073 | 13 | 0 |
474333 | 474333 | 2020-08-27 | Lac qui Parle | Minnesota | 27073 | 13 | 0 |
471101 | 471101 | 2020-08-26 | Lac qui Parle | Minnesota | 27073 | 13 | 0 |
467871 | 467871 | 2020-08-25 | Lac qui Parle | Minnesota | 27073 | 13 | 0 |
464642 | 464642 | 2020-08-24 | Lac qui Parle | Minnesota | 27073 | 13 | 0 |
429184 | 429184 | 2020-08-13 | Traverse | Minnesota | 27155 | 13 | 0 |
384103 | 384103 | 2020-07-30 | Red Lake | Minnesota | 27125 | 13 | 0 |
371217 | 371217 | 2020-07-26 | Lake | Minnesota | 27075 | 13 | 0 |
368007 | 368007 | 2020-07-25 | Lake | Minnesota | 27075 | 13 | 0 |
364791 | 364791 | 2020-07-24 | Hubbard | Minnesota | 27057 | 13 | 0 |
364800 | 364800 | 2020-07-24 | Lake | Minnesota | 27075 | 13 | 0 |
361584 | 361584 | 2020-07-23 | Hubbard | Minnesota | 27057 | 13 | 0 |
361593 | 361593 | 2020-07-23 | Lake | Minnesota | 27075 | 13 | 0 |
352019 | 352019 | 2020-07-20 | Stevens | Minnesota | 27149 | 13 | 0 |
348819 | 348819 | 2020-07-19 | Stevens | Minnesota | 27149 | 13 | 0 |
345618 | 345618 | 2020-07-18 | Stevens | Minnesota | 27149 | 13 | 0 |
342418 | 342418 | 2020-07-17 | Stevens | Minnesota | 27149 | 13 | 0 |
339222 | 339222 | 2020-07-16 | Stevens | Minnesota | 27149 | 13 | 0 |
335994 | 335994 | 2020-07-15 | Mahnomen | Minnesota | 27087 | 13 | 1 |
332801 | 332801 | 2020-07-14 | Mahnomen | Minnesota | 27087 | 13 | 1 |
329614 | 329614 | 2020-07-13 | Mahnomen | Minnesota | 27087 | 13 | 1 |
329632 | 329632 | 2020-07-13 | Pope | Minnesota | 27121 | 13 | 0 |
326401 | 326401 | 2020-07-12 | Clearwater | Minnesota | 27029 | 13 | 0 |
326428 | 326428 | 2020-07-12 | Mahnomen | Minnesota | 27087 | 13 | 1 |
326446 | 326446 | 2020-07-12 | Pope | Minnesota | 27121 | 13 | 0 |
323246 | 323246 | 2020-07-11 | Marshall | Minnesota | 27089 | 13 | 0 |
323263 | 323263 | 2020-07-11 | Pope | Minnesota | 27121 | 13 | 0 |
320064 | 320064 | 2020-07-10 | Lincoln | Minnesota | 27081 | 13 | 0 |
301073 | 301073 | 2020-07-04 | Roseau | Minnesota | 27135 | 13 | 0 |
297910 | 297910 | 2020-07-03 | Roseau | Minnesota | 27135 | 13 | 0 |
288391 | 288391 | 2020-06-30 | Cass | Minnesota | 27021 | 13 | 2 |
288416 | 288416 | 2020-06-30 | Koochiching | Minnesota | 27071 | 13 | 1 |
285231 | 285231 | 2020-06-29 | Aitkin | Minnesota | 27001 | 13 | 0 |
282086 | 282086 | 2020-06-28 | Aitkin | Minnesota | 27001 | 13 | 0 |
282118 | 282118 | 2020-06-28 | Kanabec | Minnesota | 27065 | 13 | 1 |
278938 | 278938 | 2020-06-27 | Aitkin | Minnesota | 27001 | 13 | 0 |
278970 | 278970 | 2020-06-27 | Kanabec | Minnesota | 27065 | 13 | 1 |
275790 | 275790 | 2020-06-26 | Aitkin | Minnesota | 27001 | 13 | 0 |
275822 | 275822 | 2020-06-26 | Kanabec | Minnesota | 27065 | 13 | 1 |
272647 | 272647 | 2020-06-25 | Aitkin | Minnesota | 27001 | 13 | 0 |
272679 | 272679 | 2020-06-25 | Kanabec | Minnesota | 27065 | 13 | 1 |
269510 | 269510 | 2020-06-24 | Aitkin | Minnesota | 27001 | 13 | 0 |
269542 | 269542 | 2020-06-24 | Kanabec | Minnesota | 27065 | 13 | 1 |
266377 | 266377 | 2020-06-23 | Aitkin | Minnesota | 27001 | 13 | 0 |
266409 | 266409 | 2020-06-23 | Kanabec | Minnesota | 27065 | 13 | 1 |
263251 | 263251 | 2020-06-22 | Aitkin | Minnesota | 27001 | 13 | 0 |
263278 | 263278 | 2020-06-22 | Houston | Minnesota | 27055 | 13 | 0 |
263283 | 263283 | 2020-06-22 | Kanabec | Minnesota | 27065 | 13 | 1 |
260122 | 260122 | 2020-06-21 | Aitkin | Minnesota | 27001 | 13 | 0 |
260149 | 260149 | 2020-06-21 | Houston | Minnesota | 27055 | 13 | 0 |
260154 | 260154 | 2020-06-21 | Kanabec | Minnesota | 27065 | 13 | 1 |
256996 | 256996 | 2020-06-20 | Aitkin | Minnesota | 27001 | 13 | 0 |
257028 | 257028 | 2020-06-20 | Kanabec | Minnesota | 27065 | 13 | 1 |
253876 | 253876 | 2020-06-19 | Aitkin | Minnesota | 27001 | 13 | 0 |
253908 | 253908 | 2020-06-19 | Kanabec | Minnesota | 27065 | 13 | 1 |
250761 | 250761 | 2020-06-18 | Aitkin | Minnesota | 27001 | 13 | 0 |
250793 | 250793 | 2020-06-18 | Kanabec | Minnesota | 27065 | 13 | 1 |
247649 | 247649 | 2020-06-17 | Aitkin | Minnesota | 27001 | 13 | 0 |
247681 | 247681 | 2020-06-17 | Kanabec | Minnesota | 27065 | 13 | 1 |
244536 | 244536 | 2020-06-16 | Aitkin | Minnesota | 27001 | 13 | 0 |
244541 | 244541 | 2020-06-16 | Big Stone | Minnesota | 27011 | 13 | 0 |
244568 | 244568 | 2020-06-16 | Kanabec | Minnesota | 27065 | 13 | 1 |
241425 | 241425 | 2020-06-15 | Aitkin | Minnesota | 27001 | 13 | 0 |
241430 | 241430 | 2020-06-15 | Big Stone | Minnesota | 27011 | 13 | 0 |
241457 | 241457 | 2020-06-15 | Kanabec | Minnesota | 27065 | 13 | 1 |
238316 | 238316 | 2020-06-14 | Aitkin | Minnesota | 27001 | 13 | 0 |
238321 | 238321 | 2020-06-14 | Big Stone | Minnesota | 27011 | 13 | 0 |
238348 | 238348 | 2020-06-14 | Kanabec | Minnesota | 27065 | 13 | 1 |
235209 | 235209 | 2020-06-13 | Aitkin | Minnesota | 27001 | 13 | 0 |
235214 | 235214 | 2020-06-13 | Big Stone | Minnesota | 27011 | 13 | 0 |
235241 | 235241 | 2020-06-13 | Kanabec | Minnesota | 27065 | 13 | 1 |
232104 | 232104 | 2020-06-12 | Aitkin | Minnesota | 27001 | 13 | 0 |
232135 | 232135 | 2020-06-12 | Kanabec | Minnesota | 27065 | 13 | 1 |
229000 | 229000 | 2020-06-11 | Aitkin | Minnesota | 27001 | 13 | 0 |
229005 | 229005 | 2020-06-11 | Big Stone | Minnesota | 27011 | 13 | 0 |
229031 | 229031 | 2020-06-11 | Kanabec | Minnesota | 27065 | 13 | 1 |
225898 | 225898 | 2020-06-10 | Aitkin | Minnesota | 27001 | 13 | 0 |
225903 | 225903 | 2020-06-10 | Big Stone | Minnesota | 27011 | 13 | 0 |
222800 | 222800 | 2020-06-09 | Aitkin | Minnesota | 27001 | 13 | 0 |
213581 | 213581 | 2020-06-06 | Pipestone | Minnesota | 27117 | 13 | 0 |
210497 | 210497 | 2020-06-05 | Pipestone | Minnesota | 27117 | 13 | 0 |
201212 | 201212 | 2020-06-02 | Cass | Minnesota | 27021 | 13 | 2 |
201253 | 201253 | 2020-06-02 | Norman | Minnesota | 27107 | 13 | 0 |
198180 | 198180 | 2020-06-01 | Norman | Minnesota | 27107 | 13 | 0 |
195109 | 195109 | 2020-05-31 | Norman | Minnesota | 27107 | 13 | 0 |
192000 | 192000 | 2020-05-30 | Cass | Minnesota | 27021 | 13 | 2 |
192041 | 192041 | 2020-05-30 | Norman | Minnesota | 27107 | 13 | 0 |
188936 | 188936 | 2020-05-29 | Cass | Minnesota | 27021 | 13 | 2 |
185878 | 185878 | 2020-05-28 | Cass | Minnesota | 27021 | 13 | 2 |
185888 | 185888 | 2020-05-28 | Faribault | Minnesota | 27043 | 13 | 0 |
182816 | 182816 | 2020-05-27 | Beltrami | Minnesota | 27007 | 13 | 0 |
182833 | 182833 | 2020-05-27 | Faribault | Minnesota | 27043 | 13 | 0 |
182881 | 182881 | 2020-05-27 | Sibley | Minnesota | 27143 | 13 | 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);