ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28053 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175637 | 2175637 | 2022-02-02 | Humphreys | Mississippi | 28053 | 1885 | 40 |
2172384 | 2172384 | 2022-02-01 | Humphreys | Mississippi | 28053 | 1873 | 40 |
2169131 | 2169131 | 2022-01-31 | Humphreys | Mississippi | 28053 | 1866 | 40 |
2165876 | 2165876 | 2022-01-30 | Humphreys | Mississippi | 28053 | 1846 | 39 |
2162621 | 2162621 | 2022-01-29 | Humphreys | Mississippi | 28053 | 1846 | 39 |
2159366 | 2159366 | 2022-01-28 | Humphreys | Mississippi | 28053 | 1846 | 39 |
2156112 | 2156112 | 2022-01-27 | Humphreys | Mississippi | 28053 | 1830 | 39 |
2152859 | 2152859 | 2022-01-26 | Humphreys | Mississippi | 28053 | 1810 | 39 |
2149607 | 2149607 | 2022-01-25 | Humphreys | Mississippi | 28053 | 1779 | 39 |
2146355 | 2146355 | 2022-01-24 | Humphreys | Mississippi | 28053 | 1778 | 39 |
2143100 | 2143100 | 2022-01-23 | Humphreys | Mississippi | 28053 | 1758 | 39 |
2139845 | 2139845 | 2022-01-22 | Humphreys | Mississippi | 28053 | 1758 | 39 |
2136589 | 2136589 | 2022-01-21 | Humphreys | Mississippi | 28053 | 1758 | 39 |
2133337 | 2133337 | 2022-01-20 | Humphreys | Mississippi | 28053 | 1748 | 39 |
2130084 | 2130084 | 2022-01-19 | Humphreys | Mississippi | 28053 | 1730 | 39 |
2126830 | 2126830 | 2022-01-18 | Humphreys | Mississippi | 28053 | 1718 | 39 |
2123578 | 2123578 | 2022-01-17 | Humphreys | Mississippi | 28053 | 1688 | 39 |
2120326 | 2120326 | 2022-01-16 | Humphreys | Mississippi | 28053 | 1688 | 39 |
2117074 | 2117074 | 2022-01-15 | Humphreys | Mississippi | 28053 | 1688 | 39 |
2113823 | 2113823 | 2022-01-14 | Humphreys | Mississippi | 28053 | 1688 | 39 |
2110571 | 2110571 | 2022-01-13 | Humphreys | Mississippi | 28053 | 1648 | 39 |
2107320 | 2107320 | 2022-01-12 | Humphreys | Mississippi | 28053 | 1632 | 39 |
2104069 | 2104069 | 2022-01-11 | Humphreys | Mississippi | 28053 | 1608 | 39 |
2100818 | 2100818 | 2022-01-10 | Humphreys | Mississippi | 28053 | 1587 | 39 |
2097567 | 2097567 | 2022-01-09 | Humphreys | Mississippi | 28053 | 1522 | 39 |
2094315 | 2094315 | 2022-01-08 | Humphreys | Mississippi | 28053 | 1522 | 39 |
2091063 | 2091063 | 2022-01-07 | Humphreys | Mississippi | 28053 | 1522 | 39 |
2087812 | 2087812 | 2022-01-06 | Humphreys | Mississippi | 28053 | 1493 | 39 |
2084560 | 2084560 | 2022-01-05 | Humphreys | Mississippi | 28053 | 1474 | 39 |
2081308 | 2081308 | 2022-01-04 | Humphreys | Mississippi | 28053 | 1452 | 39 |
2078056 | 2078056 | 2022-01-03 | Humphreys | Mississippi | 28053 | 1438 | 39 |
2074805 | 2074805 | 2022-01-02 | Humphreys | Mississippi | 28053 | 1388 | 39 |
2071554 | 2071554 | 2022-01-01 | Humphreys | Mississippi | 28053 | 1388 | 39 |
2068303 | 2068303 | 2021-12-31 | Humphreys | Mississippi | 28053 | 1388 | 39 |
2065052 | 2065052 | 2021-12-30 | Humphreys | Mississippi | 28053 | 1388 | 39 |
2061802 | 2061802 | 2021-12-29 | Humphreys | Mississippi | 28053 | 1380 | 39 |
2058553 | 2058553 | 2021-12-28 | Humphreys | Mississippi | 28053 | 1371 | 39 |
2055304 | 2055304 | 2021-12-27 | Humphreys | Mississippi | 28053 | 1362 | 39 |
2052054 | 2052054 | 2021-12-26 | Humphreys | Mississippi | 28053 | 1348 | 39 |
2048804 | 2048804 | 2021-12-25 | Humphreys | Mississippi | 28053 | 1348 | 39 |
2045554 | 2045554 | 2021-12-24 | Humphreys | Mississippi | 28053 | 1348 | 39 |
2042304 | 2042304 | 2021-12-23 | Humphreys | Mississippi | 28053 | 1348 | 39 |
2039055 | 2039055 | 2021-12-22 | Humphreys | Mississippi | 28053 | 1348 | 39 |
2035805 | 2035805 | 2021-12-21 | Humphreys | Mississippi | 28053 | 1346 | 39 |
2032555 | 2032555 | 2021-12-20 | Humphreys | Mississippi | 28053 | 1339 | 39 |
2029304 | 2029304 | 2021-12-19 | Humphreys | Mississippi | 28053 | 1334 | 39 |
2026053 | 2026053 | 2021-12-18 | Humphreys | Mississippi | 28053 | 1334 | 39 |
2022802 | 2022802 | 2021-12-17 | Humphreys | Mississippi | 28053 | 1334 | 39 |
2019551 | 2019551 | 2021-12-16 | Humphreys | Mississippi | 28053 | 1332 | 39 |
2016301 | 2016301 | 2021-12-15 | Humphreys | Mississippi | 28053 | 1331 | 39 |
2013050 | 2013050 | 2021-12-14 | Humphreys | Mississippi | 28053 | 1331 | 39 |
2009799 | 2009799 | 2021-12-13 | Humphreys | Mississippi | 28053 | 1330 | 39 |
2006548 | 2006548 | 2021-12-12 | Humphreys | Mississippi | 28053 | 1329 | 39 |
2003297 | 2003297 | 2021-12-11 | Humphreys | Mississippi | 28053 | 1329 | 39 |
2000047 | 2000047 | 2021-12-10 | Humphreys | Mississippi | 28053 | 1329 | 39 |
1996796 | 1996796 | 2021-12-09 | Humphreys | Mississippi | 28053 | 1328 | 39 |
1993545 | 1993545 | 2021-12-08 | Humphreys | Mississippi | 28053 | 1328 | 39 |
1990294 | 1990294 | 2021-12-07 | Humphreys | Mississippi | 28053 | 1326 | 39 |
1987044 | 1987044 | 2021-12-06 | Humphreys | Mississippi | 28053 | 1323 | 39 |
1983794 | 1983794 | 2021-12-05 | Humphreys | Mississippi | 28053 | 1322 | 39 |
1980544 | 1980544 | 2021-12-04 | Humphreys | Mississippi | 28053 | 1322 | 39 |
1977294 | 1977294 | 2021-12-03 | Humphreys | Mississippi | 28053 | 1322 | 39 |
1974044 | 1974044 | 2021-12-02 | Humphreys | Mississippi | 28053 | 1322 | 39 |
1970795 | 1970795 | 2021-12-01 | Humphreys | Mississippi | 28053 | 1322 | 39 |
1967545 | 1967545 | 2021-11-30 | Humphreys | Mississippi | 28053 | 1321 | 39 |
1964293 | 1964293 | 2021-11-29 | Humphreys | Mississippi | 28053 | 1312 | 39 |
1961042 | 1961042 | 2021-11-28 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1957791 | 1957791 | 2021-11-27 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1954540 | 1954540 | 2021-11-26 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1951289 | 1951289 | 2021-11-25 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1948038 | 1948038 | 2021-11-24 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1944787 | 1944787 | 2021-11-23 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1941536 | 1941536 | 2021-11-22 | Humphreys | Mississippi | 28053 | 1311 | 39 |
1938286 | 1938286 | 2021-11-21 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1935036 | 1935036 | 2021-11-20 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1931786 | 1931786 | 2021-11-19 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1928535 | 1928535 | 2021-11-18 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1925285 | 1925285 | 2021-11-17 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1922036 | 1922036 | 2021-11-16 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1918786 | 1918786 | 2021-11-15 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1915536 | 1915536 | 2021-11-14 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1912286 | 1912286 | 2021-11-13 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1909036 | 1909036 | 2021-11-12 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1905787 | 1905787 | 2021-11-11 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1902538 | 1902538 | 2021-11-10 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1899288 | 1899288 | 2021-11-09 | Humphreys | Mississippi | 28053 | 1306 | 39 |
1896038 | 1896038 | 2021-11-08 | Humphreys | Mississippi | 28053 | 1303 | 39 |
1892788 | 1892788 | 2021-11-07 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1889538 | 1889538 | 2021-11-06 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1886288 | 1886288 | 2021-11-05 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1883039 | 1883039 | 2021-11-04 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1879790 | 1879790 | 2021-11-03 | Humphreys | Mississippi | 28053 | 1301 | 39 |
1876541 | 1876541 | 2021-11-02 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1873292 | 1873292 | 2021-11-01 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1870043 | 1870043 | 2021-10-31 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1866794 | 1866794 | 2021-10-30 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1863545 | 1863545 | 2021-10-29 | Humphreys | Mississippi | 28053 | 1300 | 39 |
1860296 | 1860296 | 2021-10-28 | Humphreys | Mississippi | 28053 | 1299 | 38 |
1857047 | 1857047 | 2021-10-27 | Humphreys | Mississippi | 28053 | 1299 | 38 |
1853798 | 1853798 | 2021-10-26 | Humphreys | Mississippi | 28053 | 1297 | 38 |
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);