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 583
- 39151 581
- 39155 580
- 39049 578
- 39093 578
- 39153 578
- 39157 578
- 39013 577
- 39017 577
- 39095 577
- 39103 577
- 39055 576
- 39031 575
- 39037 575
- 39085 575
- 39099 575
- 39023 574
- 39041 574
- 39077 574
- 39109 574
- 39005 573
- 39061 573
- 39113 573
- 39139 573
- 39029 572
- 39101 572
- 39159 572
- 39165 572
- 39007 571
- 39025 571
- …
county >30
- Cuyahoga 583
- Stark 581
- Trumbull 580
- Franklin 578
- Lorain 578
- Summit 578
- Tuscarawas 578
- Belmont 577
- Butler 577
- Lucas 577
- Medina 577
- Geauga 576
- Coshocton 575
- Darke 575
- Lake 575
- Mahoning 575
- Clark 574
- Delaware 574
- Huron 574
- Miami 574
- Ashland 573
- Hamilton 573
- Montgomery 573
- Richland 573
- Columbiana 572
- Marion 572
- Union 572
- Warren 572
- Ashtabula 571
- Clermont 571
- …
state 1
- Ohio · 50,133 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1808941 | 1808941 | 2021-10-12 | Clark | Ohio | 39023 | 19308 | 346 |
1808942 | 1808942 | 2021-10-12 | Clermont | Ohio | 39025 | 27537 | 315 |
1808943 | 1808943 | 2021-10-12 | Clinton | Ohio | 39027 | 5693 | 87 |
1808944 | 1808944 | 2021-10-12 | Columbiana | Ohio | 39029 | 13301 | 257 |
1808945 | 1808945 | 2021-10-12 | Coshocton | Ohio | 39031 | 4535 | 79 |
1808946 | 1808946 | 2021-10-12 | Crawford | Ohio | 39033 | 6067 | 127 |
1808947 | 1808947 | 2021-10-12 | Cuyahoga | Ohio | 39035 | 142685 | 2400 |
1808948 | 1808948 | 2021-10-12 | Darke | Ohio | 39037 | 7423 | 150 |
1808949 | 1808949 | 2021-10-12 | Defiance | Ohio | 39039 | 5939 | 102 |
1808950 | 1808950 | 2021-10-12 | Delaware | Ohio | 39041 | 23721 | 160 |
1808951 | 1808951 | 2021-10-12 | Erie | Ohio | 39043 | 10451 | 180 |
1808952 | 1808952 | 2021-10-12 | Fairfield | Ohio | 39045 | 21929 | 238 |
1808953 | 1808953 | 2021-10-12 | Fayette | Ohio | 39047 | 4145 | 60 |
1808954 | 1808954 | 2021-10-12 | Franklin | Ohio | 39049 | 160901 | 1643 |
1808955 | 1808955 | 2021-10-12 | Fulton | Ohio | 39051 | 5813 | 92 |
1808956 | 1808956 | 2021-10-12 | Gallia | Ohio | 39053 | 3985 | 62 |
1808957 | 1808957 | 2021-10-12 | Geauga | Ohio | 39055 | 8656 | 158 |
1808958 | 1808958 | 2021-10-12 | Greene | Ohio | 39057 | 21761 | 305 |
1808959 | 1808959 | 2021-10-12 | Guernsey | Ohio | 39059 | 5487 | 67 |
1808960 | 1808960 | 2021-10-12 | Hamilton | Ohio | 39061 | 103275 | 1388 |
1808961 | 1808961 | 2021-10-12 | Hancock | Ohio | 39063 | 9325 | 149 |
1808962 | 1808962 | 2021-10-12 | Hardin | Ohio | 39065 | 3995 | 74 |
1808963 | 1808963 | 2021-10-12 | Harrison | Ohio | 39067 | 1746 | 42 |
1808964 | 1808964 | 2021-10-12 | Henry | Ohio | 39069 | 3526 | 69 |
1808965 | 1808965 | 2021-10-12 | Highland | Ohio | 39071 | 5811 | 99 |
1808966 | 1808966 | 2021-10-12 | Hocking | Ohio | 39073 | 3458 | 77 |
1808967 | 1808967 | 2021-10-12 | Holmes | Ohio | 39075 | 3503 | 120 |
1808968 | 1808968 | 2021-10-12 | Huron | Ohio | 39077 | 8068 | 138 |
1808969 | 1808969 | 2021-10-12 | Jackson | Ohio | 39079 | 4841 | 69 |
1808970 | 1808970 | 2021-10-12 | Jefferson | Ohio | 39081 | 8324 | 191 |
1808971 | 1808971 | 2021-10-12 | Knox | Ohio | 39083 | 7429 | 132 |
1808972 | 1808972 | 2021-10-12 | Lake | Ohio | 39085 | 26163 | 432 |
1808973 | 1808973 | 2021-10-12 | Lawrence | Ohio | 39087 | 9534 | 137 |
1808974 | 1808974 | 2021-10-12 | Licking | Ohio | 39089 | 23069 | 279 |
1808975 | 1808975 | 2021-10-12 | Logan | Ohio | 39091 | 5572 | 91 |
1808976 | 1808976 | 2021-10-12 | Lorain | Ohio | 39093 | 34466 | 566 |
1808977 | 1808977 | 2021-10-12 | Lucas | Ohio | 39095 | 54701 | 894 |
1808978 | 1808978 | 2021-10-12 | Madison | Ohio | 39097 | 5796 | 75 |
1808979 | 1808979 | 2021-10-12 | Mahoning | Ohio | 39099 | 29612 | 667 |
1808980 | 1808980 | 2021-10-12 | Marion | Ohio | 39101 | 11632 | 169 |
1808981 | 1808981 | 2021-10-12 | Medina | Ohio | 39103 | 21380 | 302 |
1808982 | 1808982 | 2021-10-12 | Meigs | Ohio | 39105 | 2505 | 47 |
1808983 | 1808983 | 2021-10-12 | Mercer | Ohio | 39107 | 5994 | 92 |
1808984 | 1808984 | 2021-10-12 | Miami | Ohio | 39109 | 15079 | 289 |
1808985 | 1808985 | 2021-10-12 | Monroe | Ohio | 39111 | 2075 | 51 |
1808986 | 1808986 | 2021-10-12 | Montgomery | Ohio | 39113 | 72134 | 1227 |
1808987 | 1808987 | 2021-10-12 | Morgan | Ohio | 39115 | 1852 | 32 |
1808988 | 1808988 | 2021-10-12 | Morrow | Ohio | 39117 | 4422 | 56 |
1808989 | 1808989 | 2021-10-12 | Muskingum | Ohio | 39119 | 14205 | 168 |
1808990 | 1808990 | 2021-10-12 | Noble | Ohio | 39121 | 1924 | 44 |
1808991 | 1808991 | 2021-10-12 | Ottawa | Ohio | 39123 | 4713 | 86 |
1808992 | 1808992 | 2021-10-12 | Paulding | Ohio | 39125 | 2696 | 45 |
1808993 | 1808993 | 2021-10-12 | Perry | Ohio | 39127 | 5046 | 59 |
1808994 | 1808994 | 2021-10-12 | Pickaway | Ohio | 39129 | 11176 | 137 |
1808995 | 1808995 | 2021-10-12 | Pike | Ohio | 39131 | 4246 | 58 |
1808996 | 1808996 | 2021-10-12 | Portage | Ohio | 39133 | 17389 | 243 |
1808997 | 1808997 | 2021-10-12 | Preble | Ohio | 39135 | 5553 | 120 |
1808998 | 1808998 | 2021-10-12 | Putnam | Ohio | 39137 | 5172 | 108 |
1808999 | 1808999 | 2021-10-12 | Richland | Ohio | 39139 | 17999 | 270 |
1809000 | 1809000 | 2021-10-12 | Ross | Ohio | 39141 | 10295 | 193 |
1809001 | 1809001 | 2021-10-12 | Sandusky | Ohio | 39143 | 7557 | 145 |
1809002 | 1809002 | 2021-10-12 | Scioto | Ohio | 39145 | 11229 | 149 |
1809003 | 1809003 | 2021-10-12 | Seneca | Ohio | 39147 | 7047 | 143 |
1809004 | 1809004 | 2021-10-12 | Shelby | Ohio | 39149 | 6289 | 109 |
1809005 | 1809005 | 2021-10-12 | Stark | Ohio | 39151 | 45111 | 1035 |
1809006 | 1809006 | 2021-10-12 | Summit | Ohio | 39153 | 60084 | 1088 |
1809007 | 1809007 | 2021-10-12 | Trumbull | Ohio | 39155 | 22040 | 541 |
1809008 | 1809008 | 2021-10-12 | Tuscarawas | Ohio | 39157 | 12178 | 291 |
1809009 | 1809009 | 2021-10-12 | Union | Ohio | 39159 | 7994 | 55 |
1809010 | 1809010 | 2021-10-12 | Unknown | Ohio | 0 | 5 | |
1809011 | 1809011 | 2021-10-12 | Van Wert | Ohio | 39161 | 3535 | 74 |
1809012 | 1809012 | 2021-10-12 | Vinton | Ohio | 39163 | 1568 | 23 |
1809013 | 1809013 | 2021-10-12 | Warren | Ohio | 39165 | 31985 | 365 |
1809014 | 1809014 | 2021-10-12 | Washington | Ohio | 39167 | 7932 | 136 |
1809015 | 1809015 | 2021-10-12 | Wayne | Ohio | 39169 | 13293 | 259 |
1809016 | 1809016 | 2021-10-12 | Williams | Ohio | 39171 | 5048 | 84 |
1809017 | 1809017 | 2021-10-12 | Wood | Ohio | 39173 | 16952 | 217 |
1809018 | 1809018 | 2021-10-12 | Wyandot | Ohio | 39175 | 3100 | 61 |
1805680 | 1805680 | 2021-10-11 | Adams | Ohio | 39001 | 4012 | 82 |
1805681 | 1805681 | 2021-10-11 | Allen | Ohio | 39003 | 15365 | 266 |
1805682 | 1805682 | 2021-10-11 | Ashland | Ohio | 39005 | 6606 | 120 |
1805683 | 1805683 | 2021-10-11 | Ashtabula | Ohio | 39007 | 9199 | 192 |
1805684 | 1805684 | 2021-10-11 | Athens | Ohio | 39009 | 7543 | 68 |
1805685 | 1805685 | 2021-10-11 | Auglaize | Ohio | 39011 | 6512 | 89 |
1805686 | 1805686 | 2021-10-11 | Belmont | Ohio | 39013 | 8850 | 195 |
1805687 | 1805687 | 2021-10-11 | Brown | Ohio | 39015 | 6172 | 79 |
1805688 | 1805688 | 2021-10-11 | Butler | Ohio | 39017 | 50272 | 685 |
1805689 | 1805689 | 2021-10-11 | Carroll | Ohio | 39019 | 2882 | 57 |
1805690 | 1805690 | 2021-10-11 | Champaign | Ohio | 39021 | 4914 | 66 |
1805691 | 1805691 | 2021-10-11 | Clark | Ohio | 39023 | 19260 | 341 |
1805692 | 1805692 | 2021-10-11 | Clermont | Ohio | 39025 | 27472 | 313 |
1805693 | 1805693 | 2021-10-11 | Clinton | Ohio | 39027 | 5680 | 87 |
1805694 | 1805694 | 2021-10-11 | Columbiana | Ohio | 39029 | 13242 | 256 |
1805695 | 1805695 | 2021-10-11 | Coshocton | Ohio | 39031 | 4498 | 78 |
1805696 | 1805696 | 2021-10-11 | Crawford | Ohio | 39033 | 6045 | 127 |
1805697 | 1805697 | 2021-10-11 | Cuyahoga | Ohio | 39035 | 142302 | 2387 |
1805698 | 1805698 | 2021-10-11 | Darke | Ohio | 39037 | 7386 | 147 |
1805699 | 1805699 | 2021-10-11 | Defiance | Ohio | 39039 | 5918 | 102 |
1805700 | 1805700 | 2021-10-11 | Delaware | Ohio | 39041 | 23689 | 156 |
1805701 | 1805701 | 2021-10-11 | Erie | Ohio | 39043 | 10407 | 180 |
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);