ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
356 rows where deaths = 48 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Ashtabula 63
- Carroll 63
- Fayette 39
- Guernsey 21
- Morgan 18
- Marion 17
- Union 14
- Pickaway 12
- Warren 8
- Belmont 7
- Gallia 7
- Harrison 7
- Lawrence 7
- Perry 7
- Fulton 5
- Hocking 5
- Miami 5
- Wayne 5
- Jackson 4
- Monroe 4
- Williams 4
- Holmes 3
- Paulding 3
- Pike 3
- Trumbull 3
- Tuscarawas 3
- Delaware 2
- Geauga 2
- Butler 1
- Clermont 1
- …
state 1
- Ohio · 356 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2169811 | 2169811 | 2022-01-31 | Morgan | Ohio | 39115 | 3044 | 48 |
2166556 | 2166556 | 2022-01-30 | Morgan | Ohio | 39115 | 3031 | 48 |
2163301 | 2163301 | 2022-01-29 | Morgan | Ohio | 39115 | 3031 | 48 |
2160046 | 2160046 | 2022-01-28 | Morgan | Ohio | 39115 | 3013 | 48 |
2156791 | 2156791 | 2022-01-27 | Morgan | Ohio | 39115 | 3001 | 48 |
2153538 | 2153538 | 2022-01-26 | Morgan | Ohio | 39115 | 2977 | 48 |
2150286 | 2150286 | 2022-01-25 | Morgan | Ohio | 39115 | 2951 | 48 |
2147034 | 2147034 | 2022-01-24 | Morgan | Ohio | 39115 | 2927 | 48 |
2143780 | 2143780 | 2022-01-23 | Morgan | Ohio | 39115 | 2914 | 48 |
2140525 | 2140525 | 2022-01-22 | Morgan | Ohio | 39115 | 2894 | 48 |
2137269 | 2137269 | 2022-01-21 | Morgan | Ohio | 39115 | 2875 | 48 |
2134015 | 2134015 | 2022-01-20 | Morgan | Ohio | 39115 | 2833 | 48 |
2130763 | 2130763 | 2022-01-19 | Morgan | Ohio | 39115 | 2803 | 48 |
2127509 | 2127509 | 2022-01-18 | Morgan | Ohio | 39115 | 2781 | 48 |
2124257 | 2124257 | 2022-01-17 | Morgan | Ohio | 39115 | 2768 | 48 |
2121005 | 2121005 | 2022-01-16 | Morgan | Ohio | 39115 | 2753 | 48 |
2117753 | 2117753 | 2022-01-15 | Morgan | Ohio | 39115 | 2722 | 48 |
2114502 | 2114502 | 2022-01-14 | Morgan | Ohio | 39115 | 2682 | 48 |
1951972 | 1951972 | 2021-11-25 | Paulding | Ohio | 39125 | 3144 | 48 |
1948721 | 1948721 | 2021-11-24 | Paulding | Ohio | 39125 | 3144 | 48 |
1945470 | 1945470 | 2021-11-23 | Paulding | Ohio | 39125 | 3125 | 48 |
1896692 | 1896692 | 2021-11-08 | Harrison | Ohio | 39067 | 1897 | 48 |
1893442 | 1893442 | 2021-11-07 | Harrison | Ohio | 39067 | 1894 | 48 |
1890192 | 1890192 | 2021-11-06 | Harrison | Ohio | 39067 | 1891 | 48 |
1886942 | 1886942 | 2021-11-05 | Harrison | Ohio | 39067 | 1885 | 48 |
1883692 | 1883692 | 2021-11-04 | Harrison | Ohio | 39067 | 1878 | 48 |
1880443 | 1880443 | 2021-11-03 | Harrison | Ohio | 39067 | 1873 | 48 |
1877194 | 1877194 | 2021-11-02 | Harrison | Ohio | 39067 | 1867 | 48 |
1770003 | 1770003 | 2021-09-30 | Pike | Ohio | 39131 | 4097 | 48 |
1766754 | 1766754 | 2021-09-29 | Pike | Ohio | 39131 | 4076 | 48 |
1763505 | 1763505 | 2021-09-28 | Pike | Ohio | 39131 | 4047 | 48 |
1714761 | 1714761 | 2021-09-13 | Monroe | Ohio | 39111 | 1742 | 48 |
1711515 | 1711515 | 2021-09-12 | Monroe | Ohio | 39111 | 1729 | 48 |
1708268 | 1708268 | 2021-09-11 | Monroe | Ohio | 39111 | 1724 | 48 |
1705021 | 1705021 | 2021-09-10 | Monroe | Ohio | 39111 | 1712 | 48 |
1519825 | 1519825 | 2021-07-15 | Carroll | Ohio | 39019 | 1992 | 48 |
1516577 | 1516577 | 2021-07-14 | Carroll | Ohio | 39019 | 1989 | 48 |
1513330 | 1513330 | 2021-07-13 | Carroll | Ohio | 39019 | 1986 | 48 |
1510084 | 1510084 | 2021-07-12 | Carroll | Ohio | 39019 | 1985 | 48 |
1506837 | 1506837 | 2021-07-11 | Carroll | Ohio | 39019 | 1985 | 48 |
1503591 | 1503591 | 2021-07-10 | Carroll | Ohio | 39019 | 1985 | 48 |
1500345 | 1500345 | 2021-07-09 | Carroll | Ohio | 39019 | 1984 | 48 |
1497099 | 1497099 | 2021-07-08 | Carroll | Ohio | 39019 | 1983 | 48 |
1493852 | 1493852 | 2021-07-07 | Carroll | Ohio | 39019 | 1981 | 48 |
1490605 | 1490605 | 2021-07-06 | Carroll | Ohio | 39019 | 1981 | 48 |
1487358 | 1487358 | 2021-07-05 | Carroll | Ohio | 39019 | 1981 | 48 |
1484111 | 1484111 | 2021-07-04 | Carroll | Ohio | 39019 | 1981 | 48 |
1480865 | 1480865 | 2021-07-03 | Carroll | Ohio | 39019 | 1981 | 48 |
1477618 | 1477618 | 2021-07-02 | Carroll | Ohio | 39019 | 1981 | 48 |
1474372 | 1474372 | 2021-07-01 | Carroll | Ohio | 39019 | 1981 | 48 |
1471126 | 1471126 | 2021-06-30 | Carroll | Ohio | 39019 | 1981 | 48 |
1467881 | 1467881 | 2021-06-29 | Carroll | Ohio | 39019 | 1980 | 48 |
1464636 | 1464636 | 2021-06-28 | Carroll | Ohio | 39019 | 1980 | 48 |
1461391 | 1461391 | 2021-06-27 | Carroll | Ohio | 39019 | 1980 | 48 |
1458146 | 1458146 | 2021-06-26 | Carroll | Ohio | 39019 | 1977 | 48 |
1454901 | 1454901 | 2021-06-25 | Carroll | Ohio | 39019 | 1977 | 48 |
1451656 | 1451656 | 2021-06-24 | Carroll | Ohio | 39019 | 1977 | 48 |
1448410 | 1448410 | 2021-06-23 | Carroll | Ohio | 39019 | 1975 | 48 |
1445165 | 1445165 | 2021-06-22 | Carroll | Ohio | 39019 | 1974 | 48 |
1441920 | 1441920 | 2021-06-21 | Carroll | Ohio | 39019 | 1973 | 48 |
1438675 | 1438675 | 2021-06-20 | Carroll | Ohio | 39019 | 1973 | 48 |
1435428 | 1435428 | 2021-06-19 | Carroll | Ohio | 39019 | 1973 | 48 |
1432181 | 1432181 | 2021-06-18 | Carroll | Ohio | 39019 | 1973 | 48 |
1428935 | 1428935 | 2021-06-17 | Carroll | Ohio | 39019 | 1971 | 48 |
1425690 | 1425690 | 2021-06-16 | Carroll | Ohio | 39019 | 1970 | 48 |
1422443 | 1422443 | 2021-06-15 | Carroll | Ohio | 39019 | 1970 | 48 |
1419197 | 1419197 | 2021-06-14 | Carroll | Ohio | 39019 | 1969 | 48 |
1415952 | 1415952 | 2021-06-13 | Carroll | Ohio | 39019 | 1967 | 48 |
1412706 | 1412706 | 2021-06-12 | Carroll | Ohio | 39019 | 1966 | 48 |
1409461 | 1409461 | 2021-06-11 | Carroll | Ohio | 39019 | 1966 | 48 |
1406216 | 1406216 | 2021-06-10 | Carroll | Ohio | 39019 | 1965 | 48 |
1402970 | 1402970 | 2021-06-09 | Carroll | Ohio | 39019 | 1962 | 48 |
1399725 | 1399725 | 2021-06-08 | Carroll | Ohio | 39019 | 1962 | 48 |
1396480 | 1396480 | 2021-06-07 | Carroll | Ohio | 39019 | 1955 | 48 |
1393233 | 1393233 | 2021-06-06 | Carroll | Ohio | 39019 | 1954 | 48 |
1389988 | 1389988 | 2021-06-05 | Carroll | Ohio | 39019 | 1954 | 48 |
1386743 | 1386743 | 2021-06-04 | Carroll | Ohio | 39019 | 1953 | 48 |
1383498 | 1383498 | 2021-06-03 | Carroll | Ohio | 39019 | 1951 | 48 |
1380252 | 1380252 | 2021-06-02 | Carroll | Ohio | 39019 | 1951 | 48 |
1377007 | 1377007 | 2021-06-01 | Carroll | Ohio | 39019 | 1949 | 48 |
1373761 | 1373761 | 2021-05-31 | Carroll | Ohio | 39019 | 1940 | 48 |
1370516 | 1370516 | 2021-05-30 | Carroll | Ohio | 39019 | 1940 | 48 |
1367270 | 1367270 | 2021-05-29 | Carroll | Ohio | 39019 | 1940 | 48 |
1364024 | 1364024 | 2021-05-28 | Carroll | Ohio | 39019 | 1938 | 48 |
1360778 | 1360778 | 2021-05-27 | Carroll | Ohio | 39019 | 1938 | 48 |
1357532 | 1357532 | 2021-05-26 | Carroll | Ohio | 39019 | 1937 | 48 |
1354286 | 1354286 | 2021-05-25 | Carroll | Ohio | 39019 | 1935 | 48 |
1351040 | 1351040 | 2021-05-24 | Carroll | Ohio | 39019 | 1934 | 48 |
1347794 | 1347794 | 2021-05-23 | Carroll | Ohio | 39019 | 1933 | 48 |
1344546 | 1344546 | 2021-05-22 | Carroll | Ohio | 39019 | 1932 | 48 |
1341298 | 1341298 | 2021-05-21 | Carroll | Ohio | 39019 | 1931 | 48 |
1338050 | 1338050 | 2021-05-20 | Carroll | Ohio | 39019 | 1929 | 48 |
1334803 | 1334803 | 2021-05-19 | Carroll | Ohio | 39019 | 1928 | 48 |
1331556 | 1331556 | 2021-05-18 | Carroll | Ohio | 39019 | 1924 | 48 |
1328309 | 1328309 | 2021-05-17 | Carroll | Ohio | 39019 | 1924 | 48 |
1328379 | 1328379 | 2021-05-17 | Union | Ohio | 39159 | 5754 | 48 |
1325063 | 1325063 | 2021-05-16 | Carroll | Ohio | 39019 | 1924 | 48 |
1325133 | 1325133 | 2021-05-16 | Union | Ohio | 39159 | 5750 | 48 |
1321817 | 1321817 | 2021-05-15 | Carroll | Ohio | 39019 | 1920 | 48 |
1321887 | 1321887 | 2021-05-15 | Union | Ohio | 39159 | 5748 | 48 |
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);