Causes Of Death - Standardised Death Rate By Country Of Residence, Monthly Data
Eurostat code: hlth_cd_msdr2 ยท (2019-01 - 2022-12)
@eurostat.hlth_cd_msdr2
Eurostat code: hlth_cd_msdr2 ยท (2019-01 - 2022-12)
@eurostat.hlth_cd_msdr2
This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.
freqFreq | unitUnit | sexSex | ageAge | icd10Icd10 | geoGeo | n_2019_012019-01 | n_2019_022019-02 | n_2019_032019-03 | n_2019_042019-04 | n_2019_052019-05 | n_2019_062019-06 | n_2019_072019-07 | n_2019_082019-08 | n_2019_092019-09 | n_2019_102019-10 | n_2019_112019-11 | n_2019_122019-12 | n_2020_012020-01 | n_2020_022020-02 | n_2020_032020-03 | n_2020_042020-04 | n_2020_052020-05 | n_2020_062020-06 | n_2020_072020-07 | n_2020_082020-08 | n_2020_092020-09 | n_2020_102020-10 | n_2020_112020-11 | n_2020_122020-12 | n_2021_012021-01 | n_2021_022021-02 | n_2021_032021-03 | n_2021_042021-04 | n_2021_052021-05 | n_2021_062021-06 | n_2021_072021-07 | n_2021_082021-08 | n_2021_092021-09 | n_2021_102021-10 | n_2021_112021-11 | n_2021_122021-12 | n_2022_012022-01 | n_2022_022022-02 | n_2022_032022-03 | n_2022_042022-04 | n_2022_052022-05 | n_2022_062022-06 | n_2022_072022-07 | n_2022_082022-08 | n_2022_092022-09 | n_2022_102022-10 | n_2022_112022-11 | n_2022_122022-12 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Austria | 71.18 | 67.45 | 71.78 | 64.17 | 61.17 | 58.98 | 60.85 | 59.52 | 59.12 | 64.72 | 62.96 | 66.43 | 74.2 | 66.95 | 72.23 | 66.71 | 59.74 | 57.75 | 59.46 | 61.56 | 60.87 | 68.54 | 87.02 | 94.97 | 82.24 | 64.56 | 67.08 | 65.77 | 62.4 | 63.38 | 60.76 | 63.41 | 64.1 | 69.16 | 80.21 | 82.69 | ||||||||||||
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Belgium | 73.17 | 70.37 | 70.64 | 61.32 | 63.28 | 58.68 | 61.62 | 59.18 | 56.75 | 62.28 | 62.89 | 68.53 | 70.67 | 65.38 | 79.44 | 110.24 | 67.17 | 57.22 | 56.2 | 70.38 | 57.12 | 72.53 | 95.74 | 82.24 | 72.77 | 61.8 | 64.18 | 62.8 | 61.51 | 55.49 | 60.07 | 56.07 | 56.67 | 67.46 | 68.82 | 75.67 | ||||||||||||
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Bulgaria | 135.83 | 104.86 | 108.19 | 99.8 | 101 | 97.57 | 93.86 | 93.57 | 84.04 | 98.63 | 100.18 | 105.37 | 112.09 | 106.02 | 102.38 | 95.94 | 94.64 | 92.74 | 98.99 | 96.87 | 90.98 | 109.21 | 183.27 | 183.32 | 125.41 | 109.33 | 157.6 | 170.39 | 121.71 | 102.4 | 101.77 | 113.86 | 130.45 | 179.14 | 191.68 | 159.04 | ||||||||||||
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Cyprus | 91.38 | 73.54 | 76.69 | 69.83 | 72.06 | 46.87 | 61.98 | 64.45 | 55.18 | 58.71 | 57.45 | 72.5 | 90.14 | 75.56 | 74.54 | 68.76 | 75.9 | 50.7 | 62.16 | 54.18 | 54.07 | 60.73 | 62.48 | 81.52 | 85.76 | 68.5 | 75.07 | 78.92 | 62.22 | 54.69 | 82.6 | 90.69 | 62.32 | 65.58 | 67.24 | 84.79 | ||||||||||||
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Czechia | 88.92 | 81.87 | 82.34 | 76.14 | 74.63 | 73.69 | 75.54 | 74.41 | 71.94 | 79.62 | 76.91 | 82.39 | 83.8 | 81.09 | 84.82 | 75.73 | 72.56 | 72.63 | 73.99 | 77.35 | 76.59 | 115.61 | 128.45 | 115.26 | 125.3 | 106.01 | 125.84 | 91.06 | 76.04 | 70.58 | 70.98 | 70.75 | 73.47 | 82.84 | 104.73 | 112.63 | ||||||||||||
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Denmark | 78.44 | 72.68 | 73.1 | 72.26 | 69.65 | 67.44 | 65.13 | 65.93 | 66.48 | 66.49 | 68.96 | 74.63 | 72.91 | 66.3 | 73.19 | 71.93 | 66.51 | 63.36 | 65.77 | 65.93 | 65.13 | 65.76 | 68.93 | 80.3 | 80.95 | 64.72 | 65.8 | 64.45 | 68.89 | 65.5 | 68.46 | 71.08 | 68.85 | 74.43 | 73.07 | 81.85 | ||||||||||||
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Estonia | 84.18 | 73.55 | 76.39 | 66.5 | 68.99 | 68.57 | 71.67 | 69.02 | 66.59 | 69.88 | 68.28 | 72.56 | 73.28 | 75 | 79.02 | 73.44 | 69.08 | 68.62 | 69.9 | 69.45 | 73.06 | 71.77 | 70.14 | 80.43 | 89.51 | 83.4 | 96.17 | 88.8 | 77.63 | 76.83 | 74.36 | 72.81 | 74.97 | 86.21 | 95.61 | 94.4 | ||||||||||||
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Greece | 85.63 | 70.85 | 70.89 | 65.78 | 64.35 | 66.08 | 64.78 | 66.78 | 59.08 | 60.58 | 63.53 | 70.49 | 81.82 | 71.3 | 73.57 | 63.95 | 62.94 | 60.59 | 66.9 | 69.72 | 61.11 | 62.1 | 78.55 | 82.17 | 72.57 | 62.59 | 75.93 | 75.94 | 72.05 | 68.97 | 77.59 | 86.11 | 67.93 | 69.46 | 79.6 | 90.46 | ||||||||||||
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Spain | 67.81 | 56.74 | 55.41 | 50.96 | 50.88 | 47.74 | 50.85 | 47.85 | 44.81 | 49.25 | 51.52 | 54.81 | 64.05 | 54.39 | 82.54 | 92.9 | 52.88 | 46.44 | 52.36 | 54.67 | 50.69 | 57.68 | 61.65 | 60.83 | 74.4 | 57.68 | 52.19 | 50.2 | 49.54 | 47.55 | 51.47 | 55.35 | 47.66 | 50.42 | 54.29 | 61.27 | ||||||||||||
Monthly | Rate | Females | Total | All causes of death (A00-Y89) excluding S00-T98 | Finland | 70.59 | 60.8 | 68.81 | 61.54 | 59.42 | 56.03 | 57.91 | 58.01 | 61.28 | 64.03 | 60.29 | 67.21 | 62.39 | 60.94 | 65.3 | 67.54 | 63.57 | 59.35 | 57.97 | 58.94 | 61.04 | 63.3 | 61.54 | 67.35 | 66.12 | 59.49 | 62.63 | 57.66 | 60.32 | 57.62 | 61.64 | 63.65 | 63.63 | 67.78 | 67.6 | 72.57 |
CREATE TABLE raw (
"freq" VARCHAR,
"unit" VARCHAR,
"sex" VARCHAR,
"age" VARCHAR,
"icd10" VARCHAR,
"geo" VARCHAR,
"n_2019_01" DOUBLE,
"n_2019_02" DOUBLE,
"n_2019_03" DOUBLE,
"n_2019_04" DOUBLE,
"n_2019_05" DOUBLE,
"n_2019_06" DOUBLE,
"n_2019_07" DOUBLE,
"n_2019_08" DOUBLE,
"n_2019_09" DOUBLE,
"n_2019_10" DOUBLE,
"n_2019_11" DOUBLE,
"n_2019_12" DOUBLE,
"n_2020_01" DOUBLE,
"n_2020_02" DOUBLE,
"n_2020_03" DOUBLE,
"n_2020_04" DOUBLE,
"n_2020_05" DOUBLE,
"n_2020_06" DOUBLE,
"n_2020_07" DOUBLE,
"n_2020_08" DOUBLE,
"n_2020_09" DOUBLE,
"n_2020_10" DOUBLE,
"n_2020_11" DOUBLE,
"n_2020_12" DOUBLE,
"n_2021_01" DOUBLE,
"n_2021_02" DOUBLE,
"n_2021_03" DOUBLE,
"n_2021_04" DOUBLE,
"n_2021_05" DOUBLE,
"n_2021_06" DOUBLE,
"n_2021_07" DOUBLE,
"n_2021_08" DOUBLE,
"n_2021_09" DOUBLE,
"n_2021_10" DOUBLE,
"n_2021_11" DOUBLE,
"n_2021_12" DOUBLE,
"n_2022_01" DOUBLE,
"n_2022_02" DOUBLE,
"n_2022_03" DOUBLE,
"n_2022_04" DOUBLE,
"n_2022_05" DOUBLE,
"n_2022_06" DOUBLE,
"n_2022_07" DOUBLE,
"n_2022_08" DOUBLE,
"n_2022_09" DOUBLE,
"n_2022_10" DOUBLE,
"n_2022_11" DOUBLE,
"n_2022_12" DOUBLE
);
Anyone who has the link will be able to view this.