ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
268 rows where deaths = 43 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Geauga 24
- Morrow 18
- Fayette 15
- Fulton 14
- Paulding 14
- Vinton 14
- Clinton 10
- Monroe 10
- Morgan 10
- Pickaway 9
- Jackson 8
- Miami 8
- Ottawa 8
- Lake 6
- Muskingum 6
- Ashtabula 5
- Columbiana 5
- Jefferson 5
- Medina 5
- Perry 5
- Union 5
- Van Wert 5
- Carroll 4
- Crawford 4
- Delaware 4
- Gallia 4
- Lawrence 4
- Wood 4
- Adams 3
- Champaign 3
- …
state 1
- Ohio · 268 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2088514 | 2088514 | 2022-01-06 | Vinton | Ohio | 39163 | 2159 | 43 |
2085263 | 2085263 | 2022-01-05 | Vinton | Ohio | 39163 | 2145 | 43 |
2082011 | 2082011 | 2022-01-04 | Vinton | Ohio | 39163 | 2128 | 43 |
2078759 | 2078759 | 2022-01-03 | Vinton | Ohio | 39163 | 2105 | 43 |
2075508 | 2075508 | 2022-01-02 | Vinton | Ohio | 39163 | 2092 | 43 |
2072257 | 2072257 | 2022-01-01 | Vinton | Ohio | 39163 | 2074 | 43 |
2069006 | 2069006 | 2021-12-31 | Vinton | Ohio | 39163 | 2074 | 43 |
2065730 | 2065730 | 2021-12-30 | Morgan | Ohio | 39115 | 2397 | 43 |
2065755 | 2065755 | 2021-12-30 | Vinton | Ohio | 39163 | 2063 | 43 |
2062480 | 2062480 | 2021-12-29 | Morgan | Ohio | 39115 | 2384 | 43 |
2062505 | 2062505 | 2021-12-29 | Vinton | Ohio | 39163 | 2045 | 43 |
2059230 | 2059230 | 2021-12-28 | Morgan | Ohio | 39115 | 2366 | 43 |
2059255 | 2059255 | 2021-12-28 | Vinton | Ohio | 39163 | 2037 | 43 |
2055981 | 2055981 | 2021-12-27 | Morgan | Ohio | 39115 | 2354 | 43 |
2056006 | 2056006 | 2021-12-27 | Vinton | Ohio | 39163 | 2031 | 43 |
2052732 | 2052732 | 2021-12-26 | Morgan | Ohio | 39115 | 2348 | 43 |
2052757 | 2052757 | 2021-12-26 | Vinton | Ohio | 39163 | 2029 | 43 |
2049482 | 2049482 | 2021-12-25 | Morgan | Ohio | 39115 | 2344 | 43 |
2049507 | 2049507 | 2021-12-25 | Vinton | Ohio | 39163 | 2015 | 43 |
2046232 | 2046232 | 2021-12-24 | Morgan | Ohio | 39115 | 2344 | 43 |
2046257 | 2046257 | 2021-12-24 | Vinton | Ohio | 39163 | 2015 | 43 |
2042982 | 2042982 | 2021-12-23 | Morgan | Ohio | 39115 | 2341 | 43 |
2039733 | 2039733 | 2021-12-22 | Morgan | Ohio | 39115 | 2332 | 43 |
2036483 | 2036483 | 2021-12-21 | Morgan | Ohio | 39115 | 2323 | 43 |
1838203 | 1838203 | 2021-10-21 | Harrison | Ohio | 39067 | 1801 | 43 |
1834954 | 1834954 | 2021-10-20 | Harrison | Ohio | 39067 | 1794 | 43 |
1831705 | 1831705 | 2021-10-19 | Harrison | Ohio | 39067 | 1787 | 43 |
1782999 | 1782999 | 2021-10-04 | Paulding | Ohio | 39125 | 2587 | 43 |
1779750 | 1779750 | 2021-10-03 | Paulding | Ohio | 39125 | 2580 | 43 |
1776500 | 1776500 | 2021-10-02 | Paulding | Ohio | 39125 | 2574 | 43 |
1773250 | 1773250 | 2021-10-01 | Paulding | Ohio | 39125 | 2559 | 43 |
1769990 | 1769990 | 2021-09-30 | Meigs | Ohio | 39105 | 2321 | 43 |
1770000 | 1770000 | 2021-09-30 | Paulding | Ohio | 39125 | 2547 | 43 |
1766741 | 1766741 | 2021-09-29 | Meigs | Ohio | 39105 | 2291 | 43 |
1766751 | 1766751 | 2021-09-29 | Paulding | Ohio | 39125 | 2530 | 43 |
1763492 | 1763492 | 2021-09-28 | Meigs | Ohio | 39105 | 2274 | 43 |
1763502 | 1763502 | 2021-09-28 | Paulding | Ohio | 39125 | 2514 | 43 |
1760253 | 1760253 | 2021-09-27 | Paulding | Ohio | 39125 | 2488 | 43 |
1757005 | 1757005 | 2021-09-26 | Paulding | Ohio | 39125 | 2474 | 43 |
1753757 | 1753757 | 2021-09-25 | Paulding | Ohio | 39125 | 2464 | 43 |
1750509 | 1750509 | 2021-09-24 | Paulding | Ohio | 39125 | 2451 | 43 |
1747259 | 1747259 | 2021-09-23 | Paulding | Ohio | 39125 | 2435 | 43 |
1747262 | 1747262 | 2021-09-23 | Pike | Ohio | 39131 | 3926 | 43 |
1744010 | 1744010 | 2021-09-22 | Paulding | Ohio | 39125 | 2422 | 43 |
1744013 | 1744013 | 2021-09-22 | Pike | Ohio | 39131 | 3888 | 43 |
1740761 | 1740761 | 2021-09-21 | Paulding | Ohio | 39125 | 2403 | 43 |
1740764 | 1740764 | 2021-09-21 | Pike | Ohio | 39131 | 3846 | 43 |
1578329 | 1578329 | 2021-08-02 | Morrow | Ohio | 39117 | 2974 | 43 |
1575081 | 1575081 | 2021-08-01 | Morrow | Ohio | 39117 | 2960 | 43 |
1571833 | 1571833 | 2021-07-31 | Morrow | Ohio | 39117 | 2960 | 43 |
1568585 | 1568585 | 2021-07-30 | Morrow | Ohio | 39117 | 2954 | 43 |
1565337 | 1565337 | 2021-07-29 | Morrow | Ohio | 39117 | 2952 | 43 |
1562089 | 1562089 | 2021-07-28 | Morrow | Ohio | 39117 | 2949 | 43 |
1558841 | 1558841 | 2021-07-27 | Morrow | Ohio | 39117 | 2947 | 43 |
1555594 | 1555594 | 2021-07-26 | Morrow | Ohio | 39117 | 2946 | 43 |
1552347 | 1552347 | 2021-07-25 | Morrow | Ohio | 39117 | 2945 | 43 |
1549100 | 1549100 | 2021-07-24 | Morrow | Ohio | 39117 | 2945 | 43 |
1545853 | 1545853 | 2021-07-23 | Morrow | Ohio | 39117 | 2945 | 43 |
1542606 | 1542606 | 2021-07-22 | Morrow | Ohio | 39117 | 2945 | 43 |
1539358 | 1539358 | 2021-07-21 | Morrow | Ohio | 39117 | 2945 | 43 |
1536111 | 1536111 | 2021-07-20 | Morrow | Ohio | 39117 | 2944 | 43 |
1532863 | 1532863 | 2021-07-19 | Morrow | Ohio | 39117 | 2941 | 43 |
1529616 | 1529616 | 2021-07-18 | Morrow | Ohio | 39117 | 2939 | 43 |
1526369 | 1526369 | 2021-07-17 | Morrow | Ohio | 39117 | 2940 | 43 |
1523122 | 1523122 | 2021-07-16 | Morrow | Ohio | 39117 | 2939 | 43 |
1383544 | 1383544 | 2021-06-03 | Monroe | Ohio | 39111 | 1354 | 43 |
1380298 | 1380298 | 2021-06-02 | Monroe | Ohio | 39111 | 1353 | 43 |
1377053 | 1377053 | 2021-06-01 | Monroe | Ohio | 39111 | 1353 | 43 |
1373807 | 1373807 | 2021-05-31 | Monroe | Ohio | 39111 | 1351 | 43 |
1370562 | 1370562 | 2021-05-30 | Monroe | Ohio | 39111 | 1351 | 43 |
1367316 | 1367316 | 2021-05-29 | Monroe | Ohio | 39111 | 1351 | 43 |
1364070 | 1364070 | 2021-05-28 | Monroe | Ohio | 39111 | 1350 | 43 |
1360824 | 1360824 | 2021-05-27 | Monroe | Ohio | 39111 | 1342 | 43 |
1357578 | 1357578 | 2021-05-26 | Monroe | Ohio | 39111 | 1339 | 43 |
1354332 | 1354332 | 2021-05-25 | Monroe | Ohio | 39111 | 1337 | 43 |
1146483 | 1146483 | 2021-03-22 | Gallia | Ohio | 39053 | 2265 | 43 |
1143236 | 1143236 | 2021-03-21 | Gallia | Ohio | 39053 | 2264 | 43 |
1139989 | 1139989 | 2021-03-20 | Gallia | Ohio | 39053 | 2264 | 43 |
1136743 | 1136743 | 2021-03-19 | Gallia | Ohio | 39053 | 2264 | 43 |
1133471 | 1133471 | 2021-03-18 | Adams | Ohio | 39001 | 2206 | 43 |
1133494 | 1133494 | 2021-03-18 | Fayette | Ohio | 39047 | 2723 | 43 |
1130223 | 1130223 | 2021-03-17 | Adams | Ohio | 39001 | 2202 | 43 |
1130246 | 1130246 | 2021-03-17 | Fayette | Ohio | 39047 | 2720 | 43 |
1126976 | 1126976 | 2021-03-16 | Adams | Ohio | 39001 | 2201 | 43 |
1126999 | 1126999 | 2021-03-16 | Fayette | Ohio | 39047 | 2718 | 43 |
1123753 | 1123753 | 2021-03-15 | Fayette | Ohio | 39047 | 2716 | 43 |
1123809 | 1123809 | 2021-03-15 | Union | Ohio | 39159 | 5237 | 43 |
1120507 | 1120507 | 2021-03-14 | Fayette | Ohio | 39047 | 2713 | 43 |
1120563 | 1120563 | 2021-03-14 | Union | Ohio | 39159 | 5235 | 43 |
1117260 | 1117260 | 2021-03-13 | Fayette | Ohio | 39047 | 2713 | 43 |
1117316 | 1117316 | 2021-03-13 | Union | Ohio | 39159 | 5228 | 43 |
1114013 | 1114013 | 2021-03-12 | Fayette | Ohio | 39047 | 2712 | 43 |
1114069 | 1114069 | 2021-03-12 | Union | Ohio | 39159 | 5217 | 43 |
1110767 | 1110767 | 2021-03-11 | Fayette | Ohio | 39047 | 2709 | 43 |
1107521 | 1107521 | 2021-03-10 | Fayette | Ohio | 39047 | 2706 | 43 |
1104275 | 1104275 | 2021-03-09 | Fayette | Ohio | 39047 | 2703 | 43 |
1101015 | 1101015 | 2021-03-08 | Carroll | Ohio | 39019 | 1822 | 43 |
1101029 | 1101029 | 2021-03-08 | Fayette | Ohio | 39047 | 2703 | 43 |
1097769 | 1097769 | 2021-03-07 | Carroll | Ohio | 39019 | 1821 | 43 |
1097783 | 1097783 | 2021-03-07 | Fayette | Ohio | 39047 | 2701 | 43 |
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);