⚠️ 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 = "Vasterbotten" sorted by day descending

View and edit SQL

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

province_or_state

  • Vasterbotten · 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
235244 2021-06-24 Sweden Vasterbotten     23392 181 0 23211 65.3337 16.5162 2021-06-25 04:21:33 Vasterbotten, Sweden
472191 2021-06-23 Sweden Vasterbotten     23387 181 0 23206 65.3337 16.5162 2021-06-24 04:21:55 Vasterbotten, Sweden
627249 2021-06-22 Sweden Vasterbotten     23369 181 0 23188 65.3337 16.5162 2021-06-23 04:21:46 Vasterbotten, Sweden
227269 2021-06-21 Sweden Vasterbotten     23298 181 0 23117 65.3337 16.5162 2021-06-22 04:21:34 Vasterbotten, Sweden
1472791 2021-06-20 Sweden Vasterbotten     23298 181 0 23117 65.3337 16.5162 2021-06-21 04:21:41 Vasterbotten, Sweden
1304032 2021-06-19 Sweden Vasterbotten     23298 181 0 23117 65.3337 16.5162 2021-06-20 04:21:48 Vasterbotten, Sweden
303634 2021-06-18 Sweden Vasterbotten     23298 181 0 23117 65.3337 16.5162 2021-06-19 04:22:33 Vasterbotten, Sweden
886464 2021-06-17 Sweden Vasterbotten     23298 181 0 23117 65.3337 16.5162 2021-06-18 04:22:16 Vasterbotten, Sweden
42359 2021-06-16 Sweden Vasterbotten     23298 181 0 23117 65.3337 16.5162 2021-06-17 04:22:36 Vasterbotten, Sweden
1705181 2021-06-15 Sweden Vasterbotten     23298 181 0 23117 65.3337 16.5162 2021-06-16 04:22:32 Vasterbotten, Sweden
1661452 2021-06-14 Sweden Vasterbotten     23270 181 0 23089 65.3337 16.5162 2021-06-15 04:22:22 Vasterbotten, Sweden
319528 2021-06-13 Sweden Vasterbotten     23270 181 0 23089 65.3337 16.5162 2021-06-14 04:22:46 Vasterbotten, Sweden
619273 2021-06-12 Sweden Vasterbotten     23270 181 0 23089 65.3337 16.5162 2021-06-13 04:22:44 Vasterbotten, Sweden
592282 2021-06-11 Sweden Vasterbotten     23270 181 0 23089 65.3337 16.5162 2021-06-12 04:22:22 Vasterbotten, Sweden
273160 2021-06-10 Sweden Vasterbotten     23244 181 0 23063 65.3337 16.5162 2021-06-11 04:23:20 Vasterbotten, Sweden
1638218 2021-06-09 Sweden Vasterbotten     23231 181 0 23050 65.3337 16.5162 2021-06-10 04:23:17 Vasterbotten, Sweden
1744831 2021-06-08 Sweden Vasterbotten     23185 181 0 23004 65.3337 16.5162 2021-06-09 04:23:31 Vasterbotten, Sweden
577374 2021-06-07 Sweden Vasterbotten     23146 181 0 22965 65.3337 16.5162 2021-06-08 04:22:35 Vasterbotten, Sweden
246237 2021-06-06 Sweden Vasterbotten     23146 181 0 22965 65.3337 16.5162 2021-06-07 04:22:51 Vasterbotten, Sweden
674214 2021-06-05 Sweden Vasterbotten     23146 181 0 22965 65.3337 16.5162 2021-06-06 04:24:03 Vasterbotten, Sweden
553477 2021-06-04 Sweden Vasterbotten     23146 181 0 22965 65.3337 16.5162 2021-06-05 04:23:03 Vasterbotten, Sweden
1460874 2021-06-03 Sweden Vasterbotten     23108 181 0 22927 65.3337 16.5162 2021-06-04 04:23:37 Vasterbotten, Sweden
1399867 2021-06-02 Sweden Vasterbotten     22909 181 0 22728 65.3337 16.5162 2021-06-03 04:23:32 Vasterbotten, Sweden
1709214 2021-06-01 Sweden Vasterbotten     22909 181 0 22728 65.3337 16.5162 2021-06-02 04:24:34 Vasterbotten, Sweden
19444 2021-05-31 Sweden Vasterbotten     22909 181 0 22728 65.3337 16.5162 2021-06-01 04:23:09 Vasterbotten, Sweden
1497837 2021-05-30 Sweden Vasterbotten     22909 181 0 22728 65.3337 16.5162 2021-05-31 03:08:59 Vasterbotten, Sweden
623260 2021-05-29 Sweden Vasterbotten     22909 181 0 22728 65.3337 16.5162 2021-05-30 04:20:55 Vasterbotten, Sweden
81116 2021-05-28 Sweden Vasterbotten     22909 181 0 22728 65.3337 16.5162 2021-05-29 04:20:41 Vasterbotten, Sweden
1426391 2021-05-27 Sweden Vasterbotten     22909 181 0 22728 65.3337 16.5162 2021-05-28 04:20:36 Vasterbotten, Sweden
1549358 2021-05-26 Sweden Vasterbotten     22874 179 0 22695 65.3337 16.5162 2021-05-27 04:20:59 Vasterbotten, Sweden
1200934 2021-05-25 Sweden Vasterbotten     22774 180 0 22594 65.3337 16.5162 2021-05-26 04:20:35 Vasterbotten, Sweden
149927 2021-05-24 Sweden Vasterbotten     22641 180 0 22461 65.3337 16.5162 2021-05-25 04:21:08 Vasterbotten, Sweden
690080 2021-05-23 Sweden Vasterbotten     22641 180 0 22461 65.3337 16.5162 2021-05-24 04:20:53 Vasterbotten, Sweden
387694 2021-05-22 Sweden Vasterbotten     22641 180 0 22461 65.3337 16.5162 2021-05-23 04:20:51 Vasterbotten, Sweden
970009 2021-05-21 Sweden Vasterbotten     22641 180 0 22461 65.3337 16.5162 2021-05-22 04:20:45 Vasterbotten, Sweden
57971 2021-05-20 Sweden Vasterbotten     22560 180 0 22380 65.3337 16.5162 2021-05-21 04:20:43 Vasterbotten, Sweden
464233 2021-05-19 Sweden Vasterbotten     22499 180 0 22319 65.3337 16.5162 2021-05-20 04:21:05 Vasterbotten, Sweden
1276189 2021-05-18 Sweden Vasterbotten     22342 180 0 22162 65.3337 16.5162 2021-05-19 04:20:42 Vasterbotten, Sweden
231253 2021-05-17 Sweden Vasterbotten     22214 180 0 22034 65.3337 16.5162 2021-05-18 04:20:33 Vasterbotten, Sweden
1159468 2021-05-16 Sweden Vasterbotten     22214 180 0 22034 65.3337 16.5162 2021-05-17 04:20:34 Vasterbotten, Sweden
1009024 2021-05-15 Sweden Vasterbotten     22214 180 0 22034 65.3337 16.5162 2021-05-16 04:20:49 Vasterbotten, Sweden
805136 2021-05-14 Sweden Vasterbotten     22214 180 0 22034 65.3337 16.5162 2021-05-15 04:20:58 Vasterbotten, Sweden
1192964 2021-05-13 Sweden Vasterbotten     22021 180 0 21841 65.3337 16.5162 2021-05-14 04:20:41 Vasterbotten, Sweden
686093 2021-05-12 Sweden Vasterbotten     22021 180 0 21841 65.3337 16.5162 2021-05-13 04:20:51 Vasterbotten, Sweden
129493 2021-05-11 Sweden Vasterbotten     21820 180 0 21640 65.3337 16.5162 2021-05-12 04:21:29 Vasterbotten, Sweden
1257498 2021-05-10 Sweden Vasterbotten     21589 179 0 21410 65.3337 16.5162 2021-05-11 04:20:41 Vasterbotten, Sweden
121519 2021-05-09 Sweden Vasterbotten     21589 179 0 21410 65.3337 16.5162 2021-05-10 04:20:38 Vasterbotten, Sweden
89089 2021-05-08 Sweden Vasterbotten     21589 179 0 21410 65.3337 16.5162 2021-05-09 04:20:35 Vasterbotten, Sweden
522587 2021-05-07 Sweden Vasterbotten     21589 179 0 21410 65.3337 16.5162 2021-05-08 04:21:04 Vasterbotten, Sweden
1685211 2021-05-06 Sweden Vasterbotten     21453 179 0 21274 65.3337 16.5162 2021-05-07 04:20:40 Vasterbotten, Sweden
23430 2021-05-05 Sweden Vasterbotten     21352 178 0 21174 65.3337 16.5162 2021-05-06 04:20:38 Vasterbotten, Sweden
1331372 2021-05-04 Sweden Vasterbotten     21143 178 0 20965 65.3337 16.5162 2021-05-05 04:20:43 Vasterbotten, Sweden
1035959 2021-05-03 Sweden Vasterbotten     20903 178 0 20725 65.3337 16.5162 2021-05-04 04:20:34 Vasterbotten, Sweden
914149 2021-05-02 Sweden Vasterbotten     20903 178 0 20725 65.3337 16.5162 2021-05-03 04:20:39 Vasterbotten, Sweden
1757115 2021-05-01 Sweden Vasterbotten     20903 178 0 20725 65.3337 16.5162 2021-05-02 04:20:48 Vasterbotten, Sweden
1456886 2021-04-30 Sweden Vasterbotten     20903 178 0 20725 65.3337 16.5162 2021-05-01 04:20:47 Vasterbotten, Sweden
1614700 2021-04-29 Sweden Vasterbotten     20798 178 0 20620 65.3337 16.5162 2021-04-30 04:21:03 Vasterbotten, Sweden
484099 2021-04-28 Sweden Vasterbotten     20695 178 0 20517 65.3337 16.5162 2021-04-29 04:20:55 Vasterbotten, Sweden
335137 2021-04-27 Sweden Vasterbotten     20458 178 0 20280 65.3337 16.5162 2021-04-28 04:20:32 Vasterbotten, Sweden
1358182 2021-04-26 Sweden Vasterbotten     20182 178 0 20004 65.3337 16.5162 2021-04-27 04:20:52 Vasterbotten, Sweden
496138 2021-04-25 Sweden Vasterbotten     20182 178 0 20004 65.3337 16.5162 2021-04-26 04:21:04 Vasterbotten, Sweden
1112737 2021-04-24 Sweden Vasterbotten     20182 178 0 20004 65.3337 16.5162 2021-04-25 04:20:32 Vasterbotten, Sweden
488086 2021-04-23 Sweden Vasterbotten     20182 178 0 20004 65.3337 16.5162 2021-04-24 04:20:38 Vasterbotten, Sweden
1170471 2021-04-22 Sweden Vasterbotten     20056 176 0 19880 65.3337 16.5162 2021-04-23 04:20:52 Vasterbotten, Sweden
1403942 2021-04-21 Sweden Vasterbotten     19896 177 0 19719 65.3337 16.5162 2021-04-22 04:20:53 Vasterbotten, Sweden
1713200 2021-04-20 Sweden Vasterbotten     19797 177 0 19620 65.3337 16.5162 2021-04-21 04:21:14 Vasterbotten, Sweden
607329 2021-04-19 Sweden Vasterbotten     19575 177 0 19398 65.3337 16.5162 2021-04-20 04:20:41 Vasterbotten, Sweden
918136 2021-04-18 Sweden Vasterbotten     19575 177 0 19398 65.3337 16.5162 2021-04-19 04:20:57 Vasterbotten, Sweden
1319447 2021-04-17 Sweden Vasterbotten     19575 177 0 19398 65.3337 16.5162 2021-04-18 04:20:41 Vasterbotten, Sweden
989139 2021-04-16 Sweden Vasterbotten     19575 177 0 19398 65.3337 16.5162 2021-04-17 04:20:40 Vasterbotten, Sweden
380243 2021-04-15 Sweden Vasterbotten     19454 177 0 19277 65.3337 16.5162 2021-04-16 04:20:46 Vasterbotten, Sweden
906193 2021-04-14 Sweden Vasterbotten     19357 175 0 19182 65.3337 16.5162 2021-04-15 04:20:54 Vasterbotten, Sweden
1079420 2021-04-13 Sweden Vasterbotten     19151 171 0 18980 65.3337 16.5162 2021-04-14 04:20:41 Vasterbotten, Sweden
354656 2021-04-12 Sweden Vasterbotten     18905 170 0 18735 65.3337 16.5162 2021-04-13 04:20:37 Vasterbotten, Sweden
1181105 2021-04-11 Sweden Vasterbotten     18905 170 0 18735 65.3337 16.5162 2021-04-12 04:21:00 Vasterbotten, Sweden
1188977 2021-04-10 Sweden Vasterbotten     18905 170 0 18735 65.3337 16.5162 2021-04-11 04:20:56 Vasterbotten, Sweden
1693163 2021-04-09 Sweden Vasterbotten     18905 170 0 18735 65.3337 16.5162 2021-04-10 04:20:59 Vasterbotten, Sweden
569402 2021-04-08 Sweden Vasterbotten     18793 170 0 18623 65.3337 16.5162 2021-04-09 04:21:13 Vasterbotten, Sweden
1346221 2021-04-07 Sweden Vasterbotten     18634 170 0 18464 65.3337 16.5162 2021-04-08 04:21:13 Vasterbotten, Sweden
350589 2021-04-06 Sweden Vasterbotten     18479 170 0 18309 65.3337 16.5162 2021-04-07 04:20:53 Vasterbotten, Sweden
1043914 2021-04-05 Sweden Vasterbotten     18287 168 0 18119 65.3337 16.5162 2021-04-06 04:20:32 Vasterbotten, Sweden
215234 2021-04-04 Sweden Vasterbotten     18287 168 0 18119 65.3337 16.5162 2021-04-05 04:20:35 Vasterbotten, Sweden
1701193 2021-04-03 Sweden Vasterbotten     18287 168 0 18119 65.3337 16.5162 2021-04-04 04:20:49 Vasterbotten, Sweden
953882 2021-04-02 Sweden Vasterbotten     18287 168 0 18119 65.3337 16.5162 2021-04-03 04:20:44 Vasterbotten, Sweden
125506 2021-04-01 Sweden Vasterbotten     18287 168 0 18119 65.3337 16.5162 2021-04-02 04:20:36 Vasterbotten, Sweden
1516398 2021-03-31 Sweden Vasterbotten     18195 168 0 18027 65.3337 16.5162 2021-04-01 04:27:05 Vasterbotten, Sweden
1717187 2021-03-30 Sweden Vasterbotten     18013 166 0 17847 65.3337 16.5162 2021-03-31 04:26:25 Vasterbotten, Sweden
733174 2021-03-29 Sweden Vasterbotten     17812 165 0 17647 65.3337 16.5162 2021-03-30 04:26:23 Vasterbotten, Sweden
422478 2021-03-28 Sweden Vasterbotten     17812 165 0 17647 65.3337 16.5162 2021-03-29 04:28:35 Vasterbotten, Sweden
1732869 2021-03-27 Sweden Vasterbotten     17812 165 0 17647 65.3337 16.5162 2021-03-28 05:28:10 Vasterbotten, Sweden
403312 2021-03-26 Sweden Vasterbotten     17812 165 0 17647 65.3337 16.5162 2021-03-27 05:25:04 Vasterbotten, Sweden
1354195 2021-03-25 Sweden Vasterbotten     17712 164 0 17548 65.3337 16.5162 2021-03-26 05:26:55 Vasterbotten, Sweden
507885 2021-03-24 Sweden Vasterbotten     17595 163 0 17432 65.3337 16.5162 2021-03-25 05:27:00 Vasterbotten, Sweden
1590802 2021-03-23 Sweden Vasterbotten     17395 160 0 17235 65.3337 16.5162 2021-03-24 05:25:40 Vasterbotten, Sweden
840194 2021-03-22 Sweden Vasterbotten     17173 158 0 17015 65.3337 16.5162 2021-03-23 05:26:18 Vasterbotten, Sweden
721434 2021-03-21 Sweden Vasterbotten     17173 158 0 17015 65.3337 16.5162 2021-03-22 05:25:43 Vasterbotten, Sweden
442577 2021-03-20 Sweden Vasterbotten     17173 158 0 17015 65.3337 16.5162 2021-03-21 05:25:44 Vasterbotten, Sweden
545519 2021-03-19 Sweden Vasterbotten     17173 158 0 17015 65.3337 16.5162 2021-03-20 05:25:46 Vasterbotten, Sweden
1350208 2021-03-18 Sweden Vasterbotten     17032 158 0 16874 65.3337 16.5162 2021-03-19 05:26:09 Vasterbotten, Sweden
85102 2021-03-17 Sweden Vasterbotten     16902 157 0 16745 65.3337 16.5162 2021-03-18 05:26:22 Vasterbotten, 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]);