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 351
- 39151 349
- 39155 348
- 39013 346
- 39017 346
- 39049 346
- 39093 346
- 39153 346
- 39157 346
- 39095 345
- 39103 345
- 39055 344
- 39031 343
- 39037 343
- 39085 343
- 39099 343
- 39005 342
- 39023 342
- 39041 342
- 39077 342
- 39109 342
- 39061 341
- 39113 341
- 39139 341
- 39007 340
- 39029 340
- 39101 340
- 39159 340
- 39165 340
- 39025 339
- 39039 339
- 39043 339
- 39089 339
- 39019 338
- 39027 338
- 39053 338
- 39057 338
- 39063 338
- 39133 338
- 39173 338
- 39083 337
- 39091 337
- 39097 337
- 39143 337
- 39167 337
- 39021 336
- 39033 336
- 39045 336
- 39071 336
- 39047 335
- 39087 335
- 39107 335
- 39129 335
- 39147 335
- 39169 335
- 39009 334
- 39081 334
- 39119 334
- 39175 334
- 39051 333
- 39149 333
- 39003 332
- 39011 332
- 39123 332
- 39131 332
- 39161 332
- 39015 330
- 39075 330
- 39135 330
- 39141 330
- 39127 329
- 39117 328
- 39059 327
- 39065 327
- 39171 327
- 39001 325
- 39111 324
- 39115 323
- 39125 323
- 39137 323
- 39145 323
- 39105 322
- 39069 321
- 39079 321
- 39121 320
- 39073 318
- 39067 314
- 39163 301
- - 4
county 89
- Cuyahoga 351
- Stark 349
- Trumbull 348
- Belmont 346
- Butler 346
- Franklin 346
- Lorain 346
- Summit 346
- Tuscarawas 346
- Lucas 345
- Medina 345
- Geauga 344
- Coshocton 343
- Darke 343
- Lake 343
- Mahoning 343
- Ashland 342
- Clark 342
- Delaware 342
- Huron 342
- Miami 342
- Hamilton 341
- Montgomery 341
- Richland 341
- Ashtabula 340
- Columbiana 340
- Marion 340
- Union 340
- Warren 340
- Clermont 339
- Defiance 339
- Erie 339
- Licking 339
- Carroll 338
- Clinton 338
- Gallia 338
- Greene 338
- Hancock 338
- Portage 338
- Wood 338
- Knox 337
- Logan 337
- Madison 337
- Sandusky 337
- Washington 337
- Champaign 336
- Crawford 336
- Fairfield 336
- Highland 336
- Fayette 335
- Lawrence 335
- Mercer 335
- Pickaway 335
- Seneca 335
- Wayne 335
- Athens 334
- Jefferson 334
- Muskingum 334
- Wyandot 334
- Fulton 333
- Shelby 333
- Allen 332
- Auglaize 332
- Ottawa 332
- Pike 332
- Van Wert 332
- Brown 330
- Holmes 330
- Preble 330
- Ross 330
- Perry 329
- Morrow 328
- Guernsey 327
- Hardin 327
- Williams 327
- Adams 325
- Monroe 324
- Morgan 323
- Paulding 323
- Putnam 323
- Scioto 323
- Meigs 322
- Henry 321
- Jackson 321
- Noble 320
- Hocking 318
- Harrison 314
- Vinton 301
- Unknown 4
state 1
- Ohio · 29,506 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055566 | 1055566 | 2021-02-22 | Adams | Ohio | 39001 | 2136 | 32 |
1055567 | 1055567 | 2021-02-22 | Allen | Ohio | 39003 | 10700 | 231 |
1055568 | 1055568 | 2021-02-22 | Ashland | Ohio | 39005 | 3743 | 93 |
1055569 | 1055569 | 2021-02-22 | Ashtabula | Ohio | 39007 | 5746 | 140 |
1055570 | 1055570 | 2021-02-22 | Athens | Ohio | 39009 | 4550 | 30 |
1055571 | 1055571 | 2021-02-22 | Auglaize | Ohio | 39011 | 4531 | 95 |
1055572 | 1055572 | 2021-02-22 | Belmont | Ohio | 39013 | 4837 | 86 |
1055573 | 1055573 | 2021-02-22 | Brown | Ohio | 39015 | 3660 | 42 |
1055574 | 1055574 | 2021-02-22 | Butler | Ohio | 39017 | 34918 | 459 |
1055575 | 1055575 | 2021-02-22 | Carroll | Ohio | 39019 | 1788 | 27 |
1055576 | 1055576 | 2021-02-22 | Champaign | Ohio | 39021 | 2819 | 45 |
1055577 | 1055577 | 2021-02-22 | Clark | Ohio | 39023 | 12101 | 331 |
1055578 | 1055578 | 2021-02-22 | Clermont | Ohio | 39025 | 18113 | 204 |
1055579 | 1055579 | 2021-02-22 | Clinton | Ohio | 39027 | 3357 | 62 |
1055580 | 1055580 | 2021-02-22 | Columbiana | Ohio | 39029 | 8029 | 177 |
1055581 | 1055581 | 2021-02-22 | Coshocton | Ohio | 39031 | 2291 | 46 |
1055582 | 1055582 | 2021-02-22 | Crawford | Ohio | 39033 | 3539 | 95 |
1055583 | 1055583 | 2021-02-22 | Cuyahoga | Ohio | 39035 | 94021 | 1695 |
1055584 | 1055584 | 2021-02-22 | Darke | Ohio | 39037 | 4999 | 122 |
1055585 | 1055585 | 2021-02-22 | Defiance | Ohio | 39039 | 3667 | 102 |
1055586 | 1055586 | 2021-02-22 | Delaware | Ohio | 39041 | 16176 | 128 |
1055587 | 1055587 | 2021-02-22 | Erie | Ohio | 39043 | 6767 | 180 |
1055588 | 1055588 | 2021-02-22 | Fairfield | Ohio | 39045 | 14332 | 157 |
1055589 | 1055589 | 2021-02-22 | Fayette | Ohio | 39047 | 2647 | 42 |
1055590 | 1055590 | 2021-02-22 | Franklin | Ohio | 39049 | 110653 | 1186 |
1055591 | 1055591 | 2021-02-22 | Fulton | Ohio | 39051 | 3740 | 64 |
1055592 | 1055592 | 2021-02-22 | Gallia | Ohio | 39053 | 2191 | 46 |
1055593 | 1055593 | 2021-02-22 | Geauga | Ohio | 39055 | 5941 | 129 |
1055594 | 1055594 | 2021-02-22 | Greene | Ohio | 39057 | 13430 | 210 |
1055595 | 1055595 | 2021-02-22 | Guernsey | Ohio | 39059 | 2826 | 35 |
1055596 | 1055596 | 2021-02-22 | Hamilton | Ohio | 39061 | 72330 | 938 |
1055597 | 1055597 | 2021-02-22 | Hancock | Ohio | 39063 | 5925 | 110 |
1055598 | 1055598 | 2021-02-22 | Hardin | Ohio | 39065 | 2408 | 55 |
1055599 | 1055599 | 2021-02-22 | Harrison | Ohio | 39067 | 989 | 32 |
1055600 | 1055600 | 2021-02-22 | Henry | Ohio | 39069 | 2423 | 65 |
1055601 | 1055601 | 2021-02-22 | Highland | Ohio | 39071 | 3224 | 49 |
1055602 | 1055602 | 2021-02-22 | Hocking | Ohio | 39073 | 1917 | 48 |
1055603 | 1055603 | 2021-02-22 | Holmes | Ohio | 39075 | 2414 | 102 |
1055604 | 1055604 | 2021-02-22 | Huron | Ohio | 39077 | 4691 | 117 |
1055605 | 1055605 | 2021-02-22 | Jackson | Ohio | 39079 | 2867 | 53 |
1055606 | 1055606 | 2021-02-22 | Jefferson | Ohio | 39081 | 4689 | 105 |
1055607 | 1055607 | 2021-02-22 | Knox | Ohio | 39083 | 3969 | 83 |
1055608 | 1055608 | 2021-02-22 | Lake | Ohio | 39085 | 18087 | 300 |
1055609 | 1055609 | 2021-02-22 | Lawrence | Ohio | 39087 | 5177 | 74 |
1055610 | 1055610 | 2021-02-22 | Licking | Ohio | 39089 | 14764 | 187 |
1055611 | 1055611 | 2021-02-22 | Logan | Ohio | 39091 | 3488 | 56 |
1055612 | 1055612 | 2021-02-22 | Lorain | Ohio | 39093 | 21667 | 382 |
1055613 | 1055613 | 2021-02-22 | Lucas | Ohio | 39095 | 34620 | 753 |
1055614 | 1055614 | 2021-02-22 | Madison | Ohio | 39097 | 3882 | 47 |
1055615 | 1055615 | 2021-02-22 | Mahoning | Ohio | 39099 | 19183 | 532 |
1055616 | 1055616 | 2021-02-22 | Marion | Ohio | 39101 | 7928 | 134 |
1055617 | 1055617 | 2021-02-22 | Medina | Ohio | 39103 | 13130 | 217 |
1055618 | 1055618 | 2021-02-22 | Meigs | Ohio | 39105 | 1331 | 36 |
1055619 | 1055619 | 2021-02-22 | Mercer | Ohio | 39107 | 4558 | 101 |
1055620 | 1055620 | 2021-02-22 | Miami | Ohio | 39109 | 9917 | 178 |
1055621 | 1055621 | 2021-02-22 | Monroe | Ohio | 39111 | 1142 | 37 |
1055622 | 1055622 | 2021-02-22 | Montgomery | Ohio | 39113 | 46824 | 865 |
1055623 | 1055623 | 2021-02-22 | Morgan | Ohio | 39115 | 980 | 34 |
1055624 | 1055624 | 2021-02-22 | Morrow | Ohio | 39117 | 2562 | 24 |
1055625 | 1055625 | 2021-02-22 | Muskingum | Ohio | 39119 | 8032 | 122 |
1055626 | 1055626 | 2021-02-22 | Noble | Ohio | 39121 | 1277 | 42 |
1055627 | 1055627 | 2021-02-22 | Ottawa | Ohio | 39123 | 3180 | 67 |
1055628 | 1055628 | 2021-02-22 | Paulding | Ohio | 39125 | 1580 | 23 |
1055629 | 1055629 | 2021-02-22 | Perry | Ohio | 39127 | 2648 | 39 |
1055630 | 1055630 | 2021-02-22 | Pickaway | Ohio | 39129 | 7946 | 97 |
1055631 | 1055631 | 2021-02-22 | Pike | Ohio | 39131 | 2117 | 24 |
1055632 | 1055632 | 2021-02-22 | Portage | Ohio | 39133 | 10778 | 152 |
1055633 | 1055633 | 2021-02-22 | Preble | Ohio | 39135 | 3495 | 69 |
1055634 | 1055634 | 2021-02-22 | Putnam | Ohio | 39137 | 3963 | 98 |
1055635 | 1055635 | 2021-02-22 | Richland | Ohio | 39139 | 10131 | 197 |
1055636 | 1055636 | 2021-02-22 | Ross | Ohio | 39141 | 6057 | 135 |
1055637 | 1055637 | 2021-02-22 | Sandusky | Ohio | 39143 | 4714 | 92 |
1055638 | 1055638 | 2021-02-22 | Scioto | Ohio | 39145 | 5853 | 104 |
1055639 | 1055639 | 2021-02-22 | Seneca | Ohio | 39147 | 4610 | 103 |
1055640 | 1055640 | 2021-02-22 | Shelby | Ohio | 39149 | 4386 | 67 |
1055641 | 1055641 | 2021-02-22 | Stark | Ohio | 39151 | 28891 | 824 |
1055642 | 1055642 | 2021-02-22 | Summit | Ohio | 39153 | 39474 | 930 |
1055643 | 1055643 | 2021-02-22 | Trumbull | Ohio | 39155 | 14076 | 449 |
1055644 | 1055644 | 2021-02-22 | Tuscarawas | Ohio | 39157 | 7971 | 232 |
1055645 | 1055645 | 2021-02-22 | Union | Ohio | 39159 | 5035 | 52 |
1055646 | 1055646 | 2021-02-22 | Van Wert | Ohio | 39161 | 2269 | 49 |
1055647 | 1055647 | 2021-02-22 | Vinton | Ohio | 39163 | 762 | 15 |
1055648 | 1055648 | 2021-02-22 | Warren | Ohio | 39165 | 22083 | 267 |
1055649 | 1055649 | 2021-02-22 | Washington | Ohio | 39167 | 4509 | 86 |
1055650 | 1055650 | 2021-02-22 | Wayne | Ohio | 39169 | 7778 | 214 |
1055651 | 1055651 | 2021-02-22 | Williams | Ohio | 39171 | 2992 | 77 |
1055652 | 1055652 | 2021-02-22 | Wood | Ohio | 39173 | 11367 | 191 |
1055653 | 1055653 | 2021-02-22 | Wyandot | Ohio | 39175 | 2070 | 52 |
1052320 | 1052320 | 2021-02-21 | Adams | Ohio | 39001 | 2129 | 32 |
1052321 | 1052321 | 2021-02-21 | Allen | Ohio | 39003 | 10691 | 231 |
1052322 | 1052322 | 2021-02-21 | Ashland | Ohio | 39005 | 3733 | 92 |
1052323 | 1052323 | 2021-02-21 | Ashtabula | Ohio | 39007 | 5629 | 140 |
1052324 | 1052324 | 2021-02-21 | Athens | Ohio | 39009 | 4536 | 30 |
1052325 | 1052325 | 2021-02-21 | Auglaize | Ohio | 39011 | 4526 | 95 |
1052326 | 1052326 | 2021-02-21 | Belmont | Ohio | 39013 | 4818 | 85 |
1052327 | 1052327 | 2021-02-21 | Brown | Ohio | 39015 | 3660 | 41 |
1052328 | 1052328 | 2021-02-21 | Butler | Ohio | 39017 | 34874 | 458 |
1052329 | 1052329 | 2021-02-21 | Carroll | Ohio | 39019 | 1785 | 26 |
1052330 | 1052330 | 2021-02-21 | Champaign | Ohio | 39021 | 2812 | 45 |
1052331 | 1052331 | 2021-02-21 | Clark | Ohio | 39023 | 12082 | 330 |
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);