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-57263TPANicholas V Miller1959-05-12UHC-78923-11—5983 Spring St, Tampa, FL, 336970.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-63617TPAAndrea Hrrison1956-06-22——1180 Meadow Ln, Phoenix, AZ, 850540.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56584TPAAlice Peters1997-11-27——8453 Apache Blvd, Plano, TX, 750400.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-59826TPAJack A Riley1986-05-12——9899 Park Pl # 841, Phoenix, AZ, 850100.68Unit split from streetState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-51247TPARoy Tucker1946-01-17——7341 Oak St, Atlanta, GA, 303000.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-63448TPARalph Phillips1983-08-09—46360045766178 Park Pl Apt 29, Austin, TX, 787120.68Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased
TPA-58859TPAMarya Carr1975-01-13—43750479529203 Cedar Ln, Orlando, FL, 328350.68Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed
TPA-57457TPACamila Daniels———2438 Sage Ct, Phoenix, AZ, 850530.68Date of birth missingGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58418TPAElizabeth Warren1980-09-25—74647146088697 Washington St, Houston, TX0.68Name split from “Last, First”Phone reformattedCity re-casedZIP missing
TPA-62227TPAStephen Davis1963-12-19—66754267574730 Washington St, Las Vegas, NV, 891740.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56967TPAScott Reed1984-08-28—79460556529220 Union St Apt 36, Tempe, AZ, 852990.68Phone reformattedUnit split from streetZIP+4 trimmedPlaceholder values cleared
TPA-57852TPAAaron Jensen1969-05-08——5197 Baseline Rd, Scottsdale, AZ, 852270.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-62017TPAAlbert Watkins2008-09-26—69389046296358 Ridge Rd, Tucson, AZ, 857800.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63624TPAPamela Wheeler1971-02-19———0.68Name split from “Last, First”Gender normalisedPlan code upper-casedPlaceholder values cleared
TPA-55859TPADiego Guerrero1943-03-05——4725 Willow Ct # 450, San Diego, CA0.68Name re-casedUnit split from streetZIP missingPlaceholder values cleared
TPA-57177TPAWilliam S Carpenter1954-02-11——2934 Apache Blvd, Denver, CO0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-53918TPASamuel Jimenez1953-04-02UHC-67719-04—7505 Cedar Ln, Atlanta, GA, 303710.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60178TPASantiago Foster1987-03-15——6861 Ridge Rd, Eden Prairie, MN, 553020.68Two-digit birth yearState code upper-casedGender normalisedPlaceholder values cleared
TPA-60057TPABenjammin Fuller1980-12-22——3846 Sunset Blvd, Las Vegas, NV, 891130.68Two-digit birth yearZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-59937TPATommy Day1944-02-21UHC-61347-18—1025 Mesa Dr, Miami, FL, 331710.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50823TPADick Medina1981-07-21——1406 Lincoln Way, Tucson, AZ, 857870.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-53616TPASandra B Andersn2000-01-17——4692 Sunset Blvd, Seattle, WA, 981760.68SSN last four extractedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-55437TPABob GJunk2000-10-21——1002 Elm St, Seattle, WA0.68State code upper-casedZIP missingPlaceholder values clearedNo usable name (quarantined)
TPA-60743TPAJacqueline Lewis1979-05-16——9882 Sage Ct, San Diego, CA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-56836TPAAnna Fox1995-06-05——8586 Central Ave, San Diego, CA, 921460.68Name split from “Last, First”Email lower-casedGender normalisedPlaceholder values cleared
TPA-55853TPADoris White1995-02-02———0.68Two-digit birth yearSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-61391TPALucia Weaver2000-08-24——4920 Lake View Rd, Columbus, OH, 432960.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-61879TPADenise V Henry1963-07-22—64540373086558 Apache Blvd Apt 35, Tempe, AZ, 852840.68Unit split from streetGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58281TPAAnn Garrett1977-01-19——6583 Oak St, Houston, TX0.68Name split from “Last, First”Date of birth reformattedZIP missingPlaceholder values cleared
TPA-52512TPABetty F Hernandez1950-05-09——4114 Valley View Dr, Glendale, AZ, 853070.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-58577TPATheersa Hill———5396 Church St, San Diego, CA, 921180.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60789TPATyler B Wagner1977-08-17UHC-29723-3340566584748116 Willow Ct, San Antonio, TX, 782390.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61853TPASarrah Patterson1962-09-14——2748 Maple Ave, Miami, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-58982TPADonald Elllis1939-01-25—28090115029268 Union St, Tempe, AZ, 852690.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-50546TPAMark McDonald1989-02-06——1238 Park Pl, Seattle, WA, 981920.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57185TPAChristopher White1978-04-15——6212 Broadway, Orlando, FL, 328200.68Two-digit birth yearZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-62169TPASofia Mitkhell1969-05-08———0.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-62560TPASara Murray1944-05-25——9636 Spring St # 982, Columbus, OH, 432410.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61633TPASusan Perez1978-02-15—24054589564972 Sunset Blvd, Minneapolis, MN0.68City re-casedZIP missingGender normalisedPlaceholder values cleared
TPA-50834TPAAlbert Miller1940-02-09——5580 Hillcrest Rd, Orlando, FL, 328700.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-59922TPAKayla B Contreras1996-11-11——1305 Sunset Blvd, Scottsdale, AZ, 852810.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53093TPABobby Jordan1948-01-10——8985 Valley View Dr, Dallas, TX, 752950.68Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised
TPA-53092TPABobby Jordan1948-01-10——8985 Valley View Dr, Dallas, TX, 752950.68Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised
TPA-55663TPAJudy Ortega1963-10-09—9313430829—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63537TPADiego Warren1994-10-28——8476 Palm Dr, Chandler, AZ, 852100.68Date of birth reformattedState name converted to codeZIP+4 trimmedPlaceholder values cleared
TPA-52788TPARyan Rios———4656 Maple Ave, Miami, FL, 331730.68Date of birth unreadableState code upper-casedGender normalisedPlaceholder values cleared
TPA-53256TPAEmma West2000-10-12—40162455744639 Highland Ave, Columbus, OH, 432200.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-53574TPACharlotte Simmons1961-05-14UHC-98486-13——0.68SSN last four extractedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61317TPAPriya Berry1967-10-14——958 Main St, Los Angeles, CA, 900050.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-59858TPAAmanda Alexander———879 Sunset Blvd, Houston, TX0.68Name re-casedDate of birth unreadableZIP missingPlaceholder values cleared
14,474 rows, page 91 of 290PreviousNext