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-413302CLMTeresa Ford2007-08-17UHC-20506-45—9494 Market St, Gilbert, AZ, 852590.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-416007CLMBrian M Lawrence1981-07-24UHC-44332-02——0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-410850CLMCharlotte Kenneedy—UHC-67859-40—1168 Apache Blvd, San Diego, CA, 921460.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-422402CLMSharon Campbell1956-06-07——878 Canyon Rd, Tucson, AZ, 857180.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-432164CLMRachel Holmes1982-08-28——9194 Desert Sky Blvd Apt 19, Los Angeles, CA, 900010.68Unit split from streetZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-413885CLMJonathan Evans1938-10-24UHC-49583-7485634348961311 Palm Dr, Austin, TX, 787220.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-401228CLMYuki Stone1942-05-22UHC-81424-76—1220 Forest Ave, Columbus, OH, 432410.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-405922CLMSteven Orteag1941-03-27UHC-06063-03—1456 Jefferson Ave, Tempe, AZ, 852390.68Two-digit birth yearSSN last four extractedWhitespace trimmedPlaceholder values cleared
CLM-401351CLMCarolyn Snyder1981-08-10——6684 Meadow Ln, Scottsdale, AZ0.68Date of birth reformattedPhone missing area codeZIP missingPlaceholder values cleared
CLM-412851CLMAna Fuller—UHC-81544-39—3985 Desert Sky Blvd, Mesa, AZ0.68Date of birth unreadableZIP missingWhitespace trimmedPlaceholder values cleared
CLM-405932CLMAmber Oliver1949-08-23UHC-05224-5157779484761841 Willow Ct, Scottsdale, AZ, 852360.68Name re-casedTwo-digit birth yearState name converted to codePlaceholder values cleared
CLM-430925CLMKimberly V Richardson1951-05-02———0.68Middle initial moved out of first nameGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-415565CLMFatima G Vasquez1981-08-13—82450207993158 Valley View Dr, Los Angeles, CA, 900940.68Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased
CLM-408102CLMJudith Peters1972-01-24—47987127571591 Canyon Rd, Dallas, TX, 752190.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-402255CLMDebra Hoffman1989-03-03UHC-99555-59—9110 Grand Ave, Scottsdale, AZ, 852330.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-401058CLMCharles Hunter1989-06-08——5023 Elm St Apt 4, Tempe, AZ, 852670.68Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-407384CLMGeorge Holmes—UHC-85048-47——0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-429672CLMDonna Jenkins1958-12-26UHC-36805-7996498028792650 Maple Ave, Charlotte, NC0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-403165CLMDylan Morris1947-09-14———0.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
CLM-425741CLMLuis Dominguez1955-05-24UHC-85052-29—42 Washington St, Los Angeles, CA, 900340.68Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised
CLM-406696CLMAna R Austin—UHC-98418-43——0.68Name re-casedDate of birth missingGender normalisedPlaceholder values cleared
CLM-406697CLMAna R Austin—UHC-98418-43——0.68Name re-casedDate of birth missingGender normalisedPlaceholder values cleared
CLM-418605CLMCynthia Gray1986-06-08UHC-12777-9845141326507290 Washington St, Jacksonville, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-424488CLMDouglas E Stephens1969-06-24—27171923262790 Desert Sky Blvd, Houston, TX, 770220.68Middle initial moved out of first namePhone reformattedState name converted to codePlaceholder values cleared
CLM-430836CLMGrace Santos1972-06-27—56047332721178 Central Ave, Austin, TX, 787790.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-414133CLMKaren N Welch1955-01-05UHC-51273-0255681198965842 Washington St, Plano, TX, 750960.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-400239CLMEmily Rice1955-12-08UHC-52218-454108956746—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-400417CLMStephen Vasquez1957-08-23—69981075387979 Canyon Rd, Houston, TX, 770290.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-414465CLMWilliam Allen1953-06-12UHC-46233-87—430 Highland Ave, Dallas, TX, 752670.68Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased
CLM-430688CLMStephen Ford1974-03-24UHC-14624-8345634695558206 River Rd, Sacramento, CA0.68Date of birth reformattedState name converted to codeZIP missingPlaceholder values cleared
CLM-410150CLMMatthew Mason1975-11-09UHC-38038-76—1967 Indian School Rd, Fresno, CA, 937380.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412589CLMJesse Ross1940-07-10UHC-10623-58——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-404465CLMBruce K Stephens1938-03-04UHC-46738-1341060700756482 Union St, Orlando, FL, 328440.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-423550CLMLauren Reynolds———7932 Willow Ct, Columbus, OH0.68Date of birth unreadableCity re-casedZIP missingPlaceholder values cleared
CLM-417926CLMSean Dixon1999-10-04UHC-62395-04—3247 Mountain View Dr, Nashville, TN0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-421156CLMRandy Alvarado2000-02-01UHC-90506-58—5022 Sunset Blvd, Orlando, FL, 328300.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406540CLMChristopher Owens1988-11-07UHC-06809-20—5084 Broadway # 916, Gilbert, AZ, 852460.68Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-415756CLMNicole Daniels2002-09-27UHC-34186-32—6952 Central Ave, Tampa, FL, 336270.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-420921CLMDenise J Lucas1997-06-10UHC-21721-41—1042 Sunset Blvd, Tampa, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-416207CLMMaria Meyer1957-11-25UHC-73025-52—7272 Mesa Dr, Dallas, TX, 752470.68Date of birth reformattedSSN last four extractedZIP+4 trimmedPlaceholder values cleared
CLM-416206CLMMaria Meyer1957-11-25UHC-73025-52—7272 Mesa Dr, Dallas, TX, 752470.68Date of birth reformattedSSN last four extractedZIP+4 trimmedPlaceholder values cleared
CLM-419587CLMKaren R Stewart2001-02-02UHC-89576-14——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421668CLMDanielle G Nichols1940-03-06UHC-84780-7456039248324735 Harbor Blvd, Austin, TX, 787700.68Phone reformattedZIP+4 trimmedEmail lower-casedGender normalised
CLM-420547CLMBruce J Wright1963-11-10UHC-57010-363139077538—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-419534CLMTerry Y Banks1974-12-03UHC-30407-95—1760 Highland Ave, Orlando, FL, 328300.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
CLM-429923CLMStephen Freeman1991-10-18UHC-40496-41—1765 Spring St # 190, Atlanta, GA, 303980.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-418728CLMCatherine Smith1969-04-03UHC-24248-33—6032 Market St Apt 31, Dallas, TX, 752990.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
CLM-422669CLMNoah Sanchez1989-10-24UHC-62379-68—8247 Ridge Rd, Los Angeles, CA, 900560.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-410518CLMDiego M Martin2007-11-05——2849 Apache Blvd # 993, Orlando, FL, 328720.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-405571CLMLawrence Sullivan—UHC-85120-50——0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
32,829 rows, page 202 of 657PreviousNext