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-08-02 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 |
---|---|---|---|---|---|---|---|
394410 | 394410 | 2020-08-02 | Adams | Ohio | 39001 | 53 | 2 |
394411 | 394411 | 2020-08-02 | Allen | Ohio | 39003 | 646 | 42 |
394412 | 394412 | 2020-08-02 | Ashland | Ohio | 39005 | 130 | 3 |
394413 | 394413 | 2020-08-02 | Ashtabula | Ohio | 39007 | 538 | 45 |
394414 | 394414 | 2020-08-02 | Athens | Ohio | 39009 | 344 | 1 |
394415 | 394415 | 2020-08-02 | Auglaize | Ohio | 39011 | 213 | 5 |
394416 | 394416 | 2020-08-02 | Belmont | Ohio | 39013 | 589 | 26 |
394417 | 394417 | 2020-08-02 | Brown | Ohio | 39015 | 112 | 1 |
394418 | 394418 | 2020-08-02 | Butler | Ohio | 39017 | 2683 | 59 |
394419 | 394419 | 2020-08-02 | Carroll | Ohio | 39019 | 107 | 5 |
394420 | 394420 | 2020-08-02 | Champaign | Ohio | 39021 | 105 | 1 |
394421 | 394421 | 2020-08-02 | Clark | Ohio | 39023 | 1076 | 13 |
394422 | 394422 | 2020-08-02 | Clermont | Ohio | 39025 | 835 | 10 |
394423 | 394423 | 2020-08-02 | Clinton | Ohio | 39027 | 146 | 6 |
394424 | 394424 | 2020-08-02 | Columbiana | Ohio | 39029 | 1570 | 60 |
394425 | 394425 | 2020-08-02 | Coshocton | Ohio | 39031 | 185 | 6 |
394426 | 394426 | 2020-08-02 | Crawford | Ohio | 39033 | 164 | 5 |
394427 | 394427 | 2020-08-02 | Cuyahoga | Ohio | 39035 | 12646 | 477 |
394428 | 394428 | 2020-08-02 | Darke | Ohio | 39037 | 316 | 27 |
394429 | 394429 | 2020-08-02 | Defiance | Ohio | 39039 | 129 | 4 |
394430 | 394430 | 2020-08-02 | Delaware | Ohio | 39041 | 1194 | 18 |
394431 | 394431 | 2020-08-02 | Erie | Ohio | 39043 | 516 | 27 |
394432 | 394432 | 2020-08-02 | Fairfield | Ohio | 39045 | 1238 | 25 |
394433 | 394433 | 2020-08-02 | Fayette | Ohio | 39047 | 94 | 0 |
394434 | 394434 | 2020-08-02 | Franklin | Ohio | 39049 | 17107 | 514 |
394435 | 394435 | 2020-08-02 | Fulton | Ohio | 39051 | 139 | 1 |
394436 | 394436 | 2020-08-02 | Gallia | Ohio | 39053 | 57 | 1 |
394437 | 394437 | 2020-08-02 | Geauga | Ohio | 39055 | 528 | 43 |
394438 | 394438 | 2020-08-02 | Greene | Ohio | 39057 | 619 | 11 |
394439 | 394439 | 2020-08-02 | Guernsey | Ohio | 39059 | 110 | 6 |
394440 | 394440 | 2020-08-02 | Hamilton | Ohio | 39061 | 9110 | 247 |
394441 | 394441 | 2020-08-02 | Hancock | Ohio | 39063 | 315 | 2 |
394442 | 394442 | 2020-08-02 | Hardin | Ohio | 39065 | 150 | 12 |
394443 | 394443 | 2020-08-02 | Harrison | Ohio | 39067 | 19 | 1 |
394444 | 394444 | 2020-08-02 | Henry | Ohio | 39069 | 106 | 1 |
394445 | 394445 | 2020-08-02 | Highland | Ohio | 39071 | 127 | 1 |
394446 | 394446 | 2020-08-02 | Hocking | Ohio | 39073 | 108 | 9 |
394447 | 394447 | 2020-08-02 | Holmes | Ohio | 39075 | 320 | 6 |
394448 | 394448 | 2020-08-02 | Huron | Ohio | 39077 | 371 | 4 |
394449 | 394449 | 2020-08-02 | Jackson | Ohio | 39079 | 65 | 0 |
394450 | 394450 | 2020-08-02 | Jefferson | Ohio | 39081 | 204 | 3 |
394451 | 394451 | 2020-08-02 | Knox | Ohio | 39083 | 165 | 2 |
394452 | 394452 | 2020-08-02 | Lake | Ohio | 39085 | 1034 | 35 |
394453 | 394453 | 2020-08-02 | Lawrence | Ohio | 39087 | 216 | 0 |
394454 | 394454 | 2020-08-02 | Licking | Ohio | 39089 | 1116 | 42 |
394455 | 394455 | 2020-08-02 | Logan | Ohio | 39091 | 120 | 1 |
394456 | 394456 | 2020-08-02 | Lorain | Ohio | 39093 | 1620 | 76 |
394457 | 394457 | 2020-08-02 | Lucas | Ohio | 39095 | 4852 | 318 |
394458 | 394458 | 2020-08-02 | Madison | Ohio | 39097 | 329 | 10 |
394459 | 394459 | 2020-08-02 | Mahoning | Ohio | 39099 | 2393 | 253 |
394460 | 394460 | 2020-08-02 | Marion | Ohio | 39101 | 2875 | 44 |
394461 | 394461 | 2020-08-02 | Medina | Ohio | 39103 | 831 | 33 |
394462 | 394462 | 2020-08-02 | Meigs | Ohio | 39105 | 24 | 0 |
394463 | 394463 | 2020-08-02 | Mercer | Ohio | 39107 | 522 | 13 |
394464 | 394464 | 2020-08-02 | Miami | Ohio | 39109 | 768 | 37 |
394465 | 394465 | 2020-08-02 | Monroe | Ohio | 39111 | 90 | 18 |
394466 | 394466 | 2020-08-02 | Montgomery | Ohio | 39113 | 4024 | 77 |
394467 | 394467 | 2020-08-02 | Morgan | Ohio | 39115 | 20 | 0 |
394468 | 394468 | 2020-08-02 | Morrow | Ohio | 39117 | 158 | 2 |
394469 | 394469 | 2020-08-02 | Muskingum | Ohio | 39119 | 178 | 1 |
394470 | 394470 | 2020-08-02 | Noble | Ohio | 39121 | 16 | 0 |
394471 | 394471 | 2020-08-02 | Ottawa | Ohio | 39123 | 352 | 25 |
394472 | 394472 | 2020-08-02 | Paulding | Ohio | 39125 | 59 | 0 |
394473 | 394473 | 2020-08-02 | Perry | Ohio | 39127 | 105 | 2 |
394474 | 394474 | 2020-08-02 | Pickaway | Ohio | 39129 | 2352 | 42 |
394475 | 394475 | 2020-08-02 | Pike | Ohio | 39131 | 66 | 0 |
394476 | 394476 | 2020-08-02 | Portage | Ohio | 39133 | 711 | 60 |
394477 | 394477 | 2020-08-02 | Preble | Ohio | 39135 | 164 | 2 |
394478 | 394478 | 2020-08-02 | Putnam | Ohio | 39137 | 193 | 17 |
394479 | 394479 | 2020-08-02 | Richland | Ohio | 39139 | 536 | 10 |
394480 | 394480 | 2020-08-02 | Ross | Ohio | 39141 | 387 | 4 |
394481 | 394481 | 2020-08-02 | Sandusky | Ohio | 39143 | 329 | 17 |
394482 | 394482 | 2020-08-02 | Scioto | Ohio | 39145 | 185 | 1 |
394483 | 394483 | 2020-08-02 | Seneca | Ohio | 39147 | 153 | 3 |
394484 | 394484 | 2020-08-02 | Shelby | Ohio | 39149 | 157 | 4 |
394485 | 394485 | 2020-08-02 | Stark | Ohio | 39151 | 1679 | 132 |
394486 | 394486 | 2020-08-02 | Summit | Ohio | 39153 | 3248 | 217 |
394487 | 394487 | 2020-08-02 | Trumbull | Ohio | 39155 | 1421 | 103 |
394488 | 394488 | 2020-08-02 | Tuscarawas | Ohio | 39157 | 746 | 13 |
394489 | 394489 | 2020-08-02 | Union | Ohio | 39159 | 214 | 1 |
394490 | 394490 | 2020-08-02 | Van Wert | Ohio | 39161 | 68 | 1 |
394491 | 394491 | 2020-08-02 | Vinton | Ohio | 39163 | 30 | 2 |
394492 | 394492 | 2020-08-02 | Warren | Ohio | 39165 | 1600 | 35 |
394493 | 394493 | 2020-08-02 | Washington | Ohio | 39167 | 197 | 22 |
394494 | 394494 | 2020-08-02 | Wayne | Ohio | 39169 | 492 | 58 |
394495 | 394495 | 2020-08-02 | Williams | Ohio | 39171 | 123 | 3 |
394496 | 394496 | 2020-08-02 | Wood | Ohio | 39173 | 910 | 58 |
394497 | 394497 | 2020-08-02 | Wyandot | Ohio | 39175 | 119 | 5 |
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);