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

Claims, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-431465CLMMary Munoz1956-02-24UHC-13183-92—6326 Hillcrest Rd, Fresno, CA0.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-407311CLMChristopher B Cooper1968-04-23——3094 Willow Ct, Columbus, OH0.64Name re-casedDate of birth reformattedZIP missingGender normalised+2 more
CLM-408958CLMAndrea Carroll1988-07-02UHC-45950-0226171942996828 Oak St, Sacramento, CA, 958780.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-405365CLMElijah A Brooks1964-10-22—27694064332640 Baseline Rd, Orlando, FL, 328290.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429943CLMPatrick Sanders2005-09-06——4835 Apache Blvd, San Diego, CA, 921930.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-405336CLMHenry Mitchell1992-03-03——3105 Mountain View Dr, Columbus, OH, 432230.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-425840CLMLaura Peterson1998-11-12UHC-01699-49—7718 Main St, Tempe, AZ, 852430.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429262CLMNicholas Carr1989-07-01UHC-93074-6997383142849452 Indian School Rd, Tucson, AZ, 857420.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-413379CLMLuis Peters2000-12-01UHC-99143-5222969602584568 Cedar Ln, Austin, TX, 787370.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421085CLMRebecca Carlson1983-06-12UHC-32126-5674068236353457 Bayshore Dr Apt 27, Chandler, AZ, 852420.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-422851CLMGeorge Kelley1982-01-24UHC-50392-85—1386 Bayshore Dr, Gilbert, AZ, 852750.64Member ID reformattedCity re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-422033CLMBrian Coleman1948-01-28UHC-17963-7684978609124479 Ocean Ave, San Antonio, TX, 782520.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422531CLMBetty Johnston1977-01-21UHC-31784-8565859841544534 Baseline Rd, Houston, TX, 770960.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-422393CLMJosh Payne1938-09-03UHC-40350-50—5146 Cedar Ln, Sacramento, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-422392CLMJosh Payne1938-09-03UHC-40350-50—5146 Cedar Ln, Sacramento, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-432674CLMScott J Mills1973-04-03UHC-95658-73—5136 Desert Sky Blvd, Tampa, FL0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410227CLMLoir Cooper1954-12-05——7740 Washington St, Las Vegas, NV, 891910.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-404935CLMDenise Johnston1952-02-12UHC-20279-5591252818885325 Baseline Rd, Jacksonville, FL, 322100.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400284CLMAdam Harper1994-06-26UHC-81160-1246048300283915 Maple Ave, Jacksonville, FL0.64Date of birth reformattedPhone reformattedZIP missingGender normalised+2 more
CLM-404380CLMDylan Robertson1975-12-12UHC-45403-9694669214472897 Canyon Rd, Fresno, CA, 937820.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410144CLMWilliam Contreras2002-04-08—20253225153013 Grand Ave, Seattle, WA, 981160.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412765CLMSteven Cook1990-08-01——6710 Market St, Orlando, FL0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-418940CLMHelen Johnson1977-05-18—73294158499802 Bayshore Dr, Los Angeles, CA, 900190.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419502CLMLarry Banks1947-05-21UHC-47014-15—7288 Mesa Dr Apt 29, Sacramento, CA, 958400.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-409231CLMOlivia G Ramos1998-07-18—38365803356004 Harbor Blvd, Los Angeles, CA, 900460.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400498CLMMariana Shaw1952-02-14UHC-69035-2157655504101064 Oak St, Denver, CO, 802870.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-401810CLMJacqueline Willis2003-09-05—87160366305661 Sage Ct, San Diego, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-401811CLMJacqueline Willis2003-09-05—87160366305661 Sage Ct, San Diego, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-406813CLMVincent Lewis1977-02-13UHC-59903-8976945085507484 Bayshore Dr, Glendale, AZ, 853830.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-430351CLMAaron Shaw———3907 Elm St, Seattle, WA, 981070.64Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+2 more
CLM-413117CLMAnthony Johnston1976-01-26UHC-39804-8923758990846353 Cedar Ln # 964, Tampa, FL, 336190.64Name split from “Last, First”Member ID reformattedUnit split from streetState code upper-cased+2 more
CLM-424164CLMLarson Gary1949-11-11——8955 Canyon Rd, Atlanta, GA, 303740.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-407179CLMKathleen Silva1997-10-04—68347488013778 Church St Apt 4, Glendale, AZ, 853820.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-413414CLMPamela Tran2004-09-25——8893 Grand Ave Apt 36, Glendale, AZ, 853320.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425325CLMJoan Murhpy2000-05-01UHC-51326-2629485952604518 Sage Ct, Jacksonville, FL, 322490.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-418906CLMAustin Li1962-04-04UHC-41620-28—3597 Spring St # 140, Plano, TX, 750290.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414777CLMJacob Carr1995-12-25UHC-36540-95—473 Grand Ave, San Antonio, TX0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401532CLMKeith L Ford1979-12-04UHC-86520-46—3256 Meadow Ln, Atlanta, GA, 303890.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-418328CLMHannah Willis1973-05-27—91260504349616 Harbor Blvd, Phoenix, AZ, 850230.66Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+1 more
CLM-424584CLMAlexander Moore1977-02-04——6873 Pine Dr Apt 39, Scottsdale, AZ, 852150.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-413692CLMDiane H West1996-07-02UHC-87387-07—9757 Ridge Rd, Charlotte, NC, 282850.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-417603CLMArthur Gibson1982-09-25UHC-31926-06—6998 Cedar Ln Apt 33, Austin, TX0.66Unit split from streetCity re-casedZIP missingWhitespace trimmed+1 more
CLM-408470CLMAlice Salezar2002-02-23——7779 Maple Ave, Mesa, AZ, 852230.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-427036CLMAisha Cunningham1996-12-02UHC-04872-6823727072733681 Union St, Dallas, TX, 752670.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-420461CLMPatrick Valdez1950-04-27—63837438855078 Canyon Rd, Minneapolis, MN, 554320.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422832CLMDylan Perrry1956-03-25UHC-04097-97—1210 Canyon Rd, Mesa, AZ, 852520.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-411778CLMGary Espinoza1948-04-18UHC-84150-57—7730 Lincoln Way, Gilbert, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-427782CLMKren T Nichols1965-04-02——87 Bayshore Dr, Scottsdale, AZ, 852580.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-414870CLMDot Hudson1988-11-08——3077 Meadow Ln, Minneapolis, MN, 554370.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-432260CLMArthur Turner1996-10-25UHC-79544-7355040831283704 Mountain View Dr, Gilbert, AZ, 852710.66Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 153 of 657PreviousNext