ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where fips = 27055 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 482 ✖
- 1 32
- 2 29
- 1746 13
- 33 10
- 1751 10
- 1740 9
- 5 8
- 1747 8
- 1736 7
- 32 5
- 1614 5
- 25 4
- 37 4
- 39 4
- 65 4
- 1618 4
- 1720 4
- 1937 4
- 3045 4
- 3160 4
- 3463 4
- 4260 4
- 3 3
- 40 3
- 1583 3
- 1597 3
- 1610 3
- 1626 3
- 1753 3
- 1754 3
- 1765 3
- 1788 3
- 1828 3
- 1857 3
- 1899 3
- 1974 3
- 2038 3
- 2112 3
- 2166 3
- 2227 3
- 2290 3
- 2311 3
- 2360 3
- 2439 3
- 2508 3
- 2599 3
- 2668 3
- 2753 3
- 2847 3
- 2955 3
- 3282 3
- 3660 3
- 3826 3
- 3948 3
- 4052 3
- 4395 3
- 4463 3
- 4482 3
- 4491 3
- 4506 3
- 4512 3
- 4536 3
- 4546 3
- 4563 3
- 4587 3
- 4625 3
- 7 2
- 13 2
- 15 2
- 24 2
- 29 2
- 34 2
- 42 2
- 63 2
- 77 2
- 89 2
- 93 2
- 104 2
- 128 2
- 146 2
- 154 2
- 163 2
- 164 2
- 181 2
- 642 2
- 1132 2
- 1185 2
- 1356 2
- 1549 2
- 1559 2
- 1573 2
- 1582 2
- 1588 2
- 1589 2
- 1596 2
- 1598 2
- 1616 2
- 1716 2
- 1726 2
- 1727 2
- 1732 2
- 1749 2
- 1759 2
- 2648 2
- 4468 2
- 4485 2
- 4509 2
- 4 1
- 8 1
- 10 1
- 16 1
- 17 1
- 20 1
- 21 1
- 23 1
- 26 1
- 27 1
- 28 1
- 38 1
- 41 1
- 44 1
- 45 1
- 49 1
- 52 1
- 57 1
- 59 1
- 60 1
- 66 1
- 67 1
- 69 1
- 70 1
- 74 1
- 76 1
- 80 1
- 81 1
- 83 1
- 84 1
- 86 1
- 88 1
- 91 1
- 92 1
- 96 1
- 97 1
- 105 1
- 107 1
- 110 1
- 114 1
- 115 1
- 117 1
- 121 1
- 125 1
- 127 1
- 130 1
- 135 1
- 136 1
- 142 1
- 148 1
- 156 1
- 161 1
- 168 1
- 169 1
- 174 1
- 177 1
- 180 1
- 183 1
- 186 1
- 195 1
- 197 1
- 204 1
- 206 1
- 212 1
- 220 1
- 238 1
- 249 1
- 255 1
- 260 1
- 262 1
- 269 1
- 290 1
- 303 1
- 318 1
- 336 1
- 344 1
- 358 1
- 372 1
- 394 1
- 412 1
- 438 1
- 456 1
- 482 1
- 508 1
- 514 1
- 524 1
- 543 1
- 567 1
- 582 1
- 601 1
- 615 1
- 624 1
- 653 1
- 685 1
- 698 1
- 713 1
- 734 1
- 769 1
- 800 1
- 813 1
- 833 1
- 854 1
- 868 1
- 883 1
- 905 1
- 927 1
- 951 1
- 984 1
- 994 1
- 996 1
- 1004 1
- 1029 1
- 1044 1
- 1058 1
- 1067 1
- 1074 1
- 1080 1
- 1089 1
- 1118 1
- 1146 1
- 1154 1
- 1156 1
- 1164 1
- 1171 1
- 1198 1
- 1200 1
- 1212 1
- 1217 1
- 1243 1
- 1257 1
- 1273 1
- 1280 1
- 1299 1
- 1300 1
- 1305 1
- 1313 1
- 1332 1
- 1336 1
- 1353 1
- 1359 1
- 1372 1
- 1390 1
- 1397 1
- 1398 1
- 1400 1
- 1403 1
- 1411 1
- 1422 1
- 1435 1
- 1439 1
- 1451 1
- 1453 1
- 1457 1
- 1462 1
- 1467 1
- 1487 1
- 1499 1
- 1512 1
- 1521 1
- 1524 1
- 1525 1
- 1532 1
- 1537 1
- 1543 1
- 1546 1
- 1547 1
- 1548 1
- 1552 1
- 1555 1
- 1560 1
- 1562 1
- 1564 1
- 1567 1
- 1569 1
- 1571 1
- 1572 1
- 1574 1
- 1580 1
- 1581 1
- 1584 1
- 1586 1
- 1587 1
- 1599 1
- 1611 1
- 1612 1
- 1613 1
- 1617 1
- 1619 1
- 1620 1
- 1621 1
- 1624 1
- 1625 1
- 1627 1
- 1630 1
- 1631 1
- 1640 1
- 1643 1
- 1649 1
- 1653 1
- 1654 1
- 1655 1
- 1661 1
- 1662 1
- 1667 1
- 1668 1
- 1669 1
- 1692 1
- 1702 1
- 1705 1
- 1709 1
- 1713 1
- 1714 1
- 1715 1
- 1718 1
- 1719 1
- 1728 1
- 1729 1
- 1731 1
- 1739 1
- 1750 1
- 1752 1
- 1755 1
- 1760 1
- 1767 1
- 1779 1
- 1781 1
- 1787 1
- 1796 1
- 1805 1
- 1811 1
- 1819 1
- 1834 1
- 1847 1
- 1848 1
- 1850 1
- 1862 1
- 1875 1
- 1878 1
- 1885 1
- 1902 1
- 1914 1
- 1918 1
- 1927 1
- 1941 1
- 1961 1
- 1963 1
- 1982 1
- 2004 1
- 2016 1
- 2027 1
- 2054 1
- 2068 1
- 2074 1
- 2098 1
- 2118 1
- 2129 1
- 2141 1
- 2143 1
- 2179 1
- 2199 1
- 2211 1
- 2218 1
- 2235 1
- 2260 1
- 2264 1
- 2276 1
- 2291 1
- 2300 1
- 2305 1
- 2310 1
- 2325 1
- 2342 1
- 2345 1
- 2359 1
- 2384 1
- 2401 1
- 2416 1
- 2431 1
- 2452 1
- 2462 1
- 2483 1
- 2495 1
- 2526 1
- 2557 1
- 2561 1
- 2584 1
- 2611 1
- 2638 1
- 2687 1
- 2707 1
- 2720 1
- 2724 1
- 2778 1
- 2811 1
- 2815 1
- 2837 1
- 2856 1
- 2893 1
- 2908 1
- 2927 1
- 2976 1
- 3007 1
- 3018 1
- 3075 1
- 3112 1
- 3128 1
- 3177 1
- 3210 1
- 3244 1
- 3259 1
- 3296 1
- 3398 1
- 3419 1
- 3446 1
- 3497 1
- 3608 1
- 3632 1
- 3682 1
- 3733 1
- 3755 1
- 3802 1
- 3849 1
- 3889 1
- 3913 1
- 3937 1
- 3966 1
- 4002 1
- 4018 1
- 4028 1
- 4074 1
- 4105 1
- 4114 1
- 4135 1
- 4319 1
- 4371 1
- 4373 1
- 4409 1
- 4423 1
- 4435 1
- 4456 1
- 4464 1
- 4470 1
- 4483 1
- 4488 1
- 4493 1
- 4494 1
- 4496 1
- 4501 1
- 4505 1
- 4510 1
- 4515 1
- 4522 1
- 4523 1
- 4530 1
- 4538 1
- 4539 1
- 4542 1
- 4544 1
- 4548 1
- 4550 1
- 4556 1
- 4557 1
- 4566 1
- 4573 1
- 4577 1
- 4583 1
- 4591 1
- 4599 1
- 4601 1
- 4615 1
- 4629 1
- 4640 1
- 4648 1
- 4653 1
- 4660 1
state 1
- Minnesota · 769 ✖
fips 1
- 27055 · 769 ✖
county 1
- Houston 769
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500932 | 2500932 | 2022-05-13 | Houston | Minnesota | 27055 | 4660 | 19 |
2497674 | 2497674 | 2022-05-12 | Houston | Minnesota | 27055 | 4653 | 19 |
2494416 | 2494416 | 2022-05-11 | Houston | Minnesota | 27055 | 4648 | 18 |
2491158 | 2491158 | 2022-05-10 | Houston | Minnesota | 27055 | 4640 | 18 |
2487901 | 2487901 | 2022-05-09 | Houston | Minnesota | 27055 | 4629 | 18 |
2484643 | 2484643 | 2022-05-08 | Houston | Minnesota | 27055 | 4625 | 18 |
2481385 | 2481385 | 2022-05-07 | Houston | Minnesota | 27055 | 4625 | 18 |
2478127 | 2478127 | 2022-05-06 | Houston | Minnesota | 27055 | 4625 | 18 |
2474869 | 2474869 | 2022-05-05 | Houston | Minnesota | 27055 | 4615 | 18 |
2471612 | 2471612 | 2022-05-04 | Houston | Minnesota | 27055 | 4601 | 18 |
2468356 | 2468356 | 2022-05-03 | Houston | Minnesota | 27055 | 4599 | 18 |
2465101 | 2465101 | 2022-05-02 | Houston | Minnesota | 27055 | 4591 | 18 |
2461845 | 2461845 | 2022-05-01 | Houston | Minnesota | 27055 | 4587 | 18 |
2458589 | 2458589 | 2022-04-30 | Houston | Minnesota | 27055 | 4587 | 18 |
2455333 | 2455333 | 2022-04-29 | Houston | Minnesota | 27055 | 4587 | 18 |
2452077 | 2452077 | 2022-04-28 | Houston | Minnesota | 27055 | 4583 | 18 |
2448821 | 2448821 | 2022-04-27 | Houston | Minnesota | 27055 | 4577 | 18 |
2445565 | 2445565 | 2022-04-26 | Houston | Minnesota | 27055 | 4573 | 18 |
2442309 | 2442309 | 2022-04-25 | Houston | Minnesota | 27055 | 4566 | 18 |
2439053 | 2439053 | 2022-04-24 | Houston | Minnesota | 27055 | 4563 | 18 |
2435797 | 2435797 | 2022-04-23 | Houston | Minnesota | 27055 | 4563 | 18 |
2432541 | 2432541 | 2022-04-22 | Houston | Minnesota | 27055 | 4563 | 18 |
2429285 | 2429285 | 2022-04-21 | Houston | Minnesota | 27055 | 4557 | 18 |
2426029 | 2426029 | 2022-04-20 | Houston | Minnesota | 27055 | 4556 | 18 |
2422773 | 2422773 | 2022-04-19 | Houston | Minnesota | 27055 | 4550 | 18 |
2419517 | 2419517 | 2022-04-18 | Houston | Minnesota | 27055 | 4548 | 18 |
2416261 | 2416261 | 2022-04-17 | Houston | Minnesota | 27055 | 4546 | 18 |
2413005 | 2413005 | 2022-04-16 | Houston | Minnesota | 27055 | 4546 | 18 |
2409749 | 2409749 | 2022-04-15 | Houston | Minnesota | 27055 | 4546 | 18 |
2406493 | 2406493 | 2022-04-14 | Houston | Minnesota | 27055 | 4544 | 18 |
2403237 | 2403237 | 2022-04-13 | Houston | Minnesota | 27055 | 4542 | 18 |
2399983 | 2399983 | 2022-04-12 | Houston | Minnesota | 27055 | 4539 | 18 |
2396727 | 2396727 | 2022-04-11 | Houston | Minnesota | 27055 | 4538 | 18 |
2393472 | 2393472 | 2022-04-10 | Houston | Minnesota | 27055 | 4536 | 18 |
2390216 | 2390216 | 2022-04-09 | Houston | Minnesota | 27055 | 4536 | 18 |
2386960 | 2386960 | 2022-04-08 | Houston | Minnesota | 27055 | 4536 | 18 |
2383705 | 2383705 | 2022-04-07 | Houston | Minnesota | 27055 | 4530 | 18 |
2380450 | 2380450 | 2022-04-06 | Houston | Minnesota | 27055 | 4523 | 18 |
2377195 | 2377195 | 2022-04-05 | Houston | Minnesota | 27055 | 4522 | 18 |
2373943 | 2373943 | 2022-04-04 | Houston | Minnesota | 27055 | 4515 | 18 |
2370690 | 2370690 | 2022-04-03 | Houston | Minnesota | 27055 | 4512 | 18 |
2367437 | 2367437 | 2022-04-02 | Houston | Minnesota | 27055 | 4512 | 18 |
2364184 | 2364184 | 2022-04-01 | Houston | Minnesota | 27055 | 4512 | 18 |
2360930 | 2360930 | 2022-03-31 | Houston | Minnesota | 27055 | 4510 | 18 |
2357676 | 2357676 | 2022-03-30 | Houston | Minnesota | 27055 | 4509 | 18 |
2354423 | 2354423 | 2022-03-29 | Houston | Minnesota | 27055 | 4509 | 18 |
2351171 | 2351171 | 2022-03-28 | Houston | Minnesota | 27055 | 4505 | 18 |
2347918 | 2347918 | 2022-03-27 | Houston | Minnesota | 27055 | 4506 | 18 |
2344665 | 2344665 | 2022-03-26 | Houston | Minnesota | 27055 | 4506 | 18 |
2341412 | 2341412 | 2022-03-25 | Houston | Minnesota | 27055 | 4506 | 18 |
2338159 | 2338159 | 2022-03-24 | Houston | Minnesota | 27055 | 4501 | 18 |
2334905 | 2334905 | 2022-03-23 | Houston | Minnesota | 27055 | 4496 | 18 |
2331651 | 2331651 | 2022-03-22 | Houston | Minnesota | 27055 | 4494 | 18 |
2328399 | 2328399 | 2022-03-21 | Houston | Minnesota | 27055 | 4493 | 18 |
2325146 | 2325146 | 2022-03-20 | Houston | Minnesota | 27055 | 4491 | 18 |
2321892 | 2321892 | 2022-03-19 | Houston | Minnesota | 27055 | 4491 | 18 |
2318638 | 2318638 | 2022-03-18 | Houston | Minnesota | 27055 | 4491 | 18 |
2315385 | 2315385 | 2022-03-17 | Houston | Minnesota | 27055 | 4488 | 18 |
2312132 | 2312132 | 2022-03-16 | Houston | Minnesota | 27055 | 4485 | 18 |
2308879 | 2308879 | 2022-03-15 | Houston | Minnesota | 27055 | 4485 | 18 |
2305628 | 2305628 | 2022-03-14 | Houston | Minnesota | 27055 | 4483 | 18 |
2302376 | 2302376 | 2022-03-13 | Houston | Minnesota | 27055 | 4482 | 18 |
2299124 | 2299124 | 2022-03-12 | Houston | Minnesota | 27055 | 4482 | 18 |
2295872 | 2295872 | 2022-03-11 | Houston | Minnesota | 27055 | 4482 | 18 |
2292620 | 2292620 | 2022-03-10 | Houston | Minnesota | 27055 | 4470 | 18 |
2289368 | 2289368 | 2022-03-09 | Houston | Minnesota | 27055 | 4468 | 18 |
2286117 | 2286117 | 2022-03-08 | Houston | Minnesota | 27055 | 4468 | 18 |
2282865 | 2282865 | 2022-03-07 | Houston | Minnesota | 27055 | 4464 | 18 |
2279612 | 2279612 | 2022-03-06 | Houston | Minnesota | 27055 | 4463 | 18 |
2276359 | 2276359 | 2022-03-05 | Houston | Minnesota | 27055 | 4463 | 18 |
2273106 | 2273106 | 2022-03-04 | Houston | Minnesota | 27055 | 4463 | 18 |
2269854 | 2269854 | 2022-03-03 | Houston | Minnesota | 27055 | 4456 | 18 |
2266601 | 2266601 | 2022-03-02 | Houston | Minnesota | 27055 | 4435 | 18 |
2263350 | 2263350 | 2022-03-01 | Houston | Minnesota | 27055 | 4423 | 18 |
2260099 | 2260099 | 2022-02-28 | Houston | Minnesota | 27055 | 4409 | 18 |
2256848 | 2256848 | 2022-02-27 | Houston | Minnesota | 27055 | 4395 | 18 |
2253597 | 2253597 | 2022-02-26 | Houston | Minnesota | 27055 | 4395 | 18 |
2250346 | 2250346 | 2022-02-25 | Houston | Minnesota | 27055 | 4395 | 18 |
2247095 | 2247095 | 2022-02-24 | Houston | Minnesota | 27055 | 4373 | 18 |
2243844 | 2243844 | 2022-02-23 | Houston | Minnesota | 27055 | 4371 | 18 |
2240593 | 2240593 | 2022-02-22 | Houston | Minnesota | 27055 | 4319 | 18 |
2237342 | 2237342 | 2022-02-21 | Houston | Minnesota | 27055 | 4260 | 18 |
2234091 | 2234091 | 2022-02-20 | Houston | Minnesota | 27055 | 4260 | 18 |
2230840 | 2230840 | 2022-02-19 | Houston | Minnesota | 27055 | 4260 | 18 |
2227589 | 2227589 | 2022-02-18 | Houston | Minnesota | 27055 | 4260 | 18 |
2224338 | 2224338 | 2022-02-17 | Houston | Minnesota | 27055 | 4135 | 18 |
2221087 | 2221087 | 2022-02-16 | Houston | Minnesota | 27055 | 4114 | 18 |
2217836 | 2217836 | 2022-02-15 | Houston | Minnesota | 27055 | 4105 | 18 |
2214585 | 2214585 | 2022-02-14 | Houston | Minnesota | 27055 | 4074 | 18 |
2211333 | 2211333 | 2022-02-13 | Houston | Minnesota | 27055 | 4052 | 18 |
2208080 | 2208080 | 2022-02-12 | Houston | Minnesota | 27055 | 4052 | 18 |
2204827 | 2204827 | 2022-02-11 | Houston | Minnesota | 27055 | 4052 | 18 |
2201574 | 2201574 | 2022-02-10 | Houston | Minnesota | 27055 | 4028 | 18 |
2198320 | 2198320 | 2022-02-09 | Houston | Minnesota | 27055 | 4018 | 18 |
2195066 | 2195066 | 2022-02-08 | Houston | Minnesota | 27055 | 4002 | 18 |
2191812 | 2191812 | 2022-02-07 | Houston | Minnesota | 27055 | 3966 | 18 |
2188559 | 2188559 | 2022-02-06 | Houston | Minnesota | 27055 | 3948 | 18 |
2185306 | 2185306 | 2022-02-05 | Houston | Minnesota | 27055 | 3948 | 18 |
2182054 | 2182054 | 2022-02-04 | Houston | Minnesota | 27055 | 3948 | 18 |
2178802 | 2178802 | 2022-02-03 | Houston | Minnesota | 27055 | 3937 | 18 |
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);