⚠️ 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,106 rows where country_or_region = "Sweden" sorted by longitude

View and edit SQL

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

country_or_region

  • Sweden · 8,106
Link rowid day country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude ▼ last_update combined_key
72825 2020-02-02 Sweden       1 0 0       2020-02-01T02:13:26  
80319 2020-02-25 Sweden       1 0 0       2020-02-01T02:13:26  
252577 2020-02-07 Sweden       1 0 0       2020-02-01T02:13:26  
299512 2020-02-18 Sweden       1 0 0       2020-02-01T02:13:26  
383974 2020-02-01 Sweden       1 0 0       2/1/2020 2:13  
399895 2020-02-11 Sweden       1 0 0       2020-02-01T02:13:26  
477679 2020-02-04 Sweden       1 0 0       2020-02-01T02:13:26  
523921 2020-02-09 Sweden       1 0 0       2020-02-01T02:13:26  
527963 2020-02-06 Sweden       1 0 0       2020-02-01T02:13:26  
629437 2020-02-26 Sweden       2 0 0       2020-02-26T18:53:02  
655340 2020-02-17 Sweden       1 0 0       2020-02-01T02:13:26  
677722 2020-02-08 Sweden       1 0 0       2020-02-01T02:13:26  
803593 2020-02-29 Sweden       12 0 0       2020-02-29T14:43:03  
826589 2020-02-27 Sweden       7 0 0       2020-02-27T20:33:02  
996379 2020-02-16 Sweden       1 0 0       2020-02-01T02:13:26  
1071626 2020-02-28 Sweden       7 0 0       2020-02-27T20:33:02  
1079712 2020-02-22 Sweden       1 0 0       2020-02-01T02:13:26  
1091755 2020-02-23 Sweden       1 0 0       2020-02-01T02:13:26  
1113597 2020-01-31 Sweden       1 0 0       1/31/2020 23:59  
1156695 2020-02-24 Sweden       1 0 0       2020-02-01T02:13:26  
1277098 2020-02-14 Sweden       1 0 0       2020-02-01T02:13:26  
1285149 2020-02-15 Sweden       1 0 0       2020-02-01T02:13:26  
1350219 2020-02-03 Sweden       1 0 0       2020-02-01T02:13:26  
1442264 2020-02-10 Sweden       1 0 0       2020-02-01T02:13:26  
1542137 2020-02-12 Sweden       1 0 0       2020-02-01T02:13:26  
1597202 2020-02-19 Sweden       1 0 0       2020-02-01T02:13:26  
1597278 2020-02-05 Sweden       1 0 0       2020-02-01T02:13:26  
1659445 2020-02-20 Sweden       1 0 0       2020-02-01T02:13:26  
1710542 2020-02-13 Sweden       1 0 0       2020-02-01T02:13:26  
1738897 2020-02-21 Sweden       1 0 0       2020-02-01T02:13:26  
606 2020-09-15 Sweden Halland     2323 83 0 2240 56.8967 12.8034 2020-09-16 04:22:53 Halland, Sweden
4584 2020-12-05 Sweden Halland     7372 111 0 7261 56.8967 12.8034 2020-12-06 05:26:18 Halland, Sweden
11132 2020-06-09 Sweden Halland     937 57 0 880 56.8967 12.8034 2020-06-10 04:07:00 Halland, Sweden
12253 2021-04-28 Sweden Halland     37657 308 0 37349 56.8967 12.8034 2021-04-29 04:20:55 Halland, Sweden
21475 2020-06-17 Sweden Halland     1131 62 0 1069 56.8967 12.8034 2020-06-18 04:33:18 Halland, Sweden
22829 2021-03-12 Sweden Halland     26561 280 0 26281 56.8967 12.8034 2021-03-13 05:25:15 Halland, Sweden
29597 2020-08-02 Sweden Halland     1757 79 0 1678 56.8967 12.8034 2020-08-03 04:34:35 Halland, Sweden
30741 2020-10-09 Sweden Halland     2784 88 0 2696 56.8967 12.8034 2020-10-10 04:23:57 Halland, Sweden
34704 2020-08-21 Sweden Halland     2020 81 0 1939 56.8967 12.8034 2020-08-22 04:27:49 Halland, Sweden
38680 2021-04-29 Sweden Halland     37799 308 0 37491 56.8967 12.8034 2021-04-30 04:21:03 Halland, Sweden
42666 2021-02-26 Sweden Halland     23637 271 0 23366 56.8967 12.8034 2021-02-27 05:22:28 Halland, Sweden
46649 2020-12-31 Sweden Halland     12380 140 0 12240 56.8967 12.8034 2021-01-01 05:23:07 Halland, Sweden
50617 2020-09-24 Sweden Halland     2449 84 0 2365 56.8967 12.8034 2020-09-25 04:23:00 Halland, Sweden
54599 2021-05-22 Sweden Halland     39888 315 0 39573 56.8967 12.8034 2021-05-23 04:20:51 Halland, Sweden
65290 2021-05-18 Sweden Halland     39603 314 0 39289 56.8967 12.8034 2021-05-19 04:20:42 Halland, Sweden
69403 2021-01-08 Sweden Halland     14860 150 0 14710 56.8967 12.8034 2021-01-09 05:22:18 Halland, Sweden
73637 2021-04-04 Sweden Halland     32182 290 0 31892 56.8967 12.8034 2021-04-05 04:20:35 Halland, Sweden
80962 2021-06-12 Sweden Halland     40715 319 0 40396 56.8967 12.8034 2021-06-13 04:22:44 Halland, Sweden
87602 2020-07-03 Sweden Halland     1574 72 0 1502 56.8967 12.8034 2020-07-04 04:33:51 Halland, Sweden
88753 2021-04-06 Sweden Halland     33039 293 0 32746 56.8967 12.8034 2021-04-07 04:20:53 Halland, Sweden
92737 2021-01-09 Sweden Halland     14860 150 0 14710 56.8967 12.8034 2021-01-10 05:22:12 Halland, Sweden
96723 2021-04-22 Sweden Halland     36829 306 0 36523 56.8967 12.8034 2021-04-23 04:20:52 Halland, Sweden
100759 2021-02-23 Sweden Halland     22745 262 0 22483 56.8967 12.8034 2021-02-24 05:29:16 Halland, Sweden
104727 2020-09-25 Sweden Halland     2480 84 0 2396 56.8967 12.8034 2020-09-26 04:23:00 Halland, Sweden
108706 2020-12-28 Sweden Halland     10430 134 0 10296 56.8967 12.8034 2020-12-29 05:22:37 Halland, Sweden
112675 2020-10-26 Sweden Halland     3084 89 0 2995 56.8967 12.8034 2020-10-27 04:24:45 Halland, Sweden
116659 2021-02-21 Sweden Halland     22211 262 0 21949 56.8967 12.8034 2021-02-22 05:24:21 Halland, Sweden
123135 2021-04-05 Sweden Halland     32182 290 0 31892 56.8967 12.8034 2021-04-06 04:20:32 Halland, Sweden
127103 2020-09-29 Sweden Halland     2551 87 0 2464 56.8967 12.8034 2020-09-30 04:23:33 Halland, Sweden
133870 2020-08-06 Sweden Halland     1827 79 0 1748 56.8967 12.8034 2020-08-07 04:35:11 Halland, Sweden
135032 2021-01-19 Sweden Halland     16939 172 0 16767 56.8967 12.8034 2021-01-20 05:21:54 Halland, Sweden
141799 2020-07-30 Sweden Halland     1758 78 0 1680 56.8967 12.8034 2020-07-31 04:35:18 Halland, Sweden
145630 2020-07-11 Sweden Halland     1639 75 0 1564 56.8967 12.8034 2020-07-12 04:34:30 Halland, Sweden
149394 2020-06-21 Sweden Halland     1154 62 0 1092 56.8967 12.8034 2020-06-22 04:33:20 Halland, Sweden
150541 2020-11-19 Sweden Halland     5347 98 0 5249 56.8967 12.8034 2020-11-20 05:26:28 Halland, Sweden
154579 2020-12-23 Sweden Halland     10430 134 0 10296 56.8967 12.8034 2020-12-24 05:23:04 Halland, Sweden
161465 2020-11-02 Sweden Halland     3435 89 0 3346 56.8967 12.8034 2020-11-03 06:00:16 Halland, Sweden
168774 2021-06-19 Sweden Halland     40737 319 0 40418 56.8967 12.8034 2021-06-20 04:21:48 Halland, Sweden
172757 2021-03-09 Sweden Halland     25577 275 0 25302 56.8967 12.8034 2021-03-10 05:24:35 Halland, Sweden
180281 2020-12-04 Sweden Halland     7372 111 0 7261 56.8967 12.8034 2020-12-05 05:27:36 Halland, Sweden
186825 2020-06-07 Sweden Halland     913 57 0 856 56.8967 12.8034 2020-06-08 03:33:22 Halland, Sweden
187947 2021-02-20 Sweden Halland     22211 262 0 21949 56.8967 12.8034 2021-02-21 05:24:33 Halland, Sweden
194715 2020-08-03 Sweden Halland     1774 79 0 1695 56.8967 12.8034 2020-08-04 04:41:59 Halland, Sweden
195858 2020-08-28 Sweden Halland     2129 81 0 2048 56.8967 12.8034 2020-08-29 04:28:19 Halland, Sweden
199816 2020-08-24 Sweden Halland     2061 81 0 1980 56.8967 12.8034 2020-08-25 04:28:02 Halland, Sweden
207217 2021-02-22 Sweden Halland     22211 262 0 21949 56.8967 12.8034 2021-02-23 05:23:41 Halland, Sweden
211187 2020-11-08 Sweden Halland     4052 89 0 3963 56.8967 12.8034 2020-11-09 05:25:45 Halland, Sweden
215170 2021-01-13 Sweden Halland     15980 165 0 15815 56.8967 12.8034 2021-01-14 05:22:32 Halland, Sweden
225243 2020-07-07 Sweden Halland     1592 72 0 1520 56.8967 12.8034 2020-07-08 05:33:48 Halland, Sweden
226392 2020-11-28 Sweden Halland     6299 109 0 6190 56.8967 12.8034 2020-11-29 05:25:55 Halland, Sweden
230378 2021-03-19 Sweden Halland     28262 285 0 27977 56.8967 12.8034 2021-03-20 05:25:46 Halland, Sweden
234346 2020-09-21 Sweden Halland     2356 83 0 2273 56.8967 12.8034 2020-09-22 04:23:00 Halland, Sweden
238328 2021-04-16 Sweden Halland     35796 301 0 35495 56.8967 12.8034 2021-04-17 04:20:40 Halland, Sweden
242295 2020-08-22 Sweden Halland     2020 81 0 1939 56.8967 12.8034 2020-08-23 04:27:48 Halland, Sweden
253212 2021-03-10 Sweden Halland     26007 278 0 25729 56.8967 12.8034 2021-03-11 05:25:48 Halland, Sweden
257197 2021-02-16 Sweden Halland     21479 254 0 21225 56.8967 12.8034 2021-02-17 05:23:10 Halland, Sweden
261181 2020-11-29 Sweden Halland     6299 109 0 6190 56.8967 12.8034 2020-11-30 05:26:13 Halland, Sweden
267824 2020-07-05 Sweden Halland     1574 72 0 1502 56.8967 12.8034 2020-07-06 04:33:57 Halland, Sweden
272196 2020-10-19 Sweden Halland     2914 89 0 2825 56.8967 12.8034 2020-10-20 04:24:22 Halland, Sweden
276180 2021-03-14 Sweden Halland     26561 280 0 26281 56.8967 12.8034 2021-03-15 05:25:51 Halland, Sweden
280165 2021-01-23 Sweden Halland     17694 195 0 17499 56.8967 12.8034 2021-01-24 05:22:35 Halland, Sweden
284134 2020-10-02 Sweden Halland     2636 87 0 2549 56.8967 12.8034 2020-10-03 04:23:40 Halland, Sweden
288114 2021-01-07 Sweden Halland     14398 149 0 14249 56.8967 12.8034 2021-01-08 05:22:42 Halland, Sweden
292101 2021-06-01 Sweden Halland     40207 317 0 39890 56.8967 12.8034 2021-06-02 04:24:34 Halland, Sweden
296083 2020-12-13 Sweden Halland     8249 118 0 8131 56.8967 12.8034 2020-12-14 05:26:27 Halland, Sweden
303339 2020-11-26 Sweden Halland     6226 105 0 6121 56.8967 12.8034 2020-11-27 05:26:53 Halland, Sweden
311027 2020-08-31 Sweden Halland     2137 81 0 2056 56.8967 12.8034 2020-09-01 04:28:31 Halland, Sweden
318411 2021-06-03 Sweden Halland     40477 317 0 40160 56.8967 12.8034 2021-06-04 04:23:37 Halland, Sweden
322392 2020-11-16 Sweden Halland     4847 95 0 4752 56.8967 12.8034 2020-11-17 05:25:54 Halland, Sweden
332370 2020-08-10 Sweden Halland     1872 79 0 1793 56.8967 12.8034 2020-08-11 04:35:08 Halland, 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]);