ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 28045 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948034 | 1948034 | 2021-11-24 | Hancock | Mississippi | 28045 | 7835 | 132 |
1944783 | 1944783 | 2021-11-23 | Hancock | Mississippi | 28045 | 7831 | 132 |
1941532 | 1941532 | 2021-11-22 | Hancock | Mississippi | 28045 | 7828 | 131 |
1938282 | 1938282 | 2021-11-21 | Hancock | Mississippi | 28045 | 7816 | 130 |
1935032 | 1935032 | 2021-11-20 | Hancock | Mississippi | 28045 | 7816 | 130 |
1931782 | 1931782 | 2021-11-19 | Hancock | Mississippi | 28045 | 7816 | 130 |
1928531 | 1928531 | 2021-11-18 | Hancock | Mississippi | 28045 | 7814 | 130 |
1925281 | 1925281 | 2021-11-17 | Hancock | Mississippi | 28045 | 7813 | 130 |
1922032 | 1922032 | 2021-11-16 | Hancock | Mississippi | 28045 | 7812 | 130 |
1918782 | 1918782 | 2021-11-15 | Hancock | Mississippi | 28045 | 7809 | 130 |
1915532 | 1915532 | 2021-11-14 | Hancock | Mississippi | 28045 | 7803 | 130 |
1912282 | 1912282 | 2021-11-13 | Hancock | Mississippi | 28045 | 7803 | 130 |
1909032 | 1909032 | 2021-11-12 | Hancock | Mississippi | 28045 | 7803 | 130 |
1905783 | 1905783 | 2021-11-11 | Hancock | Mississippi | 28045 | 7799 | 130 |
1902534 | 1902534 | 2021-11-10 | Hancock | Mississippi | 28045 | 7799 | 130 |
1899284 | 1899284 | 2021-11-09 | Hancock | Mississippi | 28045 | 7796 | 130 |
1896034 | 1896034 | 2021-11-08 | Hancock | Mississippi | 28045 | 7785 | 130 |
1892784 | 1892784 | 2021-11-07 | Hancock | Mississippi | 28045 | 7782 | 130 |
1889534 | 1889534 | 2021-11-06 | Hancock | Mississippi | 28045 | 7782 | 130 |
1886284 | 1886284 | 2021-11-05 | Hancock | Mississippi | 28045 | 7782 | 130 |
1883035 | 1883035 | 2021-11-04 | Hancock | Mississippi | 28045 | 7781 | 130 |
1879786 | 1879786 | 2021-11-03 | Hancock | Mississippi | 28045 | 7773 | 130 |
1876537 | 1876537 | 2021-11-02 | Hancock | Mississippi | 28045 | 7772 | 130 |
1873288 | 1873288 | 2021-11-01 | Hancock | Mississippi | 28045 | 7770 | 130 |
1870039 | 1870039 | 2021-10-31 | Hancock | Mississippi | 28045 | 7758 | 130 |
1866790 | 1866790 | 2021-10-30 | Hancock | Mississippi | 28045 | 7758 | 130 |
1863541 | 1863541 | 2021-10-29 | Hancock | Mississippi | 28045 | 7758 | 130 |
1860292 | 1860292 | 2021-10-28 | Hancock | Mississippi | 28045 | 7755 | 130 |
1857043 | 1857043 | 2021-10-27 | Hancock | Mississippi | 28045 | 7753 | 130 |
1853794 | 1853794 | 2021-10-26 | Hancock | Mississippi | 28045 | 7751 | 130 |
1850545 | 1850545 | 2021-10-25 | Hancock | Mississippi | 28045 | 7740 | 127 |
1847295 | 1847295 | 2021-10-24 | Hancock | Mississippi | 28045 | 7732 | 127 |
1844045 | 1844045 | 2021-10-23 | Hancock | Mississippi | 28045 | 7732 | 127 |
1840795 | 1840795 | 2021-10-22 | Hancock | Mississippi | 28045 | 7732 | 127 |
1837546 | 1837546 | 2021-10-21 | Hancock | Mississippi | 28045 | 7728 | 126 |
1834297 | 1834297 | 2021-10-20 | Hancock | Mississippi | 28045 | 7727 | 126 |
1831048 | 1831048 | 2021-10-19 | Hancock | Mississippi | 28045 | 7721 | 126 |
1827799 | 1827799 | 2021-10-18 | Hancock | Mississippi | 28045 | 7703 | 126 |
1824550 | 1824550 | 2021-10-17 | Hancock | Mississippi | 28045 | 7697 | 126 |
1821301 | 1821301 | 2021-10-16 | Hancock | Mississippi | 28045 | 7697 | 126 |
1818052 | 1818052 | 2021-10-15 | Hancock | Mississippi | 28045 | 7697 | 126 |
1814803 | 1814803 | 2021-10-14 | Hancock | Mississippi | 28045 | 7690 | 126 |
1811555 | 1811555 | 2021-10-13 | Hancock | Mississippi | 28045 | 7685 | 126 |
1808306 | 1808306 | 2021-10-12 | Hancock | Mississippi | 28045 | 7681 | 126 |
1805055 | 1805055 | 2021-10-11 | Hancock | Mississippi | 28045 | 7675 | 126 |
1801806 | 1801806 | 2021-10-10 | Hancock | Mississippi | 28045 | 7667 | 126 |
1798557 | 1798557 | 2021-10-09 | Hancock | Mississippi | 28045 | 7667 | 126 |
1795308 | 1795308 | 2021-10-08 | Hancock | Mississippi | 28045 | 7667 | 126 |
1792059 | 1792059 | 2021-10-07 | Hancock | Mississippi | 28045 | 7658 | 125 |
1788810 | 1788810 | 2021-10-06 | Hancock | Mississippi | 28045 | 7646 | 125 |
1785562 | 1785562 | 2021-10-05 | Hancock | Mississippi | 28045 | 7632 | 124 |
1782313 | 1782313 | 2021-10-04 | Hancock | Mississippi | 28045 | 7605 | 123 |
1779063 | 1779063 | 2021-10-03 | Hancock | Mississippi | 28045 | 7587 | 121 |
1775813 | 1775813 | 2021-10-02 | Hancock | Mississippi | 28045 | 7587 | 121 |
1772563 | 1772563 | 2021-10-01 | Hancock | Mississippi | 28045 | 7587 | 121 |
1769314 | 1769314 | 2021-09-30 | Hancock | Mississippi | 28045 | 7582 | 121 |
1766065 | 1766065 | 2021-09-29 | Hancock | Mississippi | 28045 | 7569 | 121 |
1762816 | 1762816 | 2021-09-28 | Hancock | Mississippi | 28045 | 7554 | 116 |
1759567 | 1759567 | 2021-09-27 | Hancock | Mississippi | 28045 | 7534 | 113 |
1756319 | 1756319 | 2021-09-26 | Hancock | Mississippi | 28045 | 7514 | 112 |
1753071 | 1753071 | 2021-09-25 | Hancock | Mississippi | 28045 | 7514 | 112 |
1749823 | 1749823 | 2021-09-24 | Hancock | Mississippi | 28045 | 7514 | 112 |
1746573 | 1746573 | 2021-09-23 | Hancock | Mississippi | 28045 | 7501 | 112 |
1743324 | 1743324 | 2021-09-22 | Hancock | Mississippi | 28045 | 7404 | 111 |
1740075 | 1740075 | 2021-09-21 | Hancock | Mississippi | 28045 | 7391 | 111 |
1736826 | 1736826 | 2021-09-20 | Hancock | Mississippi | 28045 | 7365 | 111 |
1733576 | 1733576 | 2021-09-19 | Hancock | Mississippi | 28045 | 7324 | 111 |
1730326 | 1730326 | 2021-09-18 | Hancock | Mississippi | 28045 | 7324 | 111 |
1727076 | 1727076 | 2021-09-17 | Hancock | Mississippi | 28045 | 7324 | 111 |
1723827 | 1723827 | 2021-09-16 | Hancock | Mississippi | 28045 | 7172 | 111 |
1720578 | 1720578 | 2021-09-15 | Hancock | Mississippi | 28045 | 7110 | 107 |
1717330 | 1717330 | 2021-09-14 | Hancock | Mississippi | 28045 | 7065 | 105 |
1714082 | 1714082 | 2021-09-13 | Hancock | Mississippi | 28045 | 7005 | 105 |
1710836 | 1710836 | 2021-09-12 | Hancock | Mississippi | 28045 | 6936 | 104 |
1707589 | 1707589 | 2021-09-11 | Hancock | Mississippi | 28045 | 6936 | 104 |
1704342 | 1704342 | 2021-09-10 | Hancock | Mississippi | 28045 | 6936 | 104 |
1701092 | 1701092 | 2021-09-09 | Hancock | Mississippi | 28045 | 6912 | 103 |
1697843 | 1697843 | 2021-09-08 | Hancock | Mississippi | 28045 | 6858 | 102 |
1694595 | 1694595 | 2021-09-07 | Hancock | Mississippi | 28045 | 6794 | 99 |
1691346 | 1691346 | 2021-09-06 | Hancock | Mississippi | 28045 | 6777 | 99 |
1688096 | 1688096 | 2021-09-05 | Hancock | Mississippi | 28045 | 6684 | 99 |
1684846 | 1684846 | 2021-09-04 | Hancock | Mississippi | 28045 | 6684 | 99 |
1681595 | 1681595 | 2021-09-03 | Hancock | Mississippi | 28045 | 6684 | 99 |
1678347 | 1678347 | 2021-09-02 | Hancock | Mississippi | 28045 | 6587 | 98 |
1675099 | 1675099 | 2021-09-01 | Hancock | Mississippi | 28045 | 6535 | 98 |
1671851 | 1671851 | 2021-08-31 | Hancock | Mississippi | 28045 | 6502 | 98 |
1668604 | 1668604 | 2021-08-30 | Hancock | Mississippi | 28045 | 6484 | 98 |
1665357 | 1665357 | 2021-08-29 | Hancock | Mississippi | 28045 | 6311 | 97 |
1662109 | 1662109 | 2021-08-28 | Hancock | Mississippi | 28045 | 6311 | 97 |
1658861 | 1658861 | 2021-08-27 | Hancock | Mississippi | 28045 | 6311 | 97 |
1655612 | 1655612 | 2021-08-26 | Hancock | Mississippi | 28045 | 6223 | 94 |
1652365 | 1652365 | 2021-08-25 | Hancock | Mississippi | 28045 | 6160 | 94 |
1649117 | 1649117 | 2021-08-24 | Hancock | Mississippi | 28045 | 6052 | 94 |
1645868 | 1645868 | 2021-08-23 | Hancock | Mississippi | 28045 | 5982 | 93 |
1642619 | 1642619 | 2021-08-22 | Hancock | Mississippi | 28045 | 5782 | 92 |
1639369 | 1639369 | 2021-08-21 | Hancock | Mississippi | 28045 | 5782 | 92 |
1636119 | 1636119 | 2021-08-20 | Hancock | Mississippi | 28045 | 5782 | 92 |
1632869 | 1632869 | 2021-08-19 | Hancock | Mississippi | 28045 | 5562 | 91 |
1629622 | 1629622 | 2021-08-18 | Hancock | Mississippi | 28045 | 5437 | 91 |
1626375 | 1626375 | 2021-08-17 | Hancock | Mississippi | 28045 | 5320 | 91 |
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);