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-421117CLMJessica Schmidt1999-11-07UHC-33321-2675138695721851 River Rd, Houston, TX, 770830.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-409650CLMBilly J Homles1941-01-13——1950 Valley View Dr, Charlotte, NC, 282410.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-405434CLMBenjamin Olson2003-05-25UHC-22547-34—7725 Palm Dr, Las Vegas, NV, 891950.66Date of birth reformattedMember ID reformattedSSN last four extractedGender normalised+1 more
CLM-417870CLMHeather Sanchez1996-06-03——3323 Park Pl, Chandler, AZ, 852930.66Name re-casedPhone missing area codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-431863CLMJames Holmes1983-12-16——4498 Bayshore Dr # 571, Gilbert, AZ, 852820.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412349CLMValentina Daniels1995-04-20——8688 Palm Dr, Seattle, WA, 981080.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
CLM-410006CLMGerald Fernandez1951-04-27——6759 Camelback Rd, Nashville, TN0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-415576CLMBarbara Fisher1938-06-16——4226 Church St, Orlando, FL, 328220.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-430425CLMJacquelineJunk1990-02-14UHC-51173-49—6121 Cedar Ln # 799, Las Vegas, NV, 891100.66Unit split from streetCity re-casedWhitespace trimmedPlaceholder values cleared+1 more
CLM-402656CLMKathleen Hanson1946-09-17UHC-09595-21—1114 Grand Ave, Gilbert, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-420699CLMDonna Guerrero1993-09-18UHC-56642-684732970994—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-417076CLMBilly Griffin1986-06-20UHC-51997-76—1134 Valley View Dr, Houston, TX, 770160.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-414335CLMMariana Parker2008-11-14UHC-18863-5286764212349046 Church St, Gilbert, AZ, 852240.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-425657CLMMason Bkaer1942-12-28UHC-52066-68—7065 Harbor Blvd, Columbus, OH, 432620.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-409119CLMJoe Freeman2007-11-17——7788 Meadow Ln, Miami, FL, 331280.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-418787CLMLarry Green1958-08-24UHC-67519-46—7068 Lake View Rd, Orlando, FL, 328300.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-407725CLMCarlos Hamilton1956-01-21——7313 Desert Sky Blvd, Tampa, FL, 336350.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-418677CLMYuki H Hanson—UHC-02203-04—6392 Bayshore Dr, Fresno, CA, 937490.66Name re-casedDate of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-428977CLMDeborah Ortega1966-09-17UHC-05686-6550733738485164 Lincoln Way, Atlanta, GA, 303700.66Name split from “Last, First”Phone reformattedCity re-casedGender normalised+1 more
CLM-421239CLMParker Elizabeth1941-06-22——1852 Cedar Ln, Seattle, WA, 981410.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-410502CLMSean Shaw1971-12-01UHC-92556-56—321 Park Pl, Nashville, TN, 372240.66Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+1 more
CLM-423518CLMJoan Woods1963-12-01—40320936029615 Central Ave, Dallas, TX, 752840.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-403125CLMNick Carter1938-12-23——8213 Apache Blvd, Orlando, FL, 328430.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-431965CLMEric H Young1949-09-14—3852300313—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-400422CLMDenny Warren2007-05-11UHC-29646-2473523963224604 Washington St Apt 15, Eden Prairie, MN, 553050.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-416680CLMDorothy Wagner1999-11-07——1607 Forest Ave # 398, Tucson, AZ, 857330.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-409179CLMOmar Contreras1990-04-12UHC-81935-53—920 Valley View Dr, Columbus, OH0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-408195CLMKelly Harris1979-09-09UHC-56453-10—1366 Highland Ave # 915, Tempe, AZ, 852090.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402032CLMGeorge Lawrence2008-06-13UHC-88302-44—3807 Market St, Denver, CO, 802870.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-402730CLMRonald P Howard1974-04-01UHC-34914-04—3729 Sage Ct, Glendale, AZ, 853220.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-426695CLMBilly Lopez1940-09-21UHC-11120-88—6638 Highland Ave, Columbus, OH0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-407886CLMAlice Hayes2000-06-23UHC-80765-96—8618 Washington St, San Diego, CA, 921290.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-416396CLMJohn Anderson—UHC-74807-02—9872 Ocean Ave, Phoenix, AZ, 850870.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-418536CLMRussell Brown1941-07-27UHC-59359-98—654 Forest Ave, Orlando, FL, 328040.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-423676CLMBrenda Allen1952-03-07——2354 Apache Blvd, Atlanta, GA, 303450.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-404426CLMChristina Castro1973-09-16UHC-59692-4480374652261514 Church St, Jacksonville, FL, 322450.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-410802CLMFatimma Z Baker1982-12-22UHC-98242-1374824433937973 Apache Blvd, Chandler, AZ, 852890.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430611CLMAlan Perkins1961-10-26——3907 Desert Sky Blvd, Eden Prairie, MN, 553360.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-423284CLMJose Gordon1994-04-13UHC-27613-60—2402 Willow Ct, Tempe, AZ, 852680.66Name split from “Last, First”Date of birth reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-423285CLMJose Gordon1994-04-13UHC-27613-60—2402 Willow Ct, Tempe, AZ, 852680.66Name split from “Last, First”Date of birth reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-412391CLMOmar Reyes1965-10-23UHC-05993-47—4469 Harbor Blvd Apt 33, Charlotte, NC, 282750.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422804CLMBetty Santiago1938-02-07UHC-84720-4697652801526786 Elm St, Columbus, OH, 432130.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-419616CLMEugene R Warren1965-03-23UHC-16651-2057399045444103 Bayshore Dr Apt 10, Gilbert, AZ0.66Phone reformattedUnit split from streetZIP missingWhitespace trimmed+1 more
CLM-424022CLMMike J Contreras1958-01-23——4013 Pine Dr Apt 39, Seattle, WA, 981560.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-424021CLMMike J Contreras1958-01-23——4013 Pine Dr Apt 39, Seattle, WA, 981560.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419839CLMNicole L Welch1975-05-01UHC-08156-1027138539048107 Washington St, San Diego, CA, 921070.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-428301CLMAlbert Hawkins2000-08-08UHC-89653-7068439752026537 Mesa Dr, Dallas, TX, 752540.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-418511CLMAhmed Silva1965-07-09UHC-49438-0525179856389183 Elm St, Scottsdale, AZ, 852990.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-402500CLMKeith Mills1940-08-12UHC-71507-37—3588 Canyon Rd, Plano, TX, 750060.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-405539CLMJesse Tucker1983-05-04——4341 Church St, Glendale, AZ, 853150.66Two-digit birth yearCity re-casedGender normalisedWhitespace trimmed+1 more
32,829 rows, page 181 of 657PreviousNext