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 |
---|---|---|---|---|---|---|---|
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 |
1850558 | 1850558 | 2021-10-25 | Lafayette | Mississippi | 28071 | 8557 | 140 |
1847308 | 1847308 | 2021-10-24 | Lafayette | Mississippi | 28071 | 8550 | 140 |
1844058 | 1844058 | 2021-10-23 | Lafayette | Mississippi | 28071 | 8550 | 140 |
1840808 | 1840808 | 2021-10-22 | Lafayette | Mississippi | 28071 | 8550 | 140 |
1837559 | 1837559 | 2021-10-21 | Lafayette | Mississippi | 28071 | 8547 | 139 |
1834310 | 1834310 | 2021-10-20 | Lafayette | Mississippi | 28071 | 8542 | 139 |
1831061 | 1831061 | 2021-10-19 | Lafayette | Mississippi | 28071 | 8538 | 138 |
1827812 | 1827812 | 2021-10-18 | Lafayette | Mississippi | 28071 | 8462 | 138 |
1824563 | 1824563 | 2021-10-17 | Lafayette | Mississippi | 28071 | 8454 | 138 |
1821314 | 1821314 | 2021-10-16 | Lafayette | Mississippi | 28071 | 8454 | 138 |
1818065 | 1818065 | 2021-10-15 | Lafayette | Mississippi | 28071 | 8454 | 138 |
1814816 | 1814816 | 2021-10-14 | Lafayette | Mississippi | 28071 | 8450 | 137 |
1811568 | 1811568 | 2021-10-13 | Lafayette | Mississippi | 28071 | 8443 | 137 |
1808319 | 1808319 | 2021-10-12 | Lafayette | Mississippi | 28071 | 8434 | 137 |
1805068 | 1805068 | 2021-10-11 | Lafayette | Mississippi | 28071 | 8413 | 137 |
1801819 | 1801819 | 2021-10-10 | Lafayette | Mississippi | 28071 | 8390 | 137 |
1798570 | 1798570 | 2021-10-09 | Lafayette | Mississippi | 28071 | 8390 | 137 |
1795321 | 1795321 | 2021-10-08 | Lafayette | Mississippi | 28071 | 8390 | 137 |
1792072 | 1792072 | 2021-10-07 | Lafayette | Mississippi | 28071 | 8373 | 137 |
1788823 | 1788823 | 2021-10-06 | Lafayette | Mississippi | 28071 | 8362 | 137 |
1785575 | 1785575 | 2021-10-05 | Lafayette | Mississippi | 28071 | 8350 | 137 |
1782326 | 1782326 | 2021-10-04 | Lafayette | Mississippi | 28071 | 8340 | 137 |
1779076 | 1779076 | 2021-10-03 | Lafayette | Mississippi | 28071 | 8318 | 137 |
1775826 | 1775826 | 2021-10-02 | Lafayette | Mississippi | 28071 | 8318 | 137 |
1772576 | 1772576 | 2021-10-01 | Lafayette | Mississippi | 28071 | 8318 | 137 |
1769327 | 1769327 | 2021-09-30 | Lafayette | Mississippi | 28071 | 8307 | 137 |
1766078 | 1766078 | 2021-09-29 | Lafayette | Mississippi | 28071 | 8302 | 137 |
1762829 | 1762829 | 2021-09-28 | Lafayette | Mississippi | 28071 | 8298 | 137 |
1759580 | 1759580 | 2021-09-27 | Lafayette | Mississippi | 28071 | 8268 | 137 |
1756332 | 1756332 | 2021-09-26 | Lafayette | Mississippi | 28071 | 8241 | 137 |
1753084 | 1753084 | 2021-09-25 | Lafayette | Mississippi | 28071 | 8241 | 137 |
1749836 | 1749836 | 2021-09-24 | Lafayette | Mississippi | 28071 | 8241 | 137 |
1746586 | 1746586 | 2021-09-23 | Lafayette | Mississippi | 28071 | 8218 | 137 |
1743337 | 1743337 | 2021-09-22 | Lafayette | Mississippi | 28071 | 8193 | 137 |
1740088 | 1740088 | 2021-09-21 | Lafayette | Mississippi | 28071 | 8164 | 137 |
1736839 | 1736839 | 2021-09-20 | Lafayette | Mississippi | 28071 | 8110 | 137 |
1733589 | 1733589 | 2021-09-19 | Lafayette | Mississippi | 28071 | 8078 | 136 |
1730339 | 1730339 | 2021-09-18 | Lafayette | Mississippi | 28071 | 8078 | 136 |
1727089 | 1727089 | 2021-09-17 | Lafayette | Mississippi | 28071 | 8078 | 136 |
1723840 | 1723840 | 2021-09-16 | Lafayette | Mississippi | 28071 | 8052 | 136 |
1720591 | 1720591 | 2021-09-15 | Lafayette | Mississippi | 28071 | 8008 | 136 |
1717343 | 1717343 | 2021-09-14 | Lafayette | Mississippi | 28071 | 7958 | 135 |
1714095 | 1714095 | 2021-09-13 | Lafayette | Mississippi | 28071 | 7905 | 135 |
1710849 | 1710849 | 2021-09-12 | Lafayette | Mississippi | 28071 | 7850 | 134 |
1707602 | 1707602 | 2021-09-11 | Lafayette | Mississippi | 28071 | 7850 | 134 |
1704355 | 1704355 | 2021-09-10 | Lafayette | Mississippi | 28071 | 7850 | 134 |
1701105 | 1701105 | 2021-09-09 | Lafayette | Mississippi | 28071 | 7806 | 133 |
1697856 | 1697856 | 2021-09-08 | Lafayette | Mississippi | 28071 | 7770 | 132 |
1694608 | 1694608 | 2021-09-07 | Lafayette | Mississippi | 28071 | 7732 | 131 |
1691359 | 1691359 | 2021-09-06 | Lafayette | Mississippi | 28071 | 7721 | 131 |
1688109 | 1688109 | 2021-09-05 | Lafayette | Mississippi | 28071 | 7644 | 130 |
1684859 | 1684859 | 2021-09-04 | Lafayette | Mississippi | 28071 | 7644 | 130 |
1681608 | 1681608 | 2021-09-03 | Lafayette | Mississippi | 28071 | 7644 | 130 |
1678360 | 1678360 | 2021-09-02 | Lafayette | Mississippi | 28071 | 7574 | 130 |
1675112 | 1675112 | 2021-09-01 | Lafayette | Mississippi | 28071 | 7500 | 130 |
1671864 | 1671864 | 2021-08-31 | Lafayette | Mississippi | 28071 | 7451 | 130 |
1668617 | 1668617 | 2021-08-30 | Lafayette | Mississippi | 28071 | 7433 | 130 |
1665370 | 1665370 | 2021-08-29 | Lafayette | Mississippi | 28071 | 7363 | 129 |
1662122 | 1662122 | 2021-08-28 | Lafayette | Mississippi | 28071 | 7363 | 129 |
1658874 | 1658874 | 2021-08-27 | Lafayette | Mississippi | 28071 | 7363 | 129 |
1655625 | 1655625 | 2021-08-26 | Lafayette | Mississippi | 28071 | 7326 | 129 |
1652378 | 1652378 | 2021-08-25 | Lafayette | Mississippi | 28071 | 7304 | 129 |
1649130 | 1649130 | 2021-08-24 | Lafayette | Mississippi | 28071 | 7290 | 129 |
1645881 | 1645881 | 2021-08-23 | Lafayette | Mississippi | 28071 | 7243 | 129 |
1642632 | 1642632 | 2021-08-22 | Lafayette | Mississippi | 28071 | 7191 | 128 |
1639382 | 1639382 | 2021-08-21 | Lafayette | Mississippi | 28071 | 7191 | 128 |
1636132 | 1636132 | 2021-08-20 | Lafayette | Mississippi | 28071 | 7191 | 128 |
1632882 | 1632882 | 2021-08-19 | Lafayette | Mississippi | 28071 | 7154 | 128 |
1629635 | 1629635 | 2021-08-18 | Lafayette | Mississippi | 28071 | 7124 | 128 |
1626388 | 1626388 | 2021-08-17 | Lafayette | Mississippi | 28071 | 7098 | 128 |
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);