ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Lorain" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176306 | 2176306 | 2022-02-02 | Lorain | Ohio | 39093 | 65050 | 867 |
2173052 | 2173052 | 2022-02-01 | Lorain | Ohio | 39093 | 64945 | 867 |
2169800 | 2169800 | 2022-01-31 | Lorain | Ohio | 39093 | 64882 | 850 |
2166545 | 2166545 | 2022-01-30 | Lorain | Ohio | 39093 | 64810 | 850 |
2163290 | 2163290 | 2022-01-29 | Lorain | Ohio | 39093 | 64761 | 850 |
2160035 | 2160035 | 2022-01-28 | Lorain | Ohio | 39093 | 64687 | 850 |
2156780 | 2156780 | 2022-01-27 | Lorain | Ohio | 39093 | 64586 | 835 |
2153527 | 2153527 | 2022-01-26 | Lorain | Ohio | 39093 | 64456 | 835 |
2150275 | 2150275 | 2022-01-25 | Lorain | Ohio | 39093 | 64242 | 835 |
2147023 | 2147023 | 2022-01-24 | Lorain | Ohio | 39093 | 64214 | 809 |
2143769 | 2143769 | 2022-01-23 | Lorain | Ohio | 39093 | 64068 | 809 |
2140514 | 2140514 | 2022-01-22 | Lorain | Ohio | 39093 | 63976 | 809 |
2137258 | 2137258 | 2022-01-21 | Lorain | Ohio | 39093 | 63765 | 809 |
2134004 | 2134004 | 2022-01-20 | Lorain | Ohio | 39093 | 63561 | 792 |
2130752 | 2130752 | 2022-01-19 | Lorain | Ohio | 39093 | 63313 | 792 |
2127498 | 2127498 | 2022-01-18 | Lorain | Ohio | 39093 | 63061 | 792 |
2124246 | 2124246 | 2022-01-17 | Lorain | Ohio | 39093 | 62885 | 783 |
2120994 | 2120994 | 2022-01-16 | Lorain | Ohio | 39093 | 62529 | 783 |
2117742 | 2117742 | 2022-01-15 | Lorain | Ohio | 39093 | 62105 | 783 |
2114491 | 2114491 | 2022-01-14 | Lorain | Ohio | 39093 | 61289 | 783 |
2111239 | 2111239 | 2022-01-13 | Lorain | Ohio | 39093 | 60620 | 769 |
2107987 | 2107987 | 2022-01-12 | Lorain | Ohio | 39093 | 60223 | 769 |
2104736 | 2104736 | 2022-01-11 | Lorain | Ohio | 39093 | 59784 | 769 |
2101485 | 2101485 | 2022-01-10 | Lorain | Ohio | 39093 | 59413 | 764 |
2098234 | 2098234 | 2022-01-09 | Lorain | Ohio | 39093 | 58955 | 764 |
2094982 | 2094982 | 2022-01-08 | Lorain | Ohio | 39093 | 58486 | 764 |
2091730 | 2091730 | 2022-01-07 | Lorain | Ohio | 39093 | 57873 | 764 |
2088478 | 2088478 | 2022-01-06 | Lorain | Ohio | 39093 | 57527 | 735 |
2085227 | 2085227 | 2022-01-05 | Lorain | Ohio | 39093 | 56956 | 735 |
2081975 | 2081975 | 2022-01-04 | Lorain | Ohio | 39093 | 56483 | 735 |
2078723 | 2078723 | 2022-01-03 | Lorain | Ohio | 39093 | 56097 | 729 |
2075472 | 2075472 | 2022-01-02 | Lorain | Ohio | 39093 | 55440 | 729 |
2072221 | 2072221 | 2022-01-01 | Lorain | Ohio | 39093 | 53732 | 729 |
2068970 | 2068970 | 2021-12-31 | Lorain | Ohio | 39093 | 53732 | 729 |
2065719 | 2065719 | 2021-12-30 | Lorain | Ohio | 39093 | 52840 | 694 |
2062469 | 2062469 | 2021-12-29 | Lorain | Ohio | 39093 | 52167 | 694 |
2059219 | 2059219 | 2021-12-28 | Lorain | Ohio | 39093 | 51301 | 694 |
2055970 | 2055970 | 2021-12-27 | Lorain | Ohio | 39093 | 50827 | 693 |
2052721 | 2052721 | 2021-12-26 | Lorain | Ohio | 39093 | 50574 | 693 |
2049471 | 2049471 | 2021-12-25 | Lorain | Ohio | 39093 | 49564 | 693 |
2046221 | 2046221 | 2021-12-24 | Lorain | Ohio | 39093 | 49564 | 693 |
2042971 | 2042971 | 2021-12-23 | Lorain | Ohio | 39093 | 48807 | 686 |
2039722 | 2039722 | 2021-12-22 | Lorain | Ohio | 39093 | 48101 | 686 |
2036472 | 2036472 | 2021-12-21 | Lorain | Ohio | 39093 | 47503 | 686 |
2033222 | 2033222 | 2021-12-20 | Lorain | Ohio | 39093 | 46814 | 674 |
2029972 | 2029972 | 2021-12-19 | Lorain | Ohio | 39093 | 46504 | 674 |
2026721 | 2026721 | 2021-12-18 | Lorain | Ohio | 39093 | 46178 | 674 |
2023470 | 2023470 | 2021-12-17 | Lorain | Ohio | 39093 | 45844 | 674 |
2020219 | 2020219 | 2021-12-16 | Lorain | Ohio | 39093 | 45453 | 671 |
2016968 | 2016968 | 2021-12-15 | Lorain | Ohio | 39093 | 45100 | 671 |
2013718 | 2013718 | 2021-12-14 | Lorain | Ohio | 39093 | 44811 | 671 |
2010467 | 2010467 | 2021-12-13 | Lorain | Ohio | 39093 | 44609 | 669 |
2007216 | 2007216 | 2021-12-12 | Lorain | Ohio | 39093 | 44454 | 669 |
2003965 | 2003965 | 2021-12-11 | Lorain | Ohio | 39093 | 44259 | 669 |
2000714 | 2000714 | 2021-12-10 | Lorain | Ohio | 39093 | 44000 | 669 |
1997464 | 1997464 | 2021-12-09 | Lorain | Ohio | 39093 | 43792 | 650 |
1994213 | 1994213 | 2021-12-08 | Lorain | Ohio | 39093 | 43467 | 650 |
1990962 | 1990962 | 2021-12-07 | Lorain | Ohio | 39093 | 43171 | 650 |
1987711 | 1987711 | 2021-12-06 | Lorain | Ohio | 39093 | 42941 | 645 |
1984461 | 1984461 | 2021-12-05 | Lorain | Ohio | 39093 | 42754 | 645 |
1981211 | 1981211 | 2021-12-04 | Lorain | Ohio | 39093 | 42555 | 645 |
1977961 | 1977961 | 2021-12-03 | Lorain | Ohio | 39093 | 42330 | 645 |
1974711 | 1974711 | 2021-12-02 | Lorain | Ohio | 39093 | 41895 | 642 |
1971462 | 1971462 | 2021-12-01 | Lorain | Ohio | 39093 | 41562 | 642 |
1968212 | 1968212 | 2021-11-30 | Lorain | Ohio | 39093 | 41276 | 642 |
1964961 | 1964961 | 2021-11-29 | Lorain | Ohio | 39093 | 41058 | 639 |
1961709 | 1961709 | 2021-11-28 | Lorain | Ohio | 39093 | 40812 | 639 |
1958458 | 1958458 | 2021-11-27 | Lorain | Ohio | 39093 | 40661 | 639 |
1955207 | 1955207 | 2021-11-26 | Lorain | Ohio | 39093 | 40514 | 639 |
1951956 | 1951956 | 2021-11-25 | Lorain | Ohio | 39093 | 40179 | 633 |
1948705 | 1948705 | 2021-11-24 | Lorain | Ohio | 39093 | 40179 | 633 |
1945454 | 1945454 | 2021-11-23 | Lorain | Ohio | 39093 | 39973 | 633 |
1942203 | 1942203 | 2021-11-22 | Lorain | Ohio | 39093 | 39765 | 631 |
1938953 | 1938953 | 2021-11-21 | Lorain | Ohio | 39093 | 39620 | 631 |
1935703 | 1935703 | 2021-11-20 | Lorain | Ohio | 39093 | 39479 | 631 |
1932453 | 1932453 | 2021-11-19 | Lorain | Ohio | 39093 | 39323 | 631 |
1929202 | 1929202 | 2021-11-18 | Lorain | Ohio | 39093 | 39099 | 627 |
1925952 | 1925952 | 2021-11-17 | Lorain | Ohio | 39093 | 38881 | 627 |
1922702 | 1922702 | 2021-11-16 | Lorain | Ohio | 39093 | 38608 | 627 |
1919453 | 1919453 | 2021-11-15 | Lorain | Ohio | 39093 | 38467 | 626 |
1916203 | 1916203 | 2021-11-14 | Lorain | Ohio | 39093 | 38320 | 626 |
1912953 | 1912953 | 2021-11-13 | Lorain | Ohio | 39093 | 38215 | 626 |
1909703 | 1909703 | 2021-11-12 | Lorain | Ohio | 39093 | 38066 | 626 |
1906454 | 1906454 | 2021-11-11 | Lorain | Ohio | 39093 | 37842 | 615 |
1903205 | 1903205 | 2021-11-10 | Lorain | Ohio | 39093 | 37734 | 615 |
1899955 | 1899955 | 2021-11-09 | Lorain | Ohio | 39093 | 37537 | 615 |
1896705 | 1896705 | 2021-11-08 | Lorain | Ohio | 39093 | 37425 | 601 |
1893455 | 1893455 | 2021-11-07 | Lorain | Ohio | 39093 | 37280 | 601 |
1890205 | 1890205 | 2021-11-06 | Lorain | Ohio | 39093 | 37107 | 601 |
1886955 | 1886955 | 2021-11-05 | Lorain | Ohio | 39093 | 37023 | 601 |
1883705 | 1883705 | 2021-11-04 | Lorain | Ohio | 39093 | 36841 | 600 |
1880456 | 1880456 | 2021-11-03 | Lorain | Ohio | 39093 | 36686 | 600 |
1877207 | 1877207 | 2021-11-02 | Lorain | Ohio | 39093 | 36549 | 600 |
1873958 | 1873958 | 2021-11-01 | Lorain | Ohio | 39093 | 36469 | 600 |
1870709 | 1870709 | 2021-10-31 | Lorain | Ohio | 39093 | 36386 | 600 |
1867460 | 1867460 | 2021-10-30 | Lorain | Ohio | 39093 | 36286 | 600 |
1864211 | 1864211 | 2021-10-29 | Lorain | Ohio | 39093 | 36219 | 600 |
1860962 | 1860962 | 2021-10-28 | Lorain | Ohio | 39093 | 36118 | 591 |
1857713 | 1857713 | 2021-10-27 | Lorain | Ohio | 39093 | 36003 | 591 |
1854464 | 1854464 | 2021-10-26 | Lorain | Ohio | 39093 | 35859 | 591 |
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);