ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29069 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840889 | 1840889 | 2021-10-22 | Dunklin | Missouri | 29069 | 4318 | 61 |
1837640 | 1837640 | 2021-10-21 | Dunklin | Missouri | 29069 | 4317 | 61 |
1834391 | 1834391 | 2021-10-20 | Dunklin | Missouri | 29069 | 4310 | 61 |
1831142 | 1831142 | 2021-10-19 | Dunklin | Missouri | 29069 | 4296 | 60 |
1827893 | 1827893 | 2021-10-18 | Dunklin | Missouri | 29069 | 4285 | 60 |
1824644 | 1824644 | 2021-10-17 | Dunklin | Missouri | 29069 | 4284 | 60 |
1821395 | 1821395 | 2021-10-16 | Dunklin | Missouri | 29069 | 4283 | 60 |
1818146 | 1818146 | 2021-10-15 | Dunklin | Missouri | 29069 | 4276 | 60 |
1814897 | 1814897 | 2021-10-14 | Dunklin | Missouri | 29069 | 4262 | 60 |
1811649 | 1811649 | 2021-10-13 | Dunklin | Missouri | 29069 | 4260 | 60 |
1808400 | 1808400 | 2021-10-12 | Dunklin | Missouri | 29069 | 4246 | 58 |
1805149 | 1805149 | 2021-10-11 | Dunklin | Missouri | 29069 | 4240 | 58 |
1801900 | 1801900 | 2021-10-10 | Dunklin | Missouri | 29069 | 4237 | 58 |
1798651 | 1798651 | 2021-10-09 | Dunklin | Missouri | 29069 | 4235 | 58 |
1795402 | 1795402 | 2021-10-08 | Dunklin | Missouri | 29069 | 4224 | 58 |
1792153 | 1792153 | 2021-10-07 | Dunklin | Missouri | 29069 | 4216 | 58 |
1788904 | 1788904 | 2021-10-06 | Dunklin | Missouri | 29069 | 4203 | 58 |
1785656 | 1785656 | 2021-10-05 | Dunklin | Missouri | 29069 | 4193 | 58 |
1782407 | 1782407 | 2021-10-04 | Dunklin | Missouri | 29069 | 4194 | 58 |
1779157 | 1779157 | 2021-10-03 | Dunklin | Missouri | 29069 | 4194 | 58 |
1775907 | 1775907 | 2021-10-02 | Dunklin | Missouri | 29069 | 4191 | 58 |
1772657 | 1772657 | 2021-10-01 | Dunklin | Missouri | 29069 | 4187 | 58 |
1769408 | 1769408 | 2021-09-30 | Dunklin | Missouri | 29069 | 4185 | 58 |
1766159 | 1766159 | 2021-09-29 | Dunklin | Missouri | 29069 | 4174 | 58 |
1762910 | 1762910 | 2021-09-28 | Dunklin | Missouri | 29069 | 4158 | 58 |
1759661 | 1759661 | 2021-09-27 | Dunklin | Missouri | 29069 | 4147 | 58 |
1756413 | 1756413 | 2021-09-26 | Dunklin | Missouri | 29069 | 4139 | 58 |
1753165 | 1753165 | 2021-09-25 | Dunklin | Missouri | 29069 | 4128 | 58 |
1749917 | 1749917 | 2021-09-24 | Dunklin | Missouri | 29069 | 4110 | 58 |
1746667 | 1746667 | 2021-09-23 | Dunklin | Missouri | 29069 | 4103 | 58 |
1743418 | 1743418 | 2021-09-22 | Dunklin | Missouri | 29069 | 4097 | 58 |
1740169 | 1740169 | 2021-09-21 | Dunklin | Missouri | 29069 | 4093 | 58 |
1736920 | 1736920 | 2021-09-20 | Dunklin | Missouri | 29069 | 4071 | 57 |
1733670 | 1733670 | 2021-09-19 | Dunklin | Missouri | 29069 | 4066 | 57 |
1730420 | 1730420 | 2021-09-18 | Dunklin | Missouri | 29069 | 4058 | 57 |
1727170 | 1727170 | 2021-09-17 | Dunklin | Missouri | 29069 | 4009 | 57 |
1723921 | 1723921 | 2021-09-16 | Dunklin | Missouri | 29069 | 3990 | 57 |
1720672 | 1720672 | 2021-09-15 | Dunklin | Missouri | 29069 | 3968 | 57 |
1717424 | 1717424 | 2021-09-14 | Dunklin | Missouri | 29069 | 3953 | 57 |
1714176 | 1714176 | 2021-09-13 | Dunklin | Missouri | 29069 | 3938 | 55 |
1710930 | 1710930 | 2021-09-12 | Dunklin | Missouri | 29069 | 3926 | 55 |
1707683 | 1707683 | 2021-09-11 | Dunklin | Missouri | 29069 | 3916 | 55 |
1704436 | 1704436 | 2021-09-10 | Dunklin | Missouri | 29069 | 3883 | 55 |
1701186 | 1701186 | 2021-09-09 | Dunklin | Missouri | 29069 | 3845 | 55 |
1697937 | 1697937 | 2021-09-08 | Dunklin | Missouri | 29069 | 3828 | 55 |
1694689 | 1694689 | 2021-09-07 | Dunklin | Missouri | 29069 | 3801 | 55 |
1691440 | 1691440 | 2021-09-06 | Dunklin | Missouri | 29069 | 3799 | 55 |
1688190 | 1688190 | 2021-09-05 | Dunklin | Missouri | 29069 | 3793 | 55 |
1684940 | 1684940 | 2021-09-04 | Dunklin | Missouri | 29069 | 3782 | 55 |
1681689 | 1681689 | 2021-09-03 | Dunklin | Missouri | 29069 | 3756 | 55 |
1678441 | 1678441 | 2021-09-02 | Dunklin | Missouri | 29069 | 3737 | 55 |
1675193 | 1675193 | 2021-09-01 | Dunklin | Missouri | 29069 | 3721 | 55 |
1671945 | 1671945 | 2021-08-31 | Dunklin | Missouri | 29069 | 3697 | 54 |
1668698 | 1668698 | 2021-08-30 | Dunklin | Missouri | 29069 | 3692 | 52 |
1665451 | 1665451 | 2021-08-29 | Dunklin | Missouri | 29069 | 3679 | 52 |
1662203 | 1662203 | 2021-08-28 | Dunklin | Missouri | 29069 | 3662 | 52 |
1658955 | 1658955 | 2021-08-27 | Dunklin | Missouri | 29069 | 3646 | 52 |
1655706 | 1655706 | 2021-08-26 | Dunklin | Missouri | 29069 | 3632 | 52 |
1652459 | 1652459 | 2021-08-25 | Dunklin | Missouri | 29069 | 3622 | 52 |
1649211 | 1649211 | 2021-08-24 | Dunklin | Missouri | 29069 | 3615 | 52 |
1645962 | 1645962 | 2021-08-23 | Dunklin | Missouri | 29069 | 3591 | 51 |
1642713 | 1642713 | 2021-08-22 | Dunklin | Missouri | 29069 | 3582 | 51 |
1639463 | 1639463 | 2021-08-21 | Dunklin | Missouri | 29069 | 3574 | 51 |
1636213 | 1636213 | 2021-08-20 | Dunklin | Missouri | 29069 | 3559 | 51 |
1632963 | 1632963 | 2021-08-19 | Dunklin | Missouri | 29069 | 3542 | 51 |
1629716 | 1629716 | 2021-08-18 | Dunklin | Missouri | 29069 | 3517 | 51 |
1626469 | 1626469 | 2021-08-17 | Dunklin | Missouri | 29069 | 3509 | 51 |
1623222 | 1623222 | 2021-08-16 | Dunklin | Missouri | 29069 | 3504 | 50 |
1619975 | 1619975 | 2021-08-15 | Dunklin | Missouri | 29069 | 3496 | 50 |
1616727 | 1616727 | 2021-08-14 | Dunklin | Missouri | 29069 | 3487 | 50 |
1613479 | 1613479 | 2021-08-13 | Dunklin | Missouri | 29069 | 3465 | 50 |
1610230 | 1610230 | 2021-08-12 | Dunklin | Missouri | 29069 | 3449 | 50 |
1606982 | 1606982 | 2021-08-11 | Dunklin | Missouri | 29069 | 3425 | 50 |
1603733 | 1603733 | 2021-08-10 | Dunklin | Missouri | 29069 | 3411 | 50 |
1600484 | 1600484 | 2021-08-09 | Dunklin | Missouri | 29069 | 3405 | 50 |
1597236 | 1597236 | 2021-08-08 | Dunklin | Missouri | 29069 | 3399 | 50 |
1593987 | 1593987 | 2021-08-07 | Dunklin | Missouri | 29069 | 3392 | 50 |
1590738 | 1590738 | 2021-08-06 | Dunklin | Missouri | 29069 | 3367 | 50 |
1587489 | 1587489 | 2021-08-05 | Dunklin | Missouri | 29069 | 3358 | 50 |
1584238 | 1584238 | 2021-08-04 | Dunklin | Missouri | 29069 | 3333 | 50 |
1580989 | 1580989 | 2021-08-03 | Dunklin | Missouri | 29069 | 3309 | 50 |
1577740 | 1577740 | 2021-08-02 | Dunklin | Missouri | 29069 | 3296 | 50 |
1574492 | 1574492 | 2021-08-01 | Dunklin | Missouri | 29069 | 3291 | 50 |
1571244 | 1571244 | 2021-07-31 | Dunklin | Missouri | 29069 | 3288 | 50 |
1567996 | 1567996 | 2021-07-30 | Dunklin | Missouri | 29069 | 3279 | 50 |
1564748 | 1564748 | 2021-07-29 | Dunklin | Missouri | 29069 | 3267 | 50 |
1561500 | 1561500 | 2021-07-28 | Dunklin | Missouri | 29069 | 3261 | 50 |
1558252 | 1558252 | 2021-07-27 | Dunklin | Missouri | 29069 | 3245 | 50 |
1555005 | 1555005 | 2021-07-26 | Dunklin | Missouri | 29069 | 3239 | 50 |
1551758 | 1551758 | 2021-07-25 | Dunklin | Missouri | 29069 | 3236 | 50 |
1548511 | 1548511 | 2021-07-24 | Dunklin | Missouri | 29069 | 3231 | 50 |
1545264 | 1545264 | 2021-07-23 | Dunklin | Missouri | 29069 | 3229 | 50 |
1542016 | 1542016 | 2021-07-22 | Dunklin | Missouri | 29069 | 3216 | 50 |
1538769 | 1538769 | 2021-07-21 | Dunklin | Missouri | 29069 | 3196 | 50 |
1535522 | 1535522 | 2021-07-20 | Dunklin | Missouri | 29069 | 3189 | 50 |
1532274 | 1532274 | 2021-07-19 | Dunklin | Missouri | 29069 | 3184 | 50 |
1529027 | 1529027 | 2021-07-18 | Dunklin | Missouri | 29069 | 3181 | 50 |
1525780 | 1525780 | 2021-07-17 | Dunklin | Missouri | 29069 | 3181 | 50 |
1522533 | 1522533 | 2021-07-16 | Dunklin | Missouri | 29069 | 3174 | 50 |
1519284 | 1519284 | 2021-07-15 | Dunklin | Missouri | 29069 | 3170 | 50 |
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);