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 359
- 39151 357
- 39155 356
- 39049 354
- 39093 354
- 39153 354
- 39157 354
- 39013 353
- 39017 353
- 39095 353
- 39103 353
- 39055 352
- 39031 351
- 39037 351
- 39085 351
- 39099 351
- 39041 350
- 39077 350
- 39109 350
- 39005 349
- 39023 349
- 39061 349
- 39113 349
- 39139 349
- 39029 348
- 39101 348
- 39159 348
- 39165 348
- 39007 347
- 39025 347
- …
county >30
- Cuyahoga 359
- Stark 357
- Trumbull 356
- Franklin 354
- Lorain 354
- Summit 354
- Tuscarawas 354
- Belmont 353
- Butler 353
- Lucas 353
- Medina 353
- Geauga 352
- Coshocton 351
- Darke 351
- Lake 351
- Mahoning 351
- Delaware 350
- Huron 350
- Miami 350
- Ashland 349
- Clark 349
- Hamilton 349
- Montgomery 349
- Richland 349
- Columbiana 348
- Marion 348
- Union 348
- Warren 348
- Ashtabula 347
- Clermont 347
- …
state 1
- Ohio · 30,198 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081542 | 1081542 | 2021-03-02 | Clermont | Ohio | 39025 | 18389 | 201 |
1081543 | 1081543 | 2021-03-02 | Clinton | Ohio | 39027 | 3407 | 52 |
1081544 | 1081544 | 2021-03-02 | Columbiana | Ohio | 39029 | 8134 | 200 |
1081545 | 1081545 | 2021-03-02 | Coshocton | Ohio | 39031 | 2367 | 54 |
1081546 | 1081546 | 2021-03-02 | Crawford | Ohio | 39033 | 3579 | 96 |
1081547 | 1081547 | 2021-03-02 | Cuyahoga | Ohio | 39035 | 95912 | 1832 |
1081548 | 1081548 | 2021-03-02 | Darke | Ohio | 39037 | 5029 | 114 |
1081549 | 1081549 | 2021-03-02 | Defiance | Ohio | 39039 | 3718 | 83 |
1081550 | 1081550 | 2021-03-02 | Delaware | Ohio | 39041 | 16471 | 116 |
1081551 | 1081551 | 2021-03-02 | Erie | Ohio | 39043 | 6895 | 140 |
1081552 | 1081552 | 2021-03-02 | Fairfield | Ohio | 39045 | 14529 | 180 |
1081553 | 1081553 | 2021-03-02 | Fayette | Ohio | 39047 | 2682 | 41 |
1081554 | 1081554 | 2021-03-02 | Franklin | Ohio | 39049 | 112182 | 1214 |
1081555 | 1081555 | 2021-03-02 | Fulton | Ohio | 39051 | 3797 | 58 |
1081556 | 1081556 | 2021-03-02 | Gallia | Ohio | 39053 | 2225 | 31 |
1081557 | 1081557 | 2021-03-02 | Geauga | Ohio | 39055 | 6067 | 136 |
1081558 | 1081558 | 2021-03-02 | Greene | Ohio | 39057 | 13585 | 218 |
1081559 | 1081559 | 2021-03-02 | Guernsey | Ohio | 39059 | 2868 | 44 |
1081560 | 1081560 | 2021-03-02 | Hamilton | Ohio | 39061 | 73415 | 1034 |
1081561 | 1081561 | 2021-03-02 | Hancock | Ohio | 39063 | 5994 | 116 |
1081562 | 1081562 | 2021-03-02 | Hardin | Ohio | 39065 | 2447 | 58 |
1081563 | 1081563 | 2021-03-02 | Harrison | Ohio | 39067 | 1004 | 24 |
1081564 | 1081564 | 2021-03-02 | Henry | Ohio | 39069 | 2463 | 58 |
1081565 | 1081565 | 2021-03-02 | Highland | Ohio | 39071 | 3280 | 49 |
1081566 | 1081566 | 2021-03-02 | Hocking | Ohio | 39073 | 1942 | 54 |
1081567 | 1081567 | 2021-03-02 | Holmes | Ohio | 39075 | 2430 | 93 |
1081568 | 1081568 | 2021-03-02 | Huron | Ohio | 39077 | 4807 | 107 |
1081569 | 1081569 | 2021-03-02 | Jackson | Ohio | 39079 | 2900 | 45 |
1081570 | 1081570 | 2021-03-02 | Jefferson | Ohio | 39081 | 4795 | 107 |
1081571 | 1081571 | 2021-03-02 | Knox | Ohio | 39083 | 4025 | 101 |
1081572 | 1081572 | 2021-03-02 | Lake | Ohio | 39085 | 18411 | 318 |
1081573 | 1081573 | 2021-03-02 | Lawrence | Ohio | 39087 | 5262 | 18 |
1081574 | 1081574 | 2021-03-02 | Licking | Ohio | 39089 | 14988 | 189 |
1081575 | 1081575 | 2021-03-02 | Logan | Ohio | 39091 | 3544 | 72 |
1081576 | 1081576 | 2021-03-02 | Lorain | Ohio | 39093 | 22016 | 414 |
1081577 | 1081577 | 2021-03-02 | Lucas | Ohio | 39095 | 35389 | 685 |
1081578 | 1081578 | 2021-03-02 | Madison | Ohio | 39097 | 3928 | 53 |
1081579 | 1081579 | 2021-03-02 | Mahoning | Ohio | 39099 | 19470 | 537 |
1081580 | 1081580 | 2021-03-02 | Marion | Ohio | 39101 | 7989 | 125 |
1081581 | 1081581 | 2021-03-02 | Medina | Ohio | 39103 | 13394 | 226 |
1081582 | 1081582 | 2021-03-02 | Meigs | Ohio | 39105 | 1353 | 30 |
1081583 | 1081583 | 2021-03-02 | Mercer | Ohio | 39107 | 4584 | 80 |
1081584 | 1081584 | 2021-03-02 | Miami | Ohio | 39109 | 10022 | 189 |
1081585 | 1081585 | 2021-03-02 | Monroe | Ohio | 39111 | 1163 | 27 |
1081586 | 1081586 | 2021-03-02 | Montgomery | Ohio | 39113 | 47301 | 903 |
1081587 | 1081587 | 2021-03-02 | Morgan | Ohio | 39115 | 1009 | 19 |
1081588 | 1081588 | 2021-03-02 | Morrow | Ohio | 39117 | 2597 | 34 |
1081589 | 1081589 | 2021-03-02 | Muskingum | Ohio | 39119 | 8182 | 112 |
1081590 | 1081590 | 2021-03-02 | Noble | Ohio | 39121 | 1292 | 33 |
1081591 | 1081591 | 2021-03-02 | Ottawa | Ohio | 39123 | 3239 | 69 |
1081592 | 1081592 | 2021-03-02 | Paulding | Ohio | 39125 | 1602 | 30 |
1081593 | 1081593 | 2021-03-02 | Perry | Ohio | 39127 | 2686 | 47 |
1081594 | 1081594 | 2021-03-02 | Pickaway | Ohio | 39129 | 8054 | 107 |
1081595 | 1081595 | 2021-03-02 | Pike | Ohio | 39131 | 2152 | 26 |
1081596 | 1081596 | 2021-03-02 | Portage | Ohio | 39133 | 11031 | 164 |
1081597 | 1081597 | 2021-03-02 | Preble | Ohio | 39135 | 3533 | 78 |
1081598 | 1081598 | 2021-03-02 | Putnam | Ohio | 39137 | 3989 | 90 |
1081599 | 1081599 | 2021-03-02 | Richland | Ohio | 39139 | 10298 | 183 |
1081600 | 1081600 | 2021-03-02 | Ross | Ohio | 39141 | 6140 | 128 |
1081601 | 1081601 | 2021-03-02 | Sandusky | Ohio | 39143 | 4769 | 108 |
1081602 | 1081602 | 2021-03-02 | Scioto | Ohio | 39145 | 5948 | 80 |
1081603 | 1081603 | 2021-03-02 | Seneca | Ohio | 39147 | 4690 | 107 |
1081604 | 1081604 | 2021-03-02 | Shelby | Ohio | 39149 | 4411 | 79 |
1081605 | 1081605 | 2021-03-02 | Stark | Ohio | 39151 | 29403 | 803 |
1081606 | 1081606 | 2021-03-02 | Summit | Ohio | 39153 | 40266 | 802 |
1081607 | 1081607 | 2021-03-02 | Trumbull | Ohio | 39155 | 14337 | 413 |
1081608 | 1081608 | 2021-03-02 | Tuscarawas | Ohio | 39157 | 8039 | 227 |
1081609 | 1081609 | 2021-03-02 | Union | Ohio | 39159 | 5129 | 37 |
1081610 | 1081610 | 2021-03-02 | Van Wert | Ohio | 39161 | 2294 | 54 |
1081611 | 1081611 | 2021-03-02 | Vinton | Ohio | 39163 | 768 | 13 |
1081612 | 1081612 | 2021-03-02 | Warren | Ohio | 39165 | 22421 | 271 |
1081613 | 1081613 | 2021-03-02 | Washington | Ohio | 39167 | 4637 | 91 |
1081614 | 1081614 | 2021-03-02 | Wayne | Ohio | 39169 | 7872 | 193 |
1081615 | 1081615 | 2021-03-02 | Williams | Ohio | 39171 | 3020 | 62 |
1081616 | 1081616 | 2021-03-02 | Wood | Ohio | 39173 | 11537 | 163 |
1081617 | 1081617 | 2021-03-02 | Wyandot | Ohio | 39175 | 2100 | 47 |
1078284 | 1078284 | 2021-03-01 | Adams | Ohio | 39001 | 2160 | 32 |
1078285 | 1078285 | 2021-03-01 | Allen | Ohio | 39003 | 10768 | 235 |
1078286 | 1078286 | 2021-03-01 | Ashland | Ohio | 39005 | 3791 | 95 |
1078287 | 1078287 | 2021-03-01 | Ashtabula | Ohio | 39007 | 5959 | 147 |
1078288 | 1078288 | 2021-03-01 | Athens | Ohio | 39009 | 4637 | 33 |
1078289 | 1078289 | 2021-03-01 | Auglaize | Ohio | 39011 | 4554 | 99 |
1078290 | 1078290 | 2021-03-01 | Belmont | Ohio | 39013 | 4918 | 89 |
1078291 | 1078291 | 2021-03-01 | Brown | Ohio | 39015 | 3692 | 42 |
1078292 | 1078292 | 2021-03-01 | Butler | Ohio | 39017 | 35456 | 473 |
1078293 | 1078293 | 2021-03-01 | Carroll | Ohio | 39019 | 1808 | 28 |
1078294 | 1078294 | 2021-03-01 | Champaign | Ohio | 39021 | 2866 | 46 |
1078295 | 1078295 | 2021-03-01 | Clark | Ohio | 39023 | 12246 | 336 |
1078296 | 1078296 | 2021-03-01 | Clermont | Ohio | 39025 | 18346 | 212 |
1078297 | 1078297 | 2021-03-01 | Clinton | Ohio | 39027 | 3400 | 64 |
1078298 | 1078298 | 2021-03-01 | Columbiana | Ohio | 39029 | 8120 | 183 |
1078299 | 1078299 | 2021-03-01 | Coshocton | Ohio | 39031 | 2355 | 47 |
1078300 | 1078300 | 2021-03-01 | Crawford | Ohio | 39033 | 3574 | 96 |
1078301 | 1078301 | 2021-03-01 | Cuyahoga | Ohio | 39035 | 95705 | 1750 |
1078302 | 1078302 | 2021-03-01 | Darke | Ohio | 39037 | 5026 | 124 |
1078303 | 1078303 | 2021-03-01 | Defiance | Ohio | 39039 | 3714 | 102 |
1078304 | 1078304 | 2021-03-01 | Delaware | Ohio | 39041 | 16437 | 136 |
1078305 | 1078305 | 2021-03-01 | Erie | Ohio | 39043 | 6872 | 184 |
1078306 | 1078306 | 2021-03-01 | Fairfield | Ohio | 39045 | 14506 | 160 |
1078307 | 1078307 | 2021-03-01 | Fayette | Ohio | 39047 | 2681 | 44 |
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);