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

View and edit SQL

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

province_or_state

  • Jamtland Harjedalen · 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
223240 2021-06-14 Sweden Jamtland Harjedalen     12493 121 0 12372 63.1712 14.9592 2021-06-15 04:22:22 Jamtland Harjedalen, Sweden
215272 2021-06-13 Sweden Jamtland Harjedalen     12493 121 0 12372 63.1712 14.9592 2021-06-14 04:22:46 Jamtland Harjedalen, Sweden
281842 2021-06-12 Sweden Jamtland Harjedalen     12493 121 0 12372 63.1712 14.9592 2021-06-13 04:22:44 Jamtland Harjedalen, Sweden
1633941 2021-06-11 Sweden Jamtland Harjedalen     12493 121 0 12372 63.1712 14.9592 2021-06-12 04:22:22 Jamtland Harjedalen, Sweden
663227 2021-06-10 Sweden Jamtland Harjedalen     12486 121 0 12365 63.1712 14.9592 2021-06-11 04:23:20 Jamtland Harjedalen, Sweden
882331 2021-06-09 Sweden Jamtland Harjedalen     12480 121 0 12359 63.1712 14.9592 2021-06-10 04:23:17 Jamtland Harjedalen, Sweden
1710330 2021-06-08 Sweden Jamtland Harjedalen     12464 121 0 12343 63.1712 14.9592 2021-06-09 04:23:31 Jamtland Harjedalen, Sweden
1466174 2021-06-07 Sweden Jamtland Harjedalen     12445 120 0 12325 63.1712 14.9592 2021-06-08 04:22:35 Jamtland Harjedalen, Sweden
993941 2021-06-06 Sweden Jamtland Harjedalen     12445 120 0 12325 63.1712 14.9592 2021-06-07 04:22:51 Jamtland Harjedalen, Sweden
158731 2021-06-05 Sweden Jamtland Harjedalen     12445 120 0 12325 63.1712 14.9592 2021-06-06 04:24:03 Jamtland Harjedalen, Sweden
1516716 2021-06-04 Sweden Jamtland Harjedalen     12445 120 0 12325 63.1712 14.9592 2021-06-05 04:23:03 Jamtland Harjedalen, Sweden
1141027 2021-06-03 Sweden Jamtland Harjedalen     12436 120 0 12316 63.1712 14.9592 2021-06-04 04:23:37 Jamtland Harjedalen, Sweden
427471 2021-06-02 Sweden Jamtland Harjedalen     12307 120 0 12187 63.1712 14.9592 2021-06-03 04:23:32 Jamtland Harjedalen, Sweden
539978 2021-06-01 Sweden Jamtland Harjedalen     12307 120 0 12187 63.1712 14.9592 2021-06-02 04:24:34 Jamtland Harjedalen, Sweden
787163 2021-05-31 Sweden Jamtland Harjedalen     12307 120 0 12187 63.1712 14.9592 2021-06-01 04:23:09 Jamtland Harjedalen, Sweden
1330561 2021-05-30 Sweden Jamtland Harjedalen     12307 120 0 12187 63.1712 14.9592 2021-05-31 03:08:59 Jamtland Harjedalen, Sweden
67770 2021-05-29 Sweden Jamtland Harjedalen     12307 120 0 12187 63.1712 14.9592 2021-05-30 04:20:55 Jamtland Harjedalen, Sweden
195956 2021-05-28 Sweden Jamtland Harjedalen     12307 120 0 12187 63.1712 14.9592 2021-05-29 04:20:41 Jamtland Harjedalen, Sweden
939215 2021-05-27 Sweden Jamtland Harjedalen     12307 120 0 12187 63.1712 14.9592 2021-05-28 04:20:36 Jamtland Harjedalen, Sweden
1226889 2021-05-26 Sweden Jamtland Harjedalen     12262 120 0 12142 63.1712 14.9592 2021-05-27 04:20:59 Jamtland Harjedalen, Sweden
1338528 2021-05-25 Sweden Jamtland Harjedalen     12255 120 0 12135 63.1712 14.9592 2021-05-26 04:20:35 Jamtland Harjedalen, Sweden
203360 2021-05-24 Sweden Jamtland Harjedalen     12176 120 0 12056 63.1712 14.9592 2021-05-25 04:21:08 Jamtland Harjedalen, Sweden
99524 2021-05-23 Sweden Jamtland Harjedalen     12176 120 0 12056 63.1712 14.9592 2021-05-24 04:20:53 Jamtland Harjedalen, Sweden
524043 2021-05-22 Sweden Jamtland Harjedalen     12176 120 0 12056 63.1712 14.9592 2021-05-23 04:20:51 Jamtland Harjedalen, Sweden
859738 2021-05-21 Sweden Jamtland Harjedalen     12176 120 0 12056 63.1712 14.9592 2021-05-22 04:20:45 Jamtland Harjedalen, Sweden
721161 2021-05-20 Sweden Jamtland Harjedalen     12124 120 0 12004 63.1712 14.9592 2021-05-21 04:20:43 Jamtland Harjedalen, Sweden
408292 2021-05-19 Sweden Jamtland Harjedalen     12072 120 0 11952 63.1712 14.9592 2021-05-20 04:21:05 Jamtland Harjedalen, Sweden
783178 2021-05-18 Sweden Jamtland Harjedalen     11970 120 0 11850 63.1712 14.9592 2021-05-19 04:20:42 Jamtland Harjedalen, Sweden
1423320 2021-05-17 Sweden Jamtland Harjedalen     11851 120 0 11731 63.1712 14.9592 2021-05-18 04:20:33 Jamtland Harjedalen, Sweden
740506 2021-05-16 Sweden Jamtland Harjedalen     11851 120 0 11731 63.1712 14.9592 2021-05-17 04:20:34 Jamtland Harjedalen, Sweden
1117039 2021-05-15 Sweden Jamtland Harjedalen     11851 120 0 11731 63.1712 14.9592 2021-05-16 04:20:49 Jamtland Harjedalen, Sweden
1587548 2021-05-14 Sweden Jamtland Harjedalen     11851 120 0 11731 63.1712 14.9592 2021-05-15 04:20:58 Jamtland Harjedalen, Sweden
1675465 2021-05-13 Sweden Jamtland Harjedalen     11716 120 0 11596 63.1712 14.9592 2021-05-14 04:20:41 Jamtland Harjedalen, Sweden
803092 2021-05-12 Sweden Jamtland Harjedalen     11716 120 0 11596 63.1712 14.9592 2021-05-13 04:20:51 Jamtland Harjedalen, Sweden
1181480 2021-05-11 Sweden Jamtland Harjedalen     11601 120 0 11481 63.1712 14.9592 2021-05-12 04:21:29 Jamtland Harjedalen, Sweden
325270 2021-05-10 Sweden Jamtland Harjedalen     11426 120 0 11306 63.1712 14.9592 2021-05-11 04:20:41 Jamtland Harjedalen, Sweden
604417 2021-05-09 Sweden Jamtland Harjedalen     11426 120 0 11306 63.1712 14.9592 2021-05-10 04:20:38 Jamtland Harjedalen, Sweden
986164 2021-05-08 Sweden Jamtland Harjedalen     11426 120 0 11306 63.1712 14.9592 2021-05-09 04:20:35 Jamtland Harjedalen, Sweden
434646 2021-05-07 Sweden Jamtland Harjedalen     11426 120 0 11306 63.1712 14.9592 2021-05-08 04:21:04 Jamtland Harjedalen, Sweden
901427 2021-05-06 Sweden Jamtland Harjedalen     11315 120 0 11195 63.1712 14.9592 2021-05-07 04:20:40 Jamtland Harjedalen, Sweden
71753 2021-05-05 Sweden Jamtland Harjedalen     11214 120 0 11094 63.1712 14.9592 2021-05-06 04:20:38 Jamtland Harjedalen, Sweden
791146 2021-05-04 Sweden Jamtland Harjedalen     11092 120 0 10972 63.1712 14.9592 2021-05-05 04:20:43 Jamtland Harjedalen, Sweden
1613676 2021-05-03 Sweden Jamtland Harjedalen     10897 120 0 10777 63.1712 14.9592 2021-05-04 04:20:34 Jamtland Harjedalen, Sweden
886314 2021-05-02 Sweden Jamtland Harjedalen     10897 120 0 10777 63.1712 14.9592 2021-05-03 04:20:39 Jamtland Harjedalen, Sweden
512019 2021-05-01 Sweden Jamtland Harjedalen     10897 120 0 10777 63.1712 14.9592 2021-05-02 04:20:48 Jamtland Harjedalen, Sweden
14955 2021-04-30 Sweden Jamtland Harjedalen     10897 120 0 10777 63.1712 14.9592 2021-05-01 04:20:47 Jamtland Harjedalen, Sweden
1125059 2021-04-29 Sweden Jamtland Harjedalen     10809 120 0 10689 63.1712 14.9592 2021-04-30 04:21:03 Jamtland Harjedalen, Sweden
462356 2021-04-28 Sweden Jamtland Harjedalen     10741 120 0 10621 63.1712 14.9592 2021-04-29 04:20:55 Jamtland Harjedalen, Sweden
1315062 2021-04-27 Sweden Jamtland Harjedalen     10587 120 0 10467 63.1712 14.9592 2021-04-28 04:20:32 Jamtland Harjedalen, Sweden
1549489 2021-04-26 Sweden Jamtland Harjedalen     10419 118 0 10301 63.1712 14.9592 2021-04-27 04:20:52 Jamtland Harjedalen, Sweden
1629956 2021-04-25 Sweden Jamtland Harjedalen     10419 118 0 10301 63.1712 14.9592 2021-04-26 04:21:04 Jamtland Harjedalen, Sweden
354096 2021-04-24 Sweden Jamtland Harjedalen     10419 118 0 10301 63.1712 14.9592 2021-04-25 04:20:32 Jamtland Harjedalen, Sweden
725145 2021-04-23 Sweden Jamtland Harjedalen     10419 118 0 10301 63.1712 14.9592 2021-04-24 04:20:38 Jamtland Harjedalen, Sweden
1470157 2021-04-22 Sweden Jamtland Harjedalen     10306 118 0 10188 63.1712 14.9592 2021-04-23 04:20:52 Jamtland Harjedalen, Sweden
1222905 2021-04-21 Sweden Jamtland Harjedalen     10228 118 0 10110 63.1712 14.9592 2021-04-22 04:20:53 Jamtland Harjedalen, Sweden
458372 2021-04-20 Sweden Jamtland Harjedalen     10069 118 0 9951 63.1712 14.9592 2021-04-21 04:21:14 Jamtland Harjedalen, Sweden
1300560 2021-04-19 Sweden Jamtland Harjedalen     9873 118 0 9755 63.1712 14.9592 2021-04-20 04:20:41 Jamtland Harjedalen, Sweden
1070139 2021-04-18 Sweden Jamtland Harjedalen     9873 118 0 9755 63.1712 14.9592 2021-04-19 04:20:57 Jamtland Harjedalen, Sweden
1046021 2021-04-17 Sweden Jamtland Harjedalen     9873 118 0 9755 63.1712 14.9592 2021-04-18 04:20:41 Jamtland Harjedalen, Sweden
597297 2021-04-16 Sweden Jamtland Harjedalen     9873 118 0 9755 63.1712 14.9592 2021-04-17 04:20:40 Jamtland Harjedalen, Sweden
1621713 2021-04-15 Sweden Jamtland Harjedalen     9775 118 0 9657 63.1712 14.9592 2021-04-16 04:20:46 Jamtland Harjedalen, Sweden
951144 2021-04-14 Sweden Jamtland Harjedalen     9675 118 0 9557 63.1712 14.9592 2021-04-15 04:20:54 Jamtland Harjedalen, Sweden
593313 2021-04-13 Sweden Jamtland Harjedalen     9479 118 0 9361 63.1712 14.9592 2021-04-14 04:20:41 Jamtland Harjedalen, Sweden
33252 2021-04-12 Sweden Jamtland Harjedalen     9223 118 0 9105 63.1712 14.9592 2021-04-13 04:20:37 Jamtland Harjedalen, Sweden
1372267 2021-04-11 Sweden Jamtland Harjedalen     9223 118 0 9105 63.1712 14.9592 2021-04-12 04:21:00 Jamtland Harjedalen, Sweden
1667519 2021-04-10 Sweden Jamtland Harjedalen     9223 118 0 9105 63.1712 14.9592 2021-04-11 04:20:56 Jamtland Harjedalen, Sweden
1160135 2021-04-09 Sweden Jamtland Harjedalen     9223 118 0 9105 63.1712 14.9592 2021-04-10 04:20:59 Jamtland Harjedalen, Sweden
1057970 2021-04-08 Sweden Jamtland Harjedalen     9095 118 0 8977 63.1712 14.9592 2021-04-09 04:21:13 Jamtland Harjedalen, Sweden
1500759 2021-04-07 Sweden Jamtland Harjedalen     8997 118 0 8879 63.1712 14.9592 2021-04-08 04:21:13 Jamtland Harjedalen, Sweden
1207964 2021-04-06 Sweden Jamtland Harjedalen     8923 118 0 8805 63.1712 14.9592 2021-04-07 04:20:53 Jamtland Harjedalen, Sweden
123265 2021-04-05 Sweden Jamtland Harjedalen     8664 118 0 8546 63.1712 14.9592 2021-04-06 04:20:32 Jamtland Harjedalen, Sweden
1255066 2021-04-04 Sweden Jamtland Harjedalen     8664 118 0 8546 63.1712 14.9592 2021-04-05 04:20:35 Jamtland Harjedalen, Sweden
1129043 2021-04-03 Sweden Jamtland Harjedalen     8664 118 0 8546 63.1712 14.9592 2021-04-04 04:20:49 Jamtland Harjedalen, Sweden
270434 2021-04-02 Sweden Jamtland Harjedalen     8664 118 0 8546 63.1712 14.9592 2021-04-03 04:20:44 Jamtland Harjedalen, Sweden
1173766 2021-04-01 Sweden Jamtland Harjedalen     8664 118 0 8546 63.1712 14.9592 2021-04-02 04:20:36 Jamtland Harjedalen, Sweden
516077 2021-03-31 Sweden Jamtland Harjedalen     8519 118 0 8401 63.1712 14.9592 2021-04-01 04:27:05 Jamtland Harjedalen, Sweden
289806 2021-03-30 Sweden Jamtland Harjedalen     8454 118 0 8336 63.1712 14.9592 2021-03-31 04:26:25 Jamtland Harjedalen, Sweden
1575343 2021-03-29 Sweden Jamtland Harjedalen     8336 118 0 8218 63.1712 14.9592 2021-03-30 04:26:23 Jamtland Harjedalen, Sweden
631620 2021-03-28 Sweden Jamtland Harjedalen     8336 118 0 8218 63.1712 14.9592 2021-03-29 04:28:35 Jamtland Harjedalen, Sweden
608401 2021-03-27 Sweden Jamtland Harjedalen     8336 118 0 8218 63.1712 14.9592 2021-03-28 05:28:10 Jamtland Harjedalen, Sweden
1334544 2021-03-26 Sweden Jamtland Harjedalen     8336 118 0 8218 63.1712 14.9592 2021-03-27 05:25:04 Jamtland Harjedalen, Sweden
150983 2021-03-25 Sweden Jamtland Harjedalen     8258 117 0 8141 63.1712 14.9592 2021-03-26 05:26:55 Jamtland Harjedalen, Sweden
1598504 2021-03-24 Sweden Jamtland Harjedalen     8183 117 0 8066 63.1712 14.9592 2021-03-25 05:27:00 Jamtland Harjedalen, Sweden
404308 2021-03-23 Sweden Jamtland Harjedalen     8097 117 0 7980 63.1712 14.9592 2021-03-24 05:25:40 Jamtland Harjedalen, Sweden
1387845 2021-03-22 Sweden Jamtland Harjedalen     7927 117 0 7810 63.1712 14.9592 2021-03-23 05:26:18 Jamtland Harjedalen, Sweden
305332 2021-03-21 Sweden Jamtland Harjedalen     7927 117 0 7810 63.1712 14.9592 2021-03-22 05:25:43 Jamtland Harjedalen, Sweden
254381 2021-03-20 Sweden Jamtland Harjedalen     7927 117 0 7810 63.1712 14.9592 2021-03-21 05:25:44 Jamtland Harjedalen, Sweden
1231137 2021-03-19 Sweden Jamtland Harjedalen     7927 117 0 7810 63.1712 14.9592 2021-03-20 05:25:46 Jamtland Harjedalen, Sweden
975062 2021-03-18 Sweden Jamtland Harjedalen     7835 117 0 7718 63.1712 14.9592 2021-03-19 05:26:09 Jamtland Harjedalen, Sweden
1532697 2021-03-17 Sweden Jamtland Harjedalen     7762 117 0 7645 63.1712 14.9592 2021-03-18 05:26:22 Jamtland Harjedalen, Sweden
55891 2021-03-16 Sweden Jamtland Harjedalen     7665 117 0 7548 63.1712 14.9592 2021-03-17 05:25:07 Jamtland Harjedalen, Sweden
563204 2021-03-15 Sweden Jamtland Harjedalen     7505 117 0 7388 63.1712 14.9592 2021-03-16 05:25:13 Jamtland Harjedalen, Sweden
851773 2021-03-14 Sweden Jamtland Harjedalen     7505 117 0 7388 63.1712 14.9592 2021-03-15 05:25:51 Jamtland Harjedalen, Sweden
943198 2021-03-13 Sweden Jamtland Harjedalen     7505 117 0 7388 63.1712 14.9592 2021-03-14 05:25:37 Jamtland Harjedalen, Sweden
1311078 2021-03-12 Sweden Jamtland Harjedalen     7505 117 0 7388 63.1712 14.9592 2021-03-13 05:25:15 Jamtland Harjedalen, Sweden
1077916 2021-03-11 Sweden Jamtland Harjedalen     7468 117 0 7351 63.1712 14.9592 2021-03-12 05:26:50 Jamtland Harjedalen, Sweden
955128 2021-03-10 Sweden Jamtland Harjedalen     7350 117 0 7233 63.1712 14.9592 2021-03-11 05:25:48 Jamtland Harjedalen, Sweden
543961 2021-03-09 Sweden Jamtland Harjedalen     7298 117 0 7181 63.1712 14.9592 2021-03-10 05:24:35 Jamtland Harjedalen, Sweden
1520699 2021-03-08 Sweden Jamtland Harjedalen     7159 117 0 7042 63.1712 14.9592 2021-03-09 05:28:19 Jamtland Harjedalen, Sweden
866980 2021-03-07 Sweden Jamtland Harjedalen     7159 117 0 7042 63.1712 14.9592 2021-03-08 05:24:48 Jamtland Harjedalen, 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]);