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-55589TPAJustin Wilson1974-03-27—95046258765123 Camelback Rd, Plano, TX, 750010.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-62097TPADonna Reynolds1941-10-22——6169 Elm St, Chandler, AZ0.48Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
TPA-59695TPAKimberly G Hoffman1949-03-15——3254 Jefferson Ave, San Diego, CA0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-59696TPAKimberly G Hoffman1949-03-15——3254 Jefferson Ave, San Diego, CA0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-52044TPAKathleen Obrien1988-02-05UHC-27159-7243663445119351 Elm St, Los Angeles, CA, 900750.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-62935TPAGeorge Hoewll1984-03-09—26189748289286 Baseline Rd, Mesa, AZ, 852070.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-64358TPADuris McDonald1977-06-19UHC-00910-815318250759566 Church St, Chandler, AZ, 852030.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57311TPAWayne Bailey2007-07-10——8816 Forest Ave, Phoenix, AZ, 850170.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-52425TPAMartha Harper1950-11-13—50352205177781 Market St, Minneapolis, MN0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55650TPARyan Grant1989-09-27——6174 Valley View Dr, Tucson, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56825TPAMelissa Espinoza1983-01-01—87572534364879 Jefferson Ave, Tucson, AZ, 857170.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63922TPAMelissa Dominguez1955-10-15—98553047381059 Indian School Rd Apt 36, Austin, TX, 787450.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-56511TPAOlivia Ruiz1961-01-18——9419 Apache Blvd # 974, Austin, TX0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-62317TPASteven Guerrero1959-03-02—65862294037513 Mountain View Dr, Denver, CO, 802810.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-62654TPAMartha Davis1983-01-03——1368 Harbor Blvd, San Antonio, TX, 782710.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-60922TPASamantha S Adams1997-01-12—61347124506922 Sage Ct, Fresno, CA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-52582TPAMadison Foster1955-03-28——8828 Spring St, Atlanta, GA, 303930.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59946TPAWilliam Miller1998-08-23—40629114842824 Grand Ave, Miami, FL, 331610.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57294TPAZachary Baker1988-07-16——6101 Desert Sky Blvd, Orlando, FL, 328140.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59335TPARandy Carlosn1948-01-28—31146005379624 Baseline Rd, Dallas, TX, 752070.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-52564TPAEugene Foster1959-03-24UHC-01745-6968568869846273 Central Ave, Sacramento, CA, 958330.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57015TPALori Gibson1960-08-15—81742595758161 Ridge Rd, Austin, TX, 787150.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51100TPAJanet Graham1965-01-05——7239 Lincoln Way, Phoenix, AZ, 850340.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
TPA-62457TPABruce Porter1986-12-02UHC-09068-8190464166252200 Bayshore Dr, Fresno, CA, 937510.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-52179TPACharles Lane1953-12-13—83272443932643 Washington St, Seattle, WA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63744TPASandra Richardson2008-03-12—91096377123793 Canyon Rd, Scottsdale, AZ, 852540.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-53153TPAPamela Lucas1963-10-05UHC-08267-93—6958 Highland Ave Apt 37, San Antonio, TX0.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
TPA-62433TPAJudith Espiinoza1987-06-10—6165697187403 Spring St Apt 22, Mesa, AZ, 852490.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51244TPAEugene Chavez1944-12-06—53338108953313 Ocean Ave, Minneapolis, MN, 554430.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55431TPAJuan Santiago1988-05-17—8593034625166 Union St, Plano, TX, 750370.48Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+4 more
TPA-61316TPAChristine Broooks1953-12-25—74323869893231 Cedar Ln, Seattle, WA, 981910.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-60479TPAAndrea Guzman1992-05-15——4778 Sage Ct # 158, Tucson, AZ0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-50940TPAKimberly Q Morris—UHC-70976-5750872993293790 River Rd, Tucson, AZ, 857920.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
TPA-50284TPASarah Howell1966-05-27—2373550725320 Main St, Austin, TX0.48Date of birth reformattedPhone reformattedCity re-casedState name converted to code+4 more
TPA-53582TPAKathryn Cook1991-07-01—30091479582631 Park Pl Apt 22, Plano, TX0.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-59961TPANoah Sanchez1989-10-24—63247989828247 Ridge Rd, Los Angeles, CA, 900560.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-50478TPAHiroshi Hernandez1961-11-21——1528 Central Ave, Chandler, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63458TPADiane Le1952-09-26——4863 River Rd, Gilbert, AZ, 852270.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-51987TPAJose McDonald1986-07-13——7713 Lincoln Way, Austin, TX, 787090.48Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+4 more
TPA-55871TPAPaul Patel1942-11-22—67172337078622 Bayshore Dr, Tucson, AZ0.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-55033TPAJennifer Le1970-11-26——5766 Park Pl, Orlando, FL0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-50134TPACharles Palmer1994-02-11—27831397456887 Valley View Dr, Columbus, OH, 432590.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56246TPAStephen Q Evans1941-07-16—5667832046539 Indian School Rd, Houston, TX, 770160.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
TPA-63621TPAEthan Gilbert1974-06-16—45939998775664 Washington St, Houston, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-60385TPAAaron Rojas1938-03-27——7749 Mesa Dr, Gilbert, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62413TPAWilliam Hughes1978-01-02—82245637919230 Canyon Rd, Minneapolis, MN0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-58816TPAJeeremy Robertts1994-12-02—53187153019863 Sage Ct # 320, Columbus, OH, 432600.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-54950TPAJerry Greene1968-01-26—34992935636098 Sunset Blvd, Tempe, AZ, 852020.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-62272TPAAustin Gibson1985-01-01——8410 Sage Ct, Seattle, WA, 981370.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
TPA-52083TPAHelen Cruz1988-11-02—2427366336756 Central Ave, Orlando, FL0.48Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
14,474 rows, page 7 of 290PreviousNext