ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Miami" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176314 | 2176314 | 2022-02-02 | Miami | Ohio | 39109 | 25126 | 429 |
2173060 | 2173060 | 2022-02-01 | Miami | Ohio | 39109 | 25041 | 429 |
2169808 | 2169808 | 2022-01-31 | Miami | Ohio | 39109 | 24948 | 422 |
2166553 | 2166553 | 2022-01-30 | Miami | Ohio | 39109 | 24914 | 422 |
2163298 | 2163298 | 2022-01-29 | Miami | Ohio | 39109 | 24866 | 422 |
2160043 | 2160043 | 2022-01-28 | Miami | Ohio | 39109 | 24767 | 422 |
2156788 | 2156788 | 2022-01-27 | Miami | Ohio | 39109 | 24665 | 410 |
2153535 | 2153535 | 2022-01-26 | Miami | Ohio | 39109 | 24532 | 410 |
2150283 | 2150283 | 2022-01-25 | Miami | Ohio | 39109 | 24273 | 410 |
2147031 | 2147031 | 2022-01-24 | Miami | Ohio | 39109 | 24243 | 408 |
2143777 | 2143777 | 2022-01-23 | Miami | Ohio | 39109 | 24086 | 408 |
2140522 | 2140522 | 2022-01-22 | Miami | Ohio | 39109 | 23931 | 408 |
2137266 | 2137266 | 2022-01-21 | Miami | Ohio | 39109 | 23785 | 408 |
2134012 | 2134012 | 2022-01-20 | Miami | Ohio | 39109 | 23567 | 395 |
2130760 | 2130760 | 2022-01-19 | Miami | Ohio | 39109 | 23274 | 395 |
2127506 | 2127506 | 2022-01-18 | Miami | Ohio | 39109 | 23075 | 395 |
2124254 | 2124254 | 2022-01-17 | Miami | Ohio | 39109 | 22806 | 389 |
2121002 | 2121002 | 2022-01-16 | Miami | Ohio | 39109 | 22611 | 389 |
2117750 | 2117750 | 2022-01-15 | Miami | Ohio | 39109 | 22308 | 389 |
2114499 | 2114499 | 2022-01-14 | Miami | Ohio | 39109 | 21697 | 389 |
2111247 | 2111247 | 2022-01-13 | Miami | Ohio | 39109 | 21290 | 381 |
2107995 | 2107995 | 2022-01-12 | Miami | Ohio | 39109 | 21100 | 381 |
2104744 | 2104744 | 2022-01-11 | Miami | Ohio | 39109 | 20916 | 381 |
2101493 | 2101493 | 2022-01-10 | Miami | Ohio | 39109 | 20774 | 379 |
2098242 | 2098242 | 2022-01-09 | Miami | Ohio | 39109 | 20601 | 379 |
2094990 | 2094990 | 2022-01-08 | Miami | Ohio | 39109 | 20486 | 379 |
2091738 | 2091738 | 2022-01-07 | Miami | Ohio | 39109 | 20347 | 379 |
2088486 | 2088486 | 2022-01-06 | Miami | Ohio | 39109 | 20155 | 377 |
2085235 | 2085235 | 2022-01-05 | Miami | Ohio | 39109 | 20061 | 377 |
2081983 | 2081983 | 2022-01-04 | Miami | Ohio | 39109 | 19910 | 377 |
2078731 | 2078731 | 2022-01-03 | Miami | Ohio | 39109 | 19741 | 375 |
2075480 | 2075480 | 2022-01-02 | Miami | Ohio | 39109 | 19647 | 375 |
2072229 | 2072229 | 2022-01-01 | Miami | Ohio | 39109 | 19397 | 375 |
2068978 | 2068978 | 2021-12-31 | Miami | Ohio | 39109 | 19397 | 375 |
2065727 | 2065727 | 2021-12-30 | Miami | Ohio | 39109 | 19244 | 371 |
2062477 | 2062477 | 2021-12-29 | Miami | Ohio | 39109 | 19094 | 371 |
2059227 | 2059227 | 2021-12-28 | Miami | Ohio | 39109 | 18964 | 371 |
2055978 | 2055978 | 2021-12-27 | Miami | Ohio | 39109 | 18872 | 369 |
2052729 | 2052729 | 2021-12-26 | Miami | Ohio | 39109 | 18826 | 369 |
2049479 | 2049479 | 2021-12-25 | Miami | Ohio | 39109 | 18714 | 369 |
2046229 | 2046229 | 2021-12-24 | Miami | Ohio | 39109 | 18714 | 369 |
2042979 | 2042979 | 2021-12-23 | Miami | Ohio | 39109 | 18632 | 363 |
2039730 | 2039730 | 2021-12-22 | Miami | Ohio | 39109 | 18526 | 363 |
2036480 | 2036480 | 2021-12-21 | Miami | Ohio | 39109 | 18486 | 363 |
2033230 | 2033230 | 2021-12-20 | Miami | Ohio | 39109 | 18406 | 360 |
2029980 | 2029980 | 2021-12-19 | Miami | Ohio | 39109 | 18356 | 360 |
2026729 | 2026729 | 2021-12-18 | Miami | Ohio | 39109 | 18303 | 360 |
2023478 | 2023478 | 2021-12-17 | Miami | Ohio | 39109 | 18238 | 360 |
2020227 | 2020227 | 2021-12-16 | Miami | Ohio | 39109 | 18188 | 357 |
2016976 | 2016976 | 2021-12-15 | Miami | Ohio | 39109 | 18111 | 357 |
2013726 | 2013726 | 2021-12-14 | Miami | Ohio | 39109 | 18047 | 357 |
2010475 | 2010475 | 2021-12-13 | Miami | Ohio | 39109 | 17977 | 355 |
2007224 | 2007224 | 2021-12-12 | Miami | Ohio | 39109 | 17885 | 355 |
2003973 | 2003973 | 2021-12-11 | Miami | Ohio | 39109 | 17864 | 355 |
2000722 | 2000722 | 2021-12-10 | Miami | Ohio | 39109 | 17802 | 355 |
1997472 | 1997472 | 2021-12-09 | Miami | Ohio | 39109 | 17714 | 352 |
1994221 | 1994221 | 2021-12-08 | Miami | Ohio | 39109 | 17654 | 352 |
1990970 | 1990970 | 2021-12-07 | Miami | Ohio | 39109 | 17571 | 352 |
1987719 | 1987719 | 2021-12-06 | Miami | Ohio | 39109 | 17486 | 352 |
1984469 | 1984469 | 2021-12-05 | Miami | Ohio | 39109 | 17456 | 352 |
1981219 | 1981219 | 2021-12-04 | Miami | Ohio | 39109 | 17412 | 352 |
1977969 | 1977969 | 2021-12-03 | Miami | Ohio | 39109 | 17338 | 352 |
1974719 | 1974719 | 2021-12-02 | Miami | Ohio | 39109 | 17196 | 348 |
1971470 | 1971470 | 2021-12-01 | Miami | Ohio | 39109 | 17136 | 348 |
1968220 | 1968220 | 2021-11-30 | Miami | Ohio | 39109 | 17074 | 348 |
1964969 | 1964969 | 2021-11-29 | Miami | Ohio | 39109 | 17031 | 348 |
1961717 | 1961717 | 2021-11-28 | Miami | Ohio | 39109 | 16983 | 348 |
1958466 | 1958466 | 2021-11-27 | Miami | Ohio | 39109 | 16950 | 348 |
1955215 | 1955215 | 2021-11-26 | Miami | Ohio | 39109 | 16931 | 348 |
1951964 | 1951964 | 2021-11-25 | Miami | Ohio | 39109 | 16876 | 343 |
1948713 | 1948713 | 2021-11-24 | Miami | Ohio | 39109 | 16876 | 343 |
1945462 | 1945462 | 2021-11-23 | Miami | Ohio | 39109 | 16832 | 343 |
1942211 | 1942211 | 2021-11-22 | Miami | Ohio | 39109 | 16787 | 343 |
1938961 | 1938961 | 2021-11-21 | Miami | Ohio | 39109 | 16748 | 343 |
1935711 | 1935711 | 2021-11-20 | Miami | Ohio | 39109 | 16729 | 343 |
1932461 | 1932461 | 2021-11-19 | Miami | Ohio | 39109 | 16691 | 343 |
1929210 | 1929210 | 2021-11-18 | Miami | Ohio | 39109 | 16653 | 343 |
1925960 | 1925960 | 2021-11-17 | Miami | Ohio | 39109 | 16595 | 343 |
1922710 | 1922710 | 2021-11-16 | Miami | Ohio | 39109 | 16553 | 343 |
1919461 | 1919461 | 2021-11-15 | Miami | Ohio | 39109 | 16495 | 340 |
1916211 | 1916211 | 2021-11-14 | Miami | Ohio | 39109 | 16454 | 340 |
1912961 | 1912961 | 2021-11-13 | Miami | Ohio | 39109 | 16418 | 340 |
1909711 | 1909711 | 2021-11-12 | Miami | Ohio | 39109 | 16387 | 340 |
1906462 | 1906462 | 2021-11-11 | Miami | Ohio | 39109 | 16330 | 332 |
1903213 | 1903213 | 2021-11-10 | Miami | Ohio | 39109 | 16274 | 332 |
1899963 | 1899963 | 2021-11-09 | Miami | Ohio | 39109 | 16228 | 332 |
1896713 | 1896713 | 2021-11-08 | Miami | Ohio | 39109 | 16178 | 329 |
1893463 | 1893463 | 2021-11-07 | Miami | Ohio | 39109 | 16155 | 329 |
1890213 | 1890213 | 2021-11-06 | Miami | Ohio | 39109 | 16122 | 329 |
1886963 | 1886963 | 2021-11-05 | Miami | Ohio | 39109 | 16096 | 329 |
1883713 | 1883713 | 2021-11-04 | Miami | Ohio | 39109 | 16061 | 326 |
1880464 | 1880464 | 2021-11-03 | Miami | Ohio | 39109 | 15990 | 326 |
1877215 | 1877215 | 2021-11-02 | Miami | Ohio | 39109 | 15947 | 326 |
1873966 | 1873966 | 2021-11-01 | Miami | Ohio | 39109 | 15910 | 322 |
1870717 | 1870717 | 2021-10-31 | Miami | Ohio | 39109 | 15887 | 322 |
1867468 | 1867468 | 2021-10-30 | Miami | Ohio | 39109 | 15848 | 322 |
1864219 | 1864219 | 2021-10-29 | Miami | Ohio | 39109 | 15814 | 322 |
1860970 | 1860970 | 2021-10-28 | Miami | Ohio | 39109 | 15779 | 313 |
1857721 | 1857721 | 2021-10-27 | Miami | Ohio | 39109 | 15717 | 313 |
1854472 | 1854472 | 2021-10-26 | Miami | Ohio | 39109 | 15676 | 313 |
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);