daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
90,027 rows where province_or_state = "Ohio" sorted by deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-08 | US | Ohio | Muskingum | 39119 | 24 | 0 | 0 | 24 | 39.96575964 | -81.94363275 | 2020-05-09 02:32:35 | Muskingum, Ohio, US |
2020-05-08 | US | Ohio | Noble | 39121 | 5 | 0 | 0 | 5 | 39.76818851 | -81.45937183 | 2020-05-09 02:32:35 | Noble, Ohio, US |
2020-05-08 | US | Ohio | Paulding | 39125 | 8 | 0 | 0 | 8 | 41.11676341 | -84.5801017 | 2020-05-09 02:32:35 | Paulding, Ohio, US |
2020-05-08 | US | Ohio | Scioto | 39145 | 13 | 0 | 0 | 13 | 38.80270163 | -82.98907345 | 2020-05-09 02:32:35 | Scioto, Ohio, US |
2020-05-08 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-05-09 02:32:35 | Unassigned, Ohio, US |
2020-05-08 | US | Ohio | Union | 39159 | 28 | 0 | 0 | 28 | 40.30016061 | -83.37239023 | 2020-05-09 02:32:35 | Union, Ohio, US |
2020-05-08 | US | Ohio | Van Wert | 39161 | 3 | 0 | 0 | 3 | 40.8554138 | -84.59111700000003 | 2020-05-09 02:32:35 | Van Wert, Ohio, US |
2020-05-08 | US | Ohio | Vinton | 39163 | 10 | 0 | 0 | 10 | 39.25208988 | -82.4831444 | 2020-05-09 02:32:35 | Vinton, Ohio, US |
2020-05-08 | US | Ohio | Williams | 39171 | 44 | 0 | 0 | 44 | 41.56052014 | -84.58429552 | 2020-05-09 02:32:35 | Williams, Ohio, US |
2020-07-19 | US | Ohio | Fayette | 39047 | 59 | 0 | 0 | 59 | 39.56021306 | -83.4562016 | 2020-07-20 05:34:40 | Fayette, Ohio, US |
2020-07-19 | US | Ohio | Lawrence | 39087 | 138 | 0 | 0 | 138 | 38.59743452 | -82.53466552 | 2020-07-20 05:34:40 | Lawrence, Ohio, US |
2020-07-19 | US | Ohio | Morgan | 39115 | 14 | 0 | 0 | 14 | 39.62081738 | -81.85308173 | 2020-07-20 05:34:40 | Morgan, Ohio, US |
2020-07-19 | US | Ohio | Muskingum | 39119 | 119 | 0 | 0 | 119 | 39.96575964 | -81.94363275 | 2020-07-20 05:34:40 | Muskingum, Ohio, US |
2020-07-19 | US | Ohio | Noble | 39121 | 16 | 0 | 0 | 16 | 39.76818851 | -81.45937183 | 2020-07-20 05:34:40 | Noble, Ohio, US |
2020-07-19 | US | Ohio | Paulding | 39125 | 41 | 0 | 0 | 41 | 41.11676341 | -84.5801017 | 2020-07-20 05:34:40 | Paulding, Ohio, US |
2020-07-19 | US | Ohio | Scioto | 39145 | 100 | 0 | 0 | 100 | 38.80270163 | -82.98907345 | 2020-07-20 05:34:40 | Scioto, Ohio, US |
2020-07-19 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-07-20 05:34:40 | Unassigned, Ohio, US |
2020-11-18 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-11-19 05:25:23 | Unassigned, Ohio, US |
2020-04-29 | US | Ohio | Adams | 39001 | 5 | 0 | 0 | 5 | 38.84541072 | -83.4718964 | 2020-04-30 02:32:27 | Adams, Ohio, US |
2020-04-29 | US | Ohio | Ashland | 39005 | 6 | 0 | 0 | 6 | 40.84772277 | -82.27280781 | 2020-04-30 02:32:27 | Ashland, Ohio, US |
2020-04-29 | US | Ohio | Brown | 39015 | 11 | 0 | 0 | 11 | 38.93416837 | -83.86788395 | 2020-04-30 02:32:27 | Brown, Ohio, US |
2020-04-29 | US | Ohio | Clinton | 39027 | 29 | 0 | 0 | 29 | 39.41485808 | -83.80852286 | 2020-04-30 02:32:27 | Clinton, Ohio, US |
2020-04-29 | US | Ohio | Coshocton | 39031 | 17 | 0 | 0 | 17 | 40.30096166 | -81.91729018 | 2020-04-30 02:32:27 | Coshocton, Ohio, US |
2020-04-29 | US | Ohio | Crawford | 39033 | 45 | 0 | 0 | 45 | 40.85065156 | -82.91989099 | 2020-04-30 02:32:27 | Crawford, Ohio, US |
2020-04-29 | US | Ohio | Fayette | 39047 | 15 | 0 | 0 | 15 | 39.56021306 | -83.4562016 | 2020-04-30 02:32:27 | Fayette, Ohio, US |
2020-04-29 | US | Ohio | Harrison | 39067 | 4 | 0 | 0 | 4 | 40.29380509 | -81.09068544 | 2020-04-30 02:32:27 | Harrison, Ohio, US |
2020-04-29 | US | Ohio | Highland | 39071 | 11 | 0 | 0 | 11 | 39.1839264 | -83.60331456 | 2020-04-30 02:32:27 | Highland, Ohio, US |
2020-04-29 | US | Ohio | Lawrence | 39087 | 24 | 0 | 0 | 24 | 38.59743452 | -82.53466552 | 2020-04-30 02:32:27 | Lawrence, Ohio, US |
2020-04-29 | US | Ohio | Morgan | 39115 | 4 | 0 | 0 | 4 | 39.62081738 | -81.85308173 | 2020-04-30 02:32:27 | Morgan, Ohio, US |
2020-04-29 | US | Ohio | Muskingum | 39119 | 10 | 0 | 0 | 10 | 39.96575964 | -81.94363275 | 2020-04-30 02:32:27 | Muskingum, Ohio, US |
2020-04-29 | US | Ohio | Noble | 39121 | 5 | 0 | 0 | 5 | 39.76818851 | -81.45937183 | 2020-04-30 02:32:27 | Noble, Ohio, US |
2020-04-29 | US | Ohio | Paulding | 39125 | 8 | 0 | 0 | 8 | 41.11676341 | -84.5801017 | 2020-04-30 02:32:27 | Paulding, Ohio, US |
2020-04-29 | US | Ohio | Perry | 39127 | 12 | 0 | 0 | 12 | 39.73508655 | -82.23804971 | 2020-04-30 02:32:27 | Perry, Ohio, US |
2020-04-29 | US | Ohio | Scioto | 39145 | 8 | 0 | 0 | 8 | 38.80270163 | -82.98907345 | 2020-04-30 02:32:27 | Scioto, Ohio, US |
2020-04-29 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-04-30 02:32:27 | Unassigned, Ohio, US |
2020-04-29 | US | Ohio | Union | 39159 | 19 | 0 | 0 | 19 | 40.30016061 | -83.37239023 | 2020-04-30 02:32:27 | Union, Ohio, US |
2020-04-29 | US | Ohio | Van Wert | 39161 | 3 | 0 | 0 | 3 | 40.8554138 | -84.59111700000003 | 2020-04-30 02:32:27 | Van Wert, Ohio, US |
2020-04-29 | US | Ohio | Vinton | 39163 | 5 | 0 | 0 | 5 | 39.25208988 | -82.4831444 | 2020-04-30 02:32:27 | Vinton, Ohio, US |
2020-04-29 | US | Ohio | Williams | 39171 | 33 | 0 | 0 | 33 | 41.56052014 | -84.58429552 | 2020-04-30 02:32:27 | Williams, Ohio, US |
2020-08-15 | US | Ohio | Fayette | 39047 | 129 | 0 | 0 | 129 | 39.56021306 | -83.4562016 | 2020-08-16 04:27:42 | Fayette, Ohio, US |
2020-08-15 | US | Ohio | Morgan | 39115 | 33 | 0 | 0 | 33 | 39.62081738 | -81.85308173 | 2020-08-16 04:27:42 | Morgan, Ohio, US |
2020-08-15 | US | Ohio | Muskingum | 39119 | 266 | 0 | 0 | 266 | 39.96575964 | -81.94363275 | 2020-08-16 04:27:42 | Muskingum, Ohio, US |
2020-08-15 | US | Ohio | Noble | 39121 | 19 | 0 | 0 | 19 | 39.76818851 | -81.45937183 | 2020-08-16 04:27:42 | Noble, Ohio, US |
2020-08-15 | US | Ohio | Paulding | 39125 | 74 | 0 | 0 | 74 | 41.11676341 | -84.5801017 | 2020-08-16 04:27:42 | Paulding, Ohio, US |
2020-08-15 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-08-16 04:27:42 | Unassigned, Ohio, US |
2021-01-08 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2021-01-09 05:22:18 | Unassigned, Ohio, US |
2020-07-27 | US | Ohio | Fayette | 39047 | 71 | 0 | 0 | 71 | 39.56021306 | -83.4562016 | 2020-07-28 04:58:43 | Fayette, Ohio, US |
2020-07-27 | US | Ohio | Lawrence | 39087 | 186 | 0 | 0 | 186 | 38.59743452 | -82.53466552 | 2020-07-28 04:58:43 | Lawrence, Ohio, US |
2020-07-27 | US | Ohio | Morgan | 39115 | 16 | 0 | 0 | 16 | 39.62081738 | -81.85308173 | 2020-07-28 04:58:43 | Morgan, Ohio, US |
2020-07-27 | US | Ohio | Muskingum | 39119 | 150 | 0 | 0 | 150 | 39.96575964 | -81.94363275 | 2020-07-28 04:58:43 | Muskingum, Ohio, US |
2020-07-27 | US | Ohio | Noble | 39121 | 16 | 0 | 0 | 16 | 39.76818851 | -81.45937183 | 2020-07-28 04:58:43 | Noble, Ohio, US |
2020-07-27 | US | Ohio | Paulding | 39125 | 55 | 0 | 0 | 55 | 41.11676341 | -84.5801017 | 2020-07-28 04:58:43 | Paulding, Ohio, US |
2020-07-27 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-07-28 04:58:43 | Unassigned, Ohio, US |
2021-02-21 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2021-02-22 05:24:21 | Unassigned, Ohio, US |
2021-01-11 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2021-01-12 05:22:15 | Unassigned, Ohio, US |
2020-08-31 | US | Ohio | Morgan | 39115 | 44 | 0 | 0 | 44 | 39.62081738 | -81.85308173 | 2020-09-01 04:28:31 | Morgan, Ohio, US |
2020-08-31 | US | Ohio | Noble | 39121 | 22 | 0 | 0 | 22 | 39.76818851 | -81.45937183 | 2020-09-01 04:28:31 | Noble, Ohio, US |
2020-08-31 | US | Ohio | Paulding | 39125 | 79 | 0 | 0 | 79 | 41.11676341 | -84.5801017 | 2020-09-01 04:28:31 | Paulding, Ohio, US |
2020-08-31 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-09-01 04:28:31 | Unassigned, Ohio, US |
2020-12-25 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-12-26 05:22:28 | Unassigned, Ohio, US |
2020-08-19 | US | Ohio | Fayette | 39047 | 142 | 0 | 0 | 142 | 39.56021306 | -83.4562016 | 2020-08-20 04:27:43 | Fayette, Ohio, US |
2020-08-19 | US | Ohio | Morgan | 39115 | 36 | 0 | 0 | 36 | 39.62081738 | -81.85308173 | 2020-08-20 04:27:43 | Morgan, Ohio, US |
2020-08-19 | US | Ohio | Noble | 39121 | 20 | 0 | 0 | 20 | 39.76818851 | -81.45937183 | 2020-08-20 04:27:43 | Noble, Ohio, US |
2020-08-19 | US | Ohio | Paulding | 39125 | 75 | 0 | 0 | 75 | 41.11676341 | -84.5801017 | 2020-08-20 04:27:43 | Paulding, Ohio, US |
2020-08-19 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-08-20 04:27:43 | Unassigned, Ohio, US |
2020-10-29 | US | Ohio | Morgan | 39115 | 97 | 0 | 0 | 97 | 39.62081738 | -81.85308173 | 2020-10-30 04:24:49 | Morgan, Ohio, US |
2020-10-29 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-10-30 04:24:49 | Unassigned, Ohio, US |
2020-06-08 | US | Ohio | Fayette | 39047 | 43 | 0 | 0 | 43 | 39.56021306 | -83.4562016 | 2020-06-09 03:33:03 | Fayette, Ohio, US |
2020-06-08 | US | Ohio | Harrison | 39067 | 10 | 0 | 0 | 10 | 40.29380509 | -81.09068544 | 2020-06-09 03:33:03 | Harrison, Ohio, US |
2020-06-08 | US | Ohio | Lawrence | 39087 | 30 | 0 | 0 | 30 | 38.59743452 | -82.53466552 | 2020-06-09 03:33:03 | Lawrence, Ohio, US |
2020-06-08 | US | Ohio | Morgan | 39115 | 6 | 0 | 0 | 6 | 39.62081738 | -81.85308173 | 2020-06-09 03:33:03 | Morgan, Ohio, US |
2020-06-08 | US | Ohio | Muskingum | 39119 | 57 | 0 | 0 | 57 | 39.96575964 | -81.94363275 | 2020-06-09 03:33:03 | Muskingum, Ohio, US |
2020-06-08 | US | Ohio | Noble | 39121 | 6 | 0 | 0 | 6 | 39.76818851 | -81.45937183 | 2020-06-09 03:33:03 | Noble, Ohio, US |
2020-06-08 | US | Ohio | Paulding | 39125 | 14 | 0 | 0 | 14 | 41.11676341 | -84.5801017 | 2020-06-09 03:33:03 | Paulding, Ohio, US |
2020-06-08 | US | Ohio | Scioto | 39145 | 19 | 0 | 0 | 19 | 38.80270163 | -82.98907345 | 2020-06-09 03:33:03 | Scioto, Ohio, US |
2020-06-08 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-06-09 03:33:03 | Unassigned, Ohio, US |
2020-06-08 | US | Ohio | Van Wert | 39161 | 8 | 0 | 0 | 8 | 40.8554138 | -84.59111700000003 | 2020-06-09 03:33:03 | Van Wert, Ohio, US |
2020-06-08 | US | Ohio | Williams | 39171 | 58 | 0 | 0 | 58 | 41.56052014 | -84.58429552 | 2020-06-09 03:33:03 | Williams, Ohio, US |
2020-04-30 | US | Ohio | Adams | 39001 | 4 | 0 | 0 | 4 | 38.84541072 | -83.4718964 | 2020-05-01 02:32:28 | Adams, Ohio, US |
2020-04-30 | US | Ohio | Ashland | 39005 | 7 | 0 | 0 | 7 | 40.84772277 | -82.27280781 | 2020-05-01 02:32:28 | Ashland, Ohio, US |
2020-04-30 | US | Ohio | Brown | 39015 | 11 | 0 | 0 | 11 | 38.93416837 | -83.86788395 | 2020-05-01 02:32:28 | Brown, Ohio, US |
2020-04-30 | US | Ohio | Clinton | 39027 | 29 | 0 | 0 | 29 | 39.41485808 | -83.80852286 | 2020-05-01 02:32:28 | Clinton, Ohio, US |
2020-04-30 | US | Ohio | Coshocton | 39031 | 17 | 0 | 0 | 17 | 40.30096166 | -81.91729018 | 2020-05-01 02:32:28 | Coshocton, Ohio, US |
2020-04-30 | US | Ohio | Crawford | 39033 | 45 | 0 | 0 | 45 | 40.85065156 | -82.91989099 | 2020-05-01 02:32:28 | Crawford, Ohio, US |
2020-04-30 | US | Ohio | Fayette | 39047 | 15 | 0 | 0 | 15 | 39.56021306 | -83.4562016 | 2020-05-01 02:32:28 | Fayette, Ohio, US |
2020-04-30 | US | Ohio | Harrison | 39067 | 4 | 0 | 0 | 4 | 40.29380509 | -81.09068544 | 2020-05-01 02:32:28 | Harrison, Ohio, US |
2020-04-30 | US | Ohio | Highland | 39071 | 11 | 0 | 0 | 11 | 39.1839264 | -83.60331456 | 2020-05-01 02:32:28 | Highland, Ohio, US |
2020-04-30 | US | Ohio | Lawrence | 39087 | 24 | 0 | 0 | 24 | 38.59743452 | -82.53466552 | 2020-05-01 02:32:28 | Lawrence, Ohio, US |
2020-04-30 | US | Ohio | Morgan | 39115 | 4 | 0 | 0 | 4 | 39.62081738 | -81.85308173 | 2020-05-01 02:32:28 | Morgan, Ohio, US |
2020-04-30 | US | Ohio | Muskingum | 39119 | 12 | 0 | 0 | 12 | 39.96575964 | -81.94363275 | 2020-05-01 02:32:28 | Muskingum, Ohio, US |
2020-04-30 | US | Ohio | Noble | 39121 | 5 | 0 | 0 | 5 | 39.76818851 | -81.45937183 | 2020-05-01 02:32:28 | Noble, Ohio, US |
2020-04-30 | US | Ohio | Paulding | 39125 | 8 | 0 | 0 | 8 | 41.11676341 | -84.5801017 | 2020-05-01 02:32:28 | Paulding, Ohio, US |
2020-04-30 | US | Ohio | Perry | 39127 | 12 | 0 | 0 | 12 | 39.73508655 | -82.23804971 | 2020-05-01 02:32:28 | Perry, Ohio, US |
2020-04-30 | US | Ohio | Scioto | 39145 | 10 | 0 | 0 | 10 | 38.80270163 | -82.98907345 | 2020-05-01 02:32:28 | Scioto, Ohio, US |
2020-04-30 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-05-01 02:32:28 | Unassigned, Ohio, US |
2020-04-30 | US | Ohio | Union | 39159 | 22 | 0 | 0 | 22 | 40.30016061 | -83.37239023 | 2020-05-01 02:32:28 | Union, Ohio, US |
2020-04-30 | US | Ohio | Van Wert | 39161 | 3 | 0 | 0 | 3 | 40.8554138 | -84.59111700000003 | 2020-05-01 02:32:28 | Van Wert, Ohio, US |
2020-04-30 | US | Ohio | Vinton | 39163 | 6 | 0 | 0 | 6 | 39.25208988 | -82.4831444 | 2020-05-01 02:32:28 | Vinton, Ohio, US |
2020-04-30 | US | Ohio | Williams | 39171 | 34 | 0 | 0 | 34 | 41.56052014 | -84.58429552 | 2020-05-01 02:32:28 | Williams, Ohio, US |
2021-01-18 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2021-01-19 05:22:15 | Unassigned, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;