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-59238TPATyler Reed1950-11-15——7735 Meadow Ln, Eden Prairie, MN, 553800.80SSN last four extractedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-62037TPAStephen Carter1945-09-16—4782268064—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57188TPAGrace Soto1948-12-28——3732 Highland Ave, Scottsdale, AZ, 852060.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54591TPAMariana E Herrera1979-09-25—30169892144823 Mountain View Dr, Sacramento, CA, 958630.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55109TPASantiago Miller1951-02-23UHC-98037-76—963 Mountain View Dr, Sacramento, CA, 958930.80Name re-casedState code upper-casedZIP+4 trimmedPlaceholder values cleared
TPA-60223TPAMark Howell2000-10-15——8095 Bayshore Dr, San Diego, CA, 921350.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-50191TPACheryl R Fernandez1964-05-13——5415 Lake View Rd, San Diego, CA, 921520.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55640TPAYuki Scott1981-05-13—75986035118031 Lake View Rd, Scottsdale, AZ, 852120.80Phone reformattedCity re-casedGender normalisedPlaceholder values cleared
TPA-58529TPABilly Hayes1996-02-14——2016 Forest Ave, Houston, TX, 770310.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-60263TPAHarold Ramirez1943-04-28—72231607786606 Forest Ave, Charlotte, NC, 282600.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56104TPATeresa Castro1974-07-06——324 Ridge Rd, Tampa, FL, 336560.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52911TPAJimmy A Butler1955-08-09—27642825834933 Valley View Dr, Tempe, AZ, 852040.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57083TPAAslhey Johnston1964-09-24——3722 Maple Ave, Sacramento, CA, 958540.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-55025TPAWei Hanson1956-02-20—57630198047792 Spring St # 509, Nashville, TN, 372380.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-61536TPAChristopher Harris1948-11-20—86570134143241 Valley View Dr, Tucson, AZ, 857820.80Two-digit birth yearCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-60345TPAAdam Morgan1970-12-26——7848 Bayshore Dr, Chandler, AZ, 852680.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61261TPAJeffrey V Soto2006-08-10——4743 Desert Sky Blvd, Fresno, CA, 937340.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58035TPAPeter Santiago1962-08-17——8587 Valley View Dr, Eden Prairie, MN, 553370.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-63205TPAAna Y Mkcoy1965-09-24UHC-95888-71—2208 Highland Ave, San Diego, CA, 921920.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57641TPADanielle Rojas1952-05-16—51495090224114 Forest Ave Apt 28, Tucson, AZ, 857620.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-57642TPADanielle Rojas1952-05-16—51495090224114 Forest Ave Apt 28, Tucson, AZ, 857620.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-54011TPAEmma Robertson1974-03-04——434 Pine Dr, Tempe, AZ, 852420.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63138TPABilyl Z Wells1947-09-03UHC-28507-55—6266 Maple Ave, Minneapolis, MN, 554400.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-51255TPAElijah Portter1950-09-15——1753 Desert Sky Blvd, Plano, TX, 750420.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54277TPARuth Cole1966-12-16——2598 Broadway, Jacksonville, FL, 322320.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55098TPABarbara Pena2005-02-23——2978 Church St, Atlanta, GA, 303180.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59355TPASean Wallacce1994-10-23UHC-48266-32——0.80Two-digit birth yearEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-53744TPAGary Contreras1999-07-12——3338 Bayshore Dr, Los Angeles, CA, 900200.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56586TPAAndrew Y Carlson1979-02-07——1592 Ridge Rd, Los Angeles, CA, 900740.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59879TPAPhilip Hanson1996-01-09——4609 Spring St, Eden Prairie, MN, 553730.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63409TPADiaz Kelly1996-08-11—24169172215998 Mesa Dr, Austin, TX, 787850.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50827TPAPamela Ruiz1951-01-16——2604 Baseline Rd, Gilbert, AZ, 852560.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-57532TPAGary Carr1957-05-06——9019 Washington St, Scottsdale, AZ, 852090.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54793TPASarah Fernandez1951-11-24———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58218TPACatherine Carroll1971-06-08——5270 Highland Ave, Orlando, FL, 328470.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62467TPAJesse Padilla1944-01-13—8616486458—0.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
TPA-59995TPABath Reyes1944-11-12—34172119086171 Spring St, Fresno, CA, 937330.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57498TPAMadison Taylor1957-06-12——4368 Sage Ct, Sacramento, CA, 958470.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-56873TPAMason Wong1991-01-03——7395 Pine Dr, Fresno, CA, 937140.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62176TPAIsabella Reed1987-08-24——8519 Main St # 450, Gilbert, AZ, 852500.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-52548TPAEric Burns1991-06-28—80979417505566 Pine Dr, Tempe, AZ, 852400.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64443TPAEugene Obrien2005-10-05UHC-43357-4876421223103202 Spring St Apt 3, Fresno, CA, 937840.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-56189TPAFatima Boyd1985-07-28—74579461167311 Sage Ct, Fresno, CA, 937910.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60473TPAJeremy Black1991-06-26———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-53529TPACarolyn W Kelley1991-02-21——3821 Market St, Tucson, AZ, 857150.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54158TPABrandon Jacobs1962-07-15—73293925536182 Lincoln Way, Houston, TX0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-51114TPAEric J Warren2007-08-06—36730815738057 Union St, Nashville, TN, 372800.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63052TPAAisha Cunningham1948-04-16——9144 Pine Dr, Tempe, AZ, 852720.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53839TPAJanice T Hicks2003-12-05——5392 Ocean Ave # 630, Austin, TX, 787540.80Name re-casedDate of birth reformattedUnit split from streetPlaceholder values cleared
TPA-52679TPAPhiip Fisher1953-02-10——2181 Jefferson Ave, Seattle, WA, 981800.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 192 of 290PreviousNext