johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
418 rows where active = 534 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 342
- Russia 16
- Japan 7
- Madagascar 7
- Eritrea 4
- Colombia 3
- Hungary 3
- India 3
- Mexico 3
- Ukraine 3
- Bahamas 2
- Chile 2
- Italy 2
- Pakistan 2
- Suriname 2
- Canada 1
- Denmark 1
- Germany 1
- Guinea-Bissau 1
- Lebanon 1
- Liberia 1
- Malawi 1
- Malaysia 1
- Maldives 1
- Mali 1
- Mauritania 1
- Mongolia 1
- Netherlands 1
- Somalia 1
- Thailand 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903936 | 3903936 | 2021-07-31 | India | Punjab | 599104 | 16293 | 582277 | 534 | 30.841465000000003 | 75.40879 | 2021-08-01 04:21:50 | Punjab, India | ||
411928 | 411928 | 2021-07-28 | Ukraine | Lviv Oblast | 138037 | 3685 | 133818 | 534 | 49.8397 | 24.0297 | 2021-07-29 04:21:33 | Lviv Oblast, Ukraine | ||
2673725 | 2673725 | 2021-07-18 | Germany | Hamburg | 77823 | 1603 | 75800 | 534 | 53.5511 | 9.9937 | 2021-07-19 04:21:24 | Hamburg, Germany | ||
400451 | 400451 | 2021-06-29 | Russia | Amur Oblast | 24007 | 305 | 23168 | 534 | 52.8032368 | 128.437295 | 2021-06-30 04:21:41 | Amur Oblast, Russia | ||
2426530 | 2426530 | 2021-06-23 | Ukraine | Ternopil Oblast | 69986 | 1196 | 68256 | 534 | 49.5535 | 25.5948 | 2021-06-24 04:21:55 | Ternopil Oblast, Ukraine | ||
2716993 | 2716993 | 2021-06-10 | Japan | Kyoto | 16257 | 227 | 15496 | 534 | 35.253815 | 135.443341 | 2021-06-11 04:23:20 | Kyoto, Japan | ||
3472370 | 3472370 | 2021-06-08 | Mauritania | 19895 | 470 | 18891 | 534 | 21.0079 | -10.9408 | 2021-06-09 04:23:31 | Mauritania | |||
3145789 | 3145789 | 2021-06-07 | Russia | Kemerovo Oblast | 37373 | 737 | 36102 | 534 | 54.53357809999999 | 87.342861 | 2021-06-08 04:22:35 | Kemerovo Oblast, Russia | ||
20214 | 20214 | 2021-05-28 | Colombia | Choco | 11225 | 283 | 10408 | 534 | 5.2528 | -76.82600000000002 | 2021-05-29 04:20:41 | Choco, Colombia | ||
1916879 | 1916879 | 2021-05-20 | Zambia | 92754 | 1265 | 90955 | 534 | -13.133897 | 27.849332 | 2021-05-21 04:20:43 | Zambia | |||
2255755 | 2255755 | 2021-05-19 | Japan | Mie | 4580 | 98 | 3948 | 534 | 34.508018 | 136.376013 | 2021-05-20 04:21:05 | Mie, Japan | ||
2939373 | 2939373 | 2021-05-16 | Japan | Yamaguchi | 2423 | 51 | 1838 | 534 | 34.201190000000004 | 131.573293 | 2021-05-17 04:20:34 | Yamaguchi, Japan | ||
3954489 | 3954489 | 2021-05-11 | Italy | Valle d'Aosta | 11259 | 464 | 10261 | 534 | 45.73750286 | 7.320149366 | 2021-05-12 04:21:29 | Valle d'Aosta, Italy | ||
954901 | 954901 | 2021-04-25 | Japan | Shiga | 3521 | 61 | 2926 | 534 | 35.21582700000001 | 136.138064 | 2021-04-26 04:21:04 | Shiga, Japan | ||
1567811 | 1567811 | 2021-04-22 | Bahamas | 9868 | 194 | 9140 | 534 | 25.025885 | -78.035889 | 2021-04-23 04:20:52 | Bahamas | |||
3242032 | 3242032 | 2021-04-21 | Bahamas | 9868 | 194 | 9140 | 534 | 25.025885 | -78.035889 | 2021-04-22 04:20:53 | Bahamas | |||
2548804 | 2548804 | 2021-04-15 | Guinea-Bissau | 3706 | 66 | 3106 | 534 | 11.8037 | -15.1804 | 2021-04-16 04:20:46 | Guinea-Bissau | |||
3369335 | 3369335 | 2021-03-21 | Japan | Fukuoka | 18750 | 325 | 17891 | 534 | 33.526032 | 130.666949 | 2021-03-22 05:25:43 | Fukuoka, Japan | ||
1744764 | 1744764 | 2021-03-20 | Russia | Murmansk Oblast | 48248 | 1042 | 46672 | 534 | 68.00004179999999 | 33.9999151 | 2021-03-21 05:25:44 | Murmansk Oblast, Russia | ||
3667971 | 3667971 | 2021-03-06 | US | Alabama | Choctaw | 1023 | 557 | 23 | 0 | 534 | 32.02227341 | -88.26564429999998 | 2021-03-07 05:21:54 | Choctaw, Alabama, US |
3667954 | 3667954 | 2021-03-06 | Thailand | 26305 | 85 | 25686 | 534 | 15.870032 | 100.992541 | 2021-03-07 05:21:54 | Thailand | |||
1092009 | 1092009 | 2021-03-03 | US | Missouri | Ozark | 29153 | 550 | 16 | 0 | 534 | 36.64916339 | -92.44459066 | 2021-03-04 05:24:24 | Ozark, Missouri, US |
3255431 | 3255431 | 2021-03-02 | US | Kansas | Greenwood | 20073 | 547 | 13 | 0 | 534 | 37.8774388 | -96.23250453 | 2021-03-03 05:23:28 | Greenwood, Kansas, US |
999723 | 999723 | 2021-03-01 | US | Kansas | Greenwood | 20073 | 547 | 13 | 0 | 534 | 37.8774388 | -96.23250453 | 2021-03-02 05:23:30 | Greenwood, Kansas, US |
2368984 | 2368984 | 2021-02-28 | US | Louisiana | Cameron | 22023 | 539 | 5 | 0 | 534 | 29.87592238 | -93.19310676 | 2021-03-01 05:23:01 | Cameron, Louisiana, US |
2368781 | 2368781 | 2021-02-28 | US | Kansas | Greenwood | 20073 | 547 | 13 | 0 | 534 | 37.8774388 | -96.23250453 | 2021-03-01 05:23:01 | Greenwood, Kansas, US |
3068743 | 3068743 | 2021-02-27 | US | Puerto Rico | Lares | 72081 | 534 | 0 | 0 | 534 | 18.269035 | -66.867236 | 2021-02-28 05:22:20 | Lares, Puerto Rico, US |
3067283 | 3067283 | 2021-02-27 | US | Kansas | Greenwood | 20073 | 547 | 13 | 0 | 534 | 37.8774388 | -96.23250453 | 2021-02-28 05:22:20 | Greenwood, Kansas, US |
2186327 | 2186327 | 2021-02-26 | US | Puerto Rico | Lares | 72081 | 534 | 0 | 0 | 534 | 18.269035 | -66.867236 | 2021-02-27 05:22:28 | Lares, Puerto Rico, US |
2184867 | 2184867 | 2021-02-26 | US | Kansas | Greenwood | 20073 | 547 | 13 | 0 | 534 | 37.8774388 | -96.23250453 | 2021-02-27 05:22:28 | Greenwood, Kansas, US |
1859289 | 1859289 | 2021-02-25 | US | Kansas | Greenwood | 20073 | 546 | 12 | 0 | 534 | 37.8774388 | -96.23250453 | 2021-02-26 05:22:40 | Greenwood, Kansas, US |
281565 | 281565 | 2021-02-24 | US | Kentucky | Crittenden | 21055 | 551 | 17 | 0 | 534 | 37.35839237 | -88.08826090000002 | 2021-02-25 05:24:57 | Crittenden, Kentucky, US |
281467 | 281467 | 2021-02-24 | US | Kansas | Greenwood | 20073 | 546 | 12 | 0 | 534 | 37.8774388 | -96.23250453 | 2021-02-25 05:24:57 | Greenwood, Kansas, US |
1937938 | 1937938 | 2021-02-23 | US | Louisiana | Cameron | 22023 | 539 | 5 | 0 | 534 | 29.87592238 | -93.19310676 | 2021-02-24 05:29:16 | Cameron, Louisiana, US |
1937833 | 1937833 | 2021-02-23 | US | Kentucky | Crittenden | 21055 | 551 | 17 | 0 | 534 | 37.35839237 | -88.08826090000002 | 2021-02-24 05:29:16 | Crittenden, Kentucky, US |
1937735 | 1937735 | 2021-02-23 | US | Kansas | Greenwood | 20073 | 546 | 12 | 0 | 534 | 37.8774388 | -96.23250453 | 2021-02-24 05:29:16 | Greenwood, Kansas, US |
531990 | 531990 | 2021-02-22 | US | Kansas | Greenwood | 20073 | 546 | 12 | 0 | 534 | 37.8774388 | -96.23250453 | 2021-02-23 05:23:41 | Greenwood, Kansas, US |
182676 | 182676 | 2021-02-21 | US | Colorado | Park | 8093 | 568 | 5 | 0 | 534 | 39.120926 | -105.7182065 | 2021-02-22 05:24:21 | Park, Colorado, US |
474588 | 474588 | 2021-02-19 | US | Texas | Newton | 48351 | 488 | 29 | 0 | 534 | 30.78548982 | -93.74408813 | 2021-02-20 05:22:51 | Newton, Texas, US |
474178 | 474178 | 2021-02-19 | US | Puerto Rico | Salinas | 72123 | 534 | 0 | 0 | 534 | 18.010386999999994 | -66.256592 | 2021-02-20 05:22:51 | Salinas, Puerto Rico, US |
1155511 | 1155511 | 2021-02-18 | US | North Dakota | Foster | 38031 | 556 | 19 | 0 | 534 | 47.4571084 | -98.88279923 | 2021-02-19 05:24:16 | Foster, North Dakota, US |
3602975 | 3602975 | 2021-02-17 | US | Missouri | Ozark | 29153 | 546 | 12 | 0 | 534 | 36.64916339 | -92.44459066 | 2021-02-18 05:22:58 | Ozark, Missouri, US |
3602224 | 3602224 | 2021-02-17 | US | Iowa | Fremont | 19071 | 543 | 9 | 0 | 534 | 40.74542720000001 | -95.60129045 | 2021-02-18 05:22:58 | Fremont, Iowa, US |
1340989 | 1340989 | 2021-02-15 | US | Puerto Rico | Cabo Rojo | 72023 | 534 | 0 | 0 | 534 | 18.040993 | -67.154391 | 2021-02-16 05:24:38 | Cabo Rojo, Puerto Rico, US |
792439 | 792439 | 2021-02-04 | US | Nebraska | Dixon | 31051 | 542 | 8 | 0 | 534 | 42.49188363 | -96.86782408 | 2021-02-05 05:22:38 | Dixon, Nebraska, US |
791692 | 791692 | 2021-02-04 | US | Kansas | Mitchell | 20123 | 545 | 11 | 0 | 534 | 39.39331582 | -98.20906732 | 2021-02-05 05:22:38 | Mitchell, Kansas, US |
341584 | 341584 | 2021-02-03 | US | Kansas | Mitchell | 20123 | 545 | 11 | 0 | 534 | 39.39331582 | -98.20906732 | 2021-02-04 05:22:26 | Mitchell, Kansas, US |
1679793 | 1679793 | 2021-02-01 | US | Virginia | Essex | 51057 | 538 | 4 | 0 | 534 | 37.93357639 | -76.94230311 | 2021-02-02 05:22:49 | Essex, Virginia, US |
1679595 | 1679595 | 2021-02-01 | US | Texas | Jim Hogg | 48247 | 626 | 13 | 0 | 534 | 27.04453923 | -98.6968187 | 2021-02-02 05:22:49 | Jim Hogg, Texas, US |
1676357 | 1676357 | 2021-02-01 | Eritrea | 2135 | 7 | 1594 | 534 | 15.1794 | 39.7823 | 2021-02-02 05:22:49 | Eritrea | |||
1462883 | 1462883 | 2021-01-31 | US | Texas | Jim Hogg | 48247 | 626 | 13 | 0 | 534 | 27.04453923 | -98.6968187 | 2021-02-01 05:22:53 | Jim Hogg, Texas, US |
1462158 | 1462158 | 2021-01-31 | US | North Dakota | McHenry | 38049 | 553 | 21 | 0 | 534 | 48.23104458 | -100.6324822 | 2021-02-01 05:22:53 | McHenry, North Dakota, US |
1460381 | 1460381 | 2021-01-31 | US | Colorado | Lake | 8065 | 564 | 0 | 0 | 534 | 39.20278823 | -106.3555697 | 2021-02-01 05:22:53 | Lake, Colorado, US |
1459645 | 1459645 | 2021-01-31 | Eritrea | 2135 | 7 | 1594 | 534 | 15.1794 | 39.7823 | 2021-02-01 05:22:53 | Eritrea | |||
2214066 | 2214066 | 2021-01-30 | US | North Dakota | McHenry | 38049 | 552 | 21 | 0 | 534 | 48.23104458 | -100.6324822 | 2021-01-31 05:22:42 | McHenry, North Dakota, US |
2211733 | 2211733 | 2021-01-30 | Madagascar | 18743 | 279 | 17930 | 534 | -18.766947 | 46.869107 | 2021-01-31 05:22:42 | Madagascar | |||
2211553 | 2211553 | 2021-01-30 | Eritrea | 2135 | 7 | 1594 | 534 | 15.1794 | 39.7823 | 2021-01-31 05:22:42 | Eritrea | |||
1900360 | 1900360 | 2021-01-29 | US | Texas | San Saba | 48411 | 539 | 17 | 0 | 534 | 31.1577796 | -98.81758731 | 2021-01-30 05:22:49 | San Saba, Texas, US |
1900210 | 1900210 | 2021-01-29 | US | Texas | Dallam | 48111 | 943 | 21 | 0 | 534 | 36.27787176 | -102.6020725 | 2021-01-30 05:22:49 | Dallam, Texas, US |
1897220 | 1897220 | 2021-01-29 | Madagascar | 18743 | 279 | 17930 | 534 | -18.766947 | 46.869107 | 2021-01-30 05:22:49 | Madagascar | |||
1897040 | 1897040 | 2021-01-29 | Eritrea | 2135 | 7 | 1594 | 534 | 15.1794 | 39.7823 | 2021-01-30 05:22:49 | Eritrea | |||
2482036 | 2482036 | 2021-01-28 | Madagascar | 18743 | 279 | 17930 | 534 | -18.766947 | 46.869107 | 2021-01-29 05:22:23 | Madagascar | |||
3153671 | 3153671 | 2021-01-27 | Madagascar | 18743 | 279 | 17930 | 534 | -18.766947 | 46.869107 | 2021-01-28 05:22:24 | Madagascar | |||
15944 | 15944 | 2021-01-26 | US | Wyoming | Platte | 56031 | 545 | 11 | 0 | 534 | 42.13299116 | -104.966331 | 2021-01-27 05:23:41 | Platte, Wyoming, US |
13788 | 13788 | 2021-01-26 | US | Kentucky | Owen | 21187 | 541 | 7 | 0 | 534 | 38.51679143 | -84.82404619 | 2021-01-27 05:23:41 | Owen, Kentucky, US |
13634 | 13634 | 2021-01-26 | US | Kansas | Kearny | 20093 | 545 | 11 | 0 | 534 | 38.00017981 | -101.321681 | 2021-01-27 05:23:41 | Kearny, Kansas, US |
12406 | 12406 | 2021-01-26 | Madagascar | 18743 | 279 | 17930 | 534 | -18.766947 | 46.869107 | 2021-01-27 05:23:41 | Madagascar | |||
2568958 | 2568958 | 2021-01-25 | US | Kansas | Kearny | 20093 | 545 | 11 | 0 | 534 | 38.00017981 | -101.321681 | 2021-01-26 05:22:02 | Kearny, Kansas, US |
2567730 | 2567730 | 2021-01-25 | Madagascar | 18743 | 279 | 17930 | 534 | -18.766947 | 46.869107 | 2021-01-26 05:22:02 | Madagascar | |||
1760582 | 1760582 | 2021-01-24 | US | Kansas | Harper | 20077 | 553 | 19 | 0 | 534 | 37.19175361 | -98.07578384 | 2021-01-25 05:22:16 | Harper, Kansas, US |
1759362 | 1759362 | 2021-01-24 | Madagascar | 18743 | 279 | 17930 | 534 | -18.766947 | 46.869107 | 2021-01-25 05:22:16 | Madagascar | |||
2428189 | 2428189 | 2021-01-23 | US | Kansas | Harper | 20077 | 553 | 19 | 0 | 534 | 37.19175361 | -98.07578384 | 2021-01-24 05:22:35 | Harper, Kansas, US |
2427794 | 2427794 | 2021-01-23 | US | Georgia | Wheeler | 13309 | 555 | 21 | 0 | 534 | 32.12009104 | -82.72574721 | 2021-01-24 05:22:35 | Wheeler, Georgia, US |
2469999 | 2469999 | 2021-01-22 | US | Texas | Red River | 48387 | 607 | 31 | 0 | 534 | 33.61886692 | -95.04841765 | 2021-01-23 05:22:03 | Red River, Texas, US |
2468091 | 2468091 | 2021-01-22 | US | Kansas | Harper | 20077 | 553 | 19 | 0 | 534 | 37.19175361 | -98.07578384 | 2021-01-23 05:22:03 | Harper, Kansas, US |
438552 | 438552 | 2021-01-21 | US | Texas | Refugio | 48391 | 593 | 17 | 0 | 534 | 28.3238976 | -97.15766311 | 2021-01-22 05:22:10 | Refugio, Texas, US |
437450 | 437450 | 2021-01-21 | US | Nebraska | Nemaha | 31127 | 546 | 12 | 0 | 534 | 40.38514847 | -95.85433992 | 2021-01-22 05:22:10 | Nemaha, Nebraska, US |
911489 | 911489 | 2021-01-19 | US | Virginia | Clarke | 51043 | 541 | 7 | 0 | 534 | 39.11271747 | -77.99199425 | 2021-01-20 05:21:54 | Clarke, Virginia, US |
240020 | 240020 | 2021-01-18 | US | Puerto Rico | Villalba | 72149 | 534 | 0 | 0 | 534 | 18.127951 | -66.473115 | 2021-01-19 05:22:15 | Villalba, Puerto Rico, US |
3104148 | 3104148 | 2021-01-16 | US | Puerto Rico | Anasco | 72011 | 534 | 0 | 0 | 534 | 18.287985 | -67.120611 | 2021-01-17 05:22:17 | Anasco, Puerto Rico, US |
3103481 | 3103481 | 2021-01-16 | US | Nebraska | Burt | 31021 | 544 | 10 | 0 | 534 | 41.85056773 | -96.32605633 | 2021-01-17 05:22:17 | Burt, Nebraska, US |
3517443 | 3517443 | 2021-01-15 | US | Nebraska | Burt | 31021 | 544 | 10 | 0 | 534 | 41.85056773 | -96.32605633 | 2021-01-16 05:22:40 | Burt, Nebraska, US |
3517329 | 3517329 | 2021-01-15 | US | Missouri | Montgomery | 29139 | 543 | 9 | 0 | 534 | 38.94022054 | -91.47000721 | 2021-01-16 05:22:40 | Montgomery, Missouri, US |
3881615 | 3881615 | 2021-01-14 | US | Nebraska | Burt | 31021 | 544 | 10 | 0 | 534 | 41.85056773 | -96.32605633 | 2021-01-15 05:22:24 | Burt, Nebraska, US |
3310242 | 3310242 | 2021-01-13 | US | Nebraska | Burt | 31021 | 544 | 10 | 0 | 534 | 41.85056773 | -96.32605633 | 2021-01-14 05:22:32 | Burt, Nebraska, US |
777398 | 777398 | 2021-01-12 | US | Texas | Crane | 48103 | 410 | 10 | 0 | 534 | 31.43052248 | -102.5143314 | 2021-01-13 05:22:15 | Crane, Texas, US |
2629221 | 2629221 | 2021-01-10 | US | Virginia | King William | 51101 | 538 | 4 | 0 | 534 | 37.70965316 | -77.09384941 | 2021-01-11 05:21:50 | King William, Virginia, US |
2626343 | 2626343 | 2021-01-10 | US | Arkansas | Dallas | 5039 | 546 | 12 | 0 | 534 | 33.97042763 | -92.65167437 | 2021-01-11 05:21:50 | Dallas, Arkansas, US |
2625732 | 2625732 | 2021-01-10 | Colombia | Sucre | 17907 | 685 | 16688 | 534 | 8.814 | -74.7233 | 2021-01-11 05:21:50 | Sucre, Colombia | ||
3901811 | 3901811 | 2021-01-09 | US | Mississippi | Wilkinson | 28157 | 558 | 24 | 0 | 534 | 31.16078225 | -91.31018819 | 2021-01-10 05:22:12 | Wilkinson, Mississippi, US |
2544291 | 2544291 | 2021-01-07 | US | South Dakota | Moody | 46101 | 548 | 14 | 0 | 534 | 44.02266214 | -96.67081159 | 2021-01-08 05:22:42 | Moody, South Dakota, US |
2541427 | 2541427 | 2021-01-07 | Japan | Kumamoto | 2182 | 28 | 1620 | 534 | 32.608154 | 130.74523100000002 | 2021-01-08 05:22:42 | Kumamoto, Japan | ||
2867886 | 2867886 | 2021-01-06 | US | Texas | Morris | 48343 | 691 | 11 | 0 | 534 | 33.11304005 | -94.73255695 | 2021-01-07 05:22:03 | Morris, Texas, US |
2865537 | 2865537 | 2021-01-06 | US | Georgia | Lanier | 13173 | 544 | 10 | 0 | 534 | 31.038285700000007 | -83.06472457 | 2021-01-07 05:22:03 | Lanier, Georgia, US |
3037175 | 3037175 | 2021-01-05 | US | South Dakota | Kingsbury | 46077 | 547 | 13 | 0 | 534 | 44.36956169 | -97.4913945 | 2021-01-06 05:22:16 | Kingsbury, South Dakota, US |
3035438 | 3035438 | 2021-01-05 | US | Indiana | Union | 18161 | 538 | 4 | 0 | 534 | 39.62550777 | -84.92497066 | 2021-01-06 05:22:16 | Union, Indiana, US |
2228733 | 2228733 | 2021-01-02 | US | Iowa | Monona | 19133 | 550 | 16 | 0 | 534 | 42.05220391 | -95.95743843 | 2021-01-03 05:22:52 | Monona, Iowa, US |
1013747 | 1013747 | 2020-12-30 | US | Washington | Pacific | 53049 | 539 | 5 | 0 | 534 | 46.55418369 | -123.7285716 | 2020-12-31 05:22:49 | Pacific, Washington, US |
1012216 | 1012216 | 2020-12-30 | US | Missouri | Lewis | 29111 | 537 | 3 | 0 | 534 | 40.09673161 | -91.72070156 | 2020-12-31 05:22:49 | Lewis, Missouri, US |
1012024 | 1012024 | 2020-12-30 | US | Minnesota | Koochiching | 27071 | 542 | 8 | 0 | 534 | 48.24539665 | -93.78352843 | 2020-12-31 05:22:49 | Koochiching, Minnesota, 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]);