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

View and edit SQL

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

province_or_state

  • Vasternorrland · 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
168788 2021-06-19 Sweden Vasternorrland     26791 474 0 26317 63.4276 17.7292 2021-06-20 04:21:48 Vasternorrland, Sweden
686313 2021-06-18 Sweden Vasternorrland     26791 474 0 26317 63.4276 17.7292 2021-06-19 04:22:33 Vasternorrland, Sweden
958370 2021-06-17 Sweden Vasternorrland     26791 474 0 26317 63.4276 17.7292 2021-06-18 04:22:16 Vasternorrland, Sweden
1281735 2021-06-16 Sweden Vasternorrland     26791 474 0 26317 63.4276 17.7292 2021-06-17 04:22:36 Vasternorrland, Sweden
682325 2021-06-15 Sweden Vasternorrland     26791 474 0 26317 63.4276 17.7292 2021-06-16 04:22:32 Vasternorrland, Sweden
372879 2021-06-14 Sweden Vasternorrland     26783 474 0 26309 63.4276 17.7292 2021-06-15 04:22:22 Vasternorrland, Sweden
1223695 2021-06-13 Sweden Vasternorrland     26783 474 0 26309 63.4276 17.7292 2021-06-14 04:22:46 Vasternorrland, Sweden
80976 2021-06-12 Sweden Vasternorrland     26783 474 0 26309 63.4276 17.7292 2021-06-13 04:22:44 Vasternorrland, Sweden
970279 2021-06-11 Sweden Vasternorrland     26783 474 0 26309 63.4276 17.7292 2021-06-12 04:22:22 Vasternorrland, Sweden
1438852 2021-06-10 Sweden Vasternorrland     26773 473 0 26300 63.4276 17.7292 2021-06-11 04:23:20 Vasternorrland, Sweden
1157351 2021-06-09 Sweden Vasternorrland     26761 473 0 26288 63.4276 17.7292 2021-06-10 04:23:17 Vasternorrland, Sweden
1231667 2021-06-08 Sweden Vasternorrland     26727 470 0 26257 63.4276 17.7292 2021-06-09 04:23:31 Vasternorrland, Sweden
360663 2021-06-07 Sweden Vasternorrland     26678 470 0 26208 63.4276 17.7292 2021-06-08 04:22:35 Vasternorrland, Sweden
1076291 2021-06-06 Sweden Vasternorrland     26678 470 0 26208 63.4276 17.7292 2021-06-07 04:22:51 Vasternorrland, Sweden
1613683 2021-06-05 Sweden Vasternorrland     26678 470 0 26208 63.4276 17.7292 2021-06-06 04:24:03 Vasternorrland, Sweden
1125969 2021-06-04 Sweden Vasternorrland     26678 470 0 26208 63.4276 17.7292 2021-06-05 04:23:03 Vasternorrland, Sweden
318425 2021-06-03 Sweden Vasternorrland     26653 468 0 26185 63.4276 17.7292 2021-06-04 04:23:37 Vasternorrland, Sweden
1133938 2021-06-02 Sweden Vasternorrland     26417 467 0 25950 63.4276 17.7292 2021-06-03 04:23:32 Vasternorrland, Sweden
292115 2021-06-01 Sweden Vasternorrland     26417 467 0 25950 63.4276 17.7292 2021-06-02 04:24:34 Vasternorrland, Sweden
1652066 2021-05-31 Sweden Vasternorrland     26417 467 0 25950 63.4276 17.7292 2021-06-01 04:23:09 Vasternorrland, Sweden
981294 2021-05-30 Sweden Vasternorrland     26417 467 0 25950 63.4276 17.7292 2021-05-31 03:08:59 Vasternorrland, Sweden
841675 2021-05-29 Sweden Vasternorrland     26417 467 0 25950 63.4276 17.7292 2021-05-30 04:20:55 Vasternorrland, Sweden
698247 2021-05-28 Sweden Vasternorrland     26417 467 0 25950 63.4276 17.7292 2021-05-29 04:20:41 Vasternorrland, Sweden
1369748 2021-05-27 Sweden Vasternorrland     26417 467 0 25950 63.4276 17.7292 2021-05-28 04:20:36 Vasternorrland, Sweden
1292832 2021-05-26 Sweden Vasternorrland     26369 467 0 25902 63.4276 17.7292 2021-05-27 04:20:59 Vasternorrland, Sweden
603203 2021-05-25 Sweden Vasternorrland     26311 467 0 25844 63.4276 17.7292 2021-05-26 04:20:35 Vasternorrland, Sweden
1365761 2021-05-24 Sweden Vasternorrland     26188 467 0 25721 63.4276 17.7292 2021-05-25 04:21:08 Vasternorrland, Sweden
420274 2021-05-23 Sweden Vasternorrland     26188 467 0 25721 63.4276 17.7292 2021-05-24 04:20:53 Vasternorrland, Sweden
54613 2021-05-22 Sweden Vasternorrland     26188 467 0 25721 63.4276 17.7292 2021-05-23 04:20:51 Vasternorrland, Sweden
368892 2021-05-21 Sweden Vasternorrland     26188 467 0 25721 63.4276 17.7292 2021-05-22 04:20:45 Vasternorrland, Sweden
1024691 2021-05-20 Sweden Vasternorrland     26109 466 0 25643 63.4276 17.7292 2021-05-21 04:20:43 Vasternorrland, Sweden
1679317 2021-05-19 Sweden Vasternorrland     26050 466 0 25584 63.4276 17.7292 2021-05-20 04:21:05 Vasternorrland, Sweden
65304 2021-05-18 Sweden Vasternorrland     25897 465 0 25432 63.4276 17.7292 2021-05-19 04:20:42 Vasternorrland, Sweden
1243376 2021-05-17 Sweden Vasternorrland     25725 465 0 25260 63.4276 17.7292 2021-05-18 04:20:33 Vasternorrland, Sweden
1068224 2021-05-16 Sweden Vasternorrland     25725 465 0 25260 63.4276 17.7292 2021-05-17 04:20:34 Vasternorrland, Sweden
505352 2021-05-15 Sweden Vasternorrland     25725 465 0 25260 63.4276 17.7292 2021-05-16 04:20:49 Vasternorrland, Sweden
892957 2021-05-14 Sweden Vasternorrland     25725 465 0 25260 63.4276 17.7292 2021-05-15 04:20:58 Vasternorrland, Sweden
532292 2021-05-13 Sweden Vasternorrland     25495 461 0 25034 63.4276 17.7292 2021-05-14 04:20:41 Vasternorrland, Sweden
1719579 2021-05-12 Sweden Vasternorrland     25495 461 0 25034 63.4276 17.7292 2021-05-13 04:20:51 Vasternorrland, Sweden
1723565 2021-05-11 Sweden Vasternorrland     25265 461 0 24804 63.4276 17.7292 2021-05-12 04:21:29 Vasternorrland, Sweden
1165322 2021-05-10 Sweden Vasternorrland     24914 460 0 24454 63.4276 17.7292 2021-05-11 04:20:41 Vasternorrland, Sweden
1169308 2021-05-09 Sweden Vasternorrland     24914 460 0 24454 63.4276 17.7292 2021-05-10 04:20:38 Vasternorrland, Sweden
1660095 2021-05-08 Sweden Vasternorrland     24914 460 0 24454 63.4276 17.7292 2021-05-09 04:20:35 Vasternorrland, Sweden
800193 2021-05-07 Sweden Vasternorrland     24914 460 0 24454 63.4276 17.7292 2021-05-08 04:21:04 Vasternorrland, Sweden
1219708 2021-05-06 Sweden Vasternorrland     24711 460 0 24251 63.4276 17.7292 2021-05-07 04:20:40 Vasternorrland, Sweden
416288 2021-05-05 Sweden Vasternorrland     24490 459 0 24031 63.4276 17.7292 2021-05-06 04:20:38 Vasternorrland, Sweden
674309 2021-05-04 Sweden Vasternorrland     24182 459 0 23723 63.4276 17.7292 2021-05-05 04:20:43 Vasternorrland, Sweden
1088333 2021-05-03 Sweden Vasternorrland     23802 458 0 23344 63.4276 17.7292 2021-05-04 04:20:34 Vasternorrland, Sweden
1727551 2021-05-02 Sweden Vasternorrland     23802 458 0 23344 63.4276 17.7292 2021-05-03 04:20:39 Vasternorrland, Sweden
1084347 2021-05-01 Sweden Vasternorrland     23802 458 0 23344 63.4276 17.7292 2021-05-02 04:20:48 Vasternorrland, Sweden
1388875 2021-04-30 Sweden Vasternorrland     23802 458 0 23344 63.4276 17.7292 2021-05-01 04:20:47 Vasternorrland, Sweden
38694 2021-04-29 Sweden Vasternorrland     23561 458 0 23103 63.4276 17.7292 2021-04-30 04:21:03 Vasternorrland, Sweden
12267 2021-04-28 Sweden Vasternorrland     23312 458 0 22854 63.4276 17.7292 2021-04-29 04:20:55 Vasternorrland, Sweden
853650 2021-04-27 Sweden Vasternorrland     22938 452 0 22486 63.4276 17.7292 2021-04-28 04:20:32 Vasternorrland, Sweden
1064238 2021-04-26 Sweden Vasternorrland     22467 445 0 22022 63.4276 17.7292 2021-04-27 04:20:52 Vasternorrland, Sweden
1476488 2021-04-25 Sweden Vasternorrland     22467 445 0 22022 63.4276 17.7292 2021-04-26 04:21:04 Vasternorrland, Sweden
744109 2021-04-24 Sweden Vasternorrland     22467 445 0 22022 63.4276 17.7292 2021-04-25 04:20:32 Vasternorrland, Sweden
1430908 2021-04-23 Sweden Vasternorrland     22467 445 0 22022 63.4276 17.7292 2021-04-24 04:20:38 Vasternorrland, Sweden
96737 2021-04-22 Sweden Vasternorrland     22178 445 0 21733 63.4276 17.7292 2021-04-23 04:20:52 Vasternorrland, Sweden
849664 2021-04-21 Sweden Vasternorrland     21848 439 0 21409 63.4276 17.7292 2021-04-22 04:20:53 Vasternorrland, Sweden
827282 2021-04-20 Sweden Vasternorrland     21431 437 0 20994 63.4276 17.7292 2021-04-21 04:21:14 Vasternorrland, Sweden
770993 2021-04-19 Sweden Vasternorrland     20861 437 0 20424 63.4276 17.7292 2021-04-20 04:20:41 Vasternorrland, Sweden
1416302 2021-04-18 Sweden Vasternorrland     20861 437 0 20424 63.4276 17.7292 2021-04-19 04:20:57 Vasternorrland, Sweden
985279 2021-04-17 Sweden Vasternorrland     20861 437 0 20424 63.4276 17.7292 2021-04-18 04:20:41 Vasternorrland, Sweden
238342 2021-04-16 Sweden Vasternorrland     20861 437 0 20424 63.4276 17.7292 2021-04-17 04:20:40 Vasternorrland, Sweden
580071 2021-04-15 Sweden Vasternorrland     20503 437 0 20066 63.4276 17.7292 2021-04-16 04:20:46 Vasternorrland, Sweden
1266699 2021-04-14 Sweden Vasternorrland     20222 437 0 19785 63.4276 17.7292 2021-04-15 04:20:54 Vasternorrland, Sweden
702232 2021-04-13 Sweden Vasternorrland     19862 435 0 19427 63.4276 17.7292 2021-04-14 04:20:41 Vasternorrland, Sweden
1671345 2021-04-12 Sweden Vasternorrland     19234 434 0 18800 63.4276 17.7292 2021-04-13 04:20:37 Vasternorrland, Sweden
785050 2021-04-11 Sweden Vasternorrland     19234 434 0 18800 63.4276 17.7292 2021-04-12 04:21:00 Vasternorrland, Sweden
1392861 2021-04-10 Sweden Vasternorrland     19234 434 0 18800 63.4276 17.7292 2021-04-11 04:20:56 Vasternorrland, Sweden
966292 2021-04-09 Sweden Vasternorrland     19234 434 0 18800 63.4276 17.7292 2021-04-10 04:20:59 Vasternorrland, Sweden
690296 2021-04-08 Sweden Vasternorrland     18912 432 0 18480 63.4276 17.7292 2021-04-09 04:21:13 Vasternorrland, Sweden
1277748 2021-04-07 Sweden Vasternorrland     18617 432 0 18185 63.4276 17.7292 2021-04-08 04:21:13 Vasternorrland, Sweden
88767 2021-04-06 Sweden Vasternorrland     18404 430 0 17974 63.4276 17.7292 2021-04-07 04:20:53 Vasternorrland, Sweden
123149 2021-04-05 Sweden Vasternorrland     17857 429 0 17428 63.4276 17.7292 2021-04-06 04:20:32 Vasternorrland, Sweden
73651 2021-04-04 Sweden Vasternorrland     17857 429 0 17428 63.4276 17.7292 2021-04-05 04:20:35 Vasternorrland, Sweden
792267 2021-04-03 Sweden Vasternorrland     17857 429 0 17428 63.4276 17.7292 2021-04-04 04:20:49 Vasternorrland, Sweden
1020705 2021-04-02 Sweden Vasternorrland     17857 429 0 17428 63.4276 17.7292 2021-04-03 04:20:44 Vasternorrland, Sweden
1350867 2021-04-01 Sweden Vasternorrland     17857 429 0 17428 63.4276 17.7292 2021-04-02 04:20:36 Vasternorrland, Sweden
1691253 2021-03-31 Sweden Vasternorrland     17608 428 0 17180 63.4276 17.7292 2021-04-01 04:27:05 Vasternorrland, Sweden
873622 2021-03-30 Sweden Vasternorrland     17371 427 0 16944 63.4276 17.7292 2021-03-31 04:26:25 Vasternorrland, Sweden
1400669 2021-03-29 Sweden Vasternorrland     17063 425 0 16638 63.4276 17.7292 2021-03-30 04:26:23 Vasternorrland, Sweden
1625072 2021-03-28 Sweden Vasternorrland     17063 425 0 16638 63.4276 17.7292 2021-03-29 04:28:35 Vasternorrland, Sweden
1472502 2021-03-27 Sweden Vasternorrland     17063 425 0 16638 63.4276 17.7292 2021-03-28 05:28:10 Vasternorrland, Sweden
721049 2021-03-26 Sweden Vasternorrland     17063 425 0 16638 63.4276 17.7292 2021-03-27 05:25:04 Vasternorrland, Sweden
1617668 2021-03-25 Sweden Vasternorrland     16906 424 0 16482 63.4276 17.7292 2021-03-26 05:26:55 Vasternorrland, Sweden
470329 2021-03-24 Sweden Vasternorrland     16663 424 0 16239 63.4276 17.7292 2021-03-25 05:27:00 Vasternorrland, Sweden
1585369 2021-03-23 Sweden Vasternorrland     16556 423 0 16133 63.4276 17.7292 2021-03-24 05:25:40 Vasternorrland, Sweden
717063 2021-03-22 Sweden Vasternorrland     16321 423 0 15898 63.4276 17.7292 2021-03-23 05:26:18 Vasternorrland, Sweden
1675331 2021-03-21 Sweden Vasternorrland     16321 423 0 15898 63.4276 17.7292 2021-03-22 05:25:43 Vasternorrland, Sweden
1747270 2021-03-20 Sweden Vasternorrland     16321 423 0 15898 63.4276 17.7292 2021-03-21 05:25:44 Vasternorrland, Sweden
230392 2021-03-19 Sweden Vasternorrland     16321 423 0 15898 63.4276 17.7292 2021-03-20 05:25:46 Vasternorrland, Sweden
478327 2021-03-18 Sweden Vasternorrland     16203 421 0 15782 63.4276 17.7292 2021-03-19 05:26:09 Vasternorrland, Sweden
1426922 2021-03-17 Sweden Vasternorrland     16073 421 0 15652 63.4276 17.7292 2021-03-18 05:26:22 Vasternorrland, Sweden
1593510 2021-03-16 Sweden Vasternorrland     15911 418 0 15493 63.4276 17.7292 2021-03-17 05:25:07 Vasternorrland, Sweden
1176509 2021-03-15 Sweden Vasternorrland     15738 417 0 15321 63.4276 17.7292 2021-03-16 05:25:13 Vasternorrland, Sweden
276194 2021-03-14 Sweden Vasternorrland     15738 417 0 15321 63.4276 17.7292 2021-03-15 05:25:51 Vasternorrland, Sweden
1161336 2021-03-13 Sweden Vasternorrland     15738 417 0 15321 63.4276 17.7292 2021-03-14 05:25:37 Vasternorrland, Sweden
22843 2021-03-12 Sweden Vasternorrland     15738 417 0 15321 63.4276 17.7292 2021-03-13 05:25:15 Vasternorrland, 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]);