ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2020-10-22 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adams 1
- Allen 1
- Ashland 1
- Ashtabula 1
- Athens 1
- Auglaize 1
- Belmont 1
- Brown 1
- Butler 1
- Carroll 1
- Champaign 1
- Clark 1
- Clermont 1
- Clinton 1
- Columbiana 1
- Coshocton 1
- Crawford 1
- Cuyahoga 1
- Darke 1
- Defiance 1
- Delaware 1
- Erie 1
- Fairfield 1
- Fayette 1
- Franklin 1
- Fulton 1
- Gallia 1
- Geauga 1
- Greene 1
- Guernsey 1
- …
state 1
- Ohio · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
656418 | 656418 | 2020-10-22 | Adams | Ohio | 39001 | 209 | 6 |
656419 | 656419 | 2020-10-22 | Allen | Ohio | 39003 | 2130 | 73 |
656420 | 656420 | 2020-10-22 | Ashland | Ohio | 39005 | 398 | 6 |
656421 | 656421 | 2020-10-22 | Ashtabula | Ohio | 39007 | 726 | 48 |
656422 | 656422 | 2020-10-22 | Athens | Ohio | 39009 | 1205 | 2 |
656423 | 656423 | 2020-10-22 | Auglaize | Ohio | 39011 | 1006 | 16 |
656424 | 656424 | 2020-10-22 | Belmont | Ohio | 39013 | 788 | 27 |
656425 | 656425 | 2020-10-22 | Brown | Ohio | 39015 | 379 | 3 |
656426 | 656426 | 2020-10-22 | Butler | Ohio | 39017 | 8276 | 129 |
656427 | 656427 | 2020-10-22 | Carroll | Ohio | 39019 | 200 | 7 |
656428 | 656428 | 2020-10-22 | Champaign | Ohio | 39021 | 398 | 3 |
656429 | 656429 | 2020-10-22 | Clark | Ohio | 39023 | 2494 | 56 |
656430 | 656430 | 2020-10-22 | Clermont | Ohio | 39025 | 2459 | 38 |
656431 | 656431 | 2020-10-22 | Clinton | Ohio | 39027 | 464 | 13 |
656432 | 656432 | 2020-10-22 | Columbiana | Ohio | 39029 | 2128 | 87 |
656433 | 656433 | 2020-10-22 | Coshocton | Ohio | 39031 | 321 | 12 |
656434 | 656434 | 2020-10-22 | Crawford | Ohio | 39033 | 452 | 8 |
656435 | 656435 | 2020-10-22 | Cuyahoga | Ohio | 39035 | 19706 | 682 |
656436 | 656436 | 2020-10-22 | Darke | Ohio | 39037 | 1144 | 51 |
656437 | 656437 | 2020-10-22 | Defiance | Ohio | 39039 | 460 | 13 |
656438 | 656438 | 2020-10-22 | Delaware | Ohio | 39041 | 2872 | 27 |
656439 | 656439 | 2020-10-22 | Erie | Ohio | 39043 | 1155 | 53 |
656440 | 656440 | 2020-10-22 | Fairfield | Ohio | 39045 | 2644 | 57 |
656441 | 656441 | 2020-10-22 | Fayette | Ohio | 39047 | 449 | 8 |
656442 | 656442 | 2020-10-22 | Franklin | Ohio | 39049 | 31466 | 640 |
656443 | 656443 | 2020-10-22 | Fulton | Ohio | 39051 | 537 | 11 |
656444 | 656444 | 2020-10-22 | Gallia | Ohio | 39053 | 291 | 13 |
656445 | 656445 | 2020-10-22 | Geauga | Ohio | 39055 | 859 | 50 |
656446 | 656446 | 2020-10-22 | Greene | Ohio | 39057 | 2292 | 42 |
656447 | 656447 | 2020-10-22 | Guernsey | Ohio | 39059 | 321 | 8 |
656448 | 656448 | 2020-10-22 | Hamilton | Ohio | 39061 | 16687 | 343 |
656449 | 656449 | 2020-10-22 | Hancock | Ohio | 39063 | 1047 | 25 |
656450 | 656450 | 2020-10-22 | Hardin | Ohio | 39065 | 336 | 13 |
656451 | 656451 | 2020-10-22 | Harrison | Ohio | 39067 | 80 | 3 |
656452 | 656452 | 2020-10-22 | Henry | Ohio | 39069 | 473 | 17 |
656453 | 656453 | 2020-10-22 | Highland | Ohio | 39071 | 430 | 4 |
656454 | 656454 | 2020-10-22 | Hocking | Ohio | 39073 | 197 | 9 |
656455 | 656455 | 2020-10-22 | Holmes | Ohio | 39075 | 617 | 10 |
656456 | 656456 | 2020-10-22 | Huron | Ohio | 39077 | 709 | 12 |
656457 | 656457 | 2020-10-22 | Jackson | Ohio | 39079 | 459 | 8 |
656458 | 656458 | 2020-10-22 | Jefferson | Ohio | 39081 | 469 | 4 |
656459 | 656459 | 2020-10-22 | Knox | Ohio | 39083 | 384 | 16 |
656460 | 656460 | 2020-10-22 | Lake | Ohio | 39085 | 1936 | 59 |
656461 | 656461 | 2020-10-22 | Lawrence | Ohio | 39087 | 930 | 25 |
656462 | 656462 | 2020-10-22 | Licking | Ohio | 39089 | 2579 | 66 |
656463 | 656463 | 2020-10-22 | Logan | Ohio | 39091 | 423 | 3 |
656464 | 656464 | 2020-10-22 | Lorain | Ohio | 39093 | 2728 | 89 |
656465 | 656465 | 2020-10-22 | Lucas | Ohio | 39095 | 8285 | 373 |
656466 | 656466 | 2020-10-22 | Madison | Ohio | 39097 | 1054 | 15 |
656467 | 656467 | 2020-10-22 | Mahoning | Ohio | 39099 | 3709 | 286 |
656468 | 656468 | 2020-10-22 | Marion | Ohio | 39101 | 3388 | 50 |
656469 | 656469 | 2020-10-22 | Medina | Ohio | 39103 | 1856 | 42 |
656470 | 656470 | 2020-10-22 | Meigs | Ohio | 39105 | 210 | 12 |
656471 | 656471 | 2020-10-22 | Mercer | Ohio | 39107 | 1521 | 28 |
656472 | 656472 | 2020-10-22 | Miami | Ohio | 39109 | 1999 | 58 |
656473 | 656473 | 2020-10-22 | Monroe | Ohio | 39111 | 161 | 18 |
656474 | 656474 | 2020-10-22 | Montgomery | Ohio | 39113 | 10377 | 189 |
656475 | 656475 | 2020-10-22 | Morgan | Ohio | 39115 | 78 | 0 |
656476 | 656476 | 2020-10-22 | Morrow | Ohio | 39117 | 344 | 2 |
656477 | 656477 | 2020-10-22 | Muskingum | Ohio | 39119 | 888 | 4 |
656478 | 656478 | 2020-10-22 | Noble | Ohio | 39121 | 129 | 0 |
656479 | 656479 | 2020-10-22 | Ottawa | Ohio | 39123 | 584 | 30 |
656480 | 656480 | 2020-10-22 | Paulding | Ohio | 39125 | 201 | 2 |
656481 | 656481 | 2020-10-22 | Perry | Ohio | 39127 | 366 | 11 |
656482 | 656482 | 2020-10-22 | Pickaway | Ohio | 39129 | 3011 | 46 |
656483 | 656483 | 2020-10-22 | Pike | Ohio | 39131 | 300 | 0 |
656484 | 656484 | 2020-10-22 | Portage | Ohio | 39133 | 1620 | 68 |
656485 | 656485 | 2020-10-22 | Preble | Ohio | 39135 | 624 | 18 |
656486 | 656486 | 2020-10-22 | Putnam | Ohio | 39137 | 974 | 27 |
656487 | 656487 | 2020-10-22 | Richland | Ohio | 39139 | 1323 | 24 |
656488 | 656488 | 2020-10-22 | Ross | Ohio | 39141 | 1394 | 36 |
656489 | 656489 | 2020-10-22 | Sandusky | Ohio | 39143 | 711 | 22 |
656490 | 656490 | 2020-10-22 | Scioto | Ohio | 39145 | 859 | 9 |
656491 | 656491 | 2020-10-22 | Seneca | Ohio | 39147 | 601 | 14 |
656492 | 656492 | 2020-10-22 | Shelby | Ohio | 39149 | 909 | 14 |
656493 | 656493 | 2020-10-22 | Stark | Ohio | 39151 | 3796 | 181 |
656494 | 656494 | 2020-10-22 | Summit | Ohio | 39153 | 6689 | 265 |
656495 | 656495 | 2020-10-22 | Trumbull | Ohio | 39155 | 2270 | 134 |
656496 | 656496 | 2020-10-22 | Tuscarawas | Ohio | 39157 | 1290 | 24 |
656497 | 656497 | 2020-10-22 | Union | Ohio | 39159 | 758 | 3 |
656498 | 656498 | 2020-10-22 | Van Wert | Ohio | 39161 | 263 | 3 |
656499 | 656499 | 2020-10-22 | Vinton | Ohio | 39163 | 96 | 3 |
656500 | 656500 | 2020-10-22 | Warren | Ohio | 39165 | 4200 | 64 |
656501 | 656501 | 2020-10-22 | Washington | Ohio | 39167 | 351 | 24 |
656502 | 656502 | 2020-10-22 | Wayne | Ohio | 39169 | 1402 | 69 |
656503 | 656503 | 2020-10-22 | Williams | Ohio | 39171 | 335 | 4 |
656504 | 656504 | 2020-10-22 | Wood | Ohio | 39173 | 2496 | 81 |
656505 | 656505 | 2020-10-22 | Wyandot | Ohio | 39175 | 295 | 13 |
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);