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" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175796 | 2175796 | 2022-02-02 | St. Louis city | Missouri | 29510 | 54164 | 710 |
2172543 | 2172543 | 2022-02-01 | St. Louis city | Missouri | 29510 | 53936 | 707 |
2169290 | 2169290 | 2022-01-31 | St. Louis city | Missouri | 29510 | 53792 | 703 |
2166035 | 2166035 | 2022-01-30 | St. Louis city | Missouri | 29510 | 53689 | 703 |
2162780 | 2162780 | 2022-01-29 | St. Louis city | Missouri | 29510 | 53603 | 702 |
2159525 | 2159525 | 2022-01-28 | St. Louis city | Missouri | 29510 | 53312 | 702 |
2156271 | 2156271 | 2022-01-27 | St. Louis city | Missouri | 29510 | 53086 | 698 |
2153018 | 2153018 | 2022-01-26 | St. Louis city | Missouri | 29510 | 52825 | 698 |
2149766 | 2149766 | 2022-01-25 | St. Louis city | Missouri | 29510 | 52531 | 694 |
2146514 | 2146514 | 2022-01-24 | St. Louis city | Missouri | 29510 | 52272 | 689 |
2143259 | 2143259 | 2022-01-23 | St. Louis city | Missouri | 29510 | 52079 | 688 |
2140004 | 2140004 | 2022-01-22 | St. Louis city | Missouri | 29510 | 51811 | 687 |
2136748 | 2136748 | 2022-01-21 | St. Louis city | Missouri | 29510 | 51498 | 687 |
2133496 | 2133496 | 2022-01-20 | St. Louis city | Missouri | 29510 | 51054 | 685 |
2130243 | 2130243 | 2022-01-19 | St. Louis city | Missouri | 29510 | 50483 | 673 |
2126989 | 2126989 | 2022-01-18 | St. Louis city | Missouri | 29510 | 50204 | 673 |
2123737 | 2123737 | 2022-01-17 | St. Louis city | Missouri | 29510 | 49281 | 668 |
2120485 | 2120485 | 2022-01-16 | St. Louis city | Missouri | 29510 | 49281 | 668 |
2117233 | 2117233 | 2022-01-15 | St. Louis city | Missouri | 29510 | 49275 | 668 |
2113982 | 2113982 | 2022-01-14 | St. Louis city | Missouri | 29510 | 48502 | 668 |
2110730 | 2110730 | 2022-01-13 | St. Louis city | Missouri | 29510 | 48068 | 664 |
2107479 | 2107479 | 2022-01-12 | St. Louis city | Missouri | 29510 | 47414 | 664 |
2104228 | 2104228 | 2022-01-11 | St. Louis city | Missouri | 29510 | 46853 | 661 |
2100977 | 2100977 | 2022-01-10 | St. Louis city | Missouri | 29510 | 46161 | 661 |
2097726 | 2097726 | 2022-01-09 | St. Louis city | Missouri | 29510 | 45572 | 660 |
2094474 | 2094474 | 2022-01-08 | St. Louis city | Missouri | 29510 | 45308 | 660 |
2091222 | 2091222 | 2022-01-07 | St. Louis city | Missouri | 29510 | 44221 | 657 |
2087971 | 2087971 | 2022-01-06 | St. Louis city | Missouri | 29510 | 43362 | 653 |
2084719 | 2084719 | 2022-01-05 | St. Louis city | Missouri | 29510 | 42534 | 652 |
2081467 | 2081467 | 2022-01-04 | St. Louis city | Missouri | 29510 | 41645 | 650 |
2078215 | 2078215 | 2022-01-03 | St. Louis city | Missouri | 29510 | 41117 | 646 |
2074964 | 2074964 | 2022-01-02 | St. Louis city | Missouri | 29510 | 38978 | 645 |
2071713 | 2071713 | 2022-01-01 | St. Louis city | Missouri | 29510 | 38978 | 642 |
2068462 | 2068462 | 2021-12-31 | St. Louis city | Missouri | 29510 | 38978 | 638 |
2065211 | 2065211 | 2021-12-30 | St. Louis city | Missouri | 29510 | 38978 | 638 |
2061961 | 2061961 | 2021-12-29 | St. Louis city | Missouri | 29510 | 38401 | 638 |
2058712 | 2058712 | 2021-12-28 | St. Louis city | Missouri | 29510 | 37871 | 637 |
2055463 | 2055463 | 2021-12-27 | St. Louis city | Missouri | 29510 | 37528 | 636 |
2052213 | 2052213 | 2021-12-26 | St. Louis city | Missouri | 29510 | 36781 | 636 |
2048963 | 2048963 | 2021-12-25 | St. Louis city | Missouri | 29510 | 36781 | 636 |
2045713 | 2045713 | 2021-12-24 | St. Louis city | Missouri | 29510 | 36781 | 636 |
2042463 | 2042463 | 2021-12-23 | St. Louis city | Missouri | 29510 | 36779 | 636 |
2039214 | 2039214 | 2021-12-22 | St. Louis city | Missouri | 29510 | 36365 | 635 |
2035964 | 2035964 | 2021-12-21 | St. Louis city | Missouri | 29510 | 36202 | 635 |
2032714 | 2032714 | 2021-12-20 | St. Louis city | Missouri | 29510 | 36098 | 635 |
2029463 | 2029463 | 2021-12-19 | St. Louis city | Missouri | 29510 | 36016 | 635 |
2026212 | 2026212 | 2021-12-18 | St. Louis city | Missouri | 29510 | 35925 | 635 |
2022961 | 2022961 | 2021-12-17 | St. Louis city | Missouri | 29510 | 35769 | 635 |
2019710 | 2019710 | 2021-12-16 | St. Louis city | Missouri | 29510 | 35682 | 634 |
2016460 | 2016460 | 2021-12-15 | St. Louis city | Missouri | 29510 | 35544 | 634 |
2013209 | 2013209 | 2021-12-14 | St. Louis city | Missouri | 29510 | 35442 | 631 |
2009958 | 2009958 | 2021-12-13 | St. Louis city | Missouri | 29510 | 35361 | 628 |
2006707 | 2006707 | 2021-12-12 | St. Louis city | Missouri | 29510 | 35308 | 628 |
2003456 | 2003456 | 2021-12-11 | St. Louis city | Missouri | 29510 | 35257 | 628 |
2000206 | 2000206 | 2021-12-10 | St. Louis city | Missouri | 29510 | 35191 | 628 |
1996955 | 1996955 | 2021-12-09 | St. Louis city | Missouri | 29510 | 35096 | 626 |
1993704 | 1993704 | 2021-12-08 | St. Louis city | Missouri | 29510 | 34992 | 626 |
1990453 | 1990453 | 2021-12-07 | St. Louis city | Missouri | 29510 | 34879 | 625 |
1987203 | 1987203 | 2021-12-06 | St. Louis city | Missouri | 29510 | 34801 | 625 |
1983953 | 1983953 | 2021-12-05 | St. Louis city | Missouri | 29510 | 34668 | 624 |
1980703 | 1980703 | 2021-12-04 | St. Louis city | Missouri | 29510 | 34614 | 624 |
1977453 | 1977453 | 2021-12-03 | St. Louis city | Missouri | 29510 | 34483 | 622 |
1974203 | 1974203 | 2021-12-02 | St. Louis city | Missouri | 29510 | 34483 | 620 |
1970954 | 1970954 | 2021-12-01 | St. Louis city | Missouri | 29510 | 34388 | 620 |
1967704 | 1967704 | 2021-11-30 | St. Louis city | Missouri | 29510 | 34305 | 620 |
1964452 | 1964452 | 2021-11-29 | St. Louis city | Missouri | 29510 | 34243 | 620 |
1961201 | 1961201 | 2021-11-28 | St. Louis city | Missouri | 29510 | 33999 | 620 |
1957950 | 1957950 | 2021-11-27 | St. Louis city | Missouri | 29510 | 33999 | 620 |
1954699 | 1954699 | 2021-11-26 | St. Louis city | Missouri | 29510 | 33999 | 620 |
1951448 | 1951448 | 2021-11-25 | St. Louis city | Missouri | 29510 | 33999 | 620 |
1948197 | 1948197 | 2021-11-24 | St. Louis city | Missouri | 29510 | 33999 | 620 |
1944946 | 1944946 | 2021-11-23 | St. Louis city | Missouri | 29510 | 33923 | 619 |
1941695 | 1941695 | 2021-11-22 | St. Louis city | Missouri | 29510 | 33866 | 619 |
1938445 | 1938445 | 2021-11-21 | St. Louis city | Missouri | 29510 | 33838 | 619 |
1935195 | 1935195 | 2021-11-20 | St. Louis city | Missouri | 29510 | 33809 | 619 |
1931945 | 1931945 | 2021-11-19 | St. Louis city | Missouri | 29510 | 33758 | 617 |
1928694 | 1928694 | 2021-11-18 | St. Louis city | Missouri | 29510 | 33706 | 613 |
1925444 | 1925444 | 2021-11-17 | St. Louis city | Missouri | 29510 | 33331 | 613 |
1922195 | 1922195 | 2021-11-16 | St. Louis city | Missouri | 29510 | 33272 | 613 |
1918945 | 1918945 | 2021-11-15 | St. Louis city | Missouri | 29510 | 33228 | 613 |
1915695 | 1915695 | 2021-11-14 | St. Louis city | Missouri | 29510 | 33196 | 613 |
1912445 | 1912445 | 2021-11-13 | St. Louis city | Missouri | 29510 | 33147 | 613 |
1909195 | 1909195 | 2021-11-12 | St. Louis city | Missouri | 29510 | 33071 | 613 |
1905946 | 1905946 | 2021-11-11 | St. Louis city | Missouri | 29510 | 32972 | 613 |
1902697 | 1902697 | 2021-11-10 | St. Louis city | Missouri | 29510 | 32972 | 613 |
1899447 | 1899447 | 2021-11-09 | St. Louis city | Missouri | 29510 | 32938 | 613 |
1896197 | 1896197 | 2021-11-08 | St. Louis city | Missouri | 29510 | 32904 | 612 |
1892947 | 1892947 | 2021-11-07 | St. Louis city | Missouri | 29510 | 32870 | 612 |
1889697 | 1889697 | 2021-11-06 | St. Louis city | Missouri | 29510 | 32840 | 612 |
1886447 | 1886447 | 2021-11-05 | St. Louis city | Missouri | 29510 | 32790 | 612 |
1883198 | 1883198 | 2021-11-04 | St. Louis city | Missouri | 29510 | 32742 | 611 |
1879949 | 1879949 | 2021-11-03 | St. Louis city | Missouri | 29510 | 32703 | 610 |
1876700 | 1876700 | 2021-11-02 | St. Louis city | Missouri | 29510 | 32660 | 610 |
1873451 | 1873451 | 2021-11-01 | St. Louis city | Missouri | 29510 | 32636 | 610 |
1870202 | 1870202 | 2021-10-31 | St. Louis city | Missouri | 29510 | 32612 | 609 |
1866953 | 1866953 | 2021-10-30 | St. Louis city | Missouri | 29510 | 32595 | 606 |
1863704 | 1863704 | 2021-10-29 | St. Louis city | Missouri | 29510 | 32564 | 604 |
1860455 | 1860455 | 2021-10-28 | St. Louis city | Missouri | 29510 | 32515 | 604 |
1857206 | 1857206 | 2021-10-27 | St. Louis city | Missouri | 29510 | 32480 | 602 |
1853957 | 1853957 | 2021-10-26 | St. Louis city | Missouri | 29510 | 32426 | 602 |
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);