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

View and edit SQL

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

province_or_state

  • Uppsala · 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
168785 2021-06-19 Sweden Uppsala     40338 538 0 39800 60.0092 17.2715 2021-06-20 04:21:48 Uppsala, Sweden
686310 2021-06-18 Sweden Uppsala     40338 538 0 39800 60.0092 17.2715 2021-06-19 04:22:33 Uppsala, Sweden
958367 2021-06-17 Sweden Uppsala     40338 538 0 39800 60.0092 17.2715 2021-06-18 04:22:16 Uppsala, Sweden
1281732 2021-06-16 Sweden Uppsala     40338 538 0 39800 60.0092 17.2715 2021-06-17 04:22:36 Uppsala, Sweden
682322 2021-06-15 Sweden Uppsala     40338 538 0 39800 60.0092 17.2715 2021-06-16 04:22:32 Uppsala, Sweden
372876 2021-06-14 Sweden Uppsala     40286 538 0 39748 60.0092 17.2715 2021-06-15 04:22:22 Uppsala, Sweden
1223692 2021-06-13 Sweden Uppsala     40286 538 0 39748 60.0092 17.2715 2021-06-14 04:22:46 Uppsala, Sweden
80973 2021-06-12 Sweden Uppsala     40286 538 0 39748 60.0092 17.2715 2021-06-13 04:22:44 Uppsala, Sweden
970276 2021-06-11 Sweden Uppsala     40286 538 0 39748 60.0092 17.2715 2021-06-12 04:22:22 Uppsala, Sweden
1438849 2021-06-10 Sweden Uppsala     40261 537 0 39724 60.0092 17.2715 2021-06-11 04:23:20 Uppsala, Sweden
1157348 2021-06-09 Sweden Uppsala     40243 537 0 39706 60.0092 17.2715 2021-06-10 04:23:17 Uppsala, Sweden
1231664 2021-06-08 Sweden Uppsala     40206 537 0 39669 60.0092 17.2715 2021-06-09 04:23:31 Uppsala, Sweden
360660 2021-06-07 Sweden Uppsala     40142 537 0 39605 60.0092 17.2715 2021-06-08 04:22:35 Uppsala, Sweden
1076288 2021-06-06 Sweden Uppsala     40142 537 0 39605 60.0092 17.2715 2021-06-07 04:22:51 Uppsala, Sweden
1613680 2021-06-05 Sweden Uppsala     40142 537 0 39605 60.0092 17.2715 2021-06-06 04:24:03 Uppsala, Sweden
1125966 2021-06-04 Sweden Uppsala     40142 537 0 39605 60.0092 17.2715 2021-06-05 04:23:03 Uppsala, Sweden
318422 2021-06-03 Sweden Uppsala     40090 536 0 39554 60.0092 17.2715 2021-06-04 04:23:37 Uppsala, Sweden
1133935 2021-06-02 Sweden Uppsala     39789 536 0 39253 60.0092 17.2715 2021-06-03 04:23:32 Uppsala, Sweden
292112 2021-06-01 Sweden Uppsala     39789 536 0 39253 60.0092 17.2715 2021-06-02 04:24:34 Uppsala, Sweden
1652063 2021-05-31 Sweden Uppsala     39789 536 0 39253 60.0092 17.2715 2021-06-01 04:23:09 Uppsala, Sweden
981291 2021-05-30 Sweden Uppsala     39789 536 0 39253 60.0092 17.2715 2021-05-31 03:08:59 Uppsala, Sweden
841672 2021-05-29 Sweden Uppsala     39789 536 0 39253 60.0092 17.2715 2021-05-30 04:20:55 Uppsala, Sweden
698244 2021-05-28 Sweden Uppsala     39789 536 0 39253 60.0092 17.2715 2021-05-29 04:20:41 Uppsala, Sweden
1369745 2021-05-27 Sweden Uppsala     39789 536 0 39253 60.0092 17.2715 2021-05-28 04:20:36 Uppsala, Sweden
1292829 2021-05-26 Sweden Uppsala     39746 536 0 39210 60.0092 17.2715 2021-05-27 04:20:59 Uppsala, Sweden
603200 2021-05-25 Sweden Uppsala     39657 536 0 39121 60.0092 17.2715 2021-05-26 04:20:35 Uppsala, Sweden
1365758 2021-05-24 Sweden Uppsala     39437 533 0 38904 60.0092 17.2715 2021-05-25 04:21:08 Uppsala, Sweden
420271 2021-05-23 Sweden Uppsala     39437 533 0 38904 60.0092 17.2715 2021-05-24 04:20:53 Uppsala, Sweden
54610 2021-05-22 Sweden Uppsala     39437 533 0 38904 60.0092 17.2715 2021-05-23 04:20:51 Uppsala, Sweden
368889 2021-05-21 Sweden Uppsala     39437 533 0 38904 60.0092 17.2715 2021-05-22 04:20:45 Uppsala, Sweden
1024688 2021-05-20 Sweden Uppsala     39328 533 0 38795 60.0092 17.2715 2021-05-21 04:20:43 Uppsala, Sweden
1679314 2021-05-19 Sweden Uppsala     39233 533 0 38700 60.0092 17.2715 2021-05-20 04:21:05 Uppsala, Sweden
65301 2021-05-18 Sweden Uppsala     39125 533 0 38592 60.0092 17.2715 2021-05-19 04:20:42 Uppsala, Sweden
1243373 2021-05-17 Sweden Uppsala     38786 530 0 38256 60.0092 17.2715 2021-05-18 04:20:33 Uppsala, Sweden
1068221 2021-05-16 Sweden Uppsala     38786 530 0 38256 60.0092 17.2715 2021-05-17 04:20:34 Uppsala, Sweden
505349 2021-05-15 Sweden Uppsala     38786 530 0 38256 60.0092 17.2715 2021-05-16 04:20:49 Uppsala, Sweden
892954 2021-05-14 Sweden Uppsala     38786 530 0 38256 60.0092 17.2715 2021-05-15 04:20:58 Uppsala, Sweden
532289 2021-05-13 Sweden Uppsala     38538 530 0 38008 60.0092 17.2715 2021-05-14 04:20:41 Uppsala, Sweden
1719576 2021-05-12 Sweden Uppsala     38538 530 0 38008 60.0092 17.2715 2021-05-13 04:20:51 Uppsala, Sweden
1723562 2021-05-11 Sweden Uppsala     38371 529 0 37842 60.0092 17.2715 2021-05-12 04:21:29 Uppsala, Sweden
1165319 2021-05-10 Sweden Uppsala     37882 524 0 37358 60.0092 17.2715 2021-05-11 04:20:41 Uppsala, Sweden
1169305 2021-05-09 Sweden Uppsala     37882 524 0 37358 60.0092 17.2715 2021-05-10 04:20:38 Uppsala, Sweden
1660092 2021-05-08 Sweden Uppsala     37882 524 0 37358 60.0092 17.2715 2021-05-09 04:20:35 Uppsala, Sweden
800190 2021-05-07 Sweden Uppsala     37882 524 0 37358 60.0092 17.2715 2021-05-08 04:21:04 Uppsala, Sweden
1219705 2021-05-06 Sweden Uppsala     37693 523 0 37170 60.0092 17.2715 2021-05-07 04:20:40 Uppsala, Sweden
416285 2021-05-05 Sweden Uppsala     37436 523 0 36913 60.0092 17.2715 2021-05-06 04:20:38 Uppsala, Sweden
674306 2021-05-04 Sweden Uppsala     37181 522 0 36659 60.0092 17.2715 2021-05-05 04:20:43 Uppsala, Sweden
1088330 2021-05-03 Sweden Uppsala     36601 520 0 36081 60.0092 17.2715 2021-05-04 04:20:34 Uppsala, Sweden
1727548 2021-05-02 Sweden Uppsala     36601 520 0 36081 60.0092 17.2715 2021-05-03 04:20:39 Uppsala, Sweden
1084344 2021-05-01 Sweden Uppsala     36601 520 0 36081 60.0092 17.2715 2021-05-02 04:20:48 Uppsala, Sweden
1388872 2021-04-30 Sweden Uppsala     36601 520 0 36081 60.0092 17.2715 2021-05-01 04:20:47 Uppsala, Sweden
38691 2021-04-29 Sweden Uppsala     36327 517 0 35810 60.0092 17.2715 2021-04-30 04:21:03 Uppsala, Sweden
12264 2021-04-28 Sweden Uppsala     36069 517 0 35552 60.0092 17.2715 2021-04-29 04:20:55 Uppsala, Sweden
853647 2021-04-27 Sweden Uppsala     35778 517 0 35261 60.0092 17.2715 2021-04-28 04:20:32 Uppsala, Sweden
1064235 2021-04-26 Sweden Uppsala     35174 513 0 34661 60.0092 17.2715 2021-04-27 04:20:52 Uppsala, Sweden
1476485 2021-04-25 Sweden Uppsala     35174 513 0 34661 60.0092 17.2715 2021-04-26 04:21:04 Uppsala, Sweden
744106 2021-04-24 Sweden Uppsala     35174 513 0 34661 60.0092 17.2715 2021-04-25 04:20:32 Uppsala, Sweden
1430905 2021-04-23 Sweden Uppsala     35174 513 0 34661 60.0092 17.2715 2021-04-24 04:20:38 Uppsala, Sweden
96734 2021-04-22 Sweden Uppsala     34902 513 0 34389 60.0092 17.2715 2021-04-23 04:20:52 Uppsala, Sweden
849661 2021-04-21 Sweden Uppsala     34495 511 0 33984 60.0092 17.2715 2021-04-22 04:20:53 Uppsala, Sweden
827279 2021-04-20 Sweden Uppsala     34164 510 0 33654 60.0092 17.2715 2021-04-21 04:21:14 Uppsala, Sweden
770990 2021-04-19 Sweden Uppsala     33436 506 0 32930 60.0092 17.2715 2021-04-20 04:20:41 Uppsala, Sweden
1416299 2021-04-18 Sweden Uppsala     33436 506 0 32930 60.0092 17.2715 2021-04-19 04:20:57 Uppsala, Sweden
985276 2021-04-17 Sweden Uppsala     33436 506 0 32930 60.0092 17.2715 2021-04-18 04:20:41 Uppsala, Sweden
238339 2021-04-16 Sweden Uppsala     33436 506 0 32930 60.0092 17.2715 2021-04-17 04:20:40 Uppsala, Sweden
580068 2021-04-15 Sweden Uppsala     33036 506 0 32530 60.0092 17.2715 2021-04-16 04:20:46 Uppsala, Sweden
1266696 2021-04-14 Sweden Uppsala     32739 503 0 32236 60.0092 17.2715 2021-04-15 04:20:54 Uppsala, Sweden
702229 2021-04-13 Sweden Uppsala     32439 503 0 31936 60.0092 17.2715 2021-04-14 04:20:41 Uppsala, Sweden
1671342 2021-04-12 Sweden Uppsala     31607 503 0 31104 60.0092 17.2715 2021-04-13 04:20:37 Uppsala, Sweden
785047 2021-04-11 Sweden Uppsala     31607 503 0 31104 60.0092 17.2715 2021-04-12 04:21:00 Uppsala, Sweden
1392858 2021-04-10 Sweden Uppsala     31607 503 0 31104 60.0092 17.2715 2021-04-11 04:20:56 Uppsala, Sweden
966289 2021-04-09 Sweden Uppsala     31607 503 0 31104 60.0092 17.2715 2021-04-10 04:20:59 Uppsala, Sweden
690293 2021-04-08 Sweden Uppsala     31187 503 0 30684 60.0092 17.2715 2021-04-09 04:21:13 Uppsala, Sweden
1277745 2021-04-07 Sweden Uppsala     30874 503 0 30371 60.0092 17.2715 2021-04-08 04:21:13 Uppsala, Sweden
88764 2021-04-06 Sweden Uppsala     30599 501 0 30098 60.0092 17.2715 2021-04-07 04:20:53 Uppsala, Sweden
123146 2021-04-05 Sweden Uppsala     29524 501 0 29023 60.0092 17.2715 2021-04-06 04:20:32 Uppsala, Sweden
73648 2021-04-04 Sweden Uppsala     29524 501 0 29023 60.0092 17.2715 2021-04-05 04:20:35 Uppsala, Sweden
792264 2021-04-03 Sweden Uppsala     29524 501 0 29023 60.0092 17.2715 2021-04-04 04:20:49 Uppsala, Sweden
1020702 2021-04-02 Sweden Uppsala     29524 501 0 29023 60.0092 17.2715 2021-04-03 04:20:44 Uppsala, Sweden
1350864 2021-04-01 Sweden Uppsala     29524 501 0 29023 60.0092 17.2715 2021-04-02 04:20:36 Uppsala, Sweden
1691250 2021-03-31 Sweden Uppsala     29210 499 0 28711 60.0092 17.2715 2021-04-01 04:27:05 Uppsala, Sweden
873619 2021-03-30 Sweden Uppsala     28910 498 0 28412 60.0092 17.2715 2021-03-31 04:26:25 Uppsala, Sweden
1400666 2021-03-29 Sweden Uppsala     28263 494 0 27769 60.0092 17.2715 2021-03-30 04:26:23 Uppsala, Sweden
1625069 2021-03-28 Sweden Uppsala     28263 494 0 27769 60.0092 17.2715 2021-03-29 04:28:35 Uppsala, Sweden
1472499 2021-03-27 Sweden Uppsala     28263 494 0 27769 60.0092 17.2715 2021-03-28 05:28:10 Uppsala, Sweden
721046 2021-03-26 Sweden Uppsala     28263 494 0 27769 60.0092 17.2715 2021-03-27 05:25:04 Uppsala, Sweden
1617665 2021-03-25 Sweden Uppsala     27957 494 0 27463 60.0092 17.2715 2021-03-26 05:26:55 Uppsala, Sweden
470326 2021-03-24 Sweden Uppsala     27735 492 0 27243 60.0092 17.2715 2021-03-25 05:27:00 Uppsala, Sweden
1585366 2021-03-23 Sweden Uppsala     27396 492 0 26904 60.0092 17.2715 2021-03-24 05:25:40 Uppsala, Sweden
717060 2021-03-22 Sweden Uppsala     26852 489 0 26363 60.0092 17.2715 2021-03-23 05:26:18 Uppsala, Sweden
1675328 2021-03-21 Sweden Uppsala     26852 489 0 26363 60.0092 17.2715 2021-03-22 05:25:43 Uppsala, Sweden
1747267 2021-03-20 Sweden Uppsala     26852 489 0 26363 60.0092 17.2715 2021-03-21 05:25:44 Uppsala, Sweden
230389 2021-03-19 Sweden Uppsala     26852 489 0 26363 60.0092 17.2715 2021-03-20 05:25:46 Uppsala, Sweden
478324 2021-03-18 Sweden Uppsala     26632 489 0 26143 60.0092 17.2715 2021-03-19 05:26:09 Uppsala, Sweden
1426919 2021-03-17 Sweden Uppsala     26420 485 0 25935 60.0092 17.2715 2021-03-18 05:26:22 Uppsala, Sweden
1593507 2021-03-16 Sweden Uppsala     26183 485 0 25698 60.0092 17.2715 2021-03-17 05:25:07 Uppsala, Sweden
1176506 2021-03-15 Sweden Uppsala     25778 485 0 25293 60.0092 17.2715 2021-03-16 05:25:13 Uppsala, Sweden
276191 2021-03-14 Sweden Uppsala     25778 485 0 25293 60.0092 17.2715 2021-03-15 05:25:51 Uppsala, Sweden
1161333 2021-03-13 Sweden Uppsala     25778 485 0 25293 60.0092 17.2715 2021-03-14 05:25:37 Uppsala, Sweden
22840 2021-03-12 Sweden Uppsala     25778 485 0 25293 60.0092 17.2715 2021-03-13 05:25:15 Uppsala, 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]);