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-404570CLMDiana Patterson2002-09-09UHC-03595-51—8120 Maple Ave, Scottsdale, AZ, 852150.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-405910CLMJeffrey R Chen1974-01-07UHC-36893-664186864788—0.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
CLM-412840CLMRyan Grant1989-09-27——6174 Valley View Dr # 604, Tucson, AZ, 857080.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-400555CLMFrances R Wilson1940-10-21——9472 Willow Ct, Mesa, AZ, 852270.66Name re-casedCity re-casedState name converted to codeGender normalised+1 more
CLM-420020CLMAngela Lopez1994-07-26UHC-47375-08—7803 Canyon Rd, Houston, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-409342CLMFatima Coleman1981-12-02UHC-25318-23—4474 Sunset Blvd, Los Angeles, CA, 900610.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-424093CLMNicole Gonzalez1959-04-24—77568325451921 Union St, Las Vegas, NV, 891060.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-414340CLMLucia Welch1983-09-18UHC-74680-1159456306771802 Spring St, Mesa, AZ, 852130.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-404855CLMBobby D Romero2001-02-09—92352891198742 Park Pl, Seattle, WA, 981540.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-402025CLMElijah X Ray2004-04-16UHC-16733-8551942469145905 Sunset Blvd, Mesa, AZ, 852670.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-417546CLMWalter D Moreno1939-07-01UHC-84396-395143662966597 Elm St, Denver, CO, 802620.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-419382CLMCatherine Hart1963-09-20——7998 Desert Sky Blvd, Atlanta, GA, 303170.66Name re-casedTwo-digit birth yearState name converted to codeWhitespace trimmed+1 more
CLM-423019CLMBradley Carlson1951-06-21———0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-401619CLMSophia Fox1973-06-20UHC-96989-32—5249 Sage Ct, Houston, TX, 770120.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-431533CLM—Junk1954-08-06UHC-17902-3122926491266016 Baseline Rd, Tampa, FL, 336500.66Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared+1 more
CLM-400035CLMMartha Stone—UHC-83497-59——0.66Name re-casedDate of birth missingGender normalisedWhitespace trimmed+1 more
CLM-429604CLMNancy Reyes1996-12-25UHC-22688-1746192674311664 Lincoln Way, Houston, TX, 770330.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-403489CLMCamila Olson—UHC-51240-43—5990 Camelback Rd, Denver, CO, 802720.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-417230CLMAndrea Anderson1945-09-25——1436 Cedar Ln, San Antonio, TX, 782500.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429194CLMBrandon Andrews1956-02-04UHC-68112-035848021755414 Oak St, Tucson, AZ, 857120.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
CLM-409521CLMBradley Fernandez1946-08-11UHC-37198-75—660 Maple Ave, San Antonio, TX, 782850.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404773CLMMike Nelson1938-06-07——1008 Pine Dr Apt 16, Sacramento, CA, 958490.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407810CLMMaria Nunez1946-01-24UHC-05838-12—5440 Camelback Rd # 743, Atlanta, GA, 303420.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412448CLMKevin Lewis1972-06-28—27361472658730 Sage Ct, San Diego, CA, 921570.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-427238CLMRussell King1946-12-11—78725802359139 Willow Ct Apt 32, Fresno, CA, 937340.66Name split from “Last, First”Phone reformattedUnit split from streetWhitespace trimmed+1 more
CLM-422462CLMScott Thomas1979-06-10——3750 Bayshore Dr, Chandler, AZ, 852390.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-421868CLMBetty Morales1968-05-13UHC-75997-354278558517532 Palm Dr, Sacramento, CA, 958340.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-416174CLMSamantha Jenkins2007-01-20UHC-20745-11—3267 Oak St, Orlando, FL0.66Date of birth reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-421649CLMMark Washigton2006-12-27—76076406525914 Ridge Rd, Minneapolis, MN, 554340.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-429564CLMRobert Robinson1988-10-05—85872927056663 Bayshore Dr, San Antonio, TX, 782880.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419440CLMThomaas U Johnston1997-12-06—79550596634189 Market St, Tampa, FL, 336900.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-418060CLMDorothy Austin1949-11-11UHC-48631-14—8657 Oak St, Los Angeles, CA, 900680.66Name split from “Last, First”City re-casedState name converted to codeWhitespace trimmed+1 more
CLM-402661CLMChristine Henry—UHC-14353-969073872354—0.66Name split from “Last, First”Date of birth missingPhone reformattedWhitespace trimmed+1 more
CLM-410581CLMRonald Dominguez1989-05-26UHC-96584-75—4274 Desert Sky Blvd, San Antonio, TX, 782000.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-409992CLMMariana T Green1989-08-17UHC-41515-80—9052 Grand Ave, Denver, CO, 802220.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-428836CLMAshley Walsh1961-10-13—45222818787897 Palm Dr, Nashville, TN0.66Name split from “Last, First”Phone reformattedZIP missingWhitespace trimmed+1 more
CLM-400378CLMVictoria J Lynch1959-10-10—47887100329353 Baseline Rd, Jacksonville, FL, 322960.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-407279CLMNathan Singh1943-01-14—38335027966404 Park Pl, Minneapolis, MN, 554840.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-426601CLMPatricia S Owens1950-08-04UHC-87048-14—3078 Ocean Ave, Nashville, TN, 372010.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
CLM-424963CLMAhmde Harper1942-12-22——8851 Valley View Dr, Dallas, TX, 752540.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-428296CLMFrank Alvarez2002-04-13——221 Willow Ct, Los Angeles, CA, 900610.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-408616CLMDavid Berry1958-08-22UHC-53040-86—2050 Oak St, Nashville, TN, 372170.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-421045CLMJoshua Williamson1987-07-19——2202 Apache Blvd, Jacksonville, FL, 322860.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-427213CLMDrew M Carroll1943-04-21UHC-88757-5892581644898282 Baseline Rd, Tempe, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-414621CLMArthur N Myers—UHC-40907-3726474482773245 Indian School Rd, Jacksonville, FL0.66Name re-casedDate of birth missingPhone reformattedZIP missing+1 more
CLM-403678CLMFrank P Williamson1938-10-13——5825 Forest Ave # 233, Los Angeles, CA, 900910.66Name split from “Last, First”Date of birth reformattedUnit split from streetWhitespace trimmed+1 more
CLM-415688CLMJordan Willis2001-06-16UHC-82878-88—6683 Desert Sky Blvd, Fresno, CA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-408424CLMJulia A Castillo——51356648216225 Bayshore Dr, Eden Prairie, MN, 553820.66Date of birth missingPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-421581CLMTyler Maldonado1948-07-12——7191 Mesa Dr, Minneapolis, MN, 554800.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-418360CLMDorothy W Vega2007-12-16——1660 Ridge Rd, Atlanta, GA, 303060.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
32,829 rows, page 196 of 657PreviousNext