ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where deaths = 93 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 |
---|---|---|---|---|---|---|---|
2260172 | 2260172 | 2022-02-28 | Clay | Mississippi | 28025 | 4932 | 93 |
2256921 | 2256921 | 2022-02-27 | Clay | Mississippi | 28025 | 4929 | 93 |
2253670 | 2253670 | 2022-02-26 | Clay | Mississippi | 28025 | 4929 | 93 |
2250419 | 2250419 | 2022-02-25 | Clay | Mississippi | 28025 | 4929 | 93 |
2247164 | 2247164 | 2022-02-24 | Chickasaw | Mississippi | 28017 | 5541 | 93 |
2243913 | 2243913 | 2022-02-23 | Chickasaw | Mississippi | 28017 | 5523 | 93 |
2224449 | 2224449 | 2022-02-17 | Newton | Mississippi | 28101 | 5898 | 93 |
2221198 | 2221198 | 2022-02-16 | Newton | Mississippi | 28101 | 5890 | 93 |
2169174 | 2169174 | 2022-01-31 | Tippah | Mississippi | 28139 | 6397 | 93 |
2165853 | 2165853 | 2022-01-30 | Attala | Mississippi | 28007 | 4275 | 93 |
2162598 | 2162598 | 2022-01-29 | Attala | Mississippi | 28007 | 4275 | 93 |
2159343 | 2159343 | 2022-01-28 | Attala | Mississippi | 28007 | 4275 | 93 |
2152872 | 2152872 | 2022-01-26 | Leake | Mississippi | 28079 | 5520 | 93 |
2149620 | 2149620 | 2022-01-25 | Leake | Mississippi | 28079 | 5477 | 93 |
2146368 | 2146368 | 2022-01-24 | Leake | Mississippi | 28079 | 5434 | 93 |
2097566 | 2097566 | 2022-01-09 | Holmes | Mississippi | 28051 | 3263 | 93 |
2094314 | 2094314 | 2022-01-08 | Holmes | Mississippi | 28051 | 3263 | 93 |
2091062 | 2091062 | 2022-01-07 | Holmes | Mississippi | 28051 | 3263 | 93 |
2087811 | 2087811 | 2022-01-06 | Holmes | Mississippi | 28051 | 3202 | 93 |
2084559 | 2084559 | 2022-01-05 | Holmes | Mississippi | 28051 | 3137 | 93 |
2081307 | 2081307 | 2022-01-04 | Holmes | Mississippi | 28051 | 3093 | 93 |
2074858 | 2074858 | 2022-01-02 | Winston | Mississippi | 28159 | 3278 | 93 |
2071607 | 2071607 | 2022-01-01 | Winston | Mississippi | 28159 | 3278 | 93 |
2068356 | 2068356 | 2021-12-31 | Winston | Mississippi | 28159 | 3278 | 93 |
2065105 | 2065105 | 2021-12-30 | Winston | Mississippi | 28159 | 3278 | 93 |
2016356 | 2016356 | 2021-12-15 | Yazoo | Mississippi | 28163 | 4635 | 93 |
2013105 | 2013105 | 2021-12-14 | Yazoo | Mississippi | 28163 | 4630 | 93 |
2009854 | 2009854 | 2021-12-13 | Yazoo | Mississippi | 28163 | 4623 | 93 |
2006603 | 2006603 | 2021-12-12 | Yazoo | Mississippi | 28163 | 4609 | 93 |
2003352 | 2003352 | 2021-12-11 | Yazoo | Mississippi | 28163 | 4609 | 93 |
2000102 | 2000102 | 2021-12-10 | Yazoo | Mississippi | 28163 | 4609 | 93 |
1996851 | 1996851 | 2021-12-09 | Yazoo | Mississippi | 28163 | 4607 | 93 |
1964337 | 1964337 | 2021-11-29 | Tishomingo | Mississippi | 28141 | 3835 | 93 |
1961086 | 1961086 | 2021-11-28 | Tishomingo | Mississippi | 28141 | 3817 | 93 |
1957835 | 1957835 | 2021-11-27 | Tishomingo | Mississippi | 28141 | 3817 | 93 |
1954584 | 1954584 | 2021-11-26 | Tishomingo | Mississippi | 28141 | 3817 | 93 |
1951333 | 1951333 | 2021-11-25 | Tishomingo | Mississippi | 28141 | 3817 | 93 |
1948082 | 1948082 | 2021-11-24 | Tishomingo | Mississippi | 28141 | 3817 | 93 |
1944831 | 1944831 | 2021-11-23 | Tishomingo | Mississippi | 28141 | 3800 | 93 |
1941580 | 1941580 | 2021-11-22 | Tishomingo | Mississippi | 28141 | 3794 | 93 |
1938330 | 1938330 | 2021-11-21 | Tishomingo | Mississippi | 28141 | 3744 | 93 |
1935080 | 1935080 | 2021-11-20 | Tishomingo | Mississippi | 28141 | 3744 | 93 |
1931830 | 1931830 | 2021-11-19 | Tishomingo | Mississippi | 28141 | 3744 | 93 |
1928579 | 1928579 | 2021-11-18 | Tishomingo | Mississippi | 28141 | 3732 | 93 |
1925329 | 1925329 | 2021-11-17 | Tishomingo | Mississippi | 28141 | 3724 | 93 |
1922080 | 1922080 | 2021-11-16 | Tishomingo | Mississippi | 28141 | 3722 | 93 |
1918830 | 1918830 | 2021-11-15 | Tishomingo | Mississippi | 28141 | 3718 | 93 |
1915580 | 1915580 | 2021-11-14 | Tishomingo | Mississippi | 28141 | 3710 | 93 |
1912330 | 1912330 | 2021-11-13 | Tishomingo | Mississippi | 28141 | 3710 | 93 |
1909080 | 1909080 | 2021-11-12 | Tishomingo | Mississippi | 28141 | 3710 | 93 |
1905831 | 1905831 | 2021-11-11 | Tishomingo | Mississippi | 28141 | 3706 | 93 |
1902582 | 1902582 | 2021-11-10 | Tishomingo | Mississippi | 28141 | 3706 | 93 |
1899332 | 1899332 | 2021-11-09 | Tishomingo | Mississippi | 28141 | 3705 | 93 |
1896026 | 1896026 | 2021-11-08 | Copiah | Mississippi | 28029 | 4510 | 93 |
1896082 | 1896082 | 2021-11-08 | Tishomingo | Mississippi | 28141 | 3697 | 93 |
1892776 | 1892776 | 2021-11-07 | Copiah | Mississippi | 28029 | 4510 | 93 |
1892832 | 1892832 | 2021-11-07 | Tishomingo | Mississippi | 28141 | 3692 | 93 |
1889526 | 1889526 | 2021-11-06 | Copiah | Mississippi | 28029 | 4510 | 93 |
1889582 | 1889582 | 2021-11-06 | Tishomingo | Mississippi | 28141 | 3692 | 93 |
1886276 | 1886276 | 2021-11-05 | Copiah | Mississippi | 28029 | 4510 | 93 |
1886332 | 1886332 | 2021-11-05 | Tishomingo | Mississippi | 28141 | 3692 | 93 |
1883027 | 1883027 | 2021-11-04 | Copiah | Mississippi | 28029 | 4507 | 93 |
1883083 | 1883083 | 2021-11-04 | Tishomingo | Mississippi | 28141 | 3689 | 93 |
1879778 | 1879778 | 2021-11-03 | Copiah | Mississippi | 28029 | 4506 | 93 |
1879834 | 1879834 | 2021-11-03 | Tishomingo | Mississippi | 28141 | 3686 | 93 |
1876529 | 1876529 | 2021-11-02 | Copiah | Mississippi | 28029 | 4503 | 93 |
1876585 | 1876585 | 2021-11-02 | Tishomingo | Mississippi | 28141 | 3681 | 93 |
1873336 | 1873336 | 2021-11-01 | Tishomingo | Mississippi | 28141 | 3648 | 93 |
1808299 | 1808299 | 2021-10-12 | Covington | Mississippi | 28031 | 4263 | 93 |
1808356 | 1808356 | 2021-10-12 | Union | Mississippi | 28145 | 5931 | 93 |
1805044 | 1805044 | 2021-10-11 | Clarke | Mississippi | 28023 | 2880 | 93 |
1805048 | 1805048 | 2021-10-11 | Covington | Mississippi | 28031 | 4260 | 93 |
1805105 | 1805105 | 2021-10-11 | Union | Mississippi | 28145 | 5910 | 93 |
1801795 | 1801795 | 2021-10-10 | Clarke | Mississippi | 28023 | 2880 | 93 |
1801799 | 1801799 | 2021-10-10 | Covington | Mississippi | 28031 | 4252 | 93 |
1801856 | 1801856 | 2021-10-10 | Union | Mississippi | 28145 | 5899 | 93 |
1798546 | 1798546 | 2021-10-09 | Clarke | Mississippi | 28023 | 2880 | 93 |
1798550 | 1798550 | 2021-10-09 | Covington | Mississippi | 28031 | 4252 | 93 |
1798607 | 1798607 | 2021-10-09 | Union | Mississippi | 28145 | 5899 | 93 |
1795297 | 1795297 | 2021-10-08 | Clarke | Mississippi | 28023 | 2880 | 93 |
1795301 | 1795301 | 2021-10-08 | Covington | Mississippi | 28031 | 4252 | 93 |
1795358 | 1795358 | 2021-10-08 | Union | Mississippi | 28145 | 5899 | 93 |
1792052 | 1792052 | 2021-10-07 | Covington | Mississippi | 28031 | 4248 | 93 |
1792109 | 1792109 | 2021-10-07 | Union | Mississippi | 28145 | 5892 | 93 |
1788803 | 1788803 | 2021-10-06 | Covington | Mississippi | 28031 | 4236 | 93 |
1788860 | 1788860 | 2021-10-06 | Union | Mississippi | 28145 | 5884 | 93 |
1785541 | 1785541 | 2021-10-05 | Alcorn | Mississippi | 28003 | 5541 | 93 |
1785555 | 1785555 | 2021-10-05 | Covington | Mississippi | 28031 | 4233 | 93 |
1785612 | 1785612 | 2021-10-05 | Union | Mississippi | 28145 | 5864 | 93 |
1782306 | 1782306 | 2021-10-04 | Covington | Mississippi | 28031 | 4224 | 93 |
1782363 | 1782363 | 2021-10-04 | Union | Mississippi | 28145 | 5844 | 93 |
1779056 | 1779056 | 2021-10-03 | Covington | Mississippi | 28031 | 4212 | 93 |
1779113 | 1779113 | 2021-10-03 | Union | Mississippi | 28145 | 5821 | 93 |
1775806 | 1775806 | 2021-10-02 | Covington | Mississippi | 28031 | 4212 | 93 |
1775863 | 1775863 | 2021-10-02 | Union | Mississippi | 28145 | 5821 | 93 |
1772556 | 1772556 | 2021-10-01 | Covington | Mississippi | 28031 | 4212 | 93 |
1772613 | 1772613 | 2021-10-01 | Union | Mississippi | 28145 | 5821 | 93 |
1769307 | 1769307 | 2021-09-30 | Covington | Mississippi | 28031 | 4204 | 93 |
1766058 | 1766058 | 2021-09-29 | Covington | Mississippi | 28031 | 4195 | 93 |
1762809 | 1762809 | 2021-09-28 | Covington | Mississippi | 28031 | 4183 | 93 |
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);