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-50719TPALauren Parker1986-10-21—84951082214890 Ocean Ave, San Antonio, TX, 782430.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-54375TPAKeith Garcia1994-09-05—69574978932681 Bayshore Dr, Plano, TX, 750320.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56308TPAMegan Andrews1974-07-14—43771037179086 Palm Dr, Columbus, OH, 432740.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55408TPACharlotte Obrien1984-03-14—3556449036314 Washington St, San Diego, CA, 921680.62Name split from “Last, First”Name re-casedPhone reformattedStreet suffix standardised+3 more
TPA-51309TPAJose Howell1979-11-01UHC-12973-72—6267 Camelback Rd, Nashville, TN, 372650.62Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
TPA-53668TPACamila Lucas1959-11-09——1620 Jefferson Ave, Dallas, TX, 752320.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-62888TPASusan Hanson1982-10-01—27152302714755 Maple Ave, Minneapolis, MN, 554880.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58844TPASamuel Alvarez1939-10-18——7856 Highland Ave, Columbus, OH, 432820.62Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-59431TPAAna Valdez1946-07-18—42646732627974 Elm St, Columbus, OH0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57325TPADylan Carroll1991-03-20——4376 Central Ave, Phoenix, AZ, 850320.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50910TPAGrag P Knight1993-08-02——8500 Main St Apt 14, Austin, TX, 787400.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61761TPACharlotte Rogers1996-03-20—97235742027069 Cedar Ln, Houston, TX, 770380.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51779TPABeverly Fuller1940-08-02—26060911941857 Willow Ct, Minneapolis, MN0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50595TPACynthia Hensen1971-01-22——3524 Ridge Rd # 711, Jacksonville, FL, 322220.62Name re-casedDate of birth reformattedUnit split from streetCity re-cased+3 more
TPA-56651TPATeresa Harrison2007-01-27—97530497521781 Harbor Blvd, San Antonio, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54383TPAChristian X Bowman2007-09-01—55587675089778 Willow Ct # 486, Las Vegas, NV, 891710.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-62989TPAEric Harper2002-10-26——8687 Ocean Ave Apt 20, San Diego, CA, 921450.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-62299TPAHenry Nguyen2002-03-18—48431095925080 Canyon Rd, Columbus, OH, 432730.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50238TPAMaria Chavez1999-10-15——3624 Union St, Las Vegas, NV, 891050.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57936TPAJacqueline Sanders1951-07-10—2998888429737 Grand Ave, Glendale, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62340TPAJack J Taylor1971-03-07UHC-47608-4952946338743243 Main St, Tampa, FL0.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-61988TPANathan Lawrence1955-07-04—59329626496668 Park Pl, Eden Prairie, MN, 553930.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57113TPAAmanda Washington2000-07-01——2909 Spring St, Charlotte, NC, 282570.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61378TPADoris Kelly1957-03-07—39527269809827 Highland Ave, Seattle, WA, 981620.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62127TPACarr Michelle1968-12-25—32772988003407 Mountain View Dr, Glendale, AZ, 853660.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59324TPAOmar Coleman1979-12-02—25292045774576 Camelback Rd Apt 27, Sacramento, CA, 958160.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-60361TPAMary J Watkins1994-02-25—58533889266724 Baseline Rd, Jacksonville, FL, 322880.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52256TPAElijah Flors1966-09-10——2946 Washington St # 632, Sacramento, CA, 958690.64Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-54741TPAAshley Gibson2005-08-12—77036972228818 Maple Ave, Phoenix, AZ, 850450.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59150TPAGary Stewart2004-07-21UHC-03014-1069191543934203 Apache Blvd, Plano, TX0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62014TPAPat Howell1979-04-14——7085 Pine Dr, Houston, TX, 770990.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-52714TPAJudith Dunn1969-02-18—42571989313345 Meadow Ln, Atlanta, GA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-52715TPAJudith Dunn1969-02-18—42571989313345 Meadow Ln, Atlanta, GA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-57685TPARalph Yang1950-10-02—87389649274177 Sunset Blvd, Tucson, AZ, 857700.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-55824TPADavid P Lynch1959-02-27—90299032526485 Harbor Blvd, Dallas, TX, 752920.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58555TPAJulia Le1972-12-15—27894042059364 Market St # 125, Tucson, AZ, 857500.64Name re-casedPhone reformattedUnit split from streetEmail lower-cased+2 more
TPA-52988TPAJacob Kyng1970-03-14—52367965887963 Lake View Rd, Tempe, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54969TPAPatrick Jones2003-05-09——3171 Cedar Ln, Plano, TX, 750210.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-59749TPANatalie Thomas1946-03-08——9790 Hillcrest Rd, Tampa, FL0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-58424TPANicole Peterson1940-03-25——4591 Jefferson Ave, Phoenix, AZ, 850950.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
TPA-50649TPAAndrea Castillo1957-07-14UHC-62841-3337146438112250 Desert Sky Blvd, Mesa, AZ, 852590.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-62224TPAZachary Fuller1969-07-13—39198919063951 Market St, Eden Prairie, MN, 553230.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59773TPAAlbert Sanders1976-05-06——5471 Camelback Rd, Las Vegas, NV, 891610.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54940TPAKayla Wheeler1950-02-20—96270338024541 Meadow Ln, Minneapolis, MN0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-52760TPAJessica Mendez1958-11-24——1455 Meadow Ln, Phoenix, AZ, 850160.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-62192TPAWilliam Cook———221 Baseline Rd, Seattle, WA, 981350.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-56573TPAOmar J Obrien———8082 Highland Ave, Tucson, AZ, 857600.64Name re-casedDate of birth reformattedDate of birth unreadableState name converted to code+2 more
TPA-51258TPAJames Reid2008-10-13UHC-04022-72—5685 Sage Ct # 446, Scottsdale, AZ, 852690.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58027TPAAhmed I Adams———3121 Union St, Las Vegas, NV, 891390.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-58026TPAAhmed I Adams———3121 Union St, Las Vegas, NV, 891390.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 47 of 290PreviousNext