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

View and edit SQL

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

province_or_state

  • Gavleborg · 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
168772 2021-06-19 Sweden Gavleborg     35814 560 0 35254 61.3012 16.1534 2021-06-20 04:21:48 Gavleborg, Sweden
686297 2021-06-18 Sweden Gavleborg     35814 560 0 35254 61.3012 16.1534 2021-06-19 04:22:33 Gavleborg, Sweden
958354 2021-06-17 Sweden Gavleborg     35814 560 0 35254 61.3012 16.1534 2021-06-18 04:22:16 Gavleborg, Sweden
1281719 2021-06-16 Sweden Gavleborg     35814 560 0 35254 61.3012 16.1534 2021-06-17 04:22:36 Gavleborg, Sweden
682309 2021-06-15 Sweden Gavleborg     35814 560 0 35254 61.3012 16.1534 2021-06-16 04:22:32 Gavleborg, Sweden
372863 2021-06-14 Sweden Gavleborg     35802 560 0 35242 61.3012 16.1534 2021-06-15 04:22:22 Gavleborg, Sweden
1223679 2021-06-13 Sweden Gavleborg     35802 560 0 35242 61.3012 16.1534 2021-06-14 04:22:46 Gavleborg, Sweden
80960 2021-06-12 Sweden Gavleborg     35802 560 0 35242 61.3012 16.1534 2021-06-13 04:22:44 Gavleborg, Sweden
970263 2021-06-11 Sweden Gavleborg     35802 560 0 35242 61.3012 16.1534 2021-06-12 04:22:22 Gavleborg, Sweden
1438836 2021-06-10 Sweden Gavleborg     35791 560 0 35231 61.3012 16.1534 2021-06-11 04:23:20 Gavleborg, Sweden
1157335 2021-06-09 Sweden Gavleborg     35779 560 0 35219 61.3012 16.1534 2021-06-10 04:23:17 Gavleborg, Sweden
1231651 2021-06-08 Sweden Gavleborg     35748 559 0 35189 61.3012 16.1534 2021-06-09 04:23:31 Gavleborg, Sweden
360647 2021-06-07 Sweden Gavleborg     35695 559 0 35136 61.3012 16.1534 2021-06-08 04:22:35 Gavleborg, Sweden
1076275 2021-06-06 Sweden Gavleborg     35695 559 0 35136 61.3012 16.1534 2021-06-07 04:22:51 Gavleborg, Sweden
1613667 2021-06-05 Sweden Gavleborg     35695 559 0 35136 61.3012 16.1534 2021-06-06 04:24:03 Gavleborg, Sweden
1125953 2021-06-04 Sweden Gavleborg     35695 559 0 35136 61.3012 16.1534 2021-06-05 04:23:03 Gavleborg, Sweden
318409 2021-06-03 Sweden Gavleborg     35674 559 0 35115 61.3012 16.1534 2021-06-04 04:23:37 Gavleborg, Sweden
1133922 2021-06-02 Sweden Gavleborg     35512 556 0 34956 61.3012 16.1534 2021-06-03 04:23:32 Gavleborg, Sweden
292099 2021-06-01 Sweden Gavleborg     35512 556 0 34956 61.3012 16.1534 2021-06-02 04:24:34 Gavleborg, Sweden
1652050 2021-05-31 Sweden Gavleborg     35512 556 0 34956 61.3012 16.1534 2021-06-01 04:23:09 Gavleborg, Sweden
981278 2021-05-30 Sweden Gavleborg     35512 556 0 34956 61.3012 16.1534 2021-05-31 03:08:59 Gavleborg, Sweden
841659 2021-05-29 Sweden Gavleborg     35512 556 0 34956 61.3012 16.1534 2021-05-30 04:20:55 Gavleborg, Sweden
698231 2021-05-28 Sweden Gavleborg     35512 556 0 34956 61.3012 16.1534 2021-05-29 04:20:41 Gavleborg, Sweden
1369732 2021-05-27 Sweden Gavleborg     35512 556 0 34956 61.3012 16.1534 2021-05-28 04:20:36 Gavleborg, Sweden
1292816 2021-05-26 Sweden Gavleborg     35474 553 0 34921 61.3012 16.1534 2021-05-27 04:20:59 Gavleborg, Sweden
603187 2021-05-25 Sweden Gavleborg     35401 553 0 34848 61.3012 16.1534 2021-05-26 04:20:35 Gavleborg, Sweden
1365745 2021-05-24 Sweden Gavleborg     35236 552 0 34684 61.3012 16.1534 2021-05-25 04:21:08 Gavleborg, Sweden
420258 2021-05-23 Sweden Gavleborg     35236 552 0 34684 61.3012 16.1534 2021-05-24 04:20:53 Gavleborg, Sweden
54597 2021-05-22 Sweden Gavleborg     35236 552 0 34684 61.3012 16.1534 2021-05-23 04:20:51 Gavleborg, Sweden
368876 2021-05-21 Sweden Gavleborg     35236 552 0 34684 61.3012 16.1534 2021-05-22 04:20:45 Gavleborg, Sweden
1024675 2021-05-20 Sweden Gavleborg     35168 551 0 34617 61.3012 16.1534 2021-05-21 04:20:43 Gavleborg, Sweden
1679301 2021-05-19 Sweden Gavleborg     35077 551 0 34526 61.3012 16.1534 2021-05-20 04:21:05 Gavleborg, Sweden
65288 2021-05-18 Sweden Gavleborg     34951 550 0 34401 61.3012 16.1534 2021-05-19 04:20:42 Gavleborg, Sweden
1243360 2021-05-17 Sweden Gavleborg     34706 549 0 34157 61.3012 16.1534 2021-05-18 04:20:33 Gavleborg, Sweden
1068208 2021-05-16 Sweden Gavleborg     34706 549 0 34157 61.3012 16.1534 2021-05-17 04:20:34 Gavleborg, Sweden
505336 2021-05-15 Sweden Gavleborg     34706 549 0 34157 61.3012 16.1534 2021-05-16 04:20:49 Gavleborg, Sweden
892941 2021-05-14 Sweden Gavleborg     34706 549 0 34157 61.3012 16.1534 2021-05-15 04:20:58 Gavleborg, Sweden
532276 2021-05-13 Sweden Gavleborg     34441 549 0 33892 61.3012 16.1534 2021-05-14 04:20:41 Gavleborg, Sweden
1719563 2021-05-12 Sweden Gavleborg     34441 549 0 33892 61.3012 16.1534 2021-05-13 04:20:51 Gavleborg, Sweden
1723549 2021-05-11 Sweden Gavleborg     34260 549 0 33711 61.3012 16.1534 2021-05-12 04:21:29 Gavleborg, Sweden
1165306 2021-05-10 Sweden Gavleborg     33930 548 0 33382 61.3012 16.1534 2021-05-11 04:20:41 Gavleborg, Sweden
1169292 2021-05-09 Sweden Gavleborg     33930 548 0 33382 61.3012 16.1534 2021-05-10 04:20:38 Gavleborg, Sweden
1660079 2021-05-08 Sweden Gavleborg     33930 548 0 33382 61.3012 16.1534 2021-05-09 04:20:35 Gavleborg, Sweden
800177 2021-05-07 Sweden Gavleborg     33930 548 0 33382 61.3012 16.1534 2021-05-08 04:21:04 Gavleborg, Sweden
1219692 2021-05-06 Sweden Gavleborg     33792 546 0 33246 61.3012 16.1534 2021-05-07 04:20:40 Gavleborg, Sweden
416272 2021-05-05 Sweden Gavleborg     33627 546 0 33081 61.3012 16.1534 2021-05-06 04:20:38 Gavleborg, Sweden
674293 2021-05-04 Sweden Gavleborg     33378 544 0 32834 61.3012 16.1534 2021-05-05 04:20:43 Gavleborg, Sweden
1088317 2021-05-03 Sweden Gavleborg     33107 544 0 32563 61.3012 16.1534 2021-05-04 04:20:34 Gavleborg, Sweden
1727535 2021-05-02 Sweden Gavleborg     33107 544 0 32563 61.3012 16.1534 2021-05-03 04:20:39 Gavleborg, Sweden
1084331 2021-05-01 Sweden Gavleborg     33107 544 0 32563 61.3012 16.1534 2021-05-02 04:20:48 Gavleborg, Sweden
1388859 2021-04-30 Sweden Gavleborg     33107 544 0 32563 61.3012 16.1534 2021-05-01 04:20:47 Gavleborg, Sweden
38678 2021-04-29 Sweden Gavleborg     32946 543 0 32403 61.3012 16.1534 2021-04-30 04:21:03 Gavleborg, Sweden
12251 2021-04-28 Sweden Gavleborg     32801 543 0 32258 61.3012 16.1534 2021-04-29 04:20:55 Gavleborg, Sweden
853634 2021-04-27 Sweden Gavleborg     32596 543 0 32053 61.3012 16.1534 2021-04-28 04:20:32 Gavleborg, Sweden
1064222 2021-04-26 Sweden Gavleborg     32223 543 0 31680 61.3012 16.1534 2021-04-27 04:20:52 Gavleborg, Sweden
1476472 2021-04-25 Sweden Gavleborg     32223 543 0 31680 61.3012 16.1534 2021-04-26 04:21:04 Gavleborg, Sweden
744093 2021-04-24 Sweden Gavleborg     32223 543 0 31680 61.3012 16.1534 2021-04-25 04:20:32 Gavleborg, Sweden
1430892 2021-04-23 Sweden Gavleborg     32223 543 0 31680 61.3012 16.1534 2021-04-24 04:20:38 Gavleborg, Sweden
96721 2021-04-22 Sweden Gavleborg     32030 540 0 31490 61.3012 16.1534 2021-04-23 04:20:52 Gavleborg, Sweden
849648 2021-04-21 Sweden Gavleborg     31855 539 0 31316 61.3012 16.1534 2021-04-22 04:20:53 Gavleborg, Sweden
827266 2021-04-20 Sweden Gavleborg     31608 537 0 31071 61.3012 16.1534 2021-04-21 04:21:14 Gavleborg, Sweden
770977 2021-04-19 Sweden Gavleborg     31127 537 0 30590 61.3012 16.1534 2021-04-20 04:20:41 Gavleborg, Sweden
1416286 2021-04-18 Sweden Gavleborg     31127 537 0 30590 61.3012 16.1534 2021-04-19 04:20:57 Gavleborg, Sweden
985263 2021-04-17 Sweden Gavleborg     31127 537 0 30590 61.3012 16.1534 2021-04-18 04:20:41 Gavleborg, Sweden
238326 2021-04-16 Sweden Gavleborg     31127 537 0 30590 61.3012 16.1534 2021-04-17 04:20:40 Gavleborg, Sweden
580055 2021-04-15 Sweden Gavleborg     30926 536 0 30390 61.3012 16.1534 2021-04-16 04:20:46 Gavleborg, Sweden
1266683 2021-04-14 Sweden Gavleborg     30725 536 0 30189 61.3012 16.1534 2021-04-15 04:20:54 Gavleborg, Sweden
702216 2021-04-13 Sweden Gavleborg     30398 536 0 29862 61.3012 16.1534 2021-04-14 04:20:41 Gavleborg, Sweden
1671329 2021-04-12 Sweden Gavleborg     29814 534 0 29280 61.3012 16.1534 2021-04-13 04:20:37 Gavleborg, Sweden
785034 2021-04-11 Sweden Gavleborg     29814 534 0 29280 61.3012 16.1534 2021-04-12 04:21:00 Gavleborg, Sweden
1392845 2021-04-10 Sweden Gavleborg     29814 534 0 29280 61.3012 16.1534 2021-04-11 04:20:56 Gavleborg, Sweden
966276 2021-04-09 Sweden Gavleborg     29814 534 0 29280 61.3012 16.1534 2021-04-10 04:20:59 Gavleborg, Sweden
690280 2021-04-08 Sweden Gavleborg     29483 532 0 28951 61.3012 16.1534 2021-04-09 04:21:13 Gavleborg, Sweden
1277732 2021-04-07 Sweden Gavleborg     29162 533 0 28629 61.3012 16.1534 2021-04-08 04:21:13 Gavleborg, Sweden
88751 2021-04-06 Sweden Gavleborg     28886 526 0 28360 61.3012 16.1534 2021-04-07 04:20:53 Gavleborg, Sweden
123133 2021-04-05 Sweden Gavleborg     28169 525 0 27644 61.3012 16.1534 2021-04-06 04:20:32 Gavleborg, Sweden
73635 2021-04-04 Sweden Gavleborg     28169 525 0 27644 61.3012 16.1534 2021-04-05 04:20:35 Gavleborg, Sweden
792251 2021-04-03 Sweden Gavleborg     28169 525 0 27644 61.3012 16.1534 2021-04-04 04:20:49 Gavleborg, Sweden
1020689 2021-04-02 Sweden Gavleborg     28169 525 0 27644 61.3012 16.1534 2021-04-03 04:20:44 Gavleborg, Sweden
1350851 2021-04-01 Sweden Gavleborg     28169 525 0 27644 61.3012 16.1534 2021-04-02 04:20:36 Gavleborg, Sweden
1691237 2021-03-31 Sweden Gavleborg     27932 523 0 27409 61.3012 16.1534 2021-04-01 04:27:05 Gavleborg, Sweden
873606 2021-03-30 Sweden Gavleborg     27633 521 0 27112 61.3012 16.1534 2021-03-31 04:26:25 Gavleborg, Sweden
1400653 2021-03-29 Sweden Gavleborg     27019 518 0 26501 61.3012 16.1534 2021-03-30 04:26:23 Gavleborg, Sweden
1625056 2021-03-28 Sweden Gavleborg     27019 518 0 26501 61.3012 16.1534 2021-03-29 04:28:35 Gavleborg, Sweden
1472486 2021-03-27 Sweden Gavleborg     27019 518 0 26501 61.3012 16.1534 2021-03-28 05:28:10 Gavleborg, Sweden
721033 2021-03-26 Sweden Gavleborg     27019 518 0 26501 61.3012 16.1534 2021-03-27 05:25:04 Gavleborg, Sweden
1617652 2021-03-25 Sweden Gavleborg     26794 517 0 26277 61.3012 16.1534 2021-03-26 05:26:55 Gavleborg, Sweden
470313 2021-03-24 Sweden Gavleborg     26542 517 0 26025 61.3012 16.1534 2021-03-25 05:27:00 Gavleborg, Sweden
1585353 2021-03-23 Sweden Gavleborg     26237 513 0 25724 61.3012 16.1534 2021-03-24 05:25:40 Gavleborg, Sweden
717047 2021-03-22 Sweden Gavleborg     25545 510 0 25035 61.3012 16.1534 2021-03-23 05:26:18 Gavleborg, Sweden
1675315 2021-03-21 Sweden Gavleborg     25545 510 0 25035 61.3012 16.1534 2021-03-22 05:25:43 Gavleborg, Sweden
1747254 2021-03-20 Sweden Gavleborg     25545 510 0 25035 61.3012 16.1534 2021-03-21 05:25:44 Gavleborg, Sweden
230376 2021-03-19 Sweden Gavleborg     25545 510 0 25035 61.3012 16.1534 2021-03-20 05:25:46 Gavleborg, Sweden
478311 2021-03-18 Sweden Gavleborg     25258 509 0 24749 61.3012 16.1534 2021-03-19 05:26:09 Gavleborg, Sweden
1426906 2021-03-17 Sweden Gavleborg     25045 509 0 24536 61.3012 16.1534 2021-03-18 05:26:22 Gavleborg, Sweden
1593494 2021-03-16 Sweden Gavleborg     24745 508 0 24237 61.3012 16.1534 2021-03-17 05:25:07 Gavleborg, Sweden
1176493 2021-03-15 Sweden Gavleborg     24119 503 0 23616 61.3012 16.1534 2021-03-16 05:25:13 Gavleborg, Sweden
276178 2021-03-14 Sweden Gavleborg     24119 503 0 23616 61.3012 16.1534 2021-03-15 05:25:51 Gavleborg, Sweden
1161320 2021-03-13 Sweden Gavleborg     24119 503 0 23616 61.3012 16.1534 2021-03-14 05:25:37 Gavleborg, Sweden
22827 2021-03-12 Sweden Gavleborg     24119 503 0 23616 61.3012 16.1534 2021-03-13 05:25:15 Gavleborg, 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]);