ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lawrence" and fips = 28077 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1623144 | 1623144 | 2021-08-16 | Lawrence | Mississippi | 28077 | 1638 | 27 |
1619897 | 1619897 | 2021-08-15 | Lawrence | Mississippi | 28077 | 1587 | 27 |
1616649 | 1616649 | 2021-08-14 | Lawrence | Mississippi | 28077 | 1587 | 27 |
1613401 | 1613401 | 2021-08-13 | Lawrence | Mississippi | 28077 | 1587 | 27 |
1610152 | 1610152 | 2021-08-12 | Lawrence | Mississippi | 28077 | 1564 | 27 |
1606904 | 1606904 | 2021-08-11 | Lawrence | Mississippi | 28077 | 1548 | 27 |
1603655 | 1603655 | 2021-08-10 | Lawrence | Mississippi | 28077 | 1530 | 27 |
1600406 | 1600406 | 2021-08-09 | Lawrence | Mississippi | 28077 | 1517 | 26 |
1597158 | 1597158 | 2021-08-08 | Lawrence | Mississippi | 28077 | 1492 | 26 |
1593909 | 1593909 | 2021-08-07 | Lawrence | Mississippi | 28077 | 1492 | 26 |
1590660 | 1590660 | 2021-08-06 | Lawrence | Mississippi | 28077 | 1492 | 26 |
1587411 | 1587411 | 2021-08-05 | Lawrence | Mississippi | 28077 | 1474 | 26 |
1584160 | 1584160 | 2021-08-04 | Lawrence | Mississippi | 28077 | 1464 | 26 |
1580911 | 1580911 | 2021-08-03 | Lawrence | Mississippi | 28077 | 1454 | 26 |
1577662 | 1577662 | 2021-08-02 | Lawrence | Mississippi | 28077 | 1452 | 26 |
1574414 | 1574414 | 2021-08-01 | Lawrence | Mississippi | 28077 | 1428 | 26 |
1571166 | 1571166 | 2021-07-31 | Lawrence | Mississippi | 28077 | 1428 | 26 |
1567918 | 1567918 | 2021-07-30 | Lawrence | Mississippi | 28077 | 1428 | 26 |
1564670 | 1564670 | 2021-07-29 | Lawrence | Mississippi | 28077 | 1416 | 26 |
1561422 | 1561422 | 2021-07-28 | Lawrence | Mississippi | 28077 | 1406 | 26 |
1558174 | 1558174 | 2021-07-27 | Lawrence | Mississippi | 28077 | 1400 | 26 |
1554927 | 1554927 | 2021-07-26 | Lawrence | Mississippi | 28077 | 1396 | 26 |
1551680 | 1551680 | 2021-07-25 | Lawrence | Mississippi | 28077 | 1377 | 26 |
1548433 | 1548433 | 2021-07-24 | Lawrence | Mississippi | 28077 | 1377 | 26 |
1545186 | 1545186 | 2021-07-23 | Lawrence | Mississippi | 28077 | 1377 | 26 |
1541938 | 1541938 | 2021-07-22 | Lawrence | Mississippi | 28077 | 1370 | 26 |
1538691 | 1538691 | 2021-07-21 | Lawrence | Mississippi | 28077 | 1362 | 26 |
1535444 | 1535444 | 2021-07-20 | Lawrence | Mississippi | 28077 | 1353 | 26 |
1532196 | 1532196 | 2021-07-19 | Lawrence | Mississippi | 28077 | 1351 | 26 |
1528949 | 1528949 | 2021-07-18 | Lawrence | Mississippi | 28077 | 1341 | 26 |
1525702 | 1525702 | 2021-07-17 | Lawrence | Mississippi | 28077 | 1341 | 26 |
1522455 | 1522455 | 2021-07-16 | Lawrence | Mississippi | 28077 | 1341 | 26 |
1519206 | 1519206 | 2021-07-15 | Lawrence | Mississippi | 28077 | 1340 | 26 |
1515959 | 1515959 | 2021-07-14 | Lawrence | Mississippi | 28077 | 1337 | 25 |
1512713 | 1512713 | 2021-07-13 | Lawrence | Mississippi | 28077 | 1334 | 25 |
1509466 | 1509466 | 2021-07-12 | Lawrence | Mississippi | 28077 | 1334 | 25 |
1506220 | 1506220 | 2021-07-11 | Lawrence | Mississippi | 28077 | 1331 | 25 |
1502974 | 1502974 | 2021-07-10 | Lawrence | Mississippi | 28077 | 1331 | 25 |
1499728 | 1499728 | 2021-07-09 | Lawrence | Mississippi | 28077 | 1331 | 25 |
1496482 | 1496482 | 2021-07-08 | Lawrence | Mississippi | 28077 | 1328 | 25 |
1493235 | 1493235 | 2021-07-07 | Lawrence | Mississippi | 28077 | 1327 | 25 |
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);