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 264
- 39151 262
- 39155 261
- 39013 259
- 39017 259
- 39049 259
- 39093 259
- 39153 259
- 39157 259
- 39095 258
- 39103 258
- 39055 257
- 39031 256
- 39037 256
- 39085 256
- 39099 256
- 39005 255
- 39023 255
- 39041 255
- 39077 255
- 39109 255
- 39061 254
- 39113 254
- 39139 254
- 39007 253
- 39029 253
- 39101 253
- 39159 253
- 39165 253
- 39025 252
- …
county >30
- Cuyahoga 264
- Stark 262
- Trumbull 261
- Belmont 259
- Butler 259
- Franklin 259
- Lorain 259
- Summit 259
- Tuscarawas 259
- Lucas 258
- Medina 258
- Geauga 257
- Coshocton 256
- Darke 256
- Lake 256
- Mahoning 256
- Ashland 255
- Clark 255
- Delaware 255
- Huron 255
- Miami 255
- Hamilton 254
- Montgomery 254
- Richland 254
- Ashtabula 253
- Columbiana 253
- Marion 253
- Union 253
- Warren 253
- Clermont 252
- …
state 1
- Ohio · 21,850 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
773212 | 773212 | 2020-11-27 | Adams | Ohio | 39001 | 838 | 13 |
773213 | 773213 | 2020-11-27 | Allen | Ohio | 39003 | 5183 | 89 |
773214 | 773214 | 2020-11-27 | Ashland | Ohio | 39005 | 1173 | 28 |
773215 | 773215 | 2020-11-27 | Ashtabula | Ohio | 39007 | 2404 | 54 |
773216 | 773216 | 2020-11-27 | Athens | Ohio | 39009 | 1998 | 4 |
773217 | 773217 | 2020-11-27 | Auglaize | Ohio | 39011 | 2439 | 35 |
773218 | 773218 | 2020-11-27 | Belmont | Ohio | 39013 | 1767 | 29 |
773219 | 773219 | 2020-11-27 | Brown | Ohio | 39015 | 1075 | 5 |
773220 | 773220 | 2020-11-27 | Butler | Ohio | 39017 | 15768 | 149 |
773221 | 773221 | 2020-11-27 | Carroll | Ohio | 39019 | 532 | 10 |
773222 | 773222 | 2020-11-27 | Champaign | Ohio | 39021 | 1053 | 5 |
773223 | 773223 | 2020-11-27 | Clark | Ohio | 39023 | 5438 | 129 |
773224 | 773224 | 2020-11-27 | Clermont | Ohio | 39025 | 6229 | 53 |
773225 | 773225 | 2020-11-27 | Clinton | Ohio | 39027 | 1131 | 15 |
773226 | 773226 | 2020-11-27 | Columbiana | Ohio | 39029 | 3765 | 99 |
773227 | 773227 | 2020-11-27 | Coshocton | Ohio | 39031 | 910 | 15 |
773228 | 773228 | 2020-11-27 | Crawford | Ohio | 39033 | 1344 | 17 |
773229 | 773229 | 2020-11-27 | Cuyahoga | Ohio | 39035 | 39132 | 746 |
773230 | 773230 | 2020-11-27 | Darke | Ohio | 39037 | 2461 | 60 |
773231 | 773231 | 2020-11-27 | Defiance | Ohio | 39039 | 1499 | 23 |
773232 | 773232 | 2020-11-27 | Delaware | Ohio | 39041 | 5973 | 37 |
773233 | 773233 | 2020-11-27 | Erie | Ohio | 39043 | 2408 | 68 |
773234 | 773234 | 2020-11-27 | Fairfield | Ohio | 39045 | 5764 | 64 |
773235 | 773235 | 2020-11-27 | Fayette | Ohio | 39047 | 973 | 17 |
773236 | 773236 | 2020-11-27 | Franklin | Ohio | 39049 | 52652 | 672 |
773237 | 773237 | 2020-11-27 | Fulton | Ohio | 39051 | 1358 | 26 |
773238 | 773238 | 2020-11-27 | Gallia | Ohio | 39053 | 816 | 15 |
773239 | 773239 | 2020-11-27 | Geauga | Ohio | 39055 | 2270 | 51 |
773240 | 773240 | 2020-11-27 | Greene | Ohio | 39057 | 5595 | 68 |
773241 | 773241 | 2020-11-27 | Guernsey | Ohio | 39059 | 968 | 14 |
773242 | 773242 | 2020-11-27 | Hamilton | Ohio | 39061 | 31491 | 372 |
773243 | 773243 | 2020-11-27 | Hancock | Ohio | 39063 | 2572 | 40 |
773244 | 773244 | 2020-11-27 | Hardin | Ohio | 39065 | 1070 | 19 |
773245 | 773245 | 2020-11-27 | Harrison | Ohio | 39067 | 243 | 3 |
773246 | 773246 | 2020-11-27 | Henry | Ohio | 39069 | 1054 | 23 |
773247 | 773247 | 2020-11-27 | Highland | Ohio | 39071 | 1081 | 18 |
773248 | 773248 | 2020-11-27 | Hocking | Ohio | 39073 | 685 | 16 |
773249 | 773249 | 2020-11-27 | Holmes | Ohio | 39075 | 1469 | 39 |
773250 | 773250 | 2020-11-27 | Huron | Ohio | 39077 | 1630 | 22 |
773251 | 773251 | 2020-11-27 | Jackson | Ohio | 39079 | 1020 | 12 |
773252 | 773252 | 2020-11-27 | Jefferson | Ohio | 39081 | 1381 | 13 |
773253 | 773253 | 2020-11-27 | Knox | Ohio | 39083 | 1397 | 19 |
773254 | 773254 | 2020-11-27 | Lake | Ohio | 39085 | 7525 | 66 |
773255 | 773255 | 2020-11-27 | Lawrence | Ohio | 39087 | 2011 | 39 |
773256 | 773256 | 2020-11-27 | Licking | Ohio | 39089 | 5899 | 77 |
773257 | 773257 | 2020-11-27 | Logan | Ohio | 39091 | 1390 | 18 |
773258 | 773258 | 2020-11-27 | Lorain | Ohio | 39093 | 7149 | 106 |
773259 | 773259 | 2020-11-27 | Lucas | Ohio | 39095 | 15301 | 420 |
773260 | 773260 | 2020-11-27 | Madison | Ohio | 39097 | 1720 | 19 |
773261 | 773261 | 2020-11-27 | Mahoning | Ohio | 39099 | 7985 | 301 |
773262 | 773262 | 2020-11-27 | Marion | Ohio | 39101 | 4893 | 59 |
773263 | 773263 | 2020-11-27 | Medina | Ohio | 39103 | 4965 | 57 |
773264 | 773264 | 2020-11-27 | Meigs | Ohio | 39105 | 417 | 12 |
773265 | 773265 | 2020-11-27 | Mercer | Ohio | 39107 | 2992 | 48 |
773266 | 773266 | 2020-11-27 | Miami | Ohio | 39109 | 4562 | 68 |
773267 | 773267 | 2020-11-27 | Monroe | Ohio | 39111 | 349 | 21 |
773268 | 773268 | 2020-11-27 | Montgomery | Ohio | 39113 | 21355 | 242 |
773269 | 773269 | 2020-11-27 | Morgan | Ohio | 39115 | 292 | 5 |
773270 | 773270 | 2020-11-27 | Morrow | Ohio | 39117 | 968 | 2 |
773271 | 773271 | 2020-11-27 | Muskingum | Ohio | 39119 | 2625 | 10 |
773272 | 773272 | 2020-11-27 | Noble | Ohio | 39121 | 651 | 24 |
773273 | 773273 | 2020-11-27 | Ottawa | Ohio | 39123 | 1288 | 30 |
773274 | 773274 | 2020-11-27 | Paulding | Ohio | 39125 | 700 | 12 |
773275 | 773275 | 2020-11-27 | Perry | Ohio | 39127 | 866 | 13 |
773276 | 773276 | 2020-11-27 | Pickaway | Ohio | 39129 | 4105 | 48 |
773277 | 773277 | 2020-11-27 | Pike | Ohio | 39131 | 792 | 1 |
773278 | 773278 | 2020-11-27 | Portage | Ohio | 39133 | 3855 | 74 |
773279 | 773279 | 2020-11-27 | Preble | Ohio | 39135 | 1625 | 21 |
773280 | 773280 | 2020-11-27 | Putnam | Ohio | 39137 | 2345 | 49 |
773281 | 773281 | 2020-11-27 | Richland | Ohio | 39139 | 3496 | 39 |
773282 | 773282 | 2020-11-27 | Ross | Ohio | 39141 | 2512 | 59 |
773283 | 773283 | 2020-11-27 | Sandusky | Ohio | 39143 | 1664 | 29 |
773284 | 773284 | 2020-11-27 | Scioto | Ohio | 39145 | 2043 | 16 |
773285 | 773285 | 2020-11-27 | Seneca | Ohio | 39147 | 1929 | 19 |
773286 | 773286 | 2020-11-27 | Shelby | Ohio | 39149 | 1999 | 17 |
773287 | 773287 | 2020-11-27 | Stark | Ohio | 39151 | 9780 | 209 |
773288 | 773288 | 2020-11-27 | Summit | Ohio | 39153 | 14667 | 330 |
773289 | 773289 | 2020-11-27 | Trumbull | Ohio | 39155 | 5867 | 148 |
773290 | 773290 | 2020-11-27 | Tuscarawas | Ohio | 39157 | 3605 | 67 |
773291 | 773291 | 2020-11-27 | Union | Ohio | 39159 | 2083 | 8 |
773292 | 773292 | 2020-11-27 | Van Wert | Ohio | 39161 | 999 | 18 |
773293 | 773293 | 2020-11-27 | Vinton | Ohio | 39163 | 232 | 6 |
773294 | 773294 | 2020-11-27 | Warren | Ohio | 39165 | 8787 | 77 |
773295 | 773295 | 2020-11-27 | Washington | Ohio | 39167 | 1334 | 27 |
773296 | 773296 | 2020-11-27 | Wayne | Ohio | 39169 | 3408 | 94 |
773297 | 773297 | 2020-11-27 | Williams | Ohio | 39171 | 1147 | 9 |
773298 | 773298 | 2020-11-27 | Wood | Ohio | 39173 | 4861 | 108 |
773299 | 773299 | 2020-11-27 | Wyandot | Ohio | 39175 | 761 | 18 |
769967 | 769967 | 2020-11-26 | Adams | Ohio | 39001 | 803 | 13 |
769968 | 769968 | 2020-11-26 | Allen | Ohio | 39003 | 4949 | 89 |
769969 | 769969 | 2020-11-26 | Ashland | Ohio | 39005 | 1078 | 25 |
769970 | 769970 | 2020-11-26 | Ashtabula | Ohio | 39007 | 2283 | 54 |
769971 | 769971 | 2020-11-26 | Athens | Ohio | 39009 | 1913 | 4 |
769972 | 769972 | 2020-11-26 | Auglaize | Ohio | 39011 | 2364 | 35 |
769973 | 769973 | 2020-11-26 | Belmont | Ohio | 39013 | 1702 | 29 |
769974 | 769974 | 2020-11-26 | Brown | Ohio | 39015 | 1013 | 5 |
769975 | 769975 | 2020-11-26 | Butler | Ohio | 39017 | 15199 | 148 |
769976 | 769976 | 2020-11-26 | Carroll | Ohio | 39019 | 488 | 10 |
769977 | 769977 | 2020-11-26 | Champaign | Ohio | 39021 | 982 | 5 |
769978 | 769978 | 2020-11-26 | Clark | Ohio | 39023 | 5218 | 101 |
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);