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 89
- 39035 318
- 39151 316
- 39155 315
- 39013 313
- 39017 313
- 39049 313
- 39093 313
- 39153 313
- 39157 313
- 39095 312
- 39103 312
- 39055 311
- 39031 310
- 39037 310
- 39085 310
- 39099 310
- 39005 309
- 39023 309
- 39041 309
- 39077 309
- 39109 309
- 39061 308
- 39113 308
- 39139 308
- 39007 307
- 39029 307
- 39101 307
- 39159 307
- 39165 307
- 39025 306
- 39039 306
- 39043 306
- 39089 306
- 39019 305
- 39027 305
- 39053 305
- 39057 305
- 39063 305
- 39133 305
- 39173 305
- 39083 304
- 39091 304
- 39097 304
- 39143 304
- 39167 304
- 39021 303
- 39033 303
- 39045 303
- 39071 303
- 39047 302
- 39087 302
- 39107 302
- 39129 302
- 39147 302
- 39169 302
- 39009 301
- 39081 301
- 39119 301
- 39175 301
- 39051 300
- 39149 300
- 39003 299
- 39011 299
- 39123 299
- 39131 299
- 39161 299
- 39015 297
- 39075 297
- 39135 297
- 39141 297
- 39127 296
- 39117 295
- 39059 294
- 39065 294
- 39171 294
- 39001 292
- 39111 291
- 39115 290
- 39125 290
- 39137 290
- 39145 290
- 39105 289
- 39069 288
- 39079 288
- 39121 287
- 39073 285
- 39067 281
- 39163 268
- - 4
county 89
- Cuyahoga 318
- Stark 316
- Trumbull 315
- Belmont 313
- Butler 313
- Franklin 313
- Lorain 313
- Summit 313
- Tuscarawas 313
- Lucas 312
- Medina 312
- Geauga 311
- Coshocton 310
- Darke 310
- Lake 310
- Mahoning 310
- Ashland 309
- Clark 309
- Delaware 309
- Huron 309
- Miami 309
- Hamilton 308
- Montgomery 308
- Richland 308
- Ashtabula 307
- Columbiana 307
- Marion 307
- Union 307
- Warren 307
- Clermont 306
- Defiance 306
- Erie 306
- Licking 306
- Carroll 305
- Clinton 305
- Gallia 305
- Greene 305
- Hancock 305
- Portage 305
- Wood 305
- Knox 304
- Logan 304
- Madison 304
- Sandusky 304
- Washington 304
- Champaign 303
- Crawford 303
- Fairfield 303
- Highland 303
- Fayette 302
- Lawrence 302
- Mercer 302
- Pickaway 302
- Seneca 302
- Wayne 302
- Athens 301
- Jefferson 301
- Muskingum 301
- Wyandot 301
- Fulton 300
- Shelby 300
- Allen 299
- Auglaize 299
- Ottawa 299
- Pike 299
- Van Wert 299
- Brown 297
- Holmes 297
- Preble 297
- Ross 297
- Perry 296
- Morrow 295
- Guernsey 294
- Hardin 294
- Williams 294
- Adams 292
- Monroe 291
- Morgan 290
- Paulding 290
- Putnam 290
- Scioto 290
- Meigs 289
- Henry 288
- Jackson 288
- Noble 287
- Hocking 285
- Harrison 281
- Vinton 268
- Unknown 4
state 1
- Ohio · 26,602 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948461 | 948461 | 2021-01-20 | Adams | Ohio | 39001 | 1695 | 15 |
948462 | 948462 | 2021-01-20 | Allen | Ohio | 39003 | 9695 | 126 |
948463 | 948463 | 2021-01-20 | Ashland | Ohio | 39005 | 3397 | 38 |
948464 | 948464 | 2021-01-20 | Ashtabula | Ohio | 39007 | 4463 | 73 |
948465 | 948465 | 2021-01-20 | Athens | Ohio | 39009 | 3707 | 9 |
948466 | 948466 | 2021-01-20 | Auglaize | Ohio | 39011 | 4183 | 59 |
948467 | 948467 | 2021-01-20 | Belmont | Ohio | 39013 | 4084 | 40 |
948468 | 948468 | 2021-01-20 | Brown | Ohio | 39015 | 3026 | 21 |
948469 | 948469 | 2021-01-20 | Butler | Ohio | 39017 | 30216 | 228 |
948470 | 948470 | 2021-01-20 | Carroll | Ohio | 39019 | 1521 | 16 |
948471 | 948471 | 2021-01-20 | Champaign | Ohio | 39021 | 2469 | 27 |
948472 | 948472 | 2021-01-20 | Clark | Ohio | 39023 | 10723 | 264 |
948473 | 948473 | 2021-01-20 | Clermont | Ohio | 39025 | 15546 | 108 |
948474 | 948474 | 2021-01-20 | Clinton | Ohio | 39027 | 2849 | 43 |
948475 | 948475 | 2021-01-20 | Columbiana | Ohio | 39029 | 7202 | 124 |
948476 | 948476 | 2021-01-20 | Coshocton | Ohio | 39031 | 2011 | 20 |
948477 | 948477 | 2021-01-20 | Crawford | Ohio | 39033 | 3180 | 72 |
948478 | 948478 | 2021-01-20 | Cuyahoga | Ohio | 39035 | 83770 | 1068 |
948479 | 948479 | 2021-01-20 | Darke | Ohio | 39037 | 4626 | 89 |
948480 | 948480 | 2021-01-20 | Defiance | Ohio | 39039 | 3239 | 78 |
948481 | 948481 | 2021-01-20 | Delaware | Ohio | 39041 | 14136 | 77 |
948482 | 948482 | 2021-01-20 | Erie | Ohio | 39043 | 6022 | 120 |
948483 | 948483 | 2021-01-20 | Fairfield | Ohio | 39045 | 12449 | 80 |
948484 | 948484 | 2021-01-20 | Fayette | Ohio | 39047 | 2322 | 29 |
948485 | 948485 | 2021-01-20 | Franklin | Ohio | 39049 | 99253 | 706 |
948486 | 948486 | 2021-01-20 | Fulton | Ohio | 39051 | 3312 | 43 |
948487 | 948487 | 2021-01-20 | Gallia | Ohio | 39053 | 1934 | 26 |
948488 | 948488 | 2021-01-20 | Geauga | Ohio | 39055 | 4971 | 55 |
948489 | 948489 | 2021-01-20 | Greene | Ohio | 39057 | 11814 | 135 |
948490 | 948490 | 2021-01-20 | Guernsey | Ohio | 39059 | 2478 | 25 |
948491 | 948491 | 2021-01-20 | Hamilton | Ohio | 39061 | 62391 | 443 |
948492 | 948492 | 2021-01-20 | Hancock | Ohio | 39063 | 5458 | 90 |
948493 | 948493 | 2021-01-20 | Hardin | Ohio | 39065 | 2087 | 33 |
948494 | 948494 | 2021-01-20 | Harrison | Ohio | 39067 | 872 | 21 |
948495 | 948495 | 2021-01-20 | Henry | Ohio | 39069 | 2150 | 49 |
948496 | 948496 | 2021-01-20 | Highland | Ohio | 39071 | 2693 | 18 |
948497 | 948497 | 2021-01-20 | Hocking | Ohio | 39073 | 1678 | 23 |
948498 | 948498 | 2021-01-20 | Holmes | Ohio | 39075 | 2213 | 62 |
948499 | 948499 | 2021-01-20 | Huron | Ohio | 39077 | 4193 | 38 |
948500 | 948500 | 2021-01-20 | Jackson | Ohio | 39079 | 2605 | 44 |
948501 | 948501 | 2021-01-20 | Jefferson | Ohio | 39081 | 4120 | 67 |
948502 | 948502 | 2021-01-20 | Knox | Ohio | 39083 | 3444 | 22 |
948503 | 948503 | 2021-01-20 | Lake | Ohio | 39085 | 15747 | 136 |
948504 | 948504 | 2021-01-20 | Lawrence | Ohio | 39087 | 4428 | 53 |
948505 | 948505 | 2021-01-20 | Licking | Ohio | 39089 | 12943 | 133 |
948506 | 948506 | 2021-01-20 | Logan | Ohio | 39091 | 3007 | 31 |
948507 | 948507 | 2021-01-20 | Lorain | Ohio | 39093 | 18599 | 212 |
948508 | 948508 | 2021-01-20 | Lucas | Ohio | 39095 | 30760 | 609 |
948509 | 948509 | 2021-01-20 | Madison | Ohio | 39097 | 3467 | 29 |
948510 | 948510 | 2021-01-20 | Mahoning | Ohio | 39099 | 17035 | 337 |
948511 | 948511 | 2021-01-20 | Marion | Ohio | 39101 | 7398 | 113 |
948512 | 948512 | 2021-01-20 | Medina | Ohio | 39103 | 11364 | 167 |
948513 | 948513 | 2021-01-20 | Meigs | Ohio | 39105 | 1058 | 21 |
948514 | 948514 | 2021-01-20 | Mercer | Ohio | 39107 | 4303 | 87 |
948515 | 948515 | 2021-01-20 | Miami | Ohio | 39109 | 8999 | 73 |
948516 | 948516 | 2021-01-20 | Monroe | Ohio | 39111 | 991 | 31 |
948517 | 948517 | 2021-01-20 | Montgomery | Ohio | 39113 | 42334 | 403 |
948518 | 948518 | 2021-01-20 | Morgan | Ohio | 39115 | 804 | 29 |
948519 | 948519 | 2021-01-20 | Morrow | Ohio | 39117 | 2286 | 4 |
948520 | 948520 | 2021-01-20 | Muskingum | Ohio | 39119 | 6799 | 41 |
948521 | 948521 | 2021-01-20 | Noble | Ohio | 39121 | 1194 | 40 |
948522 | 948522 | 2021-01-20 | Ottawa | Ohio | 39123 | 2870 | 34 |
948523 | 948523 | 2021-01-20 | Paulding | Ohio | 39125 | 1417 | 21 |
948524 | 948524 | 2021-01-20 | Perry | Ohio | 39127 | 2244 | 18 |
948525 | 948525 | 2021-01-20 | Pickaway | Ohio | 39129 | 7151 | 50 |
948526 | 948526 | 2021-01-20 | Pike | Ohio | 39131 | 1695 | 17 |
948527 | 948527 | 2021-01-20 | Portage | Ohio | 39133 | 9095 | 107 |
948528 | 948528 | 2021-01-20 | Preble | Ohio | 39135 | 3153 | 37 |
948529 | 948529 | 2021-01-20 | Putnam | Ohio | 39137 | 3699 | 74 |
948530 | 948530 | 2021-01-20 | Richland | Ohio | 39139 | 8973 | 117 |
948531 | 948531 | 2021-01-20 | Ross | Ohio | 39141 | 5387 | 87 |
948532 | 948532 | 2021-01-20 | Sandusky | Ohio | 39143 | 4302 | 62 |
948533 | 948533 | 2021-01-20 | Scioto | Ohio | 39145 | 5297 | 64 |
948534 | 948534 | 2021-01-20 | Seneca | Ohio | 39147 | 4202 | 61 |
948535 | 948535 | 2021-01-20 | Shelby | Ohio | 39149 | 4166 | 21 |
948536 | 948536 | 2021-01-20 | Stark | Ohio | 39151 | 25262 | 428 |
948537 | 948537 | 2021-01-20 | Summit | Ohio | 39153 | 34150 | 743 |
948538 | 948538 | 2021-01-20 | Trumbull | Ohio | 39155 | 12604 | 311 |
948539 | 948539 | 2021-01-20 | Tuscarawas | Ohio | 39157 | 7211 | 178 |
948540 | 948540 | 2021-01-20 | Union | Ohio | 39159 | 4409 | 28 |
948541 | 948541 | 2021-01-20 | Van Wert | Ohio | 39161 | 2000 | 44 |
948542 | 948542 | 2021-01-20 | Vinton | Ohio | 39163 | 681 | 13 |
948543 | 948543 | 2021-01-20 | Warren | Ohio | 39165 | 19222 | 140 |
948544 | 948544 | 2021-01-20 | Washington | Ohio | 39167 | 3794 | 40 |
948545 | 948545 | 2021-01-20 | Wayne | Ohio | 39169 | 6897 | 167 |
948546 | 948546 | 2021-01-20 | Williams | Ohio | 39171 | 2746 | 66 |
948547 | 948547 | 2021-01-20 | Wood | Ohio | 39173 | 10158 | 157 |
948548 | 948548 | 2021-01-20 | Wyandot | Ohio | 39175 | 1935 | 51 |
945215 | 945215 | 2021-01-19 | Adams | Ohio | 39001 | 1674 | 15 |
945216 | 945216 | 2021-01-19 | Allen | Ohio | 39003 | 9639 | 126 |
945217 | 945217 | 2021-01-19 | Ashland | Ohio | 39005 | 3368 | 38 |
945218 | 945218 | 2021-01-19 | Ashtabula | Ohio | 39007 | 4431 | 72 |
945219 | 945219 | 2021-01-19 | Athens | Ohio | 39009 | 3675 | 9 |
945220 | 945220 | 2021-01-19 | Auglaize | Ohio | 39011 | 4162 | 59 |
945221 | 945221 | 2021-01-19 | Belmont | Ohio | 39013 | 4037 | 40 |
945222 | 945222 | 2021-01-19 | Brown | Ohio | 39015 | 2988 | 19 |
945223 | 945223 | 2021-01-19 | Butler | Ohio | 39017 | 30003 | 228 |
945224 | 945224 | 2021-01-19 | Carroll | Ohio | 39019 | 1513 | 16 |
945225 | 945225 | 2021-01-19 | Champaign | Ohio | 39021 | 2444 | 27 |
945226 | 945226 | 2021-01-19 | Clark | Ohio | 39023 | 10672 | 264 |
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);