⚠️ 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

8,211 rows where country_or_region = "Sweden" sorted by confirmed

View and edit SQL

Suggested facets: recovered, latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Sweden · 8,211
Link rowid day country_or_region province_or_state admin2 fips confirmed ▼ deaths recovered active latitude longitude last_update combined_key
120867 2020-02-21 Sweden       1 0 0       2020-02-01T02:13:26  
153357 2020-02-25 Sweden       1 0 0       2020-02-01T02:13:26  
226617 2020-02-09 Sweden       1 0 0       2020-02-01T02:13:26  
242417 2020-02-05 Sweden       1 0 0       2020-02-01T02:13:26  
354006 2020-02-18 Sweden       1 0 0       2020-02-01T02:13:26  
379593 2020-02-16 Sweden       1 0 0       2020-02-01T02:13:26  
491504 2020-02-20 Sweden       1 0 0       2020-02-01T02:13:26  
673564 2020-02-06 Sweden       1 0 0       2020-02-01T02:13:26  
677627 2020-02-04 Sweden       1 0 0       2020-02-01T02:13:26  
708827 2020-02-15 Sweden       1 0 0       2020-02-01T02:13:26  
754578 2020-02-19 Sweden       1 0 0       2020-02-01T02:13:26  
754656 2020-02-11 Sweden       1 0 0       2020-02-01T02:13:26  
874538 2020-02-07 Sweden       1 0 0       2020-02-01T02:13:26  
885811 2020-02-13 Sweden       1 0 0       2020-02-01T02:13:26  
965394 2020-02-14 Sweden       1 0 0       2020-02-01T02:13:26  
1012448 2020-02-23 Sweden       1 0 0       2020-02-01T02:13:26  
1023614 2020-01-31 Sweden       1 0 0       1/31/2020 23:59  
1143347 2020-02-08 Sweden       1 0 0       2020-02-01T02:13:26  
1215250 2020-02-03 Sweden       1 0 0       2020-02-01T02:13:26  
1311413 2020-02-10 Sweden       1 0 0       2020-02-01T02:13:26  
1369542 2020-02-17 Sweden       1 0 0       2020-02-01T02:13:26  
1403290 2020-02-22 Sweden       1 0 0       2020-02-01T02:13:26  
1523232 2020-02-02 Sweden       1 0 0       2020-02-01T02:13:26  
1586185 2020-02-12 Sweden       1 0 0       2020-02-01T02:13:26  
1637568 2020-02-01 Sweden       1 0 0       2/1/2020 2:13  
1684556 2020-02-24 Sweden       1 0 0       2020-02-01T02:13:26  
1086540 2020-02-26 Sweden       2 0 0       2020-02-26T18:53:02  
685400 2020-02-27 Sweden       7 0 0       2020-02-27T20:33:02  
1560776 2020-02-28 Sweden       7 0 0       2020-02-27T20:33:02  
965255 2020-02-29 Sweden       12 0 0       2020-02-29T14:43:03  
1507988 2020-03-01 Sweden       14 0 0   63.0 16.0 2020-03-01T23:23:02  
598658 2020-03-02 Sweden       15 0 0   63.0 16.0 2020-03-02T20:53:02  
1120068 2020-03-03 Sweden       21 0 0   63.0 16.0 2020-03-03T15:13:26  
132893 2020-03-04 Sweden       35 0 0   63.0 16.0 2020-03-04T12:33:03  
56821 2020-06-05 Sweden Gotland     88 6 0 82 57.4684 18.4867 2020-06-06 02:33:00 Gotland, Sweden
1410460 2020-06-06 Sweden Gotland     89 6 0 83 57.4684 18.4867 2020-06-07 03:53:30 Gotland, Sweden
1078270 2020-06-08 Sweden Gotland     90 6 0 84 57.4684 18.4867 2020-06-09 03:33:03 Gotland, Sweden
1187623 2020-06-07 Sweden Gotland     90 6 0 84 57.4684 18.4867 2020-06-08 03:33:22 Gotland, Sweden
330035 2020-06-09 Sweden Gotland     91 6 0 85 57.4684 18.4867 2020-06-10 04:07:00 Gotland, Sweden
1107989 2020-03-05 Sweden       94 0 0   63.0 16.0 2020-03-05T18:03:03  
765786 2020-06-10 Sweden Gotland     97 6 0 91 57.4684 18.4867 2020-06-11 03:33:41 Gotland, Sweden
1644756 2020-06-11 Sweden Gotland     99 6 0 93 57.4684 18.4867 2020-06-12 05:09:52 Gotland, Sweden
1188176 2020-03-06 Sweden       101 0 0   63.0 16.0 2020-03-06T13:03:12  
1248499 2020-06-12 Sweden Gotland     106 6 0 100 57.4684 18.4867 2020-06-13 03:33:14 Gotland, Sweden
106505 2020-06-13 Sweden Gotland     109 6 0 103 57.4684 18.4867 2020-06-14 03:33:15 Gotland, Sweden
1515217 2020-06-15 Sweden Gotland     109 6 0 103 57.4684 18.4867 2020-06-16 04:33:09 Gotland, Sweden
1652494 2020-06-14 Sweden Gotland     109 6 0 103 57.4684 18.4867 2020-06-15 03:33:14 Gotland, Sweden
1731688 2020-06-16 Sweden Gotland     114 6 0 108 57.4684 18.4867 2020-06-17 04:33:21 Gotland, Sweden
980537 2020-06-17 Sweden Gotland     118 6 0 112 57.4684 18.4867 2020-06-18 04:33:18 Gotland, Sweden
241809 2020-06-20 Sweden Gotland     122 6 0 116 57.4684 18.4867 2020-06-21 04:33:19 Gotland, Sweden
660998 2020-06-21 Sweden Gotland     122 6 0 116 57.4684 18.4867 2020-06-22 04:33:20 Gotland, Sweden
680852 2020-06-18 Sweden Gotland     122 6 0 116 57.4684 18.4867 2020-06-19 04:33:17 Gotland, Sweden
1240766 2020-06-19 Sweden Gotland     122 6 0 116 57.4684 18.4867 2020-06-20 04:33:19 Gotland, Sweden
64543 2020-06-22 Sweden Gotland     131 6 0 125 57.4684 18.4867 2020-06-23 04:33:22 Gotland, Sweden
1302848 2020-06-23 Sweden Gotland     137 6 0 131 57.4684 18.4867 2020-06-24 04:33:28 Gotland, Sweden
1763705 2020-06-24 Sweden Gotland     144 7 0 137 57.4684 18.4867 2020-06-25 05:26:54 Gotland, Sweden
279758 2020-06-28 Sweden Gotland     147 7 0 140 57.4684 18.4867 2020-06-29 04:33:44 Gotland, Sweden
769575 2020-06-26 Sweden Gotland     147 7 0 140 57.4684 18.4867 2020-06-27 04:33:35 Gotland, Sweden
1092933 2020-06-27 Sweden Gotland     147 7 0 140 57.4684 18.4867 2020-06-28 04:34:04 Gotland, Sweden
1656285 2020-06-25 Sweden Gotland     147 7 0 140 57.4684 18.4867 2020-06-26 04:33:43 Gotland, Sweden
506704 2020-06-29 Sweden Gotland     154 7 0 147 57.4684 18.4867 2020-06-30 04:33:48 Gotland, Sweden
587941 2020-06-30 Sweden Gotland     160 7 0 153 57.4684 18.4867 2020-07-01 04:33:52 Gotland, Sweden
199301 2020-03-07 Sweden       161 0 0   63.0 16.0 2020-03-07T17:53:03  
120249 2020-07-05 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-06 04:33:57 Gotland, Sweden
728048 2020-07-04 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-05 04:33:46 Gotland, Sweden
873929 2020-07-01 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-02 04:33:46 Gotland, Sweden
1026878 2020-07-02 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-03 04:33:54 Gotland, Sweden
1337985 2020-07-03 Sweden Gotland     162 6 0 156 57.4684 18.4867 2020-07-04 04:33:51 Gotland, Sweden
753965 2020-07-06 Sweden Gotland     165 6 0 159 57.4684 18.4867 2020-07-07 04:34:00 Gotland, Sweden
456378 2020-07-08 Sweden Gotland     174 6 0 168 57.4684 18.4867 2020-07-09 04:34:23 Gotland, Sweden
1486165 2020-07-07 Sweden Gotland     174 6 0 168 57.4684 18.4867 2020-07-08 05:33:48 Gotland, Sweden
1683933 2020-07-09 Sweden Gotland     177 6 0 171 57.4684 18.4867 2020-07-10 04:34:24 Gotland, Sweden
1345038 2020-07-12 Sweden Gotland     181 6 0 175 57.4684 18.4867 2020-07-13 04:43:04 Gotland, Sweden
1387991 2020-07-11 Sweden Gotland     181 6 0 175 57.4684 18.4867 2020-07-12 04:34:30 Gotland, Sweden
1632821 2020-07-10 Sweden Gotland     181 6 0 175 57.4684 18.4867 2020-07-11 04:34:26 Gotland, Sweden
893089 2020-07-13 Sweden Gotland     182 6 0 176 57.4684 18.4867 2020-07-14 04:34:46 Gotland, Sweden
1256315 2020-07-14 Sweden Gotland     186 6 0 180 57.4684 18.4867 2020-07-15 04:34:39 Gotland, Sweden
1414261 2020-07-16 Sweden Gotland     189 6 0 183 57.4684 18.4867 2020-07-17 04:34:50 Gotland, Sweden
1636653 2020-07-15 Sweden Gotland     189 6 0 183 57.4684 18.4867 2020-07-16 04:44:59 Gotland, Sweden
866132 2020-07-17 Sweden Gotland     196 6 0 190 57.4684 18.4867 2020-07-18 04:34:45 Gotland, Sweden
1119460 2020-07-19 Sweden Gotland     196 6 0 190 57.4684 18.4867 2020-07-20 05:34:40 Gotland, Sweden
1229832 2020-07-18 Sweden Gotland     196 6 0 190 57.4684 18.4867 2020-07-19 04:34:58 Gotland, Sweden
1540523 2020-03-08 Sweden       203 0 0   63.0 16.0 2020-03-08T14:03:12  
375683 2020-07-20 Sweden Gotland     206 6 0 200 57.4684 18.4867 2020-07-21 04:38:46 Gotland, Sweden
1034766 2020-07-21 Sweden Gotland     206 6 0 200 57.4684 18.4867 2020-07-22 04:34:42 Gotland, Sweden
1391916 2020-07-22 Sweden Gotland     212 6 0 206 57.4684 18.4867 2020-07-23 05:15:04 Gotland, Sweden
928821 2020-07-23 Sweden Gotland     217 6 0 211 57.4684 18.4867 2020-07-24 05:30:40 Gotland, Sweden
537290 2020-07-24 Sweden Gotland     219 6 0 213 57.4684 18.4867 2020-07-25 04:47:39 Gotland, Sweden
1169234 2020-07-25 Sweden Gotland     219 6 0 213 57.4684 18.4867 2020-07-26 04:35:00 Gotland, Sweden
1511448 2020-07-26 Sweden Gotland     219 6 0 213 57.4684 18.4867 2020-07-27 04:35:02 Gotland, Sweden
260945 2020-07-29 Sweden Gotland     230 6 0 224 57.4684 18.4867 2020-07-30 04:35:05 Gotland, Sweden
341871 2020-07-28 Sweden Gotland     230 6 0 224 57.4684 18.4867 2020-07-29 04:35:11 Gotland, Sweden
482905 2020-07-27 Sweden Gotland     230 6 0 224 57.4684 18.4867 2020-07-28 04:58:43 Gotland, Sweden
1526632 2020-07-30 Sweden Gotland     238 6 0 232 57.4684 18.4867 2020-07-31 04:35:18 Gotland, Sweden
191102 2020-07-31 Sweden Gotland     248 6 0 242 57.4684 18.4867 2020-08-01 04:36:27 Gotland, Sweden
425856 2020-03-09 Sweden       248 0 1   63.0 16.0 2020-03-09T18:33:03  
932777 2020-08-01 Sweden Gotland     248 6 0 242 57.4684 18.4867 2020-08-02 04:34:47 Gotland, Sweden
1107397 2020-08-02 Sweden Gotland     248 6 0 242 57.4684 18.4867 2020-08-03 04:34:35 Gotland, Sweden
731982 2020-08-03 Sweden Gotland     250 6 0 244 57.4684 18.4867 2020-08-04 04:41:59 Gotland, Sweden
762044 2020-08-04 Sweden Gotland     251 6 0 245 57.4684 18.4867 2020-08-05 04:34:43 Gotland, 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]);