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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-136554ENRBradley McDonald2006-02-04UHC-28129-6564229319655167 Main St Apt 30, Eden Prairie, MN0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-23116PRVLucia F Edwards1970-06-17—43747515306382 Jefferson Ave, Dallas, TX, 752990.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136504ENRRuh C Montgomery1968-10-18UHC-83646-29—125 Sunset Blvd, Atlanta, GA, 303830.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-113152ENRTler Sullivan1992-07-06UHC-70041-9096032156481500 Meadow Ln, Miami, FL, 331150.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+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
ENR-130499ENRBradley U Green1970-06-22UHC-21055-7341288721346742 Market St, Austin, TX, 787410.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+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
TPA-56423TPAVirrginia Hart1982-10-13—50674988224504 Church St # 736, Miami, FL, 331390.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-132257ENRChristina H Hawkins1975-10-25UHC-77082-7320148569662144 Cedar Ln, Austin, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+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
ENR-132029ENRAngela U Henry1969-08-26UHC-34788-4177658683528514 Desert Sky Blvd, San Antonio, TX, 782760.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+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
PRV-21762PRVGerald W Richardson1957-04-11UHC-52791-3529988256601747 Sage Ct, Gilbert, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+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
ENR-117997ENRElizabeth N Contreras1965-06-13UHC-92452-2671450301385143 Elm St, Nashville, TN, 372470.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+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
TPA-60086TPABradley Bryant1990-12-16—20342111543422 Lake View Rd, Atlanta, GA, 303700.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132937ENRVincent Lee1989-04-10UHC-01286-91—6997 River Rd, Glendale, AZ, 853380.50Phone missing area codeSSN last four extractedStreet 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
ENR-142745ENRAmanda Bennett2004-01-08UHC-35446-7748276298396065 Union St # 946, Columbus, OH, 432510.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-114825ENRDaniel X Austin1967-05-16UHC-34567-1086247414771430 Pine Dr # 733, Denver, CO, 802620.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
TPA-62003TPARonald Bennett1988-11-01——3179 Camelback Rd, Fresno, CA, 937940.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-106784ENRDenise L Morgan1995-12-27UHC-49964-5553462324965211 Harbor Blvd Apt 36, Houston, TX, 770850.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+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
ENR-138625ENRLuis Hicks1963-12-07UHC-24118-3322589847247581 Lincoln Way, Tempe, AZ, 852190.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138278ENRSophia Stone1985-10-25UHC-25297-9397690779037630 Mesa Dr # 889, Columbus, OH, 432400.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130246ENREmily X Little1996-04-14UHC-12266-1973754036033165 Sunset Blvd, Chandler, AZ, 852920.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-130247ENREmily X Little1996-04-14UHC-12266-1973754036033165 Sunset Blvd, Chandler, AZ, 852920.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-127584ENRNicole Snyder1988-07-06UHC-47909-5433024176736336 Spring St, San Antonio, TX, 782370.50Name split from “Last, First”Date of birth 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
ENR-102993ENRJesse C Peters1982-04-06UHC-85390-3852038922626712 Ridge Rd, Glendale, AZ, 853610.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-111913ENRChristine D Barnes2006-01-22UHC-70917-3253226338615821 Washington St, Columbus, OH0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23253PRVSamuel Reyes——8256939401445 Mesa Dr, Charlotte, NC, 282560.50Date of birth unreadablePhone reformattedStreet 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
PRV-22666PRVKenneth Carroll——27766743975265 Maple Ave Apt 38, Dallas, TX, 752980.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
100,000 rows, page 84 of 2,000PreviousNext