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-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
CLM-407991CLMSamantha Nunez——53654747173542 Hillcrest Rd Apt 18, Los Angeles, CA0.54Date of birth unreadablePhone reformattedUnit split from streetZIP missing+1 more
CLM-430218CLMNoah Bryant1967-03-10UHC-41330-6239382303955903 Palm Dr # 428, Atlanta, GA, 303430.54Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+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
TPA-59060TPAElijah Cruz1962-02-05UHC-01148-98—8081 Central Ave Apt 10, Columbus, OH, 432400.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-55978TPARamirez Heather1985-09-07——3843 Main St Apt 18, Plano, TX, 750500.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+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
PRV-29000PRVBrandon J Edwards1948-04-23UHC-65049-62—3531 Church St, Sacramento, CA, 958500.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-412578CLMJoe Ford1978-09-19UHC-43516-61—1902 Highland Ave Apt 17, Chandler, AZ, 852010.54SSN last four extractedUnit split from streetStreet 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
TPA-61024TPAJulia Wright1994-05-15——5217 Main St, Dallas, TX, 752410.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+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
TPA-61915TPAJordan Herrera1994-01-02——8958 Indian School Rd, Phoenix, AZ, 850530.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+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
TPA-51711TPABrayn Saners1968-09-27—47577421854575 Broadway # 865, Los Angeles, CA, 900130.54Name re-casedUnit split from streetState name converted to codeGender normalised+1 more
CLM-420632CLMBeverly Y Pierce1977-11-04——1374 Central Ave, Austin, TX0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+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
CLM-432042CLMVirginia Carlson1993-03-18UHC-04926-88—4591 Valley View Dr Apt 18, Dallas, TX, 752410.54Unit split from streetState name converted to codeZIP+4 trimmedWhitespace trimmed+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
CLM-404022CLMGeorge Hoffman1962-10-01UHC-52151-87—1238 Palm Dr Apt 10, Houston, TX, 770120.54Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-28225PRVCarl Russell—UHC-40882-6898837286633970 Palm Dr, Dallas, TX, 752040.54Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-24071PRVChristine O Bryant1964-01-02UHC-13671-7831391130308446 Union St, Jacksonville, FL, 322340.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-50991TPALauren O Stephens1994-01-02UHC-21092-63—8542 Valley View Dr, Tempe, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-60845TPAAshley Perry1968-03-26UHC-37171-052574365078697 Park Pl, Fresno, CA0.54Name split from “Last, First”Phone reformattedState 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
CLM-407722CLMRay Banks2004-07-09UHC-53680-51—2102 Central Ave, Denver, CO, 802360.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-412318CLMJohn Burke1977-07-17——126 Main St, Tempe, AZ0.54Two-digit birth yearState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-412317CLMJohn Burke1977-07-17——126 Main St, Tempe, AZ0.54Two-digit birth yearState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-412016CLMStephanieJunk1941-07-06UHC-12127-52—478 Oak St, Mesa, AZ, 852590.54Name re-casedPhone missing area codeZIP+4 trimmedPlaceholder values cleared+1 more
TPA-53794TPAMateo Ortega1956-01-09UHC-99277-69—7123 Lincoln Way, Houston, TX, 770270.54Name split from “Last, First”Two-digit birth yearZIP+4 trimmedWhitespace 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
ENR-141521ENRGabriel I Rios1960-07-09UHC-91956-1048863471984839 Ocean Ave, San Antonio, TX, 782640.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-130407ENRJuan E Mills1949-05-25UHC-33516-5248431963843084 Desert Sky Blvd, Gilbert, AZ, 852470.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-50988TPAAnn Perez1999-12-05——352 Elm St, Denver, CO, 802290.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
PRV-26847PRVKaren Campbell——97064130404437 River Rd, Columbus, OH, 432640.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
ENR-105880ENRKelly G Baker—UHC-48249-9227868597564218 Sunset Blvd, San Diego, CA, 921800.54Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+1 more
CLM-430428CLMSophia Welch1938-07-16UHC-08969-87—9297 Church St, San Diego, CA, 921710.54State name converted to codeZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
100,000 rows, page 202 of 2,000PreviousNext