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-53637TPAElizabeth Ramirez2002-01-11—40778752312787 Indian School Rd, Austin, TX, 787410.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-50481TPABeth G West1964-07-01——9763 Apache Blvd # 735, San Antonio, TX, 782940.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
TPA-55254TPAAustin Bryant2006-12-17—29463166296850 Spring St, Orlando, FL, 328990.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-61243TPAKelly Stephens1994-10-12—70272172835799 Main St, Fresno, CA, 937330.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-62743TPADaniel Marshall——86641216916761 Hillcrest Rd, Nashville, TN, 372860.46Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more
TPA-59883TPADanielle Martinez2004-07-22——8733 Desert Sky Blvd, Orlando, FL, 328150.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-51196TPATimothy Vargas1956-09-02——3151 Palm Dr, Glendale, AZ0.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-60197TPASean Webb2001-10-08—81021798803689 Willow Ct, Tucson, AZ, 857680.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
TPA-58786TPAKimberly Morrison1991-05-06UHC-31666-5291122920316635 Palm Dr, Gilbert, AZ, 852390.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-61296TPATimothy Lawrence1973-06-15UHC-34368-5133442868085015 Park Pl, Tempe, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-59180TPAElizabeth Schultz1967-12-24—90666732979384 Pine Dr, Fresno, CA, 937580.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
TPA-51925TPAGloria V Ortega2007-02-20—62566424504707 Highland Ave, Tempe, AZ, 852520.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-55353TPABrittany Fowler1995-11-07—29826975163562 Apache Blvd, Austin, TX, 787420.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-58311TPAJake Mdina1968-08-23—69546156168514 Park Pl, Tempe, AZ, 852430.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-50222TPAIsabella Harrison1987-09-12—93334127194153 Ridge Rd, Sacramento, CA, 958830.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-57313TPAButler Dylan1971-06-18—24563841485807 Church St, Houston, TX, 770950.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-64299TPAMichelle Z Alvarez2007-03-11—98827350279370 Hillcrest Rd, Tempe, AZ, 852350.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-61959TPAKim Hernandez1945-12-13UHC-62431-46—4884 Pine Dr # 316, Phoenix, AZ, 850230.46Name split from “Last, First”Date of birth reformattedMember ID reformattedUnit split from street+5 more
TPA-60760TPABruce Smith1994-02-20—9353156705959 Baseline Rd, Eden Prairie, MN0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-57905TPABradley Herrera2006-02-10—79258013843645 Mountain View Dr, Scottsdale, AZ, 852860.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-63769TPATimothy Bishop1978-10-26UHC-78355-4976250345552293 Washington St, Jacksonville, FL, 322520.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
TPA-58560TPAJefrfey Wells——50474082726803 Apache Blvd, San Antonio, TX, 782720.46Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more
TPA-54228TPAWei Berry1942-06-01——8201 Bayshore Dr Apt 33, Houston, TX, 770220.46Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+5 more
TPA-60023TPABenjamin Brooks2008-12-09——9416 Desert Sky Blvd # 960, San Diego, CA0.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
TPA-63360TPARyan Hansen1974-02-25UHC-08451-934616908946871 Meadow Ln, San Antonio, TX, 782500.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-60335TPARlph Bailey1968-01-10——9827 Elm St, Houston, TX, 770970.46Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+5 more
TPA-63632TPABbby Wright1947-09-21UHC-08635-99—5786 Lake View Rd, Scottsdale, AZ, 852630.46Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+5 more
TPA-59132TPAMariana U Jackson1992-11-20UHC-36939-9649963105298346 Palm Dr, Austin, TX, 787380.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
TPA-56425TPAAmy Romero1953-04-25—73071981425444 Union St Apt 7, Phoenix, AZ, 850610.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
TPA-50609TPANick Perry1972-02-16UHC-33463-1930354906213968 Sunset Blvd Apt 30, San Antonio, TX, 782210.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
TPA-51639TPASrah Snyder1944-01-02—29385832488118 Canyon Rd, San Diego, CA0.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
TPA-53709TPACarol Myers1977-12-17UHC-11827-9649988957086335 Church St, Seattle, WA, 981260.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
TPA-55992TPAElijah Y Castillo1939-10-27—78073033242196 Elm St, Chandler, AZ0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-61274TPACheryl Perez1990-04-03——260 Lake View Rd, San Diego, CA, 921010.46Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-63158TPAHennry Dominguez2000-08-01—55167892879538 Mesa Dr, Tampa, FL, 336620.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-55889TPACharles Bradley1988-08-19—47430252781556 Willow Ct, Denver, CO0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-53134TPANicholas Gibson1948-06-11—82197692506030 Camelback Rd, Minneapolis, MN, 554890.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
TPA-53098TPAKelly Reed1981-06-21——640 Washington St, Phoenix, AZ0.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53343TPAPatrick X James——88371767746916 Hillcrest Rd, Miami, FL0.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
TPA-60680TPARebecca Myers1985-12-02—52394438162515 Palm Dr, Tucson, AZ, 857670.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57060TPACamila W Walsh1960-01-13—77168857682775 Harbor Blvd, Tempe, AZ, 852150.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-55854TPACarolyn Patterson1975-02-10UHC-74389-7368193742092439 Valley View Dr, Los Angeles, CA0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-62445TPASantiago Adams1981-12-07——9625 Camelback Rd, Jacksonville, FL, 322740.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55021TPAYuki O Hill1993-11-25—86992086078400 Mountain View Dr, Atlanta, GA, 303890.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-51341TPAArthur H Rice2001-04-24UHC-69841-7335690546014593 Highland Ave, Nashville, TN0.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51088TPABryan Carpenter1953-01-10——3793 Harbor Blvd, Los Angeles, CA, 900750.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53187TPARichard Santtos1947-06-15—69049554307248 Main St Apt 20, Mesa, AZ, 852170.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-54645TPAMarcus Pierce1944-05-08——7945 Park Pl, Los Angeles, CA, 900960.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-57735TPAJuan Herrera1995-05-05—30192024148271 Apache Blvd, Mesa, AZ, 852190.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-56463TPAJecob Watkins1948-01-23——1221 Church St, Fresno, CA, 937190.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
14,474 rows, page 6 of 290PreviousNext