Results of linkage process of crash-involved passengers (total number of records included in linkage process=1 050 182)
Pass | Match criteria* | Cumulative number (%) of passenger records that matched to at least one other data source |
1 | Exact match on first name, last name, DOB, street name soundex, sex | 33 300 (4.7) |
2† | Match on first name soundex, last name soundex, DOB, street name soundex, sex, hospital element(s) | 33 704 (4.8) |
3 | Match on first name soundex, last name soundex, DOB, street name soundex, sex | 35 754 (5.1) |
4 | Exact match on first name, last name, DOB, sex | 47 926 (6.8) |
5† | Match on first name soundex, last name soundex, DOB, sex, hospital element(s) | 48 233 (6.8) |
6 | Match on first name soundex, last name soundex, DOB, sex | 49 916 (7.1) |
7 | Exact match on first name, last name, street name soundex, age, sex | 384 498 (54.5) |
8† | Match on first name soundex, last name soundex, street name soundex, age, sex, hospital element(s) | 392 483 (55.6) |
9 | Match on first name soundex, last name soundex, street name soundex, age, sex | 457 345 (64.8) |
10 | Exact match on first name, last name, street name soundex, sex | 469 855 (66.6) |
11† | Match on first name soundex, last name soundex, street name soundex, sex, hospital element(s) | 470 298 (66.7) |
12 | Match on first name soundex, last name soundex, street name soundex, sex | 476 687 (67.6) |
13 | Exact match on first name, last name, age, sex | 601 664 (85.3) |
14† | Match on first name soundex, last name soundex, age, sex, hospital element(s) | 605 642 (85.9) |
15 | Match on non-null first initial and last initial, age and sex. Also meets criteria related to spelling distance for the last name, first name and street name fields | 656 882 (93.1) |
16 | Match on first name soundex, last name soundex, age, sex | 705 339 (100) |
*Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English.26
†Attempts 2, 5, 8, 11 and 14 were between passengers and crash-related or injury-related hospital records. Hospital elements included date of crash/admission, hospital county, and/or hospital code.
DOB, date of birth.