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

View and edit SQL

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

province_or_state

  • Varmland · 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
223251 2021-06-14 Sweden Varmland     19347 212 0 19135 59.7294 13.2354 2021-06-15 04:22:22 Varmland, Sweden
215283 2021-06-13 Sweden Varmland     19347 212 0 19135 59.7294 13.2354 2021-06-14 04:22:46 Varmland, Sweden
281853 2021-06-12 Sweden Varmland     19347 212 0 19135 59.7294 13.2354 2021-06-13 04:22:44 Varmland, Sweden
1633952 2021-06-11 Sweden Varmland     19347 212 0 19135 59.7294 13.2354 2021-06-12 04:22:22 Varmland, Sweden
663238 2021-06-10 Sweden Varmland     19270 212 0 19058 59.7294 13.2354 2021-06-11 04:23:20 Varmland, Sweden
882342 2021-06-09 Sweden Varmland     19183 212 0 18971 59.7294 13.2354 2021-06-10 04:23:17 Varmland, Sweden
1710341 2021-06-08 Sweden Varmland     19069 211 0 18858 59.7294 13.2354 2021-06-09 04:23:31 Varmland, Sweden
1466185 2021-06-07 Sweden Varmland     18864 211 0 18653 59.7294 13.2354 2021-06-08 04:22:35 Varmland, Sweden
993952 2021-06-06 Sweden Varmland     18864 211 0 18653 59.7294 13.2354 2021-06-07 04:22:51 Varmland, Sweden
158742 2021-06-05 Sweden Varmland     18864 211 0 18653 59.7294 13.2354 2021-06-06 04:24:03 Varmland, Sweden
1516727 2021-06-04 Sweden Varmland     18864 211 0 18653 59.7294 13.2354 2021-06-05 04:23:03 Varmland, Sweden
1141038 2021-06-03 Sweden Varmland     18787 211 0 18576 59.7294 13.2354 2021-06-04 04:23:37 Varmland, Sweden
427482 2021-06-02 Sweden Varmland     18454 210 0 18244 59.7294 13.2354 2021-06-03 04:23:32 Varmland, Sweden
539989 2021-06-01 Sweden Varmland     18454 210 0 18244 59.7294 13.2354 2021-06-02 04:24:34 Varmland, Sweden
787174 2021-05-31 Sweden Varmland     18454 210 0 18244 59.7294 13.2354 2021-06-01 04:23:09 Varmland, Sweden
1330572 2021-05-30 Sweden Varmland     18454 210 0 18244 59.7294 13.2354 2021-05-31 03:08:59 Varmland, Sweden
67781 2021-05-29 Sweden Varmland     18454 210 0 18244 59.7294 13.2354 2021-05-30 04:20:55 Varmland, Sweden
195967 2021-05-28 Sweden Varmland     18454 210 0 18244 59.7294 13.2354 2021-05-29 04:20:41 Varmland, Sweden
939226 2021-05-27 Sweden Varmland     18454 210 0 18244 59.7294 13.2354 2021-05-28 04:20:36 Varmland, Sweden
1226900 2021-05-26 Sweden Varmland     18434 210 0 18224 59.7294 13.2354 2021-05-27 04:20:59 Varmland, Sweden
1338539 2021-05-25 Sweden Varmland     18373 210 0 18163 59.7294 13.2354 2021-05-26 04:20:35 Varmland, Sweden
203371 2021-05-24 Sweden Varmland     18265 209 0 18056 59.7294 13.2354 2021-05-25 04:21:08 Varmland, Sweden
99535 2021-05-23 Sweden Varmland     18265 209 0 18056 59.7294 13.2354 2021-05-24 04:20:53 Varmland, Sweden
524054 2021-05-22 Sweden Varmland     18265 209 0 18056 59.7294 13.2354 2021-05-23 04:20:51 Varmland, Sweden
859749 2021-05-21 Sweden Varmland     18265 209 0 18056 59.7294 13.2354 2021-05-22 04:20:45 Varmland, Sweden
721172 2021-05-20 Sweden Varmland     18212 209 0 18003 59.7294 13.2354 2021-05-21 04:20:43 Varmland, Sweden
408303 2021-05-19 Sweden Varmland     18152 209 0 17943 59.7294 13.2354 2021-05-20 04:21:05 Varmland, Sweden
783189 2021-05-18 Sweden Varmland     18066 208 0 17858 59.7294 13.2354 2021-05-19 04:20:42 Varmland, Sweden
1423331 2021-05-17 Sweden Varmland     17932 206 0 17726 59.7294 13.2354 2021-05-18 04:20:33 Varmland, Sweden
740517 2021-05-16 Sweden Varmland     17932 206 0 17726 59.7294 13.2354 2021-05-17 04:20:34 Varmland, Sweden
1117050 2021-05-15 Sweden Varmland     17932 206 0 17726 59.7294 13.2354 2021-05-16 04:20:49 Varmland, Sweden
1587559 2021-05-14 Sweden Varmland     17932 206 0 17726 59.7294 13.2354 2021-05-15 04:20:58 Varmland, Sweden
1675476 2021-05-13 Sweden Varmland     17785 204 0 17581 59.7294 13.2354 2021-05-14 04:20:41 Varmland, Sweden
803103 2021-05-12 Sweden Varmland     17785 204 0 17581 59.7294 13.2354 2021-05-13 04:20:51 Varmland, Sweden
1181491 2021-05-11 Sweden Varmland     17658 202 0 17456 59.7294 13.2354 2021-05-12 04:21:29 Varmland, Sweden
325281 2021-05-10 Sweden Varmland     17425 200 0 17225 59.7294 13.2354 2021-05-11 04:20:41 Varmland, Sweden
604428 2021-05-09 Sweden Varmland     17425 200 0 17225 59.7294 13.2354 2021-05-10 04:20:38 Varmland, Sweden
986175 2021-05-08 Sweden Varmland     17425 200 0 17225 59.7294 13.2354 2021-05-09 04:20:35 Varmland, Sweden
434657 2021-05-07 Sweden Varmland     17425 200 0 17225 59.7294 13.2354 2021-05-08 04:21:04 Varmland, Sweden
901438 2021-05-06 Sweden Varmland     17315 200 0 17115 59.7294 13.2354 2021-05-07 04:20:40 Varmland, Sweden
71764 2021-05-05 Sweden Varmland     17222 199 0 17023 59.7294 13.2354 2021-05-06 04:20:38 Varmland, Sweden
791157 2021-05-04 Sweden Varmland     17067 199 0 16868 59.7294 13.2354 2021-05-05 04:20:43 Varmland, Sweden
1613687 2021-05-03 Sweden Varmland     16697 198 0 16499 59.7294 13.2354 2021-05-04 04:20:34 Varmland, Sweden
886325 2021-05-02 Sweden Varmland     16697 198 0 16499 59.7294 13.2354 2021-05-03 04:20:39 Varmland, Sweden
512030 2021-05-01 Sweden Varmland     16697 198 0 16499 59.7294 13.2354 2021-05-02 04:20:48 Varmland, Sweden
14966 2021-04-30 Sweden Varmland     16697 198 0 16499 59.7294 13.2354 2021-05-01 04:20:47 Varmland, Sweden
1125070 2021-04-29 Sweden Varmland     16556 197 0 16359 59.7294 13.2354 2021-04-30 04:21:03 Varmland, Sweden
462367 2021-04-28 Sweden Varmland     16425 197 0 16228 59.7294 13.2354 2021-04-29 04:20:55 Varmland, Sweden
1315073 2021-04-27 Sweden Varmland     16173 197 0 15976 59.7294 13.2354 2021-04-28 04:20:32 Varmland, Sweden
1549500 2021-04-26 Sweden Varmland     15797 196 0 15601 59.7294 13.2354 2021-04-27 04:20:52 Varmland, Sweden
1629967 2021-04-25 Sweden Varmland     15797 196 0 15601 59.7294 13.2354 2021-04-26 04:21:04 Varmland, Sweden
354107 2021-04-24 Sweden Varmland     15797 196 0 15601 59.7294 13.2354 2021-04-25 04:20:32 Varmland, Sweden
725156 2021-04-23 Sweden Varmland     15797 196 0 15601 59.7294 13.2354 2021-04-24 04:20:38 Varmland, Sweden
1470168 2021-04-22 Sweden Varmland     15601 196 0 15405 59.7294 13.2354 2021-04-23 04:20:52 Varmland, Sweden
1222916 2021-04-21 Sweden Varmland     15459 194 0 15265 59.7294 13.2354 2021-04-22 04:20:53 Varmland, Sweden
458383 2021-04-20 Sweden Varmland     15235 193 0 15042 59.7294 13.2354 2021-04-21 04:21:14 Varmland, Sweden
1300571 2021-04-19 Sweden Varmland     14852 191 0 14661 59.7294 13.2354 2021-04-20 04:20:41 Varmland, Sweden
1070150 2021-04-18 Sweden Varmland     14852 191 0 14661 59.7294 13.2354 2021-04-19 04:20:57 Varmland, Sweden
1046032 2021-04-17 Sweden Varmland     14852 191 0 14661 59.7294 13.2354 2021-04-18 04:20:41 Varmland, Sweden
597308 2021-04-16 Sweden Varmland     14852 191 0 14661 59.7294 13.2354 2021-04-17 04:20:40 Varmland, Sweden
1621724 2021-04-15 Sweden Varmland     14640 190 0 14450 59.7294 13.2354 2021-04-16 04:20:46 Varmland, Sweden
951155 2021-04-14 Sweden Varmland     14458 189 0 14269 59.7294 13.2354 2021-04-15 04:20:54 Varmland, Sweden
593324 2021-04-13 Sweden Varmland     14164 188 0 13976 59.7294 13.2354 2021-04-14 04:20:41 Varmland, Sweden
33263 2021-04-12 Sweden Varmland     13677 186 0 13491 59.7294 13.2354 2021-04-13 04:20:37 Varmland, Sweden
1372278 2021-04-11 Sweden Varmland     13677 186 0 13491 59.7294 13.2354 2021-04-12 04:21:00 Varmland, Sweden
1667530 2021-04-10 Sweden Varmland     13677 186 0 13491 59.7294 13.2354 2021-04-11 04:20:56 Varmland, Sweden
1160146 2021-04-09 Sweden Varmland     13677 186 0 13491 59.7294 13.2354 2021-04-10 04:20:59 Varmland, Sweden
1057981 2021-04-08 Sweden Varmland     13450 185 0 13265 59.7294 13.2354 2021-04-09 04:21:13 Varmland, Sweden
1500770 2021-04-07 Sweden Varmland     13272 185 0 13087 59.7294 13.2354 2021-04-08 04:21:13 Varmland, Sweden
1207975 2021-04-06 Sweden Varmland     12993 185 0 12808 59.7294 13.2354 2021-04-07 04:20:53 Varmland, Sweden
123276 2021-04-05 Sweden Varmland     12517 185 0 12332 59.7294 13.2354 2021-04-06 04:20:32 Varmland, Sweden
1255077 2021-04-04 Sweden Varmland     12517 185 0 12332 59.7294 13.2354 2021-04-05 04:20:35 Varmland, Sweden
1129054 2021-04-03 Sweden Varmland     12517 185 0 12332 59.7294 13.2354 2021-04-04 04:20:49 Varmland, Sweden
270445 2021-04-02 Sweden Varmland     12517 185 0 12332 59.7294 13.2354 2021-04-03 04:20:44 Varmland, Sweden
1173777 2021-04-01 Sweden Varmland     12517 185 0 12332 59.7294 13.2354 2021-04-02 04:20:36 Varmland, Sweden
516088 2021-03-31 Sweden Varmland     12335 184 0 12151 59.7294 13.2354 2021-04-01 04:27:05 Varmland, Sweden
289817 2021-03-30 Sweden Varmland     12110 184 0 11926 59.7294 13.2354 2021-03-31 04:26:25 Varmland, Sweden
1575354 2021-03-29 Sweden Varmland     11781 182 0 11599 59.7294 13.2354 2021-03-30 04:26:23 Varmland, Sweden
631631 2021-03-28 Sweden Varmland     11781 182 0 11599 59.7294 13.2354 2021-03-29 04:28:35 Varmland, Sweden
608412 2021-03-27 Sweden Varmland     11781 182 0 11599 59.7294 13.2354 2021-03-28 05:28:10 Varmland, Sweden
1334555 2021-03-26 Sweden Varmland     11781 182 0 11599 59.7294 13.2354 2021-03-27 05:25:04 Varmland, Sweden
150994 2021-03-25 Sweden Varmland     11622 181 0 11441 59.7294 13.2354 2021-03-26 05:26:55 Varmland, Sweden
1598515 2021-03-24 Sweden Varmland     11463 181 0 11282 59.7294 13.2354 2021-03-25 05:27:00 Varmland, Sweden
404319 2021-03-23 Sweden Varmland     11235 181 0 11054 59.7294 13.2354 2021-03-24 05:25:40 Varmland, Sweden
1387856 2021-03-22 Sweden Varmland     10927 180 0 10747 59.7294 13.2354 2021-03-23 05:26:18 Varmland, Sweden
305343 2021-03-21 Sweden Varmland     10927 180 0 10747 59.7294 13.2354 2021-03-22 05:25:43 Varmland, Sweden
254392 2021-03-20 Sweden Varmland     10927 180 0 10747 59.7294 13.2354 2021-03-21 05:25:44 Varmland, Sweden
1231148 2021-03-19 Sweden Varmland     10927 180 0 10747 59.7294 13.2354 2021-03-20 05:25:46 Varmland, Sweden
975073 2021-03-18 Sweden Varmland     10789 179 0 10610 59.7294 13.2354 2021-03-19 05:26:09 Varmland, Sweden
1532708 2021-03-17 Sweden Varmland     10659 177 0 10482 59.7294 13.2354 2021-03-18 05:26:22 Varmland, Sweden
55902 2021-03-16 Sweden Varmland     10473 177 0 10296 59.7294 13.2354 2021-03-17 05:25:07 Varmland, Sweden
563215 2021-03-15 Sweden Varmland     10221 177 0 10044 59.7294 13.2354 2021-03-16 05:25:13 Varmland, Sweden
851784 2021-03-14 Sweden Varmland     10221 177 0 10044 59.7294 13.2354 2021-03-15 05:25:51 Varmland, Sweden
943209 2021-03-13 Sweden Varmland     10221 177 0 10044 59.7294 13.2354 2021-03-14 05:25:37 Varmland, Sweden
1311089 2021-03-12 Sweden Varmland     10221 177 0 10044 59.7294 13.2354 2021-03-13 05:25:15 Varmland, Sweden
1077927 2021-03-11 Sweden Varmland     10095 177 0 9918 59.7294 13.2354 2021-03-12 05:26:50 Varmland, Sweden
955139 2021-03-10 Sweden Varmland     10000 175 0 9825 59.7294 13.2354 2021-03-11 05:25:48 Varmland, Sweden
543972 2021-03-09 Sweden Varmland     9835 174 0 9661 59.7294 13.2354 2021-03-10 05:24:35 Varmland, Sweden
1520710 2021-03-08 Sweden Varmland     9605 171 0 9434 59.7294 13.2354 2021-03-09 05:28:19 Varmland, Sweden
866991 2021-03-07 Sweden Varmland     9605 171 0 9434 59.7294 13.2354 2021-03-08 05:24:48 Varmland, 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]);