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

View and edit SQL

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

province_or_state

  • Vastra Gotaland · 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
168790 2021-06-19 Sweden Vastra Gotaland     189520 2367 0 187153 58.2528 13.0596 2021-06-20 04:21:48 Vastra Gotaland, Sweden
686315 2021-06-18 Sweden Vastra Gotaland     189520 2367 0 187153 58.2528 13.0596 2021-06-19 04:22:33 Vastra Gotaland, Sweden
958372 2021-06-17 Sweden Vastra Gotaland     189520 2367 0 187153 58.2528 13.0596 2021-06-18 04:22:16 Vastra Gotaland, Sweden
1281737 2021-06-16 Sweden Vastra Gotaland     189520 2367 0 187153 58.2528 13.0596 2021-06-17 04:22:36 Vastra Gotaland, Sweden
682327 2021-06-15 Sweden Vastra Gotaland     189520 2367 0 187153 58.2528 13.0596 2021-06-16 04:22:32 Vastra Gotaland, Sweden
372881 2021-06-14 Sweden Vastra Gotaland     189381 2367 0 187014 58.2528 13.0596 2021-06-15 04:22:22 Vastra Gotaland, Sweden
1223697 2021-06-13 Sweden Vastra Gotaland     189381 2367 0 187014 58.2528 13.0596 2021-06-14 04:22:46 Vastra Gotaland, Sweden
80978 2021-06-12 Sweden Vastra Gotaland     189381 2367 0 187014 58.2528 13.0596 2021-06-13 04:22:44 Vastra Gotaland, Sweden
970281 2021-06-11 Sweden Vastra Gotaland     189381 2367 0 187014 58.2528 13.0596 2021-06-12 04:22:22 Vastra Gotaland, Sweden
1438854 2021-06-10 Sweden Vastra Gotaland     189292 2366 0 186926 58.2528 13.0596 2021-06-11 04:23:20 Vastra Gotaland, Sweden
1157353 2021-06-09 Sweden Vastra Gotaland     189144 2363 0 186781 58.2528 13.0596 2021-06-10 04:23:17 Vastra Gotaland, Sweden
1231669 2021-06-08 Sweden Vastra Gotaland     188988 2364 0 186624 58.2528 13.0596 2021-06-09 04:23:31 Vastra Gotaland, Sweden
360665 2021-06-07 Sweden Vastra Gotaland     188652 2363 0 186289 58.2528 13.0596 2021-06-08 04:22:35 Vastra Gotaland, Sweden
1076293 2021-06-06 Sweden Vastra Gotaland     188652 2363 0 186289 58.2528 13.0596 2021-06-07 04:22:51 Vastra Gotaland, Sweden
1613685 2021-06-05 Sweden Vastra Gotaland     188652 2363 0 186289 58.2528 13.0596 2021-06-06 04:24:03 Vastra Gotaland, Sweden
1125971 2021-06-04 Sweden Vastra Gotaland     188652 2363 0 186289 58.2528 13.0596 2021-06-05 04:23:03 Vastra Gotaland, Sweden
318427 2021-06-03 Sweden Vastra Gotaland     188511 2360 0 186151 58.2528 13.0596 2021-06-04 04:23:37 Vastra Gotaland, Sweden
1133940 2021-06-02 Sweden Vastra Gotaland     186844 2349 0 184495 58.2528 13.0596 2021-06-03 04:23:32 Vastra Gotaland, Sweden
292117 2021-06-01 Sweden Vastra Gotaland     186844 2349 0 184495 58.2528 13.0596 2021-06-02 04:24:34 Vastra Gotaland, Sweden
1652068 2021-05-31 Sweden Vastra Gotaland     186844 2349 0 184495 58.2528 13.0596 2021-06-01 04:23:09 Vastra Gotaland, Sweden
981296 2021-05-30 Sweden Vastra Gotaland     186844 2349 0 184495 58.2528 13.0596 2021-05-31 03:08:59 Vastra Gotaland, Sweden
841677 2021-05-29 Sweden Vastra Gotaland     186844 2349 0 184495 58.2528 13.0596 2021-05-30 04:20:55 Vastra Gotaland, Sweden
698249 2021-05-28 Sweden Vastra Gotaland     186844 2349 0 184495 58.2528 13.0596 2021-05-29 04:20:41 Vastra Gotaland, Sweden
1369750 2021-05-27 Sweden Vastra Gotaland     186844 2349 0 184495 58.2528 13.0596 2021-05-28 04:20:36 Vastra Gotaland, Sweden
1292834 2021-05-26 Sweden Vastra Gotaland     186517 2349 0 184168 58.2528 13.0596 2021-05-27 04:20:59 Vastra Gotaland, Sweden
603205 2021-05-25 Sweden Vastra Gotaland     185967 2339 0 183628 58.2528 13.0596 2021-05-26 04:20:35 Vastra Gotaland, Sweden
1365763 2021-05-24 Sweden Vastra Gotaland     184956 2342 0 182614 58.2528 13.0596 2021-05-25 04:21:08 Vastra Gotaland, Sweden
420276 2021-05-23 Sweden Vastra Gotaland     184956 2342 0 182614 58.2528 13.0596 2021-05-24 04:20:53 Vastra Gotaland, Sweden
54615 2021-05-22 Sweden Vastra Gotaland     184956 2342 0 182614 58.2528 13.0596 2021-05-23 04:20:51 Vastra Gotaland, Sweden
368894 2021-05-21 Sweden Vastra Gotaland     184956 2342 0 182614 58.2528 13.0596 2021-05-22 04:20:45 Vastra Gotaland, Sweden
1024693 2021-05-20 Sweden Vastra Gotaland     184261 2337 0 181924 58.2528 13.0596 2021-05-21 04:20:43 Vastra Gotaland, Sweden
1679319 2021-05-19 Sweden Vastra Gotaland     183588 2336 0 181252 58.2528 13.0596 2021-05-20 04:21:05 Vastra Gotaland, Sweden
65306 2021-05-18 Sweden Vastra Gotaland     182679 2331 0 180348 58.2528 13.0596 2021-05-19 04:20:42 Vastra Gotaland, Sweden
1243378 2021-05-17 Sweden Vastra Gotaland     180440 2329 0 178111 58.2528 13.0596 2021-05-18 04:20:33 Vastra Gotaland, Sweden
1068226 2021-05-16 Sweden Vastra Gotaland     180440 2329 0 178111 58.2528 13.0596 2021-05-17 04:20:34 Vastra Gotaland, Sweden
505354 2021-05-15 Sweden Vastra Gotaland     180440 2329 0 178111 58.2528 13.0596 2021-05-16 04:20:49 Vastra Gotaland, Sweden
892959 2021-05-14 Sweden Vastra Gotaland     180440 2329 0 178111 58.2528 13.0596 2021-05-15 04:20:58 Vastra Gotaland, Sweden
532294 2021-05-13 Sweden Vastra Gotaland     179158 2328 0 176830 58.2528 13.0596 2021-05-14 04:20:41 Vastra Gotaland, Sweden
1719581 2021-05-12 Sweden Vastra Gotaland     179158 2328 0 176830 58.2528 13.0596 2021-05-13 04:20:51 Vastra Gotaland, Sweden
1723567 2021-05-11 Sweden Vastra Gotaland     178278 2314 0 175964 58.2528 13.0596 2021-05-12 04:21:29 Vastra Gotaland, Sweden
1165324 2021-05-10 Sweden Vastra Gotaland     176041 2313 0 173728 58.2528 13.0596 2021-05-11 04:20:41 Vastra Gotaland, Sweden
1169310 2021-05-09 Sweden Vastra Gotaland     176041 2313 0 173728 58.2528 13.0596 2021-05-10 04:20:38 Vastra Gotaland, Sweden
1660097 2021-05-08 Sweden Vastra Gotaland     176041 2313 0 173728 58.2528 13.0596 2021-05-09 04:20:35 Vastra Gotaland, Sweden
800195 2021-05-07 Sweden Vastra Gotaland     176041 2313 0 173728 58.2528 13.0596 2021-05-08 04:21:04 Vastra Gotaland, Sweden
1219710 2021-05-06 Sweden Vastra Gotaland     175301 2310 0 172991 58.2528 13.0596 2021-05-07 04:20:40 Vastra Gotaland, Sweden
416290 2021-05-05 Sweden Vastra Gotaland     173908 2311 0 171597 58.2528 13.0596 2021-05-06 04:20:38 Vastra Gotaland, Sweden
674311 2021-05-04 Sweden Vastra Gotaland     173174 2295 0 170879 58.2528 13.0596 2021-05-05 04:20:43 Vastra Gotaland, Sweden
1088335 2021-05-03 Sweden Vastra Gotaland     171187 2294 0 168893 58.2528 13.0596 2021-05-04 04:20:34 Vastra Gotaland, Sweden
1727553 2021-05-02 Sweden Vastra Gotaland     171187 2294 0 168893 58.2528 13.0596 2021-05-03 04:20:39 Vastra Gotaland, Sweden
1084349 2021-05-01 Sweden Vastra Gotaland     171187 2294 0 168893 58.2528 13.0596 2021-05-02 04:20:48 Vastra Gotaland, Sweden
1388877 2021-04-30 Sweden Vastra Gotaland     171187 2294 0 168893 58.2528 13.0596 2021-05-01 04:20:47 Vastra Gotaland, Sweden
38696 2021-04-29 Sweden Vastra Gotaland     170402 2290 0 168112 58.2528 13.0596 2021-04-30 04:21:03 Vastra Gotaland, Sweden
12269 2021-04-28 Sweden Vastra Gotaland     168948 2290 0 166658 58.2528 13.0596 2021-04-29 04:20:55 Vastra Gotaland, Sweden
853652 2021-04-27 Sweden Vastra Gotaland     167963 2284 0 165679 58.2528 13.0596 2021-04-28 04:20:32 Vastra Gotaland, Sweden
1064240 2021-04-26 Sweden Vastra Gotaland     165866 2283 0 163583 58.2528 13.0596 2021-04-27 04:20:52 Vastra Gotaland, Sweden
1476490 2021-04-25 Sweden Vastra Gotaland     165866 2283 0 163583 58.2528 13.0596 2021-04-26 04:21:04 Vastra Gotaland, Sweden
744111 2021-04-24 Sweden Vastra Gotaland     165866 2283 0 163583 58.2528 13.0596 2021-04-25 04:20:32 Vastra Gotaland, Sweden
1430910 2021-04-23 Sweden Vastra Gotaland     165866 2283 0 163583 58.2528 13.0596 2021-04-24 04:20:38 Vastra Gotaland, Sweden
96739 2021-04-22 Sweden Vastra Gotaland     165108 2277 0 162831 58.2528 13.0596 2021-04-23 04:20:52 Vastra Gotaland, Sweden
849666 2021-04-21 Sweden Vastra Gotaland     163317 2277 0 161040 58.2528 13.0596 2021-04-22 04:20:53 Vastra Gotaland, Sweden
827284 2021-04-20 Sweden Vastra Gotaland     162392 2267 0 160125 58.2528 13.0596 2021-04-21 04:21:14 Vastra Gotaland, Sweden
770995 2021-04-19 Sweden Vastra Gotaland     159744 2267 0 157477 58.2528 13.0596 2021-04-20 04:20:41 Vastra Gotaland, Sweden
1416304 2021-04-18 Sweden Vastra Gotaland     159744 2267 0 157477 58.2528 13.0596 2021-04-19 04:20:57 Vastra Gotaland, Sweden
985281 2021-04-17 Sweden Vastra Gotaland     159744 2267 0 157477 58.2528 13.0596 2021-04-18 04:20:41 Vastra Gotaland, Sweden
238344 2021-04-16 Sweden Vastra Gotaland     159744 2267 0 157477 58.2528 13.0596 2021-04-17 04:20:40 Vastra Gotaland, Sweden
580073 2021-04-15 Sweden Vastra Gotaland     158197 2258 0 155939 58.2528 13.0596 2021-04-16 04:20:46 Vastra Gotaland, Sweden
1266701 2021-04-14 Sweden Vastra Gotaland     156725 2257 0 154468 58.2528 13.0596 2021-04-15 04:20:54 Vastra Gotaland, Sweden
702234 2021-04-13 Sweden Vastra Gotaland     155943 2239 0 153704 58.2528 13.0596 2021-04-14 04:20:41 Vastra Gotaland, Sweden
1671347 2021-04-12 Sweden Vastra Gotaland     152347 2238 0 150109 58.2528 13.0596 2021-04-13 04:20:37 Vastra Gotaland, Sweden
785052 2021-04-11 Sweden Vastra Gotaland     152347 2238 0 150109 58.2528 13.0596 2021-04-12 04:21:00 Vastra Gotaland, Sweden
1392863 2021-04-10 Sweden Vastra Gotaland     152347 2238 0 150109 58.2528 13.0596 2021-04-11 04:20:56 Vastra Gotaland, Sweden
966294 2021-04-09 Sweden Vastra Gotaland     152347 2238 0 150109 58.2528 13.0596 2021-04-10 04:20:59 Vastra Gotaland, Sweden
690298 2021-04-08 Sweden Vastra Gotaland     150966 2228 0 148738 58.2528 13.0596 2021-04-09 04:21:13 Vastra Gotaland, Sweden
1277750 2021-04-07 Sweden Vastra Gotaland     149882 2228 0 147654 58.2528 13.0596 2021-04-08 04:21:13 Vastra Gotaland, Sweden
88769 2021-04-06 Sweden Vastra Gotaland     149331 2221 0 147110 58.2528 13.0596 2021-04-07 04:20:53 Vastra Gotaland, Sweden
123151 2021-04-05 Sweden Vastra Gotaland     145238 2213 0 143025 58.2528 13.0596 2021-04-06 04:20:32 Vastra Gotaland, Sweden
73653 2021-04-04 Sweden Vastra Gotaland     145238 2213 0 143025 58.2528 13.0596 2021-04-05 04:20:35 Vastra Gotaland, Sweden
792269 2021-04-03 Sweden Vastra Gotaland     145238 2213 0 143025 58.2528 13.0596 2021-04-04 04:20:49 Vastra Gotaland, Sweden
1020707 2021-04-02 Sweden Vastra Gotaland     145238 2213 0 143025 58.2528 13.0596 2021-04-03 04:20:44 Vastra Gotaland, Sweden
1350869 2021-04-01 Sweden Vastra Gotaland     145238 2213 0 143025 58.2528 13.0596 2021-04-02 04:20:36 Vastra Gotaland, Sweden
1691255 2021-03-31 Sweden Vastra Gotaland     143550 2212 0 141338 58.2528 13.0596 2021-04-01 04:27:05 Vastra Gotaland, Sweden
873624 2021-03-30 Sweden Vastra Gotaland     142501 2193 0 140308 58.2528 13.0596 2021-03-31 04:26:25 Vastra Gotaland, Sweden
1400671 2021-03-29 Sweden Vastra Gotaland     139335 2194 0 137141 58.2528 13.0596 2021-03-30 04:26:23 Vastra Gotaland, Sweden
1625074 2021-03-28 Sweden Vastra Gotaland     139335 2194 0 137141 58.2528 13.0596 2021-03-29 04:28:35 Vastra Gotaland, Sweden
1472504 2021-03-27 Sweden Vastra Gotaland     139335 2194 0 137141 58.2528 13.0596 2021-03-28 05:28:10 Vastra Gotaland, Sweden
721051 2021-03-26 Sweden Vastra Gotaland     139335 2194 0 137141 58.2528 13.0596 2021-03-27 05:25:04 Vastra Gotaland, Sweden
1617670 2021-03-25 Sweden Vastra Gotaland     137904 2186 0 135718 58.2528 13.0596 2021-03-26 05:26:55 Vastra Gotaland, Sweden
470331 2021-03-24 Sweden Vastra Gotaland     136270 2186 0 134084 58.2528 13.0596 2021-03-25 05:27:00 Vastra Gotaland, Sweden
1585371 2021-03-23 Sweden Vastra Gotaland     135201 2166 0 133035 58.2528 13.0596 2021-03-24 05:25:40 Vastra Gotaland, Sweden
717065 2021-03-22 Sweden Vastra Gotaland     132425 2166 0 130259 58.2528 13.0596 2021-03-23 05:26:18 Vastra Gotaland, Sweden
1675333 2021-03-21 Sweden Vastra Gotaland     132425 2166 0 130259 58.2528 13.0596 2021-03-22 05:25:43 Vastra Gotaland, Sweden
1747272 2021-03-20 Sweden Vastra Gotaland     132425 2166 0 130259 58.2528 13.0596 2021-03-21 05:25:44 Vastra Gotaland, Sweden
230394 2021-03-19 Sweden Vastra Gotaland     132425 2166 0 130259 58.2528 13.0596 2021-03-20 05:25:46 Vastra Gotaland, Sweden
478329 2021-03-18 Sweden Vastra Gotaland     131390 2159 0 129231 58.2528 13.0596 2021-03-19 05:26:09 Vastra Gotaland, Sweden
1426924 2021-03-17 Sweden Vastra Gotaland     129949 2159 0 127790 58.2528 13.0596 2021-03-18 05:26:22 Vastra Gotaland, Sweden
1593512 2021-03-16 Sweden Vastra Gotaland     129194 2145 0 127049 58.2528 13.0596 2021-03-17 05:25:07 Vastra Gotaland, Sweden
1176511 2021-03-15 Sweden Vastra Gotaland     126591 2143 0 124448 58.2528 13.0596 2021-03-16 05:25:13 Vastra Gotaland, Sweden
276196 2021-03-14 Sweden Vastra Gotaland     126591 2143 0 124448 58.2528 13.0596 2021-03-15 05:25:51 Vastra Gotaland, Sweden
1161338 2021-03-13 Sweden Vastra Gotaland     126591 2143 0 124448 58.2528 13.0596 2021-03-14 05:25:37 Vastra Gotaland, Sweden
22845 2021-03-12 Sweden Vastra Gotaland     126591 2143 0 124448 58.2528 13.0596 2021-03-13 05:25:15 Vastra Gotaland, 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]);