ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "DeSoto" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175627 | 2175627 | 2022-02-02 | DeSoto | Mississippi | 28033 | 46974 | 493 |
2172374 | 2172374 | 2022-02-01 | DeSoto | Mississippi | 28033 | 46644 | 488 |
2169121 | 2169121 | 2022-01-31 | DeSoto | Mississippi | 28033 | 46370 | 483 |
2165866 | 2165866 | 2022-01-30 | DeSoto | Mississippi | 28033 | 45754 | 479 |
2162611 | 2162611 | 2022-01-29 | DeSoto | Mississippi | 28033 | 45754 | 479 |
2159356 | 2159356 | 2022-01-28 | DeSoto | Mississippi | 28033 | 45754 | 479 |
2156102 | 2156102 | 2022-01-27 | DeSoto | Mississippi | 28033 | 45511 | 479 |
2152849 | 2152849 | 2022-01-26 | DeSoto | Mississippi | 28033 | 45151 | 479 |
2149597 | 2149597 | 2022-01-25 | DeSoto | Mississippi | 28033 | 44743 | 476 |
2146345 | 2146345 | 2022-01-24 | DeSoto | Mississippi | 28033 | 44573 | 475 |
2143090 | 2143090 | 2022-01-23 | DeSoto | Mississippi | 28033 | 43813 | 474 |
2139835 | 2139835 | 2022-01-22 | DeSoto | Mississippi | 28033 | 43813 | 474 |
2136579 | 2136579 | 2022-01-21 | DeSoto | Mississippi | 28033 | 43813 | 474 |
2133327 | 2133327 | 2022-01-20 | DeSoto | Mississippi | 28033 | 43429 | 473 |
2130074 | 2130074 | 2022-01-19 | DeSoto | Mississippi | 28033 | 42900 | 473 |
2126820 | 2126820 | 2022-01-18 | DeSoto | Mississippi | 28033 | 42397 | 463 |
2123568 | 2123568 | 2022-01-17 | DeSoto | Mississippi | 28033 | 41451 | 463 |
2120316 | 2120316 | 2022-01-16 | DeSoto | Mississippi | 28033 | 41451 | 463 |
2117064 | 2117064 | 2022-01-15 | DeSoto | Mississippi | 28033 | 41451 | 463 |
2113813 | 2113813 | 2022-01-14 | DeSoto | Mississippi | 28033 | 41451 | 463 |
2110561 | 2110561 | 2022-01-13 | DeSoto | Mississippi | 28033 | 40994 | 460 |
2107310 | 2107310 | 2022-01-12 | DeSoto | Mississippi | 28033 | 40580 | 459 |
2104059 | 2104059 | 2022-01-11 | DeSoto | Mississippi | 28033 | 40219 | 451 |
2100808 | 2100808 | 2022-01-10 | DeSoto | Mississippi | 28033 | 39959 | 448 |
2097557 | 2097557 | 2022-01-09 | DeSoto | Mississippi | 28033 | 38899 | 448 |
2094305 | 2094305 | 2022-01-08 | DeSoto | Mississippi | 28033 | 38899 | 448 |
2091053 | 2091053 | 2022-01-07 | DeSoto | Mississippi | 28033 | 38899 | 448 |
2087802 | 2087802 | 2022-01-06 | DeSoto | Mississippi | 28033 | 38524 | 447 |
2084550 | 2084550 | 2022-01-05 | DeSoto | Mississippi | 28033 | 38008 | 446 |
2081298 | 2081298 | 2022-01-04 | DeSoto | Mississippi | 28033 | 37555 | 444 |
2078046 | 2078046 | 2022-01-03 | DeSoto | Mississippi | 28033 | 37222 | 444 |
2074795 | 2074795 | 2022-01-02 | DeSoto | Mississippi | 28033 | 35831 | 444 |
2071544 | 2071544 | 2022-01-01 | DeSoto | Mississippi | 28033 | 35831 | 444 |
2068293 | 2068293 | 2021-12-31 | DeSoto | Mississippi | 28033 | 35831 | 444 |
2065042 | 2065042 | 2021-12-30 | DeSoto | Mississippi | 28033 | 35831 | 444 |
2061792 | 2061792 | 2021-12-29 | DeSoto | Mississippi | 28033 | 35445 | 444 |
2058543 | 2058543 | 2021-12-28 | DeSoto | Mississippi | 28033 | 35201 | 442 |
2055294 | 2055294 | 2021-12-27 | DeSoto | Mississippi | 28033 | 34864 | 440 |
2052044 | 2052044 | 2021-12-26 | DeSoto | Mississippi | 28033 | 34175 | 440 |
2048794 | 2048794 | 2021-12-25 | DeSoto | Mississippi | 28033 | 34175 | 440 |
2045544 | 2045544 | 2021-12-24 | DeSoto | Mississippi | 28033 | 34175 | 440 |
2042294 | 2042294 | 2021-12-23 | DeSoto | Mississippi | 28033 | 34175 | 440 |
2039045 | 2039045 | 2021-12-22 | DeSoto | Mississippi | 28033 | 34175 | 440 |
2035795 | 2035795 | 2021-12-21 | DeSoto | Mississippi | 28033 | 34111 | 440 |
2032545 | 2032545 | 2021-12-20 | DeSoto | Mississippi | 28033 | 34045 | 437 |
2029294 | 2029294 | 2021-12-19 | DeSoto | Mississippi | 28033 | 33920 | 435 |
2026043 | 2026043 | 2021-12-18 | DeSoto | Mississippi | 28033 | 33920 | 435 |
2022792 | 2022792 | 2021-12-17 | DeSoto | Mississippi | 28033 | 33920 | 435 |
2019541 | 2019541 | 2021-12-16 | DeSoto | Mississippi | 28033 | 33870 | 435 |
2016291 | 2016291 | 2021-12-15 | DeSoto | Mississippi | 28033 | 33820 | 435 |
2013040 | 2013040 | 2021-12-14 | DeSoto | Mississippi | 28033 | 33780 | 435 |
2009789 | 2009789 | 2021-12-13 | DeSoto | Mississippi | 28033 | 33749 | 434 |
2006538 | 2006538 | 2021-12-12 | DeSoto | Mississippi | 28033 | 33686 | 434 |
2003287 | 2003287 | 2021-12-11 | DeSoto | Mississippi | 28033 | 33686 | 434 |
2000037 | 2000037 | 2021-12-10 | DeSoto | Mississippi | 28033 | 33686 | 434 |
1996786 | 1996786 | 2021-12-09 | DeSoto | Mississippi | 28033 | 33645 | 432 |
1993535 | 1993535 | 2021-12-08 | DeSoto | Mississippi | 28033 | 33574 | 432 |
1990284 | 1990284 | 2021-12-07 | DeSoto | Mississippi | 28033 | 33512 | 432 |
1987034 | 1987034 | 2021-12-06 | DeSoto | Mississippi | 28033 | 33463 | 432 |
1983784 | 1983784 | 2021-12-05 | DeSoto | Mississippi | 28033 | 33360 | 432 |
1980534 | 1980534 | 2021-12-04 | DeSoto | Mississippi | 28033 | 33360 | 432 |
1977284 | 1977284 | 2021-12-03 | DeSoto | Mississippi | 28033 | 33360 | 432 |
1974034 | 1974034 | 2021-12-02 | DeSoto | Mississippi | 28033 | 33342 | 432 |
1970785 | 1970785 | 2021-12-01 | DeSoto | Mississippi | 28033 | 33304 | 432 |
1967535 | 1967535 | 2021-11-30 | DeSoto | Mississippi | 28033 | 33270 | 432 |
1964283 | 1964283 | 2021-11-29 | DeSoto | Mississippi | 28033 | 33234 | 432 |
1961032 | 1961032 | 2021-11-28 | DeSoto | Mississippi | 28033 | 33162 | 432 |
1957781 | 1957781 | 2021-11-27 | DeSoto | Mississippi | 28033 | 33162 | 432 |
1954530 | 1954530 | 2021-11-26 | DeSoto | Mississippi | 28033 | 33162 | 432 |
1951279 | 1951279 | 2021-11-25 | DeSoto | Mississippi | 28033 | 33162 | 432 |
1948028 | 1948028 | 2021-11-24 | DeSoto | Mississippi | 28033 | 33162 | 432 |
1944777 | 1944777 | 2021-11-23 | DeSoto | Mississippi | 28033 | 33131 | 431 |
1941526 | 1941526 | 2021-11-22 | DeSoto | Mississippi | 28033 | 33122 | 429 |
1938276 | 1938276 | 2021-11-21 | DeSoto | Mississippi | 28033 | 33009 | 425 |
1935026 | 1935026 | 2021-11-20 | DeSoto | Mississippi | 28033 | 33009 | 425 |
1931776 | 1931776 | 2021-11-19 | DeSoto | Mississippi | 28033 | 33009 | 425 |
1928525 | 1928525 | 2021-11-18 | DeSoto | Mississippi | 28033 | 32966 | 425 |
1925275 | 1925275 | 2021-11-17 | DeSoto | Mississippi | 28033 | 32889 | 424 |
1922026 | 1922026 | 2021-11-16 | DeSoto | Mississippi | 28033 | 32875 | 424 |
1918776 | 1918776 | 2021-11-15 | DeSoto | Mississippi | 28033 | 32830 | 422 |
1915526 | 1915526 | 2021-11-14 | DeSoto | Mississippi | 28033 | 32746 | 422 |
1912276 | 1912276 | 2021-11-13 | DeSoto | Mississippi | 28033 | 32746 | 422 |
1909026 | 1909026 | 2021-11-12 | DeSoto | Mississippi | 28033 | 32746 | 422 |
1905777 | 1905777 | 2021-11-11 | DeSoto | Mississippi | 28033 | 32678 | 422 |
1902528 | 1902528 | 2021-11-10 | DeSoto | Mississippi | 28033 | 32678 | 422 |
1899278 | 1899278 | 2021-11-09 | DeSoto | Mississippi | 28033 | 32652 | 422 |
1896028 | 1896028 | 2021-11-08 | DeSoto | Mississippi | 28033 | 32625 | 420 |
1892778 | 1892778 | 2021-11-07 | DeSoto | Mississippi | 28033 | 32567 | 420 |
1889528 | 1889528 | 2021-11-06 | DeSoto | Mississippi | 28033 | 32567 | 420 |
1886278 | 1886278 | 2021-11-05 | DeSoto | Mississippi | 28033 | 32567 | 420 |
1883029 | 1883029 | 2021-11-04 | DeSoto | Mississippi | 28033 | 32523 | 420 |
1879780 | 1879780 | 2021-11-03 | DeSoto | Mississippi | 28033 | 32488 | 420 |
1876531 | 1876531 | 2021-11-02 | DeSoto | Mississippi | 28033 | 32462 | 420 |
1873282 | 1873282 | 2021-11-01 | DeSoto | Mississippi | 28033 | 32432 | 412 |
1870033 | 1870033 | 2021-10-31 | DeSoto | Mississippi | 28033 | 32394 | 412 |
1866784 | 1866784 | 2021-10-30 | DeSoto | Mississippi | 28033 | 32394 | 412 |
1863535 | 1863535 | 2021-10-29 | DeSoto | Mississippi | 28033 | 32394 | 412 |
1860286 | 1860286 | 2021-10-28 | DeSoto | Mississippi | 28033 | 32375 | 412 |
1857037 | 1857037 | 2021-10-27 | DeSoto | Mississippi | 28033 | 32343 | 411 |
1853788 | 1853788 | 2021-10-26 | DeSoto | Mississippi | 28033 | 32318 | 411 |
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);