Normalised records

Normalised records (silver)

Each raw row is parsed into consistently formatted fields. Every change from the raw value is recorded as a data-quality flag.

Normalised rows
99,495
usable in matching
Flagged rows
99,881
99.9% carry at least one flag
Junk quarantined
505
no usable last name
Average quality score
0.75
1.00 = no corrections needed

Quality flags

What normalisation had to do, and how often. Select a flag to filter the table.

Normalised records

Third-party administrator, lowest dq score first

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-62720TPARebecca Fox2000-12-04UHC-05601-414408713521—0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-61565TPAJacob Mitchell2005-05-03——3700 Hillcrest Rd, Eden Prairie, MN0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-58886TPADiana Estrada1987-06-14——6741 Cedar Ln, Fresno, CA, 937060.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52477TPAWillie L Shmidt1978-04-21UHC-26025-5347795308985446 Forest Ave, Charlotte, NC, 282010.68Middle initial moved out of first namePhone reformattedGender normalisedPlaceholder values cleared
TPA-60134TPADois Dunn1967-06-25——5802 Lake View Rd, Seattle, WA, 981510.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-59503TPAGrahm Deborah1986-12-05——5543 Maple Ave, San Antonio, TX, 782200.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-53585TPAVincent I Hayes1945-11-04——1652 Washington St, Phoenix, AZ, 850990.68Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed
TPA-51363TPAJoe Stephens1975-03-11—3118285793302 Church St, Columbus, OH, 432370.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-60051TPAScott Maldonado1988-06-23——5599 Palm Dr, Atlanta, GA, 303170.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57462TPA—Junk1967-01-23UHC-12402-61—4340 Canyon Rd, Chandler, AZ, 852520.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
TPA-62230TPABenjamin Mejia1944-06-10——2779 Cedar Ln, Plano, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-55318TPAElizabeth H Munoz1946-03-11——4796 Spring St, Columbus, OH, 432050.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-51791TPADylan C Webb1993-04-28—63876728482218 Harbor Blvd, Eden Prairie, MN, 553240.68Middle initial moved out of first namePhone reformattedState name converted to codePlaceholder values cleared
TPA-61387TPADonald Santiago2003-08-02—53922131504272 Harbor Blvd, Miami, FL0.68Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing
TPA-54756TPAAlbert Santos——66597909402953 Union St, Chandler, AZ, 852210.68Date of birth unreadableZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-53796TPAKetherine Williamson1999-08-27——6785 Sunset Blvd, Tucson, AZ0.68Date of birth reformattedState name converted to codeZIP missingPlaceholder values cleared
TPA-59479TPAAlexander Rivera1958-07-12——298 Washington St, Phoenix, AZ, 850870.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57335TPABenjamin Y Yang1944-10-04UHC-43975-07—5389 Desert Sky Blvd, Mesa, AZ, 852650.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57334TPABenjamin Y Yang1944-10-04UHC-43975-07—5389 Desert Sky Blvd, Mesa, AZ, 852650.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60702TPADeborah Vargas1944-06-26———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57211TPALaura Black1958-12-07——3594 Washington St, Houston, TX, 770920.68Name split from “Last, First”City re-casedZIP+4 trimmedPlaceholder values cleared
TPA-56479TPAAnn Schmidt1977-05-05—38787603949812 Palm Dr, Sacramento, CA, 958880.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-64206TPALinda Reid1941-09-26——3931 Harbor Blvd, San Diego, CA, 921040.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-54668TPABenjamin Maldonado1996-12-12—98527108853930 Apache Blvd, Scottsdale, AZ, 852830.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60750TPACharlotte Peters1997-05-10—36158841958173 Park Pl, Tampa, FL, 336050.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60751TPACharlotte Peters1997-05-10—36158841958173 Park Pl, Tampa, FL, 336050.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58052TPASara Y Grant1987-01-24——5202 Cedar Ln, Plano, TX, 750500.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-57538TPARussell Matthews——9684397875—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-57145TPACarlos Kennedy1976-02-05——4777 Palm Dr # 721, Orlando, FL, 328670.68Unit split from streetZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57372TPABrayn H Wood1953-06-28——8221 Willow Ct # 383, Mesa, AZ0.68Unit split from streetZIP missingWhitespace trimmedPlaceholder values cleared
TPA-59989TPAMateo Ray2006-10-13———0.68Name split from “Last, First”Date of birth reformattedSSN last four extractedPlaceholder values cleared
TPA-52398TPAJacob McDonald1938-03-26——2266 Washington St, Nashville, TN, 372130.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-62393TPABlack Evelyn1953-10-02——8411 Union St, Columbus, OH, 432280.68Name split from “Last, First”Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-63157TPAHenry Dominguez2000-08-01——9538 Mesa Dr # 521, Tampa, FL, 336620.68Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-52337TPABruce White1979-12-28—43855483481956 Market St, Tempe, AZ, 852790.68Phone reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-53987TPAKyle Rosss1970-08-03——6425 Baseline Rd, Fresno, CA, 937360.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-51910TPAJoe S King1995-08-07UHC-65740-09—265 Palm Dr Apt 32, Miami, FL, 331540.68Name re-casedUnit split from streetGender normalisedPlaceholder values cleared
TPA-57236TPABruce J Gray1977-11-28——2080 River Rd, Nashville, TN, 372490.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53761TPAJoshua O Sanchez1998-09-25—39449025547066 Lincoln Way, Dallas, TX, 752820.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
TPA-52308TPAAlexis Washington1997-12-03——5669 Valley View Dr, Columbus, OH, 432340.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62936TPAAustin Jensen1945-08-06——6006 Church St, San Diego, CA0.68Date of birth reformattedZIP missingGender normalisedPlaceholder values cleared
TPA-54873TPAMaria Kelly1970-02-25——478 Spring St, Minneapolis, MN, 554560.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54751TPADylan Larson————0.68Name re-casedDate of birth missingGender normalisedPlaceholder values cleared
TPA-53883TPAAaron Andrews2007-04-08——6597 Church St # 966, San Diego, CA, 921700.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50594TPACynthia Hansen1971-01-22UHC-95339-89—388 Cedar Ln, Tucson, AZ, 857480.68Date of birth reformattedPhone missing area codeGender normalisedPlan code upper-cased
TPA-62269TPALucia White1997-06-02——8826 Cedar Ln, Jacksonville, FL0.68State code upper-casedZIP missingGender normalisedPlaceholder values cleared
TPA-53311TPABruce Sanchez1966-12-13—94094832069891 Highland Ave, Tempe, AZ, 852160.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
TPA-58221TPAAshley Mitchell1994-09-14——181 Grand Ave, Phoenix, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-56152TPAJoyce Reyes2008-12-04——1156 Broadway, Dallas, TX0.68Name re-casedState name converted to codeZIP missingPlaceholder values cleared
TPA-51673TPAMei Rogers1954-02-16——4173 Pine Dr, San Antonio, TX, 782730.68Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed
14,474 rows, page 97 of 290PreviousNext