⚠️ 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 = "Stockholm" sorted by day descending

View and edit SQL

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

province_or_state

  • Stockholm · 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
168784 2021-06-19 Sweden Stockholm     253951 4353 0 249598 59.6025 18.1384 2021-06-20 04:21:48 Stockholm, Sweden
686309 2021-06-18 Sweden Stockholm     253951 4353 0 249598 59.6025 18.1384 2021-06-19 04:22:33 Stockholm, Sweden
958366 2021-06-17 Sweden Stockholm     253951 4353 0 249598 59.6025 18.1384 2021-06-18 04:22:16 Stockholm, Sweden
1281731 2021-06-16 Sweden Stockholm     253951 4353 0 249598 59.6025 18.1384 2021-06-17 04:22:36 Stockholm, Sweden
682321 2021-06-15 Sweden Stockholm     253951 4353 0 249598 59.6025 18.1384 2021-06-16 04:22:32 Stockholm, Sweden
372875 2021-06-14 Sweden Stockholm     253770 4353 0 249417 59.6025 18.1384 2021-06-15 04:22:22 Stockholm, Sweden
1223691 2021-06-13 Sweden Stockholm     253770 4353 0 249417 59.6025 18.1384 2021-06-14 04:22:46 Stockholm, Sweden
80972 2021-06-12 Sweden Stockholm     253770 4353 0 249417 59.6025 18.1384 2021-06-13 04:22:44 Stockholm, Sweden
970275 2021-06-11 Sweden Stockholm     253770 4353 0 249417 59.6025 18.1384 2021-06-12 04:22:22 Stockholm, Sweden
1438848 2021-06-10 Sweden Stockholm     253645 4349 0 249296 59.6025 18.1384 2021-06-11 04:23:20 Stockholm, Sweden
1157347 2021-06-09 Sweden Stockholm     253548 4349 0 249199 59.6025 18.1384 2021-06-10 04:23:17 Stockholm, Sweden
1231663 2021-06-08 Sweden Stockholm     253388 4344 0 249044 59.6025 18.1384 2021-06-09 04:23:31 Stockholm, Sweden
360659 2021-06-07 Sweden Stockholm     252972 4339 0 248633 59.6025 18.1384 2021-06-08 04:22:35 Stockholm, Sweden
1076287 2021-06-06 Sweden Stockholm     252972 4339 0 248633 59.6025 18.1384 2021-06-07 04:22:51 Stockholm, Sweden
1613679 2021-06-05 Sweden Stockholm     252972 4339 0 248633 59.6025 18.1384 2021-06-06 04:24:03 Stockholm, Sweden
1125965 2021-06-04 Sweden Stockholm     252972 4339 0 248633 59.6025 18.1384 2021-06-05 04:23:03 Stockholm, Sweden
318421 2021-06-03 Sweden Stockholm     252829 4339 0 248490 59.6025 18.1384 2021-06-04 04:23:37 Stockholm, Sweden
1133934 2021-06-02 Sweden Stockholm     251285 4320 0 246965 59.6025 18.1384 2021-06-03 04:23:32 Stockholm, Sweden
292111 2021-06-01 Sweden Stockholm     251285 4320 0 246965 59.6025 18.1384 2021-06-02 04:24:34 Stockholm, Sweden
1652062 2021-05-31 Sweden Stockholm     251285 4320 0 246965 59.6025 18.1384 2021-06-01 04:23:09 Stockholm, Sweden
981290 2021-05-30 Sweden Stockholm     251285 4320 0 246965 59.6025 18.1384 2021-05-31 03:08:59 Stockholm, Sweden
841671 2021-05-29 Sweden Stockholm     251285 4320 0 246965 59.6025 18.1384 2021-05-30 04:20:55 Stockholm, Sweden
698243 2021-05-28 Sweden Stockholm     251285 4320 0 246965 59.6025 18.1384 2021-05-29 04:20:41 Stockholm, Sweden
1369744 2021-05-27 Sweden Stockholm     251285 4320 0 246965 59.6025 18.1384 2021-05-28 04:20:36 Stockholm, Sweden
1292828 2021-05-26 Sweden Stockholm     251133 4320 0 246813 59.6025 18.1384 2021-05-27 04:20:59 Stockholm, Sweden
603199 2021-05-25 Sweden Stockholm     250763 4305 0 246458 59.6025 18.1384 2021-05-26 04:20:35 Stockholm, Sweden
1365757 2021-05-24 Sweden Stockholm     249494 4294 0 245200 59.6025 18.1384 2021-05-25 04:21:08 Stockholm, Sweden
420270 2021-05-23 Sweden Stockholm     249494 4294 0 245200 59.6025 18.1384 2021-05-24 04:20:53 Stockholm, Sweden
54609 2021-05-22 Sweden Stockholm     249494 4294 0 245200 59.6025 18.1384 2021-05-23 04:20:51 Stockholm, Sweden
368888 2021-05-21 Sweden Stockholm     249494 4294 0 245200 59.6025 18.1384 2021-05-22 04:20:45 Stockholm, Sweden
1024687 2021-05-20 Sweden Stockholm     249011 4294 0 244717 59.6025 18.1384 2021-05-21 04:20:43 Stockholm, Sweden
1679313 2021-05-19 Sweden Stockholm     248348 4294 0 244054 59.6025 18.1384 2021-05-20 04:21:05 Stockholm, Sweden
65300 2021-05-18 Sweden Stockholm     247714 4267 0 243447 59.6025 18.1384 2021-05-19 04:20:42 Stockholm, Sweden
1243372 2021-05-17 Sweden Stockholm     245353 4266 0 241087 59.6025 18.1384 2021-05-18 04:20:33 Stockholm, Sweden
1068220 2021-05-16 Sweden Stockholm     245353 4266 0 241087 59.6025 18.1384 2021-05-17 04:20:34 Stockholm, Sweden
505348 2021-05-15 Sweden Stockholm     245353 4266 0 241087 59.6025 18.1384 2021-05-16 04:20:49 Stockholm, Sweden
892953 2021-05-14 Sweden Stockholm     245353 4266 0 241087 59.6025 18.1384 2021-05-15 04:20:58 Stockholm, Sweden
532288 2021-05-13 Sweden Stockholm     243381 4266 0 239115 59.6025 18.1384 2021-05-14 04:20:41 Stockholm, Sweden
1719575 2021-05-12 Sweden Stockholm     243381 4266 0 239115 59.6025 18.1384 2021-05-13 04:20:51 Stockholm, Sweden
1723561 2021-05-11 Sweden Stockholm     242275 4244 0 238031 59.6025 18.1384 2021-05-12 04:21:29 Stockholm, Sweden
1165318 2021-05-10 Sweden Stockholm     238733 4230 0 234503 59.6025 18.1384 2021-05-11 04:20:41 Stockholm, Sweden
1169304 2021-05-09 Sweden Stockholm     238733 4230 0 234503 59.6025 18.1384 2021-05-10 04:20:38 Stockholm, Sweden
1660091 2021-05-08 Sweden Stockholm     238733 4230 0 234503 59.6025 18.1384 2021-05-09 04:20:35 Stockholm, Sweden
800189 2021-05-07 Sweden Stockholm     238733 4230 0 234503 59.6025 18.1384 2021-05-08 04:21:04 Stockholm, Sweden
1219704 2021-05-06 Sweden Stockholm     237528 4230 0 233298 59.6025 18.1384 2021-05-07 04:20:40 Stockholm, Sweden
416284 2021-05-05 Sweden Stockholm     236126 4230 0 231896 59.6025 18.1384 2021-05-06 04:20:38 Stockholm, Sweden
674305 2021-05-04 Sweden Stockholm     234858 4203 0 230655 59.6025 18.1384 2021-05-05 04:20:43 Stockholm, Sweden
1088329 2021-05-03 Sweden Stockholm     230930 4188 0 226742 59.6025 18.1384 2021-05-04 04:20:34 Stockholm, Sweden
1727547 2021-05-02 Sweden Stockholm     230930 4188 0 226742 59.6025 18.1384 2021-05-03 04:20:39 Stockholm, Sweden
1084343 2021-05-01 Sweden Stockholm     230930 4188 0 226742 59.6025 18.1384 2021-05-02 04:20:48 Stockholm, Sweden
1388871 2021-04-30 Sweden Stockholm     230930 4188 0 226742 59.6025 18.1384 2021-05-01 04:20:47 Stockholm, Sweden
38690 2021-04-29 Sweden Stockholm     229589 4160 0 225429 59.6025 18.1384 2021-04-30 04:21:03 Stockholm, Sweden
12263 2021-04-28 Sweden Stockholm     227828 4160 0 223668 59.6025 18.1384 2021-04-29 04:20:55 Stockholm, Sweden
853646 2021-04-27 Sweden Stockholm     226471 4160 0 222311 59.6025 18.1384 2021-04-28 04:20:32 Stockholm, Sweden
1064234 2021-04-26 Sweden Stockholm     222719 4160 0 218559 59.6025 18.1384 2021-04-27 04:20:52 Stockholm, Sweden
1476484 2021-04-25 Sweden Stockholm     222719 4160 0 218559 59.6025 18.1384 2021-04-26 04:21:04 Stockholm, Sweden
744105 2021-04-24 Sweden Stockholm     222719 4160 0 218559 59.6025 18.1384 2021-04-25 04:20:32 Stockholm, Sweden
1430904 2021-04-23 Sweden Stockholm     222719 4160 0 218559 59.6025 18.1384 2021-04-24 04:20:38 Stockholm, Sweden
96733 2021-04-22 Sweden Stockholm     221251 4139 0 217112 59.6025 18.1384 2021-04-23 04:20:52 Stockholm, Sweden
849660 2021-04-21 Sweden Stockholm     219693 4139 0 215554 59.6025 18.1384 2021-04-22 04:20:53 Stockholm, Sweden
827278 2021-04-20 Sweden Stockholm     218109 4124 0 213985 59.6025 18.1384 2021-04-21 04:21:14 Stockholm, Sweden
770989 2021-04-19 Sweden Stockholm     214510 4105 0 210405 59.6025 18.1384 2021-04-20 04:20:41 Stockholm, Sweden
1416298 2021-04-18 Sweden Stockholm     214510 4105 0 210405 59.6025 18.1384 2021-04-19 04:20:57 Stockholm, Sweden
985275 2021-04-17 Sweden Stockholm     214510 4105 0 210405 59.6025 18.1384 2021-04-18 04:20:41 Stockholm, Sweden
238338 2021-04-16 Sweden Stockholm     214510 4105 0 210405 59.6025 18.1384 2021-04-17 04:20:40 Stockholm, Sweden
580067 2021-04-15 Sweden Stockholm     212766 4105 0 208661 59.6025 18.1384 2021-04-16 04:20:46 Stockholm, Sweden
1266695 2021-04-14 Sweden Stockholm     211199 4077 0 207122 59.6025 18.1384 2021-04-15 04:20:54 Stockholm, Sweden
702228 2021-04-13 Sweden Stockholm     208810 4077 0 204733 59.6025 18.1384 2021-04-14 04:20:41 Stockholm, Sweden
1671341 2021-04-12 Sweden Stockholm     204455 4059 0 200396 59.6025 18.1384 2021-04-13 04:20:37 Stockholm, Sweden
785046 2021-04-11 Sweden Stockholm     204455 4059 0 200396 59.6025 18.1384 2021-04-12 04:21:00 Stockholm, Sweden
1392857 2021-04-10 Sweden Stockholm     204455 4059 0 200396 59.6025 18.1384 2021-04-11 04:20:56 Stockholm, Sweden
966288 2021-04-09 Sweden Stockholm     204455 4059 0 200396 59.6025 18.1384 2021-04-10 04:20:59 Stockholm, Sweden
690292 2021-04-08 Sweden Stockholm     203085 4058 0 199027 59.6025 18.1384 2021-04-09 04:21:13 Stockholm, Sweden
1277744 2021-04-07 Sweden Stockholm     201615 4042 0 197573 59.6025 18.1384 2021-04-08 04:21:13 Stockholm, Sweden
88763 2021-04-06 Sweden Stockholm     199728 4042 0 195686 59.6025 18.1384 2021-04-07 04:20:53 Stockholm, Sweden
123145 2021-04-05 Sweden Stockholm     194252 4029 0 190223 59.6025 18.1384 2021-04-06 04:20:32 Stockholm, Sweden
73647 2021-04-04 Sweden Stockholm     194252 4029 0 190223 59.6025 18.1384 2021-04-05 04:20:35 Stockholm, Sweden
792263 2021-04-03 Sweden Stockholm     194252 4029 0 190223 59.6025 18.1384 2021-04-04 04:20:49 Stockholm, Sweden
1020701 2021-04-02 Sweden Stockholm     194252 4029 0 190223 59.6025 18.1384 2021-04-03 04:20:44 Stockholm, Sweden
1350863 2021-04-01 Sweden Stockholm     194252 4029 0 190223 59.6025 18.1384 2021-04-02 04:20:36 Stockholm, Sweden
1691249 2021-03-31 Sweden Stockholm     192075 4003 0 188072 59.6025 18.1384 2021-04-01 04:27:05 Stockholm, Sweden
873618 2021-03-30 Sweden Stockholm     189762 4003 0 185759 59.6025 18.1384 2021-03-31 04:26:25 Stockholm, Sweden
1400665 2021-03-29 Sweden Stockholm     185885 4001 0 181884 59.6025 18.1384 2021-03-30 04:26:23 Stockholm, Sweden
1625068 2021-03-28 Sweden Stockholm     185885 4001 0 181884 59.6025 18.1384 2021-03-29 04:28:35 Stockholm, Sweden
1472498 2021-03-27 Sweden Stockholm     185885 4001 0 181884 59.6025 18.1384 2021-03-28 05:28:10 Stockholm, Sweden
721045 2021-03-26 Sweden Stockholm     185885 4001 0 181884 59.6025 18.1384 2021-03-27 05:25:04 Stockholm, Sweden
1617664 2021-03-25 Sweden Stockholm     184509 3994 0 180515 59.6025 18.1384 2021-03-26 05:26:55 Stockholm, Sweden
470325 2021-03-24 Sweden Stockholm     182675 3988 0 178687 59.6025 18.1384 2021-03-25 05:27:00 Stockholm, Sweden
1585365 2021-03-23 Sweden Stockholm     180474 3987 0 176487 59.6025 18.1384 2021-03-24 05:25:40 Stockholm, Sweden
717059 2021-03-22 Sweden Stockholm     177379 3966 0 173413 59.6025 18.1384 2021-03-23 05:26:18 Stockholm, Sweden
1675327 2021-03-21 Sweden Stockholm     177379 3966 0 173413 59.6025 18.1384 2021-03-22 05:25:43 Stockholm, Sweden
1747266 2021-03-20 Sweden Stockholm     177379 3966 0 173413 59.6025 18.1384 2021-03-21 05:25:44 Stockholm, Sweden
230388 2021-03-19 Sweden Stockholm     177379 3966 0 173413 59.6025 18.1384 2021-03-20 05:25:46 Stockholm, Sweden
478323 2021-03-18 Sweden Stockholm     176180 3957 0 172223 59.6025 18.1384 2021-03-19 05:26:09 Stockholm, Sweden
1426918 2021-03-17 Sweden Stockholm     174528 3957 0 170571 59.6025 18.1384 2021-03-18 05:26:22 Stockholm, Sweden
1593506 2021-03-16 Sweden Stockholm     172595 3936 0 168659 59.6025 18.1384 2021-03-17 05:25:07 Stockholm, Sweden
1176505 2021-03-15 Sweden Stockholm     169005 3934 0 165071 59.6025 18.1384 2021-03-16 05:25:13 Stockholm, Sweden
276190 2021-03-14 Sweden Stockholm     169005 3934 0 165071 59.6025 18.1384 2021-03-15 05:25:51 Stockholm, Sweden
1161332 2021-03-13 Sweden Stockholm     169005 3934 0 165071 59.6025 18.1384 2021-03-14 05:25:37 Stockholm, Sweden
22839 2021-03-12 Sweden Stockholm     169005 3934 0 165071 59.6025 18.1384 2021-03-13 05:25:15 Stockholm, 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]);