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 2022-02-11 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 |
---|---|---|---|---|---|---|---|
2205537 | 2205537 | 2022-02-11 | Adams | Ohio | 39001 | 6788 | 134 |
2205538 | 2205538 | 2022-02-11 | Allen | Ohio | 39003 | 27150 | 431 |
2205539 | 2205539 | 2022-02-11 | Ashland | Ohio | 39005 | 11804 | 203 |
2205540 | 2205540 | 2022-02-11 | Ashtabula | Ohio | 39007 | 19327 | 388 |
2205541 | 2205541 | 2022-02-11 | Athens | Ohio | 39009 | 13920 | 116 |
2205542 | 2205542 | 2022-02-11 | Auglaize | Ohio | 39011 | 11426 | 164 |
2205543 | 2205543 | 2022-02-11 | Belmont | Ohio | 39013 | 15313 | 263 |
2205544 | 2205544 | 2022-02-11 | Brown | Ohio | 39015 | 10989 | 156 |
2205545 | 2205545 | 2022-02-11 | Butler | Ohio | 39017 | 89108 | 1029 |
2205546 | 2205546 | 2022-02-11 | Carroll | Ohio | 39019 | 5205 | 116 |
2205547 | 2205547 | 2022-02-11 | Champaign | Ohio | 39021 | 8580 | 130 |
2205548 | 2205548 | 2022-02-11 | Clark | Ohio | 39023 | 34440 | 508 |
2205549 | 2205549 | 2022-02-11 | Clermont | Ohio | 39025 | 50325 | 491 |
2205550 | 2205550 | 2022-02-11 | Clinton | Ohio | 39027 | 10148 | 149 |
2205551 | 2205551 | 2022-02-11 | Columbiana | Ohio | 39029 | 23990 | 455 |
2205552 | 2205552 | 2022-02-11 | Coshocton | Ohio | 39031 | 7826 | 144 |
2205553 | 2205553 | 2022-02-11 | Crawford | Ohio | 39033 | 10982 | 191 |
2205554 | 2205554 | 2022-02-11 | Cuyahoga | Ohio | 39035 | 264870 | 3456 |
2205555 | 2205555 | 2022-02-11 | Darke | Ohio | 39037 | 12207 | 215 |
2205556 | 2205556 | 2022-02-11 | Defiance | Ohio | 39039 | 10062 | 152 |
2205557 | 2205557 | 2022-02-11 | Delaware | Ohio | 39041 | 43447 | 248 |
2205558 | 2205558 | 2022-02-11 | Erie | Ohio | 39043 | 19204 | 253 |
2205559 | 2205559 | 2022-02-11 | Fairfield | Ohio | 39045 | 37800 | 389 |
2205560 | 2205560 | 2022-02-11 | Fayette | Ohio | 39047 | 7668 | 102 |
2205561 | 2205561 | 2022-02-11 | Franklin | Ohio | 39049 | 283512 | 2326 |
2205562 | 2205562 | 2022-02-11 | Fulton | Ohio | 39051 | 10178 | 167 |
2205563 | 2205563 | 2022-02-11 | Gallia | Ohio | 39053 | 7138 | 105 |
2205564 | 2205564 | 2022-02-11 | Geauga | Ohio | 39055 | 15805 | 252 |
2205565 | 2205565 | 2022-02-11 | Greene | Ohio | 39057 | 36581 | 467 |
2205566 | 2205566 | 2022-02-11 | Guernsey | Ohio | 39059 | 10238 | 136 |
2205567 | 2205567 | 2022-02-11 | Hamilton | Ohio | 39061 | 184216 | 1867 |
2205568 | 2205568 | 2022-02-11 | Hancock | Ohio | 39063 | 16878 | 250 |
2205569 | 2205569 | 2022-02-11 | Hardin | Ohio | 39065 | 6976 | 139 |
2205570 | 2205570 | 2022-02-11 | Harrison | Ohio | 39067 | 3171 | 67 |
2205571 | 2205571 | 2022-02-11 | Henry | Ohio | 39069 | 6339 | 100 |
2205572 | 2205572 | 2022-02-11 | Highland | Ohio | 39071 | 10466 | 166 |
2205573 | 2205573 | 2022-02-11 | Hocking | Ohio | 39073 | 6407 | 111 |
2205574 | 2205574 | 2022-02-11 | Holmes | Ohio | 39075 | 5030 | 172 |
2205575 | 2205575 | 2022-02-11 | Huron | Ohio | 39077 | 14295 | 210 |
2205576 | 2205576 | 2022-02-11 | Jackson | Ohio | 39079 | 8590 | 128 |
2205577 | 2205577 | 2022-02-11 | Jefferson | Ohio | 39081 | 14415 | 285 |
2205578 | 2205578 | 2022-02-11 | Knox | Ohio | 39083 | 12917 | 217 |
2205579 | 2205579 | 2022-02-11 | Lake | Ohio | 39085 | 48296 | 690 |
2205580 | 2205580 | 2022-02-11 | Lawrence | Ohio | 39087 | 17128 | 209 |
2205581 | 2205581 | 2022-02-11 | Licking | Ohio | 39089 | 40887 | 441 |
2205582 | 2205582 | 2022-02-11 | Logan | Ohio | 39091 | 10023 | 153 |
2205583 | 2205583 | 2022-02-11 | Lorain | Ohio | 39093 | 65775 | 907 |
2205584 | 2205584 | 2022-02-11 | Lucas | Ohio | 39095 | 97570 | 1304 |
2205585 | 2205585 | 2022-02-11 | Madison | Ohio | 39097 | 9517 | 121 |
2205586 | 2205586 | 2022-02-11 | Mahoning | Ohio | 39099 | 52682 | 1016 |
2205587 | 2205587 | 2022-02-11 | Marion | Ohio | 39101 | 19505 | 247 |
2205588 | 2205588 | 2022-02-11 | Medina | Ohio | 39103 | 39546 | 467 |
2205589 | 2205589 | 2022-02-11 | Meigs | Ohio | 39105 | 4377 | 77 |
2205590 | 2205590 | 2022-02-11 | Mercer | Ohio | 39107 | 9559 | 122 |
2205591 | 2205591 | 2022-02-11 | Miami | Ohio | 39109 | 25427 | 446 |
2205592 | 2205592 | 2022-02-11 | Monroe | Ohio | 39111 | 3385 | 70 |
2205593 | 2205593 | 2022-02-11 | Montgomery | Ohio | 39113 | 124923 | 1818 |
2205594 | 2205594 | 2022-02-11 | Morgan | Ohio | 39115 | 3165 | 52 |
2205595 | 2205595 | 2022-02-11 | Morrow | Ohio | 39117 | 7619 | 89 |
2205596 | 2205596 | 2022-02-11 | Muskingum | Ohio | 39119 | 24844 | 271 |
2205597 | 2205597 | 2022-02-11 | Noble | Ohio | 39121 | 3136 | 53 |
2205598 | 2205598 | 2022-02-11 | Ottawa | Ohio | 39123 | 8243 | 133 |
2205599 | 2205599 | 2022-02-11 | Paulding | Ohio | 39125 | 4557 | 69 |
2205600 | 2205600 | 2022-02-11 | Perry | Ohio | 39127 | 8039 | 115 |
2205601 | 2205601 | 2022-02-11 | Pickaway | Ohio | 39129 | 17234 | 203 |
2205602 | 2205602 | 2022-02-11 | Pike | Ohio | 39131 | 7251 | 100 |
2205603 | 2205603 | 2022-02-11 | Portage | Ohio | 39133 | 33472 | 409 |
2205604 | 2205604 | 2022-02-11 | Preble | Ohio | 39135 | 9287 | 182 |
2205605 | 2205605 | 2022-02-11 | Putnam | Ohio | 39137 | 8370 | 140 |
2205606 | 2205606 | 2022-02-11 | Richland | Ohio | 39139 | 30942 | 478 |
2205607 | 2205607 | 2022-02-11 | Ross | Ohio | 39141 | 18822 | 275 |
2205608 | 2205608 | 2022-02-11 | Sandusky | Ohio | 39143 | 13758 | 215 |
2205609 | 2205609 | 2022-02-11 | Scioto | Ohio | 39145 | 19980 | 226 |
2205610 | 2205610 | 2022-02-11 | Seneca | Ohio | 39147 | 12554 | 217 |
2205611 | 2205611 | 2022-02-11 | Shelby | Ohio | 39149 | 10917 | 172 |
2205612 | 2205612 | 2022-02-11 | Stark | Ohio | 39151 | 78989 | 1591 |
2205613 | 2205613 | 2022-02-11 | Summit | Ohio | 39153 | 111034 | 1586 |
2205614 | 2205614 | 2022-02-11 | Trumbull | Ohio | 39155 | 40865 | 855 |
2205615 | 2205615 | 2022-02-11 | Tuscarawas | Ohio | 39157 | 20306 | 466 |
2205616 | 2205616 | 2022-02-11 | Union | Ohio | 39159 | 15247 | 88 |
2205617 | 2205617 | 2022-02-11 | Unknown | Ohio | 0 | 5 | |
2205618 | 2205618 | 2022-02-11 | Van Wert | Ohio | 39161 | 6459 | 130 |
2205619 | 2205619 | 2022-02-11 | Vinton | Ohio | 39163 | 2842 | 52 |
2205620 | 2205620 | 2022-02-11 | Warren | Ohio | 39165 | 56636 | 532 |
2205621 | 2205621 | 2022-02-11 | Washington | Ohio | 39167 | 12075 | 181 |
2205622 | 2205622 | 2022-02-11 | Wayne | Ohio | 39169 | 22852 | 404 |
2205623 | 2205623 | 2022-02-11 | Williams | Ohio | 39171 | 8852 | 152 |
2205624 | 2205624 | 2022-02-11 | Wood | Ohio | 39173 | 30775 | 330 |
2205625 | 2205625 | 2022-02-11 | Wyandot | Ohio | 39175 | 5361 | 98 |
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);