ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Morgan" and fips = 39115 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176317 | 2176317 | 2022-02-02 | Morgan | Ohio | 39115 | 3076 | 49 |
2173063 | 2173063 | 2022-02-01 | Morgan | Ohio | 39115 | 3055 | 49 |
2169811 | 2169811 | 2022-01-31 | Morgan | Ohio | 39115 | 3044 | 48 |
2166556 | 2166556 | 2022-01-30 | Morgan | Ohio | 39115 | 3031 | 48 |
2163301 | 2163301 | 2022-01-29 | Morgan | Ohio | 39115 | 3031 | 48 |
2160046 | 2160046 | 2022-01-28 | Morgan | Ohio | 39115 | 3013 | 48 |
2156791 | 2156791 | 2022-01-27 | Morgan | Ohio | 39115 | 3001 | 48 |
2153538 | 2153538 | 2022-01-26 | Morgan | Ohio | 39115 | 2977 | 48 |
2150286 | 2150286 | 2022-01-25 | Morgan | Ohio | 39115 | 2951 | 48 |
2147034 | 2147034 | 2022-01-24 | Morgan | Ohio | 39115 | 2927 | 48 |
2143780 | 2143780 | 2022-01-23 | Morgan | Ohio | 39115 | 2914 | 48 |
2140525 | 2140525 | 2022-01-22 | Morgan | Ohio | 39115 | 2894 | 48 |
2137269 | 2137269 | 2022-01-21 | Morgan | Ohio | 39115 | 2875 | 48 |
2134015 | 2134015 | 2022-01-20 | Morgan | Ohio | 39115 | 2833 | 48 |
2130763 | 2130763 | 2022-01-19 | Morgan | Ohio | 39115 | 2803 | 48 |
2127509 | 2127509 | 2022-01-18 | Morgan | Ohio | 39115 | 2781 | 48 |
2124257 | 2124257 | 2022-01-17 | Morgan | Ohio | 39115 | 2768 | 48 |
2121005 | 2121005 | 2022-01-16 | Morgan | Ohio | 39115 | 2753 | 48 |
2117753 | 2117753 | 2022-01-15 | Morgan | Ohio | 39115 | 2722 | 48 |
2114502 | 2114502 | 2022-01-14 | Morgan | Ohio | 39115 | 2682 | 48 |
2111250 | 2111250 | 2022-01-13 | Morgan | Ohio | 39115 | 2643 | 47 |
2107998 | 2107998 | 2022-01-12 | Morgan | Ohio | 39115 | 2605 | 47 |
2104747 | 2104747 | 2022-01-11 | Morgan | Ohio | 39115 | 2582 | 47 |
2101496 | 2101496 | 2022-01-10 | Morgan | Ohio | 39115 | 2560 | 47 |
2098245 | 2098245 | 2022-01-09 | Morgan | Ohio | 39115 | 2547 | 47 |
2094993 | 2094993 | 2022-01-08 | Morgan | Ohio | 39115 | 2537 | 47 |
2091741 | 2091741 | 2022-01-07 | Morgan | Ohio | 39115 | 2529 | 47 |
2088489 | 2088489 | 2022-01-06 | Morgan | Ohio | 39115 | 2516 | 47 |
2085238 | 2085238 | 2022-01-05 | Morgan | Ohio | 39115 | 2491 | 47 |
2081986 | 2081986 | 2022-01-04 | Morgan | Ohio | 39115 | 2453 | 47 |
2078734 | 2078734 | 2022-01-03 | Morgan | Ohio | 39115 | 2441 | 46 |
2075483 | 2075483 | 2022-01-02 | Morgan | Ohio | 39115 | 2424 | 46 |
2072232 | 2072232 | 2022-01-01 | Morgan | Ohio | 39115 | 2408 | 46 |
2068981 | 2068981 | 2021-12-31 | Morgan | Ohio | 39115 | 2408 | 46 |
2065730 | 2065730 | 2021-12-30 | Morgan | Ohio | 39115 | 2397 | 43 |
2062480 | 2062480 | 2021-12-29 | Morgan | Ohio | 39115 | 2384 | 43 |
2059230 | 2059230 | 2021-12-28 | Morgan | Ohio | 39115 | 2366 | 43 |
2055981 | 2055981 | 2021-12-27 | Morgan | Ohio | 39115 | 2354 | 43 |
2052732 | 2052732 | 2021-12-26 | Morgan | Ohio | 39115 | 2348 | 43 |
2049482 | 2049482 | 2021-12-25 | Morgan | Ohio | 39115 | 2344 | 43 |
2046232 | 2046232 | 2021-12-24 | Morgan | Ohio | 39115 | 2344 | 43 |
2042982 | 2042982 | 2021-12-23 | Morgan | Ohio | 39115 | 2341 | 43 |
2039733 | 2039733 | 2021-12-22 | Morgan | Ohio | 39115 | 2332 | 43 |
2036483 | 2036483 | 2021-12-21 | Morgan | Ohio | 39115 | 2323 | 43 |
2033233 | 2033233 | 2021-12-20 | Morgan | Ohio | 39115 | 2306 | 40 |
2029983 | 2029983 | 2021-12-19 | Morgan | Ohio | 39115 | 2301 | 40 |
2026732 | 2026732 | 2021-12-18 | Morgan | Ohio | 39115 | 2298 | 40 |
2023481 | 2023481 | 2021-12-17 | Morgan | Ohio | 39115 | 2289 | 40 |
2020230 | 2020230 | 2021-12-16 | Morgan | Ohio | 39115 | 2281 | 39 |
2016979 | 2016979 | 2021-12-15 | Morgan | Ohio | 39115 | 2270 | 39 |
2013729 | 2013729 | 2021-12-14 | Morgan | Ohio | 39115 | 2265 | 39 |
2010478 | 2010478 | 2021-12-13 | Morgan | Ohio | 39115 | 2260 | 39 |
2007227 | 2007227 | 2021-12-12 | Morgan | Ohio | 39115 | 2255 | 39 |
2003976 | 2003976 | 2021-12-11 | Morgan | Ohio | 39115 | 2249 | 39 |
2000725 | 2000725 | 2021-12-10 | Morgan | Ohio | 39115 | 2238 | 39 |
1997475 | 1997475 | 2021-12-09 | Morgan | Ohio | 39115 | 2229 | 39 |
1994224 | 1994224 | 2021-12-08 | Morgan | Ohio | 39115 | 2216 | 39 |
1990973 | 1990973 | 2021-12-07 | Morgan | Ohio | 39115 | 2204 | 39 |
1987722 | 1987722 | 2021-12-06 | Morgan | Ohio | 39115 | 2194 | 39 |
1984472 | 1984472 | 2021-12-05 | Morgan | Ohio | 39115 | 2190 | 39 |
1981222 | 1981222 | 2021-12-04 | Morgan | Ohio | 39115 | 2185 | 39 |
1977972 | 1977972 | 2021-12-03 | Morgan | Ohio | 39115 | 2169 | 39 |
1974722 | 1974722 | 2021-12-02 | Morgan | Ohio | 39115 | 2152 | 38 |
1971473 | 1971473 | 2021-12-01 | Morgan | Ohio | 39115 | 2144 | 38 |
1968223 | 1968223 | 2021-11-30 | Morgan | Ohio | 39115 | 2121 | 38 |
1964972 | 1964972 | 2021-11-29 | Morgan | Ohio | 39115 | 2101 | 38 |
1961720 | 1961720 | 2021-11-28 | Morgan | Ohio | 39115 | 2096 | 38 |
1958469 | 1958469 | 2021-11-27 | Morgan | Ohio | 39115 | 2089 | 38 |
1955218 | 1955218 | 2021-11-26 | Morgan | Ohio | 39115 | 2083 | 38 |
1951967 | 1951967 | 2021-11-25 | Morgan | Ohio | 39115 | 2071 | 38 |
1948716 | 1948716 | 2021-11-24 | Morgan | Ohio | 39115 | 2071 | 38 |
1945465 | 1945465 | 2021-11-23 | Morgan | Ohio | 39115 | 2064 | 38 |
1942214 | 1942214 | 2021-11-22 | Morgan | Ohio | 39115 | 2058 | 38 |
1938964 | 1938964 | 2021-11-21 | Morgan | Ohio | 39115 | 2057 | 38 |
1935714 | 1935714 | 2021-11-20 | Morgan | Ohio | 39115 | 2049 | 38 |
1932464 | 1932464 | 2021-11-19 | Morgan | Ohio | 39115 | 2043 | 38 |
1929213 | 1929213 | 2021-11-18 | Morgan | Ohio | 39115 | 2042 | 38 |
1925963 | 1925963 | 2021-11-17 | Morgan | Ohio | 39115 | 2025 | 38 |
1922713 | 1922713 | 2021-11-16 | Morgan | Ohio | 39115 | 2016 | 38 |
1919464 | 1919464 | 2021-11-15 | Morgan | Ohio | 39115 | 2008 | 37 |
1916214 | 1916214 | 2021-11-14 | Morgan | Ohio | 39115 | 2007 | 37 |
1912964 | 1912964 | 2021-11-13 | Morgan | Ohio | 39115 | 2003 | 37 |
1909714 | 1909714 | 2021-11-12 | Morgan | Ohio | 39115 | 1997 | 37 |
1906465 | 1906465 | 2021-11-11 | Morgan | Ohio | 39115 | 1993 | 37 |
1903216 | 1903216 | 2021-11-10 | Morgan | Ohio | 39115 | 1986 | 37 |
1899966 | 1899966 | 2021-11-09 | Morgan | Ohio | 39115 | 1983 | 37 |
1896716 | 1896716 | 2021-11-08 | Morgan | Ohio | 39115 | 1981 | 36 |
1893466 | 1893466 | 2021-11-07 | Morgan | Ohio | 39115 | 1981 | 36 |
1890216 | 1890216 | 2021-11-06 | Morgan | Ohio | 39115 | 1976 | 36 |
1886966 | 1886966 | 2021-11-05 | Morgan | Ohio | 39115 | 1971 | 36 |
1883716 | 1883716 | 2021-11-04 | Morgan | Ohio | 39115 | 1968 | 35 |
1880467 | 1880467 | 2021-11-03 | Morgan | Ohio | 39115 | 1966 | 35 |
1877218 | 1877218 | 2021-11-02 | Morgan | Ohio | 39115 | 1961 | 35 |
1873969 | 1873969 | 2021-11-01 | Morgan | Ohio | 39115 | 1958 | 34 |
1870720 | 1870720 | 2021-10-31 | Morgan | Ohio | 39115 | 1957 | 34 |
1867471 | 1867471 | 2021-10-30 | Morgan | Ohio | 39115 | 1954 | 34 |
1864222 | 1864222 | 2021-10-29 | Morgan | Ohio | 39115 | 1952 | 34 |
1860973 | 1860973 | 2021-10-28 | Morgan | Ohio | 39115 | 1952 | 34 |
1857724 | 1857724 | 2021-10-27 | Morgan | Ohio | 39115 | 1949 | 34 |
1854475 | 1854475 | 2021-10-26 | Morgan | Ohio | 39115 | 1943 | 34 |
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);