ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where date = "2021-10-06" 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 · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1789434 | 1789434 | 2021-10-06 | Adams | Ohio | 39001 | 3948 | 81 |
1789435 | 1789435 | 2021-10-06 | Allen | Ohio | 39003 | 15052 | 266 |
1789436 | 1789436 | 2021-10-06 | Ashland | Ohio | 39005 | 6451 | 119 |
1789437 | 1789437 | 2021-10-06 | Ashtabula | Ohio | 39007 | 8901 | 192 |
1789438 | 1789438 | 2021-10-06 | Athens | Ohio | 39009 | 7442 | 66 |
1789439 | 1789439 | 2021-10-06 | Auglaize | Ohio | 39011 | 6340 | 89 |
1789440 | 1789440 | 2021-10-06 | Belmont | Ohio | 39013 | 8692 | 194 |
1789441 | 1789441 | 2021-10-06 | Brown | Ohio | 39015 | 6051 | 77 |
1789442 | 1789442 | 2021-10-06 | Butler | Ohio | 39017 | 49586 | 675 |
1789443 | 1789443 | 2021-10-06 | Carroll | Ohio | 39019 | 2817 | 56 |
1789444 | 1789444 | 2021-10-06 | Champaign | Ohio | 39021 | 4810 | 65 |
1789445 | 1789445 | 2021-10-06 | Clark | Ohio | 39023 | 18990 | 335 |
1789446 | 1789446 | 2021-10-06 | Clermont | Ohio | 39025 | 27076 | 306 |
1789447 | 1789447 | 2021-10-06 | Clinton | Ohio | 39027 | 5617 | 87 |
1789448 | 1789448 | 2021-10-06 | Columbiana | Ohio | 39029 | 12838 | 249 |
1789449 | 1789449 | 2021-10-06 | Coshocton | Ohio | 39031 | 4324 | 74 |
1789450 | 1789450 | 2021-10-06 | Crawford | Ohio | 39033 | 5914 | 125 |
1789451 | 1789451 | 2021-10-06 | Cuyahoga | Ohio | 39035 | 140258 | 2376 |
1789452 | 1789452 | 2021-10-06 | Darke | Ohio | 39037 | 7263 | 145 |
1789453 | 1789453 | 2021-10-06 | Defiance | Ohio | 39039 | 5814 | 102 |
1789454 | 1789454 | 2021-10-06 | Delaware | Ohio | 39041 | 23305 | 154 |
1789455 | 1789455 | 2021-10-06 | Erie | Ohio | 39043 | 10251 | 176 |
1789456 | 1789456 | 2021-10-06 | Fairfield | Ohio | 39045 | 21580 | 232 |
1789457 | 1789457 | 2021-10-06 | Fayette | Ohio | 39047 | 4041 | 56 |
1789458 | 1789458 | 2021-10-06 | Franklin | Ohio | 39049 | 158547 | 1611 |
1789459 | 1789459 | 2021-10-06 | Fulton | Ohio | 39051 | 5688 | 88 |
1789460 | 1789460 | 2021-10-06 | Gallia | Ohio | 39053 | 3868 | 61 |
1789461 | 1789461 | 2021-10-06 | Geauga | Ohio | 39055 | 8505 | 158 |
1789462 | 1789462 | 2021-10-06 | Greene | Ohio | 39057 | 21403 | 288 |
1789463 | 1789463 | 2021-10-06 | Guernsey | Ohio | 39059 | 5286 | 67 |
1789464 | 1789464 | 2021-10-06 | Hamilton | Ohio | 39061 | 101908 | 1359 |
1789465 | 1789465 | 2021-10-06 | Hancock | Ohio | 39063 | 9071 | 147 |
1789466 | 1789466 | 2021-10-06 | Hardin | Ohio | 39065 | 3883 | 71 |
1789467 | 1789467 | 2021-10-06 | Harrison | Ohio | 39067 | 1707 | 41 |
1789468 | 1789468 | 2021-10-06 | Henry | Ohio | 39069 | 3453 | 69 |
1789469 | 1789469 | 2021-10-06 | Highland | Ohio | 39071 | 5714 | 96 |
1789470 | 1789470 | 2021-10-06 | Hocking | Ohio | 39073 | 3360 | 72 |
1789471 | 1789471 | 2021-10-06 | Holmes | Ohio | 39075 | 3437 | 112 |
1789472 | 1789472 | 2021-10-06 | Huron | Ohio | 39077 | 7900 | 134 |
1789473 | 1789473 | 2021-10-06 | Jackson | Ohio | 39079 | 4677 | 68 |
1789474 | 1789474 | 2021-10-06 | Jefferson | Ohio | 39081 | 8116 | 185 |
1789475 | 1789475 | 2021-10-06 | Knox | Ohio | 39083 | 7217 | 128 |
1789476 | 1789476 | 2021-10-06 | Lake | Ohio | 39085 | 25664 | 428 |
1789477 | 1789477 | 2021-10-06 | Lawrence | Ohio | 39087 | 9367 | 136 |
1789478 | 1789478 | 2021-10-06 | Licking | Ohio | 39089 | 22428 | 266 |
1789479 | 1789479 | 2021-10-06 | Logan | Ohio | 39091 | 5439 | 90 |
1789480 | 1789480 | 2021-10-06 | Lorain | Ohio | 39093 | 33643 | 554 |
1789481 | 1789481 | 2021-10-06 | Lucas | Ohio | 39095 | 53603 | 883 |
1789482 | 1789482 | 2021-10-06 | Madison | Ohio | 39097 | 5701 | 73 |
1789483 | 1789483 | 2021-10-06 | Mahoning | Ohio | 39099 | 28861 | 658 |
1789484 | 1789484 | 2021-10-06 | Marion | Ohio | 39101 | 11390 | 159 |
1789485 | 1789485 | 2021-10-06 | Medina | Ohio | 39103 | 20986 | 299 |
1789486 | 1789486 | 2021-10-06 | Meigs | Ohio | 39105 | 2422 | 45 |
1789487 | 1789487 | 2021-10-06 | Mercer | Ohio | 39107 | 5878 | 91 |
1789488 | 1789488 | 2021-10-06 | Miami | Ohio | 39109 | 14742 | 275 |
1789489 | 1789489 | 2021-10-06 | Monroe | Ohio | 39111 | 2031 | 50 |
1789490 | 1789490 | 2021-10-06 | Montgomery | Ohio | 39113 | 70773 | 1192 |
1789491 | 1789491 | 2021-10-06 | Morgan | Ohio | 39115 | 1798 | 30 |
1789492 | 1789492 | 2021-10-06 | Morrow | Ohio | 39117 | 4317 | 54 |
1789493 | 1789493 | 2021-10-06 | Muskingum | Ohio | 39119 | 13786 | 163 |
1789494 | 1789494 | 2021-10-06 | Noble | Ohio | 39121 | 1874 | 44 |
1789495 | 1789495 | 2021-10-06 | Ottawa | Ohio | 39123 | 4622 | 85 |
1789496 | 1789496 | 2021-10-06 | Paulding | Ohio | 39125 | 2623 | 44 |
1789497 | 1789497 | 2021-10-06 | Perry | Ohio | 39127 | 4941 | 56 |
1789498 | 1789498 | 2021-10-06 | Pickaway | Ohio | 39129 | 10993 | 133 |
1789499 | 1789499 | 2021-10-06 | Pike | Ohio | 39131 | 4174 | 51 |
1789500 | 1789500 | 2021-10-06 | Portage | Ohio | 39133 | 17059 | 238 |
1789501 | 1789501 | 2021-10-06 | Preble | Ohio | 39135 | 5412 | 117 |
1789502 | 1789502 | 2021-10-06 | Putnam | Ohio | 39137 | 5077 | 108 |
1789503 | 1789503 | 2021-10-06 | Richland | Ohio | 39139 | 17586 | 255 |
1789504 | 1789504 | 2021-10-06 | Ross | Ohio | 39141 | 10087 | 186 |
1789505 | 1789505 | 2021-10-06 | Sandusky | Ohio | 39143 | 7341 | 140 |
1789506 | 1789506 | 2021-10-06 | Scioto | Ohio | 39145 | 11043 | 138 |
1789507 | 1789507 | 2021-10-06 | Seneca | Ohio | 39147 | 6852 | 140 |
1789508 | 1789508 | 2021-10-06 | Shelby | Ohio | 39149 | 6179 | 107 |
1789509 | 1789509 | 2021-10-06 | Stark | Ohio | 39151 | 44185 | 1012 |
1789510 | 1789510 | 2021-10-06 | Summit | Ohio | 39153 | 58914 | 1075 |
1789511 | 1789511 | 2021-10-06 | Trumbull | Ohio | 39155 | 21455 | 534 |
1789512 | 1789512 | 2021-10-06 | Tuscarawas | Ohio | 39157 | 11892 | 282 |
1789513 | 1789513 | 2021-10-06 | Union | Ohio | 39159 | 7837 | 54 |
1789514 | 1789514 | 2021-10-06 | Unknown | Ohio | 0 | 5 | |
1789515 | 1789515 | 2021-10-06 | Van Wert | Ohio | 39161 | 3423 | 73 |
1789516 | 1789516 | 2021-10-06 | Vinton | Ohio | 39163 | 1521 | 21 |
1789517 | 1789517 | 2021-10-06 | Warren | Ohio | 39165 | 31471 | 350 |
1789518 | 1789518 | 2021-10-06 | Washington | Ohio | 39167 | 7786 | 132 |
1789519 | 1789519 | 2021-10-06 | Wayne | Ohio | 39169 | 12956 | 256 |
1789520 | 1789520 | 2021-10-06 | Williams | Ohio | 39171 | 4923 | 84 |
1789521 | 1789521 | 2021-10-06 | Wood | Ohio | 39173 | 16614 | 214 |
1789522 | 1789522 | 2021-10-06 | Wyandot | Ohio | 39175 | 3016 | 58 |
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);