ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 29095 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840902 | 1840902 | 2021-10-22 | Jackson | Missouri | 29095 | 55516 | 683 |
1837653 | 1837653 | 2021-10-21 | Jackson | Missouri | 29095 | 55452 | 683 |
1834404 | 1834404 | 2021-10-20 | Jackson | Missouri | 29095 | 55370 | 683 |
1831155 | 1831155 | 2021-10-19 | Jackson | Missouri | 29095 | 55297 | 680 |
1827906 | 1827906 | 2021-10-18 | Jackson | Missouri | 29095 | 55242 | 672 |
1824657 | 1824657 | 2021-10-17 | Jackson | Missouri | 29095 | 55222 | 672 |
1821408 | 1821408 | 2021-10-16 | Jackson | Missouri | 29095 | 55178 | 672 |
1818159 | 1818159 | 2021-10-15 | Jackson | Missouri | 29095 | 55098 | 672 |
1814910 | 1814910 | 2021-10-14 | Jackson | Missouri | 29095 | 55013 | 672 |
1811662 | 1811662 | 2021-10-13 | Jackson | Missouri | 29095 | 54918 | 672 |
1808413 | 1808413 | 2021-10-12 | Jackson | Missouri | 29095 | 54832 | 663 |
1805162 | 1805162 | 2021-10-11 | Jackson | Missouri | 29095 | 54758 | 661 |
1801913 | 1801913 | 2021-10-10 | Jackson | Missouri | 29095 | 54710 | 661 |
1798664 | 1798664 | 2021-10-09 | Jackson | Missouri | 29095 | 54662 | 661 |
1795415 | 1795415 | 2021-10-08 | Jackson | Missouri | 29095 | 54570 | 660 |
1792166 | 1792166 | 2021-10-07 | Jackson | Missouri | 29095 | 54469 | 659 |
1788917 | 1788917 | 2021-10-06 | Jackson | Missouri | 29095 | 54373 | 660 |
1785669 | 1785669 | 2021-10-05 | Jackson | Missouri | 29095 | 54275 | 659 |
1782420 | 1782420 | 2021-10-04 | Jackson | Missouri | 29095 | 54203 | 645 |
1779170 | 1779170 | 2021-10-03 | Jackson | Missouri | 29095 | 54147 | 645 |
1775920 | 1775920 | 2021-10-02 | Jackson | Missouri | 29095 | 54069 | 645 |
1772670 | 1772670 | 2021-10-01 | Jackson | Missouri | 29095 | 53940 | 645 |
1769421 | 1769421 | 2021-09-30 | Jackson | Missouri | 29095 | 53754 | 643 |
1766172 | 1766172 | 2021-09-29 | Jackson | Missouri | 29095 | 53634 | 642 |
1762923 | 1762923 | 2021-09-28 | Jackson | Missouri | 29095 | 53497 | 640 |
1759674 | 1759674 | 2021-09-27 | Jackson | Missouri | 29095 | 53416 | 629 |
1756426 | 1756426 | 2021-09-26 | Jackson | Missouri | 29095 | 53357 | 629 |
1753178 | 1753178 | 2021-09-25 | Jackson | Missouri | 29095 | 53281 | 628 |
1749930 | 1749930 | 2021-09-24 | Jackson | Missouri | 29095 | 53173 | 626 |
1746680 | 1746680 | 2021-09-23 | Jackson | Missouri | 29095 | 53057 | 626 |
1743431 | 1743431 | 2021-09-22 | Jackson | Missouri | 29095 | 52931 | 625 |
1740182 | 1740182 | 2021-09-21 | Jackson | Missouri | 29095 | 52820 | 621 |
1736933 | 1736933 | 2021-09-20 | Jackson | Missouri | 29095 | 52689 | 605 |
1733683 | 1733683 | 2021-09-19 | Jackson | Missouri | 29095 | 52622 | 605 |
1730433 | 1730433 | 2021-09-18 | Jackson | Missouri | 29095 | 52519 | 605 |
1727183 | 1727183 | 2021-09-17 | Jackson | Missouri | 29095 | 52368 | 603 |
1723934 | 1723934 | 2021-09-16 | Jackson | Missouri | 29095 | 52246 | 598 |
1720685 | 1720685 | 2021-09-15 | Jackson | Missouri | 29095 | 52076 | 597 |
1717437 | 1717437 | 2021-09-14 | Jackson | Missouri | 29095 | 51902 | 597 |
1714189 | 1714189 | 2021-09-13 | Jackson | Missouri | 29095 | 51796 | 588 |
1710943 | 1710943 | 2021-09-12 | Jackson | Missouri | 29095 | 51712 | 588 |
1707696 | 1707696 | 2021-09-11 | Jackson | Missouri | 29095 | 51567 | 588 |
1704449 | 1704449 | 2021-09-10 | Jackson | Missouri | 29095 | 51405 | 586 |
1701199 | 1701199 | 2021-09-09 | Jackson | Missouri | 29095 | 51182 | 583 |
1697950 | 1697950 | 2021-09-08 | Jackson | Missouri | 29095 | 51048 | 582 |
1694702 | 1694702 | 2021-09-07 | Jackson | Missouri | 29095 | 50870 | 571 |
1691453 | 1691453 | 2021-09-06 | Jackson | Missouri | 29095 | 50810 | 568 |
1688203 | 1688203 | 2021-09-05 | Jackson | Missouri | 29095 | 50716 | 568 |
1684953 | 1684953 | 2021-09-04 | Jackson | Missouri | 29095 | 50620 | 568 |
1681702 | 1681702 | 2021-09-03 | Jackson | Missouri | 29095 | 50459 | 568 |
1678454 | 1678454 | 2021-09-02 | Jackson | Missouri | 29095 | 50282 | 567 |
1675206 | 1675206 | 2021-09-01 | Jackson | Missouri | 29095 | 50073 | 562 |
1671958 | 1671958 | 2021-08-31 | Jackson | Missouri | 29095 | 49894 | 559 |
1668711 | 1668711 | 2021-08-30 | Jackson | Missouri | 29095 | 49692 | 549 |
1665464 | 1665464 | 2021-08-29 | Jackson | Missouri | 29095 | 49538 | 549 |
1662216 | 1662216 | 2021-08-28 | Jackson | Missouri | 29095 | 49409 | 549 |
1658968 | 1658968 | 2021-08-27 | Jackson | Missouri | 29095 | 49227 | 549 |
1655719 | 1655719 | 2021-08-26 | Jackson | Missouri | 29095 | 49042 | 547 |
1652472 | 1652472 | 2021-08-25 | Jackson | Missouri | 29095 | 48823 | 546 |
1649224 | 1649224 | 2021-08-24 | Jackson | Missouri | 29095 | 48598 | 541 |
1645975 | 1645975 | 2021-08-23 | Jackson | Missouri | 29095 | 48459 | 533 |
1642726 | 1642726 | 2021-08-22 | Jackson | Missouri | 29095 | 48323 | 533 |
1639476 | 1639476 | 2021-08-21 | Jackson | Missouri | 29095 | 48181 | 533 |
1636226 | 1636226 | 2021-08-20 | Jackson | Missouri | 29095 | 48016 | 531 |
1632976 | 1632976 | 2021-08-19 | Jackson | Missouri | 29095 | 47792 | 527 |
1629729 | 1629729 | 2021-08-18 | Jackson | Missouri | 29095 | 47469 | 527 |
1626482 | 1626482 | 2021-08-17 | Jackson | Missouri | 29095 | 47224 | 525 |
1623235 | 1623235 | 2021-08-16 | Jackson | Missouri | 29095 | 47093 | 517 |
1619988 | 1619988 | 2021-08-15 | Jackson | Missouri | 29095 | 46945 | 517 |
1616740 | 1616740 | 2021-08-14 | Jackson | Missouri | 29095 | 46768 | 517 |
1613492 | 1613492 | 2021-08-13 | Jackson | Missouri | 29095 | 46565 | 517 |
1610243 | 1610243 | 2021-08-12 | Jackson | Missouri | 29095 | 46275 | 517 |
1606995 | 1606995 | 2021-08-11 | Jackson | Missouri | 29095 | 45939 | 513 |
1603746 | 1603746 | 2021-08-10 | Jackson | Missouri | 29095 | 45624 | 513 |
1600497 | 1600497 | 2021-08-09 | Jackson | Missouri | 29095 | 45462 | 505 |
1597249 | 1597249 | 2021-08-08 | Jackson | Missouri | 29095 | 45331 | 505 |
1594000 | 1594000 | 2021-08-07 | Jackson | Missouri | 29095 | 45160 | 505 |
1590751 | 1590751 | 2021-08-06 | Jackson | Missouri | 29095 | 44926 | 505 |
1587502 | 1587502 | 2021-08-05 | Jackson | Missouri | 29095 | 44647 | 505 |
1584251 | 1584251 | 2021-08-04 | Jackson | Missouri | 29095 | 44304 | 504 |
1581002 | 1581002 | 2021-08-03 | Jackson | Missouri | 29095 | 43945 | 504 |
1577753 | 1577753 | 2021-08-02 | Jackson | Missouri | 29095 | 43684 | 501 |
1574505 | 1574505 | 2021-08-01 | Jackson | Missouri | 29095 | 43599 | 501 |
1571257 | 1571257 | 2021-07-31 | Jackson | Missouri | 29095 | 43472 | 501 |
1568009 | 1568009 | 2021-07-30 | Jackson | Missouri | 29095 | 43233 | 501 |
1564761 | 1564761 | 2021-07-29 | Jackson | Missouri | 29095 | 42859 | 498 |
1561513 | 1561513 | 2021-07-28 | Jackson | Missouri | 29095 | 42654 | 498 |
1558265 | 1558265 | 2021-07-27 | Jackson | Missouri | 29095 | 42484 | 497 |
1555018 | 1555018 | 2021-07-26 | Jackson | Missouri | 29095 | 42344 | 494 |
1551771 | 1551771 | 2021-07-25 | Jackson | Missouri | 29095 | 42259 | 494 |
1548524 | 1548524 | 2021-07-24 | Jackson | Missouri | 29095 | 42123 | 494 |
1545277 | 1545277 | 2021-07-23 | Jackson | Missouri | 29095 | 41920 | 494 |
1542029 | 1542029 | 2021-07-22 | Jackson | Missouri | 29095 | 41750 | 493 |
1538782 | 1538782 | 2021-07-21 | Jackson | Missouri | 29095 | 41553 | 492 |
1535535 | 1535535 | 2021-07-20 | Jackson | Missouri | 29095 | 41389 | 492 |
1532287 | 1532287 | 2021-07-19 | Jackson | Missouri | 29095 | 41267 | 488 |
1529040 | 1529040 | 2021-07-18 | Jackson | Missouri | 29095 | 41214 | 488 |
1525793 | 1525793 | 2021-07-17 | Jackson | Missouri | 29095 | 41114 | 488 |
1522546 | 1522546 | 2021-07-16 | Jackson | Missouri | 29095 | 41006 | 488 |
1519297 | 1519297 | 2021-07-15 | Jackson | Missouri | 29095 | 40873 | 488 |
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);