johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where active = 93, country_or_region = "US" and province_or_state = "Ohio" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3318695 | 3318695 | 2020-09-22 | US | Ohio | Monroe | 39111 | 109 | 16 | 0 | 93 | 39.72984936 | -81.08464734 | 2020-09-23 04:23:00 | Monroe, Ohio, US |
2173969 | 2173969 | 2020-09-09 | US | Ohio | Adams | 39001 | 98 | 5 | 0 | 93 | 38.84541072 | -83.4718964 | 2020-09-10 04:29:01 | Adams, Ohio, US |
816078 | 816078 | 2020-09-05 | US | Ohio | Van Wert | 39161 | 96 | 3 | 0 | 93 | 40.8554138 | -84.59111700000003 | 2020-09-06 04:28:33 | Van Wert, Ohio, US |
2956370 | 2956370 | 2020-07-29 | US | Ohio | Hocking | 39073 | 103 | 10 | 0 | 93 | 39.49537927 | -82.47991446 | 2020-07-30 04:35:05 | Hocking, Ohio, US |
3182853 | 3182853 | 2020-07-28 | US | Ohio | Guernsey | 39059 | 101 | 8 | 0 | 93 | 40.05026529 | -81.49248905 | 2020-07-29 04:35:11 | Guernsey, Ohio, US |
175018 | 175018 | 2020-07-27 | US | Ohio | Henry | 39069 | 95 | 2 | 0 | 93 | 41.333964200000004 | -84.06830637 | 2020-07-28 04:58:43 | Henry, Ohio, US |
1500587 | 1500587 | 2020-07-25 | US | Ohio | Highland | 39071 | 94 | 1 | 0 | 93 | 39.1839264 | -83.60331456 | 2020-07-26 04:35:00 | Highland, Ohio, US |
59278 | 59278 | 2020-07-23 | US | Ohio | Defiance | 39039 | 96 | 3 | 0 | 93 | 41.32398837 | -84.49076944 | 2020-07-24 05:30:40 | Defiance, Ohio, US |
61112 | 61112 | 2020-07-23 | US | Ohio | Seneca | 39147 | 96 | 3 | 0 | 93 | 41.12351311 | -83.12783209 | 2020-07-24 05:30:40 | Seneca, Ohio, US |
1707186 | 1707186 | 2020-07-21 | US | Ohio | Williams | 39171 | 95 | 2 | 0 | 93 | 41.56052014 | -84.58429552 | 2020-07-22 04:34:42 | Williams, Ohio, US |
2705298 | 2705298 | 2020-07-17 | US | Ohio | Ashland | 39005 | 97 | 4 | 0 | 93 | 40.84772277 | -82.27280781 | 2020-07-18 04:34:45 | Ashland, Ohio, US |
2745859 | 2745859 | 2020-07-15 | US | Ohio | Hancock | 39063 | 98 | 5 | 0 | 93 | 41.00250487 | -83.66838948 | 2020-07-16 04:44:59 | Hancock, Ohio, US |
2156924 | 2156924 | 2020-07-14 | US | Ohio | Lawrence | 39087 | 93 | 0 | 0 | 93 | 38.59743452 | -82.53466552 | 2020-07-15 04:34:39 | Lawrence, Ohio, US |
2157640 | 2157640 | 2020-07-14 | US | Ohio | Preble | 39135 | 96 | 3 | 0 | 93 | 39.7420247 | -84.64787018 | 2020-07-15 04:34:39 | Preble, Ohio, US |
3490285 | 3490285 | 2020-07-13 | US | Ohio | Preble | 39135 | 96 | 3 | 0 | 93 | 39.7420247 | -84.64787018 | 2020-07-14 04:34:46 | Preble, Ohio, US |
2436897 | 2436897 | 2020-06-20 | US | Ohio | Putnam | 39137 | 103 | 10 | 0 | 93 | 41.02094889 | -84.1336111 | 2020-06-21 04:33:19 | Putnam, Ohio, US |
1689476 | 1689476 | 2020-06-19 | US | Ohio | Huron | 39077 | 96 | 3 | 0 | 93 | 41.14651175 | -82.59867951 | 2020-06-20 04:33:19 | Huron, Ohio, US |
1690475 | 1690475 | 2020-06-19 | US | Ohio | Putnam | 39137 | 103 | 10 | 0 | 93 | 41.02094889 | -84.1336111 | 2020-06-20 04:33:19 | Putnam, Ohio, US |
1209573 | 1209573 | 2020-06-09 | US | Ohio | Ottawa | 39123 | 112 | 19 | 0 | 93 | 41.53781826 | -83.0940185 | 2020-06-10 04:07:00 | Ottawa, Ohio, US |
3864589 | 3864589 | 2020-06-03 | US | Ohio | Greene | 39057 | 102 | 9 | 0 | 93 | 39.69116283 | -83.89032084 | 2020-06-04 02:33:14 | Greene, Ohio, US |
2553634 | 2553634 | 2020-06-02 | US | Ohio | Greene | 39057 | 102 | 9 | 0 | 93 | 39.69116283 | -83.89032084 | 2020-06-03 02:33:13 | Greene, Ohio, US |
3259485 | 3259485 | 2020-05-18 | US | Ohio | Madison | 39097 | 99 | 6 | 0 | 93 | 39.89381073 | -83.40178317 | 2020-05-19 02:32:18 | Madison, Ohio, US |
3414879 | 3414879 | 2020-05-17 | US | Ohio | Madison | 39097 | 98 | 5 | 0 | 93 | 39.89381073 | -83.40178317 | 2020-05-18 02:32:21 | Madison, Ohio, US |
1828114 | 1828114 | 2020-05-16 | US | Ohio | Madison | 39097 | 98 | 5 | 0 | 93 | 39.89381073 | -83.40178317 | 2020-05-17 02:32:32 | Madison, Ohio, US |
1183773 | 1183773 | 2020-05-01 | US | Ohio | Tuscarawas | 39157 | 94 | 1 | 0 | 93 | 40.44214695 | -81.47226262 | 2020-05-02 02:32:27 | Tuscarawas, Ohio, US |
3589563 | 3589563 | 2020-04-26 | US | Ohio | Allen | 39003 | 108 | 15 | 0 | 93 | 40.77285242 | -84.10802343 | 2020-04-27 02:30:52 | Allen, Ohio, US |
3499920 | 3499920 | 2020-04-25 | US | Ohio | Allen | 39003 | 108 | 15 | 0 | 93 | 40.77285242 | -84.10802343 | 2020-04-26 02:30:51 | Allen, Ohio, US |
932172 | 932172 | 2020-04-16 | US | Ohio | Fairfield | 39045 | 96 | 3 | 0 | 93 | 39.75107189 | -82.63088163 | 2020-04-16 23:30:51 | Fairfield, Ohio, US |
3020933 | 3020933 | 2020-04-07 | US | Ohio | Portage | 39133 | 101 | 8 | 0 | 93 | 41.16793482 | -81.19735782 | 2020-04-07 23:04:49 | Portage, Ohio, US |
3627016 | 3627016 | 2020-04-06 | US | Ohio | Trumbull | 39155 | 102 | 9 | 0 | 93 | 41.31735028 | -80.76109643 | 4/6/20 23:22 | Trumbull, Ohio, US |
3739357 | 3739357 | 2020-04-03 | US | Ohio | Lorain | 39093 | 95 | 2 | 0 | 93 | 41.29553751 | -82.15083537 | 2020-04-03 22:46:37 | Lorain, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);