Routine data monitoring – Practical 28/11/2024
Part 1
Using the webpage of GBD answer the following questions:
1. What causes contribute more to DALYs globally up to 2021: Chronic diseases, infectious
and neonatal diseases, or injuries?
2. What causes contribute more to YLDs globally up to 2021: Chronic diseases, infectious
and neonatal diseases, or injuries?
3. In which sex COVID19 caused more deaths?
4. What was the main cause of death in Czechia in 2021?
5. Compared with high socio-demographic index (SDI) countries, what was the difference
in death rate in Czechia in 2021?
6. What are the categories of risk factors in GBD webpage?
7. High systolic blood pressure is a risk factor for multiple diseases. Identify all the
diseases that can benefit of blood pressure control and write the respective attributable
risk percentage.
Part 2
Based on the dataset provided answer the following questions:
1. What is the most frequent cause of death by country?
2. Complete the chart of good/excellent health by: Czech Republic (1) vs Slovakia (2)
○ Czech Republic ∆ Slovakia
3. Did health improve in any country?
4. What is the most frequent cause of death in females?
5. What is the frequency of sickness in the last 3 months by age group?
Codebook Practical
Year: year of survey
Country:
1: Czechia
2: Slovakia
ID: Identification Number
Female:
0: Male
1: Female
Age_group:
1: 20-45 years
2: 46-70 years
3: >70 years
Employed:
1: Yes
0: No
Sick_3mon: Have you been sick in the last 3 months?
1: Yes
0: No
Heath_sta: How you rate your health in the last 3 months?
0: Poor
1: Good/Excellent
Status: Dead or alive in 2024
0: Alive
1: Dead
Cause: Cause of death
1: Heart attack
2: Cancer
3: Other
Year_dead: Year of Death
Year Country ID Female Age_group Employed Sick_3mon Health_sta ID Status Cause Year_dead
1970 1 1001 1 2 1 0 0 1001 0
1971 1 1002 0 1 1 0 0 1002 1 1 1980
1972 1 1003 1 2 1 0 1 1003 1 1 1990
1973 1 1004 0 1 1 0 1 1004 0
1970 1 1005 1 2 1 0 0 1005 0
1971 1 1006 0 3 1 0 1 1006 1 1 2005
1972 1 1007 1 3 0 1 1 1007 1 2 2007
1973 1 1008 0 2 0 1 0 1008 0
1970 1 1009 1 1 0 0 0 1009 1 3 1980
1971 1 1010 1 1 1 0 0 1010 0
1972 1 1011 0 2 1 0 1 1011 0
1973 1 1012 1 3 1 1 1 1012 1 1 1992
1970 1 1013 0 2 1 0 1 1013 0
1971 1 1014 1 2 1 0 1 1014 1 1 2015
1972 1 1015 1 1 1 0 1 1015 0
1973 1 1016 0 2 1 0 1 1016 1 2 2007
1970 1 1017 1 3 0 1 0 1017 1 3 1980
1971 1 1018 0 1 0 0 0 1018 1 1 1972
1972 1 1019 1 1 1 0 0 1019 1 2 2003
1973 1 1020 0 2 1 0 1 1020 1 3 2008
1970 1 1021 1 3 1 0 0 1021 1 1 1980
1971 1 1022 0 1 1 1 1 1022 0
1972 1 1023 1 2 1 0 0 1023 0
1973 1 1024 0 3 1 1 1 1024 1 1 2001
1970 1 1025 1 1 1 0 0 1025 0
1971 1 1026 0 2 1 1 1 1026 1 1 1998
1972 1 1027 0 3 1 1 0 1027 1 2 2000
1973 1 1028 0 1 1 0 1 1028 1 1 1995
1970 1 1029 0 2 0 0 0 1029 1 1 2013
1971 1 1030 1 3 1 0 0 1030 1 3 1986
1972 2 1031 1 1 1 0 0 1031 1 1 2020
1973 2 1032 0 2 1 0 0 1032 0
1970 2 1033 1 3 0 0 0 1033 1 1 2003
1971 2 1034 0 1 0 0 0 1034 1 2 2020
1972 2 1035 1 2 1 0 0 1035 1 2 2005
1973 2 1036 0 3 1 1 1 1036 1 1 1979
1970 2 1037 1 1 1 1 1 1037 0
1971 2 1038 0 2 1 1 1 1038 1 3 1998
1972 2 1039 1 3 1 1 0 1039 1 2 1996
1973 2 1040 0 1 1 0 0 1040 1 2 2005
1970 2 1041 1 2 1 0 0 1041 1 1 2000
1971 2 1042 0 1 1 0 0 1042 0
1972 2 1043 1 1 1 0 0 1043 0
1973 2 1044 0 2 0 0 0 1044 0
1970 2 1045 1 3 0 1 0 1045 1 2 1996
1971 2 1046 0 1 0 0 0 1046 1 2 1980
1972 2 1047 1 2 1 0 1 1047 1 3 1986
1973 2 1048 0 3 1 1 1 1048 1 1 2002
1970 2 1049 1 1 0 0 0 1049 0
1971 2 1050 0 2 1 0 1 1050 0
1972 2 1051 1 3 1 1 1 1051 1 2 1978
1973 2 1052 0 1 1 0 0 1052 0
1970 2 1053 1 2 1 0 1 1053 0
1971 2 1054 1 1 1 0 0 1054 1 2 2015
1972 2 1055 0 2 1 0 0 1055 1 1 1998
1973 2 1056 1 1 1 0 0 1056 1 1 2020
1970 2 1057 0 2 1 0 0 1057 0
1971 2 1058 1 3 0 1 0 1058 1 3 1980
1972 2 1059 0 1 1 0 0 1059 1 2 2021
1973 2 1060 1 2 1 0 0 1060 0