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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-123021ENRJanet Perry1966-11-20UHC-78618-4549967182079064 Bayshore Dr, Charlotte, NC, 282810.54Two-digit birth yearPhone reformattedSSN last four extractedState name converted to code+1 more
ENR-141907ENRJustin Hernandez1939-02-15UHC-93913-1260328498714617 Willow Ct, Gilbert, AZ0.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-120644ENRBrandon P Mason1940-02-11UHC-72913-092296444365617 Elm St, Tucson, AZ, 857010.54Name split from “Last, First”City re-casedState name converted to codeGender normalised+1 more
ENR-120554ENRAnna Ortega—UHC-30781-8086248896391899 Elm St, Las Vegas, NV0.54Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-116023ENRSaraah O Sulivan1968-10-17UHC-55633-98—4140 Highland Ave, San Diego, CA, 921550.54SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-128020ENRNoah Cook1966-08-22UHC-73381-7775522847247531 Oak St, Austin, TX, 787330.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-126085ENRArjun X Guerrero1991-07-07UHC-90114-99—9583 Jefferson Ave, Columbus, OH, 432650.54Two-digit birth yearState name converted to codeEmail lower-casedGender normalised+1 more
ENR-116807ENRJuan B Carpenter2000-06-11UHC-33252-10—5866 Church St, Columbus, OH, 432370.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-130128ENRCheryl C Harrison1954-12-16UHC-63017-8939930841243389 Meadow Ln, Los Angeles, CA, 900370.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-102382ENRKayla V Oliver1968-06-25UHC-52302-689247620522159 Meadow Ln, Sacramento, CA, 958180.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-119708ENREugene Wallace1942-06-16UHC-99190-1422073350968878 Baseline Rd, Jacksonville, FL, 322190.54Two-digit birth yearPhone reformattedState name converted to codeEmail lower-cased+1 more
ENR-119258ENRKathleen Andrews1960-05-22UHC-09149-8730920807634573 Baseline Rd # 273, Phoenix, AZ, 850360.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-142527ENRHiroshi B Russell—UHC-16259-545902349183203 Oak St, Phoenix, AZ, 850300.54Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-101297ENRKenneth I Wong1994-06-21UHC-77202-56—6751 Central Ave, Chandler, AZ, 852500.54Two-digit birth yearState name converted to codeZIP+4 trimmedEmail lower-cased+1 more
ENR-104008ENRRuth Black1963-11-09UHC-63053-4622280507833100 Washington St, Plano, TX0.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-140998ENRDonna Morris2003-07-27UHC-81537-6253368510737992 Elm St Apt 3, Nashville, TN0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-137581ENRRoger C Gomez2000-11-06UHC-26333-1859732571583214 Sage Ct, Tempe, AZ0.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-105916ENRGregory Mitchell1973-05-09UHC-64045-83—199 Highland Ave, Glendale, AZ, 853660.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-125232ENRKim P Karen1993-01-13UHC-31368-1926141325658068 Mountain View Dr, Dallas, TX, 752060.54Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+1 more
ENR-103710ENRCatherine Z Cook1990-06-20—67932464193042 Cedar Ln, Los Angeles, CA, 900940.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-103312ENRStephanie T Garcia1940-02-21UHC-63671-8394070018398820 Central Ave # 550, Sacramento, CA, 958570.54Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+1 more
ENR-122203ENRMichelle Chavez1992-04-26UHC-36979-40—5832 Sunset Blvd, Scottsdale, AZ, 852880.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-129488ENRJose Vargas1990-12-04UHC-62704-9733959898868971 Main St, Tempe, AZ, 852030.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-116675ENRIsabella N Torres2008-09-07UHC-07446-4036583956387978 Ridge Rd, Tucson, AZ, 857850.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-123051ENRZachary Romero1992-04-13UHC-18836-747353258273283 Camelback Rd, Eden Prairie, MN, 553270.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-105936ENRMartha D Yang1957-02-23UHC-83060-1558681465743884 Oak St, Orlando, FL0.54Date of birth reformattedSSN last four extractedState name converted to codeZIP missing+1 more
ENR-112279ENREddie Z Morales1992-03-08UHC-12549-9630377575915801 Forest Ave, Tampa, FL, 336850.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-117791ENRMelissa Whie2000-05-10UHC-48799-0247064171558965 Main St, Tempe, AZ0.54Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-109765ENRJoseph C Kiing1982-12-04UHC-46651-1170383629469130 Broadway Apt 37, Jacksonville, FL0.54Name split from “Last, First”Phone reformattedUnit split from streetZIP missing+1 more
ENR-121699ENRLaura I Herrera1959-06-27UHC-79427-4321127812938443 Willow Ct, Phoenix, AZ0.54Name re-casedPhone reformattedState name converted to codeZIP missing+1 more
ENR-122942ENRCharles Aguilar1991-11-08UHC-47926-5945198074314747 Church St # 907, Miami, FL, 331410.54Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+1 more
ENR-115756ENRWang Jose1988-02-03UHC-58676-0755793448673956 Indian School Rd, Atlanta, GA, 303080.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-140279ENRMaria Z Fernandez—UHC-39681-763094187173318 Hillcrest Rd, Glendale, AZ, 853380.54Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-142928ENRSuasn U Hart1938-10-02UHC-24309-1935560063182889 Maple Ave, Fresno, CA, 937960.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-125367ENRNicholas Silva—UHC-83506-5021945729633586 Forest Ave, Chandler, AZ, 852170.54Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-131056ENRJanet G Medina1969-11-27UHC-08466-3982563025959565 Lake View Rd, Scottsdale, AZ, 852260.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-111194ENRMartha Dean1983-08-15UHC-45430-60—2239 Washington St, Charlotte, NC, 282490.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-103130ENRCamila Spencer2008-06-20UHC-06958-03—730 Lake View Rd, Fresno, CA, 937360.54Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-112883ENRMei A Johnson1978-02-23UHC-36165-09—4634 River Rd # 113, Plano, TX, 750890.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-125874ENRKim Franklin—UHC-00943-54—8818 Elm St # 133, Atlanta, GA, 303520.54Name re-casedDate of birth unreadablePhone missing area codeUnit split from street+1 more
ENR-132073ENRMark E Scott—UHC-18709-4774383974205120 Willow Ct, Gilbert, AZ, 852680.54Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+1 more
ENR-130703ENRRalph R Bailey1968-01-10UHC-65270-9750330353069827 Elm St # 426, Houston, TX, 770970.54Unit split from streetCity re-casedState name converted to codeGender normalised+1 more
ENR-112763ENRCamila H Nguyen1940-02-11UHC-16080-8924989637121696 Lake View Rd, Phoenix, AZ, 850960.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-100501ENRDonna S Sullivan1995-08-15UHC-77457-3778055691803502 Lincoln Way, Denver, CO, 802230.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-125548ENRAlan R Austin—UHC-92138-8880232731027497 Elm St, Austin, TX, 787580.54Date of birth unreadablePhone reformattedSSN last four extractedCity re-cased+1 more
ENR-116801ENREthan Webb1978-02-22UHC-84411-1873030147077603 River Rd Apt 28, Scottsdale, AZ, 852700.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-108633ENRKayla Lee1941-02-24UHC-04196-2856923922722438 Willow Ct Apt 37, Las Vegas, NV0.54Phone reformattedUnit split from streetState name converted to codeZIP missing+1 more
ENR-118593ENRCarlos U Daniels—UHC-16011-75—7763 Main St, Gilbert, AZ, 852180.54Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-103165ENRLaura K Austin—UHC-04604-6685666988317668 Jefferson Ave, Houston, TX, 770520.54Middle initial moved out of first nameDate of birth unreadablePhone reformattedZIP+4 trimmed+1 more
ENR-134872ENRJulie Y Santos2007-05-07UHC-40432-3354278462756524 Canyon Rd # 409, San Diego, CA, 921570.54Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+1 more
43,101 rows, page 100 of 863PreviousNext