ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 39103 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176311 | 2176311 | 2022-02-02 | Medina | Ohio | 39103 | 39267 | 443 |
2173057 | 2173057 | 2022-02-01 | Medina | Ohio | 39103 | 39206 | 443 |
2169805 | 2169805 | 2022-01-31 | Medina | Ohio | 39103 | 39169 | 437 |
2166550 | 2166550 | 2022-01-30 | Medina | Ohio | 39103 | 39135 | 437 |
2163295 | 2163295 | 2022-01-29 | Medina | Ohio | 39103 | 39104 | 437 |
2160040 | 2160040 | 2022-01-28 | Medina | Ohio | 39103 | 39036 | 437 |
2156785 | 2156785 | 2022-01-27 | Medina | Ohio | 39103 | 38963 | 431 |
2153532 | 2153532 | 2022-01-26 | Medina | Ohio | 39103 | 38848 | 431 |
2150280 | 2150280 | 2022-01-25 | Medina | Ohio | 39103 | 38687 | 431 |
2147028 | 2147028 | 2022-01-24 | Medina | Ohio | 39103 | 38646 | 427 |
2143774 | 2143774 | 2022-01-23 | Medina | Ohio | 39103 | 38556 | 427 |
2140519 | 2140519 | 2022-01-22 | Medina | Ohio | 39103 | 38487 | 427 |
2137263 | 2137263 | 2022-01-21 | Medina | Ohio | 39103 | 38323 | 427 |
2134009 | 2134009 | 2022-01-20 | Medina | Ohio | 39103 | 38036 | 419 |
2130757 | 2130757 | 2022-01-19 | Medina | Ohio | 39103 | 37850 | 419 |
2127503 | 2127503 | 2022-01-18 | Medina | Ohio | 39103 | 37708 | 419 |
2124251 | 2124251 | 2022-01-17 | Medina | Ohio | 39103 | 37611 | 416 |
2120999 | 2120999 | 2022-01-16 | Medina | Ohio | 39103 | 37455 | 416 |
2117747 | 2117747 | 2022-01-15 | Medina | Ohio | 39103 | 37223 | 416 |
2114496 | 2114496 | 2022-01-14 | Medina | Ohio | 39103 | 36739 | 416 |
2111244 | 2111244 | 2022-01-13 | Medina | Ohio | 39103 | 36337 | 406 |
2107992 | 2107992 | 2022-01-12 | Medina | Ohio | 39103 | 36046 | 406 |
2104741 | 2104741 | 2022-01-11 | Medina | Ohio | 39103 | 35768 | 406 |
2101490 | 2101490 | 2022-01-10 | Medina | Ohio | 39103 | 35495 | 405 |
2098239 | 2098239 | 2022-01-09 | Medina | Ohio | 39103 | 35210 | 405 |
2094987 | 2094987 | 2022-01-08 | Medina | Ohio | 39103 | 34717 | 405 |
2091735 | 2091735 | 2022-01-07 | Medina | Ohio | 39103 | 34374 | 405 |
2088483 | 2088483 | 2022-01-06 | Medina | Ohio | 39103 | 34038 | 401 |
2085232 | 2085232 | 2022-01-05 | Medina | Ohio | 39103 | 33713 | 401 |
2081980 | 2081980 | 2022-01-04 | Medina | Ohio | 39103 | 33394 | 401 |
2078728 | 2078728 | 2022-01-03 | Medina | Ohio | 39103 | 33126 | 394 |
2075477 | 2075477 | 2022-01-02 | Medina | Ohio | 39103 | 32780 | 394 |
2072226 | 2072226 | 2022-01-01 | Medina | Ohio | 39103 | 31996 | 394 |
2068975 | 2068975 | 2021-12-31 | Medina | Ohio | 39103 | 31996 | 394 |
2065724 | 2065724 | 2021-12-30 | Medina | Ohio | 39103 | 31493 | 382 |
2062474 | 2062474 | 2021-12-29 | Medina | Ohio | 39103 | 31185 | 382 |
2059224 | 2059224 | 2021-12-28 | Medina | Ohio | 39103 | 30791 | 382 |
2055975 | 2055975 | 2021-12-27 | Medina | Ohio | 39103 | 30497 | 381 |
2052726 | 2052726 | 2021-12-26 | Medina | Ohio | 39103 | 30356 | 381 |
2049476 | 2049476 | 2021-12-25 | Medina | Ohio | 39103 | 29855 | 381 |
2046226 | 2046226 | 2021-12-24 | Medina | Ohio | 39103 | 29855 | 381 |
2042976 | 2042976 | 2021-12-23 | Medina | Ohio | 39103 | 29506 | 373 |
2039727 | 2039727 | 2021-12-22 | Medina | Ohio | 39103 | 29101 | 373 |
2036477 | 2036477 | 2021-12-21 | Medina | Ohio | 39103 | 28863 | 373 |
2033227 | 2033227 | 2021-12-20 | Medina | Ohio | 39103 | 28550 | 369 |
2029977 | 2029977 | 2021-12-19 | Medina | Ohio | 39103 | 28382 | 369 |
2026726 | 2026726 | 2021-12-18 | Medina | Ohio | 39103 | 28250 | 369 |
2023475 | 2023475 | 2021-12-17 | Medina | Ohio | 39103 | 28048 | 369 |
2020224 | 2020224 | 2021-12-16 | Medina | Ohio | 39103 | 27865 | 362 |
2016973 | 2016973 | 2021-12-15 | Medina | Ohio | 39103 | 27694 | 362 |
2013723 | 2013723 | 2021-12-14 | Medina | Ohio | 39103 | 27539 | 362 |
2010472 | 2010472 | 2021-12-13 | Medina | Ohio | 39103 | 27363 | 362 |
2007221 | 2007221 | 2021-12-12 | Medina | Ohio | 39103 | 27287 | 362 |
2003970 | 2003970 | 2021-12-11 | Medina | Ohio | 39103 | 27185 | 362 |
2000719 | 2000719 | 2021-12-10 | Medina | Ohio | 39103 | 27031 | 362 |
1997469 | 1997469 | 2021-12-09 | Medina | Ohio | 39103 | 26898 | 356 |
1994218 | 1994218 | 2021-12-08 | Medina | Ohio | 39103 | 26704 | 356 |
1990967 | 1990967 | 2021-12-07 | Medina | Ohio | 39103 | 26529 | 356 |
1987716 | 1987716 | 2021-12-06 | Medina | Ohio | 39103 | 26408 | 353 |
1984466 | 1984466 | 2021-12-05 | Medina | Ohio | 39103 | 26290 | 353 |
1981216 | 1981216 | 2021-12-04 | Medina | Ohio | 39103 | 26179 | 353 |
1977966 | 1977966 | 2021-12-03 | Medina | Ohio | 39103 | 26042 | 353 |
1974716 | 1974716 | 2021-12-02 | Medina | Ohio | 39103 | 25825 | 351 |
1971467 | 1971467 | 2021-12-01 | Medina | Ohio | 39103 | 25619 | 351 |
1968217 | 1968217 | 2021-11-30 | Medina | Ohio | 39103 | 25419 | 351 |
1964966 | 1964966 | 2021-11-29 | Medina | Ohio | 39103 | 25291 | 351 |
1961714 | 1961714 | 2021-11-28 | Medina | Ohio | 39103 | 25175 | 351 |
1958463 | 1958463 | 2021-11-27 | Medina | Ohio | 39103 | 25072 | 351 |
1955212 | 1955212 | 2021-11-26 | Medina | Ohio | 39103 | 25011 | 351 |
1951961 | 1951961 | 2021-11-25 | Medina | Ohio | 39103 | 24836 | 344 |
1948710 | 1948710 | 2021-11-24 | Medina | Ohio | 39103 | 24836 | 344 |
1945459 | 1945459 | 2021-11-23 | Medina | Ohio | 39103 | 24675 | 344 |
1942208 | 1942208 | 2021-11-22 | Medina | Ohio | 39103 | 24540 | 343 |
1938958 | 1938958 | 2021-11-21 | Medina | Ohio | 39103 | 24446 | 343 |
1935708 | 1935708 | 2021-11-20 | Medina | Ohio | 39103 | 24368 | 343 |
1932458 | 1932458 | 2021-11-19 | Medina | Ohio | 39103 | 24271 | 343 |
1929207 | 1929207 | 2021-11-18 | Medina | Ohio | 39103 | 24141 | 340 |
1925957 | 1925957 | 2021-11-17 | Medina | Ohio | 39103 | 24013 | 340 |
1922707 | 1922707 | 2021-11-16 | Medina | Ohio | 39103 | 23913 | 340 |
1919458 | 1919458 | 2021-11-15 | Medina | Ohio | 39103 | 23801 | 338 |
1916208 | 1916208 | 2021-11-14 | Medina | Ohio | 39103 | 23697 | 338 |
1912958 | 1912958 | 2021-11-13 | Medina | Ohio | 39103 | 23613 | 338 |
1909708 | 1909708 | 2021-11-12 | Medina | Ohio | 39103 | 23502 | 338 |
1906459 | 1906459 | 2021-11-11 | Medina | Ohio | 39103 | 23413 | 329 |
1903210 | 1903210 | 2021-11-10 | Medina | Ohio | 39103 | 23315 | 329 |
1899960 | 1899960 | 2021-11-09 | Medina | Ohio | 39103 | 23193 | 329 |
1896710 | 1896710 | 2021-11-08 | Medina | Ohio | 39103 | 23108 | 322 |
1893460 | 1893460 | 2021-11-07 | Medina | Ohio | 39103 | 23038 | 322 |
1890210 | 1890210 | 2021-11-06 | Medina | Ohio | 39103 | 22935 | 322 |
1886960 | 1886960 | 2021-11-05 | Medina | Ohio | 39103 | 22888 | 322 |
1883710 | 1883710 | 2021-11-04 | Medina | Ohio | 39103 | 22802 | 319 |
1880461 | 1880461 | 2021-11-03 | Medina | Ohio | 39103 | 22697 | 319 |
1877212 | 1877212 | 2021-11-02 | Medina | Ohio | 39103 | 22623 | 319 |
1873963 | 1873963 | 2021-11-01 | Medina | Ohio | 39103 | 22555 | 317 |
1870714 | 1870714 | 2021-10-31 | Medina | Ohio | 39103 | 22497 | 317 |
1867465 | 1867465 | 2021-10-30 | Medina | Ohio | 39103 | 22457 | 317 |
1864216 | 1864216 | 2021-10-29 | Medina | Ohio | 39103 | 22406 | 317 |
1860967 | 1860967 | 2021-10-28 | Medina | Ohio | 39103 | 22344 | 316 |
1857718 | 1857718 | 2021-10-27 | Medina | Ohio | 39103 | 22262 | 316 |
1854469 | 1854469 | 2021-10-26 | Medina | Ohio | 39103 | 22201 | 316 |
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);