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 309
- 39151 307
- 39155 306
- 39049 304
- 39093 304
- 39153 304
- 39157 304
- 39013 303
- 39017 303
- 39095 303
- 39103 303
- 39055 302
- 39031 301
- 39037 301
- 39085 301
- 39099 301
- 39041 300
- 39077 300
- 39109 300
- 39005 299
- 39023 299
- 39061 299
- 39113 299
- 39139 299
- 39029 298
- 39101 298
- 39159 298
- 39165 298
- 39007 297
- 39025 297
- …
county >30
- Cuyahoga 309
- Stark 307
- Trumbull 306
- Franklin 304
- Lorain 304
- Summit 304
- Tuscarawas 304
- Belmont 303
- Butler 303
- Lucas 303
- Medina 303
- Geauga 302
- Coshocton 301
- Darke 301
- Lake 301
- Mahoning 301
- Delaware 300
- Huron 300
- Miami 300
- Ashland 299
- Clark 299
- Hamilton 299
- Montgomery 299
- Richland 299
- Columbiana 298
- Marion 298
- Union 298
- Warren 298
- Ashtabula 297
- Clermont 297
- …
state 1
- Ohio · 25,798 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919264 | 919264 | 2021-01-11 | Clermont | Ohio | 39025 | 14238 | 93 |
919265 | 919265 | 2021-01-11 | Clinton | Ohio | 39027 | 2637 | 40 |
919266 | 919266 | 2021-01-11 | Columbiana | Ohio | 39029 | 6699 | 122 |
919267 | 919267 | 2021-01-11 | Coshocton | Ohio | 39031 | 1897 | 17 |
919268 | 919268 | 2021-01-11 | Crawford | Ohio | 39033 | 2965 | 66 |
919269 | 919269 | 2021-01-11 | Cuyahoga | Ohio | 39035 | 78231 | 955 |
919270 | 919270 | 2021-01-11 | Darke | Ohio | 39037 | 4429 | 87 |
919271 | 919271 | 2021-01-11 | Defiance | Ohio | 39039 | 3034 | 68 |
919272 | 919272 | 2021-01-11 | Delaware | Ohio | 39041 | 13100 | 73 |
919273 | 919273 | 2021-01-11 | Erie | Ohio | 39043 | 5567 | 113 |
919274 | 919274 | 2021-01-11 | Fairfield | Ohio | 39045 | 11418 | 79 |
919275 | 919275 | 2021-01-11 | Fayette | Ohio | 39047 | 2101 | 29 |
919276 | 919276 | 2021-01-11 | Franklin | Ohio | 39049 | 93057 | 701 |
919277 | 919277 | 2021-01-11 | Fulton | Ohio | 39051 | 3095 | 41 |
919278 | 919278 | 2021-01-11 | Gallia | Ohio | 39053 | 1825 | 25 |
919279 | 919279 | 2021-01-11 | Geauga | Ohio | 39055 | 4559 | 55 |
919280 | 919280 | 2021-01-11 | Greene | Ohio | 39057 | 10930 | 127 |
919281 | 919281 | 2021-01-11 | Guernsey | Ohio | 39059 | 2286 | 24 |
919282 | 919282 | 2021-01-11 | Hamilton | Ohio | 39061 | 57879 | 426 |
919283 | 919283 | 2021-01-11 | Hancock | Ohio | 39063 | 5160 | 85 |
919284 | 919284 | 2021-01-11 | Hardin | Ohio | 39065 | 1946 | 32 |
919285 | 919285 | 2021-01-11 | Harrison | Ohio | 39067 | 814 | 6 |
919286 | 919286 | 2021-01-11 | Henry | Ohio | 39069 | 2023 | 47 |
919287 | 919287 | 2021-01-11 | Highland | Ohio | 39071 | 2437 | 18 |
919288 | 919288 | 2021-01-11 | Hocking | Ohio | 39073 | 1530 | 22 |
919289 | 919289 | 2021-01-11 | Holmes | Ohio | 39075 | 2133 | 62 |
919290 | 919290 | 2021-01-11 | Huron | Ohio | 39077 | 3861 | 38 |
919291 | 919291 | 2021-01-11 | Jackson | Ohio | 39079 | 2434 | 37 |
919292 | 919292 | 2021-01-11 | Jefferson | Ohio | 39081 | 3805 | 64 |
919293 | 919293 | 2021-01-11 | Knox | Ohio | 39083 | 3193 | 22 |
919294 | 919294 | 2021-01-11 | Lake | Ohio | 39085 | 14461 | 126 |
919295 | 919295 | 2021-01-11 | Lawrence | Ohio | 39087 | 4038 | 49 |
919296 | 919296 | 2021-01-11 | Licking | Ohio | 39089 | 11997 | 127 |
919297 | 919297 | 2021-01-11 | Logan | Ohio | 39091 | 2757 | 28 |
919298 | 919298 | 2021-01-11 | Lorain | Ohio | 39093 | 17071 | 200 |
919299 | 919299 | 2021-01-11 | Lucas | Ohio | 39095 | 28841 | 559 |
919300 | 919300 | 2021-01-11 | Madison | Ohio | 39097 | 3244 | 27 |
919301 | 919301 | 2021-01-11 | Mahoning | Ohio | 39099 | 16104 | 325 |
919302 | 919302 | 2021-01-11 | Marion | Ohio | 39101 | 7121 | 111 |
919303 | 919303 | 2021-01-11 | Medina | Ohio | 39103 | 10551 | 167 |
919304 | 919304 | 2021-01-11 | Meigs | Ohio | 39105 | 961 | 21 |
919305 | 919305 | 2021-01-11 | Mercer | Ohio | 39107 | 4122 | 85 |
919306 | 919306 | 2021-01-11 | Miami | Ohio | 39109 | 8454 | 73 |
919307 | 919307 | 2021-01-11 | Monroe | Ohio | 39111 | 897 | 27 |
919308 | 919308 | 2021-01-11 | Montgomery | Ohio | 39113 | 39691 | 382 |
919309 | 919309 | 2021-01-11 | Morgan | Ohio | 39115 | 726 | 26 |
919310 | 919310 | 2021-01-11 | Morrow | Ohio | 39117 | 2103 | 4 |
919311 | 919311 | 2021-01-11 | Muskingum | Ohio | 39119 | 6251 | 39 |
919312 | 919312 | 2021-01-11 | Noble | Ohio | 39121 | 1129 | 35 |
919313 | 919313 | 2021-01-11 | Ottawa | Ohio | 39123 | 2689 | 34 |
919314 | 919314 | 2021-01-11 | Paulding | Ohio | 39125 | 1340 | 20 |
919315 | 919315 | 2021-01-11 | Perry | Ohio | 39127 | 2086 | 17 |
919316 | 919316 | 2021-01-11 | Pickaway | Ohio | 39129 | 6725 | 50 |
919317 | 919317 | 2021-01-11 | Pike | Ohio | 39131 | 1553 | 16 |
919318 | 919318 | 2021-01-11 | Portage | Ohio | 39133 | 8326 | 103 |
919319 | 919319 | 2021-01-11 | Preble | Ohio | 39135 | 2973 | 34 |
919320 | 919320 | 2021-01-11 | Putnam | Ohio | 39137 | 3523 | 70 |
919321 | 919321 | 2021-01-11 | Richland | Ohio | 39139 | 8386 | 104 |
919322 | 919322 | 2021-01-11 | Ross | Ohio | 39141 | 5033 | 87 |
919323 | 919323 | 2021-01-11 | Sandusky | Ohio | 39143 | 4036 | 59 |
919324 | 919324 | 2021-01-11 | Scioto | Ohio | 39145 | 4941 | 52 |
919325 | 919325 | 2021-01-11 | Seneca | Ohio | 39147 | 3943 | 49 |
919326 | 919326 | 2021-01-11 | Shelby | Ohio | 39149 | 3934 | 20 |
919327 | 919327 | 2021-01-11 | Stark | Ohio | 39151 | 23278 | 380 |
919328 | 919328 | 2021-01-11 | Summit | Ohio | 39153 | 31539 | 655 |
919329 | 919329 | 2021-01-11 | Trumbull | Ohio | 39155 | 11781 | 288 |
919330 | 919330 | 2021-01-11 | Tuscarawas | Ohio | 39157 | 6778 | 161 |
919331 | 919331 | 2021-01-11 | Union | Ohio | 39159 | 4103 | 23 |
919332 | 919332 | 2021-01-11 | Van Wert | Ohio | 39161 | 1901 | 43 |
919333 | 919333 | 2021-01-11 | Vinton | Ohio | 39163 | 605 | 13 |
919334 | 919334 | 2021-01-11 | Warren | Ohio | 39165 | 17861 | 128 |
919335 | 919335 | 2021-01-11 | Washington | Ohio | 39167 | 3447 | 39 |
919336 | 919336 | 2021-01-11 | Wayne | Ohio | 39169 | 6455 | 157 |
919337 | 919337 | 2021-01-11 | Williams | Ohio | 39171 | 2589 | 57 |
919338 | 919338 | 2021-01-11 | Wood | Ohio | 39173 | 9454 | 151 |
919339 | 919339 | 2021-01-11 | Wyandot | Ohio | 39175 | 1842 | 47 |
916007 | 916007 | 2021-01-10 | Adams | Ohio | 39001 | 1561 | 15 |
916008 | 916008 | 2021-01-10 | Allen | Ohio | 39003 | 9064 | 119 |
916009 | 916009 | 2021-01-10 | Ashland | Ohio | 39005 | 3089 | 38 |
916010 | 916010 | 2021-01-10 | Ashtabula | Ohio | 39007 | 4203 | 66 |
916011 | 916011 | 2021-01-10 | Athens | Ohio | 39009 | 3399 | 9 |
916012 | 916012 | 2021-01-10 | Auglaize | Ohio | 39011 | 3942 | 59 |
916013 | 916013 | 2021-01-10 | Belmont | Ohio | 39013 | 3609 | 38 |
916014 | 916014 | 2021-01-10 | Brown | Ohio | 39015 | 2776 | 15 |
916015 | 916015 | 2021-01-10 | Butler | Ohio | 39017 | 28128 | 211 |
916016 | 916016 | 2021-01-10 | Carroll | Ohio | 39019 | 1333 | 14 |
916017 | 916017 | 2021-01-10 | Champaign | Ohio | 39021 | 2222 | 24 |
916018 | 916018 | 2021-01-10 | Clark | Ohio | 39023 | 9945 | 248 |
916019 | 916019 | 2021-01-10 | Clermont | Ohio | 39025 | 14109 | 93 |
916020 | 916020 | 2021-01-10 | Clinton | Ohio | 39027 | 2622 | 40 |
916021 | 916021 | 2021-01-10 | Columbiana | Ohio | 39029 | 6651 | 122 |
916022 | 916022 | 2021-01-10 | Coshocton | Ohio | 39031 | 1867 | 17 |
916023 | 916023 | 2021-01-10 | Crawford | Ohio | 39033 | 2931 | 64 |
916024 | 916024 | 2021-01-10 | Cuyahoga | Ohio | 39035 | 77359 | 955 |
916025 | 916025 | 2021-01-10 | Darke | Ohio | 39037 | 4409 | 87 |
916026 | 916026 | 2021-01-10 | Defiance | Ohio | 39039 | 2982 | 68 |
916027 | 916027 | 2021-01-10 | Delaware | Ohio | 39041 | 12994 | 73 |
916028 | 916028 | 2021-01-10 | Erie | Ohio | 39043 | 5508 | 112 |
916029 | 916029 | 2021-01-10 | Fairfield | Ohio | 39045 | 11278 | 79 |
916030 | 916030 | 2021-01-10 | Fayette | Ohio | 39047 | 2075 | 29 |
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);