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-415661CLMJerry Cox1957-06-05——1970 Baseline Rd, Columbus, OH0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420902CLMNicholas Alexander1955-02-23UHC-81486-0754669500286174 Central Ave # 438, San Diego, CA, 921540.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-421289CLMMrilyn Soto1943-08-15——7701 Church St, Tempe, AZ, 852220.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-421309CLMCarol Rose1975-01-26—79048896984217 Willow Ct, Tampa, FL0.62Name re-casedDate of birth reformattedCity re-casedZIP missing+3 more
CLM-423251CLMLarry Campbell1950-10-28UHC-12054-7946656991025628 Ridge Rd, Nashville, TN, 372230.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-410894CLMJulie B Perry1941-11-10UHC-61280-6860246786717330 Canyon Rd, San Diego, CA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424289CLMMei King1976-07-28—68074464146872 Washington St, Tucson, AZ, 857260.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412943CLMGloria S Allen1976-12-08UHC-05703-453084703302585 River Rd, Austin, TX, 787730.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403547CLMTeresa Wilosn1977-09-18UHC-45385-633675462817456 Canyon Rd, Tucson, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407014CLMJacob L Kim1958-07-15UHC-18672-9648774896248072 Elm St, Jacksonville, FL, 322910.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-416510CLMAustin Ynag1968-02-23UHC-44918-67—1316 River Rd, Tampa, FL, 336700.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432427CLMJustin Cruz1944-09-18UHC-59406-3041967781482917 Ridge Rd, San Antonio, TX0.62Name re-casedDate of birth reformattedPhone reformattedZIP missing+3 more
CLM-418346CLMJoan D Bishop1960-11-01UHC-81997-9437661494802326 Canyon Rd, Tampa, FL, 336700.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404167CLMRick U Matthews1958-07-27UHC-04859-748945794523276 Ridge Rd, Orlando, FL, 328570.62Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-411987CLMChris Elliott2001-08-27UHC-77522-55—6246 Church St, Austin, TX, 787040.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-424869CLMNany Mills1950-02-27——4406 Sunset Blvd, Chandler, AZ, 852510.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418175CLMMichael Diaz1967-02-07UHC-32363-72—7862 Indian School Rd, Eden Prairie, MN, 553180.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-416101CLMYuki Marquez1975-11-13—71423499495165 Mountain View Dr, Houston, TX, 770770.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-425207CLMKaren Owens2002-09-07UHC-11443-63—4662 Harbor Blvd, Minneapolis, MN, 554810.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431920CLMBryan Grant——53977066087460 Mountain View Dr, Chandler, AZ, 852540.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-403399CLMKatherine Marshall1944-08-16UHC-61716-6557198860696981 Grand Ave, Fresno, CA, 937350.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401070CLMEric Jimenez———3062 Meadow Ln, Chandler, AZ, 852500.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-429711CLMRobert Walker1988-05-09UHC-76321-65—1063 Mesa Dr, San Antonio, TX0.62Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-429739CLMAustin L Nguyen1939-12-26—31689526437868 Highland Ave, Jacksonville, FL, 322790.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-402056CLMWalter Ortega1960-11-18—75898641663191 Elm St, San Antonio, TX, 782960.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-420013CLMTerry Burns1971-09-12UHC-17911-64—8343 Main St, Tampa, FL, 336010.62Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
CLM-419537CLMHenry Brooks1980-08-28UHC-09209-8720869813979799 Pine Dr, Denver, CO, 802170.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430908CLMJuse Pena1972-04-18—36737809611513 Indian School Rd, Los Angeles, CA, 900560.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429677CLMMadison U Franklin1975-01-16UHC-89354-8127283669636733 Oak St, Tucson, AZ, 857110.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-410111CLMKevin M James1968-07-04UHC-20440-3080221841837132 Lake View Rd # 492, Orlando, FL, 328410.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-424342CLMJanet Anderson2002-10-24UHC-16486-01—3028 Willow Ct # 487, San Antonio, TX, 782040.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-424803CLMFatima Ford1970-04-08UHC-30010-1194531982035826 Pine Dr # 698, Mesa, AZ, 852050.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402489CLMCharlotte Clark1939-07-20UHC-71305-3956622820637782 River Rd, Minneapolis, MN0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400264CLMCharlotte Ortiz2002-10-16UHC-52389-4945944797627944 Canyon Rd, Columbus, OH0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405691CLMSantiago Mendoza1939-10-25—82586979144106 Central Ave, San Diego, CA, 921240.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400005CLMJesse Black2004-10-05UHC-94495-51—3456 Bayshore Dr, Nashville, TN, 372300.62Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-427735CLMBeverly Padilla1940-02-20UHC-77581-82—5745 Grand Ave, Las Vegas, NV, 891910.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-409410CLMCarlos F Mendez1967-01-27——9858 Elm St, San Antonio, TX, 782880.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403741CLMMei A Griffin1958-01-25UHC-58308-51—7654 Mesa Dr, Sacramento, CA, 958600.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-432195CLMAlexis Hicks1950-12-06UHC-23659-3198641334267538 Market St Apt 30, Seattle, WA0.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-409579CLMBrian Pallmer—UHC-03330-36—4587 Sunset Blvd, Charlotte, NC, 282560.62Date of birth reformattedDate of birth unreadableMember ID reformattedStreet suffix standardised+3 more
CLM-432223CLMQJunk1974-02-04UHC-41356-3331075608704275 Union St, Mesa, AZ, 852060.62Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-402530CLMJerry Johnson1966-05-03UHC-03123-7056533900965614 Palm Dr, San Diego, CA, 921250.62Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more
CLM-400924CLMPeter Carter——59825475308215 Market St, Fresno, CA, 937550.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-407008CLMEmily Silva1976-12-22UHC-43687-7172294205144265 Union St, Los Angeles, CA, 900670.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401785CLMAmy I Rice1991-06-04UHC-66150-22—7485 Highland Ave, Denver, CO, 802650.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426052CLMCarlos Estrada1969-05-14——4195 Ocean Ave, Denver, CO, 802810.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426133CLMHiroshi Garza2005-11-05UHC-77416-36—3626 Indian School Rd, Plano, TX, 750180.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416575CLMEthan Welch1949-09-13——1962 Mesa Dr, San Antonio, TX, 782210.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430390CLMKeith Kennedy2007-04-08UHC-38492-3240485915328920 Palm Dr, Houston, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 84 of 657PreviousNext