johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
938 rows where country_or_region = "Sweden" and province_or_state = "Halland" sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002986 | 4002986 | 2022-10-08 | Sweden | Halland | 108326 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-09 04:21:16 | Halland, Sweden | |||
3998966 | 3998966 | 2021-12-30 | Sweden | Halland | 48813 | 339 | 0 | 56.8967 | 12.8034 | 2021-12-31 04:21:50 | Halland, Sweden | |||
3994954 | 3994954 | 2022-09-27 | Sweden | Halland | 108032 | 495 | 0 | 56.8967 | 12.8034 | 2022-09-28 04:23:01 | Halland, Sweden | |||
3990917 | 3990917 | 2020-10-20 | Sweden | Halland | 2980 | 89 | 0 | 2891 | 56.8967 | 12.8034 | 2020-10-21 04:24:14 | Halland, Sweden | ||
3986943 | 3986943 | 2022-09-15 | Sweden | Halland | 107880 | 492 | 0 | 56.8967 | 12.8034 | 2022-09-16 04:21:19 | Halland, Sweden | |||
3982925 | 3982925 | 2022-06-15 | Sweden | Halland | 105007 | 456 | 0 | 56.8967 | 12.8034 | 2022-06-16 04:20:55 | Halland, Sweden | |||
3978887 | 3978887 | 2021-02-10 | Sweden | Halland | 20631 | 247 | 0 | 20384 | 56.8967 | 12.8034 | 2021-02-11 05:23:55 | Halland, Sweden | ||
3974878 | 3974878 | 2021-09-03 | Sweden | Halland | 42349 | 321 | 0 | 56.8967 | 12.8034 | 2021-09-04 04:21:28 | Halland, Sweden | |||
3970861 | 3970861 | 2021-06-11 | Sweden | Halland | 40715 | 319 | 0 | 40396 | 56.8967 | 12.8034 | 2021-06-12 04:22:22 | Halland, Sweden | ||
3966867 | 3966867 | 2022-07-05 | Sweden | Halland | 105418 | 457 | 0 | 56.8967 | 12.8034 | 2022-07-06 04:20:58 | Halland, Sweden | |||
3962830 | 3962830 | 2021-03-10 | Sweden | Halland | 26007 | 278 | 0 | 25729 | 56.8967 | 12.8034 | 2021-03-11 05:25:48 | Halland, Sweden | ||
3958820 | 3958820 | 2021-06-26 | Sweden | Halland | 40838 | 320 | 0 | 40518 | 56.8967 | 12.8034 | 2021-06-27 04:21:39 | Halland, Sweden | ||
3954802 | 3954802 | 2021-05-11 | Sweden | Halland | 39064 | 310 | 0 | 38754 | 56.8967 | 12.8034 | 2021-05-12 04:21:29 | Halland, Sweden | ||
3950809 | 3950809 | 2022-08-17 | Sweden | Halland | 106896 | 469 | 0 | 56.8967 | 12.8034 | 2022-08-18 04:21:11 | Halland, Sweden | |||
3940376 | 3940376 | 2022-06-30 | Sweden | Halland | 105418 | 457 | 0 | 56.8967 | 12.8034 | 2022-07-01 04:21:10 | Halland, Sweden | |||
3936362 | 3936362 | 2022-12-09 | Sweden | Halland | 110001 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-10 04:21:02 | Halland, Sweden | |||
3932332 | 3932332 | 2020-08-30 | Sweden | Halland | 2129 | 81 | 0 | 2048 | 56.8967 | 12.8034 | 2020-08-31 04:28:27 | Halland, Sweden | ||
3928357 | 3928357 | 2021-10-02 | Sweden | Halland | 43017 | 327 | 0 | 56.8967 | 12.8034 | 2021-10-03 04:21:24 | Halland, Sweden | |||
3924322 | 3924322 | 2021-04-24 | Sweden | Halland | 37018 | 306 | 0 | 36712 | 56.8967 | 12.8034 | 2021-04-25 04:20:32 | Halland, Sweden | ||
3923131 | 3923131 | 2020-08-09 | Sweden | Halland | 1843 | 79 | 0 | 1764 | 56.8967 | 12.8034 | 2020-08-10 04:34:55 | Halland, Sweden | ||
3916351 | 3916351 | 2022-05-01 | Sweden | Halland | 104620 | 445 | 0 | 56.8967 | 12.8034 | 2022-05-02 04:21:10 | Halland, Sweden | |||
3912335 | 3912335 | 2022-02-20 | Sweden | Halland | 101518 | 382 | 0 | 56.8967 | 12.8034 | 2022-02-21 04:21:05 | Halland, Sweden | |||
3908320 | 3908320 | 2022-08-11 | Sweden | Halland | 106896 | 469 | 0 | 56.8967 | 12.8034 | 2022-08-12 04:20:54 | Halland, Sweden | |||
3904287 | 3904287 | 2021-07-31 | Sweden | Halland | 41321 | 320 | 0 | 41001 | 56.8967 | 12.8034 | 2021-08-01 04:21:50 | Halland, Sweden | ||
3900269 | 3900269 | 2021-01-09 | Sweden | Halland | 14860 | 150 | 0 | 14710 | 56.8967 | 12.8034 | 2021-01-10 05:22:12 | Halland, Sweden | ||
3896278 | 3896278 | 2022-05-19 | Sweden | Halland | 104841 | 453 | 0 | 56.8967 | 12.8034 | 2022-05-20 04:20:57 | Halland, Sweden | |||
3892245 | 3892245 | 2021-08-29 | Sweden | Halland | 42139 | 321 | 0 | 56.8967 | 12.8034 | 2021-08-30 04:21:23 | Halland, Sweden | |||
3887936 | 3887936 | 2022-06-06 | Sweden | Halland | 104928 | 455 | 0 | 56.8967 | 12.8034 | 2022-06-07 04:21:08 | Halland, Sweden | |||
3883899 | 3883899 | 2021-04-11 | Sweden | Halland | 34203 | 297 | 0 | 33906 | 56.8967 | 12.8034 | 2021-04-12 04:21:00 | Halland, Sweden | ||
3879885 | 3879885 | 2021-01-14 | Sweden | Halland | 16246 | 165 | 0 | 16081 | 56.8967 | 12.8034 | 2021-01-15 05:22:24 | Halland, Sweden | ||
3875893 | 3875893 | 2022-02-19 | Sweden | Halland | 101518 | 382 | 0 | 56.8967 | 12.8034 | 2022-02-20 04:21:00 | Halland, Sweden | |||
3871878 | 3871878 | 2022-07-31 | Sweden | Halland | 106324 | 469 | 0 | 56.8967 | 12.8034 | 2022-08-01 04:21:03 | Halland, Sweden | |||
3867861 | 3867861 | 2022-04-05 | Sweden | Halland | 104058 | 432 | 0 | 56.8967 | 12.8034 | 2022-04-06 04:20:49 | Halland, Sweden | |||
3860140 | 3860140 | 2020-12-04 | Sweden | Halland | 7372 | 111 | 0 | 7261 | 56.8967 | 12.8034 | 2020-12-05 05:27:36 | Halland, Sweden | ||
3856149 | 3856149 | 2022-02-18 | Sweden | Halland | 101518 | 382 | 0 | 56.8967 | 12.8034 | 2022-02-19 04:21:11 | Halland, Sweden | |||
3852133 | 3852133 | 2022-04-27 | Sweden | Halland | 104490 | 442 | 0 | 56.8967 | 12.8034 | 2022-04-28 04:20:47 | Halland, Sweden | |||
3848097 | 3848097 | 2020-12-13 | Sweden | Halland | 8249 | 118 | 0 | 8131 | 56.8967 | 12.8034 | 2020-12-14 05:26:27 | Halland, Sweden | ||
3840826 | 3840826 | 2022-01-15 | Sweden | Halland | 60486 | 341 | 0 | 56.8967 | 12.8034 | 2022-01-16 04:21:12 | Halland, Sweden | |||
3836791 | 3836791 | 2020-11-21 | Sweden | Halland | 5527 | 99 | 0 | 5428 | 56.8967 | 12.8034 | 2020-11-22 05:25:45 | Halland, Sweden | ||
3832801 | 3832801 | 2021-10-05 | Sweden | Halland | 43061 | 328 | 0 | 56.8967 | 12.8034 | 2021-10-06 04:21:33 | Halland, Sweden | |||
3828785 | 3828785 | 2021-12-21 | Sweden | Halland | 46648 | 333 | 0 | 56.8967 | 12.8034 | 2021-12-22 04:21:54 | Halland, Sweden | |||
3824771 | 3824771 | 2022-09-10 | Sweden | Halland | 107736 | 482 | 0 | 56.8967 | 12.8034 | 2022-09-11 04:20:50 | Halland, Sweden | |||
3820754 | 3820754 | 2022-02-16 | Sweden | Halland | 101260 | 379 | 0 | 56.8967 | 12.8034 | 2022-02-17 04:20:56 | Halland, Sweden | |||
3816737 | 3816737 | 2021-12-23 | Sweden | Halland | 46841 | 335 | 0 | 56.8967 | 12.8034 | 2021-12-24 04:21:34 | Halland, Sweden | |||
3810248 | 3810248 | 2022-01-28 | Sweden | Halland | 87290 | 348 | 0 | 56.8967 | 12.8034 | 2022-01-29 04:21:10 | Halland, Sweden | |||
3806217 | 3806217 | 2021-09-11 | Sweden | Halland | 42535 | 322 | 0 | 56.8967 | 12.8034 | 2021-09-12 04:21:13 | Halland, Sweden | |||
3802203 | 3802203 | 2020-10-05 | Sweden | Halland | 2636 | 87 | 0 | 2549 | 56.8967 | 12.8034 | 2020-10-06 04:23:33 | Halland, Sweden | ||
3798228 | 3798228 | 2022-08-20 | Sweden | Halland | 107186 | 474 | 0 | 56.8967 | 12.8034 | 2022-08-21 04:20:44 | Halland, Sweden | |||
3794210 | 3794210 | 2021-10-25 | Sweden | Halland | 43269 | 328 | 0 | 56.8967 | 12.8034 | 2021-10-26 04:22:09 | Halland, Sweden | |||
3792998 | 3792998 | 2020-08-05 | Sweden | Halland | 1794 | 79 | 0 | 1715 | 56.8967 | 12.8034 | 2020-08-06 04:35:02 | Halland, Sweden | ||
3786202 | 3786202 | 2020-10-11 | Sweden | Halland | 2784 | 88 | 0 | 2696 | 56.8967 | 12.8034 | 2020-10-12 04:23:45 | Halland, Sweden | ||
3782210 | 3782210 | 2020-10-13 | Sweden | Halland | 2848 | 88 | 0 | 2760 | 56.8967 | 12.8034 | 2020-10-14 04:24:05 | Halland, Sweden | ||
3778213 | 3778213 | 2020-12-27 | Sweden | Halland | 10430 | 134 | 0 | 10296 | 56.8967 | 12.8034 | 2020-12-28 05:22:06 | Halland, Sweden | ||
3774223 | 3774223 | 2022-08-30 | Sweden | Halland | 107383 | 480 | 0 | 56.8967 | 12.8034 | 2022-08-31 04:20:57 | Halland, Sweden | |||
3770186 | 3770186 | 2020-12-22 | Sweden | Halland | 10180 | 126 | 0 | 10054 | 56.8967 | 12.8034 | 2020-12-23 05:22:03 | Halland, Sweden | ||
3766196 | 3766196 | 2022-09-11 | Sweden | Halland | 107736 | 482 | 0 | 56.8967 | 12.8034 | 2022-09-12 04:20:58 | Halland, Sweden | |||
3761893 | 3761893 | 2020-12-28 | Sweden | Halland | 10430 | 134 | 0 | 10296 | 56.8967 | 12.8034 | 2020-12-29 05:22:37 | Halland, Sweden | ||
3757787 | 3757787 | 2021-09-21 | Sweden | Halland | 42855 | 323 | 0 | 56.8967 | 12.8034 | 2021-09-22 04:21:45 | Halland, Sweden | |||
3753792 | 3753792 | 2022-10-13 | Sweden | Halland | 108485 | 503 | 0 | 56.8967 | 12.8034 | 2022-10-14 04:22:28 | Halland, Sweden | |||
3749442 | 3749442 | 2021-11-22 | Sweden | Halland | 43839 | 328 | 0 | 56.8967 | 12.8034 | 2021-11-23 04:22:39 | Halland, Sweden | |||
3745428 | 3745428 | 2022-09-07 | Sweden | Halland | 107589 | 482 | 0 | 56.8967 | 12.8034 | 2022-09-08 04:21:02 | Halland, Sweden | |||
3741395 | 3741395 | 2021-07-12 | Sweden | Halland | 40987 | 320 | 0 | 40667 | 56.8967 | 12.8034 | 2021-07-13 04:21:18 | Halland, Sweden | ||
3737548 | 3737548 | 2020-07-12 | Sweden | Halland | 1639 | 75 | 0 | 1564 | 56.8967 | 12.8034 | 2020-07-13 04:43:04 | Halland, Sweden | ||
3730549 | 3730549 | 2022-04-03 | Sweden | Halland | 104058 | 432 | 0 | 56.8967 | 12.8034 | 2022-04-04 04:20:51 | Halland, Sweden | |||
3726534 | 3726534 | 2022-06-07 | Sweden | Halland | 104928 | 455 | 0 | 56.8967 | 12.8034 | 2022-06-08 04:20:55 | Halland, Sweden | |||
3722517 | 3722517 | 2022-04-25 | Sweden | Halland | 104490 | 442 | 0 | 56.8967 | 12.8034 | 2022-04-26 04:20:51 | Halland, Sweden | |||
3718501 | 3718501 | 2022-02-21 | Sweden | Halland | 101518 | 382 | 0 | 56.8967 | 12.8034 | 2022-02-22 04:21:01 | Halland, Sweden | |||
3714488 | 3714488 | 2022-12-06 | Sweden | Halland | 109673 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-07 04:20:58 | Halland, Sweden | |||
3710449 | 3710449 | 2021-04-03 | Sweden | Halland | 32182 | 290 | 0 | 31892 | 56.8967 | 12.8034 | 2021-04-04 04:20:49 | Halland, Sweden | ||
3706439 | 3706439 | 2021-07-17 | Sweden | Halland | 41057 | 320 | 0 | 40737 | 56.8967 | 12.8034 | 2021-07-18 04:22:07 | Halland, Sweden | ||
3702421 | 3702421 | 2021-04-27 | Sweden | Halland | 37469 | 306 | 0 | 37163 | 56.8967 | 12.8034 | 2021-04-28 04:20:32 | Halland, Sweden | ||
3695799 | 3695799 | 2020-12-31 | Sweden | Halland | 12380 | 140 | 0 | 12240 | 56.8967 | 12.8034 | 2021-01-01 05:23:07 | Halland, Sweden | ||
3691788 | 3691788 | 2020-12-24 | Sweden | Halland | 10430 | 134 | 0 | 10296 | 56.8967 | 12.8034 | 2020-12-25 05:22:48 | Halland, Sweden | ||
3687796 | 3687796 | 2022-01-13 | Sweden | Halland | 59333 | 341 | 0 | 56.8967 | 12.8034 | 2022-01-14 04:21:54 | Halland, Sweden | |||
3683765 | 3683765 | 2021-08-02 | Sweden | Halland | 41321 | 320 | 0 | 41001 | 56.8967 | 12.8034 | 2021-08-03 04:21:39 | Halland, Sweden | ||
3682583 | 3682583 | 2020-06-18 | Sweden | Halland | 1154 | 62 | 0 | 1092 | 56.8967 | 12.8034 | 2020-06-19 04:33:17 | Halland, Sweden | ||
3675962 | 3675962 | 2021-05-04 | Sweden | Halland | 38336 | 309 | 0 | 38027 | 56.8967 | 12.8034 | 2021-05-05 04:20:43 | Halland, Sweden | ||
3671968 | 3671968 | 2022-02-15 | Sweden | Halland | 101032 | 372 | 0 | 56.8967 | 12.8034 | 2022-02-16 04:21:10 | Halland, Sweden | |||
3667932 | 3667932 | 2021-03-06 | Sweden | Halland | 25057 | 275 | 0 | 24782 | 56.8967 | 12.8034 | 2021-03-07 05:21:54 | Halland, Sweden | ||
3663918 | 3663918 | 2021-03-09 | Sweden | Halland | 25577 | 275 | 0 | 25302 | 56.8967 | 12.8034 | 2021-03-10 05:24:35 | Halland, Sweden | ||
3659908 | 3659908 | 2021-07-11 | Sweden | Halland | 40987 | 320 | 0 | 40667 | 56.8967 | 12.8034 | 2021-07-12 04:21:34 | Halland, Sweden | ||
3655909 | 3655909 | 2021-12-10 | Sweden | Halland | 45534 | 332 | 0 | 56.8967 | 12.8034 | 2021-12-11 04:22:45 | Halland, Sweden | |||
3651876 | 3651876 | 2020-10-24 | Sweden | Halland | 3084 | 89 | 0 | 2995 | 56.8967 | 12.8034 | 2020-10-25 04:24:36 | Halland, Sweden | ||
3647900 | 3647900 | 2022-08-14 | Sweden | Halland | 106896 | 469 | 0 | 56.8967 | 12.8034 | 2022-08-15 04:20:59 | Halland, Sweden | |||
3643863 | 3643863 | 2021-03-30 | Sweden | Halland | 31442 | 287 | 0 | 31155 | 56.8967 | 12.8034 | 2021-03-31 04:26:25 | Halland, Sweden | ||
3639868 | 3639868 | 2021-11-08 | Sweden | Halland | 43477 | 328 | 0 | 56.8967 | 12.8034 | 2021-11-09 04:21:36 | Halland, Sweden | |||
3632271 | 3632271 | 2021-07-14 | Sweden | Halland | 41030 | 320 | 0 | 40710 | 56.8967 | 12.8034 | 2021-07-15 04:21:48 | Halland, Sweden | ||
3628273 | 3628273 | 2022-03-13 | Sweden | Halland | 103200 | 414 | 0 | 56.8967 | 12.8034 | 2022-03-14 04:20:46 | Halland, Sweden | |||
3621391 | 3621391 | 2021-03-17 | Sweden | Halland | 27580 | 283 | 0 | 27297 | 56.8967 | 12.8034 | 2021-03-18 05:26:22 | Halland, Sweden | ||
3617398 | 3617398 | 2022-08-01 | Sweden | Halland | 106324 | 469 | 0 | 56.8967 | 12.8034 | 2022-08-02 04:20:53 | Halland, Sweden | |||
3613380 | 3613380 | 2022-01-12 | Sweden | Halland | 58188 | 340 | 0 | 56.8967 | 12.8034 | 2022-01-13 08:00:09 | Halland, Sweden | |||
3612168 | 3612168 | 2020-08-06 | Sweden | Halland | 1827 | 79 | 0 | 1748 | 56.8967 | 12.8034 | 2020-08-07 04:35:11 | Halland, Sweden | ||
3605387 | 3605387 | 2021-12-25 | Sweden | Halland | 46841 | 335 | 0 | 56.8967 | 12.8034 | 2021-12-26 04:21:50 | Halland, Sweden | |||
3601351 | 3601351 | 2021-02-17 | Sweden | Halland | 21761 | 258 | 0 | 21503 | 56.8967 | 12.8034 | 2021-02-18 05:22:58 | Halland, Sweden | ||
3597361 | 3597361 | 2022-11-14 | Sweden | Halland | 109187 | 524 | 0 | 56.8967 | 12.8034 | 2022-11-15 04:21:16 | Halland, Sweden | |||
3593343 | 3593343 | 2022-05-23 | Sweden | Halland | 104841 | 453 | 0 | 56.8967 | 12.8034 | 2022-05-24 04:20:57 | Halland, Sweden | |||
3582959 | 3582959 | 2022-05-17 | Sweden | Halland | 104789 | 452 | 0 | 56.8967 | 12.8034 | 2022-05-18 04:20:50 | Halland, Sweden | |||
3578943 | 3578943 | 2022-06-02 | Sweden | Halland | 104928 | 455 | 0 | 56.8967 | 12.8034 | 2022-06-03 04:20:58 | Halland, Sweden | |||
3574906 | 3574906 | 2021-05-17 | Sweden | Halland | 39368 | 314 | 0 | 39054 | 56.8967 | 12.8034 | 2021-05-18 04:20:33 | Halland, Sweden | ||
3570915 | 3570915 | 2022-09-19 | Sweden | Halland | 107880 | 492 | 0 | 56.8967 | 12.8034 | 2022-09-20 04:22:48 | Halland, Sweden |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);