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-55607TPALuis Nelson2007-06-21——5017 Sunset Blvd, Seattle, WA, 981150.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61017TPAElizabeth B Vazquez1968-07-27—5579960303222 Mountain View Dr Apt 6, Eden Prairie, MN, 553440.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-52142TPAGerald Cox1971-10-05——5111 Canyon Rd, Plano, TX, 750440.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60601TPALawrence Hayes2003-11-18UHC-66712-2650744398641346 Mesa Dr, San Diego, CA, 921710.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50101TPAMaria Jenkins1977-04-06UHC-71956-2192520292969603 Elm St, Chandler, AZ0.62Date of birth reformattedPhone reformattedCity re-casedZIP missing+3 more
TPA-50100TPAMaria Jenkins1977-04-06UHC-71956-2192520292969603 Elm St, Chandler, AZ0.62Date of birth reformattedPhone reformattedCity re-casedZIP missing+3 more
TPA-60768TPADoris Burke1962-04-27——3850 Bayshore Dr, Dallas, TX, 752700.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52480TPAJeremy O Henry2005-08-01—63098220375034 Main St, Charlotte, NC, 282220.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-55729TPAGeorge McCoy1994-09-25——8944 Cedar Ln, Orlando, FL, 328960.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59887TPABrittany Wong1978-04-20—47439217611666 Mountain View Dr # 529, Los Angeles, CA, 900960.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50190TPAJoe V Ferguson1963-11-02—21835208764324 Jefferson Ave, Charlotte, NC, 282250.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60227TPAStephen Gonzales1986-05-06——789 Highland Ave, Tucson, AZ, 857800.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61650TPAHannah Nguyan1939-07-28—94583143528600 Lincoln Way, Los Angeles, CA, 900710.62Name re-casedTwo-digit birth yearPhone reformattedEmail lower-cased+3 more
TPA-64042TPARuth Hudson1966-02-12——6660 Market St, Eden Prairie, MN, 553840.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61356TPAAlbert Freeman1967-11-21—5953976960587 Willow Ct, Nashville, TN0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59353TPABrian B Cook1997-03-07—79733942493174 Market St, Columbus, OH, 432240.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55413TPASamuel Hoffman——36362439724480 Sunset Blvd, San Antonio, TX, 782790.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-64422TPAMary McCoy2002-02-19——52 Harbor Blvd, Phoenix, AZ, 850790.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-55019TPAMason Gardner1957-02-01—51328163261165 Oak St, Tucson, AZ, 857860.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-59854TPAWayne Thomas1954-02-10——4016 Jefferson Ave, Seattle, WA, 981680.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60383TPAChristine Hoffman2003-05-09—45568192525855 Spring St, Phoenix, AZ, 850220.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-59260TPABrandon Gilbert1940-03-10UHC-47987-5363938873585070 Highland Ave, Phoenix, AZ, 850930.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57737TPASean Luna1971-05-16——3548 Baseline Rd, Chandler, AZ, 852110.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-54079TPABrandon Mejia1994-12-12——3682 Cedar Ln, Minneapolis, MN, 554630.62Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-55331TPAMichael Mills1943-11-05—63693585095025 Highland Ave, Las Vegas, NV0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59513TPALori Gonalez1956-11-03——2271 Ridge Rd, Nashville, TN, 372900.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57934TPAAnn Sims1973-12-20—93678299333815 Palm Dr, Phoenix, AZ, 850500.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62318TPALaura Arnnold1982-09-24—38940335256320 Main St, Scottsdale, AZ, 852830.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51832TPAJanice C Clark1988-06-25——2719 River Rd, Orlando, FL, 328170.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53771TPAVincent Pena1945-02-06—36834305413385 Hillcrest Rd, Minneapolis, MN, 554800.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58358TPAKyle O Bryant1976-09-16UHC-45658-5558243599883140 Ocean Ave, Nashville, TN, 372810.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62099TPADonna Reynolds1941-10-22——6169 Elm St # 505, Chandler, AZ, 852510.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-64222TPADylan Castillo1996-10-13——3459 Baseline Rd, Scottsdale, AZ, 852730.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58527TPAMadison Knight1984-02-05——8677 Baseline Rd Apt 37, Atlanta, GA, 303190.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50377TPASteve Armstroong1947-09-03—83085149472077 Grand Ave, Plano, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58551TPASantiago Hamilton2007-02-12——6075 Canyon Rd, Phoenix, AZ, 850800.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-52430TPAPriya Crawford1980-08-21—65575121722381 Indian School Rd, Tucson, AZ, 857350.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61514TPASamuel Alen1998-01-15——5766 Harbor Blvd, Dallas, TX0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57089TPAArjun Torres1986-04-21—79782688164920 Cedar Ln, Orlando, FL, 328050.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-62511TPAGary Q Schultz1974-05-01—74393901642035 Jefferson Ave, Tucson, AZ, 857470.62Name re-casedPhone reformattedCity re-casedState name converted to code+3 more
TPA-56282TPARachel Kelley1977-08-18——7186 Oak St, Orlando, FL, 328830.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57448TPAJerry Hughes1983-05-26——1707 Hillcrest Rd, Seattle, WA, 981470.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50488TPAEugene Dean1963-10-24——1762 Oak St, Scottsdale, AZ, 852110.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60650TPAJohn Weber1948-05-24—66565979994227 Washington St, Houston, TX, 770260.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60895TPAKaren Montgomery1963-09-14—23185505988807 Highland Ave, Columbus, OH, 432780.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55842TPASamuel A Rivera1988-07-26—37864411734182 Valley View Dr, Jacksonville, FL, 322710.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58184TPAJean Wang1965-07-21—79582278712348 Elm St, Glendale, AZ, 853680.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64155TPACox I Edward——91364897083714 Meadow Ln, Tucson, AZ, 857120.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-53866TPAJack C Pierce1958-12-15——4710 Jefferson Ave, Miami, FL, 331230.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53907TPABetty Lewis1993-08-28——3459 River Rd, San Antonio, TX0.62Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
14,474 rows, page 38 of 290PreviousNext