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

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
1548861 2020-01-31 Sweden       1 0 0       1/31/2020 23:59  
1124425 2020-02-01 Sweden       1 0 0       2/1/2020 2:13  
1649273 2020-02-02 Sweden       1 0 0       2020-02-01T02:13:26  
647082 2020-02-03 Sweden       1 0 0       2020-02-01T02:13:26  
1617099 2020-02-04 Sweden       1 0 0       2020-02-01T02:13:26  
1649204 2020-02-05 Sweden       1 0 0       2020-02-01T02:13:26  
1430724 2020-02-06 Sweden       1 0 0       2020-02-01T02:13:26  
1203909 2020-02-07 Sweden       1 0 0       2020-02-01T02:13:26  
515443 2020-02-08 Sweden       1 0 0       2020-02-01T02:13:26  
1512100 2020-02-09 Sweden       1 0 0       2020-02-01T02:13:26  
134296 2020-02-10 Sweden       1 0 0       2020-02-01T02:13:26  
195320 2020-02-11 Sweden       1 0 0       2020-02-01T02:13:26  
1563742 2020-02-12 Sweden       1 0 0       2020-02-01T02:13:26  
1281586 2020-02-13 Sweden       1 0 0       2020-02-01T02:13:26  
863164 2020-02-14 Sweden       1 0 0       2020-02-01T02:13:26  
1169926 2020-02-15 Sweden       1 0 0       2020-02-01T02:13:26  
166140 2020-02-16 Sweden       1 0 0       2020-02-01T02:13:26  
1485286 2020-02-17 Sweden       1 0 0       2020-02-01T02:13:26  
1073643 2020-02-18 Sweden       1 0 0       2020-02-01T02:13:26  
1073566 2020-02-19 Sweden       1 0 0       2020-02-01T02:13:26  
1318489 2020-02-20 Sweden       1 0 0       2020-02-01T02:13:26  
1649128 2020-02-21 Sweden       1 0 0       2020-02-01T02:13:26  
1371630 2020-02-22 Sweden       1 0 0       2020-02-01T02:13:26  
889747 2020-02-23 Sweden       1 0 0       2020-02-01T02:13:26  
966473 2020-02-24 Sweden       1 0 0       2020-02-01T02:13:26  
1713768 2020-02-25 Sweden       1 0 0       2020-02-01T02:13:26  
1536124 2020-02-26 Sweden       2 0 0       2020-02-26T18:53:02  
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  
1450891 2020-02-29 Sweden       12 0 0       2020-02-29T14:43:03  
1085313 2020-03-01 Sweden       14 0 0   63.0 16.0 2020-03-01T23:23:02  
150270 2020-03-02 Sweden       15 0 0   63.0 16.0 2020-03-02T20:53:02  
646919 2020-03-03 Sweden       21 0 0   63.0 16.0 2020-03-03T15:13:26  
265731 2020-03-04 Sweden       35 0 0   63.0 16.0 2020-03-04T12:33:03  
301144 2020-03-05 Sweden       94 0 0   63.0 16.0 2020-03-05T18:03:03  
1250300 2020-03-06 Sweden       101 0 0   63.0 16.0 2020-03-06T13:03:12  
1073685 2020-03-07 Sweden       161 0 0   63.0 16.0 2020-03-07T17:53:03  
1430762 2020-03-08 Sweden       203 0 0   63.0 16.0 2020-03-08T14:03:12  
419518 2020-03-09 Sweden       248 0 1   63.0 16.0 2020-03-09T18:33:03  
1230329 2020-03-10 Sweden       355 0 1   63.0 16.0 2020-03-10T23:53:02  
1539348 2020-03-11 Sweden       500 1 1   63.0 16.0 2020-03-11T19:33:02  
1069314 2020-03-12 Sweden       599 1 1   63.0 16.0 2020-03-12T21:39:09  
589540 2020-03-13 Sweden       814 1 1   60.1282 18.6435 2020-03-11T20:00:00  
126755 2020-03-14 Sweden       961 2 1   60.1282 18.6435 2020-03-14T22:13:11  
527416 2020-03-15 Sweden       1022 3 1   60.1282 18.6435 2020-03-15T18:20:18  
1578716 2020-03-16 Sweden       1103 6 1   60.1282 18.6435 2020-03-16T14:38:45  
923637 2020-03-17 Sweden       1190 7 1   60.1282 18.6435 2020-03-17T15:33:06  
419219 2020-03-18 Sweden       1279 10 1   60.1282 18.6435 2020-03-18T17:53:02  
1629051 2020-03-19 Sweden       1439 11 16   60.1282 18.6435 2020-03-19T15:13:27  
762525 2020-03-20 Sweden       1639 16 16   60.1282 18.6435 2020-03-20T15:43:24  
414966 2020-03-21 Sweden       1763 20 16   60.1282 18.6435 2020-03-21T14:43:03  
1092616 2020-03-22 Sweden       1931 21 16 1894 60.128161 18.643501 3/22/20 23:45 Sweden
1042744 2020-03-23 Sweden       2046 25 16 2005 60.128161 18.643501 2020-03-23 23:19:21 Sweden
202712 2020-03-24 Sweden       2286 36 16 2234 60.128161 18.643501 2020-03-24 23:37:15 Sweden
304684 2020-03-25 Sweden       2526 62 16 2448 60.128161 18.643501 2020-03-25 23:33:04 Sweden
1652684 2020-03-26 Sweden       2840 77 16 2747 60.128161 18.643501 2020-03-26 23:48:18 Sweden
739857 2020-03-27 Sweden       3069 105 16 2948 60.128161 18.643501 2020-03-27 23:23:03 Sweden
130402 2020-03-28 Sweden       3447 105 16 3326 60.128161 18.643501 3/28/20 23:05 Sweden
277208 2020-03-29 Sweden       3700 110 16 3574 60.128161 18.643501 3/29/20 23:08 Sweden
10462 2020-03-30 Sweden       4028 146 16 3866 60.128161 18.643501 3/30/20 22:52 Sweden
851124 2020-03-31 Sweden       4435 180 16 4239 60.128161 18.643501 2020-03-31 23:43:43 Sweden
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
1045371 2020-04-03 Sweden       6131 358 205 5568 60.128161 18.643501 2020-04-03 22:46:20 Sweden
176752 2020-04-04 Sweden       6443 373 205 5865 60.128161 18.643501 4/4/20 23:34 Sweden
511369 2020-04-05 Sweden       6830 401 205 6224 60.128161 18.643501 2020-04-05 23:06:26 Sweden
1542331 2020-04-06 Sweden       7206 477 205 6524 60.128161 18.643501 4/6/20 23:21 Sweden
1367528 2020-04-07 Sweden       7693 591 205 6897 60.128161 18.643501 2020-04-07 23:04:29 Sweden
1563653 2020-04-08 Sweden       8419 687 205 7527 60.128161 18.643501 2020-04-08 22:51:39 Sweden
1496150 2020-04-09 Sweden       9141 793 205 8143 60.128161 18.643501 2020-04-09 23:02:19 Sweden
930801 2020-04-10 Sweden       9685 870 381 8434 60.128161 18.643501 2020-04-10 22:53:48 Sweden
342214 2020-04-11 Sweden       10151 887 381 8883 60.128161 18.643501 2020-04-11 22:45:13 Sweden
592662 2020-04-12 Sweden       10483 899 381 9203 60.128161 18.643501 2020-04-12 23:17:00 Sweden
1574693 2020-04-13 Sweden       10948 919 381 9648 60.128161 18.643501 2020-04-13 23:07:34 Sweden
1593899 2020-04-14 Sweden       11445 1033 381 10031 60.128161 18.643501 2020-04-14 23:33:12 Sweden
1348829 2020-04-15 Sweden       11927 1203 381 10343 60.128161 18.643501 2020-04-15 22:56:32 Sweden
1169834 2020-04-16 Sweden       12540 1333 550 10657 60.128161 18.643501 2020-04-16 23:30:31 Sweden
1662885 2020-04-17 Sweden       13216 1400 550 11266 60.128161 18.643501 2020-04-17 23:30:32 Sweden
391760 2020-04-18 Sweden       13822 1511 550 11761 60.128161 18.643501 2020-04-18 22:32:28 Sweden
3052 2020-04-19 Sweden       14385 1540 550 12295 60.128161 18.643501 2020-04-19 23:40:41 Sweden
1012280 2020-04-20 Sweden       14777 1580 550 12647 60.128161 18.643501 2020-04-20 23:36:27 Sweden
919786 2020-04-21 Sweden       15322 1765 550 13007 60.128161 18.643501 2020-04-21 23:30:30 Sweden
422836 2020-04-22 Sweden       16004 1937 550 13517 60.128161 18.643501 2020-04-22 23:30:32 Sweden
896833 2020-04-23 Sweden       16755 2021 550 14184 60.128161 18.643501 2020-04-24 03:30:31 Sweden
21411 2020-04-24 Sweden       17567 2152 1005 14410 60.128161 18.643501 2020-04-25 06:30:33 Sweden
603759 2020-04-25 Sweden       18177 2192 1005 14980 60.128161 18.643501 2020-04-26 02:30:31 Sweden
187285 2020-04-26 Sweden       18640 2194 1005 15441 60.128161 18.643501 2020-04-27 02:30:33 Sweden
985506 2020-04-27 Sweden       18926 2274 1005 15647 60.128161 18.643501 2020-04-28 02:30:32 Sweden
1539301 2020-04-28 Sweden       19621 2355 1005 16261 60.128161 18.643501 2020-04-29 02:32:29 Sweden
1655855 2020-04-29 Sweden       20302 2462 1005 16835 60.128161 18.643501 2020-04-30 02:32:27 Sweden
866329 2020-04-30 Sweden       21092 2586 1005 17501 60.128161 18.643501 2020-05-01 02:32:28 Sweden
433995 2020-05-01 Sweden       21520 2653 1005 17862 60.128161 18.643501 2020-05-02 02:32:27 Sweden
1548774 2020-05-02 Sweden       22082 2669 1005 18408 60.128161 18.643501 2020-05-03 02:32:28 Sweden
1545532 2020-05-03 Sweden       22317 2679 1005 18633 60.128161 18.643501 2020-05-04 02:32:28 Sweden
1173115 2020-05-04 Sweden       22721 2769 4074 15878 60.128161 18.643501 2020-05-05 02:32:34 Sweden
1222254 2020-05-05 Sweden       23216 2854 4074 16288 60.128161 18.643501 2020-05-06 02:32:31 Sweden
585472 2020-05-06 Sweden       23918 2941 4074 16903 60.128161 18.643501 2020-05-07 02:32:28 Sweden
1697761 2020-05-07 Sweden       24623 3040 4971 16612 60.128161 18.643501 2020-05-08 02:32:32 Sweden
720508 2020-05-08 Sweden       25265 3175 4971 17119 60.128161 18.643501 2020-05-09 02:32:35 Sweden
47728 2020-05-09 Sweden       25921 3220 4971 17730 60.128161 18.643501 2020-05-10 02:32:30 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]);