ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
457 rows where deaths = 43 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Jefferson Davis 102
- Amite 37
- Montgomery 31
- Lawrence 26
- Leake 22
- Lafayette 21
- Walthall 19
- Tunica 14
- Wayne 11
- Yalobusha 11
- Benton 10
- Noxubee 10
- Attala 9
- Coahoma 9
- Forrest 8
- Copiah 7
- Holmes 7
- Kemper 7
- Carroll 6
- Panola 6
- Webster 6
- George 5
- Itawamba 5
- Lee 5
- Adams 4
- DeSoto 4
- Grenada 4
- Scott 4
- Hancock 3
- Marion 3
- …
state 1
- Mississippi · 457 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217923 | 2217923 | 2022-02-15 | Humphreys | Mississippi | 28053 | 2001 | 43 |
2217968 | 2217968 | 2022-02-15 | Tunica | Mississippi | 28143 | 2493 | 43 |
2214717 | 2214717 | 2022-02-14 | Tunica | Mississippi | 28143 | 2484 | 43 |
2211465 | 2211465 | 2022-02-13 | Tunica | Mississippi | 28143 | 2480 | 43 |
2208212 | 2208212 | 2022-02-12 | Tunica | Mississippi | 28143 | 2480 | 43 |
2204959 | 2204959 | 2022-02-11 | Tunica | Mississippi | 28143 | 2480 | 43 |
2201706 | 2201706 | 2022-02-10 | Tunica | Mississippi | 28143 | 2474 | 43 |
2198452 | 2198452 | 2022-02-09 | Tunica | Mississippi | 28143 | 2471 | 43 |
2198459 | 2198459 | 2022-02-09 | Wilkinson | Mississippi | 28157 | 1760 | 43 |
2195198 | 2195198 | 2022-02-08 | Tunica | Mississippi | 28143 | 2465 | 43 |
2195205 | 2195205 | 2022-02-08 | Wilkinson | Mississippi | 28157 | 1757 | 43 |
2191944 | 2191944 | 2022-02-07 | Tunica | Mississippi | 28143 | 2462 | 43 |
2191951 | 2191951 | 2022-02-07 | Wilkinson | Mississippi | 28157 | 1756 | 43 |
2188691 | 2188691 | 2022-02-06 | Tunica | Mississippi | 28143 | 2438 | 43 |
2185438 | 2185438 | 2022-02-05 | Tunica | Mississippi | 28143 | 2438 | 43 |
2182186 | 2182186 | 2022-02-04 | Tunica | Mississippi | 28143 | 2438 | 43 |
2178934 | 2178934 | 2022-02-03 | Tunica | Mississippi | 28143 | 2431 | 43 |
2175645 | 2175645 | 2022-02-02 | Kemper | Mississippi | 28069 | 2058 | 43 |
2175682 | 2175682 | 2022-02-02 | Tunica | Mississippi | 28143 | 2415 | 43 |
2172392 | 2172392 | 2022-02-01 | Kemper | Mississippi | 28069 | 2052 | 43 |
2169137 | 2169137 | 2022-01-31 | Jefferson Davis | Mississippi | 28065 | 2646 | 43 |
2169139 | 2169139 | 2022-01-31 | Kemper | Mississippi | 28069 | 2041 | 43 |
2165854 | 2165854 | 2022-01-30 | Benton | Mississippi | 28009 | 2040 | 43 |
2165857 | 2165857 | 2022-01-30 | Carroll | Mississippi | 28015 | 2387 | 43 |
2165882 | 2165882 | 2022-01-30 | Jefferson Davis | Mississippi | 28065 | 2621 | 43 |
2165884 | 2165884 | 2022-01-30 | Kemper | Mississippi | 28069 | 2024 | 43 |
2162599 | 2162599 | 2022-01-29 | Benton | Mississippi | 28009 | 2040 | 43 |
2162602 | 2162602 | 2022-01-29 | Carroll | Mississippi | 28015 | 2387 | 43 |
2162627 | 2162627 | 2022-01-29 | Jefferson Davis | Mississippi | 28065 | 2621 | 43 |
2162629 | 2162629 | 2022-01-29 | Kemper | Mississippi | 28069 | 2024 | 43 |
2159344 | 2159344 | 2022-01-28 | Benton | Mississippi | 28009 | 2040 | 43 |
2159347 | 2159347 | 2022-01-28 | Carroll | Mississippi | 28015 | 2387 | 43 |
2159372 | 2159372 | 2022-01-28 | Jefferson Davis | Mississippi | 28065 | 2621 | 43 |
2159374 | 2159374 | 2022-01-28 | Kemper | Mississippi | 28069 | 2024 | 43 |
2156090 | 2156090 | 2022-01-27 | Benton | Mississippi | 28009 | 2033 | 43 |
2156093 | 2156093 | 2022-01-27 | Carroll | Mississippi | 28015 | 2371 | 43 |
2156118 | 2156118 | 2022-01-27 | Jefferson Davis | Mississippi | 28065 | 2607 | 43 |
2156120 | 2156120 | 2022-01-27 | Kemper | Mississippi | 28069 | 2010 | 43 |
2152837 | 2152837 | 2022-01-26 | Benton | Mississippi | 28009 | 2009 | 43 |
2152840 | 2152840 | 2022-01-26 | Carroll | Mississippi | 28015 | 2355 | 43 |
2152865 | 2152865 | 2022-01-26 | Jefferson Davis | Mississippi | 28065 | 2582 | 43 |
2149585 | 2149585 | 2022-01-25 | Benton | Mississippi | 28009 | 2001 | 43 |
2149588 | 2149588 | 2022-01-25 | Carroll | Mississippi | 28015 | 2341 | 43 |
2149613 | 2149613 | 2022-01-25 | Jefferson Davis | Mississippi | 28065 | 2570 | 43 |
2146333 | 2146333 | 2022-01-24 | Benton | Mississippi | 28009 | 1981 | 43 |
2146361 | 2146361 | 2022-01-24 | Jefferson Davis | Mississippi | 28065 | 2554 | 43 |
2143078 | 2143078 | 2022-01-23 | Benton | Mississippi | 28009 | 1954 | 43 |
2143106 | 2143106 | 2022-01-23 | Jefferson Davis | Mississippi | 28065 | 2527 | 43 |
2139823 | 2139823 | 2022-01-22 | Benton | Mississippi | 28009 | 1954 | 43 |
2139851 | 2139851 | 2022-01-22 | Jefferson Davis | Mississippi | 28065 | 2527 | 43 |
2136567 | 2136567 | 2022-01-21 | Benton | Mississippi | 28009 | 1954 | 43 |
2136595 | 2136595 | 2022-01-21 | Jefferson Davis | Mississippi | 28065 | 2527 | 43 |
2133343 | 2133343 | 2022-01-20 | Jefferson Davis | Mississippi | 28065 | 2502 | 43 |
2130090 | 2130090 | 2022-01-19 | Jefferson Davis | Mississippi | 28065 | 2480 | 43 |
2126836 | 2126836 | 2022-01-18 | Jefferson Davis | Mississippi | 28065 | 2446 | 43 |
2123584 | 2123584 | 2022-01-17 | Jefferson Davis | Mississippi | 28065 | 2316 | 43 |
2120332 | 2120332 | 2022-01-16 | Jefferson Davis | Mississippi | 28065 | 2316 | 43 |
2117080 | 2117080 | 2022-01-15 | Jefferson Davis | Mississippi | 28065 | 2316 | 43 |
2113829 | 2113829 | 2022-01-14 | Jefferson Davis | Mississippi | 28065 | 2316 | 43 |
2110577 | 2110577 | 2022-01-13 | Jefferson Davis | Mississippi | 28065 | 2291 | 43 |
2107326 | 2107326 | 2022-01-12 | Jefferson Davis | Mississippi | 28065 | 2259 | 43 |
2104075 | 2104075 | 2022-01-11 | Jefferson Davis | Mississippi | 28065 | 2229 | 43 |
2100824 | 2100824 | 2022-01-10 | Jefferson Davis | Mississippi | 28065 | 2199 | 43 |
2097573 | 2097573 | 2022-01-09 | Jefferson Davis | Mississippi | 28065 | 2135 | 43 |
2094321 | 2094321 | 2022-01-08 | Jefferson Davis | Mississippi | 28065 | 2135 | 43 |
2091069 | 2091069 | 2022-01-07 | Jefferson Davis | Mississippi | 28065 | 2135 | 43 |
2087818 | 2087818 | 2022-01-06 | Jefferson Davis | Mississippi | 28065 | 2091 | 43 |
2084566 | 2084566 | 2022-01-05 | Jefferson Davis | Mississippi | 28065 | 2042 | 43 |
2081314 | 2081314 | 2022-01-04 | Jefferson Davis | Mississippi | 28065 | 2008 | 43 |
2081320 | 2081320 | 2022-01-04 | Lawrence | Mississippi | 28077 | 2446 | 43 |
2078062 | 2078062 | 2022-01-03 | Jefferson Davis | Mississippi | 28065 | 1976 | 43 |
2078068 | 2078068 | 2022-01-03 | Lawrence | Mississippi | 28077 | 2432 | 43 |
2074811 | 2074811 | 2022-01-02 | Jefferson Davis | Mississippi | 28065 | 1893 | 43 |
2074817 | 2074817 | 2022-01-02 | Lawrence | Mississippi | 28077 | 2371 | 43 |
2071560 | 2071560 | 2022-01-01 | Jefferson Davis | Mississippi | 28065 | 1893 | 43 |
2071566 | 2071566 | 2022-01-01 | Lawrence | Mississippi | 28077 | 2371 | 43 |
2068309 | 2068309 | 2021-12-31 | Jefferson Davis | Mississippi | 28065 | 1893 | 43 |
2068315 | 2068315 | 2021-12-31 | Lawrence | Mississippi | 28077 | 2371 | 43 |
2065058 | 2065058 | 2021-12-30 | Jefferson Davis | Mississippi | 28065 | 1893 | 43 |
2065064 | 2065064 | 2021-12-30 | Lawrence | Mississippi | 28077 | 2371 | 43 |
2061808 | 2061808 | 2021-12-29 | Jefferson Davis | Mississippi | 28065 | 1846 | 43 |
2061814 | 2061814 | 2021-12-29 | Lawrence | Mississippi | 28077 | 2339 | 43 |
2058559 | 2058559 | 2021-12-28 | Jefferson Davis | Mississippi | 28065 | 1823 | 43 |
2058565 | 2058565 | 2021-12-28 | Lawrence | Mississippi | 28077 | 2308 | 43 |
2055310 | 2055310 | 2021-12-27 | Jefferson Davis | Mississippi | 28065 | 1796 | 43 |
2055316 | 2055316 | 2021-12-27 | Lawrence | Mississippi | 28077 | 2294 | 43 |
2052060 | 2052060 | 2021-12-26 | Jefferson Davis | Mississippi | 28065 | 1768 | 43 |
2052066 | 2052066 | 2021-12-26 | Lawrence | Mississippi | 28077 | 2245 | 43 |
2048810 | 2048810 | 2021-12-25 | Jefferson Davis | Mississippi | 28065 | 1768 | 43 |
2048816 | 2048816 | 2021-12-25 | Lawrence | Mississippi | 28077 | 2245 | 43 |
2045560 | 2045560 | 2021-12-24 | Jefferson Davis | Mississippi | 28065 | 1768 | 43 |
2045566 | 2045566 | 2021-12-24 | Lawrence | Mississippi | 28077 | 2245 | 43 |
2042310 | 2042310 | 2021-12-23 | Jefferson Davis | Mississippi | 28065 | 1768 | 43 |
2042316 | 2042316 | 2021-12-23 | Lawrence | Mississippi | 28077 | 2245 | 43 |
2039061 | 2039061 | 2021-12-22 | Jefferson Davis | Mississippi | 28065 | 1768 | 43 |
2039067 | 2039067 | 2021-12-22 | Lawrence | Mississippi | 28077 | 2245 | 43 |
2035811 | 2035811 | 2021-12-21 | Jefferson Davis | Mississippi | 28065 | 1764 | 43 |
2035817 | 2035817 | 2021-12-21 | Lawrence | Mississippi | 28077 | 2243 | 43 |
2032561 | 2032561 | 2021-12-20 | Jefferson Davis | Mississippi | 28065 | 1764 | 43 |
2032567 | 2032567 | 2021-12-20 | Lawrence | Mississippi | 28077 | 2237 | 43 |
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);