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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-112829ENRFrank K Gonzales1986-03-06UHC-69591-7869924143093263 Ridge Rd # 123, Las Vegas, NV, 891630.38Middle initial moved out of first nameName re-casedPhone reformattedUnit split from street+3 more
TPA-58473TPALisaJunk———8703 Sunset Blvd, Phoenix, AZ, 850670.38Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-138530ENRJanet H Weaver1995-02-05UHC-30144-8133078186819551 Lake View Rd, Atlanta, GA, 303070.38Name split from “Last, First”Middle initial moved out of first nameZIP+4 trimmedEmail lower-cased+3 more
TPA-54840TPAWillie Ross2004-05-19——896 Lake View Rd, Fresno, CA, 937200.38Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-140592ENRBenjamin Williams1947-06-24UHC-98822-5026539561426053 Broadway, Tucson, AZ, 857390.38Name split from “Last, First”Phone reformattedSSN last four extractedCity re-cased+3 more
TPA-64188TPALoganJunk1960-07-15——6603 Jefferson Ave # 113, Miami, FL, 331910.38Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-142090ENRPriya C Hanson1940-05-01UHC-32350-1521249065753596 Bayshore Dr, Glendale, AZ, 853750.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133918ENRStephanie F Martinez1978-06-25UHC-10286-6330424253724964 Church St, Sacramento, CA0.38Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+3 more
CLM-428297CLMMichael Carpenter1995-07-11——8019 Market St, Plano, TX0.38Two-digit birth yearCity re-casedState name converted to codeZIP missing+3 more
ENR-123891ENRJulia S Tran1973-07-16UHC-57015-5191653871937521 Meadow Ln Apt 5, Sacramento, CA0.38Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-115095ENRMartha I Ellis1950-12-09UHC-43659-49—2887 Highland Ave, Charlotte, NC, 282920.38Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-403215CLMPriya West2006-07-03UHC-15513-7821541214537070 Oak St, Charlotte, NC, 282520.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139333ENRPaaul I Hernandez1972-07-11UHC-62047-5169186926963778 Sage Ct Apt 14, Chandler, AZ, 852860.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125880ENRCarolyn H Carslon1963-03-23UHC-63760-02—4704 Bayshore Dr, Columbus, OH, 432140.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112200ENRNicole O Graham1942-05-22UHC-66344-349459917254876 Pine Dr # 102, Charlotte, NC, 282400.38Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-418909CLMCheryl Wells2002-03-22UHC-16740-01—4094 Apache Blvd, Los Angeles, CA, 900850.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-124886ENRJoseph Schultz1973-08-16UHC-92693-5448745256067373 Main St, Los Angeles, CA, 900390.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-408673CLMMariana Z Morrison—UHC-48094-21—8632 Mesa Dr, Chandler, AZ0.38Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-125146ENRGary E Ortiz2006-09-25UHC-32126-6631040124189373 Pine Dr, Sacramento, CA, 958010.38Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400604CLMGabriel Brown—UHC-97090-9255962756877279 Meadow Ln, Sacramento, CA0.38Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-404095CLMJoshua Mendoza1954-10-27—9532876576650 Valley View Dr Apt 15, Houston, TX, 770670.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-109453ENRSofia Robertson1956-08-16UHC-53644-1834693104121515 Market St, Plano, TX0.38Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-109452ENRSofia Robertson1956-08-16UHC-53644-1834693104121515 Market St, Plano, TX0.38Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-410548CLMDanielle Ford———9012 Central Ave # 138, Plano, TX, 750810.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-403642CLMEmily V Le1997-12-09UHC-71304-1592192778479284 Meadow Ln, Atlanta, GA0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424237CLMBecky Myers———2515 Palm Dr, Tucson, AZ0.38Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-405212CLMKatherine Lucas2000-07-16—88724705659123 Bayshore Dr, Plano, TX, 750470.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-101938ENRDoris R Black1957-02-20UHC-33201-5772236186174505 Ridge Rd, Denver, CO, 802770.38Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-115621ENRChristina D Carroll1990-07-10UHC-18251-33—1480 Main St, Eden Prairie, MN, 553310.38Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-407859CLMRonald B Espinoza1981-09-20—3695381020763 Oak St, Atlanta, GA, 303550.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-430397CLMKeith G Crawford1975-06-10UHC-72967-12—239 Grand Ave, Fresno, CA, 937030.38Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-107206ENRAmber Z Bailey1999-11-06UHC-62902-396845376629630 Union St Apt 7, Jacksonville, FL, 322080.38Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
PRV-26224PRVMichelle Powell1966-11-26—88467910477546 Ocean Ave, Chandler, AZ, 852690.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-424715CLMDaniel Jordan1970-02-07——2166 Mountain View Dr, Plano, TX, 750150.38Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-424714CLMDaniel Jordan1970-02-07——2166 Mountain View Dr, Plano, TX, 750150.38Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-414689CLMOlivia Franklin1955-09-28—22133497396531 Hillcrest Rd, San Diego, CA, 921250.38SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-410911CLMRussell Gutierrez1963-10-20—67774973593087 Apache Blvd, Mesa, AZ, 852520.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62583TPAJack James1957-03-03—89568869501297 Maple Ave Apt 6, Tampa, FL, 336620.38Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-63603TPADouglas Sanders—UHC-15375-20—7638 Bayshore Dr, Atlanta, GA, 303710.38Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+3 more
CLM-427060CLMAmanda Singh1946-10-03——2132 Baseline Rd, Dallas, TX, 752740.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408733CLMBrenda Jimenez1946-09-24UHC-35314-08—3317 Mountain View Dr # 635, Atlanta, GA0.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-417893CLMJustin P Tran1941-03-07—49945923123195 Market St, Mesa, AZ, 852320.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106552ENRJanice V Tran1977-08-21UHC-34246-5779093894445132 Jefferson Ave, San Antonio, TX, 782390.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56412TPAPatricia M Wang———8628 Maple Ave, Plano, TX, 750360.38Name split from “Last, First”Middle initial moved out of first nameDate of birth unreadableStreet suffix standardised+3 more
CLM-429629CLMAmber Banks1975-11-16——2815 Lincoln Way, Fresno, CA, 937920.38Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+3 more
ENR-109193ENRSims Joseph2001-03-26UHC-26661-0750097380668402 Baseline Rd, Sacramento, CA, 958270.38Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more
CLM-408164CLMPhilip Black1955-02-06UHC-68692-47—1873 Forest Ave, Houston, TX0.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-432773CLMSteve Marquez2002-01-24—87728546231142 Hillcrest Rd Apt 25, Sacramento, CA, 958640.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-121490ENRAlbert R Park—UHC-34842-6122090144794568 Bayshore Dr, Mesa, AZ0.38Middle initial moved out of first nameDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-109600ENRPatricya M Rivera1967-02-21UHC-78624-5845786576359792 Ridge Rd, Gilbert, AZ, 852290.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 24 of 2,000PreviousNext