⚠️ 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

8,001 rows where country_or_region = "Sweden" sorted by province_or_state

View and edit SQL

Suggested facets: recovered, latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Sweden · 8,001
Link rowid day country_or_region province_or_state ▼ admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
3052 2020-04-19 Sweden       14385 1540 550 12295 60.128161 18.643501 2020-04-19 23:40:41 Sweden
10462 2020-03-30 Sweden       4028 146 16 3866 60.128161 18.643501 3/30/20 22:52 Sweden
21411 2020-04-24 Sweden       17567 2152 1005 14410 60.128161 18.643501 2020-04-25 06:30:33 Sweden
28619 2020-05-11 Sweden       26670 3256 4971 18443 60.128161 18.643501 2020-05-12 03:32:27 Sweden
47728 2020-05-09 Sweden       25921 3220 4971 17730 60.128161 18.643501 2020-05-10 02:32:30 Sweden
55238 2020-05-29 Sweden       36476 4350 4971 27155 60.128161 18.643501 2020-05-30 02:32:48 Sweden
67091 2020-02-27 Sweden       7 0 0       2020-02-27T20:33:02  
126678 2020-02-28 Sweden       7 0 0       2020-02-27T20:33:02  
126755 2020-03-14 Sweden       961 2 1   60.1282 18.6435 2020-03-14T22:13:11  
130402 2020-03-28 Sweden       3447 105 16 3326 60.128161 18.643501 3/28/20 23:05 Sweden
134296 2020-02-10 Sweden       1 0 0       2020-02-01T02:13:26  
150270 2020-03-02 Sweden       15 0 0   63.0 16.0 2020-03-02T20:53:02  
166140 2020-02-16 Sweden       1 0 0       2020-02-01T02:13:26  
176752 2020-04-04 Sweden       6443 373 205 5865 60.128161 18.643501 4/4/20 23:34 Sweden
180402 2020-06-04 Sweden       41883 4562 0 37321 60.128161 18.643501 2020-06-05 02:33:06 Sweden
187285 2020-04-26 Sweden       18640 2194 1005 15441 60.128161 18.643501 2020-04-27 02:30:33 Sweden
195320 2020-02-11 Sweden       1 0 0       2020-02-01T02:13:26  
202712 2020-03-24 Sweden       2286 36 16 2234 60.128161 18.643501 2020-03-24 23:37:15 Sweden
265731 2020-03-04 Sweden       35 0 0   63.0 16.0 2020-03-04T12:33:03  
277208 2020-03-29 Sweden       3700 110 16 3574 60.128161 18.643501 3/29/20 23:08 Sweden
301144 2020-03-05 Sweden       94 0 0   63.0 16.0 2020-03-05T18:03:03  
304684 2020-03-25 Sweden       2526 62 16 2448 60.128161 18.643501 2020-03-25 23:33:04 Sweden
332250 2020-06-02 Sweden       38589 4468 0 34121 60.128161 18.643501 2020-06-03 02:33:13 Sweden
339243 2020-05-10 Sweden       26322 3225 4971 18126 60.128161 18.643501 2020-05-11 02:32:30 Sweden
342214 2020-04-11 Sweden       10151 887 381 8883 60.128161 18.643501 2020-04-11 22:45:13 Sweden
353443 2020-05-18 Sweden       30377 3698 4971 21708 60.128161 18.643501 2020-05-19 02:32:18 Sweden
391760 2020-04-18 Sweden       13822 1511 550 11761 60.128161 18.643501 2020-04-18 22:32:28 Sweden
414923 2020-05-14 Sweden       28582 3529 4971 20082 60.128161 18.643501 2020-05-15 02:33:02 Sweden
414966 2020-03-21 Sweden       1763 20 16   60.1282 18.6435 2020-03-21T14:43:03  
419219 2020-03-18 Sweden       1279 10 1   60.1282 18.6435 2020-03-18T17:53:02  
419518 2020-03-09 Sweden       248 0 1   63.0 16.0 2020-03-09T18:33:03  
422836 2020-04-22 Sweden       16004 1937 550 13517 60.128161 18.643501 2020-04-22 23:30:32 Sweden
433995 2020-05-01 Sweden       21520 2653 1005 17862 60.128161 18.643501 2020-05-02 02:32:27 Sweden
492905 2020-05-21 Sweden       32172 3871 4971 23330 60.128161 18.643501 2020-05-22 02:36:51 Sweden
511369 2020-04-05 Sweden       6830 401 205 6224 60.128161 18.643501 2020-04-05 23:06:26 Sweden
515443 2020-02-08 Sweden       1 0 0       2020-02-01T02:13:26  
527416 2020-03-15 Sweden       1022 3 1   60.1282 18.6435 2020-03-15T18:20:18  
554621 2020-05-15 Sweden       29207 3646 4971 20590 60.128161 18.643501 2020-05-16 02:32:19 Sweden
585472 2020-05-06 Sweden       23918 2941 4074 16903 60.128161 18.643501 2020-05-07 02:32:28 Sweden
589540 2020-03-13 Sweden       814 1 1   60.1282 18.6435 2020-03-11T20:00:00  
592662 2020-04-12 Sweden       10483 899 381 9203 60.128161 18.643501 2020-04-12 23:17:00 Sweden
603759 2020-04-25 Sweden       18177 2192 1005 14980 60.128161 18.643501 2020-04-26 02:30:31 Sweden
619101 2020-05-22 Sweden       32809 3925 4971 23913 60.128161 18.643501 2020-05-23 02:32:42 Sweden
646919 2020-03-03 Sweden       21 0 0   63.0 16.0 2020-03-03T15:13:26  
647082 2020-02-03 Sweden       1 0 0       2020-02-01T02:13:26  
713288 2020-05-20 Sweden       31523 3831 4971 22721 60.128161 18.643501 2020-05-21 02:32:48 Sweden
720508 2020-05-08 Sweden       25265 3175 4971 17119 60.128161 18.643501 2020-05-09 02:32:35 Sweden
739857 2020-03-27 Sweden       3069 105 16 2948 60.128161 18.643501 2020-03-27 23:23:03 Sweden
755079 2020-05-16 Sweden       29677 3674 4971 21032 60.128161 18.643501 2020-05-17 02:32:32 Sweden
762484 2020-06-01 Sweden       37814 4403 4971 28440 60.128161 18.643501 2020-06-02 02:33:08 Sweden
762525 2020-03-20 Sweden       1639 16 16   60.1282 18.6435 2020-03-20T15:43:24  
817441 2020-05-12 Sweden       27272 3313 4971 18988 60.128161 18.643501 2020-05-13 03:32:26 Sweden
851124 2020-03-31 Sweden       4435 180 16 4239 60.128161 18.643501 2020-03-31 23:43:43 Sweden
863164 2020-02-14 Sweden       1 0 0       2020-02-01T02:13:26  
866329 2020-04-30 Sweden       21092 2586 1005 17501 60.128161 18.643501 2020-05-01 02:32:28 Sweden
881677 2020-05-25 Sweden       33843 4029 4971 24843 60.128161 18.643501 2020-05-26 02:32:35 Sweden
889747 2020-02-23 Sweden       1 0 0       2020-02-01T02:13:26  
896833 2020-04-23 Sweden       16755 2021 550 14184 60.128161 18.643501 2020-04-24 03:30:31 Sweden
919786 2020-04-21 Sweden       15322 1765 550 13007 60.128161 18.643501 2020-04-21 23:30:30 Sweden
923637 2020-03-17 Sweden       1190 7 1   60.1282 18.6435 2020-03-17T15:33:06  
930801 2020-04-10 Sweden       9685 870 381 8434 60.128161 18.643501 2020-04-10 22:53:48 Sweden
966473 2020-02-24 Sweden       1 0 0       2020-02-01T02:13:26  
985506 2020-04-27 Sweden       18926 2274 1005 15647 60.128161 18.643501 2020-04-28 02:30:32 Sweden
1012280 2020-04-20 Sweden       14777 1580 550 12647 60.128161 18.643501 2020-04-20 23:36:27 Sweden
1027853 2020-06-03 Sweden       40803 4542 0 36261 60.128161 18.643501 2020-06-04 02:33:14 Sweden
1039321 2020-05-30 Sweden       37113 4395 4971 27747 60.128161 18.643501 2020-05-31 02:32:45 Sweden
1042744 2020-03-23 Sweden       2046 25 16 2005 60.128161 18.643501 2020-03-23 23:19:21 Sweden
1045371 2020-04-03 Sweden       6131 358 205 5568 60.128161 18.643501 2020-04-03 22:46:20 Sweden
1069314 2020-03-12 Sweden       599 1 1   63.0 16.0 2020-03-12T21:39:09  
1073566 2020-02-19 Sweden       1 0 0       2020-02-01T02:13:26  
1073643 2020-02-18 Sweden       1 0 0       2020-02-01T02:13:26  
1073685 2020-03-07 Sweden       161 0 0   63.0 16.0 2020-03-07T17:53:03  
1077263 2020-05-23 Sweden       33188 3992 4971 24225 60.128161 18.643501 2020-05-24 02:32:43 Sweden
1085313 2020-03-01 Sweden       14 0 0   63.0 16.0 2020-03-01T23:23:02  
1092616 2020-03-22 Sweden       1931 21 16 1894 60.128161 18.643501 3/22/20 23:45 Sweden
1124425 2020-02-01 Sweden       1 0 0       2/1/2020 2:13  
1159482 2020-05-26 Sweden       34440 4125 4971 25344 60.128161 18.643501 2020-05-27 02:32:31 Sweden
1166786 2020-05-19 Sweden       30799 3743 4971 22085 60.128161 18.643501 2020-05-20 02:32:19 Sweden
1169834 2020-04-16 Sweden       12540 1333 550 10657 60.128161 18.643501 2020-04-16 23:30:31 Sweden
1169926 2020-02-15 Sweden       1 0 0       2020-02-01T02:13:26  
1173115 2020-05-04 Sweden       22721 2769 4074 15878 60.128161 18.643501 2020-05-05 02:32:34 Sweden
1199832 2020-05-17 Sweden       30143 3679 4971 21493 60.128161 18.643501 2020-05-18 02:32:21 Sweden
1203909 2020-02-07 Sweden       1 0 0       2020-02-01T02:13:26  
1207311 2020-05-27 Sweden       35088 4220 4971 25897 60.128161 18.643501 2020-05-28 02:32:31 Sweden
1222254 2020-05-05 Sweden       23216 2854 4074 16288 60.128161 18.643501 2020-05-06 02:32:31 Sweden
1230329 2020-03-10 Sweden       355 0 1   63.0 16.0 2020-03-10T23:53:02  
1250300 2020-03-06 Sweden       101 0 0   63.0 16.0 2020-03-06T13:03:12  
1273543 2020-05-28 Sweden       35727 4266 4971 26490 60.128161 18.643501 2020-05-29 02:32:50 Sweden
1281586 2020-02-13 Sweden       1 0 0       2020-02-01T02:13:26  
1292007 2020-04-01 Sweden       4947 239 103 4605 60.128161 18.643501 2020-04-01 21:58:34 Sweden
1306468 2020-04-02 Sweden       5568 308 103 5157 60.128161 18.643501 4/2/20 23:25 Sweden
1318489 2020-02-20 Sweden       1 0 0       2020-02-01T02:13:26  
1348829 2020-04-15 Sweden       11927 1203 381 10343 60.128161 18.643501 2020-04-15 22:56:32 Sweden
1367528 2020-04-07 Sweden       7693 591 205 6897 60.128161 18.643501 2020-04-07 23:04:29 Sweden
1371630 2020-02-22 Sweden       1 0 0       2020-02-01T02:13:26  
1430724 2020-02-06 Sweden       1 0 0       2020-02-01T02:13:26  
1430762 2020-03-08 Sweden       203 0 0   63.0 16.0 2020-03-08T14:03:12  
1450891 2020-02-29 Sweden       12 0 0       2020-02-29T14:43:03  
1454347 2020-05-24 Sweden       33459 3998 4971 24490 60.128161 18.643501 2020-05-25 02:32:44 Sweden
1465520 2020-05-31 Sweden       37542 4395 4971 28176 60.128161 18.643501 2020-06-01 02:32:46 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]);