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 day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
344597 | 344597 | 2020-09-14 | Sweden | Vastra Gotaland | 19224 | 857 | 0 | 18367 | 58.2528 | 13.0596 | 2020-09-15 03:22:50 | 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 | ||
547075 | 547075 | 2020-09-12 | Sweden | Vastra Gotaland | 19224 | 857 | 0 | 18367 | 58.2528 | 13.0596 | 2020-09-13 04:30:52 | Vastra Gotaland, Sweden | ||
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 | ||
1173505 | 1173505 | 2020-09-10 | Sweden | Vastra Gotaland | 19130 | 856 | 0 | 18274 | 58.2528 | 13.0596 | 2020-09-11 04:46:23 | Vastra Gotaland, Sweden | ||
2171870 | 2171870 | 2020-09-09 | Sweden | Vastra Gotaland | 19091 | 856 | 0 | 18235 | 58.2528 | 13.0596 | 2020-09-10 04:29:01 | Vastra Gotaland, Sweden | ||
1244079 | 1244079 | 2020-09-08 | Sweden | Vastra Gotaland | 19052 | 855 | 0 | 18197 | 58.2528 | 13.0596 | 2020-09-09 04:28:48 | Vastra Gotaland, Sweden | ||
427658 | 427658 | 2020-09-07 | Sweden | Vastra Gotaland | 19027 | 855 | 0 | 18172 | 58.2528 | 13.0596 | 2020-09-08 04:28:25 | Vastra Gotaland, Sweden | ||
3161943 | 3161943 | 2020-09-06 | Sweden | Vastra Gotaland | 18860 | 855 | 0 | 18005 | 58.2528 | 13.0596 | 2020-09-07 04:28:30 | Vastra Gotaland, Sweden | ||
813898 | 813898 | 2020-09-05 | Sweden | Vastra Gotaland | 18860 | 855 | 0 | 18005 | 58.2528 | 13.0596 | 2020-09-06 04:28:33 | Vastra Gotaland, Sweden | ||
2662098 | 2662098 | 2020-09-04 | Sweden | Vastra Gotaland | 18860 | 855 | 0 | 18005 | 58.2528 | 13.0596 | 2020-09-05 04:28:19 | Vastra Gotaland, Sweden | ||
1354638 | 1354638 | 2020-09-03 | Sweden | Vastra Gotaland | 18809 | 854 | 0 | 17955 | 58.2528 | 13.0596 | 2020-09-04 04:28:26 | Vastra Gotaland, Sweden | ||
1105875 | 1105875 | 2020-09-02 | Sweden | Vastra Gotaland | 18768 | 854 | 0 | 17914 | 58.2528 | 13.0596 | 2020-09-03 04:28:22 | Vastra Gotaland, Sweden | ||
2060204 | 2060204 | 2020-09-01 | Sweden | Vastra Gotaland | 18820 | 852 | 0 | 17968 | 58.2528 | 13.0596 | 2020-09-02 04:28:25 | Vastra Gotaland, Sweden | ||
194389 | 194389 | 2020-08-31 | Sweden | Vastra Gotaland | 18815 | 852 | 0 | 17963 | 58.2528 | 13.0596 | 2020-09-01 04:28:31 | Vastra Gotaland, Sweden | ||
3932348 | 3932348 | 2020-08-30 | Sweden | Vastra Gotaland | 18688 | 851 | 0 | 17837 | 58.2528 | 13.0596 | 2020-08-31 04:28:27 | Vastra Gotaland, Sweden | ||
610010 | 610010 | 2020-08-29 | Sweden | Vastra Gotaland | 18688 | 851 | 0 | 17837 | 58.2528 | 13.0596 | 2020-08-30 04:28:22 | Vastra Gotaland, Sweden | ||
1523505 | 1523505 | 2020-08-28 | Sweden | Vastra Gotaland | 18688 | 851 | 0 | 17837 | 58.2528 | 13.0596 | 2020-08-29 04:28:19 | Vastra Gotaland, Sweden | ||
2510506 | 2510506 | 2020-08-27 | Sweden | Vastra Gotaland | 18776 | 851 | 0 | 17925 | 58.2528 | 13.0596 | 2020-08-28 04:28:11 | Vastra Gotaland, Sweden | ||
1996966 | 1996966 | 2020-08-26 | Sweden | Vastra Gotaland | 20111 | 851 | 0 | 19260 | 58.2528 | 13.0596 | 2020-08-27 04:28:15 | Vastra Gotaland, Sweden | ||
3562890 | 3562890 | 2020-08-25 | Sweden | Vastra Gotaland | 20098 | 849 | 0 | 19249 | 58.2528 | 13.0596 | 2020-08-26 04:28:11 | 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]);