Chapter 45 15. Join mortality data to correspondence file
For Analysis 1, the cleaned cancer mortality data needs to be joined to the correspondence file using dbuid2016.
A dissemination block (DB) is a geographic area identifier. Many people can live in one dissemination block, but each dissemination block should correspond to one health region.
## # A tibble: 48,682 x 24
## ID Sex Cause_of_death letter number dbuid2016 Postalcode B_year B_month B_day D_year
## <dbl> <fct> <chr> <chr> <dbl> <dbl> <chr> <dbl> <dbl> <dbl> <dbl>
## 1 1000002 F C34 C 34 48060924001 T2E0T2 1943 5 22 2016
## 2 1000003 M C26 C 26 35204502002 M4J1L1 1953 8 9 2016
## 3 1000004 M C16 C 16 24663048013 H9H1B4 1923 6 14 2016
## 4 1000005 M C22 C 22 24560249013 J2W2B6 1931 8 8 2016
## 5 1000006 F C50 C 50 35250845002 L8H2K1 1933 11 4 2016
## 6 1000007 F C85 C 85 35370763005 N9Y3X5 1918 5 20 2016
## 7 1000008 F C56 C 56 35250788003 L8H7G2 1972 8 18 2016
## 8 1000009 F C64 C 64 24662429005 H9P2B3 1922 7 23 2016
## 9 1000010 M C22 C 22 48111094001 T5M1G2 1953 2 7 2016
## 10 1000011 F C50 C 50 12090210002 B3A4B2 1978 11 8 2016
## # i 48,672 more rows
## # i 13 more variables: D_month <dbl>, D_day <dbl>, DOB <date>, DOD <date>, Age <dbl>,
## # CauseCat <dbl>, CauseCat_label <chr>, AgeCat <fct>, csduid2016 <dbl>, hruid2017 <dbl>,
## # hrname_english <chr>, hrname_french <chr>, dbpop2016 <dbl>