ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where "date" is on date 2021-09-12 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 · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1711460 | 1711460 | 2021-09-12 | Adams | Ohio | 39001 | 3284 | 63 |
1711461 | 1711461 | 2021-09-12 | Allen | Ohio | 39003 | 13474 | 254 |
1711462 | 1711462 | 2021-09-12 | Ashland | Ohio | 39005 | 5507 | 107 |
1711463 | 1711463 | 2021-09-12 | Ashtabula | Ohio | 39007 | 7949 | 184 |
1711464 | 1711464 | 2021-09-12 | Athens | Ohio | 39009 | 6536 | 63 |
1711465 | 1711465 | 2021-09-12 | Auglaize | Ohio | 39011 | 5645 | 88 |
1711466 | 1711466 | 2021-09-12 | Belmont | Ohio | 39013 | 7604 | 183 |
1711467 | 1711467 | 2021-09-12 | Brown | Ohio | 39015 | 5171 | 67 |
1711468 | 1711468 | 2021-09-12 | Butler | Ohio | 39017 | 45363 | 646 |
1711469 | 1711469 | 2021-09-12 | Carroll | Ohio | 39019 | 2440 | 51 |
1711470 | 1711470 | 2021-09-12 | Champaign | Ohio | 39021 | 4165 | 63 |
1711471 | 1711471 | 2021-09-12 | Clark | Ohio | 39023 | 16910 | 320 |
1711472 | 1711472 | 2021-09-12 | Clermont | Ohio | 39025 | 24369 | 275 |
1711473 | 1711473 | 2021-09-12 | Clinton | Ohio | 39027 | 4961 | 74 |
1711474 | 1711474 | 2021-09-12 | Columbiana | Ohio | 39029 | 10880 | 237 |
1711475 | 1711475 | 2021-09-12 | Coshocton | Ohio | 39031 | 3319 | 64 |
1711476 | 1711476 | 2021-09-12 | Crawford | Ohio | 39033 | 5041 | 112 |
1711477 | 1711477 | 2021-09-12 | Cuyahoga | Ohio | 39035 | 129835 | 2304 |
1711478 | 1711478 | 2021-09-12 | Darke | Ohio | 39037 | 6239 | 135 |
1711479 | 1711479 | 2021-09-12 | Defiance | Ohio | 39039 | 5199 | 100 |
1711480 | 1711480 | 2021-09-12 | Delaware | Ohio | 39041 | 21458 | 140 |
1711481 | 1711481 | 2021-09-12 | Erie | Ohio | 39043 | 9301 | 169 |
1711482 | 1711482 | 2021-09-12 | Fairfield | Ohio | 39045 | 19439 | 217 |
1711483 | 1711483 | 2021-09-12 | Fayette | Ohio | 39047 | 3477 | 51 |
1711484 | 1711484 | 2021-09-12 | Franklin | Ohio | 39049 | 146227 | 1533 |
1711485 | 1711485 | 2021-09-12 | Fulton | Ohio | 39051 | 5005 | 81 |
1711486 | 1711486 | 2021-09-12 | Gallia | Ohio | 39053 | 3199 | 54 |
1711487 | 1711487 | 2021-09-12 | Geauga | Ohio | 39055 | 7858 | 155 |
1711488 | 1711488 | 2021-09-12 | Greene | Ohio | 39057 | 19372 | 266 |
1711489 | 1711489 | 2021-09-12 | Guernsey | Ohio | 39059 | 4266 | 55 |
1711490 | 1711490 | 2021-09-12 | Hamilton | Ohio | 39061 | 93837 | 1305 |
1711491 | 1711491 | 2021-09-12 | Hancock | Ohio | 39063 | 7959 | 139 |
1711492 | 1711492 | 2021-09-12 | Hardin | Ohio | 39065 | 3327 | 66 |
1711493 | 1711493 | 2021-09-12 | Harrison | Ohio | 39067 | 1404 | 40 |
1711494 | 1711494 | 2021-09-12 | Henry | Ohio | 39069 | 3082 | 68 |
1711495 | 1711495 | 2021-09-12 | Highland | Ohio | 39071 | 4982 | 75 |
1711496 | 1711496 | 2021-09-12 | Hocking | Ohio | 39073 | 2724 | 66 |
1711497 | 1711497 | 2021-09-12 | Holmes | Ohio | 39075 | 3108 | 103 |
1711498 | 1711498 | 2021-09-12 | Huron | Ohio | 39077 | 6920 | 124 |
1711499 | 1711499 | 2021-09-12 | Jackson | Ohio | 39079 | 3927 | 59 |
1711500 | 1711500 | 2021-09-12 | Jefferson | Ohio | 39081 | 6900 | 168 |
1711501 | 1711501 | 2021-09-12 | Knox | Ohio | 39083 | 6142 | 120 |
1711502 | 1711502 | 2021-09-12 | Lake | Ohio | 39085 | 23824 | 408 |
1711503 | 1711503 | 2021-09-12 | Lawrence | Ohio | 39087 | 7920 | 116 |
1711504 | 1711504 | 2021-09-12 | Licking | Ohio | 39089 | 19446 | 236 |
1711505 | 1711505 | 2021-09-12 | Logan | Ohio | 39091 | 4846 | 82 |
1711506 | 1711506 | 2021-09-12 | Lorain | Ohio | 39093 | 29907 | 523 |
1711507 | 1711507 | 2021-09-12 | Lucas | Ohio | 39095 | 48868 | 851 |
1711508 | 1711508 | 2021-09-12 | Madison | Ohio | 39097 | 5185 | 68 |
1711509 | 1711509 | 2021-09-12 | Mahoning | Ohio | 39099 | 25569 | 627 |
1711510 | 1711510 | 2021-09-12 | Marion | Ohio | 39101 | 10135 | 142 |
1711511 | 1711511 | 2021-09-12 | Medina | Ohio | 39103 | 18902 | 283 |
1711512 | 1711512 | 2021-09-12 | Meigs | Ohio | 39105 | 1912 | 42 |
1711513 | 1711513 | 2021-09-12 | Mercer | Ohio | 39107 | 5395 | 87 |
1711514 | 1711514 | 2021-09-12 | Miami | Ohio | 39109 | 13091 | 242 |
1711515 | 1711515 | 2021-09-12 | Monroe | Ohio | 39111 | 1729 | 48 |
1711516 | 1711516 | 2021-09-12 | Montgomery | Ohio | 39113 | 63812 | 1113 |
1711517 | 1711517 | 2021-09-12 | Morgan | Ohio | 39115 | 1473 | 26 |
1711518 | 1711518 | 2021-09-12 | Morrow | Ohio | 39117 | 3502 | 47 |
1711519 | 1711519 | 2021-09-12 | Muskingum | Ohio | 39119 | 11443 | 145 |
1711520 | 1711520 | 2021-09-12 | Noble | Ohio | 39121 | 1565 | 40 |
1711521 | 1711521 | 2021-09-12 | Ottawa | Ohio | 39123 | 4196 | 83 |
1711522 | 1711522 | 2021-09-12 | Paulding | Ohio | 39125 | 2256 | 42 |
1711523 | 1711523 | 2021-09-12 | Perry | Ohio | 39127 | 3948 | 50 |
1711524 | 1711524 | 2021-09-12 | Pickaway | Ohio | 39129 | 10039 | 128 |
1711525 | 1711525 | 2021-09-12 | Pike | Ohio | 39131 | 3552 | 38 |
1711526 | 1711526 | 2021-09-12 | Portage | Ohio | 39133 | 15370 | 223 |
1711527 | 1711527 | 2021-09-12 | Preble | Ohio | 39135 | 4706 | 110 |
1711528 | 1711528 | 2021-09-12 | Putnam | Ohio | 39137 | 4699 | 105 |
1711529 | 1711529 | 2021-09-12 | Richland | Ohio | 39139 | 15146 | 226 |
1711530 | 1711530 | 2021-09-12 | Ross | Ohio | 39141 | 8780 | 171 |
1711531 | 1711531 | 2021-09-12 | Sandusky | Ohio | 39143 | 6482 | 132 |
1711532 | 1711532 | 2021-09-12 | Scioto | Ohio | 39145 | 9429 | 124 |
1711533 | 1711533 | 2021-09-12 | Seneca | Ohio | 39147 | 6030 | 135 |
1711534 | 1711534 | 2021-09-12 | Shelby | Ohio | 39149 | 5489 | 98 |
1711535 | 1711535 | 2021-09-12 | Stark | Ohio | 39151 | 39197 | 960 |
1711536 | 1711536 | 2021-09-12 | Summit | Ohio | 39153 | 54281 | 1039 |
1711537 | 1711537 | 2021-09-12 | Trumbull | Ohio | 39155 | 18870 | 500 |
1711538 | 1711538 | 2021-09-12 | Tuscarawas | Ohio | 39157 | 10194 | 263 |
1711539 | 1711539 | 2021-09-12 | Union | Ohio | 39159 | 6934 | 49 |
1711540 | 1711540 | 2021-09-12 | Unknown | Ohio | 0 | 5 | |
1711541 | 1711541 | 2021-09-12 | Van Wert | Ohio | 39161 | 2952 | 68 |
1711542 | 1711542 | 2021-09-12 | Vinton | Ohio | 39163 | 1273 | 17 |
1711543 | 1711543 | 2021-09-12 | Warren | Ohio | 39165 | 28797 | 323 |
1711544 | 1711544 | 2021-09-12 | Washington | Ohio | 39167 | 6583 | 116 |
1711545 | 1711545 | 2021-09-12 | Wayne | Ohio | 39169 | 11220 | 233 |
1711546 | 1711546 | 2021-09-12 | Williams | Ohio | 39171 | 4284 | 81 |
1711547 | 1711547 | 2021-09-12 | Wood | Ohio | 39173 | 14917 | 207 |
1711548 | 1711548 | 2021-09-12 | Wyandot | Ohio | 39175 | 2672 | 58 |
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);