ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
269 rows where deaths = 92 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Leake 46
- Winston 44
- Marshall 18
- Copiah 15
- Tishomingo 13
- Newton 12
- Madison 10
- Clay 9
- Yazoo 9
- Chickasaw 7
- Covington 7
- Grenada 7
- Panola 7
- Lafayette 5
- Neshoba 5
- Lauderdale 4
- Lincoln 4
- Scott 4
- Sunflower 4
- Clarke 3
- Forrest 3
- Hancock 3
- Harrison 3
- Lowndes 3
- Pontotoc 3
- Bolivar 2
- Coahoma 2
- Jones 2
- Lamar 2
- Marion 2
- …
state 1
- Mississippi · 269 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2247168 | 2247168 | 2022-02-24 | Clay | Mississippi | 28025 | 4925 | 92 |
2243917 | 2243917 | 2022-02-23 | Clay | Mississippi | 28025 | 4924 | 92 |
2240662 | 2240662 | 2022-02-22 | Chickasaw | Mississippi | 28017 | 5521 | 92 |
2240666 | 2240666 | 2022-02-22 | Clay | Mississippi | 28025 | 4922 | 92 |
2237411 | 2237411 | 2022-02-21 | Chickasaw | Mississippi | 28017 | 5497 | 92 |
2237415 | 2237415 | 2022-02-21 | Clay | Mississippi | 28025 | 4917 | 92 |
2234160 | 2234160 | 2022-02-20 | Chickasaw | Mississippi | 28017 | 5497 | 92 |
2234164 | 2234164 | 2022-02-20 | Clay | Mississippi | 28025 | 4917 | 92 |
2230909 | 2230909 | 2022-02-19 | Chickasaw | Mississippi | 28017 | 5497 | 92 |
2230913 | 2230913 | 2022-02-19 | Clay | Mississippi | 28025 | 4917 | 92 |
2227658 | 2227658 | 2022-02-18 | Chickasaw | Mississippi | 28017 | 5497 | 92 |
2227662 | 2227662 | 2022-02-18 | Clay | Mississippi | 28025 | 4917 | 92 |
2224407 | 2224407 | 2022-02-17 | Chickasaw | Mississippi | 28017 | 5489 | 92 |
2224411 | 2224411 | 2022-02-17 | Clay | Mississippi | 28025 | 4916 | 92 |
2221156 | 2221156 | 2022-02-16 | Chickasaw | Mississippi | 28017 | 5485 | 92 |
2221160 | 2221160 | 2022-02-16 | Clay | Mississippi | 28025 | 4915 | 92 |
2217947 | 2217947 | 2022-02-15 | Newton | Mississippi | 28101 | 5878 | 92 |
2214696 | 2214696 | 2022-02-14 | Newton | Mississippi | 28101 | 5870 | 92 |
2211444 | 2211444 | 2022-02-13 | Newton | Mississippi | 28101 | 5804 | 92 |
2208191 | 2208191 | 2022-02-12 | Newton | Mississippi | 28101 | 5804 | 92 |
2204938 | 2204938 | 2022-02-11 | Newton | Mississippi | 28101 | 5804 | 92 |
2201685 | 2201685 | 2022-02-10 | Newton | Mississippi | 28101 | 5791 | 92 |
2198431 | 2198431 | 2022-02-09 | Newton | Mississippi | 28101 | 5772 | 92 |
2195177 | 2195177 | 2022-02-08 | Newton | Mississippi | 28101 | 5747 | 92 |
2191923 | 2191923 | 2022-02-07 | Newton | Mississippi | 28101 | 5738 | 92 |
2188670 | 2188670 | 2022-02-06 | Newton | Mississippi | 28101 | 5677 | 92 |
2185417 | 2185417 | 2022-02-05 | Newton | Mississippi | 28101 | 5677 | 92 |
2182165 | 2182165 | 2022-02-04 | Newton | Mississippi | 28101 | 5677 | 92 |
2178921 | 2178921 | 2022-02-03 | Prentiss | Mississippi | 28117 | 7569 | 92 |
2175669 | 2175669 | 2022-02-02 | Prentiss | Mississippi | 28117 | 7492 | 92 |
2143113 | 2143113 | 2022-01-23 | Leake | Mississippi | 28079 | 5339 | 92 |
2139858 | 2139858 | 2022-01-22 | Leake | Mississippi | 28079 | 5339 | 92 |
2136602 | 2136602 | 2022-01-21 | Leake | Mississippi | 28079 | 5339 | 92 |
2133350 | 2133350 | 2022-01-20 | Leake | Mississippi | 28079 | 5290 | 92 |
2130097 | 2130097 | 2022-01-19 | Leake | Mississippi | 28079 | 5244 | 92 |
2126843 | 2126843 | 2022-01-18 | Leake | Mississippi | 28079 | 5171 | 92 |
2123591 | 2123591 | 2022-01-17 | Leake | Mississippi | 28079 | 5009 | 92 |
2120339 | 2120339 | 2022-01-16 | Leake | Mississippi | 28079 | 5009 | 92 |
2117087 | 2117087 | 2022-01-15 | Leake | Mississippi | 28079 | 5009 | 92 |
2113836 | 2113836 | 2022-01-14 | Leake | Mississippi | 28079 | 5009 | 92 |
2110584 | 2110584 | 2022-01-13 | Leake | Mississippi | 28079 | 4948 | 92 |
2107333 | 2107333 | 2022-01-12 | Leake | Mississippi | 28079 | 4900 | 92 |
2104082 | 2104082 | 2022-01-11 | Leake | Mississippi | 28079 | 4815 | 92 |
2100831 | 2100831 | 2022-01-10 | Leake | Mississippi | 28079 | 4762 | 92 |
2097580 | 2097580 | 2022-01-09 | Leake | Mississippi | 28079 | 4647 | 92 |
2094328 | 2094328 | 2022-01-08 | Leake | Mississippi | 28079 | 4647 | 92 |
2091076 | 2091076 | 2022-01-07 | Leake | Mississippi | 28079 | 4647 | 92 |
2087825 | 2087825 | 2022-01-06 | Leake | Mississippi | 28079 | 4594 | 92 |
2084573 | 2084573 | 2022-01-05 | Leake | Mississippi | 28079 | 4545 | 92 |
2081321 | 2081321 | 2022-01-04 | Leake | Mississippi | 28079 | 4490 | 92 |
2078069 | 2078069 | 2022-01-03 | Leake | Mississippi | 28079 | 4434 | 92 |
2074818 | 2074818 | 2022-01-02 | Leake | Mississippi | 28079 | 4315 | 92 |
2071567 | 2071567 | 2022-01-01 | Leake | Mississippi | 28079 | 4315 | 92 |
2068316 | 2068316 | 2021-12-31 | Leake | Mississippi | 28079 | 4315 | 92 |
2065065 | 2065065 | 2021-12-30 | Leake | Mississippi | 28079 | 4315 | 92 |
2061815 | 2061815 | 2021-12-29 | Leake | Mississippi | 28079 | 4281 | 92 |
2061855 | 2061855 | 2021-12-29 | Winston | Mississippi | 28159 | 3264 | 92 |
2058566 | 2058566 | 2021-12-28 | Leake | Mississippi | 28079 | 4258 | 92 |
2058606 | 2058606 | 2021-12-28 | Winston | Mississippi | 28159 | 3243 | 92 |
2055317 | 2055317 | 2021-12-27 | Leake | Mississippi | 28079 | 4223 | 92 |
2055357 | 2055357 | 2021-12-27 | Winston | Mississippi | 28159 | 3240 | 92 |
2052067 | 2052067 | 2021-12-26 | Leake | Mississippi | 28079 | 4175 | 92 |
2052107 | 2052107 | 2021-12-26 | Winston | Mississippi | 28159 | 3228 | 92 |
2048817 | 2048817 | 2021-12-25 | Leake | Mississippi | 28079 | 4175 | 92 |
2048857 | 2048857 | 2021-12-25 | Winston | Mississippi | 28159 | 3228 | 92 |
2045567 | 2045567 | 2021-12-24 | Leake | Mississippi | 28079 | 4175 | 92 |
2045607 | 2045607 | 2021-12-24 | Winston | Mississippi | 28159 | 3228 | 92 |
2042317 | 2042317 | 2021-12-23 | Leake | Mississippi | 28079 | 4175 | 92 |
2042357 | 2042357 | 2021-12-23 | Winston | Mississippi | 28159 | 3228 | 92 |
2039068 | 2039068 | 2021-12-22 | Leake | Mississippi | 28079 | 4175 | 92 |
2039108 | 2039108 | 2021-12-22 | Winston | Mississippi | 28159 | 3228 | 92 |
2035818 | 2035818 | 2021-12-21 | Leake | Mississippi | 28079 | 4172 | 92 |
2035858 | 2035858 | 2021-12-21 | Winston | Mississippi | 28159 | 3220 | 92 |
2032568 | 2032568 | 2021-12-20 | Leake | Mississippi | 28079 | 4170 | 92 |
2032608 | 2032608 | 2021-12-20 | Winston | Mississippi | 28159 | 3219 | 92 |
2029317 | 2029317 | 2021-12-19 | Leake | Mississippi | 28079 | 4161 | 92 |
2029357 | 2029357 | 2021-12-19 | Winston | Mississippi | 28159 | 3216 | 92 |
2026066 | 2026066 | 2021-12-18 | Leake | Mississippi | 28079 | 4161 | 92 |
2026106 | 2026106 | 2021-12-18 | Winston | Mississippi | 28159 | 3216 | 92 |
2022815 | 2022815 | 2021-12-17 | Leake | Mississippi | 28079 | 4161 | 92 |
2022855 | 2022855 | 2021-12-17 | Winston | Mississippi | 28159 | 3216 | 92 |
2019564 | 2019564 | 2021-12-16 | Leake | Mississippi | 28079 | 4159 | 92 |
2019604 | 2019604 | 2021-12-16 | Winston | Mississippi | 28159 | 3215 | 92 |
2016314 | 2016314 | 2021-12-15 | Leake | Mississippi | 28079 | 4158 | 92 |
2016354 | 2016354 | 2021-12-15 | Winston | Mississippi | 28159 | 3210 | 92 |
2013063 | 2013063 | 2021-12-14 | Leake | Mississippi | 28079 | 4157 | 92 |
2013103 | 2013103 | 2021-12-14 | Winston | Mississippi | 28159 | 3207 | 92 |
2009812 | 2009812 | 2021-12-13 | Leake | Mississippi | 28079 | 4153 | 92 |
2009852 | 2009852 | 2021-12-13 | Winston | Mississippi | 28159 | 3206 | 92 |
2006561 | 2006561 | 2021-12-12 | Leake | Mississippi | 28079 | 4151 | 92 |
2006601 | 2006601 | 2021-12-12 | Winston | Mississippi | 28159 | 3203 | 92 |
2003310 | 2003310 | 2021-12-11 | Leake | Mississippi | 28079 | 4151 | 92 |
2003350 | 2003350 | 2021-12-11 | Winston | Mississippi | 28159 | 3203 | 92 |
2000060 | 2000060 | 2021-12-10 | Leake | Mississippi | 28079 | 4151 | 92 |
2000100 | 2000100 | 2021-12-10 | Winston | Mississippi | 28159 | 3203 | 92 |
1996809 | 1996809 | 2021-12-09 | Leake | Mississippi | 28079 | 4150 | 92 |
1996849 | 1996849 | 2021-12-09 | Winston | Mississippi | 28159 | 3199 | 92 |
1993598 | 1993598 | 2021-12-08 | Winston | Mississippi | 28159 | 3197 | 92 |
1993600 | 1993600 | 2021-12-08 | Yazoo | Mississippi | 28163 | 4593 | 92 |
1990347 | 1990347 | 2021-12-07 | Winston | Mississippi | 28159 | 3190 | 92 |
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);