ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28081 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175651 | 2175651 | 2022-02-02 | Lee | Mississippi | 28081 | 25025 | 271 |
2172398 | 2172398 | 2022-02-01 | Lee | Mississippi | 28081 | 24877 | 265 |
2169145 | 2169145 | 2022-01-31 | Lee | Mississippi | 28081 | 24755 | 265 |
2165890 | 2165890 | 2022-01-30 | Lee | Mississippi | 28081 | 24532 | 259 |
2162635 | 2162635 | 2022-01-29 | Lee | Mississippi | 28081 | 24532 | 259 |
2159380 | 2159380 | 2022-01-28 | Lee | Mississippi | 28081 | 24532 | 259 |
2156126 | 2156126 | 2022-01-27 | Lee | Mississippi | 28081 | 24344 | 258 |
2152873 | 2152873 | 2022-01-26 | Lee | Mississippi | 28081 | 24140 | 257 |
2149621 | 2149621 | 2022-01-25 | Lee | Mississippi | 28081 | 23908 | 255 |
2146369 | 2146369 | 2022-01-24 | Lee | Mississippi | 28081 | 23675 | 255 |
2143114 | 2143114 | 2022-01-23 | Lee | Mississippi | 28081 | 23198 | 255 |
2139859 | 2139859 | 2022-01-22 | Lee | Mississippi | 28081 | 23198 | 255 |
2136603 | 2136603 | 2022-01-21 | Lee | Mississippi | 28081 | 23198 | 255 |
2133351 | 2133351 | 2022-01-20 | Lee | Mississippi | 28081 | 22969 | 255 |
2130098 | 2130098 | 2022-01-19 | Lee | Mississippi | 28081 | 22721 | 255 |
2126844 | 2126844 | 2022-01-18 | Lee | Mississippi | 28081 | 22323 | 255 |
2123592 | 2123592 | 2022-01-17 | Lee | Mississippi | 28081 | 21493 | 255 |
2120340 | 2120340 | 2022-01-16 | Lee | Mississippi | 28081 | 21493 | 255 |
2117088 | 2117088 | 2022-01-15 | Lee | Mississippi | 28081 | 21493 | 255 |
2113837 | 2113837 | 2022-01-14 | Lee | Mississippi | 28081 | 21493 | 255 |
2110585 | 2110585 | 2022-01-13 | Lee | Mississippi | 28081 | 21058 | 253 |
2107334 | 2107334 | 2022-01-12 | Lee | Mississippi | 28081 | 20688 | 253 |
2104083 | 2104083 | 2022-01-11 | Lee | Mississippi | 28081 | 20345 | 253 |
2100832 | 2100832 | 2022-01-10 | Lee | Mississippi | 28081 | 20044 | 253 |
2097581 | 2097581 | 2022-01-09 | Lee | Mississippi | 28081 | 19504 | 252 |
2094329 | 2094329 | 2022-01-08 | Lee | Mississippi | 28081 | 19504 | 252 |
2091077 | 2091077 | 2022-01-07 | Lee | Mississippi | 28081 | 19504 | 252 |
2087826 | 2087826 | 2022-01-06 | Lee | Mississippi | 28081 | 19251 | 249 |
2084574 | 2084574 | 2022-01-05 | Lee | Mississippi | 28081 | 18945 | 249 |
2081322 | 2081322 | 2022-01-04 | Lee | Mississippi | 28081 | 18696 | 249 |
2078070 | 2078070 | 2022-01-03 | Lee | Mississippi | 28081 | 18478 | 248 |
2074819 | 2074819 | 2022-01-02 | Lee | Mississippi | 28081 | 17850 | 248 |
2071568 | 2071568 | 2022-01-01 | Lee | Mississippi | 28081 | 17850 | 248 |
2068317 | 2068317 | 2021-12-31 | Lee | Mississippi | 28081 | 17850 | 248 |
2065066 | 2065066 | 2021-12-30 | Lee | Mississippi | 28081 | 17850 | 248 |
2061816 | 2061816 | 2021-12-29 | Lee | Mississippi | 28081 | 17660 | 248 |
2058567 | 2058567 | 2021-12-28 | Lee | Mississippi | 28081 | 17506 | 248 |
2055318 | 2055318 | 2021-12-27 | Lee | Mississippi | 28081 | 17366 | 248 |
2052068 | 2052068 | 2021-12-26 | Lee | Mississippi | 28081 | 17067 | 248 |
2048818 | 2048818 | 2021-12-25 | Lee | Mississippi | 28081 | 17067 | 248 |
2045568 | 2045568 | 2021-12-24 | Lee | Mississippi | 28081 | 17067 | 248 |
2042318 | 2042318 | 2021-12-23 | Lee | Mississippi | 28081 | 17067 | 248 |
2039069 | 2039069 | 2021-12-22 | Lee | Mississippi | 28081 | 17067 | 248 |
2035819 | 2035819 | 2021-12-21 | Lee | Mississippi | 28081 | 17031 | 248 |
2032569 | 2032569 | 2021-12-20 | Lee | Mississippi | 28081 | 16991 | 247 |
2029318 | 2029318 | 2021-12-19 | Lee | Mississippi | 28081 | 16905 | 247 |
2026067 | 2026067 | 2021-12-18 | Lee | Mississippi | 28081 | 16905 | 247 |
2022816 | 2022816 | 2021-12-17 | Lee | Mississippi | 28081 | 16905 | 247 |
2019565 | 2019565 | 2021-12-16 | Lee | Mississippi | 28081 | 16864 | 247 |
2016315 | 2016315 | 2021-12-15 | Lee | Mississippi | 28081 | 16815 | 246 |
2013064 | 2013064 | 2021-12-14 | Lee | Mississippi | 28081 | 16778 | 246 |
2009813 | 2009813 | 2021-12-13 | Lee | Mississippi | 28081 | 16754 | 245 |
2006562 | 2006562 | 2021-12-12 | Lee | Mississippi | 28081 | 16698 | 245 |
2003311 | 2003311 | 2021-12-11 | Lee | Mississippi | 28081 | 16698 | 245 |
2000061 | 2000061 | 2021-12-10 | Lee | Mississippi | 28081 | 16698 | 245 |
1996810 | 1996810 | 2021-12-09 | Lee | Mississippi | 28081 | 16665 | 245 |
1993559 | 1993559 | 2021-12-08 | Lee | Mississippi | 28081 | 16631 | 245 |
1990308 | 1990308 | 2021-12-07 | Lee | Mississippi | 28081 | 16564 | 245 |
1987058 | 1987058 | 2021-12-06 | Lee | Mississippi | 28081 | 16523 | 245 |
1983808 | 1983808 | 2021-12-05 | Lee | Mississippi | 28081 | 16455 | 245 |
1980558 | 1980558 | 2021-12-04 | Lee | Mississippi | 28081 | 16455 | 245 |
1977308 | 1977308 | 2021-12-03 | Lee | Mississippi | 28081 | 16455 | 245 |
1974058 | 1974058 | 2021-12-02 | Lee | Mississippi | 28081 | 16439 | 245 |
1970809 | 1970809 | 2021-12-01 | Lee | Mississippi | 28081 | 16410 | 245 |
1967559 | 1967559 | 2021-11-30 | Lee | Mississippi | 28081 | 16366 | 245 |
1964307 | 1964307 | 2021-11-29 | Lee | Mississippi | 28081 | 16337 | 242 |
1961056 | 1961056 | 2021-11-28 | Lee | Mississippi | 28081 | 16238 | 242 |
1957805 | 1957805 | 2021-11-27 | Lee | Mississippi | 28081 | 16238 | 242 |
1954554 | 1954554 | 2021-11-26 | Lee | Mississippi | 28081 | 16238 | 242 |
1951303 | 1951303 | 2021-11-25 | Lee | Mississippi | 28081 | 16238 | 242 |
1948052 | 1948052 | 2021-11-24 | Lee | Mississippi | 28081 | 16238 | 242 |
1944801 | 1944801 | 2021-11-23 | Lee | Mississippi | 28081 | 16208 | 242 |
1941550 | 1941550 | 2021-11-22 | Lee | Mississippi | 28081 | 16187 | 240 |
1938300 | 1938300 | 2021-11-21 | Lee | Mississippi | 28081 | 16125 | 240 |
1935050 | 1935050 | 2021-11-20 | Lee | Mississippi | 28081 | 16125 | 240 |
1931800 | 1931800 | 2021-11-19 | Lee | Mississippi | 28081 | 16125 | 240 |
1928549 | 1928549 | 2021-11-18 | Lee | Mississippi | 28081 | 16101 | 240 |
1925299 | 1925299 | 2021-11-17 | Lee | Mississippi | 28081 | 16074 | 240 |
1922050 | 1922050 | 2021-11-16 | Lee | Mississippi | 28081 | 16051 | 240 |
1918800 | 1918800 | 2021-11-15 | Lee | Mississippi | 28081 | 16012 | 239 |
1915550 | 1915550 | 2021-11-14 | Lee | Mississippi | 28081 | 15960 | 238 |
1912300 | 1912300 | 2021-11-13 | Lee | Mississippi | 28081 | 15960 | 238 |
1909050 | 1909050 | 2021-11-12 | Lee | Mississippi | 28081 | 15960 | 238 |
1905801 | 1905801 | 2021-11-11 | Lee | Mississippi | 28081 | 15910 | 238 |
1902552 | 1902552 | 2021-11-10 | Lee | Mississippi | 28081 | 15910 | 238 |
1899302 | 1899302 | 2021-11-09 | Lee | Mississippi | 28081 | 15877 | 238 |
1896052 | 1896052 | 2021-11-08 | Lee | Mississippi | 28081 | 15849 | 238 |
1892802 | 1892802 | 2021-11-07 | Lee | Mississippi | 28081 | 15814 | 238 |
1889552 | 1889552 | 2021-11-06 | Lee | Mississippi | 28081 | 15814 | 238 |
1886302 | 1886302 | 2021-11-05 | Lee | Mississippi | 28081 | 15814 | 238 |
1883053 | 1883053 | 2021-11-04 | Lee | Mississippi | 28081 | 15792 | 236 |
1879804 | 1879804 | 2021-11-03 | Lee | Mississippi | 28081 | 15777 | 236 |
1876555 | 1876555 | 2021-11-02 | Lee | Mississippi | 28081 | 15758 | 236 |
1873306 | 1873306 | 2021-11-01 | Lee | Mississippi | 28081 | 15733 | 236 |
1870057 | 1870057 | 2021-10-31 | Lee | Mississippi | 28081 | 15707 | 235 |
1866808 | 1866808 | 2021-10-30 | Lee | Mississippi | 28081 | 15707 | 235 |
1863559 | 1863559 | 2021-10-29 | Lee | Mississippi | 28081 | 15707 | 235 |
1860310 | 1860310 | 2021-10-28 | Lee | Mississippi | 28081 | 15689 | 235 |
1857061 | 1857061 | 2021-10-27 | Lee | Mississippi | 28081 | 15671 | 235 |
1853812 | 1853812 | 2021-10-26 | Lee | Mississippi | 28081 | 15657 | 235 |
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);