johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
243 rows where active = 997 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3632160 | 3632160 | 2021-07-14 | Russia | Kabardino-Balkarian Republic | 25653 | 535 | 24121 | 997 | 43.4806048 | 43.5978976 | 2021-07-15 04:21:48 | Kabardino-Balkarian Republic, Russia | ||
3631872 | 3631872 | 2021-07-14 | Germany | Niedersachsen | 261843 | 5799 | 255200 | 997 | 52.6367 | 9.8451 | 2021-07-15 04:21:48 | Niedersachsen, Germany | ||
2765197 | 2765197 | 2021-07-01 | Russia | Yamalo-Nenets Autonomous Okrug | 40175 | 431 | 38747 | 997 | 67.1471631 | 74.3415488 | 2021-07-02 04:21:47 | Yamalo-Nenets Autonomous Okrug, Russia | ||
1893397 | 1893397 | 2021-06-30 | Russia | Tyumen Oblast | 39096 | 675 | 37424 | 997 | 58.8206488 | 70.36588370000001 | 2021-07-01 04:21:19 | Tyumen Oblast, Russia | ||
2590244 | 2590244 | 2021-06-27 | Russia | Ryazan Oblast | 30796 | 598 | 29201 | 997 | 54.42267320000001 | 40.57052460000001 | 2021-06-28 04:21:29 | Ryazan Oblast, Russia | ||
3958748 | 3958748 | 2021-06-26 | Russia | Ryazan Oblast | 30718 | 593 | 29128 | 997 | 54.42267320000001 | 40.57052460000001 | 2021-06-27 04:21:39 | Ryazan Oblast, Russia | ||
3033927 | 3033927 | 2021-06-16 | Ukraine | Sumy Oblast | 77570 | 1304 | 75269 | 997 | 50.9077 | 34.7981 | 2021-06-17 04:22:36 | Sumy Oblast, Ukraine | ||
1798836 | 1798836 | 2021-03-23 | Russia | Irkutsk Oblast | 60209 | 1952 | 57260 | 997 | 56.6370122 | 104.719221 | 2021-03-24 05:25:40 | Irkutsk Oblast, Russia | ||
1744484 | 1744484 | 2021-03-20 | India | Goa | 56525 | 815 | 54713 | 997 | 15.359682 | 74.057396 | 2021-03-21 05:25:44 | Goa, India | ||
702289 | 702289 | 2021-03-16 | El Salvador | 62531 | 1958 | 59576 | 997 | 13.7942 | -88.8965 | 2021-03-17 05:25:07 | El Salvador | |||
3669895 | 3669895 | 2021-03-06 | US | New York | Yates | 36123 | 1023 | 26 | 0 | 997 | 42.63505484 | -77.10369919 | 2021-03-07 05:21:54 | Yates, New York, US |
2207852 | 2207852 | 2021-03-04 | Russia | Ivanovo Oblast | 30834 | 944 | 28893 | 997 | 56.9167446 | 41.43521370000001 | 2021-03-05 05:26:29 | Ivanovo Oblast, Russia | ||
3257092 | 3257092 | 2021-03-02 | US | Tennessee | Houston | 47083 | 1036 | 32 | 0 | 997 | 36.28872054 | -87.71878828 | 2021-03-03 05:23:28 | Houston, Tennessee, US |
2368801 | 2368801 | 2021-02-28 | US | Kansas | Marion | 20115 | 1021 | 24 | 0 | 997 | 38.35855394 | -97.0985251 | 2021-03-01 05:23:01 | Marion, Kansas, US |
3067303 | 3067303 | 2021-02-27 | US | Kansas | Marion | 20115 | 1021 | 24 | 0 | 997 | 38.35855394 | -97.0985251 | 2021-02-28 05:22:20 | Marion, Kansas, US |
2184887 | 2184887 | 2021-02-26 | US | Kansas | Marion | 20115 | 1021 | 24 | 0 | 997 | 38.35855394 | -97.0985251 | 2021-02-27 05:22:28 | Marion, Kansas, US |
1858900 | 1858900 | 2021-02-25 | US | Georgia | Wilkes | 13317 | 1018 | 21 | 0 | 997 | 33.78290391 | -82.74286107 | 2021-02-26 05:22:40 | Wilkes, Georgia, US |
282953 | 282953 | 2021-02-24 | US | Puerto Rico | San Sebastian | 72131 | 997 | 0 | 0 | 997 | 18.328646 | -66.971214 | 2021-02-25 05:24:57 | San Sebastian, Puerto Rico, US |
281078 | 281078 | 2021-02-24 | US | Georgia | Wilkes | 13317 | 1018 | 21 | 0 | 997 | 33.78290391 | -82.74286107 | 2021-02-25 05:24:57 | Wilkes, Georgia, US |
1937346 | 1937346 | 2021-02-23 | US | Georgia | Wilkes | 13317 | 1018 | 21 | 0 | 997 | 33.78290391 | -82.74286107 | 2021-02-24 05:29:16 | Wilkes, Georgia, US |
1936785 | 1936785 | 2021-02-23 | Togo | 6466 | 81 | 5388 | 997 | 8.6195 | 0.8248 | 2021-02-24 05:29:16 | Togo | |||
533476 | 533476 | 2021-02-22 | US | Puerto Rico | San Sebastian | 72131 | 997 | 0 | 0 | 997 | 18.328646 | -66.971214 | 2021-02-23 05:23:41 | San Sebastian, Puerto Rico, US |
532120 | 532120 | 2021-02-22 | US | Kentucky | Knott | 21119 | 1012 | 15 | 0 | 997 | 37.35388197 | -82.94981134 | 2021-02-23 05:23:41 | Knott, Kentucky, US |
2681160 | 2681160 | 2021-02-13 | US | Virginia | Giles | 51071 | 1006 | 9 | 0 | 997 | 37.31234791 | -80.70636931 | 2021-02-14 05:23:43 | Giles, Virginia, US |
2641312 | 2641312 | 2021-02-11 | US | Wyoming | Big Horn | 56003 | 1026 | 29 | 0 | 997 | 44.52405055 | -107.9960365 | 2021-02-12 05:23:29 | Big Horn, Wyoming, US |
1529319 | 1529319 | 2021-02-09 | US | Kentucky | Lewis | 21135 | 1027 | 30 | 0 | 997 | 38.53184419 | -83.37735618 | 2021-02-10 05:22:41 | Lewis, Kentucky, US |
617159 | 617159 | 2021-02-08 | US | West Virginia | Grant | 54023 | 1019 | 22 | 0 | 997 | 39.10314817 | -79.19440518 | 2021-02-09 05:23:30 | Grant, West Virginia, US |
616901 | 616901 | 2021-02-08 | US | Texas | Somervell | 48425 | 1016 | 10 | 0 | 997 | 32.22236802 | -97.77403489 | 2021-02-09 05:23:30 | Somervell, Texas, US |
1675670 | 1675670 | 2021-02-07 | US | Texas | Somervell | 48425 | 1016 | 10 | 0 | 997 | 32.22236802 | -97.77403489 | 2021-02-08 05:22:39 | Somervell, Texas, US |
978131 | 978131 | 2021-02-06 | US | Texas | Somervell | 48425 | 1016 | 10 | 0 | 997 | 32.22236802 | -97.77403489 | 2021-02-07 05:23:00 | Somervell, Texas, US |
343787 | 343787 | 2021-02-03 | US | West Virginia | Wetzel | 54103 | 1016 | 19 | 0 | 997 | 39.6065771 | -80.64016540000001 | 2021-02-04 05:22:26 | Wetzel, West Virginia, US |
341763 | 341763 | 2021-02-03 | US | Louisiana | Catahoula | 22025 | 1030 | 33 | 0 | 997 | 31.66778967 | -91.84526385 | 2021-02-04 05:22:26 | Catahoula, Louisiana, US |
340246 | 340246 | 2021-02-03 | India | Uttarakhand | 96281 | 1655 | 93629 | 997 | 30.156447 | 79.197608 | 2021-02-04 05:22:26 | Uttarakhand, India | ||
1687072 | 1687072 | 2021-02-02 | US | Oklahoma | Nowata | 40105 | 1011 | 14 | 0 | 997 | 36.79843529 | -95.61902331 | 2021-02-03 05:22:52 | Nowata, Oklahoma, US |
1461104 | 1461104 | 2021-01-31 | US | Kansas | Thomas | 20193 | 1014 | 17 | 0 | 997 | 39.35107575 | -101.0553705 | 2021-02-01 05:22:53 | Thomas, Kansas, US |
1460252 | 1460252 | 2021-01-31 | US | Arkansas | Little River | 5081 | 1036 | 39 | 0 | 997 | 33.70375665 | -94.23468591 | 2021-02-01 05:22:53 | Little River, Arkansas, US |
2213241 | 2213241 | 2021-01-30 | US | Maryland | Kent | 24029 | 1033 | 36 | 0 | 997 | 39.24976208 | -76.04741541 | 2021-01-31 05:22:42 | Kent, Maryland, US |
2213012 | 2213012 | 2021-01-30 | US | Kansas | Thomas | 20193 | 1014 | 17 | 0 | 997 | 39.35107575 | -101.0553705 | 2021-01-31 05:22:42 | Thomas, Kansas, US |
2212452 | 2212452 | 2021-01-30 | US | Georgia | Early | 13099 | 1041 | 44 | 0 | 997 | 31.32155345 | -84.90255207 | 2021-01-31 05:22:42 | Early, Georgia, US |
1898499 | 1898499 | 2021-01-29 | US | Kansas | Thomas | 20193 | 1014 | 17 | 0 | 997 | 39.35107575 | -101.0553705 | 2021-01-30 05:22:49 | Thomas, Kansas, US |
3154147 | 3154147 | 2021-01-27 | US | California | Inyo | 6027 | 1031 | 27 | 0 | 997 | 36.51112084 | -117.41119779999998 | 2021-01-28 05:22:24 | Inyo, California, US |
3153794 | 3153794 | 2021-01-27 | Russia | Bryansk Oblast | 28358 | 238 | 27123 | 997 | 52.8873315 | 33.41585300000001 | 2021-01-28 05:22:24 | Bryansk Oblast, Russia | ||
14082 | 14082 | 2021-01-26 | US | Minnesota | Pennington | 27113 | 1013 | 16 | 0 | 997 | 48.06642577 | -96.0370814 | 2021-01-27 05:23:41 | Pennington, Minnesota, US |
2569080 | 2569080 | 2021-01-25 | US | Kentucky | Larue | 21123 | 1004 | 7 | 0 | 997 | 37.54567114 | -85.70138352 | 2021-01-26 05:22:02 | Larue, Kentucky, US |
1762049 | 1762049 | 2021-01-24 | US | Puerto Rico | Moca | 72099 | 997 | 0 | 0 | 997 | 18.377805 | -67.080952 | 2021-01-25 05:22:16 | Moca, Puerto Rico, US |
2429921 | 2429921 | 2021-01-23 | US | Texas | Bosque | 48035 | 1288 | 21 | 0 | 997 | 31.89978581 | -97.63613524 | 2021-01-24 05:22:35 | Bosque, Texas, US |
2470034 | 2470034 | 2021-01-22 | US | Texas | Tyler | 48457 | 1103 | 23 | 0 | 997 | 30.77031716 | -94.37690895 | 2021-01-23 05:22:03 | Tyler, Texas, US |
2469823 | 2469823 | 2021-01-22 | US | Texas | Bosque | 48035 | 1288 | 21 | 0 | 997 | 31.89978581 | -97.63613524 | 2021-01-23 05:22:03 | Bosque, Texas, US |
2469561 | 2469561 | 2021-01-22 | US | Puerto Rico | Naranjito | 72105 | 997 | 0 | 0 | 997 | 18.288019 | -66.252703 | 2021-01-23 05:22:03 | Naranjito, Puerto Rico, US |
1095916 | 1095916 | 2021-01-20 | US | Mississippi | Perry | 28111 | 1028 | 31 | 0 | 997 | 31.17161885 | -88.99281835 | 2021-01-21 05:22:01 | Perry, Mississippi, US |
911527 | 911527 | 2021-01-19 | US | Virginia | King George | 51099 | 1007 | 10 | 0 | 997 | 38.26818502 | -77.15852768 | 2021-01-20 05:21:54 | King George, Virginia, US |
910554 | 910554 | 2021-01-19 | US | North Dakota | Benson | 38005 | 1014 | 17 | 0 | 997 | 48.0683985 | -99.35916363 | 2021-01-20 05:21:54 | Benson, North Dakota, US |
908954 | 908954 | 2021-01-19 | US | Georgia | Dade | 13083 | 1006 | 9 | 0 | 997 | 34.854916700000004 | -85.50490424 | 2021-01-20 05:21:54 | Dade, Georgia, US |
3518004 | 3518004 | 2021-01-15 | US | Oregon | Columbia | 41009 | 1015 | 18 | 0 | 997 | 45.94464254 | -123.0890898 | 2021-01-16 05:22:40 | Columbia, Oregon, US |
3516588 | 3516588 | 2021-01-15 | US | Iowa | Guthrie | 19077 | 1021 | 24 | 0 | 997 | 41.68378965 | -94.50111014 | 2021-01-16 05:22:40 | Guthrie, Iowa, US |
3881800 | 3881800 | 2021-01-14 | US | New York | Franklin | 36033 | 1006 | 9 | 0 | 997 | 44.59040891 | -74.29926032 | 2021-01-15 05:22:24 | Franklin, New York, US |
3880761 | 3880761 | 2021-01-14 | US | Iowa | Guthrie | 19077 | 1021 | 24 | 0 | 997 | 41.68378965 | -94.50111014 | 2021-01-15 05:22:24 | Guthrie, Iowa, US |
3311720 | 3311720 | 2021-01-13 | US | Wisconsin | Bayfield | 55007 | 1015 | 18 | 0 | 997 | 46.52868768 | -91.19716729 | 2021-01-14 05:22:32 | Bayfield, Wisconsin, US |
3310750 | 3310750 | 2021-01-13 | US | Oklahoma | Haskell | 40061 | 1004 | 7 | 0 | 997 | 35.22257600000001 | -95.11513306 | 2021-01-14 05:22:32 | Haskell, Oklahoma, US |
3309572 | 3309572 | 2021-01-13 | US | Kentucky | Caldwell | 21033 | 1014 | 17 | 0 | 997 | 37.14749129 | -87.86948214 | 2021-01-14 05:22:32 | Caldwell, Kentucky, US |
2628817 | 2628817 | 2021-01-10 | US | Tennessee | Jackson | 47087 | 1136 | 20 | 0 | 997 | 36.36380466 | -85.67239905 | 2021-01-11 05:21:50 | Jackson, Tennessee, US |
2627577 | 2627577 | 2021-01-10 | US | Minnesota | Faribault | 27043 | 1011 | 14 | 0 | 997 | 43.67381499 | -93.94787458 | 2021-01-11 05:21:50 | Faribault, Minnesota, US |
155133 | 155133 | 2021-01-08 | US | Iowa | Appanoose | 19007 | 1034 | 37 | 0 | 997 | 40.74324454 | -92.86865906 | 2021-01-09 05:22:18 | Appanoose, Iowa, US |
2541879 | 2541879 | 2021-01-07 | US | Arkansas | Desha | 5041 | 1008 | 11 | 0 | 997 | 33.83011025 | -91.25500948 | 2021-01-08 05:22:42 | Desha, Arkansas, US |
2866858 | 2866858 | 2021-01-06 | US | New Hampshire | Carroll | 33003 | 1001 | 4 | 0 | 997 | 43.87498583 | -71.20430216 | 2021-01-07 05:22:03 | Carroll, New Hampshire, US |
3035664 | 3035664 | 2021-01-05 | US | Kentucky | Bourbon | 21017 | 998 | 1 | 0 | 997 | 38.2054607 | -84.21827874 | 2021-01-06 05:22:16 | Bourbon, Kentucky, US |
1062595 | 1062595 | 2021-01-04 | US | Georgia | Bleckley | 13023 | 1032 | 35 | 0 | 997 | 32.43829035 | -83.33035166 | 2021-01-05 05:21:49 | Bleckley, Georgia, US |
1062228 | 1062228 | 2021-01-04 | US | Alabama | Macon | 1087 | 1027 | 30 | 0 | 997 | 32.38759944 | -85.69267724 | 2021-01-05 05:21:49 | Macon, Alabama, US |
3231089 | 3231089 | 2021-01-03 | US | Colorado | Prowers | 8099 | 1049 | 21 | 0 | 997 | 37.95544985 | -102.3926052 | 2021-01-04 05:22:02 | Prowers, Colorado, US |
2230881 | 2230881 | 2021-01-02 | US | Virginia | Martinsville | 51690 | 1024 | 27 | 0 | 997 | 36.68212094 | -79.86352771 | 2021-01-03 05:22:52 | Martinsville, Virginia, US |
2229204 | 2229204 | 2021-01-02 | US | Minnesota | Aitkin | 27001 | 1029 | 32 | 0 | 997 | 46.60962049 | -93.4116826 | 2021-01-03 05:22:52 | Aitkin, Minnesota, US |
3698533 | 3698533 | 2020-12-31 | US | Texas | Colorado | 48089 | 1039 | 15 | 0 | 997 | 29.622098 | -96.5273805 | 2021-01-01 05:23:07 | Colorado, Texas, US |
1013348 | 1013348 | 2020-12-30 | US | Texas | Colorado | 48089 | 986 | 15 | 0 | 997 | 29.622098 | -96.5273805 | 2020-12-31 05:22:49 | Colorado, Texas, US |
769650 | 769650 | 2020-12-29 | US | Virginia | Fredericksburg | 51630 | 1006 | 9 | 0 | 997 | 38.2977863 | -77.4922454 | 2020-12-30 05:22:34 | Fredericksburg, Virginia, US |
768657 | 768657 | 2020-12-29 | US | North Carolina | Northampton | 37131 | 1024 | 27 | 0 | 997 | 36.41736238 | -77.39769443 | 2020-12-30 05:22:34 | Northampton, North Carolina, US |
3778649 | 3778649 | 2020-12-27 | US | Georgia | Berrien | 13019 | 1028 | 31 | 0 | 997 | 31.27590016 | -83.22529920000002 | 2020-12-28 05:22:06 | Berrien, Georgia, US |
3778278 | 3778278 | 2020-12-27 | US | Alabama | Lamar | 1075 | 1012 | 15 | 0 | 997 | 33.77995024 | -88.09668032 | 2020-12-28 05:22:06 | Lamar, Alabama, US |
205771 | 205771 | 2020-12-25 | US | Wisconsin | Ashland | 55003 | 1011 | 14 | 0 | 997 | 46.31956891 | -90.67837132 | 2020-12-26 05:22:28 | Ashland, Wisconsin, US |
203280 | 203280 | 2020-12-25 | US | Illinois | Piatt | 17147 | 1003 | 6 | 0 | 997 | 40.01360584 | -88.59319339 | 2020-12-26 05:22:28 | Piatt, Illinois, US |
3772489 | 3772489 | 2020-12-22 | US | Oregon | Josephine | 41033 | 1016 | 19 | 0 | 997 | 42.3665549 | -123.5561938 | 2020-12-23 05:22:03 | Josephine, Oregon, US |
3771061 | 3771061 | 2020-12-22 | US | Iowa | Grundy | 19075 | 1011 | 14 | 0 | 997 | 42.40183723 | -92.78829551 | 2020-12-23 05:22:03 | Grundy, Iowa, US |
929047 | 929047 | 2020-12-21 | US | Kentucky | Allen | 21003 | 1012 | 15 | 0 | 997 | 36.75197631 | -86.19457544 | 2020-12-22 05:22:33 | Allen, Kentucky, US |
928741 | 928741 | 2020-12-21 | US | Illinois | White | 17193 | 1013 | 16 | 0 | 997 | 38.08706198 | -88.17657461 | 2020-12-22 05:22:33 | White, Illinois, US |
927543 | 927543 | 2020-12-21 | Colombia | Huila | 33067 | 1065 | 31005 | 997 | 2.5359 | -75.5277 | 2020-12-22 05:22:33 | Huila, Colombia | ||
2122693 | 2122693 | 2020-12-20 | US | Tennessee | Sequatchie | 47153 | 969 | 7 | 0 | 997 | 35.36979721 | -85.41022136 | 2020-12-21 05:27:58 | Sequatchie, Tennessee, US |
2121960 | 2121960 | 2020-12-20 | US | New York | Otsego | 36077 | 1005 | 8 | 0 | 997 | 42.63492579 | -75.03151402 | 2020-12-21 05:27:58 | Otsego, New York, US |
2121958 | 2121958 | 2020-12-20 | US | New York | Orleans | 36073 | 1056 | 59 | 0 | 997 | 43.2516977 | -78.2320066 | 2020-12-21 05:27:58 | Orleans, New York, US |
2121027 | 2121027 | 2020-12-20 | US | Kansas | Neosho | 20133 | 1006 | 9 | 0 | 997 | 37.55862897 | -95.30670046 | 2020-12-21 05:27:58 | Neosho, Kansas, US |
2932534 | 2932534 | 2020-12-19 | US | Kansas | Neosho | 20133 | 1006 | 9 | 0 | 997 | 37.55862897 | -95.30670046 | 2020-12-20 05:27:32 | Neosho, Kansas, US |
1903455 | 1903455 | 2020-12-18 | US | North Carolina | Caswell | 37033 | 1005 | 8 | 0 | 997 | 36.39312665 | -79.33353281 | 2020-12-19 05:27:52 | Caswell, North Carolina, US |
1902480 | 1902480 | 2020-12-18 | US | Kansas | Neosho | 20133 | 1006 | 9 | 0 | 997 | 37.55862897 | -95.30670046 | 2020-12-19 05:27:52 | Neosho, Kansas, US |
2129830 | 2129830 | 2020-12-17 | US | Mississippi | Stone | 28131 | 1015 | 18 | 0 | 997 | 30.79187949 | -89.11547539 | 2020-12-18 05:28:18 | Stone, Mississippi, US |
2129593 | 2129593 | 2020-12-17 | US | Michigan | Alpena | 26007 | 1018 | 21 | 0 | 997 | 45.03477666 | -83.62212411 | 2020-12-18 05:28:18 | Alpena, Michigan, US |
2129306 | 2129306 | 2020-12-17 | US | Kansas | Neosho | 20133 | 1006 | 9 | 0 | 997 | 37.55862897 | -95.30670046 | 2020-12-18 05:28:18 | Neosho, Kansas, US |
1753994 | 1753994 | 2020-12-14 | US | Puerto Rico | Dorado | 72051 | 997 | 0 | 0 | 997 | 18.436115 | -66.278669 | 2020-12-15 05:26:38 | Dorado, Puerto Rico, US |
845973 | 845973 | 2020-12-12 | US | Alabama | Washington | 1129 | 1020 | 23 | 0 | 997 | 31.4092794 | -88.20689944 | 2020-12-13 05:27:20 | Washington, Alabama, US |
1601027 | 1601027 | 2020-12-10 | US | Georgia | Hart | 13147 | 1026 | 29 | 0 | 997 | 34.34626973 | -82.96567682 | 2020-12-11 05:26:59 | Hart, Georgia, US |
1007313 | 1007313 | 2020-12-06 | US | Illinois | Moultrie | 17139 | 1008 | 11 | 0 | 997 | 39.64187451 | -88.62099969 | 2020-12-07 05:26:14 | Moultrie, Illinois, US |
1635655 | 1635655 | 2020-12-05 | US | Virginia | Lee | 51105 | 1012 | 15 | 0 | 997 | 36.70586667 | -83.12606515 | 2020-12-06 05:26:18 | Lee, Virginia, US |
3862365 | 3862365 | 2020-12-04 | US | Oklahoma | Craig | 40035 | 1000 | 3 | 0 | 997 | 36.76268118 | -95.20916602 | 2020-12-05 05:27:36 | Craig, Oklahoma, 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]);