ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lawrence" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948050 | 1948050 | 2021-11-24 | Lawrence | Mississippi | 28077 | 2178 | 40 |
1944799 | 1944799 | 2021-11-23 | Lawrence | Mississippi | 28077 | 2175 | 40 |
1941548 | 1941548 | 2021-11-22 | Lawrence | Mississippi | 28077 | 2174 | 40 |
1938298 | 1938298 | 2021-11-21 | Lawrence | Mississippi | 28077 | 2169 | 40 |
1935048 | 1935048 | 2021-11-20 | Lawrence | Mississippi | 28077 | 2169 | 40 |
1931798 | 1931798 | 2021-11-19 | Lawrence | Mississippi | 28077 | 2169 | 40 |
1928547 | 1928547 | 2021-11-18 | Lawrence | Mississippi | 28077 | 2167 | 40 |
1925297 | 1925297 | 2021-11-17 | Lawrence | Mississippi | 28077 | 2166 | 40 |
1922048 | 1922048 | 2021-11-16 | Lawrence | Mississippi | 28077 | 2166 | 40 |
1918798 | 1918798 | 2021-11-15 | Lawrence | Mississippi | 28077 | 2164 | 40 |
1915548 | 1915548 | 2021-11-14 | Lawrence | Mississippi | 28077 | 2162 | 40 |
1912298 | 1912298 | 2021-11-13 | Lawrence | Mississippi | 28077 | 2162 | 40 |
1909048 | 1909048 | 2021-11-12 | Lawrence | Mississippi | 28077 | 2162 | 40 |
1905799 | 1905799 | 2021-11-11 | Lawrence | Mississippi | 28077 | 2155 | 40 |
1902550 | 1902550 | 2021-11-10 | Lawrence | Mississippi | 28077 | 2155 | 40 |
1899300 | 1899300 | 2021-11-09 | Lawrence | Mississippi | 28077 | 2153 | 40 |
1896050 | 1896050 | 2021-11-08 | Lawrence | Mississippi | 28077 | 2153 | 40 |
1892800 | 1892800 | 2021-11-07 | Lawrence | Mississippi | 28077 | 2147 | 40 |
1889550 | 1889550 | 2021-11-06 | Lawrence | Mississippi | 28077 | 2147 | 40 |
1886300 | 1886300 | 2021-11-05 | Lawrence | Mississippi | 28077 | 2147 | 40 |
1883051 | 1883051 | 2021-11-04 | Lawrence | Mississippi | 28077 | 2144 | 40 |
1879802 | 1879802 | 2021-11-03 | Lawrence | Mississippi | 28077 | 2143 | 40 |
1876553 | 1876553 | 2021-11-02 | Lawrence | Mississippi | 28077 | 2140 | 40 |
1873304 | 1873304 | 2021-11-01 | Lawrence | Mississippi | 28077 | 2140 | 40 |
1870055 | 1870055 | 2021-10-31 | Lawrence | Mississippi | 28077 | 2138 | 40 |
1866806 | 1866806 | 2021-10-30 | Lawrence | Mississippi | 28077 | 2138 | 40 |
1863557 | 1863557 | 2021-10-29 | Lawrence | Mississippi | 28077 | 2138 | 40 |
1860308 | 1860308 | 2021-10-28 | Lawrence | Mississippi | 28077 | 2137 | 40 |
1857059 | 1857059 | 2021-10-27 | Lawrence | Mississippi | 28077 | 2137 | 40 |
1853810 | 1853810 | 2021-10-26 | Lawrence | Mississippi | 28077 | 2136 | 40 |
1850561 | 1850561 | 2021-10-25 | Lawrence | Mississippi | 28077 | 2131 | 40 |
1847311 | 1847311 | 2021-10-24 | Lawrence | Mississippi | 28077 | 2129 | 40 |
1844061 | 1844061 | 2021-10-23 | Lawrence | Mississippi | 28077 | 2129 | 40 |
1840811 | 1840811 | 2021-10-22 | Lawrence | Mississippi | 28077 | 2129 | 40 |
1837562 | 1837562 | 2021-10-21 | Lawrence | Mississippi | 28077 | 2124 | 40 |
1834313 | 1834313 | 2021-10-20 | Lawrence | Mississippi | 28077 | 2124 | 40 |
1831064 | 1831064 | 2021-10-19 | Lawrence | Mississippi | 28077 | 2119 | 40 |
1827815 | 1827815 | 2021-10-18 | Lawrence | Mississippi | 28077 | 2114 | 40 |
1824566 | 1824566 | 2021-10-17 | Lawrence | Mississippi | 28077 | 2111 | 40 |
1821317 | 1821317 | 2021-10-16 | Lawrence | Mississippi | 28077 | 2111 | 40 |
1818068 | 1818068 | 2021-10-15 | Lawrence | Mississippi | 28077 | 2111 | 40 |
1814819 | 1814819 | 2021-10-14 | Lawrence | Mississippi | 28077 | 2111 | 40 |
1811571 | 1811571 | 2021-10-13 | Lawrence | Mississippi | 28077 | 2110 | 39 |
1808322 | 1808322 | 2021-10-12 | Lawrence | Mississippi | 28077 | 2106 | 38 |
1805071 | 1805071 | 2021-10-11 | Lawrence | Mississippi | 28077 | 2099 | 38 |
1801822 | 1801822 | 2021-10-10 | Lawrence | Mississippi | 28077 | 2094 | 38 |
1798573 | 1798573 | 2021-10-09 | Lawrence | Mississippi | 28077 | 2094 | 38 |
1795324 | 1795324 | 2021-10-08 | Lawrence | Mississippi | 28077 | 2094 | 38 |
1792075 | 1792075 | 2021-10-07 | Lawrence | Mississippi | 28077 | 2093 | 38 |
1788826 | 1788826 | 2021-10-06 | Lawrence | Mississippi | 28077 | 2088 | 38 |
1785578 | 1785578 | 2021-10-05 | Lawrence | Mississippi | 28077 | 2087 | 37 |
1782329 | 1782329 | 2021-10-04 | Lawrence | Mississippi | 28077 | 2085 | 36 |
1779079 | 1779079 | 2021-10-03 | Lawrence | Mississippi | 28077 | 2080 | 36 |
1775829 | 1775829 | 2021-10-02 | Lawrence | Mississippi | 28077 | 2080 | 36 |
1772579 | 1772579 | 2021-10-01 | Lawrence | Mississippi | 28077 | 2080 | 36 |
1769330 | 1769330 | 2021-09-30 | Lawrence | Mississippi | 28077 | 2079 | 36 |
1766081 | 1766081 | 2021-09-29 | Lawrence | Mississippi | 28077 | 2076 | 36 |
1762832 | 1762832 | 2021-09-28 | Lawrence | Mississippi | 28077 | 2074 | 35 |
1759583 | 1759583 | 2021-09-27 | Lawrence | Mississippi | 28077 | 2070 | 34 |
1756335 | 1756335 | 2021-09-26 | Lawrence | Mississippi | 28077 | 2068 | 33 |
1753087 | 1753087 | 2021-09-25 | Lawrence | Mississippi | 28077 | 2068 | 33 |
1749839 | 1749839 | 2021-09-24 | Lawrence | Mississippi | 28077 | 2068 | 33 |
1746589 | 1746589 | 2021-09-23 | Lawrence | Mississippi | 28077 | 2060 | 33 |
1743340 | 1743340 | 2021-09-22 | Lawrence | Mississippi | 28077 | 2057 | 32 |
1740091 | 1740091 | 2021-09-21 | Lawrence | Mississippi | 28077 | 2047 | 31 |
1736842 | 1736842 | 2021-09-20 | Lawrence | Mississippi | 28077 | 2044 | 31 |
1733592 | 1733592 | 2021-09-19 | Lawrence | Mississippi | 28077 | 2038 | 31 |
1730342 | 1730342 | 2021-09-18 | Lawrence | Mississippi | 28077 | 2038 | 31 |
1727092 | 1727092 | 2021-09-17 | Lawrence | Mississippi | 28077 | 2038 | 31 |
1723843 | 1723843 | 2021-09-16 | Lawrence | Mississippi | 28077 | 2032 | 31 |
1720594 | 1720594 | 2021-09-15 | Lawrence | Mississippi | 28077 | 2024 | 31 |
1717346 | 1717346 | 2021-09-14 | Lawrence | Mississippi | 28077 | 2015 | 31 |
1714098 | 1714098 | 2021-09-13 | Lawrence | Mississippi | 28077 | 2014 | 31 |
1710852 | 1710852 | 2021-09-12 | Lawrence | Mississippi | 28077 | 1989 | 31 |
1707605 | 1707605 | 2021-09-11 | Lawrence | Mississippi | 28077 | 1989 | 31 |
1704358 | 1704358 | 2021-09-10 | Lawrence | Mississippi | 28077 | 1989 | 31 |
1701108 | 1701108 | 2021-09-09 | Lawrence | Mississippi | 28077 | 1982 | 31 |
1697859 | 1697859 | 2021-09-08 | Lawrence | Mississippi | 28077 | 1967 | 31 |
1694611 | 1694611 | 2021-09-07 | Lawrence | Mississippi | 28077 | 1961 | 30 |
1691362 | 1691362 | 2021-09-06 | Lawrence | Mississippi | 28077 | 1956 | 30 |
1688112 | 1688112 | 2021-09-05 | Lawrence | Mississippi | 28077 | 1938 | 30 |
1684862 | 1684862 | 2021-09-04 | Lawrence | Mississippi | 28077 | 1938 | 30 |
1681611 | 1681611 | 2021-09-03 | Lawrence | Mississippi | 28077 | 1938 | 30 |
1678363 | 1678363 | 2021-09-02 | Lawrence | Mississippi | 28077 | 1929 | 29 |
1675115 | 1675115 | 2021-09-01 | Lawrence | Mississippi | 28077 | 1906 | 29 |
1671867 | 1671867 | 2021-08-31 | Lawrence | Mississippi | 28077 | 1890 | 29 |
1668620 | 1668620 | 2021-08-30 | Lawrence | Mississippi | 28077 | 1885 | 29 |
1665373 | 1665373 | 2021-08-29 | Lawrence | Mississippi | 28077 | 1852 | 29 |
1662125 | 1662125 | 2021-08-28 | Lawrence | Mississippi | 28077 | 1852 | 29 |
1658877 | 1658877 | 2021-08-27 | Lawrence | Mississippi | 28077 | 1852 | 29 |
1655628 | 1655628 | 2021-08-26 | Lawrence | Mississippi | 28077 | 1827 | 29 |
1652381 | 1652381 | 2021-08-25 | Lawrence | Mississippi | 28077 | 1809 | 28 |
1649133 | 1649133 | 2021-08-24 | Lawrence | Mississippi | 28077 | 1778 | 28 |
1645884 | 1645884 | 2021-08-23 | Lawrence | Mississippi | 28077 | 1766 | 28 |
1642635 | 1642635 | 2021-08-22 | Lawrence | Mississippi | 28077 | 1724 | 28 |
1639385 | 1639385 | 2021-08-21 | Lawrence | Mississippi | 28077 | 1724 | 28 |
1636135 | 1636135 | 2021-08-20 | Lawrence | Mississippi | 28077 | 1724 | 28 |
1632885 | 1632885 | 2021-08-19 | Lawrence | Mississippi | 28077 | 1703 | 27 |
1629638 | 1629638 | 2021-08-18 | Lawrence | Mississippi | 28077 | 1676 | 27 |
1626391 | 1626391 | 2021-08-17 | Lawrence | Mississippi | 28077 | 1645 | 27 |
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);