johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
938 rows where country_or_region = "Sweden" and province_or_state = "Vastra Gotaland" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1444904 | 1444904 | 2020-09-11 | Sweden | Vastra Gotaland | 19224 | 857 | 0 | 18367 | 58.2528 | 13.0596 | 2020-09-12 04:25:05 | Vastra Gotaland, Sweden | ||
2869036 | 2869036 | 2020-09-13 | Sweden | Vastra Gotaland | 19224 | 857 | 0 | 18367 | 58.2528 | 13.0596 | 2020-09-14 04:26:00 | Vastra Gotaland, Sweden | ||
2729325 | 2729325 | 2020-09-15 | Sweden | Vastra Gotaland | 19352 | 858 | 0 | 18494 | 58.2528 | 13.0596 | 2020-09-16 04:22:53 | Vastra Gotaland, Sweden | ||
666600 | 666600 | 2020-09-16 | Sweden | Vastra Gotaland | 19401 | 859 | 0 | 18542 | 58.2528 | 13.0596 | 2020-09-17 04:22:00 | Vastra Gotaland, Sweden | ||
1121911 | 1121911 | 2020-09-17 | Sweden | Vastra Gotaland | 19450 | 859 | 0 | 18591 | 58.2528 | 13.0596 | 2020-09-18 05:05:00 | Vastra Gotaland, Sweden | ||
2455093 | 2455093 | 2020-09-19 | Sweden | Vastra Gotaland | 19514 | 860 | 0 | 18654 | 58.2528 | 13.0596 | 2020-09-20 04:22:00 | Vastra Gotaland, Sweden | ||
2837139 | 2837139 | 2020-09-21 | Sweden | Vastra Gotaland | 19514 | 860 | 0 | 18654 | 58.2528 | 13.0596 | 2020-09-22 04:23:00 | Vastra Gotaland, Sweden | ||
2849162 | 2849162 | 2020-09-18 | Sweden | Vastra Gotaland | 19514 | 860 | 0 | 18654 | 58.2528 | 13.0596 | 2020-09-19 04:22:00 | Vastra Gotaland, Sweden | ||
3093743 | 3093743 | 2020-09-20 | Sweden | Vastra Gotaland | 19514 | 860 | 0 | 18654 | 58.2528 | 13.0596 | 2020-09-21 04:23:00 | Vastra Gotaland, Sweden | ||
3316540 | 3316540 | 2020-09-22 | Sweden | Vastra Gotaland | 19681 | 860 | 0 | 18821 | 58.2528 | 13.0596 | 2020-09-23 04:23:00 | Vastra Gotaland, Sweden | ||
1515716 | 1515716 | 2020-09-28 | Sweden | Vastra Gotaland | 19972 | 861 | 0 | 19111 | 58.2528 | 13.0596 | 2020-09-29 04:23:42 | Vastra Gotaland, Sweden | ||
2582304 | 2582304 | 2020-09-27 | Sweden | Vastra Gotaland | 19972 | 861 | 0 | 19111 | 58.2528 | 13.0596 | 2020-09-28 04:23:00 | Vastra Gotaland, Sweden | ||
2606348 | 2606348 | 2020-09-24 | Sweden | Vastra Gotaland | 19845 | 861 | 0 | 18984 | 58.2528 | 13.0596 | 2020-09-25 04:23:00 | Vastra Gotaland, Sweden | ||
2614356 | 2614356 | 2020-09-26 | Sweden | Vastra Gotaland | 19972 | 861 | 0 | 19111 | 58.2528 | 13.0596 | 2020-09-27 04:23:00 | Vastra Gotaland, Sweden | ||
2654091 | 2654091 | 2020-09-23 | Sweden | Vastra Gotaland | 19709 | 861 | 0 | 18848 | 58.2528 | 13.0596 | 2020-09-24 04:23:00 | Vastra Gotaland, Sweden | ||
2813071 | 2813071 | 2020-09-25 | Sweden | Vastra Gotaland | 19972 | 861 | 0 | 19111 | 58.2528 | 13.0596 | 2020-09-26 04:23:00 | Vastra Gotaland, Sweden | ||
967219 | 967219 | 2020-09-29 | Sweden | Vastra Gotaland | 20202 | 863 | 0 | 19339 | 58.2528 | 13.0596 | 2020-09-30 04:23:33 | Vastra Gotaland, Sweden | ||
1046138 | 1046138 | 2020-09-30 | Sweden | Vastra Gotaland | 20247 | 863 | 0 | 19384 | 58.2528 | 13.0596 | 2020-10-01 04:23:42 | Vastra Gotaland, Sweden | ||
2379952 | 2379952 | 2020-10-01 | Sweden | Vastra Gotaland | 20328 | 863 | 0 | 19465 | 58.2528 | 13.0596 | 2020-10-02 04:23:51 | Vastra Gotaland, Sweden | ||
1823109 | 1823109 | 2020-10-04 | Sweden | Vastra Gotaland | 20406 | 865 | 0 | 19541 | 58.2528 | 13.0596 | 2020-10-05 04:23:33 | Vastra Gotaland, Sweden | ||
2514493 | 2514493 | 2020-10-03 | Sweden | Vastra Gotaland | 20406 | 865 | 0 | 19541 | 58.2528 | 13.0596 | 2020-10-04 04:23:44 | Vastra Gotaland, Sweden | ||
3389711 | 3389711 | 2020-10-02 | Sweden | Vastra Gotaland | 20406 | 865 | 0 | 19541 | 58.2528 | 13.0596 | 2020-10-03 04:23:40 | Vastra Gotaland, Sweden | ||
3802219 | 3802219 | 2020-10-05 | Sweden | Vastra Gotaland | 20406 | 865 | 0 | 19541 | 58.2528 | 13.0596 | 2020-10-06 04:23:33 | Vastra Gotaland, Sweden | ||
3117807 | 3117807 | 2020-10-06 | Sweden | Vastra Gotaland | 20596 | 866 | 0 | 19730 | 58.2528 | 13.0596 | 2020-10-07 04:23:40 | Vastra Gotaland, Sweden | ||
817889 | 817889 | 2020-10-09 | Sweden | Vastra Gotaland | 20876 | 867 | 0 | 20009 | 58.2528 | 13.0596 | 2020-10-10 04:23:57 | Vastra Gotaland, Sweden | ||
1042146 | 1042146 | 2020-10-07 | Sweden | Vastra Gotaland | 20647 | 867 | 0 | 19780 | 58.2528 | 13.0596 | 2020-10-08 04:23:56 | Vastra Gotaland, Sweden | ||
2291766 | 2291766 | 2020-10-12 | Sweden | Vastra Gotaland | 20876 | 867 | 0 | 20009 | 58.2528 | 13.0596 | 2020-10-13 04:24:02 | Vastra Gotaland, Sweden | ||
2602356 | 2602356 | 2020-10-10 | Sweden | Vastra Gotaland | 20876 | 867 | 0 | 20009 | 58.2528 | 13.0596 | 2020-10-11 04:23:46 | Vastra Gotaland, Sweden | ||
2690004 | 2690004 | 2020-10-08 | Sweden | Vastra Gotaland | 20754 | 867 | 0 | 19887 | 58.2528 | 13.0596 | 2020-10-09 04:23:59 | Vastra Gotaland, Sweden | ||
3782226 | 3782226 | 2020-10-13 | Sweden | Vastra Gotaland | 21136 | 867 | 0 | 20269 | 58.2528 | 13.0596 | 2020-10-14 04:24:05 | Vastra Gotaland, Sweden | ||
3786218 | 3786218 | 2020-10-11 | Sweden | Vastra Gotaland | 20876 | 867 | 0 | 20009 | 58.2528 | 13.0596 | 2020-10-12 04:23:45 | Vastra Gotaland, Sweden | ||
79411 | 79411 | 2020-10-14 | Sweden | Vastra Gotaland | 21225 | 868 | 0 | 20357 | 58.2528 | 13.0596 | 2020-10-15 04:24:28 | Vastra Gotaland, Sweden | ||
786700 | 786700 | 2020-10-15 | Sweden | Vastra Gotaland | 21355 | 868 | 0 | 20487 | 58.2528 | 13.0596 | 2020-10-16 04:24:01 | Vastra Gotaland, Sweden | ||
762637 | 762637 | 2020-10-18 | Sweden | Vastra Gotaland | 21475 | 869 | 0 | 20606 | 58.2528 | 13.0596 | 2020-10-19 04:24:16 | Vastra Gotaland, Sweden | ||
1026675 | 1026675 | 2020-10-17 | Sweden | Vastra Gotaland | 21475 | 869 | 0 | 20606 | 58.2528 | 13.0596 | 2020-10-18 04:24:25 | Vastra Gotaland, Sweden | ||
1794953 | 1794953 | 2020-10-19 | Sweden | Vastra Gotaland | 21475 | 869 | 0 | 20606 | 58.2528 | 13.0596 | 2020-10-20 04:24:22 | Vastra Gotaland, Sweden | ||
2857170 | 2857170 | 2020-10-16 | Sweden | Vastra Gotaland | 21475 | 869 | 0 | 20606 | 58.2528 | 13.0596 | 2020-10-17 04:24:12 | Vastra Gotaland, Sweden | ||
3990933 | 3990933 | 2020-10-20 | Sweden | Vastra Gotaland | 21885 | 869 | 0 | 21016 | 58.2528 | 13.0596 | 2020-10-21 04:24:14 | Vastra Gotaland, Sweden | ||
1177817 | 1177817 | 2020-10-22 | Sweden | Vastra Gotaland | 22187 | 871 | 0 | 21316 | 58.2528 | 13.0596 | 2020-10-23 04:24:46 | Vastra Gotaland, Sweden | ||
2191922 | 2191922 | 2020-10-21 | Sweden | Vastra Gotaland | 21991 | 871 | 0 | 21120 | 58.2528 | 13.0596 | 2020-10-22 04:24:27 | Vastra Gotaland, Sweden | ||
8655 | 8655 | 2020-10-25 | Sweden | Vastra Gotaland | 22457 | 872 | 0 | 21585 | 58.2528 | 13.0596 | 2020-10-26 04:25:02 | Vastra Gotaland, Sweden | ||
1054147 | 1054147 | 2020-10-23 | Sweden | Vastra Gotaland | 22457 | 872 | 0 | 21585 | 58.2528 | 13.0596 | 2020-10-24 04:24:46 | Vastra Gotaland, Sweden | ||
3480634 | 3480634 | 2020-10-26 | Sweden | Vastra Gotaland | 22457 | 872 | 0 | 21585 | 58.2528 | 13.0596 | 2020-10-27 04:24:45 | Vastra Gotaland, Sweden | ||
3651892 | 3651892 | 2020-10-24 | Sweden | Vastra Gotaland | 22457 | 872 | 0 | 21585 | 58.2528 | 13.0596 | 2020-10-25 04:24:36 | Vastra Gotaland, Sweden | ||
1452910 | 1452910 | 2020-10-27 | Sweden | Vastra Gotaland | 23328 | 873 | 0 | 22455 | 58.2528 | 13.0596 | 2020-10-28 04:24:39 | Vastra Gotaland, Sweden | ||
754626 | 754626 | 2020-10-28 | Sweden | Vastra Gotaland | 23648 | 874 | 0 | 22774 | 58.2528 | 13.0596 | 2020-10-29 04:24:49 | Vastra Gotaland, Sweden | ||
210564 | 210564 | 2020-10-29 | Sweden | Vastra Gotaland | 24154 | 875 | 0 | 23279 | 58.2528 | 13.0596 | 2020-10-30 04:24:49 | Vastra Gotaland, Sweden | ||
2080256 | 2080256 | 2020-10-31 | Sweden | Vastra Gotaland | 24896 | 877 | 0 | 24019 | 58.2528 | 13.0596 | 2020-11-01 04:36:19 | Vastra Gotaland, Sweden | ||
2243709 | 2243709 | 2020-10-30 | Sweden | Vastra Gotaland | 24896 | 877 | 0 | 24019 | 58.2528 | 13.0596 | 2020-10-31 04:24:44 | Vastra Gotaland, Sweden | ||
3304518 | 3304518 | 2020-11-02 | Sweden | Vastra Gotaland | 24896 | 877 | 0 | 24019 | 58.2528 | 13.0596 | 2020-11-03 06:00:16 | Vastra Gotaland, Sweden | ||
3409767 | 3409767 | 2020-11-01 | Sweden | Vastra Gotaland | 24896 | 877 | 0 | 24019 | 58.2528 | 13.0596 | 2020-11-02 05:25:04 | Vastra Gotaland, Sweden | ||
2498343 | 2498343 | 2020-11-03 | Sweden | Vastra Gotaland | 26260 | 879 | 0 | 25381 | 58.2528 | 13.0596 | 2020-11-04 05:25:09 | Vastra Gotaland, Sweden | ||
892444 | 892444 | 2020-11-05 | Sweden | Vastra Gotaland | 27354 | 881 | 0 | 26473 | 58.2528 | 13.0596 | 2020-11-06 05:24:55 | Vastra Gotaland, Sweden | ||
2919506 | 2919506 | 2020-11-04 | Sweden | Vastra Gotaland | 26721 | 881 | 0 | 25840 | 58.2528 | 13.0596 | 2020-11-05 06:05:03 | Vastra Gotaland, Sweden | ||
376506 | 376506 | 2020-11-06 | Sweden | Vastra Gotaland | 28085 | 887 | 0 | 27198 | 58.2528 | 13.0596 | 2020-11-07 05:24:52 | Vastra Gotaland, Sweden | ||
1544268 | 1544268 | 2020-11-07 | Sweden | Vastra Gotaland | 28085 | 887 | 0 | 27198 | 58.2528 | 13.0596 | 2020-11-08 05:24:56 | Vastra Gotaland, Sweden | ||
1728808 | 1728808 | 2020-11-08 | Sweden | Vastra Gotaland | 28085 | 887 | 0 | 27198 | 58.2528 | 13.0596 | 2020-11-09 05:25:45 | Vastra Gotaland, Sweden | ||
1988956 | 1988956 | 2020-11-09 | Sweden | Vastra Gotaland | 28085 | 887 | 0 | 27198 | 58.2528 | 13.0596 | 2020-11-10 05:40:07 | Vastra Gotaland, Sweden | ||
272479 | 272479 | 2020-11-10 | Sweden | Vastra Gotaland | 30555 | 893 | 0 | 29662 | 58.2528 | 13.0596 | 2020-11-11 05:25:30 | Vastra Gotaland, Sweden | ||
3441139 | 3441139 | 2020-11-11 | Sweden | Vastra Gotaland | 31151 | 898 | 0 | 30253 | 58.2528 | 13.0596 | 2020-11-12 05:25:55 | Vastra Gotaland, Sweden | ||
865095 | 865095 | 2020-11-12 | Sweden | Vastra Gotaland | 31980 | 901 | 0 | 31079 | 58.2528 | 13.0596 | 2020-11-13 05:25:30 | Vastra Gotaland, Sweden | ||
2785330 | 2785330 | 2020-11-13 | Sweden | Vastra Gotaland | 32726 | 908 | 0 | 31818 | 58.2528 | 13.0596 | 2020-11-14 05:25:37 | Vastra Gotaland, Sweden | ||
2880530 | 2880530 | 2020-11-15 | Sweden | Vastra Gotaland | 32726 | 908 | 0 | 31818 | 58.2528 | 13.0596 | 2020-11-16 05:25:57 | Vastra Gotaland, Sweden | ||
2915508 | 2915508 | 2020-11-14 | Sweden | Vastra Gotaland | 32726 | 908 | 0 | 31818 | 58.2528 | 13.0596 | 2020-11-15 05:26:53 | Vastra Gotaland, Sweden | ||
3169962 | 3169962 | 2020-11-16 | Sweden | Vastra Gotaland | 32726 | 908 | 0 | 31818 | 58.2528 | 13.0596 | 2020-11-17 05:25:54 | Vastra Gotaland, Sweden | ||
3338917 | 3338917 | 2020-11-17 | Sweden | Vastra Gotaland | 34663 | 914 | 0 | 33749 | 58.2528 | 13.0596 | 2020-11-18 05:40:31 | Vastra Gotaland, Sweden | ||
123029 | 123029 | 2020-11-18 | Sweden | Vastra Gotaland | 34983 | 927 | 0 | 34056 | 58.2528 | 13.0596 | 2020-11-19 05:25:23 | Vastra Gotaland, Sweden | ||
821895 | 821895 | 2020-11-19 | Sweden | Vastra Gotaland | 35945 | 936 | 0 | 35009 | 58.2528 | 13.0596 | 2020-11-20 05:26:28 | Vastra Gotaland, Sweden | ||
678637 | 678637 | 2020-11-23 | Sweden | Vastra Gotaland | 37147 | 941 | 0 | 36206 | 58.2528 | 13.0596 | 2020-11-24 05:27:31 | Vastra Gotaland, Sweden | ||
2701835 | 2701835 | 2020-11-20 | Sweden | Vastra Gotaland | 37147 | 941 | 0 | 36206 | 58.2528 | 13.0596 | 2020-11-21 05:25:51 | Vastra Gotaland, Sweden | ||
3190313 | 3190313 | 2020-11-22 | Sweden | Vastra Gotaland | 37147 | 941 | 0 | 36206 | 58.2528 | 13.0596 | 2020-11-23 05:25:26 | Vastra Gotaland, Sweden | ||
3836807 | 3836807 | 2020-11-21 | Sweden | Vastra Gotaland | 37147 | 941 | 0 | 36206 | 58.2528 | 13.0596 | 2020-11-22 05:25:45 | Vastra Gotaland, Sweden | ||
1350643 | 1350643 | 2020-11-24 | Sweden | Vastra Gotaland | 39278 | 944 | 0 | 38334 | 58.2528 | 13.0596 | 2020-11-25 05:27:20 | Vastra Gotaland, Sweden | ||
1972912 | 1972912 | 2020-11-25 | Sweden | Vastra Gotaland | 39653 | 955 | 0 | 38698 | 58.2528 | 13.0596 | 2020-11-26 05:27:44 | Vastra Gotaland, Sweden | ||
924007 | 924007 | 2020-11-26 | Sweden | Vastra Gotaland | 40484 | 957 | 0 | 39527 | 58.2528 | 13.0596 | 2020-11-27 05:26:53 | Vastra Gotaland, Sweden | ||
392560 | 392560 | 2020-11-27 | Sweden | Vastra Gotaland | 41444 | 972 | 0 | 40472 | 58.2528 | 13.0596 | 2020-11-28 05:25:50 | Vastra Gotaland, Sweden | ||
1584489 | 1584489 | 2020-11-30 | Sweden | Vastra Gotaland | 41444 | 972 | 0 | 40472 | 58.2528 | 13.0596 | 2020-12-01 05:26:18 | Vastra Gotaland, Sweden | ||
2935557 | 2935557 | 2020-11-28 | Sweden | Vastra Gotaland | 41444 | 972 | 0 | 40472 | 58.2528 | 13.0596 | 2020-11-29 05:25:55 | Vastra Gotaland, Sweden | ||
3566892 | 3566892 | 2020-11-29 | Sweden | Vastra Gotaland | 41444 | 972 | 0 | 40472 | 58.2528 | 13.0596 | 2020-11-30 05:26:13 | Vastra Gotaland, Sweden | ||
2537720 | 2537720 | 2020-12-01 | Sweden | Vastra Gotaland | 43607 | 987 | 0 | 42620 | 58.2528 | 13.0596 | 2020-12-02 05:27:41 | Vastra Gotaland, Sweden | ||
75414 | 75414 | 2020-12-03 | Sweden | Vastra Gotaland | 44986 | 1014 | 0 | 43972 | 58.2528 | 13.0596 | 2020-12-04 05:27:27 | Vastra Gotaland, Sweden | ||
738626 | 738626 | 2020-12-02 | Sweden | Vastra Gotaland | 44080 | 1014 | 0 | 43066 | 58.2528 | 13.0596 | 2020-12-03 05:28:22 | Vastra Gotaland, Sweden | ||
1006619 | 1006619 | 2020-12-06 | Sweden | Vastra Gotaland | 45740 | 1032 | 0 | 44708 | 58.2528 | 13.0596 | 2020-12-07 05:26:14 | Vastra Gotaland, Sweden | ||
1632628 | 1632628 | 2020-12-05 | Sweden | Vastra Gotaland | 45740 | 1032 | 0 | 44708 | 58.2528 | 13.0596 | 2020-12-06 05:26:18 | Vastra Gotaland, Sweden | ||
2347749 | 2347749 | 2020-12-07 | Sweden | Vastra Gotaland | 45740 | 1032 | 0 | 44708 | 58.2528 | 13.0596 | 2020-12-08 05:27:42 | Vastra Gotaland, Sweden | ||
3860156 | 3860156 | 2020-12-04 | Sweden | Vastra Gotaland | 45740 | 1032 | 0 | 44708 | 58.2528 | 13.0596 | 2020-12-05 05:27:36 | Vastra Gotaland, Sweden | ||
1819113 | 1819113 | 2020-12-08 | Sweden | Vastra Gotaland | 48234 | 1038 | 0 | 47196 | 58.2528 | 13.0596 | 2020-12-09 05:28:01 | Vastra Gotaland, Sweden | ||
2975553 | 2975553 | 2020-12-09 | Sweden | Vastra Gotaland | 49263 | 1065 | 0 | 48198 | 58.2528 | 13.0596 | 2020-12-10 05:26:19 | Vastra Gotaland, Sweden | ||
1600544 | 1600544 | 2020-12-10 | Sweden | Vastra Gotaland | 50353 | 1066 | 0 | 49287 | 58.2528 | 13.0596 | 2020-12-11 05:26:59 | Vastra Gotaland, Sweden | ||
845895 | 845895 | 2020-12-12 | Sweden | Vastra Gotaland | 51634 | 1082 | 0 | 50552 | 58.2528 | 13.0596 | 2020-12-13 05:27:20 | Vastra Gotaland, Sweden | ||
861002 | 861002 | 2020-12-11 | Sweden | Vastra Gotaland | 51634 | 1082 | 0 | 50552 | 58.2528 | 13.0596 | 2020-12-12 05:26:19 | Vastra Gotaland, Sweden | ||
1751593 | 1751593 | 2020-12-14 | Sweden | Vastra Gotaland | 51634 | 1082 | 0 | 50552 | 58.2528 | 13.0596 | 2020-12-15 05:26:38 | Vastra Gotaland, Sweden | ||
3848113 | 3848113 | 2020-12-13 | Sweden | Vastra Gotaland | 51634 | 1082 | 0 | 50552 | 58.2528 | 13.0596 | 2020-12-14 05:26:27 | Vastra Gotaland, Sweden | ||
1034699 | 1034699 | 2020-12-15 | Sweden | Vastra Gotaland | 55373 | 1085 | 0 | 54288 | 58.2528 | 13.0596 | 2020-12-16 05:28:04 | Vastra Gotaland, Sweden | ||
2128318 | 2128318 | 2020-12-17 | Sweden | Vastra Gotaland | 56682 | 1120 | 0 | 55562 | 58.2528 | 13.0596 | 2020-12-18 05:28:18 | Vastra Gotaland, Sweden | ||
3149918 | 3149918 | 2020-12-16 | Sweden | Vastra Gotaland | 55995 | 1120 | 0 | 54875 | 58.2528 | 13.0596 | 2020-12-17 05:28:12 | Vastra Gotaland, Sweden | ||
928018 | 928018 | 2020-12-21 | Sweden | Vastra Gotaland | 58876 | 1143 | 0 | 57733 | 58.2528 | 13.0596 | 2020-12-22 05:22:33 | Vastra Gotaland, Sweden | ||
1901492 | 1901492 | 2020-12-18 | Sweden | Vastra Gotaland | 58876 | 1143 | 0 | 57733 | 58.2528 | 13.0596 | 2020-12-19 05:27:52 | Vastra Gotaland, Sweden | ||
2120039 | 2120039 | 2020-12-20 | Sweden | Vastra Gotaland | 58876 | 1143 | 0 | 57733 | 58.2528 | 13.0596 | 2020-12-21 05:27:58 | Vastra Gotaland, Sweden | ||
2931546 | 2931546 | 2020-12-19 | Sweden | Vastra Gotaland | 58876 | 1143 | 0 | 57733 | 58.2528 | 13.0596 | 2020-12-20 05:27:32 | Vastra Gotaland, 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]);