Data license: ODbL · Data source: our world in data github owid/covid-19-data repository

35 rows where "date" is on date 2020-01-05

View and edit SQL

Suggested facets: p_scores_all_ages, p_scores_0_14, p_scores_15_64, p_scores_65_74, p_scores_75_84, p_scores_85plus, delay, date (date)

Link rowid ▼ location date p_scores_all_ages p_scores_0_14 p_scores_15_64 p_scores_65_74 p_scores_75_84 p_scores_85plus deaths_2020_all_ages avg_deaths_2015_2019 deaths_2015_all_ages deaths_2016_all_ages deaths_2017_all_ages deaths_2018_all_ages deaths_2019_all_ages delay
1 Austria 2020-01-05 -11 -84 -5 -23 -5 -11 1611 1809 1704 1634 2293 1767 1647 7
41 Belgium 2020-01-05 -7 -17 -7 -1 -13 -5 2226 2390 2461 2244 2557 2382 2308 14
79 Bulgaria 2020-01-05 -19 -22 -22 -15 -21 -16 2105 2585 2502 2445 3169 2274 2533 14
118 Chile 2020-01-05 7 -15 5 13 3 12 2074 1932   1884 1878 1946 2019 14
157 Croatia 2020-01-05 -16 14 -11 -8 -29 -9 1012 1208 1177 1115 1465 1128 1154 14
190 Czech Republic 2020-01-05 -3 14 -4 -3 -1 -3 2303 2365 2378 2222 2763 2143 2321 14
223 Denmark 2020-01-05 0 -17 -12 4 -2 4 1116 1121 1127 1103 1113 1134 1130 14
262 England & Wales 2020-01-05 0 -6 -8 -4 3 3 12253 12199 12284 13045 11989 12721 10955 14
301 Estonia 2020-01-05 -14 11 -10 -20 -33 4 295 344 354 322 364 328 351 14
340 Finland 2020-01-05 -10 -75 -16 -2 -20 -4 1045 1165 1084 1184 1273 1072 1213 14
379 France 2020-01-05 -5 -19 -4 6 -13 -5 12722 13445 12804 11944 15509 14154 12813 14
415 Germany 2020-01-05 -2 -12 -3 -6 -2 -1 18892 19353   18467 20918 19342 18686 7
452 Greece 2020-01-05 -3 5 2 9 -15 1 2748 2825   2637 3425 2533 2706 14
480 Hungary 2020-01-05 -10 -44 -9 0 -11 -16 2609 2885 2800 2823 3155 2595 3054 14
516 Iceland 2020-01-05 24 -100 67 90 -3 11 57 46 49 44 35 62 39 14
547 Israel 2020-01-05 8 -17 2 12 3 13 1091 1011 936 1012 1128 1011 969 14
585 Italy 2020-01-05 -12 -22 -6 -11 -13 -13 12707 14455   12637 16889 15164 13131 14
609 Latvia 2020-01-05 -2 11 -15 -12 2 11 597 612 617 684 606 567 586 14
649 Lithuania 2020-01-05 -6 -41 -3 -4 -14 -3 808 863 844 845 958 826 842 7
688 Luxembourg 2020-01-05 -27 0 -32 -18 -27 -31 63 87 81 75 95 85 98 14
717 Netherlands 2020-01-05 -5 -11 -13 3 -8 -5 3102 3282 3259 3175 3570 3344 3061 7
757 New Zealand 2020-01-05 4 0 6 5 5 1 591 569 564 564 528 582 609 7
794 Northern Ireland 2020-01-05 -14 -64 -24 -6 -12 -15 353 411   421 414 447 362 14
833 Norway 2020-01-05 -7 82 0 -2 -10 -9 861 924 937 870 1006 938 871 14
872 Poland 2020-01-05 -1 -36 -12 17 -16 11 8438 8504 7984 8215 9279 8372 8668 14
910 Portugal 2020-01-05 -10 6 -9 -4 -16 -8 2510 2794 2813 2321 3366 2851 2621 14
948 Scotland 2020-01-05 -9 -13 -9 -14 -4 -11 1161 1276 1146 1394 1205 1531 1104 14
987 Slovakia 2020-01-05 -6 8 4 6 -19 -12 1090 1159 1112 1072 1411 1094 1105 14
1020 Slovenia 2020-01-05 -5 -100 -6 7 1 -14 419 442 408 451 479 401 469 14
1053 South Korea 2020-01-05 5 -13 1 -4 7 13 6424 6090 5699 5500 5958 7000 6292 28
1084 Spain 2020-01-05 -10 -14 -3 -1 -19 -8 8904 9864 9605 8658 10726 11204 9127 14
1123 Sweden 2020-01-05 -8 -10 -11 -13 1 -11 1821 1975 1927 1860 2149 1998 1943 14
1162 Switzerland 2020-01-05 -11 -3 -15 -3 -8 -13 1310 1469 1423 1340 1678 1561 1341 14
1199 United Kingdom 2020-01-05 34                         14
1221 United States 2020-01-05 0 -6 1 2 1 -2 59976 59860 59335 55784 59760 66129 58290 28

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "excess_mortality" (
"location" TEXT,
  "date" TEXT,
  "p_scores_all_ages" INTEGER,
  "p_scores_0_14" INTEGER,
  "p_scores_15_64" INTEGER,
  "p_scores_65_74" INTEGER,
  "p_scores_75_84" INTEGER,
  "p_scores_85plus" INTEGER,
  "deaths_2020_all_ages" INTEGER,
  "avg_deaths_2015_2019" INTEGER,
  "deaths_2015_all_ages" INTEGER,
  "deaths_2016_all_ages" INTEGER,
  "deaths_2017_all_ages" INTEGER,
  "deaths_2018_all_ages" INTEGER,
  "deaths_2019_all_ages" INTEGER,
  "delay" INTEGER
);