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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-54098TPATeresa U Greene1966-10-05—80967197276237 Oak St, San Diego, CA, 921780.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-60557TPADanielle Lee1963-06-15——5751 Desert Sky Blvd, Dallas, TX, 752130.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59722TPAKevin J Reynolds1943-06-27UHC-73040-31—2591 Baseline Rd, Chandler, AZ, 852940.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54524TPABrandon Ortega2008-07-14——5578 Pine Dr, Tempe, AZ, 852980.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62642TPANancy G Harvey1994-03-19——4513 Palm Dr, San Diego, CA, 921690.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52246TPAWalter U Alvarado1988-09-16——1370 Washington St, Tempe, AZ, 852560.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51094TPAJacob Wilson1964-02-09UHC-87096-71—1598 Lincoln Way, Atlanta, GA, 303220.80Name re-casedCity re-casedState name converted to codePlaceholder values cleared
TPA-55812TPAMatthew Burke1982-01-07—55445102372792 Desert Sky Blvd, Nashville, TN, 372910.80Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-52148TPACerlos Lawrence1949-08-04—38849009009012 Mesa Dr # 931, Plano, TX, 750350.80Name re-casedPhone reformattedUnit split from streetPlaceholder values cleared
TPA-63565TPAFatima Schmidt1955-10-17——6559 Highland Ave, Los Angeles, CA, 900680.80Date of birth reformattedState code upper-casedGender normalisedPlaceholder values cleared
TPA-50580TPASara Gomez2002-04-12UHC-60271-3865365452305624 Elm St, Columbus, OH, 432980.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-55319TPAGreg Moreno1991-02-06—21036926442887 Apache Blvd, Fresno, CA, 937270.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-60430TPAJerry White1996-12-23——2285 Sage Ct, Seattle, WA, 981810.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-54091TPASophai I Jenkins1960-06-23—62938953541604 River Rd, Orlando, FL, 328220.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-53778TPAWaye Ferguson1969-06-12—7397781136—0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63293TPACarlos Boyd1983-03-26——7880 Apache Blvd, Denver, CO, 802260.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59840TPAJoseph Carter1979-12-15—25373839193938 Desert Sky Blvd, Chandler, AZ, 852310.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57437TPAAndrea Casitllo1989-08-21——6085 Camelback Rd, Phoenix, AZ, 850440.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51306TPAKatherine Castillo1953-04-28——782 Highland Ave, Houston, TX, 770920.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61330TPALauren Gordon1958-10-27——2676 Mesa Dr Apt 24, Miami, FL, 331820.80Unit split from streetCity re-casedState code upper-casedPlaceholder values cleared
TPA-59348TPAMelissa Ortiiz1987-02-24—65985089393048 Forest Ave # 967, Scottsdale, AZ, 852160.80Phone reformattedUnit split from streetCity re-casedPlaceholder values cleared
TPA-62061TPADick S Harrison1988-06-17UHC-65374-17—3120 Main St, Tampa, FL, 336780.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63009TPAAustin Rogers———7743 Sage Ct, San Antonio, TX, 782730.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-59732TPABilly Collins1941-06-06———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53816TPAGregorry Pena1942-12-12—23177559843086 Spring St, San Antonio, TX, 782370.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61869TPAMichael Santos2003-07-12——7101 Sage Ct, Miami, FL, 331250.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61133TPABilly Peterson1983-03-22UHC-37115-86——0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-61337TPAScott B Moreno1943-03-17——2645 Park Pl, Sacramento, CA, 958410.80Phone missing area codeCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-57182TPAJose U Schmidt1975-12-20—54667977024255 Broadway, Minneapolis, MN, 554720.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55875TPAAisha Walker1991-12-23—57539242229366 Union St, Columbus, OH, 432920.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-56981TPANoah Castro1985-09-07——5592 Apache Blvd, Tempe, AZ, 852660.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55044TPAEthan Vasquez1973-06-11——9113 Washington St, Las Vegas, NV, 891220.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55500TPAEdward Garrett1941-02-20——4079 Hillcrest Rd, Orlando, FL, 328330.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63296TPADavid Rojas2006-02-10——3125 Washington St, Eden Prairie, MN, 553500.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-55731TPAJudy I Stevens1962-08-11——3652 Palm Dr, Los Angeles, CA0.80City re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-52995TPAMelissa Fox1979-01-22——4095 Valley View Dr, Houston, TX, 770610.80City re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50543TPALucia Peters1981-09-08——8664 Market St # 614, Atlanta, GA, 303750.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-61579TPASamantha Morris2004-09-22———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64044TPARyan O Aguilar1966-07-24——1354 Baseline Rd, Las Vegas, NV, 891180.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60866TPAJack Austin1950-04-20—34495476246937 Union St, Orlando, FL, 328340.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52818TPAHeather N Singh1948-01-09—42443390756811 Elm St, Plano, TX, 750980.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
TPA-52968TPAEugene Elliott1945-03-11UHC-77796-837748269784—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52969TPAEugene Elliott1945-03-11UHC-77796-837748269784—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61210TPAIsabella Reed1960-09-07—68990323607712 Jefferson Ave, Tempe, AZ, 852120.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61252TPAGrace Armstrong1959-03-16—86961623456118 Sage Ct Apt 26, Scottsdale, AZ, 852880.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-62796TPAJudy Patterson1998-03-07——7921 Church St, Austin, TX, 787670.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-61007TPAJesse Spencer1948-11-07—88729556653187 Meadow Ln, Tampa, FL, 336970.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56539TPAGrace Coleman1953-12-14——3475 Union St, Austin, TX, 787070.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59078TPAEmma Hunt1984-02-17——3835 Central Ave, Miami, FL, 331610.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-56310TPASophia G Vargs1962-06-05——8577 Apache Blvd, Houston, TX, 770120.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 184 of 290PreviousNext