ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Lauderdale" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175648 | 2175648 | 2022-02-02 | Lauderdale | Mississippi | 28075 | 17595 | 332 |
2172395 | 2172395 | 2022-02-01 | Lauderdale | Mississippi | 28075 | 17483 | 330 |
2169142 | 2169142 | 2022-01-31 | Lauderdale | Mississippi | 28075 | 17376 | 328 |
2165887 | 2165887 | 2022-01-30 | Lauderdale | Mississippi | 28075 | 17175 | 326 |
2162632 | 2162632 | 2022-01-29 | Lauderdale | Mississippi | 28075 | 17175 | 326 |
2159377 | 2159377 | 2022-01-28 | Lauderdale | Mississippi | 28075 | 17175 | 326 |
2156123 | 2156123 | 2022-01-27 | Lauderdale | Mississippi | 28075 | 16985 | 326 |
2152870 | 2152870 | 2022-01-26 | Lauderdale | Mississippi | 28075 | 16799 | 326 |
2149618 | 2149618 | 2022-01-25 | Lauderdale | Mississippi | 28075 | 16599 | 326 |
2146366 | 2146366 | 2022-01-24 | Lauderdale | Mississippi | 28075 | 16460 | 326 |
2143111 | 2143111 | 2022-01-23 | Lauderdale | Mississippi | 28075 | 16196 | 326 |
2139856 | 2139856 | 2022-01-22 | Lauderdale | Mississippi | 28075 | 16196 | 326 |
2136600 | 2136600 | 2022-01-21 | Lauderdale | Mississippi | 28075 | 16196 | 326 |
2133348 | 2133348 | 2022-01-20 | Lauderdale | Mississippi | 28075 | 15980 | 326 |
2130095 | 2130095 | 2022-01-19 | Lauderdale | Mississippi | 28075 | 15732 | 326 |
2126841 | 2126841 | 2022-01-18 | Lauderdale | Mississippi | 28075 | 15455 | 325 |
2123589 | 2123589 | 2022-01-17 | Lauderdale | Mississippi | 28075 | 14909 | 325 |
2120337 | 2120337 | 2022-01-16 | Lauderdale | Mississippi | 28075 | 14909 | 325 |
2117085 | 2117085 | 2022-01-15 | Lauderdale | Mississippi | 28075 | 14909 | 325 |
2113834 | 2113834 | 2022-01-14 | Lauderdale | Mississippi | 28075 | 14909 | 325 |
2110582 | 2110582 | 2022-01-13 | Lauderdale | Mississippi | 28075 | 14687 | 324 |
2107331 | 2107331 | 2022-01-12 | Lauderdale | Mississippi | 28075 | 14493 | 324 |
2104080 | 2104080 | 2022-01-11 | Lauderdale | Mississippi | 28075 | 14212 | 324 |
2100829 | 2100829 | 2022-01-10 | Lauderdale | Mississippi | 28075 | 14032 | 324 |
2097578 | 2097578 | 2022-01-09 | Lauderdale | Mississippi | 28075 | 13605 | 324 |
2094326 | 2094326 | 2022-01-08 | Lauderdale | Mississippi | 28075 | 13605 | 324 |
2091074 | 2091074 | 2022-01-07 | Lauderdale | Mississippi | 28075 | 13605 | 324 |
2087823 | 2087823 | 2022-01-06 | Lauderdale | Mississippi | 28075 | 13469 | 324 |
2084571 | 2084571 | 2022-01-05 | Lauderdale | Mississippi | 28075 | 13306 | 324 |
2081319 | 2081319 | 2022-01-04 | Lauderdale | Mississippi | 28075 | 13130 | 324 |
2078067 | 2078067 | 2022-01-03 | Lauderdale | Mississippi | 28075 | 13026 | 323 |
2074816 | 2074816 | 2022-01-02 | Lauderdale | Mississippi | 28075 | 12795 | 323 |
2071565 | 2071565 | 2022-01-01 | Lauderdale | Mississippi | 28075 | 12795 | 323 |
2068314 | 2068314 | 2021-12-31 | Lauderdale | Mississippi | 28075 | 12795 | 323 |
2065063 | 2065063 | 2021-12-30 | Lauderdale | Mississippi | 28075 | 12795 | 323 |
2061813 | 2061813 | 2021-12-29 | Lauderdale | Mississippi | 28075 | 12701 | 323 |
2058564 | 2058564 | 2021-12-28 | Lauderdale | Mississippi | 28075 | 12642 | 323 |
2055315 | 2055315 | 2021-12-27 | Lauderdale | Mississippi | 28075 | 12594 | 323 |
2052065 | 2052065 | 2021-12-26 | Lauderdale | Mississippi | 28075 | 12473 | 323 |
2048815 | 2048815 | 2021-12-25 | Lauderdale | Mississippi | 28075 | 12473 | 323 |
2045565 | 2045565 | 2021-12-24 | Lauderdale | Mississippi | 28075 | 12473 | 323 |
2042315 | 2042315 | 2021-12-23 | Lauderdale | Mississippi | 28075 | 12473 | 323 |
2039066 | 2039066 | 2021-12-22 | Lauderdale | Mississippi | 28075 | 12473 | 323 |
2035816 | 2035816 | 2021-12-21 | Lauderdale | Mississippi | 28075 | 12462 | 323 |
2032566 | 2032566 | 2021-12-20 | Lauderdale | Mississippi | 28075 | 12443 | 323 |
2029315 | 2029315 | 2021-12-19 | Lauderdale | Mississippi | 28075 | 12430 | 323 |
2026064 | 2026064 | 2021-12-18 | Lauderdale | Mississippi | 28075 | 12430 | 323 |
2022813 | 2022813 | 2021-12-17 | Lauderdale | Mississippi | 28075 | 12430 | 323 |
2019562 | 2019562 | 2021-12-16 | Lauderdale | Mississippi | 28075 | 12419 | 323 |
2016312 | 2016312 | 2021-12-15 | Lauderdale | Mississippi | 28075 | 12411 | 323 |
2013061 | 2013061 | 2021-12-14 | Lauderdale | Mississippi | 28075 | 12408 | 323 |
2009810 | 2009810 | 2021-12-13 | Lauderdale | Mississippi | 28075 | 12400 | 323 |
2006559 | 2006559 | 2021-12-12 | Lauderdale | Mississippi | 28075 | 12396 | 323 |
2003308 | 2003308 | 2021-12-11 | Lauderdale | Mississippi | 28075 | 12396 | 323 |
2000058 | 2000058 | 2021-12-10 | Lauderdale | Mississippi | 28075 | 12396 | 323 |
1996807 | 1996807 | 2021-12-09 | Lauderdale | Mississippi | 28075 | 12390 | 323 |
1993556 | 1993556 | 2021-12-08 | Lauderdale | Mississippi | 28075 | 12371 | 323 |
1990305 | 1990305 | 2021-12-07 | Lauderdale | Mississippi | 28075 | 12343 | 323 |
1987055 | 1987055 | 2021-12-06 | Lauderdale | Mississippi | 28075 | 12326 | 323 |
1983805 | 1983805 | 2021-12-05 | Lauderdale | Mississippi | 28075 | 12311 | 323 |
1980555 | 1980555 | 2021-12-04 | Lauderdale | Mississippi | 28075 | 12311 | 323 |
1977305 | 1977305 | 2021-12-03 | Lauderdale | Mississippi | 28075 | 12311 | 323 |
1974055 | 1974055 | 2021-12-02 | Lauderdale | Mississippi | 28075 | 12305 | 324 |
1970806 | 1970806 | 2021-12-01 | Lauderdale | Mississippi | 28075 | 12281 | 324 |
1967556 | 1967556 | 2021-11-30 | Lauderdale | Mississippi | 28075 | 12279 | 324 |
1964304 | 1964304 | 2021-11-29 | Lauderdale | Mississippi | 28075 | 12270 | 324 |
1961053 | 1961053 | 2021-11-28 | Lauderdale | Mississippi | 28075 | 12249 | 324 |
1957802 | 1957802 | 2021-11-27 | Lauderdale | Mississippi | 28075 | 12249 | 324 |
1954551 | 1954551 | 2021-11-26 | Lauderdale | Mississippi | 28075 | 12249 | 324 |
1951300 | 1951300 | 2021-11-25 | Lauderdale | Mississippi | 28075 | 12249 | 324 |
1948049 | 1948049 | 2021-11-24 | Lauderdale | Mississippi | 28075 | 12249 | 324 |
1944798 | 1944798 | 2021-11-23 | Lauderdale | Mississippi | 28075 | 12234 | 324 |
1941547 | 1941547 | 2021-11-22 | Lauderdale | Mississippi | 28075 | 12229 | 324 |
1938297 | 1938297 | 2021-11-21 | Lauderdale | Mississippi | 28075 | 12199 | 324 |
1935047 | 1935047 | 2021-11-20 | Lauderdale | Mississippi | 28075 | 12199 | 324 |
1931797 | 1931797 | 2021-11-19 | Lauderdale | Mississippi | 28075 | 12199 | 324 |
1928546 | 1928546 | 2021-11-18 | Lauderdale | Mississippi | 28075 | 12188 | 324 |
1925296 | 1925296 | 2021-11-17 | Lauderdale | Mississippi | 28075 | 12174 | 324 |
1922047 | 1922047 | 2021-11-16 | Lauderdale | Mississippi | 28075 | 12168 | 324 |
1918797 | 1918797 | 2021-11-15 | Lauderdale | Mississippi | 28075 | 12155 | 324 |
1915547 | 1915547 | 2021-11-14 | Lauderdale | Mississippi | 28075 | 12129 | 323 |
1912297 | 1912297 | 2021-11-13 | Lauderdale | Mississippi | 28075 | 12129 | 323 |
1909047 | 1909047 | 2021-11-12 | Lauderdale | Mississippi | 28075 | 12129 | 323 |
1905798 | 1905798 | 2021-11-11 | Lauderdale | Mississippi | 28075 | 12123 | 323 |
1902549 | 1902549 | 2021-11-10 | Lauderdale | Mississippi | 28075 | 12123 | 323 |
1899299 | 1899299 | 2021-11-09 | Lauderdale | Mississippi | 28075 | 12121 | 323 |
1896049 | 1896049 | 2021-11-08 | Lauderdale | Mississippi | 28075 | 12107 | 323 |
1892799 | 1892799 | 2021-11-07 | Lauderdale | Mississippi | 28075 | 12096 | 323 |
1889549 | 1889549 | 2021-11-06 | Lauderdale | Mississippi | 28075 | 12096 | 323 |
1886299 | 1886299 | 2021-11-05 | Lauderdale | Mississippi | 28075 | 12096 | 323 |
1883050 | 1883050 | 2021-11-04 | Lauderdale | Mississippi | 28075 | 12085 | 323 |
1879801 | 1879801 | 2021-11-03 | Lauderdale | Mississippi | 28075 | 12072 | 323 |
1876552 | 1876552 | 2021-11-02 | Lauderdale | Mississippi | 28075 | 12064 | 323 |
1873303 | 1873303 | 2021-11-01 | Lauderdale | Mississippi | 28075 | 12056 | 321 |
1870054 | 1870054 | 2021-10-31 | Lauderdale | Mississippi | 28075 | 12048 | 318 |
1866805 | 1866805 | 2021-10-30 | Lauderdale | Mississippi | 28075 | 12048 | 318 |
1863556 | 1863556 | 2021-10-29 | Lauderdale | Mississippi | 28075 | 12048 | 318 |
1860307 | 1860307 | 2021-10-28 | Lauderdale | Mississippi | 28075 | 12040 | 318 |
1857058 | 1857058 | 2021-10-27 | Lauderdale | Mississippi | 28075 | 12038 | 318 |
1853809 | 1853809 | 2021-10-26 | Lauderdale | Mississippi | 28075 | 12037 | 318 |
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);