daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
135 rows where country_or_region = "US", deaths = 118 and province_or_state = "Ohio" sorted by day descending
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-03-05 | US | Ohio | Pike | 39131 | 7419 | 118 | 0 | 39.07634001 | -83.06769584 | 2022-03-06 04:20:49 | Pike, Ohio, US | |
2022-03-04 | US | Ohio | Pike | 39131 | 7417 | 118 | 0 | 39.07634001 | -83.06769584 | 2022-03-05 04:21:10 | Pike, Ohio, US | |
2022-02-28 | US | Ohio | Fayette | 39047 | 7747 | 118 | 0 | 39.56021306 | -83.4562016 | 2022-03-01 04:21:09 | Fayette, Ohio, US | |
2022-02-27 | US | Ohio | Fayette | 39047 | 7744 | 118 | 0 | 39.56021306 | -83.4562016 | 2022-02-28 04:21:05 | Fayette, Ohio, US | |
2022-02-27 | US | Ohio | Hocking | 39073 | 6512 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-28 04:21:05 | Hocking, Ohio, US | |
2022-02-26 | US | Ohio | Fayette | 39047 | 7743 | 118 | 0 | 39.56021306 | -83.4562016 | 2022-02-27 04:21:04 | Fayette, Ohio, US | |
2022-02-26 | US | Ohio | Hocking | 39073 | 6511 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-27 04:21:04 | Hocking, Ohio, US | |
2022-02-25 | US | Ohio | Fayette | 39047 | 7739 | 118 | 0 | 39.56021306 | -83.4562016 | 2022-02-26 04:21:12 | Fayette, Ohio, US | |
2022-02-25 | US | Ohio | Hocking | 39073 | 6508 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-26 04:21:12 | Hocking, Ohio, US | |
2022-02-24 | US | Ohio | Fayette | 39047 | 7732 | 118 | 0 | 39.56021306 | -83.4562016 | 2022-02-25 04:21:11 | Fayette, Ohio, US | |
2022-02-24 | US | Ohio | Hocking | 39073 | 6504 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-25 04:21:11 | Hocking, Ohio, US | |
2022-02-23 | US | Ohio | Fayette | 39047 | 7734 | 118 | 0 | 39.56021306 | -83.4562016 | 2022-02-24 04:21:14 | Fayette, Ohio, US | |
2022-02-23 | US | Ohio | Hocking | 39073 | 6497 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-24 04:21:14 | Hocking, Ohio, US | |
2022-02-22 | US | Ohio | Hocking | 39073 | 6476 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-23 04:21:09 | Hocking, Ohio, US | |
2022-02-21 | US | Ohio | Hocking | 39073 | 6469 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-22 04:21:01 | Hocking, Ohio, US | |
2022-02-20 | US | Ohio | Hocking | 39073 | 6464 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-21 04:21:05 | Hocking, Ohio, US | |
2022-02-19 | US | Ohio | Hocking | 39073 | 6461 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-20 04:21:00 | Hocking, Ohio, US | |
2022-02-18 | US | Ohio | Hocking | 39073 | 6455 | 118 | 0 | 39.49537927 | -82.47991446 | 2022-02-19 04:21:11 | Hocking, Ohio, US | |
2022-02-14 | US | Ohio | Gallia | 39053 | 7170 | 118 | 0 | 38.82708533 | -82.31647569 | 2022-02-15 04:21:09 | Gallia, Ohio, US | |
2022-02-02 | US | Ohio | Perry | 39127 | 7878 | 118 | 0 | 39.73508655 | -82.23804971 | 2022-02-03 04:21:21 | Perry, Ohio, US | |
2022-01-28 | US | Ohio | Athens | 39009 | 13257 | 118 | 0 | 39.33425634 | -82.04278644 | 2022-01-29 04:21:10 | Athens, Ohio, US | |
2022-01-26 | US | Ohio | Carroll | 39019 | 5051 | 118 | 0 | 40.578968599999996 | -81.09178213 | 2022-01-27 04:21:19 | Carroll, Ohio, US | |
2022-01-23 | US | Ohio | Madison | 39097 | 9007 | 118 | 0 | 39.89381073 | -83.40178317 | 2022-01-24 04:21:12 | Madison, Ohio, US | |
2022-01-15 | US | Ohio | Mercer | 39107 | 8533 | 118 | 0 | 40.54043046 | -84.62912742 | 2022-01-16 04:21:12 | Mercer, Ohio, US | |
2022-01-14 | US | Ohio | Champaign | 39021 | 7256 | 118 | 0 | 40.13923427 | -83.76875242 | 2022-01-15 04:21:07 | Champaign, Ohio, US | |
2022-01-14 | US | Ohio | Mercer | 39107 | 8302 | 118 | 0 | 40.54043046 | -84.62912742 | 2022-01-15 04:21:07 | Mercer, Ohio, US | |
2022-01-13 | US | Ohio | Mercer | 39107 | 8062 | 118 | 0 | 40.54043046 | -84.62912742 | 2022-01-14 04:21:54 | Mercer, Ohio, US | |
2022-01-12 | US | Ohio | Mercer | 39107 | 8020 | 118 | 0 | 40.54043046 | -84.62912742 | 2022-01-13 08:00:09 | Mercer, Ohio, US | |
2022-01-04 | US | Ohio | Jackson | 39079 | 6513 | 118 | 0 | 39.01914254 | -82.61818559999998 | 2022-01-05 04:21:59 | Jackson, Ohio, US | |
2022-01-03 | US | Ohio | Jackson | 39079 | 6464 | 118 | 0 | 39.01914254 | -82.61818559999998 | 2022-01-04 04:22:17 | Jackson, Ohio, US | |
2021-12-26 | US | Ohio | Van Wert | 39161 | 5012 | 118 | 0 | 40.8554138 | -84.59111700000003 | 2021-12-27 04:21:58 | Van Wert, Ohio, US | |
2021-12-25 | US | Ohio | Van Wert | 39161 | 5005 | 118 | 0 | 40.8554138 | -84.59111700000003 | 2021-12-26 04:21:50 | Van Wert, Ohio, US | |
2021-12-24 | US | Ohio | Van Wert | 39161 | 5005 | 118 | 0 | 40.8554138 | -84.59111700000003 | 2021-12-25 04:21:37 | Van Wert, Ohio, US | |
2021-12-21 | US | Ohio | Ottawa | 39123 | 6094 | 118 | 0 | 41.53781826 | -83.0940185 | 2021-12-22 04:21:54 | Ottawa, Ohio, US | |
2021-12-17 | US | Ohio | Adams | 39001 | 4805 | 118 | 0 | 38.84541072 | -83.4718964 | 2021-12-18 02:22:20 | Adams, Ohio, US | |
2021-12-16 | US | Ohio | Adams | 39001 | 4794 | 118 | 0 | 38.84541072 | -83.4718964 | 2021-12-17 04:22:14 | Adams, Ohio, US | |
2021-12-15 | US | Ohio | Adams | 39001 | 4776 | 118 | 0 | 38.84541072 | -83.4718964 | 2021-12-16 04:22:11 | Adams, Ohio, US | |
2021-12-10 | US | Ohio | Hardin | 39065 | 5092 | 118 | 0 | 40.66015414 | -83.65929931 | 2021-12-11 04:22:45 | Hardin, Ohio, US | |
2021-12-09 | US | Ohio | Hardin | 39065 | 5072 | 118 | 0 | 40.66015414 | -83.65929931 | 2021-12-10 04:22:28 | Hardin, Ohio, US | |
2021-12-07 | US | Ohio | Coshocton | 39031 | 5733 | 118 | 0 | 40.30096166 | -81.91729018 | 2021-12-08 04:22:46 | Coshocton, Ohio, US | |
2021-12-06 | US | Ohio | Coshocton | 39031 | 5700 | 118 | 0 | 40.30096166 | -81.91729018 | 2021-12-07 04:22:34 | Coshocton, Ohio, US | |
2021-11-26 | US | Ohio | Logan | 39091 | 6793 | 118 | 0 | 40.38996525 | -83.76784341 | 2021-11-27 04:22:45 | Logan, Ohio, US | |
2021-11-25 | US | Ohio | Defiance | 39039 | 7117 | 118 | 0 | 41.32398837 | -84.49076944 | 2021-11-26 04:22:33 | Defiance, Ohio, US | |
2021-11-25 | US | Ohio | Logan | 39091 | 6749 | 118 | 0 | 40.38996525 | -83.76784341 | 2021-11-26 04:22:33 | Logan, Ohio, US | |
2021-11-24 | US | Ohio | Defiance | 39039 | 7117 | 118 | 0 | 41.32398837 | -84.49076944 | 2021-11-25 04:22:33 | Defiance, Ohio, US | |
2021-11-24 | US | Ohio | Logan | 39091 | 6749 | 118 | 0 | 40.38996525 | -83.76784341 | 2021-11-25 04:22:33 | Logan, Ohio, US | |
2021-11-23 | US | Ohio | Defiance | 39039 | 7088 | 118 | 0 | 41.32398837 | -84.49076944 | 2021-11-24 04:22:14 | Defiance, Ohio, US | |
2021-11-22 | US | Ohio | Brown | 39015 | 6911 | 118 | 0 | 38.93416837 | -83.86788395 | 2021-11-23 04:22:39 | Brown, Ohio, US | |
2021-11-22 | US | Ohio | Defiance | 39039 | 7044 | 118 | 0 | 41.32398837 | -84.49076944 | 2021-11-23 04:22:39 | Defiance, Ohio, US | |
2021-11-21 | US | Ohio | Brown | 39015 | 6895 | 118 | 0 | 38.93416837 | -83.86788395 | 2021-11-22 04:22:20 | Brown, Ohio, US | |
2021-11-21 | US | Ohio | Defiance | 39039 | 7031 | 118 | 0 | 41.32398837 | -84.49076944 | 2021-11-22 04:22:20 | Defiance, Ohio, US | |
2021-11-20 | US | Ohio | Brown | 39015 | 6885 | 118 | 0 | 38.93416837 | -83.86788395 | 2021-11-21 04:22:13 | Brown, Ohio, US | |
2021-11-20 | US | Ohio | Defiance | 39039 | 7006 | 118 | 0 | 41.32398837 | -84.49076944 | 2021-11-21 04:22:13 | Defiance, Ohio, US | |
2021-11-19 | US | Ohio | Defiance | 39039 | 6971 | 118 | 0 | 41.32398837 | -84.49076944 | 2021-11-20 04:22:17 | Defiance, Ohio, US | |
2021-11-18 | US | Ohio | Defiance | 39039 | 6938 | 118 | 0 | 41.32398837 | -84.49076944 | 2021-11-19 04:21:40 | Defiance, Ohio, US | |
2021-11-14 | US | Ohio | Auglaize | 39011 | 7305 | 118 | 0 | 40.55998859 | -84.22421429999999 | 2021-11-15 04:21:36 | Auglaize, Ohio, US | |
2021-11-10 | US | Ohio | Putnam | 39137 | 5653 | 118 | 0 | 41.02094889 | -84.1336111 | 2021-11-11 04:21:45 | Putnam, Ohio, US | |
2021-11-09 | US | Ohio | Putnam | 39137 | 5606 | 118 | 0 | 41.02094889 | -84.1336111 | 2021-11-10 04:21:38 | Putnam, Ohio, US | |
2021-11-08 | US | Ohio | Putnam | 39137 | 5567 | 118 | 0 | 41.02094889 | -84.1336111 | 2021-11-09 04:21:36 | Putnam, Ohio, US | |
2021-11-07 | US | Ohio | Putnam | 39137 | 5552 | 118 | 0 | 41.02094889 | -84.1336111 | 2021-11-08 04:21:43 | Putnam, Ohio, US | |
2021-11-06 | US | Ohio | Putnam | 39137 | 5541 | 118 | 0 | 41.02094889 | -84.1336111 | 2021-11-07 04:21:53 | Putnam, Ohio, US | |
2021-11-05 | US | Ohio | Putnam | 39137 | 5535 | 118 | 0 | 41.02094889 | -84.1336111 | 2021-11-06 04:21:51 | Putnam, Ohio, US | |
2021-10-09 | US | Ohio | Shelby | 39149 | 6242 | 118 | 0 | 40.33163494 | -84.20258189 | 2021-10-10 04:21:38 | Shelby, Ohio, US | |
2021-09-20 | US | Ohio | Holmes | 39075 | 3224 | 118 | 0 | 40.56163713 | -81.92635677 | 2021-09-21 04:21:26 | Holmes, Ohio, US | |
2021-09-20 | US | Ohio | Preble | 39135 | 4938 | 118 | 0 | 39.7420247 | -84.64787018 | 2021-09-21 04:21:26 | Preble, Ohio, US | |
2021-09-19 | US | Ohio | Holmes | 39075 | 3220 | 118 | 0 | 40.56163713 | -81.92635677 | 2021-09-20 04:21:22 | Holmes, Ohio, US | |
2021-09-19 | US | Ohio | Preble | 39135 | 4917 | 118 | 0 | 39.7420247 | -84.64787018 | 2021-09-20 04:21:22 | Preble, Ohio, US | |
2021-09-18 | US | Ohio | Holmes | 39075 | 3197 | 118 | 0 | 40.56163713 | -81.92635677 | 2021-09-19 04:21:34 | Holmes, Ohio, US | |
2021-09-18 | US | Ohio | Preble | 39135 | 4902 | 118 | 0 | 39.7420247 | -84.64787018 | 2021-09-19 04:21:34 | Preble, Ohio, US | |
2021-09-13 | US | Ohio | Ashland | 39005 | 5541 | 118 | 0 | 40.84772277 | -82.27280781 | 2021-09-14 04:21:41 | Ashland, Ohio, US | |
2021-09-12 | US | Ohio | Ashland | 39005 | 5507 | 118 | 0 | 40.84772277 | -82.27280781 | 2021-09-13 04:21:15 | Ashland, Ohio, US | |
2021-09-07 | US | Ohio | Crawford | 39033 | 4857 | 118 | 0 | 40.85065156 | -82.91989099 | 2021-09-08 04:21:31 | Crawford, Ohio, US | |
2021-08-31 | US | Ohio | Washington | 39167 | 5802 | 118 | 0 | 39.45690571 | -81.49121382 | 2021-09-01 04:21:38 | Washington, Ohio, US | |
2021-08-25 | US | Ohio | Knox | 39083 | 5183 | 118 | 0 | 40.39830217 | -82.42027563 | 2021-08-26 04:21:28 | Knox, Ohio, US | |
2021-08-24 | US | Ohio | Knox | 39083 | 5142 | 118 | 0 | 40.39830217 | -82.42027563 | 2021-08-25 04:21:41 | Knox, Ohio, US | |
2021-08-21 | US | Ohio | Lawrence | 39087 | 6521 | 118 | 0 | 38.59743452 | -82.53466552 | 2021-08-22 04:21:29 | Lawrence, Ohio, US | |
2021-08-20 | US | Ohio | Lawrence | 39087 | 6489 | 118 | 0 | 38.59743452 | -82.53466552 | 2021-08-21 04:21:38 | Lawrence, Ohio, US | |
2021-08-19 | US | Ohio | Lawrence | 39087 | 6427 | 118 | 0 | 38.59743452 | -82.53466552 | 2021-08-20 04:21:33 | Lawrence, Ohio, US | |
2021-08-18 | US | Ohio | Lawrence | 39087 | 6386 | 118 | 0 | 38.59743452 | -82.53466552 | 2021-08-19 04:21:15 | Lawrence, Ohio, US | |
2021-08-12 | US | Ohio | Scioto | 39145 | 7260 | 118 | 0 | 38.80270163 | -82.98907345 | 2021-08-13 04:21:24 | Scioto, Ohio, US | |
2021-04-13 | US | Ohio | Huron | 39077 | 5257 | 118 | 0 | 41.14651175 | -82.59867951 | 2021-04-14 04:20:41 | Huron, Ohio, US | |
2021-04-12 | US | Ohio | Huron | 39077 | 5247 | 118 | 0 | 41.14651175 | -82.59867951 | 2021-04-13 04:20:37 | Huron, Ohio, US | |
2021-04-11 | US | Ohio | Huron | 39077 | 5237 | 118 | 0 | 41.14651175 | -82.59867951 | 2021-04-12 04:21:00 | Huron, Ohio, US | |
2021-04-10 | US | Ohio | Huron | 39077 | 5229 | 118 | 0 | 41.14651175 | -82.59867951 | 2021-04-11 04:20:56 | Huron, Ohio, US | |
2021-04-09 | US | Ohio | Huron | 39077 | 5219 | 118 | 0 | 41.14651175 | -82.59867951 | 2021-04-10 04:20:59 | Huron, Ohio, US | |
2021-04-08 | US | Ohio | Huron | 39077 | 5204 | 118 | 0 | 41.14651175 | -82.59867951 | 2021-04-09 04:21:13 | Huron, Ohio, US | |
2021-04-07 | US | Ohio | Huron | 39077 | 5190 | 118 | 0 | 41.14651175 | -82.59867951 | 2021-04-08 04:21:13 | Huron, Ohio, US | |
2021-03-17 | US | Ohio | Seneca | 39147 | 4833 | 118 | 0 | 41.12351311 | -83.12783209 | 2021-03-18 05:26:22 | Seneca, Ohio, US | |
2021-03-16 | US | Ohio | Seneca | 39147 | 4826 | 118 | 0 | 41.12351311 | -83.12783209 | 2021-03-17 05:25:07 | Seneca, Ohio, US | |
2021-03-15 | US | Ohio | Seneca | 39147 | 4807 | 118 | 0 | 41.12351311 | -83.12783209 | 2021-03-16 05:25:13 | Seneca, Ohio, US | |
2021-03-10 | US | Ohio | Sandusky | 39143 | 4825 | 118 | 0 | 41.35624126 | -83.137872 | 2021-03-11 05:25:48 | Sandusky, Ohio, US | |
2021-03-09 | US | Ohio | Sandusky | 39143 | 4811 | 118 | 0 | 41.35624126 | -83.137872 | 2021-03-10 05:24:35 | Sandusky, Ohio, US | |
2021-03-08 | US | Ohio | Sandusky | 39143 | 4801 | 118 | 0 | 41.35624126 | -83.137872 | 2021-03-09 05:28:19 | Sandusky, Ohio, US | |
2021-03-07 | US | Ohio | Pickaway | 39129 | 8096 | 118 | 0 | 39.64170392 | -83.0243386 | 2021-03-08 05:24:48 | Pickaway, Ohio, US | |
2021-03-07 | US | Ohio | Sandusky | 39143 | 4800 | 118 | 0 | 41.35624126 | -83.137872 | 2021-03-08 05:24:48 | Sandusky, Ohio, US | |
2021-03-06 | US | Ohio | Pickaway | 39129 | 8094 | 118 | 0 | 7976 | 39.64170392 | -83.0243386 | 2021-03-07 05:21:54 | Pickaway, Ohio, US |
2021-03-05 | US | Ohio | Pickaway | 39129 | 8085 | 118 | 0 | 7967 | 39.64170392 | -83.0243386 | 2021-03-06 04:23:41 | Pickaway, Ohio, US |
2021-03-04 | US | Ohio | Pickaway | 39129 | 8079 | 118 | 0 | 7961 | 39.64170392 | -83.0243386 | 2021-03-05 05:26:29 | Pickaway, Ohio, US |
2021-03-03 | US | Ohio | Pickaway | 39129 | 8067 | 118 | 0 | 7949 | 39.64170392 | -83.0243386 | 2021-03-04 05:24:24 | Pickaway, Ohio, US |
2021-03-02 | US | Ohio | Pickaway | 39129 | 8054 | 118 | 0 | 7936 | 39.64170392 | -83.0243386 | 2021-03-03 05:23:28 | Pickaway, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;