ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where date = "2020-11-24" 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 · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
763476 | 763476 | 2020-11-24 | Adams | Ohio | 39001 | 783 | 13 |
763477 | 763477 | 2020-11-24 | Allen | Ohio | 39003 | 4654 | 85 |
763478 | 763478 | 2020-11-24 | Ashland | Ohio | 39005 | 1052 | 22 |
763479 | 763479 | 2020-11-24 | Ashtabula | Ohio | 39007 | 2232 | 53 |
763480 | 763480 | 2020-11-24 | Athens | Ohio | 39009 | 1886 | 4 |
763481 | 763481 | 2020-11-24 | Auglaize | Ohio | 39011 | 2310 | 31 |
763482 | 763482 | 2020-11-24 | Belmont | Ohio | 39013 | 1649 | 29 |
763483 | 763483 | 2020-11-24 | Brown | Ohio | 39015 | 992 | 5 |
763484 | 763484 | 2020-11-24 | Butler | Ohio | 39017 | 14769 | 146 |
763485 | 763485 | 2020-11-24 | Carroll | Ohio | 39019 | 457 | 10 |
763486 | 763486 | 2020-11-24 | Champaign | Ohio | 39021 | 947 | 5 |
763487 | 763487 | 2020-11-24 | Clark | Ohio | 39023 | 5114 | 64 |
763488 | 763488 | 2020-11-24 | Clermont | Ohio | 39025 | 5772 | 48 |
763489 | 763489 | 2020-11-24 | Clinton | Ohio | 39027 | 1067 | 14 |
763490 | 763490 | 2020-11-24 | Columbiana | Ohio | 39029 | 3472 | 97 |
763491 | 763491 | 2020-11-24 | Coshocton | Ohio | 39031 | 826 | 13 |
763492 | 763492 | 2020-11-24 | Crawford | Ohio | 39033 | 1215 | 16 |
763493 | 763493 | 2020-11-24 | Cuyahoga | Ohio | 39035 | 36047 | 741 |
763494 | 763494 | 2020-11-24 | Darke | Ohio | 39037 | 2235 | 59 |
763495 | 763495 | 2020-11-24 | Defiance | Ohio | 39039 | 1395 | 22 |
763496 | 763496 | 2020-11-24 | Delaware | Ohio | 39041 | 5564 | 36 |
763497 | 763497 | 2020-11-24 | Erie | Ohio | 39043 | 2242 | 66 |
763498 | 763498 | 2020-11-24 | Fairfield | Ohio | 39045 | 5384 | 64 |
763499 | 763499 | 2020-11-24 | Fayette | Ohio | 39047 | 903 | 17 |
763500 | 763500 | 2020-11-24 | Franklin | Ohio | 39049 | 50231 | 667 |
763501 | 763501 | 2020-11-24 | Fulton | Ohio | 39051 | 1245 | 25 |
763502 | 763502 | 2020-11-24 | Gallia | Ohio | 39053 | 735 | 13 |
763503 | 763503 | 2020-11-24 | Geauga | Ohio | 39055 | 2033 | 51 |
763504 | 763504 | 2020-11-24 | Greene | Ohio | 39057 | 5223 | 64 |
763505 | 763505 | 2020-11-24 | Guernsey | Ohio | 39059 | 839 | 14 |
763506 | 763506 | 2020-11-24 | Hamilton | Ohio | 39061 | 29931 | 372 |
763507 | 763507 | 2020-11-24 | Hancock | Ohio | 39063 | 2413 | 37 |
763508 | 763508 | 2020-11-24 | Hardin | Ohio | 39065 | 910 | 19 |
763509 | 763509 | 2020-11-24 | Harrison | Ohio | 39067 | 202 | 3 |
763510 | 763510 | 2020-11-24 | Henry | Ohio | 39069 | 1000 | 23 |
763511 | 763511 | 2020-11-24 | Highland | Ohio | 39071 | 1013 | 17 |
763512 | 763512 | 2020-11-24 | Hocking | Ohio | 39073 | 626 | 16 |
763513 | 763513 | 2020-11-24 | Holmes | Ohio | 39075 | 1391 | 39 |
763514 | 763514 | 2020-11-24 | Huron | Ohio | 39077 | 1523 | 18 |
763515 | 763515 | 2020-11-24 | Jackson | Ohio | 39079 | 931 | 12 |
763516 | 763516 | 2020-11-24 | Jefferson | Ohio | 39081 | 1045 | 12 |
763517 | 763517 | 2020-11-24 | Knox | Ohio | 39083 | 1263 | 18 |
763518 | 763518 | 2020-11-24 | Lake | Ohio | 39085 | 6826 | 66 |
763519 | 763519 | 2020-11-24 | Lawrence | Ohio | 39087 | 1894 | 38 |
763520 | 763520 | 2020-11-24 | Licking | Ohio | 39089 | 5492 | 76 |
763521 | 763521 | 2020-11-24 | Logan | Ohio | 39091 | 1278 | 16 |
763522 | 763522 | 2020-11-24 | Lorain | Ohio | 39093 | 6434 | 99 |
763523 | 763523 | 2020-11-24 | Lucas | Ohio | 39095 | 14317 | 414 |
763524 | 763524 | 2020-11-24 | Madison | Ohio | 39097 | 1589 | 18 |
763525 | 763525 | 2020-11-24 | Mahoning | Ohio | 39099 | 7276 | 299 |
763526 | 763526 | 2020-11-24 | Marion | Ohio | 39101 | 4652 | 51 |
763527 | 763527 | 2020-11-24 | Medina | Ohio | 39103 | 4477 | 56 |
763528 | 763528 | 2020-11-24 | Meigs | Ohio | 39105 | 390 | 12 |
763529 | 763529 | 2020-11-24 | Mercer | Ohio | 39107 | 2899 | 45 |
763530 | 763530 | 2020-11-24 | Miami | Ohio | 39109 | 4258 | 67 |
763531 | 763531 | 2020-11-24 | Monroe | Ohio | 39111 | 318 | 21 |
763532 | 763532 | 2020-11-24 | Montgomery | Ohio | 39113 | 20065 | 228 |
763533 | 763533 | 2020-11-24 | Morgan | Ohio | 39115 | 257 | 5 |
763534 | 763534 | 2020-11-24 | Morrow | Ohio | 39117 | 888 | 2 |
763535 | 763535 | 2020-11-24 | Muskingum | Ohio | 39119 | 2402 | 10 |
763536 | 763536 | 2020-11-24 | Noble | Ohio | 39121 | 602 | 23 |
763537 | 763537 | 2020-11-24 | Ottawa | Ohio | 39123 | 1211 | 30 |
763538 | 763538 | 2020-11-24 | Paulding | Ohio | 39125 | 646 | 11 |
763539 | 763539 | 2020-11-24 | Perry | Ohio | 39127 | 787 | 12 |
763540 | 763540 | 2020-11-24 | Pickaway | Ohio | 39129 | 3993 | 48 |
763541 | 763541 | 2020-11-24 | Pike | Ohio | 39131 | 745 | 1 |
763542 | 763542 | 2020-11-24 | Portage | Ohio | 39133 | 3448 | 72 |
763543 | 763543 | 2020-11-24 | Preble | Ohio | 39135 | 1526 | 21 |
763544 | 763544 | 2020-11-24 | Putnam | Ohio | 39137 | 2247 | 49 |
763545 | 763545 | 2020-11-24 | Richland | Ohio | 39139 | 3166 | 38 |
763546 | 763546 | 2020-11-24 | Ross | Ohio | 39141 | 2407 | 59 |
763547 | 763547 | 2020-11-24 | Sandusky | Ohio | 39143 | 1542 | 29 |
763548 | 763548 | 2020-11-24 | Scioto | Ohio | 39145 | 1959 | 15 |
763549 | 763549 | 2020-11-24 | Seneca | Ohio | 39147 | 1800 | 18 |
763550 | 763550 | 2020-11-24 | Shelby | Ohio | 39149 | 1906 | 15 |
763551 | 763551 | 2020-11-24 | Stark | Ohio | 39151 | 8792 | 197 |
763552 | 763552 | 2020-11-24 | Summit | Ohio | 39153 | 13388 | 316 |
763553 | 763553 | 2020-11-24 | Trumbull | Ohio | 39155 | 5305 | 147 |
763554 | 763554 | 2020-11-24 | Tuscarawas | Ohio | 39157 | 3286 | 58 |
763555 | 763555 | 2020-11-24 | Union | Ohio | 39159 | 1911 | 8 |
763556 | 763556 | 2020-11-24 | Van Wert | Ohio | 39161 | 932 | 16 |
763557 | 763557 | 2020-11-24 | Vinton | Ohio | 39163 | 219 | 5 |
763558 | 763558 | 2020-11-24 | Warren | Ohio | 39165 | 8191 | 75 |
763559 | 763559 | 2020-11-24 | Washington | Ohio | 39167 | 1219 | 27 |
763560 | 763560 | 2020-11-24 | Wayne | Ohio | 39169 | 3187 | 93 |
763561 | 763561 | 2020-11-24 | Williams | Ohio | 39171 | 1057 | 9 |
763562 | 763562 | 2020-11-24 | Wood | Ohio | 39173 | 4491 | 107 |
763563 | 763563 | 2020-11-24 | Wyandot | Ohio | 39175 | 712 | 16 |
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);