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-400529CLMDorothy Hill1999-08-03UHC-52013-5327076886477095 Elm St, Orlando, FL, 328630.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402418CLMNatalie S Guzman1994-02-26UHC-13685-4628253780103513 Central Ave Apt 22, Plano, TX, 750080.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-429419CLMBilly Hrrera1981-04-28—76198167623510 Park Pl, Fresno, CA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402761CLMLidna Oliver—UHC-29977-4422944386931038 Sunset Blvd, Eden Prairie, MN, 553750.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-410098CLMJames Cox1982-11-25UHC-14257-05—5562 Indian School Rd # 204, Denver, CO, 802540.48Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+4 more
CLM-411351CLMGerald Bowman1991-02-02——8942 Desert Sky Blvd, Glendale, AZ, 853720.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-411610CLMLawrence Weaver1964-02-04UHC-26133-9892921200243519 Church St, Tempe, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408546CLMRobert Lewis1985-04-22UHC-37733-01—2513 Valley View Dr, Charlotte, NC, 282100.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426624CLMDiana Hunt1949-07-28UHC-91212-74—5404 Hillcrest Rd, Jacksonville, FL, 322070.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430447CLMArthur X Hell—UHC-60721-0392682535218579 Camelback Rd, Chandler, AZ, 852450.48Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-415564CLMLori Roberts—UHC-78605-17—9741 Canyon Rd, Houston, TX, 770710.48Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
CLM-426634CLMBarbara Cooper1993-09-17—49274285261440 Forest Ave, Tempe, AZ, 852450.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-418489CLMBruce Sanchez1958-03-21—72449318202162 Hillcrest Rd, Sacramento, CA, 958430.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-417351CLMSamuel West1959-04-07UHC-29799-4841133948716720 Willow Ct, Austin, TX, 787700.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428260CLMRyan Walker1979-07-19UHC-79552-94—9299 Hillcrest Rd, Las Vegas, NV0.48Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
CLM-412271CLMJerry Jensen1955-08-28UHC-63050-3526795865824916 Sunset Blvd, Nashville, TN, 372550.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429831CLMJesse Lewis1976-02-19UHC-25390-9978045422172263 Oak St, Gilbert, AZ, 852330.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-409998CLMPamela Hicks1990-09-04—23369004956514 Mountain View Dr, Plano, TX, 750560.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-414793CLMScott Ward1943-10-21UHC-40403-019702470172468 Pine Dr # 226, Jacksonville, FL, 322510.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-405986CLMDeborah Vasquez1956-12-13UHC-04821-42—6123 Highland Ave, San Diego, CA, 921500.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429278CLMJohn Bell1979-07-03——4113 Market St, Tucson, AZ, 857850.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-405876CLMDeborah Ramos1996-05-03UHC-13452-1464997362272747 Baseline Rd, Los Angeles, CA, 900080.48Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403710CLMKetih Vazquez1965-05-23UHC-01356-4620966825676164 Grand Ave, Scottsdale, AZ, 852990.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416472CLMFJunk1941-04-09UHC-76175-26—5061 Highland Ave, Las Vegas, NV, 891550.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-406777CLMBradley B Russell2000-07-16UHC-45171-1127499221935244 Valley View Dr, Minneapolis, MN, 554460.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-414746CLMLori Jones—UHC-48852-5786967864947860 Mesa Dr, Atlanta, GA, 303670.48Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
CLM-415569CLMTimothy Brown1962-05-07UHC-81996-24—2918 Highland Ave # 420, Charlotte, NC, 282090.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-414252CLMLisa Hughes2005-08-28UHC-77813-26—3596 Main St, Las Vegas, NV, 891780.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-408510CLMVincent Stevens1975-10-05UHC-60712-5947239524321528 Baseline Rd, Sacramento, CA, 958450.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416760CLMJeffrey Jones1994-10-09UHC-52048-1697467676396076 Market St, Columbus, OH0.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-410757CLMShirley Armstrong1993-03-18—26758318725754 Harbor Blvd, San Antonio, TX, 782240.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-407602CLMAnthony Murphy1959-01-19UHC-88733-62—528 Canyon Rd, Phoenix, AZ, 850240.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407400CLMMatthews Pamela1990-07-12UHC-37090-99—7195 Sage Ct, Houston, TX, 770260.50Phone missing area codeMember ID reformattedCity re-casedZIP+4 trimmed+3 more
CLM-407401CLMMatthews Pamela1990-07-12UHC-37090-99—7195 Sage Ct, Houston, TX, 770260.50Phone missing area codeMember ID reformattedCity re-casedZIP+4 trimmed+3 more
CLM-429792CLMJeremy Moore1995-09-27—94557312227041 Willow Ct Apt 13, Mesa, AZ, 852620.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-432472CLMJuan Snyder——27796785547663 Spring St # 821, Las Vegas, NV, 891640.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-421353CLMElijah Clark1966-03-23UHC-01209-6129169981803071 Oak St, Chandler, AZ, 852950.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421352CLMElijah Clark1966-03-23UHC-01209-6129169981803071 Oak St, Chandler, AZ, 852950.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420411CLMEspinoza Jason1959-09-06UHC-11220-61—7502 Central Ave, Miami, FL, 331090.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-422442CLMSilva Emma1977-06-11—36132587237932 Grand Ave, Tucson, AZ, 857880.50Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+3 more
CLM-431076CLMRobert Mason1978-01-24——4934 Mountain View Dr Apt 25, Orlando, FL, 328390.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-415490CLMCharlotte Obrien1944-12-04UHC-09453-36—2619 Central Ave, San Diego, CA, 921100.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416989CLMDouglas Howell1959-05-10UHC-59326-05—275 Apache Blvd # 389, Minneapolis, MN, 554170.50Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+3 more
CLM-404870CLMKyle Cruz1970-07-28UHC-67404-3374273260304360 Broadway # 696, Glendale, AZ0.50Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
CLM-432478CLMWillie Bennett1968-01-25UHC-41101-83—1924 Highland Ave Apt 2, Columbus, OH0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-424769CLMSophia Cole1979-10-03——5607 Ridge Rd Apt 7, Austin, TX, 787110.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-406019CLMKayla L Bell1982-09-18——6689 Canyon Rd Apt 6, Dallas, TX, 752490.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-404230CLMDiana Reid2000-01-25——548 Central Ave, Houston, TX, 770060.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430569CLMKelly Miller1970-07-10UHC-14354-7458848518344486 Palm Dr, Gilbert, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431084CLMGoerge Jones2006-12-09UHC-24975-70—3287 Lincoln Way Apt 28, Atlanta, GA, 303330.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
32,829 rows, page 22 of 657PreviousNext