johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
90,027 rows where province_or_state = "Ohio" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1821262 | 1821262 | 2020-12-08 | US | Ohio | Lorain | 39093 | 10195 | 198 | 0 | 9997 | 41.29553751 | -82.15083537 | 2020-12-09 05:28:01 | Lorain, Ohio, US |
2429357 | 2429357 | 2021-01-23 | US | Ohio | Franklin | 39049 | 101171 | 1226 | 0 | 99945 | 39.96995815 | -83.01115755 | 2021-01-24 05:22:35 | Franklin, Ohio, US |
1096604 | 1096604 | 2021-01-20 | US | Ohio | Wood | 39173 | 10158 | 164 | 0 | 9994 | 41.36224827 | -83.62285108 | 2021-01-21 05:22:01 | Wood, Ohio, US |
125177 | 125177 | 2020-11-18 | US | Ohio | Logan | 39091 | 1021 | 22 | 0 | 999 | 40.38996525 | -83.76784341 | 2020-11-19 05:25:23 | Logan, Ohio, US |
764786 | 764786 | 2020-10-18 | US | Ohio | Madison | 39097 | 1013 | 14 | 0 | 999 | 39.89381073 | -83.40178317 | 2020-10-19 04:24:16 | Madison, Ohio, US |
820010 | 820010 | 2020-10-09 | US | Ohio | Erie | 39043 | 1036 | 37 | 0 | 999 | 41.36796058 | -82.62904521 | 2020-10-10 04:23:57 | Erie, Ohio, US |
1044316 | 1044316 | 2020-10-07 | US | Ohio | Ross | 39141 | 1029 | 30 | 0 | 999 | 39.33705391 | -83.06000914 | 2020-10-08 04:23:56 | Ross, Ohio, US |
1586615 | 1586615 | 2020-11-30 | US | Ohio | Fayette | 39047 | 1018 | 19 | 0 | 999 | 39.56021306 | -83.4562016 | 2020-12-01 05:26:18 | Fayette, Ohio, US |
3486772 | 3486772 | 2020-08-20 | US | Ohio | Medina | 39103 | 1038 | 39 | 0 | 999 | 41.11770589 | -81.89986209999998 | 2020-08-21 04:27:41 | Medina, Ohio, US |
3569024 | 3569024 | 2020-11-29 | US | Ohio | Guernsey | 39059 | 1021 | 22 | 0 | 999 | 40.05026529 | -81.49248905 | 2020-11-30 05:26:13 | Guernsey, Ohio, US |
3670109 | 3670109 | 2021-03-06 | US | Ohio | Morgan | 39115 | 1021 | 22 | 0 | 999 | 39.62081738 | -81.85308173 | 2021-03-07 05:21:54 | Morgan, Ohio, US |
3788403 | 3788403 | 2020-10-11 | US | Ohio | Wayne | 39169 | 1060 | 61 | 0 | 999 | 40.82925852 | -81.88844833 | 2020-10-12 04:23:45 | Wayne, Ohio, US |
282682 | 282682 | 2021-02-24 | US | Ohio | Richland | 39139 | 10184 | 196 | 0 | 9988 | 40.77180308 | -82.53799609999999 | 2021-02-25 05:24:57 | Richland, Ohio, US |
3764056 | 3764056 | 2020-12-28 | US | Ohio | Licking | 39089 | 10130 | 146 | 0 | 9984 | 40.09136236 | -82.48185785 | 2020-12-29 05:22:37 | Licking, Ohio, US |
267772 | 267772 | 2020-05-21 | US | Ohio | Summit | 39153 | 1141 | 143 | 0 | 998 | 41.12464734 | -81.53123079 | 2020-05-22 02:36:51 | Summit, Ohio, US |
680742 | 680742 | 2020-11-23 | US | Ohio | Ashland | 39005 | 1027 | 29 | 0 | 998 | 40.84772277 | -82.27280781 | 2020-11-24 05:27:31 | Ashland, Ohio, US |
1525654 | 1525654 | 2020-08-28 | US | Ohio | Miami | 39109 | 1030 | 32 | 0 | 998 | 40.0543329 | -84.22871271 | 2020-08-29 04:28:19 | Miami, Ohio, US |
2806052 | 2806052 | 2020-08-02 | US | Ohio | Lake | 39085 | 1034 | 36 | 0 | 998 | 41.69710807 | -81.23676539 | 2020-08-03 04:34:35 | Lake, Ohio, US |
2851327 | 2851327 | 2020-09-18 | US | Ohio | Portage | 39133 | 1056 | 58 | 0 | 998 | 41.16793482 | -81.19735782 | 2020-09-19 04:22:00 | Portage, Ohio, US |
3922912 | 3922912 | 2020-08-09 | US | Ohio | Wood | 39173 | 1043 | 45 | 0 | 998 | 41.36224827 | -83.62285108 | 2020-08-10 04:34:55 | Wood, Ohio, US |
3341045 | 3341045 | 2020-11-17 | US | Ohio | Fulton | 39051 | 1022 | 25 | 0 | 997 | 41.60213491 | -84.12571393 | 2020-11-18 05:40:31 | Fulton, Ohio, US |
1938950 | 1938950 | 2021-02-23 | US | Ohio | Richland | 39139 | 10165 | 196 | 0 | 9969 | 40.77180308 | -82.53799609999999 | 2021-02-24 05:29:16 | Richland, Ohio, US |
2917687 | 2917687 | 2020-11-14 | US | Ohio | Summit | 39153 | 10245 | 276 | 0 | 9969 | 41.12464734 | -81.53123079 | 2020-11-15 05:26:53 | Summit, Ohio, US |
14825 | 14825 | 2021-01-26 | US | Ohio | Monroe | 39111 | 1034 | 38 | 0 | 996 | 39.72984936 | -81.08464734 | 2021-01-27 05:23:41 | Monroe, Ohio, US |
680780 | 680780 | 2020-11-23 | US | Ohio | Jefferson | 39081 | 1012 | 16 | 0 | 996 | 40.38614126 | -80.76259514 | 2020-11-24 05:27:31 | Jefferson, Ohio, US |
1821304 | 1821304 | 2020-12-08 | US | Ohio | Wyandot | 39175 | 1016 | 20 | 0 | 996 | 40.84339621 | -83.30734173 | 2020-12-09 05:28:01 | Wyandot, Ohio, US |
2221028 | 2221028 | 2020-07-08 | US | Ohio | Lorain | 39093 | 1064 | 68 | 0 | 996 | 41.29553751 | -82.15083537 | 2020-07-09 04:34:23 | Lorain, Ohio, US |
3103922 | 3103922 | 2021-01-16 | US | Ohio | Meigs | 39105 | 1024 | 28 | 0 | 996 | 39.09224872 | -82.0305041 | 2021-01-17 05:22:17 | Meigs, Ohio, US |
1590672 | 1590672 | 2021-02-05 | US | Ohio | Portage | 39133 | 10131 | 176 | 0 | 9956 | 41.16793482 | -81.19735782 | 2021-02-06 05:23:55 | Portage, Ohio, US |
1899585 | 1899585 | 2021-01-29 | US | Ohio | Allen | 39003 | 10166 | 211 | 0 | 9955 | 40.77285242 | -84.10802343 | 2021-01-30 05:22:49 | Allen, Ohio, US |
3693984 | 3693984 | 2020-12-24 | US | Ohio | Trumbull | 39155 | 10265 | 314 | 0 | 9951 | 41.31735028 | -80.76109643 | 2020-12-25 05:22:48 | Trumbull, Ohio, US |
756771 | 756771 | 2020-10-28 | US | Ohio | Lawrence | 39087 | 1016 | 21 | 0 | 995 | 38.59743452 | -82.53466552 | 2020-10-29 04:24:49 | Lawrence, Ohio, US |
824014 | 824014 | 2020-11-19 | US | Ohio | Crawford | 39033 | 1028 | 33 | 0 | 995 | 40.85065156 | -82.91989099 | 2020-11-20 05:26:28 | Crawford, Ohio, US |
1044324 | 1044324 | 2020-10-07 | US | Ohio | Tuscarawas | 39157 | 1013 | 18 | 0 | 995 | 40.44214695 | -81.47226262 | 2020-10-08 04:23:56 | Tuscarawas, Ohio, US |
1207819 | 1207819 | 2020-06-09 | US | Ohio | Butler | 39017 | 1034 | 39 | 0 | 995 | 39.44012838 | -84.57388716 | 2020-06-10 04:07:00 | Butler, Ohio, US |
1352786 | 1352786 | 2020-11-24 | US | Ohio | Jefferson | 39081 | 1012 | 17 | 0 | 995 | 40.38614126 | -80.76259514 | 2020-11-25 05:27:20 | Jefferson, Ohio, US |
2516662 | 2516662 | 2020-10-03 | US | Ohio | Richland | 39139 | 1014 | 19 | 0 | 995 | 40.77180308 | -82.53799609999999 | 2020-10-04 04:23:44 | Richland, Ohio, US |
3443309 | 3443309 | 2020-11-11 | US | Ohio | Preble | 39135 | 1022 | 27 | 0 | 995 | 39.7420247 | -84.64787018 | 2020-11-12 05:25:55 | Preble, Ohio, US |
204761 | 204761 | 2020-12-25 | US | Ohio | Trumbull | 39155 | 10265 | 317 | 0 | 9948 | 41.31735028 | -80.76109643 | 2020-12-26 05:22:28 | Trumbull, Ohio, US |
776787 | 776787 | 2021-01-12 | US | Ohio | Clark | 39023 | 10177 | 231 | 0 | 9946 | 39.91592258 | -83.78498252 | 2021-01-13 05:22:15 | Clark, Ohio, US |
840056 | 840056 | 2020-08-17 | US | Ohio | Hamilton | 39061 | 10184 | 243 | 0 | 9941 | 39.19673558 | -84.54502924 | 2020-08-18 04:27:56 | Hamilton, Ohio, US |
81529 | 81529 | 2020-10-14 | US | Ohio | Darke | 39037 | 1035 | 41 | 0 | 994 | 40.13412966 | -84.6194517 | 2020-10-15 04:24:28 | Darke, Ohio, US |
204693 | 204693 | 2020-12-25 | US | Ohio | Carroll | 39019 | 1017 | 23 | 0 | 994 | 40.5789686 | -81.09178213 | 2020-12-26 05:22:28 | Carroll, Ohio, US |
1618730 | 1618730 | 2021-03-05 | US | Ohio | Morgan | 39115 | 1016 | 22 | 0 | 994 | 39.62081738 | -81.85308173 | 2021-03-06 04:23:41 | Morgan, Ohio, US |
3490930 | 3490930 | 2020-07-13 | US | Ohio | Warren | 39165 | 1018 | 24 | 0 | 994 | 39.42581994 | -84.16557457 | 2020-07-14 04:34:46 | Warren, Ohio, US |
3693916 | 3693916 | 2020-12-24 | US | Ohio | Carroll | 39019 | 1017 | 23 | 0 | 994 | 40.5789686 | -81.09178213 | 2020-12-25 05:22:48 | Carroll, Ohio, US |
533205 | 533205 | 2021-02-22 | US | Ohio | Richland | 39139 | 10131 | 195 | 0 | 9936 | 40.77180308 | -82.53799609999999 | 2021-02-23 05:23:41 | Richland, Ohio, US |
2469259 | 2469259 | 2021-01-22 | US | Ohio | Franklin | 39049 | 100550 | 1218 | 0 | 99332 | 39.96995815 | -83.01115755 | 2021-01-23 05:22:03 | Franklin, Ohio, US |
1064304 | 1064304 | 2021-01-04 | US | Ohio | Greene | 39057 | 10104 | 171 | 0 | 9933 | 39.69116283 | -83.89032084 | 2021-01-05 05:21:49 | Greene, Ohio, US |
1108002 | 1108002 | 2020-09-02 | US | Ohio | Greene | 39057 | 1020 | 27 | 0 | 993 | 39.69116283 | -83.89032084 | 2020-09-03 04:28:22 | Greene, Ohio, US |
2921636 | 2921636 | 2020-11-04 | US | Ohio | Geauga | 39055 | 1044 | 51 | 0 | 993 | 41.49952319 | -81.17935342 | 2020-11-05 06:05:03 | Geauga, Ohio, US |
2937741 | 2937741 | 2020-11-28 | US | Ohio | Van Wert | 39161 | 1025 | 32 | 0 | 993 | 40.8554138 | -84.59111700000003 | 2020-11-29 05:25:55 | Van Wert, Ohio, US |
1991106 | 1991106 | 2020-11-09 | US | Ohio | Lucas | 39095 | 10313 | 385 | 0 | 9928 | 41.62101218 | -83.65468618 | 2020-11-10 05:40:07 | Lucas, Ohio, US |
930141 | 930141 | 2020-12-21 | US | Ohio | Delaware | 39041 | 9997 | 72 | 0 | 9925 | 40.27942393 | -83.00457058 | 2020-12-22 05:22:33 | Delaware, Ohio, US |
378612 | 378612 | 2020-11-06 | US | Ohio | Ashtabula | 39007 | 1034 | 42 | 0 | 992 | 41.70860332 | -80.74830218 | 2020-11-07 05:24:52 | Ashtabula, Ohio, US |
867236 | 867236 | 2020-11-12 | US | Ohio | Huron | 39077 | 1011 | 19 | 0 | 992 | 41.14651175 | -82.59867951 | 2020-11-13 05:25:30 | Huron, Ohio, US |
1028824 | 1028824 | 2020-10-17 | US | Ohio | Madison | 39097 | 1006 | 14 | 0 | 992 | 39.89381073 | -83.40178317 | 2020-10-18 04:24:25 | Madison, Ohio, US |
910694 | 910694 | 2021-01-19 | US | Ohio | Wood | 39173 | 10081 | 163 | 0 | 9918 | 41.36224827 | -83.62285108 | 2021-01-20 05:21:54 | Wood, Ohio, US |
2484401 | 2484401 | 2021-01-28 | US | Ohio | Allen | 39003 | 10120 | 207 | 0 | 9913 | 40.77285242 | -84.10802343 | 2021-01-29 05:22:23 | Allen, Ohio, US |
3780376 | 3780376 | 2020-12-27 | US | Ohio | Licking | 39089 | 10053 | 142 | 0 | 9911 | 40.09136236 | -82.48185785 | 2020-12-28 05:22:06 | Licking, Ohio, US |
792879 | 792879 | 2021-02-04 | US | Ohio | Portage | 39133 | 10083 | 174 | 0 | 9910 | 41.16793482 | -81.19735782 | 2021-02-05 05:22:38 | Portage, Ohio, US |
1179924 | 1179924 | 2020-10-22 | US | Ohio | Auglaize | 39011 | 1006 | 15 | 0 | 991 | 40.55998859 | -84.22421429999999 | 2020-10-23 04:24:46 | Auglaize, Ohio, US |
2158130 | 2158130 | 2020-07-14 | US | Ohio | Trumbull | 39155 | 1071 | 80 | 0 | 991 | 41.31735028 | -80.76109643 | 2020-07-15 04:34:39 | Trumbull, Ohio, US |
412943 | 412943 | 2020-07-05 | US | Ohio | Franklin | 39049 | 10271 | 362 | 0 | 9909 | 39.96995815 | -83.01115755 | 2020-07-06 04:33:57 | Franklin, Ohio, US |
184539 | 184539 | 2021-02-21 | US | Ohio | Richland | 39139 | 10102 | 195 | 0 | 9907 | 40.77180308 | -82.53799609999999 | 2021-02-22 05:24:21 | Richland, Ohio, US |
2543886 | 2543886 | 2021-01-07 | US | Ohio | Medina | 39103 | 10102 | 199 | 0 | 9903 | 41.11770589 | -81.89986209999998 | 2021-01-08 05:22:42 | Medina, Ohio, US |
1139334 | 1139334 | 2021-01-01 | US | Ohio | Fairfield | 39045 | 10031 | 130 | 0 | 9901 | 39.75107189 | -82.63088163 | 2021-01-02 05:22:33 | Fairfield, Ohio, US |
1558412 | 1558412 | 2020-08-16 | US | Ohio | Hamilton | 39061 | 10142 | 241 | 0 | 9901 | 39.19673558 | -84.54502924 | 2020-08-17 04:27:20 | Hamilton, Ohio, US |
3697940 | 3697940 | 2020-12-31 | US | Ohio | Fairfield | 39045 | 10031 | 130 | 0 | 9901 | 39.75107189 | -82.63088163 | 2021-01-01 05:23:07 | Fairfield, Ohio, US |
1991130 | 1991130 | 2020-11-09 | US | Ohio | Sandusky | 39143 | 1017 | 27 | 0 | 990 | 41.35624126 | -83.137872 | 2020-11-10 05:40:07 | Sandusky, Ohio, US |
2512655 | 2512655 | 2020-08-27 | US | Ohio | Miami | 39109 | 1022 | 32 | 0 | 990 | 40.0543329 | -84.22871271 | 2020-08-28 04:28:11 | Miami, Ohio, US |
3192429 | 3192429 | 2020-11-22 | US | Ohio | Clinton | 39027 | 1003 | 13 | 0 | 990 | 39.41485808 | -83.80852286 | 2020-11-23 05:25:26 | Clinton, Ohio, US |
61133 | 61133 | 2020-07-23 | US | Ohio | Shelby | 39149 | 103 | 4 | 0 | 99 | 40.33163494 | -84.20258189 | 2020-07-24 05:30:40 | Shelby, Ohio, US |
175473 | 175473 | 2020-07-27 | US | Ohio | Logan | 39091 | 102 | 3 | 0 | 99 | 40.38996525 | -83.76784341 | 2020-07-28 04:58:43 | Logan, Ohio, US |
266864 | 266864 | 2020-05-21 | US | Ohio | Madison | 39097 | 105 | 6 | 0 | 99 | 39.89381073 | -83.40178317 | 2020-05-22 02:36:51 | Madison, Ohio, US |
366327 | 366327 | 2020-07-16 | US | Ohio | Preble | 39135 | 102 | 3 | 0 | 99 | 39.7420247 | -84.64787018 | 2020-07-17 04:34:50 | Preble, Ohio, US |
520862 | 520862 | 2020-04-21 | US | Ohio | Licking | 39089 | 102 | 3 | 0 | 99 | 40.09136236 | -82.48185785 | 2020-04-21 23:30:50 | Licking, Ohio, US |
571852 | 571852 | 2020-06-06 | US | Ohio | Greene | 39057 | 108 | 9 | 0 | 99 | 39.69116283 | -83.89032084 | 2020-06-07 03:53:30 | Greene, Ohio, US |
788860 | 788860 | 2020-10-15 | US | Ohio | Noble | 39121 | 99 | 0 | 0 | 99 | 39.76818851 | -81.45937183 | 2020-10-16 04:24:01 | Noble, Ohio, US |
841394 | 841394 | 2020-07-22 | US | Ohio | Ashland | 39005 | 103 | 4 | 0 | 99 | 40.84772277 | -82.27280781 | 2020-07-23 05:15:04 | Ashland, Ohio, US |
1102438 | 1102438 | 2020-05-25 | US | Ohio | Crawford | 39033 | 104 | 5 | 0 | 99 | 40.85065156 | -82.91989099 | 2020-05-26 02:32:35 | Crawford, Ohio, US |
1135052 | 1135052 | 2020-06-26 | US | Ohio | Putnam | 39137 | 109 | 10 | 0 | 99 | 41.02094889 | -84.1336111 | 2020-06-27 04:33:35 | Putnam, Ohio, US |
1175685 | 1175685 | 2020-09-10 | US | Ohio | Van Wert | 39161 | 102 | 3 | 0 | 99 | 40.8554138 | -84.59111700000003 | 2020-09-11 04:46:23 | Van Wert, Ohio, US |
1246259 | 1246259 | 2020-09-08 | US | Ohio | Van Wert | 39161 | 102 | 3 | 0 | 99 | 40.8554138 | -84.59111700000003 | 2020-09-09 04:28:48 | Van Wert, Ohio, US |
1383644 | 1383644 | 2020-04-19 | US | Ohio | Licking | 39089 | 102 | 3 | 0 | 99 | 40.09136236 | -82.48185785 | 2020-04-19 23:41:01 | Licking, Ohio, US |
1704134 | 1704134 | 2020-07-21 | US | Ohio | Ashland | 39005 | 103 | 4 | 0 | 99 | 40.84772277 | -82.27280781 | 2020-07-22 04:34:42 | Ashland, Ohio, US |
2174050 | 2174050 | 2020-09-09 | US | Ohio | Van Wert | 39161 | 102 | 3 | 0 | 99 | 40.8554138 | -84.59111700000003 | 2020-09-10 04:29:01 | Van Wert, Ohio, US |
2512666 | 2512666 | 2020-08-27 | US | Ohio | Pike | 39131 | 101 | 2 | 0 | 99 | 39.07634001 | -83.06769584 | 2020-08-28 04:28:11 | Pike, Ohio, US |
2561045 | 2561045 | 2020-07-24 | US | Ohio | Defiance | 39039 | 102 | 3 | 0 | 99 | 41.32398837 | -84.49076944 | 2020-07-25 04:47:39 | Defiance, Ohio, US |
2563426 | 2563426 | 2020-07-24 | US | Ohio | Williams | 39171 | 101 | 2 | 0 | 99 | 41.56052014 | -84.58429552 | 2020-07-25 04:47:39 | Williams, Ohio, US |
2581210 | 2581210 | 2020-05-12 | US | Ohio | Washington | 39167 | 114 | 15 | 0 | 99 | 39.45690571 | -81.49121382 | 2020-05-13 03:32:26 | Washington, Ohio, US |
2921642 | 2921642 | 2020-11-04 | US | Ohio | Harrison | 39067 | 103 | 4 | 0 | 99 | 40.29380509 | -81.09068544 | 2020-11-05 06:05:03 | Harrison, Ohio, US |
3082267 | 3082267 | 2020-05-04 | US | Ohio | Clermont | 39025 | 103 | 4 | 0 | 99 | 39.04847534 | -84.15375786 | 2020-05-05 02:32:34 | Clermont, Ohio, US |
3204400 | 3204400 | 2020-07-18 | US | Ohio | Scioto | 39145 | 99 | 0 | 0 | 99 | 38.80270163 | -82.98907345 | 2020-07-19 04:34:58 | Scioto, Ohio, US |
3262471 | 3262471 | 2020-07-31 | US | Ohio | Henry | 39069 | 101 | 2 | 0 | 99 | 41.333964200000004 | -84.06830637 | 2020-08-01 04:36:27 | Henry, Ohio, US |
3330744 | 3330744 | 2020-05-11 | US | Ohio | Washington | 39167 | 114 | 15 | 0 | 99 | 39.45690571 | -81.49121382 | 2020-05-12 03:32:27 | Washington, Ohio, US |
3459359 | 3459359 | 2020-05-10 | US | Ohio | Washington | 39167 | 114 | 15 | 0 | 99 | 39.45690571 | -81.49121382 | 2020-05-11 02:32:30 | Washington, Ohio, US |
3559618 | 3559618 | 2020-04-08 | US | Ohio | Butler | 39017 | 102 | 3 | 0 | 99 | 39.44012838 | -84.57388716 | 2020-04-08 22:51:58 | Butler, Ohio, US |
3589676 | 3589676 | 2020-04-26 | US | Ohio | Belmont | 39013 | 106 | 7 | 0 | 99 | 40.01625942 | -80.9924051 | 2020-04-27 02:30:52 | Belmont, Ohio, US |
744813 | 744813 | 2021-02-20 | US | Ohio | Richland | 39139 | 10092 | 195 | 0 | 9897 | 40.77180308 | -82.53799609999999 | 2021-02-21 05:24:33 | Richland, 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]);