ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 28089 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 617 ✖
- 23987 8
- 24040 8
- 23930 7
- 23950 7
- 23969 7
- 24113 7
- 23911 6
- 24018 6
- 24079 6
- 922 5
- 14874 5
- 15359 5
- 24189 5
- 10335 4
- 16239 4
- 19442 4
- 23758 4
- 9990 3
- 10035 3
- 10066 3
- 10113 3
- 10152 3
- 10184 3
- 10194 3
- 10213 3
- 10263 3
- 10288 3
- 10391 3
- 10498 3
- 10692 3
- 10959 3
- 11352 3
- 11789 3
- 12520 3
- 12941 3
- 13418 3
- 13807 3
- 14043 3
- 14166 3
- 14356 3
- 14463 3
- 14525 3
- 14581 3
- 14680 3
- 14756 3
- 14793 3
- 14844 3
- 14954 3
- 15049 3
- 15183 3
- 17845 3
- 21129 3
- 21942 3
- 22994 3
- 23494 3
- 23838 3
- 23880 3
- 1 2
- 843 2
- 2556 2
- 3710 2
- 3831 2
- 9663 2
- 9720 2
- 10202 2
- 14781 2
- 3 1
- 7 1
- 9 1
- 11 1
- 14 1
- 17 1
- 21 1
- 25 1
- 29 1
- 37 1
- 38 1
- 42 1
- 53 1
- 55 1
- 65 1
- 67 1
- 72 1
- 74 1
- 82 1
- 83 1
- 88 1
- 95 1
- 99 1
- 103 1
- 106 1
- 108 1
- 112 1
- 116 1
- 123 1
- 127 1
- 135 1
- 140 1
- 144 1
- 151 1
- 165 1
- 178 1
- 186 1
- 194 1
- 208 1
- 212 1
- 224 1
- 229 1
- 251 1
- 268 1
- 272 1
- 286 1
- 298 1
- 318 1
- 333 1
- 404 1
- 422 1
- 431 1
- 466 1
- 491 1
- 493 1
- 502 1
- 507 1
- 526 1
- 533 1
- 543 1
- 561 1
- 573 1
- 582 1
- 618 1
- 639 1
- 653 1
- 654 1
- 675 1
- 687 1
- 694 1
- 709 1
- 720 1
- 724 1
- 742 1
- 745 1
- 757 1
- 767 1
- 778 1
- 788 1
- 796 1
- 807 1
- 832 1
- 864 1
- 877 1
- 886 1
- 889 1
- 905 1
- 995 1
- 1014 1
- 1034 1
- 1082 1
- 1112 1
- 1127 1
- 1145 1
- 1181 1
- 1206 1
- 1222 1
- 1242 1
- 1267 1
- 1296 1
- 1300 1
- 1314 1
- 1326 1
- 1355 1
- 1382 1
- 1419 1
- 1446 1
- 1484 1
- 1508 1
- 1560 1
- 1589 1
- 1630 1
- 1657 1
- 1681 1
- 1691 1
- 1740 1
- 1804 1
- 1852 1
- 1893 1
- 1978 1
- 2026 1
- 2058 1
- 2096 1
- 2139 1
- 2167 1
- 2211 1
- 2250 1
- 2272 1
- 2281 1
- 2297 1
- 2324 1
- 2363 1
- 2387 1
- 2396 1
- 2414 1
- 2422 1
- 2443 1
- 2455 1
- 2489 1
- 2503 1
- 2521 1
- 2538 1
- 2583 1
- 2662 1
- 2668 1
- 2693 1
- 2774 1
- 2786 1
- 2792 1
- 2802 1
- 2821 1
- 2845 1
- 2865 1
- 2939 1
- 2967 1
- 2971 1
- 2994 1
- 3009 1
- 3020 1
- 3039 1
- 3048 1
- 3057 1
- 3059 1
- 3062 1
- 3076 1
- 3095 1
- 3115 1
- 3123 1
- 3134 1
- 3136 1
- 3146 1
- 3164 1
- 3180 1
- 3190 1
- 3200 1
- 3208 1
- 3212 1
- 3218 1
- 3233 1
- 3265 1
- 3297 1
- 3310 1
- 3312 1
- 3314 1
- 3331 1
- 3341 1
- 3363 1
- 3374 1
- 3387 1
- 3389 1
- 3405 1
- 3441 1
- 3451 1
- 3463 1
- 3481 1
- 3501 1
- 3504 1
- 3511 1
- 3526 1
- 3552 1
- 3623 1
- 3683 1
- 3717 1
- 3739 1
- 3757 1
- 3779 1
- 3812 1
- 3837 1
- 3843 1
- 3861 1
- 3880 1
- 3894 1
- 3909 1
- 3914 1
- 3918 1
- 3930 1
- 3958 1
- 3986 1
- 4005 1
- 4034 1
- 4081 1
- 4098 1
- 4120 1
- 4146 1
- 4201 1
- 4244 1
- 4282 1
- 4300 1
- 4311 1
- 4339 1
- 4402 1
- 4462 1
- 4498 1
- 4573 1
- 4595 1
- 4602 1
- 4633 1
- 4666 1
- 4711 1
- 4734 1
- 4799 1
- 4902 1
- 4964 1
- 5014 1
- 5120 1
- 5202 1
- 5311 1
- 5368 1
- 5408 1
- 5433 1
- 5478 1
- 5532 1
- 5639 1
- 5726 1
- 5836 1
- 5889 1
- 5927 1
- 5997 1
- 6114 1
- 6196 1
- 6327 1
- 6379 1
- 6482 1
- 6517 1
- 6568 1
- 6665 1
- 6733 1
- 6783 1
- 6815 1
- 6859 1
- 6905 1
- 6961 1
- 7079 1
- 7194 1
- 7294 1
- 7342 1
- 7372 1
- 7418 1
- 7447 1
- 7551 1
- 7651 1
- 7723 1
- 7796 1
- 7853 1
- 7868 1
- 7893 1
- 7937 1
- 7994 1
- 8071 1
- 8186 1
- 8232 1
- 8262 1
- 8314 1
- 8335 1
- 8413 1
- 8495 1
- 8568 1
- 8599 1
- 8619 1
- 8663 1
- 8736 1
- 8785 1
- 8856 1
- 8893 1
- 8922 1
- 8941 1
- 8988 1
- 9009 1
- 9042 1
- 9075 1
- 9112 1
- 9147 1
- 9162 1
- 9180 1
- 9204 1
- 9227 1
- 9242 1
- 9262 1
- 9295 1
- 9307 1
- 9318 1
- 9324 1
- 9327 1
- 9333 1
- 9336 1
- 9340 1
- 9343 1
- 9353 1
- 9378 1
- 9400 1
- 9420 1
- 9432 1
- 9448 1
- 9457 1
- 9466 1
- 9480 1
- 9484 1
- 9499 1
- 9516 1
- 9522 1
- 9525 1
- 9533 1
- 9569 1
- 9615 1
- 9640 1
- 9661 1
- 9666 1
- 9681 1
- 9691 1
- 9700 1
- 9710 1
- 9741 1
- 9757 1
- 9775 1
- 9782 1
- 9788 1
- 9799 1
- 9803 1
- 9805 1
- 9816 1
- 9826 1
- 9831 1
- 9848 1
- 9855 1
- 9856 1
- 9859 1
- 9864 1
- 9872 1
- 9876 1
- 9886 1
- 9895 1
- 9896 1
- 9908 1
- 9922 1
- 9949 1
- 9950 1
- 9957 1
- 9963 1
- 9965 1
- 9970 1
- 9981 1
- 9988 1
- 10003 1
- 10010 1
- 10016 1
- 10024 1
- 10048 1
- 10051 1
- 10055 1
- 10062 1
- 10085 1
- 10088 1
- 10092 1
- 10099 1
- 10130 1
- 10135 1
- 10141 1
- 10148 1
- 10169 1
- 10171 1
- 10173 1
- 10178 1
- 10186 1
- 10187 1
- 10188 1
- 10190 1
- 10208 1
- 10211 1
- 10234 1
- 10237 1
- 10239 1
- 10249 1
- 10270 1
- 10273 1
- 10276 1
- 10280 1
- 10305 1
- 10314 1
- 10323 1
- 10328 1
- 10356 1
- 10369 1
- 10382 1
- 10431 1
- 10440 1
- 10466 1
- 10489 1
- 10576 1
- 10589 1
- 10616 1
- 10658 1
- 10787 1
- 10806 1
- 10864 1
- 10917 1
- 11114 1
- 11171 1
- 11224 1
- 11306 1
- 11512 1
- 11559 1
- 11620 1
- 11711 1
- 11955 1
- 12044 1
- 12165 1
- 12335 1
- 12619 1
- 12659 1
- 12793 1
- 12887 1
- 13239 1
- 13261 1
- 13302 1
- 13353 1
- 13607 1
- 13625 1
- 13665 1
- 13756 1
- 13880 1
- 13914 1
- 13961 1
- 13993 1
- 14086 1
- 14101 1
- 14120 1
- 14145 1
- 14206 1
- 14297 1
- 14314 1
- 14345 1
- 14389 1
- 14407 1
- 14419 1
- 14451 1
- 14478 1
- 14497 1
- 14507 1
- 14513 1
- 14547 1
- 14558 1
- 14566 1
- 14574 1
- 14597 1
- 14662 1
- 14668 1
- 14677 1
- 14693 1
- 14699 1
- 14725 1
- 14726 1
- 14771 1
- 14778 1
- 14820 1
- 14825 1
- 14832 1
- 14840 1
- 14868 1
- 14869 1
- 14922 1
- 14932 1
- 14939 1
- 14949 1
- 14978 1
- 14986 1
- 14996 1
- 15041 1
- 15066 1
- 15077 1
- 15090 1
- 15110 1
- 15273 1
- 15303 1
- 15769 1
- 15872 1
- 16035 1
- 17076 1
- 17214 1
- 17461 1
- 17667 1
- 18747 1
- 18846 1
- 19046 1
- 19238 1
- 20261 1
- 20476 1
- 20688 1
- 21428 1
- 21534 1
- 21687 1
- 21842 1
- 22307 1
- 22394 1
- 22518 1
- 22654 1
- 23264 1
- 23296 1
- 23354 1
- 23381 1
- 23630 1
- 23651 1
- 23669 1
- 23681 1
- 23796 1
- 23803 1
- 23819 1
- 23857 1
- 23869 1
- 23873 1
- 23877 1
- 23905 1
state 1
- Mississippi 787
fips 1
- 28089 · 787 ✖
county 1
- Madison 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501037 | 2501037 | 2022-05-13 | Madison | Mississippi | 28089 | 24189 | 329 |
2497779 | 2497779 | 2022-05-12 | Madison | Mississippi | 28089 | 24189 | 329 |
2494521 | 2494521 | 2022-05-11 | Madison | Mississippi | 28089 | 24189 | 329 |
2491263 | 2491263 | 2022-05-10 | Madison | Mississippi | 28089 | 24189 | 329 |
2488006 | 2488006 | 2022-05-09 | Madison | Mississippi | 28089 | 24189 | 329 |
2484748 | 2484748 | 2022-05-08 | Madison | Mississippi | 28089 | 24113 | 329 |
2481490 | 2481490 | 2022-05-07 | Madison | Mississippi | 28089 | 24113 | 329 |
2478232 | 2478232 | 2022-05-06 | Madison | Mississippi | 28089 | 24113 | 329 |
2474974 | 2474974 | 2022-05-05 | Madison | Mississippi | 28089 | 24113 | 329 |
2471717 | 2471717 | 2022-05-04 | Madison | Mississippi | 28089 | 24113 | 329 |
2468461 | 2468461 | 2022-05-03 | Madison | Mississippi | 28089 | 24113 | 329 |
2465206 | 2465206 | 2022-05-02 | Madison | Mississippi | 28089 | 24113 | 329 |
2461950 | 2461950 | 2022-05-01 | Madison | Mississippi | 28089 | 24079 | 329 |
2458694 | 2458694 | 2022-04-30 | Madison | Mississippi | 28089 | 24079 | 329 |
2455438 | 2455438 | 2022-04-29 | Madison | Mississippi | 28089 | 24079 | 329 |
2452182 | 2452182 | 2022-04-28 | Madison | Mississippi | 28089 | 24079 | 329 |
2448926 | 2448926 | 2022-04-27 | Madison | Mississippi | 28089 | 24079 | 329 |
2445670 | 2445670 | 2022-04-26 | Madison | Mississippi | 28089 | 24079 | 329 |
2442414 | 2442414 | 2022-04-25 | Madison | Mississippi | 28089 | 24040 | 328 |
2439158 | 2439158 | 2022-04-24 | Madison | Mississippi | 28089 | 24040 | 328 |
2435902 | 2435902 | 2022-04-23 | Madison | Mississippi | 28089 | 24040 | 328 |
2432646 | 2432646 | 2022-04-22 | Madison | Mississippi | 28089 | 24040 | 328 |
2429390 | 2429390 | 2022-04-21 | Madison | Mississippi | 28089 | 24040 | 328 |
2426134 | 2426134 | 2022-04-20 | Madison | Mississippi | 28089 | 24040 | 328 |
2422878 | 2422878 | 2022-04-19 | Madison | Mississippi | 28089 | 24040 | 328 |
2419622 | 2419622 | 2022-04-18 | Madison | Mississippi | 28089 | 24040 | 328 |
2416366 | 2416366 | 2022-04-17 | Madison | Mississippi | 28089 | 24018 | 327 |
2413110 | 2413110 | 2022-04-16 | Madison | Mississippi | 28089 | 24018 | 327 |
2409854 | 2409854 | 2022-04-15 | Madison | Mississippi | 28089 | 24018 | 327 |
2406598 | 2406598 | 2022-04-14 | Madison | Mississippi | 28089 | 24018 | 327 |
2403342 | 2403342 | 2022-04-13 | Madison | Mississippi | 28089 | 24018 | 327 |
2400088 | 2400088 | 2022-04-12 | Madison | Mississippi | 28089 | 24018 | 327 |
2396832 | 2396832 | 2022-04-11 | Madison | Mississippi | 28089 | 23987 | 327 |
2393577 | 2393577 | 2022-04-10 | Madison | Mississippi | 28089 | 23987 | 327 |
2390321 | 2390321 | 2022-04-09 | Madison | Mississippi | 28089 | 23987 | 327 |
2387065 | 2387065 | 2022-04-08 | Madison | Mississippi | 28089 | 23987 | 327 |
2383810 | 2383810 | 2022-04-07 | Madison | Mississippi | 28089 | 23987 | 327 |
2380555 | 2380555 | 2022-04-06 | Madison | Mississippi | 28089 | 23987 | 327 |
2377300 | 2377300 | 2022-04-05 | Madison | Mississippi | 28089 | 23987 | 327 |
2374048 | 2374048 | 2022-04-04 | Madison | Mississippi | 28089 | 23987 | 327 |
2370795 | 2370795 | 2022-04-03 | Madison | Mississippi | 28089 | 23969 | 326 |
2367542 | 2367542 | 2022-04-02 | Madison | Mississippi | 28089 | 23969 | 326 |
2364289 | 2364289 | 2022-04-01 | Madison | Mississippi | 28089 | 23969 | 326 |
2361035 | 2361035 | 2022-03-31 | Madison | Mississippi | 28089 | 23969 | 326 |
2357781 | 2357781 | 2022-03-30 | Madison | Mississippi | 28089 | 23969 | 326 |
2354528 | 2354528 | 2022-03-29 | Madison | Mississippi | 28089 | 23969 | 326 |
2351276 | 2351276 | 2022-03-28 | Madison | Mississippi | 28089 | 23969 | 326 |
2348023 | 2348023 | 2022-03-27 | Madison | Mississippi | 28089 | 23950 | 325 |
2344770 | 2344770 | 2022-03-26 | Madison | Mississippi | 28089 | 23950 | 325 |
2341517 | 2341517 | 2022-03-25 | Madison | Mississippi | 28089 | 23950 | 325 |
2338264 | 2338264 | 2022-03-24 | Madison | Mississippi | 28089 | 23950 | 325 |
2335010 | 2335010 | 2022-03-23 | Madison | Mississippi | 28089 | 23950 | 325 |
2331756 | 2331756 | 2022-03-22 | Madison | Mississippi | 28089 | 23950 | 325 |
2328504 | 2328504 | 2022-03-21 | Madison | Mississippi | 28089 | 23950 | 325 |
2325251 | 2325251 | 2022-03-20 | Madison | Mississippi | 28089 | 23930 | 323 |
2321997 | 2321997 | 2022-03-19 | Madison | Mississippi | 28089 | 23930 | 323 |
2318743 | 2318743 | 2022-03-18 | Madison | Mississippi | 28089 | 23930 | 323 |
2315490 | 2315490 | 2022-03-17 | Madison | Mississippi | 28089 | 23930 | 323 |
2312237 | 2312237 | 2022-03-16 | Madison | Mississippi | 28089 | 23930 | 323 |
2308984 | 2308984 | 2022-03-15 | Madison | Mississippi | 28089 | 23930 | 323 |
2305733 | 2305733 | 2022-03-14 | Madison | Mississippi | 28089 | 23930 | 323 |
2302481 | 2302481 | 2022-03-13 | Madison | Mississippi | 28089 | 23911 | 321 |
2299229 | 2299229 | 2022-03-12 | Madison | Mississippi | 28089 | 23911 | 321 |
2295977 | 2295977 | 2022-03-11 | Madison | Mississippi | 28089 | 23911 | 321 |
2292725 | 2292725 | 2022-03-10 | Madison | Mississippi | 28089 | 23911 | 321 |
2289473 | 2289473 | 2022-03-09 | Madison | Mississippi | 28089 | 23911 | 321 |
2286222 | 2286222 | 2022-03-08 | Madison | Mississippi | 28089 | 23911 | 321 |
2282970 | 2282970 | 2022-03-07 | Madison | Mississippi | 28089 | 23905 | 321 |
2279717 | 2279717 | 2022-03-06 | Madison | Mississippi | 28089 | 23880 | 319 |
2276464 | 2276464 | 2022-03-05 | Madison | Mississippi | 28089 | 23880 | 319 |
2273211 | 2273211 | 2022-03-04 | Madison | Mississippi | 28089 | 23880 | 319 |
2269959 | 2269959 | 2022-03-03 | Madison | Mississippi | 28089 | 23877 | 319 |
2266706 | 2266706 | 2022-03-02 | Madison | Mississippi | 28089 | 23873 | 319 |
2263455 | 2263455 | 2022-03-01 | Madison | Mississippi | 28089 | 23869 | 319 |
2260204 | 2260204 | 2022-02-28 | Madison | Mississippi | 28089 | 23857 | 318 |
2256953 | 2256953 | 2022-02-27 | Madison | Mississippi | 28089 | 23838 | 318 |
2253702 | 2253702 | 2022-02-26 | Madison | Mississippi | 28089 | 23838 | 318 |
2250451 | 2250451 | 2022-02-25 | Madison | Mississippi | 28089 | 23838 | 318 |
2247200 | 2247200 | 2022-02-24 | Madison | Mississippi | 28089 | 23819 | 318 |
2243949 | 2243949 | 2022-02-23 | Madison | Mississippi | 28089 | 23803 | 318 |
2240698 | 2240698 | 2022-02-22 | Madison | Mississippi | 28089 | 23796 | 314 |
2237447 | 2237447 | 2022-02-21 | Madison | Mississippi | 28089 | 23758 | 314 |
2234196 | 2234196 | 2022-02-20 | Madison | Mississippi | 28089 | 23758 | 314 |
2230945 | 2230945 | 2022-02-19 | Madison | Mississippi | 28089 | 23758 | 314 |
2227694 | 2227694 | 2022-02-18 | Madison | Mississippi | 28089 | 23758 | 314 |
2224443 | 2224443 | 2022-02-17 | Madison | Mississippi | 28089 | 23681 | 314 |
2221192 | 2221192 | 2022-02-16 | Madison | Mississippi | 28089 | 23669 | 314 |
2217941 | 2217941 | 2022-02-15 | Madison | Mississippi | 28089 | 23651 | 312 |
2214690 | 2214690 | 2022-02-14 | Madison | Mississippi | 28089 | 23630 | 311 |
2211438 | 2211438 | 2022-02-13 | Madison | Mississippi | 28089 | 23494 | 310 |
2208185 | 2208185 | 2022-02-12 | Madison | Mississippi | 28089 | 23494 | 310 |
2204932 | 2204932 | 2022-02-11 | Madison | Mississippi | 28089 | 23494 | 310 |
2201679 | 2201679 | 2022-02-10 | Madison | Mississippi | 28089 | 23381 | 307 |
2198425 | 2198425 | 2022-02-09 | Madison | Mississippi | 28089 | 23354 | 305 |
2195171 | 2195171 | 2022-02-08 | Madison | Mississippi | 28089 | 23296 | 304 |
2191917 | 2191917 | 2022-02-07 | Madison | Mississippi | 28089 | 23264 | 303 |
2188664 | 2188664 | 2022-02-06 | Madison | Mississippi | 28089 | 22994 | 303 |
2185411 | 2185411 | 2022-02-05 | Madison | Mississippi | 28089 | 22994 | 303 |
2182159 | 2182159 | 2022-02-04 | Madison | Mississippi | 28089 | 22994 | 303 |
2178907 | 2178907 | 2022-02-03 | Madison | Mississippi | 28089 | 22654 | 302 |
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);