ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Marion", fips = 39101 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176310 | 2176310 | 2022-02-02 | Marion | Ohio | 39101 | 19299 | 242 |
2173056 | 2173056 | 2022-02-01 | Marion | Ohio | 39101 | 19227 | 242 |
2169804 | 2169804 | 2022-01-31 | Marion | Ohio | 39101 | 19170 | 240 |
2166549 | 2166549 | 2022-01-30 | Marion | Ohio | 39101 | 19129 | 240 |
2163294 | 2163294 | 2022-01-29 | Marion | Ohio | 39101 | 19102 | 240 |
2160039 | 2160039 | 2022-01-28 | Marion | Ohio | 39101 | 19036 | 240 |
2156784 | 2156784 | 2022-01-27 | Marion | Ohio | 39101 | 18964 | 237 |
2153531 | 2153531 | 2022-01-26 | Marion | Ohio | 39101 | 18854 | 237 |
2150279 | 2150279 | 2022-01-25 | Marion | Ohio | 39101 | 18622 | 237 |
2147027 | 2147027 | 2022-01-24 | Marion | Ohio | 39101 | 18616 | 235 |
2143773 | 2143773 | 2022-01-23 | Marion | Ohio | 39101 | 18531 | 235 |
2140518 | 2140518 | 2022-01-22 | Marion | Ohio | 39101 | 18456 | 235 |
2137262 | 2137262 | 2022-01-21 | Marion | Ohio | 39101 | 18304 | 235 |
2134008 | 2134008 | 2022-01-20 | Marion | Ohio | 39101 | 18111 | 232 |
2130756 | 2130756 | 2022-01-19 | Marion | Ohio | 39101 | 17861 | 232 |
2127502 | 2127502 | 2022-01-18 | Marion | Ohio | 39101 | 17633 | 232 |
2124250 | 2124250 | 2022-01-17 | Marion | Ohio | 39101 | 17503 | 231 |
2120998 | 2120998 | 2022-01-16 | Marion | Ohio | 39101 | 17314 | 231 |
2117746 | 2117746 | 2022-01-15 | Marion | Ohio | 39101 | 17058 | 231 |
2114495 | 2114495 | 2022-01-14 | Marion | Ohio | 39101 | 16653 | 231 |
2111243 | 2111243 | 2022-01-13 | Marion | Ohio | 39101 | 16304 | 227 |
2107991 | 2107991 | 2022-01-12 | Marion | Ohio | 39101 | 16186 | 227 |
2104740 | 2104740 | 2022-01-11 | Marion | Ohio | 39101 | 16047 | 227 |
2101489 | 2101489 | 2022-01-10 | Marion | Ohio | 39101 | 16019 | 224 |
2098238 | 2098238 | 2022-01-09 | Marion | Ohio | 39101 | 15895 | 224 |
2094986 | 2094986 | 2022-01-08 | Marion | Ohio | 39101 | 15759 | 224 |
2091734 | 2091734 | 2022-01-07 | Marion | Ohio | 39101 | 15706 | 224 |
2088482 | 2088482 | 2022-01-06 | Marion | Ohio | 39101 | 15536 | 218 |
2085231 | 2085231 | 2022-01-05 | Marion | Ohio | 39101 | 15412 | 218 |
2081979 | 2081979 | 2022-01-04 | Marion | Ohio | 39101 | 15320 | 218 |
2078727 | 2078727 | 2022-01-03 | Marion | Ohio | 39101 | 15192 | 217 |
2075476 | 2075476 | 2022-01-02 | Marion | Ohio | 39101 | 15096 | 217 |
2072225 | 2072225 | 2022-01-01 | Marion | Ohio | 39101 | 14953 | 217 |
2068974 | 2068974 | 2021-12-31 | Marion | Ohio | 39101 | 14953 | 217 |
2065723 | 2065723 | 2021-12-30 | Marion | Ohio | 39101 | 14919 | 208 |
2062473 | 2062473 | 2021-12-29 | Marion | Ohio | 39101 | 14813 | 208 |
2059223 | 2059223 | 2021-12-28 | Marion | Ohio | 39101 | 14713 | 208 |
2055974 | 2055974 | 2021-12-27 | Marion | Ohio | 39101 | 14631 | 208 |
2052725 | 2052725 | 2021-12-26 | Marion | Ohio | 39101 | 14590 | 208 |
2049475 | 2049475 | 2021-12-25 | Marion | Ohio | 39101 | 14508 | 208 |
2046225 | 2046225 | 2021-12-24 | Marion | Ohio | 39101 | 14508 | 208 |
2042975 | 2042975 | 2021-12-23 | Marion | Ohio | 39101 | 14450 | 204 |
2039726 | 2039726 | 2021-12-22 | Marion | Ohio | 39101 | 14382 | 204 |
2036476 | 2036476 | 2021-12-21 | Marion | Ohio | 39101 | 14302 | 204 |
2033226 | 2033226 | 2021-12-20 | Marion | Ohio | 39101 | 14249 | 204 |
2029976 | 2029976 | 2021-12-19 | Marion | Ohio | 39101 | 14226 | 204 |
2026725 | 2026725 | 2021-12-18 | Marion | Ohio | 39101 | 14188 | 204 |
2023474 | 2023474 | 2021-12-17 | Marion | Ohio | 39101 | 14143 | 204 |
2020223 | 2020223 | 2021-12-16 | Marion | Ohio | 39101 | 14082 | 200 |
2016972 | 2016972 | 2021-12-15 | Marion | Ohio | 39101 | 14014 | 200 |
2013722 | 2013722 | 2021-12-14 | Marion | Ohio | 39101 | 13946 | 200 |
2010471 | 2010471 | 2021-12-13 | Marion | Ohio | 39101 | 13895 | 199 |
2007220 | 2007220 | 2021-12-12 | Marion | Ohio | 39101 | 13851 | 199 |
2003969 | 2003969 | 2021-12-11 | Marion | Ohio | 39101 | 13806 | 199 |
2000718 | 2000718 | 2021-12-10 | Marion | Ohio | 39101 | 13715 | 199 |
1997468 | 1997468 | 2021-12-09 | Marion | Ohio | 39101 | 13673 | 198 |
1994217 | 1994217 | 2021-12-08 | Marion | Ohio | 39101 | 13590 | 198 |
1990966 | 1990966 | 2021-12-07 | Marion | Ohio | 39101 | 13520 | 198 |
1987715 | 1987715 | 2021-12-06 | Marion | Ohio | 39101 | 13477 | 196 |
1984465 | 1984465 | 2021-12-05 | Marion | Ohio | 39101 | 13440 | 196 |
1981215 | 1981215 | 2021-12-04 | Marion | Ohio | 39101 | 13385 | 196 |
1977965 | 1977965 | 2021-12-03 | Marion | Ohio | 39101 | 13332 | 196 |
1974715 | 1974715 | 2021-12-02 | Marion | Ohio | 39101 | 13250 | 194 |
1971466 | 1971466 | 2021-12-01 | Marion | Ohio | 39101 | 13186 | 194 |
1968216 | 1968216 | 2021-11-30 | Marion | Ohio | 39101 | 13116 | 194 |
1964965 | 1964965 | 2021-11-29 | Marion | Ohio | 39101 | 13054 | 194 |
1961713 | 1961713 | 2021-11-28 | Marion | Ohio | 39101 | 13012 | 194 |
1958462 | 1958462 | 2021-11-27 | Marion | Ohio | 39101 | 12978 | 194 |
1955211 | 1955211 | 2021-11-26 | Marion | Ohio | 39101 | 12948 | 194 |
1951960 | 1951960 | 2021-11-25 | Marion | Ohio | 39101 | 12903 | 192 |
1948709 | 1948709 | 2021-11-24 | Marion | Ohio | 39101 | 12903 | 192 |
1945458 | 1945458 | 2021-11-23 | Marion | Ohio | 39101 | 12867 | 192 |
1942207 | 1942207 | 2021-11-22 | Marion | Ohio | 39101 | 12822 | 192 |
1938957 | 1938957 | 2021-11-21 | Marion | Ohio | 39101 | 12799 | 192 |
1935707 | 1935707 | 2021-11-20 | Marion | Ohio | 39101 | 12781 | 192 |
1932457 | 1932457 | 2021-11-19 | Marion | Ohio | 39101 | 12746 | 192 |
1929206 | 1929206 | 2021-11-18 | Marion | Ohio | 39101 | 12708 | 188 |
1925956 | 1925956 | 2021-11-17 | Marion | Ohio | 39101 | 12662 | 188 |
1922706 | 1922706 | 2021-11-16 | Marion | Ohio | 39101 | 12594 | 188 |
1919457 | 1919457 | 2021-11-15 | Marion | Ohio | 39101 | 12561 | 187 |
1916207 | 1916207 | 2021-11-14 | Marion | Ohio | 39101 | 12530 | 187 |
1912957 | 1912957 | 2021-11-13 | Marion | Ohio | 39101 | 12512 | 187 |
1909707 | 1909707 | 2021-11-12 | Marion | Ohio | 39101 | 12481 | 187 |
1906458 | 1906458 | 2021-11-11 | Marion | Ohio | 39101 | 12446 | 186 |
1903209 | 1903209 | 2021-11-10 | Marion | Ohio | 39101 | 12414 | 186 |
1899959 | 1899959 | 2021-11-09 | Marion | Ohio | 39101 | 12367 | 186 |
1896709 | 1896709 | 2021-11-08 | Marion | Ohio | 39101 | 12344 | 185 |
1893459 | 1893459 | 2021-11-07 | Marion | Ohio | 39101 | 12326 | 185 |
1890209 | 1890209 | 2021-11-06 | Marion | Ohio | 39101 | 12303 | 185 |
1886959 | 1886959 | 2021-11-05 | Marion | Ohio | 39101 | 12279 | 185 |
1883709 | 1883709 | 2021-11-04 | Marion | Ohio | 39101 | 12247 | 184 |
1880460 | 1880460 | 2021-11-03 | Marion | Ohio | 39101 | 12216 | 184 |
1877211 | 1877211 | 2021-11-02 | Marion | Ohio | 39101 | 12191 | 184 |
1873962 | 1873962 | 2021-11-01 | Marion | Ohio | 39101 | 12181 | 184 |
1870713 | 1870713 | 2021-10-31 | Marion | Ohio | 39101 | 12165 | 184 |
1867464 | 1867464 | 2021-10-30 | Marion | Ohio | 39101 | 12147 | 184 |
1864215 | 1864215 | 2021-10-29 | Marion | Ohio | 39101 | 12117 | 184 |
1860966 | 1860966 | 2021-10-28 | Marion | Ohio | 39101 | 12091 | 181 |
1857717 | 1857717 | 2021-10-27 | Marion | Ohio | 39101 | 12065 | 181 |
1854468 | 1854468 | 2021-10-26 | Marion | Ohio | 39101 | 12047 | 181 |
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);