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

5,796 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 · 5,796 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
801593 801593 2021-03-01 Sweden Blekinge     7945 114 0 7831 56.2784 15.018 2021-03-02 05:23:30 Blekinge, Sweden
801594 801594 2021-03-01 Sweden Dalarna     14749 304 0 14445 61.0917 14.6664 2021-03-02 05:23:30 Dalarna, Sweden
801595 801595 2021-03-01 Sweden Gavleborg     21256 494 0 20762 61.3012 16.1534 2021-03-02 05:23:30 Gavleborg, Sweden
801596 801596 2021-03-01 Sweden Gotland     2687 45 0 2642 57.4684 18.4867 2021-03-02 05:23:30 Gotland, Sweden
801597 801597 2021-03-01 Sweden Halland     23637 271 0 23366 56.8967 12.8034 2021-03-02 05:23:30 Halland, Sweden
801598 801598 2021-03-01 Sweden Jamtland Harjedalen     6822 113 0 6709 63.1712 14.9592 2021-03-02 05:23:30 Jamtland Harjedalen, Sweden
801599 801599 2021-03-01 Sweden Jonkoping     26485 509 0 25976 57.3708 14.3439 2021-03-02 05:23:30 Jonkoping, Sweden
801600 801600 2021-03-01 Sweden Kalmar     11315 214 0 11101 57.235 16.1849 2021-03-02 05:23:30 Kalmar, Sweden
801601 801601 2021-03-01 Sweden Kronoberg     13899 291 0 13608 56.7183 14.4115 2021-03-02 05:23:30 Kronoberg, Sweden
801602 801602 2021-03-01 Sweden Norrbotten     12480 218 0 12262 66.8309 20.3992 2021-03-02 05:23:30 Norrbotten, Sweden
801603 801603 2021-03-01 Sweden Orebro     17895 289 0 17606 59.535 15.0066 2021-03-02 05:23:30 Orebro, Sweden
801604 801604 2021-03-01 Sweden Ostergotland     22855 552 0 22303 58.3454 15.5198 2021-03-02 05:23:30 Ostergotland, Sweden
801605 801605 2021-03-01 Sweden Skane     110096 1547 0 108549 55.9903 13.5958 2021-03-02 05:23:30 Skane, Sweden
801606 801606 2021-03-01 Sweden Sormland     13207 401 0 12806 59.0336 16.7519 2021-03-02 05:23:30 Sormland, Sweden
801607 801607 2021-03-01 Sweden Stockholm     155151 3866 0 151285 59.6025 18.1384 2021-03-02 05:23:30 Stockholm, Sweden
801608 801608 2021-03-01 Sweden Uppsala     24154 479 0 23675 60.0092 17.2715 2021-03-02 05:23:30 Uppsala, Sweden
801609 801609 2021-03-01 Sweden Varmland     9115 167 0 8948 59.7294 13.2354 2021-03-02 05:23:30 Varmland, Sweden
801610 801610 2021-03-01 Sweden Vasterbotten     14376 136 0 14240 65.3337 16.5162 2021-03-02 05:23:30 Vasterbotten, Sweden
801611 801611 2021-03-01 Sweden Vasternorrland     14841 404 0 14437 63.4276 17.7292 2021-03-02 05:23:30 Vasternorrland, Sweden
801612 801612 2021-03-01 Sweden Vastmanland     18167 326 0 17841 59.6714 16.2159 2021-03-02 05:23:30 Vastmanland, Sweden
801613 801613 2021-03-01 Sweden Vastra Gotaland     116177 2086 0 114091 58.2528 13.0596 2021-03-02 05:23:30 Vastra Gotaland, Sweden
1066735 1066735 2021-02-28 Sweden Blekinge     7945 114 0 7831 56.2784 15.018 2021-03-01 05:23:01 Blekinge, Sweden
1066736 1066736 2021-02-28 Sweden Dalarna     14749 304 0 14445 61.0917 14.6664 2021-03-01 05:23:01 Dalarna, Sweden
1066737 1066737 2021-02-28 Sweden Gavleborg     21256 494 0 20762 61.3012 16.1534 2021-03-01 05:23:01 Gavleborg, Sweden
1066738 1066738 2021-02-28 Sweden Gotland     2687 45 0 2642 57.4684 18.4867 2021-03-01 05:23:01 Gotland, Sweden
1066739 1066739 2021-02-28 Sweden Halland     23637 271 0 23366 56.8967 12.8034 2021-03-01 05:23:01 Halland, Sweden
1066740 1066740 2021-02-28 Sweden Jamtland Harjedalen     6822 113 0 6709 63.1712 14.9592 2021-03-01 05:23:01 Jamtland Harjedalen, Sweden
1066741 1066741 2021-02-28 Sweden Jonkoping     26485 509 0 25976 57.3708 14.3439 2021-03-01 05:23:01 Jonkoping, Sweden
1066742 1066742 2021-02-28 Sweden Kalmar     11315 214 0 11101 57.235 16.1849 2021-03-01 05:23:01 Kalmar, Sweden
1066743 1066743 2021-02-28 Sweden Kronoberg     13899 291 0 13608 56.7183 14.4115 2021-03-01 05:23:01 Kronoberg, Sweden
1066744 1066744 2021-02-28 Sweden Norrbotten     12480 218 0 12262 66.8309 20.3992 2021-03-01 05:23:01 Norrbotten, Sweden
1066745 1066745 2021-02-28 Sweden Orebro     17895 289 0 17606 59.535 15.0066 2021-03-01 05:23:01 Orebro, Sweden
1066746 1066746 2021-02-28 Sweden Ostergotland     22855 552 0 22303 58.3454 15.5198 2021-03-01 05:23:01 Ostergotland, Sweden
1066747 1066747 2021-02-28 Sweden Skane     110096 1547 0 108549 55.9903 13.5958 2021-03-01 05:23:01 Skane, Sweden
1066748 1066748 2021-02-28 Sweden Sormland     13207 401 0 12806 59.0336 16.7519 2021-03-01 05:23:01 Sormland, Sweden
1066749 1066749 2021-02-28 Sweden Stockholm     155151 3866 0 151285 59.6025 18.1384 2021-03-01 05:23:01 Stockholm, Sweden
1066750 1066750 2021-02-28 Sweden Uppsala     24154 479 0 23675 60.0092 17.2715 2021-03-01 05:23:01 Uppsala, Sweden
1066751 1066751 2021-02-28 Sweden Varmland     9115 167 0 8948 59.7294 13.2354 2021-03-01 05:23:01 Varmland, Sweden
1066752 1066752 2021-02-28 Sweden Vasterbotten     14376 136 0 14240 65.3337 16.5162 2021-03-01 05:23:01 Vasterbotten, Sweden
1066753 1066753 2021-02-28 Sweden Vasternorrland     14841 404 0 14437 63.4276 17.7292 2021-03-01 05:23:01 Vasternorrland, Sweden
1066754 1066754 2021-02-28 Sweden Vastmanland     18167 326 0 17841 59.6714 16.2159 2021-03-01 05:23:01 Vastmanland, Sweden
1066755 1066755 2021-02-28 Sweden Vastra Gotaland     116177 2086 0 114091 58.2528 13.0596 2021-03-01 05:23:01 Vastra Gotaland, Sweden
745128 745128 2021-02-27 Sweden Blekinge     7945 114 0 7831 56.2784 15.018 2021-02-28 05:22:20 Blekinge, Sweden
745129 745129 2021-02-27 Sweden Dalarna     14749 304 0 14445 61.0917 14.6664 2021-02-28 05:22:20 Dalarna, Sweden
745130 745130 2021-02-27 Sweden Gavleborg     21256 494 0 20762 61.3012 16.1534 2021-02-28 05:22:20 Gavleborg, Sweden
745131 745131 2021-02-27 Sweden Gotland     2687 45 0 2642 57.4684 18.4867 2021-02-28 05:22:20 Gotland, Sweden
745132 745132 2021-02-27 Sweden Halland     23637 271 0 23366 56.8967 12.8034 2021-02-28 05:22:20 Halland, Sweden
745133 745133 2021-02-27 Sweden Jamtland Harjedalen     6822 113 0 6709 63.1712 14.9592 2021-02-28 05:22:20 Jamtland Harjedalen, Sweden
745134 745134 2021-02-27 Sweden Jonkoping     26485 509 0 25976 57.3708 14.3439 2021-02-28 05:22:20 Jonkoping, Sweden
745135 745135 2021-02-27 Sweden Kalmar     11315 214 0 11101 57.235 16.1849 2021-02-28 05:22:20 Kalmar, Sweden
745136 745136 2021-02-27 Sweden Kronoberg     13899 291 0 13608 56.7183 14.4115 2021-02-28 05:22:20 Kronoberg, Sweden
745137 745137 2021-02-27 Sweden Norrbotten     12480 218 0 12262 66.8309 20.3992 2021-02-28 05:22:20 Norrbotten, Sweden
745138 745138 2021-02-27 Sweden Orebro     17895 289 0 17606 59.535 15.0066 2021-02-28 05:22:20 Orebro, Sweden
745139 745139 2021-02-27 Sweden Ostergotland     22855 552 0 22303 58.3454 15.5198 2021-02-28 05:22:20 Ostergotland, Sweden
745140 745140 2021-02-27 Sweden Skane     110096 1547 0 108549 55.9903 13.5958 2021-02-28 05:22:20 Skane, Sweden
745141 745141 2021-02-27 Sweden Sormland     13207 401 0 12806 59.0336 16.7519 2021-02-28 05:22:20 Sormland, Sweden
745142 745142 2021-02-27 Sweden Stockholm     155151 3866 0 151285 59.6025 18.1384 2021-02-28 05:22:20 Stockholm, Sweden
745143 745143 2021-02-27 Sweden Uppsala     24154 479 0 23675 60.0092 17.2715 2021-02-28 05:22:20 Uppsala, Sweden
745144 745144 2021-02-27 Sweden Varmland     9115 167 0 8948 59.7294 13.2354 2021-02-28 05:22:20 Varmland, Sweden
745145 745145 2021-02-27 Sweden Vasterbotten     14376 136 0 14240 65.3337 16.5162 2021-02-28 05:22:20 Vasterbotten, Sweden
745146 745146 2021-02-27 Sweden Vasternorrland     14841 404 0 14437 63.4276 17.7292 2021-02-28 05:22:20 Vasternorrland, Sweden
745147 745147 2021-02-27 Sweden Vastmanland     18167 326 0 17841 59.6714 16.2159 2021-02-28 05:22:20 Vastmanland, Sweden
745148 745148 2021-02-27 Sweden Vastra Gotaland     116177 2086 0 114091 58.2528 13.0596 2021-02-28 05:22:20 Vastra Gotaland, Sweden
951272 951272 2021-02-26 Sweden Blekinge     7945 114 0 7831 56.2784 15.018 2021-02-27 05:22:28 Blekinge, Sweden
951273 951273 2021-02-26 Sweden Dalarna     14749 304 0 14445 61.0917 14.6664 2021-02-27 05:22:28 Dalarna, Sweden
951274 951274 2021-02-26 Sweden Gavleborg     21256 494 0 20762 61.3012 16.1534 2021-02-27 05:22:28 Gavleborg, Sweden
951275 951275 2021-02-26 Sweden Gotland     2687 45 0 2642 57.4684 18.4867 2021-02-27 05:22:28 Gotland, Sweden
951276 951276 2021-02-26 Sweden Halland     23637 271 0 23366 56.8967 12.8034 2021-02-27 05:22:28 Halland, Sweden
951277 951277 2021-02-26 Sweden Jamtland Harjedalen     6822 113 0 6709 63.1712 14.9592 2021-02-27 05:22:28 Jamtland Harjedalen, Sweden
951278 951278 2021-02-26 Sweden Jonkoping     26485 509 0 25976 57.3708 14.3439 2021-02-27 05:22:28 Jonkoping, Sweden
951279 951279 2021-02-26 Sweden Kalmar     11315 214 0 11101 57.235 16.1849 2021-02-27 05:22:28 Kalmar, Sweden
951280 951280 2021-02-26 Sweden Kronoberg     13899 291 0 13608 56.7183 14.4115 2021-02-27 05:22:28 Kronoberg, Sweden
951281 951281 2021-02-26 Sweden Norrbotten     12480 218 0 12262 66.8309 20.3992 2021-02-27 05:22:28 Norrbotten, Sweden
951282 951282 2021-02-26 Sweden Orebro     17895 289 0 17606 59.535 15.0066 2021-02-27 05:22:28 Orebro, Sweden
951283 951283 2021-02-26 Sweden Ostergotland     22855 552 0 22303 58.3454 15.5198 2021-02-27 05:22:28 Ostergotland, Sweden
951284 951284 2021-02-26 Sweden Skane     110096 1547 0 108549 55.9903 13.5958 2021-02-27 05:22:28 Skane, Sweden
951285 951285 2021-02-26 Sweden Sormland     13207 401 0 12806 59.0336 16.7519 2021-02-27 05:22:28 Sormland, Sweden
951286 951286 2021-02-26 Sweden Stockholm     155151 3866 0 151285 59.6025 18.1384 2021-02-27 05:22:28 Stockholm, Sweden
951287 951287 2021-02-26 Sweden Uppsala     24154 479 0 23675 60.0092 17.2715 2021-02-27 05:22:28 Uppsala, Sweden
951288 951288 2021-02-26 Sweden Varmland     9115 167 0 8948 59.7294 13.2354 2021-02-27 05:22:28 Varmland, Sweden
951289 951289 2021-02-26 Sweden Vasterbotten     14376 136 0 14240 65.3337 16.5162 2021-02-27 05:22:28 Vasterbotten, Sweden
951290 951290 2021-02-26 Sweden Vasternorrland     14841 404 0 14437 63.4276 17.7292 2021-02-27 05:22:28 Vasternorrland, Sweden
951291 951291 2021-02-26 Sweden Vastmanland     18167 326 0 17841 59.6714 16.2159 2021-02-27 05:22:28 Vastmanland, Sweden
951292 951292 2021-02-26 Sweden Vastra Gotaland     116177 2086 0 114091 58.2528 13.0596 2021-02-27 05:22:28 Vastra Gotaland, Sweden
1280228 1280228 2021-02-25 Sweden Blekinge     7916 114 0 7802 56.2784 15.018 2021-02-26 05:22:40 Blekinge, Sweden
1280229 1280229 2021-02-25 Sweden Dalarna     14653 304 0 14349 61.0917 14.6664 2021-02-26 05:22:40 Dalarna, Sweden
1280230 1280230 2021-02-25 Sweden Gavleborg     21053 492 0 20561 61.3012 16.1534 2021-02-26 05:22:40 Gavleborg, Sweden
1280231 1280231 2021-02-25 Sweden Gotland     2681 45 0 2636 57.4684 18.4867 2021-02-26 05:22:40 Gotland, Sweden
1280232 1280232 2021-02-25 Sweden Halland     23398 269 0 23129 56.8967 12.8034 2021-02-26 05:22:40 Halland, Sweden
1280233 1280233 2021-02-25 Sweden Jamtland Harjedalen     6762 113 0 6649 63.1712 14.9592 2021-02-26 05:22:40 Jamtland Harjedalen, Sweden
1280234 1280234 2021-02-25 Sweden Jonkoping     26259 506 0 25753 57.3708 14.3439 2021-02-26 05:22:40 Jonkoping, Sweden
1280235 1280235 2021-02-25 Sweden Kalmar     11229 214 0 11015 57.235 16.1849 2021-02-26 05:22:40 Kalmar, Sweden
1280236 1280236 2021-02-25 Sweden Kronoberg     13830 291 0 13539 56.7183 14.4115 2021-02-26 05:22:40 Kronoberg, Sweden
1280237 1280237 2021-02-25 Sweden Norrbotten     12261 217 0 12044 66.8309 20.3992 2021-02-26 05:22:40 Norrbotten, Sweden
1280238 1280238 2021-02-25 Sweden Orebro     17839 289 0 17550 59.535 15.0066 2021-02-26 05:22:40 Orebro, Sweden
1280239 1280239 2021-02-25 Sweden Ostergotland     22715 551 0 22164 58.3454 15.5198 2021-02-26 05:22:40 Ostergotland, Sweden
1280240 1280240 2021-02-25 Sweden Skane     109616 1547 0 108069 55.9903 13.5958 2021-02-26 05:22:40 Skane, Sweden
1280241 1280241 2021-02-25 Sweden Sormland     13086 397 0 12689 59.0336 16.7519 2021-02-26 05:22:40 Sormland, Sweden
1280242 1280242 2021-02-25 Sweden Stockholm     154218 3865 0 150353 59.6025 18.1384 2021-02-26 05:22:40 Stockholm, Sweden
1280243 1280243 2021-02-25 Sweden Uppsala     24021 479 0 23542 60.0092 17.2715 2021-02-26 05:22:40 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]);