johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
502 rows where deaths = 566 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 353
- Sweden 50
- Russia 24
- Spain 10
- Japan 9
- Ukraine 6
- Fiji 5
- Chile 4
- Cameroon 3
- Canada 3
- Mexico 3
- Netherlands 3
- Peru 3
- Germany 2
- Haiti 2
- India 2
- Sri Lanka 2
- Azerbaijan 1
- Bahrain 1
- Belize 1
- Burma 1
- Colombia 1
- Congo (Kinshasa) 1
- Cote d'Ivoire 1
- Georgia 1
- Italy 1
- Jamaica 1
- Luxembourg 1
- Malaysia 1
- Montenegro 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754823 | 2754823 | 2022-12-29 | US | Missouri | Jasper | 29097 | 39777 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-30 04:21:04 | Jasper, Missouri, US | |
2753395 | 2753395 | 2022-12-29 | US | Arkansas | Garland | 5051 | 26593 | 566 | 0 | 34.57692074 | -93.14921604 | 2022-12-30 04:21:04 | Garland, Arkansas, US | |
1075829 | 1075829 | 2022-12-28 | US | Missouri | Jasper | 29097 | 39777 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-29 04:21:01 | Jasper, Missouri, US | |
1074401 | 1074401 | 2022-12-28 | US | Arkansas | Garland | 5051 | 26593 | 566 | 0 | 34.57692074 | -93.14921604 | 2022-12-29 04:21:01 | Garland, Arkansas, US | |
329826 | 329826 | 2022-12-27 | US | Missouri | Jasper | 29097 | 39774 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-28 04:21:04 | Jasper, Missouri, US | |
328398 | 328398 | 2022-12-27 | US | Arkansas | Garland | 5051 | 26577 | 566 | 0 | 34.57692074 | -93.14921604 | 2022-12-28 04:21:04 | Garland, Arkansas, US | |
219899 | 219899 | 2022-12-26 | US | Missouri | Jasper | 29097 | 39623 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-27 04:21:07 | Jasper, Missouri, US | |
219017 | 219017 | 2022-12-26 | US | Illinois | Peoria | 17143 | 58444 | 566 | 0 | 40.78702156 | -89.76078901 | 2022-12-27 04:21:07 | Peoria, Illinois, US | |
218471 | 218471 | 2022-12-26 | US | Arkansas | Garland | 5051 | 26574 | 566 | 0 | 34.57692074 | -93.14921604 | 2022-12-27 04:21:07 | Garland, Arkansas, US | |
3224356 | 3224356 | 2022-12-25 | US | Missouri | Jasper | 29097 | 39623 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-26 04:21:06 | Jasper, Missouri, US | |
3223474 | 3223474 | 2022-12-25 | US | Illinois | Peoria | 17143 | 58444 | 566 | 0 | 40.78702156 | -89.76078901 | 2022-12-26 04:21:06 | Peoria, Illinois, US | |
3222928 | 3222928 | 2022-12-25 | US | Arkansas | Garland | 5051 | 26565 | 566 | 0 | 34.57692074 | -93.14921604 | 2022-12-26 04:21:06 | Garland, Arkansas, US | |
1020270 | 1020270 | 2022-12-24 | US | Missouri | Jasper | 29097 | 39623 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-25 04:21:04 | Jasper, Missouri, US | |
1019388 | 1019388 | 2022-12-24 | US | Illinois | Peoria | 17143 | 58444 | 566 | 0 | 40.78702156 | -89.76078901 | 2022-12-25 04:21:04 | Peoria, Illinois, US | |
1018842 | 1018842 | 2022-12-24 | US | Arkansas | Garland | 5051 | 26565 | 566 | 0 | 34.57692074 | -93.14921604 | 2022-12-25 04:21:04 | Garland, Arkansas, US | |
692293 | 692293 | 2022-12-23 | US | Missouri | Jasper | 29097 | 39623 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-24 04:21:02 | Jasper, Missouri, US | |
691411 | 691411 | 2022-12-23 | US | Illinois | Peoria | 17143 | 58444 | 566 | 0 | 40.78702156 | -89.76078901 | 2022-12-24 04:21:02 | Peoria, Illinois, US | |
690865 | 690865 | 2022-12-23 | US | Arkansas | Garland | 5051 | 26563 | 566 | 0 | 34.57692074 | -93.14921604 | 2022-12-24 04:21:02 | Garland, Arkansas, US | |
2181503 | 2181503 | 2022-12-22 | US | Missouri | Jasper | 29097 | 39623 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-23 04:21:04 | Jasper, Missouri, US | |
2180621 | 2180621 | 2022-12-22 | US | Illinois | Peoria | 17143 | 58388 | 566 | 0 | 40.78702156 | -89.76078901 | 2022-12-23 04:21:04 | Peoria, Illinois, US | |
2180075 | 2180075 | 2022-12-22 | US | Arkansas | Garland | 5051 | 26561 | 566 | 0 | 34.57692074 | -93.14921604 | 2022-12-23 04:21:04 | Garland, Arkansas, US | |
453307 | 453307 | 2022-12-21 | US | Missouri | Jasper | 29097 | 39623 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-22 04:20:56 | Jasper, Missouri, US | |
451703 | 451703 | 2022-12-21 | Sweden | Dalarna | 77225 | 566 | 0 | 61.0917 | 14.6664 | 2022-12-22 04:20:56 | Dalarna, Sweden | |||
2953306 | 2953306 | 2022-12-20 | US | Missouri | Jasper | 29097 | 39623 | 566 | 0 | 37.20351921 | -94.34050458 | 2022-12-21 04:21:03 | Jasper, Missouri, US | |
2951702 | 2951702 | 2022-12-20 | Sweden | Dalarna | 77225 | 566 | 0 | 61.0917 | 14.6664 | 2022-12-21 04:21:03 | Dalarna, Sweden | |||
3174104 | 3174104 | 2022-12-19 | Sweden | Dalarna | 77225 | 566 | 0 | 61.0917 | 14.6664 | 2022-12-20 04:21:04 | Dalarna, Sweden | |||
1628621 | 1628621 | 2022-12-18 | Sweden | Dalarna | 77225 | 566 | 0 | 61.0917 | 14.6664 | 2022-12-19 04:21:03 | Dalarna, Sweden | |||
504000 | 504000 | 2022-12-17 | Sweden | Dalarna | 77225 | 566 | 0 | 61.0917 | 14.6664 | 2022-12-18 04:21:03 | Dalarna, Sweden | |||
3324572 | 3324572 | 2022-12-16 | Sweden | Dalarna | 77225 | 566 | 0 | 61.0917 | 14.6664 | 2022-12-17 04:21:04 | Dalarna, Sweden | |||
543084 | 543084 | 2022-12-15 | Sweden | Dalarna | 77225 | 566 | 0 | 61.0917 | 14.6664 | 2022-12-16 04:21:01 | Dalarna, Sweden | |||
3714700 | 3714700 | 2022-12-06 | US | Arkansas | Sebastian | 5131 | 38142 | 566 | 0 | 35.19605503 | -94.27162713 | 2022-12-07 04:20:58 | Sebastian, Arkansas, US | |
2415405 | 2415405 | 2022-12-05 | US | Arkansas | Sebastian | 5131 | 38116 | 566 | 0 | 35.19605503 | -94.27162713 | 2022-12-06 04:21:03 | Sebastian, Arkansas, US | |
719013 | 719013 | 2022-12-04 | US | Arkansas | Sebastian | 5131 | 38108 | 566 | 0 | 35.19605503 | -94.27162713 | 2022-12-05 04:20:58 | Sebastian, Arkansas, US | |
2817302 | 2817302 | 2022-12-03 | US | Arkansas | Sebastian | 5131 | 38105 | 566 | 0 | 35.19605503 | -94.27162713 | 2022-12-04 04:20:56 | Sebastian, Arkansas, US | |
834158 | 834158 | 2022-12-02 | US | Arkansas | Sebastian | 5131 | 38083 | 566 | 0 | 35.19605503 | -94.27162713 | 2022-12-03 04:21:02 | Sebastian, Arkansas, US | |
2136688 | 2136688 | 2022-12-01 | US | Arkansas | Sebastian | 5131 | 38051 | 566 | 0 | 35.19605503 | -94.27162713 | 2022-12-02 04:21:07 | Sebastian, Arkansas, US | |
3312256 | 3312256 | 2022-11-23 | Japan | Tochigi | 270280 | 566 | 0 | 36.689912 | 139.819213 | 2022-11-24 04:21:09 | Tochigi, Japan | |||
1620297 | 1620297 | 2022-11-22 | Japan | Tochigi | 267588 | 566 | 0 | 36.689912 | 139.819213 | 2022-11-23 04:21:06 | Tochigi, Japan | |||
3598627 | 3598627 | 2022-11-14 | US | Maryland | Frederick | 24021 | 55120 | 566 | 0 | 39.47296601 | -77.39999394 | 2022-11-15 04:21:16 | Frederick, Maryland, US | |
313485 | 313485 | 2022-11-13 | US | Maryland | Frederick | 24021 | 55098 | 566 | 0 | 39.47296601 | -77.39999394 | 2022-11-14 04:21:09 | Frederick, Maryland, US | |
64646 | 64646 | 2022-11-12 | US | Maryland | Frederick | 24021 | 55098 | 566 | 0 | 39.47296601 | -77.39999394 | 2022-11-13 04:21:14 | Frederick, Maryland, US | |
2928808 | 2928808 | 2022-11-11 | US | Maryland | Frederick | 24021 | 55098 | 566 | 0 | 39.47296601 | -77.39999394 | 2022-11-12 04:20:41 | Frederick, Maryland, US | |
2507644 | 2507644 | 2022-11-10 | US | Maryland | Frederick | 24021 | 55098 | 566 | 0 | 39.47296601 | -77.39999394 | 2022-11-11 04:21:22 | Frederick, Maryland, US | |
2432519 | 2432519 | 2022-11-09 | US | Maryland | Frederick | 24021 | 55059 | 566 | 0 | 39.47296601 | -77.39999394 | 2022-11-10 04:21:16 | Frederick, Maryland, US | |
1832378 | 1832378 | 2022-10-25 | US | New York | Albany | 36001 | 74346 | 566 | 0 | 42.60060306 | -73.97723916 | 2022-10-26 04:22:19 | Albany, New York, US | |
2759980 | 2759980 | 2022-10-18 | US | Texas | Comal | 48091 | 40824 | 566 | 0 | 29.80811278 | -98.27647225 | 2022-10-19 04:22:26 | Comal, Texas, US | |
2027814 | 2027814 | 2022-10-17 | US | Texas | Comal | 48091 | 40824 | 566 | 0 | 29.80811278 | -98.27647225 | 2022-10-18 04:22:42 | Comal, Texas, US | |
2162592 | 2162592 | 2022-10-16 | US | Texas | Comal | 48091 | 40794 | 566 | 0 | 29.80811278 | -98.27647225 | 2022-10-17 04:20:31 | Comal, Texas, US | |
518789 | 518789 | 2022-10-15 | US | Texas | Comal | 48091 | 40794 | 566 | 0 | 29.80811278 | -98.27647225 | 2022-10-16 04:22:39 | Comal, Texas, US | |
2035846 | 2035846 | 2022-10-14 | US | Texas | Comal | 48091 | 40794 | 566 | 0 | 29.80811278 | -98.27647225 | 2022-10-15 04:22:00 | Comal, Texas, US | |
3756534 | 3756534 | 2022-10-13 | US | Texas | Comal | 48091 | 40754 | 566 | 0 | 29.80811278 | -98.27647225 | 2022-10-14 04:22:28 | Comal, Texas, US | |
3217359 | 3217359 | 2022-10-12 | US | Texas | Comal | 48091 | 40754 | 566 | 0 | 29.80811278 | -98.27647225 | 2022-10-13 04:22:39 | Comal, Texas, US | |
3253208 | 3253208 | 2022-10-11 | US | Texas | Comal | 48091 | 40748 | 566 | 0 | 29.80811278 | -98.27647225 | 2022-10-12 04:22:51 | Comal, Texas, US | |
2970467 | 2970467 | 2022-10-10 | US | Texas | Comal | 48091 | 40748 | 566 | 0 | 29.80811278 | -98.27647225 | 2022-10-11 04:23:05 | Comal, Texas, US | |
3996440 | 3996440 | 2022-09-27 | US | Mississippi | DeSoto | 28033 | 57396 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-28 04:23:01 | DeSoto, Mississippi, US | |
2770768 | 2770768 | 2022-09-26 | US | Mississippi | DeSoto | 28033 | 57396 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-27 04:23:01 | DeSoto, Mississippi, US | |
1978421 | 1978421 | 2022-09-25 | US | Mississippi | DeSoto | 28033 | 57396 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-26 04:20:52 | DeSoto, Mississippi, US | |
2651588 | 2651588 | 2022-09-24 | US | Mississippi | DeSoto | 28033 | 57396 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-25 04:23:31 | DeSoto, Mississippi, US | |
386028 | 386028 | 2022-09-23 | US | Mississippi | DeSoto | 28033 | 57396 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-24 04:21:40 | DeSoto, Mississippi, US | |
1626094 | 1626094 | 2022-09-22 | US | Mississippi | DeSoto | 28033 | 57396 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-23 04:23:13 | DeSoto, Mississippi, US | |
1372298 | 1372298 | 2022-09-21 | US | Mississippi | DeSoto | 28033 | 57396 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-22 04:22:56 | DeSoto, Mississippi, US | |
2018528 | 2018528 | 2022-09-20 | US | Mississippi | DeSoto | 28033 | 57396 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-21 04:23:22 | DeSoto, Mississippi, US | |
3572401 | 3572401 | 2022-09-19 | US | Mississippi | DeSoto | 28033 | 57224 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-20 04:22:48 | DeSoto, Mississippi, US | |
421140 | 421140 | 2022-09-18 | US | Mississippi | DeSoto | 28033 | 57224 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-19 04:21:49 | DeSoto, Mississippi, US | |
3375164 | 3375164 | 2022-09-17 | US | Mississippi | DeSoto | 28033 | 57224 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-18 04:22:50 | DeSoto, Mississippi, US | |
2357272 | 2357272 | 2022-09-16 | US | Mississippi | DeSoto | 28033 | 57224 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-17 04:20:19 | DeSoto, Mississippi, US | |
3988429 | 3988429 | 2022-09-15 | US | Mississippi | DeSoto | 28033 | 57224 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-16 04:21:19 | DeSoto, Mississippi, US | |
1890946 | 1890946 | 2022-09-14 | US | Mississippi | DeSoto | 28033 | 57224 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-15 04:21:02 | DeSoto, Mississippi, US | |
374001 | 374001 | 2022-09-13 | US | Mississippi | DeSoto | 28033 | 56972 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-14 04:20:44 | DeSoto, Mississippi, US | |
2396603 | 2396603 | 2022-09-12 | US | Mississippi | DeSoto | 28033 | 56972 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-13 04:20:57 | DeSoto, Mississippi, US | |
2396496 | 2396496 | 2022-09-12 | US | Michigan | Washtenaw | 26161 | 98420 | 566 | 0 | 42.253105 | -83.83853204 | 2022-09-13 04:20:57 | Washtenaw, Michigan, US | |
3767681 | 3767681 | 2022-09-11 | US | Mississippi | DeSoto | 28033 | 56972 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-12 04:20:58 | DeSoto, Mississippi, US | |
3767574 | 3767574 | 2022-09-11 | US | Michigan | Washtenaw | 26161 | 98420 | 566 | 0 | 42.253105 | -83.83853204 | 2022-09-12 04:20:58 | Washtenaw, Michigan, US | |
3826256 | 3826256 | 2022-09-10 | US | Mississippi | DeSoto | 28033 | 56972 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-11 04:20:50 | DeSoto, Mississippi, US | |
3826149 | 3826149 | 2022-09-10 | US | Michigan | Washtenaw | 26161 | 98420 | 566 | 0 | 42.253105 | -83.83853204 | 2022-09-11 04:20:50 | Washtenaw, Michigan, US | |
964713 | 964713 | 2022-09-09 | US | Mississippi | DeSoto | 28033 | 56972 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-10 04:21:10 | DeSoto, Mississippi, US | |
964606 | 964606 | 2022-09-09 | US | Michigan | Washtenaw | 26161 | 98420 | 566 | 0 | 42.253105 | -83.83853204 | 2022-09-10 04:21:10 | Washtenaw, Michigan, US | |
255115 | 255115 | 2022-09-08 | US | Mississippi | DeSoto | 28033 | 56972 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-09 04:21:11 | DeSoto, Mississippi, US | |
255008 | 255008 | 2022-09-08 | US | Michigan | Washtenaw | 26161 | 98420 | 566 | 0 | 42.253105 | -83.83853204 | 2022-09-09 04:21:11 | Washtenaw, Michigan, US | |
3746913 | 3746913 | 2022-09-07 | US | Mississippi | DeSoto | 28033 | 56972 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-08 04:21:02 | DeSoto, Mississippi, US | |
3746806 | 3746806 | 2022-09-07 | US | Michigan | Washtenaw | 26161 | 98420 | 566 | 0 | 42.253105 | -83.83853204 | 2022-09-08 04:21:02 | Washtenaw, Michigan, US | |
116553 | 116553 | 2022-09-06 | US | Mississippi | DeSoto | 28033 | 56972 | 566 | 0 | 34.87625235 | -89.99091418 | 2022-09-07 04:20:59 | DeSoto, Mississippi, US | |
116446 | 116446 | 2022-09-06 | US | Michigan | Washtenaw | 26161 | 98420 | 566 | 0 | 42.253105 | -83.83853204 | 2022-09-07 04:20:59 | Washtenaw, Michigan, US | |
1161191 | 1161191 | 2022-08-18 | Japan | Shizuoka | 357448 | 566 | 0 | 34.916975 | 138.407784 | 2022-08-19 04:20:54 | Shizuoka, Japan | |||
3909101 | 3909101 | 2022-08-11 | US | Indiana | Hendricks | 18063 | 44153 | 566 | 0 | 39.76719009 | -86.51037283 | 2022-08-12 04:20:54 | Hendricks, Indiana, US | |
1347418 | 1347418 | 2022-08-10 | US | Indiana | Hendricks | 18063 | 44153 | 566 | 0 | 39.76719009 | -86.51037283 | 2022-08-11 04:20:49 | Hendricks, Indiana, US | |
1072517 | 1072517 | 2022-08-07 | US | Oregon | Jackson | 41029 | 49075 | 566 | 0 | 42.43201126 | -122.7289309 | 2022-08-08 04:21:08 | Jackson, Oregon, US | |
1943105 | 1943105 | 2022-08-06 | US | Oregon | Jackson | 41029 | 49075 | 566 | 0 | 42.43201126 | -122.7289309 | 2022-08-07 04:20:54 | Jackson, Oregon, US | |
882904 | 882904 | 2022-08-05 | US | Oregon | Jackson | 41029 | 49075 | 566 | 0 | 42.43201126 | -122.7289309 | 2022-08-06 04:20:56 | Jackson, Oregon, US | |
2010733 | 2010733 | 2022-08-04 | US | Montana | Yellowstone | 30111 | 45806 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-08-05 04:20:52 | Yellowstone, Montana, US | |
1100160 | 1100160 | 2022-08-03 | US | Montana | Yellowstone | 30111 | 45806 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-08-04 04:20:58 | Yellowstone, Montana, US | |
1407085 | 1407085 | 2022-08-02 | US | Montana | Yellowstone | 30111 | 45806 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-08-03 04:20:59 | Yellowstone, Montana, US | |
3619123 | 3619123 | 2022-08-01 | US | Montana | Yellowstone | 30111 | 45806 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-08-02 04:20:53 | Yellowstone, Montana, US | |
3873603 | 3873603 | 2022-07-31 | US | Montana | Yellowstone | 30111 | 45806 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-08-01 04:21:03 | Yellowstone, Montana, US | |
676357 | 676357 | 2022-07-30 | US | Montana | Yellowstone | 30111 | 45806 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-07-31 04:21:02 | Yellowstone, Montana, US | |
1785556 | 1785556 | 2022-07-29 | US | Montana | Yellowstone | 30111 | 45806 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-07-30 04:20:42 | Yellowstone, Montana, US | |
1067919 | 1067919 | 2022-07-28 | US | Montana | Yellowstone | 30111 | 45471 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-07-29 04:20:45 | Yellowstone, Montana, US | |
2337438 | 2337438 | 2022-07-27 | US | Montana | Yellowstone | 30111 | 45471 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-07-28 04:20:56 | Yellowstone, Montana, US | |
1489628 | 1489628 | 2022-07-26 | US | Montana | Yellowstone | 30111 | 45471 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-07-27 04:21:04 | Yellowstone, Montana, US | |
2596074 | 2596074 | 2022-07-25 | US | Montana | Yellowstone | 30111 | 45471 | 566 | 0 | 45.93955949 | -108.2691486 | 2022-07-26 04:20:58 | Yellowstone, Montana, 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]);