ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lafayette" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840910 | 1840910 | 2021-10-22 | Lafayette | Missouri | 29107 | 4613 | 73 |
1837661 | 1837661 | 2021-10-21 | Lafayette | Missouri | 29107 | 4602 | 73 |
1834412 | 1834412 | 2021-10-20 | Lafayette | Missouri | 29107 | 4598 | 73 |
1831163 | 1831163 | 2021-10-19 | Lafayette | Missouri | 29107 | 4588 | 73 |
1827914 | 1827914 | 2021-10-18 | Lafayette | Missouri | 29107 | 4576 | 73 |
1824665 | 1824665 | 2021-10-17 | Lafayette | Missouri | 29107 | 4573 | 73 |
1821416 | 1821416 | 2021-10-16 | Lafayette | Missouri | 29107 | 4570 | 73 |
1818167 | 1818167 | 2021-10-15 | Lafayette | Missouri | 29107 | 4564 | 73 |
1814918 | 1814918 | 2021-10-14 | Lafayette | Missouri | 29107 | 4548 | 73 |
1811670 | 1811670 | 2021-10-13 | Lafayette | Missouri | 29107 | 4534 | 72 |
1808421 | 1808421 | 2021-10-12 | Lafayette | Missouri | 29107 | 4528 | 71 |
1805170 | 1805170 | 2021-10-11 | Lafayette | Missouri | 29107 | 4524 | 71 |
1801921 | 1801921 | 2021-10-10 | Lafayette | Missouri | 29107 | 4519 | 71 |
1798672 | 1798672 | 2021-10-09 | Lafayette | Missouri | 29107 | 4513 | 71 |
1795423 | 1795423 | 2021-10-08 | Lafayette | Missouri | 29107 | 4506 | 71 |
1792174 | 1792174 | 2021-10-07 | Lafayette | Missouri | 29107 | 4500 | 71 |
1788925 | 1788925 | 2021-10-06 | Lafayette | Missouri | 29107 | 4491 | 71 |
1785677 | 1785677 | 2021-10-05 | Lafayette | Missouri | 29107 | 4477 | 71 |
1782428 | 1782428 | 2021-10-04 | Lafayette | Missouri | 29107 | 4473 | 71 |
1779178 | 1779178 | 2021-10-03 | Lafayette | Missouri | 29107 | 4471 | 71 |
1775928 | 1775928 | 2021-10-02 | Lafayette | Missouri | 29107 | 4466 | 71 |
1772678 | 1772678 | 2021-10-01 | Lafayette | Missouri | 29107 | 4462 | 71 |
1769429 | 1769429 | 2021-09-30 | Lafayette | Missouri | 29107 | 4457 | 71 |
1766180 | 1766180 | 2021-09-29 | Lafayette | Missouri | 29107 | 4442 | 71 |
1762931 | 1762931 | 2021-09-28 | Lafayette | Missouri | 29107 | 4432 | 71 |
1759682 | 1759682 | 2021-09-27 | Lafayette | Missouri | 29107 | 4426 | 70 |
1756434 | 1756434 | 2021-09-26 | Lafayette | Missouri | 29107 | 4423 | 70 |
1753186 | 1753186 | 2021-09-25 | Lafayette | Missouri | 29107 | 4417 | 70 |
1749938 | 1749938 | 2021-09-24 | Lafayette | Missouri | 29107 | 4404 | 70 |
1746688 | 1746688 | 2021-09-23 | Lafayette | Missouri | 29107 | 4392 | 70 |
1743439 | 1743439 | 2021-09-22 | Lafayette | Missouri | 29107 | 4381 | 70 |
1740190 | 1740190 | 2021-09-21 | Lafayette | Missouri | 29107 | 4377 | 70 |
1736941 | 1736941 | 2021-09-20 | Lafayette | Missouri | 29107 | 4365 | 68 |
1733691 | 1733691 | 2021-09-19 | Lafayette | Missouri | 29107 | 4357 | 68 |
1730441 | 1730441 | 2021-09-18 | Lafayette | Missouri | 29107 | 4351 | 68 |
1727191 | 1727191 | 2021-09-17 | Lafayette | Missouri | 29107 | 4339 | 68 |
1723942 | 1723942 | 2021-09-16 | Lafayette | Missouri | 29107 | 4318 | 68 |
1720693 | 1720693 | 2021-09-15 | Lafayette | Missouri | 29107 | 4298 | 68 |
1717445 | 1717445 | 2021-09-14 | Lafayette | Missouri | 29107 | 4289 | 68 |
1714197 | 1714197 | 2021-09-13 | Lafayette | Missouri | 29107 | 4281 | 67 |
1710951 | 1710951 | 2021-09-12 | Lafayette | Missouri | 29107 | 4278 | 67 |
1707704 | 1707704 | 2021-09-11 | Lafayette | Missouri | 29107 | 4267 | 67 |
1704457 | 1704457 | 2021-09-10 | Lafayette | Missouri | 29107 | 4247 | 66 |
1701207 | 1701207 | 2021-09-09 | Lafayette | Missouri | 29107 | 4219 | 63 |
1697958 | 1697958 | 2021-09-08 | Lafayette | Missouri | 29107 | 4210 | 63 |
1694710 | 1694710 | 2021-09-07 | Lafayette | Missouri | 29107 | 4196 | 63 |
1691461 | 1691461 | 2021-09-06 | Lafayette | Missouri | 29107 | 4186 | 63 |
1688211 | 1688211 | 2021-09-05 | Lafayette | Missouri | 29107 | 4176 | 63 |
1684961 | 1684961 | 2021-09-04 | Lafayette | Missouri | 29107 | 4164 | 63 |
1681710 | 1681710 | 2021-09-03 | Lafayette | Missouri | 29107 | 4153 | 63 |
1678462 | 1678462 | 2021-09-02 | Lafayette | Missouri | 29107 | 4133 | 63 |
1675214 | 1675214 | 2021-09-01 | Lafayette | Missouri | 29107 | 4115 | 62 |
1671966 | 1671966 | 2021-08-31 | Lafayette | Missouri | 29107 | 4098 | 62 |
1668719 | 1668719 | 2021-08-30 | Lafayette | Missouri | 29107 | 4088 | 62 |
1665472 | 1665472 | 2021-08-29 | Lafayette | Missouri | 29107 | 4078 | 62 |
1662224 | 1662224 | 2021-08-28 | Lafayette | Missouri | 29107 | 4065 | 62 |
1658976 | 1658976 | 2021-08-27 | Lafayette | Missouri | 29107 | 4044 | 62 |
1655727 | 1655727 | 2021-08-26 | Lafayette | Missouri | 29107 | 4021 | 62 |
1652480 | 1652480 | 2021-08-25 | Lafayette | Missouri | 29107 | 4005 | 62 |
1649232 | 1649232 | 2021-08-24 | Lafayette | Missouri | 29107 | 3989 | 62 |
1645983 | 1645983 | 2021-08-23 | Lafayette | Missouri | 29107 | 3980 | 62 |
1642734 | 1642734 | 2021-08-22 | Lafayette | Missouri | 29107 | 3960 | 62 |
1639484 | 1639484 | 2021-08-21 | Lafayette | Missouri | 29107 | 3943 | 62 |
1636234 | 1636234 | 2021-08-20 | Lafayette | Missouri | 29107 | 3926 | 62 |
1632984 | 1632984 | 2021-08-19 | Lafayette | Missouri | 29107 | 3905 | 62 |
1629737 | 1629737 | 2021-08-18 | Lafayette | Missouri | 29107 | 3878 | 61 |
1626490 | 1626490 | 2021-08-17 | Lafayette | Missouri | 29107 | 3863 | 61 |
1623243 | 1623243 | 2021-08-16 | Lafayette | Missouri | 29107 | 3851 | 59 |
1619996 | 1619996 | 2021-08-15 | Lafayette | Missouri | 29107 | 3840 | 59 |
1616748 | 1616748 | 2021-08-14 | Lafayette | Missouri | 29107 | 3812 | 59 |
1613500 | 1613500 | 2021-08-13 | Lafayette | Missouri | 29107 | 3777 | 59 |
1610251 | 1610251 | 2021-08-12 | Lafayette | Missouri | 29107 | 3755 | 59 |
1607003 | 1607003 | 2021-08-11 | Lafayette | Missouri | 29107 | 3711 | 59 |
1603754 | 1603754 | 2021-08-10 | Lafayette | Missouri | 29107 | 3689 | 59 |
1600505 | 1600505 | 2021-08-09 | Lafayette | Missouri | 29107 | 3674 | 59 |
1597257 | 1597257 | 2021-08-08 | Lafayette | Missouri | 29107 | 3663 | 59 |
1594008 | 1594008 | 2021-08-07 | Lafayette | Missouri | 29107 | 3650 | 59 |
1590759 | 1590759 | 2021-08-06 | Lafayette | Missouri | 29107 | 3622 | 59 |
1587510 | 1587510 | 2021-08-05 | Lafayette | Missouri | 29107 | 3599 | 59 |
1584259 | 1584259 | 2021-08-04 | Lafayette | Missouri | 29107 | 3571 | 59 |
1581010 | 1581010 | 2021-08-03 | Lafayette | Missouri | 29107 | 3548 | 58 |
1577761 | 1577761 | 2021-08-02 | Lafayette | Missouri | 29107 | 3515 | 58 |
1574513 | 1574513 | 2021-08-01 | Lafayette | Missouri | 29107 | 3511 | 58 |
1571265 | 1571265 | 2021-07-31 | Lafayette | Missouri | 29107 | 3490 | 58 |
1568017 | 1568017 | 2021-07-30 | Lafayette | Missouri | 29107 | 3476 | 58 |
1564769 | 1564769 | 2021-07-29 | Lafayette | Missouri | 29107 | 3450 | 58 |
1561521 | 1561521 | 2021-07-28 | Lafayette | Missouri | 29107 | 3432 | 58 |
1558273 | 1558273 | 2021-07-27 | Lafayette | Missouri | 29107 | 3418 | 57 |
1555026 | 1555026 | 2021-07-26 | Lafayette | Missouri | 29107 | 3403 | 57 |
1551779 | 1551779 | 2021-07-25 | Lafayette | Missouri | 29107 | 3397 | 57 |
1548532 | 1548532 | 2021-07-24 | Lafayette | Missouri | 29107 | 3379 | 57 |
1545285 | 1545285 | 2021-07-23 | Lafayette | Missouri | 29107 | 3367 | 57 |
1542037 | 1542037 | 2021-07-22 | Lafayette | Missouri | 29107 | 3355 | 57 |
1538790 | 1538790 | 2021-07-21 | Lafayette | Missouri | 29107 | 3334 | 57 |
1535543 | 1535543 | 2021-07-20 | Lafayette | Missouri | 29107 | 3327 | 57 |
1532295 | 1532295 | 2021-07-19 | Lafayette | Missouri | 29107 | 3318 | 57 |
1529048 | 1529048 | 2021-07-18 | Lafayette | Missouri | 29107 | 3313 | 57 |
1525801 | 1525801 | 2021-07-17 | Lafayette | Missouri | 29107 | 3308 | 57 |
1522554 | 1522554 | 2021-07-16 | Lafayette | Missouri | 29107 | 3298 | 57 |
1519305 | 1519305 | 2021-07-15 | Lafayette | Missouri | 29107 | 3284 | 57 |
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);