ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where deaths = 97 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2348029 | 2348029 | 2022-03-27 | Newton | Mississippi | 28101 | 5996 | 97 |
2344776 | 2344776 | 2022-03-26 | Newton | Mississippi | 28101 | 5996 | 97 |
2341523 | 2341523 | 2022-03-25 | Newton | Mississippi | 28101 | 5996 | 97 |
2338270 | 2338270 | 2022-03-24 | Newton | Mississippi | 28101 | 5996 | 97 |
2335016 | 2335016 | 2022-03-23 | Newton | Mississippi | 28101 | 5996 | 97 |
2331762 | 2331762 | 2022-03-22 | Newton | Mississippi | 28101 | 5996 | 97 |
2328510 | 2328510 | 2022-03-21 | Newton | Mississippi | 28101 | 5996 | 97 |
2325257 | 2325257 | 2022-03-20 | Newton | Mississippi | 28101 | 5996 | 97 |
2322003 | 2322003 | 2022-03-19 | Newton | Mississippi | 28101 | 5996 | 97 |
2318749 | 2318749 | 2022-03-18 | Newton | Mississippi | 28101 | 5996 | 97 |
2315496 | 2315496 | 2022-03-17 | Newton | Mississippi | 28101 | 5996 | 97 |
2312243 | 2312243 | 2022-03-16 | Newton | Mississippi | 28101 | 5996 | 97 |
2308990 | 2308990 | 2022-03-15 | Newton | Mississippi | 28101 | 5996 | 97 |
2305739 | 2305739 | 2022-03-14 | Newton | Mississippi | 28101 | 5996 | 97 |
2302487 | 2302487 | 2022-03-13 | Newton | Mississippi | 28101 | 5989 | 97 |
2299235 | 2299235 | 2022-03-12 | Newton | Mississippi | 28101 | 5989 | 97 |
2295983 | 2295983 | 2022-03-11 | Newton | Mississippi | 28101 | 5989 | 97 |
2292731 | 2292731 | 2022-03-10 | Newton | Mississippi | 28101 | 5989 | 97 |
2289479 | 2289479 | 2022-03-09 | Newton | Mississippi | 28101 | 5989 | 97 |
2286228 | 2286228 | 2022-03-08 | Newton | Mississippi | 28101 | 5989 | 97 |
2282976 | 2282976 | 2022-03-07 | Newton | Mississippi | 28101 | 5986 | 97 |
2279685 | 2279685 | 2022-03-06 | Clay | Mississippi | 28025 | 4934 | 97 |
2276432 | 2276432 | 2022-03-05 | Clay | Mississippi | 28025 | 4934 | 97 |
2273179 | 2273179 | 2022-03-04 | Clay | Mississippi | 28025 | 4934 | 97 |
2269927 | 2269927 | 2022-03-03 | Clay | Mississippi | 28025 | 4933 | 97 |
2188689 | 2188689 | 2022-02-06 | Tippah | Mississippi | 28139 | 6779 | 97 |
2188701 | 2188701 | 2022-02-06 | Yazoo | Mississippi | 28163 | 7800 | 97 |
2185436 | 2185436 | 2022-02-05 | Tippah | Mississippi | 28139 | 6779 | 97 |
2185448 | 2185448 | 2022-02-05 | Yazoo | Mississippi | 28163 | 7800 | 97 |
2182184 | 2182184 | 2022-02-04 | Tippah | Mississippi | 28139 | 6779 | 97 |
2182196 | 2182196 | 2022-02-04 | Yazoo | Mississippi | 28163 | 7800 | 97 |
2178932 | 2178932 | 2022-02-03 | Tippah | Mississippi | 28139 | 6658 | 97 |
2178942 | 2178942 | 2022-02-03 | Winston | Mississippi | 28159 | 4827 | 97 |
2178944 | 2178944 | 2022-02-03 | Yazoo | Mississippi | 28163 | 7727 | 97 |
2175690 | 2175690 | 2022-02-02 | Winston | Mississippi | 28159 | 4795 | 97 |
2175692 | 2175692 | 2022-02-02 | Yazoo | Mississippi | 28163 | 7697 | 97 |
2172369 | 2172369 | 2022-02-01 | Clarke | Mississippi | 28023 | 3898 | 97 |
2172383 | 2172383 | 2022-02-01 | Holmes | Mississippi | 28051 | 4171 | 97 |
2172437 | 2172437 | 2022-02-01 | Winston | Mississippi | 28159 | 4767 | 97 |
2169184 | 2169184 | 2022-01-31 | Winston | Mississippi | 28159 | 4743 | 97 |
2165864 | 2165864 | 2022-01-30 | Copiah | Mississippi | 28029 | 6300 | 97 |
2162609 | 2162609 | 2022-01-29 | Copiah | Mississippi | 28029 | 6300 | 97 |
2159354 | 2159354 | 2022-01-28 | Copiah | Mississippi | 28029 | 6300 | 97 |
2156100 | 2156100 | 2022-01-27 | Copiah | Mississippi | 28029 | 6232 | 97 |
2152847 | 2152847 | 2022-01-26 | Copiah | Mississippi | 28029 | 6201 | 97 |
2149595 | 2149595 | 2022-01-25 | Copiah | Mississippi | 28029 | 6159 | 97 |
2146343 | 2146343 | 2022-01-24 | Copiah | Mississippi | 28029 | 6136 | 97 |
2097556 | 2097556 | 2022-01-09 | Covington | Mississippi | 28031 | 5051 | 97 |
2094304 | 2094304 | 2022-01-08 | Covington | Mississippi | 28031 | 5051 | 97 |
2091052 | 2091052 | 2022-01-07 | Covington | Mississippi | 28031 | 5051 | 97 |
2087801 | 2087801 | 2022-01-06 | Covington | Mississippi | 28031 | 4955 | 97 |
2084549 | 2084549 | 2022-01-05 | Covington | Mississippi | 28031 | 4879 | 97 |
2081297 | 2081297 | 2022-01-04 | Covington | Mississippi | 28031 | 4808 | 97 |
2078045 | 2078045 | 2022-01-03 | Covington | Mississippi | 28031 | 4754 | 97 |
2058597 | 2058597 | 2021-12-28 | Tishomingo | Mississippi | 28141 | 4082 | 97 |
2055348 | 2055348 | 2021-12-27 | Tishomingo | Mississippi | 28141 | 4074 | 97 |
1964339 | 1964339 | 2021-11-29 | Union | Mississippi | 28145 | 6382 | 97 |
1961088 | 1961088 | 2021-11-28 | Union | Mississippi | 28145 | 6338 | 97 |
1957837 | 1957837 | 2021-11-27 | Union | Mississippi | 28145 | 6338 | 97 |
1954586 | 1954586 | 2021-11-26 | Union | Mississippi | 28145 | 6338 | 97 |
1951335 | 1951335 | 2021-11-25 | Union | Mississippi | 28145 | 6338 | 97 |
1948084 | 1948084 | 2021-11-24 | Union | Mississippi | 28145 | 6338 | 97 |
1808345 | 1808345 | 2021-10-12 | Scott | Mississippi | 28123 | 4699 | 97 |
1805034 | 1805034 | 2021-10-11 | Alcorn | Mississippi | 28003 | 5610 | 97 |
1801785 | 1801785 | 2021-10-10 | Alcorn | Mississippi | 28003 | 5595 | 97 |
1798536 | 1798536 | 2021-10-09 | Alcorn | Mississippi | 28003 | 5595 | 97 |
1795287 | 1795287 | 2021-10-08 | Alcorn | Mississippi | 28003 | 5595 | 97 |
1792094 | 1792094 | 2021-10-07 | Pontotoc | Mississippi | 28115 | 6536 | 97 |
1788845 | 1788845 | 2021-10-06 | Pontotoc | Mississippi | 28115 | 6520 | 97 |
1717353 | 1717353 | 2021-09-14 | Marion | Mississippi | 28091 | 3975 | 97 |
1714105 | 1714105 | 2021-09-13 | Marion | Mississippi | 28091 | 3962 | 97 |
1710835 | 1710835 | 2021-09-12 | Grenada | Mississippi | 28043 | 3402 | 97 |
1710859 | 1710859 | 2021-09-12 | Marion | Mississippi | 28091 | 3927 | 97 |
1707588 | 1707588 | 2021-09-11 | Grenada | Mississippi | 28043 | 3402 | 97 |
1707612 | 1707612 | 2021-09-11 | Marion | Mississippi | 28091 | 3927 | 97 |
1704341 | 1704341 | 2021-09-10 | Grenada | Mississippi | 28043 | 3402 | 97 |
1704365 | 1704365 | 2021-09-10 | Marion | Mississippi | 28091 | 3927 | 97 |
1701091 | 1701091 | 2021-09-09 | Grenada | Mississippi | 28043 | 3393 | 97 |
1697842 | 1697842 | 2021-09-08 | Grenada | Mississippi | 28043 | 3374 | 97 |
1665357 | 1665357 | 2021-08-29 | Hancock | Mississippi | 28045 | 6311 | 97 |
1662109 | 1662109 | 2021-08-28 | Hancock | Mississippi | 28045 | 6311 | 97 |
1658861 | 1658861 | 2021-08-27 | Hancock | Mississippi | 28045 | 6311 | 97 |
1645909 | 1645909 | 2021-08-23 | Simpson | Mississippi | 28127 | 3736 | 97 |
1642660 | 1642660 | 2021-08-22 | Simpson | Mississippi | 28127 | 3705 | 97 |
1642663 | 1642663 | 2021-08-22 | Sunflower | Mississippi | 28133 | 3806 | 97 |
1639410 | 1639410 | 2021-08-21 | Simpson | Mississippi | 28127 | 3705 | 97 |
1639413 | 1639413 | 2021-08-21 | Sunflower | Mississippi | 28133 | 3806 | 97 |
1636160 | 1636160 | 2021-08-20 | Simpson | Mississippi | 28127 | 3705 | 97 |
1636163 | 1636163 | 2021-08-20 | Sunflower | Mississippi | 28133 | 3806 | 97 |
1632910 | 1632910 | 2021-08-19 | Simpson | Mississippi | 28127 | 3664 | 97 |
1632913 | 1632913 | 2021-08-19 | Sunflower | Mississippi | 28133 | 3784 | 97 |
1629663 | 1629663 | 2021-08-18 | Simpson | Mississippi | 28127 | 3629 | 97 |
1629666 | 1629666 | 2021-08-18 | Sunflower | Mississippi | 28133 | 3750 | 97 |
1236799 | 1236799 | 2021-04-19 | Oktibbeha | Mississippi | 28105 | 4580 | 97 |
1233552 | 1233552 | 2021-04-18 | Oktibbeha | Mississippi | 28105 | 4580 | 97 |
1230304 | 1230304 | 2021-04-17 | Oktibbeha | Mississippi | 28105 | 4579 | 97 |
1227056 | 1227056 | 2021-04-16 | Oktibbeha | Mississippi | 28105 | 4571 | 97 |
1223808 | 1223808 | 2021-04-15 | Oktibbeha | Mississippi | 28105 | 4570 | 97 |
1220561 | 1220561 | 2021-04-14 | Oktibbeha | Mississippi | 28105 | 4562 | 97 |
1217313 | 1217313 | 2021-04-13 | Oktibbeha | Mississippi | 28105 | 4558 | 97 |
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);