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-427364CLMPeter Austin—UHC-85220-8645048369056884 Maple Ave, Gilbert, AZ, 852650.36Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-414601CLMSamuel Ortiz—UHC-72440-13—691 Mesa Dr, Orlando, FL, 328780.36Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+4 more
CLM-416215CLMAlan Maldonado1940-09-18UHC-40405-9896486407403947 Willow Ct # 416, Fresno, CA, 937600.36Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+4 more
CLM-432017CLMNicholas Cunningham1971-07-18UHC-89997-78—7483 Canyon Rd, Phoenix, AZ0.36Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-406578CLMAbigail Hayes1945-12-15——2400 Sage Ct, Denver, CO0.36Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
CLM-411518CLMPeter A Wong——91663333861739 Central Ave, Tempe, AZ, 852830.36Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-413338CLMEvelyn Moore1940-10-11UHC-51694-7458071759407696 Apache Blvd, Eden Prairie, MN0.36Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-405712CLMLis Richardson1990-06-10UHC-29830-20—7253 Elm St # 117, Los Angeles, CA, 900800.36Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-401642CLMDonna G Perez—UHC-15786-23—8563 Palm Dr, Atlanta, GA0.36Name re-casedDate of birth unreadableSSN last four extractedStreet suffix standardised+4 more
CLM-409511CLMLogan Turner1972-06-01UHC-66944-79—3235 Central Ave, San Antonio, TX0.36Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-412180CLMStephanie Y Ruiz1999-01-26UHC-28633-53—1752 Main St, Eden Prairie, MN, 553290.38Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-422425CLMLawrence Sooto1974-08-02UHC-60682-8458239027906232 Willow Ct Apt 30, Tempe, AZ, 852690.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413461CLMNatalie Wang1942-05-17——5516 Market St Apt 23, Austin, TX, 787860.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413958CLMDiana Hamilton1951-05-28——6681 Apache Blvd Apt 22, Charlotte, NC, 282350.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-410842CLMAnn Rios—UHC-55469-7490042133736732 Valley View Dr # 284, Eden Prairie, MN, 553310.38Name split from “Last, First”Date of birth unreadableMember ID reformattedUnit split from street+3 more
CLM-420814CLMLauren Johnson1955-02-23UHC-97366-6325496165958349 Harbor Blvd, Minneapolis, MN, 554400.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-410040CLMJason Mills1986-04-22UHC-72396-45—2460 Grand Ave # 759, Tampa, FL, 336390.38Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-405335CLMSofia Hart2007-01-01UHC-60364-393126488737346 Meadow Ln, Tampa, FL, 336550.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419829CLMJudy Andrews1986-09-07UHC-49978-5835465829106785 Pine Dr, Sacramento, CA, 958450.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-431102CLMAlexis Murray1990-12-15UHC-07375-77—5747 Camelback Rd, San Diego, CA, 921310.38Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-413916CLMDorothy Wods1942-01-03UHC-01218-9055628396035620 Indian School Rd, Houston, TX, 770690.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419379CLMAlbert Ellis2001-08-08——860 Ocean Ave, Houston, TX, 770500.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-424267CLMJack Barnes1940-07-25——5734 Washington St, Atlanta, GA, 303560.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-429997CLMDaniel U Russell—UHC-04417-79—6057 Apache Blvd, Sacramento, CA, 958420.38Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-412435CLMMaria McDonald———8439 Elm St, Houston, TX, 770440.38Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-405215CLMDorothy A Gray1945-08-20UHC-28039-87—9607 Meadow Ln # 871, Las Vegas, NV, 891550.38Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-424718CLMPaul Gordon1954-05-19—68384721259470 Camelback Rd, Miami, FL, 331650.38Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-409898CLMEthan Maldonado1948-10-25——6746 Central Ave, Glendale, AZ0.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-428297CLMMichael Carpenter1995-07-11——8019 Market St, Plano, TX0.38Two-digit birth yearCity re-casedState name converted to codeZIP missing+3 more
CLM-403215CLMPriya West2006-07-03UHC-15513-7821541214537070 Oak St, Charlotte, NC, 282520.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418909CLMCheryl Wells2002-03-22UHC-16740-01—4094 Apache Blvd, Los Angeles, CA, 900850.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408673CLMMariana Z Morrison—UHC-48094-21—8632 Mesa Dr, Chandler, AZ0.38Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-400604CLMGabriel Brown—UHC-97090-9255962756877279 Meadow Ln, Sacramento, CA0.38Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-404095CLMJoshua Mendoza1954-10-27—9532876576650 Valley View Dr Apt 15, Houston, TX, 770670.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-410548CLMDanielle Ford———9012 Central Ave # 138, Plano, TX, 750810.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-403642CLMEmily V Le1997-12-09UHC-71304-1592192778479284 Meadow Ln, Atlanta, GA0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424237CLMBecky Myers———2515 Palm Dr, Tucson, AZ0.38Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-405212CLMKatherine Lucas2000-07-16—88724705659123 Bayshore Dr, Plano, TX, 750470.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-407859CLMRonald B Espinoza1981-09-20—3695381020763 Oak St, Atlanta, GA, 303550.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-430397CLMKeith G Crawford1975-06-10UHC-72967-12—239 Grand Ave, Fresno, CA, 937030.38Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-424715CLMDaniel Jordan1970-02-07——2166 Mountain View Dr, Plano, TX, 750150.38Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-424714CLMDaniel Jordan1970-02-07——2166 Mountain View Dr, Plano, TX, 750150.38Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-414689CLMOlivia Franklin1955-09-28—22133497396531 Hillcrest Rd, San Diego, CA, 921250.38SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-410911CLMRussell Gutierrez1963-10-20—67774973593087 Apache Blvd, Mesa, AZ, 852520.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427060CLMAmanda Singh1946-10-03——2132 Baseline Rd, Dallas, TX, 752740.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408733CLMBrenda Jimenez1946-09-24UHC-35314-08—3317 Mountain View Dr # 635, Atlanta, GA0.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-417893CLMJustin P Tran1941-03-07—49945923123195 Market St, Mesa, AZ, 852320.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429629CLMAmber Banks1975-11-16——2815 Lincoln Way, Fresno, CA, 937920.38Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+3 more
CLM-408164CLMPhilip Black1955-02-06UHC-68692-47—1873 Forest Ave, Houston, TX0.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-432773CLMSteve Marquez2002-01-24—87728546231142 Hillcrest Rd Apt 25, Sacramento, CA, 958640.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 6 of 657PreviousNext