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 |
---|---|---|---|---|---|---|---|
2175795 | 2175795 | 2022-02-02 | St. Louis | Missouri | 29189 | 212711 | 3005 |
2172542 | 2172542 | 2022-02-01 | St. Louis | Missouri | 29189 | 211558 | 2985 |
2169289 | 2169289 | 2022-01-31 | St. Louis | Missouri | 29189 | 210980 | 2973 |
2166034 | 2166034 | 2022-01-30 | St. Louis | Missouri | 29189 | 209292 | 2964 |
2162779 | 2162779 | 2022-01-29 | St. Louis | Missouri | 29189 | 209292 | 2964 |
2159524 | 2159524 | 2022-01-28 | St. Louis | Missouri | 29189 | 208980 | 2963 |
2156270 | 2156270 | 2022-01-27 | St. Louis | Missouri | 29189 | 207892 | 2945 |
2153017 | 2153017 | 2022-01-26 | St. Louis | Missouri | 29189 | 207248 | 2938 |
2149765 | 2149765 | 2022-01-25 | St. Louis | Missouri | 29189 | 205883 | 2927 |
2146513 | 2146513 | 2022-01-24 | St. Louis | Missouri | 29189 | 204931 | 2916 |
2143258 | 2143258 | 2022-01-23 | St. Louis | Missouri | 29189 | 202803 | 2912 |
2140003 | 2140003 | 2022-01-22 | St. Louis | Missouri | 29189 | 202803 | 2912 |
2136747 | 2136747 | 2022-01-21 | St. Louis | Missouri | 29189 | 201929 | 2907 |
2133495 | 2133495 | 2022-01-20 | St. Louis | Missouri | 29189 | 199982 | 2898 |
2130242 | 2130242 | 2022-01-19 | St. Louis | Missouri | 29189 | 198450 | 2887 |
2126988 | 2126988 | 2022-01-18 | St. Louis | Missouri | 29189 | 196441 | 2872 |
2123736 | 2123736 | 2022-01-17 | St. Louis | Missouri | 29189 | 192949 | 2855 |
2120484 | 2120484 | 2022-01-16 | St. Louis | Missouri | 29189 | 192949 | 2855 |
2117232 | 2117232 | 2022-01-15 | St. Louis | Missouri | 29189 | 192949 | 2855 |
2113981 | 2113981 | 2022-01-14 | St. Louis | Missouri | 29189 | 189487 | 2838 |
2110729 | 2110729 | 2022-01-13 | St. Louis | Missouri | 29189 | 187912 | 2835 |
2107478 | 2107478 | 2022-01-12 | St. Louis | Missouri | 29189 | 185306 | 2829 |
2104227 | 2104227 | 2022-01-11 | St. Louis | Missouri | 29189 | 182521 | 2811 |
2100976 | 2100976 | 2022-01-10 | St. Louis | Missouri | 29189 | 180545 | 2791 |
2097725 | 2097725 | 2022-01-09 | St. Louis | Missouri | 29189 | 179257 | 2790 |
2094473 | 2094473 | 2022-01-08 | St. Louis | Missouri | 29189 | 175124 | 2788 |
2091221 | 2091221 | 2022-01-07 | St. Louis | Missouri | 29189 | 173630 | 2780 |
2087970 | 2087970 | 2022-01-06 | St. Louis | Missouri | 29189 | 170590 | 2780 |
2084718 | 2084718 | 2022-01-05 | St. Louis | Missouri | 29189 | 167487 | 2767 |
2081466 | 2081466 | 2022-01-04 | St. Louis | Missouri | 29189 | 164187 | 2747 |
2078214 | 2078214 | 2022-01-03 | St. Louis | Missouri | 29189 | 161710 | 2745 |
2074963 | 2074963 | 2022-01-02 | St. Louis | Missouri | 29189 | 160389 | 2742 |
2071712 | 2071712 | 2022-01-01 | St. Louis | Missouri | 29189 | 154468 | 2739 |
2068461 | 2068461 | 2021-12-31 | St. Louis | Missouri | 29189 | 154468 | 2739 |
2065210 | 2065210 | 2021-12-30 | St. Louis | Missouri | 29189 | 154468 | 2739 |
2061960 | 2061960 | 2021-12-29 | St. Louis | Missouri | 29189 | 151643 | 2725 |
2058711 | 2058711 | 2021-12-28 | St. Louis | Missouri | 29189 | 150069 | 2722 |
2055462 | 2055462 | 2021-12-27 | St. Louis | Missouri | 29189 | 148175 | 2714 |
2052212 | 2052212 | 2021-12-26 | St. Louis | Missouri | 29189 | 147868 | 2712 |
2048962 | 2048962 | 2021-12-25 | St. Louis | Missouri | 29189 | 145630 | 2708 |
2045712 | 2045712 | 2021-12-24 | St. Louis | Missouri | 29189 | 145630 | 2708 |
2042462 | 2042462 | 2021-12-23 | St. Louis | Missouri | 29189 | 145630 | 2708 |
2039213 | 2039213 | 2021-12-22 | St. Louis | Missouri | 29189 | 144627 | 2708 |
2035963 | 2035963 | 2021-12-21 | St. Louis | Missouri | 29189 | 143861 | 2695 |
2032713 | 2032713 | 2021-12-20 | St. Louis | Missouri | 29189 | 143268 | 2691 |
2029462 | 2029462 | 2021-12-19 | St. Louis | Missouri | 29189 | 143067 | 2691 |
2026211 | 2026211 | 2021-12-18 | St. Louis | Missouri | 29189 | 142756 | 2690 |
2022960 | 2022960 | 2021-12-17 | St. Louis | Missouri | 29189 | 142294 | 2688 |
2019709 | 2019709 | 2021-12-16 | St. Louis | Missouri | 29189 | 141749 | 2682 |
2016459 | 2016459 | 2021-12-15 | St. Louis | Missouri | 29189 | 141207 | 2679 |
2013208 | 2013208 | 2021-12-14 | St. Louis | Missouri | 29189 | 140911 | 2672 |
2009957 | 2009957 | 2021-12-13 | St. Louis | Missouri | 29189 | 140452 | 2667 |
2006706 | 2006706 | 2021-12-12 | St. Louis | Missouri | 29189 | 139988 | 2665 |
2003455 | 2003455 | 2021-12-11 | St. Louis | Missouri | 29189 | 139988 | 2665 |
2000205 | 2000205 | 2021-12-10 | St. Louis | Missouri | 29189 | 139825 | 2663 |
1996954 | 1996954 | 2021-12-09 | St. Louis | Missouri | 29189 | 139111 | 2658 |
1993703 | 1993703 | 2021-12-08 | St. Louis | Missouri | 29189 | 138651 | 2652 |
1990452 | 1990452 | 2021-12-07 | St. Louis | Missouri | 29189 | 138380 | 2650 |
1987202 | 1987202 | 2021-12-06 | St. Louis | Missouri | 29189 | 137925 | 2634 |
1983952 | 1983952 | 2021-12-05 | St. Louis | Missouri | 29189 | 137612 | 2633 |
1980702 | 1980702 | 2021-12-04 | St. Louis | Missouri | 29189 | 137428 | 2633 |
1977452 | 1977452 | 2021-12-03 | St. Louis | Missouri | 29189 | 137085 | 2627 |
1974202 | 1974202 | 2021-12-02 | St. Louis | Missouri | 29189 | 136816 | 2627 |
1970953 | 1970953 | 2021-12-01 | St. Louis | Missouri | 29189 | 136270 | 2620 |
1967703 | 1967703 | 2021-11-30 | St. Louis | Missouri | 29189 | 135882 | 2618 |
1964451 | 1964451 | 2021-11-29 | St. Louis | Missouri | 29189 | 135356 | 2617 |
1961200 | 1961200 | 2021-11-28 | St. Louis | Missouri | 29189 | 135280 | 2617 |
1957949 | 1957949 | 2021-11-27 | St. Louis | Missouri | 29189 | 135111 | 2616 |
1954698 | 1954698 | 2021-11-26 | St. Louis | Missouri | 29189 | 134456 | 2613 |
1951447 | 1951447 | 2021-11-25 | St. Louis | Missouri | 29189 | 134456 | 2613 |
1948196 | 1948196 | 2021-11-24 | St. Louis | Missouri | 29189 | 134456 | 2613 |
1944945 | 1944945 | 2021-11-23 | St. Louis | Missouri | 29189 | 134338 | 2606 |
1941694 | 1941694 | 2021-11-22 | St. Louis | Missouri | 29189 | 134005 | 2601 |
1938444 | 1938444 | 2021-11-21 | St. Louis | Missouri | 29189 | 133395 | 2594 |
1935194 | 1935194 | 2021-11-20 | St. Louis | Missouri | 29189 | 133395 | 2594 |
1931944 | 1931944 | 2021-11-19 | St. Louis | Missouri | 29189 | 133395 | 2594 |
1928693 | 1928693 | 2021-11-18 | St. Louis | Missouri | 29189 | 133184 | 2593 |
1925443 | 1925443 | 2021-11-17 | St. Louis | Missouri | 29189 | 132798 | 2593 |
1922194 | 1922194 | 2021-11-16 | St. Louis | Missouri | 29189 | 132646 | 2593 |
1918944 | 1918944 | 2021-11-15 | St. Louis | Missouri | 29189 | 132430 | 2593 |
1915694 | 1915694 | 2021-11-14 | St. Louis | Missouri | 29189 | 132329 | 2593 |
1912444 | 1912444 | 2021-11-13 | St. Louis | Missouri | 29189 | 132225 | 2593 |
1909194 | 1909194 | 2021-11-12 | St. Louis | Missouri | 29189 | 131982 | 2593 |
1905945 | 1905945 | 2021-11-11 | St. Louis | Missouri | 29189 | 131492 | 2587 |
1902696 | 1902696 | 2021-11-10 | St. Louis | Missouri | 29189 | 131492 | 2587 |
1899446 | 1899446 | 2021-11-09 | St. Louis | Missouri | 29189 | 131214 | 2556 |
1896196 | 1896196 | 2021-11-08 | St. Louis | Missouri | 29189 | 130946 | 2555 |
1892946 | 1892946 | 2021-11-07 | St. Louis | Missouri | 29189 | 130838 | 2555 |
1889696 | 1889696 | 2021-11-06 | St. Louis | Missouri | 29189 | 130726 | 2555 |
1886446 | 1886446 | 2021-11-05 | St. Louis | Missouri | 29189 | 130539 | 2555 |
1883197 | 1883197 | 2021-11-04 | St. Louis | Missouri | 29189 | 130399 | 2552 |
1879948 | 1879948 | 2021-11-03 | St. Louis | Missouri | 29189 | 130239 | 2552 |
1876699 | 1876699 | 2021-11-02 | St. Louis | Missouri | 29189 | 130072 | 2552 |
1873450 | 1873450 | 2021-11-01 | St. Louis | Missouri | 29189 | 129929 | 2550 |
1870201 | 1870201 | 2021-10-31 | St. Louis | Missouri | 29189 | 129855 | 2550 |
1866952 | 1866952 | 2021-10-30 | St. Louis | Missouri | 29189 | 129736 | 2550 |
1863703 | 1863703 | 2021-10-29 | St. Louis | Missouri | 29189 | 129610 | 2550 |
1860454 | 1860454 | 2021-10-28 | St. Louis | Missouri | 29189 | 129476 | 2550 |
1857205 | 1857205 | 2021-10-27 | St. Louis | Missouri | 29189 | 129317 | 2550 |
1853956 | 1853956 | 2021-10-26 | St. Louis | Missouri | 29189 | 129171 | 2542 |
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);