ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 29071 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840890 | 1840890 | 2021-10-22 | Franklin | Missouri | 29071 | 14361 | 219 |
1837641 | 1837641 | 2021-10-21 | Franklin | Missouri | 29071 | 14348 | 219 |
1834392 | 1834392 | 2021-10-20 | Franklin | Missouri | 29071 | 14324 | 219 |
1831143 | 1831143 | 2021-10-19 | Franklin | Missouri | 29071 | 14291 | 219 |
1827894 | 1827894 | 2021-10-18 | Franklin | Missouri | 29071 | 14262 | 214 |
1824645 | 1824645 | 2021-10-17 | Franklin | Missouri | 29071 | 14257 | 214 |
1821396 | 1821396 | 2021-10-16 | Franklin | Missouri | 29071 | 14230 | 214 |
1818147 | 1818147 | 2021-10-15 | Franklin | Missouri | 29071 | 14212 | 214 |
1814898 | 1814898 | 2021-10-14 | Franklin | Missouri | 29071 | 14184 | 214 |
1811650 | 1811650 | 2021-10-13 | Franklin | Missouri | 29071 | 14157 | 214 |
1808401 | 1808401 | 2021-10-12 | Franklin | Missouri | 29071 | 14132 | 213 |
1805150 | 1805150 | 2021-10-11 | Franklin | Missouri | 29071 | 14107 | 213 |
1801901 | 1801901 | 2021-10-10 | Franklin | Missouri | 29071 | 14094 | 213 |
1798652 | 1798652 | 2021-10-09 | Franklin | Missouri | 29071 | 14074 | 213 |
1795403 | 1795403 | 2021-10-08 | Franklin | Missouri | 29071 | 14053 | 213 |
1792154 | 1792154 | 2021-10-07 | Franklin | Missouri | 29071 | 14014 | 213 |
1788905 | 1788905 | 2021-10-06 | Franklin | Missouri | 29071 | 13990 | 213 |
1785657 | 1785657 | 2021-10-05 | Franklin | Missouri | 29071 | 13949 | 213 |
1782408 | 1782408 | 2021-10-04 | Franklin | Missouri | 29071 | 13939 | 210 |
1779158 | 1779158 | 2021-10-03 | Franklin | Missouri | 29071 | 13916 | 210 |
1775908 | 1775908 | 2021-10-02 | Franklin | Missouri | 29071 | 13893 | 210 |
1772658 | 1772658 | 2021-10-01 | Franklin | Missouri | 29071 | 13864 | 210 |
1769409 | 1769409 | 2021-09-30 | Franklin | Missouri | 29071 | 13818 | 210 |
1766160 | 1766160 | 2021-09-29 | Franklin | Missouri | 29071 | 13780 | 210 |
1762911 | 1762911 | 2021-09-28 | Franklin | Missouri | 29071 | 13737 | 210 |
1759662 | 1759662 | 2021-09-27 | Franklin | Missouri | 29071 | 13694 | 207 |
1756414 | 1756414 | 2021-09-26 | Franklin | Missouri | 29071 | 13676 | 207 |
1753166 | 1753166 | 2021-09-25 | Franklin | Missouri | 29071 | 13642 | 207 |
1749918 | 1749918 | 2021-09-24 | Franklin | Missouri | 29071 | 13599 | 207 |
1746668 | 1746668 | 2021-09-23 | Franklin | Missouri | 29071 | 13536 | 207 |
1743419 | 1743419 | 2021-09-22 | Franklin | Missouri | 29071 | 13492 | 207 |
1740170 | 1740170 | 2021-09-21 | Franklin | Missouri | 29071 | 13430 | 206 |
1736921 | 1736921 | 2021-09-20 | Franklin | Missouri | 29071 | 13396 | 198 |
1733671 | 1733671 | 2021-09-19 | Franklin | Missouri | 29071 | 13378 | 198 |
1730421 | 1730421 | 2021-09-18 | Franklin | Missouri | 29071 | 13346 | 198 |
1727171 | 1727171 | 2021-09-17 | Franklin | Missouri | 29071 | 13283 | 198 |
1723922 | 1723922 | 2021-09-16 | Franklin | Missouri | 29071 | 13227 | 198 |
1720673 | 1720673 | 2021-09-15 | Franklin | Missouri | 29071 | 13154 | 198 |
1717425 | 1717425 | 2021-09-14 | Franklin | Missouri | 29071 | 13108 | 198 |
1714177 | 1714177 | 2021-09-13 | Franklin | Missouri | 29071 | 13054 | 194 |
1710931 | 1710931 | 2021-09-12 | Franklin | Missouri | 29071 | 13035 | 194 |
1707684 | 1707684 | 2021-09-11 | Franklin | Missouri | 29071 | 13001 | 194 |
1704437 | 1704437 | 2021-09-10 | Franklin | Missouri | 29071 | 12922 | 194 |
1701187 | 1701187 | 2021-09-09 | Franklin | Missouri | 29071 | 12857 | 194 |
1697938 | 1697938 | 2021-09-08 | Franklin | Missouri | 29071 | 12773 | 194 |
1694690 | 1694690 | 2021-09-07 | Franklin | Missouri | 29071 | 12733 | 194 |
1691441 | 1691441 | 2021-09-06 | Franklin | Missouri | 29071 | 12714 | 194 |
1688191 | 1688191 | 2021-09-05 | Franklin | Missouri | 29071 | 12687 | 194 |
1684941 | 1684941 | 2021-09-04 | Franklin | Missouri | 29071 | 12667 | 194 |
1681690 | 1681690 | 2021-09-03 | Franklin | Missouri | 29071 | 12619 | 194 |
1678442 | 1678442 | 2021-09-02 | Franklin | Missouri | 29071 | 12572 | 194 |
1675194 | 1675194 | 2021-09-01 | Franklin | Missouri | 29071 | 12508 | 194 |
1671946 | 1671946 | 2021-08-31 | Franklin | Missouri | 29071 | 12448 | 194 |
1668699 | 1668699 | 2021-08-30 | Franklin | Missouri | 29071 | 12426 | 193 |
1665452 | 1665452 | 2021-08-29 | Franklin | Missouri | 29071 | 12389 | 193 |
1662204 | 1662204 | 2021-08-28 | Franklin | Missouri | 29071 | 12369 | 193 |
1658956 | 1658956 | 2021-08-27 | Franklin | Missouri | 29071 | 12336 | 193 |
1655707 | 1655707 | 2021-08-26 | Franklin | Missouri | 29071 | 12284 | 193 |
1652460 | 1652460 | 2021-08-25 | Franklin | Missouri | 29071 | 12236 | 193 |
1649212 | 1649212 | 2021-08-24 | Franklin | Missouri | 29071 | 12196 | 193 |
1645963 | 1645963 | 2021-08-23 | Franklin | Missouri | 29071 | 12159 | 190 |
1642714 | 1642714 | 2021-08-22 | Franklin | Missouri | 29071 | 12140 | 190 |
1639464 | 1639464 | 2021-08-21 | Franklin | Missouri | 29071 | 12108 | 190 |
1636214 | 1636214 | 2021-08-20 | Franklin | Missouri | 29071 | 12081 | 190 |
1632964 | 1632964 | 2021-08-19 | Franklin | Missouri | 29071 | 12042 | 190 |
1629717 | 1629717 | 2021-08-18 | Franklin | Missouri | 29071 | 12000 | 190 |
1626470 | 1626470 | 2021-08-17 | Franklin | Missouri | 29071 | 11952 | 190 |
1623223 | 1623223 | 2021-08-16 | Franklin | Missouri | 29071 | 11928 | 190 |
1619976 | 1619976 | 2021-08-15 | Franklin | Missouri | 29071 | 11911 | 190 |
1616728 | 1616728 | 2021-08-14 | Franklin | Missouri | 29071 | 11876 | 190 |
1613480 | 1613480 | 2021-08-13 | Franklin | Missouri | 29071 | 11842 | 190 |
1610231 | 1610231 | 2021-08-12 | Franklin | Missouri | 29071 | 11802 | 190 |
1606983 | 1606983 | 2021-08-11 | Franklin | Missouri | 29071 | 11755 | 190 |
1603734 | 1603734 | 2021-08-10 | Franklin | Missouri | 29071 | 11699 | 190 |
1600485 | 1600485 | 2021-08-09 | Franklin | Missouri | 29071 | 11680 | 188 |
1597237 | 1597237 | 2021-08-08 | Franklin | Missouri | 29071 | 11661 | 188 |
1593988 | 1593988 | 2021-08-07 | Franklin | Missouri | 29071 | 11636 | 188 |
1590739 | 1590739 | 2021-08-06 | Franklin | Missouri | 29071 | 11607 | 188 |
1587490 | 1587490 | 2021-08-05 | Franklin | Missouri | 29071 | 11551 | 188 |
1584239 | 1584239 | 2021-08-04 | Franklin | Missouri | 29071 | 11504 | 188 |
1580990 | 1580990 | 2021-08-03 | Franklin | Missouri | 29071 | 11474 | 188 |
1577741 | 1577741 | 2021-08-02 | Franklin | Missouri | 29071 | 11445 | 187 |
1574493 | 1574493 | 2021-08-01 | Franklin | Missouri | 29071 | 11428 | 187 |
1571245 | 1571245 | 2021-07-31 | Franklin | Missouri | 29071 | 11400 | 187 |
1567997 | 1567997 | 2021-07-30 | Franklin | Missouri | 29071 | 11368 | 187 |
1564749 | 1564749 | 2021-07-29 | Franklin | Missouri | 29071 | 11323 | 187 |
1561501 | 1561501 | 2021-07-28 | Franklin | Missouri | 29071 | 11296 | 187 |
1558253 | 1558253 | 2021-07-27 | Franklin | Missouri | 29071 | 11254 | 187 |
1555006 | 1555006 | 2021-07-26 | Franklin | Missouri | 29071 | 11226 | 187 |
1551759 | 1551759 | 2021-07-25 | Franklin | Missouri | 29071 | 11215 | 187 |
1548512 | 1548512 | 2021-07-24 | Franklin | Missouri | 29071 | 11196 | 187 |
1545265 | 1545265 | 2021-07-23 | Franklin | Missouri | 29071 | 11179 | 187 |
1542017 | 1542017 | 2021-07-22 | Franklin | Missouri | 29071 | 11150 | 187 |
1538770 | 1538770 | 2021-07-21 | Franklin | Missouri | 29071 | 11126 | 187 |
1535523 | 1535523 | 2021-07-20 | Franklin | Missouri | 29071 | 11103 | 187 |
1532275 | 1532275 | 2021-07-19 | Franklin | Missouri | 29071 | 11087 | 187 |
1529028 | 1529028 | 2021-07-18 | Franklin | Missouri | 29071 | 11074 | 187 |
1525781 | 1525781 | 2021-07-17 | Franklin | Missouri | 29071 | 11060 | 187 |
1522534 | 1522534 | 2021-07-16 | Franklin | Missouri | 29071 | 11044 | 187 |
1519285 | 1519285 | 2021-07-15 | Franklin | Missouri | 29071 | 11023 | 187 |
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);