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 2020-05-08 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 |
---|---|---|---|---|---|---|---|
126150 | 126150 | 2020-05-08 | Adams | Ohio | 39001 | 5 | 0 |
126151 | 126151 | 2020-05-08 | Allen | Ohio | 39003 | 139 | 29 |
126152 | 126152 | 2020-05-08 | Ashland | Ohio | 39005 | 12 | 0 |
126153 | 126153 | 2020-05-08 | Ashtabula | Ohio | 39007 | 172 | 18 |
126154 | 126154 | 2020-05-08 | Athens | Ohio | 39009 | 4 | 1 |
126155 | 126155 | 2020-05-08 | Auglaize | Ohio | 39011 | 42 | 3 |
126156 | 126156 | 2020-05-08 | Belmont | Ohio | 39013 | 216 | 7 |
126157 | 126157 | 2020-05-08 | Brown | Ohio | 39015 | 16 | 1 |
126158 | 126158 | 2020-05-08 | Butler | Ohio | 39017 | 404 | 12 |
126159 | 126159 | 2020-05-08 | Carroll | Ohio | 39019 | 23 | 1 |
126160 | 126160 | 2020-05-08 | Champaign | Ohio | 39021 | 16 | 1 |
126161 | 126161 | 2020-05-08 | Clark | Ohio | 39023 | 80 | 2 |
126162 | 126162 | 2020-05-08 | Clermont | Ohio | 39025 | 120 | 3 |
126163 | 126163 | 2020-05-08 | Clinton | Ohio | 39027 | 33 | 0 |
126164 | 126164 | 2020-05-08 | Columbiana | Ohio | 39029 | 313 | 33 |
126165 | 126165 | 2020-05-08 | Coshocton | Ohio | 39031 | 19 | 0 |
126166 | 126166 | 2020-05-08 | Crawford | Ohio | 39033 | 69 | 1 |
126167 | 126167 | 2020-05-08 | Cuyahoga | Ohio | 39035 | 2668 | 143 |
126168 | 126168 | 2020-05-08 | Darke | Ohio | 39037 | 82 | 14 |
126169 | 126169 | 2020-05-08 | Defiance | Ohio | 39039 | 21 | 1 |
126170 | 126170 | 2020-05-08 | Delaware | Ohio | 39041 | 199 | 4 |
126171 | 126171 | 2020-05-08 | Erie | Ohio | 39043 | 78 | 3 |
126172 | 126172 | 2020-05-08 | Fairfield | Ohio | 39045 | 171 | 2 |
126173 | 126173 | 2020-05-08 | Fayette | Ohio | 39047 | 23 | 0 |
126174 | 126174 | 2020-05-08 | Franklin | Ohio | 39049 | 3615 | 108 |
126175 | 126175 | 2020-05-08 | Fulton | Ohio | 39051 | 30 | 0 |
126176 | 126176 | 2020-05-08 | Gallia | Ohio | 39053 | 6 | 1 |
126177 | 126177 | 2020-05-08 | Geauga | Ohio | 39055 | 187 | 19 |
126178 | 126178 | 2020-05-08 | Greene | Ohio | 39057 | 52 | 5 |
126179 | 126179 | 2020-05-08 | Guernsey | Ohio | 39059 | 20 | 0 |
126180 | 126180 | 2020-05-08 | Hamilton | Ohio | 39061 | 1664 | 100 |
126181 | 126181 | 2020-05-08 | Hancock | Ohio | 39063 | 39 | 1 |
126182 | 126182 | 2020-05-08 | Hardin | Ohio | 39065 | 27 | 0 |
126183 | 126183 | 2020-05-08 | Harrison | Ohio | 39067 | 6 | 0 |
126184 | 126184 | 2020-05-08 | Henry | Ohio | 39069 | 8 | 0 |
126185 | 126185 | 2020-05-08 | Highland | Ohio | 39071 | 11 | 1 |
126186 | 126186 | 2020-05-08 | Hocking | Ohio | 39073 | 20 | 1 |
126187 | 126187 | 2020-05-08 | Holmes | Ohio | 39075 | 7 | 1 |
126188 | 126188 | 2020-05-08 | Huron | Ohio | 39077 | 37 | 1 |
126189 | 126189 | 2020-05-08 | Jackson | Ohio | 39079 | 7 | 0 |
126190 | 126190 | 2020-05-08 | Jefferson | Ohio | 39081 | 50 | 2 |
126191 | 126191 | 2020-05-08 | Knox | Ohio | 39083 | 20 | 1 |
126192 | 126192 | 2020-05-08 | Lake | Ohio | 39085 | 192 | 8 |
126193 | 126193 | 2020-05-08 | Lawrence | Ohio | 39087 | 24 | 0 |
126194 | 126194 | 2020-05-08 | Licking | Ohio | 39089 | 150 | 7 |
126195 | 126195 | 2020-05-08 | Logan | Ohio | 39091 | 23 | 0 |
126196 | 126196 | 2020-05-08 | Lorain | Ohio | 39093 | 537 | 44 |
126197 | 126197 | 2020-05-08 | Lucas | Ohio | 39095 | 1665 | 161 |
126198 | 126198 | 2020-05-08 | Madison | Ohio | 39097 | 78 | 3 |
126199 | 126199 | 2020-05-08 | Mahoning | Ohio | 39099 | 1087 | 119 |
126200 | 126200 | 2020-05-08 | Marion | Ohio | 39101 | 2366 | 13 |
126201 | 126201 | 2020-05-08 | Medina | Ohio | 39103 | 190 | 17 |
126202 | 126202 | 2020-05-08 | Meigs | Ohio | 39105 | 3 | 0 |
126203 | 126203 | 2020-05-08 | Mercer | Ohio | 39107 | 62 | 1 |
126204 | 126204 | 2020-05-08 | Miami | Ohio | 39109 | 176 | 27 |
126205 | 126205 | 2020-05-08 | Monroe | Ohio | 39111 | 8 | 0 |
126206 | 126206 | 2020-05-08 | Montgomery | Ohio | 39113 | 356 | 10 |
126207 | 126207 | 2020-05-08 | Morgan | Ohio | 39115 | 5 | 0 |
126208 | 126208 | 2020-05-08 | Morrow | Ohio | 39117 | 84 | 1 |
126209 | 126209 | 2020-05-08 | Muskingum | Ohio | 39119 | 24 | 0 |
126210 | 126210 | 2020-05-08 | Noble | Ohio | 39121 | 5 | 0 |
126211 | 126211 | 2020-05-08 | Ottawa | Ohio | 39123 | 45 | 2 |
126212 | 126212 | 2020-05-08 | Paulding | Ohio | 39125 | 8 | 0 |
126213 | 126213 | 2020-05-08 | Perry | Ohio | 39127 | 13 | 1 |
126214 | 126214 | 2020-05-08 | Pickaway | Ohio | 39129 | 1842 | 23 |
126215 | 126215 | 2020-05-08 | Pike | Ohio | 39131 | 4 | 0 |
126216 | 126216 | 2020-05-08 | Portage | Ohio | 39133 | 272 | 46 |
126217 | 126217 | 2020-05-08 | Preble | Ohio | 39135 | 27 | 1 |
126218 | 126218 | 2020-05-08 | Putnam | Ohio | 39137 | 75 | 13 |
126219 | 126219 | 2020-05-08 | Richland | Ohio | 39139 | 103 | 2 |
126220 | 126220 | 2020-05-08 | Ross | Ohio | 39141 | 49 | 1 |
126221 | 126221 | 2020-05-08 | Sandusky | Ohio | 39143 | 47 | 7 |
126222 | 126222 | 2020-05-08 | Scioto | Ohio | 39145 | 15 | 0 |
126223 | 126223 | 2020-05-08 | Seneca | Ohio | 39147 | 14 | 1 |
126224 | 126224 | 2020-05-08 | Shelby | Ohio | 39149 | 31 | 1 |
126225 | 126225 | 2020-05-08 | Stark | Ohio | 39151 | 464 | 62 |
126226 | 126226 | 2020-05-08 | Summit | Ohio | 39153 | 867 | 74 |
126227 | 126227 | 2020-05-08 | Trumbull | Ohio | 39155 | 392 | 36 |
126228 | 126228 | 2020-05-08 | Tuscarawas | Ohio | 39157 | 168 | 1 |
126229 | 126229 | 2020-05-08 | Union | Ohio | 39159 | 28 | 0 |
126230 | 126230 | 2020-05-08 | Van Wert | Ohio | 39161 | 3 | 0 |
126231 | 126231 | 2020-05-08 | Vinton | Ohio | 39163 | 10 | 0 |
126232 | 126232 | 2020-05-08 | Warren | Ohio | 39165 | 191 | 13 |
126233 | 126233 | 2020-05-08 | Washington | Ohio | 39167 | 111 | 17 |
126234 | 126234 | 2020-05-08 | Wayne | Ohio | 39169 | 183 | 42 |
126235 | 126235 | 2020-05-08 | Williams | Ohio | 39171 | 44 | 1 |
126236 | 126236 | 2020-05-08 | Wood | Ohio | 39173 | 220 | 29 |
126237 | 126237 | 2020-05-08 | Wyandot | Ohio | 39175 | 26 | 2 |
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);