ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where "date" is on date 2022-03-17 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 |
---|---|---|---|---|---|---|---|
2316096 | 2316096 | 2022-03-17 | Adams | Ohio | 39001 | 6918 | 141 |
2316097 | 2316097 | 2022-03-17 | Allen | Ohio | 39003 | 27379 | 476 |
2316098 | 2316098 | 2022-03-17 | Ashland | Ohio | 39005 | 11930 | 213 |
2316099 | 2316099 | 2022-03-17 | Ashtabula | Ohio | 39007 | 19711 | 418 |
2316100 | 2316100 | 2022-03-17 | Athens | Ohio | 39009 | 14425 | 135 |
2316101 | 2316101 | 2022-03-17 | Auglaize | Ohio | 39011 | 11566 | 184 |
2316102 | 2316102 | 2022-03-17 | Belmont | Ohio | 39013 | 15600 | 291 |
2316103 | 2316103 | 2022-03-17 | Brown | Ohio | 39015 | 11165 | 174 |
2316104 | 2316104 | 2022-03-17 | Butler | Ohio | 39017 | 91520 | 1122 |
2316105 | 2316105 | 2022-03-17 | Carroll | Ohio | 39019 | 5249 | 124 |
2316106 | 2316106 | 2022-03-17 | Champaign | Ohio | 39021 | 8696 | 145 |
2316107 | 2316107 | 2022-03-17 | Clark | Ohio | 39023 | 34903 | 566 |
2316108 | 2316108 | 2022-03-17 | Clermont | Ohio | 39025 | 51131 | 537 |
2316109 | 2316109 | 2022-03-17 | Clinton | Ohio | 39027 | 10292 | 163 |
2316110 | 2316110 | 2022-03-17 | Columbiana | Ohio | 39029 | 24322 | 476 |
2316111 | 2316111 | 2022-03-17 | Coshocton | Ohio | 39031 | 7933 | 155 |
2316112 | 2316112 | 2022-03-17 | Crawford | Ohio | 39033 | 11149 | 209 |
2316113 | 2316113 | 2022-03-17 | Cuyahoga | Ohio | 39035 | 267450 | 3704 |
2316114 | 2316114 | 2022-03-17 | Darke | Ohio | 39037 | 12348 | 233 |
2316115 | 2316115 | 2022-03-17 | Defiance | Ohio | 39039 | 10184 | 163 |
2316116 | 2316116 | 2022-03-17 | Delaware | Ohio | 39041 | 44023 | 269 |
2316117 | 2316117 | 2022-03-17 | Erie | Ohio | 39043 | 19369 | 264 |
2316118 | 2316118 | 2022-03-17 | Fairfield | Ohio | 39045 | 38336 | 422 |
2316119 | 2316119 | 2022-03-17 | Fayette | Ohio | 39047 | 7762 | 116 |
2316120 | 2316120 | 2022-03-17 | Franklin | Ohio | 39049 | 287443 | 2523 |
2316121 | 2316121 | 2022-03-17 | Fulton | Ohio | 39051 | 10305 | 177 |
2316122 | 2316122 | 2022-03-17 | Gallia | Ohio | 39053 | 7462 | 121 |
2316123 | 2316123 | 2022-03-17 | Geauga | Ohio | 39055 | 15961 | 263 |
2316124 | 2316124 | 2022-03-17 | Greene | Ohio | 39057 | 37417 | 503 |
2316125 | 2316125 | 2022-03-17 | Guernsey | Ohio | 39059 | 10429 | 150 |
2316126 | 2316126 | 2022-03-17 | Hamilton | Ohio | 39061 | 186696 | 2008 |
2316127 | 2316127 | 2022-03-17 | Hancock | Ohio | 39063 | 17066 | 271 |
2316128 | 2316128 | 2022-03-17 | Hardin | Ohio | 39065 | 7055 | 150 |
2316129 | 2316129 | 2022-03-17 | Harrison | Ohio | 39067 | 3211 | 73 |
2316130 | 2316130 | 2022-03-17 | Henry | Ohio | 39069 | 6418 | 106 |
2316131 | 2316131 | 2022-03-17 | Highland | Ohio | 39071 | 10595 | 177 |
2316132 | 2316132 | 2022-03-17 | Hocking | Ohio | 39073 | 6609 | 117 |
2316133 | 2316133 | 2022-03-17 | Holmes | Ohio | 39075 | 5098 | 180 |
2316134 | 2316134 | 2022-03-17 | Huron | Ohio | 39077 | 14439 | 221 |
2316135 | 2316135 | 2022-03-17 | Jackson | Ohio | 39079 | 8876 | 138 |
2316136 | 2316136 | 2022-03-17 | Jefferson | Ohio | 39081 | 14655 | 312 |
2316137 | 2316137 | 2022-03-17 | Knox | Ohio | 39083 | 13109 | 226 |
2316138 | 2316138 | 2022-03-17 | Lake | Ohio | 39085 | 48723 | 730 |
2316139 | 2316139 | 2022-03-17 | Lawrence | Ohio | 39087 | 17789 | 233 |
2316140 | 2316140 | 2022-03-17 | Licking | Ohio | 39089 | 41516 | 475 |
2316141 | 2316141 | 2022-03-17 | Logan | Ohio | 39091 | 10196 | 167 |
2316142 | 2316142 | 2022-03-17 | Lorain | Ohio | 39093 | 66311 | 963 |
2316143 | 2316143 | 2022-03-17 | Lucas | Ohio | 39095 | 99438 | 1381 |
2316144 | 2316144 | 2022-03-17 | Madison | Ohio | 39097 | 9639 | 126 |
2316145 | 2316145 | 2022-03-17 | Mahoning | Ohio | 39099 | 53217 | 1061 |
2316146 | 2316146 | 2022-03-17 | Marion | Ohio | 39101 | 19805 | 262 |
2316147 | 2316147 | 2022-03-17 | Medina | Ohio | 39103 | 39906 | 498 |
2316148 | 2316148 | 2022-03-17 | Meigs | Ohio | 39105 | 4592 | 85 |
2316149 | 2316149 | 2022-03-17 | Mercer | Ohio | 39107 | 9673 | 138 |
2316150 | 2316150 | 2022-03-17 | Miami | Ohio | 39109 | 25671 | 473 |
2316151 | 2316151 | 2022-03-17 | Monroe | Ohio | 39111 | 3454 | 80 |
2316152 | 2316152 | 2022-03-17 | Montgomery | Ohio | 39113 | 126462 | 1963 |
2316153 | 2316153 | 2022-03-17 | Morgan | Ohio | 39115 | 3262 | 56 |
2316154 | 2316154 | 2022-03-17 | Morrow | Ohio | 39117 | 7728 | 103 |
2316155 | 2316155 | 2022-03-17 | Muskingum | Ohio | 39119 | 25225 | 292 |
2316156 | 2316156 | 2022-03-17 | Noble | Ohio | 39121 | 3201 | 55 |
2316157 | 2316157 | 2022-03-17 | Ottawa | Ohio | 39123 | 8442 | 136 |
2316158 | 2316158 | 2022-03-17 | Paulding | Ohio | 39125 | 4597 | 74 |
2316159 | 2316159 | 2022-03-17 | Perry | Ohio | 39127 | 8264 | 124 |
2316160 | 2316160 | 2022-03-17 | Pickaway | Ohio | 39129 | 17445 | 225 |
2316161 | 2316161 | 2022-03-17 | Pike | Ohio | 39131 | 7442 | 114 |
2316162 | 2316162 | 2022-03-17 | Portage | Ohio | 39133 | 34016 | 441 |
2316163 | 2316163 | 2022-03-17 | Preble | Ohio | 39135 | 9437 | 194 |
2316164 | 2316164 | 2022-03-17 | Putnam | Ohio | 39137 | 8435 | 154 |
2316165 | 2316165 | 2022-03-17 | Richland | Ohio | 39139 | 31438 | 500 |
2316166 | 2316166 | 2022-03-17 | Ross | Ohio | 39141 | 19188 | 292 |
2316167 | 2316167 | 2022-03-17 | Sandusky | Ohio | 39143 | 13862 | 232 |
2316168 | 2316168 | 2022-03-17 | Scioto | Ohio | 39145 | 20556 | 248 |
2316169 | 2316169 | 2022-03-17 | Seneca | Ohio | 39147 | 12722 | 224 |
2316170 | 2316170 | 2022-03-17 | Shelby | Ohio | 39149 | 11037 | 186 |
2316171 | 2316171 | 2022-03-17 | Stark | Ohio | 39151 | 79566 | 1687 |
2316172 | 2316172 | 2022-03-17 | Summit | Ohio | 39153 | 111887 | 1684 |
2316173 | 2316173 | 2022-03-17 | Trumbull | Ohio | 39155 | 41375 | 924 |
2316174 | 2316174 | 2022-03-17 | Tuscarawas | Ohio | 39157 | 20548 | 488 |
2316175 | 2316175 | 2022-03-17 | Union | Ohio | 39159 | 15557 | 99 |
2316176 | 2316176 | 2022-03-17 | Unknown | Ohio | 0 | 5 | |
2316177 | 2316177 | 2022-03-17 | Van Wert | Ohio | 39161 | 6703 | 143 |
2316178 | 2316178 | 2022-03-17 | Vinton | Ohio | 39163 | 2898 | 55 |
2316179 | 2316179 | 2022-03-17 | Warren | Ohio | 39165 | 57475 | 571 |
2316180 | 2316180 | 2022-03-17 | Washington | Ohio | 39167 | 12327 | 203 |
2316181 | 2316181 | 2022-03-17 | Wayne | Ohio | 39169 | 23068 | 432 |
2316182 | 2316182 | 2022-03-17 | Williams | Ohio | 39171 | 8983 | 161 |
2316183 | 2316183 | 2022-03-17 | Wood | Ohio | 39173 | 31350 | 352 |
2316184 | 2316184 | 2022-03-17 | Wyandot | Ohio | 39175 | 5399 | 103 |
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);