johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
872 rows where active = 197 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 768
- Japan 17
- Colombia 8
- Italy 8
- India 7
- Russia 6
- Malaysia 5
- Ukraine 5
- Chile 4
- Cote d'Ivoire 4
- Mexico 4
- Germany 3
- Latvia 3
- Cuba 2
- Eswatini 2
- France 2
- Jordan 2
- San Marino 2
- Sao Tome and Principe 2
- United Kingdom 2
- Burkina Faso 1
- China 1
- Costa Rica 1
- Eritrea 1
- Guinea 1
- Guinea-Bissau 1
- Iceland 1
- Liechtenstein 1
- Maldives 1
- North Macedonia 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683477 | 3683477 | 2021-08-02 | Japan | Nagasaki | 3506 | 69 | 3240 | 197 | 33.235712 | 129.608033 | 2021-08-03 04:21:39 | Nagasaki, Japan | ||
3015393 | 3015393 | 2021-08-01 | Japan | Toyama | 2307 | 38 | 2072 | 197 | 36.637464 | 137.26934599999998 | 2021-08-02 04:21:36 | Toyama, Japan | ||
1306188 | 1306188 | 2021-07-27 | Japan | Port Quarantine | 3459 | 5 | 3258 | 197 | 2021-07-28 04:21:39 | Port Quarantine, Japan | ||||
3137462 | 3137462 | 2021-07-23 | Germany | Bremen | 27680 | 492 | 27030 | 197 | 53.0793 | 8.8017 | 2021-07-24 00:21:36 | Bremen, Germany | ||
3331520 | 3331520 | 2021-07-21 | Italy | P.A. Trento | 46036 | 1363 | 44476 | 197 | 46.06893511 | 11.12123097 | 2021-07-22 04:21:19 | P.A. Trento, Italy | ||
2677450 | 2677450 | 2021-07-18 | Ukraine | Poltava Oblast | 78104 | 1868 | 76039 | 197 | 49.5883 | 34.5514 | 2021-07-19 04:21:24 | Poltava Oblast, Ukraine | ||
578971 | 578971 | 2021-07-13 | North Macedonia | 155823 | 5487 | 150139 | 197 | 41.6086 | 21.7453 | 2021-07-14 04:21:35 | North Macedonia | |||
3663227 | 3663227 | 2021-07-11 | Ukraine | Luhansk Oblast | 26730 | 954 | 25579 | 197 | 48.574 | 39.3078 | 2021-07-12 04:21:34 | Luhansk Oblast, Ukraine | ||
1444271 | 1444271 | 2021-07-07 | Malaysia | W.P. Putrajaya | 2447 | 14 | 2236 | 197 | 2.9264 | 101.6964 | 2021-07-08 04:21:26 | W.P. Putrajaya, Malaysia | ||
1440566 | 1440566 | 2021-07-07 | Italy | Friuli Venezia Giulia | 107033 | 3789 | 103047 | 197 | 45.6494354 | 13.76813649 | 2021-07-08 04:21:26 | Friuli Venezia Giulia, Italy | ||
2075555 | 2075555 | 2021-07-02 | Ukraine | Rivne Oblast | 79507 | 1205 | 78105 | 197 | 50.6199 | 26.2516 | 2021-07-03 04:21:37 | Rivne Oblast, Ukraine | ||
563166 | 563166 | 2021-06-22 | Russia | Ingushetia Republic | 16019 | 190 | 15632 | 197 | 43.11542075 | 45.01713552 | 2021-06-23 04:21:46 | Ingushetia Republic, Russia | ||
107487 | 107487 | 2021-06-19 | Japan | Shiga | 5485 | 88 | 5200 | 197 | 35.21582700000001 | 136.138064 | 2021-06-20 04:21:48 | Shiga, Japan | ||
2911101 | 2911101 | 2021-06-17 | Guinea-Bissau | 3819 | 69 | 3553 | 197 | 11.8037 | -15.1804 | 2021-06-18 04:22:16 | Guinea-Bissau | |||
1564427 | 1564427 | 2021-06-14 | Togo | 13631 | 126 | 13308 | 197 | 8.6195 | 0.8248 | 2021-06-15 04:22:22 | Togo | |||
3970420 | 3970420 | 2021-06-11 | Cote d'Ivoire | 47638 | 306 | 47135 | 197 | 7.54 | -5.5471 | 2021-06-12 04:22:22 | Cote d'Ivoire | |||
3145787 | 3145787 | 2021-06-07 | Russia | Karachay-Cherkess Republic | 20534 | 149 | 20188 | 197 | 43.7368326 | 41.7267991 | 2021-06-08 04:22:35 | Karachay-Cherkess Republic, Russia | ||
2586194 | 2586194 | 2021-06-05 | Russia | Karachay-Cherkess Republic | 20509 | 145 | 20167 | 197 | 43.7368326 | 41.7267991 | 2021-06-06 04:24:03 | Karachay-Cherkess Republic, Russia | ||
1806761 | 1806761 | 2021-05-27 | Japan | Kagawa | 1975 | 24 | 1754 | 197 | 34.217292 | 133.969047 | 2021-05-28 04:20:36 | Kagawa, Japan | ||
1413102 | 1413102 | 2021-05-24 | Japan | Wakayama | 2567 | 40 | 2330 | 197 | 33.911879 | 135.505446 | 2021-05-25 04:21:08 | Wakayama, Japan | ||
1413045 | 1413045 | 2021-05-24 | Italy | Molise | 13551 | 488 | 12866 | 197 | 41.55774754 | 14.65916051 | 2021-05-25 04:21:08 | Molise, Italy | ||
1636156 | 1636156 | 2021-04-29 | Colombia | Caqueta | 17473 | 655 | 16621 | 197 | 0.8699 | -73.8419 | 2021-04-30 04:21:03 | Caqueta, Colombia | ||
2020992 | 2020992 | 2021-04-20 | San Marino | 5040 | 88 | 4755 | 197 | 43.9424 | 12.4578 | 2021-04-21 04:21:14 | San Marino | |||
2020609 | 2020609 | 2021-04-20 | Eritrea | 3548 | 10 | 3341 | 197 | 15.1794 | 39.7823 | 2021-04-21 04:21:14 | Eritrea | |||
3085140 | 3085140 | 2021-04-05 | Colombia | Caqueta | 17207 | 651 | 16359 | 197 | 0.8699 | -73.8419 | 2021-04-06 04:20:32 | Caqueta, Colombia | ||
388414 | 388414 | 2021-04-04 | Russia | Chechen Republic | 11704 | 117 | 11390 | 197 | 43.39761470000001 | 45.6985005 | 2021-04-05 04:20:35 | Chechen Republic, Russia | ||
244907 | 244907 | 2021-04-02 | United Kingdom | Isle of Man | 1570 | 29 | 1344 | 197 | 54.2361 | -4.5481 | 2021-04-03 04:20:44 | Isle of Man, United Kingdom | ||
1535685 | 1535685 | 2021-03-28 | Burkina Faso | 12692 | 145 | 12350 | 197 | 12.2383 | -1.5616 | 2021-03-29 04:28:35 | Burkina Faso | |||
1219751 | 1219751 | 2021-03-27 | Russia | Altai Republic | 16631 | 187 | 16247 | 197 | 50.7114101 | 86.8572186 | 2021-03-28 05:28:10 | Altai Republic, Russia | ||
2780834 | 2780834 | 2021-03-24 | Colombia | Caqueta | 17148 | 646 | 16305 | 197 | 0.8699 | -73.8419 | 2021-03-25 05:27:00 | Caqueta, Colombia | ||
1798479 | 1798479 | 2021-03-23 | Colombia | Caqueta | 17146 | 646 | 16303 | 197 | 0.8699 | -73.8419 | 2021-03-24 05:25:40 | Caqueta, Colombia | ||
2055904 | 2055904 | 2021-03-15 | Japan | Kyoto | 9202 | 164 | 8841 | 197 | 35.253815 | 135.443341 | 2021-03-16 05:25:13 | Kyoto, Japan | ||
3670332 | 3670332 | 2021-03-06 | US | Puerto Rico | Arroyo | 72015 | 197 | 0 | 0 | 197 | 17.998457000000005 | -66.056546 | 2021-03-07 05:21:54 | Arroyo, Puerto Rico, US |
1619407 | 1619407 | 2021-03-05 | US | Texas | Menard | 48327 | 196 | 9 | 0 | 197 | 30.88990665 | -99.8204794 | 2021-03-06 04:23:41 | Menard, Texas, US |
1618953 | 1618953 | 2021-03-05 | US | Puerto Rico | Arroyo | 72015 | 197 | 0 | 0 | 197 | 17.998457000000005 | -66.056546 | 2021-03-06 04:23:41 | Arroyo, Puerto Rico, US |
1618774 | 1618774 | 2021-03-05 | US | Oklahoma | Cimarron | 40025 | 198 | 1 | 0 | 197 | 36.74817177 | -102.5173885 | 2021-03-06 04:23:41 | Cimarron, Oklahoma, US |
2210818 | 2210818 | 2021-03-04 | US | Texas | Menard | 48327 | 196 | 9 | 0 | 197 | 30.88990665 | -99.8204794 | 2021-03-05 05:26:29 | Menard, Texas, US |
2210364 | 2210364 | 2021-03-04 | US | Puerto Rico | Arroyo | 72015 | 197 | 0 | 0 | 197 | 17.998457000000005 | -66.056546 | 2021-03-05 05:26:29 | Arroyo, Puerto Rico, US |
2210185 | 2210185 | 2021-03-04 | US | Oklahoma | Cimarron | 40025 | 198 | 1 | 0 | 197 | 36.74817177 | -102.5173885 | 2021-03-05 05:26:29 | Cimarron, Oklahoma, US |
1093239 | 1093239 | 2021-03-03 | US | Texas | Menard | 48327 | 196 | 9 | 0 | 197 | 30.88990665 | -99.8204794 | 2021-03-04 05:24:24 | Menard, Texas, US |
1092785 | 1092785 | 2021-03-03 | US | Puerto Rico | Arroyo | 72015 | 197 | 0 | 0 | 197 | 17.998457000000005 | -66.056546 | 2021-03-04 05:24:24 | Arroyo, Puerto Rico, US |
3256857 | 3256857 | 2021-03-02 | US | Puerto Rico | Arroyo | 72015 | 197 | 0 | 0 | 197 | 17.998457000000005 | -66.056546 | 2021-03-03 05:23:28 | Arroyo, Puerto Rico, US |
1001149 | 1001149 | 2021-03-01 | US | Puerto Rico | Arroyo | 72015 | 197 | 0 | 0 | 197 | 17.998457000000005 | -66.056546 | 2021-03-02 05:23:30 | Arroyo, Puerto Rico, US |
3065961 | 3065961 | 2021-02-27 | India | Puducherry | 39717 | 668 | 38852 | 197 | 11.882658 | 78.86498 | 2021-02-28 05:22:20 | Puducherry, India | ||
1858922 | 1858922 | 2021-02-25 | US | Idaho | Butte | 16023 | 198 | 1 | 0 | 197 | 43.72592209 | -113.1735463 | 2021-02-26 05:22:40 | Butte, Idaho, US |
281100 | 281100 | 2021-02-24 | US | Idaho | Butte | 16023 | 198 | 1 | 0 | 197 | 43.72592209 | -113.1735463 | 2021-02-25 05:24:57 | Butte, Idaho, US |
1937368 | 1937368 | 2021-02-23 | US | Idaho | Butte | 16023 | 198 | 1 | 0 | 197 | 43.72592209 | -113.1735463 | 2021-02-24 05:29:16 | Butte, Idaho, US |
745478 | 745478 | 2021-02-20 | US | Texas | Menard | 48327 | 194 | 7 | 0 | 197 | 30.88990665 | -99.8204794 | 2021-02-21 05:24:33 | Menard, Texas, US |
474576 | 474576 | 2021-02-19 | US | Texas | Menard | 48327 | 194 | 7 | 0 | 197 | 30.88990665 | -99.8204794 | 2021-02-20 05:22:51 | Menard, Texas, US |
1156285 | 1156285 | 2021-02-18 | US | Texas | Menard | 48327 | 194 | 7 | 0 | 197 | 30.88990665 | -99.8204794 | 2021-02-19 05:24:16 | Menard, Texas, US |
3604205 | 3604205 | 2021-02-17 | US | Texas | Menard | 48327 | 194 | 7 | 0 | 197 | 30.88990665 | -99.8204794 | 2021-02-18 05:22:58 | Menard, Texas, US |
3542888 | 3542888 | 2021-02-12 | US | Washington | Ferry | 53019 | 201 | 4 | 0 | 197 | 48.471143100000006 | -118.5154041 | 2021-02-13 05:22:12 | Ferry, Washington, US |
2641151 | 2641151 | 2021-02-11 | US | Washington | Ferry | 53019 | 201 | 4 | 0 | 197 | 48.471143100000006 | -118.5154041 | 2021-02-12 05:23:29 | Ferry, Washington, US |
2637758 | 2637758 | 2021-02-11 | Japan | Shiga | 2284 | 35 | 2052 | 197 | 35.21582700000001 | 136.138064 | 2021-02-12 05:23:29 | Shiga, Japan | ||
3982006 | 3982006 | 2021-02-10 | US | Washington | Ferry | 53019 | 201 | 4 | 0 | 197 | 48.471143100000006 | -118.5154041 | 2021-02-11 05:23:55 | Ferry, Washington, US |
3978607 | 3978607 | 2021-02-10 | Japan | Okayama | 2422 | 26 | 2199 | 197 | 34.89246 | 133.826252 | 2021-02-11 05:23:55 | Okayama, Japan | ||
1531326 | 1531326 | 2021-02-09 | US | Washington | Ferry | 53019 | 201 | 4 | 0 | 197 | 48.471143100000006 | -118.5154041 | 2021-02-10 05:22:41 | Ferry, Washington, US |
1528173 | 1528173 | 2021-02-09 | Singapore | 59732 | 29 | 59506 | 197 | 1.2833 | 103.8333 | 2021-02-10 05:22:41 | Singapore | |||
617117 | 617117 | 2021-02-08 | US | Washington | Ferry | 53019 | 201 | 4 | 0 | 197 | 48.471143100000006 | -118.5154041 | 2021-02-09 05:23:30 | Ferry, Washington, US |
1675886 | 1675886 | 2021-02-07 | US | Washington | Ferry | 53019 | 201 | 4 | 0 | 197 | 48.471143100000006 | -118.5154041 | 2021-02-08 05:22:39 | Ferry, Washington, US |
1672291 | 1672291 | 2021-02-07 | Colombia | Arauca | 5448 | 158 | 5093 | 197 | 7.0762 | -70.7105 | 2021-02-08 05:22:39 | Arauca, Colombia | ||
978347 | 978347 | 2021-02-06 | US | Washington | Ferry | 53019 | 201 | 4 | 0 | 197 | 48.471143100000006 | -118.5154041 | 2021-02-07 05:23:00 | Ferry, Washington, US |
1591605 | 1591605 | 2021-02-05 | US | Washington | Ferry | 53019 | 201 | 4 | 0 | 197 | 48.471143100000006 | -118.5154041 | 2021-02-06 05:23:55 | Ferry, Washington, US |
793812 | 793812 | 2021-02-04 | US | Washington | Ferry | 53019 | 201 | 4 | 0 | 197 | 48.471143100000006 | -118.5154041 | 2021-02-05 05:22:38 | Ferry, Washington, US |
1687681 | 1687681 | 2021-02-02 | US | Texas | Oldham | 48359 | 257 | 3 | 0 | 197 | 35.40425596 | -102.6027606 | 2021-02-03 05:22:52 | Oldham, Texas, US |
1676741 | 1676741 | 2021-02-01 | Sao Tome and Principe | 1259 | 17 | 1045 | 197 | 0.1864 | 6.6131 | 2021-02-02 05:22:49 | Sao Tome and Principe | |||
2211696 | 2211696 | 2021-01-30 | Japan | Oita | 1145 | 17 | 931 | 197 | 33.200697 | 131.43323999999998 | 2021-01-31 05:22:42 | Oita, Japan | ||
3153875 | 3153875 | 2021-01-27 | Sao Tome and Principe | 1221 | 17 | 1007 | 197 | 0.1864 | 6.6131 | 2021-01-28 05:22:24 | Sao Tome and Principe | |||
12374 | 12374 | 2021-01-26 | Japan | Saga | 924 | 4 | 723 | 197 | 33.286977 | 130.115738 | 2021-01-27 05:23:41 | Saga, Japan | ||
2569388 | 2569388 | 2021-01-25 | US | Minnesota | Lake of the Woods | 27077 | 198 | 1 | 0 | 197 | 48.77217001 | -94.90274472 | 2021-01-26 05:22:02 | Lake of the Woods, Minnesota, US |
1760581 | 1760581 | 2021-01-24 | US | Kansas | Hamilton | 20075 | 197 | 0 | 0 | 197 | 37.99978709 | -101.7921066 | 2021-01-25 05:22:16 | Hamilton, Kansas, US |
2428188 | 2428188 | 2021-01-23 | US | Kansas | Hamilton | 20075 | 197 | 0 | 0 | 197 | 37.99978709 | -101.7921066 | 2021-01-24 05:22:35 | Hamilton, Kansas, US |
2468090 | 2468090 | 2021-01-22 | US | Kansas | Hamilton | 20075 | 197 | 0 | 0 | 197 | 37.99978709 | -101.7921066 | 2021-01-23 05:22:03 | Hamilton, Kansas, US |
2466762 | 2466762 | 2021-01-22 | India | Manipur | 28953 | 369 | 28387 | 197 | 24.738975 | 93.882541 | 2021-01-23 05:22:03 | Manipur, India | ||
436641 | 436641 | 2021-01-21 | US | Kansas | Hamilton | 20075 | 197 | 0 | 0 | 197 | 37.99978709 | -101.7921066 | 2021-01-22 05:22:10 | Hamilton, Kansas, US |
1095372 | 1095372 | 2021-01-20 | US | Kansas | Hamilton | 20075 | 197 | 0 | 0 | 197 | 37.99978709 | -101.7921066 | 2021-01-21 05:22:01 | Hamilton, Kansas, US |
3518463 | 3518463 | 2021-01-15 | US | Texas | Delta | 48119 | 837 | 5 | 0 | 197 | 33.38570922 | -95.66921122 | 2021-01-16 05:22:40 | Delta, Texas, US |
3518167 | 3518167 | 2021-01-15 | US | Puerto Rico | Sabana Grande | 72121 | 197 | 0 | 0 | 197 | 18.08282 | -66.943758 | 2021-01-16 05:22:40 | Sabana Grande, Puerto Rico, US |
3517049 | 3517049 | 2021-01-15 | US | Michigan | Luce | 26095 | 197 | 0 | 0 | 197 | 46.47227431 | -85.54471223 | 2021-01-16 05:22:40 | Luce, Michigan, US |
3881782 | 3881782 | 2021-01-14 | US | New Mexico | Union | 35059 | 204 | 7 | 0 | 197 | 36.48126404 | -103.4709624 | 2021-01-15 05:22:24 | Union, New Mexico, US |
3881221 | 3881221 | 2021-01-14 | US | Michigan | Luce | 26095 | 197 | 0 | 0 | 197 | 46.47227431 | -85.54471223 | 2021-01-15 05:22:24 | Luce, Michigan, US |
3310409 | 3310409 | 2021-01-13 | US | New Mexico | Union | 35059 | 204 | 7 | 0 | 197 | 36.48126404 | -103.4709624 | 2021-01-14 05:22:32 | Union, New Mexico, US |
3309848 | 3309848 | 2021-01-13 | US | Michigan | Luce | 26095 | 197 | 0 | 0 | 197 | 46.47227431 | -85.54471223 | 2021-01-14 05:22:32 | Luce, Michigan, US |
3308968 | 3308968 | 2021-01-13 | US | Georgia | Clay | 13061 | 200 | 3 | 0 | 197 | 31.62221166 | -84.97713865 | 2021-01-14 05:22:32 | Clay, Georgia, US |
777415 | 777415 | 2021-01-12 | US | Texas | Edwards | 48137 | 215 | 3 | 0 | 197 | 29.98202582 | -100.304252 | 2021-01-13 05:22:15 | Edwards, Texas, US |
775113 | 775113 | 2021-01-12 | US | Georgia | Clay | 13061 | 200 | 3 | 0 | 197 | 31.62221166 | -84.97713865 | 2021-01-13 05:22:15 | Clay, Georgia, US |
193136 | 193136 | 2021-01-11 | US | Texas | Edwards | 48137 | 215 | 3 | 0 | 197 | 29.98202582 | -100.304252 | 2021-01-12 05:22:15 | Edwards, Texas, US |
192071 | 192071 | 2021-01-11 | US | Montana | Mineral | 30061 | 197 | 0 | 0 | 197 | 47.15283992 | -115.0015239 | 2021-01-12 05:22:15 | Mineral, Montana, US |
190117 | 190117 | 2021-01-11 | Japan | Yamanashi | 754 | 11 | 546 | 197 | 35.612364 | 138.61148899999998 | 2021-01-12 05:22:15 | Yamanashi, Japan | ||
189903 | 189903 | 2021-01-11 | Colombia | Arauca | 4776 | 137 | 4442 | 197 | 7.0762 | -70.7105 | 2021-01-12 05:22:15 | Arauca, Colombia | ||
2628939 | 2628939 | 2021-01-10 | US | Texas | Edwards | 48137 | 215 | 3 | 0 | 197 | 29.98202582 | -100.304252 | 2021-01-11 05:21:50 | Edwards, Texas, US |
2627874 | 2627874 | 2021-01-10 | US | Montana | Mineral | 30061 | 197 | 0 | 0 | 197 | 47.15283992 | -115.0015239 | 2021-01-11 05:21:50 | Mineral, Montana, US |
2625825 | 2625825 | 2021-01-10 | India | Ladakh | 9618 | 127 | 9294 | 197 | 34.1526 | 77.5771 | 2021-01-11 05:21:50 | Ladakh, India | ||
3903027 | 3903027 | 2021-01-09 | US | Texas | Edwards | 48137 | 215 | 3 | 0 | 197 | 29.98202582 | -100.304252 | 2021-01-10 05:22:12 | Edwards, Texas, US |
2542663 | 2542663 | 2021-01-07 | US | Kansas | Chautauqua | 20019 | 200 | 3 | 0 | 197 | 37.14994405 | -96.2454192 | 2021-01-08 05:22:42 | Chautauqua, Kansas, US |
2865972 | 2865972 | 2021-01-06 | US | Kansas | Chautauqua | 20019 | 200 | 3 | 0 | 197 | 37.14994405 | -96.2454192 | 2021-01-07 05:22:03 | Chautauqua, Kansas, US |
1064462 | 1064462 | 2021-01-04 | US | Oregon | Lake | 41037 | 201 | 4 | 0 | 197 | 42.79246693 | -120.3850163 | 2021-01-05 05:21:49 | Lake, Oregon, US |
3231042 | 3231042 | 2021-01-03 | US | Colorado | Baca | 8009 | 212 | 2 | 0 | 197 | 37.31940883 | -102.5603223 | 2021-01-04 05:22:02 | Baca, Colorado, US |
2231193 | 2231193 | 2021-01-02 | Malaysia | Kedah | 3091 | 12 | 2882 | 197 | 6.1184 | 100.3685 | 2021-01-03 05:22:52 | Kedah, Malaysia | ||
1012253 | 1012253 | 2020-12-30 | US | Missouri | Schuyler | 29197 | 198 | 1 | 0 | 197 | 40.46921489 | -92.52311943 | 2020-12-31 05:22:49 | Schuyler, Missouri, 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]);