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

380 rows where country_or_region = "Sweden" and province_or_state = "Skane" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Skane · 380

country_or_region

  • Sweden · 380
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168782 2021-06-19 Sweden Skane     155639 1749 0 153890 55.9903 13.5958 2021-06-20 04:21:48 Skane, Sweden
686307 2021-06-18 Sweden Skane     155639 1749 0 153890 55.9903 13.5958 2021-06-19 04:22:33 Skane, Sweden
958364 2021-06-17 Sweden Skane     155639 1749 0 153890 55.9903 13.5958 2021-06-18 04:22:16 Skane, Sweden
1281729 2021-06-16 Sweden Skane     155639 1749 0 153890 55.9903 13.5958 2021-06-17 04:22:36 Skane, Sweden
682319 2021-06-15 Sweden Skane     155639 1749 0 153890 55.9903 13.5958 2021-06-16 04:22:32 Skane, Sweden
372873 2021-06-14 Sweden Skane     155456 1749 0 153707 55.9903 13.5958 2021-06-15 04:22:22 Skane, Sweden
1223689 2021-06-13 Sweden Skane     155456 1749 0 153707 55.9903 13.5958 2021-06-14 04:22:46 Skane, Sweden
80970 2021-06-12 Sweden Skane     155456 1749 0 153707 55.9903 13.5958 2021-06-13 04:22:44 Skane, Sweden
970273 2021-06-11 Sweden Skane     155456 1749 0 153707 55.9903 13.5958 2021-06-12 04:22:22 Skane, Sweden
1438846 2021-06-10 Sweden Skane     155382 1749 0 153633 55.9903 13.5958 2021-06-11 04:23:20 Skane, Sweden
1157345 2021-06-09 Sweden Skane     155276 1749 0 153527 55.9903 13.5958 2021-06-10 04:23:17 Skane, Sweden
1231661 2021-06-08 Sweden Skane     155145 1749 0 153396 55.9903 13.5958 2021-06-09 04:23:31 Skane, Sweden
360657 2021-06-07 Sweden Skane     154791 1743 0 153048 55.9903 13.5958 2021-06-08 04:22:35 Skane, Sweden
1076285 2021-06-06 Sweden Skane     154791 1743 0 153048 55.9903 13.5958 2021-06-07 04:22:51 Skane, Sweden
1613677 2021-06-05 Sweden Skane     154791 1743 0 153048 55.9903 13.5958 2021-06-06 04:24:03 Skane, Sweden
1125963 2021-06-04 Sweden Skane     154791 1743 0 153048 55.9903 13.5958 2021-06-05 04:23:03 Skane, Sweden
318419 2021-06-03 Sweden Skane     154643 1743 0 152900 55.9903 13.5958 2021-06-04 04:23:37 Skane, Sweden
1133932 2021-06-02 Sweden Skane     153662 1730 0 151932 55.9903 13.5958 2021-06-03 04:23:32 Skane, Sweden
292109 2021-06-01 Sweden Skane     153662 1730 0 151932 55.9903 13.5958 2021-06-02 04:24:34 Skane, Sweden
1652060 2021-05-31 Sweden Skane     153662 1730 0 151932 55.9903 13.5958 2021-06-01 04:23:09 Skane, Sweden
981288 2021-05-30 Sweden Skane     153662 1730 0 151932 55.9903 13.5958 2021-05-31 03:08:59 Skane, Sweden
841669 2021-05-29 Sweden Skane     153662 1730 0 151932 55.9903 13.5958 2021-05-30 04:20:55 Skane, Sweden
698241 2021-05-28 Sweden Skane     153662 1730 0 151932 55.9903 13.5958 2021-05-29 04:20:41 Skane, Sweden
1369742 2021-05-27 Sweden Skane     153662 1730 0 151932 55.9903 13.5958 2021-05-28 04:20:36 Skane, Sweden
1292826 2021-05-26 Sweden Skane     153438 1730 0 151708 55.9903 13.5958 2021-05-27 04:20:59 Skane, Sweden
603197 2021-05-25 Sweden Skane     153120 1730 0 151390 55.9903 13.5958 2021-05-26 04:20:35 Skane, Sweden
1365755 2021-05-24 Sweden Skane     152297 1716 0 150581 55.9903 13.5958 2021-05-25 04:21:08 Skane, Sweden
420268 2021-05-23 Sweden Skane     152297 1716 0 150581 55.9903 13.5958 2021-05-24 04:20:53 Skane, Sweden
54607 2021-05-22 Sweden Skane     152297 1716 0 150581 55.9903 13.5958 2021-05-23 04:20:51 Skane, Sweden
368886 2021-05-21 Sweden Skane     152297 1716 0 150581 55.9903 13.5958 2021-05-22 04:20:45 Skane, Sweden
1024685 2021-05-20 Sweden Skane     151892 1716 0 150176 55.9903 13.5958 2021-05-21 04:20:43 Skane, Sweden
1679311 2021-05-19 Sweden Skane     151421 1716 0 149705 55.9903 13.5958 2021-05-20 04:21:05 Skane, Sweden
65298 2021-05-18 Sweden Skane     150664 1715 0 148949 55.9903 13.5958 2021-05-19 04:20:42 Skane, Sweden
1243370 2021-05-17 Sweden Skane     149348 1703 0 147645 55.9903 13.5958 2021-05-18 04:20:33 Skane, Sweden
1068218 2021-05-16 Sweden Skane     149348 1703 0 147645 55.9903 13.5958 2021-05-17 04:20:34 Skane, Sweden
505346 2021-05-15 Sweden Skane     149348 1703 0 147645 55.9903 13.5958 2021-05-16 04:20:49 Skane, Sweden
892951 2021-05-14 Sweden Skane     149348 1703 0 147645 55.9903 13.5958 2021-05-15 04:20:58 Skane, Sweden
532286 2021-05-13 Sweden Skane     147972 1702 0 146270 55.9903 13.5958 2021-05-14 04:20:41 Skane, Sweden
1719573 2021-05-12 Sweden Skane     147972 1702 0 146270 55.9903 13.5958 2021-05-13 04:20:51 Skane, Sweden
1723559 2021-05-11 Sweden Skane     147128 1702 0 145426 55.9903 13.5958 2021-05-12 04:21:29 Skane, Sweden
1165316 2021-05-10 Sweden Skane     145278 1688 0 143590 55.9903 13.5958 2021-05-11 04:20:41 Skane, Sweden
1169302 2021-05-09 Sweden Skane     145278 1688 0 143590 55.9903 13.5958 2021-05-10 04:20:38 Skane, Sweden
1660089 2021-05-08 Sweden Skane     145278 1688 0 143590 55.9903 13.5958 2021-05-09 04:20:35 Skane, Sweden
800187 2021-05-07 Sweden Skane     145278 1688 0 143590 55.9903 13.5958 2021-05-08 04:21:04 Skane, Sweden
1219702 2021-05-06 Sweden Skane     144574 1688 0 142886 55.9903 13.5958 2021-05-07 04:20:40 Skane, Sweden
416282 2021-05-05 Sweden Skane     143830 1688 0 142142 55.9903 13.5958 2021-05-06 04:20:38 Skane, Sweden
674303 2021-05-04 Sweden Skane     142860 1688 0 141172 55.9903 13.5958 2021-05-05 04:20:43 Skane, Sweden
1088327 2021-05-03 Sweden Skane     140997 1677 0 139320 55.9903 13.5958 2021-05-04 04:20:34 Skane, Sweden
1727545 2021-05-02 Sweden Skane     140997 1677 0 139320 55.9903 13.5958 2021-05-03 04:20:39 Skane, Sweden
1084341 2021-05-01 Sweden Skane     140997 1677 0 139320 55.9903 13.5958 2021-05-02 04:20:48 Skane, Sweden
1388869 2021-04-30 Sweden Skane     140997 1677 0 139320 55.9903 13.5958 2021-05-01 04:20:47 Skane, Sweden
38688 2021-04-29 Sweden Skane     140255 1677 0 138578 55.9903 13.5958 2021-04-30 04:21:03 Skane, Sweden
12261 2021-04-28 Sweden Skane     139462 1677 0 137785 55.9903 13.5958 2021-04-29 04:20:55 Skane, Sweden
853644 2021-04-27 Sweden Skane     138604 1675 0 136929 55.9903 13.5958 2021-04-28 04:20:32 Skane, Sweden
1064232 2021-04-26 Sweden Skane     136944 1669 0 135275 55.9903 13.5958 2021-04-27 04:20:52 Skane, Sweden
1476482 2021-04-25 Sweden Skane     136944 1669 0 135275 55.9903 13.5958 2021-04-26 04:21:04 Skane, Sweden
744103 2021-04-24 Sweden Skane     136944 1669 0 135275 55.9903 13.5958 2021-04-25 04:20:32 Skane, Sweden
1430902 2021-04-23 Sweden Skane     136944 1669 0 135275 55.9903 13.5958 2021-04-24 04:20:38 Skane, Sweden
96731 2021-04-22 Sweden Skane     136223 1669 0 134554 55.9903 13.5958 2021-04-23 04:20:52 Skane, Sweden
849658 2021-04-21 Sweden Skane     135516 1669 0 133847 55.9903 13.5958 2021-04-22 04:20:53 Skane, Sweden
827276 2021-04-20 Sweden Skane     134760 1669 0 133091 55.9903 13.5958 2021-04-21 04:21:14 Skane, Sweden
770987 2021-04-19 Sweden Skane     133098 1663 0 131435 55.9903 13.5958 2021-04-20 04:20:41 Skane, Sweden
1416296 2021-04-18 Sweden Skane     133098 1663 0 131435 55.9903 13.5958 2021-04-19 04:20:57 Skane, Sweden
985273 2021-04-17 Sweden Skane     133098 1663 0 131435 55.9903 13.5958 2021-04-18 04:20:41 Skane, Sweden
238336 2021-04-16 Sweden Skane     133098 1663 0 131435 55.9903 13.5958 2021-04-17 04:20:40 Skane, Sweden
580065 2021-04-15 Sweden Skane     132429 1663 0 130766 55.9903 13.5958 2021-04-16 04:20:46 Skane, Sweden
1266693 2021-04-14 Sweden Skane     131765 1661 0 130104 55.9903 13.5958 2021-04-15 04:20:54 Skane, Sweden
702226 2021-04-13 Sweden Skane     130857 1653 0 129204 55.9903 13.5958 2021-04-14 04:20:41 Skane, Sweden
1671339 2021-04-12 Sweden Skane     129010 1649 0 127361 55.9903 13.5958 2021-04-13 04:20:37 Skane, Sweden
785044 2021-04-11 Sweden Skane     129010 1649 0 127361 55.9903 13.5958 2021-04-12 04:21:00 Skane, Sweden
1392855 2021-04-10 Sweden Skane     129010 1649 0 127361 55.9903 13.5958 2021-04-11 04:20:56 Skane, Sweden
966286 2021-04-09 Sweden Skane     129010 1649 0 127361 55.9903 13.5958 2021-04-10 04:20:59 Skane, Sweden
690290 2021-04-08 Sweden Skane     128168 1648 0 126520 55.9903 13.5958 2021-04-09 04:21:13 Skane, Sweden
1277742 2021-04-07 Sweden Skane     127118 1648 0 125470 55.9903 13.5958 2021-04-08 04:21:13 Skane, Sweden
88761 2021-04-06 Sweden Skane     126645 1643 0 125002 55.9903 13.5958 2021-04-07 04:20:53 Skane, Sweden
123143 2021-04-05 Sweden Skane     124712 1643 0 123069 55.9903 13.5958 2021-04-06 04:20:32 Skane, Sweden
73645 2021-04-04 Sweden Skane     124712 1643 0 123069 55.9903 13.5958 2021-04-05 04:20:35 Skane, Sweden
792261 2021-04-03 Sweden Skane     124712 1643 0 123069 55.9903 13.5958 2021-04-04 04:20:49 Skane, Sweden
1020699 2021-04-02 Sweden Skane     124712 1643 0 123069 55.9903 13.5958 2021-04-03 04:20:44 Skane, Sweden
1350861 2021-04-01 Sweden Skane     124712 1643 0 123069 55.9903 13.5958 2021-04-02 04:20:36 Skane, Sweden
1691247 2021-03-31 Sweden Skane     124024 1643 0 122381 55.9903 13.5958 2021-04-01 04:27:05 Skane, Sweden
873616 2021-03-30 Sweden Skane     123228 1640 0 121588 55.9903 13.5958 2021-03-31 04:26:25 Skane, Sweden
1400663 2021-03-29 Sweden Skane     121690 1629 0 120061 55.9903 13.5958 2021-03-30 04:26:23 Skane, Sweden
1625066 2021-03-28 Sweden Skane     121690 1629 0 120061 55.9903 13.5958 2021-03-29 04:28:35 Skane, Sweden
1472496 2021-03-27 Sweden Skane     121690 1629 0 120061 55.9903 13.5958 2021-03-28 05:28:10 Skane, Sweden
721043 2021-03-26 Sweden Skane     121690 1629 0 120061 55.9903 13.5958 2021-03-27 05:25:04 Skane, Sweden
1617662 2021-03-25 Sweden Skane     121155 1629 0 119526 55.9903 13.5958 2021-03-26 05:26:55 Skane, Sweden
470323 2021-03-24 Sweden Skane     120356 1629 0 118727 55.9903 13.5958 2021-03-25 05:27:00 Skane, Sweden
1585363 2021-03-23 Sweden Skane     119715 1627 0 118088 55.9903 13.5958 2021-03-24 05:25:40 Skane, Sweden
717057 2021-03-22 Sweden Skane     118480 1616 0 116864 55.9903 13.5958 2021-03-23 05:26:18 Skane, Sweden
1675325 2021-03-21 Sweden Skane     118480 1616 0 116864 55.9903 13.5958 2021-03-22 05:25:43 Skane, Sweden
1747264 2021-03-20 Sweden Skane     118480 1616 0 116864 55.9903 13.5958 2021-03-21 05:25:44 Skane, Sweden
230386 2021-03-19 Sweden Skane     118480 1616 0 116864 55.9903 13.5958 2021-03-20 05:25:46 Skane, Sweden
478321 2021-03-18 Sweden Skane     117998 1616 0 116382 55.9903 13.5958 2021-03-19 05:26:09 Skane, Sweden
1426916 2021-03-17 Sweden Skane     117526 1615 0 115911 55.9903 13.5958 2021-03-18 05:26:22 Skane, Sweden
1593504 2021-03-16 Sweden Skane     116790 1615 0 115175 55.9903 13.5958 2021-03-17 05:25:07 Skane, Sweden
1176503 2021-03-15 Sweden Skane     115671 1601 0 114070 55.9903 13.5958 2021-03-16 05:25:13 Skane, Sweden
276188 2021-03-14 Sweden Skane     115671 1601 0 114070 55.9903 13.5958 2021-03-15 05:25:51 Skane, Sweden
1161330 2021-03-13 Sweden Skane     115671 1601 0 114070 55.9903 13.5958 2021-03-14 05:25:37 Skane, Sweden
22837 2021-03-12 Sweden Skane     115671 1601 0 114070 55.9903 13.5958 2021-03-13 05:25:15 Skane, 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]);