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 696
- 39151 695
- 39155 694
- 39093 692
- 39153 692
- 39157 692
- 39013 691
- 39017 691
- 39049 691
- 39095 691
- 39103 691
- 39055 690
- 39085 689
- 39099 689
- 39031 688
- 39037 688
- 39077 688
- 39109 688
- 39005 687
- 39023 687
- 39041 687
- 39061 687
- 39113 687
- 39139 687
- 39101 686
- 39159 686
- 39165 686
- 39007 685
- 39029 685
- 39089 685
- …
county >30
- Cuyahoga 696
- Stark 695
- Trumbull 694
- Lorain 692
- Summit 692
- Tuscarawas 692
- Belmont 691
- Butler 691
- Franklin 691
- Lucas 691
- Medina 691
- Geauga 690
- Lake 689
- Mahoning 689
- Coshocton 688
- Darke 688
- Huron 688
- Miami 688
- Ashland 687
- Clark 687
- Delaware 687
- Hamilton 687
- Montgomery 687
- Richland 687
- Marion 686
- Union 686
- Warren 686
- Ashtabula 685
- Columbiana 685
- Licking 685
- …
state 1
- Ohio · 60,265 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179536 | 2179536 | 2022-02-03 | Fulton | Ohio | 39051 | 10098 | 161 |
2179537 | 2179537 | 2022-02-03 | Gallia | Ohio | 39053 | 6917 | 95 |
2179538 | 2179538 | 2022-02-03 | Geauga | Ohio | 39055 | 15713 | 238 |
2179539 | 2179539 | 2022-02-03 | Greene | Ohio | 39057 | 36047 | 448 |
2179540 | 2179540 | 2022-02-03 | Guernsey | Ohio | 39059 | 10127 | 130 |
2179541 | 2179541 | 2022-02-03 | Hamilton | Ohio | 39061 | 182296 | 1816 |
2179542 | 2179542 | 2022-02-03 | Hancock | Ohio | 39063 | 16690 | 242 |
2179543 | 2179543 | 2022-02-03 | Hardin | Ohio | 39065 | 6879 | 137 |
2179544 | 2179544 | 2022-02-03 | Harrison | Ohio | 39067 | 3143 | 66 |
2179545 | 2179545 | 2022-02-03 | Henry | Ohio | 39069 | 6275 | 98 |
2179546 | 2179546 | 2022-02-03 | Highland | Ohio | 39071 | 10329 | 156 |
2179547 | 2179547 | 2022-02-03 | Hocking | Ohio | 39073 | 6279 | 107 |
2179548 | 2179548 | 2022-02-03 | Holmes | Ohio | 39075 | 5001 | 167 |
2179549 | 2179549 | 2022-02-03 | Huron | Ohio | 39077 | 14213 | 201 |
2179550 | 2179550 | 2022-02-03 | Jackson | Ohio | 39079 | 8366 | 125 |
2179551 | 2179551 | 2022-02-03 | Jefferson | Ohio | 39081 | 14244 | 274 |
2179552 | 2179552 | 2022-02-03 | Knox | Ohio | 39083 | 12692 | 212 |
2179553 | 2179553 | 2022-02-03 | Lake | Ohio | 39085 | 48091 | 661 |
2179554 | 2179554 | 2022-02-03 | Lawrence | Ohio | 39087 | 16561 | 198 |
2179555 | 2179555 | 2022-02-03 | Licking | Ohio | 39089 | 40231 | 431 |
2179556 | 2179556 | 2022-02-03 | Logan | Ohio | 39091 | 9880 | 148 |
2179557 | 2179557 | 2022-02-03 | Lorain | Ohio | 39093 | 65114 | 867 |
2179558 | 2179558 | 2022-02-03 | Lucas | Ohio | 39095 | 96516 | 1218 |
2179559 | 2179559 | 2022-02-03 | Madison | Ohio | 39097 | 9402 | 116 |
2179560 | 2179560 | 2022-02-03 | Mahoning | Ohio | 39099 | 52282 | 974 |
2179561 | 2179561 | 2022-02-03 | Marion | Ohio | 39101 | 19332 | 242 |
2179562 | 2179562 | 2022-02-03 | Medina | Ohio | 39103 | 39339 | 443 |
2179563 | 2179563 | 2022-02-03 | Meigs | Ohio | 39105 | 4264 | 74 |
2179564 | 2179564 | 2022-02-03 | Mercer | Ohio | 39107 | 9463 | 115 |
2179565 | 2179565 | 2022-02-03 | Miami | Ohio | 39109 | 25178 | 429 |
2179566 | 2179566 | 2022-02-03 | Monroe | Ohio | 39111 | 3344 | 69 |
2179567 | 2179567 | 2022-02-03 | Montgomery | Ohio | 39113 | 123292 | 1726 |
2179568 | 2179568 | 2022-02-03 | Morgan | Ohio | 39115 | 3096 | 49 |
2179569 | 2179569 | 2022-02-03 | Morrow | Ohio | 39117 | 7542 | 87 |
2179570 | 2179570 | 2022-02-03 | Muskingum | Ohio | 39119 | 24528 | 260 |
2179571 | 2179571 | 2022-02-03 | Noble | Ohio | 39121 | 3117 | 53 |
2179572 | 2179572 | 2022-02-03 | Ottawa | Ohio | 39123 | 8196 | 126 |
2179573 | 2179573 | 2022-02-03 | Paulding | Ohio | 39125 | 4492 | 69 |
2179574 | 2179574 | 2022-02-03 | Perry | Ohio | 39127 | 7901 | 108 |
2179575 | 2179575 | 2022-02-03 | Pickaway | Ohio | 39129 | 17027 | 194 |
2179576 | 2179576 | 2022-02-03 | Pike | Ohio | 39131 | 7089 | 93 |
2179577 | 2179577 | 2022-02-03 | Portage | Ohio | 39133 | 33093 | 396 |
2179578 | 2179578 | 2022-02-03 | Preble | Ohio | 39135 | 9041 | 178 |
2179579 | 2179579 | 2022-02-03 | Putnam | Ohio | 39137 | 8309 | 139 |
2179580 | 2179580 | 2022-02-03 | Richland | Ohio | 39139 | 30639 | 461 |
2179581 | 2179581 | 2022-02-03 | Ross | Ohio | 39141 | 18520 | 263 |
2179582 | 2179582 | 2022-02-03 | Sandusky | Ohio | 39143 | 13667 | 210 |
2179583 | 2179583 | 2022-02-03 | Scioto | Ohio | 39145 | 19535 | 219 |
2179584 | 2179584 | 2022-02-03 | Seneca | Ohio | 39147 | 12440 | 213 |
2179585 | 2179585 | 2022-02-03 | Shelby | Ohio | 39149 | 10830 | 167 |
2179586 | 2179586 | 2022-02-03 | Stark | Ohio | 39151 | 78539 | 1526 |
2179587 | 2179587 | 2022-02-03 | Summit | Ohio | 39153 | 110399 | 1505 |
2179588 | 2179588 | 2022-02-03 | Trumbull | Ohio | 39155 | 40578 | 823 |
2179589 | 2179589 | 2022-02-03 | Tuscarawas | Ohio | 39157 | 20158 | 446 |
2179590 | 2179590 | 2022-02-03 | Union | Ohio | 39159 | 15013 | 85 |
2179591 | 2179591 | 2022-02-03 | Unknown | Ohio | 0 | 5 | |
2179592 | 2179592 | 2022-02-03 | Van Wert | Ohio | 39161 | 6363 | 127 |
2179593 | 2179593 | 2022-02-03 | Vinton | Ohio | 39163 | 2761 | 47 |
2179594 | 2179594 | 2022-02-03 | Warren | Ohio | 39165 | 55916 | 508 |
2179595 | 2179595 | 2022-02-03 | Washington | Ohio | 39167 | 11879 | 173 |
2179596 | 2179596 | 2022-02-03 | Wayne | Ohio | 39169 | 22687 | 389 |
2179597 | 2179597 | 2022-02-03 | Williams | Ohio | 39171 | 8730 | 149 |
2179598 | 2179598 | 2022-02-03 | Wood | Ohio | 39173 | 30494 | 309 |
2179599 | 2179599 | 2022-02-03 | Wyandot | Ohio | 39175 | 5242 | 95 |
2176260 | 2176260 | 2022-02-02 | Adams | Ohio | 39001 | 6626 | 132 |
2176261 | 2176261 | 2022-02-02 | Allen | Ohio | 39003 | 26837 | 416 |
2176262 | 2176262 | 2022-02-02 | Ashland | Ohio | 39005 | 11619 | 195 |
2176263 | 2176263 | 2022-02-02 | Ashtabula | Ohio | 39007 | 19024 | 373 |
2176264 | 2176264 | 2022-02-02 | Athens | Ohio | 39009 | 13552 | 112 |
2176265 | 2176265 | 2022-02-02 | Auglaize | Ohio | 39011 | 11302 | 158 |
2176266 | 2176266 | 2022-02-02 | Belmont | Ohio | 39013 | 15046 | 257 |
2176267 | 2176267 | 2022-02-02 | Brown | Ohio | 39015 | 10767 | 149 |
2176268 | 2176268 | 2022-02-02 | Butler | Ohio | 39017 | 87394 | 1005 |
2176269 | 2176269 | 2022-02-02 | Carroll | Ohio | 39019 | 5153 | 108 |
2176270 | 2176270 | 2022-02-02 | Champaign | Ohio | 39021 | 8445 | 122 |
2176271 | 2176271 | 2022-02-02 | Clark | Ohio | 39023 | 33871 | 479 |
2176272 | 2176272 | 2022-02-02 | Clermont | Ohio | 39025 | 49436 | 469 |
2176273 | 2176273 | 2022-02-02 | Clinton | Ohio | 39027 | 9974 | 139 |
2176274 | 2176274 | 2022-02-02 | Columbiana | Ohio | 39029 | 23628 | 431 |
2176275 | 2176275 | 2022-02-02 | Coshocton | Ohio | 39031 | 7719 | 139 |
2176276 | 2176276 | 2022-02-02 | Crawford | Ohio | 39033 | 10832 | 185 |
2176277 | 2176277 | 2022-02-02 | Cuyahoga | Ohio | 39035 | 263424 | 3296 |
2176278 | 2176278 | 2022-02-02 | Darke | Ohio | 39037 | 12031 | 206 |
2176279 | 2176279 | 2022-02-02 | Defiance | Ohio | 39039 | 9937 | 146 |
2176280 | 2176280 | 2022-02-02 | Delaware | Ohio | 39041 | 42927 | 234 |
2176281 | 2176281 | 2022-02-02 | Erie | Ohio | 39043 | 18994 | 241 |
2176282 | 2176282 | 2022-02-02 | Fairfield | Ohio | 39045 | 37269 | 371 |
2176283 | 2176283 | 2022-02-02 | Fayette | Ohio | 39047 | 7562 | 99 |
2176284 | 2176284 | 2022-02-02 | Franklin | Ohio | 39049 | 280218 | 2219 |
2176285 | 2176285 | 2022-02-02 | Fulton | Ohio | 39051 | 10087 | 161 |
2176286 | 2176286 | 2022-02-02 | Gallia | Ohio | 39053 | 6865 | 95 |
2176287 | 2176287 | 2022-02-02 | Geauga | Ohio | 39055 | 15699 | 238 |
2176288 | 2176288 | 2022-02-02 | Greene | Ohio | 39057 | 35893 | 448 |
2176289 | 2176289 | 2022-02-02 | Guernsey | Ohio | 39059 | 10092 | 130 |
2176290 | 2176290 | 2022-02-02 | Hamilton | Ohio | 39061 | 181869 | 1816 |
2176291 | 2176291 | 2022-02-02 | Hancock | Ohio | 39063 | 16655 | 242 |
2176292 | 2176292 | 2022-02-02 | Hardin | Ohio | 39065 | 6865 | 137 |
2176293 | 2176293 | 2022-02-02 | Harrison | Ohio | 39067 | 3131 | 66 |
2176294 | 2176294 | 2022-02-02 | Henry | Ohio | 39069 | 6265 | 98 |
2176295 | 2176295 | 2022-02-02 | Highland | Ohio | 39071 | 10280 | 156 |
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);