ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39029 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176274 | 2176274 | 2022-02-02 | Columbiana | Ohio | 39029 | 23628 | 431 |
2173020 | 2173020 | 2022-02-01 | Columbiana | Ohio | 39029 | 23570 | 431 |
2169768 | 2169768 | 2022-01-31 | Columbiana | Ohio | 39029 | 23527 | 425 |
2166513 | 2166513 | 2022-01-30 | Columbiana | Ohio | 39029 | 23492 | 425 |
2163258 | 2163258 | 2022-01-29 | Columbiana | Ohio | 39029 | 23454 | 425 |
2160003 | 2160003 | 2022-01-28 | Columbiana | Ohio | 39029 | 23393 | 425 |
2156748 | 2156748 | 2022-01-27 | Columbiana | Ohio | 39029 | 23327 | 418 |
2153495 | 2153495 | 2022-01-26 | Columbiana | Ohio | 39029 | 23206 | 418 |
2150243 | 2150243 | 2022-01-25 | Columbiana | Ohio | 39029 | 23075 | 418 |
2146991 | 2146991 | 2022-01-24 | Columbiana | Ohio | 39029 | 23046 | 409 |
2143737 | 2143737 | 2022-01-23 | Columbiana | Ohio | 39029 | 22985 | 409 |
2140482 | 2140482 | 2022-01-22 | Columbiana | Ohio | 39029 | 22903 | 409 |
2137226 | 2137226 | 2022-01-21 | Columbiana | Ohio | 39029 | 22757 | 409 |
2133972 | 2133972 | 2022-01-20 | Columbiana | Ohio | 39029 | 22539 | 403 |
2130720 | 2130720 | 2022-01-19 | Columbiana | Ohio | 39029 | 22370 | 403 |
2127466 | 2127466 | 2022-01-18 | Columbiana | Ohio | 39029 | 22202 | 403 |
2124214 | 2124214 | 2022-01-17 | Columbiana | Ohio | 39029 | 22095 | 399 |
2120962 | 2120962 | 2022-01-16 | Columbiana | Ohio | 39029 | 21919 | 399 |
2117710 | 2117710 | 2022-01-15 | Columbiana | Ohio | 39029 | 21711 | 399 |
2114459 | 2114459 | 2022-01-14 | Columbiana | Ohio | 39029 | 21198 | 399 |
2111207 | 2111207 | 2022-01-13 | Columbiana | Ohio | 39029 | 20900 | 395 |
2107955 | 2107955 | 2022-01-12 | Columbiana | Ohio | 39029 | 20778 | 395 |
2104704 | 2104704 | 2022-01-11 | Columbiana | Ohio | 39029 | 20639 | 395 |
2101453 | 2101453 | 2022-01-10 | Columbiana | Ohio | 39029 | 20485 | 385 |
2098202 | 2098202 | 2022-01-09 | Columbiana | Ohio | 39029 | 20328 | 385 |
2094950 | 2094950 | 2022-01-08 | Columbiana | Ohio | 39029 | 20154 | 385 |
2091698 | 2091698 | 2022-01-07 | Columbiana | Ohio | 39029 | 19987 | 385 |
2088446 | 2088446 | 2022-01-06 | Columbiana | Ohio | 39029 | 19888 | 384 |
2085195 | 2085195 | 2022-01-05 | Columbiana | Ohio | 39029 | 19736 | 384 |
2081943 | 2081943 | 2022-01-04 | Columbiana | Ohio | 39029 | 19593 | 384 |
2078691 | 2078691 | 2022-01-03 | Columbiana | Ohio | 39029 | 19471 | 382 |
2075440 | 2075440 | 2022-01-02 | Columbiana | Ohio | 39029 | 19356 | 382 |
2072189 | 2072189 | 2022-01-01 | Columbiana | Ohio | 39029 | 19079 | 382 |
2068938 | 2068938 | 2021-12-31 | Columbiana | Ohio | 39029 | 19079 | 382 |
2065687 | 2065687 | 2021-12-30 | Columbiana | Ohio | 39029 | 18964 | 369 |
2062437 | 2062437 | 2021-12-29 | Columbiana | Ohio | 39029 | 18811 | 369 |
2059187 | 2059187 | 2021-12-28 | Columbiana | Ohio | 39029 | 18651 | 369 |
2055938 | 2055938 | 2021-12-27 | Columbiana | Ohio | 39029 | 18533 | 369 |
2052689 | 2052689 | 2021-12-26 | Columbiana | Ohio | 39029 | 18499 | 369 |
2049439 | 2049439 | 2021-12-25 | Columbiana | Ohio | 39029 | 18403 | 369 |
2046189 | 2046189 | 2021-12-24 | Columbiana | Ohio | 39029 | 18403 | 369 |
2042939 | 2042939 | 2021-12-23 | Columbiana | Ohio | 39029 | 18316 | 361 |
2039690 | 2039690 | 2021-12-22 | Columbiana | Ohio | 39029 | 18221 | 361 |
2036440 | 2036440 | 2021-12-21 | Columbiana | Ohio | 39029 | 18149 | 361 |
2033190 | 2033190 | 2021-12-20 | Columbiana | Ohio | 39029 | 18076 | 359 |
2029940 | 2029940 | 2021-12-19 | Columbiana | Ohio | 39029 | 18008 | 359 |
2026689 | 2026689 | 2021-12-18 | Columbiana | Ohio | 39029 | 17978 | 359 |
2023438 | 2023438 | 2021-12-17 | Columbiana | Ohio | 39029 | 17925 | 359 |
2020187 | 2020187 | 2021-12-16 | Columbiana | Ohio | 39029 | 17846 | 357 |
2016936 | 2016936 | 2021-12-15 | Columbiana | Ohio | 39029 | 17757 | 357 |
2013686 | 2013686 | 2021-12-14 | Columbiana | Ohio | 39029 | 17642 | 357 |
2010435 | 2010435 | 2021-12-13 | Columbiana | Ohio | 39029 | 17550 | 347 |
2007184 | 2007184 | 2021-12-12 | Columbiana | Ohio | 39029 | 17517 | 347 |
2003933 | 2003933 | 2021-12-11 | Columbiana | Ohio | 39029 | 17474 | 347 |
2000682 | 2000682 | 2021-12-10 | Columbiana | Ohio | 39029 | 17390 | 347 |
1997432 | 1997432 | 2021-12-09 | Columbiana | Ohio | 39029 | 17338 | 336 |
1994181 | 1994181 | 2021-12-08 | Columbiana | Ohio | 39029 | 17250 | 336 |
1990930 | 1990930 | 2021-12-07 | Columbiana | Ohio | 39029 | 17162 | 336 |
1987679 | 1987679 | 2021-12-06 | Columbiana | Ohio | 39029 | 17078 | 335 |
1984429 | 1984429 | 2021-12-05 | Columbiana | Ohio | 39029 | 17014 | 335 |
1981179 | 1981179 | 2021-12-04 | Columbiana | Ohio | 39029 | 16987 | 335 |
1977929 | 1977929 | 2021-12-03 | Columbiana | Ohio | 39029 | 16905 | 335 |
1974679 | 1974679 | 2021-12-02 | Columbiana | Ohio | 39029 | 16795 | 332 |
1971430 | 1971430 | 2021-12-01 | Columbiana | Ohio | 39029 | 16689 | 332 |
1968180 | 1968180 | 2021-11-30 | Columbiana | Ohio | 39029 | 16571 | 332 |
1964929 | 1964929 | 2021-11-29 | Columbiana | Ohio | 39029 | 16502 | 331 |
1961677 | 1961677 | 2021-11-28 | Columbiana | Ohio | 39029 | 16443 | 331 |
1958426 | 1958426 | 2021-11-27 | Columbiana | Ohio | 39029 | 16385 | 331 |
1955175 | 1955175 | 2021-11-26 | Columbiana | Ohio | 39029 | 16300 | 331 |
1951924 | 1951924 | 2021-11-25 | Columbiana | Ohio | 39029 | 16188 | 321 |
1948673 | 1948673 | 2021-11-24 | Columbiana | Ohio | 39029 | 16188 | 321 |
1945422 | 1945422 | 2021-11-23 | Columbiana | Ohio | 39029 | 16107 | 321 |
1942171 | 1942171 | 2021-11-22 | Columbiana | Ohio | 39029 | 16030 | 317 |
1938921 | 1938921 | 2021-11-21 | Columbiana | Ohio | 39029 | 15958 | 317 |
1935671 | 1935671 | 2021-11-20 | Columbiana | Ohio | 39029 | 15907 | 317 |
1932421 | 1932421 | 2021-11-19 | Columbiana | Ohio | 39029 | 15808 | 317 |
1929170 | 1929170 | 2021-11-18 | Columbiana | Ohio | 39029 | 15724 | 311 |
1925920 | 1925920 | 2021-11-17 | Columbiana | Ohio | 39029 | 15615 | 311 |
1922670 | 1922670 | 2021-11-16 | Columbiana | Ohio | 39029 | 15537 | 311 |
1919421 | 1919421 | 2021-11-15 | Columbiana | Ohio | 39029 | 15446 | 307 |
1916171 | 1916171 | 2021-11-14 | Columbiana | Ohio | 39029 | 15413 | 307 |
1912921 | 1912921 | 2021-11-13 | Columbiana | Ohio | 39029 | 15356 | 307 |
1909671 | 1909671 | 2021-11-12 | Columbiana | Ohio | 39029 | 15289 | 307 |
1906422 | 1906422 | 2021-11-11 | Columbiana | Ohio | 39029 | 15230 | 302 |
1903173 | 1903173 | 2021-11-10 | Columbiana | Ohio | 39029 | 15165 | 302 |
1899923 | 1899923 | 2021-11-09 | Columbiana | Ohio | 39029 | 15057 | 302 |
1896673 | 1896673 | 2021-11-08 | Columbiana | Ohio | 39029 | 14979 | 301 |
1893423 | 1893423 | 2021-11-07 | Columbiana | Ohio | 39029 | 14939 | 301 |
1890173 | 1890173 | 2021-11-06 | Columbiana | Ohio | 39029 | 14869 | 301 |
1886923 | 1886923 | 2021-11-05 | Columbiana | Ohio | 39029 | 14823 | 301 |
1883673 | 1883673 | 2021-11-04 | Columbiana | Ohio | 39029 | 14754 | 289 |
1880424 | 1880424 | 2021-11-03 | Columbiana | Ohio | 39029 | 14686 | 289 |
1877175 | 1877175 | 2021-11-02 | Columbiana | Ohio | 39029 | 14618 | 289 |
1873926 | 1873926 | 2021-11-01 | Columbiana | Ohio | 39029 | 14556 | 284 |
1870677 | 1870677 | 2021-10-31 | Columbiana | Ohio | 39029 | 14492 | 284 |
1867428 | 1867428 | 2021-10-30 | Columbiana | Ohio | 39029 | 14463 | 284 |
1864179 | 1864179 | 2021-10-29 | Columbiana | Ohio | 39029 | 14383 | 284 |
1860930 | 1860930 | 2021-10-28 | Columbiana | Ohio | 39029 | 14344 | 279 |
1857681 | 1857681 | 2021-10-27 | Columbiana | Ohio | 39029 | 14282 | 279 |
1854432 | 1854432 | 2021-10-26 | Columbiana | Ohio | 39029 | 14195 | 279 |
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);