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-415069CLMDenise Richardson2002-10-07UHC-40221-43—6090 Spring St, Chandler, AZ, 852530.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415113CLMCharles Hill1993-12-10UHC-05062-59—7232 Grand Ave, Denver, CO, 802390.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
CLM-412321CLMTerry W Richards1989-11-18—25353873962331 Apache Blvd, Minneapolis, MN, 554810.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408280CLMJennifer A Rogers1942-06-12UHC-08853-68—5864 Union St, Scottsdale, AZ, 852990.52Middle initial moved out of first nameName re-casedTwo-digit birth yearStreet suffix standardised+2 more
CLM-432004CLMKevin Mitchell1962-07-27UHC-59458-43—661 Valley View Dr, Dallas, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-432772CLMDan Webb—UHC-96158-05—7729 Union St, Atlanta, GA, 303090.52Date of birth unreadableSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-406564CLMAnthuny U Rios1984-09-02UHC-38512-88—5354 Camelback Rd, Gilbert, AZ, 852460.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400312CLMJames Romero1992-08-19UHC-88315-3981564994812891 Sunset Blvd, Dallas, TX0.52Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
CLM-416624CLMDennis Vargas1944-05-16—72259914755789 Elm St # 203, Gilbert, AZ, 852970.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
CLM-426593CLMAmanda Patterson1977-02-24UHC-12161-92—5482 Desert Sky Blvd # 778, Chandler, AZ, 852340.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430513CLMLauren H Rice——47723888347069 Sage Ct, Los Angeles, CA, 900950.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404580CLMMelissa Dominguez1941-01-16——6079 Canyon Rd, Columbus, OH0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-416825CLMCynthia Mason——36177133808767 Central Ave Apt 38, Fresno, CA, 937660.52Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-409960CLMKyle Taylor2006-05-28UHC-63974-9570395137588390 Market St, Tampa, FL0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417586CLMHannah Luna1980-07-17UHC-65080-5496424096714685 Grand Ave, Tampa, FL0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415802CLMBrian Daniels1991-04-27——1346 Grand Ave, Mesa, AZ, 852530.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-409392CLMAbigail K Holmes1994-03-16UHC-14169-2740835969516461 Main St, Denver, CO, 802000.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403550CLMCarolyn O Jackson2002-11-02UHC-39760-46—2843 Mesa Dr, Atlanta, GA, 303050.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-424362CLMPamela Hayes1967-07-20——3336 Valley View Dr, Atlanta, GA, 303250.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-428688CLMIsabella Wang———600 Church St, Minneapolis, MN, 554330.52Name split from “Last, First”Date of birth unreadableZIP+4 trimmedPlan code upper-cased+2 more
CLM-418581CLMSamuel Santiago1960-07-21UHC-56570-42—2697 Cedar Ln, Las Vegas, NV, 891860.52Name re-casedMember ID reformattedSSN last four extractedState name converted to code+2 more
CLM-431666CLMRoger Luna1960-10-11——2436 Indian School Rd, Miami, FL, 331480.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428552CLMEugene Mendez1942-11-24——1937 Meadow Ln, Chandler, AZ, 852440.52SSN last four extractedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-400793CLMRoger Mason1964-04-28UHC-97852-8384893921245276 River Rd, Sacramento, CA0.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-413694CLMJesse Knight2004-04-28—39693084862451 Meadow Ln, Seattle, WA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425278CLMPhilip R Bailey2006-02-08UHC-50588-6544075960364686 Ocean Ave # 412, Miami, FL, 331180.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-426269CLMSharon Lynch1942-12-05UHC-84606-18—7952 Mountain View Dr Apt 15, Nashville, TN, 372490.52Date of birth reformattedSSN last four extractedUnit split from streetCity re-cased+2 more
CLM-423259CLMMark Howell——5226252989—0.52Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+2 more
CLM-400394CLMChristopherJunk1944-11-18UHC-48535-90—3313 Desert Sky Blvd, Minneapolis, MN, 554050.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-412033CLMSamuel L Wong2005-10-12——9102 Forest Ave, Houston, TX, 770620.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-409923CLMRandy L Castillo1981-06-23UHC-52935-57—7377 Mesa Dr, Las Vegas, NV, 891900.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414975CLMKeith Vasquze2000-09-04UHC-43961-56—3840 Elm St, Scottsdale, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-401563CLMRichard Stewart1997-01-27——524 Mountain View Dr, Miami, FL0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-420397CLMCarol Castillo2004-05-18UHC-75924-10—9167 Canyon Rd, Tampa, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413599CLMSteven Carr—UHC-95393-63—3232 Willow Ct, Houston, TX, 770570.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-403018CLMNancy S Vazquez1967-08-27—65551461714030 Maple Ave Apt 9, Scottsdale, AZ, 852070.52Phone reformattedUnit split from streetZIP+4 trimmedGender normalised+2 more
CLM-410401CLMBrian Hall1946-06-06UHC-70681-1177283313127724 Ridge Rd, Dallas, TX0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409627CLMVirginia T Rie1942-12-26—57945767836678 Lincoln Way, Fresno, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-403705CLMSamantha Z Guzman1969-12-26UHC-92739-3791182846335202 Market St, Los Angeles, CA, 900400.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410851CLMKayla D Thompson1963-09-26UHC-24551-29711953873989 Park Pl, Mesa, AZ, 852760.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408080CLMMarcus Scott2003-02-20UHC-58921-8954756763422530 Harbor Blvd, Mesa, AZ, 852520.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-432061CLMCarl G Rios——6892764410180 Meadow Ln, Tucson, AZ, 857620.52Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-429482CLMDenise Obrien1947-05-13UHC-16406-7958785166719137 Indian School Rd Apt 23, Nashville, TN, 372800.52Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+2 more
CLM-416764CLMRalph Sullivan1943-12-18UHC-55195-82—19 Washington St # 885, Orlando, FL, 328670.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425803CLMStephanie Chapman1961-10-04UHC-42279-63—7839 Main St, Gilbert, AZ, 852620.52Name split from “Last, First”Member ID reformattedState name converted to codeGender normalised+2 more
CLM-424128CLMJustin Boyd2007-09-17——3999 Pine Dr, Tempe, AZ, 852680.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-411641CLMJason Moreno1977-12-24——7109 Pine Dr, Mesa, AZ, 852700.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-427104CLMLori Burke1960-03-14—95829860803482 Sage Ct, Charlotte, NC, 282400.52Name split from “Last, First”Two-digit birth yearPhone reformattedState name converted to code+2 more
CLM-409751CLMAmber Powell1964-03-27UHC-53088-98—7198 Ridge Rd, San Antonio, TX, 782520.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410544CLMNicole Nunez———6643 Valley View Dr, Dallas, TX0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
32,829 rows, page 50 of 657PreviousNext