daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
178 rows where "last_update" is on date 2022-04-13 and province_or_state = "Ohio" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-04-12 | US | Ohio | Adams | 39001 | 6966 | 149 | 0 | 38.84541072 | -83.4718964 | 2022-04-13 04:21:03 | Adams, Ohio, US | |
2022-04-13 | US | Ohio | Adams | 39001 | 6966 | 149 | 0 | 38.84541072 | -83.4718964 | 2022-04-13 23:21:06 | Adams, Ohio, US | |
2022-04-12 | US | Ohio | Allen | 39003 | 27433 | 479 | 0 | 40.77285242 | -84.10802343 | 2022-04-13 04:21:03 | Allen, Ohio, US | |
2022-04-13 | US | Ohio | Allen | 39003 | 27433 | 479 | 0 | 40.77285242 | -84.10802343 | 2022-04-13 23:21:06 | Allen, Ohio, US | |
2022-04-12 | US | Ohio | Ashland | 39005 | 11959 | 218 | 0 | 40.84772277 | -82.27280781 | 2022-04-13 04:21:03 | Ashland, Ohio, US | |
2022-04-13 | US | Ohio | Ashland | 39005 | 11959 | 218 | 0 | 40.84772277 | -82.27280781 | 2022-04-13 23:21:06 | Ashland, Ohio, US | |
2022-04-12 | US | Ohio | Ashtabula | 39007 | 19820 | 432 | 0 | 41.70860332 | -80.74830218 | 2022-04-13 04:21:03 | Ashtabula, Ohio, US | |
2022-04-13 | US | Ohio | Ashtabula | 39007 | 19820 | 432 | 0 | 41.70860332 | -80.74830218 | 2022-04-13 23:21:06 | Ashtabula, Ohio, US | |
2022-04-12 | US | Ohio | Athens | 39009 | 14511 | 142 | 0 | 39.33425634 | -82.04278644 | 2022-04-13 04:21:03 | Athens, Ohio, US | |
2022-04-13 | US | Ohio | Athens | 39009 | 14511 | 142 | 0 | 39.33425634 | -82.04278644 | 2022-04-13 23:21:06 | Athens, Ohio, US | |
2022-04-12 | US | Ohio | Auglaize | 39011 | 11574 | 190 | 0 | 40.55998859 | -84.22421429999999 | 2022-04-13 04:21:03 | Auglaize, Ohio, US | |
2022-04-13 | US | Ohio | Auglaize | 39011 | 11574 | 190 | 0 | 40.55998859 | -84.22421429999999 | 2022-04-13 23:21:06 | Auglaize, Ohio, US | |
2022-04-12 | US | Ohio | Belmont | 39013 | 15667 | 310 | 0 | 40.01625942 | -80.9924051 | 2022-04-13 04:21:03 | Belmont, Ohio, US | |
2022-04-13 | US | Ohio | Belmont | 39013 | 15667 | 310 | 0 | 40.01625942 | -80.9924051 | 2022-04-13 23:21:06 | Belmont, Ohio, US | |
2022-04-12 | US | Ohio | Brown | 39015 | 11179 | 182 | 0 | 38.93416837 | -83.86788395 | 2022-04-13 04:21:03 | Brown, Ohio, US | |
2022-04-13 | US | Ohio | Brown | 39015 | 11179 | 182 | 0 | 38.93416837 | -83.86788395 | 2022-04-13 23:21:06 | Brown, Ohio, US | |
2022-04-12 | US | Ohio | Butler | 39017 | 92752 | 1155 | 0 | 39.44012838 | -84.57388716 | 2022-04-13 04:21:03 | Butler, Ohio, US | |
2022-04-13 | US | Ohio | Butler | 39017 | 92752 | 1156 | 0 | 39.44012838 | -84.57388716 | 2022-04-13 23:21:06 | Butler, Ohio, US | |
2022-04-12 | US | Ohio | Carroll | 39019 | 5253 | 127 | 0 | 40.578968599999996 | -81.09178213 | 2022-04-13 04:21:03 | Carroll, Ohio, US | |
2022-04-13 | US | Ohio | Carroll | 39019 | 5253 | 127 | 0 | 40.578968599999996 | -81.09178213 | 2022-04-13 23:21:06 | Carroll, Ohio, US | |
2022-04-12 | US | Ohio | Champaign | 39021 | 8715 | 147 | 0 | 40.13923427 | -83.76875242 | 2022-04-13 04:21:03 | Champaign, Ohio, US | |
2022-04-13 | US | Ohio | Champaign | 39021 | 8715 | 147 | 0 | 40.13923427 | -83.76875242 | 2022-04-13 23:21:06 | Champaign, Ohio, US | |
2022-04-12 | US | Ohio | Clark | 39023 | 34938 | 583 | 0 | 39.91592258 | -83.78498252 | 2022-04-13 04:21:03 | Clark, Ohio, US | |
2022-04-13 | US | Ohio | Clark | 39023 | 34938 | 583 | 0 | 39.91592258 | -83.78498252 | 2022-04-13 23:21:06 | Clark, Ohio, US | |
2022-04-12 | US | Ohio | Clermont | 39025 | 51283 | 558 | 0 | 39.04847534 | -84.15375786 | 2022-04-13 04:21:03 | Clermont, Ohio, US | |
2022-04-13 | US | Ohio | Clermont | 39025 | 51283 | 558 | 0 | 39.04847534 | -84.15375786 | 2022-04-13 23:21:06 | Clermont, Ohio, US | |
2022-04-12 | US | Ohio | Clinton | 39027 | 10307 | 169 | 0 | 39.41485808 | -83.80852286 | 2022-04-13 04:21:03 | Clinton, Ohio, US | |
2022-04-13 | US | Ohio | Clinton | 39027 | 10307 | 169 | 0 | 39.41485808 | -83.80852286 | 2022-04-13 23:21:06 | Clinton, Ohio, US | |
2022-04-12 | US | Ohio | Columbiana | 39029 | 24374 | 488 | 0 | 40.76932373 | -80.78094576 | 2022-04-13 04:21:03 | Columbiana, Ohio, US | |
2022-04-13 | US | Ohio | Columbiana | 39029 | 24374 | 488 | 0 | 40.76932373 | -80.78094576 | 2022-04-13 23:21:06 | Columbiana, Ohio, US | |
2022-04-12 | US | Ohio | Coshocton | 39031 | 7946 | 160 | 0 | 40.30096166 | -81.91729018 | 2022-04-13 04:21:03 | Coshocton, Ohio, US | |
2022-04-13 | US | Ohio | Coshocton | 39031 | 7946 | 160 | 0 | 40.30096166 | -81.91729018 | 2022-04-13 23:21:06 | Coshocton, Ohio, US | |
2022-04-12 | US | Ohio | Crawford | 39033 | 11177 | 216 | 0 | 40.85065156 | -82.91989099 | 2022-04-13 04:21:03 | Crawford, Ohio, US | |
2022-04-13 | US | Ohio | Crawford | 39033 | 11177 | 216 | 0 | 40.85065156 | -82.91989099 | 2022-04-13 23:21:06 | Crawford, Ohio, US | |
2022-04-12 | US | Ohio | Cuyahoga | 39035 | 268759 | 3800 | 0 | 41.424119 | -81.65918339 | 2022-04-13 04:21:03 | Cuyahoga, Ohio, US | |
2022-04-13 | US | Ohio | Cuyahoga | 39035 | 268759 | 3800 | 0 | 41.424119 | -81.65918339 | 2022-04-13 23:21:06 | Cuyahoga, Ohio, US | |
2022-04-12 | US | Ohio | Darke | 39037 | 12371 | 239 | 0 | 40.13412966 | -84.6194517 | 2022-04-13 04:21:03 | Darke, Ohio, US | |
2022-04-13 | US | Ohio | Darke | 39037 | 12371 | 239 | 0 | 40.13412966 | -84.6194517 | 2022-04-13 23:21:06 | Darke, Ohio, US | |
2022-04-12 | US | Ohio | Defiance | 39039 | 10209 | 166 | 0 | 41.32398837 | -84.49076944 | 2022-04-13 04:21:03 | Defiance, Ohio, US | |
2022-04-13 | US | Ohio | Defiance | 39039 | 10209 | 166 | 0 | 41.32398837 | -84.49076944 | 2022-04-13 23:21:06 | Defiance, Ohio, US | |
2022-04-12 | US | Ohio | Delaware | 39041 | 44255 | 272 | 0 | 40.27942393 | -83.00457058 | 2022-04-13 04:21:03 | Delaware, Ohio, US | |
2022-04-13 | US | Ohio | Delaware | 39041 | 44255 | 272 | 0 | 40.27942393 | -83.00457058 | 2022-04-13 23:21:06 | Delaware, Ohio, US | |
2022-04-12 | US | Ohio | Erie | 39043 | 19434 | 268 | 0 | 41.36796058 | -82.62904521 | 2022-04-13 04:21:03 | Erie, Ohio, US | |
2022-04-13 | US | Ohio | Erie | 39043 | 19434 | 268 | 0 | 41.36796058 | -82.62904521 | 2022-04-13 23:21:06 | Erie, Ohio, US | |
2022-04-12 | US | Ohio | Fairfield | 39045 | 38473 | 430 | 0 | 39.75107189 | -82.63088163 | 2022-04-13 04:21:03 | Fairfield, Ohio, US | |
2022-04-13 | US | Ohio | Fairfield | 39045 | 38473 | 430 | 0 | 39.75107189 | -82.63088163 | 2022-04-13 23:21:06 | Fairfield, Ohio, US | |
2022-04-12 | US | Ohio | Fayette | 39047 | 7783 | 122 | 0 | 39.56021306 | -83.4562016 | 2022-04-13 04:21:03 | Fayette, Ohio, US | |
2022-04-13 | US | Ohio | Fayette | 39047 | 7783 | 122 | 0 | 39.56021306 | -83.4562016 | 2022-04-13 23:21:06 | Fayette, Ohio, US | |
2022-04-12 | US | Ohio | Franklin | 39049 | 289003 | 2614 | 0 | 39.96995815 | -83.01115755 | 2022-04-13 04:21:03 | Franklin, Ohio, US | |
2022-04-13 | US | Ohio | Franklin | 39049 | 289003 | 2615 | 0 | 39.96995815 | -83.01115755 | 2022-04-13 23:21:06 | Franklin, Ohio, US | |
2022-04-12 | US | Ohio | Fulton | 39051 | 10320 | 179 | 0 | 41.60213491 | -84.12571393 | 2022-04-13 04:21:03 | Fulton, Ohio, US | |
2022-04-13 | US | Ohio | Fulton | 39051 | 10320 | 179 | 0 | 41.60213491 | -84.12571393 | 2022-04-13 23:21:06 | Fulton, Ohio, US | |
2022-04-12 | US | Ohio | Gallia | 39053 | 7481 | 128 | 0 | 38.82708533 | -82.31647569 | 2022-04-13 04:21:03 | Gallia, Ohio, US | |
2022-04-13 | US | Ohio | Gallia | 39053 | 7481 | 128 | 0 | 38.82708533 | -82.31647569 | 2022-04-13 23:21:06 | Gallia, Ohio, US | |
2022-04-12 | US | Ohio | Geauga | 39055 | 16022 | 266 | 0 | 41.49952319 | -81.17935342 | 2022-04-13 04:21:03 | Geauga, Ohio, US | |
2022-04-13 | US | Ohio | Geauga | 39055 | 16022 | 266 | 0 | 41.49952319 | -81.17935342 | 2022-04-13 23:21:06 | Geauga, Ohio, US | |
2022-04-12 | US | Ohio | Greene | 39057 | 37509 | 511 | 0 | 39.69116283 | -83.89032084 | 2022-04-13 04:21:03 | Greene, Ohio, US | |
2022-04-13 | US | Ohio | Greene | 39057 | 37509 | 511 | 0 | 39.69116283 | -83.89032084 | 2022-04-13 23:21:06 | Greene, Ohio, US | |
2022-04-12 | US | Ohio | Guernsey | 39059 | 10458 | 152 | 0 | 40.05026529 | -81.49248905 | 2022-04-13 04:21:03 | Guernsey, Ohio, US | |
2022-04-13 | US | Ohio | Guernsey | 39059 | 10458 | 152 | 0 | 40.05026529 | -81.49248905 | 2022-04-13 23:21:06 | Guernsey, Ohio, US | |
2022-04-12 | US | Ohio | Hamilton | 39061 | 187652 | 2070 | 0 | 39.19673558 | -84.54502924 | 2022-04-13 04:21:03 | Hamilton, Ohio, US | |
2022-04-13 | US | Ohio | Hamilton | 39061 | 187652 | 2070 | 0 | 39.19673558 | -84.54502924 | 2022-04-13 23:21:06 | Hamilton, Ohio, US | |
2022-04-12 | US | Ohio | Hancock | 39063 | 17091 | 276 | 0 | 41.00250487 | -83.66838948 | 2022-04-13 04:21:03 | Hancock, Ohio, US | |
2022-04-13 | US | Ohio | Hancock | 39063 | 17091 | 276 | 0 | 41.00250487 | -83.66838948 | 2022-04-13 23:21:06 | Hancock, Ohio, US | |
2022-04-12 | US | Ohio | Hardin | 39065 | 7067 | 158 | 0 | 40.66015414 | -83.65929931 | 2022-04-13 04:21:03 | Hardin, Ohio, US | |
2022-04-13 | US | Ohio | Hardin | 39065 | 7067 | 158 | 0 | 40.66015414 | -83.65929931 | 2022-04-13 23:21:06 | Hardin, Ohio, US | |
2022-04-12 | US | Ohio | Harrison | 39067 | 3227 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-04-13 04:21:03 | Harrison, Ohio, US | |
2022-04-13 | US | Ohio | Harrison | 39067 | 3227 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-04-13 23:21:06 | Harrison, Ohio, US | |
2022-04-12 | US | Ohio | Henry | 39069 | 6424 | 107 | 0 | 41.333964200000004 | -84.06830637 | 2022-04-13 04:21:03 | Henry, Ohio, US | |
2022-04-13 | US | Ohio | Henry | 39069 | 6424 | 107 | 0 | 41.333964200000004 | -84.06830637 | 2022-04-13 23:21:06 | Henry, Ohio, US | |
2022-04-12 | US | Ohio | Highland | 39071 | 10600 | 184 | 0 | 39.1839264 | -83.60331456 | 2022-04-13 04:21:03 | Highland, Ohio, US | |
2022-04-13 | US | Ohio | Highland | 39071 | 10600 | 184 | 0 | 39.1839264 | -83.60331456 | 2022-04-13 23:21:06 | Highland, Ohio, US | |
2022-04-12 | US | Ohio | Hocking | 39073 | 6668 | 122 | 0 | 39.49537927 | -82.47991446 | 2022-04-13 04:21:03 | Hocking, Ohio, US | |
2022-04-13 | US | Ohio | Hocking | 39073 | 6668 | 122 | 0 | 39.49537927 | -82.47991446 | 2022-04-13 23:21:06 | Hocking, Ohio, US | |
2022-04-12 | US | Ohio | Holmes | 39075 | 5106 | 183 | 0 | 40.56163713 | -81.92635677 | 2022-04-13 04:21:03 | Holmes, Ohio, US | |
2022-04-13 | US | Ohio | Holmes | 39075 | 5106 | 183 | 0 | 40.56163713 | -81.92635677 | 2022-04-13 23:21:06 | Holmes, Ohio, US | |
2022-04-12 | US | Ohio | Huron | 39077 | 14484 | 222 | 0 | 41.14651175 | -82.59867951 | 2022-04-13 04:21:03 | Huron, Ohio, US | |
2022-04-13 | US | Ohio | Huron | 39077 | 14484 | 222 | 0 | 41.14651175 | -82.59867951 | 2022-04-13 23:21:06 | Huron, Ohio, US | |
2022-04-12 | US | Ohio | Jackson | 39079 | 8906 | 141 | 0 | 39.01914254 | -82.61818559999998 | 2022-04-13 04:21:03 | Jackson, Ohio, US | |
2022-04-13 | US | Ohio | Jackson | 39079 | 8906 | 141 | 0 | 39.01914254 | -82.61818559999998 | 2022-04-13 23:21:06 | Jackson, Ohio, US | |
2022-04-12 | US | Ohio | Jefferson | 39081 | 14700 | 323 | 0 | 40.38614126 | -80.76259514 | 2022-04-13 04:21:03 | Jefferson, Ohio, US | |
2022-04-13 | US | Ohio | Jefferson | 39081 | 14700 | 323 | 0 | 40.38614126 | -80.76259514 | 2022-04-13 23:21:06 | Jefferson, Ohio, US | |
2022-04-12 | US | Ohio | Knox | 39083 | 13157 | 228 | 0 | 40.39830217 | -82.42027563 | 2022-04-13 04:21:03 | Knox, Ohio, US | |
2022-04-13 | US | Ohio | Knox | 39083 | 13157 | 228 | 0 | 40.39830217 | -82.42027563 | 2022-04-13 23:21:06 | Knox, Ohio, US | |
2022-04-12 | US | Ohio | Lake | 39085 | 48894 | 737 | 0 | 41.69710807 | -81.23676539 | 2022-04-13 04:21:03 | Lake, Ohio, US | |
2022-04-13 | US | Ohio | Lake | 39085 | 48894 | 737 | 0 | 41.69710807 | -81.23676539 | 2022-04-13 23:21:06 | Lake, Ohio, US | |
2022-04-12 | US | Ohio | Lawrence | 39087 | 17855 | 256 | 0 | 38.59743452 | -82.53466552 | 2022-04-13 04:21:03 | Lawrence, Ohio, US | |
2022-04-13 | US | Ohio | Lawrence | 39087 | 17855 | 256 | 0 | 38.59743452 | -82.53466552 | 2022-04-13 23:21:06 | Lawrence, Ohio, US | |
2022-04-12 | US | Ohio | Licking | 39089 | 41662 | 475 | 0 | 40.09136236 | -82.48185785 | 2022-04-13 04:21:03 | Licking, Ohio, US | |
2022-04-13 | US | Ohio | Licking | 39089 | 41662 | 475 | 0 | 40.09136236 | -82.48185785 | 2022-04-13 23:21:06 | Licking, Ohio, US | |
2022-04-12 | US | Ohio | Logan | 39091 | 10225 | 176 | 0 | 40.38996525 | -83.76784341 | 2022-04-13 04:21:03 | Logan, Ohio, US | |
2022-04-13 | US | Ohio | Logan | 39091 | 10225 | 176 | 0 | 40.38996525 | -83.76784341 | 2022-04-13 23:21:06 | Logan, Ohio, US | |
2022-04-12 | US | Ohio | Lorain | 39093 | 66517 | 976 | 0 | 41.29553751 | -82.15083537 | 2022-04-13 04:21:03 | Lorain, Ohio, US | |
2022-04-13 | US | Ohio | Lorain | 39093 | 66517 | 976 | 0 | 41.29553751 | -82.15083537 | 2022-04-13 23:21:06 | Lorain, Ohio, US | |
2022-04-12 | US | Ohio | Lucas | 39095 | 100143 | 1422 | 0 | 41.62101218 | -83.65468618 | 2022-04-13 04:21:03 | Lucas, Ohio, US | |
2022-04-13 | US | Ohio | Lucas | 39095 | 100143 | 1422 | 0 | 41.62101218 | -83.65468618 | 2022-04-13 23:21:06 | Lucas, Ohio, US | |
2022-04-12 | US | Ohio | Madison | 39097 | 9660 | 134 | 0 | 39.89381073 | -83.40178317 | 2022-04-13 04:21:03 | Madison, Ohio, US | |
2022-04-13 | US | Ohio | Madison | 39097 | 9660 | 134 | 0 | 39.89381073 | -83.40178317 | 2022-04-13 23:21:06 | Madison, Ohio, US | |
2022-04-12 | US | Ohio | Mahoning | 39099 | 53371 | 1086 | 0 | 41.01631101 | -80.77287029 | 2022-04-13 04:21:03 | Mahoning, Ohio, US | |
2022-04-13 | US | Ohio | Mahoning | 39099 | 53371 | 1086 | 0 | 41.01631101 | -80.77287029 | 2022-04-13 23:21:06 | Mahoning, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;