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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-417251CLMMartha Henderson2008-10-26UHC-24638-57—6710 Washington St, Minneapolis, MN, 554370.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-430014CLMDiane E Ruiz1948-05-15UHC-80079-74—6629 Spring St, Seattle, WA, 981550.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-418094CLMPriya F Alvarado1981-02-27UHC-65556-89—5707 Mountain View Dr Apt 11, Miami, FL, 331090.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-426966CLMKeith Collins———2439 Mesa Dr, Los Angeles, CA, 900530.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421911CLMJoshua Harper1971-08-11UHC-85497-41—282 Ocean Ave, Los Angeles, CA, 900230.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-407377CLMJoe Harvey1956-09-20——6432 Hillcrest Rd, Atlanta, GA, 303570.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-425678CLMDan Y Yang1997-09-21UHC-36268-5637851647329639 Union St, Tampa, FL, 336980.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-413214CLMAlbert Mendez1972-10-21UHC-76989-44——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-408438CLMBrandon Kim2005-03-05UHC-49210-04—9353 Church St Apt 3, San Diego, CA, 921730.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-400774CLMMark Freeman—UHC-14472-19—8601 Jefferson Ave, Scottsdale, AZ, 852770.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411713CLMYuki Peters1998-05-08UHC-44151-888272615075890 Oak St, Austin, TX, 787440.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-416543CLMJanet Henderson1976-07-16——7039 Mountain View Dr, Houston, TX, 770550.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-426342CLMOmar Weaver2002-02-28UHC-71491-85—4595 Sage Ct, Fresno, CA, 937820.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-413260CLMKaren Morrison2000-06-28——5196 Cedar Ln, Miami, FL, 331410.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-405752CLMJanet H Tran2005-01-12——6574 Pine Dr, Chandler, AZ, 852680.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-430665CLMCheryl Banks1985-09-01—63270109371981 Cedar Ln, Seattle, WA, 981910.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-418618CLMNatalie Ramos1987-04-27UHC-03397-06—926 Spring St, Tempe, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-423667CLMFrances Morrison1943-06-13UHC-70290-9640137228306190 Camelback Rd, Minneapolis, MN0.68Date of birth reformattedState name converted to codeZIP missingPlaceholder values cleared
CLM-400403CLMPatrick H Foster2001-08-21UHC-07454-342723026646—0.68SSN last four extractedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-430659CLMJudith Schultz—UHC-26690-1627456626701867 Pine Dr, Houston, TX, 770770.68Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased
CLM-400654CLMArjun Luacs1993-03-09UHC-83630-69—7452 Indian School Rd, Nashville, TN, 372370.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-415686CLMJordan Willis2001-06-16UHC-82878-8855582480886683 Desert Sky Blvd, Fresno, CA, 937940.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-407686CLMTimothy N Dunn2001-10-15UHC-00270-77—5933 Mountain View Dr, Sacramento, CA, 958550.68Name split from “Last, First”Middle initial moved out of first nameMember ID reformattedPlaceholder values cleared
CLM-431184CLMJean Nunez———1238 Central Ave, Nashville, TN0.68Date of birth unreadableZIP missingWhitespace trimmedPlaceholder values cleared
CLM-429411CLMRaymond J Day1984-07-02—83725692298570 Main St, Miami, FL0.68Name re-casedTwo-digit birth yearZIP missingWhitespace trimmed
CLM-405430CLMBetty Wallace1952-03-11UHC-44888-6186853775063223 Central Ave, Sacramento, CA, 958790.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-414094CLMDebra J Elliott1959-08-05——5362 Park Pl, Nashville, TN, 372100.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-419271CLMKaterine Lucas1966-07-23UHC-29115-96—6724 Market St, Austin, TX, 787060.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-408565CLMJanet Carroll1980-01-11UHC-53874-23—4277 Elm St, Tucson, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-406011CLMRachel Carroll1956-11-10UHC-07257-67—6558 Union St, Miami, FL, 331630.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-429279CLMJohn Bell1979-07-03UHC-89686-04—4113 Market St, Tucson, AZ, 857850.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-406855CLMNancy Spencer2008-09-06UHC-62462-1768037610986931 Ocean Ave, Charlotte, NC, 282550.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-430300CLMAndrea Martinez1941-05-17UHC-02997-045389124249—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-410822CLMTeresa Hudson———7336 Mountain View Dr, Nashville, TN, 372590.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-414071CLMMichael Lucas1965-08-11——1524 Highland Ave, Eden Prairie, MN, 553290.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-400416CLMPaul W Turner1941-08-26UHC-48325-16—1866 Maple Ave # 489, Minneapolis, MN, 554560.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-427442CLMPhiip Valdez2002-07-04UHC-98601-3768550705512007 Mountain View Dr Apt 38, Eden Prairie, MN, 553200.68Date of birth reformattedUnit split from streetCity re-casedGender normalised
CLM-410943CLMValentina C Ray2000-05-10—56168244923346 Sunset Blvd, Fresno, CA, 937500.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411192CLMBrandoon Bennett1950-02-23UHC-33676-78—3332 Bayshore Dr, Sacramento, CA0.68SSN last four extractedZIP missingWhitespace trimmedPlaceholder values cleared
CLM-424719CLMPaul M Gordon1954-05-19—68384721259470 Camelback Rd, Miami, FL, 331650.68Middle initial moved out of first nameStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409016CLMMichelle Kennedy1967-01-05——4335 Sunset Blvd, Miami, FL, 331410.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411909CLMRandy Webb1957-12-03———0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-424644CLMVincent Sullivan1973-06-20——8234 Jefferson Ave, San Antonio, TX, 782460.68Two-digit birth yearCity re-casedState name converted to codePlaceholder values cleared
CLM-418065CLMSantiago Martinez1959-06-09UHC-34421-47—225 Harbor Blvd, Minneapolis, MN, 554330.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-400756CLMMichelle C Roemro1977-06-07—2656413121923 Church St, Tampa, FL, 336810.68Two-digit birth yearPhone reformattedZIP+4 trimmedPlaceholder values cleared
CLM-410771CLMAbigail Johnston—UHC-13519-75——0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-414138CLMRaymond Banks1966-04-28—65281025183219 Grand Ave Apt 8, Eden Prairie, MN, 553440.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430837CLMJulia Reyes1980-12-18—84859163824574 Harbor Blvd, San Antonio, TX, 782140.68Name re-casedState name converted to codeZIP+4 trimmedPlaceholder values cleared
CLM-428059CLMEugene S Reyes1996-11-22UHC-32191-16—4332 Apache Blvd, Columbus, OH, 432310.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-401397CLMBryan Cruz1941-08-23——2664 Park Pl, Eden Prairie, MN, 553300.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
32,829 rows, page 218 of 657PreviousNext