ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39017 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176268 | 2176268 | 2022-02-02 | Butler | Ohio | 39017 | 87394 | 1005 |
2173014 | 2173014 | 2022-02-01 | Butler | Ohio | 39017 | 87014 | 1005 |
2169762 | 2169762 | 2022-01-31 | Butler | Ohio | 39017 | 86742 | 992 |
2166507 | 2166507 | 2022-01-30 | Butler | Ohio | 39017 | 86580 | 992 |
2163252 | 2163252 | 2022-01-29 | Butler | Ohio | 39017 | 86315 | 992 |
2159997 | 2159997 | 2022-01-28 | Butler | Ohio | 39017 | 85903 | 992 |
2156742 | 2156742 | 2022-01-27 | Butler | Ohio | 39017 | 85466 | 976 |
2153489 | 2153489 | 2022-01-26 | Butler | Ohio | 39017 | 84954 | 976 |
2150237 | 2150237 | 2022-01-25 | Butler | Ohio | 39017 | 84055 | 976 |
2146985 | 2146985 | 2022-01-24 | Butler | Ohio | 39017 | 83907 | 963 |
2143731 | 2143731 | 2022-01-23 | Butler | Ohio | 39017 | 83420 | 963 |
2140476 | 2140476 | 2022-01-22 | Butler | Ohio | 39017 | 82981 | 963 |
2137220 | 2137220 | 2022-01-21 | Butler | Ohio | 39017 | 82238 | 963 |
2133966 | 2133966 | 2022-01-20 | Butler | Ohio | 39017 | 81317 | 942 |
2130714 | 2130714 | 2022-01-19 | Butler | Ohio | 39017 | 80397 | 942 |
2127460 | 2127460 | 2022-01-18 | Butler | Ohio | 39017 | 79406 | 942 |
2124208 | 2124208 | 2022-01-17 | Butler | Ohio | 39017 | 78647 | 924 |
2120956 | 2120956 | 2022-01-16 | Butler | Ohio | 39017 | 77779 | 924 |
2117704 | 2117704 | 2022-01-15 | Butler | Ohio | 39017 | 76443 | 924 |
2114453 | 2114453 | 2022-01-14 | Butler | Ohio | 39017 | 74092 | 924 |
2111201 | 2111201 | 2022-01-13 | Butler | Ohio | 39017 | 72444 | 918 |
2107949 | 2107949 | 2022-01-12 | Butler | Ohio | 39017 | 71597 | 918 |
2104698 | 2104698 | 2022-01-11 | Butler | Ohio | 39017 | 70936 | 918 |
2101447 | 2101447 | 2022-01-10 | Butler | Ohio | 39017 | 70018 | 909 |
2098196 | 2098196 | 2022-01-09 | Butler | Ohio | 39017 | 69440 | 909 |
2094944 | 2094944 | 2022-01-08 | Butler | Ohio | 39017 | 68779 | 909 |
2091692 | 2091692 | 2022-01-07 | Butler | Ohio | 39017 | 68213 | 909 |
2088440 | 2088440 | 2022-01-06 | Butler | Ohio | 39017 | 67445 | 897 |
2085189 | 2085189 | 2022-01-05 | Butler | Ohio | 39017 | 66888 | 897 |
2081937 | 2081937 | 2022-01-04 | Butler | Ohio | 39017 | 66296 | 897 |
2078685 | 2078685 | 2022-01-03 | Butler | Ohio | 39017 | 65744 | 893 |
2075434 | 2075434 | 2022-01-02 | Butler | Ohio | 39017 | 65272 | 893 |
2072183 | 2072183 | 2022-01-01 | Butler | Ohio | 39017 | 64354 | 893 |
2068932 | 2068932 | 2021-12-31 | Butler | Ohio | 39017 | 64354 | 893 |
2065681 | 2065681 | 2021-12-30 | Butler | Ohio | 39017 | 63801 | 879 |
2062431 | 2062431 | 2021-12-29 | Butler | Ohio | 39017 | 63238 | 879 |
2059181 | 2059181 | 2021-12-28 | Butler | Ohio | 39017 | 62779 | 879 |
2055932 | 2055932 | 2021-12-27 | Butler | Ohio | 39017 | 62306 | 878 |
2052683 | 2052683 | 2021-12-26 | Butler | Ohio | 39017 | 62126 | 878 |
2049433 | 2049433 | 2021-12-25 | Butler | Ohio | 39017 | 61779 | 878 |
2046183 | 2046183 | 2021-12-24 | Butler | Ohio | 39017 | 61779 | 878 |
2042933 | 2042933 | 2021-12-23 | Butler | Ohio | 39017 | 61521 | 865 |
2039684 | 2039684 | 2021-12-22 | Butler | Ohio | 39017 | 61260 | 865 |
2036434 | 2036434 | 2021-12-21 | Butler | Ohio | 39017 | 60952 | 865 |
2033184 | 2033184 | 2021-12-20 | Butler | Ohio | 39017 | 60704 | 857 |
2029934 | 2029934 | 2021-12-19 | Butler | Ohio | 39017 | 60529 | 857 |
2026683 | 2026683 | 2021-12-18 | Butler | Ohio | 39017 | 60399 | 857 |
2023432 | 2023432 | 2021-12-17 | Butler | Ohio | 39017 | 60147 | 857 |
2020181 | 2020181 | 2021-12-16 | Butler | Ohio | 39017 | 59929 | 843 |
2016930 | 2016930 | 2021-12-15 | Butler | Ohio | 39017 | 59547 | 843 |
2013680 | 2013680 | 2021-12-14 | Butler | Ohio | 39017 | 59244 | 843 |
2010429 | 2010429 | 2021-12-13 | Butler | Ohio | 39017 | 58792 | 829 |
2007178 | 2007178 | 2021-12-12 | Butler | Ohio | 39017 | 58587 | 829 |
2003927 | 2003927 | 2021-12-11 | Butler | Ohio | 39017 | 58487 | 829 |
2000676 | 2000676 | 2021-12-10 | Butler | Ohio | 39017 | 58244 | 829 |
1997426 | 1997426 | 2021-12-09 | Butler | Ohio | 39017 | 58042 | 817 |
1994175 | 1994175 | 2021-12-08 | Butler | Ohio | 39017 | 57796 | 817 |
1990924 | 1990924 | 2021-12-07 | Butler | Ohio | 39017 | 57534 | 817 |
1987673 | 1987673 | 2021-12-06 | Butler | Ohio | 39017 | 57319 | 814 |
1984423 | 1984423 | 2021-12-05 | Butler | Ohio | 39017 | 57225 | 814 |
1981173 | 1981173 | 2021-12-04 | Butler | Ohio | 39017 | 57083 | 814 |
1977923 | 1977923 | 2021-12-03 | Butler | Ohio | 39017 | 56852 | 814 |
1974673 | 1974673 | 2021-12-02 | Butler | Ohio | 39017 | 56598 | 805 |
1971424 | 1971424 | 2021-12-01 | Butler | Ohio | 39017 | 56343 | 805 |
1968174 | 1968174 | 2021-11-30 | Butler | Ohio | 39017 | 56096 | 805 |
1964923 | 1964923 | 2021-11-29 | Butler | Ohio | 39017 | 55878 | 803 |
1961671 | 1961671 | 2021-11-28 | Butler | Ohio | 39017 | 55716 | 803 |
1958420 | 1958420 | 2021-11-27 | Butler | Ohio | 39017 | 55597 | 803 |
1955169 | 1955169 | 2021-11-26 | Butler | Ohio | 39017 | 55535 | 803 |
1951918 | 1951918 | 2021-11-25 | Butler | Ohio | 39017 | 55231 | 794 |
1948667 | 1948667 | 2021-11-24 | Butler | Ohio | 39017 | 55231 | 794 |
1945416 | 1945416 | 2021-11-23 | Butler | Ohio | 39017 | 55043 | 794 |
1942165 | 1942165 | 2021-11-22 | Butler | Ohio | 39017 | 54887 | 794 |
1938915 | 1938915 | 2021-11-21 | Butler | Ohio | 39017 | 54776 | 794 |
1935665 | 1935665 | 2021-11-20 | Butler | Ohio | 39017 | 54693 | 794 |
1932415 | 1932415 | 2021-11-19 | Butler | Ohio | 39017 | 54531 | 794 |
1929164 | 1929164 | 2021-11-18 | Butler | Ohio | 39017 | 54354 | 783 |
1925914 | 1925914 | 2021-11-17 | Butler | Ohio | 39017 | 54204 | 783 |
1922664 | 1922664 | 2021-11-16 | Butler | Ohio | 39017 | 54022 | 783 |
1919415 | 1919415 | 2021-11-15 | Butler | Ohio | 39017 | 53841 | 778 |
1916165 | 1916165 | 2021-11-14 | Butler | Ohio | 39017 | 53773 | 778 |
1912915 | 1912915 | 2021-11-13 | Butler | Ohio | 39017 | 53666 | 778 |
1909665 | 1909665 | 2021-11-12 | Butler | Ohio | 39017 | 53564 | 778 |
1906416 | 1906416 | 2021-11-11 | Butler | Ohio | 39017 | 53427 | 758 |
1903167 | 1903167 | 2021-11-10 | Butler | Ohio | 39017 | 53292 | 758 |
1899917 | 1899917 | 2021-11-09 | Butler | Ohio | 39017 | 53145 | 758 |
1896667 | 1896667 | 2021-11-08 | Butler | Ohio | 39017 | 53041 | 751 |
1893417 | 1893417 | 2021-11-07 | Butler | Ohio | 39017 | 53002 | 751 |
1890167 | 1890167 | 2021-11-06 | Butler | Ohio | 39017 | 52879 | 751 |
1886917 | 1886917 | 2021-11-05 | Butler | Ohio | 39017 | 52796 | 751 |
1883667 | 1883667 | 2021-11-04 | Butler | Ohio | 39017 | 52698 | 742 |
1880418 | 1880418 | 2021-11-03 | Butler | Ohio | 39017 | 52585 | 742 |
1877169 | 1877169 | 2021-11-02 | Butler | Ohio | 39017 | 52483 | 742 |
1873920 | 1873920 | 2021-11-01 | Butler | Ohio | 39017 | 52347 | 729 |
1870671 | 1870671 | 2021-10-31 | Butler | Ohio | 39017 | 52295 | 729 |
1867422 | 1867422 | 2021-10-30 | Butler | Ohio | 39017 | 52220 | 729 |
1864173 | 1864173 | 2021-10-29 | Butler | Ohio | 39017 | 52114 | 729 |
1860924 | 1860924 | 2021-10-28 | Butler | Ohio | 39017 | 52002 | 724 |
1857675 | 1857675 | 2021-10-27 | Butler | Ohio | 39017 | 51893 | 724 |
1854426 | 1854426 | 2021-10-26 | Butler | Ohio | 39017 | 51809 | 724 |
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);