johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
685 rows where active = 298 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 580
- Japan 14
- Russia 14
- France 11
- Benin 7
- India 6
- Malaysia 5
- Chile 4
- Colombia 4
- Italy 4
- Pakistan 4
- Germany 3
- Belize 2
- Cote d'Ivoire 2
- Gabon 2
- Guinea-Bissau 2
- Mexico 2
- Bhutan 1
- Brazil 1
- Burkina Faso 1
- Cuba 1
- Eswatini 1
- Georgia 1
- Ghana 1
- Guyana 1
- Hungary 1
- Jamaica 1
- Montenegro 1
- Sierra Leone 1
- Sri Lanka 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468088 | 3468088 | 2021-08-03 | Germany | Bremen | 27932 | 493 | 27180 | 298 | 53.0793 | 8.8017 | 2021-08-04 04:21:25 | Bremen, Germany | ||
3468011 | 3468011 | 2021-08-03 | Colombia | Arauca | 12814 | 415 | 12101 | 298 | 7.0762 | -70.7105 | 2021-08-04 04:21:25 | Arauca, Colombia | ||
3015546 | 3015546 | 2021-08-01 | Russia | Chukotka Autonomous Okrug | 1173 | 9 | 866 | 298 | 66.0006475 | 169.4900869 | 2021-08-02 04:21:36 | Chukotka Autonomous Okrug, Russia | ||
3385311 | 3385311 | 2021-07-29 | Germany | Thuringen | 129178 | 4380 | 124500 | 298 | 51.011 | 10.8453 | 2021-07-30 04:21:34 | Thuringen, Germany | ||
408322 | 408322 | 2021-07-28 | Japan | Niigata | 3864 | 54 | 3512 | 298 | 37.521819 | 138.918647 | 2021-07-29 04:21:33 | Niigata, Japan | ||
3218262 | 3218262 | 2021-07-26 | India | Rajasthan | 953560 | 8952 | 944310 | 298 | 26.583423 | 73.847973 | 2021-07-27 04:21:18 | Rajasthan, India | ||
1329992 | 1329992 | 2021-07-24 | Brazil | Piaui | 307472 | 6797 | 300312 | 298 | -7.7183 | -42.7289 | 2021-07-25 04:22:12 | Piaui, Brazil | ||
3479966 | 3479966 | 2021-07-22 | United Kingdom | Gibraltar | 4728 | 94 | 4336 | 298 | 36.1408 | -5.3536 | 2021-07-23 04:21:29 | Gibraltar, United Kingdom | ||
3476334 | 3476334 | 2021-07-22 | Japan | Miyagi | 9626 | 91 | 9237 | 298 | 38.446859 | 140.927086 | 2021-07-23 04:21:29 | Miyagi, Japan | ||
1495640 | 1495640 | 2021-07-03 | Japan | Shizuoka | 9388 | 151 | 8939 | 298 | 34.916975 | 138.40778400000002 | 2021-07-04 04:21:38 | Shizuoka, Japan | ||
1893335 | 1893335 | 2021-06-30 | Russia | Chechen Republic | 12805 | 157 | 12350 | 298 | 43.39761470000001 | 45.6985005 | 2021-07-01 04:21:19 | Chechen Republic, Russia | ||
3958460 | 3958460 | 2021-06-26 | India | Lakshadweep | 9659 | 48 | 9313 | 298 | 13.6999972 | 72.18333259999999 | 2021-06-27 04:21:39 | Lakshadweep, India | ||
3358781 | 3358781 | 2021-06-21 | Montenegro | 100092 | 1605 | 98189 | 298 | 42.708678000000006 | 19.37439 | 2021-06-22 04:21:34 | Montenegro | |||
2884552 | 2884552 | 2021-06-20 | Russia | Adygea Republic | 14853 | 227 | 14328 | 298 | 44.6939006 | 40.1520421 | 2021-06-21 04:21:41 | Adygea Republic, Russia | ||
107464 | 107464 | 2021-06-19 | Japan | Ibaraki | 10254 | 161 | 9795 | 298 | 36.303588 | 140.319591 | 2021-06-20 04:21:48 | Ibaraki, Japan | ||
3381557 | 3381557 | 2021-06-13 | Russia | Adygea Republic | 14782 | 216 | 14268 | 298 | 44.6939006 | 40.1520421 | 2021-06-14 04:22:46 | Adygea Republic, Russia | ||
825307 | 825307 | 2021-06-06 | Bhutan | 1687 | 1 | 1388 | 298 | 27.5142 | 90.4336 | 2021-06-07 04:22:51 | Bhutan | |||
1708101 | 1708101 | 2021-06-02 | Chile | Magallanes | 27871 | 411 | 27162 | 298 | -52.368 | -70.9863 | 2021-06-03 04:23:32 | Magallanes, Chile | ||
2104146 | 2104146 | 2021-06-01 | Japan | Kagoshima | 3352 | 30 | 3024 | 298 | 31.009484000000004 | 130.430665 | 2021-06-02 04:24:34 | Kagoshima, Japan | ||
3089424 | 3089424 | 2021-05-30 | Japan | Aomori | 2341 | 30 | 2013 | 298 | 40.781541 | 140.828896 | 2021-05-31 03:08:59 | Aomori, Japan | ||
1771213 | 1771213 | 2021-05-23 | Cote d'Ivoire | 46942 | 298 | 46346 | 298 | 7.54 | -5.5471 | 2021-05-24 04:20:53 | Cote d'Ivoire | |||
726368 | 726368 | 2021-05-22 | Cote d'Ivoire | 46942 | 298 | 46346 | 298 | 7.54 | -5.5471 | 2021-05-23 04:20:51 | Cote d'Ivoire | |||
1913414 | 1913414 | 2021-05-20 | Russia | Kalmykia Republic | 20681 | 366 | 20017 | 298 | 46.2313018 | 45.3275745 | 2021-05-21 04:20:43 | Kalmykia Republic, Russia | ||
2820626 | 2820626 | 2021-05-10 | Colombia | Putumayo | 10495 | 390 | 9807 | 298 | 0.436 | -75.5277 | 2021-05-11 04:20:41 | Putumayo, Colombia | ||
3113414 | 3113414 | 2021-05-06 | Guinea-Bissau | 3738 | 67 | 3373 | 298 | 11.8037 | -15.1804 | 2021-05-07 04:20:40 | Guinea-Bissau | |||
645881 | 645881 | 2021-05-05 | Guinea-Bissau | 3738 | 67 | 3373 | 298 | 11.8037 | -15.1804 | 2021-05-06 04:20:38 | Guinea-Bissau | |||
2450819 | 2450819 | 2021-05-02 | Japan | Yamaguchi | 1889 | 46 | 1545 | 298 | 34.201190000000004 | 131.573293 | 2021-05-03 04:20:39 | Yamaguchi, Japan | ||
3393442 | 3393442 | 2021-04-28 | Japan | Yamaguchi | 1790 | 43 | 1449 | 298 | 34.201190000000004 | 131.573293 | 2021-04-29 04:20:55 | Yamaguchi, Japan | ||
3927688 | 3927688 | 2021-04-24 | Malaysia | Melaka | 7120 | 22 | 6800 | 298 | 2.1896 | 102.2501 | 2021-04-25 04:20:32 | Melaka, Malaysia | ||
3924050 | 3924050 | 2021-04-24 | Japan | Shizuoka | 6294 | 121 | 5875 | 298 | 34.916975 | 138.40778400000002 | 2021-04-25 04:20:32 | Shizuoka, Japan | ||
3923913 | 3923913 | 2021-04-24 | France | St Martin | 1710 | 13 | 1399 | 298 | 18.0708 | -63.0501 | 2021-04-25 04:20:32 | St Martin, France | ||
1408944 | 1408944 | 2021-04-23 | France | St Martin | 1710 | 13 | 1399 | 298 | 18.0708 | -63.0501 | 2021-04-24 04:20:38 | St Martin, France | ||
1568007 | 1568007 | 2021-04-22 | France | St Martin | 1710 | 13 | 1399 | 298 | 18.0708 | -63.0501 | 2021-04-23 04:20:52 | St Martin, France | ||
3242228 | 3242228 | 2021-04-21 | France | St Martin | 1710 | 13 | 1399 | 298 | 18.0708 | -63.0501 | 2021-04-22 04:20:53 | St Martin, France | ||
2020624 | 2020624 | 2021-04-20 | France | St Martin | 1710 | 13 | 1399 | 298 | 18.0708 | -63.0501 | 2021-04-21 04:21:14 | St Martin, France | ||
2410745 | 2410745 | 2021-04-19 | France | St Martin | 1710 | 13 | 1399 | 298 | 18.0708 | -63.0501 | 2021-04-20 04:20:41 | St Martin, France | ||
3133199 | 3133199 | 2021-04-18 | Malaysia | Pahang | 4698 | 18 | 4382 | 298 | 3.8126 | 103.3256 | 2021-04-19 04:20:57 | Pahang, Malaysia | ||
3129422 | 3129422 | 2021-04-18 | France | St Martin | 1710 | 13 | 1399 | 298 | 18.0708 | -63.0501 | 2021-04-19 04:20:57 | St Martin, France | ||
170080 | 170080 | 2021-04-16 | Japan | Shiga | 3134 | 59 | 2777 | 298 | 35.21582700000001 | 136.138064 | 2021-04-17 04:20:40 | Shiga, Japan | ||
36398 | 36398 | 2021-04-12 | India | Tripura | 33805 | 394 | 33113 | 298 | 23.746783 | 91.743565 | 2021-04-13 04:20:37 | Tripura, India | ||
3887267 | 3887267 | 2021-04-11 | Malaysia | Pahang | 4523 | 18 | 4207 | 298 | 3.8126 | 103.3256 | 2021-04-12 04:21:00 | Pahang, Malaysia | ||
1881319 | 1881319 | 2021-03-26 | Timor-Leste | 452 | 0 | 154 | 298 | -8.874217 | 125.727539 | 2021-03-27 05:25:04 | Timor-Leste | |||
1838122 | 1838122 | 2021-03-12 | Russia | Chechen Republic | 11438 | 114 | 11026 | 298 | 43.39761470000001 | 45.6985005 | 2021-03-13 05:25:15 | Chechen Republic, Russia | ||
3663548 | 3663548 | 2021-03-09 | India | Bihar | 262820 | 1547 | 260975 | 298 | 25.679658 | 85.60484 | 2021-03-10 05:24:35 | Bihar, India | ||
2359674 | 2359674 | 2021-03-08 | Russia | Kemerovo Oblast | 32109 | 566 | 31245 | 298 | 54.53357809999999 | 87.342861 | 2021-03-09 05:28:19 | Kemerovo Oblast, Russia | ||
1616859 | 1616859 | 2021-03-05 | US | Colorado | Huerfano | 8055 | 322 | 16 | 0 | 298 | 37.68473101 | -104.9612585 | 2021-03-06 04:23:41 | Huerfano, Colorado, US |
2210016 | 2210016 | 2021-03-04 | US | North Carolina | Tyrrell | 37177 | 304 | 6 | 0 | 298 | 35.87147226 | -76.17055253 | 2021-03-05 05:26:29 | Tyrrell, North Carolina, US |
2208270 | 2208270 | 2021-03-04 | US | Colorado | Huerfano | 8055 | 322 | 16 | 0 | 298 | 37.68473101 | -104.9612585 | 2021-03-05 05:26:29 | Huerfano, Colorado, US |
1093464 | 1093464 | 2021-03-03 | US | Virginia | Rappahannock | 51157 | 300 | 2 | 0 | 298 | 38.68295619 | -78.15826963 | 2021-03-04 05:24:24 | Rappahannock, Virginia, US |
3257536 | 3257536 | 2021-03-02 | US | Virginia | Rappahannock | 51157 | 300 | 2 | 0 | 298 | 38.68295619 | -78.15826963 | 2021-03-03 05:23:28 | Rappahannock, Virginia, US |
998646 | 998646 | 2021-03-01 | Russia | Kemerovo Oblast | 31723 | 558 | 30867 | 298 | 54.53357809999999 | 87.342861 | 2021-03-02 05:23:30 | Kemerovo Oblast, Russia | ||
2370849 | 2370849 | 2021-02-28 | US | Virginia | King and Queen | 51097 | 304 | 6 | 0 | 298 | 37.71044922 | -76.88689628 | 2021-03-01 05:23:01 | King and Queen, Virginia, US |
2369260 | 2369260 | 2021-02-28 | US | Minnesota | Traverse | 27155 | 303 | 5 | 0 | 298 | 45.77298854 | -96.47062949 | 2021-03-01 05:23:01 | Traverse, Minnesota, US |
3068736 | 3068736 | 2021-02-27 | US | Puerto Rico | Hormigueros | 72067 | 298 | 0 | 0 | 298 | 18.134532 | -67.113972 | 2021-02-28 05:22:20 | Hormigueros, Puerto Rico, US |
2186320 | 2186320 | 2021-02-26 | US | Puerto Rico | Hormigueros | 72067 | 298 | 0 | 0 | 298 | 18.134532 | -67.113972 | 2021-02-27 05:22:28 | Hormigueros, Puerto Rico, US |
1860742 | 1860742 | 2021-02-25 | US | Puerto Rico | Hormigueros | 72067 | 298 | 0 | 0 | 298 | 18.134532 | -67.113972 | 2021-02-26 05:22:40 | Hormigueros, Puerto Rico, US |
282920 | 282920 | 2021-02-24 | US | Puerto Rico | Hormigueros | 72067 | 298 | 0 | 0 | 298 | 18.134532 | -67.113972 | 2021-02-25 05:24:57 | Hormigueros, Puerto Rico, US |
1939188 | 1939188 | 2021-02-23 | US | Puerto Rico | Hormigueros | 72067 | 298 | 0 | 0 | 298 | 18.134532 | -67.113972 | 2021-02-24 05:29:16 | Hormigueros, Puerto Rico, US |
533443 | 533443 | 2021-02-22 | US | Puerto Rico | Hormigueros | 72067 | 298 | 0 | 0 | 298 | 18.134532 | -67.113972 | 2021-02-23 05:23:41 | Hormigueros, Puerto Rico, US |
472272 | 472272 | 2021-02-19 | US | Georgia | Schley | 13249 | 301 | 3 | 0 | 298 | 32.2654021 | -84.31258912 | 2021-02-20 05:22:51 | Schley, Georgia, US |
471360 | 471360 | 2021-02-19 | India | Himachal Pradesh | 58344 | 994 | 57052 | 298 | 31.927213 | 77.233081 | 2021-02-20 05:22:51 | Himachal Pradesh, India | ||
1155516 | 1155516 | 2021-02-18 | US | North Dakota | Hettinger | 38041 | 305 | 4 | 0 | 298 | 46.43375068 | -102.4632417 | 2021-02-19 05:24:16 | Hettinger, North Dakota, US |
1153981 | 1153981 | 2021-02-18 | US | Georgia | Schley | 13249 | 301 | 3 | 0 | 298 | 32.2654021 | -84.31258912 | 2021-02-19 05:24:16 | Schley, Georgia, US |
3051089 | 3051089 | 2021-02-16 | US | Idaho | Boise | 16015 | 300 | 2 | 0 | 298 | 43.98829931 | -115.7309284 | 2021-02-17 05:23:10 | Boise, Idaho, US |
1339188 | 1339188 | 2021-02-15 | US | Idaho | Boise | 16015 | 300 | 2 | 0 | 298 | 43.98829931 | -115.7309284 | 2021-02-16 05:24:38 | Boise, Idaho, US |
1339135 | 1339135 | 2021-02-15 | US | Georgia | Schley | 13249 | 300 | 2 | 0 | 298 | 32.2654021 | -84.31258912 | 2021-02-16 05:24:38 | Schley, Georgia, US |
2284339 | 2284339 | 2021-02-14 | US | Idaho | Boise | 16015 | 300 | 2 | 0 | 298 | 43.98829931 | -115.7309284 | 2021-02-15 05:24:49 | Boise, Idaho, US |
2284286 | 2284286 | 2021-02-14 | US | Georgia | Schley | 13249 | 300 | 2 | 0 | 298 | 32.2654021 | -84.31258912 | 2021-02-15 05:24:49 | Schley, Georgia, US |
2678739 | 2678739 | 2021-02-13 | US | Idaho | Boise | 16015 | 300 | 2 | 0 | 298 | 43.98829931 | -115.7309284 | 2021-02-14 05:23:43 | Boise, Idaho, US |
2678686 | 2678686 | 2021-02-13 | US | Georgia | Schley | 13249 | 300 | 2 | 0 | 298 | 32.2654021 | -84.31258912 | 2021-02-14 05:23:43 | Schley, Georgia, US |
2678470 | 2678470 | 2021-02-13 | US | Colorado | Saguache | 8109 | 315 | 4 | 0 | 298 | 38.08054629 | -106.282466 | 2021-02-14 05:23:43 | Saguache, Colorado, US |
2678046 | 2678046 | 2021-02-13 | Russia | Magadan Oblast | 8038 | 94 | 7646 | 298 | 62.48858785 | 153.9903764 | 2021-02-14 05:23:43 | Magadan Oblast, Russia | ||
3542222 | 3542222 | 2021-02-12 | US | Puerto Rico | Rincon | 72117 | 298 | 0 | 0 | 298 | 18.335443 | -67.23174 | 2021-02-13 05:22:12 | Rincon, Puerto Rico, US |
3541578 | 3541578 | 2021-02-12 | US | Nebraska | Valley | 31175 | 301 | 3 | 0 | 298 | 41.56730777 | -98.98197724 | 2021-02-13 05:22:12 | Valley, Nebraska, US |
3540319 | 3540319 | 2021-02-12 | US | Georgia | Schley | 13249 | 300 | 2 | 0 | 298 | 32.2654021 | -84.31258912 | 2021-02-13 05:22:12 | Schley, Georgia, US |
2640485 | 2640485 | 2021-02-11 | US | Puerto Rico | Rincon | 72117 | 298 | 0 | 0 | 298 | 18.335443 | -67.23174 | 2021-02-12 05:23:29 | Rincon, Puerto Rico, US |
3981340 | 3981340 | 2021-02-10 | US | Puerto Rico | Rincon | 72117 | 298 | 0 | 0 | 298 | 18.335443 | -67.23174 | 2021-02-11 05:23:55 | Rincon, Puerto Rico, US |
1530660 | 1530660 | 2021-02-09 | US | Puerto Rico | Rincon | 72117 | 298 | 0 | 0 | 298 | 18.335443 | -67.23174 | 2021-02-10 05:22:41 | Rincon, Puerto Rico, US |
340322 | 340322 | 2021-02-03 | Japan | Yamaguchi | 1272 | 24 | 950 | 298 | 34.201190000000004 | 131.573293 | 2021-02-04 05:22:26 | Yamaguchi, Japan | ||
1461382 | 1461382 | 2021-01-31 | US | Michigan | Federal Correctional Institution (FCI) | 303 | 5 | 0 | 298 | 47.63197653 | 0.0 | 2021-02-01 05:22:53 | Federal Correctional Institution (FCI), Michigan, US | |
1459482 | 1459482 | 2021-01-31 | Belize | 11908 | 301 | 11309 | 298 | 17.1899 | -88.4976 | 2021-02-01 05:22:53 | Belize | |||
2213290 | 2213290 | 2021-01-30 | US | Michigan | Federal Correctional Institution (FCI) | 303 | 5 | 0 | 298 | 47.63197653 | 0.0 | 2021-01-31 05:22:42 | Federal Correctional Institution (FCI), Michigan, US | |
2211390 | 2211390 | 2021-01-30 | Belize | 11908 | 301 | 11309 | 298 | 17.1899 | -88.4976 | 2021-01-31 05:22:42 | Belize | |||
1898777 | 1898777 | 2021-01-29 | US | Michigan | Federal Correctional Institution (FCI) | 303 | 5 | 0 | 298 | 47.63197653 | 0.0 | 2021-01-30 05:22:49 | Federal Correctional Institution (FCI), Michigan, US | |
3153940 | 3153940 | 2021-01-27 | Trinidad and Tobago | 7509 | 134 | 7077 | 298 | 10.6918 | -61.2225 | 2021-01-28 05:22:24 | Trinidad and Tobago | |||
12748 | 12748 | 2021-01-26 | US | Alaska | Aleutians West | 2016 | 298 | 0 | 0 | 298 | 52.3233 | -174.1596 | 2021-01-27 05:23:41 | Aleutians West, Alaska, US |
2571105 | 2571105 | 2021-01-25 | US | Washington | Lincoln | 53043 | 302 | 4 | 0 | 298 | 47.57705241 | -118.4194388 | 2021-01-26 05:22:02 | Lincoln, Washington, US |
2430309 | 2430309 | 2021-01-23 | US | Virginia | Surry | 51181 | 303 | 5 | 0 | 298 | 37.11781893 | -76.88450012 | 2021-01-24 05:22:35 | Surry, Virginia, US |
2429091 | 2429091 | 2021-01-23 | US | New Mexico | Hidalgo | 35023 | 307 | 9 | 0 | 298 | 31.91383467 | -108.7151824 | 2021-01-24 05:22:35 | Hidalgo, New Mexico, US |
2427331 | 2427331 | 2021-01-23 | US | Alaska | Sitka | 2220 | 298 | 0 | 0 | 298 | 57.24124555 | -135.3206587 | 2021-01-24 05:22:35 | Sitka, Alaska, US |
911484 | 911484 | 2021-01-19 | US | Virginia | Charles City | 51036 | 307 | 9 | 0 | 298 | 37.35358063 | -77.05634116 | 2021-01-20 05:21:54 | Charles City, Virginia, US |
237663 | 237663 | 2021-01-18 | US | Alaska | Nome | 2180 | 298 | 0 | 0 | 298 | 64.90320724 | -164.0353804 | 2021-01-19 05:22:15 | Nome, Alaska, US |
3506629 | 3506629 | 2021-01-17 | US | Vermont | Caledonia | 50005 | 302 | 4 | 0 | 298 | 44.46548598 | -72.10314651 | 2021-01-18 05:22:34 | Caledonia, Vermont, US |
3104717 | 3104717 | 2021-01-16 | US | Vermont | Lamoille | 50015 | 299 | 1 | 0 | 298 | 44.60353043 | -72.64356694 | 2021-01-17 05:22:17 | Lamoille, Vermont, US |
3104334 | 3104334 | 2021-01-16 | US | South Dakota | Stanley | 46117 | 300 | 2 | 0 | 298 | 44.41381872 | -100.7349153 | 2021-01-17 05:22:17 | Stanley, South Dakota, US |
3516309 | 3516309 | 2021-01-15 | US | Idaho | Adams | 16003 | 301 | 3 | 0 | 298 | 44.89333571 | -116.4545247 | 2021-01-16 05:22:40 | Adams, Idaho, US |
3880915 | 3880915 | 2021-01-14 | US | Kansas | Stafford | 20185 | 306 | 8 | 0 | 298 | 38.03100851 | -98.71762001 | 2021-01-15 05:22:24 | Stafford, Kansas, US |
3879538 | 3879538 | 2021-01-14 | India | Puducherry | 38567 | 640 | 37629 | 298 | 11.882658 | 78.86498 | 2021-01-15 17:22 | Puducherry, India | ||
3309542 | 3309542 | 2021-01-13 | US | Kansas | Stafford | 20185 | 306 | 8 | 0 | 298 | 38.03100851 | -98.71762001 | 2021-01-14 05:22:32 | Stafford, Kansas, US |
3308343 | 3308343 | 2021-01-13 | Pakistan | Balochistan | 18488 | 188 | 18002 | 298 | 28.328492 | 65.898403 | 2021-01-14 05:22:32 | Balochistan, Pakistan |
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]);