ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 29051 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840880 | 1840880 | 2021-10-22 | Cole | Missouri | 29051 | 12842 | 171 |
1837631 | 1837631 | 2021-10-21 | Cole | Missouri | 29051 | 12834 | 171 |
1834382 | 1834382 | 2021-10-20 | Cole | Missouri | 29051 | 12820 | 171 |
1831133 | 1831133 | 2021-10-19 | Cole | Missouri | 29051 | 12806 | 171 |
1827884 | 1827884 | 2021-10-18 | Cole | Missouri | 29051 | 12795 | 170 |
1824635 | 1824635 | 2021-10-17 | Cole | Missouri | 29051 | 12793 | 170 |
1821386 | 1821386 | 2021-10-16 | Cole | Missouri | 29051 | 12785 | 170 |
1818137 | 1818137 | 2021-10-15 | Cole | Missouri | 29051 | 12776 | 170 |
1814888 | 1814888 | 2021-10-14 | Cole | Missouri | 29051 | 12767 | 170 |
1811640 | 1811640 | 2021-10-13 | Cole | Missouri | 29051 | 12759 | 170 |
1808391 | 1808391 | 2021-10-12 | Cole | Missouri | 29051 | 12753 | 169 |
1805140 | 1805140 | 2021-10-11 | Cole | Missouri | 29051 | 12744 | 169 |
1801891 | 1801891 | 2021-10-10 | Cole | Missouri | 29051 | 12737 | 169 |
1798642 | 1798642 | 2021-10-09 | Cole | Missouri | 29051 | 12733 | 169 |
1795393 | 1795393 | 2021-10-08 | Cole | Missouri | 29051 | 12724 | 169 |
1792144 | 1792144 | 2021-10-07 | Cole | Missouri | 29051 | 12713 | 169 |
1788895 | 1788895 | 2021-10-06 | Cole | Missouri | 29051 | 12698 | 169 |
1785647 | 1785647 | 2021-10-05 | Cole | Missouri | 29051 | 12686 | 169 |
1782398 | 1782398 | 2021-10-04 | Cole | Missouri | 29051 | 12674 | 168 |
1779148 | 1779148 | 2021-10-03 | Cole | Missouri | 29051 | 12672 | 168 |
1775898 | 1775898 | 2021-10-02 | Cole | Missouri | 29051 | 12669 | 168 |
1772648 | 1772648 | 2021-10-01 | Cole | Missouri | 29051 | 12645 | 168 |
1769399 | 1769399 | 2021-09-30 | Cole | Missouri | 29051 | 12627 | 168 |
1766150 | 1766150 | 2021-09-29 | Cole | Missouri | 29051 | 12611 | 168 |
1762901 | 1762901 | 2021-09-28 | Cole | Missouri | 29051 | 12585 | 168 |
1759652 | 1759652 | 2021-09-27 | Cole | Missouri | 29051 | 12532 | 165 |
1756404 | 1756404 | 2021-09-26 | Cole | Missouri | 29051 | 12524 | 165 |
1753156 | 1753156 | 2021-09-25 | Cole | Missouri | 29051 | 12517 | 165 |
1749908 | 1749908 | 2021-09-24 | Cole | Missouri | 29051 | 12498 | 165 |
1746658 | 1746658 | 2021-09-23 | Cole | Missouri | 29051 | 12487 | 165 |
1743409 | 1743409 | 2021-09-22 | Cole | Missouri | 29051 | 12475 | 165 |
1740160 | 1740160 | 2021-09-21 | Cole | Missouri | 29051 | 12451 | 165 |
1736911 | 1736911 | 2021-09-20 | Cole | Missouri | 29051 | 12434 | 162 |
1733661 | 1733661 | 2021-09-19 | Cole | Missouri | 29051 | 12427 | 162 |
1730411 | 1730411 | 2021-09-18 | Cole | Missouri | 29051 | 12416 | 162 |
1727161 | 1727161 | 2021-09-17 | Cole | Missouri | 29051 | 12391 | 162 |
1723912 | 1723912 | 2021-09-16 | Cole | Missouri | 29051 | 12371 | 162 |
1720663 | 1720663 | 2021-09-15 | Cole | Missouri | 29051 | 12357 | 162 |
1717415 | 1717415 | 2021-09-14 | Cole | Missouri | 29051 | 12325 | 162 |
1714167 | 1714167 | 2021-09-13 | Cole | Missouri | 29051 | 12302 | 160 |
1710921 | 1710921 | 2021-09-12 | Cole | Missouri | 29051 | 12287 | 160 |
1707674 | 1707674 | 2021-09-11 | Cole | Missouri | 29051 | 12275 | 160 |
1704427 | 1704427 | 2021-09-10 | Cole | Missouri | 29051 | 12241 | 160 |
1701177 | 1701177 | 2021-09-09 | Cole | Missouri | 29051 | 12207 | 160 |
1697928 | 1697928 | 2021-09-08 | Cole | Missouri | 29051 | 12175 | 160 |
1694680 | 1694680 | 2021-09-07 | Cole | Missouri | 29051 | 12140 | 153 |
1691431 | 1691431 | 2021-09-06 | Cole | Missouri | 29051 | 12129 | 153 |
1688181 | 1688181 | 2021-09-05 | Cole | Missouri | 29051 | 12119 | 153 |
1684931 | 1684931 | 2021-09-04 | Cole | Missouri | 29051 | 12106 | 153 |
1681680 | 1681680 | 2021-09-03 | Cole | Missouri | 29051 | 12077 | 153 |
1678432 | 1678432 | 2021-09-02 | Cole | Missouri | 29051 | 12047 | 153 |
1675184 | 1675184 | 2021-09-01 | Cole | Missouri | 29051 | 12017 | 154 |
1671936 | 1671936 | 2021-08-31 | Cole | Missouri | 29051 | 11978 | 154 |
1668689 | 1668689 | 2021-08-30 | Cole | Missouri | 29051 | 11959 | 147 |
1665442 | 1665442 | 2021-08-29 | Cole | Missouri | 29051 | 11934 | 147 |
1662194 | 1662194 | 2021-08-28 | Cole | Missouri | 29051 | 11922 | 147 |
1658946 | 1658946 | 2021-08-27 | Cole | Missouri | 29051 | 11886 | 147 |
1655697 | 1655697 | 2021-08-26 | Cole | Missouri | 29051 | 11861 | 147 |
1652450 | 1652450 | 2021-08-25 | Cole | Missouri | 29051 | 11835 | 147 |
1649202 | 1649202 | 2021-08-24 | Cole | Missouri | 29051 | 11792 | 147 |
1645953 | 1645953 | 2021-08-23 | Cole | Missouri | 29051 | 11750 | 141 |
1642704 | 1642704 | 2021-08-22 | Cole | Missouri | 29051 | 11744 | 141 |
1639454 | 1639454 | 2021-08-21 | Cole | Missouri | 29051 | 11725 | 141 |
1636204 | 1636204 | 2021-08-20 | Cole | Missouri | 29051 | 11705 | 141 |
1632954 | 1632954 | 2021-08-19 | Cole | Missouri | 29051 | 11666 | 141 |
1629707 | 1629707 | 2021-08-18 | Cole | Missouri | 29051 | 11594 | 141 |
1626460 | 1626460 | 2021-08-17 | Cole | Missouri | 29051 | 11558 | 142 |
1623213 | 1623213 | 2021-08-16 | Cole | Missouri | 29051 | 11483 | 139 |
1619966 | 1619966 | 2021-08-15 | Cole | Missouri | 29051 | 11475 | 139 |
1616718 | 1616718 | 2021-08-14 | Cole | Missouri | 29051 | 11461 | 139 |
1613470 | 1613470 | 2021-08-13 | Cole | Missouri | 29051 | 11429 | 139 |
1610221 | 1610221 | 2021-08-12 | Cole | Missouri | 29051 | 11377 | 139 |
1606973 | 1606973 | 2021-08-11 | Cole | Missouri | 29051 | 11330 | 139 |
1603724 | 1603724 | 2021-08-10 | Cole | Missouri | 29051 | 11265 | 139 |
1600475 | 1600475 | 2021-08-09 | Cole | Missouri | 29051 | 11196 | 134 |
1597227 | 1597227 | 2021-08-08 | Cole | Missouri | 29051 | 11184 | 134 |
1593978 | 1593978 | 2021-08-07 | Cole | Missouri | 29051 | 11165 | 134 |
1590729 | 1590729 | 2021-08-06 | Cole | Missouri | 29051 | 11116 | 134 |
1587480 | 1587480 | 2021-08-05 | Cole | Missouri | 29051 | 11064 | 134 |
1584229 | 1584229 | 2021-08-04 | Cole | Missouri | 29051 | 10976 | 133 |
1580980 | 1580980 | 2021-08-03 | Cole | Missouri | 29051 | 10864 | 133 |
1577731 | 1577731 | 2021-08-02 | Cole | Missouri | 29051 | 10843 | 133 |
1574483 | 1574483 | 2021-08-01 | Cole | Missouri | 29051 | 10822 | 133 |
1571235 | 1571235 | 2021-07-31 | Cole | Missouri | 29051 | 10800 | 133 |
1567987 | 1567987 | 2021-07-30 | Cole | Missouri | 29051 | 10744 | 133 |
1564739 | 1564739 | 2021-07-29 | Cole | Missouri | 29051 | 10642 | 133 |
1561491 | 1561491 | 2021-07-28 | Cole | Missouri | 29051 | 10597 | 133 |
1558243 | 1558243 | 2021-07-27 | Cole | Missouri | 29051 | 10534 | 133 |
1554996 | 1554996 | 2021-07-26 | Cole | Missouri | 29051 | 10440 | 130 |
1551749 | 1551749 | 2021-07-25 | Cole | Missouri | 29051 | 10431 | 130 |
1548502 | 1548502 | 2021-07-24 | Cole | Missouri | 29051 | 10408 | 130 |
1545255 | 1545255 | 2021-07-23 | Cole | Missouri | 29051 | 10355 | 130 |
1542007 | 1542007 | 2021-07-22 | Cole | Missouri | 29051 | 10331 | 130 |
1538760 | 1538760 | 2021-07-21 | Cole | Missouri | 29051 | 10252 | 130 |
1535513 | 1535513 | 2021-07-20 | Cole | Missouri | 29051 | 10149 | 130 |
1532265 | 1532265 | 2021-07-19 | Cole | Missouri | 29051 | 10104 | 130 |
1529018 | 1529018 | 2021-07-18 | Cole | Missouri | 29051 | 10093 | 130 |
1525771 | 1525771 | 2021-07-17 | Cole | Missouri | 29051 | 10075 | 130 |
1522524 | 1522524 | 2021-07-16 | Cole | Missouri | 29051 | 9849 | 130 |
1519275 | 1519275 | 2021-07-15 | Cole | Missouri | 29051 | 9755 | 130 |
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);