ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where county = "Lawrence" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814919 | 1814919 | 2021-10-14 | Lawrence | Missouri | 29109 | 5139 | 104 |
1811671 | 1811671 | 2021-10-13 | Lawrence | Missouri | 29109 | 5129 | 104 |
1808422 | 1808422 | 2021-10-12 | Lawrence | Missouri | 29109 | 5124 | 104 |
1805171 | 1805171 | 2021-10-11 | Lawrence | Missouri | 29109 | 5116 | 104 |
1801922 | 1801922 | 2021-10-10 | Lawrence | Missouri | 29109 | 5108 | 104 |
1798673 | 1798673 | 2021-10-09 | Lawrence | Missouri | 29109 | 5102 | 104 |
1795424 | 1795424 | 2021-10-08 | Lawrence | Missouri | 29109 | 5097 | 104 |
1792175 | 1792175 | 2021-10-07 | Lawrence | Missouri | 29109 | 5087 | 104 |
1788926 | 1788926 | 2021-10-06 | Lawrence | Missouri | 29109 | 5069 | 104 |
1785678 | 1785678 | 2021-10-05 | Lawrence | Missouri | 29109 | 5060 | 104 |
1782429 | 1782429 | 2021-10-04 | Lawrence | Missouri | 29109 | 5061 | 104 |
1779179 | 1779179 | 2021-10-03 | Lawrence | Missouri | 29109 | 5053 | 104 |
1775929 | 1775929 | 2021-10-02 | Lawrence | Missouri | 29109 | 5048 | 104 |
1772679 | 1772679 | 2021-10-01 | Lawrence | Missouri | 29109 | 5046 | 104 |
1769430 | 1769430 | 2021-09-30 | Lawrence | Missouri | 29109 | 5035 | 104 |
1766181 | 1766181 | 2021-09-29 | Lawrence | Missouri | 29109 | 5026 | 104 |
1762932 | 1762932 | 2021-09-28 | Lawrence | Missouri | 29109 | 5017 | 104 |
1759683 | 1759683 | 2021-09-27 | Lawrence | Missouri | 29109 | 5011 | 102 |
1756435 | 1756435 | 2021-09-26 | Lawrence | Missouri | 29109 | 5002 | 102 |
1753187 | 1753187 | 2021-09-25 | Lawrence | Missouri | 29109 | 4999 | 102 |
1749939 | 1749939 | 2021-09-24 | Lawrence | Missouri | 29109 | 4993 | 102 |
1746689 | 1746689 | 2021-09-23 | Lawrence | Missouri | 29109 | 4983 | 102 |
1743440 | 1743440 | 2021-09-22 | Lawrence | Missouri | 29109 | 4966 | 102 |
1740191 | 1740191 | 2021-09-21 | Lawrence | Missouri | 29109 | 4949 | 102 |
1736942 | 1736942 | 2021-09-20 | Lawrence | Missouri | 29109 | 4937 | 101 |
1733692 | 1733692 | 2021-09-19 | Lawrence | Missouri | 29109 | 4933 | 101 |
1730442 | 1730442 | 2021-09-18 | Lawrence | Missouri | 29109 | 4928 | 101 |
1727192 | 1727192 | 2021-09-17 | Lawrence | Missouri | 29109 | 4922 | 101 |
1723943 | 1723943 | 2021-09-16 | Lawrence | Missouri | 29109 | 4916 | 101 |
1720694 | 1720694 | 2021-09-15 | Lawrence | Missouri | 29109 | 4907 | 101 |
1717446 | 1717446 | 2021-09-14 | Lawrence | Missouri | 29109 | 4900 | 101 |
1714198 | 1714198 | 2021-09-13 | Lawrence | Missouri | 29109 | 4895 | 100 |
1710952 | 1710952 | 2021-09-12 | Lawrence | Missouri | 29109 | 4889 | 100 |
1707705 | 1707705 | 2021-09-11 | Lawrence | Missouri | 29109 | 4885 | 100 |
1704458 | 1704458 | 2021-09-10 | Lawrence | Missouri | 29109 | 4880 | 100 |
1701208 | 1701208 | 2021-09-09 | Lawrence | Missouri | 29109 | 4874 | 100 |
1697959 | 1697959 | 2021-09-08 | Lawrence | Missouri | 29109 | 4871 | 100 |
1694711 | 1694711 | 2021-09-07 | Lawrence | Missouri | 29109 | 4865 | 97 |
1691462 | 1691462 | 2021-09-06 | Lawrence | Missouri | 29109 | 4859 | 97 |
1688212 | 1688212 | 2021-09-05 | Lawrence | Missouri | 29109 | 4857 | 97 |
1684962 | 1684962 | 2021-09-04 | Lawrence | Missouri | 29109 | 4855 | 97 |
1681711 | 1681711 | 2021-09-03 | Lawrence | Missouri | 29109 | 4848 | 97 |
1678463 | 1678463 | 2021-09-02 | Lawrence | Missouri | 29109 | 4833 | 97 |
1675215 | 1675215 | 2021-09-01 | Lawrence | Missouri | 29109 | 4825 | 97 |
1671967 | 1671967 | 2021-08-31 | Lawrence | Missouri | 29109 | 4809 | 97 |
1668720 | 1668720 | 2021-08-30 | Lawrence | Missouri | 29109 | 4809 | 96 |
1665473 | 1665473 | 2021-08-29 | Lawrence | Missouri | 29109 | 4802 | 96 |
1662225 | 1662225 | 2021-08-28 | Lawrence | Missouri | 29109 | 4802 | 96 |
1658977 | 1658977 | 2021-08-27 | Lawrence | Missouri | 29109 | 4783 | 96 |
1655728 | 1655728 | 2021-08-26 | Lawrence | Missouri | 29109 | 4777 | 96 |
1652481 | 1652481 | 2021-08-25 | Lawrence | Missouri | 29109 | 4768 | 96 |
1649233 | 1649233 | 2021-08-24 | Lawrence | Missouri | 29109 | 4756 | 96 |
1645984 | 1645984 | 2021-08-23 | Lawrence | Missouri | 29109 | 4742 | 96 |
1642735 | 1642735 | 2021-08-22 | Lawrence | Missouri | 29109 | 4734 | 96 |
1639485 | 1639485 | 2021-08-21 | Lawrence | Missouri | 29109 | 4731 | 96 |
1636235 | 1636235 | 2021-08-20 | Lawrence | Missouri | 29109 | 4719 | 96 |
1632985 | 1632985 | 2021-08-19 | Lawrence | Missouri | 29109 | 4698 | 96 |
1629738 | 1629738 | 2021-08-18 | Lawrence | Missouri | 29109 | 4669 | 96 |
1626491 | 1626491 | 2021-08-17 | Lawrence | Missouri | 29109 | 4645 | 96 |
1623244 | 1623244 | 2021-08-16 | Lawrence | Missouri | 29109 | 4640 | 95 |
1619997 | 1619997 | 2021-08-15 | Lawrence | Missouri | 29109 | 4631 | 95 |
1616749 | 1616749 | 2021-08-14 | Lawrence | Missouri | 29109 | 4628 | 95 |
1613501 | 1613501 | 2021-08-13 | Lawrence | Missouri | 29109 | 4605 | 95 |
1610252 | 1610252 | 2021-08-12 | Lawrence | Missouri | 29109 | 4582 | 95 |
1607004 | 1607004 | 2021-08-11 | Lawrence | Missouri | 29109 | 4566 | 95 |
1603755 | 1603755 | 2021-08-10 | Lawrence | Missouri | 29109 | 4549 | 95 |
1600506 | 1600506 | 2021-08-09 | Lawrence | Missouri | 29109 | 4538 | 94 |
1597258 | 1597258 | 2021-08-08 | Lawrence | Missouri | 29109 | 4530 | 94 |
1594009 | 1594009 | 2021-08-07 | Lawrence | Missouri | 29109 | 4511 | 94 |
1590760 | 1590760 | 2021-08-06 | Lawrence | Missouri | 29109 | 4503 | 94 |
1587511 | 1587511 | 2021-08-05 | Lawrence | Missouri | 29109 | 4481 | 94 |
1584260 | 1584260 | 2021-08-04 | Lawrence | Missouri | 29109 | 4448 | 94 |
1581011 | 1581011 | 2021-08-03 | Lawrence | Missouri | 29109 | 4411 | 94 |
1577762 | 1577762 | 2021-08-02 | Lawrence | Missouri | 29109 | 4407 | 91 |
1574514 | 1574514 | 2021-08-01 | Lawrence | Missouri | 29109 | 4395 | 91 |
1571266 | 1571266 | 2021-07-31 | Lawrence | Missouri | 29109 | 4378 | 91 |
1568018 | 1568018 | 2021-07-30 | Lawrence | Missouri | 29109 | 4358 | 91 |
1564770 | 1564770 | 2021-07-29 | Lawrence | Missouri | 29109 | 4304 | 91 |
1561522 | 1561522 | 2021-07-28 | Lawrence | Missouri | 29109 | 4279 | 91 |
1558274 | 1558274 | 2021-07-27 | Lawrence | Missouri | 29109 | 4267 | 91 |
1555027 | 1555027 | 2021-07-26 | Lawrence | Missouri | 29109 | 4247 | 90 |
1551780 | 1551780 | 2021-07-25 | Lawrence | Missouri | 29109 | 4236 | 90 |
1548533 | 1548533 | 2021-07-24 | Lawrence | Missouri | 29109 | 4220 | 90 |
1545286 | 1545286 | 2021-07-23 | Lawrence | Missouri | 29109 | 4198 | 90 |
1542038 | 1542038 | 2021-07-22 | Lawrence | Missouri | 29109 | 4168 | 90 |
1538791 | 1538791 | 2021-07-21 | Lawrence | Missouri | 29109 | 4124 | 90 |
1535544 | 1535544 | 2021-07-20 | Lawrence | Missouri | 29109 | 4097 | 90 |
1532296 | 1532296 | 2021-07-19 | Lawrence | Missouri | 29109 | 4076 | 89 |
1529049 | 1529049 | 2021-07-18 | Lawrence | Missouri | 29109 | 4058 | 89 |
1525802 | 1525802 | 2021-07-17 | Lawrence | Missouri | 29109 | 4044 | 89 |
1522555 | 1522555 | 2021-07-16 | Lawrence | Missouri | 29109 | 4017 | 89 |
1519306 | 1519306 | 2021-07-15 | Lawrence | Missouri | 29109 | 3983 | 89 |
1516059 | 1516059 | 2021-07-14 | Lawrence | Missouri | 29109 | 3958 | 89 |
1512813 | 1512813 | 2021-07-13 | Lawrence | Missouri | 29109 | 3923 | 89 |
1509566 | 1509566 | 2021-07-12 | Lawrence | Missouri | 29109 | 3903 | 89 |
1506320 | 1506320 | 2021-07-11 | Lawrence | Missouri | 29109 | 3903 | 89 |
1503074 | 1503074 | 2021-07-10 | Lawrence | Missouri | 29109 | 3888 | 89 |
1499828 | 1499828 | 2021-07-09 | Lawrence | Missouri | 29109 | 3858 | 89 |
1496582 | 1496582 | 2021-07-08 | Lawrence | Missouri | 29109 | 3840 | 89 |
1493335 | 1493335 | 2021-07-07 | Lawrence | Missouri | 29109 | 3825 | 89 |
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);