ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29049 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840879 | 1840879 | 2021-10-22 | Clinton | Missouri | 29049 | 2839 | 77 |
1837630 | 1837630 | 2021-10-21 | Clinton | Missouri | 29049 | 2839 | 77 |
1834381 | 1834381 | 2021-10-20 | Clinton | Missouri | 29049 | 2834 | 77 |
1831132 | 1831132 | 2021-10-19 | Clinton | Missouri | 29049 | 2829 | 77 |
1827883 | 1827883 | 2021-10-18 | Clinton | Missouri | 29049 | 2828 | 77 |
1824634 | 1824634 | 2021-10-17 | Clinton | Missouri | 29049 | 2829 | 77 |
1821385 | 1821385 | 2021-10-16 | Clinton | Missouri | 29049 | 2822 | 77 |
1818136 | 1818136 | 2021-10-15 | Clinton | Missouri | 29049 | 2816 | 77 |
1814887 | 1814887 | 2021-10-14 | Clinton | Missouri | 29049 | 2816 | 77 |
1811639 | 1811639 | 2021-10-13 | Clinton | Missouri | 29049 | 2812 | 77 |
1808390 | 1808390 | 2021-10-12 | Clinton | Missouri | 29049 | 2803 | 76 |
1805139 | 1805139 | 2021-10-11 | Clinton | Missouri | 29049 | 2797 | 76 |
1801890 | 1801890 | 2021-10-10 | Clinton | Missouri | 29049 | 2795 | 76 |
1798641 | 1798641 | 2021-10-09 | Clinton | Missouri | 29049 | 2793 | 76 |
1795392 | 1795392 | 2021-10-08 | Clinton | Missouri | 29049 | 2791 | 76 |
1792143 | 1792143 | 2021-10-07 | Clinton | Missouri | 29049 | 2782 | 76 |
1788894 | 1788894 | 2021-10-06 | Clinton | Missouri | 29049 | 2771 | 76 |
1785646 | 1785646 | 2021-10-05 | Clinton | Missouri | 29049 | 2764 | 76 |
1782397 | 1782397 | 2021-10-04 | Clinton | Missouri | 29049 | 2758 | 75 |
1779147 | 1779147 | 2021-10-03 | Clinton | Missouri | 29049 | 2752 | 75 |
1775897 | 1775897 | 2021-10-02 | Clinton | Missouri | 29049 | 2751 | 75 |
1772647 | 1772647 | 2021-10-01 | Clinton | Missouri | 29049 | 2748 | 75 |
1769398 | 1769398 | 2021-09-30 | Clinton | Missouri | 29049 | 2743 | 75 |
1766149 | 1766149 | 2021-09-29 | Clinton | Missouri | 29049 | 2727 | 75 |
1762900 | 1762900 | 2021-09-28 | Clinton | Missouri | 29049 | 2713 | 75 |
1759651 | 1759651 | 2021-09-27 | Clinton | Missouri | 29049 | 2710 | 75 |
1756403 | 1756403 | 2021-09-26 | Clinton | Missouri | 29049 | 2704 | 75 |
1753155 | 1753155 | 2021-09-25 | Clinton | Missouri | 29049 | 2700 | 75 |
1749907 | 1749907 | 2021-09-24 | Clinton | Missouri | 29049 | 2697 | 75 |
1746657 | 1746657 | 2021-09-23 | Clinton | Missouri | 29049 | 2691 | 75 |
1743408 | 1743408 | 2021-09-22 | Clinton | Missouri | 29049 | 2686 | 75 |
1740159 | 1740159 | 2021-09-21 | Clinton | Missouri | 29049 | 2677 | 75 |
1736910 | 1736910 | 2021-09-20 | Clinton | Missouri | 29049 | 2666 | 75 |
1733660 | 1733660 | 2021-09-19 | Clinton | Missouri | 29049 | 2659 | 75 |
1730410 | 1730410 | 2021-09-18 | Clinton | Missouri | 29049 | 2656 | 75 |
1727160 | 1727160 | 2021-09-17 | Clinton | Missouri | 29049 | 2641 | 75 |
1723911 | 1723911 | 2021-09-16 | Clinton | Missouri | 29049 | 2631 | 75 |
1720662 | 1720662 | 2021-09-15 | Clinton | Missouri | 29049 | 2621 | 75 |
1717414 | 1717414 | 2021-09-14 | Clinton | Missouri | 29049 | 2613 | 74 |
1714166 | 1714166 | 2021-09-13 | Clinton | Missouri | 29049 | 2609 | 73 |
1710920 | 1710920 | 2021-09-12 | Clinton | Missouri | 29049 | 2603 | 73 |
1707673 | 1707673 | 2021-09-11 | Clinton | Missouri | 29049 | 2597 | 73 |
1704426 | 1704426 | 2021-09-10 | Clinton | Missouri | 29049 | 2582 | 72 |
1701176 | 1701176 | 2021-09-09 | Clinton | Missouri | 29049 | 2567 | 71 |
1697927 | 1697927 | 2021-09-08 | Clinton | Missouri | 29049 | 2547 | 71 |
1694679 | 1694679 | 2021-09-07 | Clinton | Missouri | 29049 | 2535 | 71 |
1691430 | 1691430 | 2021-09-06 | Clinton | Missouri | 29049 | 2526 | 71 |
1688180 | 1688180 | 2021-09-05 | Clinton | Missouri | 29049 | 2523 | 71 |
1684930 | 1684930 | 2021-09-04 | Clinton | Missouri | 29049 | 2512 | 71 |
1681679 | 1681679 | 2021-09-03 | Clinton | Missouri | 29049 | 2505 | 71 |
1678431 | 1678431 | 2021-09-02 | Clinton | Missouri | 29049 | 2491 | 71 |
1675183 | 1675183 | 2021-09-01 | Clinton | Missouri | 29049 | 2476 | 71 |
1671935 | 1671935 | 2021-08-31 | Clinton | Missouri | 29049 | 2475 | 71 |
1668688 | 1668688 | 2021-08-30 | Clinton | Missouri | 29049 | 2471 | 70 |
1665441 | 1665441 | 2021-08-29 | Clinton | Missouri | 29049 | 2464 | 70 |
1662193 | 1662193 | 2021-08-28 | Clinton | Missouri | 29049 | 2458 | 70 |
1658945 | 1658945 | 2021-08-27 | Clinton | Missouri | 29049 | 2448 | 70 |
1655696 | 1655696 | 2021-08-26 | Clinton | Missouri | 29049 | 2441 | 70 |
1652449 | 1652449 | 2021-08-25 | Clinton | Missouri | 29049 | 2428 | 70 |
1649201 | 1649201 | 2021-08-24 | Clinton | Missouri | 29049 | 2419 | 70 |
1645952 | 1645952 | 2021-08-23 | Clinton | Missouri | 29049 | 2416 | 70 |
1642703 | 1642703 | 2021-08-22 | Clinton | Missouri | 29049 | 2413 | 70 |
1639453 | 1639453 | 2021-08-21 | Clinton | Missouri | 29049 | 2407 | 70 |
1636203 | 1636203 | 2021-08-20 | Clinton | Missouri | 29049 | 2397 | 69 |
1632953 | 1632953 | 2021-08-19 | Clinton | Missouri | 29049 | 2378 | 68 |
1629706 | 1629706 | 2021-08-18 | Clinton | Missouri | 29049 | 2372 | 68 |
1626459 | 1626459 | 2021-08-17 | Clinton | Missouri | 29049 | 2360 | 68 |
1623212 | 1623212 | 2021-08-16 | Clinton | Missouri | 29049 | 2354 | 66 |
1619965 | 1619965 | 2021-08-15 | Clinton | Missouri | 29049 | 2350 | 66 |
1616717 | 1616717 | 2021-08-14 | Clinton | Missouri | 29049 | 2347 | 66 |
1613469 | 1613469 | 2021-08-13 | Clinton | Missouri | 29049 | 2334 | 66 |
1610220 | 1610220 | 2021-08-12 | Clinton | Missouri | 29049 | 2327 | 66 |
1606972 | 1606972 | 2021-08-11 | Clinton | Missouri | 29049 | 2320 | 65 |
1603723 | 1603723 | 2021-08-10 | Clinton | Missouri | 29049 | 2310 | 65 |
1600474 | 1600474 | 2021-08-09 | Clinton | Missouri | 29049 | 2300 | 65 |
1597226 | 1597226 | 2021-08-08 | Clinton | Missouri | 29049 | 2298 | 65 |
1593977 | 1593977 | 2021-08-07 | Clinton | Missouri | 29049 | 2296 | 65 |
1590728 | 1590728 | 2021-08-06 | Clinton | Missouri | 29049 | 2281 | 65 |
1587479 | 1587479 | 2021-08-05 | Clinton | Missouri | 29049 | 2278 | 65 |
1584228 | 1584228 | 2021-08-04 | Clinton | Missouri | 29049 | 2268 | 65 |
1580979 | 1580979 | 2021-08-03 | Clinton | Missouri | 29049 | 2258 | 65 |
1577730 | 1577730 | 2021-08-02 | Clinton | Missouri | 29049 | 2256 | 65 |
1574482 | 1574482 | 2021-08-01 | Clinton | Missouri | 29049 | 2253 | 65 |
1571234 | 1571234 | 2021-07-31 | Clinton | Missouri | 29049 | 2249 | 65 |
1567986 | 1567986 | 2021-07-30 | Clinton | Missouri | 29049 | 2238 | 65 |
1564738 | 1564738 | 2021-07-29 | Clinton | Missouri | 29049 | 2213 | 65 |
1561490 | 1561490 | 2021-07-28 | Clinton | Missouri | 29049 | 2210 | 65 |
1558242 | 1558242 | 2021-07-27 | Clinton | Missouri | 29049 | 2201 | 65 |
1554995 | 1554995 | 2021-07-26 | Clinton | Missouri | 29049 | 2194 | 65 |
1551748 | 1551748 | 2021-07-25 | Clinton | Missouri | 29049 | 2189 | 65 |
1548501 | 1548501 | 2021-07-24 | Clinton | Missouri | 29049 | 2173 | 65 |
1545254 | 1545254 | 2021-07-23 | Clinton | Missouri | 29049 | 2159 | 65 |
1542006 | 1542006 | 2021-07-22 | Clinton | Missouri | 29049 | 2153 | 65 |
1538759 | 1538759 | 2021-07-21 | Clinton | Missouri | 29049 | 2144 | 65 |
1535512 | 1535512 | 2021-07-20 | Clinton | Missouri | 29049 | 2132 | 65 |
1532264 | 1532264 | 2021-07-19 | Clinton | Missouri | 29049 | 2125 | 65 |
1529017 | 1529017 | 2021-07-18 | Clinton | Missouri | 29049 | 2123 | 65 |
1525770 | 1525770 | 2021-07-17 | Clinton | Missouri | 29049 | 2116 | 65 |
1522523 | 1522523 | 2021-07-16 | Clinton | Missouri | 29049 | 2104 | 65 |
1519274 | 1519274 | 2021-07-15 | Clinton | Missouri | 29049 | 2099 | 65 |
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);