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 |
---|---|---|---|---|---|---|---|
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 |
1851211 | 1851211 | 2021-10-25 | Lake | Ohio | 39085 | 27179 | 448 |
1847961 | 1847961 | 2021-10-24 | Lake | Ohio | 39085 | 27122 | 448 |
1844711 | 1844711 | 2021-10-23 | Lake | Ohio | 39085 | 27063 | 448 |
1841461 | 1841461 | 2021-10-22 | Lake | Ohio | 39085 | 26979 | 448 |
1838212 | 1838212 | 2021-10-21 | Lake | Ohio | 39085 | 26907 | 443 |
1834963 | 1834963 | 2021-10-20 | Lake | Ohio | 39085 | 26812 | 443 |
1831714 | 1831714 | 2021-10-19 | Lake | Ohio | 39085 | 26743 | 443 |
1828465 | 1828465 | 2021-10-18 | Lake | Ohio | 39085 | 26669 | 434 |
1825216 | 1825216 | 2021-10-17 | Lake | Ohio | 39085 | 26609 | 434 |
1821967 | 1821967 | 2021-10-16 | Lake | Ohio | 39085 | 26543 | 434 |
1818718 | 1818718 | 2021-10-15 | Lake | Ohio | 39085 | 26457 | 434 |
1815469 | 1815469 | 2021-10-14 | Lake | Ohio | 39085 | 26352 | 432 |
1812221 | 1812221 | 2021-10-13 | Lake | Ohio | 39085 | 26274 | 432 |
1808972 | 1808972 | 2021-10-12 | Lake | Ohio | 39085 | 26163 | 432 |
1805722 | 1805722 | 2021-10-11 | Lake | Ohio | 39085 | 26093 | 432 |
1802472 | 1802472 | 2021-10-10 | Lake | Ohio | 39085 | 26029 | 432 |
1799223 | 1799223 | 2021-10-09 | Lake | Ohio | 39085 | 25941 | 432 |
1795974 | 1795974 | 2021-10-08 | Lake | Ohio | 39085 | 25876 | 432 |
1792725 | 1792725 | 2021-10-07 | Lake | Ohio | 39085 | 25776 | 428 |
1789476 | 1789476 | 2021-10-06 | Lake | Ohio | 39085 | 25664 | 428 |
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);