johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
749 rows where active = 279 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 669
- Japan 13
- India 7
- Chile 5
- Colombia 5
- Malaysia 5
- United Kingdom 5
- Russia 4
- Ukraine 4
- Montenegro 3
- Cote d'Ivoire 2
- Latvia 2
- Liechtenstein 2
- Mauritania 2
- Netherlands 2
- United Arab Emirates 2
- Australia 1
- Canada 1
- Djibouti 1
- Egypt 1
- Eswatini 1
- France 1
- Germany 1
- Guinea-Bissau 1
- Iceland 1
- Italy 1
- Jordan 1
- Mexico 1
- Pakistan 1
- Singapore 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1607912 | 1607912 | 2021-08-16 | Malaysia | Perlis | 1062 | 13 | 770 | 279 | 6.4449 | 100.2048 | 2021-08-17 04:21:49 | Perlis, Malaysia | ||
3467964 | 3467964 | 2021-08-03 | Chile | Coquimbo | 47718 | 940 | 46499 | 279 | -29.959 | -71.3389 | 2021-08-04 04:21:25 | Coquimbo, Chile | ||
3015264 | 3015264 | 2021-08-01 | Germany | Mecklenburg-Vorpommern | 44415 | 1179 | 43000 | 279 | 53.6127 | 12.4296 | 2021-08-02 04:21:36 | Mecklenburg-Vorpommern, Germany | ||
3296201 | 3296201 | 2021-07-30 | Japan | Miyagi | 9841 | 91 | 9471 | 279 | 38.446859 | 140.927086 | 2021-07-31 04:21:35 | Miyagi, Japan | ||
3295962 | 3295962 | 2021-07-30 | Chile | Atacama | 26719 | 319 | 26121 | 279 | -27.5661 | -70.0503 | 2021-07-31 04:21:35 | Atacama, Chile | ||
408075 | 408075 | 2021-07-28 | Chile | Antofagasta | 59547 | 1186 | 58082 | 279 | -23.6509 | -70.3975 | 2021-07-29 04:21:33 | Antofagasta, Chile | ||
1378530 | 1378530 | 2021-07-25 | Japan | Miyagi | 9675 | 91 | 9305 | 279 | 38.446859 | 140.927086 | 2021-07-26 04:21:28 | Miyagi, Japan | ||
3137395 | 3137395 | 2021-07-23 | Colombia | Choco | 15691 | 378 | 15034 | 279 | 5.2528 | -76.82600000000002 | 2021-07-24 00:21:36 | Choco, Colombia | ||
3476155 | 3476155 | 2021-07-22 | Colombia | Choco | 15691 | 378 | 15034 | 279 | 5.2528 | -76.82600000000002 | 2021-07-23 04:21:29 | Choco, Colombia | ||
2375151 | 2375151 | 2021-07-20 | Ukraine | Sumy Oblast | 78204 | 1333 | 76592 | 279 | 50.9077 | 34.7981 | 2021-07-21 04:21:40 | Sumy Oblast, Ukraine | ||
1893094 | 1893094 | 2021-06-30 | India | Ladakh | 20073 | 202 | 19592 | 279 | 34.1526 | 77.5771 | 2021-07-01 04:21:19 | Ladakh, India | ||
3125619 | 3125619 | 2021-06-28 | Montenegro | 100204 | 1609 | 98316 | 279 | 42.708678000000006 | 19.37439 | 2021-06-29 04:21:28 | Montenegro | |||
3958618 | 3958618 | 2021-06-26 | Montenegro | 100168 | 1609 | 98280 | 279 | 42.708678000000006 | 19.37439 | 2021-06-27 04:21:39 | Montenegro | |||
1712533 | 1712533 | 2021-06-25 | Russia | Karachay-Cherkess Republic | 20788 | 170 | 20339 | 279 | 43.7368326 | 41.7267991 | 2021-06-26 04:21:43 | Karachay-Cherkess Republic, Russia | ||
2295562 | 2295562 | 2021-06-24 | Montenegro | 100131 | 1609 | 98243 | 279 | 42.708678000000006 | 19.37439 | 2021-06-25 04:21:33 | Montenegro | |||
1736499 | 1736499 | 2021-06-12 | Italy | P.A. Trento | 45676 | 1360 | 44037 | 279 | 46.06893511 | 11.12123097 | 2021-06-13 04:22:44 | P.A. Trento, Italy | ||
3970558 | 3970558 | 2021-06-11 | Japan | Gifu | 9044 | 176 | 8589 | 279 | 35.778671 | 137.055925 | 2021-06-12 04:22:22 | Gifu, Japan | ||
2939196 | 2939196 | 2021-05-16 | Cote d'Ivoire | 46656 | 298 | 46079 | 279 | 7.54 | -5.5471 | 2021-05-17 04:20:34 | Cote d'Ivoire | |||
2004686 | 2004686 | 2021-05-12 | Japan | Nagano | 4192 | 72 | 3841 | 279 | 36.132134 | 138.045528 | 2021-05-13 04:20:51 | Nagano, Japan | ||
2824810 | 2824810 | 2021-05-01 | Japan | Nagano | 3875 | 68 | 3528 | 279 | 36.132134 | 138.045528 | 2021-05-02 04:20:48 | Nagano, Japan | ||
3701990 | 3701990 | 2021-04-27 | Djibouti | 10931 | 142 | 10510 | 279 | 11.8251 | 42.5903 | 2021-04-28 04:20:32 | Djibouti | |||
3923867 | 3923867 | 2021-04-24 | Colombia | Putumayo | 9061 | 338 | 8444 | 279 | 0.436 | -75.5277 | 2021-04-25 04:20:32 | Putumayo, Colombia | ||
3242265 | 3242265 | 2021-04-21 | India | Arunachal Pradesh | 17186 | 56 | 16851 | 279 | 27.768456 | 96.384277 | 2021-04-22 04:20:53 | Arunachal Pradesh, India | ||
1302193 | 1302193 | 2021-04-01 | Pakistan | Balochistan | 19610 | 209 | 19122 | 279 | 28.328492 | 65.898403 | 2021-04-02 04:20:36 | Balochistan, Pakistan | ||
1984278 | 1984278 | 2021-03-25 | Vietnam | 2579 | 35 | 2265 | 279 | 14.058324 | 108.277199 | 2021-03-26 05:26:55 | Vietnam | |||
1744746 | 1744746 | 2021-03-20 | Russia | Kemerovo Oblast | 32736 | 592 | 31865 | 279 | 54.53357809999999 | 87.342861 | 2021-03-21 05:25:44 | Kemerovo Oblast, Russia | ||
1744546 | 1744546 | 2021-03-20 | Japan | Fukushima | 2300 | 103 | 1918 | 279 | 37.378867 | 140.223295 | 2021-03-21 05:25:44 | Fukushima, Japan | ||
1744380 | 1744380 | 2021-03-20 | Colombia | Casanare | 12749 | 294 | 12176 | 279 | 5.7589 | -71.5724 | 2021-03-21 05:25:44 | Casanare, Colombia | ||
1583827 | 1583827 | 2021-03-13 | Malaysia | Kelantan | 5319 | 22 | 5018 | 279 | 6.1254 | 102.2381 | 2021-03-14 05:25:37 | Kelantan, Malaysia | ||
54836 | 54836 | 2021-03-07 | Japan | Okinawa | 8321 | 120 | 7922 | 279 | 25.768923 | 126.668016 | 2021-03-08 05:24:48 | Okinawa, Japan | ||
3257159 | 3257159 | 2021-03-02 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-03-03 05:23:28 | Baylor, Texas, US |
3255174 | 3255174 | 2021-03-02 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-03-03 05:23:28 | Pope, Illinois, US |
1001451 | 1001451 | 2021-03-01 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-03-02 05:23:30 | Baylor, Texas, US |
999466 | 999466 | 2021-03-01 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-03-02 05:23:30 | Pope, Illinois, US |
2370509 | 2370509 | 2021-02-28 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-03-01 05:23:01 | Baylor, Texas, US |
2368524 | 2368524 | 2021-02-28 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-03-01 05:23:01 | Pope, Illinois, US |
3069011 | 3069011 | 2021-02-27 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-28 05:22:20 | Baylor, Texas, US |
3067026 | 3067026 | 2021-02-27 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-02-28 05:22:20 | Pope, Illinois, US |
2186595 | 2186595 | 2021-02-26 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-27 05:22:28 | Baylor, Texas, US |
2185813 | 2185813 | 2021-02-26 | US | New York | Hamilton | 36041 | 281 | 2 | 0 | 279 | 43.66146647 | -74.49721957 | 2021-02-27 05:22:28 | Hamilton, New York, US |
2184610 | 2184610 | 2021-02-26 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-02-27 05:22:28 | Pope, Illinois, US |
1861017 | 1861017 | 2021-02-25 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-26 05:22:40 | Baylor, Texas, US |
1859032 | 1859032 | 2021-02-25 | US | Illinois | Pope | 17151 | 282 | 3 | 0 | 279 | 37.41391284 | -88.56152109 | 2021-02-26 05:22:40 | Pope, Illinois, US |
1857946 | 1857946 | 2021-02-25 | India | Chandigarh | 21590 | 351 | 20960 | 279 | 30.733839 | 76.76827800000002 | 2021-02-26 05:22:40 | Chandigarh, India | ||
283195 | 283195 | 2021-02-24 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-25 05:24:57 | Baylor, Texas, US |
1939463 | 1939463 | 2021-02-23 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-24 05:29:16 | Baylor, Texas, US |
533718 | 533718 | 2021-02-22 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-23 05:23:41 | Baylor, Texas, US |
185052 | 185052 | 2021-02-21 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-22 05:24:21 | Baylor, Texas, US |
745375 | 745375 | 2021-02-20 | US | Texas | Delta | 48119 | 924 | 10 | 0 | 279 | 33.38570922 | -95.66921122 | 2021-02-21 05:24:33 | Delta, Texas, US |
745326 | 745326 | 2021-02-20 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-21 05:24:33 | Baylor, Texas, US |
474560 | 474560 | 2021-02-19 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-20 05:22:51 | Lipscomb, Texas, US |
474473 | 474473 | 2021-02-19 | US | Texas | Delta | 48119 | 924 | 10 | 0 | 279 | 33.38570922 | -95.66921122 | 2021-02-20 05:22:51 | Delta, Texas, US |
474424 | 474424 | 2021-02-19 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-20 05:22:51 | Baylor, Texas, US |
1156269 | 1156269 | 2021-02-18 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-19 05:24:16 | Lipscomb, Texas, US |
1156133 | 1156133 | 2021-02-18 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-19 05:24:16 | Baylor, Texas, US |
1153193 | 1153193 | 2021-02-18 | Mauritania | 17058 | 433 | 16346 | 279 | 21.0079 | -10.9408 | 2021-02-19 05:24:16 | Mauritania | |||
3604189 | 3604189 | 2021-02-17 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-18 05:22:58 | Lipscomb, Texas, US |
3604053 | 3604053 | 2021-02-17 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-18 05:22:58 | Baylor, Texas, US |
3053324 | 3053324 | 2021-02-16 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-17 05:23:10 | Lipscomb, Texas, US |
3053188 | 3053188 | 2021-02-16 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-17 05:23:10 | Baylor, Texas, US |
3051501 | 3051501 | 2021-02-16 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-17 05:23:10 | Rawlins, Kansas, US |
1341423 | 1341423 | 2021-02-15 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-16 05:24:38 | Lipscomb, Texas, US |
1341287 | 1341287 | 2021-02-15 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-16 05:24:38 | Baylor, Texas, US |
1339600 | 1339600 | 2021-02-15 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-16 05:24:38 | Rawlins, Kansas, US |
1338284 | 1338284 | 2021-02-15 | Japan | Gunma | 4282 | 81 | 3922 | 279 | 36.504479 | 138.985605 | 2021-02-16 05:24:38 | Gunma, Japan | ||
2286574 | 2286574 | 2021-02-14 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-15 05:24:49 | Lipscomb, Texas, US |
2286438 | 2286438 | 2021-02-14 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-15 05:24:49 | Baylor, Texas, US |
2285973 | 2285973 | 2021-02-14 | US | Oklahoma | Harmon | 40057 | 281 | 2 | 0 | 279 | 34.7440135 | -99.84741652 | 2021-02-15 05:24:49 | Harmon, Oklahoma, US |
2284751 | 2284751 | 2021-02-14 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-15 05:24:49 | Rawlins, Kansas, US |
2680974 | 2680974 | 2021-02-13 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-14 05:23:43 | Lipscomb, Texas, US |
2680874 | 2680874 | 2021-02-13 | US | Texas | Concho | 48095 | 341 | 7 | 0 | 279 | 31.32635934 | -99.86473038 | 2021-02-14 05:23:43 | Concho, Texas, US |
2680838 | 2680838 | 2021-02-13 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-14 05:23:43 | Baylor, Texas, US |
2680373 | 2680373 | 2021-02-13 | US | Oklahoma | Harmon | 40057 | 281 | 2 | 0 | 279 | 34.7440135 | -99.84741652 | 2021-02-14 05:23:43 | Harmon, Oklahoma, US |
2679151 | 2679151 | 2021-02-13 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-14 05:23:43 | Rawlins, Kansas, US |
3542607 | 3542607 | 2021-02-12 | US | Texas | Lipscomb | 48295 | 341 | 11 | 0 | 279 | 36.27783108 | -100.2733151 | 2021-02-13 05:22:12 | Lipscomb, Texas, US |
3542507 | 3542507 | 2021-02-12 | US | Texas | Concho | 48095 | 341 | 7 | 0 | 279 | 31.32635934 | -99.86473038 | 2021-02-13 05:22:12 | Concho, Texas, US |
3542471 | 3542471 | 2021-02-12 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-13 05:22:12 | Baylor, Texas, US |
3541821 | 3541821 | 2021-02-12 | US | North Carolina | Tyrrell | 37177 | 285 | 6 | 0 | 279 | 35.87147226 | -76.17055253 | 2021-02-13 05:22:12 | Tyrrell, North Carolina, US |
3540784 | 3540784 | 2021-02-12 | US | Kansas | Rawlins | 20153 | 286 | 7 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-13 05:22:12 | Rawlins, Kansas, US |
2640084 | 2640084 | 2021-02-11 | US | North Carolina | Tyrrell | 37177 | 285 | 6 | 0 | 279 | 35.87147226 | -76.17055253 | 2021-02-12 05:23:29 | Tyrrell, North Carolina, US |
3982088 | 3982088 | 2021-02-10 | US | West Virginia | Webster | 54101 | 279 | 0 | 0 | 279 | 38.49370949 | -80.4202023 | 2021-02-11 05:23:55 | Webster, West Virginia, US |
3980939 | 3980939 | 2021-02-10 | US | North Carolina | Tyrrell | 37177 | 285 | 6 | 0 | 279 | 35.87147226 | -76.17055253 | 2021-02-11 05:23:55 | Tyrrell, North Carolina, US |
1591224 | 1591224 | 2021-02-05 | US | Texas | Concho | 48095 | 340 | 6 | 0 | 279 | 31.32635934 | -99.86473038 | 2021-02-06 05:23:55 | Concho, Texas, US |
1588105 | 1588105 | 2021-02-05 | Guinea-Bissau | 2752 | 46 | 2427 | 279 | 11.8037 | -15.1804 | 2021-02-06 05:23:55 | Guinea-Bissau | |||
793395 | 793395 | 2021-02-04 | US | Texas | Baylor | 48023 | 271 | 11 | 0 | 279 | 33.61640794 | -99.21352901 | 2021-02-05 05:22:38 | Baylor, Texas, US |
791708 | 791708 | 2021-02-04 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-05 05:22:38 | Rawlins, Kansas, US |
791243 | 791243 | 2021-02-04 | US | Georgia | Schley | 13249 | 281 | 2 | 0 | 279 | 32.2654021 | -84.31258912 | 2021-02-05 05:22:38 | Schley, Georgia, US |
343012 | 343012 | 2021-02-03 | US | Puerto Rico | Hormigueros | 72067 | 279 | 0 | 0 | 279 | 18.134532 | -67.113972 | 2021-02-04 05:22:26 | Hormigueros, Puerto Rico, US |
341600 | 341600 | 2021-02-03 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-04 05:22:26 | Rawlins, Kansas, US |
340237 | 340237 | 2021-02-03 | India | Puducherry | 39146 | 652 | 38215 | 279 | 11.882658 | 78.86498 | 2021-02-04 05:22:26 | Puducherry, India | ||
1685826 | 1685826 | 2021-02-02 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-03 05:22:52 | Rawlins, Kansas, US |
1678234 | 1678234 | 2021-02-01 | US | Minnesota | Traverse | 27155 | 283 | 4 | 0 | 279 | 45.77298854 | -96.47062949 | 2021-02-02 05:22:49 | Traverse, Minnesota, US |
1677796 | 1677796 | 2021-02-01 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-02 05:22:49 | Rawlins, Kansas, US |
1461522 | 1461522 | 2021-01-31 | US | Minnesota | Traverse | 27155 | 283 | 4 | 0 | 279 | 45.77298854 | -96.47062949 | 2021-02-01 05:22:53 | Traverse, Minnesota, US |
1461084 | 1461084 | 2021-01-31 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-02-01 05:22:53 | Rawlins, Kansas, US |
1460035 | 1460035 | 2021-01-31 | Singapore | 59536 | 29 | 59228 | 279 | 1.2833 | 103.8333 | 2021-02-01 05:22:53 | Singapore | |||
1459766 | 1459766 | 2021-01-31 | Japan | Fukushima | 1727 | 44 | 1404 | 279 | 37.378867 | 140.223295 | 2021-02-01 05:22:53 | Fukushima, Japan | ||
2212992 | 2212992 | 2021-01-30 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-01-31 05:22:42 | Rawlins, Kansas, US |
1898479 | 1898479 | 2021-01-29 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-01-30 05:22:49 | Rawlins, Kansas, US |
2483295 | 2483295 | 2021-01-28 | US | Kansas | Rawlins | 20153 | 285 | 6 | 0 | 279 | 39.78525843 | -101.0761617 | 2021-01-29 05:22:23 | Rawlins, Kansas, 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]);