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
CLM-403304CLMDavid Garcia2008-01-09UHC-62582-3426356536856698 Mesa Dr, San Diego, CA, 921470.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-112270ENRRandy J Lewis2008-07-27UHC-17476-8770052686084551 Oak St, Atlanta, GA0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-124400ENRWalter Hoffman1965-04-17UHC-83616-6737633379551445 Meadow Ln, Tempe, AZ, 852320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112021ENRAna Jackson1950-11-11UHC-49207-2653486131249519 Indian School Rd, Tucson, AZ, 857680.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-106271ENRLucia Jenkins1993-12-04UHC-65576-3665046858951182 Main St, Glendale, AZ, 853170.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-419163CLMSofia Weber1987-11-14UHC-90595-76—9275 Union St, Sacramento, CA0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52173TPADebra Moore1957-05-26——3078 Jefferson Ave, Plano, TX0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
CLM-407930CLMDiego Bryant1939-09-25—83081954671522 Willow Ct, Eden Prairie, MN, 553340.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-58726TPASean Vargas1948-02-26—52240600652813 Church St Apt 2, Phoenix, AZ, 850820.50Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-416043CLMChristian Edwards1977-03-19UHC-82513-3544585771075119 Maple Ave, Plano, TX, 750900.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-124161ENRDoris I Chavez1966-09-12UHC-21944-4466863057346224 Grand Ave, Phoenix, AZ, 850140.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62388TPAJimmy Reed1945-03-19——4459 Washington St Apt 22, Tempe, AZ, 852200.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-432242CLMPriya S Williams1972-03-23UHC-70691-50—6515 Willow Ct, Charlotte, NC, 282470.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-25027PRVJacob J Smith1974-05-08—20592426254760 Canyon Rd, Atlanta, GA, 303610.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21603PRVWayne Gutierrez1982-11-13—42871316167979 Park Pl, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126994ENRMichelle D Murphy1951-01-17UHC-22881-1941387678392070 Valley View Dr, Scottsdale, AZ, 852090.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404597CLMGary Hansen1975-05-10——4171 Bayshore Dr, Minneapolis, MN, 554230.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135369ENRSophia Rojas1998-05-10UHC-55388-5237225181347059 Mesa Dr, Tempe, AZ, 852390.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-54207TPAVincent O Willis1996-09-12——7913 Sunset Blvd # 945, Las Vegas, NV, 891100.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402230CLMDaniel Obrien1993-07-25——3776 Main St # 342, Denver, CO, 802420.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
ENR-126861ENRDavid B Rogers1950-12-15UHC-03997-6969374973995317 Washington St Apt 22, Mesa, AZ, 852180.50Name re-casedDate of birth reformattedUnit split from streetCity re-cased+3 more
ENR-132083ENRWilliam Allen2006-07-18—80331176139630 Mountain View Dr, Miami, FL, 331630.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421703CLMPaul Bryant1975-01-19——7916 Meadow Ln, Denver, CO0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-123963ENRIsabella M Harper1952-12-28UHC-58378-71—6566 Cedar Ln Apt 35, Las Vegas, NV, 891330.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-105258ENRJack P Munoz1991-10-14UHC-15695-1532122634006160 Forest Ave, Minneapolis, MN, 554960.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
ENR-136078ENRKimberly Gordon2006-12-28UHC-89560-95784584526088 Willow Ct Apt 12, Eden Prairie, MN, 553600.50Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more
TPA-59308TPAGabriel Castro1994-09-24——6936 Spring St, Atlanta, GA, 303220.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-126462ENRIsabella Barnes2006-03-11UHC-66242-9340867155311853 Oak St, Mesa, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-403334CLMJanice B Harper1981-07-04—93029244789455 Canyon Rd, Gilbert, AZ, 852870.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-22239PRVIsabella Mitchell1982-12-01UHC-75813-49—1147 Canyon Rd, Chandler, AZ, 852000.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-57099TPAGerald Yang1963-07-07—2459276170533 Baseline Rd, Columbus, OH, 432610.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-55566TPAGeorge P Vasquez2008-11-14——7870 River Rd Apt 36, Plano, TX, 750850.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-55567TPAGeorge P Vasquez2008-11-14——7870 River Rd Apt 36, Plano, TX, 750850.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-134514ENRBradley T Barnes1967-01-17UHC-82109-2093928181726202 Meadow Ln, Austin, TX0.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-130800ENRJerry Webb1992-10-06UHC-72023-8265633850716340 Apache Blvd, Charlotte, NC, 282590.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-413259CLMDennis P Brooks1956-10-04UHC-34952-1626997827654878 Camelback Rd Apt 28, Austin, TX, 787670.50Name split from “Last, First”Phone reformattedUnit split from streetState code upper-cased+3 more
ENR-128282ENRDiana K Webb1967-05-27UHC-08113-6479940658365776 Oak St, Scottsdale, AZ0.50Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-408911CLMMegan P Wheeler1971-03-12UHC-61260-0688587098158380 Sunset Blvd Apt 40, Houston, TX, 770600.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-123351ENRThomas Larson1946-11-19UHC-97162-2631145473698467 Mesa Dr Apt 11, Tempe, AZ, 852280.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-420854CLMDon Baker1982-01-10UHC-82382-1685041865249253 Apache Blvd, Seattle, WA, 981350.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138664ENRRyan Price1972-08-09UHC-22613-7885557825916961 Market St, Mesa, AZ, 852900.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-119804ENRRonald Evans1987-01-25UHC-63870-5421975877158732 Meadow Ln, Gilbert, AZ, 852960.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-104020ENRStephanie D Wells1982-03-03UHC-88362-409569168260961 Pine Dr, Sacramento, CA, 958950.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-407407CLMSusan Padilla1981-03-01UHC-73638-75—2782 Central Ave, Seattle, WA, 981820.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-50171TPARalph Ellioott1993-06-26——3733 Lake View Rd, Eden Prairie, MN, 553720.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28909PRVJerry Cole2005-03-11——8103 Main St, Tampa, FL, 336000.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-131118ENRMatthew X Siimpson1997-11-10UHC-82576-6075777508638156 Ridge Rd, Las Vegas, NV0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426927CLMFatima Oliver1962-01-25UHC-11964-3048750216303457 Harbor Blvd, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122204ENRMichelle Chavez1992-04-26UHC-36979-4076441803055832 Sunset Blvd, Scottsdale, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115242ENRAhmed I Patel—UHC-86063-1361239709187258 Apache Blvd, Austin, TX, 787660.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 114 of 2,000PreviousNext