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

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  
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  
195320 2020-02-11 Sweden       1 0 0       2020-02-01T02: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  
419518 2020-03-09 Sweden       248 0 1   63.0 16.0 2020-03-09T18:33:03  
515443 2020-02-08 Sweden       1 0 0       2020-02-01T02:13:26  
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  
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  
1073685 2020-03-07 Sweden       161 0 0   63.0 16.0 2020-03-07T17:53:03  
1085313 2020-03-01 Sweden       14 0 0   63.0 16.0 2020-03-01T23:23:02  
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  
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  
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  
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  
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  
589540 2020-03-13 Sweden       814 1 1   60.1282 18.6435 2020-03-11T20:00:00  
1069314 2020-03-12 Sweden       599 1 1   63.0 16.0 2020-03-12T21:39:09  
1539348 2020-03-11 Sweden       500 1 1   63.0 16.0 2020-03-11T19:33:02  
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  
1261512 2020-06-05 Sweden Blekinge     264 5 0 259 56.2784 15.017999999999999 2020-06-06 02:33:00 Blekinge, Sweden
1378715 2020-06-07 Sweden Blekinge     279 5 0 274 56.2784 15.017999999999999 2020-06-08 03:33:22 Blekinge, Sweden
1394294 2020-06-08 Sweden Blekinge     297 5 0 292 56.2784 15.017999999999999 2020-06-09 03:33:03 Blekinge, Sweden
1461426 2020-06-06 Sweden Blekinge     274 5 0 269 56.2784 15.017999999999999 2020-06-07 03:53:30 Blekinge, Sweden
3683 2020-10-26 Sweden Gotland     384 6 0 378 57.4684 18.4867 2020-10-27 04:24:45 Gotland, Sweden
13778 2020-07-17 Sweden Gotland     196 6 0 190 57.4684 18.4867 2020-07-18 04:34:45 Gotland, Sweden
22050 2020-10-13 Sweden Gotland     366 6 0 360 57.4684 18.4867 2020-10-14 04:24:05 Gotland, Sweden
37217 2020-10-27 Sweden Gotland     408 6 0 402 57.4684 18.4867 2020-10-28 04:24:39 Gotland, Sweden
43964 2020-07-30 Sweden Gotland     238 6 0 232 57.4684 18.4867 2020-07-31 04:35:18 Gotland, Sweden
66496 2020-07-05 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-06 04:33:57 Gotland, Sweden
78496 2020-07-27 Sweden Gotland     230 6 0 224 57.4684 18.4867 2020-07-28 04:58:43 Gotland, Sweden
79657 2020-10-28 Sweden Gotland     409 6 0 403 57.4684 18.4867 2020-10-29 04:24:49 Gotland, Sweden
83620 2020-09-16 Sweden Gotland     323 6 0 317 57.4684 18.4867 2020-09-17 04:22:00 Gotland, Sweden
87581 2020-10-09 Sweden Gotland     351 6 0 345 57.4684 18.4867 2020-10-10 04:23:57 Gotland, Sweden
106276 2020-08-08 Sweden Gotland     270 6 0 264 57.4684 18.4867 2020-08-09 04:34:54 Gotland, Sweden
111415 2020-08-11 Sweden Gotland     287 6 0 281 57.4684 18.4867 2020-08-12 04:27:29 Gotland, Sweden
118133 2020-07-18 Sweden Gotland     196 6 0 190 57.4684 18.4867 2020-07-19 04:34:58 Gotland, Sweden
119289 2020-08-20 Sweden Gotland     311 6 0 305 57.4684 18.4867 2020-08-21 04:27:41 Gotland, Sweden
133690 2020-07-04 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-05 04:33:46 Gotland, Sweden
134910 2020-10-05 Sweden Gotland     337 6 0 331 57.4684 18.4867 2020-10-06 04:23:33 Gotland, Sweden
157564 2020-06-22 Sweden Gotland     131 6 0 125 57.4684 18.4867 2020-06-23 04:33:22 Gotland, Sweden
170738 2020-09-02 Sweden Gotland     318 6 0 312 57.4684 18.4867 2020-09-03 04:28:22 Gotland, Sweden
183633 2020-06-12 Sweden Gotland     106 6 0 100 57.4684 18.4867 2020-06-13 03:33:14 Gotland, Sweden
191906 2020-08-17 Sweden Gotland     307 6 0 301 57.4684 18.4867 2020-08-18 04:27:56 Gotland, Sweden
210109 2020-08-04 Sweden Gotland     251 6 0 245 57.4684 18.4867 2020-08-05 04:34:43 Gotland, Sweden
231186 2020-08-18 Sweden Gotland     308 6 0 302 57.4684 18.4867 2020-08-19 04:27:00 Gotland, Sweden
237762 2020-06-23 Sweden Gotland     137 6 0 131 57.4684 18.4867 2020-06-24 04:33:28 Gotland, Sweden
241577 2020-07-10 Sweden Gotland     181 6 0 175 57.4684 18.4867 2020-07-11 04:34:26 Gotland, Sweden
249286 2020-06-10 Sweden Gotland     97 6 0 91 57.4684 18.4867 2020-06-11 03:33:41 Gotland, Sweden
253203 2020-07-22 Sweden Gotland     212 6 0 206 57.4684 18.4867 2020-07-23 05:15:04 Gotland, Sweden
258344 2020-08-31 Sweden Gotland     318 6 0 312 57.4684 18.4867 2020-09-01 04:28:31 Gotland, Sweden
297751 2020-09-09 Sweden Gotland     319 6 0 313 57.4684 18.4867 2020-09-10 04:29:01 Gotland, Sweden
317264 2020-10-21 Sweden Gotland     378 6 0 372 57.4684 18.4867 2020-10-22 04:24:27 Gotland, Sweden
321228 2020-09-22 Sweden Gotland     327 6 0 321 57.4684 18.4867 2020-09-23 04:23:00 Gotland, Sweden
335490 2020-06-17 Sweden Gotland     118 6 0 112 57.4684 18.4867 2020-06-18 04:33:18 Gotland, Sweden
346810 2020-08-16 Sweden Gotland     297 6 0 291 57.4684 18.4867 2020-08-17 04:27:20 Gotland, Sweden
358059 2020-08-28 Sweden Gotland     317 6 0 311 57.4684 18.4867 2020-08-29 04:28:19 Gotland, Sweden
365997 2020-09-07 Sweden Gotland     319 6 0 313 57.4684 18.4867 2020-09-08 04:28:25 Gotland, Sweden
372628 2020-07-11 Sweden Gotland     181 6 0 175 57.4684 18.4867 2020-07-12 04:34:30 Gotland, Sweden
376449 2020-07-13 Sweden Gotland     182 6 0 176 57.4684 18.4867 2020-07-14 04:34:46 Gotland, Sweden
385371 2020-09-25 Sweden Gotland     327 6 0 321 57.4684 18.4867 2020-09-26 04:23:00 Gotland, Sweden
399162 2020-08-05 Sweden Gotland     257 6 0 251 57.4684 18.4867 2020-08-06 04:35:02 Gotland, Sweden
418650 2020-08-06 Sweden Gotland     268 6 0 262 57.4684 18.4867 2020-08-07 04:35:11 Gotland, Sweden
441389 2020-07-28 Sweden Gotland     230 6 0 224 57.4684 18.4867 2020-07-29 04:35:11 Gotland, Sweden
445317 2020-07-19 Sweden Gotland     196 6 0 190 57.4684 18.4867 2020-07-20 05:34:40 Gotland, Sweden
450440 2020-08-29 Sweden Gotland     317 6 0 311 57.4684 18.4867 2020-08-30 04:28:22 Gotland, Sweden
454396 2020-08-19 Sweden Gotland     310 6 0 304 57.4684 18.4867 2020-08-20 04:27:43 Gotland, Sweden
478252 2020-10-14 Sweden Gotland     366 6 0 360 57.4684 18.4867 2020-10-15 04:24:28 Gotland, Sweden
488977 2020-07-26 Sweden Gotland     219 6 0 213 57.4684 18.4867 2020-07-27 04:35:02 Gotland, Sweden
500124 2020-06-16 Sweden Gotland     114 6 0 108 57.4684 18.4867 2020-06-17 04:33:21 Gotland, Sweden
528266 2020-09-05 Sweden Gotland     318 6 0 312 57.4684 18.4867 2020-09-06 04:28:33 Gotland, Sweden
534829 2020-06-13 Sweden Gotland     109 6 0 103 57.4684 18.4867 2020-06-14 03:33:15 Gotland, Sweden
555253 2020-08-12 Sweden Gotland     288 6 0 282 57.4684 18.4867 2020-08-13 04:29:15 Gotland, Sweden
567167 2020-09-20 Sweden Gotland     324 6 0 318 57.4684 18.4867 2020-09-21 04:23:00 Gotland, Sweden
573916 2020-08-09 Sweden Gotland     270 6 0 264 57.4684 18.4867 2020-08-10 04:34:55 Gotland, 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]);