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-108984ENRJess Chapman2003-12-21UHC-58883-444519364767360 Desert Sky Blvd, Tampa, FL, 336190.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
PRV-20429PRVCarol P Powell1948-10-05—93339346796617 Highland Ave, Tucson, AZ, 857640.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132192ENRVincant Sullivan1973-06-20UHC-26763-5529775896488234 Jefferson Ave Apt 18, San Antonio, TX, 782460.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
ENR-103683ENRRonald Morales1967-07-24UHC-74352-8839583783736914 Cedar Ln, Denver, CO, 802150.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58426TPADanny Johnson1941-03-27—28548108468387 Church St # 385, Tempe, AZ0.48Name re-casedDate of birth reformattedUnit split from streetState code upper-cased+4 more
CLM-401163CLMSara Guzman1958-06-21—81540870093218 Hillcrest Rd, Eden Prairie, MN, 553540.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130871ENRWayne Nelson2003-08-18UHC-16289-7964032766044213 Spring St, Charlotte, NC, 282930.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-400262CLMRonald Estrada1972-07-19——8013 Market St # 880, Mesa, AZ, 852960.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-110446ENRBeverly U Lewis1979-09-21UHC-51806-33—1731 Sunset Blvd, Tempe, AZ, 852520.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-120227ENRAlice Patterson—UHC-05568-6539762847929575 Washington St, Chandler, AZ0.48Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
PRV-21444PRVEmma L Carpenter1987-06-28—4109002257286 Market St, Jacksonville, FL, 322950.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-120873ENRLauren E Davis1980-12-09UHC-50623-5979233934533712 Main St, Columbus, OH, 432930.48Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-111680ENRBerb S Weaver1958-06-24UHC-62451-8658191291004612 Cedar Ln, Phoenix, AZ, 850090.48Middle initial moved out of first nameSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-414052CLMIsabella Z Watkins1967-06-02UHC-63631-99—1407 Ocean Ave # 261, Mesa, AZ, 852230.48Date of birth reformattedSSN last four extractedUnit split from streetStreet suffix standardised+4 more
ENR-130287ENRDouglas Wallace2001-08-24UHC-52717-4073358909956536 Lake View Rd, Glendale, AZ, 853790.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50179TPAJeremy K Young2002-05-20——6020 Jefferson Ave # 274, Columbus, OH, 432870.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-64411TPAEmily Stephens1940-08-13——7973 Mesa Dr, Scottsdale, AZ, 852040.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102963ENRDiego Carter1966-08-09UHC-45682-2697965657031203 Mountain View Dr, Austin, TX0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-410870CLMGerald I Bennett——51080651934382 Canyon Rd, Columbus, OH, 432340.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
TPA-56482TPASophia Perez1948-12-19—44527874322043 Forest Ave # 457, Sacramento, CA0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-21627PRVKimberly Alexander1955-06-01—68085369988543 Forest Ave, Chandler, AZ, 852430.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-105303ENRRoger Watson1948-04-27UHC-88620-9543679147756246 Forest Ave, Minneapolis, MN, 554290.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-105302ENRRoger Watson1948-04-27UHC-88620-9543679147756246 Forest Ave, Minneapolis, MN, 554290.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-119224ENRFrances Z Luna2001-12-16UHC-25455-9038670863362882 Canyon Rd, Gilbert, AZ, 852710.48Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+4 more
TPA-61018TPACarol Meyer1979-07-21—24294895813897 Camelback Rd Apt 35, Nashville, TN, 372650.48Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-102066ENRRonald R Howard2000-04-14UHC-79531-3624469307484968 Valley View Dr, Jacksonville, FL0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-141580ENRChristian P Lee1989-05-03UHC-56820-6669870803863985 Canyon Rd, Atlanta, GA0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-25165PRVMaria Baker1972-02-28—65090383825242 Hillcrest Rd, Nashville, TN, 372620.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-137937ENRGloria Chapman1938-10-11UHC-10323-5847826301964425 Mesa Dr Apt 8, Denver, CO0.48Phone reformattedMember ID reformattedUnit split from streetCity re-cased+4 more
CLM-430059CLMChristine Phillips1989-02-18UHC-86842-73—3969 Hillcrest Rd # 129, Gilbert, AZ, 852910.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-115903ENRAna W Andrews1952-07-20UHC-89158-54—2817 Apache Blvd, Denver, CO0.48Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-102285ENRAnna K King1941-01-11UHC-76044-905507012262251 Main St # 202, Eden Prairie, MN, 553230.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-135250ENRJordan Ferguson—UHC-68665-0332549192476753 Sage Ct, Seattle, WA, 981330.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-132500ENRZachary Gibson2001-08-24UHC-91881-9849650295121442 Maple Ave, Austin, TX, 787960.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419307CLMNoah Roberts1953-07-09UHC-09396-3868583620985412 Main St Apt 9, Mesa, AZ, 852160.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-137595ENRGrace U Mendez1962-06-05UHC-83618-8255973308834883 Apache Blvd Apt 18, Orlando, FL, 328210.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-431333CLMRebecca Stewart1941-09-21UHC-12215-275966087482378 Willow Ct, Plano, TX, 750590.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-125068ENRHeather V Berry2004-06-17UHC-78489-9522184500994277 Spring St, San Antonio, TX, 782430.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-105254ENRAshley Hayes1993-03-18UHC-32375-6440677299673942 Highland Ave, Plano, TX, 750090.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-114296ENRLaura W Jonson1981-01-03UHC-73708-612892278574184 Meadow Ln, San Antonio, TX, 782030.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425633CLMJoyce Williams1955-08-15UHC-83998-1340994407577046 Oak St Apt 36, Dallas, TX, 752430.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-130047ENRKathy J Fisher1940-06-22UHC-76265-1340525612738461 Harbor Blvd, San Diego, CA, 921080.48Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430051CLMGary Chapman1981-02-12——8674 Lake View Rd, San Diego, CA, 921450.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-126407ENRVirginia Wilson1999-05-18UHC-88267-97—7763 Oak St, San Antonio, TX, 782680.48Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
CLM-409043CLMLogan Hart2000-06-10UHC-52400-4861576470739697 Sage Ct, Sacramento, CA, 958220.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-137144ENRDenny O Dean1974-02-06UHC-07591-253653866925863 Forest Ave, Gilbert, AZ, 852730.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-123769ENRRachel Murray—UHC-86163-9061784728091127 River Rd, Tampa, FL, 336280.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
PRV-29104PRVJulia Chavvez1958-02-19UHC-90166-6068354036046840 Willow Ct, Atlanta, GA, 303000.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-120318ENRLogan Stewart1974-03-04UHC-35018-9598380767567919 Mesa Dr # 262, Nashville, TN, 372660.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-114251ENRFrank Q Gomez1940-12-15UHC-57895-2753784753542750 Mesa Dr, Austin, TX, 787870.48Name re-casedDate of birth reformattedMember ID reformattedSSN last four extracted+4 more
100,000 rows, page 77 of 2,000PreviousNext