ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69,101 rows where state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 39035 795
- 39151 793
- 39155 792
- 39049 790
- 39093 790
- 39153 790
- 39157 790
- 39013 789
- 39017 789
- 39095 789
- 39103 789
- 39055 788
- 39031 787
- 39037 787
- 39085 787
- 39099 787
- 39023 786
- 39041 786
- 39077 786
- 39109 786
- 39005 785
- 39061 785
- 39113 785
- 39139 785
- 39029 784
- 39101 784
- 39159 784
- 39165 784
- 39007 783
- 39025 783
- …
county >30
- Cuyahoga 795
- Stark 793
- Trumbull 792
- Franklin 790
- Lorain 790
- Summit 790
- Tuscarawas 790
- Belmont 789
- Butler 789
- Lucas 789
- Medina 789
- Geauga 788
- Coshocton 787
- Darke 787
- Lake 787
- Mahoning 787
- Clark 786
- Delaware 786
- Huron 786
- Miami 786
- Ashland 785
- Hamilton 785
- Montgomery 785
- Richland 785
- Columbiana 784
- Marion 784
- Union 784
- Warren 784
- Ashtabula 783
- Clermont 783
- …
state 1
- Ohio · 69,001 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498397 | 2498397 | 2022-05-12 | Clark | Ohio | 39023 | 35217 | 586 |
2498398 | 2498398 | 2022-05-12 | Clermont | Ohio | 39025 | 51997 | 560 |
2498399 | 2498399 | 2022-05-12 | Clinton | Ohio | 39027 | 10410 | 168 |
2498400 | 2498400 | 2022-05-12 | Columbiana | Ohio | 39029 | 24651 | 486 |
2498401 | 2498401 | 2022-05-12 | Coshocton | Ohio | 39031 | 8008 | 159 |
2498402 | 2498402 | 2022-05-12 | Crawford | Ohio | 39033 | 11254 | 215 |
2498403 | 2498403 | 2022-05-12 | Cuyahoga | Ohio | 39035 | 276160 | 3794 |
2498404 | 2498404 | 2022-05-12 | Darke | Ohio | 39037 | 12442 | 239 |
2498405 | 2498405 | 2022-05-12 | Defiance | Ohio | 39039 | 10275 | 165 |
2498406 | 2498406 | 2022-05-12 | Delaware | Ohio | 39041 | 45538 | 272 |
2498407 | 2498407 | 2022-05-12 | Erie | Ohio | 39043 | 19730 | 267 |
2498408 | 2498408 | 2022-05-12 | Fairfield | Ohio | 39045 | 39082 | 430 |
2498409 | 2498409 | 2022-05-12 | Fayette | Ohio | 39047 | 7846 | 121 |
2498410 | 2498410 | 2022-05-12 | Franklin | Ohio | 39049 | 296037 | 2610 |
2498411 | 2498411 | 2022-05-12 | Fulton | Ohio | 39051 | 10436 | 180 |
2498412 | 2498412 | 2022-05-12 | Gallia | Ohio | 39053 | 7565 | 127 |
2498413 | 2498413 | 2022-05-12 | Geauga | Ohio | 39055 | 16413 | 265 |
2498414 | 2498414 | 2022-05-12 | Greene | Ohio | 39057 | 38049 | 513 |
2498415 | 2498415 | 2022-05-12 | Guernsey | Ohio | 39059 | 10567 | 151 |
2498416 | 2498416 | 2022-05-12 | Hamilton | Ohio | 39061 | 191030 | 2069 |
2498417 | 2498417 | 2022-05-12 | Hancock | Ohio | 39063 | 17253 | 277 |
2498418 | 2498418 | 2022-05-12 | Hardin | Ohio | 39065 | 7138 | 158 |
2498419 | 2498419 | 2022-05-12 | Harrison | Ohio | 39067 | 3263 | 74 |
2498420 | 2498420 | 2022-05-12 | Henry | Ohio | 39069 | 6485 | 106 |
2498421 | 2498421 | 2022-05-12 | Highland | Ohio | 39071 | 10675 | 184 |
2498422 | 2498422 | 2022-05-12 | Hocking | Ohio | 39073 | 6731 | 123 |
2498423 | 2498423 | 2022-05-12 | Holmes | Ohio | 39075 | 5135 | 182 |
2498424 | 2498424 | 2022-05-12 | Huron | Ohio | 39077 | 14626 | 222 |
2498425 | 2498425 | 2022-05-12 | Jackson | Ohio | 39079 | 8988 | 141 |
2498426 | 2498426 | 2022-05-12 | Jefferson | Ohio | 39081 | 14900 | 322 |
2498427 | 2498427 | 2022-05-12 | Knox | Ohio | 39083 | 13325 | 228 |
2498428 | 2498428 | 2022-05-12 | Lake | Ohio | 39085 | 49961 | 737 |
2498429 | 2498429 | 2022-05-12 | Lawrence | Ohio | 39087 | 18071 | 256 |
2498430 | 2498430 | 2022-05-12 | Licking | Ohio | 39089 | 42276 | 475 |
2498431 | 2498431 | 2022-05-12 | Logan | Ohio | 39091 | 10333 | 173 |
2498432 | 2498432 | 2022-05-12 | Lorain | Ohio | 39093 | 68382 | 981 |
2498433 | 2498433 | 2022-05-12 | Lucas | Ohio | 39095 | 103434 | 1420 |
2498434 | 2498434 | 2022-05-12 | Madison | Ohio | 39097 | 9754 | 136 |
2498435 | 2498435 | 2022-05-12 | Mahoning | Ohio | 39099 | 54021 | 1089 |
2498436 | 2498436 | 2022-05-12 | Marion | Ohio | 39101 | 20070 | 268 |
2498437 | 2498437 | 2022-05-12 | Medina | Ohio | 39103 | 40840 | 507 |
2498438 | 2498438 | 2022-05-12 | Meigs | Ohio | 39105 | 4686 | 88 |
2498439 | 2498439 | 2022-05-12 | Mercer | Ohio | 39107 | 9715 | 144 |
2498440 | 2498440 | 2022-05-12 | Miami | Ohio | 39109 | 25909 | 483 |
2498441 | 2498441 | 2022-05-12 | Monroe | Ohio | 39111 | 3499 | 82 |
2498442 | 2498442 | 2022-05-12 | Montgomery | Ohio | 39113 | 128090 | 2019 |
2498443 | 2498443 | 2022-05-12 | Morgan | Ohio | 39115 | 3278 | 60 |
2498444 | 2498444 | 2022-05-12 | Morrow | Ohio | 39117 | 7845 | 103 |
2498445 | 2498445 | 2022-05-12 | Muskingum | Ohio | 39119 | 25481 | 294 |
2498446 | 2498446 | 2022-05-12 | Noble | Ohio | 39121 | 3220 | 58 |
2498447 | 2498447 | 2022-05-12 | Ottawa | Ohio | 39123 | 8618 | 138 |
2498448 | 2498448 | 2022-05-12 | Paulding | Ohio | 39125 | 4639 | 74 |
2498449 | 2498449 | 2022-05-12 | Perry | Ohio | 39127 | 8356 | 125 |
2498450 | 2498450 | 2022-05-12 | Pickaway | Ohio | 39129 | 17679 | 230 |
2498451 | 2498451 | 2022-05-12 | Pike | Ohio | 39131 | 7493 | 123 |
2498452 | 2498452 | 2022-05-12 | Portage | Ohio | 39133 | 35026 | 450 |
2498453 | 2498453 | 2022-05-12 | Preble | Ohio | 39135 | 9494 | 201 |
2498454 | 2498454 | 2022-05-12 | Putnam | Ohio | 39137 | 8492 | 157 |
2498455 | 2498455 | 2022-05-12 | Richland | Ohio | 39139 | 31806 | 508 |
2498456 | 2498456 | 2022-05-12 | Ross | Ohio | 39141 | 19410 | 301 |
2498457 | 2498457 | 2022-05-12 | Sandusky | Ohio | 39143 | 14015 | 238 |
2498458 | 2498458 | 2022-05-12 | Scioto | Ohio | 39145 | 20777 | 257 |
2498459 | 2498459 | 2022-05-12 | Seneca | Ohio | 39147 | 12869 | 230 |
2498460 | 2498460 | 2022-05-12 | Shelby | Ohio | 39149 | 11102 | 188 |
2498461 | 2498461 | 2022-05-12 | Stark | Ohio | 39151 | 80794 | 1718 |
2498462 | 2498462 | 2022-05-12 | Summit | Ohio | 39153 | 115094 | 1710 |
2498463 | 2498463 | 2022-05-12 | Trumbull | Ohio | 39155 | 42078 | 941 |
2498464 | 2498464 | 2022-05-12 | Tuscarawas | Ohio | 39157 | 20753 | 505 |
2498465 | 2498465 | 2022-05-12 | Union | Ohio | 39159 | 15952 | 102 |
2498466 | 2498466 | 2022-05-12 | Unknown | Ohio | 0 | 5 | |
2498467 | 2498467 | 2022-05-12 | Van Wert | Ohio | 39161 | 6755 | 148 |
2498468 | 2498468 | 2022-05-12 | Vinton | Ohio | 39163 | 2918 | 55 |
2498469 | 2498469 | 2022-05-12 | Warren | Ohio | 39165 | 58538 | 584 |
2498470 | 2498470 | 2022-05-12 | Washington | Ohio | 39167 | 12409 | 207 |
2498471 | 2498471 | 2022-05-12 | Wayne | Ohio | 39169 | 23392 | 439 |
2498472 | 2498472 | 2022-05-12 | Williams | Ohio | 39171 | 9090 | 164 |
2498473 | 2498473 | 2022-05-12 | Wood | Ohio | 39173 | 32072 | 355 |
2498474 | 2498474 | 2022-05-12 | Wyandot | Ohio | 39175 | 5441 | 105 |
2495128 | 2495128 | 2022-05-11 | Adams | Ohio | 39001 | 6999 | 148 |
2495129 | 2495129 | 2022-05-11 | Allen | Ohio | 39003 | 27562 | 478 |
2495130 | 2495130 | 2022-05-11 | Ashland | Ohio | 39005 | 12061 | 218 |
2495131 | 2495131 | 2022-05-11 | Ashtabula | Ohio | 39007 | 20214 | 430 |
2495132 | 2495132 | 2022-05-11 | Athens | Ohio | 39009 | 14769 | 142 |
2495133 | 2495133 | 2022-05-11 | Auglaize | Ohio | 39011 | 11618 | 189 |
2495134 | 2495134 | 2022-05-11 | Belmont | Ohio | 39013 | 15762 | 309 |
2495135 | 2495135 | 2022-05-11 | Brown | Ohio | 39015 | 11216 | 180 |
2495136 | 2495136 | 2022-05-11 | Butler | Ohio | 39017 | 93585 | 1153 |
2495137 | 2495137 | 2022-05-11 | Carroll | Ohio | 39019 | 5276 | 126 |
2495138 | 2495138 | 2022-05-11 | Champaign | Ohio | 39021 | 8789 | 147 |
2495139 | 2495139 | 2022-05-11 | Clark | Ohio | 39023 | 35090 | 585 |
2495140 | 2495140 | 2022-05-11 | Clermont | Ohio | 39025 | 51741 | 560 |
2495141 | 2495141 | 2022-05-11 | Clinton | Ohio | 39027 | 10374 | 167 |
2495142 | 2495142 | 2022-05-11 | Columbiana | Ohio | 39029 | 24561 | 486 |
2495143 | 2495143 | 2022-05-11 | Coshocton | Ohio | 39031 | 7992 | 159 |
2495144 | 2495144 | 2022-05-11 | Crawford | Ohio | 39033 | 11224 | 214 |
2495145 | 2495145 | 2022-05-11 | Cuyahoga | Ohio | 39035 | 273845 | 3783 |
2495146 | 2495146 | 2022-05-11 | Darke | Ohio | 39037 | 12422 | 238 |
2495147 | 2495147 | 2022-05-11 | Defiance | Ohio | 39039 | 10253 | 164 |
2495148 | 2495148 | 2022-05-11 | Delaware | Ohio | 39041 | 45100 | 272 |
2495149 | 2495149 | 2022-05-11 | Erie | Ohio | 39043 | 19621 | 267 |
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);