ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "St. Louis" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1844207 | 1844207 | 2021-10-23 | St. Louis | Missouri | 29189 | 128895 | 2540 |
1840957 | 1840957 | 2021-10-22 | St. Louis | Missouri | 29189 | 128725 | 2540 |
1837708 | 1837708 | 2021-10-21 | St. Louis | Missouri | 29189 | 128583 | 2537 |
1834459 | 1834459 | 2021-10-20 | St. Louis | Missouri | 29189 | 128341 | 2536 |
1831210 | 1831210 | 2021-10-19 | St. Louis | Missouri | 29189 | 128188 | 2533 |
1827961 | 1827961 | 2021-10-18 | St. Louis | Missouri | 29189 | 128042 | 2525 |
1824712 | 1824712 | 2021-10-17 | St. Louis | Missouri | 29189 | 127979 | 2525 |
1821463 | 1821463 | 2021-10-16 | St. Louis | Missouri | 29189 | 127881 | 2525 |
1818214 | 1818214 | 2021-10-15 | St. Louis | Missouri | 29189 | 127734 | 2525 |
1814965 | 1814965 | 2021-10-14 | St. Louis | Missouri | 29189 | 127537 | 2523 |
1811717 | 1811717 | 2021-10-13 | St. Louis | Missouri | 29189 | 127275 | 2504 |
1808468 | 1808468 | 2021-10-12 | St. Louis | Missouri | 29189 | 127110 | 2503 |
1805217 | 1805217 | 2021-10-11 | St. Louis | Missouri | 29189 | 126967 | 2502 |
1801968 | 1801968 | 2021-10-10 | St. Louis | Missouri | 29189 | 126807 | 2499 |
1798719 | 1798719 | 2021-10-09 | St. Louis | Missouri | 29189 | 126697 | 2499 |
1795470 | 1795470 | 2021-10-08 | St. Louis | Missouri | 29189 | 126547 | 2498 |
1792221 | 1792221 | 2021-10-07 | St. Louis | Missouri | 29189 | 126360 | 2498 |
1788972 | 1788972 | 2021-10-06 | St. Louis | Missouri | 29189 | 126195 | 2496 |
1785724 | 1785724 | 2021-10-05 | St. Louis | Missouri | 29189 | 125986 | 2482 |
1782475 | 1782475 | 2021-10-04 | St. Louis | Missouri | 29189 | 125754 | 2481 |
1779225 | 1779225 | 2021-10-03 | St. Louis | Missouri | 29189 | 125602 | 2481 |
1775975 | 1775975 | 2021-10-02 | St. Louis | Missouri | 29189 | 125435 | 2481 |
1772725 | 1772725 | 2021-10-01 | St. Louis | Missouri | 29189 | 125223 | 2480 |
1769476 | 1769476 | 2021-09-30 | St. Louis | Missouri | 29189 | 125021 | 2476 |
1766227 | 1766227 | 2021-09-29 | St. Louis | Missouri | 29189 | 124661 | 2473 |
1762978 | 1762978 | 2021-09-28 | St. Louis | Missouri | 29189 | 124495 | 2466 |
1759729 | 1759729 | 2021-09-27 | St. Louis | Missouri | 29189 | 124191 | 2463 |
1756481 | 1756481 | 2021-09-26 | St. Louis | Missouri | 29189 | 124073 | 2463 |
1753233 | 1753233 | 2021-09-25 | St. Louis | Missouri | 29189 | 123912 | 2463 |
1749985 | 1749985 | 2021-09-24 | St. Louis | Missouri | 29189 | 123672 | 2459 |
1746735 | 1746735 | 2021-09-23 | St. Louis | Missouri | 29189 | 123383 | 2458 |
1743486 | 1743486 | 2021-09-22 | St. Louis | Missouri | 29189 | 123087 | 2452 |
1740237 | 1740237 | 2021-09-21 | St. Louis | Missouri | 29189 | 122825 | 2452 |
1736988 | 1736988 | 2021-09-20 | St. Louis | Missouri | 29189 | 122509 | 2430 |
1733738 | 1733738 | 2021-09-19 | St. Louis | Missouri | 29189 | 122333 | 2430 |
1730488 | 1730488 | 2021-09-18 | St. Louis | Missouri | 29189 | 122155 | 2430 |
1727238 | 1727238 | 2021-09-17 | St. Louis | Missouri | 29189 | 121898 | 2430 |
1723989 | 1723989 | 2021-09-16 | St. Louis | Missouri | 29189 | 121544 | 2430 |
1720740 | 1720740 | 2021-09-15 | St. Louis | Missouri | 29189 | 121255 | 2425 |
1717492 | 1717492 | 2021-09-14 | St. Louis | Missouri | 29189 | 120963 | 2415 |
1714244 | 1714244 | 2021-09-13 | St. Louis | Missouri | 29189 | 120643 | 2415 |
1710998 | 1710998 | 2021-09-12 | St. Louis | Missouri | 29189 | 120408 | 2415 |
1707751 | 1707751 | 2021-09-11 | St. Louis | Missouri | 29189 | 120233 | 2415 |
1704504 | 1704504 | 2021-09-10 | St. Louis | Missouri | 29189 | 119948 | 2414 |
1701254 | 1701254 | 2021-09-09 | St. Louis | Missouri | 29189 | 119584 | 2413 |
1698005 | 1698005 | 2021-09-08 | St. Louis | Missouri | 29189 | 119245 | 2409 |
1694757 | 1694757 | 2021-09-07 | St. Louis | Missouri | 29189 | 118910 | 2404 |
1691508 | 1691508 | 2021-09-06 | St. Louis | Missouri | 29189 | 118773 | 2404 |
1688258 | 1688258 | 2021-09-05 | St. Louis | Missouri | 29189 | 118689 | 2404 |
1685008 | 1685008 | 2021-09-04 | St. Louis | Missouri | 29189 | 118460 | 2399 |
1681757 | 1681757 | 2021-09-03 | St. Louis | Missouri | 29189 | 118129 | 2397 |
1678509 | 1678509 | 2021-09-02 | St. Louis | Missouri | 29189 | 117788 | 2396 |
1675261 | 1675261 | 2021-09-01 | St. Louis | Missouri | 29189 | 117433 | 2394 |
1672013 | 1672013 | 2021-08-31 | St. Louis | Missouri | 29189 | 117110 | 2375 |
1668766 | 1668766 | 2021-08-30 | St. Louis | Missouri | 29189 | 116813 | 2369 |
1665519 | 1665519 | 2021-08-29 | St. Louis | Missouri | 29189 | 116439 | 2369 |
1662271 | 1662271 | 2021-08-28 | St. Louis | Missouri | 29189 | 116424 | 2369 |
1659023 | 1659023 | 2021-08-27 | St. Louis | Missouri | 29189 | 116138 | 2369 |
1655774 | 1655774 | 2021-08-26 | St. Louis | Missouri | 29189 | 115803 | 2368 |
1652527 | 1652527 | 2021-08-25 | St. Louis | Missouri | 29189 | 115507 | 2366 |
1649279 | 1649279 | 2021-08-24 | St. Louis | Missouri | 29189 | 115210 | 2364 |
1646030 | 1646030 | 2021-08-23 | St. Louis | Missouri | 29189 | 114844 | 2354 |
1642781 | 1642781 | 2021-08-22 | St. Louis | Missouri | 29189 | 114636 | 2354 |
1639531 | 1639531 | 2021-08-21 | St. Louis | Missouri | 29189 | 114469 | 2354 |
1636281 | 1636281 | 2021-08-20 | St. Louis | Missouri | 29189 | 114221 | 2349 |
1633031 | 1633031 | 2021-08-19 | St. Louis | Missouri | 29189 | 113905 | 2349 |
1629784 | 1629784 | 2021-08-18 | St. Louis | Missouri | 29189 | 113707 | 2347 |
1626537 | 1626537 | 2021-08-17 | St. Louis | Missouri | 29189 | 113289 | 2345 |
1623290 | 1623290 | 2021-08-16 | St. Louis | Missouri | 29189 | 113017 | 2340 |
1620043 | 1620043 | 2021-08-15 | St. Louis | Missouri | 29189 | 112885 | 2340 |
1616795 | 1616795 | 2021-08-14 | St. Louis | Missouri | 29189 | 112696 | 2340 |
1613547 | 1613547 | 2021-08-13 | St. Louis | Missouri | 29189 | 112284 | 2340 |
1610298 | 1610298 | 2021-08-12 | St. Louis | Missouri | 29189 | 112052 | 2337 |
1607050 | 1607050 | 2021-08-11 | St. Louis | Missouri | 29189 | 111692 | 2335 |
1603801 | 1603801 | 2021-08-10 | St. Louis | Missouri | 29189 | 111161 | 2333 |
1600552 | 1600552 | 2021-08-09 | St. Louis | Missouri | 29189 | 110831 | 2325 |
1597304 | 1597304 | 2021-08-08 | St. Louis | Missouri | 29189 | 110690 | 2325 |
1594055 | 1594055 | 2021-08-07 | St. Louis | Missouri | 29189 | 110519 | 2325 |
1590806 | 1590806 | 2021-08-06 | St. Louis | Missouri | 29189 | 110201 | 2324 |
1587557 | 1587557 | 2021-08-05 | St. Louis | Missouri | 29189 | 109887 | 2323 |
1584306 | 1584306 | 2021-08-04 | St. Louis | Missouri | 29189 | 109421 | 2322 |
1581057 | 1581057 | 2021-08-03 | St. Louis | Missouri | 29189 | 108899 | 2320 |
1577808 | 1577808 | 2021-08-02 | St. Louis | Missouri | 29189 | 108592 | 2313 |
1574560 | 1574560 | 2021-08-01 | St. Louis | Missouri | 29189 | 108487 | 2311 |
1571312 | 1571312 | 2021-07-31 | St. Louis | Missouri | 29189 | 108225 | 2309 |
1568064 | 1568064 | 2021-07-30 | St. Louis | Missouri | 29189 | 107888 | 2307 |
1564816 | 1564816 | 2021-07-29 | St. Louis | Missouri | 29189 | 107571 | 2305 |
1561568 | 1561568 | 2021-07-28 | St. Louis | Missouri | 29189 | 107132 | 2304 |
1558320 | 1558320 | 2021-07-27 | St. Louis | Missouri | 29189 | 106864 | 2299 |
1555073 | 1555073 | 2021-07-26 | St. Louis | Missouri | 29189 | 106523 | 2293 |
1551826 | 1551826 | 2021-07-25 | St. Louis | Missouri | 29189 | 106359 | 2293 |
1548579 | 1548579 | 2021-07-24 | St. Louis | Missouri | 29189 | 106194 | 2293 |
1545332 | 1545332 | 2021-07-23 | St. Louis | Missouri | 29189 | 105603 | 2291 |
1542084 | 1542084 | 2021-07-22 | St. Louis | Missouri | 29189 | 105340 | 2291 |
1538837 | 1538837 | 2021-07-21 | St. Louis | Missouri | 29189 | 105094 | 2291 |
1535590 | 1535590 | 2021-07-20 | St. Louis | Missouri | 29189 | 104806 | 2290 |
1532342 | 1532342 | 2021-07-19 | St. Louis | Missouri | 29189 | 104456 | 2288 |
1529095 | 1529095 | 2021-07-18 | St. Louis | Missouri | 29189 | 104382 | 2286 |
1525848 | 1525848 | 2021-07-17 | St. Louis | Missouri | 29189 | 104281 | 2286 |
1522601 | 1522601 | 2021-07-16 | St. Louis | Missouri | 29189 | 104043 | 2286 |
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);