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 190
- 39151 188
- 39155 187
- 39049 185
- 39093 185
- 39153 185
- 39157 185
- 39013 184
- 39017 184
- 39095 184
- 39103 184
- 39055 183
- 39031 182
- 39037 182
- 39085 182
- 39099 182
- 39041 181
- 39077 181
- 39109 181
- 39005 180
- 39023 180
- 39061 180
- 39113 180
- 39139 180
- 39029 179
- 39101 179
- 39159 179
- 39165 179
- 39007 178
- 39025 178
- …
county >30
- Cuyahoga 190
- Stark 188
- Trumbull 187
- Franklin 185
- Lorain 185
- Summit 185
- Tuscarawas 185
- Belmont 184
- Butler 184
- Lucas 184
- Medina 184
- Geauga 183
- Coshocton 182
- Darke 182
- Lake 182
- Mahoning 182
- Delaware 181
- Huron 181
- Miami 181
- Ashland 180
- Clark 180
- Hamilton 180
- Montgomery 180
- Richland 180
- Columbiana 179
- Marion 179
- Union 179
- Warren 179
- Ashtabula 178
- Clermont 178
- …
state 1
- Ohio · 15,326 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
533252 | 533252 | 2020-09-14 | Clermont | Ohio | 39025 | 1518 | 18 |
533253 | 533253 | 2020-09-14 | Clinton | Ohio | 39027 | 273 | 13 |
533254 | 533254 | 2020-09-14 | Columbiana | Ohio | 39029 | 1897 | 71 |
533255 | 533255 | 2020-09-14 | Coshocton | Ohio | 39031 | 229 | 10 |
533256 | 533256 | 2020-09-14 | Crawford | Ohio | 39033 | 208 | 6 |
533257 | 533257 | 2020-09-14 | Cuyahoga | Ohio | 39035 | 16747 | 622 |
533258 | 533258 | 2020-09-14 | Darke | Ohio | 39037 | 726 | 37 |
533259 | 533259 | 2020-09-14 | Defiance | Ohio | 39039 | 258 | 9 |
533260 | 533260 | 2020-09-14 | Delaware | Ohio | 39041 | 1985 | 20 |
533261 | 533261 | 2020-09-14 | Erie | Ohio | 39043 | 848 | 43 |
533262 | 533262 | 2020-09-14 | Fairfield | Ohio | 39045 | 1941 | 44 |
533263 | 533263 | 2020-09-14 | Fayette | Ohio | 39047 | 219 | 5 |
533264 | 533264 | 2020-09-14 | Franklin | Ohio | 39049 | 24832 | 579 |
533265 | 533265 | 2020-09-14 | Fulton | Ohio | 39051 | 215 | 1 |
533266 | 533266 | 2020-09-14 | Gallia | Ohio | 39053 | 170 | 9 |
533267 | 533267 | 2020-09-14 | Geauga | Ohio | 39055 | 687 | 46 |
533268 | 533268 | 2020-09-14 | Greene | Ohio | 39057 | 1224 | 25 |
533269 | 533269 | 2020-09-14 | Guernsey | Ohio | 39059 | 151 | 7 |
533270 | 533270 | 2020-09-14 | Hamilton | Ohio | 39061 | 12306 | 292 |
533271 | 533271 | 2020-09-14 | Hancock | Ohio | 39063 | 615 | 7 |
533272 | 533272 | 2020-09-14 | Hardin | Ohio | 39065 | 248 | 13 |
533273 | 533273 | 2020-09-14 | Harrison | Ohio | 39067 | 49 | 1 |
533274 | 533274 | 2020-09-14 | Henry | Ohio | 39069 | 280 | 10 |
533275 | 533275 | 2020-09-14 | Highland | Ohio | 39071 | 212 | 3 |
533276 | 533276 | 2020-09-14 | Hocking | Ohio | 39073 | 154 | 9 |
533277 | 533277 | 2020-09-14 | Holmes | Ohio | 39075 | 364 | 7 |
533278 | 533278 | 2020-09-14 | Huron | Ohio | 39077 | 509 | 7 |
533279 | 533279 | 2020-09-14 | Jackson | Ohio | 39079 | 200 | 2 |
533280 | 533280 | 2020-09-14 | Jefferson | Ohio | 39081 | 306 | 4 |
533281 | 533281 | 2020-09-14 | Knox | Ohio | 39083 | 272 | 15 |
533282 | 533282 | 2020-09-14 | Lake | Ohio | 39085 | 1516 | 46 |
533283 | 533283 | 2020-09-14 | Lawrence | Ohio | 39087 | 544 | 18 |
533284 | 533284 | 2020-09-14 | Licking | Ohio | 39089 | 1792 | 59 |
533285 | 533285 | 2020-09-14 | Logan | Ohio | 39091 | 273 | 3 |
533286 | 533286 | 2020-09-14 | Lorain | Ohio | 39093 | 2211 | 85 |
533287 | 533287 | 2020-09-14 | Lucas | Ohio | 39095 | 6903 | 350 |
533288 | 533288 | 2020-09-14 | Madison | Ohio | 39097 | 748 | 11 |
533289 | 533289 | 2020-09-14 | Mahoning | Ohio | 39099 | 2960 | 274 |
533290 | 533290 | 2020-09-14 | Marion | Ohio | 39101 | 3040 | 46 |
533291 | 533291 | 2020-09-14 | Medina | Ohio | 39103 | 1373 | 38 |
533292 | 533292 | 2020-09-14 | Meigs | Ohio | 39105 | 163 | 6 |
533293 | 533293 | 2020-09-14 | Mercer | Ohio | 39107 | 976 | 17 |
533294 | 533294 | 2020-09-14 | Miami | Ohio | 39109 | 1259 | 48 |
533295 | 533295 | 2020-09-14 | Monroe | Ohio | 39111 | 106 | 18 |
533296 | 533296 | 2020-09-14 | Montgomery | Ohio | 39113 | 7148 | 144 |
533297 | 533297 | 2020-09-14 | Morgan | Ohio | 39115 | 46 | 0 |
533298 | 533298 | 2020-09-14 | Morrow | Ohio | 39117 | 243 | 2 |
533299 | 533299 | 2020-09-14 | Muskingum | Ohio | 39119 | 350 | 2 |
533300 | 533300 | 2020-09-14 | Noble | Ohio | 39121 | 23 | 0 |
533301 | 533301 | 2020-09-14 | Ottawa | Ohio | 39123 | 461 | 30 |
533302 | 533302 | 2020-09-14 | Paulding | Ohio | 39125 | 95 | 0 |
533303 | 533303 | 2020-09-14 | Perry | Ohio | 39127 | 271 | 9 |
533304 | 533304 | 2020-09-14 | Pickaway | Ohio | 39129 | 2606 | 44 |
533305 | 533305 | 2020-09-14 | Pike | Ohio | 39131 | 129 | 0 |
533306 | 533306 | 2020-09-14 | Portage | Ohio | 39133 | 1008 | 65 |
533307 | 533307 | 2020-09-14 | Preble | Ohio | 39135 | 403 | 10 |
533308 | 533308 | 2020-09-14 | Putnam | Ohio | 39137 | 481 | 18 |
533309 | 533309 | 2020-09-14 | Richland | Ohio | 39139 | 752 | 18 |
533310 | 533310 | 2020-09-14 | Ross | Ohio | 39141 | 827 | 19 |
533311 | 533311 | 2020-09-14 | Sandusky | Ohio | 39143 | 544 | 20 |
533312 | 533312 | 2020-09-14 | Scioto | Ohio | 39145 | 438 | 6 |
533313 | 533313 | 2020-09-14 | Seneca | Ohio | 39147 | 402 | 14 |
533314 | 533314 | 2020-09-14 | Shelby | Ohio | 39149 | 505 | 6 |
533315 | 533315 | 2020-09-14 | Stark | Ohio | 39151 | 2606 | 158 |
533316 | 533316 | 2020-09-14 | Summit | Ohio | 39153 | 4894 | 244 |
533317 | 533317 | 2020-09-14 | Trumbull | Ohio | 39155 | 1817 | 127 |
533318 | 533318 | 2020-09-14 | Tuscarawas | Ohio | 39157 | 892 | 19 |
533319 | 533319 | 2020-09-14 | Union | Ohio | 39159 | 443 | 2 |
533320 | 533320 | 2020-09-14 | Van Wert | Ohio | 39161 | 105 | 3 |
533321 | 533321 | 2020-09-14 | Vinton | Ohio | 39163 | 41 | 3 |
533322 | 533322 | 2020-09-14 | Warren | Ohio | 39165 | 2748 | 46 |
533323 | 533323 | 2020-09-14 | Washington | Ohio | 39167 | 241 | 23 |
533324 | 533324 | 2020-09-14 | Wayne | Ohio | 39169 | 881 | 65 |
533325 | 533325 | 2020-09-14 | Williams | Ohio | 39171 | 182 | 3 |
533326 | 533326 | 2020-09-14 | Wood | Ohio | 39173 | 1553 | 65 |
533327 | 533327 | 2020-09-14 | Wyandot | Ohio | 39175 | 198 | 11 |
530005 | 530005 | 2020-09-13 | Adams | Ohio | 39001 | 100 | 4 |
530006 | 530006 | 2020-09-13 | Allen | Ohio | 39003 | 1299 | 61 |
530007 | 530007 | 2020-09-13 | Ashland | Ohio | 39005 | 197 | 4 |
530008 | 530008 | 2020-09-13 | Ashtabula | Ohio | 39007 | 627 | 47 |
530009 | 530009 | 2020-09-13 | Athens | Ohio | 39009 | 508 | 2 |
530010 | 530010 | 2020-09-13 | Auglaize | Ohio | 39011 | 512 | 8 |
530011 | 530011 | 2020-09-13 | Belmont | Ohio | 39013 | 699 | 27 |
530012 | 530012 | 2020-09-13 | Brown | Ohio | 39015 | 256 | 2 |
530013 | 530013 | 2020-09-13 | Butler | Ohio | 39017 | 5266 | 88 |
530014 | 530014 | 2020-09-13 | Carroll | Ohio | 39019 | 139 | 7 |
530015 | 530015 | 2020-09-13 | Champaign | Ohio | 39021 | 278 | 3 |
530016 | 530016 | 2020-09-13 | Clark | Ohio | 39023 | 1615 | 36 |
530017 | 530017 | 2020-09-13 | Clermont | Ohio | 39025 | 1500 | 17 |
530018 | 530018 | 2020-09-13 | Clinton | Ohio | 39027 | 271 | 13 |
530019 | 530019 | 2020-09-13 | Columbiana | Ohio | 39029 | 1895 | 71 |
530020 | 530020 | 2020-09-13 | Coshocton | Ohio | 39031 | 228 | 10 |
530021 | 530021 | 2020-09-13 | Crawford | Ohio | 39033 | 208 | 6 |
530022 | 530022 | 2020-09-13 | Cuyahoga | Ohio | 39035 | 16698 | 622 |
530023 | 530023 | 2020-09-13 | Darke | Ohio | 39037 | 713 | 37 |
530024 | 530024 | 2020-09-13 | Defiance | Ohio | 39039 | 253 | 9 |
530025 | 530025 | 2020-09-13 | Delaware | Ohio | 39041 | 1967 | 20 |
530026 | 530026 | 2020-09-13 | Erie | Ohio | 39043 | 844 | 43 |
530027 | 530027 | 2020-09-13 | Fairfield | Ohio | 39045 | 1930 | 44 |
530028 | 530028 | 2020-09-13 | Fayette | Ohio | 39047 | 217 | 5 |
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);