ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lake" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176302 | 2176302 | 2022-02-02 | Lake | Ohio | 39085 | 48056 | 661 |
2173048 | 2173048 | 2022-02-01 | Lake | Ohio | 39085 | 48010 | 661 |
2169796 | 2169796 | 2022-01-31 | Lake | Ohio | 39085 | 47967 | 646 |
2166541 | 2166541 | 2022-01-30 | Lake | Ohio | 39085 | 47924 | 646 |
2163286 | 2163286 | 2022-01-29 | Lake | Ohio | 39085 | 47881 | 646 |
2160031 | 2160031 | 2022-01-28 | Lake | Ohio | 39085 | 47837 | 646 |
2156776 | 2156776 | 2022-01-27 | Lake | Ohio | 39085 | 47803 | 636 |
2153523 | 2153523 | 2022-01-26 | Lake | Ohio | 39085 | 47723 | 636 |
2150271 | 2150271 | 2022-01-25 | Lake | Ohio | 39085 | 47606 | 636 |
2147019 | 2147019 | 2022-01-24 | Lake | Ohio | 39085 | 47591 | 611 |
2143765 | 2143765 | 2022-01-23 | Lake | Ohio | 39085 | 47530 | 611 |
2140510 | 2140510 | 2022-01-22 | Lake | Ohio | 39085 | 47462 | 611 |
2137254 | 2137254 | 2022-01-21 | Lake | Ohio | 39085 | 47351 | 611 |
2134000 | 2134000 | 2022-01-20 | Lake | Ohio | 39085 | 47212 | 605 |
2130748 | 2130748 | 2022-01-19 | Lake | Ohio | 39085 | 47051 | 605 |
2127494 | 2127494 | 2022-01-18 | Lake | Ohio | 39085 | 46923 | 605 |
2124242 | 2124242 | 2022-01-17 | Lake | Ohio | 39085 | 46850 | 586 |
2120990 | 2120990 | 2022-01-16 | Lake | Ohio | 39085 | 46667 | 586 |
2117738 | 2117738 | 2022-01-15 | Lake | Ohio | 39085 | 46434 | 586 |
2114487 | 2114487 | 2022-01-14 | Lake | Ohio | 39085 | 45932 | 586 |
2111235 | 2111235 | 2022-01-13 | Lake | Ohio | 39085 | 45535 | 579 |
2107983 | 2107983 | 2022-01-12 | Lake | Ohio | 39085 | 45341 | 579 |
2104732 | 2104732 | 2022-01-11 | Lake | Ohio | 39085 | 45094 | 579 |
2101481 | 2101481 | 2022-01-10 | Lake | Ohio | 39085 | 44837 | 565 |
2098230 | 2098230 | 2022-01-09 | Lake | Ohio | 39085 | 44577 | 565 |
2094978 | 2094978 | 2022-01-08 | Lake | Ohio | 39085 | 44184 | 565 |
2091726 | 2091726 | 2022-01-07 | Lake | Ohio | 39085 | 43904 | 565 |
2088474 | 2088474 | 2022-01-06 | Lake | Ohio | 39085 | 43655 | 557 |
2085223 | 2085223 | 2022-01-05 | Lake | Ohio | 39085 | 43293 | 557 |
2081971 | 2081971 | 2022-01-04 | Lake | Ohio | 39085 | 42971 | 557 |
2078719 | 2078719 | 2022-01-03 | Lake | Ohio | 39085 | 42676 | 556 |
2075468 | 2075468 | 2022-01-02 | Lake | Ohio | 39085 | 42270 | 556 |
2072217 | 2072217 | 2022-01-01 | Lake | Ohio | 39085 | 41121 | 556 |
2068966 | 2068966 | 2021-12-31 | Lake | Ohio | 39085 | 41121 | 556 |
2065715 | 2065715 | 2021-12-30 | Lake | Ohio | 39085 | 40619 | 547 |
2062465 | 2062465 | 2021-12-29 | Lake | Ohio | 39085 | 40184 | 547 |
2059215 | 2059215 | 2021-12-28 | Lake | Ohio | 39085 | 39592 | 547 |
2055966 | 2055966 | 2021-12-27 | Lake | Ohio | 39085 | 39178 | 545 |
2052717 | 2052717 | 2021-12-26 | Lake | Ohio | 39085 | 38907 | 545 |
2049467 | 2049467 | 2021-12-25 | Lake | Ohio | 39085 | 38115 | 545 |
2046217 | 2046217 | 2021-12-24 | Lake | Ohio | 39085 | 38115 | 545 |
2042967 | 2042967 | 2021-12-23 | Lake | Ohio | 39085 | 37543 | 533 |
2039718 | 2039718 | 2021-12-22 | Lake | Ohio | 39085 | 36964 | 533 |
2036468 | 2036468 | 2021-12-21 | Lake | Ohio | 39085 | 36498 | 533 |
2033218 | 2033218 | 2021-12-20 | Lake | Ohio | 39085 | 36057 | 531 |
2029968 | 2029968 | 2021-12-19 | Lake | Ohio | 39085 | 35776 | 531 |
2026717 | 2026717 | 2021-12-18 | Lake | Ohio | 39085 | 35418 | 531 |
2023466 | 2023466 | 2021-12-17 | Lake | Ohio | 39085 | 35093 | 531 |
2020215 | 2020215 | 2021-12-16 | Lake | Ohio | 39085 | 34809 | 519 |
2016964 | 2016964 | 2021-12-15 | Lake | Ohio | 39085 | 34513 | 519 |
2013714 | 2013714 | 2021-12-14 | Lake | Ohio | 39085 | 34279 | 519 |
2010463 | 2010463 | 2021-12-13 | Lake | Ohio | 39085 | 34055 | 516 |
2007212 | 2007212 | 2021-12-12 | Lake | Ohio | 39085 | 33935 | 516 |
2003961 | 2003961 | 2021-12-11 | Lake | Ohio | 39085 | 33777 | 516 |
2000710 | 2000710 | 2021-12-10 | Lake | Ohio | 39085 | 33618 | 516 |
1997460 | 1997460 | 2021-12-09 | Lake | Ohio | 39085 | 33408 | 506 |
1994209 | 1994209 | 2021-12-08 | Lake | Ohio | 39085 | 33218 | 506 |
1990958 | 1990958 | 2021-12-07 | Lake | Ohio | 39085 | 33008 | 506 |
1987707 | 1987707 | 2021-12-06 | Lake | Ohio | 39085 | 32818 | 501 |
1984457 | 1984457 | 2021-12-05 | Lake | Ohio | 39085 | 32696 | 501 |
1981207 | 1981207 | 2021-12-04 | Lake | Ohio | 39085 | 32510 | 501 |
1977957 | 1977957 | 2021-12-03 | Lake | Ohio | 39085 | 32314 | 501 |
1974707 | 1974707 | 2021-12-02 | Lake | Ohio | 39085 | 32124 | 495 |
1971458 | 1971458 | 2021-12-01 | Lake | Ohio | 39085 | 31871 | 495 |
1968208 | 1968208 | 2021-11-30 | Lake | Ohio | 39085 | 31622 | 495 |
1964957 | 1964957 | 2021-11-29 | Lake | Ohio | 39085 | 31445 | 493 |
1961705 | 1961705 | 2021-11-28 | Lake | Ohio | 39085 | 31317 | 493 |
1958454 | 1958454 | 2021-11-27 | Lake | Ohio | 39085 | 31171 | 493 |
1955203 | 1955203 | 2021-11-26 | Lake | Ohio | 39085 | 31044 | 493 |
1951952 | 1951952 | 2021-11-25 | Lake | Ohio | 39085 | 30757 | 486 |
1948701 | 1948701 | 2021-11-24 | Lake | Ohio | 39085 | 30757 | 486 |
1945450 | 1945450 | 2021-11-23 | Lake | Ohio | 39085 | 30540 | 486 |
1942199 | 1942199 | 2021-11-22 | Lake | Ohio | 39085 | 30372 | 482 |
1938949 | 1938949 | 2021-11-21 | Lake | Ohio | 39085 | 30262 | 482 |
1935699 | 1935699 | 2021-11-20 | Lake | Ohio | 39085 | 30110 | 482 |
1932449 | 1932449 | 2021-11-19 | Lake | Ohio | 39085 | 29898 | 482 |
1929198 | 1929198 | 2021-11-18 | Lake | Ohio | 39085 | 29689 | 474 |
1925948 | 1925948 | 2021-11-17 | Lake | Ohio | 39085 | 29510 | 474 |
1922698 | 1922698 | 2021-11-16 | Lake | Ohio | 39085 | 29326 | 474 |
1919449 | 1919449 | 2021-11-15 | Lake | Ohio | 39085 | 29190 | 470 |
1916199 | 1916199 | 2021-11-14 | Lake | Ohio | 39085 | 29089 | 470 |
1912949 | 1912949 | 2021-11-13 | Lake | Ohio | 39085 | 28985 | 470 |
1909699 | 1909699 | 2021-11-12 | Lake | Ohio | 39085 | 28857 | 470 |
1906450 | 1906450 | 2021-11-11 | Lake | Ohio | 39085 | 28713 | 468 |
1903201 | 1903201 | 2021-11-10 | Lake | Ohio | 39085 | 28590 | 468 |
1899951 | 1899951 | 2021-11-09 | Lake | Ohio | 39085 | 28468 | 468 |
1896701 | 1896701 | 2021-11-08 | Lake | Ohio | 39085 | 28348 | 461 |
1893451 | 1893451 | 2021-11-07 | Lake | Ohio | 39085 | 28289 | 461 |
1890201 | 1890201 | 2021-11-06 | Lake | Ohio | 39085 | 28155 | 461 |
1886951 | 1886951 | 2021-11-05 | Lake | Ohio | 39085 | 28087 | 461 |
1883701 | 1883701 | 2021-11-04 | Lake | Ohio | 39085 | 27992 | 457 |
1880452 | 1880452 | 2021-11-03 | Lake | Ohio | 39085 | 27896 | 457 |
1877203 | 1877203 | 2021-11-02 | Lake | Ohio | 39085 | 27791 | 457 |
1873954 | 1873954 | 2021-11-01 | Lake | Ohio | 39085 | 27710 | 454 |
1870705 | 1870705 | 2021-10-31 | Lake | Ohio | 39085 | 27647 | 454 |
1867456 | 1867456 | 2021-10-30 | Lake | Ohio | 39085 | 27588 | 454 |
1864207 | 1864207 | 2021-10-29 | Lake | Ohio | 39085 | 27501 | 454 |
1860958 | 1860958 | 2021-10-28 | Lake | Ohio | 39085 | 27420 | 451 |
1857709 | 1857709 | 2021-10-27 | Lake | Ohio | 39085 | 27328 | 451 |
1854460 | 1854460 | 2021-10-26 | Lake | Ohio | 39085 | 27256 | 451 |
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);