ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 27087 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 371 ✖
- 566 39
- 1 34
- 6 28
- 565 28
- 5 15
- 2 10
- 1753 8
- 7 7
- 441 7
- 569 7
- 27 6
- 426 6
- 10 5
- 18 5
- 35 5
- 37 5
- 46 5
- 49 5
- 397 5
- 453 5
- 489 5
- 628 5
- 1755 5
- 1758 5
- 1765 5
- 3 4
- 13 4
- 17 4
- 32 4
- 41 4
- 410 4
- 443 4
- 448 4
- 545 4
- 571 4
- 1152 4
- 1160 4
- 1224 4
- 1646 4
- 1699 4
- 1745 4
- 1748 4
- 8 3
- 20 3
- 26 3
- 28 3
- 45 3
- 390 3
- 423 3
- 429 3
- 454 3
- 479 3
- 517 3
- 536 3
- 567 3
- 587 3
- 614 3
- 651 3
- 681 3
- 733 3
- 772 3
- 814 3
- 863 3
- 903 3
- 930 3
- 965 3
- 995 3
- 1035 3
- 1047 3
- 1083 3
- 1104 3
- 1139 3
- 1181 3
- 1290 3
- 1375 3
- 1466 3
- 1571 3
- 1688 3
- 1779 3
- 1785 3
- 1794 3
- 16 2
- 22 2
- 23 2
- 33 2
- 36 2
- 38 2
- 39 2
- 48 2
- 59 2
- 76 2
- 78 2
- 270 2
- 365 2
- 366 2
- 384 2
- 396 2
- 406 2
- 407 2
- 414 2
- 416 2
- 417 2
- 422 2
- 431 2
- 447 2
- 467 2
- 508 2
- 540 2
- 541 2
- 553 2
- 554 2
- 560 2
- 562 2
- 564 2
- 572 2
- 954 2
- 1045 2
- 1158 2
- 1170 2
- 1750 2
- 1780 2
- 1784 2
- 1787 2
- 1799 2
- 9 1
- 15 1
- 24 1
- 25 1
- 29 1
- 30 1
- 31 1
- 42 1
- 44 1
- 50 1
- 55 1
- 62 1
- 64 1
- 65 1
- 72 1
- 79 1
- 85 1
- 88 1
- 91 1
- 94 1
- 97 1
- 101 1
- 104 1
- 106 1
- 110 1
- 113 1
- 116 1
- 117 1
- 128 1
- 129 1
- 134 1
- 138 1
- 139 1
- 140 1
- 141 1
- 142 1
- 146 1
- 149 1
- 150 1
- 155 1
- 156 1
- 159 1
- 161 1
- 167 1
- 168 1
- 179 1
- 182 1
- 187 1
- 198 1
- 210 1
- 216 1
- 219 1
- 231 1
- 240 1
- 249 1
- 255 1
- 283 1
- 290 1
- 296 1
- 304 1
- 307 1
- 316 1
- 322 1
- 325 1
- 329 1
- 334 1
- 337 1
- 339 1
- 345 1
- 347 1
- 352 1
- 356 1
- 358 1
- 361 1
- 362 1
- 369 1
- 370 1
- 378 1
- 379 1
- 386 1
- 395 1
- 399 1
- 400 1
- 402 1
- 404 1
- 405 1
- 408 1
- 413 1
- 419 1
- 420 1
- 421 1
- 425 1
- 427 1
- 430 1
- 432 1
- 433 1
- 434 1
- 435 1
- 436 1
- 437 1
- 440 1
- 444 1
- 446 1
- 455 1
- 458 1
- 463 1
- 466 1
- 468 1
- 475 1
- 477 1
- 480 1
- 482 1
- 487 1
- 488 1
- 494 1
- 497 1
- 504 1
- 511 1
- 520 1
- 525 1
- 526 1
- 528 1
- 531 1
- 532 1
- 533 1
- 544 1
- 546 1
- 549 1
- 555 1
- 559 1
- 574 1
- 584 1
- 590 1
- 593 1
- 595 1
- 604 1
- 615 1
- 620 1
- 622 1
- 627 1
- 633 1
- 642 1
- 654 1
- 661 1
- 662 1
- 673 1
- 690 1
- 705 1
- 706 1
- 723 1
- 738 1
- 749 1
- 755 1
- 760 1
- 779 1
- 789 1
- 795 1
- 807 1
- 816 1
- 828 1
- 836 1
- 843 1
- 874 1
- 877 1
- 887 1
- 893 1
- 912 1
- 921 1
- 922 1
- 928 1
- 945 1
- 961 1
- 970 1
- 977 1
- 980 1
- 988 1
- 1001 1
- 1014 1
- 1020 1
- 1032 1
- 1037 1
- 1042 1
- 1054 1
- 1059 1
- 1060 1
- 1064 1
- 1085 1
- 1089 1
- 1095 1
- 1101 1
- 1111 1
- 1123 1
- 1129 1
- 1136 1
- 1141 1
- 1144 1
- 1148 1
- 1153 1
- 1164 1
- 1173 1
- 1191 1
- 1212 1
- 1213 1
- 1215 1
- 1231 1
- 1256 1
- 1271 1
- 1296 1
- 1314 1
- 1332 1
- 1365 1
- 1400 1
- 1420 1
- 1432 1
- 1450 1
- 1492 1
- 1512 1
- 1548 1
- 1567 1
- 1590 1
- 1596 1
- 1602 1
- 1616 1
- 1657 1
- 1668 1
- 1670 1
- 1691 1
- 1696 1
- 1697 1
- 1701 1
- 1704 1
- 1706 1
- 1707 1
- 1746 1
- 1747 1
- 1756 1
- 1757 1
- 1759 1
- 1761 1
- 1766 1
- 1774 1
- 1776 1
- 1789 1
- 1791 1
- 1798 1
- 1801 1
- 1803 1
state 1
- Minnesota · 778 ✖
fips 1
- 27087 · 778 ✖
county 1
- Mahnomen 778
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500947 | 2500947 | 2022-05-13 | Mahnomen | Minnesota | 27087 | 1803 | 18 |
2497689 | 2497689 | 2022-05-12 | Mahnomen | Minnesota | 27087 | 1801 | 17 |
2494431 | 2494431 | 2022-05-11 | Mahnomen | Minnesota | 27087 | 1799 | 17 |
2491173 | 2491173 | 2022-05-10 | Mahnomen | Minnesota | 27087 | 1799 | 17 |
2487916 | 2487916 | 2022-05-09 | Mahnomen | Minnesota | 27087 | 1798 | 17 |
2484658 | 2484658 | 2022-05-08 | Mahnomen | Minnesota | 27087 | 1794 | 17 |
2481400 | 2481400 | 2022-05-07 | Mahnomen | Minnesota | 27087 | 1794 | 17 |
2478142 | 2478142 | 2022-05-06 | Mahnomen | Minnesota | 27087 | 1794 | 17 |
2474884 | 2474884 | 2022-05-05 | Mahnomen | Minnesota | 27087 | 1791 | 17 |
2471627 | 2471627 | 2022-05-04 | Mahnomen | Minnesota | 27087 | 1789 | 17 |
2468371 | 2468371 | 2022-05-03 | Mahnomen | Minnesota | 27087 | 1787 | 17 |
2465116 | 2465116 | 2022-05-02 | Mahnomen | Minnesota | 27087 | 1787 | 17 |
2461860 | 2461860 | 2022-05-01 | Mahnomen | Minnesota | 27087 | 1785 | 17 |
2458604 | 2458604 | 2022-04-30 | Mahnomen | Minnesota | 27087 | 1785 | 17 |
2455348 | 2455348 | 2022-04-29 | Mahnomen | Minnesota | 27087 | 1785 | 17 |
2452092 | 2452092 | 2022-04-28 | Mahnomen | Minnesota | 27087 | 1784 | 17 |
2448836 | 2448836 | 2022-04-27 | Mahnomen | Minnesota | 27087 | 1784 | 17 |
2445580 | 2445580 | 2022-04-26 | Mahnomen | Minnesota | 27087 | 1780 | 17 |
2442324 | 2442324 | 2022-04-25 | Mahnomen | Minnesota | 27087 | 1780 | 17 |
2439068 | 2439068 | 2022-04-24 | Mahnomen | Minnesota | 27087 | 1779 | 17 |
2435812 | 2435812 | 2022-04-23 | Mahnomen | Minnesota | 27087 | 1779 | 17 |
2432556 | 2432556 | 2022-04-22 | Mahnomen | Minnesota | 27087 | 1779 | 17 |
2429300 | 2429300 | 2022-04-21 | Mahnomen | Minnesota | 27087 | 1776 | 17 |
2426044 | 2426044 | 2022-04-20 | Mahnomen | Minnesota | 27087 | 1774 | 17 |
2422788 | 2422788 | 2022-04-19 | Mahnomen | Minnesota | 27087 | 1766 | 17 |
2419532 | 2419532 | 2022-04-18 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2416276 | 2416276 | 2022-04-17 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2413020 | 2413020 | 2022-04-16 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2409764 | 2409764 | 2022-04-15 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2406508 | 2406508 | 2022-04-14 | Mahnomen | Minnesota | 27087 | 1765 | 17 |
2403252 | 2403252 | 2022-04-13 | Mahnomen | Minnesota | 27087 | 1761 | 17 |
2399998 | 2399998 | 2022-04-12 | Mahnomen | Minnesota | 27087 | 1759 | 17 |
2396742 | 2396742 | 2022-04-11 | Mahnomen | Minnesota | 27087 | 1758 | 17 |
2393487 | 2393487 | 2022-04-10 | Mahnomen | Minnesota | 27087 | 1758 | 17 |
2390231 | 2390231 | 2022-04-09 | Mahnomen | Minnesota | 27087 | 1758 | 17 |
2386975 | 2386975 | 2022-04-08 | Mahnomen | Minnesota | 27087 | 1758 | 17 |
2383720 | 2383720 | 2022-04-07 | Mahnomen | Minnesota | 27087 | 1758 | 17 |
2380465 | 2380465 | 2022-04-06 | Mahnomen | Minnesota | 27087 | 1757 | 17 |
2377210 | 2377210 | 2022-04-05 | Mahnomen | Minnesota | 27087 | 1756 | 17 |
2373958 | 2373958 | 2022-04-04 | Mahnomen | Minnesota | 27087 | 1755 | 17 |
2370705 | 2370705 | 2022-04-03 | Mahnomen | Minnesota | 27087 | 1755 | 17 |
2367452 | 2367452 | 2022-04-02 | Mahnomen | Minnesota | 27087 | 1755 | 17 |
2364199 | 2364199 | 2022-04-01 | Mahnomen | Minnesota | 27087 | 1755 | 17 |
2360945 | 2360945 | 2022-03-31 | Mahnomen | Minnesota | 27087 | 1755 | 17 |
2357691 | 2357691 | 2022-03-30 | Mahnomen | Minnesota | 27087 | 1753 | 17 |
2354438 | 2354438 | 2022-03-29 | Mahnomen | Minnesota | 27087 | 1753 | 17 |
2351186 | 2351186 | 2022-03-28 | Mahnomen | Minnesota | 27087 | 1753 | 17 |
2347933 | 2347933 | 2022-03-27 | Mahnomen | Minnesota | 27087 | 1753 | 17 |
2344680 | 2344680 | 2022-03-26 | Mahnomen | Minnesota | 27087 | 1753 | 17 |
2341427 | 2341427 | 2022-03-25 | Mahnomen | Minnesota | 27087 | 1753 | 17 |
2338174 | 2338174 | 2022-03-24 | Mahnomen | Minnesota | 27087 | 1753 | 17 |
2334920 | 2334920 | 2022-03-23 | Mahnomen | Minnesota | 27087 | 1753 | 17 |
2331666 | 2331666 | 2022-03-22 | Mahnomen | Minnesota | 27087 | 1750 | 17 |
2328414 | 2328414 | 2022-03-21 | Mahnomen | Minnesota | 27087 | 1750 | 17 |
2325161 | 2325161 | 2022-03-20 | Mahnomen | Minnesota | 27087 | 1748 | 17 |
2321907 | 2321907 | 2022-03-19 | Mahnomen | Minnesota | 27087 | 1748 | 17 |
2318653 | 2318653 | 2022-03-18 | Mahnomen | Minnesota | 27087 | 1748 | 17 |
2315400 | 2315400 | 2022-03-17 | Mahnomen | Minnesota | 27087 | 1748 | 17 |
2312147 | 2312147 | 2022-03-16 | Mahnomen | Minnesota | 27087 | 1747 | 17 |
2308894 | 2308894 | 2022-03-15 | Mahnomen | Minnesota | 27087 | 1746 | 17 |
2305643 | 2305643 | 2022-03-14 | Mahnomen | Minnesota | 27087 | 1745 | 17 |
2302391 | 2302391 | 2022-03-13 | Mahnomen | Minnesota | 27087 | 1745 | 17 |
2299139 | 2299139 | 2022-03-12 | Mahnomen | Minnesota | 27087 | 1745 | 17 |
2295887 | 2295887 | 2022-03-11 | Mahnomen | Minnesota | 27087 | 1745 | 17 |
2292635 | 2292635 | 2022-03-10 | Mahnomen | Minnesota | 27087 | 1707 | 17 |
2289383 | 2289383 | 2022-03-09 | Mahnomen | Minnesota | 27087 | 1706 | 17 |
2286132 | 2286132 | 2022-03-08 | Mahnomen | Minnesota | 27087 | 1704 | 17 |
2282880 | 2282880 | 2022-03-07 | Mahnomen | Minnesota | 27087 | 1701 | 17 |
2279627 | 2279627 | 2022-03-06 | Mahnomen | Minnesota | 27087 | 1699 | 17 |
2276374 | 2276374 | 2022-03-05 | Mahnomen | Minnesota | 27087 | 1699 | 17 |
2273121 | 2273121 | 2022-03-04 | Mahnomen | Minnesota | 27087 | 1699 | 17 |
2269869 | 2269869 | 2022-03-03 | Mahnomen | Minnesota | 27087 | 1699 | 17 |
2266616 | 2266616 | 2022-03-02 | Mahnomen | Minnesota | 27087 | 1696 | 17 |
2263365 | 2263365 | 2022-03-01 | Mahnomen | Minnesota | 27087 | 1697 | 17 |
2260114 | 2260114 | 2022-02-28 | Mahnomen | Minnesota | 27087 | 1691 | 17 |
2256863 | 2256863 | 2022-02-27 | Mahnomen | Minnesota | 27087 | 1688 | 17 |
2253612 | 2253612 | 2022-02-26 | Mahnomen | Minnesota | 27087 | 1688 | 17 |
2250361 | 2250361 | 2022-02-25 | Mahnomen | Minnesota | 27087 | 1688 | 17 |
2247110 | 2247110 | 2022-02-24 | Mahnomen | Minnesota | 27087 | 1670 | 17 |
2243859 | 2243859 | 2022-02-23 | Mahnomen | Minnesota | 27087 | 1668 | 17 |
2240608 | 2240608 | 2022-02-22 | Mahnomen | Minnesota | 27087 | 1657 | 17 |
2237357 | 2237357 | 2022-02-21 | Mahnomen | Minnesota | 27087 | 1646 | 17 |
2234106 | 2234106 | 2022-02-20 | Mahnomen | Minnesota | 27087 | 1646 | 17 |
2230855 | 2230855 | 2022-02-19 | Mahnomen | Minnesota | 27087 | 1646 | 17 |
2227604 | 2227604 | 2022-02-18 | Mahnomen | Minnesota | 27087 | 1646 | 17 |
2224353 | 2224353 | 2022-02-17 | Mahnomen | Minnesota | 27087 | 1616 | 17 |
2221102 | 2221102 | 2022-02-16 | Mahnomen | Minnesota | 27087 | 1602 | 17 |
2217851 | 2217851 | 2022-02-15 | Mahnomen | Minnesota | 27087 | 1596 | 17 |
2214600 | 2214600 | 2022-02-14 | Mahnomen | Minnesota | 27087 | 1590 | 17 |
2211348 | 2211348 | 2022-02-13 | Mahnomen | Minnesota | 27087 | 1571 | 17 |
2208095 | 2208095 | 2022-02-12 | Mahnomen | Minnesota | 27087 | 1571 | 17 |
2204842 | 2204842 | 2022-02-11 | Mahnomen | Minnesota | 27087 | 1571 | 17 |
2201589 | 2201589 | 2022-02-10 | Mahnomen | Minnesota | 27087 | 1567 | 17 |
2198335 | 2198335 | 2022-02-09 | Mahnomen | Minnesota | 27087 | 1548 | 17 |
2195081 | 2195081 | 2022-02-08 | Mahnomen | Minnesota | 27087 | 1512 | 17 |
2191827 | 2191827 | 2022-02-07 | Mahnomen | Minnesota | 27087 | 1492 | 17 |
2188574 | 2188574 | 2022-02-06 | Mahnomen | Minnesota | 27087 | 1466 | 17 |
2185321 | 2185321 | 2022-02-05 | Mahnomen | Minnesota | 27087 | 1466 | 17 |
2182069 | 2182069 | 2022-02-04 | Mahnomen | Minnesota | 27087 | 1466 | 17 |
2178817 | 2178817 | 2022-02-03 | Mahnomen | Minnesota | 27087 | 1450 | 17 |
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);