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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-52483TPAJoyce Lewis1998-12-24——908 River Rd, Tempe, AZ, 852660.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-56134TPAMadison Henderson1973-06-23——7189 Lake View Rd Apt 17, Plano, TX, 750150.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-55702TPAKathleen Morgan1960-02-04—48732096522706 Elm St, Denver, CO, 802840.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-53681TPAArjun Chavez1958-07-21—77527778633309 Elm St # 945, Charlotte, NC, 282760.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51422TPAOmar W Rios———5383 Union St Apt 40, Plano, TX, 750430.48Name re-casedDate of birth reformattedDate of birth unreadableUnit split from street+4 more
TPA-51709TPABobby Cooper1998-12-01—4882831996379 Church St, Chandler, AZ, 852780.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54945TPALaura Coleman1977-10-16—72774261528086 Washington St # 220, Houston, TX, 770270.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-55599TPAMei Jackson2005-12-15UHC-50141-31—2468 Willow Ct, Gilbert, AZ, 852880.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
TPA-58292TPAEthan Weaver1967-06-05——8731 Washington St, Mesa, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59067TPAJulie Kelly1984-06-24——2150 Park Pl, Glendale, AZ, 853130.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-60537TPAGerald Foster1993-02-26—53492083258689 Jefferson Ave, Tucson, AZ, 857620.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-61063TPABeverly Allen1963-01-04UHC-37163-0777052328432944 Willow Ct, Jacksonville, FL, 322470.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57950TPAMitchellJunk1971-03-02——9358 Jefferson Ave Apt 37, Denver, CO, 802040.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-58325TPAMdaison Vazquez1994-10-09——9099 Mesa Dr, Minneapolis, MN, 554800.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61262TPAJeffrey V Soto2006-08-10—31340556724743 Desert Sky Blvd, Fresno, CA, 937340.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59983TPARoger Ortega1939-04-19UHC-44775-27—9312 Market St # 328, Jacksonville, FL, 322100.48Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-63623TPALinda Duncan1962-10-21——838 Grand Ave # 845, Las Vegas, NV, 891260.48Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-52333TPASophia Schultz1979-05-28—23387509242062 Jefferson Ave, Phoenix, AZ, 850190.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
TPA-61208TPAJeremy C Cruz1964-04-15—54044800269297 Mountain View Dr, Tempe, AZ, 852990.48Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+4 more
TPA-57494TPARoy Edwards1944-11-25—53333211539892 Apache Blvd, Atlanta, GA, 303080.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
TPA-54610TPAKayla Bailey1981-10-10—64197401175758 Pine Dr Apt 24, Columbus, OH, 432560.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-63047TPACheryl Lnua1999-12-26—94385159395148 Harbor Blvd, Atlanta, GA0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54561TPAAnna Dunn1979-05-15—25747823741087 Hillcrest Rd, Miami, FL, 331550.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-64284TPAJose Banks1997-11-05——5571 Main St, Dallas, TX, 752750.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61933TPAEugene Henderson1959-02-22—22150165063030 Ocean Ave Apt 21, Scottsdale, AZ, 852960.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-50075TPARichard Kelley1961-01-10UHC-55573-1875436172071539 Spring St, Atlanta, GA0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56994TPADiane A Hunter1963-01-01—89837748268372 Lake View Rd, Plano, TX, 750120.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-59621TPAStephanie Campblel1952-03-26—66537421246703 River Rd Apt 29, Denver, CO0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-64268TPAMatthews Rachel1985-04-21—73637749368619 Lincoln Way, Los Angeles, CA, 900840.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53990TPACheryl Stepehns2008-06-25——8534 Valley View Dr Apt 5, Austin, TX0.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-58973TPAJessica Miller1952-02-08——8223 Jefferson Ave, Jacksonville, FL, 322520.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56512TPAPamela K Butler1995-11-10——8619 Spring St, Miami, FL0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-56650TPADaniiel K Reid1939-01-23UHC-18514-1247752400458395 Camelback Rd, Columbus, OH, 432090.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-52773TPALogan Lucas1985-09-26—92952239983084 Desert Sky Blvd, Mesa, AZ, 852810.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61160TPAMichael Chapman1980-02-27UHC-12278-8321578738909642 Washington St, Eden Prairie, MN, 553240.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-51940TPALarry Martin2001-01-13——4620 Valley View Dr Apt 1, San Antonio, TX, 782560.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51408TPARichard Henry1978-06-16—84829597867513 Spring St, Atlanta, GA0.48Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
TPA-51621TPACharles Bryant1941-02-14—38365395955600 Baseline Rd, San Antonio, TX, 782370.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53415TPAKaren Y Dean———8850 Ocean Ave, Denver, CO, 802040.48Name re-casedDate of birth missingCity re-casedZIP+4 trimmed+4 more
TPA-62249TPAGary Z Burns1984-11-19—79631360375738 Meadow Ln, Mesa, AZ, 852530.48Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+4 more
TPA-63647TPAPriya Dunn1959-05-05——7821 Oak St Apt 20, Las Vegas, NV, 891480.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-52672TPAJanice Roberts1981-08-28—90057937771097 Mountain View Dr, Eden Prairie, MN0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59909TPAGloria Dean———7637 Bayshore Dr, Glendale, AZ, 853950.48Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+4 more
TPA-63048TPABetty Marshall1957-11-08UHC-98142-1894191990109766 Mesa Dr Apt 31, Gilbert, AZ, 852120.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-55181TPAKim Vazquez1959-02-18—90355279087007 Church St, Mesa, AZ, 852460.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51746TPAJsse Ryan1984-11-25—57475348021048 Mesa Dr, Glendale, AZ, 853030.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-58706TPAGeorge Delgado1984-05-02——2597 Bayshore Dr Apt 40, Seattle, WA, 981970.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-60030TPAJacqueline Willsi1998-05-09—63871195461671 Market St, Denver, CO0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-60176TPARyan Soto2002-11-11——8891 Union St # 361, Tempe, AZ, 852330.48Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-60078TPABarbara Collins——9139945612647 Market St, Minneapolis, MN, 554680.48Name split from “Last, First”Date of birth reformattedDate of birth unreadablePhone reformatted+4 more
14,474 rows, page 8 of 290PreviousNext