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

View and edit SQL

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

province_or_state

  • Halland · 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
223239 2021-06-14 Sweden Halland     40715 319 0 40396 56.8967 12.8034 2021-06-15 04:22:22 Halland, Sweden
215271 2021-06-13 Sweden Halland     40715 319 0 40396 56.8967 12.8034 2021-06-14 04:22:46 Halland, Sweden
281841 2021-06-12 Sweden Halland     40715 319 0 40396 56.8967 12.8034 2021-06-13 04:22:44 Halland, Sweden
1633940 2021-06-11 Sweden Halland     40715 319 0 40396 56.8967 12.8034 2021-06-12 04:22:22 Halland, Sweden
663226 2021-06-10 Sweden Halland     40694 319 0 40375 56.8967 12.8034 2021-06-11 04:23:20 Halland, Sweden
882330 2021-06-09 Sweden Halland     40664 319 0 40345 56.8967 12.8034 2021-06-10 04:23:17 Halland, Sweden
1710329 2021-06-08 Sweden Halland     40623 319 0 40304 56.8967 12.8034 2021-06-09 04:23:31 Halland, Sweden
1466173 2021-06-07 Sweden Halland     40521 319 0 40202 56.8967 12.8034 2021-06-08 04:22:35 Halland, Sweden
993940 2021-06-06 Sweden Halland     40521 319 0 40202 56.8967 12.8034 2021-06-07 04:22:51 Halland, Sweden
158730 2021-06-05 Sweden Halland     40521 319 0 40202 56.8967 12.8034 2021-06-06 04:24:03 Halland, Sweden
1516715 2021-06-04 Sweden Halland     40521 319 0 40202 56.8967 12.8034 2021-06-05 04:23:03 Halland, Sweden
1141026 2021-06-03 Sweden Halland     40477 317 0 40160 56.8967 12.8034 2021-06-04 04:23:37 Halland, Sweden
427470 2021-06-02 Sweden Halland     40207 317 0 39890 56.8967 12.8034 2021-06-03 04:23:32 Halland, Sweden
539977 2021-06-01 Sweden Halland     40207 317 0 39890 56.8967 12.8034 2021-06-02 04:24:34 Halland, Sweden
787162 2021-05-31 Sweden Halland     40207 317 0 39890 56.8967 12.8034 2021-06-01 04:23:09 Halland, Sweden
1330560 2021-05-30 Sweden Halland     40207 317 0 39890 56.8967 12.8034 2021-05-31 03:08:59 Halland, Sweden
67769 2021-05-29 Sweden Halland     40207 317 0 39890 56.8967 12.8034 2021-05-30 04:20:55 Halland, Sweden
195955 2021-05-28 Sweden Halland     40207 317 0 39890 56.8967 12.8034 2021-05-29 04:20:41 Halland, Sweden
939214 2021-05-27 Sweden Halland     40207 317 0 39890 56.8967 12.8034 2021-05-28 04:20:36 Halland, Sweden
1226888 2021-05-26 Sweden Halland     40144 316 0 39828 56.8967 12.8034 2021-05-27 04:20:59 Halland, Sweden
1338527 2021-05-25 Sweden Halland     40065 315 0 39750 56.8967 12.8034 2021-05-26 04:20:35 Halland, Sweden
203359 2021-05-24 Sweden Halland     39888 315 0 39573 56.8967 12.8034 2021-05-25 04:21:08 Halland, Sweden
99523 2021-05-23 Sweden Halland     39888 315 0 39573 56.8967 12.8034 2021-05-24 04:20:53 Halland, Sweden
524042 2021-05-22 Sweden Halland     39888 315 0 39573 56.8967 12.8034 2021-05-23 04:20:51 Halland, Sweden
859737 2021-05-21 Sweden Halland     39888 315 0 39573 56.8967 12.8034 2021-05-22 04:20:45 Halland, Sweden
721160 2021-05-20 Sweden Halland     39794 315 0 39479 56.8967 12.8034 2021-05-21 04:20:43 Halland, Sweden
408291 2021-05-19 Sweden Halland     39712 315 0 39397 56.8967 12.8034 2021-05-20 04:21:05 Halland, Sweden
783177 2021-05-18 Sweden Halland     39603 314 0 39289 56.8967 12.8034 2021-05-19 04:20:42 Halland, Sweden
1423319 2021-05-17 Sweden Halland     39368 314 0 39054 56.8967 12.8034 2021-05-18 04:20:33 Halland, Sweden
740505 2021-05-16 Sweden Halland     39368 314 0 39054 56.8967 12.8034 2021-05-17 04:20:34 Halland, Sweden
1117038 2021-05-15 Sweden Halland     39368 314 0 39054 56.8967 12.8034 2021-05-16 04:20:49 Halland, Sweden
1587547 2021-05-14 Sweden Halland     39368 314 0 39054 56.8967 12.8034 2021-05-15 04:20:58 Halland, Sweden
1675464 2021-05-13 Sweden Halland     39181 314 0 38867 56.8967 12.8034 2021-05-14 04:20:41 Halland, Sweden
803091 2021-05-12 Sweden Halland     39181 314 0 38867 56.8967 12.8034 2021-05-13 04:20:51 Halland, Sweden
1181479 2021-05-11 Sweden Halland     39064 310 0 38754 56.8967 12.8034 2021-05-12 04:21:29 Halland, Sweden
325269 2021-05-10 Sweden Halland     38748 310 0 38438 56.8967 12.8034 2021-05-11 04:20:41 Halland, Sweden
604416 2021-05-09 Sweden Halland     38748 310 0 38438 56.8967 12.8034 2021-05-10 04:20:38 Halland, Sweden
986163 2021-05-08 Sweden Halland     38748 310 0 38438 56.8967 12.8034 2021-05-09 04:20:35 Halland, Sweden
434645 2021-05-07 Sweden Halland     38748 310 0 38438 56.8967 12.8034 2021-05-08 04:21:04 Halland, Sweden
901426 2021-05-06 Sweden Halland     38566 310 0 38256 56.8967 12.8034 2021-05-07 04:20:40 Halland, Sweden
71752 2021-05-05 Sweden Halland     38500 310 0 38190 56.8967 12.8034 2021-05-06 04:20:38 Halland, Sweden
791145 2021-05-04 Sweden Halland     38336 309 0 38027 56.8967 12.8034 2021-05-05 04:20:43 Halland, Sweden
1613675 2021-05-03 Sweden Halland     37919 309 0 37610 56.8967 12.8034 2021-05-04 04:20:34 Halland, Sweden
886313 2021-05-02 Sweden Halland     37919 309 0 37610 56.8967 12.8034 2021-05-03 04:20:39 Halland, Sweden
512018 2021-05-01 Sweden Halland     37919 309 0 37610 56.8967 12.8034 2021-05-02 04:20:48 Halland, Sweden
14954 2021-04-30 Sweden Halland     37919 309 0 37610 56.8967 12.8034 2021-05-01 04:20:47 Halland, Sweden
1125058 2021-04-29 Sweden Halland     37799 308 0 37491 56.8967 12.8034 2021-04-30 04:21:03 Halland, Sweden
462355 2021-04-28 Sweden Halland     37657 308 0 37349 56.8967 12.8034 2021-04-29 04:20:55 Halland, Sweden
1315061 2021-04-27 Sweden Halland     37469 306 0 37163 56.8967 12.8034 2021-04-28 04:20:32 Halland, Sweden
1549488 2021-04-26 Sweden Halland     37018 306 0 36712 56.8967 12.8034 2021-04-27 04:20:52 Halland, Sweden
1629955 2021-04-25 Sweden Halland     37018 306 0 36712 56.8967 12.8034 2021-04-26 04:21:04 Halland, Sweden
354095 2021-04-24 Sweden Halland     37018 306 0 36712 56.8967 12.8034 2021-04-25 04:20:32 Halland, Sweden
725144 2021-04-23 Sweden Halland     37018 306 0 36712 56.8967 12.8034 2021-04-24 04:20:38 Halland, Sweden
1470156 2021-04-22 Sweden Halland     36829 306 0 36523 56.8967 12.8034 2021-04-23 04:20:52 Halland, Sweden
1222904 2021-04-21 Sweden Halland     36654 306 0 36348 56.8967 12.8034 2021-04-22 04:20:53 Halland, Sweden
458371 2021-04-20 Sweden Halland     36419 300 0 36119 56.8967 12.8034 2021-04-21 04:21:14 Halland, Sweden
1300559 2021-04-19 Sweden Halland     35796 301 0 35495 56.8967 12.8034 2021-04-20 04:20:41 Halland, Sweden
1070138 2021-04-18 Sweden Halland     35796 301 0 35495 56.8967 12.8034 2021-04-19 04:20:57 Halland, Sweden
1046020 2021-04-17 Sweden Halland     35796 301 0 35495 56.8967 12.8034 2021-04-18 04:20:41 Halland, Sweden
597296 2021-04-16 Sweden Halland     35796 301 0 35495 56.8967 12.8034 2021-04-17 04:20:40 Halland, Sweden
1621712 2021-04-15 Sweden Halland     35562 300 0 35262 56.8967 12.8034 2021-04-16 04:20:46 Halland, Sweden
951143 2021-04-14 Sweden Halland     35297 300 0 34997 56.8967 12.8034 2021-04-15 04:20:54 Halland, Sweden
593312 2021-04-13 Sweden Halland     34962 298 0 34664 56.8967 12.8034 2021-04-14 04:20:41 Halland, Sweden
33251 2021-04-12 Sweden Halland     34203 297 0 33906 56.8967 12.8034 2021-04-13 04:20:37 Halland, Sweden
1372266 2021-04-11 Sweden Halland     34203 297 0 33906 56.8967 12.8034 2021-04-12 04:21:00 Halland, Sweden
1667518 2021-04-10 Sweden Halland     34203 297 0 33906 56.8967 12.8034 2021-04-11 04:20:56 Halland, Sweden
1160134 2021-04-09 Sweden Halland     34203 297 0 33906 56.8967 12.8034 2021-04-10 04:20:59 Halland, Sweden
1057969 2021-04-08 Sweden Halland     33903 295 0 33608 56.8967 12.8034 2021-04-09 04:21:13 Halland, Sweden
1500758 2021-04-07 Sweden Halland     33575 295 0 33280 56.8967 12.8034 2021-04-08 04:21:13 Halland, Sweden
1207963 2021-04-06 Sweden Halland     33039 293 0 32746 56.8967 12.8034 2021-04-07 04:20:53 Halland, Sweden
123264 2021-04-05 Sweden Halland     32182 290 0 31892 56.8967 12.8034 2021-04-06 04:20:32 Halland, Sweden
1255065 2021-04-04 Sweden Halland     32182 290 0 31892 56.8967 12.8034 2021-04-05 04:20:35 Halland, Sweden
1129042 2021-04-03 Sweden Halland     32182 290 0 31892 56.8967 12.8034 2021-04-04 04:20:49 Halland, Sweden
270433 2021-04-02 Sweden Halland     32182 290 0 31892 56.8967 12.8034 2021-04-03 04:20:44 Halland, Sweden
1173765 2021-04-01 Sweden Halland     32182 290 0 31892 56.8967 12.8034 2021-04-02 04:20:36 Halland, Sweden
516076 2021-03-31 Sweden Halland     31823 290 0 31533 56.8967 12.8034 2021-04-01 04:27:05 Halland, Sweden
289805 2021-03-30 Sweden Halland     31442 287 0 31155 56.8967 12.8034 2021-03-31 04:26:25 Halland, Sweden
1575342 2021-03-29 Sweden Halland     30480 287 0 30193 56.8967 12.8034 2021-03-30 04:26:23 Halland, Sweden
631619 2021-03-28 Sweden Halland     30480 287 0 30193 56.8967 12.8034 2021-03-29 04:28:35 Halland, Sweden
608400 2021-03-27 Sweden Halland     30480 287 0 30193 56.8967 12.8034 2021-03-28 05:28:10 Halland, Sweden
1334543 2021-03-26 Sweden Halland     30480 287 0 30193 56.8967 12.8034 2021-03-27 05:25:04 Halland, Sweden
150982 2021-03-25 Sweden Halland     30142 286 0 29856 56.8967 12.8034 2021-03-26 05:26:55 Halland, Sweden
1598503 2021-03-24 Sweden Halland     29729 286 0 29443 56.8967 12.8034 2021-03-25 05:27:00 Halland, Sweden
404307 2021-03-23 Sweden Halland     29182 285 0 28897 56.8967 12.8034 2021-03-24 05:25:40 Halland, Sweden
1387844 2021-03-22 Sweden Halland     28262 285 0 27977 56.8967 12.8034 2021-03-23 05:26:18 Halland, Sweden
305331 2021-03-21 Sweden Halland     28262 285 0 27977 56.8967 12.8034 2021-03-22 05:25:43 Halland, Sweden
254380 2021-03-20 Sweden Halland     28262 285 0 27977 56.8967 12.8034 2021-03-21 05:25:44 Halland, Sweden
1231136 2021-03-19 Sweden Halland     28262 285 0 27977 56.8967 12.8034 2021-03-20 05:25:46 Halland, Sweden
975061 2021-03-18 Sweden Halland     27958 283 0 27675 56.8967 12.8034 2021-03-19 05:26:09 Halland, Sweden
1532696 2021-03-17 Sweden Halland     27580 283 0 27297 56.8967 12.8034 2021-03-18 05:26:22 Halland, Sweden
55890 2021-03-16 Sweden Halland     27196 280 0 26916 56.8967 12.8034 2021-03-17 05:25:07 Halland, Sweden
563203 2021-03-15 Sweden Halland     26561 280 0 26281 56.8967 12.8034 2021-03-16 05:25:13 Halland, Sweden
851772 2021-03-14 Sweden Halland     26561 280 0 26281 56.8967 12.8034 2021-03-15 05:25:51 Halland, Sweden
943197 2021-03-13 Sweden Halland     26561 280 0 26281 56.8967 12.8034 2021-03-14 05:25:37 Halland, Sweden
1311077 2021-03-12 Sweden Halland     26561 280 0 26281 56.8967 12.8034 2021-03-13 05:25:15 Halland, Sweden
1077915 2021-03-11 Sweden Halland     26321 278 0 26043 56.8967 12.8034 2021-03-12 05:26:50 Halland, Sweden
955127 2021-03-10 Sweden Halland     26007 278 0 25729 56.8967 12.8034 2021-03-11 05:25:48 Halland, Sweden
543960 2021-03-09 Sweden Halland     25577 275 0 25302 56.8967 12.8034 2021-03-10 05:24:35 Halland, Sweden
1520698 2021-03-08 Sweden Halland     25057 275 0 24782 56.8967 12.8034 2021-03-09 05:28:19 Halland, Sweden
866979 2021-03-07 Sweden Halland     25057 275 0 24782 56.8967 12.8034 2021-03-08 05:24:48 Halland, 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]);