ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29201 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840951 | 1840951 | 2021-10-22 | Scott | Missouri | 29201 | 7137 | 113 |
1837702 | 1837702 | 2021-10-21 | Scott | Missouri | 29201 | 7132 | 113 |
1834453 | 1834453 | 2021-10-20 | Scott | Missouri | 29201 | 7126 | 113 |
1831204 | 1831204 | 2021-10-19 | Scott | Missouri | 29201 | 7118 | 111 |
1827955 | 1827955 | 2021-10-18 | Scott | Missouri | 29201 | 7099 | 111 |
1824706 | 1824706 | 2021-10-17 | Scott | Missouri | 29201 | 7099 | 111 |
1821457 | 1821457 | 2021-10-16 | Scott | Missouri | 29201 | 7092 | 111 |
1818208 | 1818208 | 2021-10-15 | Scott | Missouri | 29201 | 7082 | 111 |
1814959 | 1814959 | 2021-10-14 | Scott | Missouri | 29201 | 7068 | 111 |
1811711 | 1811711 | 2021-10-13 | Scott | Missouri | 29201 | 7051 | 111 |
1808462 | 1808462 | 2021-10-12 | Scott | Missouri | 29201 | 7032 | 111 |
1805211 | 1805211 | 2021-10-11 | Scott | Missouri | 29201 | 7031 | 111 |
1801962 | 1801962 | 2021-10-10 | Scott | Missouri | 29201 | 7027 | 111 |
1798713 | 1798713 | 2021-10-09 | Scott | Missouri | 29201 | 7023 | 111 |
1795464 | 1795464 | 2021-10-08 | Scott | Missouri | 29201 | 7014 | 111 |
1792215 | 1792215 | 2021-10-07 | Scott | Missouri | 29201 | 6992 | 111 |
1788966 | 1788966 | 2021-10-06 | Scott | Missouri | 29201 | 6971 | 111 |
1785718 | 1785718 | 2021-10-05 | Scott | Missouri | 29201 | 6946 | 111 |
1782469 | 1782469 | 2021-10-04 | Scott | Missouri | 29201 | 6938 | 110 |
1779219 | 1779219 | 2021-10-03 | Scott | Missouri | 29201 | 6936 | 110 |
1775969 | 1775969 | 2021-10-02 | Scott | Missouri | 29201 | 6933 | 110 |
1772719 | 1772719 | 2021-10-01 | Scott | Missouri | 29201 | 6921 | 110 |
1769470 | 1769470 | 2021-09-30 | Scott | Missouri | 29201 | 6902 | 110 |
1766221 | 1766221 | 2021-09-29 | Scott | Missouri | 29201 | 6871 | 110 |
1762972 | 1762972 | 2021-09-28 | Scott | Missouri | 29201 | 6845 | 110 |
1759723 | 1759723 | 2021-09-27 | Scott | Missouri | 29201 | 6822 | 107 |
1756475 | 1756475 | 2021-09-26 | Scott | Missouri | 29201 | 6823 | 107 |
1753227 | 1753227 | 2021-09-25 | Scott | Missouri | 29201 | 6820 | 107 |
1749979 | 1749979 | 2021-09-24 | Scott | Missouri | 29201 | 6809 | 107 |
1746729 | 1746729 | 2021-09-23 | Scott | Missouri | 29201 | 6796 | 108 |
1743480 | 1743480 | 2021-09-22 | Scott | Missouri | 29201 | 6757 | 103 |
1740231 | 1740231 | 2021-09-21 | Scott | Missouri | 29201 | 6732 | 103 |
1736982 | 1736982 | 2021-09-20 | Scott | Missouri | 29201 | 6682 | 100 |
1733732 | 1733732 | 2021-09-19 | Scott | Missouri | 29201 | 6654 | 100 |
1730482 | 1730482 | 2021-09-18 | Scott | Missouri | 29201 | 6650 | 100 |
1727232 | 1727232 | 2021-09-17 | Scott | Missouri | 29201 | 6602 | 100 |
1723983 | 1723983 | 2021-09-16 | Scott | Missouri | 29201 | 6553 | 99 |
1720734 | 1720734 | 2021-09-15 | Scott | Missouri | 29201 | 6494 | 99 |
1717486 | 1717486 | 2021-09-14 | Scott | Missouri | 29201 | 6437 | 99 |
1714238 | 1714238 | 2021-09-13 | Scott | Missouri | 29201 | 6413 | 95 |
1710992 | 1710992 | 2021-09-12 | Scott | Missouri | 29201 | 6391 | 95 |
1707745 | 1707745 | 2021-09-11 | Scott | Missouri | 29201 | 6376 | 95 |
1704498 | 1704498 | 2021-09-10 | Scott | Missouri | 29201 | 6297 | 95 |
1701248 | 1701248 | 2021-09-09 | Scott | Missouri | 29201 | 6219 | 94 |
1697999 | 1697999 | 2021-09-08 | Scott | Missouri | 29201 | 6187 | 94 |
1694751 | 1694751 | 2021-09-07 | Scott | Missouri | 29201 | 6136 | 94 |
1691502 | 1691502 | 2021-09-06 | Scott | Missouri | 29201 | 6131 | 94 |
1688252 | 1688252 | 2021-09-05 | Scott | Missouri | 29201 | 6104 | 94 |
1685002 | 1685002 | 2021-09-04 | Scott | Missouri | 29201 | 6098 | 94 |
1681751 | 1681751 | 2021-09-03 | Scott | Missouri | 29201 | 6024 | 94 |
1678503 | 1678503 | 2021-09-02 | Scott | Missouri | 29201 | 5984 | 94 |
1675255 | 1675255 | 2021-09-01 | Scott | Missouri | 29201 | 5925 | 94 |
1672007 | 1672007 | 2021-08-31 | Scott | Missouri | 29201 | 5841 | 94 |
1668760 | 1668760 | 2021-08-30 | Scott | Missouri | 29201 | 5814 | 92 |
1665513 | 1665513 | 2021-08-29 | Scott | Missouri | 29201 | 5806 | 92 |
1662265 | 1662265 | 2021-08-28 | Scott | Missouri | 29201 | 5800 | 92 |
1659017 | 1659017 | 2021-08-27 | Scott | Missouri | 29201 | 5746 | 90 |
1655768 | 1655768 | 2021-08-26 | Scott | Missouri | 29201 | 5681 | 90 |
1652521 | 1652521 | 2021-08-25 | Scott | Missouri | 29201 | 5605 | 90 |
1649273 | 1649273 | 2021-08-24 | Scott | Missouri | 29201 | 5551 | 90 |
1646024 | 1646024 | 2021-08-23 | Scott | Missouri | 29201 | 5505 | 90 |
1642775 | 1642775 | 2021-08-22 | Scott | Missouri | 29201 | 5494 | 90 |
1639525 | 1639525 | 2021-08-21 | Scott | Missouri | 29201 | 5471 | 90 |
1636275 | 1636275 | 2021-08-20 | Scott | Missouri | 29201 | 5427 | 90 |
1633025 | 1633025 | 2021-08-19 | Scott | Missouri | 29201 | 5398 | 90 |
1629778 | 1629778 | 2021-08-18 | Scott | Missouri | 29201 | 5354 | 90 |
1626531 | 1626531 | 2021-08-17 | Scott | Missouri | 29201 | 5301 | 90 |
1623284 | 1623284 | 2021-08-16 | Scott | Missouri | 29201 | 5274 | 90 |
1620037 | 1620037 | 2021-08-15 | Scott | Missouri | 29201 | 5270 | 90 |
1616789 | 1616789 | 2021-08-14 | Scott | Missouri | 29201 | 5262 | 90 |
1613541 | 1613541 | 2021-08-13 | Scott | Missouri | 29201 | 5227 | 90 |
1610292 | 1610292 | 2021-08-12 | Scott | Missouri | 29201 | 5194 | 90 |
1607044 | 1607044 | 2021-08-11 | Scott | Missouri | 29201 | 5157 | 89 |
1603795 | 1603795 | 2021-08-10 | Scott | Missouri | 29201 | 5113 | 89 |
1600546 | 1600546 | 2021-08-09 | Scott | Missouri | 29201 | 5099 | 89 |
1597298 | 1597298 | 2021-08-08 | Scott | Missouri | 29201 | 5090 | 89 |
1594049 | 1594049 | 2021-08-07 | Scott | Missouri | 29201 | 5052 | 89 |
1590800 | 1590800 | 2021-08-06 | Scott | Missouri | 29201 | 5034 | 89 |
1587551 | 1587551 | 2021-08-05 | Scott | Missouri | 29201 | 5015 | 89 |
1584300 | 1584300 | 2021-08-04 | Scott | Missouri | 29201 | 4998 | 89 |
1581051 | 1581051 | 2021-08-03 | Scott | Missouri | 29201 | 4972 | 88 |
1577802 | 1577802 | 2021-08-02 | Scott | Missouri | 29201 | 4953 | 88 |
1574554 | 1574554 | 2021-08-01 | Scott | Missouri | 29201 | 4950 | 88 |
1571306 | 1571306 | 2021-07-31 | Scott | Missouri | 29201 | 4940 | 88 |
1568058 | 1568058 | 2021-07-30 | Scott | Missouri | 29201 | 4918 | 88 |
1564810 | 1564810 | 2021-07-29 | Scott | Missouri | 29201 | 4896 | 88 |
1561562 | 1561562 | 2021-07-28 | Scott | Missouri | 29201 | 4883 | 88 |
1558314 | 1558314 | 2021-07-27 | Scott | Missouri | 29201 | 4851 | 88 |
1555067 | 1555067 | 2021-07-26 | Scott | Missouri | 29201 | 4848 | 88 |
1551820 | 1551820 | 2021-07-25 | Scott | Missouri | 29201 | 4842 | 88 |
1548573 | 1548573 | 2021-07-24 | Scott | Missouri | 29201 | 4842 | 88 |
1545326 | 1545326 | 2021-07-23 | Scott | Missouri | 29201 | 4834 | 88 |
1542078 | 1542078 | 2021-07-22 | Scott | Missouri | 29201 | 4824 | 88 |
1538831 | 1538831 | 2021-07-21 | Scott | Missouri | 29201 | 4812 | 88 |
1535584 | 1535584 | 2021-07-20 | Scott | Missouri | 29201 | 4803 | 88 |
1532336 | 1532336 | 2021-07-19 | Scott | Missouri | 29201 | 4794 | 88 |
1529089 | 1529089 | 2021-07-18 | Scott | Missouri | 29201 | 4793 | 88 |
1525842 | 1525842 | 2021-07-17 | Scott | Missouri | 29201 | 4787 | 88 |
1522595 | 1522595 | 2021-07-16 | Scott | Missouri | 29201 | 4777 | 88 |
1519346 | 1519346 | 2021-07-15 | Scott | Missouri | 29201 | 4777 | 88 |
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);