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

View and edit SQL

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

province_or_state

  • Norrbotten · 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
223244 2021-06-14 Sweden Norrbotten     25706 270 0 25436 66.8309 20.3992 2021-06-15 04:22:22 Norrbotten, Sweden
215276 2021-06-13 Sweden Norrbotten     25706 270 0 25436 66.8309 20.3992 2021-06-14 04:22:46 Norrbotten, Sweden
281846 2021-06-12 Sweden Norrbotten     25706 270 0 25436 66.8309 20.3992 2021-06-13 04:22:44 Norrbotten, Sweden
1633945 2021-06-11 Sweden Norrbotten     25706 270 0 25436 66.8309 20.3992 2021-06-12 04:22:22 Norrbotten, Sweden
663231 2021-06-10 Sweden Norrbotten     25647 270 0 25377 66.8309 20.3992 2021-06-11 04:23:20 Norrbotten, Sweden
882335 2021-06-09 Sweden Norrbotten     25571 270 0 25301 66.8309 20.3992 2021-06-10 04:23:17 Norrbotten, Sweden
1710334 2021-06-08 Sweden Norrbotten     25483 269 0 25214 66.8309 20.3992 2021-06-09 04:23:31 Norrbotten, Sweden
1466178 2021-06-07 Sweden Norrbotten     25043 269 0 24774 66.8309 20.3992 2021-06-08 04:22:35 Norrbotten, Sweden
993945 2021-06-06 Sweden Norrbotten     25043 269 0 24774 66.8309 20.3992 2021-06-07 04:22:51 Norrbotten, Sweden
158735 2021-06-05 Sweden Norrbotten     25043 269 0 24774 66.8309 20.3992 2021-06-06 04:24:03 Norrbotten, Sweden
1516720 2021-06-04 Sweden Norrbotten     25043 269 0 24774 66.8309 20.3992 2021-06-05 04:23:03 Norrbotten, Sweden
1141031 2021-06-03 Sweden Norrbotten     24958 267 0 24691 66.8309 20.3992 2021-06-04 04:23:37 Norrbotten, Sweden
427475 2021-06-02 Sweden Norrbotten     24556 264 0 24292 66.8309 20.3992 2021-06-03 04:23:32 Norrbotten, Sweden
539982 2021-06-01 Sweden Norrbotten     24556 264 0 24292 66.8309 20.3992 2021-06-02 04:24:34 Norrbotten, Sweden
787167 2021-05-31 Sweden Norrbotten     24556 264 0 24292 66.8309 20.3992 2021-06-01 04:23:09 Norrbotten, Sweden
1330565 2021-05-30 Sweden Norrbotten     24556 264 0 24292 66.8309 20.3992 2021-05-31 03:08:59 Norrbotten, Sweden
67774 2021-05-29 Sweden Norrbotten     24556 264 0 24292 66.8309 20.3992 2021-05-30 04:20:55 Norrbotten, Sweden
195960 2021-05-28 Sweden Norrbotten     24556 264 0 24292 66.8309 20.3992 2021-05-29 04:20:41 Norrbotten, Sweden
939219 2021-05-27 Sweden Norrbotten     24556 264 0 24292 66.8309 20.3992 2021-05-28 04:20:36 Norrbotten, Sweden
1226893 2021-05-26 Sweden Norrbotten     24512 264 0 24248 66.8309 20.3992 2021-05-27 04:20:59 Norrbotten, Sweden
1338532 2021-05-25 Sweden Norrbotten     24306 261 0 24045 66.8309 20.3992 2021-05-26 04:20:35 Norrbotten, Sweden
203364 2021-05-24 Sweden Norrbotten     23913 261 0 23652 66.8309 20.3992 2021-05-25 04:21:08 Norrbotten, Sweden
99528 2021-05-23 Sweden Norrbotten     23913 261 0 23652 66.8309 20.3992 2021-05-24 04:20:53 Norrbotten, Sweden
524047 2021-05-22 Sweden Norrbotten     23913 261 0 23652 66.8309 20.3992 2021-05-23 04:20:51 Norrbotten, Sweden
859742 2021-05-21 Sweden Norrbotten     23913 261 0 23652 66.8309 20.3992 2021-05-22 04:20:45 Norrbotten, Sweden
721165 2021-05-20 Sweden Norrbotten     23699 261 0 23438 66.8309 20.3992 2021-05-21 04:20:43 Norrbotten, Sweden
408296 2021-05-19 Sweden Norrbotten     23456 261 0 23195 66.8309 20.3992 2021-05-20 04:21:05 Norrbotten, Sweden
783182 2021-05-18 Sweden Norrbotten     23270 257 0 23013 66.8309 20.3992 2021-05-19 04:20:42 Norrbotten, Sweden
1423324 2021-05-17 Sweden Norrbotten     23011 257 0 22754 66.8309 20.3992 2021-05-18 04:20:33 Norrbotten, Sweden
740510 2021-05-16 Sweden Norrbotten     23011 257 0 22754 66.8309 20.3992 2021-05-17 04:20:34 Norrbotten, Sweden
1117043 2021-05-15 Sweden Norrbotten     23011 257 0 22754 66.8309 20.3992 2021-05-16 04:20:49 Norrbotten, Sweden
1587552 2021-05-14 Sweden Norrbotten     23011 257 0 22754 66.8309 20.3992 2021-05-15 04:20:58 Norrbotten, Sweden
1675469 2021-05-13 Sweden Norrbotten     22433 257 0 22176 66.8309 20.3992 2021-05-14 04:20:41 Norrbotten, Sweden
803096 2021-05-12 Sweden Norrbotten     22433 257 0 22176 66.8309 20.3992 2021-05-13 04:20:51 Norrbotten, Sweden
1181484 2021-05-11 Sweden Norrbotten     22277 255 0 22022 66.8309 20.3992 2021-05-12 04:21:29 Norrbotten, Sweden
325274 2021-05-10 Sweden Norrbotten     21918 255 0 21663 66.8309 20.3992 2021-05-11 04:20:41 Norrbotten, Sweden
604421 2021-05-09 Sweden Norrbotten     21918 255 0 21663 66.8309 20.3992 2021-05-10 04:20:38 Norrbotten, Sweden
986168 2021-05-08 Sweden Norrbotten     21918 255 0 21663 66.8309 20.3992 2021-05-09 04:20:35 Norrbotten, Sweden
434650 2021-05-07 Sweden Norrbotten     21918 255 0 21663 66.8309 20.3992 2021-05-08 04:21:04 Norrbotten, Sweden
901431 2021-05-06 Sweden Norrbotten     21687 255 0 21432 66.8309 20.3992 2021-05-07 04:20:40 Norrbotten, Sweden
71757 2021-05-05 Sweden Norrbotten     21507 255 0 21252 66.8309 20.3992 2021-05-06 04:20:38 Norrbotten, Sweden
791150 2021-05-04 Sweden Norrbotten     21302 252 0 21050 66.8309 20.3992 2021-05-05 04:20:43 Norrbotten, Sweden
1613680 2021-05-03 Sweden Norrbotten     20822 251 0 20571 66.8309 20.3992 2021-05-04 04:20:34 Norrbotten, Sweden
886318 2021-05-02 Sweden Norrbotten     20822 251 0 20571 66.8309 20.3992 2021-05-03 04:20:39 Norrbotten, Sweden
512023 2021-05-01 Sweden Norrbotten     20822 251 0 20571 66.8309 20.3992 2021-05-02 04:20:48 Norrbotten, Sweden
14959 2021-04-30 Sweden Norrbotten     20822 251 0 20571 66.8309 20.3992 2021-05-01 04:20:47 Norrbotten, Sweden
1125063 2021-04-29 Sweden Norrbotten     20573 249 0 20324 66.8309 20.3992 2021-04-30 04:21:03 Norrbotten, Sweden
462360 2021-04-28 Sweden Norrbotten     20429 249 0 20180 66.8309 20.3992 2021-04-29 04:20:55 Norrbotten, Sweden
1315066 2021-04-27 Sweden Norrbotten     20330 248 0 20082 66.8309 20.3992 2021-04-28 04:20:32 Norrbotten, Sweden
1549493 2021-04-26 Sweden Norrbotten     19953 248 0 19705 66.8309 20.3992 2021-04-27 04:20:52 Norrbotten, Sweden
1629960 2021-04-25 Sweden Norrbotten     19953 248 0 19705 66.8309 20.3992 2021-04-26 04:21:04 Norrbotten, Sweden
354100 2021-04-24 Sweden Norrbotten     19953 248 0 19705 66.8309 20.3992 2021-04-25 04:20:32 Norrbotten, Sweden
725149 2021-04-23 Sweden Norrbotten     19953 248 0 19705 66.8309 20.3992 2021-04-24 04:20:38 Norrbotten, Sweden
1470161 2021-04-22 Sweden Norrbotten     19835 248 0 19587 66.8309 20.3992 2021-04-23 04:20:52 Norrbotten, Sweden
1222909 2021-04-21 Sweden Norrbotten     19680 248 0 19432 66.8309 20.3992 2021-04-22 04:20:53 Norrbotten, Sweden
458376 2021-04-20 Sweden Norrbotten     19467 248 0 19219 66.8309 20.3992 2021-04-21 04:21:14 Norrbotten, Sweden
1300564 2021-04-19 Sweden Norrbotten     18992 248 0 18744 66.8309 20.3992 2021-04-20 04:20:41 Norrbotten, Sweden
1070143 2021-04-18 Sweden Norrbotten     18992 248 0 18744 66.8309 20.3992 2021-04-19 04:20:57 Norrbotten, Sweden
1046025 2021-04-17 Sweden Norrbotten     18992 248 0 18744 66.8309 20.3992 2021-04-18 04:20:41 Norrbotten, Sweden
597301 2021-04-16 Sweden Norrbotten     18992 248 0 18744 66.8309 20.3992 2021-04-17 04:20:40 Norrbotten, Sweden
1621717 2021-04-15 Sweden Norrbotten     18810 247 0 18563 66.8309 20.3992 2021-04-16 04:20:46 Norrbotten, Sweden
951148 2021-04-14 Sweden Norrbotten     18654 247 0 18407 66.8309 20.3992 2021-04-15 04:20:54 Norrbotten, Sweden
593317 2021-04-13 Sweden Norrbotten     18386 245 0 18141 66.8309 20.3992 2021-04-14 04:20:41 Norrbotten, Sweden
33256 2021-04-12 Sweden Norrbotten     17728 244 0 17484 66.8309 20.3992 2021-04-13 04:20:37 Norrbotten, Sweden
1372271 2021-04-11 Sweden Norrbotten     17728 244 0 17484 66.8309 20.3992 2021-04-12 04:21:00 Norrbotten, Sweden
1667523 2021-04-10 Sweden Norrbotten     17728 244 0 17484 66.8309 20.3992 2021-04-11 04:20:56 Norrbotten, Sweden
1160139 2021-04-09 Sweden Norrbotten     17728 244 0 17484 66.8309 20.3992 2021-04-10 04:20:59 Norrbotten, Sweden
1057974 2021-04-08 Sweden Norrbotten     17545 242 0 17303 66.8309 20.3992 2021-04-09 04:21:13 Norrbotten, Sweden
1500763 2021-04-07 Sweden Norrbotten     17331 242 0 17089 66.8309 20.3992 2021-04-08 04:21:13 Norrbotten, Sweden
1207968 2021-04-06 Sweden Norrbotten     17242 238 0 17004 66.8309 20.3992 2021-04-07 04:20:53 Norrbotten, Sweden
123269 2021-04-05 Sweden Norrbotten     16564 238 0 16326 66.8309 20.3992 2021-04-06 04:20:32 Norrbotten, Sweden
1255070 2021-04-04 Sweden Norrbotten     16564 238 0 16326 66.8309 20.3992 2021-04-05 04:20:35 Norrbotten, Sweden
1129047 2021-04-03 Sweden Norrbotten     16564 238 0 16326 66.8309 20.3992 2021-04-04 04:20:49 Norrbotten, Sweden
270438 2021-04-02 Sweden Norrbotten     16564 238 0 16326 66.8309 20.3992 2021-04-03 04:20:44 Norrbotten, Sweden
1173770 2021-04-01 Sweden Norrbotten     16564 238 0 16326 66.8309 20.3992 2021-04-02 04:20:36 Norrbotten, Sweden
516081 2021-03-31 Sweden Norrbotten     16375 238 0 16137 66.8309 20.3992 2021-04-01 04:27:05 Norrbotten, Sweden
289810 2021-03-30 Sweden Norrbotten     16276 236 0 16040 66.8309 20.3992 2021-03-31 04:26:25 Norrbotten, Sweden
1575347 2021-03-29 Sweden Norrbotten     15913 236 0 15677 66.8309 20.3992 2021-03-30 04:26:23 Norrbotten, Sweden
631624 2021-03-28 Sweden Norrbotten     15913 236 0 15677 66.8309 20.3992 2021-03-29 04:28:35 Norrbotten, Sweden
608405 2021-03-27 Sweden Norrbotten     15913 236 0 15677 66.8309 20.3992 2021-03-28 05:28:10 Norrbotten, Sweden
1334548 2021-03-26 Sweden Norrbotten     15913 236 0 15677 66.8309 20.3992 2021-03-27 05:25:04 Norrbotten, Sweden
150987 2021-03-25 Sweden Norrbotten     15816 236 0 15580 66.8309 20.3992 2021-03-26 05:26:55 Norrbotten, Sweden
1598508 2021-03-24 Sweden Norrbotten     15713 236 0 15477 66.8309 20.3992 2021-03-25 05:27:00 Norrbotten, Sweden
404312 2021-03-23 Sweden Norrbotten     15622 234 0 15388 66.8309 20.3992 2021-03-24 05:25:40 Norrbotten, Sweden
1387849 2021-03-22 Sweden Norrbotten     15211 234 0 14977 66.8309 20.3992 2021-03-23 05:26:18 Norrbotten, Sweden
305336 2021-03-21 Sweden Norrbotten     15211 234 0 14977 66.8309 20.3992 2021-03-22 05:25:43 Norrbotten, Sweden
254385 2021-03-20 Sweden Norrbotten     15211 234 0 14977 66.8309 20.3992 2021-03-21 05:25:44 Norrbotten, Sweden
1231141 2021-03-19 Sweden Norrbotten     15211 234 0 14977 66.8309 20.3992 2021-03-20 05:25:46 Norrbotten, Sweden
975066 2021-03-18 Sweden Norrbotten     14936 233 0 14703 66.8309 20.3992 2021-03-19 05:26:09 Norrbotten, Sweden
1532701 2021-03-17 Sweden Norrbotten     14669 233 0 14436 66.8309 20.3992 2021-03-18 05:26:22 Norrbotten, Sweden
55895 2021-03-16 Sweden Norrbotten     14610 228 0 14382 66.8309 20.3992 2021-03-17 05:25:07 Norrbotten, Sweden
563208 2021-03-15 Sweden Norrbotten     14369 228 0 14141 66.8309 20.3992 2021-03-16 05:25:13 Norrbotten, Sweden
851777 2021-03-14 Sweden Norrbotten     14369 228 0 14141 66.8309 20.3992 2021-03-15 05:25:51 Norrbotten, Sweden
943202 2021-03-13 Sweden Norrbotten     14369 228 0 14141 66.8309 20.3992 2021-03-14 05:25:37 Norrbotten, Sweden
1311082 2021-03-12 Sweden Norrbotten     14369 228 0 14141 66.8309 20.3992 2021-03-13 05:25:15 Norrbotten, Sweden
1077920 2021-03-11 Sweden Norrbotten     14226 228 0 13998 66.8309 20.3992 2021-03-12 05:26:50 Norrbotten, Sweden
955132 2021-03-10 Sweden Norrbotten     14055 228 0 13827 66.8309 20.3992 2021-03-11 05:25:48 Norrbotten, Sweden
543965 2021-03-09 Sweden Norrbotten     13944 224 0 13720 66.8309 20.3992 2021-03-10 05:24:35 Norrbotten, Sweden
1520703 2021-03-08 Sweden Norrbotten     13469 224 0 13245 66.8309 20.3992 2021-03-09 05:28:19 Norrbotten, Sweden
866984 2021-03-07 Sweden Norrbotten     13469 224 0 13245 66.8309 20.3992 2021-03-08 05:24:48 Norrbotten, 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]);