ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where "date" is on date 2021-02-13 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1026353 | 1026353 | 2021-02-13 | Adams | Ohio | 39001 | 2104 | 27 |
1026354 | 1026354 | 2021-02-13 | Allen | Ohio | 39003 | 10589 | 225 |
1026355 | 1026355 | 2021-02-13 | Ashland | Ohio | 39005 | 3680 | 86 |
1026356 | 1026356 | 2021-02-13 | Ashtabula | Ohio | 39007 | 5327 | 134 |
1026357 | 1026357 | 2021-02-13 | Athens | Ohio | 39009 | 4403 | 30 |
1026358 | 1026358 | 2021-02-13 | Auglaize | Ohio | 39011 | 4488 | 95 |
1026359 | 1026359 | 2021-02-13 | Belmont | Ohio | 39013 | 4771 | 83 |
1026360 | 1026360 | 2021-02-13 | Brown | Ohio | 39015 | 3591 | 40 |
1026361 | 1026361 | 2021-02-13 | Butler | Ohio | 39017 | 34142 | 442 |
1026362 | 1026362 | 2021-02-13 | Carroll | Ohio | 39019 | 1751 | 25 |
1026363 | 1026363 | 2021-02-13 | Champaign | Ohio | 39021 | 2753 | 43 |
1026364 | 1026364 | 2021-02-13 | Clark | Ohio | 39023 | 11913 | 320 |
1026365 | 1026365 | 2021-02-13 | Clermont | Ohio | 39025 | 17701 | 198 |
1026366 | 1026366 | 2021-02-13 | Clinton | Ohio | 39027 | 3281 | 60 |
1026367 | 1026367 | 2021-02-13 | Columbiana | Ohio | 39029 | 7883 | 173 |
1026368 | 1026368 | 2021-02-13 | Coshocton | Ohio | 39031 | 2240 | 44 |
1026369 | 1026369 | 2021-02-13 | Crawford | Ohio | 39033 | 3482 | 95 |
1026370 | 1026370 | 2021-02-13 | Cuyahoga | Ohio | 39035 | 92500 | 1626 |
1026371 | 1026371 | 2021-02-13 | Darke | Ohio | 39037 | 4958 | 118 |
1026372 | 1026372 | 2021-02-13 | Defiance | Ohio | 39039 | 3593 | 101 |
1026373 | 1026373 | 2021-02-13 | Delaware | Ohio | 39041 | 15786 | 120 |
1026374 | 1026374 | 2021-02-13 | Erie | Ohio | 39043 | 6655 | 171 |
1026375 | 1026375 | 2021-02-13 | Fairfield | Ohio | 39045 | 14080 | 149 |
1026376 | 1026376 | 2021-02-13 | Fayette | Ohio | 39047 | 2595 | 38 |
1026377 | 1026377 | 2021-02-13 | Franklin | Ohio | 39049 | 108800 | 1163 |
1026378 | 1026378 | 2021-02-13 | Fulton | Ohio | 39051 | 3684 | 60 |
1026379 | 1026379 | 2021-02-13 | Gallia | Ohio | 39053 | 2145 | 44 |
1026380 | 1026380 | 2021-02-13 | Geauga | Ohio | 39055 | 5783 | 124 |
1026381 | 1026381 | 2021-02-13 | Greene | Ohio | 39057 | 13210 | 208 |
1026382 | 1026382 | 2021-02-13 | Guernsey | Ohio | 39059 | 2780 | 35 |
1026383 | 1026383 | 2021-02-13 | Hamilton | Ohio | 39061 | 70822 | 909 |
1026384 | 1026384 | 2021-02-13 | Hancock | Ohio | 39063 | 5844 | 107 |
1026385 | 1026385 | 2021-02-13 | Hardin | Ohio | 39065 | 2368 | 55 |
1026386 | 1026386 | 2021-02-13 | Harrison | Ohio | 39067 | 974 | 28 |
1026387 | 1026387 | 2021-02-13 | Henry | Ohio | 39069 | 2387 | 60 |
1026388 | 1026388 | 2021-02-13 | Highland | Ohio | 39071 | 3161 | 43 |
1026389 | 1026389 | 2021-02-13 | Hocking | Ohio | 39073 | 1886 | 46 |
1026390 | 1026390 | 2021-02-13 | Holmes | Ohio | 39075 | 2381 | 98 |
1026391 | 1026391 | 2021-02-13 | Huron | Ohio | 39077 | 4615 | 103 |
1026392 | 1026392 | 2021-02-13 | Jackson | Ohio | 39079 | 2833 | 53 |
1026393 | 1026393 | 2021-02-13 | Jefferson | Ohio | 39081 | 4554 | 105 |
1026394 | 1026394 | 2021-02-13 | Knox | Ohio | 39083 | 3900 | 77 |
1026395 | 1026395 | 2021-02-13 | Lake | Ohio | 39085 | 17737 | 294 |
1026396 | 1026396 | 2021-02-13 | Lawrence | Ohio | 39087 | 5067 | 70 |
1026397 | 1026397 | 2021-02-13 | Licking | Ohio | 39089 | 14475 | 182 |
1026398 | 1026398 | 2021-02-13 | Logan | Ohio | 39091 | 3419 | 56 |
1026399 | 1026399 | 2021-02-13 | Lorain | Ohio | 39093 | 21152 | 364 |
1026400 | 1026400 | 2021-02-13 | Lucas | Ohio | 39095 | 33963 | 742 |
1026401 | 1026401 | 2021-02-13 | Madison | Ohio | 39097 | 3825 | 47 |
1026402 | 1026402 | 2021-02-13 | Mahoning | Ohio | 39099 | 18817 | 519 |
1026403 | 1026403 | 2021-02-13 | Marion | Ohio | 39101 | 7828 | 131 |
1026404 | 1026404 | 2021-02-13 | Medina | Ohio | 39103 | 12835 | 211 |
1026405 | 1026405 | 2021-02-13 | Meigs | Ohio | 39105 | 1289 | 32 |
1026406 | 1026406 | 2021-02-13 | Mercer | Ohio | 39107 | 4527 | 101 |
1026407 | 1026407 | 2021-02-13 | Miami | Ohio | 39109 | 9801 | 172 |
1026408 | 1026408 | 2021-02-13 | Monroe | Ohio | 39111 | 1108 | 37 |
1026409 | 1026409 | 2021-02-13 | Montgomery | Ohio | 39113 | 46222 | 841 |
1026410 | 1026410 | 2021-02-13 | Morgan | Ohio | 39115 | 939 | 33 |
1026411 | 1026411 | 2021-02-13 | Morrow | Ohio | 39117 | 2512 | 21 |
1026412 | 1026412 | 2021-02-13 | Muskingum | Ohio | 39119 | 7891 | 126 |
1026413 | 1026413 | 2021-02-13 | Noble | Ohio | 39121 | 1261 | 41 |
1026414 | 1026414 | 2021-02-13 | Ottawa | Ohio | 39123 | 3133 | 66 |
1026415 | 1026415 | 2021-02-13 | Paulding | Ohio | 39125 | 1553 | 25 |
1026416 | 1026416 | 2021-02-13 | Perry | Ohio | 39127 | 2598 | 36 |
1026417 | 1026417 | 2021-02-13 | Pickaway | Ohio | 39129 | 7839 | 91 |
1026418 | 1026418 | 2021-02-13 | Pike | Ohio | 39131 | 2066 | 23 |
1026419 | 1026419 | 2021-02-13 | Portage | Ohio | 39133 | 10462 | 148 |
1026420 | 1026420 | 2021-02-13 | Preble | Ohio | 39135 | 3451 | 69 |
1026421 | 1026421 | 2021-02-13 | Putnam | Ohio | 39137 | 3927 | 95 |
1026422 | 1026422 | 2021-02-13 | Richland | Ohio | 39139 | 9927 | 178 |
1026423 | 1026423 | 2021-02-13 | Ross | Ohio | 39141 | 5954 | 133 |
1026424 | 1026424 | 2021-02-13 | Sandusky | Ohio | 39143 | 4640 | 90 |
1026425 | 1026425 | 2021-02-13 | Scioto | Ohio | 39145 | 5766 | 101 |
1026426 | 1026426 | 2021-02-13 | Seneca | Ohio | 39147 | 4558 | 101 |
1026427 | 1026427 | 2021-02-13 | Shelby | Ohio | 39149 | 4360 | 65 |
1026428 | 1026428 | 2021-02-13 | Stark | Ohio | 39151 | 28311 | 791 |
1026429 | 1026429 | 2021-02-13 | Summit | Ohio | 39153 | 38509 | 902 |
1026430 | 1026430 | 2021-02-13 | Trumbull | Ohio | 39155 | 13815 | 438 |
1026431 | 1026431 | 2021-02-13 | Tuscarawas | Ohio | 39157 | 7870 | 230 |
1026432 | 1026432 | 2021-02-13 | Union | Ohio | 39159 | 4930 | 48 |
1026433 | 1026433 | 2021-02-13 | Van Wert | Ohio | 39161 | 2215 | 49 |
1026434 | 1026434 | 2021-02-13 | Vinton | Ohio | 39163 | 755 | 14 |
1026435 | 1026435 | 2021-02-13 | Warren | Ohio | 39165 | 21573 | 256 |
1026436 | 1026436 | 2021-02-13 | Washington | Ohio | 39167 | 4377 | 85 |
1026437 | 1026437 | 2021-02-13 | Wayne | Ohio | 39169 | 7667 | 205 |
1026438 | 1026438 | 2021-02-13 | Williams | Ohio | 39171 | 2955 | 77 |
1026439 | 1026439 | 2021-02-13 | Wood | Ohio | 39173 | 11215 | 191 |
1026440 | 1026440 | 2021-02-13 | Wyandot | Ohio | 39175 | 2054 | 52 |
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);