ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
306 rows where deaths = 78 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2282999 | 2282999 | 2022-03-07 | Walthall | Mississippi | 28147 | 3579 | 78 |
2279746 | 2279746 | 2022-03-06 | Walthall | Mississippi | 28147 | 3574 | 78 |
2276493 | 2276493 | 2022-03-05 | Walthall | Mississippi | 28147 | 3574 | 78 |
2273240 | 2273240 | 2022-03-04 | Walthall | Mississippi | 28147 | 3574 | 78 |
2269988 | 2269988 | 2022-03-03 | Walthall | Mississippi | 28147 | 3572 | 78 |
2266735 | 2266735 | 2022-03-02 | Walthall | Mississippi | 28147 | 3571 | 78 |
2263484 | 2263484 | 2022-03-01 | Walthall | Mississippi | 28147 | 3570 | 78 |
2260233 | 2260233 | 2022-02-28 | Walthall | Mississippi | 28147 | 3570 | 78 |
2256982 | 2256982 | 2022-02-27 | Walthall | Mississippi | 28147 | 3568 | 78 |
2253731 | 2253731 | 2022-02-26 | Walthall | Mississippi | 28147 | 3568 | 78 |
2250480 | 2250480 | 2022-02-25 | Walthall | Mississippi | 28147 | 3568 | 78 |
2247229 | 2247229 | 2022-02-24 | Walthall | Mississippi | 28147 | 3566 | 78 |
2243978 | 2243978 | 2022-02-23 | Walthall | Mississippi | 28147 | 3564 | 78 |
2240727 | 2240727 | 2022-02-22 | Walthall | Mississippi | 28147 | 3562 | 78 |
2237476 | 2237476 | 2022-02-21 | Walthall | Mississippi | 28147 | 3560 | 78 |
2234225 | 2234225 | 2022-02-20 | Walthall | Mississippi | 28147 | 3560 | 78 |
2230974 | 2230974 | 2022-02-19 | Walthall | Mississippi | 28147 | 3560 | 78 |
2227723 | 2227723 | 2022-02-18 | Walthall | Mississippi | 28147 | 3560 | 78 |
2224472 | 2224472 | 2022-02-17 | Walthall | Mississippi | 28147 | 3553 | 78 |
2221221 | 2221221 | 2022-02-16 | Walthall | Mississippi | 28147 | 3549 | 78 |
2178939 | 2178939 | 2022-02-03 | Wayne | Mississippi | 28153 | 5455 | 78 |
2175687 | 2175687 | 2022-02-02 | Wayne | Mississippi | 28153 | 5379 | 78 |
2130070 | 2130070 | 2022-01-19 | Clay | Mississippi | 28025 | 4370 | 78 |
2126816 | 2126816 | 2022-01-18 | Clay | Mississippi | 28025 | 4283 | 78 |
2123564 | 2123564 | 2022-01-17 | Clay | Mississippi | 28025 | 4126 | 78 |
2120312 | 2120312 | 2022-01-16 | Clay | Mississippi | 28025 | 4126 | 78 |
2117060 | 2117060 | 2022-01-15 | Clay | Mississippi | 28025 | 4126 | 78 |
2113809 | 2113809 | 2022-01-14 | Clay | Mississippi | 28025 | 4126 | 78 |
2110557 | 2110557 | 2022-01-13 | Clay | Mississippi | 28025 | 4059 | 78 |
2107302 | 2107302 | 2022-01-12 | Chickasaw | Mississippi | 28017 | 3993 | 78 |
2107306 | 2107306 | 2022-01-12 | Clay | Mississippi | 28025 | 3965 | 78 |
2104055 | 2104055 | 2022-01-11 | Clay | Mississippi | 28025 | 3895 | 78 |
2100804 | 2100804 | 2022-01-10 | Clay | Mississippi | 28025 | 3855 | 78 |
2097553 | 2097553 | 2022-01-09 | Clay | Mississippi | 28025 | 3712 | 78 |
2094301 | 2094301 | 2022-01-08 | Clay | Mississippi | 28025 | 3712 | 78 |
2091049 | 2091049 | 2022-01-07 | Clay | Mississippi | 28025 | 3712 | 78 |
2087798 | 2087798 | 2022-01-06 | Clay | Mississippi | 28025 | 3657 | 78 |
2084546 | 2084546 | 2022-01-05 | Clay | Mississippi | 28025 | 3597 | 78 |
2081294 | 2081294 | 2022-01-04 | Clay | Mississippi | 28025 | 3539 | 78 |
2078042 | 2078042 | 2022-01-03 | Clay | Mississippi | 28025 | 3483 | 78 |
2074791 | 2074791 | 2022-01-02 | Clay | Mississippi | 28025 | 3345 | 78 |
2071540 | 2071540 | 2022-01-01 | Clay | Mississippi | 28025 | 3345 | 78 |
2068289 | 2068289 | 2021-12-31 | Clay | Mississippi | 28025 | 3345 | 78 |
2065038 | 2065038 | 2021-12-30 | Clay | Mississippi | 28025 | 3345 | 78 |
2061788 | 2061788 | 2021-12-29 | Clay | Mississippi | 28025 | 3305 | 78 |
2058539 | 2058539 | 2021-12-28 | Clay | Mississippi | 28025 | 3276 | 78 |
2055290 | 2055290 | 2021-12-27 | Clay | Mississippi | 28025 | 3246 | 78 |
2052040 | 2052040 | 2021-12-26 | Clay | Mississippi | 28025 | 3207 | 78 |
2048790 | 2048790 | 2021-12-25 | Clay | Mississippi | 28025 | 3207 | 78 |
2045540 | 2045540 | 2021-12-24 | Clay | Mississippi | 28025 | 3207 | 78 |
2042290 | 2042290 | 2021-12-23 | Clay | Mississippi | 28025 | 3207 | 78 |
2039041 | 2039041 | 2021-12-22 | Clay | Mississippi | 28025 | 3207 | 78 |
2035791 | 2035791 | 2021-12-21 | Clay | Mississippi | 28025 | 3203 | 78 |
2032541 | 2032541 | 2021-12-20 | Clay | Mississippi | 28025 | 3201 | 78 |
2029290 | 2029290 | 2021-12-19 | Clay | Mississippi | 28025 | 3195 | 78 |
2026039 | 2026039 | 2021-12-18 | Clay | Mississippi | 28025 | 3195 | 78 |
2022788 | 2022788 | 2021-12-17 | Clay | Mississippi | 28025 | 3195 | 78 |
2019537 | 2019537 | 2021-12-16 | Clay | Mississippi | 28025 | 3190 | 78 |
2016287 | 2016287 | 2021-12-15 | Clay | Mississippi | 28025 | 3181 | 78 |
2013036 | 2013036 | 2021-12-14 | Clay | Mississippi | 28025 | 3172 | 78 |
2009785 | 2009785 | 2021-12-13 | Clay | Mississippi | 28025 | 3167 | 78 |
2006534 | 2006534 | 2021-12-12 | Clay | Mississippi | 28025 | 3157 | 78 |
2003283 | 2003283 | 2021-12-11 | Clay | Mississippi | 28025 | 3157 | 78 |
2000033 | 2000033 | 2021-12-10 | Clay | Mississippi | 28025 | 3157 | 78 |
1996782 | 1996782 | 2021-12-09 | Clay | Mississippi | 28025 | 3150 | 78 |
1993531 | 1993531 | 2021-12-08 | Clay | Mississippi | 28025 | 3148 | 78 |
1990280 | 1990280 | 2021-12-07 | Clay | Mississippi | 28025 | 3143 | 78 |
1987030 | 1987030 | 2021-12-06 | Clay | Mississippi | 28025 | 3139 | 78 |
1983780 | 1983780 | 2021-12-05 | Clay | Mississippi | 28025 | 3129 | 78 |
1980530 | 1980530 | 2021-12-04 | Clay | Mississippi | 28025 | 3129 | 78 |
1977280 | 1977280 | 2021-12-03 | Clay | Mississippi | 28025 | 3129 | 78 |
1974030 | 1974030 | 2021-12-02 | Clay | Mississippi | 28025 | 3127 | 78 |
1970781 | 1970781 | 2021-12-01 | Clay | Mississippi | 28025 | 3126 | 78 |
1967531 | 1967531 | 2021-11-30 | Clay | Mississippi | 28025 | 3125 | 78 |
1964279 | 1964279 | 2021-11-29 | Clay | Mississippi | 28025 | 3122 | 78 |
1961028 | 1961028 | 2021-11-28 | Clay | Mississippi | 28025 | 3118 | 78 |
1957777 | 1957777 | 2021-11-27 | Clay | Mississippi | 28025 | 3118 | 78 |
1954526 | 1954526 | 2021-11-26 | Clay | Mississippi | 28025 | 3118 | 78 |
1951275 | 1951275 | 2021-11-25 | Clay | Mississippi | 28025 | 3118 | 78 |
1948024 | 1948024 | 2021-11-24 | Clay | Mississippi | 28025 | 3118 | 78 |
1944773 | 1944773 | 2021-11-23 | Clay | Mississippi | 28025 | 3117 | 78 |
1941522 | 1941522 | 2021-11-22 | Clay | Mississippi | 28025 | 3117 | 78 |
1938272 | 1938272 | 2021-11-21 | Clay | Mississippi | 28025 | 3114 | 78 |
1935022 | 1935022 | 2021-11-20 | Clay | Mississippi | 28025 | 3114 | 78 |
1931772 | 1931772 | 2021-11-19 | Clay | Mississippi | 28025 | 3114 | 78 |
1928521 | 1928521 | 2021-11-18 | Clay | Mississippi | 28025 | 3112 | 78 |
1925271 | 1925271 | 2021-11-17 | Clay | Mississippi | 28025 | 3111 | 78 |
1922022 | 1922022 | 2021-11-16 | Clay | Mississippi | 28025 | 3109 | 78 |
1918772 | 1918772 | 2021-11-15 | Clay | Mississippi | 28025 | 3106 | 78 |
1805083 | 1805083 | 2021-10-11 | Newton | Mississippi | 28101 | 3793 | 78 |
1801834 | 1801834 | 2021-10-10 | Newton | Mississippi | 28101 | 3790 | 78 |
1798585 | 1798585 | 2021-10-09 | Newton | Mississippi | 28101 | 3790 | 78 |
1795336 | 1795336 | 2021-10-08 | Newton | Mississippi | 28101 | 3790 | 78 |
1792087 | 1792087 | 2021-10-07 | Newton | Mississippi | 28101 | 3788 | 78 |
1788838 | 1788838 | 2021-10-06 | Newton | Mississippi | 28101 | 3768 | 78 |
1785590 | 1785590 | 2021-10-05 | Newton | Mississippi | 28101 | 3764 | 78 |
1701139 | 1701139 | 2021-09-09 | Tippah | Mississippi | 28139 | 4232 | 78 |
1697890 | 1697890 | 2021-09-08 | Tippah | Mississippi | 28139 | 4194 | 78 |
1694642 | 1694642 | 2021-09-07 | Tippah | Mississippi | 28139 | 4158 | 78 |
1675091 | 1675091 | 2021-09-01 | Copiah | Mississippi | 28029 | 3928 | 78 |
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);