⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

385 rows where country_or_region = "Sweden" and province_or_state = "Gotland" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Gotland · 385

country_or_region

  • Sweden · 385
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
235230 2021-06-24 Sweden Gotland     4000 52 0 3948 57.4684 18.4867 2021-06-25 04:21:33 Gotland, Sweden
472177 2021-06-23 Sweden Gotland     3996 52 0 3944 57.4684 18.4867 2021-06-24 04:21:55 Gotland, Sweden
627235 2021-06-22 Sweden Gotland     3996 51 0 3945 57.4684 18.4867 2021-06-23 04:21:46 Gotland, Sweden
227255 2021-06-21 Sweden Gotland     3988 51 0 3937 57.4684 18.4867 2021-06-22 04:21:34 Gotland, Sweden
1472777 2021-06-20 Sweden Gotland     3988 51 0 3937 57.4684 18.4867 2021-06-21 04:21:41 Gotland, Sweden
1304018 2021-06-19 Sweden Gotland     3988 51 0 3937 57.4684 18.4867 2021-06-20 04:21:48 Gotland, Sweden
303620 2021-06-18 Sweden Gotland     3988 51 0 3937 57.4684 18.4867 2021-06-19 04:22:33 Gotland, Sweden
886450 2021-06-17 Sweden Gotland     3988 51 0 3937 57.4684 18.4867 2021-06-18 04:22:16 Gotland, Sweden
42345 2021-06-16 Sweden Gotland     3988 51 0 3937 57.4684 18.4867 2021-06-17 04:22:36 Gotland, Sweden
1705167 2021-06-15 Sweden Gotland     3988 51 0 3937 57.4684 18.4867 2021-06-16 04:22:32 Gotland, Sweden
1661438 2021-06-14 Sweden Gotland     3985 51 0 3934 57.4684 18.4867 2021-06-15 04:22:22 Gotland, Sweden
319514 2021-06-13 Sweden Gotland     3985 51 0 3934 57.4684 18.4867 2021-06-14 04:22:46 Gotland, Sweden
619259 2021-06-12 Sweden Gotland     3985 51 0 3934 57.4684 18.4867 2021-06-13 04:22:44 Gotland, Sweden
592268 2021-06-11 Sweden Gotland     3985 51 0 3934 57.4684 18.4867 2021-06-12 04:22:22 Gotland, Sweden
273146 2021-06-10 Sweden Gotland     3983 51 0 3932 57.4684 18.4867 2021-06-11 04:23:20 Gotland, Sweden
1638204 2021-06-09 Sweden Gotland     3982 51 0 3931 57.4684 18.4867 2021-06-10 04:23:17 Gotland, Sweden
1744817 2021-06-08 Sweden Gotland     3978 51 0 3927 57.4684 18.4867 2021-06-09 04:23:31 Gotland, Sweden
577360 2021-06-07 Sweden Gotland     3964 51 0 3913 57.4684 18.4867 2021-06-08 04:22:35 Gotland, Sweden
246223 2021-06-06 Sweden Gotland     3964 51 0 3913 57.4684 18.4867 2021-06-07 04:22:51 Gotland, Sweden
674200 2021-06-05 Sweden Gotland     3964 51 0 3913 57.4684 18.4867 2021-06-06 04:24:03 Gotland, Sweden
553463 2021-06-04 Sweden Gotland     3964 51 0 3913 57.4684 18.4867 2021-06-05 04:23:03 Gotland, Sweden
1460860 2021-06-03 Sweden Gotland     3960 51 0 3909 57.4684 18.4867 2021-06-04 04:23:37 Gotland, Sweden
1399853 2021-06-02 Sweden Gotland     3939 51 0 3888 57.4684 18.4867 2021-06-03 04:23:32 Gotland, Sweden
1709200 2021-06-01 Sweden Gotland     3939 51 0 3888 57.4684 18.4867 2021-06-02 04:24:34 Gotland, Sweden
19430 2021-05-31 Sweden Gotland     3939 51 0 3888 57.4684 18.4867 2021-06-01 04:23:09 Gotland, Sweden
1497823 2021-05-30 Sweden Gotland     3939 51 0 3888 57.4684 18.4867 2021-05-31 03:08:59 Gotland, Sweden
623246 2021-05-29 Sweden Gotland     3939 51 0 3888 57.4684 18.4867 2021-05-30 04:20:55 Gotland, Sweden
81102 2021-05-28 Sweden Gotland     3939 51 0 3888 57.4684 18.4867 2021-05-29 04:20:41 Gotland, Sweden
1426377 2021-05-27 Sweden Gotland     3939 51 0 3888 57.4684 18.4867 2021-05-28 04:20:36 Gotland, Sweden
1549344 2021-05-26 Sweden Gotland     3933 51 0 3882 57.4684 18.4867 2021-05-27 04:20:59 Gotland, Sweden
1200920 2021-05-25 Sweden Gotland     3925 51 0 3874 57.4684 18.4867 2021-05-26 04:20:35 Gotland, Sweden
149913 2021-05-24 Sweden Gotland     3898 51 0 3847 57.4684 18.4867 2021-05-25 04:21:08 Gotland, Sweden
690066 2021-05-23 Sweden Gotland     3898 51 0 3847 57.4684 18.4867 2021-05-24 04:20:53 Gotland, Sweden
387680 2021-05-22 Sweden Gotland     3898 51 0 3847 57.4684 18.4867 2021-05-23 04:20:51 Gotland, Sweden
969995 2021-05-21 Sweden Gotland     3898 51 0 3847 57.4684 18.4867 2021-05-22 04:20:45 Gotland, Sweden
57957 2021-05-20 Sweden Gotland     3886 51 0 3835 57.4684 18.4867 2021-05-21 04:20:43 Gotland, Sweden
464219 2021-05-19 Sweden Gotland     3870 51 0 3819 57.4684 18.4867 2021-05-20 04:21:05 Gotland, Sweden
1276175 2021-05-18 Sweden Gotland     3863 51 0 3812 57.4684 18.4867 2021-05-19 04:20:42 Gotland, Sweden
231239 2021-05-17 Sweden Gotland     3822 51 0 3771 57.4684 18.4867 2021-05-18 04:20:33 Gotland, Sweden
1159454 2021-05-16 Sweden Gotland     3822 51 0 3771 57.4684 18.4867 2021-05-17 04:20:34 Gotland, Sweden
1009010 2021-05-15 Sweden Gotland     3822 51 0 3771 57.4684 18.4867 2021-05-16 04:20:49 Gotland, Sweden
805122 2021-05-14 Sweden Gotland     3822 51 0 3771 57.4684 18.4867 2021-05-15 04:20:58 Gotland, Sweden
1192950 2021-05-13 Sweden Gotland     3783 51 0 3732 57.4684 18.4867 2021-05-14 04:20:41 Gotland, Sweden
686079 2021-05-12 Sweden Gotland     3783 51 0 3732 57.4684 18.4867 2021-05-13 04:20:51 Gotland, Sweden
129479 2021-05-11 Sweden Gotland     3768 51 0 3717 57.4684 18.4867 2021-05-12 04:21:29 Gotland, Sweden
1257484 2021-05-10 Sweden Gotland     3715 51 0 3664 57.4684 18.4867 2021-05-11 04:20:41 Gotland, Sweden
121505 2021-05-09 Sweden Gotland     3715 51 0 3664 57.4684 18.4867 2021-05-10 04:20:38 Gotland, Sweden
89075 2021-05-08 Sweden Gotland     3715 51 0 3664 57.4684 18.4867 2021-05-09 04:20:35 Gotland, Sweden
522573 2021-05-07 Sweden Gotland     3715 51 0 3664 57.4684 18.4867 2021-05-08 04:21:04 Gotland, Sweden
1685197 2021-05-06 Sweden Gotland     3705 51 0 3654 57.4684 18.4867 2021-05-07 04:20:40 Gotland, Sweden
23416 2021-05-05 Sweden Gotland     3677 51 0 3626 57.4684 18.4867 2021-05-06 04:20:38 Gotland, Sweden
1331358 2021-05-04 Sweden Gotland     3663 51 0 3612 57.4684 18.4867 2021-05-05 04:20:43 Gotland, Sweden
1035945 2021-05-03 Sweden Gotland     3617 51 0 3566 57.4684 18.4867 2021-05-04 04:20:34 Gotland, Sweden
914135 2021-05-02 Sweden Gotland     3617 51 0 3566 57.4684 18.4867 2021-05-03 04:20:39 Gotland, Sweden
1757101 2021-05-01 Sweden Gotland     3617 51 0 3566 57.4684 18.4867 2021-05-02 04:20:48 Gotland, Sweden
1456872 2021-04-30 Sweden Gotland     3617 51 0 3566 57.4684 18.4867 2021-05-01 04:20:47 Gotland, Sweden
1614686 2021-04-29 Sweden Gotland     3604 50 0 3554 57.4684 18.4867 2021-04-30 04:21:03 Gotland, Sweden
484085 2021-04-28 Sweden Gotland     3598 49 0 3549 57.4684 18.4867 2021-04-29 04:20:55 Gotland, Sweden
335123 2021-04-27 Sweden Gotland     3584 49 0 3535 57.4684 18.4867 2021-04-28 04:20:32 Gotland, Sweden
1358168 2021-04-26 Sweden Gotland     3533 48 0 3485 57.4684 18.4867 2021-04-27 04:20:52 Gotland, Sweden
496124 2021-04-25 Sweden Gotland     3533 48 0 3485 57.4684 18.4867 2021-04-26 04:21:04 Gotland, Sweden
1112723 2021-04-24 Sweden Gotland     3533 48 0 3485 57.4684 18.4867 2021-04-25 04:20:32 Gotland, Sweden
488072 2021-04-23 Sweden Gotland     3533 48 0 3485 57.4684 18.4867 2021-04-24 04:20:38 Gotland, Sweden
1170457 2021-04-22 Sweden Gotland     3507 48 0 3459 57.4684 18.4867 2021-04-23 04:20:52 Gotland, Sweden
1403928 2021-04-21 Sweden Gotland     3476 48 0 3428 57.4684 18.4867 2021-04-22 04:20:53 Gotland, Sweden
1713186 2021-04-20 Sweden Gotland     3461 48 0 3413 57.4684 18.4867 2021-04-21 04:21:14 Gotland, Sweden
607315 2021-04-19 Sweden Gotland     3358 48 0 3310 57.4684 18.4867 2021-04-20 04:20:41 Gotland, Sweden
918122 2021-04-18 Sweden Gotland     3358 48 0 3310 57.4684 18.4867 2021-04-19 04:20:57 Gotland, Sweden
1319433 2021-04-17 Sweden Gotland     3358 48 0 3310 57.4684 18.4867 2021-04-18 04:20:41 Gotland, Sweden
989125 2021-04-16 Sweden Gotland     3358 48 0 3310 57.4684 18.4867 2021-04-17 04:20:40 Gotland, Sweden
380229 2021-04-15 Sweden Gotland     3316 48 0 3268 57.4684 18.4867 2021-04-16 04:20:46 Gotland, Sweden
906179 2021-04-14 Sweden Gotland     3292 48 0 3244 57.4684 18.4867 2021-04-15 04:20:54 Gotland, Sweden
1079406 2021-04-13 Sweden Gotland     3279 48 0 3231 57.4684 18.4867 2021-04-14 04:20:41 Gotland, Sweden
354642 2021-04-12 Sweden Gotland     3196 47 0 3149 57.4684 18.4867 2021-04-13 04:20:37 Gotland, Sweden
1181091 2021-04-11 Sweden Gotland     3196 47 0 3149 57.4684 18.4867 2021-04-12 04:21:00 Gotland, Sweden
1188963 2021-04-10 Sweden Gotland     3196 47 0 3149 57.4684 18.4867 2021-04-11 04:20:56 Gotland, Sweden
1693149 2021-04-09 Sweden Gotland     3196 47 0 3149 57.4684 18.4867 2021-04-10 04:20:59 Gotland, Sweden
569388 2021-04-08 Sweden Gotland     3160 47 0 3113 57.4684 18.4867 2021-04-09 04:21:13 Gotland, Sweden
1346207 2021-04-07 Sweden Gotland     3136 47 0 3089 57.4684 18.4867 2021-04-08 04:21:13 Gotland, Sweden
350575 2021-04-06 Sweden Gotland     3120 47 0 3073 57.4684 18.4867 2021-04-07 04:20:53 Gotland, Sweden
1043900 2021-04-05 Sweden Gotland     3062 46 0 3016 57.4684 18.4867 2021-04-06 04:20:32 Gotland, Sweden
215220 2021-04-04 Sweden Gotland     3062 46 0 3016 57.4684 18.4867 2021-04-05 04:20:35 Gotland, Sweden
1701179 2021-04-03 Sweden Gotland     3062 46 0 3016 57.4684 18.4867 2021-04-04 04:20:49 Gotland, Sweden
953868 2021-04-02 Sweden Gotland     3062 46 0 3016 57.4684 18.4867 2021-04-03 04:20:44 Gotland, Sweden
125492 2021-04-01 Sweden Gotland     3062 46 0 3016 57.4684 18.4867 2021-04-02 04:20:36 Gotland, Sweden
1516384 2021-03-31 Sweden Gotland     3027 46 0 2981 57.4684 18.4867 2021-04-01 04:27:05 Gotland, Sweden
1717173 2021-03-30 Sweden Gotland     3009 46 0 2963 57.4684 18.4867 2021-03-31 04:26:25 Gotland, Sweden
733160 2021-03-29 Sweden Gotland     2947 46 0 2901 57.4684 18.4867 2021-03-30 04:26:23 Gotland, Sweden
422464 2021-03-28 Sweden Gotland     2947 46 0 2901 57.4684 18.4867 2021-03-29 04:28:35 Gotland, Sweden
1732855 2021-03-27 Sweden Gotland     2947 46 0 2901 57.4684 18.4867 2021-03-28 05:28:10 Gotland, Sweden
403298 2021-03-26 Sweden Gotland     2947 46 0 2901 57.4684 18.4867 2021-03-27 05:25:04 Gotland, Sweden
1354181 2021-03-25 Sweden Gotland     2939 46 0 2893 57.4684 18.4867 2021-03-26 05:26:55 Gotland, Sweden
507871 2021-03-24 Sweden Gotland     2924 46 0 2878 57.4684 18.4867 2021-03-25 05:27:00 Gotland, Sweden
1590788 2021-03-23 Sweden Gotland     2902 46 0 2856 57.4684 18.4867 2021-03-24 05:25:40 Gotland, Sweden
840180 2021-03-22 Sweden Gotland     2872 46 0 2826 57.4684 18.4867 2021-03-23 05:26:18 Gotland, Sweden
721420 2021-03-21 Sweden Gotland     2872 46 0 2826 57.4684 18.4867 2021-03-22 05:25:43 Gotland, Sweden
442563 2021-03-20 Sweden Gotland     2872 46 0 2826 57.4684 18.4867 2021-03-21 05:25:44 Gotland, Sweden
545505 2021-03-19 Sweden Gotland     2872 46 0 2826 57.4684 18.4867 2021-03-20 05:25:46 Gotland, Sweden
1350194 2021-03-18 Sweden Gotland     2858 46 0 2812 57.4684 18.4867 2021-03-19 05:26:09 Gotland, Sweden
85088 2021-03-17 Sweden Gotland     2836 46 0 2790 57.4684 18.4867 2021-03-18 05:26:22 Gotland, Sweden

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);