ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "St. Louis city" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1844208 | 1844208 | 2021-10-23 | St. Louis city | Missouri | 29510 | 32350 | 602 |
1840958 | 1840958 | 2021-10-22 | St. Louis city | Missouri | 29510 | 32322 | 601 |
1837709 | 1837709 | 2021-10-21 | St. Louis city | Missouri | 29510 | 32283 | 601 |
1834460 | 1834460 | 2021-10-20 | St. Louis city | Missouri | 29510 | 32251 | 600 |
1831211 | 1831211 | 2021-10-19 | St. Louis city | Missouri | 29510 | 32218 | 600 |
1827962 | 1827962 | 2021-10-18 | St. Louis city | Missouri | 29510 | 32184 | 600 |
1824713 | 1824713 | 2021-10-17 | St. Louis city | Missouri | 29510 | 32163 | 600 |
1821464 | 1821464 | 2021-10-16 | St. Louis city | Missouri | 29510 | 32136 | 599 |
1818215 | 1818215 | 2021-10-15 | St. Louis city | Missouri | 29510 | 32101 | 599 |
1814966 | 1814966 | 2021-10-14 | St. Louis city | Missouri | 29510 | 32044 | 598 |
1811718 | 1811718 | 2021-10-13 | St. Louis city | Missouri | 29510 | 31999 | 597 |
1808469 | 1808469 | 2021-10-12 | St. Louis city | Missouri | 29510 | 31959 | 597 |
1805218 | 1805218 | 2021-10-11 | St. Louis city | Missouri | 29510 | 31920 | 597 |
1801969 | 1801969 | 2021-10-10 | St. Louis city | Missouri | 29510 | 31880 | 595 |
1798720 | 1798720 | 2021-10-09 | St. Louis city | Missouri | 29510 | 31858 | 595 |
1795471 | 1795471 | 2021-10-08 | St. Louis city | Missouri | 29510 | 31815 | 594 |
1792222 | 1792222 | 2021-10-07 | St. Louis city | Missouri | 29510 | 31763 | 594 |
1788973 | 1788973 | 2021-10-06 | St. Louis city | Missouri | 29510 | 31702 | 594 |
1785725 | 1785725 | 2021-10-05 | St. Louis city | Missouri | 29510 | 31674 | 592 |
1782476 | 1782476 | 2021-10-04 | St. Louis city | Missouri | 29510 | 31626 | 590 |
1779226 | 1779226 | 2021-10-03 | St. Louis city | Missouri | 29510 | 31589 | 588 |
1775976 | 1775976 | 2021-10-02 | St. Louis city | Missouri | 29510 | 31554 | 586 |
1772726 | 1772726 | 2021-10-01 | St. Louis city | Missouri | 29510 | 31494 | 586 |
1769477 | 1769477 | 2021-09-30 | St. Louis city | Missouri | 29510 | 31422 | 586 |
1766228 | 1766228 | 2021-09-29 | St. Louis city | Missouri | 29510 | 31347 | 586 |
1762979 | 1762979 | 2021-09-28 | St. Louis city | Missouri | 29510 | 31275 | 586 |
1759730 | 1759730 | 2021-09-27 | St. Louis city | Missouri | 29510 | 31215 | 586 |
1756482 | 1756482 | 2021-09-26 | St. Louis city | Missouri | 29510 | 31163 | 586 |
1753234 | 1753234 | 2021-09-25 | St. Louis city | Missouri | 29510 | 31133 | 584 |
1749986 | 1749986 | 2021-09-24 | St. Louis city | Missouri | 29510 | 31076 | 582 |
1746736 | 1746736 | 2021-09-23 | St. Louis city | Missouri | 29510 | 31021 | 581 |
1743487 | 1743487 | 2021-09-22 | St. Louis city | Missouri | 29510 | 30958 | 581 |
1740238 | 1740238 | 2021-09-21 | St. Louis city | Missouri | 29510 | 30893 | 578 |
1736989 | 1736989 | 2021-09-20 | St. Louis city | Missouri | 29510 | 30828 | 578 |
1733739 | 1733739 | 2021-09-19 | St. Louis city | Missouri | 29510 | 30786 | 578 |
1730489 | 1730489 | 2021-09-18 | St. Louis city | Missouri | 29510 | 30733 | 578 |
1727239 | 1727239 | 2021-09-17 | St. Louis city | Missouri | 29510 | 30658 | 578 |
1723990 | 1723990 | 2021-09-16 | St. Louis city | Missouri | 29510 | 30572 | 577 |
1720741 | 1720741 | 2021-09-15 | St. Louis city | Missouri | 29510 | 30481 | 577 |
1717493 | 1717493 | 2021-09-14 | St. Louis city | Missouri | 29510 | 30380 | 577 |
1714245 | 1714245 | 2021-09-13 | St. Louis city | Missouri | 29510 | 30288 | 576 |
1710999 | 1710999 | 2021-09-12 | St. Louis city | Missouri | 29510 | 30213 | 575 |
1707752 | 1707752 | 2021-09-11 | St. Louis city | Missouri | 29510 | 30148 | 574 |
1704505 | 1704505 | 2021-09-10 | St. Louis city | Missouri | 29510 | 30062 | 572 |
1701255 | 1701255 | 2021-09-09 | St. Louis city | Missouri | 29510 | 29957 | 572 |
1698006 | 1698006 | 2021-09-08 | St. Louis city | Missouri | 29510 | 29888 | 572 |
1694758 | 1694758 | 2021-09-07 | St. Louis city | Missouri | 29510 | 29803 | 571 |
1691509 | 1691509 | 2021-09-06 | St. Louis city | Missouri | 29510 | 29743 | 570 |
1688259 | 1688259 | 2021-09-05 | St. Louis city | Missouri | 29510 | 29696 | 570 |
1685009 | 1685009 | 2021-09-04 | St. Louis city | Missouri | 29510 | 29632 | 567 |
1681758 | 1681758 | 2021-09-03 | St. Louis city | Missouri | 29510 | 29533 | 566 |
1678510 | 1678510 | 2021-09-02 | St. Louis city | Missouri | 29510 | 29431 | 565 |
1675262 | 1675262 | 2021-09-01 | St. Louis city | Missouri | 29510 | 29307 | 563 |
1672014 | 1672014 | 2021-08-31 | St. Louis city | Missouri | 29510 | 29219 | 563 |
1668767 | 1668767 | 2021-08-30 | St. Louis city | Missouri | 29510 | 29180 | 563 |
1665520 | 1665520 | 2021-08-29 | St. Louis city | Missouri | 29510 | 29074 | 562 |
1662272 | 1662272 | 2021-08-28 | St. Louis city | Missouri | 29510 | 29033 | 561 |
1659024 | 1659024 | 2021-08-27 | St. Louis city | Missouri | 29510 | 28940 | 561 |
1655775 | 1655775 | 2021-08-26 | St. Louis city | Missouri | 29510 | 28867 | 558 |
1652528 | 1652528 | 2021-08-25 | St. Louis city | Missouri | 29510 | 28782 | 558 |
1649280 | 1649280 | 2021-08-24 | St. Louis city | Missouri | 29510 | 28683 | 557 |
1646031 | 1646031 | 2021-08-23 | St. Louis city | Missouri | 29510 | 28592 | 557 |
1642782 | 1642782 | 2021-08-22 | St. Louis city | Missouri | 29510 | 28523 | 555 |
1639532 | 1639532 | 2021-08-21 | St. Louis city | Missouri | 29510 | 28461 | 555 |
1636282 | 1636282 | 2021-08-20 | St. Louis city | Missouri | 29510 | 28385 | 554 |
1633032 | 1633032 | 2021-08-19 | St. Louis city | Missouri | 29510 | 28305 | 554 |
1629785 | 1629785 | 2021-08-18 | St. Louis city | Missouri | 29510 | 28201 | 553 |
1626538 | 1626538 | 2021-08-17 | St. Louis city | Missouri | 29510 | 28116 | 553 |
1623291 | 1623291 | 2021-08-16 | St. Louis city | Missouri | 29510 | 28061 | 553 |
1620044 | 1620044 | 2021-08-15 | St. Louis city | Missouri | 29510 | 27996 | 552 |
1616796 | 1616796 | 2021-08-14 | St. Louis city | Missouri | 29510 | 27987 | 552 |
1613548 | 1613548 | 2021-08-13 | St. Louis city | Missouri | 29510 | 27883 | 552 |
1610299 | 1610299 | 2021-08-12 | St. Louis city | Missouri | 29510 | 27815 | 552 |
1607051 | 1607051 | 2021-08-11 | St. Louis city | Missouri | 29510 | 27634 | 551 |
1603802 | 1603802 | 2021-08-10 | St. Louis city | Missouri | 29510 | 27577 | 550 |
1600553 | 1600553 | 2021-08-09 | St. Louis city | Missouri | 29510 | 27539 | 548 |
1597305 | 1597305 | 2021-08-08 | St. Louis city | Missouri | 29510 | 27489 | 548 |
1594056 | 1594056 | 2021-08-07 | St. Louis city | Missouri | 29510 | 27403 | 548 |
1590807 | 1590807 | 2021-08-06 | St. Louis city | Missouri | 29510 | 27403 | 548 |
1587558 | 1587558 | 2021-08-05 | St. Louis city | Missouri | 29510 | 27332 | 548 |
1584307 | 1584307 | 2021-08-04 | St. Louis city | Missouri | 29510 | 27134 | 546 |
1581058 | 1581058 | 2021-08-03 | St. Louis city | Missouri | 29510 | 27059 | 544 |
1577809 | 1577809 | 2021-08-02 | St. Louis city | Missouri | 29510 | 27059 | 544 |
1574561 | 1574561 | 2021-08-01 | St. Louis city | Missouri | 29510 | 26949 | 542 |
1571313 | 1571313 | 2021-07-31 | St. Louis city | Missouri | 29510 | 26877 | 541 |
1568065 | 1568065 | 2021-07-30 | St. Louis city | Missouri | 29510 | 26805 | 541 |
1564817 | 1564817 | 2021-07-29 | St. Louis city | Missouri | 29510 | 26805 | 541 |
1561569 | 1561569 | 2021-07-28 | St. Louis city | Missouri | 29510 | 26695 | 541 |
1558321 | 1558321 | 2021-07-27 | St. Louis city | Missouri | 29510 | 26624 | 538 |
1555074 | 1555074 | 2021-07-26 | St. Louis city | Missouri | 29510 | 26518 | 538 |
1551827 | 1551827 | 2021-07-25 | St. Louis city | Missouri | 29510 | 26471 | 538 |
1548580 | 1548580 | 2021-07-24 | St. Louis city | Missouri | 29510 | 26471 | 538 |
1545333 | 1545333 | 2021-07-23 | St. Louis city | Missouri | 29510 | 26336 | 538 |
1542085 | 1542085 | 2021-07-22 | St. Louis city | Missouri | 29510 | 26336 | 538 |
1538838 | 1538838 | 2021-07-21 | St. Louis city | Missouri | 29510 | 26220 | 538 |
1535591 | 1535591 | 2021-07-20 | St. Louis city | Missouri | 29510 | 26171 | 538 |
1532343 | 1532343 | 2021-07-19 | St. Louis city | Missouri | 29510 | 26171 | 538 |
1529096 | 1529096 | 2021-07-18 | St. Louis city | Missouri | 29510 | 26088 | 537 |
1525849 | 1525849 | 2021-07-17 | St. Louis city | Missouri | 29510 | 26022 | 537 |
1522602 | 1522602 | 2021-07-16 | St. Louis city | Missouri | 29510 | 25963 | 535 |
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);