ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176271 | 2176271 | 2022-02-02 | Clark | Ohio | 39023 | 33871 | 479 |
2173017 | 2173017 | 2022-02-01 | Clark | Ohio | 39023 | 33737 | 479 |
2169765 | 2169765 | 2022-01-31 | Clark | Ohio | 39023 | 33607 | 469 |
2166510 | 2166510 | 2022-01-30 | Clark | Ohio | 39023 | 33567 | 469 |
2163255 | 2163255 | 2022-01-29 | Clark | Ohio | 39023 | 33486 | 469 |
2160000 | 2160000 | 2022-01-28 | Clark | Ohio | 39023 | 33297 | 469 |
2156745 | 2156745 | 2022-01-27 | Clark | Ohio | 39023 | 33104 | 463 |
2153492 | 2153492 | 2022-01-26 | Clark | Ohio | 39023 | 32841 | 463 |
2150240 | 2150240 | 2022-01-25 | Clark | Ohio | 39023 | 32462 | 463 |
2146988 | 2146988 | 2022-01-24 | Clark | Ohio | 39023 | 32361 | 453 |
2143734 | 2143734 | 2022-01-23 | Clark | Ohio | 39023 | 32156 | 453 |
2140479 | 2140479 | 2022-01-22 | Clark | Ohio | 39023 | 31960 | 453 |
2137223 | 2137223 | 2022-01-21 | Clark | Ohio | 39023 | 31632 | 453 |
2133969 | 2133969 | 2022-01-20 | Clark | Ohio | 39023 | 31218 | 445 |
2130717 | 2130717 | 2022-01-19 | Clark | Ohio | 39023 | 30769 | 445 |
2127463 | 2127463 | 2022-01-18 | Clark | Ohio | 39023 | 30496 | 445 |
2124211 | 2124211 | 2022-01-17 | Clark | Ohio | 39023 | 30277 | 440 |
2120959 | 2120959 | 2022-01-16 | Clark | Ohio | 39023 | 29980 | 440 |
2117707 | 2117707 | 2022-01-15 | Clark | Ohio | 39023 | 29486 | 440 |
2114456 | 2114456 | 2022-01-14 | Clark | Ohio | 39023 | 28535 | 440 |
2111204 | 2111204 | 2022-01-13 | Clark | Ohio | 39023 | 27998 | 430 |
2107952 | 2107952 | 2022-01-12 | Clark | Ohio | 39023 | 27740 | 430 |
2104701 | 2104701 | 2022-01-11 | Clark | Ohio | 39023 | 27473 | 430 |
2101450 | 2101450 | 2022-01-10 | Clark | Ohio | 39023 | 27258 | 424 |
2098199 | 2098199 | 2022-01-09 | Clark | Ohio | 39023 | 27026 | 424 |
2094947 | 2094947 | 2022-01-08 | Clark | Ohio | 39023 | 26796 | 424 |
2091695 | 2091695 | 2022-01-07 | Clark | Ohio | 39023 | 26589 | 424 |
2088443 | 2088443 | 2022-01-06 | Clark | Ohio | 39023 | 26364 | 416 |
2085192 | 2085192 | 2022-01-05 | Clark | Ohio | 39023 | 26112 | 416 |
2081940 | 2081940 | 2022-01-04 | Clark | Ohio | 39023 | 25953 | 416 |
2078688 | 2078688 | 2022-01-03 | Clark | Ohio | 39023 | 25708 | 412 |
2075437 | 2075437 | 2022-01-02 | Clark | Ohio | 39023 | 25510 | 412 |
2072186 | 2072186 | 2022-01-01 | Clark | Ohio | 39023 | 25201 | 412 |
2068935 | 2068935 | 2021-12-31 | Clark | Ohio | 39023 | 25201 | 412 |
2065684 | 2065684 | 2021-12-30 | Clark | Ohio | 39023 | 25021 | 406 |
2062434 | 2062434 | 2021-12-29 | Clark | Ohio | 39023 | 24883 | 406 |
2059184 | 2059184 | 2021-12-28 | Clark | Ohio | 39023 | 24714 | 406 |
2055935 | 2055935 | 2021-12-27 | Clark | Ohio | 39023 | 24605 | 406 |
2052686 | 2052686 | 2021-12-26 | Clark | Ohio | 39023 | 24548 | 406 |
2049436 | 2049436 | 2021-12-25 | Clark | Ohio | 39023 | 24413 | 406 |
2046186 | 2046186 | 2021-12-24 | Clark | Ohio | 39023 | 24413 | 406 |
2042936 | 2042936 | 2021-12-23 | Clark | Ohio | 39023 | 24308 | 403 |
2039687 | 2039687 | 2021-12-22 | Clark | Ohio | 39023 | 24201 | 403 |
2036437 | 2036437 | 2021-12-21 | Clark | Ohio | 39023 | 24085 | 403 |
2033187 | 2033187 | 2021-12-20 | Clark | Ohio | 39023 | 23985 | 402 |
2029937 | 2029937 | 2021-12-19 | Clark | Ohio | 39023 | 23908 | 402 |
2026686 | 2026686 | 2021-12-18 | Clark | Ohio | 39023 | 23831 | 402 |
2023435 | 2023435 | 2021-12-17 | Clark | Ohio | 39023 | 23712 | 402 |
2020184 | 2020184 | 2021-12-16 | Clark | Ohio | 39023 | 23604 | 401 |
2016933 | 2016933 | 2021-12-15 | Clark | Ohio | 39023 | 23439 | 401 |
2013683 | 2013683 | 2021-12-14 | Clark | Ohio | 39023 | 23322 | 401 |
2010432 | 2010432 | 2021-12-13 | Clark | Ohio | 39023 | 23184 | 400 |
2007181 | 2007181 | 2021-12-12 | Clark | Ohio | 39023 | 23064 | 400 |
2003930 | 2003930 | 2021-12-11 | Clark | Ohio | 39023 | 22983 | 400 |
2000679 | 2000679 | 2021-12-10 | Clark | Ohio | 39023 | 22855 | 400 |
1997429 | 1997429 | 2021-12-09 | Clark | Ohio | 39023 | 22742 | 391 |
1994178 | 1994178 | 2021-12-08 | Clark | Ohio | 39023 | 22608 | 391 |
1990927 | 1990927 | 2021-12-07 | Clark | Ohio | 39023 | 22488 | 391 |
1987676 | 1987676 | 2021-12-06 | Clark | Ohio | 39023 | 22391 | 390 |
1984426 | 1984426 | 2021-12-05 | Clark | Ohio | 39023 | 22327 | 390 |
1981176 | 1981176 | 2021-12-04 | Clark | Ohio | 39023 | 22239 | 390 |
1977926 | 1977926 | 2021-12-03 | Clark | Ohio | 39023 | 22122 | 390 |
1974676 | 1974676 | 2021-12-02 | Clark | Ohio | 39023 | 21980 | 387 |
1971427 | 1971427 | 2021-12-01 | Clark | Ohio | 39023 | 21849 | 387 |
1968177 | 1968177 | 2021-11-30 | Clark | Ohio | 39023 | 21748 | 387 |
1964926 | 1964926 | 2021-11-29 | Clark | Ohio | 39023 | 21653 | 387 |
1961674 | 1961674 | 2021-11-28 | Clark | Ohio | 39023 | 21587 | 387 |
1958423 | 1958423 | 2021-11-27 | Clark | Ohio | 39023 | 21542 | 387 |
1955172 | 1955172 | 2021-11-26 | Clark | Ohio | 39023 | 21501 | 387 |
1951921 | 1951921 | 2021-11-25 | Clark | Ohio | 39023 | 21398 | 382 |
1948670 | 1948670 | 2021-11-24 | Clark | Ohio | 39023 | 21398 | 382 |
1945419 | 1945419 | 2021-11-23 | Clark | Ohio | 39023 | 21346 | 382 |
1942168 | 1942168 | 2021-11-22 | Clark | Ohio | 39023 | 21274 | 382 |
1938918 | 1938918 | 2021-11-21 | Clark | Ohio | 39023 | 21232 | 382 |
1935668 | 1935668 | 2021-11-20 | Clark | Ohio | 39023 | 21183 | 382 |
1932418 | 1932418 | 2021-11-19 | Clark | Ohio | 39023 | 21113 | 382 |
1929167 | 1929167 | 2021-11-18 | Clark | Ohio | 39023 | 21036 | 380 |
1925917 | 1925917 | 2021-11-17 | Clark | Ohio | 39023 | 20991 | 380 |
1922667 | 1922667 | 2021-11-16 | Clark | Ohio | 39023 | 20932 | 380 |
1919418 | 1919418 | 2021-11-15 | Clark | Ohio | 39023 | 20879 | 379 |
1916168 | 1916168 | 2021-11-14 | Clark | Ohio | 39023 | 20842 | 379 |
1912918 | 1912918 | 2021-11-13 | Clark | Ohio | 39023 | 20784 | 379 |
1909668 | 1909668 | 2021-11-12 | Clark | Ohio | 39023 | 20749 | 379 |
1906419 | 1906419 | 2021-11-11 | Clark | Ohio | 39023 | 20692 | 371 |
1903170 | 1903170 | 2021-11-10 | Clark | Ohio | 39023 | 20639 | 371 |
1899920 | 1899920 | 2021-11-09 | Clark | Ohio | 39023 | 20582 | 371 |
1896670 | 1896670 | 2021-11-08 | Clark | Ohio | 39023 | 20538 | 369 |
1893420 | 1893420 | 2021-11-07 | Clark | Ohio | 39023 | 20507 | 369 |
1890170 | 1890170 | 2021-11-06 | Clark | Ohio | 39023 | 20448 | 369 |
1886920 | 1886920 | 2021-11-05 | Clark | Ohio | 39023 | 20398 | 369 |
1883670 | 1883670 | 2021-11-04 | Clark | Ohio | 39023 | 20355 | 367 |
1880421 | 1880421 | 2021-11-03 | Clark | Ohio | 39023 | 20297 | 367 |
1877172 | 1877172 | 2021-11-02 | Clark | Ohio | 39023 | 20248 | 367 |
1873923 | 1873923 | 2021-11-01 | Clark | Ohio | 39023 | 20214 | 364 |
1870674 | 1870674 | 2021-10-31 | Clark | Ohio | 39023 | 20185 | 364 |
1867425 | 1867425 | 2021-10-30 | Clark | Ohio | 39023 | 20155 | 364 |
1864176 | 1864176 | 2021-10-29 | Clark | Ohio | 39023 | 20094 | 364 |
1860927 | 1860927 | 2021-10-28 | Clark | Ohio | 39023 | 20052 | 360 |
1857678 | 1857678 | 2021-10-27 | Clark | Ohio | 39023 | 20007 | 360 |
1854429 | 1854429 | 2021-10-26 | Clark | Ohio | 39023 | 19948 | 360 |
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);