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)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1269960 | 1269960 | 2020-06-05 | Sweden | Vastra Gotaland | 7218 | 600 | 0 | 6618 | 58.2528 | 13.0596 | 2020-06-06 02:33:00 | Vastra Gotaland, Sweden | ||
217410 | 217410 | 2020-06-08 | Sweden | Vastra Gotaland | 8128 | 602 | 0 | 7526 | 58.2528 | 13.0596 | 2020-06-09 03:33:03 | Vastra Gotaland, Sweden | ||
574263 | 574263 | 2020-06-06 | Sweden | Vastra Gotaland | 7589 | 602 | 0 | 6987 | 58.2528 | 13.0596 | 2020-06-07 03:53:30 | Vastra Gotaland, Sweden | ||
2800207 | 2800207 | 2020-06-07 | Sweden | Vastra Gotaland | 7973 | 602 | 0 | 7371 | 58.2528 | 13.0596 | 2020-06-08 03:33:22 | Vastra Gotaland, Sweden | ||
1210983 | 1210983 | 2020-06-09 | Sweden | Vastra Gotaland | 8383 | 604 | 0 | 7779 | 58.2528 | 13.0596 | 2020-06-10 04:07:00 | Vastra Gotaland, Sweden | ||
2864165 | 2864165 | 2020-06-10 | Sweden | Vastra Gotaland | 8608 | 631 | 0 | 7977 | 58.2528 | 13.0596 | 2020-06-11 03:33:41 | Vastra Gotaland, Sweden | ||
1273725 | 1273725 | 2020-06-11 | Sweden | Vastra Gotaland | 9255 | 632 | 0 | 8623 | 58.2528 | 13.0596 | 2020-06-12 05:09:52 | Vastra Gotaland, Sweden | ||
737755 | 737755 | 2020-06-12 | Sweden | Vastra Gotaland | 9752 | 647 | 0 | 9105 | 58.2528 | 13.0596 | 2020-06-13 03:33:14 | Vastra Gotaland, 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 | ||
3061435 | 3061435 | 2020-06-13 | Sweden | Vastra Gotaland | 10231 | 647 | 0 | 9584 | 58.2528 | 13.0596 | 2020-06-14 03:33:15 | Vastra Gotaland, Sweden | ||
287432 | 287432 | 2020-06-15 | Sweden | Vastra Gotaland | 10743 | 649 | 0 | 10094 | 58.2528 | 13.0596 | 2020-06-16 04:33:09 | Vastra Gotaland, Sweden | ||
2386869 | 2386869 | 2020-06-16 | Sweden | Vastra Gotaland | 11083 | 649 | 0 | 10434 | 58.2528 | 13.0596 | 2020-06-17 04:33:21 | Vastra Gotaland, Sweden | ||
1196106 | 1196106 | 2020-06-17 | Sweden | Vastra Gotaland | 11455 | 679 | 0 | 10776 | 58.2528 | 13.0596 | 2020-06-18 04:33:18 | Vastra Gotaland, Sweden | ||
1691754 | 1691754 | 2020-06-19 | Sweden | Vastra Gotaland | 11828 | 679 | 0 | 11149 | 58.2528 | 13.0596 | 2020-06-20 04:33:19 | Vastra Gotaland, Sweden | ||
2438176 | 2438176 | 2020-06-20 | Sweden | Vastra Gotaland | 11828 | 679 | 0 | 11149 | 58.2528 | 13.0596 | 2020-06-21 04:33:19 | Vastra Gotaland, Sweden | ||
3249583 | 3249583 | 2020-06-21 | Sweden | Vastra Gotaland | 11828 | 679 | 0 | 11149 | 58.2528 | 13.0596 | 2020-06-22 04:33:20 | Vastra Gotaland, Sweden | ||
3682903 | 3682903 | 2020-06-18 | Sweden | Vastra Gotaland | 11828 | 679 | 0 | 11149 | 58.2528 | 13.0596 | 2020-06-19 04:33:17 | Vastra Gotaland, Sweden | ||
1510844 | 1510844 | 2020-06-22 | Sweden | Vastra Gotaland | 12853 | 698 | 0 | 12155 | 58.2528 | 13.0596 | 2020-06-23 04:33:22 | Vastra Gotaland, Sweden | ||
1522650 | 1522650 | 2020-06-23 | Sweden | Vastra Gotaland | 13065 | 701 | 0 | 12364 | 58.2528 | 13.0596 | 2020-06-24 04:33:28 | Vastra Gotaland, Sweden | ||
2625325 | 2625325 | 2020-06-25 | Sweden | Vastra Gotaland | 14013 | 713 | 0 | 13300 | 58.2528 | 13.0596 | 2020-06-26 04:33:43 | Vastra Gotaland, Sweden | ||
2700965 | 2700965 | 2020-06-24 | Sweden | Vastra Gotaland | 13510 | 713 | 0 | 12797 | 58.2528 | 13.0596 | 2020-06-25 05:26:54 | Vastra Gotaland, Sweden | ||
1136338 | 1136338 | 2020-06-26 | Sweden | Vastra Gotaland | 14384 | 742 | 0 | 13642 | 58.2528 | 13.0596 | 2020-06-27 04:33:35 | Vastra Gotaland, Sweden | ||
2040057 | 2040057 | 2020-06-27 | Sweden | Vastra Gotaland | 14384 | 742 | 0 | 13642 | 58.2528 | 13.0596 | 2020-06-28 04:34:04 | Vastra Gotaland, Sweden | ||
2306722 | 2306722 | 2020-06-28 | Sweden | Vastra Gotaland | 14384 | 742 | 0 | 13642 | 58.2528 | 13.0596 | 2020-06-29 04:33:44 | Vastra Gotaland, Sweden | ||
2633159 | 2633159 | 2020-06-29 | Sweden | Vastra Gotaland | 15006 | 745 | 0 | 14261 | 58.2528 | 13.0596 | 2020-06-30 04:33:48 | Vastra Gotaland, Sweden | ||
2974682 | 2974682 | 2020-06-30 | Sweden | Vastra Gotaland | 15173 | 745 | 0 | 14428 | 58.2528 | 13.0596 | 2020-07-01 04:33:52 | Vastra Gotaland, Sweden | ||
303304 | 303304 | 2020-07-01 | Sweden | Vastra Gotaland | 15408 | 761 | 0 | 14647 | 58.2528 | 13.0596 | 2020-07-02 04:33:46 | Vastra Gotaland, Sweden | ||
415595 | 415595 | 2020-07-05 | Sweden | Vastra Gotaland | 15759 | 762 | 0 | 14997 | 58.2528 | 13.0596 | 2020-07-06 04:33:57 | Vastra Gotaland, Sweden | ||
530157 | 530157 | 2020-07-04 | Sweden | Vastra Gotaland | 15759 | 762 | 0 | 14997 | 58.2528 | 13.0596 | 2020-07-05 04:33:46 | Vastra Gotaland, Sweden | ||
2234818 | 2234818 | 2020-07-03 | Sweden | Vastra Gotaland | 15759 | 762 | 0 | 14997 | 58.2528 | 13.0596 | 2020-07-04 04:33:51 | Vastra Gotaland, Sweden | ||
2685130 | 2685130 | 2020-07-06 | Sweden | Vastra Gotaland | 16210 | 762 | 0 | 15448 | 58.2528 | 13.0596 | 2020-07-07 04:34:00 | Vastra Gotaland, Sweden | ||
3045613 | 3045613 | 2020-07-02 | Sweden | Vastra Gotaland | 15628 | 762 | 0 | 14866 | 58.2528 | 13.0596 | 2020-07-03 04:33:54 | Vastra Gotaland, Sweden | ||
887570 | 887570 | 2020-07-07 | Sweden | Vastra Gotaland | 16231 | 763 | 0 | 15468 | 58.2528 | 13.0596 | 2020-07-08 05:33:48 | Vastra Gotaland, Sweden | ||
1005746 | 1005746 | 2020-07-09 | Sweden | Vastra Gotaland | 16507 | 781 | 0 | 15726 | 58.2528 | 13.0596 | 2020-07-10 04:34:24 | Vastra Gotaland, Sweden | ||
2222961 | 2222961 | 2020-07-08 | Sweden | Vastra Gotaland | 16403 | 781 | 0 | 15622 | 58.2528 | 13.0596 | 2020-07-09 04:34:23 | Vastra Gotaland, Sweden | ||
2158964 | 2158964 | 2020-07-14 | Sweden | Vastra Gotaland | 16894 | 789 | 0 | 16105 | 58.2528 | 13.0596 | 2020-07-15 04:34:39 | Vastra Gotaland, Sweden | ||
3237761 | 3237761 | 2020-07-10 | Sweden | Vastra Gotaland | 16650 | 789 | 0 | 15861 | 58.2528 | 13.0596 | 2020-07-11 04:34:26 | Vastra Gotaland, Sweden | ||
3436263 | 3436263 | 2020-07-11 | Sweden | Vastra Gotaland | 16650 | 789 | 0 | 15861 | 58.2528 | 13.0596 | 2020-07-12 04:34:30 | Vastra Gotaland, Sweden | ||
3491605 | 3491605 | 2020-07-13 | Sweden | Vastra Gotaland | 16873 | 789 | 0 | 16084 | 58.2528 | 13.0596 | 2020-07-14 04:34:46 | Vastra Gotaland, Sweden | ||
3737868 | 3737868 | 2020-07-12 | Sweden | Vastra Gotaland | 16650 | 789 | 0 | 15861 | 58.2528 | 13.0596 | 2020-07-13 04:43:04 | Vastra Gotaland, Sweden | ||
367652 | 367652 | 2020-07-16 | Sweden | Vastra Gotaland | 17126 | 798 | 0 | 16328 | 58.2528 | 13.0596 | 2020-07-17 04:34:50 | Vastra Gotaland, Sweden | ||
2748320 | 2748320 | 2020-07-15 | Sweden | Vastra Gotaland | 16983 | 798 | 0 | 16185 | 58.2528 | 13.0596 | 2020-07-16 04:44:59 | Vastra Gotaland, Sweden | ||
122151 | 122151 | 2020-07-19 | Sweden | Vastra Gotaland | 17232 | 809 | 0 | 16423 | 58.2528 | 13.0596 | 2020-07-20 05:34:40 | Vastra Gotaland, Sweden | ||
327246 | 327246 | 2020-07-20 | Sweden | Vastra Gotaland | 17484 | 809 | 0 | 16675 | 58.2528 | 13.0596 | 2020-07-21 04:38:46 | Vastra Gotaland, Sweden | ||
1707755 | 1707755 | 2020-07-21 | Sweden | Vastra Gotaland | 17500 | 809 | 0 | 16691 | 58.2528 | 13.0596 | 2020-07-22 04:34:42 | Vastra Gotaland, Sweden | ||
2708843 | 2708843 | 2020-07-17 | Sweden | Vastra Gotaland | 17232 | 809 | 0 | 16423 | 58.2528 | 13.0596 | 2020-07-18 04:34:45 | Vastra Gotaland, Sweden | ||
3205540 | 3205540 | 2020-07-18 | Sweden | Vastra Gotaland | 17232 | 809 | 0 | 16423 | 58.2528 | 13.0596 | 2020-07-19 04:34:58 | Vastra Gotaland, Sweden | ||
62199 | 62199 | 2020-07-23 | Sweden | Vastra Gotaland | 17658 | 822 | 0 | 16836 | 58.2528 | 13.0596 | 2020-07-24 05:30:40 | Vastra Gotaland, Sweden | ||
845016 | 845016 | 2020-07-22 | Sweden | Vastra Gotaland | 17571 | 822 | 0 | 16749 | 58.2528 | 13.0596 | 2020-07-23 05:15:04 | Vastra Gotaland, Sweden | ||
177469 | 177469 | 2020-07-27 | Sweden | Vastra Gotaland | 17850 | 828 | 0 | 17022 | 58.2528 | 13.0596 | 2020-07-28 04:58:43 | Vastra Gotaland, Sweden | ||
442782 | 442782 | 2020-07-26 | Sweden | Vastra Gotaland | 17732 | 828 | 0 | 16904 | 58.2528 | 13.0596 | 2020-07-27 04:35:02 | Vastra Gotaland, Sweden | ||
1503025 | 1503025 | 2020-07-25 | Sweden | Vastra Gotaland | 17732 | 828 | 0 | 16904 | 58.2528 | 13.0596 | 2020-07-26 04:35:00 | Vastra Gotaland, Sweden | ||
2563996 | 2563996 | 2020-07-24 | Sweden | Vastra Gotaland | 17732 | 828 | 0 | 16904 | 58.2528 | 13.0596 | 2020-07-25 04:47:39 | Vastra Gotaland, Sweden | ||
3185419 | 3185419 | 2020-07-28 | Sweden | Vastra Gotaland | 17859 | 828 | 0 | 17031 | 58.2528 | 13.0596 | 2020-07-29 04:35:11 | Vastra Gotaland, Sweden | ||
1928634 | 1928634 | 2020-07-30 | Sweden | Vastra Gotaland | 18065 | 836 | 0 | 17229 | 58.2528 | 13.0596 | 2020-07-31 04:35:18 | Vastra Gotaland, Sweden | ||
2958802 | 2958802 | 2020-07-29 | Sweden | Vastra Gotaland | 17970 | 836 | 0 | 17134 | 58.2528 | 13.0596 | 2020-07-30 04:35:05 | Vastra Gotaland, Sweden | ||
753763 | 753763 | 2020-08-01 | Sweden | Vastra Gotaland | 18205 | 838 | 0 | 17367 | 58.2528 | 13.0596 | 2020-08-02 04:34:47 | Vastra Gotaland, Sweden | ||
2808195 | 2808195 | 2020-08-02 | Sweden | Vastra Gotaland | 18205 | 838 | 0 | 17367 | 58.2528 | 13.0596 | 2020-08-03 04:34:35 | Vastra Gotaland, Sweden | ||
3264928 | 3264928 | 2020-07-31 | Sweden | Vastra Gotaland | 18205 | 838 | 0 | 17367 | 58.2528 | 13.0596 | 2020-08-01 04:36:27 | Vastra Gotaland, Sweden | ||
98560 | 98560 | 2020-08-04 | Sweden | Vastra Gotaland | 18471 | 839 | 0 | 17632 | 58.2528 | 13.0596 | 2020-08-05 04:34:43 | Vastra Gotaland, Sweden | ||
2740443 | 2740443 | 2020-08-03 | Sweden | Vastra Gotaland | 18450 | 839 | 0 | 17611 | 58.2528 | 13.0596 | 2020-08-04 04:41:59 | Vastra Gotaland, Sweden | ||
371625 | 371625 | 2020-08-08 | Sweden | Vastra Gotaland | 18881 | 842 | 0 | 18039 | 58.2528 | 13.0596 | 2020-08-09 04:34:54 | Vastra Gotaland, Sweden | ||
458809 | 458809 | 2020-08-07 | Sweden | Vastra Gotaland | 18881 | 842 | 0 | 18039 | 58.2528 | 13.0596 | 2020-08-08 04:34:53 | Vastra Gotaland, Sweden | ||
662621 | 662621 | 2020-08-11 | Sweden | Vastra Gotaland | 19123 | 842 | 0 | 18281 | 58.2528 | 13.0596 | 2020-08-12 04:27:29 | Vastra Gotaland, Sweden | ||
1920648 | 1920648 | 2020-08-10 | Sweden | Vastra Gotaland | 19120 | 842 | 0 | 18278 | 58.2528 | 13.0596 | 2020-08-11 04:35:08 | Vastra Gotaland, Sweden | ||
3531772 | 3531772 | 2020-08-12 | Sweden | Vastra Gotaland | 19204 | 842 | 0 | 18362 | 58.2528 | 13.0596 | 2020-08-13 04:29:15 | Vastra Gotaland, Sweden | ||
3612494 | 3612494 | 2020-08-06 | Sweden | Vastra Gotaland | 18742 | 842 | 0 | 17900 | 58.2528 | 13.0596 | 2020-08-07 04:35:11 | Vastra Gotaland, Sweden | ||
3793324 | 3793324 | 2020-08-05 | Sweden | Vastra Gotaland | 18580 | 842 | 0 | 17738 | 58.2528 | 13.0596 | 2020-08-06 04:35:02 | Vastra Gotaland, Sweden | ||
3923457 | 3923457 | 2020-08-09 | Sweden | Vastra Gotaland | 18881 | 842 | 0 | 18039 | 58.2528 | 13.0596 | 2020-08-10 04:34:55 | Vastra Gotaland, Sweden | ||
583153 | 583153 | 2020-08-13 | Sweden | Vastra Gotaland | 19299 | 843 | 0 | 18456 | 58.2528 | 13.0596 | 2020-08-14 04:51:19 | Vastra Gotaland, Sweden | ||
146294 | 146294 | 2020-08-15 | Sweden | Vastra Gotaland | 19427 | 844 | 0 | 18583 | 58.2528 | 13.0596 | 2020-08-16 04:27:42 | Vastra Gotaland, Sweden | ||
1556292 | 1556292 | 2020-08-16 | Sweden | Vastra Gotaland | 19427 | 844 | 0 | 18583 | 58.2528 | 13.0596 | 2020-08-17 04:27:20 | Vastra Gotaland, Sweden | ||
1612569 | 1612569 | 2020-08-14 | Sweden | Vastra Gotaland | 19427 | 844 | 0 | 18583 | 58.2528 | 13.0596 | 2020-08-15 04:27:31 | Vastra Gotaland, Sweden | ||
837934 | 837934 | 2020-08-17 | Sweden | Vastra Gotaland | 19698 | 845 | 0 | 18853 | 58.2528 | 13.0596 | 2020-08-18 04:27:56 | Vastra Gotaland, Sweden | ||
3178330 | 3178330 | 2020-08-18 | Sweden | Vastra Gotaland | 19701 | 845 | 0 | 18856 | 58.2528 | 13.0596 | 2020-08-19 04:27:00 | Vastra Gotaland, Sweden | ||
206576 | 206576 | 2020-08-19 | Sweden | Vastra Gotaland | 19713 | 848 | 0 | 18865 | 58.2528 | 13.0596 | 2020-08-20 04:27:43 | Vastra Gotaland, Sweden | ||
3484627 | 3484627 | 2020-08-20 | Sweden | Vastra Gotaland | 19813 | 848 | 0 | 18965 | 58.2528 | 13.0596 | 2020-08-21 04:27:41 | Vastra Gotaland, Sweden | ||
1479878 | 1479878 | 2020-08-21 | Sweden | Vastra Gotaland | 19898 | 849 | 0 | 19049 | 58.2528 | 13.0596 | 2020-08-22 04:27:49 | Vastra Gotaland, Sweden | ||
2215989 | 2215989 | 2020-08-23 | Sweden | Vastra Gotaland | 19898 | 849 | 0 | 19049 | 58.2528 | 13.0596 | 2020-08-24 04:27:56 | Vastra Gotaland, Sweden | ||
2299771 | 2299771 | 2020-08-22 | Sweden | Vastra Gotaland | 19898 | 849 | 0 | 19049 | 58.2528 | 13.0596 | 2020-08-23 04:27:48 | Vastra Gotaland, Sweden | ||
2991594 | 2991594 | 2020-08-24 | Sweden | Vastra Gotaland | 20092 | 849 | 0 | 19243 | 58.2528 | 13.0596 | 2020-08-25 04:28:02 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);