ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2021-01-24 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adams 1
- Allen 1
- Ashland 1
- Ashtabula 1
- Athens 1
- Auglaize 1
- Belmont 1
- Brown 1
- Butler 1
- Carroll 1
- Champaign 1
- Clark 1
- Clermont 1
- Clinton 1
- Columbiana 1
- Coshocton 1
- Crawford 1
- Cuyahoga 1
- Darke 1
- Defiance 1
- Delaware 1
- Erie 1
- Fairfield 1
- Fayette 1
- Franklin 1
- Fulton 1
- Gallia 1
- Geauga 1
- Greene 1
- Guernsey 1
- …
state 1
- Ohio · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
961442 | 961442 | 2021-01-24 | Adams | Ohio | 39001 | 1769 | 15 |
961443 | 961443 | 2021-01-24 | Allen | Ohio | 39003 | 9945 | 126 |
961444 | 961444 | 2021-01-24 | Ashland | Ohio | 39005 | 3474 | 38 |
961445 | 961445 | 2021-01-24 | Ashtabula | Ohio | 39007 | 4546 | 73 |
961446 | 961446 | 2021-01-24 | Athens | Ohio | 39009 | 3812 | 9 |
961447 | 961447 | 2021-01-24 | Auglaize | Ohio | 39011 | 4230 | 64 |
961448 | 961448 | 2021-01-24 | Belmont | Ohio | 39013 | 4177 | 40 |
961449 | 961449 | 2021-01-24 | Brown | Ohio | 39015 | 3139 | 21 |
961450 | 961450 | 2021-01-24 | Butler | Ohio | 39017 | 31128 | 232 |
961451 | 961451 | 2021-01-24 | Carroll | Ohio | 39019 | 1562 | 16 |
961452 | 961452 | 2021-01-24 | Champaign | Ohio | 39021 | 2526 | 28 |
961453 | 961453 | 2021-01-24 | Clark | Ohio | 39023 | 10995 | 265 |
961454 | 961454 | 2021-01-24 | Clermont | Ohio | 39025 | 16057 | 111 |
961455 | 961455 | 2021-01-24 | Clinton | Ohio | 39027 | 2907 | 43 |
961456 | 961456 | 2021-01-24 | Columbiana | Ohio | 39029 | 7356 | 124 |
961457 | 961457 | 2021-01-24 | Coshocton | Ohio | 39031 | 2057 | 22 |
961458 | 961458 | 2021-01-24 | Crawford | Ohio | 39033 | 3238 | 74 |
961459 | 961459 | 2021-01-24 | Cuyahoga | Ohio | 39035 | 86066 | 1145 |
961460 | 961460 | 2021-01-24 | Darke | Ohio | 39037 | 4710 | 92 |
961461 | 961461 | 2021-01-24 | Defiance | Ohio | 39039 | 3322 | 86 |
961462 | 961462 | 2021-01-24 | Delaware | Ohio | 39041 | 14454 | 79 |
961463 | 961463 | 2021-01-24 | Erie | Ohio | 39043 | 6188 | 129 |
961464 | 961464 | 2021-01-24 | Fairfield | Ohio | 39045 | 12877 | 81 |
961465 | 961465 | 2021-01-24 | Fayette | Ohio | 39047 | 2373 | 30 |
961466 | 961466 | 2021-01-24 | Franklin | Ohio | 39049 | 101705 | 707 |
961467 | 961467 | 2021-01-24 | Fulton | Ohio | 39051 | 3393 | 43 |
961468 | 961468 | 2021-01-24 | Gallia | Ohio | 39053 | 1988 | 26 |
961469 | 961469 | 2021-01-24 | Geauga | Ohio | 39055 | 5135 | 55 |
961470 | 961470 | 2021-01-24 | Greene | Ohio | 39057 | 12114 | 139 |
961471 | 961471 | 2021-01-24 | Guernsey | Ohio | 39059 | 2563 | 26 |
961472 | 961472 | 2021-01-24 | Hamilton | Ohio | 39061 | 64392 | 448 |
961473 | 961473 | 2021-01-24 | Hancock | Ohio | 39063 | 5543 | 90 |
961474 | 961474 | 2021-01-24 | Hardin | Ohio | 39065 | 2140 | 33 |
961475 | 961475 | 2021-01-24 | Harrison | Ohio | 39067 | 894 | 21 |
961476 | 961476 | 2021-01-24 | Henry | Ohio | 39069 | 2201 | 49 |
961477 | 961477 | 2021-01-24 | Highland | Ohio | 39071 | 2767 | 18 |
961478 | 961478 | 2021-01-24 | Hocking | Ohio | 39073 | 1726 | 24 |
961479 | 961479 | 2021-01-24 | Holmes | Ohio | 39075 | 2256 | 74 |
961480 | 961480 | 2021-01-24 | Huron | Ohio | 39077 | 4300 | 41 |
961481 | 961481 | 2021-01-24 | Jackson | Ohio | 39079 | 2653 | 45 |
961482 | 961482 | 2021-01-24 | Jefferson | Ohio | 39081 | 4205 | 69 |
961483 | 961483 | 2021-01-24 | Knox | Ohio | 39083 | 3544 | 22 |
961484 | 961484 | 2021-01-24 | Lake | Ohio | 39085 | 16178 | 154 |
961485 | 961485 | 2021-01-24 | Lawrence | Ohio | 39087 | 4579 | 58 |
961486 | 961486 | 2021-01-24 | Licking | Ohio | 39089 | 13274 | 137 |
961487 | 961487 | 2021-01-24 | Logan | Ohio | 39091 | 3091 | 32 |
961488 | 961488 | 2021-01-24 | Lorain | Ohio | 39093 | 19165 | 223 |
961489 | 961489 | 2021-01-24 | Lucas | Ohio | 39095 | 31500 | 625 |
961490 | 961490 | 2021-01-24 | Madison | Ohio | 39097 | 3565 | 29 |
961491 | 961491 | 2021-01-24 | Mahoning | Ohio | 39099 | 17383 | 338 |
961492 | 961492 | 2021-01-24 | Marion | Ohio | 39101 | 7467 | 113 |
961493 | 961493 | 2021-01-24 | Medina | Ohio | 39103 | 11666 | 168 |
961494 | 961494 | 2021-01-24 | Meigs | Ohio | 39105 | 1090 | 24 |
961495 | 961495 | 2021-01-24 | Mercer | Ohio | 39107 | 4344 | 89 |
961496 | 961496 | 2021-01-24 | Miami | Ohio | 39109 | 9210 | 73 |
961497 | 961497 | 2021-01-24 | Monroe | Ohio | 39111 | 1010 | 32 |
961498 | 961498 | 2021-01-24 | Montgomery | Ohio | 39113 | 43309 | 418 |
961499 | 961499 | 2021-01-24 | Morgan | Ohio | 39115 | 834 | 30 |
961500 | 961500 | 2021-01-24 | Morrow | Ohio | 39117 | 2333 | 4 |
961501 | 961501 | 2021-01-24 | Muskingum | Ohio | 39119 | 7052 | 41 |
961502 | 961502 | 2021-01-24 | Noble | Ohio | 39121 | 1207 | 40 |
961503 | 961503 | 2021-01-24 | Ottawa | Ohio | 39123 | 2949 | 43 |
961504 | 961504 | 2021-01-24 | Paulding | Ohio | 39125 | 1447 | 21 |
961505 | 961505 | 2021-01-24 | Perry | Ohio | 39127 | 2320 | 18 |
961506 | 961506 | 2021-01-24 | Pickaway | Ohio | 39129 | 7284 | 50 |
961507 | 961507 | 2021-01-24 | Pike | Ohio | 39131 | 1774 | 17 |
961508 | 961508 | 2021-01-24 | Portage | Ohio | 39133 | 9382 | 109 |
961509 | 961509 | 2021-01-24 | Preble | Ohio | 39135 | 3214 | 37 |
961510 | 961510 | 2021-01-24 | Putnam | Ohio | 39137 | 3762 | 75 |
961511 | 961511 | 2021-01-24 | Richland | Ohio | 39139 | 9186 | 118 |
961512 | 961512 | 2021-01-24 | Ross | Ohio | 39141 | 5532 | 100 |
961513 | 961513 | 2021-01-24 | Sandusky | Ohio | 39143 | 4385 | 62 |
961514 | 961514 | 2021-01-24 | Scioto | Ohio | 39145 | 5416 | 64 |
961515 | 961515 | 2021-01-24 | Seneca | Ohio | 39147 | 4315 | 66 |
961516 | 961516 | 2021-01-24 | Shelby | Ohio | 39149 | 4219 | 22 |
961517 | 961517 | 2021-01-24 | Stark | Ohio | 39151 | 25933 | 435 |
961518 | 961518 | 2021-01-24 | Summit | Ohio | 39153 | 35063 | 761 |
961519 | 961519 | 2021-01-24 | Trumbull | Ohio | 39155 | 12861 | 316 |
961520 | 961520 | 2021-01-24 | Tuscarawas | Ohio | 39157 | 7410 | 182 |
961521 | 961521 | 2021-01-24 | Union | Ohio | 39159 | 4546 | 28 |
961522 | 961522 | 2021-01-24 | Van Wert | Ohio | 39161 | 2026 | 45 |
961523 | 961523 | 2021-01-24 | Vinton | Ohio | 39163 | 708 | 13 |
961524 | 961524 | 2021-01-24 | Warren | Ohio | 39165 | 19746 | 141 |
961525 | 961525 | 2021-01-24 | Washington | Ohio | 39167 | 3918 | 40 |
961526 | 961526 | 2021-01-24 | Wayne | Ohio | 39169 | 7080 | 171 |
961527 | 961527 | 2021-01-24 | Williams | Ohio | 39171 | 2794 | 67 |
961528 | 961528 | 2021-01-24 | Wood | Ohio | 39173 | 10407 | 158 |
961529 | 961529 | 2021-01-24 | Wyandot | Ohio | 39175 | 1961 | 51 |
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);