johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,824 rows where country_or_region = "Sweden" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, latitude, longitude, day (date)
last_update (date) >30 ✖
- 2022-04-13 42
- 2022-05-26 42
- 2020-02-01 24
- 2020-06-06 21
- 2020-06-07 21
- 2020-06-08 21
- 2020-06-09 21
- 2020-06-10 21
- 2020-06-11 21
- 2020-06-12 21
- 2020-06-13 21
- 2020-06-14 21
- 2020-06-15 21
- 2020-06-16 21
- 2020-06-17 21
- 2020-06-18 21
- 2020-06-19 21
- 2020-06-20 21
- 2020-06-21 21
- 2020-06-22 21
- 2020-06-23 21
- 2020-06-24 21
- 2020-06-25 21
- 2020-06-26 21
- 2020-06-27 21
- 2020-06-28 21
- 2020-06-29 21
- 2020-06-30 21
- 2020-07-01 21
- 2020-07-02 21
- …
province_or_state 21
- Blekinge 938
- Dalarna 938
- Gavleborg 938
- Gotland 938
- Halland 938
- Jamtland Harjedalen 938
- Jonkoping 938
- Kalmar 938
- Kronoberg 938
- Norrbotten 938
- Orebro 938
- Ostergotland 938
- Skane 938
- Sormland 938
- Stockholm 938
- Uppsala 938
- Varmland 938
- Vasterbotten 938
- Vasternorrland 938
- Vastmanland 938
- Vastra Gotaland 938
country_or_region 1
- Sweden · 19,824 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1046135 | 1046135 | 2020-09-30 | Sweden | Vasterbotten | 1030 | 31 | 0 | 999 | 65.3337 | 16.5162 | 2020-10-01 04:23:42 | Vasterbotten, Sweden | ||
967216 | 967216 | 2020-09-29 | Sweden | Vasterbotten | 1029 | 31 | 0 | 998 | 65.3337 | 16.5162 | 2020-09-30 04:23:33 | Vasterbotten, Sweden | ||
170350 | 170350 | 2021-04-16 | Sweden | Blekinge | 10095 | 123 | 0 | 9972 | 56.2784 | 15.018 | 2021-04-17 04:20:40 | Blekinge, Sweden | ||
983255 | 983255 | 2021-04-17 | Sweden | Blekinge | 10095 | 123 | 0 | 9972 | 56.2784 | 15.018 | 2021-04-18 04:20:41 | Blekinge, Sweden | ||
2411150 | 2411150 | 2021-04-19 | Sweden | Blekinge | 10095 | 123 | 0 | 9972 | 56.2784 | 15.018 | 2021-04-20 04:20:41 | Blekinge, Sweden | ||
3129827 | 3129827 | 2021-04-18 | Sweden | Blekinge | 10095 | 123 | 0 | 9972 | 56.2784 | 15.018 | 2021-04-19 04:20:57 | Blekinge, Sweden | ||
2748068 | 2748068 | 2020-07-15 | Sweden | Kronoberg | 1098 | 101 | 0 | 997 | 56.7183 | 14.4115 | 2020-07-16 04:44:59 | Kronoberg, Sweden | ||
1837383 | 1837383 | 2020-06-14 | Sweden | Vastra Gotaland | 10609 | 647 | 0 | 9962 | 58.2528 | 13.0596 | 2020-06-15 03:33:14 | Vastra Gotaland, Sweden | ||
2975544 | 2975544 | 2020-12-09 | Sweden | Ostergotland | 10280 | 318 | 0 | 9962 | 58.3454 | 15.5198 | 2020-12-10 05:26:19 | Ostergotland, Sweden | ||
2021034 | 2021034 | 2021-04-20 | Sweden | Jamtland Harjedalen | 10069 | 118 | 0 | 9951 | 63.1712 | 14.9592 | 2021-04-21 04:21:14 | Jamtland Harjedalen, Sweden | ||
12663 | 12663 | 2021-01-26 | Sweden | Vasterbotten | 10065 | 115 | 0 | 9950 | 65.3337 | 16.5162 | 2021-01-27 05:23:41 | Vasterbotten, Sweden | ||
614006 | 614006 | 2021-02-08 | Sweden | Skane | 100873 | 1414 | 0 | 99459 | 55.9903 | 13.5958 | 2021-02-09 05:23:30 | Skane, Sweden | ||
975236 | 975236 | 2021-02-06 | Sweden | Skane | 100873 | 1414 | 0 | 99459 | 55.9903 | 13.5958 | 2021-02-07 05:23:00 | Skane, Sweden | ||
1588494 | 1588494 | 2021-02-05 | Sweden | Skane | 100873 | 1414 | 0 | 99459 | 55.9903 | 13.5958 | 2021-02-06 05:23:55 | Skane, Sweden | ||
1672775 | 1672775 | 2021-02-07 | Sweden | Skane | 100873 | 1414 | 0 | 99459 | 55.9903 | 13.5958 | 2021-02-08 05:22:39 | Skane, Sweden | ||
371621 | 371621 | 2020-08-08 | Sweden | Varmland | 1067 | 73 | 0 | 994 | 59.7294 | 13.2354 | 2020-08-09 04:34:54 | Varmland, Sweden | ||
458805 | 458805 | 2020-08-07 | Sweden | Varmland | 1067 | 73 | 0 | 994 | 59.7294 | 13.2354 | 2020-08-08 04:34:53 | Varmland, Sweden | ||
3923453 | 3923453 | 2020-08-09 | Sweden | Varmland | 1067 | 73 | 0 | 994 | 59.7294 | 13.2354 | 2020-08-10 04:34:55 | Varmland, Sweden | ||
614014 | 614014 | 2021-02-08 | Sweden | Vastra Gotaland | 101149 | 1933 | 0 | 99216 | 58.2528 | 13.0596 | 2021-02-09 05:23:30 | Vastra Gotaland, Sweden | ||
975244 | 975244 | 2021-02-06 | Sweden | Vastra Gotaland | 101149 | 1933 | 0 | 99216 | 58.2528 | 13.0596 | 2021-02-07 05:23:00 | Vastra Gotaland, Sweden | ||
1588502 | 1588502 | 2021-02-05 | Sweden | Vastra Gotaland | 101149 | 1933 | 0 | 99216 | 58.2528 | 13.0596 | 2021-02-06 05:23:55 | Vastra Gotaland, Sweden | ||
1672783 | 1672783 | 2021-02-07 | Sweden | Vastra Gotaland | 101149 | 1933 | 0 | 99216 | 58.2528 | 13.0596 | 2021-02-08 05:22:39 | Vastra Gotaland, Sweden | ||
1691752 | 1691752 | 2020-06-19 | Sweden | Vasternorrland | 1094 | 102 | 0 | 992 | 63.4276 | 17.7292 | 2020-06-20 04:33:19 | Vasternorrland, Sweden | ||
2158712 | 2158712 | 2020-07-14 | Sweden | Kronoberg | 1093 | 101 | 0 | 992 | 56.7183 | 14.4115 | 2020-07-15 04:34:39 | Kronoberg, Sweden | ||
2438174 | 2438174 | 2020-06-20 | Sweden | Vasternorrland | 1094 | 102 | 0 | 992 | 63.4276 | 17.7292 | 2020-06-21 04:33:19 | Vasternorrland, Sweden | ||
3249581 | 3249581 | 2020-06-21 | Sweden | Vasternorrland | 1094 | 102 | 0 | 992 | 63.4276 | 17.7292 | 2020-06-22 04:33:20 | Vasternorrland, Sweden | ||
3682901 | 3682901 | 2020-06-18 | Sweden | Vasternorrland | 1094 | 102 | 0 | 992 | 63.4276 | 17.7292 | 2020-06-19 04:33:17 | Vasternorrland, Sweden | ||
352618 | 352618 | 2021-03-11 | Sweden | Varmland | 10095 | 177 | 0 | 9918 | 59.7294 | 13.2354 | 2021-03-12 05:26:50 | Varmland, Sweden | ||
1010628 | 1010628 | 2020-12-30 | Sweden | Vasternorrland | 10138 | 225 | 0 | 9913 | 63.4276 | 17.7292 | 2020-12-31 05:22:49 | Vasternorrland, Sweden | ||
1062171 | 1062171 | 2021-01-04 | Sweden | Vasternorrland | 10138 | 225 | 0 | 9913 | 63.4276 | 17.7292 | 2021-01-05 05:21:49 | Vasternorrland, Sweden | ||
1137207 | 1137207 | 2021-01-01 | Sweden | Vasternorrland | 10138 | 225 | 0 | 9913 | 63.4276 | 17.7292 | 2021-01-02 05:22:33 | Vasternorrland, Sweden | ||
2227843 | 2227843 | 2021-01-02 | Sweden | Vasternorrland | 10138 | 225 | 0 | 9913 | 63.4276 | 17.7292 | 2021-01-03 05:22:52 | Vasternorrland, Sweden | ||
3230774 | 3230774 | 2021-01-03 | Sweden | Vasternorrland | 10138 | 225 | 0 | 9913 | 63.4276 | 17.7292 | 2021-01-04 05:22:02 | Vasternorrland, Sweden | ||
3695813 | 3695813 | 2020-12-31 | Sweden | Vasternorrland | 10138 | 225 | 0 | 9913 | 63.4276 | 17.7292 | 2021-01-01 05:23:07 | Vasternorrland, Sweden | ||
614001 | 614001 | 2021-02-08 | Sweden | Kalmar | 10100 | 188 | 0 | 9912 | 57.235 | 16.1849 | 2021-02-09 05:23:30 | Kalmar, Sweden | ||
975231 | 975231 | 2021-02-06 | Sweden | Kalmar | 10100 | 188 | 0 | 9912 | 57.235 | 16.1849 | 2021-02-07 05:23:00 | Kalmar, Sweden | ||
1588489 | 1588489 | 2021-02-05 | Sweden | Kalmar | 10100 | 188 | 0 | 9912 | 57.235 | 16.1849 | 2021-02-06 05:23:55 | Kalmar, Sweden | ||
1672770 | 1672770 | 2021-02-07 | Sweden | Kalmar | 10100 | 188 | 0 | 9912 | 57.235 | 16.1849 | 2021-02-08 05:22:39 | Kalmar, Sweden | ||
3491353 | 3491353 | 2020-07-13 | Sweden | Kronoberg | 1092 | 101 | 0 | 991 | 56.7183 | 14.4115 | 2020-07-14 04:34:46 | Kronoberg, Sweden | ||
3612490 | 3612490 | 2020-08-06 | Sweden | Varmland | 1064 | 73 | 0 | 991 | 59.7294 | 13.2354 | 2020-08-07 04:35:11 | Varmland, Sweden | ||
1460074 | 1460074 | 2021-01-31 | Sweden | Norrbotten | 10090 | 188 | 0 | 9902 | 66.8309 | 20.3992 | 2021-02-01 05:22:53 | Norrbotten, Sweden | ||
1676786 | 1676786 | 2021-02-01 | Sweden | Norrbotten | 10090 | 188 | 0 | 9902 | 66.8309 | 20.3992 | 2021-02-02 05:22:49 | Norrbotten, Sweden | ||
1897469 | 1897469 | 2021-01-29 | Sweden | Norrbotten | 10090 | 188 | 0 | 9902 | 66.8309 | 20.3992 | 2021-01-30 05:22:49 | Norrbotten, Sweden | ||
2211982 | 2211982 | 2021-01-30 | Sweden | Norrbotten | 10090 | 188 | 0 | 9902 | 66.8309 | 20.3992 | 2021-01-31 05:22:42 | Norrbotten, Sweden | ||
1350638 | 1350638 | 2020-11-24 | Sweden | Uppsala | 10180 | 283 | 0 | 9897 | 60.0092 | 17.2715 | 2020-11-25 05:27:20 | Uppsala, Sweden | ||
3061115 | 3061115 | 2020-06-13 | Sweden | Halland | 1049 | 60 | 0 | 989 | 56.8967 | 12.8034 | 2020-06-14 03:33:15 | Halland, Sweden | ||
790701 | 790701 | 2021-02-04 | Sweden | Skane | 100300 | 1414 | 0 | 98886 | 55.9903 | 13.5958 | 2021-02-05 05:22:38 | Skane, Sweden | ||
738616 | 738616 | 2020-12-02 | Sweden | Orebro | 10081 | 195 | 0 | 9886 | 59.535 | 15.0066 | 2020-12-03 05:28:22 | Orebro, Sweden | ||
8642 | 8642 | 2020-10-25 | Sweden | Kalmar | 1052 | 64 | 0 | 988 | 57.235 | 16.1849 | 2020-10-26 04:25:02 | Kalmar, Sweden | ||
1054134 | 1054134 | 2020-10-23 | Sweden | Kalmar | 1052 | 64 | 0 | 988 | 57.235 | 16.1849 | 2020-10-24 04:24:46 | Kalmar, Sweden | ||
3480621 | 3480621 | 2020-10-26 | Sweden | Kalmar | 1052 | 64 | 0 | 988 | 57.235 | 16.1849 | 2020-10-27 04:24:45 | Kalmar, Sweden | ||
3651879 | 3651879 | 2020-10-24 | Sweden | Kalmar | 1052 | 64 | 0 | 988 | 57.235 | 16.1849 | 2020-10-25 04:24:36 | Kalmar, Sweden | ||
2549181 | 2549181 | 2021-04-15 | Sweden | Blekinge | 9988 | 122 | 0 | 9866 | 56.2784 | 15.018 | 2021-04-16 04:20:46 | Blekinge, Sweden | ||
790709 | 790709 | 2021-02-04 | Sweden | Vastra Gotaland | 100424 | 1913 | 0 | 98511 | 58.2528 | 13.0596 | 2021-02-05 05:22:38 | Vastra Gotaland, Sweden | ||
790696 | 790696 | 2021-02-04 | Sweden | Kalmar | 10039 | 188 | 0 | 9851 | 57.235 | 16.1849 | 2021-02-05 05:22:38 | Kalmar, Sweden | ||
2974392 | 2974392 | 2020-06-30 | Sweden | Jamtland Harjedalen | 1033 | 48 | 0 | 985 | 63.1712 | 14.9592 | 2020-07-01 04:33:52 | Jamtland Harjedalen, Sweden | ||
3045323 | 3045323 | 2020-07-02 | Sweden | Jamtland Harjedalen | 1039 | 54 | 0 | 985 | 63.1712 | 14.9592 | 2020-07-03 04:33:54 | Jamtland Harjedalen, Sweden | ||
303014 | 303014 | 2020-07-01 | Sweden | Jamtland Harjedalen | 1038 | 54 | 0 | 984 | 63.1712 | 14.9592 | 2020-07-02 04:33:46 | Jamtland Harjedalen, Sweden | ||
2632869 | 2632869 | 2020-06-29 | Sweden | Jamtland Harjedalen | 1032 | 48 | 0 | 984 | 63.1712 | 14.9592 | 2020-06-30 04:33:48 | Jamtland Harjedalen, Sweden | ||
678620 | 678620 | 2020-11-23 | Sweden | Gotland | 990 | 7 | 0 | 983 | 57.4684 | 18.4867 | 2020-11-24 05:27:31 | Gotland, Sweden | ||
2701818 | 2701818 | 2020-11-20 | Sweden | Gotland | 990 | 7 | 0 | 983 | 57.4684 | 18.4867 | 2020-11-21 05:25:51 | Gotland, Sweden | ||
3190296 | 3190296 | 2020-11-22 | Sweden | Gotland | 990 | 7 | 0 | 983 | 57.4684 | 18.4867 | 2020-11-23 05:25:26 | Gotland, Sweden | ||
3836790 | 3836790 | 2020-11-21 | Sweden | Gotland | 990 | 7 | 0 | 983 | 57.4684 | 18.4867 | 2020-11-22 05:25:45 | Gotland, Sweden | ||
3962842 | 3962842 | 2021-03-10 | Sweden | Varmland | 10000 | 175 | 0 | 9825 | 59.7294 | 13.2354 | 2021-03-11 05:25:48 | Varmland, Sweden | ||
821881 | 821881 | 2020-11-19 | Sweden | Jonkoping | 10021 | 197 | 0 | 9824 | 57.3708 | 14.3439 | 2020-11-20 05:26:28 | Jonkoping, Sweden | ||
3237509 | 3237509 | 2020-07-10 | Sweden | Kronoberg | 1082 | 100 | 0 | 982 | 56.7183 | 14.4115 | 2020-07-11 04:34:26 | Kronoberg, Sweden | ||
3436011 | 3436011 | 2020-07-11 | Sweden | Kronoberg | 1082 | 100 | 0 | 982 | 56.7183 | 14.4115 | 2020-07-12 04:34:30 | Kronoberg, Sweden | ||
3737616 | 3737616 | 2020-07-12 | Sweden | Kronoberg | 1082 | 100 | 0 | 982 | 56.7183 | 14.4115 | 2020-07-13 04:43:04 | Kronoberg, Sweden | ||
1819104 | 1819104 | 2020-12-08 | Sweden | Ostergotland | 10125 | 309 | 0 | 9816 | 58.3454 | 15.5198 | 2020-12-09 05:28:01 | Ostergotland, Sweden | ||
2080236 | 2080236 | 2020-10-31 | Sweden | Blekinge | 999 | 18 | 0 | 981 | 56.2784 | 15.018 | 2020-11-01 04:36:19 | Blekinge, Sweden | ||
2243689 | 2243689 | 2020-10-30 | Sweden | Blekinge | 999 | 18 | 0 | 981 | 56.2784 | 15.018 | 2020-10-31 04:24:44 | Blekinge, Sweden | ||
3304498 | 3304498 | 2020-11-02 | Sweden | Blekinge | 999 | 18 | 0 | 981 | 56.2784 | 15.018 | 2020-11-03 06:00:16 | Blekinge, Sweden | ||
3409747 | 3409747 | 2020-11-01 | Sweden | Blekinge | 999 | 18 | 0 | 981 | 56.2784 | 15.018 | 2020-11-02 05:25:04 | Blekinge, Sweden | ||
1759619 | 1759619 | 2021-01-24 | Sweden | Vasterbotten | 9923 | 114 | 0 | 9809 | 65.3337 | 16.5162 | 2021-01-25 05:22:16 | Vasterbotten, Sweden | ||
2427226 | 2427226 | 2021-01-23 | Sweden | Vasterbotten | 9923 | 114 | 0 | 9809 | 65.3337 | 16.5162 | 2021-01-24 05:22:35 | Vasterbotten, Sweden | ||
2467128 | 2467128 | 2021-01-22 | Sweden | Vasterbotten | 9923 | 114 | 0 | 9809 | 65.3337 | 16.5162 | 2021-01-23 05:22:03 | Vasterbotten, Sweden | ||
2567987 | 2567987 | 2021-01-25 | Sweden | Vasterbotten | 9923 | 114 | 0 | 9809 | 65.3337 | 16.5162 | 2021-01-26 05:22:02 | Vasterbotten, Sweden | ||
340593 | 340593 | 2021-02-03 | Sweden | Skane | 99497 | 1413 | 0 | 98084 | 55.9903 | 13.5958 | 2021-02-04 05:22:26 | Skane, Sweden | ||
2482285 | 2482285 | 2021-01-28 | Sweden | Norrbotten | 9984 | 183 | 0 | 9801 | 66.8309 | 20.3992 | 2021-01-29 05:22:23 | Norrbotten, Sweden | ||
3793320 | 3793320 | 2020-08-05 | Sweden | Varmland | 1053 | 73 | 0 | 980 | 59.7294 | 13.2354 | 2020-08-06 04:35:02 | Varmland, Sweden | ||
1819112 | 1819112 | 2020-12-08 | Sweden | Vastmanland | 9997 | 203 | 0 | 9794 | 59.6714 | 16.2159 | 2020-12-09 05:28:01 | Vastmanland, Sweden | ||
1005494 | 1005494 | 2020-07-09 | Sweden | Kronoberg | 1079 | 100 | 0 | 979 | 56.7183 | 14.4115 | 2020-07-10 04:34:24 | Kronoberg, Sweden | ||
340601 | 340601 | 2021-02-03 | Sweden | Vastra Gotaland | 99745 | 1864 | 0 | 97881 | 58.2528 | 13.0596 | 2021-02-04 05:22:26 | Vastra Gotaland, Sweden | ||
340588 | 340588 | 2021-02-03 | Sweden | Kalmar | 9940 | 177 | 0 | 9763 | 57.235 | 16.1849 | 2021-02-04 05:22:26 | Kalmar, Sweden | ||
154301 | 154301 | 2021-01-08 | Sweden | Sormland | 10084 | 328 | 0 | 9756 | 59.0336 | 16.7519 | 2021-01-09 05:22:18 | Sormland, Sweden | ||
190387 | 190387 | 2021-01-11 | Sweden | Sormland | 10084 | 328 | 0 | 9756 | 59.0336 | 16.7519 | 2021-01-12 05:22:15 | Sormland, Sweden | ||
2626190 | 2626190 | 2021-01-10 | Sweden | Sormland | 10084 | 328 | 0 | 9756 | 59.0336 | 16.7519 | 2021-01-11 05:21:50 | Sormland, Sweden | ||
3900278 | 3900278 | 2021-01-09 | Sweden | Sormland | 10084 | 328 | 0 | 9756 | 59.0336 | 16.7519 | 2021-01-10 05:22:12 | Sormland, Sweden | ||
170355 | 170355 | 2021-04-16 | Sweden | Jamtland Harjedalen | 9873 | 118 | 0 | 9755 | 63.1712 | 14.9592 | 2021-04-17 04:20:40 | Jamtland Harjedalen, Sweden | ||
983260 | 983260 | 2021-04-17 | Sweden | Jamtland Harjedalen | 9873 | 118 | 0 | 9755 | 63.1712 | 14.9592 | 2021-04-18 04:20:41 | Jamtland Harjedalen, Sweden | ||
2411155 | 2411155 | 2021-04-19 | Sweden | Jamtland Harjedalen | 9873 | 118 | 0 | 9755 | 63.1712 | 14.9592 | 2021-04-20 04:20:41 | Jamtland Harjedalen, Sweden | ||
3129832 | 3129832 | 2021-04-18 | Sweden | Jamtland Harjedalen | 9873 | 118 | 0 | 9755 | 63.1712 | 14.9592 | 2021-04-19 04:20:57 | Jamtland Harjedalen, Sweden | ||
3149912 | 3149912 | 2020-12-16 | Sweden | Stockholm | 100515 | 2983 | 0 | 97532 | 59.6025 | 18.1384 | 2020-12-17 05:28:12 | Stockholm, Sweden | ||
1684819 | 1684819 | 2021-02-02 | Sweden | Skane | 98903 | 1377 | 0 | 97526 | 55.9903 | 13.5958 | 2021-02-03 05:22:52 | Skane, Sweden | ||
415344 | 415344 | 2020-07-05 | Sweden | Kronoberg | 1072 | 97 | 0 | 975 | 56.7183 | 14.4115 | 2020-07-06 04:33:57 | Kronoberg, Sweden | ||
529906 | 529906 | 2020-07-04 | Sweden | Kronoberg | 1072 | 97 | 0 | 975 | 56.7183 | 14.4115 | 2020-07-05 04:33:46 | Kronoberg, Sweden | ||
887319 | 887319 | 2020-07-07 | Sweden | Kronoberg | 1075 | 100 | 0 | 975 | 56.7183 | 14.4115 | 2020-07-08 05:33:48 | Kronoberg, Sweden | ||
2234567 | 2234567 | 2020-07-03 | Sweden | Kronoberg | 1072 | 97 | 0 | 975 | 56.7183 | 14.4115 | 2020-07-04 04:33:51 | Kronoberg, Sweden | ||
2684879 | 2684879 | 2020-07-06 | Sweden | Kronoberg | 1073 | 98 | 0 | 975 | 56.7183 | 14.4115 | 2020-07-07 04:34:00 | Kronoberg, Sweden | ||
1842251 | 1842251 | 2021-04-14 | Sweden | Blekinge | 9866 | 121 | 0 | 9745 | 56.2784 | 15.018 | 2021-04-15 04:20:54 | Blekinge, Sweden |
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]);