ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29135 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175762 | 2175762 | 2022-02-02 | Moniteau | Missouri | 29135 | 3693 | 49 |
2172509 | 2172509 | 2022-02-01 | Moniteau | Missouri | 29135 | 3674 | 49 |
2169256 | 2169256 | 2022-01-31 | Moniteau | Missouri | 29135 | 3660 | 48 |
2166001 | 2166001 | 2022-01-30 | Moniteau | Missouri | 29135 | 3656 | 48 |
2162746 | 2162746 | 2022-01-29 | Moniteau | Missouri | 29135 | 3652 | 48 |
2159491 | 2159491 | 2022-01-28 | Moniteau | Missouri | 29135 | 3625 | 48 |
2156237 | 2156237 | 2022-01-27 | Moniteau | Missouri | 29135 | 3609 | 48 |
2152984 | 2152984 | 2022-01-26 | Moniteau | Missouri | 29135 | 3588 | 48 |
2149732 | 2149732 | 2022-01-25 | Moniteau | Missouri | 29135 | 3551 | 48 |
2146480 | 2146480 | 2022-01-24 | Moniteau | Missouri | 29135 | 3496 | 48 |
2143225 | 2143225 | 2022-01-23 | Moniteau | Missouri | 29135 | 3493 | 48 |
2139970 | 2139970 | 2022-01-22 | Moniteau | Missouri | 29135 | 3486 | 48 |
2136714 | 2136714 | 2022-01-21 | Moniteau | Missouri | 29135 | 3461 | 48 |
2133462 | 2133462 | 2022-01-20 | Moniteau | Missouri | 29135 | 3416 | 48 |
2130209 | 2130209 | 2022-01-19 | Moniteau | Missouri | 29135 | 3350 | 47 |
2126955 | 2126955 | 2022-01-18 | Moniteau | Missouri | 29135 | 3301 | 47 |
2123703 | 2123703 | 2022-01-17 | Moniteau | Missouri | 29135 | 3216 | 47 |
2120451 | 2120451 | 2022-01-16 | Moniteau | Missouri | 29135 | 3216 | 47 |
2117199 | 2117199 | 2022-01-15 | Moniteau | Missouri | 29135 | 3216 | 47 |
2113948 | 2113948 | 2022-01-14 | Moniteau | Missouri | 29135 | 3169 | 47 |
2110696 | 2110696 | 2022-01-13 | Moniteau | Missouri | 29135 | 3153 | 47 |
2107445 | 2107445 | 2022-01-12 | Moniteau | Missouri | 29135 | 3123 | 46 |
2104194 | 2104194 | 2022-01-11 | Moniteau | Missouri | 29135 | 3096 | 46 |
2100943 | 2100943 | 2022-01-10 | Moniteau | Missouri | 29135 | 3064 | 46 |
2097692 | 2097692 | 2022-01-09 | Moniteau | Missouri | 29135 | 3057 | 46 |
2094440 | 2094440 | 2022-01-08 | Moniteau | Missouri | 29135 | 3057 | 46 |
2091188 | 2091188 | 2022-01-07 | Moniteau | Missouri | 29135 | 3028 | 46 |
2087937 | 2087937 | 2022-01-06 | Moniteau | Missouri | 29135 | 3022 | 46 |
2084685 | 2084685 | 2022-01-05 | Moniteau | Missouri | 29135 | 3008 | 46 |
2081433 | 2081433 | 2022-01-04 | Moniteau | Missouri | 29135 | 2991 | 46 |
2078181 | 2078181 | 2022-01-03 | Moniteau | Missouri | 29135 | 2985 | 46 |
2074930 | 2074930 | 2022-01-02 | Moniteau | Missouri | 29135 | 2979 | 46 |
2071679 | 2071679 | 2022-01-01 | Moniteau | Missouri | 29135 | 2979 | 46 |
2068428 | 2068428 | 2021-12-31 | Moniteau | Missouri | 29135 | 2979 | 46 |
2065177 | 2065177 | 2021-12-30 | Moniteau | Missouri | 29135 | 2979 | 46 |
2061927 | 2061927 | 2021-12-29 | Moniteau | Missouri | 29135 | 2966 | 46 |
2058678 | 2058678 | 2021-12-28 | Moniteau | Missouri | 29135 | 2958 | 46 |
2055429 | 2055429 | 2021-12-27 | Moniteau | Missouri | 29135 | 2942 | 46 |
2052179 | 2052179 | 2021-12-26 | Moniteau | Missouri | 29135 | 2935 | 46 |
2048929 | 2048929 | 2021-12-25 | Moniteau | Missouri | 29135 | 2935 | 46 |
2045679 | 2045679 | 2021-12-24 | Moniteau | Missouri | 29135 | 2935 | 46 |
2042429 | 2042429 | 2021-12-23 | Moniteau | Missouri | 29135 | 2935 | 46 |
2039180 | 2039180 | 2021-12-22 | Moniteau | Missouri | 29135 | 2923 | 46 |
2035930 | 2035930 | 2021-12-21 | Moniteau | Missouri | 29135 | 2913 | 46 |
2032680 | 2032680 | 2021-12-20 | Moniteau | Missouri | 29135 | 2909 | 46 |
2029429 | 2029429 | 2021-12-19 | Moniteau | Missouri | 29135 | 2905 | 46 |
2026178 | 2026178 | 2021-12-18 | Moniteau | Missouri | 29135 | 2905 | 46 |
2022927 | 2022927 | 2021-12-17 | Moniteau | Missouri | 29135 | 2896 | 46 |
2019676 | 2019676 | 2021-12-16 | Moniteau | Missouri | 29135 | 2887 | 46 |
2016426 | 2016426 | 2021-12-15 | Moniteau | Missouri | 29135 | 2874 | 46 |
2013175 | 2013175 | 2021-12-14 | Moniteau | Missouri | 29135 | 2862 | 46 |
2009924 | 2009924 | 2021-12-13 | Moniteau | Missouri | 29135 | 2857 | 46 |
2006673 | 2006673 | 2021-12-12 | Moniteau | Missouri | 29135 | 2856 | 46 |
2003422 | 2003422 | 2021-12-11 | Moniteau | Missouri | 29135 | 2855 | 46 |
2000172 | 2000172 | 2021-12-10 | Moniteau | Missouri | 29135 | 2845 | 46 |
1996921 | 1996921 | 2021-12-09 | Moniteau | Missouri | 29135 | 2836 | 46 |
1993670 | 1993670 | 2021-12-08 | Moniteau | Missouri | 29135 | 2826 | 46 |
1990419 | 1990419 | 2021-12-07 | Moniteau | Missouri | 29135 | 2812 | 46 |
1987169 | 1987169 | 2021-12-06 | Moniteau | Missouri | 29135 | 2807 | 46 |
1983919 | 1983919 | 2021-12-05 | Moniteau | Missouri | 29135 | 2803 | 46 |
1980669 | 1980669 | 2021-12-04 | Moniteau | Missouri | 29135 | 2797 | 46 |
1977419 | 1977419 | 2021-12-03 | Moniteau | Missouri | 29135 | 2786 | 46 |
1974169 | 1974169 | 2021-12-02 | Moniteau | Missouri | 29135 | 2786 | 46 |
1970920 | 1970920 | 2021-12-01 | Moniteau | Missouri | 29135 | 2779 | 46 |
1967670 | 1967670 | 2021-11-30 | Moniteau | Missouri | 29135 | 2776 | 46 |
1964418 | 1964418 | 2021-11-29 | Moniteau | Missouri | 29135 | 2771 | 46 |
1961167 | 1961167 | 2021-11-28 | Moniteau | Missouri | 29135 | 2761 | 46 |
1957916 | 1957916 | 2021-11-27 | Moniteau | Missouri | 29135 | 2761 | 46 |
1954665 | 1954665 | 2021-11-26 | Moniteau | Missouri | 29135 | 2761 | 46 |
1951414 | 1951414 | 2021-11-25 | Moniteau | Missouri | 29135 | 2761 | 46 |
1948163 | 1948163 | 2021-11-24 | Moniteau | Missouri | 29135 | 2761 | 46 |
1944912 | 1944912 | 2021-11-23 | Moniteau | Missouri | 29135 | 2760 | 46 |
1941661 | 1941661 | 2021-11-22 | Moniteau | Missouri | 29135 | 2759 | 46 |
1938411 | 1938411 | 2021-11-21 | Moniteau | Missouri | 29135 | 2755 | 47 |
1935161 | 1935161 | 2021-11-20 | Moniteau | Missouri | 29135 | 2755 | 47 |
1931911 | 1931911 | 2021-11-19 | Moniteau | Missouri | 29135 | 2753 | 47 |
1928660 | 1928660 | 2021-11-18 | Moniteau | Missouri | 29135 | 2750 | 46 |
1925410 | 1925410 | 2021-11-17 | Moniteau | Missouri | 29135 | 2645 | 40 |
1922161 | 1922161 | 2021-11-16 | Moniteau | Missouri | 29135 | 2642 | 40 |
1918911 | 1918911 | 2021-11-15 | Moniteau | Missouri | 29135 | 2637 | 40 |
1915661 | 1915661 | 2021-11-14 | Moniteau | Missouri | 29135 | 2636 | 40 |
1912411 | 1912411 | 2021-11-13 | Moniteau | Missouri | 29135 | 2636 | 40 |
1909161 | 1909161 | 2021-11-12 | Moniteau | Missouri | 29135 | 2636 | 40 |
1905912 | 1905912 | 2021-11-11 | Moniteau | Missouri | 29135 | 2631 | 40 |
1902663 | 1902663 | 2021-11-10 | Moniteau | Missouri | 29135 | 2631 | 40 |
1899413 | 1899413 | 2021-11-09 | Moniteau | Missouri | 29135 | 2627 | 40 |
1896163 | 1896163 | 2021-11-08 | Moniteau | Missouri | 29135 | 2623 | 39 |
1892913 | 1892913 | 2021-11-07 | Moniteau | Missouri | 29135 | 2622 | 39 |
1889663 | 1889663 | 2021-11-06 | Moniteau | Missouri | 29135 | 2622 | 39 |
1886413 | 1886413 | 2021-11-05 | Moniteau | Missouri | 29135 | 2620 | 39 |
1883164 | 1883164 | 2021-11-04 | Moniteau | Missouri | 29135 | 2617 | 39 |
1879915 | 1879915 | 2021-11-03 | Moniteau | Missouri | 29135 | 2614 | 39 |
1876666 | 1876666 | 2021-11-02 | Moniteau | Missouri | 29135 | 2609 | 39 |
1873417 | 1873417 | 2021-11-01 | Moniteau | Missouri | 29135 | 2597 | 39 |
1870168 | 1870168 | 2021-10-31 | Moniteau | Missouri | 29135 | 2597 | 39 |
1866919 | 1866919 | 2021-10-30 | Moniteau | Missouri | 29135 | 2596 | 39 |
1863670 | 1863670 | 2021-10-29 | Moniteau | Missouri | 29135 | 2594 | 39 |
1860421 | 1860421 | 2021-10-28 | Moniteau | Missouri | 29135 | 2589 | 39 |
1857172 | 1857172 | 2021-10-27 | Moniteau | Missouri | 29135 | 2585 | 38 |
1853923 | 1853923 | 2021-10-26 | Moniteau | Missouri | 29135 | 2586 | 38 |
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);