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-01-23 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 |
---|---|---|---|---|---|---|---|
958197 | 958197 | 2021-01-23 | Adams | Ohio | 39001 | 1761 | 15 |
958198 | 958198 | 2021-01-23 | Allen | Ohio | 39003 | 9897 | 126 |
958199 | 958199 | 2021-01-23 | Ashland | Ohio | 39005 | 3449 | 38 |
958200 | 958200 | 2021-01-23 | Ashtabula | Ohio | 39007 | 4530 | 73 |
958201 | 958201 | 2021-01-23 | Athens | Ohio | 39009 | 3800 | 9 |
958202 | 958202 | 2021-01-23 | Auglaize | Ohio | 39011 | 4222 | 64 |
958203 | 958203 | 2021-01-23 | Belmont | Ohio | 39013 | 4168 | 40 |
958204 | 958204 | 2021-01-23 | Brown | Ohio | 39015 | 3129 | 21 |
958205 | 958205 | 2021-01-23 | Butler | Ohio | 39017 | 30973 | 232 |
958206 | 958206 | 2021-01-23 | Carroll | Ohio | 39019 | 1556 | 16 |
958207 | 958207 | 2021-01-23 | Champaign | Ohio | 39021 | 2520 | 28 |
958208 | 958208 | 2021-01-23 | Clark | Ohio | 39023 | 10942 | 265 |
958209 | 958209 | 2021-01-23 | Clermont | Ohio | 39025 | 15926 | 111 |
958210 | 958210 | 2021-01-23 | Clinton | Ohio | 39027 | 2901 | 43 |
958211 | 958211 | 2021-01-23 | Columbiana | Ohio | 39029 | 7327 | 124 |
958212 | 958212 | 2021-01-23 | Coshocton | Ohio | 39031 | 2056 | 22 |
958213 | 958213 | 2021-01-23 | Crawford | Ohio | 39033 | 3223 | 74 |
958214 | 958214 | 2021-01-23 | Cuyahoga | Ohio | 39035 | 85571 | 1125 |
958215 | 958215 | 2021-01-23 | Darke | Ohio | 39037 | 4702 | 92 |
958216 | 958216 | 2021-01-23 | Defiance | Ohio | 39039 | 3300 | 86 |
958217 | 958217 | 2021-01-23 | Delaware | Ohio | 39041 | 14388 | 78 |
958218 | 958218 | 2021-01-23 | Erie | Ohio | 39043 | 6152 | 129 |
958219 | 958219 | 2021-01-23 | Fairfield | Ohio | 39045 | 12793 | 81 |
958220 | 958220 | 2021-01-23 | Fayette | Ohio | 39047 | 2365 | 30 |
958221 | 958221 | 2021-01-23 | Franklin | Ohio | 39049 | 101171 | 707 |
958222 | 958222 | 2021-01-23 | Fulton | Ohio | 39051 | 3384 | 43 |
958223 | 958223 | 2021-01-23 | Gallia | Ohio | 39053 | 1967 | 26 |
958224 | 958224 | 2021-01-23 | Geauga | Ohio | 39055 | 5084 | 55 |
958225 | 958225 | 2021-01-23 | Greene | Ohio | 39057 | 12055 | 137 |
958226 | 958226 | 2021-01-23 | Guernsey | Ohio | 39059 | 2541 | 25 |
958227 | 958227 | 2021-01-23 | Hamilton | Ohio | 39061 | 64017 | 448 |
958228 | 958228 | 2021-01-23 | Hancock | Ohio | 39063 | 5523 | 90 |
958229 | 958229 | 2021-01-23 | Hardin | Ohio | 39065 | 2130 | 33 |
958230 | 958230 | 2021-01-23 | Harrison | Ohio | 39067 | 891 | 21 |
958231 | 958231 | 2021-01-23 | Henry | Ohio | 39069 | 2187 | 49 |
958232 | 958232 | 2021-01-23 | Highland | Ohio | 39071 | 2751 | 18 |
958233 | 958233 | 2021-01-23 | Hocking | Ohio | 39073 | 1720 | 24 |
958234 | 958234 | 2021-01-23 | Holmes | Ohio | 39075 | 2254 | 74 |
958235 | 958235 | 2021-01-23 | Huron | Ohio | 39077 | 4287 | 41 |
958236 | 958236 | 2021-01-23 | Jackson | Ohio | 39079 | 2638 | 45 |
958237 | 958237 | 2021-01-23 | Jefferson | Ohio | 39081 | 4192 | 69 |
958238 | 958238 | 2021-01-23 | Knox | Ohio | 39083 | 3526 | 22 |
958239 | 958239 | 2021-01-23 | Lake | Ohio | 39085 | 16080 | 154 |
958240 | 958240 | 2021-01-23 | Lawrence | Ohio | 39087 | 4526 | 54 |
958241 | 958241 | 2021-01-23 | Licking | Ohio | 39089 | 13204 | 137 |
958242 | 958242 | 2021-01-23 | Logan | Ohio | 39091 | 3073 | 32 |
958243 | 958243 | 2021-01-23 | Lorain | Ohio | 39093 | 19017 | 223 |
958244 | 958244 | 2021-01-23 | Lucas | Ohio | 39095 | 31350 | 625 |
958245 | 958245 | 2021-01-23 | Madison | Ohio | 39097 | 3551 | 29 |
958246 | 958246 | 2021-01-23 | Mahoning | Ohio | 39099 | 17321 | 338 |
958247 | 958247 | 2021-01-23 | Marion | Ohio | 39101 | 7459 | 113 |
958248 | 958248 | 2021-01-23 | Medina | Ohio | 39103 | 11591 | 168 |
958249 | 958249 | 2021-01-23 | Meigs | Ohio | 39105 | 1086 | 24 |
958250 | 958250 | 2021-01-23 | Mercer | Ohio | 39107 | 4335 | 89 |
958251 | 958251 | 2021-01-23 | Miami | Ohio | 39109 | 9168 | 73 |
958252 | 958252 | 2021-01-23 | Monroe | Ohio | 39111 | 1007 | 32 |
958253 | 958253 | 2021-01-23 | Montgomery | Ohio | 39113 | 43107 | 418 |
958254 | 958254 | 2021-01-23 | Morgan | Ohio | 39115 | 831 | 30 |
958255 | 958255 | 2021-01-23 | Morrow | Ohio | 39117 | 2323 | 4 |
958256 | 958256 | 2021-01-23 | Muskingum | Ohio | 39119 | 7031 | 41 |
958257 | 958257 | 2021-01-23 | Noble | Ohio | 39121 | 1205 | 40 |
958258 | 958258 | 2021-01-23 | Ottawa | Ohio | 39123 | 2939 | 43 |
958259 | 958259 | 2021-01-23 | Paulding | Ohio | 39125 | 1443 | 21 |
958260 | 958260 | 2021-01-23 | Perry | Ohio | 39127 | 2313 | 18 |
958261 | 958261 | 2021-01-23 | Pickaway | Ohio | 39129 | 7261 | 50 |
958262 | 958262 | 2021-01-23 | Pike | Ohio | 39131 | 1762 | 17 |
958263 | 958263 | 2021-01-23 | Portage | Ohio | 39133 | 9296 | 109 |
958264 | 958264 | 2021-01-23 | Preble | Ohio | 39135 | 3206 | 37 |
958265 | 958265 | 2021-01-23 | Putnam | Ohio | 39137 | 3749 | 75 |
958266 | 958266 | 2021-01-23 | Richland | Ohio | 39139 | 9139 | 118 |
958267 | 958267 | 2021-01-23 | Ross | Ohio | 39141 | 5489 | 98 |
958268 | 958268 | 2021-01-23 | Sandusky | Ohio | 39143 | 4366 | 62 |
958269 | 958269 | 2021-01-23 | Scioto | Ohio | 39145 | 5391 | 64 |
958270 | 958270 | 2021-01-23 | Seneca | Ohio | 39147 | 4301 | 66 |
958271 | 958271 | 2021-01-23 | Shelby | Ohio | 39149 | 4212 | 22 |
958272 | 958272 | 2021-01-23 | Stark | Ohio | 39151 | 25786 | 435 |
958273 | 958273 | 2021-01-23 | Summit | Ohio | 39153 | 34836 | 761 |
958274 | 958274 | 2021-01-23 | Trumbull | Ohio | 39155 | 12809 | 316 |
958275 | 958275 | 2021-01-23 | Tuscarawas | Ohio | 39157 | 7381 | 182 |
958276 | 958276 | 2021-01-23 | Union | Ohio | 39159 | 4518 | 28 |
958277 | 958277 | 2021-01-23 | Van Wert | Ohio | 39161 | 2022 | 45 |
958278 | 958278 | 2021-01-23 | Vinton | Ohio | 39163 | 702 | 13 |
958279 | 958279 | 2021-01-23 | Warren | Ohio | 39165 | 19671 | 140 |
958280 | 958280 | 2021-01-23 | Washington | Ohio | 39167 | 3887 | 40 |
958281 | 958281 | 2021-01-23 | Wayne | Ohio | 39169 | 7034 | 171 |
958282 | 958282 | 2021-01-23 | Williams | Ohio | 39171 | 2786 | 67 |
958283 | 958283 | 2021-01-23 | Wood | Ohio | 39173 | 10348 | 158 |
958284 | 958284 | 2021-01-23 | Wyandot | Ohio | 39175 | 1960 | 51 |
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);