ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Clay" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840878 | 1840878 | 2021-10-22 | Clay | Missouri | 29047 | 14847 | 215 |
1837629 | 1837629 | 2021-10-21 | Clay | Missouri | 29047 | 14817 | 215 |
1834380 | 1834380 | 2021-10-20 | Clay | Missouri | 29047 | 14790 | 215 |
1831131 | 1831131 | 2021-10-19 | Clay | Missouri | 29047 | 14763 | 215 |
1827882 | 1827882 | 2021-10-18 | Clay | Missouri | 29047 | 14743 | 214 |
1824633 | 1824633 | 2021-10-17 | Clay | Missouri | 29047 | 14731 | 214 |
1821384 | 1821384 | 2021-10-16 | Clay | Missouri | 29047 | 14715 | 214 |
1818135 | 1818135 | 2021-10-15 | Clay | Missouri | 29047 | 14700 | 214 |
1814886 | 1814886 | 2021-10-14 | Clay | Missouri | 29047 | 14671 | 214 |
1811638 | 1811638 | 2021-10-13 | Clay | Missouri | 29047 | 14642 | 214 |
1808389 | 1808389 | 2021-10-12 | Clay | Missouri | 29047 | 14601 | 209 |
1805138 | 1805138 | 2021-10-11 | Clay | Missouri | 29047 | 14565 | 209 |
1801889 | 1801889 | 2021-10-10 | Clay | Missouri | 29047 | 14549 | 209 |
1798640 | 1798640 | 2021-10-09 | Clay | Missouri | 29047 | 14534 | 209 |
1795391 | 1795391 | 2021-10-08 | Clay | Missouri | 29047 | 14508 | 209 |
1792142 | 1792142 | 2021-10-07 | Clay | Missouri | 29047 | 14471 | 208 |
1788893 | 1788893 | 2021-10-06 | Clay | Missouri | 29047 | 14428 | 209 |
1785645 | 1785645 | 2021-10-05 | Clay | Missouri | 29047 | 14387 | 209 |
1782396 | 1782396 | 2021-10-04 | Clay | Missouri | 29047 | 14363 | 206 |
1779146 | 1779146 | 2021-10-03 | Clay | Missouri | 29047 | 14349 | 206 |
1775896 | 1775896 | 2021-10-02 | Clay | Missouri | 29047 | 14321 | 206 |
1772646 | 1772646 | 2021-10-01 | Clay | Missouri | 29047 | 14286 | 206 |
1769397 | 1769397 | 2021-09-30 | Clay | Missouri | 29047 | 14198 | 205 |
1766148 | 1766148 | 2021-09-29 | Clay | Missouri | 29047 | 14152 | 205 |
1762899 | 1762899 | 2021-09-28 | Clay | Missouri | 29047 | 14095 | 204 |
1759650 | 1759650 | 2021-09-27 | Clay | Missouri | 29047 | 14055 | 199 |
1756402 | 1756402 | 2021-09-26 | Clay | Missouri | 29047 | 14037 | 199 |
1753154 | 1753154 | 2021-09-25 | Clay | Missouri | 29047 | 14004 | 199 |
1749906 | 1749906 | 2021-09-24 | Clay | Missouri | 29047 | 13948 | 199 |
1746656 | 1746656 | 2021-09-23 | Clay | Missouri | 29047 | 13891 | 199 |
1743407 | 1743407 | 2021-09-22 | Clay | Missouri | 29047 | 13825 | 198 |
1740158 | 1740158 | 2021-09-21 | Clay | Missouri | 29047 | 13794 | 198 |
1736909 | 1736909 | 2021-09-20 | Clay | Missouri | 29047 | 13742 | 196 |
1733659 | 1733659 | 2021-09-19 | Clay | Missouri | 29047 | 13731 | 196 |
1730409 | 1730409 | 2021-09-18 | Clay | Missouri | 29047 | 13692 | 196 |
1727159 | 1727159 | 2021-09-17 | Clay | Missouri | 29047 | 13658 | 196 |
1723910 | 1723910 | 2021-09-16 | Clay | Missouri | 29047 | 13609 | 195 |
1720661 | 1720661 | 2021-09-15 | Clay | Missouri | 29047 | 13551 | 194 |
1717413 | 1717413 | 2021-09-14 | Clay | Missouri | 29047 | 13501 | 193 |
1714165 | 1714165 | 2021-09-13 | Clay | Missouri | 29047 | 13447 | 191 |
1710919 | 1710919 | 2021-09-12 | Clay | Missouri | 29047 | 13422 | 191 |
1707672 | 1707672 | 2021-09-11 | Clay | Missouri | 29047 | 13399 | 191 |
1704425 | 1704425 | 2021-09-10 | Clay | Missouri | 29047 | 13329 | 191 |
1701175 | 1701175 | 2021-09-09 | Clay | Missouri | 29047 | 13263 | 191 |
1697926 | 1697926 | 2021-09-08 | Clay | Missouri | 29047 | 13224 | 189 |
1694678 | 1694678 | 2021-09-07 | Clay | Missouri | 29047 | 13134 | 186 |
1691429 | 1691429 | 2021-09-06 | Clay | Missouri | 29047 | 13123 | 186 |
1688179 | 1688179 | 2021-09-05 | Clay | Missouri | 29047 | 13109 | 186 |
1684929 | 1684929 | 2021-09-04 | Clay | Missouri | 29047 | 13080 | 186 |
1681678 | 1681678 | 2021-09-03 | Clay | Missouri | 29047 | 13034 | 186 |
1678430 | 1678430 | 2021-09-02 | Clay | Missouri | 29047 | 12975 | 186 |
1675182 | 1675182 | 2021-09-01 | Clay | Missouri | 29047 | 12901 | 186 |
1671934 | 1671934 | 2021-08-31 | Clay | Missouri | 29047 | 12855 | 186 |
1668687 | 1668687 | 2021-08-30 | Clay | Missouri | 29047 | 12797 | 185 |
1665440 | 1665440 | 2021-08-29 | Clay | Missouri | 29047 | 12771 | 185 |
1662192 | 1662192 | 2021-08-28 | Clay | Missouri | 29047 | 12740 | 185 |
1658944 | 1658944 | 2021-08-27 | Clay | Missouri | 29047 | 12699 | 185 |
1655695 | 1655695 | 2021-08-26 | Clay | Missouri | 29047 | 12638 | 185 |
1652448 | 1652448 | 2021-08-25 | Clay | Missouri | 29047 | 12579 | 185 |
1649200 | 1649200 | 2021-08-24 | Clay | Missouri | 29047 | 12524 | 185 |
1645951 | 1645951 | 2021-08-23 | Clay | Missouri | 29047 | 12468 | 183 |
1642702 | 1642702 | 2021-08-22 | Clay | Missouri | 29047 | 12438 | 183 |
1639452 | 1639452 | 2021-08-21 | Clay | Missouri | 29047 | 12407 | 183 |
1636202 | 1636202 | 2021-08-20 | Clay | Missouri | 29047 | 12347 | 183 |
1632952 | 1632952 | 2021-08-19 | Clay | Missouri | 29047 | 12286 | 183 |
1629705 | 1629705 | 2021-08-18 | Clay | Missouri | 29047 | 12201 | 183 |
1626458 | 1626458 | 2021-08-17 | Clay | Missouri | 29047 | 12145 | 183 |
1623211 | 1623211 | 2021-08-16 | Clay | Missouri | 29047 | 12100 | 182 |
1619964 | 1619964 | 2021-08-15 | Clay | Missouri | 29047 | 12079 | 182 |
1616716 | 1616716 | 2021-08-14 | Clay | Missouri | 29047 | 12033 | 182 |
1613468 | 1613468 | 2021-08-13 | Clay | Missouri | 29047 | 11977 | 181 |
1610219 | 1610219 | 2021-08-12 | Clay | Missouri | 29047 | 11933 | 180 |
1606971 | 1606971 | 2021-08-11 | Clay | Missouri | 29047 | 11857 | 180 |
1603722 | 1603722 | 2021-08-10 | Clay | Missouri | 29047 | 11792 | 180 |
1600473 | 1600473 | 2021-08-09 | Clay | Missouri | 29047 | 11747 | 178 |
1597225 | 1597225 | 2021-08-08 | Clay | Missouri | 29047 | 11725 | 178 |
1593976 | 1593976 | 2021-08-07 | Clay | Missouri | 29047 | 11687 | 178 |
1590727 | 1590727 | 2021-08-06 | Clay | Missouri | 29047 | 11644 | 178 |
1587478 | 1587478 | 2021-08-05 | Clay | Missouri | 29047 | 11599 | 178 |
1584227 | 1584227 | 2021-08-04 | Clay | Missouri | 29047 | 11523 | 178 |
1580978 | 1580978 | 2021-08-03 | Clay | Missouri | 29047 | 11410 | 178 |
1577729 | 1577729 | 2021-08-02 | Clay | Missouri | 29047 | 11371 | 177 |
1574481 | 1574481 | 2021-08-01 | Clay | Missouri | 29047 | 11358 | 177 |
1571233 | 1571233 | 2021-07-31 | Clay | Missouri | 29047 | 11324 | 177 |
1567985 | 1567985 | 2021-07-30 | Clay | Missouri | 29047 | 11274 | 177 |
1564737 | 1564737 | 2021-07-29 | Clay | Missouri | 29047 | 11204 | 177 |
1561489 | 1561489 | 2021-07-28 | Clay | Missouri | 29047 | 11165 | 176 |
1558241 | 1558241 | 2021-07-27 | Clay | Missouri | 29047 | 11114 | 176 |
1554994 | 1554994 | 2021-07-26 | Clay | Missouri | 29047 | 11070 | 176 |
1551747 | 1551747 | 2021-07-25 | Clay | Missouri | 29047 | 11061 | 176 |
1548500 | 1548500 | 2021-07-24 | Clay | Missouri | 29047 | 11038 | 176 |
1545253 | 1545253 | 2021-07-23 | Clay | Missouri | 29047 | 10990 | 176 |
1542005 | 1542005 | 2021-07-22 | Clay | Missouri | 29047 | 10957 | 176 |
1538758 | 1538758 | 2021-07-21 | Clay | Missouri | 29047 | 10919 | 176 |
1535511 | 1535511 | 2021-07-20 | Clay | Missouri | 29047 | 10875 | 176 |
1532263 | 1532263 | 2021-07-19 | Clay | Missouri | 29047 | 10852 | 176 |
1529016 | 1529016 | 2021-07-18 | Clay | Missouri | 29047 | 10842 | 176 |
1525769 | 1525769 | 2021-07-17 | Clay | Missouri | 29047 | 10828 | 176 |
1522522 | 1522522 | 2021-07-16 | Clay | Missouri | 29047 | 10791 | 176 |
1519273 | 1519273 | 2021-07-15 | Clay | Missouri | 29047 | 10771 | 176 |
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);