johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
671 rows where active = 301 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 577
- Japan 13
- Ukraine 9
- Mexico 8
- Russia 8
- Chile 6
- Colombia 6
- India 4
- Costa Rica 3
- Malaysia 3
- Australia 2
- Bhutan 2
- Canada 2
- Germany 2
- Ghana 2
- Senegal 2
- Andorra 1
- Bolivia 1
- China 1
- Cote d'Ivoire 1
- Eritrea 1
- Eswatini 1
- France 1
- Gambia 1
- Italy 1
- Kosovo 1
- Latvia 1
- Liechtenstein 1
- Luxembourg 1
- Mauritania 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
332102 | 332102 | 2021-08-04 | Russia | Chukotka Autonomous Okrug | 1194 | 9 | 884 | 301 | 66.0006475 | 169.4900869 | 2021-08-05 04:21:51 | Chukotka Autonomous Okrug, Russia | ||
3385443 | 3385443 | 2021-07-29 | Kosovo | 108203 | 2269 | 105633 | 301 | 42.602636 | 20.902977 | 2021-07-30 04:21:34 | Kosovo | |||
3335158 | 3335158 | 2021-07-21 | Ukraine | Kherson Oblast | 36095 | 1157 | 34637 | 301 | 46.6354 | 32.6169 | 2021-07-22 04:21:19 | Kherson Oblast, Ukraine | ||
3632236 | 3632236 | 2021-07-14 | Singapore | 62804 | 36 | 62467 | 301 | 1.2833 | 103.8333 | 2021-07-15 04:21:48 | Singapore | |||
578737 | 578737 | 2021-07-13 | Gambia | 6414 | 185 | 5928 | 301 | 13.4432 | -15.3101 | 2021-07-14 04:21:35 | Gambia | |||
3740876 | 3740876 | 2021-07-12 | Chile | Tarapaca | 39515 | 757 | 38457 | 301 | -19.9232 | -69.5132 | 2021-07-13 04:21:18 | Tarapaca, Chile | ||
3659516 | 3659516 | 2021-07-11 | Germany | Thuringen | 128839 | 4350 | 124200 | 301 | 51.011 | 10.8453 | 2021-07-12 04:21:34 | Thuringen, Germany | ||
3659504 | 3659504 | 2021-07-11 | Germany | Brandenburg | 108776 | 3811 | 104700 | 301 | 52.4125 | 12.5316 | 2021-07-12 04:21:34 | Brandenburg, Germany | ||
3659318 | 3659318 | 2021-07-11 | Bhutan | 2275 | 1 | 1973 | 301 | 27.5142 | 90.4336 | 2021-07-12 04:21:34 | Bhutan | |||
1444220 | 1444220 | 2021-07-07 | Ukraine | Poltava Oblast | 77954 | 1862 | 75791 | 301 | 49.5883 | 34.5514 | 2021-07-08 04:21:26 | Poltava Oblast, Ukraine | ||
1932475 | 1932475 | 2021-07-05 | Japan | Shizuoka | 9414 | 152 | 8961 | 301 | 34.916975 | 138.40778400000002 | 2021-07-06 04:21:32 | Shizuoka, Japan | ||
1499248 | 1499248 | 2021-07-03 | Ukraine | Zhytomyr Oblast | 88470 | 1790 | 86379 | 301 | 50.2547 | 28.6587 | 2021-07-04 04:21:38 | Zhytomyr Oblast, Ukraine | ||
2071641 | 2071641 | 2021-07-02 | Bhutan | 2122 | 1 | 1820 | 301 | 27.5142 | 90.4336 | 2021-07-03 04:21:37 | Bhutan | |||
1893340 | 1893340 | 2021-06-30 | Russia | Ingushetia Republic | 16179 | 195 | 15683 | 301 | 43.11542075 | 45.01713552 | 2021-07-01 04:21:19 | Ingushetia Republic, Russia | ||
2423158 | 2423158 | 2021-06-23 | Saint Kitts and Nevis | 396 | 3 | 92 | 301 | 17.357822 | -62.782998 | 2021-06-24 04:21:55 | Saint Kitts and Nevis | |||
3030303 | 3030303 | 2021-06-16 | Japan | Ibaraki | 10185 | 160 | 9724 | 301 | 36.303588 | 140.319591 | 2021-06-17 04:22:36 | Ibaraki, Japan | ||
3970823 | 3970823 | 2021-06-11 | Senegal | 41900 | 1150 | 40449 | 301 | 14.4974 | -14.4524 | 2021-06-12 04:22:22 | Senegal | |||
522697 | 522697 | 2021-06-09 | Colombia | Caqueta | 18697 | 698 | 17698 | 301 | 0.8699 | -73.8419 | 2021-06-10 04:23:17 | Caqueta, Colombia | ||
1806615 | 1806615 | 2021-05-27 | Cote d'Ivoire | 47146 | 301 | 46544 | 301 | 7.54 | -5.5471 | 2021-05-28 04:20:36 | Cote d'Ivoire | |||
2939516 | 2939516 | 2021-05-16 | Russia | Buryatia Republic | 37592 | 874 | 36417 | 301 | 52.7182426 | 109.492143 | 2021-05-17 04:20:34 | Buryatia Republic, Russia | ||
1425105 | 1425105 | 2021-05-09 | Japan | Aomori | 1781 | 26 | 1454 | 301 | 40.781541 | 140.828896 | 2021-05-10 04:20:38 | Aomori, Japan | ||
1424793 | 1424793 | 2021-05-09 | Andorra | 13423 | 127 | 12995 | 301 | 42.5063 | 1.5218 | 2021-05-10 04:20:38 | Andorra | |||
891784 | 891784 | 2021-04-26 | Vietnam | 2852 | 35 | 2516 | 301 | 14.058324 | 108.277199 | 2021-04-27 04:20:52 | Vietnam | |||
1409081 | 1409081 | 2021-04-23 | Japan | Shizuoka | 6267 | 121 | 5845 | 301 | 34.916975 | 138.40778400000002 | 2021-04-24 04:20:38 | Shizuoka, Japan | ||
2410853 | 2410853 | 2021-04-19 | Japan | Gunma | 5494 | 102 | 5091 | 301 | 36.504479 | 138.985605 | 2021-04-20 04:20:41 | Gunma, Japan | ||
2548882 | 2548882 | 2021-04-15 | Japan | Fukushima | 2880 | 118 | 2461 | 301 | 37.378867 | 140.223295 | 2021-04-16 04:20:46 | Fukushima, Japan | ||
2983287 | 2983287 | 2021-04-10 | Japan | Okayama | 2911 | 35 | 2575 | 301 | 34.89246 | 133.826252 | 2021-04-11 04:20:56 | Okayama, Japan | ||
2983098 | 2983098 | 2021-04-10 | Colombia | Casanare | 13388 | 313 | 12774 | 301 | 5.7589 | -71.5724 | 2021-04-11 04:20:56 | Casanare, Colombia | ||
2247637 | 2247637 | 2021-04-07 | Russia | Sakhalin Oblast | 22113 | 40 | 21772 | 301 | 49.7219665 | 143.448533 | 2021-04-08 04:21:13 | Sakhalin Oblast, Russia | ||
3085542 | 3085542 | 2021-04-05 | Russia | Sakhalin Oblast | 22084 | 39 | 21744 | 301 | 49.7219665 | 143.448533 | 2021-04-06 04:20:32 | Sakhalin Oblast, Russia | ||
388261 | 388261 | 2021-04-04 | Japan | Shizuoka | 5831 | 118 | 5412 | 301 | 34.916975 | 138.40778400000002 | 2021-04-05 04:20:35 | Shizuoka, Japan | ||
241527 | 241527 | 2021-04-02 | Senegal | 38889 | 1056 | 37532 | 301 | 14.4974 | -14.4524 | 2021-04-03 04:20:44 | Senegal | |||
1880993 | 1880993 | 2021-03-26 | Japan | Fukushima | 2421 | 110 | 2010 | 301 | 37.378867 | 140.223295 | 2021-03-27 05:25:04 | Fukushima, Japan | ||
3369139 | 3369139 | 2021-03-21 | China | Hong Kong | 11379 | 203 | 10875 | 301 | 22.3 | 114.2 | 2021-03-22 05:25:43 | Hong Kong, China | ||
3620967 | 3620967 | 2021-03-17 | Eritrea | 3078 | 7 | 2770 | 301 | 15.1794 | 39.7823 | 2021-03-18 05:26:22 | Eritrea | |||
706073 | 706073 | 2021-03-16 | US | Alaska | Chugach | 2063 | 304 | 3 | 0 | 301 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
702614 | 702614 | 2021-03-16 | Russia | Khakassia Republic | 21587 | 483 | 20803 | 301 | 53.72258845 | 91.44293627 | 2021-03-17 05:25:07 | Khakassia Republic, Russia | ||
2055673 | 2055673 | 2021-03-15 | Chile | Magallanes | 22567 | 335 | 21931 | 301 | -52.368 | -70.9863 | 2021-03-16 05:25:13 | Magallanes, Chile | ||
2211043 | 2211043 | 2021-03-04 | US | Virginia | Rappahannock | 51157 | 303 | 2 | 0 | 301 | 38.68295619 | -78.15826963 | 2021-03-05 05:26:29 | Rappahannock, Virginia, US |
1001176 | 1001176 | 2021-03-01 | US | Puerto Rico | Hormigueros | 72067 | 301 | 0 | 0 | 301 | 18.134532 | -67.113972 | 2021-03-02 05:23:30 | Hormigueros, Puerto Rico, US |
3069675 | 3069675 | 2021-02-27 | Malaysia | Melaka | 5960 | 19 | 5640 | 301 | 2.1896 | 102.2501 | 2021-02-28 05:22:20 | Melaka, Malaysia | ||
531619 | 531619 | 2021-02-22 | US | Idaho | Boise | 16015 | 303 | 2 | 0 | 301 | 43.98829931 | -115.7309284 | 2021-02-23 05:23:41 | Boise, Idaho, US |
184046 | 184046 | 2021-02-21 | US | Montana | Musselshell | 30065 | 309 | 8 | 0 | 301 | 46.49684637 | -108.39498 | 2021-02-22 05:24:21 | Musselshell, Montana, US |
744320 | 744320 | 2021-02-20 | US | Montana | Musselshell | 30065 | 309 | 8 | 0 | 301 | 46.49684637 | -108.39498 | 2021-02-21 05:24:33 | Musselshell, Montana, US |
473807 | 473807 | 2021-02-19 | US | North Dakota | Hettinger | 38041 | 306 | 4 | 0 | 301 | 46.43375068 | -102.4632417 | 2021-02-20 05:22:51 | Hettinger, North Dakota, US |
1153069 | 1153069 | 2021-02-18 | India | Himachal Pradesh | 58312 | 994 | 57017 | 301 | 31.927213 | 77.233081 | 2021-02-19 05:24:16 | Himachal Pradesh, India | ||
3052295 | 3052295 | 2021-02-16 | US | Nebraska | Valley | 31175 | 304 | 3 | 0 | 301 | 41.56730777 | -98.98197724 | 2021-02-17 05:23:10 | Valley, Nebraska, US |
1340397 | 1340397 | 2021-02-15 | US | Nebraska | Webster | 31181 | 305 | 4 | 0 | 301 | 40.17642643 | -98.50019851 | 2021-02-16 05:24:38 | Webster, Nebraska, US |
1340394 | 1340394 | 2021-02-15 | US | Nebraska | Valley | 31175 | 304 | 3 | 0 | 301 | 41.56730777 | -98.98197724 | 2021-02-16 05:24:38 | Valley, Nebraska, US |
1338347 | 1338347 | 2021-02-15 | Mauritania | 16996 | 430 | 16265 | 301 | 21.0079 | -10.9408 | 2021-02-16 05:24:38 | Mauritania | |||
1338045 | 1338045 | 2021-02-15 | Canada | Newfoundland and Labrador | 704 | 4 | 399 | 301 | 53.1355 | -57.6604 | 2021-02-16 05:24:38 | Newfoundland and Labrador, Canada | ||
2285548 | 2285548 | 2021-02-14 | US | Nebraska | Webster | 31181 | 305 | 4 | 0 | 301 | 40.17642643 | -98.50019851 | 2021-02-15 05:24:49 | Webster, Nebraska, US |
2285545 | 2285545 | 2021-02-14 | US | Nebraska | Valley | 31175 | 304 | 3 | 0 | 301 | 41.56730777 | -98.98197724 | 2021-02-15 05:24:49 | Valley, Nebraska, US |
2283435 | 2283435 | 2021-02-14 | Japan | Gunma | 4265 | 79 | 3885 | 301 | 36.504479 | 138.985605 | 2021-02-15 05:24:49 | Gunma, Japan | ||
2679948 | 2679948 | 2021-02-13 | US | Nebraska | Webster | 31181 | 305 | 4 | 0 | 301 | 40.17642643 | -98.50019851 | 2021-02-14 05:23:43 | Webster, Nebraska, US |
2679945 | 2679945 | 2021-02-13 | US | Nebraska | Valley | 31175 | 304 | 3 | 0 | 301 | 41.56730777 | -98.98197724 | 2021-02-14 05:23:43 | Valley, Nebraska, US |
3980699 | 3980699 | 2021-02-10 | US | Nebraska | Webster | 31181 | 305 | 4 | 0 | 301 | 40.17642643 | -98.50019851 | 2021-02-11 05:23:55 | Webster, Nebraska, US |
1530019 | 1530019 | 2021-02-09 | US | Nebraska | Webster | 31181 | 305 | 4 | 0 | 301 | 40.17642643 | -98.50019851 | 2021-02-10 05:22:41 | Webster, Nebraska, US |
1528316 | 1528316 | 2021-02-09 | US | Alaska | Ketchikan Gateway | 2130 | 303 | 2 | 0 | 301 | 55.57445008 | -130.975561 | 2021-02-10 05:22:41 | Ketchikan Gateway, Alaska, US |
615810 | 615810 | 2021-02-08 | US | Nebraska | Webster | 31181 | 305 | 4 | 0 | 301 | 40.17642643 | -98.50019851 | 2021-02-09 05:23:30 | Webster, Nebraska, US |
614107 | 614107 | 2021-02-08 | US | Alaska | Ketchikan Gateway | 2130 | 303 | 2 | 0 | 301 | 55.57445008 | -130.975561 | 2021-02-09 05:23:30 | Ketchikan Gateway, Alaska, US |
613710 | 613710 | 2021-02-08 | Japan | Mie | 2336 | 36 | 1999 | 301 | 34.508018 | 136.376013 | 2021-02-09 05:23:30 | Mie, Japan | ||
1674579 | 1674579 | 2021-02-07 | US | Nebraska | Webster | 31181 | 305 | 4 | 0 | 301 | 40.17642643 | -98.50019851 | 2021-02-08 05:22:39 | Webster, Nebraska, US |
977534 | 977534 | 2021-02-06 | US | Oregon | Lake | 41037 | 307 | 6 | 0 | 301 | 42.79246693 | -120.3850163 | 2021-02-07 05:23:00 | Lake, Oregon, US |
2482398 | 2482398 | 2021-01-28 | US | Alaska | Sitka | 2220 | 301 | 0 | 0 | 301 | 57.24124555 | -135.3206587 | 2021-01-29 05:22:23 | Sitka, Alaska, US |
2467790 | 2467790 | 2021-01-22 | US | Illinois | Hardin | 17069 | 309 | 8 | 0 | 301 | 37.51810645 | -88.26873022 | 2021-01-23 05:22:03 | Hardin, Illinois, US |
436263 | 436263 | 2021-01-21 | US | Idaho | Adams | 16003 | 304 | 3 | 0 | 301 | 44.89333571 | -116.4545247 | 2021-01-22 05:22:10 | Adams, Idaho, US |
435815 | 435815 | 2021-01-21 | US | Arkansas | Calhoun | 5013 | 303 | 2 | 0 | 301 | 33.55598792 | -92.49974403 | 2021-01-22 05:22:10 | Calhoun, Arkansas, US |
1094994 | 1094994 | 2021-01-20 | US | Idaho | Adams | 16003 | 304 | 3 | 0 | 301 | 44.89333571 | -116.4545247 | 2021-01-21 05:22:01 | Adams, Idaho, US |
240134 | 240134 | 2021-01-18 | US | South Dakota | Stanley | 46117 | 303 | 2 | 0 | 301 | 44.41381872 | -100.7349153 | 2021-01-19 05:22:15 | Stanley, South Dakota, US |
3506634 | 3506634 | 2021-01-17 | US | Vermont | Lamoille | 50015 | 302 | 1 | 0 | 301 | 44.60353043 | -72.64356694 | 2021-01-18 05:22:34 | Lamoille, Vermont, US |
3506251 | 3506251 | 2021-01-17 | US | South Dakota | Stanley | 46117 | 303 | 2 | 0 | 301 | 44.41381872 | -100.7349153 | 2021-01-18 05:22:34 | Stanley, South Dakota, US |
3504698 | 3504698 | 2021-01-17 | US | Kansas | Stafford | 20185 | 309 | 8 | 0 | 301 | 38.03100851 | -98.71762001 | 2021-01-18 05:22:34 | Stafford, Kansas, US |
3102781 | 3102781 | 2021-01-16 | US | Kansas | Stafford | 20185 | 309 | 8 | 0 | 301 | 38.03100851 | -98.71762001 | 2021-01-17 05:22:17 | Stafford, Kansas, US |
3516743 | 3516743 | 2021-01-15 | US | Kansas | Stafford | 20185 | 309 | 8 | 0 | 301 | 38.03100851 | -98.71762001 | 2021-01-16 05:22:40 | Stafford, Kansas, US |
3516039 | 3516039 | 2021-01-15 | US | Colorado | Phillips | 8095 | 334 | 13 | 0 | 301 | 40.59414277 | -102.3577703 | 2021-01-16 05:22:40 | Phillips, Colorado, US |
3881708 | 3881708 | 2021-01-14 | US | Nevada | Lincoln | 32017 | 302 | 1 | 0 | 301 | 37.64268459 | -114.8790388 | 2021-01-15 05:22:24 | Lincoln, Nevada, US |
3881240 | 3881240 | 2021-01-14 | US | Michigan | Ontonagon | 26131 | 317 | 16 | 0 | 301 | 46.665226200000006 | -89.31390481 | 2021-01-15 05:22:24 | Ontonagon, Michigan, US |
3311300 | 3311300 | 2021-01-13 | US | Texas | Hardeman | 48197 | 302 | 9 | 0 | 301 | 34.28944521 | -99.74632408 | 2021-01-14 05:22:32 | Hardeman, Texas, US |
3311217 | 3311217 | 2021-01-13 | US | Texas | Blanco | 48031 | 382 | 9 | 0 | 301 | 30.26640707 | -98.3999852 | 2021-01-14 05:22:32 | Blanco, Texas, US |
3310335 | 3310335 | 2021-01-13 | US | Nevada | Lincoln | 32017 | 302 | 1 | 0 | 301 | 37.64268459 | -114.8790388 | 2021-01-14 05:22:32 | Lincoln, Nevada, US |
777445 | 777445 | 2021-01-12 | US | Texas | Hardeman | 48197 | 302 | 9 | 0 | 301 | 34.28944521 | -99.74632408 | 2021-01-13 05:22:15 | Hardeman, Texas, US |
776480 | 776480 | 2021-01-12 | US | Nevada | Lincoln | 32017 | 302 | 1 | 0 | 301 | 37.64268459 | -114.8790388 | 2021-01-13 05:22:15 | Lincoln, Nevada, US |
774928 | 774928 | 2021-01-12 | US | California | Trinity | 6105 | 320 | 3 | 0 | 301 | 40.64917670000001 | -123.114713 | 2021-01-13 05:22:15 | Trinity, California, US |
774488 | 774488 | 2021-01-12 | Pakistan | Balochistan | 18467 | 188 | 17978 | 301 | 28.328492 | 65.898403 | 2021-01-13 05:22:15 | Balochistan, Pakistan | ||
192201 | 192201 | 2021-01-11 | US | Nevada | Lincoln | 32017 | 302 | 1 | 0 | 301 | 37.64268459 | -114.8790388 | 2021-01-12 05:22:15 | Lincoln, Nevada, US |
2629027 | 2629027 | 2021-01-10 | US | Texas | Mason | 48319 | 267 | 3 | 0 | 301 | 30.71780434 | -99.22629416 | 2021-01-11 05:21:50 | Mason, Texas, US |
3903426 | 3903426 | 2021-01-09 | US | West Virginia | Doddridge | 54017 | 304 | 3 | 0 | 301 | 39.27057157 | -80.70671527 | 2021-01-10 05:22:12 | Doddridge, West Virginia, US |
155623 | 155623 | 2021-01-08 | US | Michigan | Lake | 26085 | 311 | 10 | 0 | 301 | 43.99050893 | -85.802173 | 2021-01-09 05:22:18 | Lake, Michigan, US |
153881 | 153881 | 2021-01-08 | France | Reunion | 9173 | 42 | 8830 | 301 | -21.1151 | 55.5364 | 2021-01-09 05:22:18 | Reunion, France | ||
2543047 | 2543047 | 2021-01-07 | US | Michigan | Lake | 26085 | 311 | 10 | 0 | 301 | 43.99050893 | -85.802173 | 2021-01-08 05:22:42 | Lake, Michigan, US |
2868038 | 2868038 | 2021-01-06 | US | Virginia | Fairfax City | 51600 | 311 | 10 | 0 | 301 | 38.85157547 | -77.29779640000002 | 2021-01-07 05:22:03 | Fairfax City, Virginia, US |
2866809 | 2866809 | 2021-01-06 | US | Nebraska | Nuckolls | 31129 | 302 | 1 | 0 | 301 | 40.17637905 | -98.04743961 | 2021-01-07 05:22:03 | Nuckolls, Nebraska, US |
3037625 | 3037625 | 2021-01-05 | US | Virginia | Fairfax City | 51600 | 311 | 10 | 0 | 301 | 38.85157547 | -77.29779640000002 | 2021-01-06 05:22:16 | Fairfax City, Virginia, US |
3036492 | 3036492 | 2021-01-05 | US | New Mexico | Los Alamos | 35028 | 301 | 0 | 0 | 301 | 35.86631386 | -106.3134985 | 2021-01-06 05:22:16 | Los Alamos, New Mexico, US |
3036396 | 3036396 | 2021-01-05 | US | Nebraska | Nuckolls | 31129 | 302 | 1 | 0 | 301 | 40.17637905 | -98.04743961 | 2021-01-06 05:22:16 | Nuckolls, Nebraska, US |
3035746 | 3035746 | 2021-01-05 | US | Kentucky | Nicholas | 21181 | 304 | 3 | 0 | 301 | 38.33342292 | -84.01889177 | 2021-01-06 05:22:16 | Nicholas, Kentucky, US |
1065170 | 1065170 | 2021-01-04 | US | Virginia | Fairfax City | 51600 | 311 | 10 | 0 | 301 | 38.85157547 | -77.29779640000002 | 2021-01-05 05:21:49 | Fairfax City, Virginia, US |
1064706 | 1064706 | 2021-01-04 | US | South Dakota | Faulk | 46049 | 313 | 12 | 0 | 301 | 45.07082625 | -99.14535601 | 2021-01-05 05:21:49 | Faulk, South Dakota, US |
3233309 | 3233309 | 2021-01-03 | US | South Dakota | Faulk | 46049 | 313 | 12 | 0 | 301 | 45.07082625 | -99.14535601 | 2021-01-04 05:22:02 | Faulk, South Dakota, 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]);