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

4,998 rows where country_or_region = "Sweden" sorted by day descending

✎ View and edit SQL

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

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

country_or_region

  • Sweden · 4,998 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
89987 89987 2021-01-22 Sweden Blekinge     7014 81 0 6933 56.2784 15.018 2021-01-23 05:22:03 Blekinge, Sweden
89988 89988 2021-01-22 Sweden Dalarna     12929 290 0 12639 61.0917 14.6664 2021-01-23 05:22:03 Dalarna, Sweden
89989 89989 2021-01-22 Sweden Gavleborg     17794 450 0 17344 61.3012 16.1534 2021-01-23 05:22:03 Gavleborg, Sweden
89990 89990 2021-01-22 Sweden Gotland     2561 41 0 2520 57.4684 18.4867 2021-01-23 05:22:03 Gotland, Sweden
89991 89991 2021-01-22 Sweden Halland     17694 195 0 17499 56.8967 12.8034 2021-01-23 05:22:03 Halland, Sweden
89992 89992 2021-01-22 Sweden Jamtland Harjedalen     5568 99 0 5469 63.1712 14.9592 2021-01-23 05:22:03 Jamtland Harjedalen, Sweden
89993 89993 2021-01-22 Sweden Jonkoping     21218 426 0 20792 57.3708 14.3439 2021-01-23 05:22:03 Jonkoping, Sweden
89994 89994 2021-01-22 Sweden Kalmar     9256 162 0 9094 57.235 16.1849 2021-01-23 05:22:03 Kalmar, Sweden
89995 89995 2021-01-22 Sweden Kronoberg     11386 263 0 11123 56.7183 14.4115 2021-01-23 05:22:03 Kronoberg, Sweden
89996 89996 2021-01-22 Sweden Norrbotten     9567 171 0 9396 66.8309 20.3992 2021-01-23 05:22:03 Norrbotten, Sweden
89997 89997 2021-01-22 Sweden Orebro     15694 249 0 15445 59.535 15.0066 2021-01-23 05:22:03 Orebro, Sweden
89998 89998 2021-01-22 Sweden Ostergotland     18545 444 0 18101 58.3454 15.5198 2021-01-23 05:22:03 Ostergotland, Sweden
89999 89999 2021-01-22 Sweden Skane     92857 1144 0 91713 55.9903 13.5958 2021-01-23 05:22:03 Skane, Sweden
90000 90000 2021-01-22 Sweden Sormland     11212 367 0 10845 59.0336 16.7519 2021-01-23 05:22:03 Sormland, Sweden
90001 90001 2021-01-22 Sweden Stockholm     133990 3591 0 130399 59.6025 18.1384 2021-01-23 05:22:03 Stockholm, Sweden
90002 90002 2021-01-22 Sweden Uppsala     20885 436 0 20449 60.0092 17.2715 2021-01-23 05:22:03 Uppsala, Sweden
90003 90003 2021-01-22 Sweden Varmland     7359 149 0 7210 59.7294 13.2354 2021-01-23 05:22:03 Varmland, Sweden
90004 90004 2021-01-22 Sweden Vasterbotten     9923 114 0 9809 65.3337 16.5162 2021-01-23 05:22:03 Vasterbotten, Sweden
90005 90005 2021-01-22 Sweden Vasternorrland     12528 318 0 12210 63.4276 17.7292 2021-01-23 05:22:03 Vasternorrland, Sweden
90006 90006 2021-01-22 Sweden Vastmanland     16289 294 0 15995 59.6714 16.2159 2021-01-23 05:22:03 Vastmanland, Sweden
90007 90007 2021-01-22 Sweden Vastra Gotaland     92897 1721 0 91176 58.2528 13.0596 2021-01-23 05:22:03 Vastra Gotaland, Sweden
302893 302893 2021-01-21 Sweden Blekinge     6956 81 0 6875 56.2784 15.018 2021-01-22 05:22:10 Blekinge, Sweden
302894 302894 2021-01-21 Sweden Dalarna     12836 285 0 12551 61.0917 14.6664 2021-01-22 05:22:10 Dalarna, Sweden
302895 302895 2021-01-21 Sweden Gavleborg     17721 446 0 17275 61.3012 16.1534 2021-01-22 05:22:10 Gavleborg, Sweden
302896 302896 2021-01-21 Sweden Gotland     2549 40 0 2509 57.4684 18.4867 2021-01-22 05:22:10 Gotland, Sweden
302897 302897 2021-01-21 Sweden Halland     17477 190 0 17287 56.8967 12.8034 2021-01-22 05:22:10 Halland, Sweden
302898 302898 2021-01-21 Sweden Jamtland Harjedalen     5535 99 0 5436 63.1712 14.9592 2021-01-22 05:22:10 Jamtland Harjedalen, Sweden
302899 302899 2021-01-21 Sweden Jonkoping     21040 420 0 20620 57.3708 14.3439 2021-01-22 05:22:10 Jonkoping, Sweden
302900 302900 2021-01-21 Sweden Kalmar     9143 162 0 8981 57.235 16.1849 2021-01-22 05:22:10 Kalmar, Sweden
302901 302901 2021-01-21 Sweden Kronoberg     11269 260 0 11009 56.7183 14.4115 2021-01-22 05:22:10 Kronoberg, Sweden
302902 302902 2021-01-21 Sweden Norrbotten     9465 162 0 9303 66.8309 20.3992 2021-01-22 05:22:10 Norrbotten, Sweden
302903 302903 2021-01-21 Sweden Orebro     15627 246 0 15381 59.535 15.0066 2021-01-22 05:22:10 Orebro, Sweden
302904 302904 2021-01-21 Sweden Ostergotland     18394 444 0 17950 58.3454 15.5198 2021-01-22 05:22:10 Ostergotland, Sweden
302905 302905 2021-01-21 Sweden Skane     91805 1146 0 90659 55.9903 13.5958 2021-01-22 05:22:10 Skane, Sweden
302906 302906 2021-01-21 Sweden Sormland     11141 367 0 10774 59.0336 16.7519 2021-01-22 05:22:10 Sormland, Sweden
302907 302907 2021-01-21 Sweden Stockholm     133406 3591 0 129815 59.6025 18.1384 2021-01-22 05:22:10 Stockholm, Sweden
302908 302908 2021-01-21 Sweden Uppsala     20693 425 0 20268 60.0092 17.2715 2021-01-22 05:22:10 Uppsala, Sweden
302909 302909 2021-01-21 Sweden Varmland     7314 148 0 7166 59.7294 13.2354 2021-01-22 05:22:10 Varmland, Sweden
302910 302910 2021-01-21 Sweden Vasterbotten     9857 113 0 9744 65.3337 16.5162 2021-01-22 05:22:10 Vasterbotten, Sweden
302911 302911 2021-01-21 Sweden Vasternorrland     12434 310 0 12124 63.4276 17.7292 2021-01-22 05:22:10 Vasternorrland, Sweden
302912 302912 2021-01-21 Sweden Vastmanland     16197 294 0 15903 59.6714 16.2159 2021-01-22 05:22:10 Vastmanland, Sweden
302913 302913 2021-01-21 Sweden Vastra Gotaland     92093 1692 0 90401 58.2528 13.0596 2021-01-22 05:22:10 Vastra Gotaland, Sweden
893944 893944 2021-01-20 Sweden Blekinge     6895 78 0 6817 56.2784 15.018 2021-01-21 05:22:01 Blekinge, Sweden
893945 893945 2021-01-20 Sweden Dalarna     12746 285 0 12461 61.0917 14.6664 2021-01-21 05:22:01 Dalarna, Sweden
893946 893946 2021-01-20 Sweden Gavleborg     17576 446 0 17130 61.3012 16.1534 2021-01-21 05:22:01 Gavleborg, Sweden
893947 893947 2021-01-20 Sweden Gotland     2539 39 0 2500 57.4684 18.4867 2021-01-21 05:22:01 Gotland, Sweden
893948 893948 2021-01-20 Sweden Halland     17256 190 0 17066 56.8967 12.8034 2021-01-21 05:22:01 Halland, Sweden
893949 893949 2021-01-20 Sweden Jamtland Harjedalen     5484 99 0 5385 63.1712 14.9592 2021-01-21 05:22:01 Jamtland Harjedalen, Sweden
893950 893950 2021-01-20 Sweden Jonkoping     20847 419 0 20428 57.3708 14.3439 2021-01-21 05:22:01 Jonkoping, Sweden
893951 893951 2021-01-20 Sweden Kalmar     8971 162 0 8809 57.235 16.1849 2021-01-21 05:22:01 Kalmar, Sweden
893952 893952 2021-01-20 Sweden Kronoberg     11192 257 0 10935 56.7183 14.4115 2021-01-21 05:22:01 Kronoberg, Sweden
893953 893953 2021-01-20 Sweden Norrbotten     9325 159 0 9166 66.8309 20.3992 2021-01-21 05:22:01 Norrbotten, Sweden
893954 893954 2021-01-20 Sweden Orebro     15500 245 0 15255 59.535 15.0066 2021-01-21 05:22:01 Orebro, Sweden
893955 893955 2021-01-20 Sweden Ostergotland     18190 444 0 17746 58.3454 15.5198 2021-01-21 05:22:01 Ostergotland, Sweden
893956 893956 2021-01-20 Sweden Skane     90854 1137 0 89717 55.9903 13.5958 2021-01-21 05:22:01 Skane, Sweden
893957 893957 2021-01-20 Sweden Sormland     11028 362 0 10666 59.0336 16.7519 2021-01-21 05:22:01 Sormland, Sweden
893958 893958 2021-01-20 Sweden Stockholm     132709 3569 0 129140 59.6025 18.1384 2021-01-21 05:22:01 Stockholm, Sweden
893959 893959 2021-01-20 Sweden Uppsala     20574 425 0 20149 60.0092 17.2715 2021-01-21 05:22:01 Uppsala, Sweden
893960 893960 2021-01-20 Sweden Varmland     7274 145 0 7129 59.7294 13.2354 2021-01-21 05:22:01 Varmland, Sweden
893961 893961 2021-01-20 Sweden Vasterbotten     9791 111 0 9680 65.3337 16.5162 2021-01-21 05:22:01 Vasterbotten, Sweden
893962 893962 2021-01-20 Sweden Vasternorrland     12321 308 0 12013 63.4276 17.7292 2021-01-21 05:22:01 Vasternorrland, Sweden
893963 893963 2021-01-20 Sweden Vastmanland     16076 287 0 15789 59.6714 16.2159 2021-01-21 05:22:01 Vastmanland, Sweden
893964 893964 2021-01-20 Sweden Vastra Gotaland     90819 1630 0 89189 58.2528 13.0596 2021-01-21 05:22:01 Vastra Gotaland, Sweden
322511 322511 2021-01-19 Sweden Blekinge     6742 76 0 6666 56.2784 15.018 2021-01-20 05:21:54 Blekinge, Sweden
322512 322512 2021-01-19 Sweden Dalarna     12591 278 0 12313 61.0917 14.6664 2021-01-20 05:21:54 Dalarna, Sweden
322513 322513 2021-01-19 Sweden Gavleborg     17476 441 0 17035 61.3012 16.1534 2021-01-20 05:21:54 Gavleborg, Sweden
322514 322514 2021-01-19 Sweden Gotland     2526 39 0 2487 57.4684 18.4867 2021-01-20 05:21:54 Gotland, Sweden
322515 322515 2021-01-19 Sweden Halland     16939 172 0 16767 56.8967 12.8034 2021-01-20 05:21:54 Halland, Sweden
322516 322516 2021-01-19 Sweden Jamtland Harjedalen     5391 99 0 5292 63.1712 14.9592 2021-01-20 05:21:54 Jamtland Harjedalen, Sweden
322517 322517 2021-01-19 Sweden Jonkoping     20566 408 0 20158 57.3708 14.3439 2021-01-20 05:21:54 Jonkoping, Sweden
322518 322518 2021-01-19 Sweden Kalmar     8884 157 0 8727 57.235 16.1849 2021-01-20 05:21:54 Kalmar, Sweden
322519 322519 2021-01-19 Sweden Kronoberg     11018 253 0 10765 56.7183 14.4115 2021-01-20 05:21:54 Kronoberg, Sweden
322520 322520 2021-01-19 Sweden Norrbotten     9268 155 0 9113 66.8309 20.3992 2021-01-20 05:21:54 Norrbotten, Sweden
322521 322521 2021-01-19 Sweden Orebro     15412 240 0 15172 59.535 15.0066 2021-01-20 05:21:54 Orebro, Sweden
322522 322522 2021-01-19 Sweden Ostergotland     18007 430 0 17577 58.3454 15.5198 2021-01-20 05:21:54 Ostergotland, Sweden
322523 322523 2021-01-19 Sweden Skane     89852 1070 0 88782 55.9903 13.5958 2021-01-20 05:21:54 Skane, Sweden
322524 322524 2021-01-19 Sweden Sormland     10918 361 0 10557 59.0336 16.7519 2021-01-20 05:21:54 Sormland, Sweden
322525 322525 2021-01-19 Sweden Stockholm     131739 3537 0 128202 59.6025 18.1384 2021-01-20 05:21:54 Stockholm, Sweden
322526 322526 2021-01-19 Sweden Uppsala     20504 424 0 20080 60.0092 17.2715 2021-01-20 05:21:54 Uppsala, Sweden
322527 322527 2021-01-19 Sweden Varmland     7208 143 0 7065 59.7294 13.2354 2021-01-20 05:21:54 Varmland, Sweden
322528 322528 2021-01-19 Sweden Vasterbotten     9680 110 0 9570 65.3337 16.5162 2021-01-20 05:21:54 Vasterbotten, Sweden
322529 322529 2021-01-19 Sweden Vasternorrland     12171 300 0 11871 63.4276 17.7292 2021-01-20 05:21:54 Vasternorrland, Sweden
322530 322530 2021-01-19 Sweden Vastmanland     15935 287 0 15648 59.6714 16.2159 2021-01-20 05:21:54 Vastmanland, Sweden
322531 322531 2021-01-19 Sweden Vastra Gotaland     90438 1611 0 88827 58.2528 13.0596 2021-01-20 05:21:54 Vastra Gotaland, Sweden
574497 574497 2021-01-18 Sweden Blekinge     6577 66 0 6511 56.2784 15.018 2021-01-19 05:22:15 Blekinge, Sweden
574498 574498 2021-01-18 Sweden Dalarna     12357 278 0 12079 61.0917 14.6664 2021-01-19 05:22:15 Dalarna, Sweden
574499 574499 2021-01-18 Sweden Gavleborg     17268 436 0 16832 61.3012 16.1534 2021-01-19 05:22:15 Gavleborg, Sweden
574500 574500 2021-01-18 Sweden Gotland     2503 37 0 2466 57.4684 18.4867 2021-01-19 05:22:15 Gotland, Sweden
574501 574501 2021-01-18 Sweden Halland     16477 172 0 16305 56.8967 12.8034 2021-01-19 05:22:15 Halland, Sweden
574502 574502 2021-01-18 Sweden Jamtland Harjedalen     5327 99 0 5228 63.1712 14.9592 2021-01-19 05:22:15 Jamtland Harjedalen, Sweden
574503 574503 2021-01-18 Sweden Jonkoping     20194 398 0 19796 57.3708 14.3439 2021-01-19 05:22:15 Jonkoping, Sweden
574504 574504 2021-01-18 Sweden Kalmar     8651 154 0 8497 57.235 16.1849 2021-01-19 05:22:15 Kalmar, Sweden
574505 574505 2021-01-18 Sweden Kronoberg     10784 237 0 10547 56.7183 14.4115 2021-01-19 05:22:15 Kronoberg, Sweden
574506 574506 2021-01-18 Sweden Norrbotten     9010 155 0 8855 66.8309 20.3992 2021-01-19 05:22:15 Norrbotten, Sweden
574507 574507 2021-01-18 Sweden Orebro     15142 239 0 14903 59.535 15.0066 2021-01-19 05:22:15 Orebro, Sweden
574508 574508 2021-01-18 Sweden Ostergotland     17354 430 0 16924 58.3454 15.5198 2021-01-19 05:22:15 Ostergotland, Sweden
574509 574509 2021-01-18 Sweden Skane     87617 986 0 86631 55.9903 13.5958 2021-01-19 05:22:15 Skane, Sweden
574510 574510 2021-01-18 Sweden Sormland     10771 353 0 10418 59.0336 16.7519 2021-01-19 05:22:15 Sormland, Sweden
574511 574511 2021-01-18 Sweden Stockholm     130531 3472 0 127059 59.6025 18.1384 2021-01-19 05:22:15 Stockholm, Sweden
574512 574512 2021-01-18 Sweden Uppsala     20218 417 0 19801 60.0092 17.2715 2021-01-19 05:22:15 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
);
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]);