johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,103 rows where active = 138 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 970
- Japan 27
- Malaysia 10
- Italy 9
- Colombia 8
- India 7
- Germany 6
- United Kingdom 6
- Canada 5
- China 4
- Russia 4
- Chile 3
- Eritrea 3
- Guyana 3
- Ukraine 3
- Djibouti 2
- Equatorial Guinea 2
- Jamaica 2
- Liechtenstein 2
- Niger 2
- Rwanda 2
- Sri Lanka 2
- Thailand 2
- Australia 1
- Belize 1
- Chad 1
- Congo (Brazzaville) 1
- Congo (Kinshasa) 1
- Cyprus 1
- Estonia 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
653646 | 653646 | 2021-08-09 | Malaysia | Perlis | 834 | 13 | 683 | 138 | 6.4449 | 100.2048 | 2021-08-10 04:21:27 | Perlis, Malaysia | ||
3018982 | 3018982 | 2021-08-01 | Ukraine | Kirovohrad Oblast | 20748 | 860 | 19750 | 138 | 48.5079 | 32.2623 | 2021-08-02 04:21:36 | Kirovohrad Oblast, Ukraine | ||
3385415 | 3385415 | 2021-07-29 | Japan | Nagasaki | 3405 | 69 | 3198 | 138 | 33.235712 | 129.608033 | 2021-07-30 04:21:34 | Nagasaki, Japan | ||
1306110 | 1306110 | 2021-07-27 | India | Madhya Pradesh | 791767 | 10512 | 781117 | 138 | 23.541513 | 78.289633 | 2021-07-28 04:21:39 | Madhya Pradesh, India | ||
1378543 | 1378543 | 2021-07-25 | Japan | Shiga | 5780 | 92 | 5550 | 138 | 35.21582700000001 | 136.138064 | 2021-07-26 04:21:28 | Shiga, Japan | ||
3137471 | 3137471 | 2021-07-23 | Germany | Sachsen-Anhalt | 99396 | 3447 | 95860 | 138 | 51.9503 | 11.6923 | 2021-07-24 00:21:36 | Sachsen-Anhalt, Germany | ||
3476231 | 3476231 | 2021-07-22 | Germany | Sachsen-Anhalt | 99383 | 3447 | 95850 | 138 | 51.9503 | 11.6923 | 2021-07-23 04:21:29 | Sachsen-Anhalt, Germany | ||
578743 | 578743 | 2021-07-13 | Germany | Bremen | 27551 | 488 | 26950 | 138 | 53.0793 | 8.8017 | 2021-07-14 04:21:35 | Bremen, Germany | ||
778346 | 778346 | 2021-07-08 | Italy | Liguria | 103527 | 4352 | 99037 | 138 | 44.41149315 | 8.9326992 | 2021-07-09 04:21:21 | Liguria, Italy | ||
1715977 | 1715977 | 2021-06-25 | United Kingdom | Channel Islands | 0 | 0 | 3994 | 138 | 49.3723 | -2.3644 | 2021-06-26 04:21:43 | Channel Islands, United Kingdom | ||
3472564 | 3472564 | 2021-06-08 | Saint Lucia | 5148 | 80 | 4930 | 138 | 13.9094 | -60.9789 | 2021-06-09 04:23:31 | Saint Lucia | |||
3089410 | 3089410 | 2021-05-30 | Italy | Molise | 13586 | 491 | 12957 | 138 | 41.55774754 | 14.65916051 | 2021-05-31 03:08:59 | Molise, Italy | ||
51013 | 51013 | 2021-05-29 | Russia | Mari El Republic | 13496 | 245 | 13113 | 138 | 56.5767504 | 47.8817512 | 2021-05-30 04:20:55 | Mari El Republic, Russia | ||
1806513 | 1806513 | 2021-05-27 | Canada | New Brunswick | 2172 | 43 | 1991 | 138 | 46.5653 | -66.4619 | 2021-05-28 04:20:36 | New Brunswick, Canada | ||
1952561 | 1952561 | 2021-05-21 | Japan | Yamanashi | 1454 | 19 | 1297 | 138 | 35.612364 | 138.61148899999998 | 2021-05-22 04:20:45 | Yamanashi, Japan | ||
2255924 | 2255924 | 2021-05-19 | Russia | Chechen Republic | 12177 | 131 | 11908 | 138 | 43.39761470000001 | 45.6985005 | 2021-05-20 04:21:05 | Chechen Republic, Russia | ||
2820772 | 2820772 | 2021-05-10 | Japan | Akita | 601 | 9 | 454 | 138 | 39.748679 | 140.408228 | 2021-05-11 04:20:41 | Akita, Japan | ||
2820605 | 2820605 | 2021-05-10 | Colombia | Arauca | 6766 | 196 | 6432 | 138 | 7.0762 | -70.7105 | 2021-05-11 04:20:41 | Arauca, Colombia | ||
1425104 | 1425104 | 2021-05-09 | Japan | Akita | 596 | 9 | 449 | 138 | 39.748679 | 140.408228 | 2021-05-10 04:20:38 | Akita, Japan | ||
380460 | 380460 | 2021-04-30 | Saint Vincent and the Grenadines | 1864 | 11 | 1715 | 138 | 12.9843 | -61.2872 | 2021-05-01 04:20:47 | Saint Vincent and the Grenadines | |||
3393253 | 3393253 | 2021-04-28 | Colombia | San Andres y Providencia | 3532 | 51 | 3343 | 138 | 12.5567 | -81.7185 | 2021-04-29 04:20:55 | San Andres y Providencia, Colombia | ||
3701879 | 3701879 | 2021-04-27 | Canada | New Brunswick | 1882 | 36 | 1708 | 138 | 46.5653 | -66.4619 | 2021-04-28 04:20:32 | New Brunswick, Canada | ||
3923948 | 3923948 | 2021-04-24 | India | Andaman and Nicobar Islands | 5614 | 66 | 5410 | 138 | 11.225999 | 92.968178 | 2021-04-25 04:20:32 | Andaman and Nicobar Islands, India | ||
3242462 | 3242462 | 2021-04-21 | Niger | 5141 | 191 | 4812 | 138 | 17.607789 | 8.081666 | 2021-04-22 04:20:53 | Niger | |||
2410702 | 2410702 | 2021-04-19 | Colombia | San Andres y Providencia | 3109 | 49 | 2922 | 138 | 12.5567 | -81.7185 | 2021-04-20 04:20:41 | San Andres y Providencia, Colombia | ||
2548891 | 2548891 | 2021-04-15 | Japan | Kagawa | 1028 | 19 | 871 | 138 | 34.217292 | 133.969047 | 2021-04-16 04:20:46 | Kagawa, Japan | ||
3883724 | 3883724 | 2021-04-11 | Niger | 5074 | 189 | 4747 | 138 | 17.607789 | 8.081666 | 2021-04-12 04:21:00 | Niger | |||
2983101 | 2983101 | 2021-04-10 | Colombia | Choco | 6882 | 205 | 6539 | 138 | 5.2528 | -76.82600000000002 | 2021-04-11 04:20:56 | Choco, Colombia | ||
2645768 | 2645768 | 2021-04-08 | Japan | Iwate | 732 | 30 | 564 | 138 | 39.593287 | 141.361777 | 2021-04-09 04:21:13 | Iwate, Japan | ||
2784679 | 2784679 | 2021-03-24 | Malaysia | Terengganu | 3573 | 13 | 3422 | 138 | 5.3117 | 103.1324 | 2021-03-25 05:27:00 | Terengganu, Malaysia | ||
3421252 | 3421252 | 2021-03-19 | Timor-Leste | 252 | 0 | 114 | 138 | -8.874217 | 125.727539 | 2021-03-20 05:25:46 | Timor-Leste | |||
355974 | 355974 | 2021-03-11 | Malaysia | Pahang | 3931 | 16 | 3777 | 138 | 3.8126 | 103.3256 | 2021-03-12 05:26:50 | Pahang, Malaysia | ||
3670492 | 3670492 | 2021-03-06 | US | South Dakota | Hyde | 46069 | 139 | 1 | 0 | 138 | 44.54747703 | -99.48572582 | 2021-03-07 05:21:54 | Hyde, South Dakota, US |
3668048 | 3668048 | 2021-03-06 | US | Alaska | Petersburg | 2195 | 139 | 1 | 0 | 138 | 57.13978948 | -132.9540995 | 2021-03-07 05:21:54 | Petersburg, Alaska, US |
1619113 | 1619113 | 2021-03-05 | US | South Dakota | Hyde | 46069 | 139 | 1 | 0 | 138 | 44.54747703 | -99.48572582 | 2021-03-06 04:23:41 | Hyde, South Dakota, US |
1616669 | 1616669 | 2021-03-05 | US | Alaska | Petersburg | 2195 | 139 | 1 | 0 | 138 | 57.13978948 | -132.9540995 | 2021-03-06 04:23:41 | Petersburg, Alaska, US |
2210284 | 2210284 | 2021-03-04 | US | Oregon | Wallowa | 41063 | 143 | 5 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-03-05 05:26:29 | Wallowa, Oregon, US |
3256777 | 3256777 | 2021-03-02 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-03-03 05:23:28 | Wallowa, Oregon, US |
3254186 | 3254186 | 2021-03-02 | Japan | Tochigi | 4113 | 67 | 3908 | 138 | 36.689912 | 139.819213 | 2021-03-03 05:23:28 | Tochigi, Japan | ||
3254183 | 3254183 | 2021-03-02 | Japan | Shiga | 2481 | 47 | 2296 | 138 | 35.21582700000001 | 136.138064 | 2021-03-03 05:23:28 | Shiga, Japan | ||
1001069 | 1001069 | 2021-03-01 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-03-02 05:23:30 | Wallowa, Oregon, US |
998161 | 998161 | 2021-03-01 | Belize | 12313 | 315 | 11860 | 138 | 17.1899 | -88.4976 | 2021-03-02 05:23:30 | Belize | |||
2370127 | 2370127 | 2021-02-28 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-03-01 05:23:01 | Wallowa, Oregon, US |
3068730 | 3068730 | 2021-02-27 | US | Puerto Rico | Guanica | 72055 | 138 | 0 | 0 | 138 | 17.982429 | -66.91964300000001 | 2021-02-28 05:22:20 | Guanica, Puerto Rico, US |
3068629 | 3068629 | 2021-02-27 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-02-28 05:22:20 | Wallowa, Oregon, US |
2186314 | 2186314 | 2021-02-26 | US | Puerto Rico | Guanica | 72055 | 138 | 0 | 0 | 138 | 17.982429 | -66.91964300000001 | 2021-02-27 05:22:28 | Guanica, Puerto Rico, US |
2186213 | 2186213 | 2021-02-26 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-02-27 05:22:28 | Wallowa, Oregon, US |
1860736 | 1860736 | 2021-02-25 | US | Puerto Rico | Guanica | 72055 | 138 | 0 | 0 | 138 | 17.982429 | -66.91964300000001 | 2021-02-26 05:22:40 | Guanica, Puerto Rico, US |
1860635 | 1860635 | 2021-02-25 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-02-26 05:22:40 | Wallowa, Oregon, US |
282914 | 282914 | 2021-02-24 | US | Puerto Rico | Guanica | 72055 | 138 | 0 | 0 | 138 | 17.982429 | -66.91964300000001 | 2021-02-25 05:24:57 | Guanica, Puerto Rico, US |
282813 | 282813 | 2021-02-24 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-02-25 05:24:57 | Wallowa, Oregon, US |
1939182 | 1939182 | 2021-02-23 | US | Puerto Rico | Guanica | 72055 | 138 | 0 | 0 | 138 | 17.982429 | -66.91964300000001 | 2021-02-24 05:29:16 | Guanica, Puerto Rico, US |
1939081 | 1939081 | 2021-02-23 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-02-24 05:29:16 | Wallowa, Oregon, US |
533437 | 533437 | 2021-02-22 | US | Puerto Rico | Guanica | 72055 | 138 | 0 | 0 | 138 | 17.982429 | -66.91964300000001 | 2021-02-23 05:23:41 | Guanica, Puerto Rico, US |
533336 | 533336 | 2021-02-22 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-02-23 05:23:41 | Wallowa, Oregon, US |
532347 | 532347 | 2021-02-22 | US | Michigan | Keweenaw | 26083 | 140 | 2 | 0 | 138 | 47.63197653 | -88.41434263 | 2021-02-23 05:23:41 | Keweenaw, Michigan, US |
530513 | 530513 | 2021-02-22 | China | Hebei | 1317 | 7 | 1172 | 138 | 37.8957 | 114.9042 | 2021-02-23 05:23:41 | Hebei, China | ||
184771 | 184771 | 2021-02-21 | US | Puerto Rico | Guanica | 72055 | 138 | 0 | 0 | 138 | 17.982429 | -66.91964300000001 | 2021-02-22 05:24:21 | Guanica, Puerto Rico, US |
184670 | 184670 | 2021-02-21 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-02-22 05:24:21 | Wallowa, Oregon, US |
182375 | 182375 | 2021-02-21 | Trinidad and Tobago | 7680 | 139 | 7403 | 138 | 10.6918 | -61.2225 | 2021-02-22 05:24:21 | Trinidad and Tobago | |||
745045 | 745045 | 2021-02-20 | US | Puerto Rico | Guanica | 72055 | 138 | 0 | 0 | 138 | 17.982429 | -66.91964300000001 | 2021-02-21 05:24:33 | Guanica, Puerto Rico, US |
744944 | 744944 | 2021-02-20 | US | Oregon | Wallowa | 41063 | 142 | 4 | 0 | 138 | 45.57894064 | -117.18353799999998 | 2021-02-21 05:24:33 | Wallowa, Oregon, US |
3052155 | 3052155 | 2021-02-16 | US | Montana | Carter | 30011 | 143 | 5 | 0 | 138 | 45.5197966 | -104.5395536 | 2021-02-17 05:23:10 | Carter, Montana, US |
1340254 | 1340254 | 2021-02-15 | US | Montana | Carter | 30011 | 143 | 5 | 0 | 138 | 45.5197966 | -104.5395536 | 2021-02-16 05:24:38 | Carter, Montana, US |
1338272 | 1338272 | 2021-02-15 | Italy | Valle d'Aosta | 7918 | 413 | 7367 | 138 | 45.73750286 | 7.320149366 | 2021-02-16 05:24:38 | Valle d'Aosta, Italy | ||
2285405 | 2285405 | 2021-02-14 | US | Montana | Carter | 30011 | 143 | 5 | 0 | 138 | 45.5197966 | -104.5395536 | 2021-02-15 05:24:49 | Carter, Montana, US |
2285398 | 2285398 | 2021-02-14 | US | Missouri | Worth | 29227 | 139 | 1 | 0 | 138 | 40.47945588 | -94.42328751 | 2021-02-15 05:24:49 | Worth, Missouri, US |
2283452 | 2283452 | 2021-02-14 | Japan | Nagasaki | 1585 | 35 | 1412 | 138 | 33.235712 | 129.608033 | 2021-02-15 05:24:49 | Nagasaki, Japan | ||
2679805 | 2679805 | 2021-02-13 | US | Montana | Carter | 30011 | 143 | 5 | 0 | 138 | 45.5197966 | -104.5395536 | 2021-02-14 05:23:43 | Carter, Montana, US |
2679798 | 2679798 | 2021-02-13 | US | Missouri | Worth | 29227 | 139 | 1 | 0 | 138 | 40.47945588 | -94.42328751 | 2021-02-14 05:23:43 | Worth, Missouri, US |
2677852 | 2677852 | 2021-02-13 | Japan | Nagasaki | 1585 | 35 | 1412 | 138 | 33.235712 | 129.608033 | 2021-02-14 05:23:43 | Nagasaki, Japan | ||
2677833 | 2677833 | 2021-02-13 | Japan | Fukushima | 1827 | 63 | 1626 | 138 | 37.378867 | 140.223295 | 2021-02-14 05:23:43 | Fukushima, Japan | ||
3541438 | 3541438 | 2021-02-12 | US | Montana | Carter | 30011 | 143 | 5 | 0 | 138 | 45.5197966 | -104.5395536 | 2021-02-13 05:22:12 | Carter, Montana, US |
3541431 | 3541431 | 2021-02-12 | US | Missouri | Worth | 29227 | 139 | 1 | 0 | 138 | 40.47945588 | -94.42328751 | 2021-02-13 05:22:12 | Worth, Missouri, US |
2639694 | 2639694 | 2021-02-11 | US | Missouri | Worth | 29227 | 139 | 1 | 0 | 138 | 40.47945588 | -94.42328751 | 2021-02-12 05:23:29 | Worth, Missouri, US |
3980549 | 3980549 | 2021-02-10 | US | Missouri | Worth | 29227 | 139 | 1 | 0 | 138 | 40.47945588 | -94.42328751 | 2021-02-11 05:23:55 | Worth, Missouri, US |
1529869 | 1529869 | 2021-02-09 | US | Missouri | Worth | 29227 | 139 | 1 | 0 | 138 | 40.47945588 | -94.42328751 | 2021-02-10 05:22:41 | Worth, Missouri, US |
615660 | 615660 | 2021-02-08 | US | Missouri | Worth | 29227 | 139 | 1 | 0 | 138 | 40.47945588 | -94.42328751 | 2021-02-09 05:23:30 | Worth, Missouri, US |
613712 | 613712 | 2021-02-08 | Japan | Miyazaki | 1879 | 20 | 1721 | 138 | 32.193203999999994 | 131.299374 | 2021-02-09 05:23:30 | Miyazaki, Japan | ||
1672486 | 1672486 | 2021-02-07 | Japan | Oita | 1226 | 18 | 1070 | 138 | 33.200697 | 131.43323999999998 | 2021-02-08 05:22:39 | Oita, Japan | ||
1672481 | 1672481 | 2021-02-07 | Japan | Miyazaki | 1879 | 20 | 1721 | 138 | 32.193203999999994 | 131.299374 | 2021-02-08 05:22:39 | Miyazaki, Japan | ||
340300 | 340300 | 2021-02-03 | Japan | Nagano | 2314 | 38 | 2138 | 138 | 36.132134 | 138.045528 | 2021-02-04 05:22:26 | Nagano, Japan | ||
1686567 | 1686567 | 2021-02-02 | US | Nebraska | Garfield | 31071 | 141 | 3 | 0 | 138 | 41.91428955 | -98.99111827 | 2021-02-03 05:22:52 | Garfield, Nebraska, US |
1684458 | 1684458 | 2021-02-02 | India | Manipur | 29077 | 371 | 28568 | 138 | 24.738975 | 93.882541 | 2021-02-03 05:22:52 | Manipur, India | ||
1678537 | 1678537 | 2021-02-01 | US | Nebraska | Garfield | 31071 | 141 | 3 | 0 | 138 | 41.91428955 | -98.99111827 | 2021-02-02 05:22:49 | Garfield, Nebraska, US |
1676697 | 1676697 | 2021-02-01 | Russia | Nenets Autonomous Okrug | 920 | 0 | 782 | 138 | 68.27557185 | 57.1686375 | 2021-02-02 05:22:49 | Nenets Autonomous Okrug, Russia | ||
1676533 | 1676533 | 2021-02-01 | Liechtenstein | 2567 | 53 | 2376 | 138 | 47.14 | 9.55 | 2021-02-02 05:22:49 | Liechtenstein | |||
1899220 | 1899220 | 2021-01-29 | US | Nebraska | Garfield | 31071 | 141 | 3 | 0 | 138 | 41.91428955 | -98.99111827 | 2021-01-30 05:22:49 | Garfield, Nebraska, US |
2484164 | 2484164 | 2021-01-28 | US | New Mexico | Mora | 35033 | 144 | 6 | 0 | 138 | 36.01095101 | -104.9497716 | 2021-01-29 05:22:23 | Mora, New Mexico, US |
2484036 | 2484036 | 2021-01-28 | US | Nebraska | Garfield | 31071 | 141 | 3 | 0 | 138 | 41.91428955 | -98.99111827 | 2021-01-29 05:22:23 | Garfield, Nebraska, US |
2481855 | 2481855 | 2021-01-28 | Equatorial Guinea | 5492 | 86 | 5268 | 138 | 1.6508 | 10.2679 | 2021-01-29 05:22:23 | Equatorial Guinea | |||
3155799 | 3155799 | 2021-01-27 | US | New Mexico | Mora | 35033 | 144 | 6 | 0 | 138 | 36.01095101 | -104.9497716 | 2021-01-28 05:22:24 | Mora, New Mexico, US |
3155671 | 3155671 | 2021-01-27 | US | Nebraska | Garfield | 31071 | 141 | 3 | 0 | 138 | 41.91428955 | -98.99111827 | 2021-01-28 05:22:24 | Garfield, Nebraska, US |
3154460 | 3154460 | 2021-01-27 | US | Georgia | Quitman | 13239 | 139 | 1 | 0 | 138 | 31.86728114 | -85.01773177 | 2021-01-28 05:22:24 | Quitman, Georgia, US |
3153490 | 3153490 | 2021-01-27 | Equatorial Guinea | 5492 | 86 | 5268 | 138 | 1.6508 | 10.2679 | 2021-01-28 05:22:24 | Equatorial Guinea | |||
2569730 | 2569730 | 2021-01-25 | US | Nebraska | Garfield | 31071 | 141 | 3 | 0 | 138 | 41.91428955 | -98.99111827 | 2021-01-26 05:22:02 | Garfield, Nebraska, US |
2569723 | 2569723 | 2021-01-25 | US | Nebraska | Dundy | 31057 | 142 | 4 | 0 | 138 | 40.17638677 | -101.6876522 | 2021-01-26 05:22:02 | Dundy, Nebraska, US |
1761490 | 1761490 | 2021-01-24 | US | New Mexico | Mora | 35033 | 143 | 5 | 0 | 138 | 36.01095101 | -104.9497716 | 2021-01-25 05:22:16 | Mora, New Mexico, US |
1761355 | 1761355 | 2021-01-24 | US | Nebraska | Dundy | 31057 | 142 | 4 | 0 | 138 | 40.17638677 | -101.6876522 | 2021-01-25 05:22:16 | Dundy, Nebraska, US |
1759329 | 1759329 | 2021-01-24 | Japan | Port Quarantine | 2130 | 1 | 1991 | 138 | 2021-01-25 05:22:16 | Port Quarantine, Japan |
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]);