ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where cases = 14 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clearwater 30
- Big Stone 19
- Pipestone 12
- Kanabec 8
- Carver 7
- Lake 6
- Aitkin 5
- Koochiching 4
- Beltrami 3
- Brown 3
- Cass 3
- Kittson 3
- Lake of the Woods 3
- Redwood 3
- Stevens 3
- Watonwan 3
- Chisago 2
- Fillmore 2
- Goodhue 2
- McLeod 2
- Meeker 2
- Morrison 2
- Rice 2
- Steele 2
- Wadena 2
- Winona 2
- Blue Earth 1
- Carlton 1
- Chippewa 1
- Dodge 1
- …
state 1
- Minnesota · 156 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
603815 | 603815 | 2020-10-06 | Kittson | Minnesota | 27069 | 14 | 0 |
600573 | 600573 | 2020-10-05 | Kittson | Minnesota | 27069 | 14 | 0 |
539017 | 539017 | 2020-09-16 | Kittson | Minnesota | 27069 | 14 | 0 |
506670 | 506670 | 2020-09-06 | Lake of the Woods | Minnesota | 27077 | 14 | 1 |
503437 | 503437 | 2020-09-05 | Lake of the Woods | Minnesota | 27077 | 14 | 1 |
500203 | 500203 | 2020-09-04 | Lake of the Woods | Minnesota | 27077 | 14 | 1 |
480798 | 480798 | 2020-08-29 | Lac qui Parle | Minnesota | 27073 | 14 | 0 |
445252 | 445252 | 2020-08-18 | Clearwater | Minnesota | 27029 | 14 | 0 |
442026 | 442026 | 2020-08-17 | Clearwater | Minnesota | 27029 | 14 | 0 |
438799 | 438799 | 2020-08-16 | Clearwater | Minnesota | 27029 | 14 | 0 |
435574 | 435574 | 2020-08-15 | Clearwater | Minnesota | 27029 | 14 | 0 |
432348 | 432348 | 2020-08-14 | Clearwater | Minnesota | 27029 | 14 | 0 |
429121 | 429121 | 2020-08-13 | Clearwater | Minnesota | 27029 | 14 | 0 |
425897 | 425897 | 2020-08-12 | Clearwater | Minnesota | 27029 | 14 | 0 |
422675 | 422675 | 2020-08-11 | Clearwater | Minnesota | 27029 | 14 | 0 |
419453 | 419453 | 2020-08-10 | Clearwater | Minnesota | 27029 | 14 | 0 |
416232 | 416232 | 2020-08-09 | Clearwater | Minnesota | 27029 | 14 | 0 |
413012 | 413012 | 2020-08-08 | Clearwater | Minnesota | 27029 | 14 | 0 |
409792 | 409792 | 2020-08-07 | Clearwater | Minnesota | 27029 | 14 | 0 |
403354 | 403354 | 2020-08-05 | Clearwater | Minnesota | 27029 | 14 | 0 |
393707 | 393707 | 2020-08-02 | Clearwater | Minnesota | 27029 | 14 | 0 |
390490 | 390490 | 2020-08-01 | Clearwater | Minnesota | 27029 | 14 | 0 |
387273 | 387273 | 2020-07-31 | Clearwater | Minnesota | 27029 | 14 | 0 |
384055 | 384055 | 2020-07-30 | Clearwater | Minnesota | 27029 | 14 | 0 |
384078 | 384078 | 2020-07-30 | Lake | Minnesota | 27075 | 14 | 0 |
380838 | 380838 | 2020-07-29 | Clearwater | Minnesota | 27029 | 14 | 0 |
380861 | 380861 | 2020-07-29 | Lake | Minnesota | 27075 | 14 | 0 |
377644 | 377644 | 2020-07-28 | Lake | Minnesota | 27075 | 14 | 0 |
374429 | 374429 | 2020-07-27 | Lake | Minnesota | 27075 | 14 | 0 |
371194 | 371194 | 2020-07-26 | Clearwater | Minnesota | 27029 | 14 | 0 |
367984 | 367984 | 2020-07-25 | Clearwater | Minnesota | 27029 | 14 | 0 |
364777 | 364777 | 2020-07-24 | Clearwater | Minnesota | 27029 | 14 | 0 |
361570 | 361570 | 2020-07-23 | Clearwater | Minnesota | 27029 | 14 | 0 |
361629 | 361629 | 2020-07-23 | Stevens | Minnesota | 27149 | 14 | 0 |
358365 | 358365 | 2020-07-22 | Clearwater | Minnesota | 27029 | 14 | 0 |
358388 | 358388 | 2020-07-22 | Lake | Minnesota | 27075 | 14 | 0 |
358424 | 358424 | 2020-07-22 | Stevens | Minnesota | 27149 | 14 | 0 |
355162 | 355162 | 2020-07-21 | Clearwater | Minnesota | 27029 | 14 | 0 |
355185 | 355185 | 2020-07-21 | Lake | Minnesota | 27075 | 14 | 0 |
355221 | 355221 | 2020-07-21 | Stevens | Minnesota | 27149 | 14 | 0 |
351960 | 351960 | 2020-07-20 | Clearwater | Minnesota | 27029 | 14 | 0 |
348760 | 348760 | 2020-07-19 | Clearwater | Minnesota | 27029 | 14 | 0 |
345559 | 345559 | 2020-07-18 | Clearwater | Minnesota | 27029 | 14 | 0 |
339163 | 339163 | 2020-07-16 | Clearwater | Minnesota | 27029 | 14 | 0 |
335967 | 335967 | 2020-07-15 | Clearwater | Minnesota | 27029 | 14 | 0 |
332774 | 332774 | 2020-07-14 | Clearwater | Minnesota | 27029 | 14 | 0 |
332819 | 332819 | 2020-07-14 | Pope | Minnesota | 27121 | 14 | 0 |
307370 | 307370 | 2020-07-06 | Kanabec | Minnesota | 27065 | 14 | 1 |
304176 | 304176 | 2020-07-05 | Big Stone | Minnesota | 27011 | 14 | 0 |
304203 | 304203 | 2020-07-05 | Kanabec | Minnesota | 27065 | 14 | 1 |
301007 | 301007 | 2020-07-04 | Aitkin | Minnesota | 27001 | 14 | 0 |
301012 | 301012 | 2020-07-04 | Big Stone | Minnesota | 27011 | 14 | 0 |
301039 | 301039 | 2020-07-04 | Kanabec | Minnesota | 27065 | 14 | 1 |
301042 | 301042 | 2020-07-04 | Koochiching | Minnesota | 27071 | 14 | 1 |
297844 | 297844 | 2020-07-03 | Aitkin | Minnesota | 27001 | 14 | 0 |
297849 | 297849 | 2020-07-03 | Big Stone | Minnesota | 27011 | 14 | 0 |
297876 | 297876 | 2020-07-03 | Kanabec | Minnesota | 27065 | 14 | 1 |
297879 | 297879 | 2020-07-03 | Koochiching | Minnesota | 27071 | 14 | 1 |
294686 | 294686 | 2020-07-02 | Aitkin | Minnesota | 27001 | 14 | 0 |
294691 | 294691 | 2020-07-02 | Big Stone | Minnesota | 27011 | 14 | 0 |
294696 | 294696 | 2020-07-02 | Cass | Minnesota | 27021 | 14 | 2 |
294718 | 294718 | 2020-07-02 | Kanabec | Minnesota | 27065 | 14 | 1 |
294721 | 294721 | 2020-07-02 | Koochiching | Minnesota | 27071 | 14 | 1 |
291532 | 291532 | 2020-07-01 | Aitkin | Minnesota | 27001 | 14 | 0 |
291537 | 291537 | 2020-07-01 | Big Stone | Minnesota | 27011 | 14 | 0 |
291564 | 291564 | 2020-07-01 | Kanabec | Minnesota | 27065 | 14 | 1 |
291567 | 291567 | 2020-07-01 | Koochiching | Minnesota | 27071 | 14 | 1 |
288381 | 288381 | 2020-06-30 | Aitkin | Minnesota | 27001 | 14 | 0 |
288386 | 288386 | 2020-06-30 | Big Stone | Minnesota | 27011 | 14 | 0 |
288413 | 288413 | 2020-06-30 | Kanabec | Minnesota | 27065 | 14 | 1 |
285236 | 285236 | 2020-06-29 | Big Stone | Minnesota | 27011 | 14 | 0 |
285263 | 285263 | 2020-06-29 | Kanabec | Minnesota | 27065 | 14 | 1 |
282091 | 282091 | 2020-06-28 | Big Stone | Minnesota | 27011 | 14 | 0 |
282148 | 282148 | 2020-06-28 | Redwood | Minnesota | 27127 | 14 | 0 |
278943 | 278943 | 2020-06-27 | Big Stone | Minnesota | 27011 | 14 | 0 |
279000 | 279000 | 2020-06-27 | Redwood | Minnesota | 27127 | 14 | 0 |
275795 | 275795 | 2020-06-26 | Big Stone | Minnesota | 27011 | 14 | 0 |
275852 | 275852 | 2020-06-26 | Redwood | Minnesota | 27127 | 14 | 0 |
272652 | 272652 | 2020-06-25 | Big Stone | Minnesota | 27011 | 14 | 0 |
269515 | 269515 | 2020-06-24 | Big Stone | Minnesota | 27011 | 14 | 0 |
269589 | 269589 | 2020-06-24 | Wadena | Minnesota | 27159 | 14 | 0 |
266382 | 266382 | 2020-06-23 | Big Stone | Minnesota | 27011 | 14 | 0 |
266456 | 266456 | 2020-06-23 | Wadena | Minnesota | 27159 | 14 | 0 |
263256 | 263256 | 2020-06-22 | Big Stone | Minnesota | 27011 | 14 | 0 |
260127 | 260127 | 2020-06-21 | Big Stone | Minnesota | 27011 | 14 | 0 |
260179 | 260179 | 2020-06-21 | Pipestone | Minnesota | 27117 | 14 | 0 |
257001 | 257001 | 2020-06-20 | Big Stone | Minnesota | 27011 | 14 | 0 |
257053 | 257053 | 2020-06-20 | Pipestone | Minnesota | 27117 | 14 | 0 |
253881 | 253881 | 2020-06-19 | Big Stone | Minnesota | 27011 | 14 | 0 |
253933 | 253933 | 2020-06-19 | Pipestone | Minnesota | 27117 | 14 | 0 |
253962 | 253962 | 2020-06-19 | Yellow Medicine | Minnesota | 27173 | 14 | 0 |
250766 | 250766 | 2020-06-18 | Big Stone | Minnesota | 27011 | 14 | 0 |
250818 | 250818 | 2020-06-18 | Pipestone | Minnesota | 27117 | 14 | 0 |
247654 | 247654 | 2020-06-17 | Big Stone | Minnesota | 27011 | 14 | 0 |
247706 | 247706 | 2020-06-17 | Pipestone | Minnesota | 27117 | 14 | 0 |
244593 | 244593 | 2020-06-16 | Pipestone | Minnesota | 27117 | 14 | 0 |
241482 | 241482 | 2020-06-15 | Pipestone | Minnesota | 27117 | 14 | 0 |
238373 | 238373 | 2020-06-14 | Pipestone | Minnesota | 27117 | 14 | 0 |
235292 | 235292 | 2020-06-13 | Wilkin | Minnesota | 27167 | 14 | 3 |
225954 | 225954 | 2020-06-10 | Pipestone | Minnesota | 27117 | 14 | 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);