johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
702 rows where active = 296 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 608
- Japan 11
- Malaysia 9
- India 8
- Colombia 7
- Mexico 5
- Russia 5
- Chile 4
- Ukraine 4
- Germany 3
- Italy 3
- Latvia 3
- Canada 2
- Lithuania 2
- Pakistan 2
- Togo 2
- Uruguay 2
- Albania 1
- Andorra 1
- Bahamas 1
- Belize 1
- Cabo Verde 1
- China 1
- Congo (Kinshasa) 1
- Denmark 1
- France 1
- Guinea-Bissau 1
- Iraq 1
- Libya 1
- Liechtenstein 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385170 | 3385170 | 2021-07-29 | Chile | Antofagasta | 59591 | 1191 | 58104 | 296 | -23.6509 | -70.3975 | 2021-07-30 04:21:34 | Antofagasta, Chile | ||
408078 | 408078 | 2021-07-28 | Chile | Atacama | 26654 | 315 | 26043 | 296 | -27.5661 | -70.0503 | 2021-07-29 04:21:33 | Atacama, Chile | ||
3137590 | 3137590 | 2021-07-23 | Japan | Tochigi | 7555 | 84 | 7175 | 296 | 36.689912 | 139.819213 | 2021-07-24 00:21:36 | Tochigi, Japan | ||
3137480 | 3137480 | 2021-07-23 | Guinea-Bissau | 4148 | 74 | 3778 | 296 | 11.8037 | -15.1804 | 2021-07-24 00:21:36 | Guinea-Bissau | |||
3744718 | 3744718 | 2021-07-12 | Ukraine | Poltava Oblast | 78013 | 1866 | 75851 | 296 | 49.5883 | 34.5514 | 2021-07-13 04:21:18 | Poltava Oblast, Ukraine | ||
3740803 | 3740803 | 2021-07-12 | Belize | 13561 | 331 | 12934 | 296 | 17.1899 | -88.4976 | 2021-07-13 04:21:18 | Belize | |||
625788 | 625788 | 2021-07-10 | Germany | Brandenburg | 108776 | 3811 | 104700 | 296 | 52.4125 | 12.5316 | 2021-07-11 04:21:43 | Brandenburg, Germany | ||
833234 | 833234 | 2021-07-09 | Ukraine | Poltava Oblast | 77991 | 1864 | 75831 | 296 | 49.5883 | 34.5514 | 2021-07-10 04:21:25 | Poltava Oblast, Ukraine | ||
778399 | 778399 | 2021-07-08 | Japan | Shizuoka | 9505 | 152 | 9057 | 296 | 34.916975 | 138.40778400000002 | 2021-07-09 04:21:21 | Shizuoka, Japan | ||
1893365 | 1893365 | 2021-06-30 | Russia | Mari El Republic | 14310 | 291 | 13723 | 296 | 56.5767504 | 47.8817512 | 2021-07-01 04:21:19 | Mari El Republic, Russia | ||
1893051 | 1893051 | 2021-06-30 | Germany | Brandenburg | 108684 | 3803 | 104600 | 296 | 52.4125 | 12.5316 | 2021-07-01 04:21:19 | Brandenburg, Germany | ||
2589956 | 2589956 | 2021-06-27 | India | Lakshadweep | 9681 | 48 | 9337 | 296 | 13.6999972 | 72.18333259999999 | 2021-06-28 04:21:29 | Lakshadweep, India | ||
3962144 | 3962144 | 2021-06-26 | Ukraine | Rivne Oblast | 79447 | 1205 | 77946 | 296 | 50.6199 | 26.2516 | 2021-06-27 04:21:39 | Rivne Oblast, Ukraine | ||
563079 | 563079 | 2021-06-22 | Montenegro | 100104 | 1606 | 98202 | 296 | 42.708678000000006 | 19.37439 | 2021-06-23 04:21:46 | Montenegro | |||
3970405 | 3970405 | 2021-06-11 | Colombia | Putumayo | 12521 | 528 | 11697 | 296 | 0.436 | -75.5277 | 2021-06-12 04:22:22 | Putumayo, Colombia | ||
2717245 | 2717245 | 2021-06-10 | Senegal | 41850 | 1150 | 40404 | 296 | 14.4974 | -14.4524 | 2021-06-11 04:23:20 | Senegal | |||
2585676 | 2585676 | 2021-06-05 | Albania | 132374 | 2451 | 129627 | 296 | 41.1533 | 20.1683 | 2021-06-06 04:24:03 | Albania | |||
1806767 | 1806767 | 2021-05-27 | Japan | Mie | 4802 | 103 | 4403 | 296 | 34.508018 | 136.376013 | 2021-05-28 04:20:36 | Mie, Japan | ||
1552018 | 1552018 | 2021-05-08 | Japan | Yamaguchi | 2021 | 46 | 1679 | 296 | 34.201190000000004 | 131.573293 | 2021-05-09 04:20:35 | Yamaguchi, Japan | ||
2410801 | 2410801 | 2021-04-19 | India | Manipur | 29775 | 377 | 29102 | 296 | 24.738975 | 93.882541 | 2021-04-20 04:20:41 | Manipur, India | ||
605479 | 605479 | 2021-04-09 | Chile | Magallanes | 23478 | 358 | 22824 | 296 | -52.368 | -70.9863 | 2021-04-10 04:20:59 | Magallanes, Chile | ||
2247100 | 2247100 | 2021-04-07 | Bahamas | 9296 | 189 | 8811 | 296 | 25.025885 | -78.035889 | 2021-04-08 04:21:13 | Bahamas | |||
3085325 | 3085325 | 2021-04-05 | Japan | Nagano | 2957 | 41 | 2620 | 296 | 36.132134 | 138.045528 | 2021-04-06 04:20:32 | Nagano, Japan | ||
241282 | 241282 | 2021-04-02 | Japan | Nara | 3793 | 55 | 3442 | 296 | 34.317451 | 135.871644 | 2021-04-03 04:20:44 | Nara, Japan | ||
1290052 | 1290052 | 2021-03-29 | Japan | Yamagata | 888 | 16 | 576 | 296 | 38.448396 | 140.102154 | 2021-03-30 04:26:23 | Yamagata, Japan | ||
2781066 | 2781066 | 2021-03-24 | Mauritania | 17690 | 447 | 16947 | 296 | 21.0079 | -10.9408 | 2021-03-25 05:27:00 | Mauritania | |||
1802313 | 1802313 | 2021-03-23 | Malaysia | Kedah | 8168 | 24 | 7848 | 296 | 6.1184 | 100.3685 | 2021-03-24 05:25:40 | Kedah, Malaysia | ||
3624756 | 3624756 | 2021-03-17 | Malaysia | Kelantan | 5456 | 22 | 5138 | 296 | 6.1254 | 102.2381 | 2021-03-18 05:26:22 | Kelantan, Malaysia | ||
706080 | 706080 | 2021-03-16 | Malaysia | Kelantan | 5437 | 22 | 5119 | 296 | 6.1254 | 102.2381 | 2021-03-17 05:25:07 | Kelantan, Malaysia | ||
1583820 | 1583820 | 2021-03-13 | US | Alaska | Chugach | 2063 | 299 | 3 | 0 | 296 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
1841599 | 1841599 | 2021-03-12 | US | Alaska | Chugach | 2063 | 299 | 3 | 0 | 296 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
1837741 | 1837741 | 2021-03-12 | China | Hong Kong | 11210 | 203 | 10711 | 296 | 22.3 | 114.2 | 2021-03-13 05:25:15 | Hong Kong, China | ||
355964 | 355964 | 2021-03-11 | US | Alaska | Chugach | 2063 | 299 | 3 | 0 | 296 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
3966188 | 3966188 | 2021-03-10 | US | Alaska | Chugach | 2063 | 299 | 3 | 0 | 296 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
3667276 | 3667276 | 2021-03-09 | US | Alaska | Chugach | 2063 | 299 | 3 | 0 | 296 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
3663878 | 3663878 | 2021-03-09 | Sao Tome and Principe | 1977 | 32 | 1649 | 296 | 0.1864 | 6.6131 | 2021-03-10 05:24:35 | Sao Tome and Principe | |||
2359157 | 2359157 | 2021-03-08 | Andorra | 11069 | 112 | 10661 | 296 | 42.5063 | 1.5218 | 2021-03-09 05:28:19 | Andorra | |||
3667653 | 3667653 | 2021-03-06 | Japan | Okinawa | 8303 | 120 | 7887 | 296 | 25.768923 | 126.668016 | 2021-03-07 05:21:54 | Okinawa, Japan | ||
1090691 | 1090691 | 2021-03-03 | US | Colorado | Huerfano | 8055 | 322 | 16 | 0 | 296 | 37.68473101 | -104.9612585 | 2021-03-04 05:24:24 | Huerfano, Colorado, US |
3069388 | 3069388 | 2021-02-27 | US | Virginia | Rappahannock | 51157 | 298 | 2 | 0 | 296 | 38.68295619 | -78.15826963 | 2021-02-28 05:22:20 | Rappahannock, Virginia, US |
2186631 | 2186631 | 2021-02-26 | US | Texas | Concho | 48095 | 358 | 7 | 0 | 296 | 31.32635934 | -99.86473038 | 2021-02-27 05:22:28 | Concho, Texas, US |
2185346 | 2185346 | 2021-02-26 | US | Minnesota | Traverse | 27155 | 301 | 5 | 0 | 296 | 45.77298854 | -96.47062949 | 2021-02-27 05:22:28 | Traverse, Minnesota, US |
1859768 | 1859768 | 2021-02-25 | US | Minnesota | Traverse | 27155 | 301 | 5 | 0 | 296 | 45.77298854 | -96.47062949 | 2021-02-26 05:22:40 | Traverse, Minnesota, US |
281946 | 281946 | 2021-02-24 | US | Minnesota | Traverse | 27155 | 301 | 5 | 0 | 296 | 45.77298854 | -96.47062949 | 2021-02-25 05:24:57 | Traverse, Minnesota, US |
1938214 | 1938214 | 2021-02-23 | US | Minnesota | Traverse | 27155 | 301 | 5 | 0 | 296 | 45.77298854 | -96.47062949 | 2021-02-24 05:29:16 | Traverse, Minnesota, US |
532469 | 532469 | 2021-02-22 | US | Minnesota | Traverse | 27155 | 301 | 5 | 0 | 296 | 45.77298854 | -96.47062949 | 2021-02-23 05:23:41 | Traverse, Minnesota, US |
183803 | 183803 | 2021-02-21 | US | Minnesota | Traverse | 27155 | 301 | 5 | 0 | 296 | 45.77298854 | -96.47062949 | 2021-02-22 05:24:21 | Traverse, Minnesota, US |
745193 | 745193 | 2021-02-20 | US | South Dakota | Marshall | 46091 | 301 | 5 | 0 | 296 | 45.75870838 | -97.59855639 | 2021-02-21 05:24:33 | Marshall, South Dakota, US |
3052182 | 3052182 | 2021-02-16 | US | Montana | Musselshell | 30065 | 304 | 8 | 0 | 296 | 46.49684637 | -108.39498 | 2021-02-17 05:23:10 | Musselshell, Montana, US |
1340281 | 1340281 | 2021-02-15 | US | Montana | Musselshell | 30065 | 304 | 8 | 0 | 296 | 46.49684637 | -108.39498 | 2021-02-16 05:24:38 | Musselshell, Montana, US |
2285432 | 2285432 | 2021-02-14 | US | Montana | Musselshell | 30065 | 304 | 8 | 0 | 296 | 46.49684637 | -108.39498 | 2021-02-15 05:24:49 | Musselshell, Montana, US |
2679233 | 2679233 | 2021-02-13 | US | Kentucky | Hickman | 21105 | 303 | 7 | 0 | 296 | 36.67948079999999 | -88.97875928 | 2021-02-14 05:23:43 | Hickman, Kentucky, US |
3540103 | 3540103 | 2021-02-12 | US | Colorado | Saguache | 8109 | 314 | 4 | 0 | 296 | 38.08054629 | -106.282466 | 2021-02-13 05:22:12 | Saguache, Colorado, US |
2638635 | 2638635 | 2021-02-11 | US | Idaho | Boise | 16015 | 298 | 2 | 0 | 296 | 43.98829931 | -115.7309284 | 2021-02-12 05:23:29 | Boise, Idaho, US |
2637684 | 2637684 | 2021-02-11 | India | Puducherry | 39397 | 656 | 38445 | 296 | 11.882658 | 78.86498 | 2021-02-12 05:23:29 | Puducherry, India | ||
3980696 | 3980696 | 2021-02-10 | US | Nebraska | Valley | 31175 | 299 | 3 | 0 | 296 | 41.56730777 | -98.98197724 | 2021-02-11 05:23:55 | Valley, Nebraska, US |
3979437 | 3979437 | 2021-02-10 | US | Georgia | Schley | 13249 | 298 | 2 | 0 | 296 | 32.2654021 | -84.31258912 | 2021-02-11 05:23:55 | Schley, Georgia, US |
613538 | 613538 | 2021-02-08 | Colombia | La Guajira | 15888 | 611 | 14981 | 296 | 11.3548 | -72.5205 | 2021-02-09 05:23:30 | La Guajira, Colombia | ||
1675220 | 1675220 | 2021-02-07 | US | Puerto Rico | Rincon | 72117 | 296 | 0 | 0 | 296 | 18.335443 | -67.23174 | 2021-02-08 05:22:39 | Rincon, Puerto Rico, US |
1899276 | 1899276 | 2021-01-29 | US | Nebraska | Webster | 31181 | 300 | 4 | 0 | 296 | 40.17642643 | -98.50019851 | 2021-01-30 05:22:49 | Webster, Nebraska, US |
2484092 | 2484092 | 2021-01-28 | US | Nebraska | Webster | 31181 | 300 | 4 | 0 | 296 | 40.17642643 | -98.50019851 | 2021-01-29 05:22:23 | Webster, Nebraska, US |
3156670 | 3156670 | 2021-01-27 | US | Texas | Donley | 48129 | 399 | 11 | 0 | 296 | 34.96517499 | -100.8140093 | 2021-01-28 05:22:24 | Donley, Texas, US |
1762737 | 1762737 | 2021-01-24 | US | Washington | Lincoln | 53043 | 300 | 4 | 0 | 296 | 47.57705241 | -118.4194388 | 2021-01-25 05:22:16 | Lincoln, Washington, US |
1760919 | 1760919 | 2021-01-24 | US | Michigan | Federal Correctional Institution (FCI) | 301 | 5 | 0 | 296 | 47.63197653 | 0.0 | 2021-01-25 05:22:16 | Federal Correctional Institution (FCI), Michigan, US | |
2430344 | 2430344 | 2021-01-23 | US | Washington | Lincoln | 53043 | 300 | 4 | 0 | 296 | 47.57705241 | -118.4194388 | 2021-01-24 05:22:35 | Lincoln, Washington, US |
2428526 | 2428526 | 2021-01-23 | US | Michigan | Federal Correctional Institution (FCI) | 301 | 5 | 0 | 296 | 47.63197653 | 0.0 | 2021-01-24 05:22:35 | Federal Correctional Institution (FCI), Michigan, US | |
2428052 | 2428052 | 2021-01-23 | US | Iowa | Adams | 19003 | 299 | 3 | 0 | 296 | 41.02903567 | -94.69932645 | 2021-01-24 05:22:35 | Adams, Iowa, US |
435496 | 435496 | 2021-01-21 | Pakistan | Azad Jammu and Kashmir | 8753 | 248 | 8209 | 296 | 34.027401 | 73.947253 | 2021-01-22 05:22:10 | Azad Jammu and Kashmir, Pakistan | ||
1094515 | 1094515 | 2021-01-20 | US | Alaska | Sitka | 2220 | 296 | 0 | 0 | 296 | 57.24124555 | -135.3206587 | 2021-01-21 05:22:01 | Sitka, Alaska, US |
1094050 | 1094050 | 2021-01-20 | India | Puducherry | 38737 | 643 | 37798 | 296 | 11.882658 | 78.86498 | 2021-01-21 05:22:01 | Puducherry, India | ||
908636 | 908636 | 2021-01-19 | US | Arkansas | Calhoun | 5013 | 298 | 2 | 0 | 296 | 33.55598792 | -92.49974403 | 2021-01-20 05:21:54 | Calhoun, Arkansas, US |
908605 | 908605 | 2021-01-19 | US | Alaska | Sitka | 2220 | 296 | 0 | 0 | 296 | 57.24124555 | -135.3206587 | 2021-01-20 05:21:54 | Sitka, Alaska, US |
237198 | 237198 | 2021-01-18 | India | Manipur | 28867 | 366 | 28205 | 296 | 24.738975 | 93.882541 | 2021-01-19 05:22:15 | Manipur, India | ||
3503780 | 3503780 | 2021-01-17 | US | Alaska | Nome | 2180 | 296 | 0 | 0 | 296 | 64.90320724 | -164.0353804 | 2021-01-18 05:22:34 | Nome, Alaska, US |
3104907 | 3104907 | 2021-01-16 | US | West Virginia | Clay | 54015 | 300 | 4 | 0 | 296 | 38.46231092 | -81.07652217 | 2021-01-17 05:22:17 | Clay, West Virginia, US |
3518679 | 3518679 | 2021-01-15 | US | Vermont | Lamoille | 50015 | 297 | 1 | 0 | 296 | 44.60353043 | -72.64356694 | 2021-01-16 05:22:40 | Lamoille, Vermont, US |
3518296 | 3518296 | 2021-01-15 | US | South Dakota | Stanley | 46117 | 298 | 2 | 0 | 296 | 44.41381872 | -100.7349153 | 2021-01-16 05:22:40 | Stanley, South Dakota, US |
3882463 | 3882463 | 2021-01-14 | US | South Dakota | Perkins | 46105 | 307 | 11 | 0 | 296 | 45.49049506 | -102.4755586 | 2021-01-15 05:22:24 | Perkins, South Dakota, US |
3311090 | 3311090 | 2021-01-13 | US | South Dakota | Perkins | 46105 | 307 | 11 | 0 | 296 | 45.49049506 | -102.4755586 | 2021-01-14 05:22:32 | Perkins, South Dakota, US |
777362 | 777362 | 2021-01-12 | US | Texas | Blanco | 48031 | 377 | 9 | 0 | 296 | 30.26640707 | -98.3999852 | 2021-01-13 05:22:15 | Blanco, Texas, US |
774988 | 774988 | 2021-01-12 | US | Colorado | Rio Blanco | 8103 | 346 | 3 | 0 | 296 | 39.97913541 | -108.2179009 | 2021-01-13 05:22:15 | Rio Blanco, Colorado, US |
193083 | 193083 | 2021-01-11 | US | Texas | Blanco | 48031 | 377 | 9 | 0 | 296 | 30.26640707 | -98.3999852 | 2021-01-12 05:22:15 | Blanco, Texas, US |
191733 | 191733 | 2021-01-11 | US | Michigan | Ontonagon | 26131 | 312 | 16 | 0 | 296 | 46.665226200000006 | -89.31390481 | 2021-01-12 05:22:15 | Ontonagon, Michigan, US |
2628886 | 2628886 | 2021-01-10 | US | Texas | Blanco | 48031 | 377 | 9 | 0 | 296 | 30.26640707 | -98.3999852 | 2021-01-11 05:21:50 | Blanco, Texas, US |
2627536 | 2627536 | 2021-01-10 | US | Michigan | Ontonagon | 26131 | 312 | 16 | 0 | 296 | 46.665226200000006 | -89.31390481 | 2021-01-11 05:21:50 | Ontonagon, Michigan, US |
2627186 | 2627186 | 2021-01-10 | US | Kansas | Ness | 20135 | 311 | 15 | 0 | 296 | 38.47974157 | -99.91547333 | 2021-01-11 05:21:50 | Ness, Kansas, US |
2626780 | 2626780 | 2021-01-10 | US | Idaho | Bear Lake | 16007 | 298 | 2 | 0 | 296 | 42.28269683 | -111.32892379999998 | 2021-01-11 05:21:50 | Bear Lake, Idaho, US |
2626452 | 2626452 | 2021-01-10 | US | California | Trinity | 6105 | 313 | 2 | 0 | 296 | 40.64917670000001 | -123.114713 | 2021-01-11 05:21:50 | Trinity, California, US |
3903324 | 3903324 | 2021-01-09 | US | Virginia | Middlesex | 51119 | 308 | 12 | 0 | 296 | 37.63191998 | -76.55064617 | 2021-01-10 05:22:12 | Middlesex, Virginia, US |
3901624 | 3901624 | 2021-01-09 | US | Michigan | Ontonagon | 26131 | 312 | 16 | 0 | 296 | 46.665226200000006 | -89.31390481 | 2021-01-10 05:22:12 | Ontonagon, Michigan, US |
3901274 | 3901274 | 2021-01-09 | US | Kansas | Ness | 20135 | 311 | 15 | 0 | 296 | 38.47974157 | -99.91547333 | 2021-01-10 05:22:12 | Ness, Kansas, US |
3900868 | 3900868 | 2021-01-09 | US | Idaho | Bear Lake | 16007 | 298 | 2 | 0 | 296 | 42.28269683 | -111.32892379999998 | 2021-01-10 05:22:12 | Bear Lake, Idaho, US |
155647 | 155647 | 2021-01-08 | US | Michigan | Ontonagon | 26131 | 312 | 16 | 0 | 296 | 46.665226200000006 | -89.31390481 | 2021-01-09 05:22:18 | Ontonagon, Michigan, US |
155297 | 155297 | 2021-01-08 | US | Kansas | Ness | 20135 | 311 | 15 | 0 | 296 | 38.47974157 | -99.91547333 | 2021-01-09 05:22:18 | Ness, Kansas, US |
2544010 | 2544010 | 2021-01-07 | US | Oregon | Curry | 41015 | 299 | 3 | 0 | 296 | 42.45911325 | -124.157282 | 2021-01-08 05:22:42 | Curry, Oregon, US |
2542721 | 2542721 | 2021-01-07 | US | Kansas | Ness | 20135 | 311 | 15 | 0 | 296 | 38.47974157 | -99.91547333 | 2021-01-08 05:22:42 | Ness, Kansas, US |
2866030 | 2866030 | 2021-01-06 | US | Kansas | Ness | 20135 | 311 | 15 | 0 | 296 | 38.47974157 | -99.91547333 | 2021-01-07 05:22:03 | Ness, Kansas, US |
3035943 | 3035943 | 2021-01-05 | US | Michigan | Lake | 26085 | 305 | 9 | 0 | 296 | 43.99050893 | -85.802173 | 2021-01-06 05:22:16 | Lake, Michigan, US |
1063291 | 1063291 | 2021-01-04 | US | Kentucky | Nicholas | 21181 | 299 | 3 | 0 | 296 | 38.33342292 | -84.01889177 | 2021-01-05 05:21:49 | Nicholas, Kentucky, US |
2229806 | 2229806 | 2021-01-02 | US | North Carolina | Camden | 37029 | 301 | 5 | 0 | 296 | 36.33804939 | -76.15568396 | 2021-01-03 05:22:52 | Camden, North Carolina, 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]);