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

View and edit SQL

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

province_or_state

  • Orebro · 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
168780 2021-06-19 Sweden Orebro     32044 342 0 31702 59.535 15.0066 2021-06-20 04:21:48 Orebro, Sweden
686305 2021-06-18 Sweden Orebro     32044 342 0 31702 59.535 15.0066 2021-06-19 04:22:33 Orebro, Sweden
958362 2021-06-17 Sweden Orebro     32044 342 0 31702 59.535 15.0066 2021-06-18 04:22:16 Orebro, Sweden
1281727 2021-06-16 Sweden Orebro     32044 342 0 31702 59.535 15.0066 2021-06-17 04:22:36 Orebro, Sweden
682317 2021-06-15 Sweden Orebro     32044 342 0 31702 59.535 15.0066 2021-06-16 04:22:32 Orebro, Sweden
372871 2021-06-14 Sweden Orebro     32018 342 0 31676 59.535 15.0066 2021-06-15 04:22:22 Orebro, Sweden
1223687 2021-06-13 Sweden Orebro     32018 342 0 31676 59.535 15.0066 2021-06-14 04:22:46 Orebro, Sweden
80968 2021-06-12 Sweden Orebro     32018 342 0 31676 59.535 15.0066 2021-06-13 04:22:44 Orebro, Sweden
970271 2021-06-11 Sweden Orebro     32018 342 0 31676 59.535 15.0066 2021-06-12 04:22:22 Orebro, Sweden
1438844 2021-06-10 Sweden Orebro     32000 342 0 31658 59.535 15.0066 2021-06-11 04:23:20 Orebro, Sweden
1157343 2021-06-09 Sweden Orebro     31981 342 0 31639 59.535 15.0066 2021-06-10 04:23:17 Orebro, Sweden
1231659 2021-06-08 Sweden Orebro     31954 342 0 31612 59.535 15.0066 2021-06-09 04:23:31 Orebro, Sweden
360655 2021-06-07 Sweden Orebro     31890 338 0 31552 59.535 15.0066 2021-06-08 04:22:35 Orebro, Sweden
1076283 2021-06-06 Sweden Orebro     31890 338 0 31552 59.535 15.0066 2021-06-07 04:22:51 Orebro, Sweden
1613675 2021-06-05 Sweden Orebro     31890 338 0 31552 59.535 15.0066 2021-06-06 04:24:03 Orebro, Sweden
1125961 2021-06-04 Sweden Orebro     31890 338 0 31552 59.535 15.0066 2021-06-05 04:23:03 Orebro, Sweden
318417 2021-06-03 Sweden Orebro     31863 338 0 31525 59.535 15.0066 2021-06-04 04:23:37 Orebro, Sweden
1133930 2021-06-02 Sweden Orebro     31602 336 0 31266 59.535 15.0066 2021-06-03 04:23:32 Orebro, Sweden
292107 2021-06-01 Sweden Orebro     31602 336 0 31266 59.535 15.0066 2021-06-02 04:24:34 Orebro, Sweden
1652058 2021-05-31 Sweden Orebro     31602 336 0 31266 59.535 15.0066 2021-06-01 04:23:09 Orebro, Sweden
981286 2021-05-30 Sweden Orebro     31602 336 0 31266 59.535 15.0066 2021-05-31 03:08:59 Orebro, Sweden
841667 2021-05-29 Sweden Orebro     31602 336 0 31266 59.535 15.0066 2021-05-30 04:20:55 Orebro, Sweden
698239 2021-05-28 Sweden Orebro     31602 336 0 31266 59.535 15.0066 2021-05-29 04:20:41 Orebro, Sweden
1369740 2021-05-27 Sweden Orebro     31602 336 0 31266 59.535 15.0066 2021-05-28 04:20:36 Orebro, Sweden
1292824 2021-05-26 Sweden Orebro     31555 336 0 31219 59.535 15.0066 2021-05-27 04:20:59 Orebro, Sweden
603195 2021-05-25 Sweden Orebro     31479 334 0 31145 59.535 15.0066 2021-05-26 04:20:35 Orebro, Sweden
1365753 2021-05-24 Sweden Orebro     31235 334 0 30901 59.535 15.0066 2021-05-25 04:21:08 Orebro, Sweden
420266 2021-05-23 Sweden Orebro     31235 334 0 30901 59.535 15.0066 2021-05-24 04:20:53 Orebro, Sweden
54605 2021-05-22 Sweden Orebro     31235 334 0 30901 59.535 15.0066 2021-05-23 04:20:51 Orebro, Sweden
368884 2021-05-21 Sweden Orebro     31235 334 0 30901 59.535 15.0066 2021-05-22 04:20:45 Orebro, Sweden
1024683 2021-05-20 Sweden Orebro     31132 331 0 30801 59.535 15.0066 2021-05-21 04:20:43 Orebro, Sweden
1679309 2021-05-19 Sweden Orebro     31035 331 0 30704 59.535 15.0066 2021-05-20 04:21:05 Orebro, Sweden
65296 2021-05-18 Sweden Orebro     30878 330 0 30548 59.535 15.0066 2021-05-19 04:20:42 Orebro, Sweden
1243368 2021-05-17 Sweden Orebro     30507 330 0 30177 59.535 15.0066 2021-05-18 04:20:33 Orebro, Sweden
1068216 2021-05-16 Sweden Orebro     30507 330 0 30177 59.535 15.0066 2021-05-17 04:20:34 Orebro, Sweden
505344 2021-05-15 Sweden Orebro     30507 330 0 30177 59.535 15.0066 2021-05-16 04:20:49 Orebro, Sweden
892949 2021-05-14 Sweden Orebro     30507 330 0 30177 59.535 15.0066 2021-05-15 04:20:58 Orebro, Sweden
532284 2021-05-13 Sweden Orebro     30179 330 0 29849 59.535 15.0066 2021-05-14 04:20:41 Orebro, Sweden
1719571 2021-05-12 Sweden Orebro     30179 330 0 29849 59.535 15.0066 2021-05-13 04:20:51 Orebro, Sweden
1723557 2021-05-11 Sweden Orebro     29983 328 0 29655 59.535 15.0066 2021-05-12 04:21:29 Orebro, Sweden
1165314 2021-05-10 Sweden Orebro     29512 328 0 29184 59.535 15.0066 2021-05-11 04:20:41 Orebro, Sweden
1169300 2021-05-09 Sweden Orebro     29512 328 0 29184 59.535 15.0066 2021-05-10 04:20:38 Orebro, Sweden
1660087 2021-05-08 Sweden Orebro     29512 328 0 29184 59.535 15.0066 2021-05-09 04:20:35 Orebro, Sweden
800185 2021-05-07 Sweden Orebro     29512 328 0 29184 59.535 15.0066 2021-05-08 04:21:04 Orebro, Sweden
1219700 2021-05-06 Sweden Orebro     29306 326 0 28980 59.535 15.0066 2021-05-07 04:20:40 Orebro, Sweden
416280 2021-05-05 Sweden Orebro     29132 326 0 28806 59.535 15.0066 2021-05-06 04:20:38 Orebro, Sweden
674301 2021-05-04 Sweden Orebro     28934 325 0 28609 59.535 15.0066 2021-05-05 04:20:43 Orebro, Sweden
1088325 2021-05-03 Sweden Orebro     28424 324 0 28100 59.535 15.0066 2021-05-04 04:20:34 Orebro, Sweden
1727543 2021-05-02 Sweden Orebro     28424 324 0 28100 59.535 15.0066 2021-05-03 04:20:39 Orebro, Sweden
1084339 2021-05-01 Sweden Orebro     28424 324 0 28100 59.535 15.0066 2021-05-02 04:20:48 Orebro, Sweden
1388867 2021-04-30 Sweden Orebro     28424 324 0 28100 59.535 15.0066 2021-05-01 04:20:47 Orebro, Sweden
38686 2021-04-29 Sweden Orebro     28223 322 0 27901 59.535 15.0066 2021-04-30 04:21:03 Orebro, Sweden
12259 2021-04-28 Sweden Orebro     28026 322 0 27704 59.535 15.0066 2021-04-29 04:20:55 Orebro, Sweden
853642 2021-04-27 Sweden Orebro     27832 322 0 27510 59.535 15.0066 2021-04-28 04:20:32 Orebro, Sweden
1064230 2021-04-26 Sweden Orebro     27167 318 0 26849 59.535 15.0066 2021-04-27 04:20:52 Orebro, Sweden
1476480 2021-04-25 Sweden Orebro     27167 318 0 26849 59.535 15.0066 2021-04-26 04:21:04 Orebro, Sweden
744101 2021-04-24 Sweden Orebro     27167 318 0 26849 59.535 15.0066 2021-04-25 04:20:32 Orebro, Sweden
1430900 2021-04-23 Sweden Orebro     27167 318 0 26849 59.535 15.0066 2021-04-24 04:20:38 Orebro, Sweden
96729 2021-04-22 Sweden Orebro     26983 317 0 26666 59.535 15.0066 2021-04-23 04:20:52 Orebro, Sweden
849656 2021-04-21 Sweden Orebro     26762 316 0 26446 59.535 15.0066 2021-04-22 04:20:53 Orebro, Sweden
827274 2021-04-20 Sweden Orebro     26552 316 0 26236 59.535 15.0066 2021-04-21 04:21:14 Orebro, Sweden
770985 2021-04-19 Sweden Orebro     25670 316 0 25354 59.535 15.0066 2021-04-20 04:20:41 Orebro, Sweden
1416294 2021-04-18 Sweden Orebro     25670 316 0 25354 59.535 15.0066 2021-04-19 04:20:57 Orebro, Sweden
985271 2021-04-17 Sweden Orebro     25670 316 0 25354 59.535 15.0066 2021-04-18 04:20:41 Orebro, Sweden
238334 2021-04-16 Sweden Orebro     25670 316 0 25354 59.535 15.0066 2021-04-17 04:20:40 Orebro, Sweden
580063 2021-04-15 Sweden Orebro     25422 308 0 25114 59.535 15.0066 2021-04-16 04:20:46 Orebro, Sweden
1266691 2021-04-14 Sweden Orebro     25331 306 0 25025 59.535 15.0066 2021-04-15 04:20:54 Orebro, Sweden
702224 2021-04-13 Sweden Orebro     25064 304 0 24760 59.535 15.0066 2021-04-14 04:20:41 Orebro, Sweden
1671337 2021-04-12 Sweden Orebro     24303 304 0 23999 59.535 15.0066 2021-04-13 04:20:37 Orebro, Sweden
785042 2021-04-11 Sweden Orebro     24303 304 0 23999 59.535 15.0066 2021-04-12 04:21:00 Orebro, Sweden
1392853 2021-04-10 Sweden Orebro     24303 304 0 23999 59.535 15.0066 2021-04-11 04:20:56 Orebro, Sweden
966284 2021-04-09 Sweden Orebro     24303 304 0 23999 59.535 15.0066 2021-04-10 04:20:59 Orebro, Sweden
690288 2021-04-08 Sweden Orebro     23872 304 0 23568 59.535 15.0066 2021-04-09 04:21:13 Orebro, Sweden
1277740 2021-04-07 Sweden Orebro     23668 303 0 23365 59.535 15.0066 2021-04-08 04:21:13 Orebro, Sweden
88759 2021-04-06 Sweden Orebro     23490 302 0 23188 59.535 15.0066 2021-04-07 04:20:53 Orebro, Sweden
123141 2021-04-05 Sweden Orebro     22472 301 0 22171 59.535 15.0066 2021-04-06 04:20:32 Orebro, Sweden
73643 2021-04-04 Sweden Orebro     22472 301 0 22171 59.535 15.0066 2021-04-05 04:20:35 Orebro, Sweden
792259 2021-04-03 Sweden Orebro     22472 301 0 22171 59.535 15.0066 2021-04-04 04:20:49 Orebro, Sweden
1020697 2021-04-02 Sweden Orebro     22472 301 0 22171 59.535 15.0066 2021-04-03 04:20:44 Orebro, Sweden
1350859 2021-04-01 Sweden Orebro     22472 301 0 22171 59.535 15.0066 2021-04-02 04:20:36 Orebro, Sweden
1691245 2021-03-31 Sweden Orebro     22112 301 0 21811 59.535 15.0066 2021-04-01 04:27:05 Orebro, Sweden
873614 2021-03-30 Sweden Orebro     21903 301 0 21602 59.535 15.0066 2021-03-31 04:26:25 Orebro, Sweden
1400661 2021-03-29 Sweden Orebro     21178 301 0 20877 59.535 15.0066 2021-03-30 04:26:23 Orebro, Sweden
1625064 2021-03-28 Sweden Orebro     21178 301 0 20877 59.535 15.0066 2021-03-29 04:28:35 Orebro, Sweden
1472494 2021-03-27 Sweden Orebro     21178 301 0 20877 59.535 15.0066 2021-03-28 05:28:10 Orebro, Sweden
721041 2021-03-26 Sweden Orebro     21178 301 0 20877 59.535 15.0066 2021-03-27 05:25:04 Orebro, Sweden
1617660 2021-03-25 Sweden Orebro     20977 300 0 20677 59.535 15.0066 2021-03-26 05:26:55 Orebro, Sweden
470321 2021-03-24 Sweden Orebro     20732 298 0 20434 59.535 15.0066 2021-03-25 05:27:00 Orebro, Sweden
1585361 2021-03-23 Sweden Orebro     20608 297 0 20311 59.535 15.0066 2021-03-24 05:25:40 Orebro, Sweden
717055 2021-03-22 Sweden Orebro     20084 296 0 19788 59.535 15.0066 2021-03-23 05:26:18 Orebro, Sweden
1675323 2021-03-21 Sweden Orebro     20084 296 0 19788 59.535 15.0066 2021-03-22 05:25:43 Orebro, Sweden
1747262 2021-03-20 Sweden Orebro     20084 296 0 19788 59.535 15.0066 2021-03-21 05:25:44 Orebro, Sweden
230384 2021-03-19 Sweden Orebro     20084 296 0 19788 59.535 15.0066 2021-03-20 05:25:46 Orebro, Sweden
478319 2021-03-18 Sweden Orebro     19885 295 0 19590 59.535 15.0066 2021-03-19 05:26:09 Orebro, Sweden
1426914 2021-03-17 Sweden Orebro     19761 295 0 19466 59.535 15.0066 2021-03-18 05:26:22 Orebro, Sweden
1593502 2021-03-16 Sweden Orebro     19627 295 0 19332 59.535 15.0066 2021-03-17 05:25:07 Orebro, Sweden
1176501 2021-03-15 Sweden Orebro     19283 295 0 18988 59.535 15.0066 2021-03-16 05:25:13 Orebro, Sweden
276186 2021-03-14 Sweden Orebro     19283 295 0 18988 59.535 15.0066 2021-03-15 05:25:51 Orebro, Sweden
1161328 2021-03-13 Sweden Orebro     19283 295 0 18988 59.535 15.0066 2021-03-14 05:25:37 Orebro, Sweden
22835 2021-03-12 Sweden Orebro     19283 295 0 18988 59.535 15.0066 2021-03-13 05:25:15 Orebro, 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]);