johns_hopkins_csse_daily_reports

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

7,224 rows where country_or_region = "Sweden" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

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

country_or_region

  • Sweden · 7,224 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1020535 1020535 2021-05-08 Sweden Blekinge     11836 128 0 11708 56.2784 15.018 2021-05-09 04:20:35 Blekinge, Sweden
1020536 1020536 2021-05-08 Sweden Dalarna     24815 332 0 24483 61.0917 14.6664 2021-05-09 04:20:35 Dalarna, Sweden
1020537 1020537 2021-05-08 Sweden Gavleborg     33930 548 0 33382 61.3012 16.1534 2021-05-09 04:20:35 Gavleborg, Sweden
1020538 1020538 2021-05-08 Sweden Gotland     3715 51 0 3664 57.4684 18.4867 2021-05-09 04:20:35 Gotland, Sweden
1020539 1020539 2021-05-08 Sweden Halland     38748 310 0 38438 56.8967 12.8034 2021-05-09 04:20:35 Halland, Sweden
1020540 1020540 2021-05-08 Sweden Jamtland Harjedalen     11426 120 0 11306 63.1712 14.9592 2021-05-09 04:20:35 Jamtland Harjedalen, Sweden
1020541 1020541 2021-05-08 Sweden Jonkoping     40396 550 0 39846 57.3708 14.3439 2021-05-09 04:20:35 Jonkoping, Sweden
1020542 1020542 2021-05-08 Sweden Kalmar     21891 240 0 21651 57.235 16.1849 2021-05-09 04:20:35 Kalmar, Sweden
1020543 1020543 2021-05-08 Sweden Kronoberg     19915 308 0 19607 56.7183 14.4115 2021-05-09 04:20:35 Kronoberg, Sweden
1020544 1020544 2021-05-08 Sweden Norrbotten     21918 255 0 21663 66.8309 20.3992 2021-05-09 04:20:35 Norrbotten, Sweden
1020545 1020545 2021-05-08 Sweden Orebro     29512 328 0 29184 59.535 15.0066 2021-05-09 04:20:35 Orebro, Sweden
1020546 1020546 2021-05-08 Sweden Ostergotland     38463 613 0 37850 58.3454 15.5198 2021-05-09 04:20:35 Ostergotland, Sweden
1020547 1020547 2021-05-08 Sweden Skane     145278 1688 0 143590 55.9903 13.5958 2021-05-09 04:20:35 Skane, Sweden
1020548 1020548 2021-05-08 Sweden Sormland     23780 451 0 23329 59.0336 16.7519 2021-05-09 04:20:35 Sormland, Sweden
1020549 1020549 2021-05-08 Sweden Stockholm     238733 4230 0 234503 59.6025 18.1384 2021-05-09 04:20:35 Stockholm, Sweden
1020550 1020550 2021-05-08 Sweden Uppsala     37882 524 0 37358 60.0092 17.2715 2021-05-09 04:20:35 Uppsala, Sweden
1020551 1020551 2021-05-08 Sweden Varmland     17425 200 0 17225 59.7294 13.2354 2021-05-09 04:20:35 Varmland, Sweden
1020552 1020552 2021-05-08 Sweden Vasterbotten     21589 179 0 21410 65.3337 16.5162 2021-05-09 04:20:35 Vasterbotten, Sweden
1020553 1020553 2021-05-08 Sweden Vasternorrland     24914 460 0 24454 63.4276 17.7292 2021-05-09 04:20:35 Vasternorrland, Sweden
1020554 1020554 2021-05-08 Sweden Vastmanland     25585 345 0 25240 59.6714 16.2159 2021-05-09 04:20:35 Vastmanland, Sweden
1020555 1020555 2021-05-08 Sweden Vastra Gotaland     176041 2313 0 173728 58.2528 13.0596 2021-05-09 04:20:35 Vastra Gotaland, Sweden
928708 928708 2021-05-07 Sweden Blekinge     11836 128 0 11708 56.2784 15.018 2021-05-08 04:21:04 Blekinge, Sweden
928709 928709 2021-05-07 Sweden Dalarna     24815 332 0 24483 61.0917 14.6664 2021-05-08 04:21:04 Dalarna, Sweden
928710 928710 2021-05-07 Sweden Gavleborg     33930 548 0 33382 61.3012 16.1534 2021-05-08 04:21:04 Gavleborg, Sweden
928711 928711 2021-05-07 Sweden Gotland     3715 51 0 3664 57.4684 18.4867 2021-05-08 04:21:04 Gotland, Sweden
928712 928712 2021-05-07 Sweden Halland     38748 310 0 38438 56.8967 12.8034 2021-05-08 04:21:04 Halland, Sweden
928713 928713 2021-05-07 Sweden Jamtland Harjedalen     11426 120 0 11306 63.1712 14.9592 2021-05-08 04:21:04 Jamtland Harjedalen, Sweden
928714 928714 2021-05-07 Sweden Jonkoping     40396 550 0 39846 57.3708 14.3439 2021-05-08 04:21:04 Jonkoping, Sweden
928715 928715 2021-05-07 Sweden Kalmar     21891 240 0 21651 57.235 16.1849 2021-05-08 04:21:04 Kalmar, Sweden
928716 928716 2021-05-07 Sweden Kronoberg     19915 308 0 19607 56.7183 14.4115 2021-05-08 04:21:04 Kronoberg, Sweden
928717 928717 2021-05-07 Sweden Norrbotten     21918 255 0 21663 66.8309 20.3992 2021-05-08 04:21:04 Norrbotten, Sweden
928718 928718 2021-05-07 Sweden Orebro     29512 328 0 29184 59.535 15.0066 2021-05-08 04:21:04 Orebro, Sweden
928719 928719 2021-05-07 Sweden Ostergotland     38463 613 0 37850 58.3454 15.5198 2021-05-08 04:21:04 Ostergotland, Sweden
928720 928720 2021-05-07 Sweden Skane     145278 1688 0 143590 55.9903 13.5958 2021-05-08 04:21:04 Skane, Sweden
928721 928721 2021-05-07 Sweden Sormland     23780 451 0 23329 59.0336 16.7519 2021-05-08 04:21:04 Sormland, Sweden
928722 928722 2021-05-07 Sweden Stockholm     238733 4230 0 234503 59.6025 18.1384 2021-05-08 04:21:04 Stockholm, Sweden
928723 928723 2021-05-07 Sweden Uppsala     37882 524 0 37358 60.0092 17.2715 2021-05-08 04:21:04 Uppsala, Sweden
928724 928724 2021-05-07 Sweden Varmland     17425 200 0 17225 59.7294 13.2354 2021-05-08 04:21:04 Varmland, Sweden
928725 928725 2021-05-07 Sweden Vasterbotten     21589 179 0 21410 65.3337 16.5162 2021-05-08 04:21:04 Vasterbotten, Sweden
928726 928726 2021-05-07 Sweden Vasternorrland     24914 460 0 24454 63.4276 17.7292 2021-05-08 04:21:04 Vasternorrland, Sweden
928727 928727 2021-05-07 Sweden Vastmanland     25585 345 0 25240 59.6714 16.2159 2021-05-08 04:21:04 Vastmanland, Sweden
928728 928728 2021-05-07 Sweden Vastra Gotaland     176041 2313 0 173728 58.2528 13.0596 2021-05-08 04:21:04 Vastra Gotaland, Sweden
622778 622778 2021-05-06 Sweden Blekinge     11744 128 0 11616 56.2784 15.018 2021-05-07 04:20:40 Blekinge, Sweden
622779 622779 2021-05-06 Sweden Dalarna     24656 332 0 24324 61.0917 14.6664 2021-05-07 04:20:40 Dalarna, Sweden
622780 622780 2021-05-06 Sweden Gavleborg     33792 546 0 33246 61.3012 16.1534 2021-05-07 04:20:40 Gavleborg, Sweden
622781 622781 2021-05-06 Sweden Gotland     3705 51 0 3654 57.4684 18.4867 2021-05-07 04:20:40 Gotland, Sweden
622782 622782 2021-05-06 Sweden Halland     38566 310 0 38256 56.8967 12.8034 2021-05-07 04:20:40 Halland, Sweden
622783 622783 2021-05-06 Sweden Jamtland Harjedalen     11315 120 0 11195 63.1712 14.9592 2021-05-07 04:20:40 Jamtland Harjedalen, Sweden
622784 622784 2021-05-06 Sweden Jonkoping     40190 549 0 39641 57.3708 14.3439 2021-05-07 04:20:40 Jonkoping, Sweden
622785 622785 2021-05-06 Sweden Kalmar     21679 239 0 21440 57.235 16.1849 2021-05-07 04:20:40 Kalmar, Sweden
622786 622786 2021-05-06 Sweden Kronoberg     19716 307 0 19409 56.7183 14.4115 2021-05-07 04:20:40 Kronoberg, Sweden
622787 622787 2021-05-06 Sweden Norrbotten     21687 255 0 21432 66.8309 20.3992 2021-05-07 04:20:40 Norrbotten, Sweden
622788 622788 2021-05-06 Sweden Orebro     29306 326 0 28980 59.535 15.0066 2021-05-07 04:20:40 Orebro, Sweden
622789 622789 2021-05-06 Sweden Ostergotland     38121 611 0 37510 58.3454 15.5198 2021-05-07 04:20:40 Ostergotland, Sweden
622790 622790 2021-05-06 Sweden Skane     144574 1688 0 142886 55.9903 13.5958 2021-05-07 04:20:40 Skane, Sweden
622791 622791 2021-05-06 Sweden Sormland     23621 451 0 23170 59.0336 16.7519 2021-05-07 04:20:40 Sormland, Sweden
622792 622792 2021-05-06 Sweden Stockholm     237528 4230 0 233298 59.6025 18.1384 2021-05-07 04:20:40 Stockholm, Sweden
622793 622793 2021-05-06 Sweden Uppsala     37693 523 0 37170 60.0092 17.2715 2021-05-07 04:20:40 Uppsala, Sweden
622794 622794 2021-05-06 Sweden Varmland     17315 200 0 17115 59.7294 13.2354 2021-05-07 04:20:40 Varmland, Sweden
622795 622795 2021-05-06 Sweden Vasterbotten     21453 179 0 21274 65.3337 16.5162 2021-05-07 04:20:40 Vasterbotten, Sweden
622796 622796 2021-05-06 Sweden Vasternorrland     24711 460 0 24251 63.4276 17.7292 2021-05-07 04:20:40 Vasternorrland, Sweden
622797 622797 2021-05-06 Sweden Vastmanland     25448 343 0 25105 59.6714 16.2159 2021-05-07 04:20:40 Vastmanland, Sweden
622798 622798 2021-05-06 Sweden Vastra Gotaland     175301 2310 0 172991 58.2528 13.0596 2021-05-07 04:20:40 Vastra Gotaland, Sweden
453291 453291 2021-05-05 Sweden Blekinge     11650 128 0 11522 56.2784 15.018 2021-05-06 04:20:38 Blekinge, Sweden
453292 453292 2021-05-05 Sweden Dalarna     24507 332 0 24175 61.0917 14.6664 2021-05-06 04:20:38 Dalarna, Sweden
453293 453293 2021-05-05 Sweden Gavleborg     33627 546 0 33081 61.3012 16.1534 2021-05-06 04:20:38 Gavleborg, Sweden
453294 453294 2021-05-05 Sweden Gotland     3677 51 0 3626 57.4684 18.4867 2021-05-06 04:20:38 Gotland, Sweden
453295 453295 2021-05-05 Sweden Halland     38500 310 0 38190 56.8967 12.8034 2021-05-06 04:20:38 Halland, Sweden
453296 453296 2021-05-05 Sweden Jamtland Harjedalen     11214 120 0 11094 63.1712 14.9592 2021-05-06 04:20:38 Jamtland Harjedalen, Sweden
453297 453297 2021-05-05 Sweden Jonkoping     39976 548 0 39428 57.3708 14.3439 2021-05-06 04:20:38 Jonkoping, Sweden
453298 453298 2021-05-05 Sweden Kalmar     21459 235 0 21224 57.235 16.1849 2021-05-06 04:20:38 Kalmar, Sweden
453299 453299 2021-05-05 Sweden Kronoberg     19500 307 0 19193 56.7183 14.4115 2021-05-06 04:20:38 Kronoberg, Sweden
453300 453300 2021-05-05 Sweden Norrbotten     21507 255 0 21252 66.8309 20.3992 2021-05-06 04:20:38 Norrbotten, Sweden
453301 453301 2021-05-05 Sweden Orebro     29132 326 0 28806 59.535 15.0066 2021-05-06 04:20:38 Orebro, Sweden
453302 453302 2021-05-05 Sweden Ostergotland     37810 611 0 37199 58.3454 15.5198 2021-05-06 04:20:38 Ostergotland, Sweden
453303 453303 2021-05-05 Sweden Skane     143830 1688 0 142142 55.9903 13.5958 2021-05-06 04:20:38 Skane, Sweden
453304 453304 2021-05-05 Sweden Sormland     23458 451 0 23007 59.0336 16.7519 2021-05-06 04:20:38 Sormland, Sweden
453305 453305 2021-05-05 Sweden Stockholm     236126 4230 0 231896 59.6025 18.1384 2021-05-06 04:20:38 Stockholm, Sweden
453306 453306 2021-05-05 Sweden Uppsala     37436 523 0 36913 60.0092 17.2715 2021-05-06 04:20:38 Uppsala, Sweden
453307 453307 2021-05-05 Sweden Varmland     17222 199 0 17023 59.7294 13.2354 2021-05-06 04:20:38 Varmland, Sweden
453308 453308 2021-05-05 Sweden Vasterbotten     21352 178 0 21174 65.3337 16.5162 2021-05-06 04:20:38 Vasterbotten, Sweden
453309 453309 2021-05-05 Sweden Vasternorrland     24490 459 0 24031 63.4276 17.7292 2021-05-06 04:20:38 Vasternorrland, Sweden
453310 453310 2021-05-05 Sweden Vastmanland     25214 343 0 24871 59.6714 16.2159 2021-05-06 04:20:38 Vastmanland, Sweden
453311 453311 2021-05-05 Sweden Vastra Gotaland     173908 2311 0 171597 58.2528 13.0596 2021-05-06 04:20:38 Vastra Gotaland, Sweden
764995 764995 2021-05-04 Sweden Blekinge     11494 128 0 11366 56.2784 15.018 2021-05-05 04:20:43 Blekinge, Sweden
764996 764996 2021-05-04 Sweden Dalarna     24241 330 0 23911 61.0917 14.6664 2021-05-05 04:20:43 Dalarna, Sweden
764997 764997 2021-05-04 Sweden Gavleborg     33378 544 0 32834 61.3012 16.1534 2021-05-05 04:20:43 Gavleborg, Sweden
764998 764998 2021-05-04 Sweden Gotland     3663 51 0 3612 57.4684 18.4867 2021-05-05 04:20:43 Gotland, Sweden
764999 764999 2021-05-04 Sweden Halland     38336 309 0 38027 56.8967 12.8034 2021-05-05 04:20:43 Halland, Sweden
765000 765000 2021-05-04 Sweden Jamtland Harjedalen     11092 120 0 10972 63.1712 14.9592 2021-05-05 04:20:43 Jamtland Harjedalen, Sweden
765001 765001 2021-05-04 Sweden Jonkoping     39580 548 0 39032 57.3708 14.3439 2021-05-05 04:20:43 Jonkoping, Sweden
765002 765002 2021-05-04 Sweden Kalmar     21116 235 0 20881 57.235 16.1849 2021-05-05 04:20:43 Kalmar, Sweden
765003 765003 2021-05-04 Sweden Kronoberg     19211 307 0 18904 56.7183 14.4115 2021-05-05 04:20:43 Kronoberg, Sweden
765004 765004 2021-05-04 Sweden Norrbotten     21302 252 0 21050 66.8309 20.3992 2021-05-05 04:20:43 Norrbotten, Sweden
765005 765005 2021-05-04 Sweden Orebro     28934 325 0 28609 59.535 15.0066 2021-05-05 04:20:43 Orebro, Sweden
765006 765006 2021-05-04 Sweden Ostergotland     37515 605 0 36910 58.3454 15.5198 2021-05-05 04:20:43 Ostergotland, Sweden
765007 765007 2021-05-04 Sweden Skane     142860 1688 0 141172 55.9903 13.5958 2021-05-05 04:20:43 Skane, Sweden
765008 765008 2021-05-04 Sweden Sormland     23280 450 0 22830 59.0336 16.7519 2021-05-05 04:20:43 Sormland, Sweden
765009 765009 2021-05-04 Sweden Stockholm     234858 4203 0 230655 59.6025 18.1384 2021-05-05 04:20:43 Stockholm, Sweden
765010 765010 2021-05-04 Sweden Uppsala     37181 522 0 36659 60.0092 17.2715 2021-05-05 04:20:43 Uppsala, 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] TEXT,
   [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]);