ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 29510 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1519353 | 1519353 | 2021-07-15 | St. Louis city | Missouri | 29510 | 25898 | 534 |
1516106 | 1516106 | 2021-07-14 | St. Louis city | Missouri | 29510 | 25841 | 534 |
1512860 | 1512860 | 2021-07-13 | St. Louis city | Missouri | 29510 | 25803 | 534 |
1509613 | 1509613 | 2021-07-12 | St. Louis city | Missouri | 29510 | 25779 | 534 |
1506367 | 1506367 | 2021-07-11 | St. Louis city | Missouri | 29510 | 25779 | 534 |
1503121 | 1503121 | 2021-07-10 | St. Louis city | Missouri | 29510 | 25761 | 534 |
1499875 | 1499875 | 2021-07-09 | St. Louis city | Missouri | 29510 | 25709 | 534 |
1496629 | 1496629 | 2021-07-08 | St. Louis city | Missouri | 29510 | 25643 | 533 |
1493382 | 1493382 | 2021-07-07 | St. Louis city | Missouri | 29510 | 25612 | 533 |
1490135 | 1490135 | 2021-07-06 | St. Louis city | Missouri | 29510 | 25612 | 533 |
1486888 | 1486888 | 2021-07-05 | St. Louis city | Missouri | 29510 | 25578 | 533 |
1483642 | 1483642 | 2021-07-04 | St. Louis city | Missouri | 29510 | 25543 | 533 |
1480396 | 1480396 | 2021-07-03 | St. Louis city | Missouri | 29510 | 25517 | 532 |
1477149 | 1477149 | 2021-07-02 | St. Louis city | Missouri | 29510 | 25487 | 531 |
1473903 | 1473903 | 2021-07-01 | St. Louis city | Missouri | 29510 | 25487 | 531 |
1470657 | 1470657 | 2021-06-30 | St. Louis city | Missouri | 29510 | 25445 | 531 |
1467412 | 1467412 | 2021-06-29 | St. Louis city | Missouri | 29510 | 25445 | 531 |
1464167 | 1464167 | 2021-06-28 | St. Louis city | Missouri | 29510 | 25413 | 531 |
1460922 | 1460922 | 2021-06-27 | St. Louis city | Missouri | 29510 | 25375 | 531 |
1457677 | 1457677 | 2021-06-26 | St. Louis city | Missouri | 29510 | 25375 | 531 |
1454432 | 1454432 | 2021-06-25 | St. Louis city | Missouri | 29510 | 25357 | 531 |
1451187 | 1451187 | 2021-06-24 | St. Louis city | Missouri | 29510 | 25316 | 530 |
1447941 | 1447941 | 2021-06-23 | St. Louis city | Missouri | 29510 | 25303 | 530 |
1444696 | 1444696 | 2021-06-22 | St. Louis city | Missouri | 29510 | 25303 | 530 |
1441451 | 1441451 | 2021-06-21 | St. Louis city | Missouri | 29510 | 25274 | 530 |
1438205 | 1438205 | 2021-06-20 | St. Louis city | Missouri | 29510 | 25260 | 529 |
1434958 | 1434958 | 2021-06-19 | St. Louis city | Missouri | 29510 | 25260 | 529 |
1431711 | 1431711 | 2021-06-18 | St. Louis city | Missouri | 29510 | 25254 | 529 |
1428466 | 1428466 | 2021-06-17 | St. Louis city | Missouri | 29510 | 25237 | 529 |
1425221 | 1425221 | 2021-06-16 | St. Louis city | Missouri | 29510 | 25231 | 528 |
1421973 | 1421973 | 2021-06-15 | St. Louis city | Missouri | 29510 | 25218 | 528 |
1418728 | 1418728 | 2021-06-14 | St. Louis city | Missouri | 29510 | 25207 | 528 |
1415483 | 1415483 | 2021-06-13 | St. Louis city | Missouri | 29510 | 25177 | 525 |
1412237 | 1412237 | 2021-06-12 | St. Louis city | Missouri | 29510 | 25165 | 525 |
1408992 | 1408992 | 2021-06-11 | St. Louis city | Missouri | 29510 | 25149 | 524 |
1405747 | 1405747 | 2021-06-10 | St. Louis city | Missouri | 29510 | 25149 | 524 |
1402501 | 1402501 | 2021-06-09 | St. Louis city | Missouri | 29510 | 25119 | 518 |
1399256 | 1399256 | 2021-06-08 | St. Louis city | Missouri | 29510 | 25094 | 516 |
1396010 | 1396010 | 2021-06-07 | St. Louis city | Missouri | 29510 | 25094 | 516 |
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);