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 394
- 39151 392
- 39155 391
- 39013 389
- 39017 389
- 39049 389
- 39093 389
- 39153 389
- 39157 389
- 39095 388
- 39103 388
- 39055 387
- 39031 386
- 39037 386
- 39085 386
- 39099 386
- 39005 385
- 39023 385
- 39041 385
- 39077 385
- 39109 385
- 39061 384
- 39113 384
- 39139 384
- 39007 383
- 39029 383
- 39101 383
- 39159 383
- 39165 383
- 39025 382
- …
county >30
- Cuyahoga 394
- Stark 392
- Trumbull 391
- Belmont 389
- Butler 389
- Franklin 389
- Lorain 389
- Summit 389
- Tuscarawas 389
- Lucas 388
- Medina 388
- Geauga 387
- Coshocton 386
- Darke 386
- Lake 386
- Mahoning 386
- Ashland 385
- Clark 385
- Delaware 385
- Huron 385
- Miami 385
- Hamilton 384
- Montgomery 384
- Richland 384
- Ashtabula 383
- Columbiana 383
- Marion 383
- Union 383
- Warren 383
- Clermont 382
- …
state 1
- Ohio · 33,323 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195169 | 1195169 | 2021-04-06 | Adams | Ohio | 39001 | 2255 | 51 |
1195170 | 1195170 | 2021-04-06 | Allen | Ohio | 39003 | 11128 | 228 |
1195171 | 1195171 | 2021-04-06 | Ashland | Ohio | 39005 | 4063 | 86 |
1195172 | 1195172 | 2021-04-06 | Ashtabula | Ohio | 39007 | 6293 | 161 |
1195173 | 1195173 | 2021-04-06 | Athens | Ohio | 39009 | 4887 | 54 |
1195174 | 1195174 | 2021-04-06 | Auglaize | Ohio | 39011 | 4677 | 84 |
1195175 | 1195175 | 2021-04-06 | Belmont | Ohio | 39013 | 5448 | 158 |
1195176 | 1195176 | 2021-04-06 | Brown | Ohio | 39015 | 3829 | 55 |
1195177 | 1195177 | 2021-04-06 | Butler | Ohio | 39017 | 37227 | 563 |
1195178 | 1195178 | 2021-04-06 | Carroll | Ohio | 39019 | 1870 | 46 |
1195179 | 1195179 | 2021-04-06 | Champaign | Ohio | 39021 | 3121 | 55 |
1195180 | 1195180 | 2021-04-06 | Clark | Ohio | 39023 | 13319 | 286 |
1195181 | 1195181 | 2021-04-06 | Clermont | Ohio | 39025 | 19222 | 223 |
1195182 | 1195182 | 2021-04-06 | Clinton | Ohio | 39027 | 3555 | 59 |
1195183 | 1195183 | 2021-04-06 | Columbiana | Ohio | 39029 | 8419 | 222 |
1195184 | 1195184 | 2021-04-06 | Coshocton | Ohio | 39031 | 2553 | 57 |
1195185 | 1195185 | 2021-04-06 | Crawford | Ohio | 39033 | 3784 | 100 |
1195186 | 1195186 | 2021-04-06 | Cuyahoga | Ohio | 39035 | 103578 | 2029 |
1195187 | 1195187 | 2021-04-06 | Darke | Ohio | 39037 | 5184 | 121 |
1195188 | 1195188 | 2021-04-06 | Defiance | Ohio | 39039 | 3911 | 95 |
1195189 | 1195189 | 2021-04-06 | Delaware | Ohio | 39041 | 17630 | 129 |
1195190 | 1195190 | 2021-04-06 | Erie | Ohio | 39043 | 7352 | 153 |
1195191 | 1195191 | 2021-04-06 | Fairfield | Ohio | 39045 | 15347 | 195 |
1195192 | 1195192 | 2021-04-06 | Fayette | Ohio | 39047 | 2757 | 48 |
1195193 | 1195193 | 2021-04-06 | Franklin | Ohio | 39049 | 119303 | 1339 |
1195194 | 1195194 | 2021-04-06 | Fulton | Ohio | 39051 | 3989 | 64 |
1195195 | 1195195 | 2021-04-06 | Gallia | Ohio | 39053 | 2313 | 44 |
1195196 | 1195196 | 2021-04-06 | Geauga | Ohio | 39055 | 6401 | 145 |
1195197 | 1195197 | 2021-04-06 | Greene | Ohio | 39057 | 14341 | 233 |
1195198 | 1195198 | 2021-04-06 | Guernsey | Ohio | 39059 | 3023 | 48 |
1195199 | 1195199 | 2021-04-06 | Hamilton | Ohio | 39061 | 76986 | 1160 |
1195200 | 1195200 | 2021-04-06 | Hancock | Ohio | 39063 | 6483 | 122 |
1195201 | 1195201 | 2021-04-06 | Hardin | Ohio | 39065 | 2594 | 63 |
1195202 | 1195202 | 2021-04-06 | Harrison | Ohio | 39067 | 1043 | 36 |
1195203 | 1195203 | 2021-04-06 | Henry | Ohio | 39069 | 2592 | 65 |
1195204 | 1195204 | 2021-04-06 | Highland | Ohio | 39071 | 3442 | 58 |
1195205 | 1195205 | 2021-04-06 | Hocking | Ohio | 39073 | 2064 | 57 |
1195206 | 1195206 | 2021-04-06 | Holmes | Ohio | 39075 | 2494 | 100 |
1195207 | 1195207 | 2021-04-06 | Huron | Ohio | 39077 | 5178 | 111 |
1195208 | 1195208 | 2021-04-06 | Jackson | Ohio | 39079 | 3021 | 51 |
1195209 | 1195209 | 2021-04-06 | Jefferson | Ohio | 39081 | 5141 | 146 |
1195210 | 1195210 | 2021-04-06 | Knox | Ohio | 39083 | 4285 | 108 |
1195211 | 1195211 | 2021-04-06 | Lake | Ohio | 39085 | 19494 | 357 |
1195212 | 1195212 | 2021-04-06 | Lawrence | Ohio | 39087 | 5417 | 98 |
1195213 | 1195213 | 2021-04-06 | Licking | Ohio | 39089 | 15865 | 203 |
1195214 | 1195214 | 2021-04-06 | Logan | Ohio | 39091 | 3689 | 76 |
1195215 | 1195215 | 2021-04-06 | Lorain | Ohio | 39093 | 23511 | 465 |
1195216 | 1195216 | 2021-04-06 | Lucas | Ohio | 39095 | 38545 | 752 |
1195217 | 1195217 | 2021-04-06 | Madison | Ohio | 39097 | 4106 | 57 |
1195218 | 1195218 | 2021-04-06 | Mahoning | Ohio | 39099 | 20463 | 577 |
1195219 | 1195219 | 2021-04-06 | Marion | Ohio | 39101 | 8261 | 135 |
1195220 | 1195220 | 2021-04-06 | Medina | Ohio | 39103 | 14525 | 255 |
1195221 | 1195221 | 2021-04-06 | Meigs | Ohio | 39105 | 1397 | 38 |
1195222 | 1195222 | 2021-04-06 | Mercer | Ohio | 39107 | 4660 | 84 |
1195223 | 1195223 | 2021-04-06 | Miami | Ohio | 39109 | 10394 | 210 |
1195224 | 1195224 | 2021-04-06 | Monroe | Ohio | 39111 | 1277 | 41 |
1195225 | 1195225 | 2021-04-06 | Montgomery | Ohio | 39113 | 49160 | 983 |
1195226 | 1195226 | 2021-04-06 | Morgan | Ohio | 39115 | 1047 | 22 |
1195227 | 1195227 | 2021-04-06 | Morrow | Ohio | 39117 | 2714 | 39 |
1195228 | 1195228 | 2021-04-06 | Muskingum | Ohio | 39119 | 8568 | 127 |
1195229 | 1195229 | 2021-04-06 | Noble | Ohio | 39121 | 1315 | 37 |
1195230 | 1195230 | 2021-04-06 | Ottawa | Ohio | 39123 | 3475 | 77 |
1195231 | 1195231 | 2021-04-06 | Paulding | Ohio | 39125 | 1672 | 38 |
1195232 | 1195232 | 2021-04-06 | Perry | Ohio | 39127 | 2836 | 49 |
1195233 | 1195233 | 2021-04-06 | Pickaway | Ohio | 39129 | 8355 | 120 |
1195234 | 1195234 | 2021-04-06 | Pike | Ohio | 39131 | 2287 | 30 |
1195235 | 1195235 | 2021-04-06 | Portage | Ohio | 39133 | 12008 | 192 |
1195236 | 1195236 | 2021-04-06 | Preble | Ohio | 39135 | 3656 | 94 |
1195237 | 1195237 | 2021-04-06 | Putnam | Ohio | 39137 | 4141 | 98 |
1195238 | 1195238 | 2021-04-06 | Richland | Ohio | 39139 | 10793 | 197 |
1195239 | 1195239 | 2021-04-06 | Ross | Ohio | 39141 | 6574 | 144 |
1195240 | 1195240 | 2021-04-06 | Sandusky | Ohio | 39143 | 5034 | 117 |
1195241 | 1195241 | 2021-04-06 | Scioto | Ohio | 39145 | 6233 | 96 |
1195242 | 1195242 | 2021-04-06 | Seneca | Ohio | 39147 | 4989 | 113 |
1195243 | 1195243 | 2021-04-06 | Shelby | Ohio | 39149 | 4516 | 89 |
1195244 | 1195244 | 2021-04-06 | Stark | Ohio | 39151 | 30889 | 889 |
1195245 | 1195245 | 2021-04-06 | Summit | Ohio | 39153 | 43976 | 904 |
1195246 | 1195246 | 2021-04-06 | Trumbull | Ohio | 39155 | 15215 | 456 |
1195247 | 1195247 | 2021-04-06 | Tuscarawas | Ohio | 39157 | 8286 | 239 |
1195248 | 1195248 | 2021-04-06 | Union | Ohio | 39159 | 5476 | 47 |
1195249 | 1195249 | 2021-04-06 | Unknown | Ohio | 0 | 1 | |
1195250 | 1195250 | 2021-04-06 | Van Wert | Ohio | 39161 | 2357 | 60 |
1195251 | 1195251 | 2021-04-06 | Vinton | Ohio | 39163 | 798 | 13 |
1195252 | 1195252 | 2021-04-06 | Warren | Ohio | 39165 | 23555 | 291 |
1195253 | 1195253 | 2021-04-06 | Washington | Ohio | 39167 | 5009 | 105 |
1195254 | 1195254 | 2021-04-06 | Wayne | Ohio | 39169 | 8379 | 209 |
1195255 | 1195255 | 2021-04-06 | Williams | Ohio | 39171 | 3141 | 74 |
1195256 | 1195256 | 2021-04-06 | Wood | Ohio | 39173 | 12412 | 182 |
1195257 | 1195257 | 2021-04-06 | Wyandot | Ohio | 39175 | 2228 | 53 |
1191921 | 1191921 | 2021-04-05 | Adams | Ohio | 39001 | 2253 | 49 |
1191922 | 1191922 | 2021-04-05 | Allen | Ohio | 39003 | 11123 | 228 |
1191923 | 1191923 | 2021-04-05 | Ashland | Ohio | 39005 | 4058 | 86 |
1191924 | 1191924 | 2021-04-05 | Ashtabula | Ohio | 39007 | 6286 | 158 |
1191925 | 1191925 | 2021-04-05 | Athens | Ohio | 39009 | 4874 | 53 |
1191926 | 1191926 | 2021-04-05 | Auglaize | Ohio | 39011 | 4671 | 84 |
1191927 | 1191927 | 2021-04-05 | Belmont | Ohio | 39013 | 5439 | 158 |
1191928 | 1191928 | 2021-04-05 | Brown | Ohio | 39015 | 3825 | 55 |
1191929 | 1191929 | 2021-04-05 | Butler | Ohio | 39017 | 37179 | 560 |
1191930 | 1191930 | 2021-04-05 | Carroll | Ohio | 39019 | 1870 | 45 |
1191931 | 1191931 | 2021-04-05 | Champaign | Ohio | 39021 | 3120 | 53 |
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);