ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 28017 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 532 ✖
- 5591 14
- 5586 8
- 2033 7
- 2105 7
- 5583 7
- 5584 7
- 5585 7
- 5594 7
- 15 6
- 5581 6
- 5587 6
- 177 5
- 2020 5
- 2048 5
- 2065 5
- 2095 5
- 3133 5
- 3351 5
- 5603 5
- 610 4
- 2024 4
- 2060 4
- 2071 4
- 2089 4
- 2099 4
- 2104 4
- 2108 4
- 2118 4
- 3483 4
- 4163 4
- 5497 4
- 2011 3
- 2031 3
- 2046 3
- 2077 3
- 2080 3
- 2101 3
- 2126 3
- 2145 3
- 2163 3
- 2190 3
- 2254 3
- 2349 3
- 2461 3
- 2559 3
- 2668 3
- 2736 3
- 2821 3
- 2870 3
- 2901 3
- 2938 3
- 2967 3
- 3003 3
- 3033 3
- 3045 3
- 3066 3
- 3102 3
- 3183 3
- 3246 3
- 3314 3
- 3791 3
- 4664 3
- 4969 3
- 5300 3
- 5420 3
- 5566 3
- 5575 3
- 6 2
- 10 2
- 51 2
- 68 2
- 76 2
- 92 2
- 114 2
- 116 2
- 125 2
- 127 2
- 137 2
- 140 2
- 158 2
- 168 2
- 438 2
- 513 2
- 685 2
- 817 2
- 855 2
- 880 2
- 1966 2
- 1996 2
- 2001 2
- 2002 2
- 2014 2
- 2025 2
- 2050 2
- 2055 2
- 2059 2
- 2061 2
- 2070 2
- 2084 2
- 2092 2
- 2094 2
- 2117 2
- 2125 2
- 3031 2
- 3041 2
- 3056 2
- 5567 2
- 1 1
- 3 1
- 7 1
- 9 1
- 12 1
- 13 1
- 14 1
- 17 1
- 20 1
- 21 1
- 22 1
- 24 1
- 30 1
- 32 1
- 33 1
- 37 1
- 39 1
- 40 1
- 43 1
- 45 1
- 52 1
- 53 1
- 56 1
- 63 1
- 64 1
- 67 1
- 75 1
- 78 1
- 80 1
- 83 1
- 84 1
- 88 1
- 93 1
- 94 1
- 95 1
- 110 1
- 115 1
- 117 1
- 122 1
- 126 1
- 128 1
- 130 1
- 132 1
- 133 1
- 135 1
- 143 1
- 146 1
- 147 1
- 153 1
- 154 1
- 163 1
- 165 1
- 166 1
- 196 1
- 202 1
- 203 1
- 217 1
- 227 1
- 232 1
- 235 1
- 246 1
- 254 1
- 259 1
- 264 1
- 269 1
- 276 1
- 277 1
- 279 1
- 287 1
- 291 1
- 292 1
- 293 1
- 297 1
- 300 1
- 302 1
- 304 1
- 313 1
- 326 1
- 330 1
- 331 1
- 337 1
- 342 1
- 348 1
- 350 1
- 360 1
- 371 1
- 385 1
- 390 1
- 391 1
- 396 1
- 398 1
- 413 1
- 420 1
- 427 1
- 435 1
- 441 1
- 443 1
- 450 1
- 459 1
- 462 1
- 470 1
- 476 1
- 488 1
- 491 1
- 502 1
- 508 1
- 518 1
- 528 1
- 535 1
- 540 1
- 547 1
- 553 1
- 560 1
- 562 1
- 564 1
- 576 1
- 578 1
- 581 1
- 584 1
- 592 1
- 598 1
- 600 1
- 603 1
- 604 1
- 606 1
- 613 1
- 618 1
- 619 1
- 621 1
- 624 1
- 626 1
- 631 1
- 635 1
- 641 1
- 652 1
- 655 1
- 656 1
- 662 1
- 667 1
- 670 1
- 679 1
- 684 1
- 692 1
- 695 1
- 701 1
- 710 1
- 715 1
- 718 1
- 719 1
- 739 1
- 741 1
- 745 1
- 764 1
- 773 1
- 776 1
- 777 1
- 786 1
- 794 1
- 801 1
- 811 1
- 820 1
- 826 1
- 832 1
- 836 1
- 840 1
- 857 1
- 862 1
- 867 1
- 870 1
- 875 1
- 879 1
- 884 1
- 885 1
- 890 1
- 897 1
- 907 1
- 910 1
- 913 1
- 927 1
- 935 1
- 943 1
- 953 1
- 964 1
- 966 1
- 967 1
- 976 1
- 986 1
- 993 1
- 1002 1
- 1019 1
- 1021 1
- 1023 1
- 1024 1
- 1041 1
- 1069 1
- 1071 1
- 1076 1
- 1083 1
- 1090 1
- 1094 1
- 1107 1
- 1121 1
- 1126 1
- 1149 1
- 1155 1
- 1169 1
- 1187 1
- 1222 1
- 1233 1
- 1246 1
- 1274 1
- 1278 1
- 1287 1
- 1307 1
- 1338 1
- 1355 1
- 1381 1
- 1415 1
- 1429 1
- 1437 1
- 1452 1
- 1485 1
- 1507 1
- 1512 1
- 1521 1
- 1530 1
- 1544 1
- 1556 1
- 1582 1
- 1594 1
- 1607 1
- 1623 1
- 1629 1
- 1639 1
- 1669 1
- 1693 1
- 1716 1
- 1728 1
- 1746 1
- 1758 1
- 1766 1
- 1775 1
- 1793 1
- 1799 1
- 1812 1
- 1829 1
- 1836 1
- 1839 1
- 1850 1
- 1857 1
- 1861 1
- 1884 1
- 1890 1
- 1893 1
- 1896 1
- 1902 1
- 1915 1
- 1919 1
- 1928 1
- 1937 1
- 1940 1
- 1942 1
- 1947 1
- 1950 1
- 1954 1
- 1960 1
- 1967 1
- 1968 1
- 1969 1
- 1974 1
- 1980 1
- 1985 1
- 1993 1
- 1994 1
- 1999 1
- 2000 1
- 2005 1
- 2006 1
- 2008 1
- 2009 1
- 2017 1
- 2019 1
- 2022 1
- 2029 1
- 2030 1
- 2032 1
- 2034 1
- 2040 1
- 2045 1
- 2047 1
- 2052 1
- 2054 1
- 2058 1
- 2069 1
- 2078 1
- 2087 1
- 2096 1
- 2103 1
- 2106 1
- 2107 1
- 2112 1
- 2115 1
- 2122 1
- 2134 1
- 2137 1
- 2141 1
- 2144 1
- 2150 1
- 2154 1
- 2156 1
- 2159 1
- 2170 1
- 2175 1
- 2179 1
- 2187 1
- 2208 1
- 2214 1
- 2227 1
- 2248 1
- 2287 1
- 2291 1
- 2308 1
- 2341 1
- 2409 1
- 2416 1
- 2434 1
- 2448 1
- 2482 1
- 2492 1
- 2509 1
- 2524 1
- 2602 1
- 2617 1
- 2629 1
- 2651 1
- 2687 1
- 2692 1
- 2703 1
- 2726 1
- 2755 1
- 2760 1
- 2774 1
- 2805 1
- 2842 1
- 2850 1
- 2862 1
- 2866 1
- 2878 1
- 2883 1
- 2888 1
- 2896 1
- 2911 1
- 2918 1
- 2924 1
- 2935 1
- 2948 1
- 2952 1
- 2959 1
- 2965 1
- 2978 1
- 2988 1
- 2994 1
- 2996 1
- 3010 1
- 3023 1
- 3036 1
- 3040 1
- 3051 1
- 3053 1
- 3072 1
- 3077 1
- 3085 1
- 3094 1
- 3116 1
- 3122 1
- 3154 1
- 3161 1
- 3171 1
- 3176 1
- 3191 1
- 3208 1
- 3222 1
- 3232 1
- 3260 1
- 3275 1
- 3288 1
- 3302 1
- 3330 1
- 3347 1
- 3401 1
- 3428 1
- 3454 1
- 3592 1
- 3641 1
- 3687 1
- 3745 1
- 3887 1
- 3948 1
- 3993 1
- 4058 1
- 4423 1
- 4533 1
- 4592 1
- 4811 1
- 4850 1
- 4886 1
- 4926 1
- 5018 1
- 5085 1
- 5130 1
- 5236 1
- 5374 1
- 5392 1
- 5400 1
- 5409 1
- 5471 1
- 5475 1
- 5485 1
- 5489 1
- 5521 1
- 5523 1
- 5541 1
- 5570 1
- 5573 1
- 5580 1
state 1
- Mississippi · 783 ✖
fips 1
- 28017 · 783 ✖
county 1
- Chickasaw 783
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501001 | 2501001 | 2022-05-13 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2497743 | 2497743 | 2022-05-12 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2494485 | 2494485 | 2022-05-11 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2491227 | 2491227 | 2022-05-10 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2487970 | 2487970 | 2022-05-09 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2484712 | 2484712 | 2022-05-08 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2481454 | 2481454 | 2022-05-07 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2478196 | 2478196 | 2022-05-06 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2474938 | 2474938 | 2022-05-05 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2471681 | 2471681 | 2022-05-04 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2468425 | 2468425 | 2022-05-03 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2465170 | 2465170 | 2022-05-02 | Chickasaw | Mississippi | 28017 | 5594 | 96 |
2461914 | 2461914 | 2022-05-01 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2458658 | 2458658 | 2022-04-30 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2455402 | 2455402 | 2022-04-29 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2452146 | 2452146 | 2022-04-28 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2448890 | 2448890 | 2022-04-27 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2445634 | 2445634 | 2022-04-26 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2442378 | 2442378 | 2022-04-25 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2439122 | 2439122 | 2022-04-24 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2435866 | 2435866 | 2022-04-23 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2432610 | 2432610 | 2022-04-22 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2429354 | 2429354 | 2022-04-21 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2426098 | 2426098 | 2022-04-20 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2422842 | 2422842 | 2022-04-19 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2419586 | 2419586 | 2022-04-18 | Chickasaw | Mississippi | 28017 | 5591 | 96 |
2416330 | 2416330 | 2022-04-17 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2413074 | 2413074 | 2022-04-16 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2409818 | 2409818 | 2022-04-15 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2406562 | 2406562 | 2022-04-14 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2403306 | 2403306 | 2022-04-13 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2400052 | 2400052 | 2022-04-12 | Chickasaw | Mississippi | 28017 | 5587 | 96 |
2396796 | 2396796 | 2022-04-11 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2393541 | 2393541 | 2022-04-10 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2390285 | 2390285 | 2022-04-09 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2387029 | 2387029 | 2022-04-08 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2383774 | 2383774 | 2022-04-07 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2380519 | 2380519 | 2022-04-06 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2377264 | 2377264 | 2022-04-05 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2374012 | 2374012 | 2022-04-04 | Chickasaw | Mississippi | 28017 | 5586 | 96 |
2370759 | 2370759 | 2022-04-03 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2367506 | 2367506 | 2022-04-02 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2364253 | 2364253 | 2022-04-01 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2360999 | 2360999 | 2022-03-31 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2357745 | 2357745 | 2022-03-30 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2354492 | 2354492 | 2022-03-29 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2351240 | 2351240 | 2022-03-28 | Chickasaw | Mississippi | 28017 | 5585 | 96 |
2347987 | 2347987 | 2022-03-27 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
2344734 | 2344734 | 2022-03-26 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
2341481 | 2341481 | 2022-03-25 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
2338228 | 2338228 | 2022-03-24 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
2334974 | 2334974 | 2022-03-23 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
2331720 | 2331720 | 2022-03-22 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
2328468 | 2328468 | 2022-03-21 | Chickasaw | Mississippi | 28017 | 5584 | 96 |
2325215 | 2325215 | 2022-03-20 | Chickasaw | Mississippi | 28017 | 5583 | 96 |
2321961 | 2321961 | 2022-03-19 | Chickasaw | Mississippi | 28017 | 5583 | 96 |
2318707 | 2318707 | 2022-03-18 | Chickasaw | Mississippi | 28017 | 5583 | 96 |
2315454 | 2315454 | 2022-03-17 | Chickasaw | Mississippi | 28017 | 5583 | 96 |
2312201 | 2312201 | 2022-03-16 | Chickasaw | Mississippi | 28017 | 5583 | 96 |
2308948 | 2308948 | 2022-03-15 | Chickasaw | Mississippi | 28017 | 5583 | 96 |
2305697 | 2305697 | 2022-03-14 | Chickasaw | Mississippi | 28017 | 5583 | 96 |
2302445 | 2302445 | 2022-03-13 | Chickasaw | Mississippi | 28017 | 5581 | 96 |
2299193 | 2299193 | 2022-03-12 | Chickasaw | Mississippi | 28017 | 5581 | 96 |
2295941 | 2295941 | 2022-03-11 | Chickasaw | Mississippi | 28017 | 5581 | 96 |
2292689 | 2292689 | 2022-03-10 | Chickasaw | Mississippi | 28017 | 5581 | 96 |
2289437 | 2289437 | 2022-03-09 | Chickasaw | Mississippi | 28017 | 5581 | 96 |
2286186 | 2286186 | 2022-03-08 | Chickasaw | Mississippi | 28017 | 5581 | 96 |
2282934 | 2282934 | 2022-03-07 | Chickasaw | Mississippi | 28017 | 5580 | 95 |
2279681 | 2279681 | 2022-03-06 | Chickasaw | Mississippi | 28017 | 5575 | 95 |
2276428 | 2276428 | 2022-03-05 | Chickasaw | Mississippi | 28017 | 5575 | 95 |
2273175 | 2273175 | 2022-03-04 | Chickasaw | Mississippi | 28017 | 5575 | 95 |
2269923 | 2269923 | 2022-03-03 | Chickasaw | Mississippi | 28017 | 5573 | 95 |
2266670 | 2266670 | 2022-03-02 | Chickasaw | Mississippi | 28017 | 5570 | 95 |
2263419 | 2263419 | 2022-03-01 | Chickasaw | Mississippi | 28017 | 5567 | 95 |
2260168 | 2260168 | 2022-02-28 | Chickasaw | Mississippi | 28017 | 5567 | 95 |
2256917 | 2256917 | 2022-02-27 | Chickasaw | Mississippi | 28017 | 5566 | 95 |
2253666 | 2253666 | 2022-02-26 | Chickasaw | Mississippi | 28017 | 5566 | 95 |
2250415 | 2250415 | 2022-02-25 | Chickasaw | Mississippi | 28017 | 5566 | 95 |
2247164 | 2247164 | 2022-02-24 | Chickasaw | Mississippi | 28017 | 5541 | 93 |
2243913 | 2243913 | 2022-02-23 | Chickasaw | Mississippi | 28017 | 5523 | 93 |
2240662 | 2240662 | 2022-02-22 | Chickasaw | Mississippi | 28017 | 5521 | 92 |
2237411 | 2237411 | 2022-02-21 | Chickasaw | Mississippi | 28017 | 5497 | 92 |
2234160 | 2234160 | 2022-02-20 | Chickasaw | Mississippi | 28017 | 5497 | 92 |
2230909 | 2230909 | 2022-02-19 | Chickasaw | Mississippi | 28017 | 5497 | 92 |
2227658 | 2227658 | 2022-02-18 | Chickasaw | Mississippi | 28017 | 5497 | 92 |
2224407 | 2224407 | 2022-02-17 | Chickasaw | Mississippi | 28017 | 5489 | 92 |
2221156 | 2221156 | 2022-02-16 | Chickasaw | Mississippi | 28017 | 5485 | 92 |
2217905 | 2217905 | 2022-02-15 | Chickasaw | Mississippi | 28017 | 5475 | 89 |
2214654 | 2214654 | 2022-02-14 | Chickasaw | Mississippi | 28017 | 5471 | 89 |
2211402 | 2211402 | 2022-02-13 | Chickasaw | Mississippi | 28017 | 5420 | 88 |
2208149 | 2208149 | 2022-02-12 | Chickasaw | Mississippi | 28017 | 5420 | 88 |
2204896 | 2204896 | 2022-02-11 | Chickasaw | Mississippi | 28017 | 5420 | 88 |
2201643 | 2201643 | 2022-02-10 | Chickasaw | Mississippi | 28017 | 5409 | 87 |
2198389 | 2198389 | 2022-02-09 | Chickasaw | Mississippi | 28017 | 5400 | 86 |
2195135 | 2195135 | 2022-02-08 | Chickasaw | Mississippi | 28017 | 5392 | 85 |
2191881 | 2191881 | 2022-02-07 | Chickasaw | Mississippi | 28017 | 5374 | 85 |
2188628 | 2188628 | 2022-02-06 | Chickasaw | Mississippi | 28017 | 5300 | 85 |
2185375 | 2185375 | 2022-02-05 | Chickasaw | Mississippi | 28017 | 5300 | 85 |
2182123 | 2182123 | 2022-02-04 | Chickasaw | Mississippi | 28017 | 5300 | 85 |
2178871 | 2178871 | 2022-02-03 | Chickasaw | Mississippi | 28017 | 5236 | 84 |
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);