Table 2.
Number of matching, non-matching, and missing values for each identifier field within the set of 7,293 linked neonatal records.
| Identifier Field | Matching N, % | Non-Matching N, % | Missing from Only Physician Billing Records N, % | Missing from Only Newborn Medical Records N, % | Missing from Both Physician Billing and Newborn Medical Records N, % |
|---|---|---|---|---|---|
| Infant Sex | 7,281, 99.8% | 11, 0.2% | 0, 0.0% | 1, 0.0% | 0, 0.0% |
| Date of Birth | 7,280, 99.8% | 13, 0.2% | 0, 0.0% | 0, 0.0% | 0, 0.0% |
| Mother Surname (Soundex-Encoded) | 6,945, 95.2% | 270, 3.7% | 72, 1.0% | 5, 0.1% | 1, 0.0% |
| Mother Surname | 6,865, 94.1% | 350, 4.8% | 72, 1.0% | 5, 0.1% | 1, 0.0% |
| Mother First Name (Soundex-Encoded) | 6,376, 87.4% | 100, 1.4% | 71, 1.0% | 745, 10.2% | 1, 0.0% |
| Mother First Name | 6,276, 86.1% | 200, 2.7% | 71, 1.0% | 745, 10.2% | 1, 0.0% |
| Zip Code | 6,265, 85.9% | 867, 11.9% | 0, 0.0% | 161, 2.2% | 0, 0.0% |
| Street Number | 6,023, 82.6% | 1,109, 15.2% | 0, 0.0% | 161, 2.2% | 0, 0.0% |
| Birth Weight (Nearest 10 Grams) | 5,963, 81.8% | 971, 13.3% | 228, 3.1% | 120, 1.6% | 11, 0.2% |
| Street Name (Soundex-Encoded) | 5,793, 79.4% | 1,300, 17.8% | 16, 0.2% | 182, 2.5% | 2, 0.0% |
| Street Name | 5,642, 77.4% | 1,451, 19.9% | 16, 0.2% | 182, 2.5% | 2, 0.0% |
| Mother or Father Surname (Physician Billing) to Infant Surname (Newborn Medical) (Soundex-Encoded) | 5,211, 71.5% | 2,020, 27.7% | 62, 0.9% | 0, 0.0% | 0, 0.0% |
| Mother or Father Surname (Physician Billing) to Infant Surname (Newborn Medical) | 5,146, 70.6% | 2,085, 28.6% | 62, 0.9% | 0, 0.0% | 0, 0.0% |
| Infant Surname (Soundex-Encoded) | 5,047, 69.2% | 2,246, 30.8% | 0, 0.0% | 0, 0.0% | 0, 0.0% |
| Infant Surname | 5,003, 68.6% | 2,290, 31.4% | 0, 0.0% | 0, 0.0% | 0, 0.0% |
| Mother Surname to Infant Surname (Soundex-Encoded) | 4,212, 57.7% | 3,008, 41.2% | 73,1.0% | 0, 0.0% | 0, 0.0% |
| Mother Surname to Infant Surname | 4,173, 57.2% | 3,047, 41.8% | 73, 1.0% | 0, 0.0% | 0, 0.0% |
| Birth Weight (Exact) | 3,516, 48.2% | 3,418, 46.9% | 228, 3.1% | 120, 1.6% | 11, 0.2% |
| Street Address | 3,437, 47.1% | 3,695, 50.7% | 0, 0.0% | 161, 2.2% | 0, 0.0% |
| Infant First Name (Soundex-Encoded) | 2,898, 39.7% | 91, 1.2% | 806, 11.1% | 2,700, 37.0% | 798, 10.9% |
| Infant First Name | 2,803, 38.4% | 186, 2.6% | 806, 11.1% | 2,700, 37.0% | 798, 10.9% |
| Father Surname (Physician Billing) to Infant Surname (Newborn Medical) (Soundex-Encoded) | 2,210, 30.3% | 1,585, 21.7% | 3,498, 48.0% | 0, 0.0% | 0, 0.0% |
| Father Surname (Physician Billing) to Infant Surname (Newborn Medical) | 2,159, 29.6% | 1,636, 22.4% | 3,498, 48.0% | 0, 0.0% | 0, 0.0% |