johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,056 rows where active = 151 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 920
- Japan 26
- Ukraine 8
- France 7
- Papua New Guinea 7
- Mexico 6
- United Kingdom 6
- Canada 5
- Chile 5
- Colombia 5
- Bhutan 4
- Germany 4
- Italy 4
- Malaysia 4
- Cyprus 3
- India 3
- Niger 3
- Russia 3
- Saint Vincent and the Grenadines 3
- Cabo Verde 2
- China 2
- Netherlands 2
- South Sudan 2
- Vietnam 2
- Albania 1
- Antigua and Barbuda 1
- Belize 1
- Estonia 1
- Fiji 1
- Liechtenstein 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903990 | 3903990 | 2021-07-31 | Japan | Kagoshima | 3968 | 39 | 3778 | 151 | 31.009484000000004 | 130.430665 | 2021-08-01 04:21:50 | Kagoshima, Japan | ||
3299800 | 3299800 | 2021-07-30 | Ukraine | Chernivtsi Oblast | 80158 | 1798 | 78209 | 151 | 48.2917 | 25.9352 | 2021-07-31 04:21:35 | Chernivtsi Oblast, Ukraine | ||
3385113 | 3385113 | 2021-07-29 | Bhutan | 2506 | 2 | 2353 | 151 | 27.5142 | 90.4336 | 2021-07-30 04:21:34 | Bhutan | |||
1306200 | 1306200 | 2021-07-27 | Japan | Wakayama | 2829 | 49 | 2629 | 151 | 33.911879 | 135.505446 | 2021-07-28 04:21:39 | Wakayama, Japan | ||
1165307 | 1165307 | 2021-07-04 | North Macedonia | 155710 | 5486 | 150073 | 151 | 41.6086 | 21.7453 | 2021-07-05 04:21:28 | North Macedonia | |||
3129133 | 3129133 | 2021-06-28 | Ukraine | Ivano-Frankivsk Oblast | 86654 | 2097 | 84406 | 151 | 48.9226 | 24.7111 | 2021-06-29 04:21:28 | Ivano-Frankivsk Oblast, Ukraine | ||
2590225 | 2590225 | 2021-06-27 | Russia | Magadan Oblast | 8659 | 117 | 8391 | 151 | 62.48858785 | 153.9903764 | 2021-06-28 04:21:29 | Magadan Oblast, Russia | ||
107481 | 107481 | 2021-06-19 | Japan | Okayama | 7577 | 124 | 7302 | 151 | 34.89246 | 133.826252 | 2021-06-20 04:21:48 | Okayama, Japan | ||
3145578 | 3145578 | 2021-06-07 | Italy | Valle d'Aosta | 11629 | 472 | 11006 | 151 | 45.73750286 | 7.320149366 | 2021-06-08 04:22:35 | Valle d'Aosta, Italy | ||
1188790 | 1188790 | 2021-05-31 | Japan | Wakayama | 2618 | 44 | 2423 | 151 | 33.911879 | 135.505446 | 2021-06-01 04:23:09 | Wakayama, Japan | ||
1806635 | 1806635 | 2021-05-27 | Fiji | 314 | 4 | 159 | 151 | -17.7134 | 178.065 | 2021-05-28 04:20:36 | Fiji | |||
1806593 | 1806593 | 2021-05-27 | Colombia | Guaviare | 2929 | 43 | 2735 | 151 | 1.0654 | -73.2603 | 2021-05-28 04:20:36 | Guaviare, Colombia | ||
83230 | 83230 | 2021-05-25 | Niger | 5389 | 192 | 5046 | 151 | 17.607789 | 8.081666 | 2021-05-26 04:20:35 | Niger | |||
1912936 | 1912936 | 2021-05-20 | Bhutan | 1338 | 1 | 1186 | 151 | 27.5142 | 90.4336 | 2021-05-21 04:20:43 | Bhutan | |||
1873223 | 1873223 | 2021-05-15 | Saint Vincent and the Grenadines | 1932 | 12 | 1769 | 151 | 12.9843 | -61.2872 | 2021-05-16 04:20:49 | Saint Vincent and the Grenadines | |||
1082192 | 1082192 | 2021-05-14 | Saint Vincent and the Grenadines | 1932 | 12 | 1769 | 151 | 12.9843 | -61.2872 | 2021-05-15 04:20:58 | Saint Vincent and the Grenadines | |||
3054239 | 3054239 | 2021-05-13 | Japan | Yamanashi | 1376 | 19 | 1206 | 151 | 35.612364 | 138.61148899999998 | 2021-05-14 04:20:41 | Yamanashi, Japan | ||
3954493 | 3954493 | 2021-05-11 | Japan | Akita | 620 | 9 | 460 | 151 | 39.748679 | 140.408228 | 2021-05-12 04:21:29 | Akita, Japan | ||
2820495 | 2820495 | 2021-05-10 | Bhutan | 1241 | 1 | 1089 | 151 | 27.5142 | 90.4336 | 2021-05-11 04:20:41 | Bhutan | |||
1552019 | 1552019 | 2021-05-08 | Japan | Yamanashi | 1299 | 19 | 1129 | 151 | 35.612364 | 138.61148899999998 | 2021-05-09 04:20:35 | Yamanashi, Japan | ||
3393667 | 3393667 | 2021-04-28 | Senegal | 40249 | 1107 | 38991 | 151 | 14.4974 | -14.4524 | 2021-04-29 04:20:55 | Senegal | |||
3924294 | 3924294 | 2021-04-24 | South Sudan | 10515 | 114 | 10250 | 151 | 6.877000000000002 | 31.307 | 2021-04-25 04:20:32 | South Sudan | |||
1409325 | 1409325 | 2021-04-23 | South Sudan | 10515 | 114 | 10250 | 151 | 6.877000000000002 | 31.307 | 2021-04-24 04:20:38 | South Sudan | |||
2410887 | 2410887 | 2021-04-19 | Japan | Toyama | 1154 | 29 | 974 | 151 | 36.637464 | 137.26934599999998 | 2021-04-20 04:20:41 | Toyama, Japan | ||
982717 | 982717 | 2021-04-17 | Canada | New Brunswick | 1778 | 33 | 1594 | 151 | 46.5653 | -66.4619 | 2021-04-18 04:20:41 | New Brunswick, Canada | ||
1841959 | 1841959 | 2021-04-14 | Japan | Ishikawa | 2094 | 66 | 1877 | 151 | 36.769464 | 136.771027 | 2021-04-15 04:20:54 | Ishikawa, Japan | ||
1841947 | 1841947 | 2021-04-14 | Japan | Aomori | 1215 | 20 | 1044 | 151 | 40.781541 | 140.828896 | 2021-04-15 04:20:54 | Aomori, Japan | ||
1841730 | 1841730 | 2021-04-14 | Chile | Aysen | 3844 | 29 | 3664 | 151 | -45.9864 | -73.7669 | 2021-04-15 04:20:54 | Aysen, Chile | ||
2571464 | 2571464 | 2021-04-13 | Chile | Aysen | 3832 | 29 | 3652 | 151 | -45.9864 | -73.7669 | 2021-04-14 04:20:41 | Aysen, Chile | ||
638191 | 638191 | 2021-03-31 | Saint Vincent and the Grenadines | 1748 | 10 | 1587 | 151 | 12.9843 | -61.2872 | 2021-04-01 04:27:05 | Saint Vincent and the Grenadines | |||
1798974 | 1798974 | 2021-03-23 | Trinidad and Tobago | 7865 | 141 | 7573 | 151 | 10.6918 | -61.2225 | 2021-03-24 05:25:40 | Trinidad and Tobago | |||
1798667 | 1798667 | 2021-03-23 | Japan | Niigata | 1312 | 16 | 1145 | 151 | 37.521819 | 138.918647 | 2021-03-24 05:25:40 | Niigata, Japan | ||
3372984 | 3372984 | 2021-03-21 | United Kingdom | Turks and Caicos Islands | 2294 | 16 | 2127 | 151 | 21.694000000000006 | -71.7979 | 2021-03-22 05:25:43 | Turks and Caicos Islands, United Kingdom | ||
1748194 | 1748194 | 2021-03-20 | United Kingdom | Turks and Caicos Islands | 2290 | 15 | 2124 | 151 | 21.694000000000006 | -71.7979 | 2021-03-21 05:25:44 | Turks and Caicos Islands, United Kingdom | ||
702625 | 702625 | 2021-03-16 | Russia | Magadan Oblast | 8211 | 98 | 7962 | 151 | 62.48858785 | 153.9903764 | 2021-03-17 05:25:07 | Magadan Oblast, Russia | ||
3663463 | 3663463 | 2021-03-09 | Colombia | Putumayo | 7965 | 316 | 7498 | 151 | 0.436 | -75.5277 | 2021-03-10 05:24:35 | Putumayo, Colombia | ||
3670029 | 3670029 | 2021-03-06 | US | North Dakota | Oliver | 38065 | 153 | 2 | 0 | 151 | 47.11530482 | -101.3406158 | 2021-03-07 05:21:54 | Oliver, North Dakota, US |
1619898 | 1619898 | 2021-03-05 | United Kingdom | Turks and Caicos Islands | 2172 | 14 | 2007 | 151 | 21.694000000000006 | -71.7979 | 2021-03-06 04:23:41 | Turks and Caicos Islands, United Kingdom | ||
1618650 | 1618650 | 2021-03-05 | US | North Dakota | Oliver | 38065 | 153 | 2 | 0 | 151 | 47.11530482 | -101.3406158 | 2021-03-06 04:23:41 | Oliver, North Dakota, US |
2210061 | 2210061 | 2021-03-04 | US | North Dakota | Oliver | 38065 | 153 | 2 | 0 | 151 | 47.11530482 | -101.3406158 | 2021-03-05 05:26:29 | Oliver, North Dakota, US |
3255411 | 3255411 | 2021-03-02 | US | Kansas | Comanche | 20033 | 158 | 7 | 0 | 151 | 37.19114520000001 | -99.27113247 | 2021-03-03 05:23:28 | Comanche, Kansas, US |
999703 | 999703 | 2021-03-01 | US | Kansas | Comanche | 20033 | 158 | 7 | 0 | 151 | 37.19114520000001 | -99.27113247 | 2021-03-02 05:23:30 | Comanche, Kansas, US |
3066035 | 3066035 | 2021-02-27 | Japan | Shiga | 2462 | 46 | 2265 | 151 | 35.21582700000001 | 136.138064 | 2021-02-28 05:22:20 | Shiga, Japan | ||
281038 | 281038 | 2021-02-24 | US | Georgia | Quitman | 13239 | 152 | 1 | 0 | 151 | 31.86728114 | -85.01773177 | 2021-02-25 05:24:57 | Quitman, Georgia, US |
1937306 | 1937306 | 2021-02-23 | US | Georgia | Quitman | 13239 | 152 | 1 | 0 | 151 | 31.86728114 | -85.01773177 | 2021-02-24 05:29:16 | Quitman, Georgia, US |
1936173 | 1936173 | 2021-02-23 | Belize | 12264 | 314 | 11799 | 151 | 17.1899 | -88.4976 | 2021-02-24 05:29:16 | Belize | |||
184426 | 184426 | 2021-02-21 | US | North Dakota | Divide | 38023 | 154 | 2 | 0 | 151 | 48.814938700000006 | -103.4873611 | 2021-02-22 05:24:21 | Divide, North Dakota, US |
471448 | 471448 | 2021-02-19 | Japan | Shiga | 2361 | 42 | 2168 | 151 | 35.21582700000001 | 136.138064 | 2021-02-20 05:22:51 | Shiga, Japan | ||
3604687 | 3604687 | 2021-02-17 | United Kingdom | Channel Islands | 0 | 0 | 3777 | 151 | 49.3723 | -2.3644 | 2021-02-18 05:22:58 | Channel Islands, United Kingdom | ||
2283195 | 2283195 | 2021-02-14 | Canada | New Brunswick | 1400 | 22 | 1227 | 151 | 46.5653 | -66.4619 | 2021-02-15 05:24:49 | New Brunswick, Canada | ||
2677658 | 2677658 | 2021-02-13 | Colombia | Amazonas | 4366 | 147 | 4068 | 151 | -1.4429 | -71.5724 | 2021-02-14 05:23:43 | Amazonas, Colombia | ||
3978394 | 3978394 | 2021-02-10 | China | Jilin | 573 | 3 | 419 | 151 | 43.6661 | 126.1923 | 2021-02-11 05:23:55 | Jilin, China | ||
3978270 | 3978270 | 2021-02-10 | Antigua and Barbuda | 350 | 9 | 190 | 151 | 17.0608 | -61.7964 | 2021-02-11 05:23:55 | Antigua and Barbuda | |||
340549 | 340549 | 2021-02-03 | Seychelles | 1243 | 5 | 1087 | 151 | -4.6796 | 55.492 | 2021-02-04 05:22:26 | Seychelles | |||
1686560 | 1686560 | 2021-02-02 | US | Nebraska | Dundy | 31057 | 155 | 4 | 0 | 151 | 40.17638677 | -101.6876522 | 2021-02-03 05:22:52 | Dundy, Nebraska, US |
1678530 | 1678530 | 2021-02-01 | US | Nebraska | Dundy | 31057 | 155 | 4 | 0 | 151 | 40.17638677 | -101.6876522 | 2021-02-02 05:22:49 | Dundy, Nebraska, US |
1461818 | 1461818 | 2021-01-31 | US | Nebraska | Dundy | 31057 | 155 | 4 | 0 | 151 | 40.17638677 | -101.6876522 | 2021-02-01 05:22:53 | Dundy, Nebraska, US |
2211608 | 2211608 | 2021-01-30 | India | Chandigarh | 20899 | 334 | 20414 | 151 | 30.733839 | 76.76827800000002 | 2021-01-31 05:22:42 | Chandigarh, India | ||
2482098 | 2482098 | 2021-01-28 | Netherlands | Sint Maarten | 1822 | 27 | 1644 | 151 | 18.0425 | -63.0548 | 2021-01-29 05:22:23 | Sint Maarten, Netherlands | ||
12402 | 12402 | 2021-01-26 | Liechtenstein | 2526 | 53 | 2322 | 151 | 47.14 | 9.55 | 2021-01-27 05:23:41 | Liechtenstein | |||
2426628 | 2426628 | 2021-01-23 | Bhutan | 854 | 1 | 702 | 151 | 27.5142 | 90.4336 | 2021-01-24 05:22:35 | Bhutan | |||
1094117 | 1094117 | 2021-01-20 | Japan | Oita | 955 | 12 | 792 | 151 | 33.200697 | 131.43323999999998 | 2021-01-21 05:22:01 | Oita, Japan | ||
910179 | 910179 | 2021-01-19 | US | Montana | McCone | 30055 | 151 | 0 | 0 | 151 | 47.64469406 | -105.7944994 | 2021-01-20 05:21:54 | McCone, Montana, US |
239242 | 239242 | 2021-01-18 | US | Montana | McCone | 30055 | 151 | 0 | 0 | 151 | 47.64469406 | -105.7944994 | 2021-01-19 05:22:15 | McCone, Montana, US |
3505359 | 3505359 | 2021-01-17 | US | Montana | McCone | 30055 | 151 | 0 | 0 | 151 | 47.64469406 | -105.7944994 | 2021-01-18 05:22:34 | McCone, Montana, US |
3103442 | 3103442 | 2021-01-16 | US | Montana | McCone | 30055 | 151 | 0 | 0 | 151 | 47.64469406 | -105.7944994 | 2021-01-17 05:22:17 | McCone, Montana, US |
3517404 | 3517404 | 2021-01-15 | US | Montana | McCone | 30055 | 151 | 0 | 0 | 151 | 47.64469406 | -105.7944994 | 2021-01-16 05:22:40 | McCone, Montana, US |
3515436 | 3515436 | 2021-01-15 | Japan | Port Quarantine | 2059 | 1 | 1907 | 151 | 2021-01-16 05:22:40 | Port Quarantine, Japan | ||||
3881576 | 3881576 | 2021-01-14 | US | Montana | McCone | 30055 | 151 | 0 | 0 | 151 | 47.64469406 | -105.7944994 | 2021-01-15 05:22:24 | McCone, Montana, US |
3881375 | 3881375 | 2021-01-14 | US | Mississippi | Issaquena | 28055 | 157 | 6 | 0 | 151 | 32.72531359 | -90.97392828 | 2021-01-15 05:22:24 | Issaquena, Mississippi, US |
3881127 | 3881127 | 2021-01-14 | US | Maine | Piscataquis | 23021 | 152 | 1 | 0 | 151 | 45.83839062 | -69.2860223 | 2021-01-15 05:22:24 | Piscataquis, Maine, US |
3310941 | 3310941 | 2021-01-13 | US | Puerto Rico | Jayuya | 72073 | 151 | 0 | 0 | 151 | 18.211446 | -66.58878 | 2021-01-14 05:22:32 | Jayuya, Puerto Rico, US |
777086 | 777086 | 2021-01-12 | US | Puerto Rico | Jayuya | 72073 | 151 | 0 | 0 | 151 | 18.211446 | -66.58878 | 2021-01-13 05:22:15 | Jayuya, Puerto Rico, US |
192807 | 192807 | 2021-01-11 | US | Puerto Rico | Jayuya | 72073 | 151 | 0 | 0 | 151 | 18.211446 | -66.58878 | 2021-01-12 05:22:15 | Jayuya, Puerto Rico, US |
190027 | 190027 | 2021-01-11 | India | Meghalaya | 13631 | 143 | 13337 | 151 | 25.536934 | 91.278882 | 2021-01-12 05:22:15 | Meghalaya, India | ||
3900625 | 3900625 | 2021-01-09 | US | Delaware | Unassigned | 90010 | 151 | 0 | 0 | 151 | 39.57992638 | 0.0 | 2021-01-10 05:22:12 | Unassigned, Delaware, US |
154584 | 154584 | 2021-01-08 | US | Colorado | Custer | 8027 | 165 | 2 | 0 | 151 | 38.10883162 | -105.3683478 | 2021-01-09 05:22:18 | Custer, Colorado, US |
2545060 | 2545060 | 2021-01-07 | United Kingdom | Turks and Caicos Islands | 956 | 6 | 799 | 151 | 21.694000000000006 | -71.7979 | 2021-01-08 05:22:42 | Turks and Caicos Islands, United Kingdom | ||
2543517 | 2543517 | 2021-01-07 | US | Nebraska | Sherman | 31163 | 155 | 4 | 0 | 151 | 41.22045983 | -98.97588642 | 2021-01-08 05:22:42 | Sherman, Nebraska, US |
2868029 | 2868029 | 2021-01-06 | US | Virginia | Craig | 51045 | 152 | 1 | 0 | 151 | 37.48133648 | -80.21072274 | 2021-01-07 05:22:03 | Craig, Virginia, US |
2867852 | 2867852 | 2021-01-06 | US | Texas | Knox | 48275 | 159 | 12 | 0 | 151 | 33.60519951 | -99.7422906 | 2021-01-07 05:22:03 | Knox, Texas, US |
2865349 | 2865349 | 2021-01-06 | US | Colorado | Ouray | 8091 | 179 | 3 | 0 | 151 | 38.14717457 | -107.7675136 | 2021-01-07 05:22:03 | Ouray, Colorado, US |
1065055 | 1065055 | 2021-01-04 | US | Texas | Shackelford | 48417 | 143 | 1 | 0 | 151 | 32.73587756 | -99.35401337 | 2021-01-05 05:21:49 | Shackelford, Texas, US |
3233658 | 3233658 | 2021-01-03 | US | Texas | Shackelford | 48417 | 143 | 1 | 0 | 151 | 32.73587756 | -99.35401337 | 2021-01-04 05:22:02 | Shackelford, Texas, US |
3233140 | 3233140 | 2021-01-03 | US | Pennsylvania | Sullivan | 42113 | 154 | 3 | 0 | 151 | 41.44634738 | -76.51246591 | 2021-01-04 05:22:02 | Sullivan, Pennsylvania, US |
2230727 | 2230727 | 2021-01-02 | US | Texas | Shackelford | 48417 | 143 | 1 | 0 | 151 | 32.73587756 | -99.35401337 | 2021-01-03 05:22:52 | Shackelford, Texas, US |
2229242 | 2229242 | 2021-01-02 | US | Minnesota | Lake of the Woods | 27077 | 152 | 1 | 0 | 151 | 48.77217001 | -94.90274472 | 2021-01-03 05:22:52 | Lake of the Woods, Minnesota, US |
1140091 | 1140091 | 2021-01-01 | US | Texas | Shackelford | 48417 | 143 | 1 | 0 | 151 | 32.73587756 | -99.35401337 | 2021-01-02 05:22:33 | Shackelford, Texas, US |
1138606 | 1138606 | 2021-01-01 | US | Minnesota | Lake of the Woods | 27077 | 152 | 1 | 0 | 151 | 48.77217001 | -94.90274472 | 2021-01-02 05:22:33 | Lake of the Woods, Minnesota, US |
1137217 | 1137217 | 2021-01-01 | Togo | 3662 | 68 | 3443 | 151 | 8.6195 | 0.8248 | 2021-01-02 05:22:33 | Togo | |||
1137159 | 1137159 | 2021-01-01 | Singapore | 58629 | 29 | 58449 | 151 | 1.2833 | 103.8333 | 2021-01-02 05:22:33 | Singapore | |||
3698697 | 3698697 | 2020-12-31 | US | Texas | Shackelford | 48417 | 143 | 1 | 0 | 151 | 32.73587756 | -99.35401337 | 2021-01-01 05:23:07 | Shackelford, Texas, US |
3698198 | 3698198 | 2020-12-31 | US | Puerto Rico | Arroyo | 72015 | 151 | 0 | 0 | 151 | 17.998457000000005 | -66.056546 | 2021-01-01 05:23:07 | Arroyo, Puerto Rico, US |
3697212 | 3697212 | 2020-12-31 | US | Minnesota | Lake of the Woods | 27077 | 152 | 1 | 0 | 151 | 48.77217001 | -94.90274472 | 2021-01-01 05:23:07 | Lake of the Woods, Minnesota, US |
3696123 | 3696123 | 2020-12-31 | US | Colorado | Ouray | 8091 | 165 | 3 | 0 | 151 | 38.14717457 | -107.7675136 | 2021-01-01 05:23:07 | Ouray, Colorado, US |
1013013 | 1013013 | 2020-12-30 | US | Puerto Rico | Arroyo | 72015 | 151 | 0 | 0 | 151 | 17.998457000000005 | -66.056546 | 2020-12-31 05:22:49 | Arroyo, Puerto Rico, US |
1010067 | 1010067 | 2020-12-30 | Cabo Verde | 11793 | 112 | 11530 | 151 | 16.5388 | -23.0418 | 2020-12-31 05:22:49 | Cabo Verde | |||
769028 | 769028 | 2020-12-29 | US | Puerto Rico | Arroyo | 72015 | 151 | 0 | 0 | 151 | 17.998457000000005 | -66.056546 | 2020-12-30 05:22:34 | Arroyo, Puerto Rico, US |
766953 | 766953 | 2020-12-29 | US | Colorado | Ouray | 8091 | 163 | 3 | 0 | 151 | 38.14717457 | -107.7675136 | 2020-12-30 05:22:34 | Ouray, Colorado, US |
3764292 | 3764292 | 2020-12-28 | US | Puerto Rico | Arroyo | 72015 | 151 | 0 | 0 | 151 | 17.998457000000005 | -66.056546 | 2020-12-29 05:22:37 | Arroyo, Puerto Rico, 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]);