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-115487ENRJcaqueline Flores2001-09-24UHC-36088-6257987560061019 Grand Ave, Plano, TX, 750050.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132763ENRTeresa Vega—UHC-01593-3665268896316622 Spring St, Gilbert, AZ, 852520.38Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-128338ENRGloria Bowman—UHC-41813-2177446692489766 Grand Ave Apt 37, Los Angeles, CA0.38Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-112786ENRGary U Campbell1962-12-06UHC-31793-9522869585261342 Hillcrest Rd, Gilbert, AZ, 852060.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412520CLMJack E Fowler1955-03-01UHC-96462-49—4237 Central Ave, Scottsdale, AZ0.38Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-412540CLMSean Freeman1966-03-08UHC-70386-67—6878 Ocean Ave, Houston, TX0.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-52545TPAMateo Ryan1944-05-21——5949 Meadow Ln, Dallas, TX, 752010.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-138892ENRJenny Shaw1998-12-17UHC-18418-4977536294603731 Lincoln Way Apt 3, Las Vegas, NV, 891250.38Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+3 more
ENR-115279ENRNoah K Burton1952-04-05UHC-87151-3332382789367202 Apache Blvd, San Diego, CA, 921290.38Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+3 more
ENR-101540ENRDaniel Hernandez1991-03-02UHC-23992-5367738403376493 Pine Dr, Charlotte, NC0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101541ENRDaniel Hernandez1991-03-02UHC-23992-5367738403376493 Pine Dr, Charlotte, NC0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141542ENRSofia HJunk—UHC-21371-1747063460896149 Cedar Ln, Eden Prairie, MN, 553650.38Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116137ENRDebra F Murphy1955-02-25UHC-04747-3820536408956611 Elm St # 552, Gilbert, AZ, 852190.38Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+3 more
ENR-102466ENRDoris Crawford1999-04-22UHC-42956-4129924280887748 Union St, Las Vegas, NV, 891560.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-415716CLMCharlotte Lopez1943-04-20UHC-02280-0265345224221647 Spring St, Tempe, AZ, 852360.38Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25923PRVBryna F Jenkins1960-03-11——9780 Union St, Nashville, TN, 372420.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-102033ENRPriya Kelly1959-05-22UHC-02663-9238862711586859 Grand Ave # 370, Tucson, AZ0.38Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-432345CLMMichael Weber1950-11-17UHC-80019-73—3529 Washington St, Columbus, OH0.38Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-425179CLMAmyJunk1968-11-16UHC-55275-97—9165 Maple Ave, Chandler, AZ, 852670.38Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-428911CLMBilly Q Lewis1942-04-19UHC-32201-16—1864 Main St, Eden Prairie, MN, 553690.38Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+3 more
CLM-425630CLMNathan Reynolds1964-03-05UHC-87757-3369061417435436 Park Pl, Sacramento, CA, 958270.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110497ENREmily H Peters1998-01-04UHC-16579-34—8187 Market St, Tucson, AZ0.38Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-135886ENRLauren Nguyen1959-09-25UHC-00209-7690447672277758 Desert Sky Blvd Apt 21, Orlando, FL, 328070.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-116104ENRNoah Y Welch1978-12-12UHC-89604-2888936051244394 Pine Dr, Denver, CO, 802450.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-137153ENRMegan C Burton1992-02-06UHC-16715-974964991389247 Sunset Blvd Apt 31, Dallas, TX, 752660.38Name split from “Last, First”Middle initial moved out of first namePhone reformattedUnit split from street+3 more
CLM-411028CLMCarollyn Chen—UHC-46103-72—2822 Sunset Blvd # 837, Glendale, AZ, 853140.38Name split from “Last, First”Date of birth unreadableUnit split from streetStreet suffix standardised+3 more
ENR-126461ENRJanet Harris1998-10-06UHC-03351-82—1529 Highland Ave Apt 31, Tempe, AZ, 852480.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-134672ENRRaymond Richarsd1989-11-09UHC-49021-65—4499 Hillcrest Rd, Columbus, OH0.38Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
TPA-59194TPAJanice Sandoval—UHC-66768-58—8538 Highland Ave # 767, Orlando, FL, 328520.38Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-101178ENRChristian Montgomery1995-06-04UHC-75946-9061799194547147 Union St Apt 2, Los Angeles, CA0.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-110159ENRVincent W Maldonado1997-04-01UHC-63268-0190673947478069 Spring St, Nashville, TN, 372050.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-105580ENRJoan Robertson—UHC-80182-89—8274 Jefferson Ave, Los Angeles, CA, 900230.38Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+3 more
TPA-61497TPADorothy Fisher1990-08-05——9204 Apache Blvd # 379, Los Angeles, CA0.38Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-52519TPAAbigali Welch1998-11-24UHC-47178-19—1621 Union St, Nashville, TN, 372070.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-53198TPAScott Simmons1976-01-09—87689321582254 Lake View Rd, Mesa, AZ, 852260.38Two-digit birth yearPhone reformattedSSN last four extractedZIP+4 trimmed+3 more
ENR-126200ENRHiroshiJunk1950-07-07UHC-42235-4134436453514534 Church St, Gilbert, AZ, 852280.38Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-126941ENRMichael O Cox1998-01-16UHC-12578-9441271358961486 Apache Blvd # 413, Seattle, WA0.38Name split from “Last, First”Middle initial moved out of first namePhone reformattedUnit split from street+3 more
ENR-104177ENRRobert V Ellis1985-03-20UHC-85875-4426861350991165 Canyon Rd, Columbus, OH, 432970.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428730CLMJoan Weber1956-02-06—83959746121837 Sunset Blvd # 641, Atlanta, GA0.38Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
CLM-422003CLMEllijah Payne2001-07-03UHC-20841-6292971230037940 Hillcrest Rd, Gilbert, AZ, 852730.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-64031TPALinda Munoz——22780879605984 Harbor Blvd Apt 19, Columbus, OH, 432610.38Name split from “Last, First”Date of birth unreadableUnit split from streetStreet suffix standardised+3 more
ENR-119843ENRLori Cole—UHC-55402-6265527562056098 Harbor Blvd, Seattle, WA, 981450.38Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-26108PRVCarl J Ross1984-10-05—25479420749633 Pine Dr, Los Angeles, CA0.38Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26593PRVDeborah Robinson1946-06-14UHC-84327-1438470630639488 Jefferson Ave, Columbus, OH0.38Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
CLM-432465CLMMichael Stewart—UHC-09021-3829634234906202 Washington St Apt 34, San Diego, CA, 921630.38Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+3 more
CLM-432464CLMMichael Stewart—UHC-09021-3829634234906202 Washington St Apt 34, San Diego, CA, 921630.38Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+3 more
ENR-102812ENRGloria R Washington1983-01-25—96398948969741 Palm Dr, Seattle, WA, 981780.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
PRV-25423PRVJon Hughes—UHC-60893-0247594155751879 Union St, Fresno, CA, 937790.38Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-63649TPAGabriel K Ross1980-11-08UHC-60294-05—2470 Hillcrest Rd, Jacksonville, FL, 322960.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-410929CLMAlice Armstrong—UHC-01835-54—7640 Forest Ave Apt 18, Columbus, OH, 432610.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 29 of 2,000PreviousNext