ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where date = "2022-02-06" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
2189268 | 2189268 | 2022-02-06 | Adams | Ohio | 39001 | 6690 | 132 |
2189269 | 2189269 | 2022-02-06 | Allen | Ohio | 39003 | 26991 | 427 |
2189270 | 2189270 | 2022-02-06 | Ashland | Ohio | 39005 | 11704 | 200 |
2189271 | 2189271 | 2022-02-06 | Ashtabula | Ohio | 39007 | 19151 | 382 |
2189272 | 2189272 | 2022-02-06 | Athens | Ohio | 39009 | 13686 | 112 |
2189273 | 2189273 | 2022-02-06 | Auglaize | Ohio | 39011 | 11345 | 163 |
2189274 | 2189274 | 2022-02-06 | Belmont | Ohio | 39013 | 15168 | 258 |
2189275 | 2189275 | 2022-02-06 | Brown | Ohio | 39015 | 10857 | 151 |
2189276 | 2189276 | 2022-02-06 | Butler | Ohio | 39017 | 88075 | 1015 |
2189277 | 2189277 | 2022-02-06 | Carroll | Ohio | 39019 | 5177 | 113 |
2189278 | 2189278 | 2022-02-06 | Champaign | Ohio | 39021 | 8504 | 124 |
2189279 | 2189279 | 2022-02-06 | Clark | Ohio | 39023 | 34168 | 488 |
2189280 | 2189280 | 2022-02-06 | Clermont | Ohio | 39025 | 49832 | 479 |
2189281 | 2189281 | 2022-02-06 | Clinton | Ohio | 39027 | 10053 | 141 |
2189282 | 2189282 | 2022-02-06 | Columbiana | Ohio | 39029 | 23809 | 446 |
2189283 | 2189283 | 2022-02-06 | Coshocton | Ohio | 39031 | 7764 | 139 |
2189284 | 2189284 | 2022-02-06 | Crawford | Ohio | 39033 | 10909 | 186 |
2189285 | 2189285 | 2022-02-06 | Cuyahoga | Ohio | 39035 | 264158 | 3390 |
2189286 | 2189286 | 2022-02-06 | Darke | Ohio | 39037 | 12118 | 211 |
2189287 | 2189287 | 2022-02-06 | Defiance | Ohio | 39039 | 9979 | 147 |
2189288 | 2189288 | 2022-02-06 | Delaware | Ohio | 39041 | 43161 | 241 |
2189289 | 2189289 | 2022-02-06 | Erie | Ohio | 39043 | 19060 | 250 |
2189290 | 2189290 | 2022-02-06 | Fairfield | Ohio | 39045 | 37512 | 384 |
2189291 | 2189291 | 2022-02-06 | Fayette | Ohio | 39047 | 7607 | 100 |
2189292 | 2189292 | 2022-02-06 | Franklin | Ohio | 39049 | 281660 | 2281 |
2189293 | 2189293 | 2022-02-06 | Fulton | Ohio | 39051 | 10130 | 164 |
2189294 | 2189294 | 2022-02-06 | Gallia | Ohio | 39053 | 6954 | 102 |
2189295 | 2189295 | 2022-02-06 | Geauga | Ohio | 39055 | 15746 | 247 |
2189296 | 2189296 | 2022-02-06 | Greene | Ohio | 39057 | 36241 | 453 |
2189297 | 2189297 | 2022-02-06 | Guernsey | Ohio | 39059 | 10147 | 132 |
2189298 | 2189298 | 2022-02-06 | Hamilton | Ohio | 39061 | 182955 | 1840 |
2189299 | 2189299 | 2022-02-06 | Hancock | Ohio | 39063 | 16752 | 248 |
2189300 | 2189300 | 2022-02-06 | Hardin | Ohio | 39065 | 6911 | 138 |
2189301 | 2189301 | 2022-02-06 | Harrison | Ohio | 39067 | 3152 | 67 |
2189302 | 2189302 | 2022-02-06 | Henry | Ohio | 39069 | 6297 | 98 |
2189303 | 2189303 | 2022-02-06 | Highland | Ohio | 39071 | 10365 | 163 |
2189304 | 2189304 | 2022-02-06 | Hocking | Ohio | 39073 | 6326 | 109 |
2189305 | 2189305 | 2022-02-06 | Holmes | Ohio | 39075 | 5007 | 172 |
2189306 | 2189306 | 2022-02-06 | Huron | Ohio | 39077 | 14242 | 210 |
2189307 | 2189307 | 2022-02-06 | Jackson | Ohio | 39079 | 8440 | 127 |
2189308 | 2189308 | 2022-02-06 | Jefferson | Ohio | 39081 | 14297 | 281 |
2189309 | 2189309 | 2022-02-06 | Knox | Ohio | 39083 | 12760 | 213 |
2189310 | 2189310 | 2022-02-06 | Lake | Ohio | 39085 | 48162 | 666 |
2189311 | 2189311 | 2022-02-06 | Lawrence | Ohio | 39087 | 16760 | 198 |
2189312 | 2189312 | 2022-02-06 | Licking | Ohio | 39089 | 40358 | 434 |
2189313 | 2189313 | 2022-02-06 | Logan | Ohio | 39091 | 9925 | 151 |
2189314 | 2189314 | 2022-02-06 | Lorain | Ohio | 39093 | 65242 | 893 |
2189315 | 2189315 | 2022-02-06 | Lucas | Ohio | 39095 | 96946 | 1219 |
2189316 | 2189316 | 2022-02-06 | Madison | Ohio | 39097 | 9440 | 121 |
2189317 | 2189317 | 2022-02-06 | Mahoning | Ohio | 39099 | 52418 | 999 |
2189318 | 2189318 | 2022-02-06 | Marion | Ohio | 39101 | 19376 | 244 |
2189319 | 2189319 | 2022-02-06 | Medina | Ohio | 39103 | 39418 | 460 |
2189320 | 2189320 | 2022-02-06 | Meigs | Ohio | 39105 | 4302 | 76 |
2189321 | 2189321 | 2022-02-06 | Mercer | Ohio | 39107 | 9482 | 117 |
2189322 | 2189322 | 2022-02-06 | Miami | Ohio | 39109 | 25269 | 435 |
2189323 | 2189323 | 2022-02-06 | Monroe | Ohio | 39111 | 3358 | 69 |
2189324 | 2189324 | 2022-02-06 | Montgomery | Ohio | 39113 | 123872 | 1762 |
2189325 | 2189325 | 2022-02-06 | Morgan | Ohio | 39115 | 3115 | 50 |
2189326 | 2189326 | 2022-02-06 | Morrow | Ohio | 39117 | 7562 | 88 |
2189327 | 2189327 | 2022-02-06 | Muskingum | Ohio | 39119 | 24631 | 264 |
2189328 | 2189328 | 2022-02-06 | Noble | Ohio | 39121 | 3121 | 53 |
2189329 | 2189329 | 2022-02-06 | Ottawa | Ohio | 39123 | 8218 | 129 |
2189330 | 2189330 | 2022-02-06 | Paulding | Ohio | 39125 | 4520 | 68 |
2189331 | 2189331 | 2022-02-06 | Perry | Ohio | 39127 | 7940 | 112 |
2189332 | 2189332 | 2022-02-06 | Pickaway | Ohio | 39129 | 17087 | 201 |
2189333 | 2189333 | 2022-02-06 | Pike | Ohio | 39131 | 7140 | 94 |
2189334 | 2189334 | 2022-02-06 | Portage | Ohio | 39133 | 33202 | 406 |
2189335 | 2189335 | 2022-02-06 | Preble | Ohio | 39135 | 9136 | 179 |
2189336 | 2189336 | 2022-02-06 | Putnam | Ohio | 39137 | 8326 | 140 |
2189337 | 2189337 | 2022-02-06 | Richland | Ohio | 39139 | 30742 | 468 |
2189338 | 2189338 | 2022-02-06 | Ross | Ohio | 39141 | 18609 | 267 |
2189339 | 2189339 | 2022-02-06 | Sandusky | Ohio | 39143 | 13702 | 213 |
2189340 | 2189340 | 2022-02-06 | Scioto | Ohio | 39145 | 19659 | 222 |
2189341 | 2189341 | 2022-02-06 | Seneca | Ohio | 39147 | 12478 | 215 |
2189342 | 2189342 | 2022-02-06 | Shelby | Ohio | 39149 | 10855 | 169 |
2189343 | 2189343 | 2022-02-06 | Stark | Ohio | 39151 | 78697 | 1565 |
2189344 | 2189344 | 2022-02-06 | Summit | Ohio | 39153 | 110624 | 1520 |
2189345 | 2189345 | 2022-02-06 | Trumbull | Ohio | 39155 | 40675 | 847 |
2189346 | 2189346 | 2022-02-06 | Tuscarawas | Ohio | 39157 | 20191 | 462 |
2189347 | 2189347 | 2022-02-06 | Union | Ohio | 39159 | 15082 | 87 |
2189348 | 2189348 | 2022-02-06 | Unknown | Ohio | 0 | 5 | |
2189349 | 2189349 | 2022-02-06 | Van Wert | Ohio | 39161 | 6400 | 128 |
2189350 | 2189350 | 2022-02-06 | Vinton | Ohio | 39163 | 2788 | 51 |
2189351 | 2189351 | 2022-02-06 | Warren | Ohio | 39165 | 56133 | 517 |
2189352 | 2189352 | 2022-02-06 | Washington | Ohio | 39167 | 11951 | 176 |
2189353 | 2189353 | 2022-02-06 | Wayne | Ohio | 39169 | 22752 | 396 |
2189354 | 2189354 | 2022-02-06 | Williams | Ohio | 39171 | 8758 | 150 |
2189355 | 2189355 | 2022-02-06 | Wood | Ohio | 39173 | 30572 | 311 |
2189356 | 2189356 | 2022-02-06 | Wyandot | Ohio | 39175 | 5271 | 96 |
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);