ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28071 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175646 | 2175646 | 2022-02-02 | Lafayette | Mississippi | 28071 | 13939 | 166 |
2172393 | 2172393 | 2022-02-01 | Lafayette | Mississippi | 28071 | 13765 | 164 |
2169140 | 2169140 | 2022-01-31 | Lafayette | Mississippi | 28071 | 13682 | 162 |
2165885 | 2165885 | 2022-01-30 | Lafayette | Mississippi | 28071 | 13518 | 160 |
2162630 | 2162630 | 2022-01-29 | Lafayette | Mississippi | 28071 | 13518 | 160 |
2159375 | 2159375 | 2022-01-28 | Lafayette | Mississippi | 28071 | 13518 | 160 |
2156121 | 2156121 | 2022-01-27 | Lafayette | Mississippi | 28071 | 13412 | 159 |
2152868 | 2152868 | 2022-01-26 | Lafayette | Mississippi | 28071 | 13265 | 158 |
2149616 | 2149616 | 2022-01-25 | Lafayette | Mississippi | 28071 | 13119 | 158 |
2146364 | 2146364 | 2022-01-24 | Lafayette | Mississippi | 28071 | 12868 | 157 |
2143109 | 2143109 | 2022-01-23 | Lafayette | Mississippi | 28071 | 12519 | 156 |
2139854 | 2139854 | 2022-01-22 | Lafayette | Mississippi | 28071 | 12519 | 156 |
2136598 | 2136598 | 2022-01-21 | Lafayette | Mississippi | 28071 | 12519 | 156 |
2133346 | 2133346 | 2022-01-20 | Lafayette | Mississippi | 28071 | 12413 | 155 |
2130093 | 2130093 | 2022-01-19 | Lafayette | Mississippi | 28071 | 12172 | 152 |
2126839 | 2126839 | 2022-01-18 | Lafayette | Mississippi | 28071 | 11980 | 149 |
2123587 | 2123587 | 2022-01-17 | Lafayette | Mississippi | 28071 | 11520 | 149 |
2120335 | 2120335 | 2022-01-16 | Lafayette | Mississippi | 28071 | 11520 | 149 |
2117083 | 2117083 | 2022-01-15 | Lafayette | Mississippi | 28071 | 11520 | 149 |
2113832 | 2113832 | 2022-01-14 | Lafayette | Mississippi | 28071 | 11520 | 149 |
2110580 | 2110580 | 2022-01-13 | Lafayette | Mississippi | 28071 | 11309 | 149 |
2107329 | 2107329 | 2022-01-12 | Lafayette | Mississippi | 28071 | 11124 | 148 |
2104078 | 2104078 | 2022-01-11 | Lafayette | Mississippi | 28071 | 10888 | 146 |
2100827 | 2100827 | 2022-01-10 | Lafayette | Mississippi | 28071 | 10799 | 145 |
2097576 | 2097576 | 2022-01-09 | Lafayette | Mississippi | 28071 | 10486 | 144 |
2094324 | 2094324 | 2022-01-08 | Lafayette | Mississippi | 28071 | 10486 | 144 |
2091072 | 2091072 | 2022-01-07 | Lafayette | Mississippi | 28071 | 10486 | 144 |
2087821 | 2087821 | 2022-01-06 | Lafayette | Mississippi | 28071 | 10369 | 143 |
2084569 | 2084569 | 2022-01-05 | Lafayette | Mississippi | 28071 | 10183 | 143 |
2081317 | 2081317 | 2022-01-04 | Lafayette | Mississippi | 28071 | 10028 | 143 |
2078065 | 2078065 | 2022-01-03 | Lafayette | Mississippi | 28071 | 9873 | 143 |
2074814 | 2074814 | 2022-01-02 | Lafayette | Mississippi | 28071 | 9524 | 143 |
2071563 | 2071563 | 2022-01-01 | Lafayette | Mississippi | 28071 | 9524 | 143 |
2068312 | 2068312 | 2021-12-31 | Lafayette | Mississippi | 28071 | 9524 | 143 |
2065061 | 2065061 | 2021-12-30 | Lafayette | Mississippi | 28071 | 9524 | 143 |
2061811 | 2061811 | 2021-12-29 | Lafayette | Mississippi | 28071 | 9396 | 143 |
2058562 | 2058562 | 2021-12-28 | Lafayette | Mississippi | 28071 | 9316 | 143 |
2055313 | 2055313 | 2021-12-27 | Lafayette | Mississippi | 28071 | 9211 | 143 |
2052063 | 2052063 | 2021-12-26 | Lafayette | Mississippi | 28071 | 9059 | 143 |
2048813 | 2048813 | 2021-12-25 | Lafayette | Mississippi | 28071 | 9059 | 143 |
2045563 | 2045563 | 2021-12-24 | Lafayette | Mississippi | 28071 | 9059 | 143 |
2042313 | 2042313 | 2021-12-23 | Lafayette | Mississippi | 28071 | 9059 | 143 |
2039064 | 2039064 | 2021-12-22 | Lafayette | Mississippi | 28071 | 9059 | 143 |
2035814 | 2035814 | 2021-12-21 | Lafayette | Mississippi | 28071 | 9040 | 143 |
2032564 | 2032564 | 2021-12-20 | Lafayette | Mississippi | 28071 | 9019 | 143 |
2029313 | 2029313 | 2021-12-19 | Lafayette | Mississippi | 28071 | 8999 | 143 |
2026062 | 2026062 | 2021-12-18 | Lafayette | Mississippi | 28071 | 8999 | 143 |
2022811 | 2022811 | 2021-12-17 | Lafayette | Mississippi | 28071 | 8999 | 143 |
2019560 | 2019560 | 2021-12-16 | Lafayette | Mississippi | 28071 | 8981 | 143 |
2016310 | 2016310 | 2021-12-15 | Lafayette | Mississippi | 28071 | 8973 | 143 |
2013059 | 2013059 | 2021-12-14 | Lafayette | Mississippi | 28071 | 8952 | 143 |
2009808 | 2009808 | 2021-12-13 | Lafayette | Mississippi | 28071 | 8943 | 143 |
2006557 | 2006557 | 2021-12-12 | Lafayette | Mississippi | 28071 | 8932 | 143 |
2003306 | 2003306 | 2021-12-11 | Lafayette | Mississippi | 28071 | 8932 | 143 |
2000056 | 2000056 | 2021-12-10 | Lafayette | Mississippi | 28071 | 8932 | 143 |
1996805 | 1996805 | 2021-12-09 | Lafayette | Mississippi | 28071 | 8921 | 143 |
1993554 | 1993554 | 2021-12-08 | Lafayette | Mississippi | 28071 | 8912 | 143 |
1990303 | 1990303 | 2021-12-07 | Lafayette | Mississippi | 28071 | 8898 | 143 |
1987053 | 1987053 | 2021-12-06 | Lafayette | Mississippi | 28071 | 8881 | 143 |
1983803 | 1983803 | 2021-12-05 | Lafayette | Mississippi | 28071 | 8868 | 143 |
1980553 | 1980553 | 2021-12-04 | Lafayette | Mississippi | 28071 | 8868 | 143 |
1977303 | 1977303 | 2021-12-03 | Lafayette | Mississippi | 28071 | 8868 | 143 |
1974053 | 1974053 | 2021-12-02 | Lafayette | Mississippi | 28071 | 8867 | 143 |
1970804 | 1970804 | 2021-12-01 | Lafayette | Mississippi | 28071 | 8865 | 143 |
1967554 | 1967554 | 2021-11-30 | Lafayette | Mississippi | 28071 | 8855 | 143 |
1964302 | 1964302 | 2021-11-29 | Lafayette | Mississippi | 28071 | 8846 | 143 |
1961051 | 1961051 | 2021-11-28 | Lafayette | Mississippi | 28071 | 8827 | 143 |
1957800 | 1957800 | 2021-11-27 | Lafayette | Mississippi | 28071 | 8827 | 143 |
1954549 | 1954549 | 2021-11-26 | Lafayette | Mississippi | 28071 | 8827 | 143 |
1951298 | 1951298 | 2021-11-25 | Lafayette | Mississippi | 28071 | 8827 | 143 |
1948047 | 1948047 | 2021-11-24 | Lafayette | Mississippi | 28071 | 8827 | 143 |
1944796 | 1944796 | 2021-11-23 | Lafayette | Mississippi | 28071 | 8813 | 143 |
1941545 | 1941545 | 2021-11-22 | Lafayette | Mississippi | 28071 | 8808 | 143 |
1938295 | 1938295 | 2021-11-21 | Lafayette | Mississippi | 28071 | 8762 | 142 |
1935045 | 1935045 | 2021-11-20 | Lafayette | Mississippi | 28071 | 8762 | 142 |
1931795 | 1931795 | 2021-11-19 | Lafayette | Mississippi | 28071 | 8762 | 142 |
1928544 | 1928544 | 2021-11-18 | Lafayette | Mississippi | 28071 | 8756 | 142 |
1925294 | 1925294 | 2021-11-17 | Lafayette | Mississippi | 28071 | 8751 | 141 |
1922045 | 1922045 | 2021-11-16 | Lafayette | Mississippi | 28071 | 8751 | 141 |
1918795 | 1918795 | 2021-11-15 | Lafayette | Mississippi | 28071 | 8737 | 141 |
1915545 | 1915545 | 2021-11-14 | Lafayette | Mississippi | 28071 | 8715 | 141 |
1912295 | 1912295 | 2021-11-13 | Lafayette | Mississippi | 28071 | 8715 | 141 |
1909045 | 1909045 | 2021-11-12 | Lafayette | Mississippi | 28071 | 8715 | 141 |
1905796 | 1905796 | 2021-11-11 | Lafayette | Mississippi | 28071 | 8704 | 141 |
1902547 | 1902547 | 2021-11-10 | Lafayette | Mississippi | 28071 | 8704 | 141 |
1899297 | 1899297 | 2021-11-09 | Lafayette | Mississippi | 28071 | 8703 | 141 |
1896047 | 1896047 | 2021-11-08 | Lafayette | Mississippi | 28071 | 8701 | 141 |
1892797 | 1892797 | 2021-11-07 | Lafayette | Mississippi | 28071 | 8683 | 141 |
1889547 | 1889547 | 2021-11-06 | Lafayette | Mississippi | 28071 | 8683 | 141 |
1886297 | 1886297 | 2021-11-05 | Lafayette | Mississippi | 28071 | 8683 | 141 |
1883048 | 1883048 | 2021-11-04 | Lafayette | Mississippi | 28071 | 8644 | 140 |
1879799 | 1879799 | 2021-11-03 | Lafayette | Mississippi | 28071 | 8634 | 140 |
1876550 | 1876550 | 2021-11-02 | Lafayette | Mississippi | 28071 | 8627 | 140 |
1873301 | 1873301 | 2021-11-01 | Lafayette | Mississippi | 28071 | 8611 | 140 |
1870052 | 1870052 | 2021-10-31 | Lafayette | Mississippi | 28071 | 8598 | 140 |
1866803 | 1866803 | 2021-10-30 | Lafayette | Mississippi | 28071 | 8598 | 140 |
1863554 | 1863554 | 2021-10-29 | Lafayette | Mississippi | 28071 | 8598 | 140 |
1860305 | 1860305 | 2021-10-28 | Lafayette | Mississippi | 28071 | 8592 | 140 |
1857056 | 1857056 | 2021-10-27 | Lafayette | Mississippi | 28071 | 8588 | 140 |
1853807 | 1853807 | 2021-10-26 | Lafayette | Mississippi | 28071 | 8581 | 140 |
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);