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

View and edit SQL

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

province_or_state

  • Ostergotland · 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
223246 2021-06-14 Sweden Ostergotland     42186 633 0 41553 58.3454 15.5198 2021-06-15 04:22:22 Ostergotland, Sweden
215278 2021-06-13 Sweden Ostergotland     42186 633 0 41553 58.3454 15.5198 2021-06-14 04:22:46 Ostergotland, Sweden
281848 2021-06-12 Sweden Ostergotland     42186 633 0 41553 58.3454 15.5198 2021-06-13 04:22:44 Ostergotland, Sweden
1633947 2021-06-11 Sweden Ostergotland     42186 633 0 41553 58.3454 15.5198 2021-06-12 04:22:22 Ostergotland, Sweden
663233 2021-06-10 Sweden Ostergotland     42166 631 0 41535 58.3454 15.5198 2021-06-11 04:23:20 Ostergotland, Sweden
882337 2021-06-09 Sweden Ostergotland     42132 631 0 41501 58.3454 15.5198 2021-06-10 04:23:17 Ostergotland, Sweden
1710336 2021-06-08 Sweden Ostergotland     42109 630 0 41479 58.3454 15.5198 2021-06-09 04:23:31 Ostergotland, Sweden
1466180 2021-06-07 Sweden Ostergotland     42010 630 0 41380 58.3454 15.5198 2021-06-08 04:22:35 Ostergotland, Sweden
993947 2021-06-06 Sweden Ostergotland     42010 630 0 41380 58.3454 15.5198 2021-06-07 04:22:51 Ostergotland, Sweden
158737 2021-06-05 Sweden Ostergotland     42010 630 0 41380 58.3454 15.5198 2021-06-06 04:24:03 Ostergotland, Sweden
1516722 2021-06-04 Sweden Ostergotland     42010 630 0 41380 58.3454 15.5198 2021-06-05 04:23:03 Ostergotland, Sweden
1141033 2021-06-03 Sweden Ostergotland     41941 630 0 41311 58.3454 15.5198 2021-06-04 04:23:37 Ostergotland, Sweden
427477 2021-06-02 Sweden Ostergotland     41618 629 0 40989 58.3454 15.5198 2021-06-03 04:23:32 Ostergotland, Sweden
539984 2021-06-01 Sweden Ostergotland     41618 629 0 40989 58.3454 15.5198 2021-06-02 04:24:34 Ostergotland, Sweden
787169 2021-05-31 Sweden Ostergotland     41618 629 0 40989 58.3454 15.5198 2021-06-01 04:23:09 Ostergotland, Sweden
1330567 2021-05-30 Sweden Ostergotland     41618 629 0 40989 58.3454 15.5198 2021-05-31 03:08:59 Ostergotland, Sweden
67776 2021-05-29 Sweden Ostergotland     41618 629 0 40989 58.3454 15.5198 2021-05-30 04:20:55 Ostergotland, Sweden
195962 2021-05-28 Sweden Ostergotland     41618 629 0 40989 58.3454 15.5198 2021-05-29 04:20:41 Ostergotland, Sweden
939221 2021-05-27 Sweden Ostergotland     41618 629 0 40989 58.3454 15.5198 2021-05-28 04:20:36 Ostergotland, Sweden
1226895 2021-05-26 Sweden Ostergotland     41589 628 0 40961 58.3454 15.5198 2021-05-27 04:20:59 Ostergotland, Sweden
1338534 2021-05-25 Sweden Ostergotland     41477 622 0 40855 58.3454 15.5198 2021-05-26 04:20:35 Ostergotland, Sweden
203366 2021-05-24 Sweden Ostergotland     41154 621 0 40533 58.3454 15.5198 2021-05-25 04:21:08 Ostergotland, Sweden
99530 2021-05-23 Sweden Ostergotland     41154 621 0 40533 58.3454 15.5198 2021-05-24 04:20:53 Ostergotland, Sweden
524049 2021-05-22 Sweden Ostergotland     41154 621 0 40533 58.3454 15.5198 2021-05-23 04:20:51 Ostergotland, Sweden
859744 2021-05-21 Sweden Ostergotland     41154 621 0 40533 58.3454 15.5198 2021-05-22 04:20:45 Ostergotland, Sweden
721167 2021-05-20 Sweden Ostergotland     41030 617 0 40413 58.3454 15.5198 2021-05-21 04:20:43 Ostergotland, Sweden
408298 2021-05-19 Sweden Ostergotland     40847 617 0 40230 58.3454 15.5198 2021-05-20 04:21:05 Ostergotland, Sweden
783184 2021-05-18 Sweden Ostergotland     40731 615 0 40116 58.3454 15.5198 2021-05-19 04:20:42 Ostergotland, Sweden
1423326 2021-05-17 Sweden Ostergotland     40063 614 0 39449 58.3454 15.5198 2021-05-18 04:20:33 Ostergotland, Sweden
740512 2021-05-16 Sweden Ostergotland     40063 614 0 39449 58.3454 15.5198 2021-05-17 04:20:34 Ostergotland, Sweden
1117045 2021-05-15 Sweden Ostergotland     40063 614 0 39449 58.3454 15.5198 2021-05-16 04:20:49 Ostergotland, Sweden
1587554 2021-05-14 Sweden Ostergotland     40063 614 0 39449 58.3454 15.5198 2021-05-15 04:20:58 Ostergotland, Sweden
1675471 2021-05-13 Sweden Ostergotland     39658 614 0 39044 58.3454 15.5198 2021-05-14 04:20:41 Ostergotland, Sweden
803098 2021-05-12 Sweden Ostergotland     39658 614 0 39044 58.3454 15.5198 2021-05-13 04:20:51 Ostergotland, Sweden
1181486 2021-05-11 Sweden Ostergotland     39283 614 0 38669 58.3454 15.5198 2021-05-12 04:21:29 Ostergotland, Sweden
325276 2021-05-10 Sweden Ostergotland     38463 613 0 37850 58.3454 15.5198 2021-05-11 04:20:41 Ostergotland, Sweden
604423 2021-05-09 Sweden Ostergotland     38463 613 0 37850 58.3454 15.5198 2021-05-10 04:20:38 Ostergotland, Sweden
986170 2021-05-08 Sweden Ostergotland     38463 613 0 37850 58.3454 15.5198 2021-05-09 04:20:35 Ostergotland, Sweden
434652 2021-05-07 Sweden Ostergotland     38463 613 0 37850 58.3454 15.5198 2021-05-08 04:21:04 Ostergotland, Sweden
901433 2021-05-06 Sweden Ostergotland     38121 611 0 37510 58.3454 15.5198 2021-05-07 04:20:40 Ostergotland, Sweden
71759 2021-05-05 Sweden Ostergotland     37810 611 0 37199 58.3454 15.5198 2021-05-06 04:20:38 Ostergotland, Sweden
791152 2021-05-04 Sweden Ostergotland     37515 605 0 36910 58.3454 15.5198 2021-05-05 04:20:43 Ostergotland, Sweden
1613682 2021-05-03 Sweden Ostergotland     36292 605 0 35687 58.3454 15.5198 2021-05-04 04:20:34 Ostergotland, Sweden
886320 2021-05-02 Sweden Ostergotland     36292 605 0 35687 58.3454 15.5198 2021-05-03 04:20:39 Ostergotland, Sweden
512025 2021-05-01 Sweden Ostergotland     36292 605 0 35687 58.3454 15.5198 2021-05-02 04:20:48 Ostergotland, Sweden
14961 2021-04-30 Sweden Ostergotland     36292 605 0 35687 58.3454 15.5198 2021-05-01 04:20:47 Ostergotland, Sweden
1125065 2021-04-29 Sweden Ostergotland     35971 604 0 35367 58.3454 15.5198 2021-04-30 04:21:03 Ostergotland, Sweden
462362 2021-04-28 Sweden Ostergotland     35581 604 0 34977 58.3454 15.5198 2021-04-29 04:20:55 Ostergotland, Sweden
1315068 2021-04-27 Sweden Ostergotland     35358 599 0 34759 58.3454 15.5198 2021-04-28 04:20:32 Ostergotland, Sweden
1549495 2021-04-26 Sweden Ostergotland     34320 599 0 33721 58.3454 15.5198 2021-04-27 04:20:52 Ostergotland, Sweden
1629962 2021-04-25 Sweden Ostergotland     34320 599 0 33721 58.3454 15.5198 2021-04-26 04:21:04 Ostergotland, Sweden
354102 2021-04-24 Sweden Ostergotland     34320 599 0 33721 58.3454 15.5198 2021-04-25 04:20:32 Ostergotland, Sweden
725151 2021-04-23 Sweden Ostergotland     34320 599 0 33721 58.3454 15.5198 2021-04-24 04:20:38 Ostergotland, Sweden
1470163 2021-04-22 Sweden Ostergotland     33944 595 0 33349 58.3454 15.5198 2021-04-23 04:20:52 Ostergotland, Sweden
1222911 2021-04-21 Sweden Ostergotland     33566 595 0 32971 58.3454 15.5198 2021-04-22 04:20:53 Ostergotland, Sweden
458378 2021-04-20 Sweden Ostergotland     33227 594 0 32633 58.3454 15.5198 2021-04-21 04:21:14 Ostergotland, Sweden
1300566 2021-04-19 Sweden Ostergotland     31885 593 0 31292 58.3454 15.5198 2021-04-20 04:20:41 Ostergotland, Sweden
1070145 2021-04-18 Sweden Ostergotland     31885 593 0 31292 58.3454 15.5198 2021-04-19 04:20:57 Ostergotland, Sweden
1046027 2021-04-17 Sweden Ostergotland     31885 593 0 31292 58.3454 15.5198 2021-04-18 04:20:41 Ostergotland, Sweden
597303 2021-04-16 Sweden Ostergotland     31885 593 0 31292 58.3454 15.5198 2021-04-17 04:20:40 Ostergotland, Sweden
1621719 2021-04-15 Sweden Ostergotland     31501 590 0 30911 58.3454 15.5198 2021-04-16 04:20:46 Ostergotland, Sweden
951150 2021-04-14 Sweden Ostergotland     31135 590 0 30545 58.3454 15.5198 2021-04-15 04:20:54 Ostergotland, Sweden
593319 2021-04-13 Sweden Ostergotland     30906 584 0 30322 58.3454 15.5198 2021-04-14 04:20:41 Ostergotland, Sweden
33258 2021-04-12 Sweden Ostergotland     30113 583 0 29530 58.3454 15.5198 2021-04-13 04:20:37 Ostergotland, Sweden
1372273 2021-04-11 Sweden Ostergotland     30113 583 0 29530 58.3454 15.5198 2021-04-12 04:21:00 Ostergotland, Sweden
1667525 2021-04-10 Sweden Ostergotland     30113 583 0 29530 58.3454 15.5198 2021-04-11 04:20:56 Ostergotland, Sweden
1160141 2021-04-09 Sweden Ostergotland     30113 583 0 29530 58.3454 15.5198 2021-04-10 04:20:59 Ostergotland, Sweden
1057976 2021-04-08 Sweden Ostergotland     29913 581 0 29332 58.3454 15.5198 2021-04-09 04:21:13 Ostergotland, Sweden
1500765 2021-04-07 Sweden Ostergotland     29693 581 0 29112 58.3454 15.5198 2021-04-08 04:21:13 Ostergotland, Sweden
1207970 2021-04-06 Sweden Ostergotland     29493 578 0 28915 58.3454 15.5198 2021-04-07 04:20:53 Ostergotland, Sweden
123271 2021-04-05 Sweden Ostergotland     28385 577 0 27808 58.3454 15.5198 2021-04-06 04:20:32 Ostergotland, Sweden
1255072 2021-04-04 Sweden Ostergotland     28385 577 0 27808 58.3454 15.5198 2021-04-05 04:20:35 Ostergotland, Sweden
1129049 2021-04-03 Sweden Ostergotland     28385 577 0 27808 58.3454 15.5198 2021-04-04 04:20:49 Ostergotland, Sweden
270440 2021-04-02 Sweden Ostergotland     28385 577 0 27808 58.3454 15.5198 2021-04-03 04:20:44 Ostergotland, Sweden
1173772 2021-04-01 Sweden Ostergotland     28385 577 0 27808 58.3454 15.5198 2021-04-02 04:20:36 Ostergotland, Sweden
516083 2021-03-31 Sweden Ostergotland     28154 576 0 27578 58.3454 15.5198 2021-04-01 04:27:05 Ostergotland, Sweden
289812 2021-03-30 Sweden Ostergotland     27933 575 0 27358 58.3454 15.5198 2021-03-31 04:26:25 Ostergotland, Sweden
1575349 2021-03-29 Sweden Ostergotland     27066 573 0 26493 58.3454 15.5198 2021-03-30 04:26:23 Ostergotland, Sweden
631626 2021-03-28 Sweden Ostergotland     27066 573 0 26493 58.3454 15.5198 2021-03-29 04:28:35 Ostergotland, Sweden
608407 2021-03-27 Sweden Ostergotland     27066 573 0 26493 58.3454 15.5198 2021-03-28 05:28:10 Ostergotland, Sweden
1334550 2021-03-26 Sweden Ostergotland     27066 573 0 26493 58.3454 15.5198 2021-03-27 05:25:04 Ostergotland, Sweden
150989 2021-03-25 Sweden Ostergotland     26815 573 0 26242 58.3454 15.5198 2021-03-26 05:26:55 Ostergotland, Sweden
1598510 2021-03-24 Sweden Ostergotland     26688 573 0 26115 58.3454 15.5198 2021-03-25 05:27:00 Ostergotland, Sweden
404314 2021-03-23 Sweden Ostergotland     26492 571 0 25921 58.3454 15.5198 2021-03-24 05:25:40 Ostergotland, Sweden
1387851 2021-03-22 Sweden Ostergotland     25883 572 0 25311 58.3454 15.5198 2021-03-23 05:26:18 Ostergotland, Sweden
305338 2021-03-21 Sweden Ostergotland     25883 572 0 25311 58.3454 15.5198 2021-03-22 05:25:43 Ostergotland, Sweden
254387 2021-03-20 Sweden Ostergotland     25883 572 0 25311 58.3454 15.5198 2021-03-21 05:25:44 Ostergotland, Sweden
1231143 2021-03-19 Sweden Ostergotland     25883 572 0 25311 58.3454 15.5198 2021-03-20 05:25:46 Ostergotland, Sweden
975068 2021-03-18 Sweden Ostergotland     25677 570 0 25107 58.3454 15.5198 2021-03-19 05:26:09 Ostergotland, Sweden
1532703 2021-03-17 Sweden Ostergotland     25523 570 0 24953 58.3454 15.5198 2021-03-18 05:26:22 Ostergotland, Sweden
55897 2021-03-16 Sweden Ostergotland     25327 570 0 24757 58.3454 15.5198 2021-03-17 05:25:07 Ostergotland, Sweden
563210 2021-03-15 Sweden Ostergotland     24740 570 0 24170 58.3454 15.5198 2021-03-16 05:25:13 Ostergotland, Sweden
851779 2021-03-14 Sweden Ostergotland     24740 570 0 24170 58.3454 15.5198 2021-03-15 05:25:51 Ostergotland, Sweden
943204 2021-03-13 Sweden Ostergotland     24740 570 0 24170 58.3454 15.5198 2021-03-14 05:25:37 Ostergotland, Sweden
1311084 2021-03-12 Sweden Ostergotland     24740 570 0 24170 58.3454 15.5198 2021-03-13 05:25:15 Ostergotland, Sweden
1077922 2021-03-11 Sweden Ostergotland     24625 567 0 24058 58.3454 15.5198 2021-03-12 05:26:50 Ostergotland, Sweden
955134 2021-03-10 Sweden Ostergotland     24470 566 0 23904 58.3454 15.5198 2021-03-11 05:25:48 Ostergotland, Sweden
543967 2021-03-09 Sweden Ostergotland     24333 561 0 23772 58.3454 15.5198 2021-03-10 05:24:35 Ostergotland, Sweden
1520705 2021-03-08 Sweden Ostergotland     23788 560 0 23228 58.3454 15.5198 2021-03-09 05:28:19 Ostergotland, Sweden
866986 2021-03-07 Sweden Ostergotland     23788 560 0 23228 58.3454 15.5198 2021-03-08 05:24:48 Ostergotland, 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]);