johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
746 rows where active = 261 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 654
- Japan 17
- Chile 8
- Mexico 6
- Russia 6
- China 5
- India 4
- Ukraine 3
- Cabo Verde 2
- Italy 2
- Malaysia 2
- Mauritania 2
- Netherlands 2
- Pakistan 2
- San Marino 2
- Slovenia 2
- Bahrain 1
- Bhutan 1
- Canada 1
- Colombia 1
- Cuba 1
- Cyprus 1
- Equatorial Guinea 1
- France 1
- Germany 1
- Guatemala 1
- Guinea 1
- Jordan 1
- Kenya 1
- Kuwait 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3137540 | 3137540 | 2021-07-23 | Italy | P.A. Bolzano | 73614 | 1183 | 72170 | 261 | 46.49933453 | 11.35662422 | 2021-07-24 00:21:36 | P.A. Bolzano, Italy | ||
299657 | 299657 | 2021-07-15 | Ukraine | Zaporizhia Oblast | 104845 | 2450 | 102134 | 261 | 47.8388 | 35.1396 | 2021-07-16 04:21:22 | Zaporizhia Oblast, Ukraine | ||
1444228 | 1444228 | 2021-07-07 | Ukraine | Zaporizhia Oblast | 104717 | 2446 | 102010 | 261 | 47.8388 | 35.1396 | 2021-07-08 04:21:26 | Zaporizhia Oblast, Ukraine | ||
1932476 | 1932476 | 2021-07-05 | Japan | Tochigi | 7134 | 82 | 6791 | 261 | 36.689912 | 139.819213 | 2021-07-06 04:21:32 | Tochigi, Japan | ||
1712549 | 1712549 | 2021-06-25 | Russia | Mari El Republic | 14127 | 281 | 13585 | 261 | 56.5767504 | 47.8817512 | 2021-06-26 04:21:43 | Mari El Republic, Russia | ||
522647 | 522647 | 2021-06-09 | Chile | Magallanes | 28176 | 420 | 27495 | 261 | -52.368 | -70.9863 | 2021-06-10 04:23:17 | Magallanes, Chile | ||
2586045 | 2586045 | 2021-06-05 | Laos | 1957 | 3 | 1693 | 261 | 19.85627 | 102.495496 | 2021-06-06 04:24:03 | Laos | |||
1448790 | 1448790 | 2021-06-03 | Russia | Kalmykia Republic | 20859 | 380 | 20218 | 261 | 46.2313018 | 45.3275745 | 2021-06-04 04:23:37 | Kalmykia Republic, Russia | ||
1708330 | 1708330 | 2021-06-02 | Japan | Kochi | 1520 | 20 | 1239 | 261 | 33.422519 | 133.367307 | 2021-06-03 04:23:32 | Kochi, Japan | ||
20094 | 20094 | 2021-05-28 | Bhutan | 1503 | 1 | 1241 | 261 | 27.5142 | 90.4336 | 2021-05-29 04:20:41 | Bhutan | |||
83121 | 83121 | 2021-05-25 | Japan | Nagasaki | 2836 | 62 | 2513 | 261 | 33.235712 | 129.608033 | 2021-05-26 04:20:35 | Nagasaki, Japan | ||
1913148 | 1913148 | 2021-05-20 | India | Andaman and Nicobar Islands | 6758 | 96 | 6401 | 261 | 11.225999 | 92.968178 | 2021-05-21 04:20:43 | Andaman and Nicobar Islands, India | ||
2939547 | 2939547 | 2021-05-16 | Russia | Mari El Republic | 13292 | 234 | 12797 | 261 | 56.5767504 | 47.8817512 | 2021-05-17 04:20:34 | Mari El Republic, Russia | ||
3057806 | 3057806 | 2021-05-13 | Uganda | 42578 | 346 | 41971 | 261 | 1.373333 | 32.290275 | 2021-05-14 04:20:41 | Uganda | |||
3675691 | 3675691 | 2021-05-04 | Japan | Tochigi | 5440 | 71 | 5108 | 261 | 36.689912 | 139.819213 | 2021-05-05 04:20:43 | Tochigi, Japan | ||
2450842 | 2450842 | 2021-05-02 | Malta | 30319 | 416 | 29642 | 261 | 35.9375 | 14.3754 | 2021-05-03 04:20:39 | Malta | |||
2450811 | 2450811 | 2021-05-02 | Japan | Tochigi | 5401 | 71 | 5069 | 261 | 36.689912 | 139.819213 | 2021-05-03 04:20:39 | Tochigi, Japan | ||
380232 | 380232 | 2021-04-30 | Japan | Tochigi | 5349 | 71 | 5017 | 261 | 36.689912 | 139.819213 | 2021-05-01 04:20:47 | Tochigi, Japan | ||
982995 | 982995 | 2021-04-17 | Japan | Yamagata | 1323 | 26 | 1036 | 261 | 38.448396 | 140.102154 | 2021-04-18 04:20:41 | Yamagata, Japan | ||
605727 | 605727 | 2021-04-09 | Japan | Shizuoka | 5926 | 120 | 5545 | 261 | 34.916975 | 138.40778400000002 | 2021-04-10 04:20:59 | Shizuoka, Japan | ||
2646029 | 2646029 | 2021-04-08 | Singapore | 60575 | 30 | 60284 | 261 | 1.2833 | 103.8333 | 2021-04-09 04:21:13 | Singapore | |||
2645799 | 2645799 | 2021-04-08 | Japan | Yamagata | 1129 | 17 | 851 | 261 | 38.448396 | 140.102154 | 2021-04-09 04:21:13 | Yamagata, Japan | ||
1290147 | 1290147 | 2021-03-29 | Pakistan | Balochistan | 19535 | 207 | 19067 | 261 | 28.328492 | 65.898403 | 2021-03-30 04:26:23 | Balochistan, Pakistan | ||
3369119 | 3369119 | 2021-03-21 | Chile | Magallanes | 22760 | 340 | 22159 | 261 | -52.368 | -70.9863 | 2021-03-22 05:25:43 | Magallanes, Chile | ||
3420991 | 3420991 | 2021-03-19 | Mauritania | 17570 | 446 | 16863 | 261 | 21.0079 | -10.9408 | 2021-03-20 05:25:46 | Mauritania | |||
3663874 | 3663874 | 2021-03-09 | Saint Lucia | 3902 | 46 | 3595 | 261 | 13.9094 | -60.9789 | 2021-03-10 05:24:35 | Saint Lucia | |||
2359277 | 2359277 | 2021-03-08 | China | Hong Kong | 11099 | 202 | 10636 | 261 | 22.3 | 114.2 | 2021-03-09 05:28:19 | Hong Kong, China | ||
1616053 | 1616053 | 2021-03-05 | China | Hong Kong | 11066 | 201 | 10604 | 261 | 22.3 | 114.2 | 2021-03-06 04:23:41 | Hong Kong, China | ||
2207464 | 2207464 | 2021-03-04 | China | Hong Kong | 11055 | 201 | 10593 | 261 | 22.3 | 114.2 | 2021-03-05 05:26:29 | Hong Kong, China | ||
2185136 | 2185136 | 2021-02-26 | US | Maine | Piscataquis | 23021 | 262 | 1 | 0 | 261 | 45.83839062 | -69.2860223 | 2021-02-27 05:22:28 | Piscataquis, Maine, US |
2183531 | 2183531 | 2021-02-26 | India | Himachal Pradesh | 58543 | 995 | 57287 | 261 | 31.927213 | 77.233081 | 2021-02-27 05:22:28 | Himachal Pradesh, India | ||
2183468 | 2183468 | 2021-02-26 | Equatorial Guinea | 5957 | 91 | 5605 | 261 | 1.6508 | 10.2679 | 2021-02-27 05:22:28 | Equatorial Guinea | |||
282229 | 282229 | 2021-02-24 | US | Nebraska | Cherry | 31031 | 267 | 6 | 0 | 261 | 42.54502621 | -101.1244332 | 2021-02-25 05:24:57 | Cherry, Nebraska, US |
1938497 | 1938497 | 2021-02-23 | US | Nebraska | Cherry | 31031 | 267 | 6 | 0 | 261 | 42.54502621 | -101.1244332 | 2021-02-24 05:29:16 | Cherry, Nebraska, US |
533590 | 533590 | 2021-02-22 | US | South Dakota | Miner | 46097 | 270 | 9 | 0 | 261 | 44.02197882 | -97.60992207 | 2021-02-23 05:23:41 | Miner, South Dakota, US |
184924 | 184924 | 2021-02-21 | US | South Dakota | Miner | 46097 | 270 | 9 | 0 | 261 | 44.02197882 | -97.60992207 | 2021-02-22 05:24:21 | Miner, South Dakota, US |
745198 | 745198 | 2021-02-20 | US | South Dakota | Miner | 46097 | 270 | 9 | 0 | 261 | 44.02197882 | -97.60992207 | 2021-02-21 05:24:33 | Miner, South Dakota, US |
474296 | 474296 | 2021-02-19 | US | South Dakota | Miner | 46097 | 270 | 9 | 0 | 261 | 44.02197882 | -97.60992207 | 2021-02-20 05:22:51 | Miner, South Dakota, US |
3603912 | 3603912 | 2021-02-17 | US | South Dakota | Jackson | 46071 | 275 | 14 | 0 | 261 | 43.69318385 | -101.6255063 | 2021-02-18 05:22:58 | Jackson, South Dakota, US |
3053047 | 3053047 | 2021-02-16 | US | South Dakota | Jackson | 46071 | 275 | 14 | 0 | 261 | 43.69318385 | -101.6255063 | 2021-02-17 05:23:10 | Jackson, South Dakota, US |
3050292 | 3050292 | 2021-02-16 | Netherlands | Aruba | 7461 | 69 | 7131 | 261 | 12.5211 | -69.9683 | 2021-02-17 05:23:10 | Aruba, Netherlands | ||
1341146 | 1341146 | 2021-02-15 | US | South Dakota | Jackson | 46071 | 275 | 14 | 0 | 261 | 43.69318385 | -101.6255063 | 2021-02-16 05:24:38 | Jackson, South Dakota, US |
1340996 | 1340996 | 2021-02-15 | US | Puerto Rico | Ceiba | 72037 | 261 | 0 | 0 | 261 | 18.251818 | -65.666416 | 2021-02-16 05:24:38 | Ceiba, Puerto Rico, US |
2286297 | 2286297 | 2021-02-14 | US | South Dakota | Jackson | 46071 | 275 | 14 | 0 | 261 | 43.69318385 | -101.6255063 | 2021-02-15 05:24:49 | Jackson, South Dakota, US |
2286147 | 2286147 | 2021-02-14 | US | Puerto Rico | Ceiba | 72037 | 261 | 0 | 0 | 261 | 18.251818 | -65.666416 | 2021-02-15 05:24:49 | Ceiba, Puerto Rico, US |
2680697 | 2680697 | 2021-02-13 | US | South Dakota | Jackson | 46071 | 275 | 14 | 0 | 261 | 43.69318385 | -101.6255063 | 2021-02-14 05:23:43 | Jackson, South Dakota, US |
2680547 | 2680547 | 2021-02-13 | US | Puerto Rico | Ceiba | 72037 | 261 | 0 | 0 | 261 | 18.251818 | -65.666416 | 2021-02-14 05:23:43 | Ceiba, Puerto Rico, US |
3542330 | 3542330 | 2021-02-12 | US | South Dakota | Jackson | 46071 | 275 | 14 | 0 | 261 | 43.69318385 | -101.6255063 | 2021-02-13 05:22:12 | Jackson, South Dakota, US |
2640593 | 2640593 | 2021-02-11 | US | South Dakota | Jackson | 46071 | 275 | 14 | 0 | 261 | 43.69318385 | -101.6255063 | 2021-02-12 05:23:29 | Jackson, South Dakota, US |
2640097 | 2640097 | 2021-02-11 | US | North Dakota | Adams | 38001 | 263 | 2 | 0 | 261 | 46.09686891 | -102.5285397 | 2021-02-12 05:23:29 | Adams, North Dakota, US |
2637831 | 2637831 | 2021-02-11 | Monaco | 1735 | 19 | 1455 | 261 | 43.7333 | 7.4167 | 2021-02-12 05:23:29 | Monaco | |||
3980952 | 3980952 | 2021-02-10 | US | North Dakota | Adams | 38001 | 262 | 2 | 0 | 261 | 46.09686891 | -102.5285397 | 2021-02-11 05:23:55 | Adams, North Dakota, US |
3978599 | 3978599 | 2021-02-10 | Japan | Mie | 2353 | 40 | 2052 | 261 | 34.508018 | 136.376013 | 2021-02-11 05:23:55 | Mie, Japan | ||
974846 | 974846 | 2021-02-06 | Guinea | 14665 | 84 | 14320 | 261 | 9.9456 | -9.6966 | 2021-02-07 05:23:00 | Guinea | |||
1590551 | 1590551 | 2021-02-05 | US | North Dakota | Adams | 38001 | 262 | 2 | 0 | 261 | 46.09686891 | -102.5285397 | 2021-02-06 05:23:55 | Adams, North Dakota, US |
1686451 | 1686451 | 2021-02-02 | US | Missouri | Schuyler | 29197 | 262 | 1 | 0 | 261 | 40.46921489 | -92.52311943 | 2021-02-03 05:22:52 | Schuyler, Missouri, US |
1678421 | 1678421 | 2021-02-01 | US | Missouri | Schuyler | 29197 | 262 | 1 | 0 | 261 | 40.46921489 | -92.52311943 | 2021-02-02 05:22:49 | Schuyler, Missouri, US |
1677498 | 1677498 | 2021-02-01 | US | Illinois | Pope | 17151 | 264 | 3 | 0 | 261 | 37.41391284 | -88.56152109 | 2021-02-02 05:22:49 | Pope, Illinois, US |
1677063 | 1677063 | 2021-02-01 | US | Colorado | Baca | 8009 | 277 | 4 | 0 | 261 | 37.31940883 | -102.5603223 | 2021-02-02 05:22:49 | Baca, Colorado, US |
1463148 | 1463148 | 2021-01-31 | US | Virginia | Rappahannock | 51157 | 263 | 2 | 0 | 261 | 38.68295619 | -78.15826963 | 2021-02-01 05:22:53 | Rappahannock, Virginia, US |
1461709 | 1461709 | 2021-01-31 | US | Missouri | Schuyler | 29197 | 262 | 1 | 0 | 261 | 40.46921489 | -92.52311943 | 2021-02-01 05:22:53 | Schuyler, Missouri, US |
1460786 | 1460786 | 2021-01-31 | US | Illinois | Pope | 17151 | 264 | 3 | 0 | 261 | 37.41391284 | -88.56152109 | 2021-02-01 05:22:53 | Pope, Illinois, US |
1460351 | 1460351 | 2021-01-31 | US | Colorado | Baca | 8009 | 274 | 4 | 0 | 261 | 37.31940883 | -102.5603223 | 2021-02-01 05:22:53 | Baca, Colorado, US |
2215056 | 2215056 | 2021-01-30 | US | Virginia | Rappahannock | 51157 | 263 | 2 | 0 | 261 | 38.68295619 | -78.15826963 | 2021-01-31 05:22:42 | Rappahannock, Virginia, US |
2212694 | 2212694 | 2021-01-30 | US | Illinois | Pope | 17151 | 264 | 3 | 0 | 261 | 37.41391284 | -88.56152109 | 2021-01-31 05:22:42 | Pope, Illinois, US |
2212259 | 2212259 | 2021-01-30 | US | Colorado | Baca | 8009 | 274 | 4 | 0 | 261 | 37.31940883 | -102.5603223 | 2021-01-31 05:22:42 | Baca, Colorado, US |
2212002 | 2212002 | 2021-01-30 | Trinidad and Tobago | 7542 | 134 | 7147 | 261 | 10.6918 | -61.2225 | 2021-01-31 05:22:42 | Trinidad and Tobago | |||
1898181 | 1898181 | 2021-01-29 | US | Illinois | Pope | 17151 | 264 | 3 | 0 | 261 | 37.41391284 | -88.56152109 | 2021-01-30 05:22:49 | Pope, Illinois, US |
1897746 | 1897746 | 2021-01-29 | US | Colorado | Baca | 8009 | 274 | 4 | 0 | 261 | 37.31940883 | -102.5603223 | 2021-01-30 05:22:49 | Baca, Colorado, US |
1897589 | 1897589 | 2021-01-29 | US | Alaska | Yukon-Koyukuk | 2290 | 265 | 4 | 0 | 261 | 65.50815459 | -151.3907387 | 2021-01-30 05:22:49 | Yukon-Koyukuk, Alaska, US |
2484586 | 2484586 | 2021-01-28 | US | Oregon | Lake | 41037 | 266 | 5 | 0 | 261 | 42.79246693 | -120.3850163 | 2021-01-29 05:22:23 | Lake, Oregon, US |
2482562 | 2482562 | 2021-01-28 | US | Colorado | Baca | 8009 | 274 | 4 | 0 | 261 | 37.31940883 | -102.5603223 | 2021-01-29 05:22:23 | Baca, Colorado, US |
2482405 | 2482405 | 2021-01-28 | US | Alaska | Yukon-Koyukuk | 2290 | 265 | 4 | 0 | 261 | 65.50815459 | -151.3907387 | 2021-01-29 05:22:23 | Yukon-Koyukuk, Alaska, US |
3154197 | 3154197 | 2021-01-27 | US | Colorado | Baca | 8009 | 274 | 4 | 0 | 261 | 37.31940883 | -102.5603223 | 2021-01-28 05:22:24 | Baca, Colorado, US |
2570740 | 2570740 | 2021-01-25 | US | Texas | Fisher | 48151 | 297 | 12 | 0 | 261 | 32.74281316 | -100.4019302 | 2021-01-26 05:22:02 | Fisher, Texas, US |
1762372 | 1762372 | 2021-01-24 | US | Texas | Fisher | 48151 | 297 | 12 | 0 | 261 | 32.74281316 | -100.4019302 | 2021-01-25 05:22:16 | Fisher, Texas, US |
2429979 | 2429979 | 2021-01-23 | US | Texas | Fisher | 48151 | 297 | 12 | 0 | 261 | 32.74281316 | -100.4019302 | 2021-01-24 05:22:35 | Fisher, Texas, US |
2469542 | 2469542 | 2021-01-22 | US | Puerto Rico | Hormigueros | 72067 | 261 | 0 | 0 | 261 | 18.134532 | -67.113972 | 2021-01-23 05:22:03 | Hormigueros, Puerto Rico, US |
438432 | 438432 | 2021-01-21 | US | Texas | Fisher | 48151 | 295 | 10 | 0 | 261 | 32.74281316 | -100.4019302 | 2021-01-22 05:22:10 | Fisher, Texas, US |
908195 | 908195 | 2021-01-19 | Japan | Kagoshima | 1401 | 15 | 1125 | 261 | 31.009484000000004 | 130.430665 | 2021-01-20 05:21:54 | Kagoshima, Japan | ||
908182 | 908182 | 2021-01-19 | Japan | Ehime | 849 | 15 | 573 | 261 | 33.624835 | 132.856842 | 2021-01-20 05:21:54 | Ehime, Japan | ||
3882586 | 3882586 | 2021-01-14 | US | Texas | Baylor | 48023 | 251 | 9 | 0 | 261 | 33.61640794 | -99.21352901 | 2021-01-15 05:22:24 | Baylor, Texas, US |
3311508 | 3311508 | 2021-01-13 | US | Virginia | Charles City | 51036 | 270 | 9 | 0 | 261 | 37.35358063 | -77.05634116 | 2021-01-14 05:22:32 | Charles City, Virginia, US |
3310972 | 3310972 | 2021-01-13 | US | Puerto Rico | Santa Isabel | 72133 | 261 | 0 | 0 | 261 | 17.994525 | -66.388913 | 2021-01-14 05:22:32 | Santa Isabel, Puerto Rico, US |
777752 | 777752 | 2021-01-12 | US | Virginia | Surry | 51181 | 266 | 5 | 0 | 261 | 37.11781893 | -76.88450012 | 2021-01-13 05:22:15 | Surry, Virginia, US |
777653 | 777653 | 2021-01-12 | US | Virginia | Charles City | 51036 | 270 | 9 | 0 | 261 | 37.35358063 | -77.05634116 | 2021-01-13 05:22:15 | Charles City, Virginia, US |
777117 | 777117 | 2021-01-12 | US | Puerto Rico | Santa Isabel | 72133 | 261 | 0 | 0 | 261 | 17.994525 | -66.388913 | 2021-01-13 05:22:15 | Santa Isabel, Puerto Rico, US |
774766 | 774766 | 2021-01-12 | US | Alaska | Ketchikan Gateway | 2130 | 262 | 1 | 0 | 261 | 55.57445008 | -130.975561 | 2021-01-13 05:22:15 | Ketchikan Gateway, Alaska, US |
774133 | 774133 | 2021-01-12 | Chile | Atacama | 8919 | 115 | 8543 | 261 | -27.5661 | -70.0503 | 2021-01-13 05:22:15 | Atacama, Chile | ||
2627228 | 2627228 | 2021-01-10 | US | Kentucky | Ballard | 21007 | 264 | 3 | 0 | 261 | 37.05842757 | -88.99427697 | 2021-01-11 05:21:50 | Ballard, Kentucky, US |
154441 | 154441 | 2021-01-08 | US | Arkansas | Calhoun | 5013 | 262 | 1 | 0 | 261 | 33.55598792 | -92.49974403 | 2021-01-09 05:22:18 | Calhoun, Arkansas, US |
2541191 | 2541191 | 2021-01-07 | Chile | Arica y Parinacota | 11071 | 228 | 10582 | 261 | -18.594 | -69.4785 | 2021-01-08 05:22:42 | Arica y Parinacota, Chile | ||
2868155 | 2868155 | 2021-01-06 | US | Washington | Lincoln | 53043 | 266 | 5 | 0 | 261 | 47.57705241 | -118.4194388 | 2021-01-07 05:22:03 | Lincoln, Washington, US |
3037573 | 3037573 | 2021-01-05 | US | Vermont | Caledonia | 50005 | 264 | 3 | 0 | 261 | 44.46548598 | -72.10314651 | 2021-01-06 05:22:16 | Caledonia, Vermont, US |
1064911 | 1064911 | 2021-01-04 | US | Texas | Donley | 48129 | 360 | 7 | 0 | 261 | 34.96517499 | -100.8140093 | 2021-01-05 05:21:49 | Donley, Texas, US |
3233514 | 3233514 | 2021-01-03 | US | Texas | Donley | 48129 | 360 | 7 | 0 | 261 | 34.96517499 | -100.8140093 | 2021-01-04 05:22:02 | Donley, Texas, US |
2230583 | 2230583 | 2021-01-02 | US | Texas | Donley | 48129 | 360 | 7 | 0 | 261 | 34.96517499 | -100.8140093 | 2021-01-03 05:22:52 | Donley, Texas, US |
2228069 | 2228069 | 2021-01-02 | US | California | Mariposa | 6043 | 265 | 4 | 0 | 261 | 37.57978556 | -119.9073334 | 2021-01-03 05:22:52 | Mariposa, California, US |
2227556 | 2227556 | 2021-01-02 | Japan | Shiga | 1222 | 12 | 949 | 261 | 35.21582700000001 | 136.138064 | 2021-01-03 05:22:52 | Shiga, Japan | ||
1139947 | 1139947 | 2021-01-01 | US | Texas | Donley | 48129 | 360 | 7 | 0 | 261 | 34.96517499 | -100.8140093 | 2021-01-02 05:22:33 | Donley, Texas, 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]);