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

15,141 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 1

  • Sweden · 15,141 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1733781 1733781 2022-05-20 Sweden Blekinge     29664 166 0   56.2784 15.018 2022-05-21 04:20:58 Blekinge, Sweden
1733782 1733782 2022-05-20 Sweden Dalarna     69890 481 0   61.0917 14.6664 2022-05-21 04:20:58 Dalarna, Sweden
1733783 1733783 2022-05-20 Sweden Gavleborg     73796 705 0   61.3012 16.1534 2022-05-21 04:20:58 Gavleborg, Sweden
1733784 1733784 2022-05-20 Sweden Gotland     11442 71 0   57.4684 18.4867 2022-05-21 04:20:58 Gotland, Sweden
1733785 1733785 2022-05-20 Sweden Halland     104841 453 0   56.8967 12.8034 2022-05-21 04:20:58 Halland, Sweden
1733786 1733786 2022-05-20 Sweden Jamtland Harjedalen     32821 175 0   63.1712 14.9592 2022-05-21 04:20:58 Jamtland Harjedalen, Sweden
1733787 1733787 2022-05-20 Sweden Jonkoping     86408 689 0   57.3708 14.3439 2022-05-21 04:20:58 Jonkoping, Sweden
1733788 1733788 2022-05-20 Sweden Kalmar     60177 354 0   57.235 16.1849 2022-05-21 04:20:58 Kalmar, Sweden
1733789 1733789 2022-05-20 Sweden Kronoberg     49494 385 0   56.7183 14.4115 2022-05-21 04:20:58 Kronoberg, Sweden
1733790 1733790 2022-05-20 Sweden Norrbotten     48886 407 0   66.8309 20.3992 2022-05-21 04:20:58 Norrbotten, Sweden
1733791 1733791 2022-05-20 Sweden Orebro     92917 472 0   59.535 15.0066 2022-05-21 04:20:58 Orebro, Sweden
1733792 1733792 2022-05-20 Sweden Ostergotland     95064 820 0   58.3454 15.5198 2022-05-21 04:20:58 Ostergotland, Sweden
1733793 1733793 2022-05-20 Sweden Skane     338117 2394 0   55.9903 13.5958 2022-05-21 04:20:58 Skane, Sweden
1733794 1733794 2022-05-20 Sweden Sormland     63883 587 0   59.0336 16.7519 2022-05-21 04:20:58 Sormland, Sweden
1733795 1733795 2022-05-20 Sweden Stockholm     573550 5249 0   59.6025 18.1384 2022-05-21 04:20:58 Stockholm, Sweden
1733796 1733796 2022-05-20 Sweden Uppsala     89719 683 0   60.0092 17.2715 2022-05-21 04:20:58 Uppsala, Sweden
1733797 1733797 2022-05-20 Sweden Varmland     65499 352 0   59.7294 13.2354 2022-05-21 04:20:58 Varmland, Sweden
1733798 1733798 2022-05-20 Sweden Vasterbotten     56661 325 0   65.3337 16.5162 2022-05-21 04:20:58 Vasterbotten, Sweden
1733799 1733799 2022-05-20 Sweden Vasternorrland     53610 602 0   63.4276 17.7292 2022-05-21 04:20:58 Vasternorrland, Sweden
1733800 1733800 2022-05-20 Sweden Vastmanland     75823 486 0   59.6714 16.2159 2022-05-21 04:20:58 Vastmanland, Sweden
1733801 1733801 2022-05-20 Sweden Vastra Gotaland     434345 3085 0   58.2528 13.0596 2022-05-21 04:20:58 Vastra Gotaland, Sweden
2573199 2573199 2022-05-19 Sweden Blekinge     29664 166 0   56.2784 15.018 2022-05-20 04:20:57 Blekinge, Sweden
2573200 2573200 2022-05-19 Sweden Dalarna     69890 481 0   61.0917 14.6664 2022-05-20 04:20:57 Dalarna, Sweden
2573201 2573201 2022-05-19 Sweden Gavleborg     73796 705 0   61.3012 16.1534 2022-05-20 04:20:57 Gavleborg, Sweden
2573202 2573202 2022-05-19 Sweden Gotland     11442 71 0   57.4684 18.4867 2022-05-20 04:20:57 Gotland, Sweden
2573203 2573203 2022-05-19 Sweden Halland     104841 453 0   56.8967 12.8034 2022-05-20 04:20:57 Halland, Sweden
2573204 2573204 2022-05-19 Sweden Jamtland Harjedalen     32821 175 0   63.1712 14.9592 2022-05-20 04:20:57 Jamtland Harjedalen, Sweden
2573205 2573205 2022-05-19 Sweden Jonkoping     86408 689 0   57.3708 14.3439 2022-05-20 04:20:57 Jonkoping, Sweden
2573206 2573206 2022-05-19 Sweden Kalmar     60177 354 0   57.235 16.1849 2022-05-20 04:20:57 Kalmar, Sweden
2573207 2573207 2022-05-19 Sweden Kronoberg     49494 385 0   56.7183 14.4115 2022-05-20 04:20:57 Kronoberg, Sweden
2573208 2573208 2022-05-19 Sweden Norrbotten     48886 407 0   66.8309 20.3992 2022-05-20 04:20:57 Norrbotten, Sweden
2573209 2573209 2022-05-19 Sweden Orebro     92917 472 0   59.535 15.0066 2022-05-20 04:20:57 Orebro, Sweden
2573210 2573210 2022-05-19 Sweden Ostergotland     95064 820 0   58.3454 15.5198 2022-05-20 04:20:57 Ostergotland, Sweden
2573211 2573211 2022-05-19 Sweden Skane     338117 2394 0   55.9903 13.5958 2022-05-20 04:20:57 Skane, Sweden
2573212 2573212 2022-05-19 Sweden Sormland     63883 587 0   59.0336 16.7519 2022-05-20 04:20:57 Sormland, Sweden
2573213 2573213 2022-05-19 Sweden Stockholm     573550 5249 0   59.6025 18.1384 2022-05-20 04:20:57 Stockholm, Sweden
2573214 2573214 2022-05-19 Sweden Uppsala     89719 683 0   60.0092 17.2715 2022-05-20 04:20:57 Uppsala, Sweden
2573215 2573215 2022-05-19 Sweden Varmland     65499 352 0   59.7294 13.2354 2022-05-20 04:20:57 Varmland, Sweden
2573216 2573216 2022-05-19 Sweden Vasterbotten     56661 325 0   65.3337 16.5162 2022-05-20 04:20:57 Vasterbotten, Sweden
2573217 2573217 2022-05-19 Sweden Vasternorrland     53610 602 0   63.4276 17.7292 2022-05-20 04:20:57 Vasternorrland, Sweden
2573218 2573218 2022-05-19 Sweden Vastmanland     75823 486 0   59.6714 16.2159 2022-05-20 04:20:57 Vastmanland, Sweden
2573219 2573219 2022-05-19 Sweden Vastra Gotaland     434345 3085 0   58.2528 13.0596 2022-05-20 04:20:57 Vastra Gotaland, Sweden
1432585 1432585 2022-05-18 Sweden Blekinge     29639 164 0   56.2784 15.018 2022-05-19 04:20:54 Blekinge, Sweden
1432586 1432586 2022-05-18 Sweden Dalarna     69799 479 0   61.0917 14.6664 2022-05-19 04:20:54 Dalarna, Sweden
1432587 1432587 2022-05-18 Sweden Gavleborg     73771 699 0   61.3012 16.1534 2022-05-19 04:20:54 Gavleborg, Sweden
1432588 1432588 2022-05-18 Sweden Gotland     11437 71 0   57.4684 18.4867 2022-05-19 04:20:54 Gotland, Sweden
1432589 1432589 2022-05-18 Sweden Halland     104789 452 0   56.8967 12.8034 2022-05-19 04:20:54 Halland, Sweden
1432590 1432590 2022-05-18 Sweden Jamtland Harjedalen     32805 175 0   63.1712 14.9592 2022-05-19 04:20:54 Jamtland Harjedalen, Sweden
1432591 1432591 2022-05-18 Sweden Jonkoping     86374 686 0   57.3708 14.3439 2022-05-19 04:20:54 Jonkoping, Sweden
1432592 1432592 2022-05-18 Sweden Kalmar     60161 353 0   57.235 16.1849 2022-05-19 04:20:54 Kalmar, Sweden
1432593 1432593 2022-05-18 Sweden Kronoberg     49459 384 0   56.7183 14.4115 2022-05-19 04:20:54 Kronoberg, Sweden
1432594 1432594 2022-05-18 Sweden Norrbotten     48838 406 0   66.8309 20.3992 2022-05-19 04:20:54 Norrbotten, Sweden
1432595 1432595 2022-05-18 Sweden Orebro     92840 468 0   59.535 15.0066 2022-05-19 04:20:54 Orebro, Sweden
1432596 1432596 2022-05-18 Sweden Ostergotland     95013 819 0   58.3454 15.5198 2022-05-19 04:20:54 Ostergotland, Sweden
1432597 1432597 2022-05-18 Sweden Skane     337986 2386 0   55.9903 13.5958 2022-05-19 04:20:54 Skane, Sweden
1432598 1432598 2022-05-18 Sweden Sormland     63824 587 0   59.0336 16.7519 2022-05-19 04:20:54 Sormland, Sweden
1432599 1432599 2022-05-18 Sweden Stockholm     572957 5243 0   59.6025 18.1384 2022-05-19 04:20:54 Stockholm, Sweden
1432600 1432600 2022-05-18 Sweden Uppsala     89632 682 0   60.0092 17.2715 2022-05-19 04:20:54 Uppsala, Sweden
1432601 1432601 2022-05-18 Sweden Varmland     65442 351 0   59.7294 13.2354 2022-05-19 04:20:54 Varmland, Sweden
1432602 1432602 2022-05-18 Sweden Vasterbotten     56591 324 0   65.3337 16.5162 2022-05-19 04:20:54 Vasterbotten, Sweden
1432603 1432603 2022-05-18 Sweden Vasternorrland     53564 602 0   63.4276 17.7292 2022-05-19 04:20:54 Vasternorrland, Sweden
1432604 1432604 2022-05-18 Sweden Vastmanland     75794 485 0   59.6714 16.2159 2022-05-19 04:20:54 Vastmanland, Sweden
1432605 1432605 2022-05-18 Sweden Vastra Gotaland     434179 3081 0   58.2528 13.0596 2022-05-19 04:20:54 Vastra Gotaland, Sweden
1599861 1599861 2022-05-17 Sweden Blekinge     29639 164 0   56.2784 15.018 2022-05-18 04:20:50 Blekinge, Sweden
1599862 1599862 2022-05-17 Sweden Dalarna     69799 479 0   61.0917 14.6664 2022-05-18 04:20:50 Dalarna, Sweden
1599863 1599863 2022-05-17 Sweden Gavleborg     73771 699 0   61.3012 16.1534 2022-05-18 04:20:50 Gavleborg, Sweden
1599864 1599864 2022-05-17 Sweden Gotland     11437 71 0   57.4684 18.4867 2022-05-18 04:20:50 Gotland, Sweden
1599865 1599865 2022-05-17 Sweden Halland     104789 452 0   56.8967 12.8034 2022-05-18 04:20:50 Halland, Sweden
1599866 1599866 2022-05-17 Sweden Jamtland Harjedalen     32805 175 0   63.1712 14.9592 2022-05-18 04:20:50 Jamtland Harjedalen, Sweden
1599867 1599867 2022-05-17 Sweden Jonkoping     86374 686 0   57.3708 14.3439 2022-05-18 04:20:50 Jonkoping, Sweden
1599868 1599868 2022-05-17 Sweden Kalmar     60161 353 0   57.235 16.1849 2022-05-18 04:20:50 Kalmar, Sweden
1599869 1599869 2022-05-17 Sweden Kronoberg     49459 384 0   56.7183 14.4115 2022-05-18 04:20:50 Kronoberg, Sweden
1599870 1599870 2022-05-17 Sweden Norrbotten     48838 406 0   66.8309 20.3992 2022-05-18 04:20:50 Norrbotten, Sweden
1599871 1599871 2022-05-17 Sweden Orebro     92840 468 0   59.535 15.0066 2022-05-18 04:20:50 Orebro, Sweden
1599872 1599872 2022-05-17 Sweden Ostergotland     95013 819 0   58.3454 15.5198 2022-05-18 04:20:50 Ostergotland, Sweden
1599873 1599873 2022-05-17 Sweden Skane     337986 2386 0   55.9903 13.5958 2022-05-18 04:20:50 Skane, Sweden
1599874 1599874 2022-05-17 Sweden Sormland     63824 587 0   59.0336 16.7519 2022-05-18 04:20:50 Sormland, Sweden
1599875 1599875 2022-05-17 Sweden Stockholm     572957 5243 0   59.6025 18.1384 2022-05-18 04:20:50 Stockholm, Sweden
1599876 1599876 2022-05-17 Sweden Uppsala     89632 682 0   60.0092 17.2715 2022-05-18 04:20:50 Uppsala, Sweden
1599877 1599877 2022-05-17 Sweden Varmland     65442 351 0   59.7294 13.2354 2022-05-18 04:20:50 Varmland, Sweden
1599878 1599878 2022-05-17 Sweden Vasterbotten     56591 324 0   65.3337 16.5162 2022-05-18 04:20:50 Vasterbotten, Sweden
1599879 1599879 2022-05-17 Sweden Vasternorrland     53564 602 0   63.4276 17.7292 2022-05-18 04:20:50 Vasternorrland, Sweden
1599880 1599880 2022-05-17 Sweden Vastmanland     75794 485 0   59.6714 16.2159 2022-05-18 04:20:50 Vastmanland, Sweden
1599881 1599881 2022-05-17 Sweden Vastra Gotaland     434179 3081 0   58.2528 13.0596 2022-05-18 04:20:50 Vastra Gotaland, Sweden
2425979 2425979 2022-05-16 Sweden Blekinge     29639 164 0   56.2784 15.018 2022-05-17 04:20:59 Blekinge, Sweden
2425980 2425980 2022-05-16 Sweden Dalarna     69799 479 0   61.0917 14.6664 2022-05-17 04:20:59 Dalarna, Sweden
2425981 2425981 2022-05-16 Sweden Gavleborg     73771 699 0   61.3012 16.1534 2022-05-17 04:20:59 Gavleborg, Sweden
2425982 2425982 2022-05-16 Sweden Gotland     11437 71 0   57.4684 18.4867 2022-05-17 04:20:59 Gotland, Sweden
2425983 2425983 2022-05-16 Sweden Halland     104789 452 0   56.8967 12.8034 2022-05-17 04:20:59 Halland, Sweden
2425984 2425984 2022-05-16 Sweden Jamtland Harjedalen     32805 175 0   63.1712 14.9592 2022-05-17 04:20:59 Jamtland Harjedalen, Sweden
2425985 2425985 2022-05-16 Sweden Jonkoping     86374 686 0   57.3708 14.3439 2022-05-17 04:20:59 Jonkoping, Sweden
2425986 2425986 2022-05-16 Sweden Kalmar     60161 353 0   57.235 16.1849 2022-05-17 04:20:59 Kalmar, Sweden
2425987 2425987 2022-05-16 Sweden Kronoberg     49459 384 0   56.7183 14.4115 2022-05-17 04:20:59 Kronoberg, Sweden
2425988 2425988 2022-05-16 Sweden Norrbotten     48838 406 0   66.8309 20.3992 2022-05-17 04:20:59 Norrbotten, Sweden
2425989 2425989 2022-05-16 Sweden Orebro     92840 468 0   59.535 15.0066 2022-05-17 04:20:59 Orebro, Sweden
2425990 2425990 2022-05-16 Sweden Ostergotland     95013 819 0   58.3454 15.5198 2022-05-17 04:20:59 Ostergotland, Sweden
2425991 2425991 2022-05-16 Sweden Skane     337986 2386 0   55.9903 13.5958 2022-05-17 04:20:59 Skane, Sweden
2425992 2425992 2022-05-16 Sweden Sormland     63824 587 0   59.0336 16.7519 2022-05-17 04:20:59 Sormland, Sweden
2425993 2425993 2022-05-16 Sweden Stockholm     572957 5243 0   59.6025 18.1384 2022-05-17 04:20:59 Stockholm, Sweden
2425994 2425994 2022-05-16 Sweden Uppsala     89632 682 0   60.0092 17.2715 2022-05-17 04:20:59 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]);