ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28147 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811606 | 1811606 | 2021-10-13 | Walthall | Mississippi | 28147 | 2174 | 63 |
1808357 | 1808357 | 2021-10-12 | Walthall | Mississippi | 28147 | 2156 | 63 |
1805106 | 1805106 | 2021-10-11 | Walthall | Mississippi | 28147 | 2152 | 63 |
1801857 | 1801857 | 2021-10-10 | Walthall | Mississippi | 28147 | 2145 | 63 |
1798608 | 1798608 | 2021-10-09 | Walthall | Mississippi | 28147 | 2145 | 63 |
1795359 | 1795359 | 2021-10-08 | Walthall | Mississippi | 28147 | 2145 | 63 |
1792110 | 1792110 | 2021-10-07 | Walthall | Mississippi | 28147 | 2143 | 63 |
1788861 | 1788861 | 2021-10-06 | Walthall | Mississippi | 28147 | 2140 | 62 |
1785613 | 1785613 | 2021-10-05 | Walthall | Mississippi | 28147 | 2139 | 62 |
1782364 | 1782364 | 2021-10-04 | Walthall | Mississippi | 28147 | 2134 | 62 |
1779114 | 1779114 | 2021-10-03 | Walthall | Mississippi | 28147 | 2130 | 61 |
1775864 | 1775864 | 2021-10-02 | Walthall | Mississippi | 28147 | 2130 | 61 |
1772614 | 1772614 | 2021-10-01 | Walthall | Mississippi | 28147 | 2130 | 61 |
1769365 | 1769365 | 2021-09-30 | Walthall | Mississippi | 28147 | 2128 | 60 |
1766116 | 1766116 | 2021-09-29 | Walthall | Mississippi | 28147 | 2125 | 60 |
1762867 | 1762867 | 2021-09-28 | Walthall | Mississippi | 28147 | 2119 | 59 |
1759618 | 1759618 | 2021-09-27 | Walthall | Mississippi | 28147 | 2117 | 58 |
1756370 | 1756370 | 2021-09-26 | Walthall | Mississippi | 28147 | 2110 | 58 |
1753122 | 1753122 | 2021-09-25 | Walthall | Mississippi | 28147 | 2110 | 58 |
1749874 | 1749874 | 2021-09-24 | Walthall | Mississippi | 28147 | 2110 | 58 |
1746624 | 1746624 | 2021-09-23 | Walthall | Mississippi | 28147 | 2105 | 58 |
1743375 | 1743375 | 2021-09-22 | Walthall | Mississippi | 28147 | 2099 | 58 |
1740126 | 1740126 | 2021-09-21 | Walthall | Mississippi | 28147 | 2094 | 58 |
1736877 | 1736877 | 2021-09-20 | Walthall | Mississippi | 28147 | 2088 | 57 |
1733627 | 1733627 | 2021-09-19 | Walthall | Mississippi | 28147 | 2055 | 57 |
1730377 | 1730377 | 2021-09-18 | Walthall | Mississippi | 28147 | 2055 | 57 |
1727127 | 1727127 | 2021-09-17 | Walthall | Mississippi | 28147 | 2055 | 57 |
1723878 | 1723878 | 2021-09-16 | Walthall | Mississippi | 28147 | 2046 | 57 |
1720629 | 1720629 | 2021-09-15 | Walthall | Mississippi | 28147 | 2034 | 57 |
1717381 | 1717381 | 2021-09-14 | Walthall | Mississippi | 28147 | 2015 | 57 |
1714133 | 1714133 | 2021-09-13 | Walthall | Mississippi | 28147 | 2010 | 54 |
1710887 | 1710887 | 2021-09-12 | Walthall | Mississippi | 28147 | 1991 | 54 |
1707640 | 1707640 | 2021-09-11 | Walthall | Mississippi | 28147 | 1991 | 54 |
1704393 | 1704393 | 2021-09-10 | Walthall | Mississippi | 28147 | 1991 | 54 |
1701143 | 1701143 | 2021-09-09 | Walthall | Mississippi | 28147 | 1981 | 54 |
1697894 | 1697894 | 2021-09-08 | Walthall | Mississippi | 28147 | 1964 | 54 |
1694646 | 1694646 | 2021-09-07 | Walthall | Mississippi | 28147 | 1955 | 54 |
1691397 | 1691397 | 2021-09-06 | Walthall | Mississippi | 28147 | 1954 | 54 |
1688147 | 1688147 | 2021-09-05 | Walthall | Mississippi | 28147 | 1936 | 53 |
1684897 | 1684897 | 2021-09-04 | Walthall | Mississippi | 28147 | 1936 | 53 |
1681646 | 1681646 | 2021-09-03 | Walthall | Mississippi | 28147 | 1936 | 53 |
1678398 | 1678398 | 2021-09-02 | Walthall | Mississippi | 28147 | 1929 | 53 |
1675150 | 1675150 | 2021-09-01 | Walthall | Mississippi | 28147 | 1913 | 53 |
1671902 | 1671902 | 2021-08-31 | Walthall | Mississippi | 28147 | 1881 | 53 |
1668655 | 1668655 | 2021-08-30 | Walthall | Mississippi | 28147 | 1872 | 53 |
1665408 | 1665408 | 2021-08-29 | Walthall | Mississippi | 28147 | 1826 | 53 |
1662160 | 1662160 | 2021-08-28 | Walthall | Mississippi | 28147 | 1826 | 53 |
1658912 | 1658912 | 2021-08-27 | Walthall | Mississippi | 28147 | 1826 | 53 |
1655663 | 1655663 | 2021-08-26 | Walthall | Mississippi | 28147 | 1809 | 53 |
1652416 | 1652416 | 2021-08-25 | Walthall | Mississippi | 28147 | 1789 | 53 |
1649168 | 1649168 | 2021-08-24 | Walthall | Mississippi | 28147 | 1778 | 53 |
1645919 | 1645919 | 2021-08-23 | Walthall | Mississippi | 28147 | 1768 | 52 |
1642670 | 1642670 | 2021-08-22 | Walthall | Mississippi | 28147 | 1735 | 52 |
1639420 | 1639420 | 2021-08-21 | Walthall | Mississippi | 28147 | 1735 | 52 |
1636170 | 1636170 | 2021-08-20 | Walthall | Mississippi | 28147 | 1735 | 52 |
1632920 | 1632920 | 2021-08-19 | Walthall | Mississippi | 28147 | 1713 | 52 |
1629673 | 1629673 | 2021-08-18 | Walthall | Mississippi | 28147 | 1687 | 52 |
1626426 | 1626426 | 2021-08-17 | Walthall | Mississippi | 28147 | 1651 | 52 |
1623179 | 1623179 | 2021-08-16 | Walthall | Mississippi | 28147 | 1645 | 52 |
1619932 | 1619932 | 2021-08-15 | Walthall | Mississippi | 28147 | 1616 | 51 |
1616684 | 1616684 | 2021-08-14 | Walthall | Mississippi | 28147 | 1616 | 51 |
1613436 | 1613436 | 2021-08-13 | Walthall | Mississippi | 28147 | 1616 | 51 |
1610187 | 1610187 | 2021-08-12 | Walthall | Mississippi | 28147 | 1596 | 51 |
1606939 | 1606939 | 2021-08-11 | Walthall | Mississippi | 28147 | 1589 | 51 |
1603690 | 1603690 | 2021-08-10 | Walthall | Mississippi | 28147 | 1580 | 50 |
1600441 | 1600441 | 2021-08-09 | Walthall | Mississippi | 28147 | 1573 | 49 |
1597193 | 1597193 | 2021-08-08 | Walthall | Mississippi | 28147 | 1538 | 49 |
1593944 | 1593944 | 2021-08-07 | Walthall | Mississippi | 28147 | 1538 | 49 |
1590695 | 1590695 | 2021-08-06 | Walthall | Mississippi | 28147 | 1538 | 49 |
1587446 | 1587446 | 2021-08-05 | Walthall | Mississippi | 28147 | 1531 | 49 |
1584195 | 1584195 | 2021-08-04 | Walthall | Mississippi | 28147 | 1512 | 49 |
1580946 | 1580946 | 2021-08-03 | Walthall | Mississippi | 28147 | 1504 | 49 |
1577697 | 1577697 | 2021-08-02 | Walthall | Mississippi | 28147 | 1490 | 49 |
1574449 | 1574449 | 2021-08-01 | Walthall | Mississippi | 28147 | 1457 | 48 |
1571201 | 1571201 | 2021-07-31 | Walthall | Mississippi | 28147 | 1457 | 48 |
1567953 | 1567953 | 2021-07-30 | Walthall | Mississippi | 28147 | 1457 | 48 |
1564705 | 1564705 | 2021-07-29 | Walthall | Mississippi | 28147 | 1453 | 48 |
1561457 | 1561457 | 2021-07-28 | Walthall | Mississippi | 28147 | 1446 | 48 |
1558209 | 1558209 | 2021-07-27 | Walthall | Mississippi | 28147 | 1444 | 48 |
1554962 | 1554962 | 2021-07-26 | Walthall | Mississippi | 28147 | 1434 | 48 |
1551715 | 1551715 | 2021-07-25 | Walthall | Mississippi | 28147 | 1415 | 48 |
1548468 | 1548468 | 2021-07-24 | Walthall | Mississippi | 28147 | 1415 | 48 |
1545221 | 1545221 | 2021-07-23 | Walthall | Mississippi | 28147 | 1415 | 48 |
1541973 | 1541973 | 2021-07-22 | Walthall | Mississippi | 28147 | 1404 | 48 |
1538726 | 1538726 | 2021-07-21 | Walthall | Mississippi | 28147 | 1397 | 48 |
1535479 | 1535479 | 2021-07-20 | Walthall | Mississippi | 28147 | 1391 | 48 |
1532231 | 1532231 | 2021-07-19 | Walthall | Mississippi | 28147 | 1389 | 48 |
1528984 | 1528984 | 2021-07-18 | Walthall | Mississippi | 28147 | 1376 | 48 |
1525737 | 1525737 | 2021-07-17 | Walthall | Mississippi | 28147 | 1376 | 48 |
1522490 | 1522490 | 2021-07-16 | Walthall | Mississippi | 28147 | 1376 | 48 |
1519241 | 1519241 | 2021-07-15 | Walthall | Mississippi | 28147 | 1374 | 48 |
1515994 | 1515994 | 2021-07-14 | Walthall | Mississippi | 28147 | 1374 | 47 |
1512748 | 1512748 | 2021-07-13 | Walthall | Mississippi | 28147 | 1369 | 47 |
1509501 | 1509501 | 2021-07-12 | Walthall | Mississippi | 28147 | 1368 | 47 |
1506255 | 1506255 | 2021-07-11 | Walthall | Mississippi | 28147 | 1366 | 47 |
1503009 | 1503009 | 2021-07-10 | Walthall | Mississippi | 28147 | 1366 | 47 |
1499763 | 1499763 | 2021-07-09 | Walthall | Mississippi | 28147 | 1366 | 47 |
1496517 | 1496517 | 2021-07-08 | Walthall | Mississippi | 28147 | 1366 | 47 |
1493270 | 1493270 | 2021-07-07 | Walthall | Mississippi | 28147 | 1363 | 47 |
1490023 | 1490023 | 2021-07-06 | Walthall | Mississippi | 28147 | 1361 | 47 |
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);