johns_hopkins_csse_daily_reports

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

756 rows where country_or_region = "Sweden" sorted by day descending

View and edit SQL

country_or_region

  • Sweden · 756
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
311684 2020-07-04 Sweden Blekinge     452 14 0 438 56.2784 15.018 2020-07-05 04:33:46 Blekinge, Sweden
311740 2020-07-04 Sweden Dalarna     1739 157 0 1582 61.0917 14.6664 2020-07-05 04:33:46 Dalarna, Sweden
311764 2020-07-04 Sweden Gavleborg     2559 133 0 2426 61.3012 16.1534 2020-07-05 04:33:46 Gavleborg, Sweden
311770 2020-07-04 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-05 04:33:46 Gotland, Sweden
311786 2020-07-04 Sweden Halland     1574 72 0 1502 56.8967 12.8034 2020-07-05 04:33:46 Halland, Sweden
311816 2020-07-04 Sweden Jamtland Harjedalen     1059 54 0 1005 63.1712 14.9592 2020-07-05 04:33:46 Jamtland Harjedalen, Sweden
311822 2020-07-04 Sweden Jonkoping     4201 169 0 4032 57.3708 14.3439 2020-07-05 04:33:46 Jonkoping, Sweden
311828 2020-07-04 Sweden Kalmar     691 57 0 634 57.235 16.1849 2020-07-05 04:33:46 Kalmar, Sweden
311854 2020-07-04 Sweden Kronoberg     1072 97 0 975 56.7183 14.4115 2020-07-05 04:33:46 Kronoberg, Sweden
311933 2020-07-04 Sweden Norrbotten     1358 67 0 1291 66.8309 20.3992 2020-07-05 04:33:46 Norrbotten, Sweden
311954 2020-07-04 Sweden Orebro     2385 164 0 2221 59.535 15.0066 2020-07-05 04:33:46 Orebro, Sweden
311958 2020-07-04 Sweden Ostergotland     3306 224 0 3082 58.3454 15.5198 2020-07-05 04:33:46 Ostergotland, Sweden
312041 2020-07-04 Sweden Skane     3121 250 0 2871 55.9903 13.5958 2020-07-05 04:33:46 Skane, Sweden
312044 2020-07-04 Sweden Sormland     2235 244 0 1991 59.0336 16.7519 2020-07-05 04:33:46 Sormland, Sweden
312048 2020-07-04 Sweden Stockholm     20933 2337 0 18596 59.6025 18.1384 2020-07-05 04:33:46 Stockholm, Sweden
312093 2020-07-04 Sweden Uppsala     3354 226 0 3128 60.0092 17.2715 2020-07-05 04:33:46 Uppsala, Sweden
312099 2020-07-04 Sweden Varmland     975 69 0 906 59.7294 13.2354 2020-07-05 04:33:46 Varmland, Sweden
312100 2020-07-04 Sweden Vasterbotten     727 31 0 696 65.3337 16.5162 2020-07-05 04:33:46 Vasterbotten, Sweden
312101 2020-07-04 Sweden Vasternorrland     1428 117 0 1311 63.4276 17.7292 2020-07-05 04:33:46 Vasternorrland, Sweden
312102 2020-07-04 Sweden Vastmanland     2329 170 0 2159 59.6714 16.2159 2020-07-05 04:33:46 Vastmanland, Sweden
312103 2020-07-04 Sweden Vastra Gotaland     15759 762 0 14997 58.2528 13.0596 2020-07-05 04:33:46 Vastra Gotaland, Sweden
252118 2020-07-03 Sweden Blekinge     452 14 0 438 56.2784 15.018 2020-07-04 04:33:51 Blekinge, Sweden
252174 2020-07-03 Sweden Dalarna     1739 157 0 1582 61.0917 14.6664 2020-07-04 04:33:51 Dalarna, Sweden
252198 2020-07-03 Sweden Gavleborg     2559 133 0 2426 61.3012 16.1534 2020-07-04 04:33:51 Gavleborg, Sweden
252204 2020-07-03 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-04 04:33:51 Gotland, Sweden
252220 2020-07-03 Sweden Halland     1574 72 0 1502 56.8967 12.8034 2020-07-04 04:33:51 Halland, Sweden
252250 2020-07-03 Sweden Jamtland Harjedalen     1059 54 0 1005 63.1712 14.9592 2020-07-04 04:33:51 Jamtland Harjedalen, Sweden
252256 2020-07-03 Sweden Jonkoping     4201 169 0 4032 57.3708 14.3439 2020-07-04 04:33:51 Jonkoping, Sweden
252262 2020-07-03 Sweden Kalmar     691 57 0 634 57.235 16.1849 2020-07-04 04:33:51 Kalmar, Sweden
252288 2020-07-03 Sweden Kronoberg     1072 97 0 975 56.7183 14.4115 2020-07-04 04:33:51 Kronoberg, Sweden
252367 2020-07-03 Sweden Norrbotten     1358 67 0 1291 66.8309 20.3992 2020-07-04 04:33:51 Norrbotten, Sweden
252388 2020-07-03 Sweden Orebro     2385 164 0 2221 59.535 15.0066 2020-07-04 04:33:51 Orebro, Sweden
252392 2020-07-03 Sweden Ostergotland     3306 224 0 3082 58.3454 15.5198 2020-07-04 04:33:51 Ostergotland, Sweden
252475 2020-07-03 Sweden Skane     3121 250 0 2871 55.9903 13.5958 2020-07-04 04:33:51 Skane, Sweden
252478 2020-07-03 Sweden Sormland     2235 244 0 1991 59.0336 16.7519 2020-07-04 04:33:51 Sormland, Sweden
252482 2020-07-03 Sweden Stockholm     20933 2337 0 18596 59.6025 18.1384 2020-07-04 04:33:51 Stockholm, Sweden
252527 2020-07-03 Sweden Uppsala     3354 226 0 3128 60.0092 17.2715 2020-07-04 04:33:51 Uppsala, Sweden
252533 2020-07-03 Sweden Varmland     975 69 0 906 59.7294 13.2354 2020-07-04 04:33:51 Varmland, Sweden
252534 2020-07-03 Sweden Vasterbotten     727 31 0 696 65.3337 16.5162 2020-07-04 04:33:51 Vasterbotten, Sweden
252535 2020-07-03 Sweden Vasternorrland     1428 117 0 1311 63.4276 17.7292 2020-07-04 04:33:51 Vasternorrland, Sweden
252536 2020-07-03 Sweden Vastmanland     2329 170 0 2159 59.6714 16.2159 2020-07-04 04:33:51 Vastmanland, Sweden
252537 2020-07-03 Sweden Vastra Gotaland     15759 762 0 14997 58.2528 13.0596 2020-07-04 04:33:51 Vastra Gotaland, Sweden
203499 2020-07-02 Sweden Blekinge     449 14 0 435 56.2784 15.017999999999999 2020-07-03 04:33:54 Blekinge, Sweden
203555 2020-07-02 Sweden Dalarna     1681 157 0 1524 61.0917 14.6664 2020-07-03 04:33:54 Dalarna, Sweden
203579 2020-07-02 Sweden Gavleborg     2531 133 0 2398 61.3012 16.1534 2020-07-03 04:33:54 Gavleborg, Sweden
203585 2020-07-02 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-03 04:33:54 Gotland, Sweden
203601 2020-07-02 Sweden Halland     1538 72 0 1466 56.8967 12.8034 2020-07-03 04:33:54 Halland, Sweden
203631 2020-07-02 Sweden Jamtland Harjedalen     1039 54 0 985 63.1712 14.9592 2020-07-03 04:33:54 Jamtland Harjedalen, Sweden
203637 2020-07-02 Sweden Jonkoping     4102 169 0 3933 57.3708 14.3439 2020-07-03 04:33:54 Jonkoping, Sweden
203643 2020-07-02 Sweden Kalmar     674 57 0 617 57.235 16.1849 2020-07-03 04:33:54 Kalmar, Sweden
203669 2020-07-02 Sweden Kronoberg     1068 96 0 972 56.7183 14.4115 2020-07-03 04:33:54 Kronoberg, Sweden
203748 2020-07-02 Sweden Norrbotten     1344 67 0 1277 66.8309 20.3992 2020-07-03 04:33:54 Norrbotten, Sweden
203769 2020-07-02 Sweden Orebro     2363 164 0 2199 59.535 15.0066 2020-07-03 04:33:54 Orebro, Sweden
203773 2020-07-02 Sweden Ostergotland     3278 224 0 3054 58.3454 15.5198 2020-07-03 04:33:54 Ostergotland, Sweden
203856 2020-07-02 Sweden Skane     3095 246 0 2849 55.9903 13.5958 2020-07-03 04:33:54 Skane, Sweden
203859 2020-07-02 Sweden Sormland     2214 244 0 1970 59.0336 16.7519 2020-07-03 04:33:54 Sormland, Sweden
203863 2020-07-02 Sweden Stockholm     20759 2337 0 18422 59.6025 18.1384 2020-07-03 04:33:54 Stockholm, Sweden
203909 2020-07-02 Sweden Uppsala     3330 226 0 3104 60.0092 17.2715 2020-07-03 04:33:54 Uppsala, Sweden
203915 2020-07-02 Sweden Varmland     961 69 0 892 59.7294 13.2354 2020-07-03 04:33:54 Varmland, Sweden
203916 2020-07-02 Sweden Vasterbotten     722 31 0 691 65.3337 16.5162 2020-07-03 04:33:54 Vasterbotten, Sweden
203917 2020-07-02 Sweden Vasternorrland     1403 117 0 1286 63.4276 17.7292 2020-07-03 04:33:54 Vasternorrland, Sweden
203918 2020-07-02 Sweden Vastmanland     2298 166 0 2132 59.6714 16.2159 2020-07-03 04:33:54 Vastmanland, Sweden
203919 2020-07-02 Sweden Vastra Gotaland     15628 762 0 14866 58.2528 13.0596 2020-07-03 04:33:54 Vastra Gotaland, Sweden
159740 2020-07-01 Sweden Blekinge     447 13 0 434 56.2784 15.018 2020-07-02 04:33:46 Blekinge, Sweden
159796 2020-07-01 Sweden Dalarna     1653 157 0 1496 61.0917 14.6664 2020-07-02 04:33:46 Dalarna, Sweden
159820 2020-07-01 Sweden Gavleborg     2467 131 0 2336 61.3012 16.1534 2020-07-02 04:33:46 Gavleborg, Sweden
159826 2020-07-01 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-02 04:33:46 Gotland, Sweden
159842 2020-07-01 Sweden Halland     1536 72 0 1464 56.8967 12.8034 2020-07-02 04:33:46 Halland, Sweden
159872 2020-07-01 Sweden Jamtland Harjedalen     1038 54 0 984 63.1712 14.9592 2020-07-02 04:33:46 Jamtland Harjedalen, Sweden
159878 2020-07-01 Sweden Jonkoping     4035 169 0 3866 57.3708 14.3439 2020-07-02 04:33:46 Jonkoping, Sweden
159884 2020-07-01 Sweden Kalmar     645 55 0 590 57.235 16.1849 2020-07-02 04:33:46 Kalmar, Sweden
159910 2020-07-01 Sweden Kronoberg     1066 96 0 970 56.7183 14.4115 2020-07-02 04:33:46 Kronoberg, Sweden
159989 2020-07-01 Sweden Norrbotten     1326 67 0 1259 66.8309 20.3992 2020-07-02 04:33:46 Norrbotten, Sweden
160010 2020-07-01 Sweden Orebro     2333 163 0 2170 59.535 15.0066 2020-07-02 04:33:46 Orebro, Sweden
160014 2020-07-01 Sweden Ostergotland     3217 224 0 2993 58.3454 15.5198 2020-07-02 04:33:46 Ostergotland, Sweden
160097 2020-07-01 Sweden Skane     3072 246 0 2826 55.9903 13.5958 2020-07-02 04:33:46 Skane, Sweden
160100 2020-07-01 Sweden Sormland     2123 244 0 1879 59.0336 16.7519 2020-07-02 04:33:46 Sormland, Sweden
160104 2020-07-01 Sweden Stockholm     20547 2303 0 18244 59.6025 18.1384 2020-07-02 04:33:46 Stockholm, Sweden
160150 2020-07-01 Sweden Uppsala     3299 226 0 3073 60.0092 17.2715 2020-07-02 04:33:46 Uppsala, Sweden
160156 2020-07-01 Sweden Varmland     954 69 0 885 59.7294 13.2354 2020-07-02 04:33:46 Varmland, Sweden
160157 2020-07-01 Sweden Vasterbotten     708 31 0 677 65.3337 16.5162 2020-07-02 04:33:46 Vasterbotten, Sweden
160158 2020-07-01 Sweden Vasternorrland     1382 117 0 1265 63.4276 17.7292 2020-07-02 04:33:46 Vasternorrland, Sweden
160159 2020-07-01 Sweden Vastmanland     2274 166 0 2108 59.6714 16.2159 2020-07-02 04:33:46 Vastmanland, Sweden
160160 2020-07-01 Sweden Vastra Gotaland     15408 761 0 14647 58.2528 13.0596 2020-07-02 04:33:46 Vastra Gotaland, Sweden
325735 2020-06-30 Sweden Blekinge     444 12 0 432 56.2784 15.018 2020-07-01 04:33:52 Blekinge, Sweden
325791 2020-06-30 Sweden Dalarna     1626 157 0 1469 61.0917 14.6664 2020-07-01 04:33:52 Dalarna, Sweden
325815 2020-06-30 Sweden Gavleborg     2264 131 0 2133 61.3012 16.1534 2020-07-01 04:33:52 Gavleborg, Sweden
325821 2020-06-30 Sweden Gotland     160 7 0 153 57.4684 18.4867 2020-07-01 04:33:52 Gotland, Sweden
325837 2020-06-30 Sweden Halland     1483 71 0 1412 56.8967 12.8034 2020-07-01 04:33:52 Halland, Sweden
325867 2020-06-30 Sweden Jamtland Harjedalen     1033 48 0 985 63.1712 14.9592 2020-07-01 04:33:52 Jamtland Harjedalen, Sweden
325873 2020-06-30 Sweden Jonkoping     3977 169 0 3808 57.3708 14.3439 2020-07-01 04:33:52 Jonkoping, Sweden
325879 2020-06-30 Sweden Kalmar     626 54 0 572 57.235 16.1849 2020-07-01 04:33:52 Kalmar, Sweden
325905 2020-06-30 Sweden Kronoberg     1063 94 0 969 56.7183 14.4115 2020-07-01 04:33:52 Kronoberg, Sweden
325984 2020-06-30 Sweden Norrbotten     1284 66 0 1218 66.8309 20.3992 2020-07-01 04:33:52 Norrbotten, Sweden
326005 2020-06-30 Sweden Orebro     2319 162 0 2157 59.535 15.0066 2020-07-01 04:33:52 Orebro, Sweden
326009 2020-06-30 Sweden Ostergotland     3212 224 0 2988 58.3454 15.5198 2020-07-01 04:33:52 Ostergotland, Sweden
326092 2020-06-30 Sweden Skane     3051 245 0 2806 55.9903 13.5958 2020-07-01 04:33:52 Skane, Sweden
326095 2020-06-30 Sweden Sormland     2080 243 0 1837 59.0336 16.7519 2020-07-01 04:33:52 Sormland, Sweden
326099 2020-06-30 Sweden Stockholm     20171 2302 0 17869 59.6025 18.1384 2020-07-01 04:33:52 Stockholm, Sweden
326145 2020-06-30 Sweden Uppsala     3236 226 0 3010 60.0092 17.2715 2020-07-01 04:33:52 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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2355.018ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette