Table 2
Keys for deterministic hierarchical exact matching of 2006/2007 Discharge Abstract Database (DAD) to 2006 Census and cumulative percentage and number of DAD records linked, by iteration, Canada excluding Quebec
Table 2
Keys for deterministic hierarchical exact matching of 2006/2007 Discharge Abstract Database (DAD) to 2006 Census and cumulative percentage and number of DAD records linked, by iteration, Canada excluding Quebec
Table summary
This table displays the results of Keys for deterministic hierarchical exact matching of 2006/2007 Discharge Abstract Database (DAD) to 2006 Census and cumulative percentage and number of DAD records linked. The information is grouped by Description of key (appearing as row headers), DAD keys linked (appearing as column headers).
Description of key
DAD keys linked
Cumulative %
Cumulative number
Iteration
Postal codes used complete
1
birth date || sex || census postal code FSA LDU
72.2
1,521,386
2
birth date || sex || postal code from 2005 T1PMF FSA LDU
74.7
1,572,846
3
birth date || sex || postal code from 2006 T1PMF FSA LDU
75.9
1,597,970
4
birth date || sex || postal code from 2007 T1PMF FSA LDU
76.1
1,601,710
Postal codes used incomplete
5
birth date || sex || census postal code FSA LDx
76.9
1,619,231
6
birth date || sex || census postal code FSA LxU
78.3
1,649,492
7
birth date || sex || census postal code FSA xDU
78.6
1,655,680
8
birth date || sex || census postal code FSx LDU
79.3
1,670,817
9
birth date || sex || census postal code FxA LDU
79.4
1,672,933
10
birth date || sex || census postal code xSA LDU
79.6
1,676,645
11
birth date || sex || postal code from 2005 T1PMF FSA LDx
79.7
1,677,620
12
birth date || sex || postal code from 2005 T1PMF FSA LxU
79.8
1,679,792
13
birth date || sex || postal code from 2005 T1PMF FSA xDU
79.8
1,680,135
14
birth date || sex || postal code from 2005 T1PMF FSx LDU
79.8
1,681,110
15
birth date || sex || postal code from 2005 T1PMF FxA LDU
79.8
1,681,220
16
birth date || sex || postal code from 2005 T1PMF xSA LDU
79.8
1,681,572
17
birth date || sex || postal code from 2006 T1PMF FSA LDx
79.9
1,682,286
18
birth date || sex || postal code from 2006 T1PMF FSA LxU
79.9
1,683,627
19
birth date || sex || postal code from 2006 T1PMF FSA xDU
80.0
1,683,846
20
birth date || sex || postal code from 2006 T1PMF FSx LDU
80.0
1,684,437
21
birth date || sex || postal code from 2006 T1PMF FxA LDU
80.0
1,684,534
22
birth date || sex || postal code from 2006 T1PMF xSA LDU
80.0
1,684,744
23
birth date || sex || postal code from 2007 T1PMF FSA LDx
80.0
1,685,177
24
birth date || sex || postal code from 2007 T1PMF FSA LxU
80.1
1,686,116
25
birth date || sex || postal code from 2007 T1PMF FSA xDU
80.1
1,686,244
26
birth date || sex || postal code from 2007 T1PMF FSx LDU
80.1
1,686,711
27
birth date || sex || postal code from 2007 T1PMF FxA LDU
80.1
1,686,767
28
birth date || sex || postal code from 2007 T1PMF xSA LDU
80.1
1,686,973
Note: Postal codes have six digits. The first three—FSA—pertain to the Forward Sortation Area; the last three—LDU—pertain to the Local Delivery Unit. An "x" in a postal code (FSA LDU) indicates the digit dropped from linkage key.