ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29043 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840876 | 1840876 | 2021-10-22 | Christian | Missouri | 29043 | 12876 | 157 |
1837627 | 1837627 | 2021-10-21 | Christian | Missouri | 29043 | 12854 | 157 |
1834378 | 1834378 | 2021-10-20 | Christian | Missouri | 29043 | 12848 | 157 |
1831129 | 1831129 | 2021-10-19 | Christian | Missouri | 29043 | 12836 | 157 |
1827880 | 1827880 | 2021-10-18 | Christian | Missouri | 29043 | 12824 | 157 |
1824631 | 1824631 | 2021-10-17 | Christian | Missouri | 29043 | 12817 | 157 |
1821382 | 1821382 | 2021-10-16 | Christian | Missouri | 29043 | 12812 | 157 |
1818133 | 1818133 | 2021-10-15 | Christian | Missouri | 29043 | 12806 | 157 |
1814884 | 1814884 | 2021-10-14 | Christian | Missouri | 29043 | 12792 | 157 |
1811636 | 1811636 | 2021-10-13 | Christian | Missouri | 29043 | 12785 | 157 |
1808387 | 1808387 | 2021-10-12 | Christian | Missouri | 29043 | 12778 | 157 |
1805136 | 1805136 | 2021-10-11 | Christian | Missouri | 29043 | 12767 | 157 |
1801887 | 1801887 | 2021-10-10 | Christian | Missouri | 29043 | 12757 | 157 |
1798638 | 1798638 | 2021-10-09 | Christian | Missouri | 29043 | 12743 | 157 |
1795389 | 1795389 | 2021-10-08 | Christian | Missouri | 29043 | 12726 | 157 |
1792140 | 1792140 | 2021-10-07 | Christian | Missouri | 29043 | 12704 | 157 |
1788891 | 1788891 | 2021-10-06 | Christian | Missouri | 29043 | 12682 | 157 |
1785643 | 1785643 | 2021-10-05 | Christian | Missouri | 29043 | 12662 | 157 |
1782394 | 1782394 | 2021-10-04 | Christian | Missouri | 29043 | 12651 | 154 |
1779144 | 1779144 | 2021-10-03 | Christian | Missouri | 29043 | 12642 | 154 |
1775894 | 1775894 | 2021-10-02 | Christian | Missouri | 29043 | 12636 | 154 |
1772644 | 1772644 | 2021-10-01 | Christian | Missouri | 29043 | 12617 | 154 |
1769395 | 1769395 | 2021-09-30 | Christian | Missouri | 29043 | 12604 | 154 |
1766146 | 1766146 | 2021-09-29 | Christian | Missouri | 29043 | 12582 | 154 |
1762897 | 1762897 | 2021-09-28 | Christian | Missouri | 29043 | 12564 | 153 |
1759648 | 1759648 | 2021-09-27 | Christian | Missouri | 29043 | 12551 | 147 |
1756400 | 1756400 | 2021-09-26 | Christian | Missouri | 29043 | 12544 | 147 |
1753152 | 1753152 | 2021-09-25 | Christian | Missouri | 29043 | 12525 | 147 |
1749904 | 1749904 | 2021-09-24 | Christian | Missouri | 29043 | 12508 | 147 |
1746654 | 1746654 | 2021-09-23 | Christian | Missouri | 29043 | 12483 | 148 |
1743405 | 1743405 | 2021-09-22 | Christian | Missouri | 29043 | 12458 | 147 |
1740156 | 1740156 | 2021-09-21 | Christian | Missouri | 29043 | 12431 | 147 |
1736907 | 1736907 | 2021-09-20 | Christian | Missouri | 29043 | 12416 | 146 |
1733657 | 1733657 | 2021-09-19 | Christian | Missouri | 29043 | 12408 | 146 |
1730407 | 1730407 | 2021-09-18 | Christian | Missouri | 29043 | 12394 | 146 |
1727157 | 1727157 | 2021-09-17 | Christian | Missouri | 29043 | 12381 | 146 |
1723908 | 1723908 | 2021-09-16 | Christian | Missouri | 29043 | 12934 | 146 |
1720659 | 1720659 | 2021-09-15 | Christian | Missouri | 29043 | 12934 | 146 |
1717411 | 1717411 | 2021-09-14 | Christian | Missouri | 29043 | 12934 | 146 |
1714163 | 1714163 | 2021-09-13 | Christian | Missouri | 29043 | 12934 | 145 |
1710917 | 1710917 | 2021-09-12 | Christian | Missouri | 29043 | 12934 | 145 |
1707670 | 1707670 | 2021-09-11 | Christian | Missouri | 29043 | 12934 | 145 |
1704423 | 1704423 | 2021-09-10 | Christian | Missouri | 29043 | 12795 | 145 |
1701173 | 1701173 | 2021-09-09 | Christian | Missouri | 29043 | 12795 | 145 |
1697924 | 1697924 | 2021-09-08 | Christian | Missouri | 29043 | 12795 | 145 |
1694676 | 1694676 | 2021-09-07 | Christian | Missouri | 29043 | 12795 | 143 |
1691427 | 1691427 | 2021-09-06 | Christian | Missouri | 29043 | 12795 | 143 |
1688177 | 1688177 | 2021-09-05 | Christian | Missouri | 29043 | 12795 | 143 |
1684927 | 1684927 | 2021-09-04 | Christian | Missouri | 29043 | 12795 | 143 |
1681676 | 1681676 | 2021-09-03 | Christian | Missouri | 29043 | 12567 | 143 |
1678428 | 1678428 | 2021-09-02 | Christian | Missouri | 29043 | 12567 | 143 |
1675180 | 1675180 | 2021-09-01 | Christian | Missouri | 29043 | 12567 | 143 |
1671932 | 1671932 | 2021-08-31 | Christian | Missouri | 29043 | 12567 | 142 |
1668685 | 1668685 | 2021-08-30 | Christian | Missouri | 29043 | 12567 | 139 |
1665438 | 1665438 | 2021-08-29 | Christian | Missouri | 29043 | 12567 | 139 |
1662190 | 1662190 | 2021-08-28 | Christian | Missouri | 29043 | 12567 | 139 |
1658942 | 1658942 | 2021-08-27 | Christian | Missouri | 29043 | 12567 | 139 |
1655693 | 1655693 | 2021-08-26 | Christian | Missouri | 29043 | 12385 | 139 |
1652446 | 1652446 | 2021-08-25 | Christian | Missouri | 29043 | 12385 | 139 |
1649198 | 1649198 | 2021-08-24 | Christian | Missouri | 29043 | 12385 | 139 |
1645949 | 1645949 | 2021-08-23 | Christian | Missouri | 29043 | 12385 | 131 |
1642700 | 1642700 | 2021-08-22 | Christian | Missouri | 29043 | 12385 | 131 |
1639450 | 1639450 | 2021-08-21 | Christian | Missouri | 29043 | 12385 | 131 |
1636200 | 1636200 | 2021-08-20 | Christian | Missouri | 29043 | 12385 | 131 |
1632950 | 1632950 | 2021-08-19 | Christian | Missouri | 29043 | 12020 | 131 |
1629703 | 1629703 | 2021-08-18 | Christian | Missouri | 29043 | 12020 | 131 |
1626456 | 1626456 | 2021-08-17 | Christian | Missouri | 29043 | 12020 | 132 |
1623209 | 1623209 | 2021-08-16 | Christian | Missouri | 29043 | 12020 | 127 |
1619962 | 1619962 | 2021-08-15 | Christian | Missouri | 29043 | 12020 | 127 |
1616714 | 1616714 | 2021-08-14 | Christian | Missouri | 29043 | 12020 | 127 |
1613466 | 1613466 | 2021-08-13 | Christian | Missouri | 29043 | 12020 | 126 |
1610217 | 1610217 | 2021-08-12 | Christian | Missouri | 29043 | 11871 | 126 |
1606969 | 1606969 | 2021-08-11 | Christian | Missouri | 29043 | 11871 | 126 |
1603720 | 1603720 | 2021-08-10 | Christian | Missouri | 29043 | 11871 | 126 |
1600471 | 1600471 | 2021-08-09 | Christian | Missouri | 29043 | 11871 | 112 |
1597223 | 1597223 | 2021-08-08 | Christian | Missouri | 29043 | 11871 | 112 |
1593974 | 1593974 | 2021-08-07 | Christian | Missouri | 29043 | 11871 | 112 |
1590725 | 1590725 | 2021-08-06 | Christian | Missouri | 29043 | 11871 | 112 |
1587476 | 1587476 | 2021-08-05 | Christian | Missouri | 29043 | 11552 | 112 |
1584225 | 1584225 | 2021-08-04 | Christian | Missouri | 29043 | 11552 | 112 |
1580976 | 1580976 | 2021-08-03 | Christian | Missouri | 29043 | 11552 | 112 |
1577727 | 1577727 | 2021-08-02 | Christian | Missouri | 29043 | 11552 | 107 |
1574479 | 1574479 | 2021-08-01 | Christian | Missouri | 29043 | 11552 | 107 |
1571231 | 1571231 | 2021-07-31 | Christian | Missouri | 29043 | 11552 | 107 |
1567983 | 1567983 | 2021-07-30 | Christian | Missouri | 29043 | 11552 | 107 |
1564735 | 1564735 | 2021-07-29 | Christian | Missouri | 29043 | 11158 | 107 |
1561487 | 1561487 | 2021-07-28 | Christian | Missouri | 29043 | 11158 | 107 |
1558239 | 1558239 | 2021-07-27 | Christian | Missouri | 29043 | 11158 | 106 |
1554992 | 1554992 | 2021-07-26 | Christian | Missouri | 29043 | 11158 | 103 |
1551745 | 1551745 | 2021-07-25 | Christian | Missouri | 29043 | 11158 | 103 |
1548498 | 1548498 | 2021-07-24 | Christian | Missouri | 29043 | 11158 | 103 |
1545251 | 1545251 | 2021-07-23 | Christian | Missouri | 29043 | 11158 | 103 |
1542003 | 1542003 | 2021-07-22 | Christian | Missouri | 29043 | 10676 | 103 |
1538756 | 1538756 | 2021-07-21 | Christian | Missouri | 29043 | 10676 | 103 |
1535509 | 1535509 | 2021-07-20 | Christian | Missouri | 29043 | 10676 | 103 |
1532261 | 1532261 | 2021-07-19 | Christian | Missouri | 29043 | 10676 | 99 |
1529014 | 1529014 | 2021-07-18 | Christian | Missouri | 29043 | 10676 | 99 |
1525767 | 1525767 | 2021-07-17 | Christian | Missouri | 29043 | 10676 | 99 |
1522520 | 1522520 | 2021-07-16 | Christian | Missouri | 29043 | 10676 | 99 |
1519271 | 1519271 | 2021-07-15 | Christian | Missouri | 29043 | 10185 | 99 |
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);