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

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
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  
134296 2020-02-10 Sweden       1 0 0       2020-02-01T02:13:26  
166140 2020-02-16 Sweden       1 0 0       2020-02-01T02:13:26  
195320 2020-02-11 Sweden       1 0 0       2020-02-01T02:13:26  
515443 2020-02-08 Sweden       1 0 0       2020-02-01T02:13:26  
647082 2020-02-03 Sweden       1 0 0       2020-02-01T02:13:26  
863164 2020-02-14 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  
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  
1124425 2020-02-01 Sweden       1 0 0       2/1/2020 2:13  
1169926 2020-02-15 Sweden       1 0 0       2020-02-01T02:13:26  
1203909 2020-02-07 Sweden       1 0 0       2020-02-01T02:13:26  
1281586 2020-02-13 Sweden       1 0 0       2020-02-01T02:13:26  
1318489 2020-02-20 Sweden       1 0 0       2020-02-01T02:13:26  
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  
1450891 2020-02-29 Sweden       12 0 0       2020-02-29T14:43:03  
1485286 2020-02-17 Sweden       1 0 0       2020-02-01T02:13:26  
1512100 2020-02-09 Sweden       1 0 0       2020-02-01T02:13:26  
1536124 2020-02-26 Sweden       2 0 0       2020-02-26T18:53:02  
1548861 2020-01-31 Sweden       1 0 0       1/31/2020 23:59  
1563742 2020-02-12 Sweden       1 0 0       2020-02-01T02:13:26  
1617099 2020-02-04 Sweden       1 0 0       2020-02-01T02:13:26  
1649128 2020-02-21 Sweden       1 0 0       2020-02-01T02:13:26  
1649204 2020-02-05 Sweden       1 0 0       2020-02-01T02:13:26  
1649273 2020-02-02 Sweden       1 0 0       2020-02-01T02:13:26  
1713768 2020-02-25 Sweden       1 0 0       2020-02-01T02:13:26  
3692 2020-10-26 Sweden Skane     8106 284 0 7822 55.9903 13.5958 2020-10-27 04:24:45 Skane, Sweden
14055 2020-07-17 Sweden Skane     3391 258 0 3133 55.9903 13.5958 2020-07-18 04:34:45 Skane, Sweden
14962 2021-04-30 Sweden Skane     140997 1677 0 139320 55.9903 13.5958 2021-05-01 04:20:47 Skane, Sweden
22059 2020-10-13 Sweden Skane     6594 282 0 6312 55.9903 13.5958 2020-10-14 04:24:05 Skane, Sweden
29275 2020-11-23 Sweden Skane     20999 353 0 20646 55.9903 13.5958 2020-11-24 05:27:31 Skane, Sweden
33259 2021-04-12 Sweden Skane     129010 1649 0 127361 55.9903 13.5958 2021-04-13 04:20:37 Skane, Sweden
37226 2020-10-27 Sweden Skane     8652 287 0 8365 55.9903 13.5958 2020-10-28 04:24:39 Skane, Sweden
44242 2020-07-30 Sweden Skane     3653 264 0 3389 55.9903 13.5958 2020-07-31 04:35:18 Skane, Sweden
48385 2020-12-19 Sweden Skane     50836 584 0 50252 55.9903 13.5958 2020-12-20 05:27:32 Skane, Sweden
55898 2021-03-16 Sweden Skane     116790 1615 0 115175 55.9903 13.5958 2021-03-17 05:25:07 Skane, Sweden
59879 2020-12-07 Sweden Skane     32005 450 0 31555 55.9903 13.5958 2020-12-08 05:27:42 Skane, Sweden
66769 2020-07-05 Sweden Skane     3121 250 0 2871 55.9903 13.5958 2020-07-06 04:33:57 Skane, Sweden
67777 2021-05-29 Sweden Skane     153662 1730 0 151932 55.9903 13.5958 2021-05-30 04:20:55 Skane, Sweden
71760 2021-05-05 Sweden Skane     143830 1688 0 142142 55.9903 13.5958 2021-05-06 04:20:38 Skane, Sweden
78773 2020-07-27 Sweden Skane     3568 262 0 3306 55.9903 13.5958 2020-07-28 04:58:43 Skane, Sweden
79666 2020-10-28 Sweden Skane     9001 287 0 8714 55.9903 13.5958 2020-10-29 04:24:49 Skane, Sweden
83629 2020-09-16 Sweden Skane     5282 276 0 5006 55.9903 13.5958 2020-09-17 04:22:00 Skane, Sweden
87590 2020-10-09 Sweden Skane     6403 281 0 6122 55.9903 13.5958 2020-10-10 04:23:57 Skane, Sweden
91567 2020-12-06 Sweden Skane     32005 450 0 31555 55.9903 13.5958 2020-12-07 05:26:14 Skane, Sweden
95547 2020-11-18 Sweden Skane     19158 351 0 18807 55.9903 13.5958 2020-11-19 05:25:23 Skane, Sweden
99531 2021-05-23 Sweden Skane     152297 1716 0 150581 55.9903 13.5958 2021-05-24 04:20:53 Skane, Sweden
106554 2020-08-08 Sweden Skane     3861 272 0 3589 55.9903 13.5958 2020-08-09 04:34:54 Skane, Sweden
107459 2020-11-29 Sweden Skane     25867 385 0 25482 55.9903 13.5958 2020-11-30 05:26:13 Skane, Sweden
111424 2020-08-11 Sweden Skane     3949 274 0 3675 55.9903 13.5958 2020-08-12 04:27:29 Skane, Sweden
118410 2020-07-18 Sweden Skane     3391 258 0 3133 55.9903 13.5958 2020-07-19 04:34:58 Skane, Sweden
119298 2020-08-20 Sweden Skane     4326 282 0 4044 55.9903 13.5958 2020-08-21 04:27:41 Skane, Sweden
123272 2021-04-05 Sweden Skane     124712 1643 0 123069 55.9903 13.5958 2021-04-06 04:20:32 Skane, Sweden
133963 2020-07-04 Sweden Skane     3121 250 0 2871 55.9903 13.5958 2020-07-05 04:33:46 Skane, Sweden
134919 2020-10-05 Sweden Skane     6034 279 0 5755 55.9903 13.5958 2020-10-06 04:23:33 Skane, Sweden
138895 2020-11-13 Sweden Skane     16639 322 0 16317 55.9903 13.5958 2020-11-14 05:25:37 Skane, Sweden
142878 2021-02-03 Sweden Skane     99497 1413 0 98084 55.9903 13.5958 2021-02-04 05:22:26 Skane, Sweden
146862 2021-02-09 Sweden Skane     102180 1446 0 100734 55.9903 13.5958 2021-02-10 05:22:41 Skane, Sweden
150990 2021-03-25 Sweden Skane     121155 1629 0 119526 55.9903 13.5958 2021-03-26 05:26:55 Skane, Sweden
157837 2020-06-22 Sweden Skane     2707 224 0 2483 55.9903 13.5958 2020-06-23 04:33:22 Skane, Sweden
158738 2021-06-05 Sweden Skane     154791 1743 0 153048 55.9903 13.5958 2021-06-06 04:24:03 Skane, Sweden
162720 2021-01-25 Sweden Skane     92857 1144 0 91713 55.9903 13.5958 2021-01-26 05:22:02 Skane, Sweden
166782 2021-02-24 Sweden Skane     108978 1547 0 107431 55.9903 13.5958 2021-02-25 05:24:57 Skane, Sweden
170747 2020-09-02 Sweden Skane     4807 272 0 4535 55.9903 13.5958 2020-09-03 04:28:22 Skane, Sweden
183906 2020-06-12 Sweden Skane     2198 205 0 1993 55.9903 13.5958 2020-06-13 03:33:14 Skane, Sweden
187949 2021-01-30 Sweden Skane     96713 1279 0 95434 55.9903 13.5958 2021-01-31 05:22:42 Skane, Sweden
191915 2020-08-17 Sweden Skane     4153 280 0 3873 55.9903 13.5958 2020-08-18 04:27:56 Skane, Sweden
195963 2021-05-28 Sweden Skane     153662 1730 0 151932 55.9903 13.5958 2021-05-29 04:20:41 Skane, Sweden
203367 2021-05-24 Sweden Skane     152297 1716 0 150581 55.9903 13.5958 2021-05-25 04:21:08 Skane, Sweden
210387 2020-08-04 Sweden Skane     3766 264 0 3502 55.9903 13.5958 2020-08-05 04:34:43 Skane, Sweden
211293 2021-02-17 Sweden Skane     105908 1506 0 104402 55.9903 13.5958 2021-02-18 05:22:58 Skane, Sweden
215279 2021-06-13 Sweden Skane     155456 1749 0 153707 55.9903 13.5958 2021-06-14 04:22:46 Skane, Sweden
219261 2021-02-15 Sweden Skane     103958 1474 0 102484 55.9903 13.5958 2021-02-16 05:24:38 Skane, Sweden
223247 2021-06-14 Sweden Skane     155456 1749 0 153707 55.9903 13.5958 2021-06-15 04:22:22 Skane, Sweden
227229 2021-01-29 Sweden Skane     96713 1279 0 95434 55.9903 13.5958 2021-01-30 05:22:49 Skane, Sweden
231195 2020-08-18 Sweden Skane     4227 280 0 3947 55.9903 13.5958 2020-08-19 04:27:00 Skane, Sweden
238035 2020-06-23 Sweden Skane     2742 225 0 2517 55.9903 13.5958 2020-06-24 04:33:28 Skane, Sweden
241850 2020-07-10 Sweden Skane     3245 255 0 2990 55.9903 13.5958 2020-07-11 04:34:26 Skane, Sweden
242748 2020-11-22 Sweden Skane     20999 353 0 20646 55.9903 13.5958 2020-11-23 05:25:26 Skane, Sweden
249557 2020-06-10 Sweden Skane     2088 205 0 1883 55.9903 13.5958 2020-06-11 03:33:41 Skane, Sweden
253480 2020-07-22 Sweden Skane     3492 261 0 3231 55.9903 13.5958 2020-07-23 05:15:04 Skane, Sweden
254388 2021-03-20 Sweden Skane     118480 1616 0 116864 55.9903 13.5958 2021-03-21 05:25:44 Skane, Sweden
258353 2020-08-31 Sweden Skane     4734 269 0 4465 55.9903 13.5958 2020-09-01 04:28:31 Skane, Sweden
262329 2020-12-15 Sweden Skane     45138 536 0 44602 55.9903 13.5958 2020-12-16 05:28:04 Skane, Sweden
266459 2020-11-02 Sweden Skane     9981 287 0 9694 55.9903 13.5958 2020-11-03 06:00:16 Skane, Sweden
270441 2021-04-02 Sweden Skane     124712 1643 0 123069 55.9903 13.5958 2021-04-03 04:20:44 Skane, Sweden
277863 2021-02-14 Sweden Skane     103958 1474 0 102484 55.9903 13.5958 2021-02-15 05:24:49 Skane, Sweden
281849 2021-06-12 Sweden Skane     155456 1749 0 153707 55.9903 13.5958 2021-06-13 04:22:44 Skane, Sweden
285829 2020-12-03 Sweden Skane     30619 450 0 30169 55.9903 13.5958 2020-12-04 05:27:27 Skane, Sweden
289813 2021-03-30 Sweden Skane     123228 1640 0 121588 55.9903 13.5958 2021-03-31 04:26:25 Skane, Sweden
293795 2021-01-10 Sweden Skane     78745 814 0 77931 55.9903 13.5958 2021-01-11 05:21:50 Skane, Sweden
297760 2020-09-09 Sweden Skane     5011 276 0 4735 55.9903 13.5958 2020-09-10 04:29:01 Skane, Sweden
305339 2021-03-21 Sweden Skane     118480 1616 0 116864 55.9903 13.5958 2021-03-22 05:25:43 Skane, Sweden
309323 2021-03-02 Sweden Skane     111508 1567 0 109941 55.9903 13.5958 2021-03-03 05:23:28 Skane, Sweden
313305 2021-01-16 Sweden Skane     87617 986 0 86631 55.9903 13.5958 2021-01-17 05:22:17 Skane, Sweden
317273 2020-10-21 Sweden Skane     7513 283 0 7230 55.9903 13.5958 2020-10-22 04:24:27 Skane, 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]);