ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 27139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 663 ✖
- 20 6
- 10 4
- 18907 4
- 28404 4
- 29161 4
- 32518 4
- 39410 4
- 17567 3
- 17572 3
- 17582 3
- 17608 3
- 17686 3
- 17763 3
- 17875 3
- 18084 3
- 18316 3
- 18608 3
- 19182 3
- 19626 3
- 20039 3
- 20438 3
- 20877 3
- 21316 3
- 21652 3
- 22057 3
- 22716 3
- 23509 3
- 24533 3
- 25329 3
- 26281 3
- 27226 3
- 27880 3
- 30436 3
- 34571 3
- 36796 3
- 38184 3
- 38918 3
- 39609 3
- 39685 3
- 39904 3
- 39967 3
- 40014 3
- 40077 3
- 40144 3
- 40234 3
- 40353 3
- 40566 3
- 40862 3
- 2 2
- 5 2
- 6 2
- 19 2
- 23 2
- 27 2
- 32 2
- 168 2
- 700 2
- 7827 2
- 10693 2
- 11016 2
- 14999 2
- 17489 2
- 17548 2
- 17566 2
- 17581 2
- 25213 2
- 1 1
- 3 1
- 7 1
- 8 1
- 9 1
- 11 1
- 12 1
- 13 1
- 15 1
- 16 1
- 17 1
- 25 1
- 28 1
- 29 1
- 30 1
- 35 1
- 36 1
- 41 1
- 44 1
- 46 1
- 52 1
- 58 1
- 63 1
- 74 1
- 90 1
- 100 1
- 121 1
- 129 1
- 140 1
- 155 1
- 186 1
- 207 1
- 223 1
- 238 1
- 259 1
- 271 1
- 291 1
- 298 1
- 316 1
- 334 1
- 346 1
- 358 1
- 374 1
- 379 1
- 383 1
- 394 1
- 408 1
- 426 1
- 436 1
- 442 1
- 455 1
- 460 1
- 471 1
- 483 1
- 486 1
- 493 1
- 496 1
- 504 1
- 517 1
- 525 1
- 526 1
- 528 1
- 536 1
- 541 1
- 546 1
- 551 1
- 555 1
- 561 1
- 570 1
- 587 1
- 595 1
- 603 1
- 609 1
- 616 1
- 627 1
- 637 1
- 641 1
- 658 1
- 671 1
- 684 1
- 715 1
- 734 1
- 762 1
- 783 1
- 803 1
- 823 1
- 858 1
- 881 1
- 899 1
- 923 1
- 953 1
- 965 1
- 977 1
- 986 1
- 1010 1
- 1022 1
- 1046 1
- 1072 1
- 1094 1
- 1119 1
- 1144 1
- 1176 1
- 1198 1
- 1217 1
- 1249 1
- 1272 1
- 1296 1
- 1339 1
- 1362 1
- 1390 1
- 1410 1
- 1439 1
- 1479 1
- 1503 1
- 1532 1
- 1559 1
- 1574 1
- 1590 1
- 1608 1
- 1634 1
- 1669 1
- 1695 1
- 1717 1
- 1734 1
- 1750 1
- 1761 1
- 1782 1
- 1805 1
- 1819 1
- 1844 1
- 1859 1
- 1870 1
- 1892 1
- 1916 1
- 1941 1
- 1965 1
- 1992 1
- 2010 1
- 2021 1
- 2068 1
- 2105 1
- 2141 1
- 2163 1
- 2180 1
- 2198 1
- 2203 1
- 2205 1
- 2217 1
- 2238 1
- 2246 1
- 2254 1
- 2279 1
- 2291 1
- 2305 1
- 2325 1
- 2366 1
- 2386 1
- 2426 1
- 2458 1
- 2473 1
- 2487 1
- 2500 1
- 2532 1
- 2574 1
- 2603 1
- 2625 1
- 2648 1
- 2663 1
- 2681 1
- 2700 1
- 2733 1
- 2759 1
- 2770 1
- 2794 1
- 2806 1
- 2822 1
- 2853 1
- 2889 1
- 2925 1
- 2946 1
- 2969 1
- 2995 1
- 3016 1
- 3057 1
- 3112 1
- 3156 1
- 3185 1
- 3209 1
- 3234 1
- 3265 1
- 3293 1
- 3348 1
- 3382 1
- 3429 1
- 3496 1
- 3549 1
- 3604 1
- 3666 1
- 3779 1
- 3836 1
- 3918 1
- 4013 1
- 4098 1
- 4201 1
- 4340 1
- 4481 1
- 4644 1
- 4744 1
- 4862 1
- 5025 1
- 5178 1
- 5336 1
- 5596 1
- 5897 1
- 6146 1
- 6296 1
- 6467 1
- 6701 1
- 6884 1
- 7131 1
- 7356 1
- 7538 1
- 7647 1
- 7981 1
- 8201 1
- 8462 1
- 8597 1
- 8667 1
- 8810 1
- 8964 1
- 9094 1
- 9274 1
- 9417 1
- 9530 1
- 9605 1
- 9727 1
- 9805 1
- 9898 1
- 10013 1
- 10091 1
- 10160 1
- 10233 1
- 10285 1
- 10357 1
- 10412 1
- 10468 1
- 10546 1
- 10580 1
- 10625 1
- 10654 1
- 10777 1
- 10834 1
- 10860 1
- 10886 1
- 10947 1
- 11108 1
- 11184 1
- 11246 1
- 11280 1
- 11354 1
- 11424 1
- 11498 1
- 11591 1
- 11634 1
- 11665 1
- 11703 1
- 11741 1
- 11786 1
- 11853 1
- 11899 1
- 11917 1
- 11932 1
- 11954 1
- 11994 1
- 12035 1
- 12091 1
- 12130 1
- 12177 1
- 12211 1
- 12248 1
- 12279 1
- 12329 1
- 12368 1
- 12396 1
- 12421 1
- 12453 1
- 12483 1
- 12517 1
- 12552 1
- 12573 1
- 12602 1
- 12636 1
- 12646 1
- 12681 1
- 12700 1
- 12732 1
- 12759 1
- 12804 1
- 12838 1
- 12865 1
- 12898 1
- 12920 1
- 12970 1
- 13007 1
- 13044 1
- 13073 1
- 13081 1
- 13104 1
- 13119 1
- 13159 1
- 13186 1
- 13209 1
- 13241 1
- 13273 1
- 13290 1
- 13308 1
- 13354 1
- 13381 1
- 13403 1
- 13445 1
- 13467 1
- 13519 1
- 13568 1
- 13605 1
- 13664 1
- 13720 1
- 13767 1
- 13813 1
- 13838 1
- 13897 1
- 14009 1
- 14034 1
- 14080 1
- 14109 1
- 14157 1
- 14184 1
- 14236 1
- 14322 1
- 14375 1
- 14454 1
- 14490 1
- 14557 1
- 14614 1
- 14697 1
- 14802 1
- 14920 1
- 15043 1
- 15124 1
- 15212 1
- 15294 1
- 15379 1
- 15455 1
- 15511 1
- 15592 1
- 15628 1
- 15682 1
- 15798 1
- 15865 1
- 15946 1
- 16013 1
- 16071 1
- 16122 1
- 16187 1
- 16258 1
- 16343 1
- 16448 1
- 16486 1
- 16533 1
- 16574 1
- 16617 1
- 16692 1
- 16751 1
- 16811 1
- 16874 1
- 16902 1
- 16941 1
- 16980 1
- 17036 1
- 17081 1
- 17117 1
- 17137 1
- 17176 1
- 17201 1
- 17222 1
- 17244 1
- 17275 1
- 17296 1
- 17324 1
- 17336 1
- 17348 1
- 17359 1
- 17384 1
- 17398 1
- 17411 1
- 17416 1
- 17432 1
- 17438 1
- 17454 1
- 17466 1
- 17475 1
- 17477 1
- 17491 1
- 17494 1
- 17499 1
- 17507 1
- 17510 1
- 17517 1
- 17518 1
- 17519 1
- 17526 1
- 17530 1
- 17532 1
- 17533 1
- 17536 1
- 17540 1
- 17543 1
- 17544 1
- 17550 1
- 17551 1
- 17552 1
- 17553 1
- 17554 1
- 17558 1
- 17560 1
- 17565 1
- 17570 1
- 17574 1
- 17589 1
- 17596 1
- 17600 1
- 17603 1
- 17616 1
- 17643 1
- 17653 1
- 17667 1
- 17701 1
- 17719 1
- 17735 1
- 17747 1
- 17778 1
- 17814 1
- 17835 1
- 17850 1
- 17906 1
- 17958 1
- 18007 1
- 18052 1
- 18123 1
- 18200 1
- 18230 1
- 18267 1
- 18357 1
- 18471 1
- 18505 1
- 18564 1
- 18637 1
- 18735 1
- 18767 1
- 18828 1
- 18942 1
- 19078 1
- 19109 1
- 19257 1
- 19422 1
- 19489 1
- 19550 1
- 19700 1
- 19872 1
- 19922 1
- 19966 1
- 20111 1
- 20259 1
- 20316 1
- 20371 1
- 20491 1
- 20634 1
- 20760 1
- 20801 1
- 20934 1
- 21137 1
- 21193 1
- 21262 1
- 21359 1
- 21503 1
- 21556 1
- 21603 1
- 21689 1
- 21836 1
- 21880 1
- 21946 1
- 22301 1
- 22476 1
- 22550 1
- 22645 1
- 22861 1
- 23056 1
- 23234 1
- 23388 1
- 23680 1
- 24077 1
- 24204 1
- 24377 1
- 24685 1
- 25041 1
- 25438 1
- 25842 1
- 25994 1
- 26116 1
- 26479 1
- 26894 1
- 27004 1
- 27091 1
- 27323 1
- 27610 1
- 27689 1
- 27784 1
- 27968 1
- 28212 1
- 28293 1
- 28588 1
- 28853 1
- 28966 1
- 29436 1
- 29913 1
- 30033 1
- 30229 1
- 30811 1
- 31495 1
- 31730 1
- 32218 1
- 32769 1
- 33557 1
- 33907 1
- 34906 1
- 35498 1
- 35824 1
- 36521 1
- 37237 1
- 37642 1
- 37928 1
- 38069 1
- 38363 1
- 38566 1
- 38725 1
- 38840 1
- 39063 1
- 39231 1
- 39257 1
- 39284 1
- 39434 1
- 39555 1
- 39593 1
- 39636 1
- 39658 1
- 39664 1
- 39683 1
- 39702 1
- 39740 1
- 39763 1
- 39777 1
- 39911 1
- 39926 1
- 39956 1
- 39965 1
- 39969 1
- 39987 1
- 39998 1
- 40007 1
- 40030 1
- 40050 1
- 40057 1
- 40064 1
- 40090 1
- 40120 1
- 40126 1
- 40134 1
- 40154 1
- 40178 1
- 40190 1
- 40217 1
- 40251 1
- 40286 1
- 40306 1
- 40323 1
- 40364 1
- 40427 1
- 40467 1
- 40505 1
- 40610 1
- 40684 1
- 40766 1
- 40815 1
- 40932 1
- 41053 1
- 41100 1
- 41156 1
- 41236 1
state 1
- Minnesota 786
fips 1
- 27139 · 786 ✖
county 1
- Scott 786
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500973 | 2500973 | 2022-05-13 | Scott | Minnesota | 27139 | 41236 | 261 |
2497715 | 2497715 | 2022-05-12 | Scott | Minnesota | 27139 | 41156 | 261 |
2494457 | 2494457 | 2022-05-11 | Scott | Minnesota | 27139 | 41100 | 260 |
2491199 | 2491199 | 2022-05-10 | Scott | Minnesota | 27139 | 41053 | 260 |
2487942 | 2487942 | 2022-05-09 | Scott | Minnesota | 27139 | 40932 | 260 |
2484684 | 2484684 | 2022-05-08 | Scott | Minnesota | 27139 | 40862 | 260 |
2481426 | 2481426 | 2022-05-07 | Scott | Minnesota | 27139 | 40862 | 260 |
2478168 | 2478168 | 2022-05-06 | Scott | Minnesota | 27139 | 40862 | 260 |
2474910 | 2474910 | 2022-05-05 | Scott | Minnesota | 27139 | 40815 | 260 |
2471653 | 2471653 | 2022-05-04 | Scott | Minnesota | 27139 | 40766 | 260 |
2468397 | 2468397 | 2022-05-03 | Scott | Minnesota | 27139 | 40684 | 260 |
2465142 | 2465142 | 2022-05-02 | Scott | Minnesota | 27139 | 40610 | 260 |
2461886 | 2461886 | 2022-05-01 | Scott | Minnesota | 27139 | 40566 | 260 |
2458630 | 2458630 | 2022-04-30 | Scott | Minnesota | 27139 | 40566 | 260 |
2455374 | 2455374 | 2022-04-29 | Scott | Minnesota | 27139 | 40566 | 260 |
2452118 | 2452118 | 2022-04-28 | Scott | Minnesota | 27139 | 40505 | 260 |
2448862 | 2448862 | 2022-04-27 | Scott | Minnesota | 27139 | 40467 | 260 |
2445606 | 2445606 | 2022-04-26 | Scott | Minnesota | 27139 | 40427 | 260 |
2442350 | 2442350 | 2022-04-25 | Scott | Minnesota | 27139 | 40364 | 260 |
2439094 | 2439094 | 2022-04-24 | Scott | Minnesota | 27139 | 40353 | 260 |
2435838 | 2435838 | 2022-04-23 | Scott | Minnesota | 27139 | 40353 | 260 |
2432582 | 2432582 | 2022-04-22 | Scott | Minnesota | 27139 | 40353 | 260 |
2429326 | 2429326 | 2022-04-21 | Scott | Minnesota | 27139 | 40323 | 260 |
2426070 | 2426070 | 2022-04-20 | Scott | Minnesota | 27139 | 40306 | 260 |
2422814 | 2422814 | 2022-04-19 | Scott | Minnesota | 27139 | 40286 | 260 |
2419558 | 2419558 | 2022-04-18 | Scott | Minnesota | 27139 | 40251 | 260 |
2416302 | 2416302 | 2022-04-17 | Scott | Minnesota | 27139 | 40234 | 260 |
2413046 | 2413046 | 2022-04-16 | Scott | Minnesota | 27139 | 40234 | 260 |
2409790 | 2409790 | 2022-04-15 | Scott | Minnesota | 27139 | 40234 | 260 |
2406534 | 2406534 | 2022-04-14 | Scott | Minnesota | 27139 | 40217 | 259 |
2403278 | 2403278 | 2022-04-13 | Scott | Minnesota | 27139 | 40190 | 259 |
2400024 | 2400024 | 2022-04-12 | Scott | Minnesota | 27139 | 40178 | 259 |
2396768 | 2396768 | 2022-04-11 | Scott | Minnesota | 27139 | 40154 | 259 |
2393513 | 2393513 | 2022-04-10 | Scott | Minnesota | 27139 | 40144 | 259 |
2390257 | 2390257 | 2022-04-09 | Scott | Minnesota | 27139 | 40144 | 259 |
2387001 | 2387001 | 2022-04-08 | Scott | Minnesota | 27139 | 40144 | 259 |
2383746 | 2383746 | 2022-04-07 | Scott | Minnesota | 27139 | 40134 | 259 |
2380491 | 2380491 | 2022-04-06 | Scott | Minnesota | 27139 | 40126 | 259 |
2377236 | 2377236 | 2022-04-05 | Scott | Minnesota | 27139 | 40120 | 258 |
2373984 | 2373984 | 2022-04-04 | Scott | Minnesota | 27139 | 40090 | 258 |
2370731 | 2370731 | 2022-04-03 | Scott | Minnesota | 27139 | 40077 | 258 |
2367478 | 2367478 | 2022-04-02 | Scott | Minnesota | 27139 | 40077 | 258 |
2364225 | 2364225 | 2022-04-01 | Scott | Minnesota | 27139 | 40077 | 258 |
2360971 | 2360971 | 2022-03-31 | Scott | Minnesota | 27139 | 40064 | 258 |
2357717 | 2357717 | 2022-03-30 | Scott | Minnesota | 27139 | 40057 | 258 |
2354464 | 2354464 | 2022-03-29 | Scott | Minnesota | 27139 | 40050 | 257 |
2351212 | 2351212 | 2022-03-28 | Scott | Minnesota | 27139 | 40030 | 257 |
2347959 | 2347959 | 2022-03-27 | Scott | Minnesota | 27139 | 40014 | 256 |
2344706 | 2344706 | 2022-03-26 | Scott | Minnesota | 27139 | 40014 | 256 |
2341453 | 2341453 | 2022-03-25 | Scott | Minnesota | 27139 | 40014 | 256 |
2338200 | 2338200 | 2022-03-24 | Scott | Minnesota | 27139 | 40007 | 256 |
2334946 | 2334946 | 2022-03-23 | Scott | Minnesota | 27139 | 39998 | 255 |
2331692 | 2331692 | 2022-03-22 | Scott | Minnesota | 27139 | 39987 | 255 |
2328440 | 2328440 | 2022-03-21 | Scott | Minnesota | 27139 | 39969 | 254 |
2325187 | 2325187 | 2022-03-20 | Scott | Minnesota | 27139 | 39967 | 253 |
2321933 | 2321933 | 2022-03-19 | Scott | Minnesota | 27139 | 39967 | 253 |
2318679 | 2318679 | 2022-03-18 | Scott | Minnesota | 27139 | 39967 | 253 |
2315426 | 2315426 | 2022-03-17 | Scott | Minnesota | 27139 | 39965 | 252 |
2312173 | 2312173 | 2022-03-16 | Scott | Minnesota | 27139 | 39956 | 251 |
2308920 | 2308920 | 2022-03-15 | Scott | Minnesota | 27139 | 39926 | 251 |
2305669 | 2305669 | 2022-03-14 | Scott | Minnesota | 27139 | 39911 | 251 |
2302417 | 2302417 | 2022-03-13 | Scott | Minnesota | 27139 | 39904 | 250 |
2299165 | 2299165 | 2022-03-12 | Scott | Minnesota | 27139 | 39904 | 250 |
2295913 | 2295913 | 2022-03-11 | Scott | Minnesota | 27139 | 39904 | 250 |
2292661 | 2292661 | 2022-03-10 | Scott | Minnesota | 27139 | 39777 | 250 |
2289409 | 2289409 | 2022-03-09 | Scott | Minnesota | 27139 | 39763 | 250 |
2286158 | 2286158 | 2022-03-08 | Scott | Minnesota | 27139 | 39740 | 250 |
2282906 | 2282906 | 2022-03-07 | Scott | Minnesota | 27139 | 39702 | 250 |
2279653 | 2279653 | 2022-03-06 | Scott | Minnesota | 27139 | 39685 | 250 |
2276400 | 2276400 | 2022-03-05 | Scott | Minnesota | 27139 | 39685 | 250 |
2273147 | 2273147 | 2022-03-04 | Scott | Minnesota | 27139 | 39685 | 250 |
2269895 | 2269895 | 2022-03-03 | Scott | Minnesota | 27139 | 39664 | 249 |
2266642 | 2266642 | 2022-03-02 | Scott | Minnesota | 27139 | 39658 | 249 |
2263391 | 2263391 | 2022-03-01 | Scott | Minnesota | 27139 | 39683 | 249 |
2260140 | 2260140 | 2022-02-28 | Scott | Minnesota | 27139 | 39636 | 249 |
2256889 | 2256889 | 2022-02-27 | Scott | Minnesota | 27139 | 39609 | 249 |
2253638 | 2253638 | 2022-02-26 | Scott | Minnesota | 27139 | 39609 | 249 |
2250387 | 2250387 | 2022-02-25 | Scott | Minnesota | 27139 | 39609 | 249 |
2247136 | 2247136 | 2022-02-24 | Scott | Minnesota | 27139 | 39593 | 248 |
2243885 | 2243885 | 2022-02-23 | Scott | Minnesota | 27139 | 39555 | 247 |
2240634 | 2240634 | 2022-02-22 | Scott | Minnesota | 27139 | 39434 | 247 |
2237383 | 2237383 | 2022-02-21 | Scott | Minnesota | 27139 | 39410 | 246 |
2234132 | 2234132 | 2022-02-20 | Scott | Minnesota | 27139 | 39410 | 246 |
2230881 | 2230881 | 2022-02-19 | Scott | Minnesota | 27139 | 39410 | 246 |
2227630 | 2227630 | 2022-02-18 | Scott | Minnesota | 27139 | 39410 | 246 |
2224379 | 2224379 | 2022-02-17 | Scott | Minnesota | 27139 | 39284 | 246 |
2221128 | 2221128 | 2022-02-16 | Scott | Minnesota | 27139 | 39257 | 246 |
2217877 | 2217877 | 2022-02-15 | Scott | Minnesota | 27139 | 39231 | 246 |
2214626 | 2214626 | 2022-02-14 | Scott | Minnesota | 27139 | 39063 | 245 |
2211374 | 2211374 | 2022-02-13 | Scott | Minnesota | 27139 | 38918 | 243 |
2208121 | 2208121 | 2022-02-12 | Scott | Minnesota | 27139 | 38918 | 243 |
2204868 | 2204868 | 2022-02-11 | Scott | Minnesota | 27139 | 38918 | 243 |
2201615 | 2201615 | 2022-02-10 | Scott | Minnesota | 27139 | 38840 | 243 |
2198361 | 2198361 | 2022-02-09 | Scott | Minnesota | 27139 | 38725 | 242 |
2195107 | 2195107 | 2022-02-08 | Scott | Minnesota | 27139 | 38566 | 241 |
2191853 | 2191853 | 2022-02-07 | Scott | Minnesota | 27139 | 38363 | 239 |
2188600 | 2188600 | 2022-02-06 | Scott | Minnesota | 27139 | 38184 | 238 |
2185347 | 2185347 | 2022-02-05 | Scott | Minnesota | 27139 | 38184 | 238 |
2182095 | 2182095 | 2022-02-04 | Scott | Minnesota | 27139 | 38184 | 238 |
2178843 | 2178843 | 2022-02-03 | Scott | Minnesota | 27139 | 38069 | 236 |
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);