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

375 rows where country_or_region = "Sweden" and province_or_state = "Blekinge" sorted by day descending

View and edit SQL

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

province_or_state

  • Blekinge · 375

country_or_region

  • Sweden · 375
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
223235 2021-06-14 Sweden Blekinge     12723 129 0 12594 56.2784 15.018 2021-06-15 04:22:22 Blekinge, Sweden
215267 2021-06-13 Sweden Blekinge     12723 129 0 12594 56.2784 15.018 2021-06-14 04:22:46 Blekinge, Sweden
281837 2021-06-12 Sweden Blekinge     12723 129 0 12594 56.2784 15.018 2021-06-13 04:22:44 Blekinge, Sweden
1633936 2021-06-11 Sweden Blekinge     12723 129 0 12594 56.2784 15.018 2021-06-12 04:22:22 Blekinge, Sweden
663222 2021-06-10 Sweden Blekinge     12717 129 0 12588 56.2784 15.018 2021-06-11 04:23:20 Blekinge, Sweden
882326 2021-06-09 Sweden Blekinge     12696 129 0 12567 56.2784 15.018 2021-06-10 04:23:17 Blekinge, Sweden
1710325 2021-06-08 Sweden Blekinge     12666 128 0 12538 56.2784 15.018 2021-06-09 04:23:31 Blekinge, Sweden
1466169 2021-06-07 Sweden Blekinge     12635 128 0 12507 56.2784 15.018 2021-06-08 04:22:35 Blekinge, Sweden
993936 2021-06-06 Sweden Blekinge     12635 128 0 12507 56.2784 15.018 2021-06-07 04:22:51 Blekinge, Sweden
158726 2021-06-05 Sweden Blekinge     12635 128 0 12507 56.2784 15.018 2021-06-06 04:24:03 Blekinge, Sweden
1516711 2021-06-04 Sweden Blekinge     12635 128 0 12507 56.2784 15.018 2021-06-05 04:23:03 Blekinge, Sweden
1141022 2021-06-03 Sweden Blekinge     12616 128 0 12488 56.2784 15.018 2021-06-04 04:23:37 Blekinge, Sweden
427466 2021-06-02 Sweden Blekinge     12519 128 0 12391 56.2784 15.018 2021-06-03 04:23:32 Blekinge, Sweden
539973 2021-06-01 Sweden Blekinge     12519 128 0 12391 56.2784 15.018 2021-06-02 04:24:34 Blekinge, Sweden
787158 2021-05-31 Sweden Blekinge     12519 128 0 12391 56.2784 15.018 2021-06-01 04:23:09 Blekinge, Sweden
1330556 2021-05-30 Sweden Blekinge     12519 128 0 12391 56.2784 15.018 2021-05-31 03:08:59 Blekinge, Sweden
67765 2021-05-29 Sweden Blekinge     12519 128 0 12391 56.2784 15.018 2021-05-30 04:20:55 Blekinge, Sweden
195951 2021-05-28 Sweden Blekinge     12519 128 0 12391 56.2784 15.018 2021-05-29 04:20:41 Blekinge, Sweden
939210 2021-05-27 Sweden Blekinge     12519 128 0 12391 56.2784 15.018 2021-05-28 04:20:36 Blekinge, Sweden
1226884 2021-05-26 Sweden Blekinge     12497 128 0 12369 56.2784 15.018 2021-05-27 04:20:59 Blekinge, Sweden
1338523 2021-05-25 Sweden Blekinge     12449 128 0 12321 56.2784 15.018 2021-05-26 04:20:35 Blekinge, Sweden
203355 2021-05-24 Sweden Blekinge     12393 128 0 12265 56.2784 15.018 2021-05-25 04:21:08 Blekinge, Sweden
99519 2021-05-23 Sweden Blekinge     12393 128 0 12265 56.2784 15.018 2021-05-24 04:20:53 Blekinge, Sweden
524038 2021-05-22 Sweden Blekinge     12393 128 0 12265 56.2784 15.018 2021-05-23 04:20:51 Blekinge, Sweden
859733 2021-05-21 Sweden Blekinge     12393 128 0 12265 56.2784 15.018 2021-05-22 04:20:45 Blekinge, Sweden
721156 2021-05-20 Sweden Blekinge     12357 128 0 12229 56.2784 15.018 2021-05-21 04:20:43 Blekinge, Sweden
408287 2021-05-19 Sweden Blekinge     12310 128 0 12182 56.2784 15.018 2021-05-20 04:21:05 Blekinge, Sweden
783173 2021-05-18 Sweden Blekinge     12241 128 0 12113 56.2784 15.018 2021-05-19 04:20:42 Blekinge, Sweden
1423315 2021-05-17 Sweden Blekinge     12168 128 0 12040 56.2784 15.018 2021-05-18 04:20:33 Blekinge, Sweden
740501 2021-05-16 Sweden Blekinge     12168 128 0 12040 56.2784 15.018 2021-05-17 04:20:34 Blekinge, Sweden
1117034 2021-05-15 Sweden Blekinge     12168 128 0 12040 56.2784 15.018 2021-05-16 04:20:49 Blekinge, Sweden
1587543 2021-05-14 Sweden Blekinge     12168 128 0 12040 56.2784 15.018 2021-05-15 04:20:58 Blekinge, Sweden
1675460 2021-05-13 Sweden Blekinge     12069 128 0 11941 56.2784 15.018 2021-05-14 04:20:41 Blekinge, Sweden
803087 2021-05-12 Sweden Blekinge     12069 128 0 11941 56.2784 15.018 2021-05-13 04:20:51 Blekinge, Sweden
1181475 2021-05-11 Sweden Blekinge     11950 128 0 11822 56.2784 15.018 2021-05-12 04:21:29 Blekinge, Sweden
325265 2021-05-10 Sweden Blekinge     11836 128 0 11708 56.2784 15.018 2021-05-11 04:20:41 Blekinge, Sweden
604412 2021-05-09 Sweden Blekinge     11836 128 0 11708 56.2784 15.018 2021-05-10 04:20:38 Blekinge, Sweden
986159 2021-05-08 Sweden Blekinge     11836 128 0 11708 56.2784 15.018 2021-05-09 04:20:35 Blekinge, Sweden
434641 2021-05-07 Sweden Blekinge     11836 128 0 11708 56.2784 15.018 2021-05-08 04:21:04 Blekinge, Sweden
901422 2021-05-06 Sweden Blekinge     11744 128 0 11616 56.2784 15.018 2021-05-07 04:20:40 Blekinge, Sweden
71748 2021-05-05 Sweden Blekinge     11650 128 0 11522 56.2784 15.018 2021-05-06 04:20:38 Blekinge, Sweden
791141 2021-05-04 Sweden Blekinge     11494 128 0 11366 56.2784 15.018 2021-05-05 04:20:43 Blekinge, Sweden
1613671 2021-05-03 Sweden Blekinge     11325 128 0 11197 56.2784 15.018 2021-05-04 04:20:34 Blekinge, Sweden
886309 2021-05-02 Sweden Blekinge     11325 128 0 11197 56.2784 15.018 2021-05-03 04:20:39 Blekinge, Sweden
512014 2021-05-01 Sweden Blekinge     11325 128 0 11197 56.2784 15.018 2021-05-02 04:20:48 Blekinge, Sweden
14950 2021-04-30 Sweden Blekinge     11325 128 0 11197 56.2784 15.018 2021-05-01 04:20:47 Blekinge, Sweden
1125054 2021-04-29 Sweden Blekinge     11229 128 0 11101 56.2784 15.018 2021-04-30 04:21:03 Blekinge, Sweden
462351 2021-04-28 Sweden Blekinge     11129 128 0 11001 56.2784 15.018 2021-04-29 04:20:55 Blekinge, Sweden
1315057 2021-04-27 Sweden Blekinge     10944 127 0 10817 56.2784 15.018 2021-04-28 04:20:32 Blekinge, Sweden
1549484 2021-04-26 Sweden Blekinge     10724 125 0 10599 56.2784 15.018 2021-04-27 04:20:52 Blekinge, Sweden
1629951 2021-04-25 Sweden Blekinge     10724 125 0 10599 56.2784 15.018 2021-04-26 04:21:04 Blekinge, Sweden
354091 2021-04-24 Sweden Blekinge     10724 125 0 10599 56.2784 15.018 2021-04-25 04:20:32 Blekinge, Sweden
725140 2021-04-23 Sweden Blekinge     10724 125 0 10599 56.2784 15.018 2021-04-24 04:20:38 Blekinge, Sweden
1470152 2021-04-22 Sweden Blekinge     10606 125 0 10481 56.2784 15.018 2021-04-23 04:20:52 Blekinge, Sweden
1222900 2021-04-21 Sweden Blekinge     10475 124 0 10351 56.2784 15.018 2021-04-22 04:20:53 Blekinge, Sweden
458367 2021-04-20 Sweden Blekinge     10288 125 0 10163 56.2784 15.018 2021-04-21 04:21:14 Blekinge, Sweden
1300555 2021-04-19 Sweden Blekinge     10095 123 0 9972 56.2784 15.018 2021-04-20 04:20:41 Blekinge, Sweden
1070134 2021-04-18 Sweden Blekinge     10095 123 0 9972 56.2784 15.018 2021-04-19 04:20:57 Blekinge, Sweden
1046016 2021-04-17 Sweden Blekinge     10095 123 0 9972 56.2784 15.018 2021-04-18 04:20:41 Blekinge, Sweden
597292 2021-04-16 Sweden Blekinge     10095 123 0 9972 56.2784 15.018 2021-04-17 04:20:40 Blekinge, Sweden
1621708 2021-04-15 Sweden Blekinge     9988 122 0 9866 56.2784 15.018 2021-04-16 04:20:46 Blekinge, Sweden
951139 2021-04-14 Sweden Blekinge     9866 121 0 9745 56.2784 15.018 2021-04-15 04:20:54 Blekinge, Sweden
593308 2021-04-13 Sweden Blekinge     9692 121 0 9571 56.2784 15.018 2021-04-14 04:20:41 Blekinge, Sweden
33247 2021-04-12 Sweden Blekinge     9521 121 0 9400 56.2784 15.018 2021-04-13 04:20:37 Blekinge, Sweden
1372262 2021-04-11 Sweden Blekinge     9521 121 0 9400 56.2784 15.018 2021-04-12 04:21:00 Blekinge, Sweden
1667514 2021-04-10 Sweden Blekinge     9521 121 0 9400 56.2784 15.018 2021-04-11 04:20:56 Blekinge, Sweden
1160130 2021-04-09 Sweden Blekinge     9521 121 0 9400 56.2784 15.018 2021-04-10 04:20:59 Blekinge, Sweden
1057965 2021-04-08 Sweden Blekinge     9429 121 0 9308 56.2784 15.018 2021-04-09 04:21:13 Blekinge, Sweden
1500754 2021-04-07 Sweden Blekinge     9322 121 0 9201 56.2784 15.018 2021-04-08 04:21:13 Blekinge, Sweden
1207959 2021-04-06 Sweden Blekinge     9235 120 0 9115 56.2784 15.018 2021-04-07 04:20:53 Blekinge, Sweden
123260 2021-04-05 Sweden Blekinge     9026 120 0 8906 56.2784 15.018 2021-04-06 04:20:32 Blekinge, Sweden
1255061 2021-04-04 Sweden Blekinge     9026 120 0 8906 56.2784 15.018 2021-04-05 04:20:35 Blekinge, Sweden
1129038 2021-04-03 Sweden Blekinge     9026 120 0 8906 56.2784 15.018 2021-04-04 04:20:49 Blekinge, Sweden
270429 2021-04-02 Sweden Blekinge     9026 120 0 8906 56.2784 15.018 2021-04-03 04:20:44 Blekinge, Sweden
1173761 2021-04-01 Sweden Blekinge     9026 120 0 8906 56.2784 15.018 2021-04-02 04:20:36 Blekinge, Sweden
516072 2021-03-31 Sweden Blekinge     8956 120 0 8836 56.2784 15.018 2021-04-01 04:27:05 Blekinge, Sweden
289801 2021-03-30 Sweden Blekinge     8854 120 0 8734 56.2784 15.018 2021-03-31 04:26:25 Blekinge, Sweden
1575338 2021-03-29 Sweden Blekinge     8744 120 0 8624 56.2784 15.018 2021-03-30 04:26:23 Blekinge, Sweden
631615 2021-03-28 Sweden Blekinge     8744 120 0 8624 56.2784 15.018 2021-03-29 04:28:35 Blekinge, Sweden
608396 2021-03-27 Sweden Blekinge     8744 120 0 8624 56.2784 15.018 2021-03-28 05:28:10 Blekinge, Sweden
1334539 2021-03-26 Sweden Blekinge     8744 120 0 8624 56.2784 15.018 2021-03-27 05:25:04 Blekinge, Sweden
150978 2021-03-25 Sweden Blekinge     8697 118 0 8579 56.2784 15.018 2021-03-26 05:26:55 Blekinge, Sweden
1598499 2021-03-24 Sweden Blekinge     8648 118 0 8530 56.2784 15.018 2021-03-25 05:27:00 Blekinge, Sweden
404303 2021-03-23 Sweden Blekinge     8545 118 0 8427 56.2784 15.018 2021-03-24 05:25:40 Blekinge, Sweden
1387840 2021-03-22 Sweden Blekinge     8461 118 0 8343 56.2784 15.018 2021-03-23 05:26:18 Blekinge, Sweden
305327 2021-03-21 Sweden Blekinge     8461 118 0 8343 56.2784 15.018 2021-03-22 05:25:43 Blekinge, Sweden
254376 2021-03-20 Sweden Blekinge     8461 118 0 8343 56.2784 15.018 2021-03-21 05:25:44 Blekinge, Sweden
1231132 2021-03-19 Sweden Blekinge     8461 118 0 8343 56.2784 15.018 2021-03-20 05:25:46 Blekinge, Sweden
975057 2021-03-18 Sweden Blekinge     8421 118 0 8303 56.2784 15.018 2021-03-19 05:26:09 Blekinge, Sweden
1532692 2021-03-17 Sweden Blekinge     8393 118 0 8275 56.2784 15.018 2021-03-18 05:26:22 Blekinge, Sweden
55886 2021-03-16 Sweden Blekinge     8335 117 0 8218 56.2784 15.018 2021-03-17 05:25:07 Blekinge, Sweden
563199 2021-03-15 Sweden Blekinge     8269 117 0 8152 56.2784 15.018 2021-03-16 05:25:13 Blekinge, Sweden
851768 2021-03-14 Sweden Blekinge     8269 117 0 8152 56.2784 15.018 2021-03-15 05:25:51 Blekinge, Sweden
943193 2021-03-13 Sweden Blekinge     8269 117 0 8152 56.2784 15.018 2021-03-14 05:25:37 Blekinge, Sweden
1311073 2021-03-12 Sweden Blekinge     8269 117 0 8152 56.2784 15.018 2021-03-13 05:25:15 Blekinge, Sweden
1077911 2021-03-11 Sweden Blekinge     8237 117 0 8120 56.2784 15.018 2021-03-12 05:26:50 Blekinge, Sweden
955123 2021-03-10 Sweden Blekinge     8210 117 0 8093 56.2784 15.018 2021-03-11 05:25:48 Blekinge, Sweden
543956 2021-03-09 Sweden Blekinge     8156 117 0 8039 56.2784 15.018 2021-03-10 05:24:35 Blekinge, Sweden
1520694 2021-03-08 Sweden Blekinge     8094 116 0 7978 56.2784 15.018 2021-03-09 05:28:19 Blekinge, Sweden
866975 2021-03-07 Sweden Blekinge     8094 116 0 7978 56.2784 15.018 2021-03-08 05:24:48 Blekinge, 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]);