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 |
---|---|---|---|---|---|---|---|
1948115 | 1948115 | 2021-11-24 | Christian | Missouri | 29043 | 13686 | 200 |
1944864 | 1944864 | 2021-11-23 | Christian | Missouri | 29043 | 13668 | 200 |
1941613 | 1941613 | 2021-11-22 | Christian | Missouri | 29043 | 13638 | 199 |
1938363 | 1938363 | 2021-11-21 | Christian | Missouri | 29043 | 13620 | 202 |
1935113 | 1935113 | 2021-11-20 | Christian | Missouri | 29043 | 13600 | 202 |
1931863 | 1931863 | 2021-11-19 | Christian | Missouri | 29043 | 13574 | 202 |
1928612 | 1928612 | 2021-11-18 | Christian | Missouri | 29043 | 13550 | 199 |
1925362 | 1925362 | 2021-11-17 | Christian | Missouri | 29043 | 13236 | 164 |
1922113 | 1922113 | 2021-11-16 | Christian | Missouri | 29043 | 13218 | 164 |
1918863 | 1918863 | 2021-11-15 | Christian | Missouri | 29043 | 13203 | 163 |
1915613 | 1915613 | 2021-11-14 | Christian | Missouri | 29043 | 13183 | 163 |
1912363 | 1912363 | 2021-11-13 | Christian | Missouri | 29043 | 13174 | 163 |
1909113 | 1909113 | 2021-11-12 | Christian | Missouri | 29043 | 13142 | 163 |
1905864 | 1905864 | 2021-11-11 | Christian | Missouri | 29043 | 13105 | 163 |
1902615 | 1902615 | 2021-11-10 | Christian | Missouri | 29043 | 13105 | 163 |
1899365 | 1899365 | 2021-11-09 | Christian | Missouri | 29043 | 13090 | 163 |
1896115 | 1896115 | 2021-11-08 | Christian | Missouri | 29043 | 13077 | 161 |
1892865 | 1892865 | 2021-11-07 | Christian | Missouri | 29043 | 13072 | 161 |
1889615 | 1889615 | 2021-11-06 | Christian | Missouri | 29043 | 13062 | 161 |
1886365 | 1886365 | 2021-11-05 | Christian | Missouri | 29043 | 13036 | 161 |
1883116 | 1883116 | 2021-11-04 | Christian | Missouri | 29043 | 13021 | 161 |
1879867 | 1879867 | 2021-11-03 | Christian | Missouri | 29043 | 12991 | 161 |
1876618 | 1876618 | 2021-11-02 | Christian | Missouri | 29043 | 12975 | 161 |
1873369 | 1873369 | 2021-11-01 | Christian | Missouri | 29043 | 12962 | 159 |
1870120 | 1870120 | 2021-10-31 | Christian | Missouri | 29043 | 12951 | 159 |
1866871 | 1866871 | 2021-10-30 | Christian | Missouri | 29043 | 12940 | 159 |
1863622 | 1863622 | 2021-10-29 | Christian | Missouri | 29043 | 12933 | 159 |
1860373 | 1860373 | 2021-10-28 | Christian | Missouri | 29043 | 12924 | 159 |
1857124 | 1857124 | 2021-10-27 | Christian | Missouri | 29043 | 12909 | 158 |
1853875 | 1853875 | 2021-10-26 | Christian | Missouri | 29043 | 12899 | 158 |
1850626 | 1850626 | 2021-10-25 | Christian | Missouri | 29043 | 12894 | 157 |
1847376 | 1847376 | 2021-10-24 | Christian | Missouri | 29043 | 12892 | 157 |
1844126 | 1844126 | 2021-10-23 | Christian | Missouri | 29043 | 12883 | 157 |
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 |
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);