johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
260 rows where active = 883 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 27
- US 205
- Colombia 7
- Russia 7
- Sweden 5
- Chile 4
- Ukraine 4
- India 3
- Cote d'Ivoire 2
- Germany 2
- Italy 2
- Malaysia 2
- Uzbekistan 2
- Bosnia and Herzegovina 1
- Brazil 1
- Finland 1
- Hungary 1
- Iceland 1
- Japan 1
- Korea, South 1
- Lithuania 1
- Malawi 1
- Mali 1
- Pakistan 1
- Papua New Guinea 1
- Sri Lanka 1
- West Bank and Gaza 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3137621 | 3137621 | 2021-07-23 | Mali | 14532 | 530 | 13119 | 883 | 17.570692 | -3.996166000000001 | 2021-07-24 00:21:36 | Mali | |||
299699 | 299699 | 2021-07-15 | Malaysia | W.P. Labuan | 9330 | 138 | 8309 | 883 | 5.2831 | 115.2308 | 2021-07-16 04:21:22 | W.P. Labuan, Malaysia | ||
3631874 | 3631874 | 2021-07-14 | Germany | Rheinland-Pfalz | 155757 | 3894 | 151100 | 883 | 50.1183 | 7.309 | 2021-07-15 04:21:48 | Rheinland-Pfalz, Germany | ||
2071704 | 2071704 | 2021-07-02 | Chile | Coquimbo | 45208 | 825 | 43500 | 883 | -29.959 | -71.3389 | 2021-07-03 04:21:37 | Coquimbo, Chile | ||
3358665 | 3358665 | 2021-06-21 | Italy | Umbria | 56775 | 1418 | 54474 | 883 | 43.10675841 | 12.38824698 | 2021-06-22 04:21:34 | Umbria, Italy | ||
3089274 | 3089274 | 2021-05-30 | Colombia | Meta | 52563 | 1235 | 50445 | 883 | 3.272 | -73.0877 | 2021-05-31 03:08:59 | Meta, Colombia | ||
1310400 | 1310400 | 2021-05-26 | Russia | Omsk Oblast | 47188 | 1429 | 44876 | 883 | 56.09352629999999 | 73.5099936 | 2021-05-27 04:20:59 | Omsk Oblast, Russia | ||
83243 | 83243 | 2021-05-25 | Papua New Guinea | 15222 | 156 | 14183 | 883 | -6.314993 | 143.95555 | 2021-05-26 04:20:35 | Papua New Guinea | |||
3675512 | 3675512 | 2021-05-04 | Colombia | Sucre | 28912 | 1009 | 27020 | 883 | 8.814 | -74.7233 | 2021-05-05 04:20:43 | Sucre, Colombia | ||
2824852 | 2824852 | 2021-05-01 | Malawi | 34095 | 1148 | 32064 | 883 | -13.2543 | 34.3015 | 2021-05-02 04:20:48 | Malawi | |||
1636168 | 1636168 | 2021-04-29 | Colombia | Meta | 46648 | 1065 | 44700 | 883 | 3.272 | -73.0877 | 2021-04-30 04:21:03 | Meta, Colombia | ||
1980453 | 1980453 | 2021-03-25 | Colombia | Boyaca | 47719 | 1146 | 45690 | 883 | 5.4545 | -73.362 | 2021-03-26 05:26:55 | Boyaca, Colombia | ||
3369533 | 3369533 | 2021-03-21 | Russia | Kamchatka Krai | 13967 | 188 | 12896 | 883 | 57.1914882 | 160.03838190000005 | 2021-03-22 05:25:43 | Kamchatka Krai, Russia | ||
3456521 | 3456521 | 2021-03-18 | Yemen | 3126 | 723 | 1520 | 883 | 15.552727 | 48.516388 | 2021-03-19 05:26:09 | Yemen | |||
3663469 | 3663469 | 2021-03-09 | Colombia | Tolima | 65684 | 2109 | 62692 | 883 | 4.0925 | -75.1545 | 2021-03-10 05:24:35 | Tolima, Colombia | ||
3669634 | 3669634 | 2021-03-06 | US | Montana | Powell | 30077 | 890 | 7 | 0 | 883 | 46.85538891 | -112.9359164 | 2021-03-07 05:21:54 | Powell, Montana, US |
3667533 | 3667533 | 2021-03-06 | Germany | Bremen | 18403 | 364 | 17215 | 883 | 53.0793 | 8.8017 | 2021-03-07 05:21:54 | Bremen, Germany | ||
1618255 | 1618255 | 2021-03-05 | US | Montana | Powell | 30077 | 890 | 7 | 0 | 883 | 46.85538891 | -112.9359164 | 2021-03-06 04:23:41 | Powell, Montana, US |
2209666 | 2209666 | 2021-03-04 | US | Montana | Powell | 30077 | 890 | 7 | 0 | 883 | 46.85538891 | -112.9359164 | 2021-03-05 05:26:29 | Powell, Montana, US |
2209029 | 2209029 | 2021-03-04 | US | Kentucky | Carroll | 21041 | 893 | 10 | 0 | 883 | 38.66599534 | -85.12601074 | 2021-03-05 05:26:29 | Carroll, Kentucky, US |
2207603 | 2207603 | 2021-03-04 | India | Jammu and Kashmir | 126772 | 1959 | 123930 | 883 | 33.75943 | 76.612638 | 2021-03-05 05:26:29 | Jammu and Kashmir, India | ||
3256194 | 3256194 | 2021-03-02 | US | Nebraska | Cheyenne | 31033 | 899 | 16 | 0 | 883 | 41.21999357 | -102.9941693 | 2021-03-03 05:23:28 | Cheyenne, Nebraska, US |
3068823 | 3068823 | 2021-02-27 | US | South Carolina | McCormick | 45065 | 909 | 26 | 0 | 883 | 33.90161443 | -82.30794338 | 2021-02-28 05:22:20 | McCormick, South Carolina, US |
2186299 | 2186299 | 2021-02-26 | US | Puerto Rico | Camuy | 72027 | 883 | 0 | 0 | 883 | 18.418578 | -66.860206 | 2021-02-27 05:22:28 | Camuy, Puerto Rico, US |
1859206 | 1859206 | 2021-02-25 | US | Iowa | Keokuk | 19107 | 912 | 29 | 0 | 883 | 41.33649833 | -92.1785067 | 2021-02-26 05:22:40 | Keokuk, Iowa, US |
1857875 | 1857875 | 2021-02-25 | Cote d'Ivoire | 32295 | 188 | 31224 | 883 | 7.54 | -5.5471 | 2021-02-26 05:22:40 | Cote d'Ivoire | |||
283449 | 283449 | 2021-02-24 | US | Utah | Unassigned | 90049 | 884 | 1 | 0 | 883 | 41.72330587 | 0.0 | 2021-02-25 05:24:57 | Unassigned, Utah, US |
280053 | 280053 | 2021-02-24 | Cote d'Ivoire | 32295 | 188 | 31224 | 883 | 7.54 | -5.5471 | 2021-02-25 05:24:57 | Cote d'Ivoire | |||
745973 | 745973 | 2021-02-20 | Uzbekistan | 79632 | 622 | 78127 | 883 | 41.377491 | 64.585262 | 2021-02-21 05:24:33 | Uzbekistan | |||
744114 | 744114 | 2021-02-20 | US | Mississippi | Humphreys | 28053 | 909 | 26 | 0 | 883 | 33.12825718 | -90.52252707 | 2021-02-21 05:24:33 | Humphreys, Mississippi, US |
473449 | 473449 | 2021-02-19 | US | Nebraska | Box Butte | 31013 | 891 | 8 | 0 | 883 | 42.22079243 | -103.0878834 | 2021-02-20 05:22:51 | Box Butte, Nebraska, US |
473424 | 473424 | 2021-02-19 | US | Montana | Powell | 30077 | 890 | 7 | 0 | 883 | 46.85538891 | -112.9359164 | 2021-02-20 05:22:51 | Powell, Montana, US |
473212 | 473212 | 2021-02-19 | US | Mississippi | Humphreys | 28053 | 909 | 26 | 0 | 883 | 33.12825718 | -90.52252707 | 2021-02-20 05:22:51 | Humphreys, Mississippi, US |
1156404 | 1156404 | 2021-02-18 | US | Vermont | Windham | 50025 | 895 | 12 | 0 | 883 | 42.986982 | -72.71268875 | 2021-02-19 05:24:16 | Windham, Vermont, US |
2680194 | 2680194 | 2021-02-13 | US | North Carolina | Washington | 37187 | 909 | 26 | 0 | 883 | 35.83810081 | -76.57299037 | 2021-02-14 05:23:43 | Washington, North Carolina, US |
2679714 | 2679714 | 2021-02-13 | US | Missouri | DeKalb | 29063 | 909 | 26 | 0 | 883 | 39.89201062 | -94.40476508 | 2021-02-14 05:23:43 | DeKalb, Missouri, US |
3541347 | 3541347 | 2021-02-12 | US | Missouri | DeKalb | 29063 | 909 | 26 | 0 | 883 | 39.89201062 | -94.40476508 | 2021-02-13 05:22:12 | DeKalb, Missouri, US |
3540898 | 3540898 | 2021-02-12 | US | Kentucky | Metcalfe | 21169 | 902 | 19 | 0 | 883 | 36.99459295 | -85.63123699 | 2021-02-13 05:22:12 | Metcalfe, Kentucky, US |
2639610 | 2639610 | 2021-02-11 | US | Missouri | DeKalb | 29063 | 909 | 26 | 0 | 883 | 39.89201062 | -94.40476508 | 2021-02-12 05:23:29 | DeKalb, Missouri, US |
2638219 | 2638219 | 2021-02-11 | US | Arkansas | Marion | 5089 | 911 | 28 | 0 | 883 | 36.26844485 | -92.68451899 | 2021-02-12 05:23:29 | Marion, Arkansas, US |
3982069 | 3982069 | 2021-02-10 | US | West Virginia | Morgan | 54065 | 895 | 12 | 0 | 883 | 39.55439028 | -78.26311676 | 2021-02-11 05:23:55 | Morgan, West Virginia, US |
1531227 | 1531227 | 2021-02-09 | US | Virginia | Franklin City | 51620 | 906 | 23 | 0 | 883 | 36.6831435 | -76.93859681 | 2021-02-10 05:22:41 | Franklin City, Virginia, US |
616407 | 616407 | 2021-02-08 | US | Puerto Rico | Catano | 72033 | 883 | 0 | 0 | 883 | 18.437269 | -66.14330600000001 | 2021-02-09 05:23:30 | Catano, Puerto Rico, US |
614224 | 614224 | 2021-02-08 | US | California | Del Norte | 6015 | 889 | 2 | 0 | 883 | 41.74228275 | -123.8974063 | 2021-02-09 05:23:30 | Del Norte, California, US |
1672404 | 1672404 | 2021-02-07 | India | Haryana | 268431 | 3029 | 264519 | 883 | 29.20004 | 76.332824 | 2021-02-08 05:22:39 | Haryana, India | ||
976635 | 976635 | 2021-02-06 | US | Minnesota | Jackson | 27063 | 893 | 10 | 0 | 883 | 43.67423373 | -95.15398258 | 2021-02-07 05:23:00 | Jackson, Minnesota, US |
1588683 | 1588683 | 2021-02-05 | US | Arkansas | Pike | 5109 | 903 | 20 | 0 | 883 | 34.16250414 | -93.65789349 | 2021-02-06 05:23:55 | Pike, Arkansas, US |
1685915 | 1685915 | 2021-02-02 | US | Kentucky | Knott | 21119 | 897 | 14 | 0 | 883 | 37.35388197 | -82.94981134 | 2021-02-03 05:22:52 | Knott, Kentucky, US |
1679332 | 1679332 | 2021-02-01 | US | South Dakota | Grant | 46051 | 920 | 37 | 0 | 883 | 45.1723937 | -96.77002276 | 2021-02-02 05:22:49 | Grant, South Dakota, US |
1462904 | 1462904 | 2021-01-31 | US | Texas | Leon | 48289 | 1273 | 33 | 0 | 883 | 31.29872538 | -95.9936328 | 2021-02-01 05:22:53 | Leon, Texas, US |
1462620 | 1462620 | 2021-01-31 | US | South Dakota | Grant | 46051 | 920 | 37 | 0 | 883 | 45.1723937 | -96.77002276 | 2021-02-01 05:22:53 | Grant, South Dakota, US |
1460951 | 1460951 | 2021-01-31 | US | Iowa | Howard | 19089 | 903 | 20 | 0 | 883 | 43.35671042 | -92.31702714 | 2021-02-01 05:22:53 | Howard, Iowa, US |
2213120 | 2213120 | 2021-01-30 | US | Kentucky | Powell | 21197 | 883 | 0 | 0 | 883 | 37.83218794 | -83.82553961 | 2021-01-31 05:22:42 | Powell, Kentucky, US |
15350 | 15350 | 2021-01-26 | US | Texas | Bandera | 48019 | 1013 | 21 | 0 | 883 | 29.74619598 | -99.24598147 | 2021-01-27 05:23:41 | Bandera, Texas, US |
15079 | 15079 | 2021-01-26 | US | Puerto Rico | Isabela | 72071 | 883 | 0 | 0 | 883 | 18.44981 | -67.005093 | 2021-01-27 05:23:41 | Isabela, Puerto Rico, US |
2568325 | 2568325 | 2021-01-25 | US | Connecticut | Unassigned | 90009 | 892 | 9 | 0 | 883 | 41.85853803 | 0.0 | 2021-01-26 05:22:02 | Unassigned, Connecticut, US |
2568289 | 2568289 | 2021-01-25 | US | Colorado | Lincoln | 8073 | 910 | 4 | 0 | 883 | 38.98749519 | -103.5136649 | 2021-01-26 05:22:02 | Lincoln, Colorado, US |
1759921 | 1759921 | 2021-01-24 | US | Colorado | Lincoln | 8073 | 906 | 4 | 0 | 883 | 38.98749519 | -103.5136649 | 2021-01-25 05:22:16 | Lincoln, Colorado, US |
2467429 | 2467429 | 2021-01-22 | US | Colorado | Las Animas | 8071 | 927 | 11 | 0 | 883 | 37.3153406 | -104.0376458 | 2021-01-23 05:22:03 | Las Animas, Colorado, US |
438669 | 438669 | 2021-01-21 | US | Virginia | Colonial Heights | 51570 | 913 | 30 | 0 | 883 | 37.26420587 | -77.39609676 | 2021-01-22 05:22:10 | Colonial Heights, Virginia, US |
911571 | 911571 | 2021-01-19 | US | Virginia | Rockbridge | 51163 | 904 | 21 | 0 | 883 | 37.81204314 | -79.44605905 | 2021-01-20 05:21:54 | Rockbridge, Virginia, US |
238629 | 238629 | 2021-01-18 | US | Kentucky | Fleming | 21069 | 889 | 6 | 0 | 883 | 38.36758311 | -83.69657514 | 2021-01-19 05:22:15 | Fleming, Kentucky, US |
3503153 | 3503153 | 2021-01-17 | Chile | OHiggins | 23655 | 625 | 22147 | 883 | -34.5755 | -71.0022 | 2021-01-18 05:22:34 | OHiggins, Chile | ||
3517548 | 3517548 | 2021-01-15 | US | New Hampshire | Coos | 33007 | 903 | 20 | 0 | 883 | 44.69063265 | -71.30633239 | 2021-01-16 05:22:40 | Coos, New Hampshire, US |
3883233 | 3883233 | 2021-01-14 | Uzbekistan | 77777 | 618 | 76276 | 883 | 41.377491 | 64.585262 | 2021-01-15 05:22:24 | Uzbekistan | |||
3881129 | 3881129 | 2021-01-14 | US | Maine | Somerset | 23025 | 907 | 24 | 0 | 883 | 45.51229767 | -69.95995554 | 2021-01-15 05:22:24 | Somerset, Maine, US |
3308695 | 3308695 | 2021-01-13 | US | Arkansas | Little River | 5081 | 922 | 39 | 0 | 883 | 33.70375665 | -94.23468591 | 2021-01-14 05:22:32 | Little River, Arkansas, US |
777378 | 777378 | 2021-01-12 | US | Texas | Camp | 48063 | 929 | 29 | 0 | 883 | 32.97195142 | -94.97790104 | 2021-01-13 05:22:15 | Camp, Texas, US |
193356 | 193356 | 2021-01-11 | US | Virginia | Alleghany | 51005 | 909 | 26 | 0 | 883 | 37.78636074 | -80.00222498 | 2021-01-12 05:22:15 | Alleghany, Virginia, US |
191680 | 191680 | 2021-01-11 | US | Michigan | Charlevoix | 26029 | 893 | 10 | 0 | 883 | 45.37790017 | -85.19614053 | 2021-01-12 05:22:15 | Charlevoix, Michigan, US |
2628481 | 2628481 | 2021-01-10 | US | Oregon | Hood River | 41027 | 903 | 20 | 0 | 883 | 45.51872811 | -121.65520359999998 | 2021-01-11 05:21:50 | Hood River, Oregon, US |
2627342 | 2627342 | 2021-01-10 | US | Kentucky | Webster | 21233 | 895 | 12 | 0 | 883 | 37.52168356 | -87.67989953 | 2021-01-11 05:21:50 | Webster, Kentucky, US |
3902306 | 3902306 | 2021-01-09 | US | North Carolina | Polk | 37149 | 897 | 14 | 0 | 883 | 35.27820615 | -82.16812354 | 2021-01-10 05:22:12 | Polk, North Carolina, US |
3901702 | 3901702 | 2021-01-09 | US | Minnesota | Pipestone | 27117 | 905 | 22 | 0 | 883 | 44.02301619 | -96.25841142 | 2021-01-10 05:22:12 | Pipestone, Minnesota, US |
3901328 | 3901328 | 2021-01-09 | US | Kentucky | Butler | 21031 | 899 | 16 | 0 | 883 | 37.20946153 | -86.68748787 | 2021-01-10 05:22:12 | Butler, Kentucky, US |
3900830 | 3900830 | 2021-01-09 | US | Georgia | Telfair | 13271 | 922 | 39 | 0 | 883 | 31.92829517 | -82.93491155 | 2021-01-10 05:22:12 | Telfair, Georgia, US |
2867467 | 2867467 | 2021-01-06 | US | Puerto Rico | Moca | 72099 | 883 | 0 | 0 | 883 | 18.377805 | -67.080952 | 2021-01-07 05:22:03 | Moca, Puerto Rico, US |
2866835 | 2866835 | 2021-01-06 | US | Nebraska | Wayne | 31179 | 889 | 6 | 0 | 883 | 42.20934475 | -97.11926964 | 2021-01-07 05:22:03 | Wayne, Nebraska, US |
2866117 | 2866117 | 2021-01-06 | US | Kentucky | Harrison | 21097 | 884 | 1 | 0 | 883 | 38.44188174 | -84.32869741 | 2021-01-07 05:22:03 | Harrison, Kentucky, US |
3233198 | 3233198 | 2021-01-03 | US | Puerto Rico | Manati | 72091 | 883 | 0 | 0 | 883 | 18.420473 | -66.490461 | 2021-01-04 05:22:02 | Manati, Puerto Rico, US |
2230067 | 2230067 | 2021-01-02 | US | Oklahoma | Haskell | 40061 | 890 | 7 | 0 | 883 | 35.22257600000001 | -95.11513306 | 2021-01-03 05:22:52 | Haskell, Oklahoma, US |
1139513 | 1139513 | 2021-01-01 | US | Oregon | Wasco | 41065 | 905 | 22 | 0 | 883 | 45.16292781 | -121.1670954 | 2021-01-02 05:22:33 | Wasco, Oregon, US |
3698119 | 3698119 | 2020-12-31 | US | Oregon | Wasco | 41065 | 905 | 22 | 0 | 883 | 45.16292781 | -121.1670954 | 2021-01-01 05:23:07 | Wasco, Oregon, US |
767983 | 767983 | 2020-12-29 | US | Michigan | Ogemaw | 26129 | 912 | 29 | 0 | 883 | 44.33481032 | -84.12725175 | 2020-12-30 05:22:34 | Ogemaw, Michigan, US |
2226103 | 2226103 | 2020-12-26 | US | Oklahoma | Woods | 40151 | 887 | 4 | 0 | 883 | 36.76705782 | -98.86573064 | 2020-12-27 05:22:55 | Woods, Oklahoma, US |
2224256 | 2224256 | 2020-12-26 | US | Georgia | Bleckley | 13023 | 918 | 35 | 0 | 883 | 32.43829035 | -83.33035166 | 2020-12-27 05:22:55 | Bleckley, Georgia, US |
2223729 | 2223729 | 2020-12-26 | Russia | Mari El Republic | 8932 | 115 | 7934 | 883 | 56.5767504 | 47.8817512 | 2020-12-27 05:22:55 | Mari El Republic, Russia | ||
204473 | 204473 | 2020-12-25 | US | New York | Clinton | 36019 | 890 | 7 | 0 | 883 | 44.74530905 | -73.67875352 | 2020-12-26 05:22:28 | Clinton, New York, US |
204238 | 204238 | 2020-12-25 | US | Montana | Dawson | 30021 | 905 | 22 | 0 | 883 | 47.26584855 | -104.89444170000002 | 2020-12-26 05:22:28 | Dawson, Montana, US |
203972 | 203972 | 2020-12-25 | US | Minnesota | Kanabec | 27065 | 901 | 18 | 0 | 883 | 45.9459309 | -93.29275192 | 2020-12-26 05:22:28 | Kanabec, Minnesota, US |
3693461 | 3693461 | 2020-12-24 | US | Montana | Dawson | 30021 | 905 | 22 | 0 | 883 | 47.26584855 | -104.89444170000002 | 2020-12-25 05:22:48 | Dawson, Montana, US |
3693195 | 3693195 | 2020-12-24 | US | Minnesota | Kanabec | 27065 | 901 | 18 | 0 | 883 | 45.9459309 | -93.29275192 | 2020-12-25 05:22:48 | Kanabec, Minnesota, US |
3691951 | 3691951 | 2020-12-24 | US | Arkansas | Desha | 5041 | 894 | 11 | 0 | 883 | 33.83011025 | -91.25500948 | 2020-12-25 05:22:48 | Desha, Arkansas, US |
2408369 | 2408369 | 2020-12-23 | US | Louisiana | West Feliciana | 22125 | 908 | 25 | 0 | 883 | 30.87882871 | -91.4148538 | 2020-12-24 05:23:04 | West Feliciana, Louisiana, US |
2406852 | 2406852 | 2020-12-23 | Japan | Kyoto | 3998 | 44 | 3071 | 883 | 35.253815 | 135.443341 | 2020-12-24 05:23:04 | Kyoto, Japan | ||
3772176 | 3772176 | 2020-12-22 | US | North Carolina | Dare | 37055 | 888 | 5 | 0 | 883 | 35.66520691 | -75.71767334 | 2020-12-23 05:22:03 | Dare, North Carolina, US |
3771157 | 3771157 | 2020-12-22 | US | Kansas | Grant | 20067 | 897 | 14 | 0 | 883 | 37.56227336 | -101.3079758 | 2020-12-23 05:22:03 | Grant, Kansas, US |
3770257 | 3770257 | 2020-12-22 | US | Alabama | Macon | 1087 | 912 | 29 | 0 | 883 | 32.38759944 | -85.69267724 | 2020-12-23 05:22:03 | Macon, Alabama, US |
930589 | 930589 | 2020-12-21 | US | South Dakota | Turner | 46125 | 930 | 47 | 0 | 883 | 43.3109081 | -97.14865776 | 2020-12-22 05:22:33 | Turner, South Dakota, US |
929180 | 929180 | 2020-12-21 | US | Louisiana | Claiborne | 22027 | 915 | 32 | 0 | 883 | 32.82308512 | -92.99526883 | 2020-12-22 05:22:33 | Claiborne, Louisiana, 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]);