ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where date = "2021-05-21" 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 |
---|---|---|---|---|---|---|---|
1341289 | 1341289 | 2021-05-21 | Adams | Ohio | 39001 | 2403 | 54 |
1341290 | 1341290 | 2021-05-21 | Allen | Ohio | 39003 | 11776 | 233 |
1341291 | 1341291 | 2021-05-21 | Ashland | Ohio | 39005 | 4297 | 92 |
1341292 | 1341292 | 2021-05-21 | Ashtabula | Ohio | 39007 | 6958 | 174 |
1341293 | 1341293 | 2021-05-21 | Athens | Ohio | 39009 | 5208 | 59 |
1341294 | 1341294 | 2021-05-21 | Auglaize | Ohio | 39011 | 4962 | 87 |
1341295 | 1341295 | 2021-05-21 | Belmont | Ohio | 39013 | 6040 | 171 |
1341296 | 1341296 | 2021-05-21 | Brown | Ohio | 39015 | 3984 | 58 |
1341297 | 1341297 | 2021-05-21 | Butler | Ohio | 39017 | 38641 | 590 |
1341298 | 1341298 | 2021-05-21 | Carroll | Ohio | 39019 | 1931 | 48 |
1341299 | 1341299 | 2021-05-21 | Champaign | Ohio | 39021 | 3378 | 58 |
1341300 | 1341300 | 2021-05-21 | Clark | Ohio | 39023 | 14141 | 301 |
1341301 | 1341301 | 2021-05-21 | Clermont | Ohio | 39025 | 19928 | 247 |
1341302 | 1341302 | 2021-05-21 | Clinton | Ohio | 39027 | 3755 | 64 |
1341303 | 1341303 | 2021-05-21 | Columbiana | Ohio | 39029 | 8918 | 229 |
1341304 | 1341304 | 2021-05-21 | Coshocton | Ohio | 39031 | 2672 | 57 |
1341305 | 1341305 | 2021-05-21 | Crawford | Ohio | 39033 | 4004 | 110 |
1341306 | 1341306 | 2021-05-21 | Cuyahoga | Ohio | 39035 | 113913 | 2153 |
1341307 | 1341307 | 2021-05-21 | Darke | Ohio | 39037 | 5381 | 126 |
1341308 | 1341308 | 2021-05-21 | Defiance | Ohio | 39039 | 4266 | 97 |
1341309 | 1341309 | 2021-05-21 | Delaware | Ohio | 39041 | 18645 | 133 |
1341310 | 1341310 | 2021-05-21 | Erie | Ohio | 39043 | 7992 | 158 |
1341311 | 1341311 | 2021-05-21 | Fairfield | Ohio | 39045 | 16375 | 202 |
1341312 | 1341312 | 2021-05-21 | Fayette | Ohio | 39047 | 2839 | 50 |
1341313 | 1341313 | 2021-05-21 | Franklin | Ohio | 39049 | 127205 | 1423 |
1341314 | 1341314 | 2021-05-21 | Fulton | Ohio | 39051 | 4286 | 70 |
1341315 | 1341315 | 2021-05-21 | Gallia | Ohio | 39053 | 2378 | 49 |
1341316 | 1341316 | 2021-05-21 | Geauga | Ohio | 39055 | 6768 | 149 |
1341317 | 1341317 | 2021-05-21 | Greene | Ohio | 39057 | 15166 | 246 |
1341318 | 1341318 | 2021-05-21 | Guernsey | Ohio | 39059 | 3199 | 53 |
1341319 | 1341319 | 2021-05-21 | Hamilton | Ohio | 39061 | 80641 | 1226 |
1341320 | 1341320 | 2021-05-21 | Hancock | Ohio | 39063 | 6975 | 130 |
1341321 | 1341321 | 2021-05-21 | Hardin | Ohio | 39065 | 2728 | 64 |
1341322 | 1341322 | 2021-05-21 | Harrison | Ohio | 39067 | 1106 | 37 |
1341323 | 1341323 | 2021-05-21 | Henry | Ohio | 39069 | 2713 | 67 |
1341324 | 1341324 | 2021-05-21 | Highland | Ohio | 39071 | 3572 | 62 |
1341325 | 1341325 | 2021-05-21 | Hocking | Ohio | 39073 | 2173 | 62 |
1341326 | 1341326 | 2021-05-21 | Holmes | Ohio | 39075 | 2633 | 101 |
1341327 | 1341327 | 2021-05-21 | Huron | Ohio | 39077 | 5479 | 120 |
1341328 | 1341328 | 2021-05-21 | Jackson | Ohio | 39079 | 3146 | 52 |
1341329 | 1341329 | 2021-05-21 | Jefferson | Ohio | 39081 | 5607 | 153 |
1341330 | 1341330 | 2021-05-21 | Knox | Ohio | 39083 | 4522 | 110 |
1341331 | 1341331 | 2021-05-21 | Lake | Ohio | 39085 | 20928 | 373 |
1341332 | 1341332 | 2021-05-21 | Lawrence | Ohio | 39087 | 5614 | 103 |
1341333 | 1341333 | 2021-05-21 | Licking | Ohio | 39089 | 16539 | 214 |
1341334 | 1341334 | 2021-05-21 | Logan | Ohio | 39091 | 3843 | 76 |
1341335 | 1341335 | 2021-05-21 | Lorain | Ohio | 39093 | 25319 | 489 |
1341336 | 1341336 | 2021-05-21 | Lucas | Ohio | 39095 | 42817 | 793 |
1341337 | 1341337 | 2021-05-21 | Madison | Ohio | 39097 | 4411 | 63 |
1341338 | 1341338 | 2021-05-21 | Mahoning | Ohio | 39099 | 21940 | 591 |
1341339 | 1341339 | 2021-05-21 | Marion | Ohio | 39101 | 8575 | 136 |
1341340 | 1341340 | 2021-05-21 | Medina | Ohio | 39103 | 15441 | 268 |
1341341 | 1341341 | 2021-05-21 | Meigs | Ohio | 39105 | 1462 | 40 |
1341342 | 1341342 | 2021-05-21 | Mercer | Ohio | 39107 | 4829 | 85 |
1341343 | 1341343 | 2021-05-21 | Miami | Ohio | 39109 | 10737 | 221 |
1341344 | 1341344 | 2021-05-21 | Monroe | Ohio | 39111 | 1329 | 42 |
1341345 | 1341345 | 2021-05-21 | Montgomery | Ohio | 39113 | 51977 | 1023 |
1341346 | 1341346 | 2021-05-21 | Morgan | Ohio | 39115 | 1089 | 24 |
1341347 | 1341347 | 2021-05-21 | Morrow | Ohio | 39117 | 2883 | 39 |
1341348 | 1341348 | 2021-05-21 | Muskingum | Ohio | 39119 | 8843 | 134 |
1341349 | 1341349 | 2021-05-21 | Noble | Ohio | 39121 | 1344 | 38 |
1341350 | 1341350 | 2021-05-21 | Ottawa | Ohio | 39123 | 3705 | 81 |
1341351 | 1341351 | 2021-05-21 | Paulding | Ohio | 39125 | 1750 | 41 |
1341352 | 1341352 | 2021-05-21 | Perry | Ohio | 39127 | 2961 | 50 |
1341353 | 1341353 | 2021-05-21 | Pickaway | Ohio | 39129 | 8610 | 121 |
1341354 | 1341354 | 2021-05-21 | Pike | Ohio | 39131 | 2395 | 34 |
1341355 | 1341355 | 2021-05-21 | Portage | Ohio | 39133 | 13037 | 210 |
1341356 | 1341356 | 2021-05-21 | Preble | Ohio | 39135 | 3823 | 101 |
1341357 | 1341357 | 2021-05-21 | Putnam | Ohio | 39137 | 4314 | 101 |
1341358 | 1341358 | 2021-05-21 | Richland | Ohio | 39139 | 11480 | 208 |
1341359 | 1341359 | 2021-05-21 | Ross | Ohio | 39141 | 6893 | 157 |
1341360 | 1341360 | 2021-05-21 | Sandusky | Ohio | 39143 | 5400 | 123 |
1341361 | 1341361 | 2021-05-21 | Scioto | Ohio | 39145 | 6474 | 103 |
1341362 | 1341362 | 2021-05-21 | Seneca | Ohio | 39147 | 5320 | 123 |
1341363 | 1341363 | 2021-05-21 | Shelby | Ohio | 39149 | 4716 | 93 |
1341364 | 1341364 | 2021-05-21 | Stark | Ohio | 39151 | 32868 | 914 |
1341365 | 1341365 | 2021-05-21 | Summit | Ohio | 39153 | 47828 | 970 |
1341366 | 1341366 | 2021-05-21 | Trumbull | Ohio | 39155 | 16287 | 473 |
1341367 | 1341367 | 2021-05-21 | Tuscarawas | Ohio | 39157 | 8533 | 245 |
1341368 | 1341368 | 2021-05-21 | Union | Ohio | 39159 | 5781 | 49 |
1341369 | 1341369 | 2021-05-21 | Unknown | Ohio | 0 | 2 | |
1341370 | 1341370 | 2021-05-21 | Van Wert | Ohio | 39161 | 2445 | 64 |
1341371 | 1341371 | 2021-05-21 | Vinton | Ohio | 39163 | 850 | 16 |
1341372 | 1341372 | 2021-05-21 | Warren | Ohio | 39165 | 24448 | 303 |
1341373 | 1341373 | 2021-05-21 | Washington | Ohio | 39167 | 5244 | 109 |
1341374 | 1341374 | 2021-05-21 | Wayne | Ohio | 39169 | 8984 | 216 |
1341375 | 1341375 | 2021-05-21 | Williams | Ohio | 39171 | 3444 | 77 |
1341376 | 1341376 | 2021-05-21 | Wood | Ohio | 39173 | 13201 | 192 |
1341377 | 1341377 | 2021-05-21 | Wyandot | Ohio | 39175 | 2331 | 56 |
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);