Table 4

Results of linkage process of crash-involved passengers (total number of records included in linkage process=1 050 182)

PassMatch criteria*Cumulative number (%) of passenger records that matched to at least one other data source
1Exact match on first name, last name, DOB, street name soundex, sex33 300 (4.7)
2†Match on first name soundex, last name soundex, DOB, street name soundex, sex, hospital element(s)33 704 (4.8)
3Match on first name soundex, last name soundex, DOB, street name soundex, sex35 754 (5.1)
4Exact match on first name, last name, DOB, sex47 926 (6.8)
5†Match on first name soundex, last name soundex, DOB, sex, hospital element(s)48 233 (6.8)
6Match on first name soundex, last name soundex, DOB, sex49 916 (7.1)
7Exact match on first name, last name, street name soundex, age, sex384 498 (54.5)
8†Match on first name soundex, last name soundex, street name soundex, age, sex, hospital element(s)392 483 (55.6)
9Match on first name soundex, last name soundex, street name soundex, age, sex457 345 (64.8)
10Exact match on first name, last name, street name soundex, sex469 855 (66.6)
11†Match on first name soundex, last name soundex, street name soundex, sex, hospital element(s)470 298 (66.7)
12Match on first name soundex, last name soundex, street name soundex, sex476 687 (67.6)
13Exact match on first name, last name, age, sex601 664 (85.3)
14†Match on first name soundex, last name soundex, age, sex, hospital element(s)605 642 (85.9)
15Match 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 fields656 882 (93.1)
16Match on first name soundex, last name soundex, age, sex705 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.