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-50295TPAThomas Arnold2006-02-21—20274085131279 Forest Ave # 301, Miami, FL, 331810.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-62290TPAGloria Palmer1944-06-01—82861563432787 Mountain View Dr Apt 4, Tampa, FL, 336660.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-54009TPAHannah Oliver1951-07-08—2558020399926 Oak St, Scottsdale, AZ, 852700.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-63955TPAMarilyn Dominnguez1991-04-14——6157 Camelback Rd # 441, Fresno, CA, 937450.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-59304TPAElijah Carlson1990-07-25——7199 Broadway Apt 31, Miami, FL, 331810.60Date of birth reformattedSSN last four extractedUnit split from streetAddress re-cased+4 more
TPA-51651TPABill Ward1984-05-17—74342201035716 Mountain View Dr, Houston, TX0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51941TPAObrien Joyce1985-07-24—20325066731865 Desert Sky Blvd Apt 15, Los Angeles, CA, 900170.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-51517TPADavid Parker1972-06-19UHC-27308-0359731744003490 Church St, Seattle, WA, 981260.60Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+4 more
TPA-60966TPAKenneth West1989-04-08—72132713148925 Pine Dr, Austin, TX, 787130.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61916TPAFrank Taylor1954-04-27—77849632305678 Desert Sky Blvd # 327, Jacksonville, FL, 322110.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-61806TPAAmy Aguilar1975-09-13UHC-37978-2037675897286164 Sage Ct, Columbus, OH, 432080.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-51068TPAEthan K Estrada———5007 Apache Blvd, Chandler, AZ, 852290.60Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+4 more
TPA-51158TPALuis Sandoval1986-02-12—77090476692264 Harbor Blvd, Charlotte, NC, 282760.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-50873TPADenise Johnston2008-03-09—62730809286538 Palm Dr, Gilbert, AZ, 852100.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-55168TPADenise Ros1975-07-10UHC-51808-4830564695109734 Apache Blvd, Columbus, OH, 432230.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-62114TPAScott Mitchell1975-02-20—77354925119701 Main St, Scottsdale, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-59392TPAMateo Mendoza1945-03-28——3021 Washington St, Columbus, OH0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54506TPALawrence Hicks1954-03-16—66089032941518 Canyon Rd, Eden Prairie, MN0.60Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
TPA-56534TPAJeremy Mejia1951-09-14—41687118967721 Camelback Rd Apt 34, Las Vegas, NV, 891870.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-58616TPABryan Bradley1954-07-16—41696931179053 Maple Ave, Tempe, AZ, 852880.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59892TPAHelen U Wylliams1978-04-25—38142719211803 Bayshore Dr, San Antonio, TX, 782080.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51897TPAPamela Contreras1990-04-02UHC-42414-79—8748 Elm St Apt 24, Las Vegas, NV, 891960.60Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
TPA-58921TPAJackson Susan1985-02-10—57489938951342 Mountain View Dr, Mesa, AZ, 852800.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-62710TPAPriya Phillips1984-06-03——1868 Hillcrest Rd, Miami, FL0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55151TPAEmma L Washington1949-12-01—75325534512206 Maple Ave Apt 15, San Antonio, TX, 782220.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-58549TPAPayne Amber1974-01-05UHC-74098-98—5347 Central Ave # 905, Glendale, AZ, 853990.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-63442TPAMatt Ellis1967-12-06—94837191824838 Jefferson Ave, Houston, TX0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59988TPARoger Bennett2000-03-02UHC-51537-0323126560606308 Spring St, Austin, TX, 787570.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61726TPAJanice Wong2006-04-19——7523 Highland Ave, Nashville, TN, 372230.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-54959TPAPatricia Kennedy1991-09-17—44730833526142 Harbor Blvd, Los Angeles, CA, 900150.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56654TPAFatima Ford1992-05-16—50521854784477 Maple Ave, San Diego, CA, 921340.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-56764TPAJanet Edwards1965-07-10—73782634783833 Market St, Scottsdale, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-53007TPAWalter Murray1964-02-14—35725962887714 Washington St, Tampa, FL, 336000.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56614TPAChristopher Fuller1947-05-27—91285203577758 River Rd, Eden Prairie, MN, 553950.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51690TPANathan Williams1976-09-07—55220589255340 Jefferson Ave, Tempe, AZ, 852030.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-57939TPACole Kevin1961-02-14UHC-88488-7841522272072813 Market St, Eden Prairie, MN, 553290.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54149TPAAngela Hawkins2003-04-13—86320206788940 Church St, Mesa, AZ, 852760.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-63490TPAAlexander Lawrence1974-03-07—60872865524292 Grand Ave, Jacksonville, FL, 322790.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50642TPARoger A Ortiz1945-02-12——7876 Forest Ave # 812, Orlando, FL, 328970.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-53324TPAJudith O Boyd——71780996719713 Desert Sky Blvd, Charlotte, NC, 282580.60Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
TPA-53773TPAAhmed Peters1946-01-14—73195676319559 Spring St # 849, Seattle, WA, 981720.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-50898TPADaniel Lawrence——87266984998162 Spring St, Plano, TX, 750040.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
TPA-59254TPAJessica Carter1977-08-02UHC-74848-2689541344792230 Hillcrest Rd, Phoenix, AZ, 850440.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-58062TPAJacob Vazquez1972-07-14—55986488462247 Park Pl Apt 30, Glendale, AZ, 853510.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51896TPARandy Castro1969-09-18—28954465288169 Oak St, Las Vegas, NV, 891610.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-57620TPANaoh U Price1969-11-08UHC-27165-5255525322204559 Market St, Plano, TX, 750260.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-53155TPAHenry Roberts1969-10-21—68560785237955 Sage Ct, Chandler, AZ0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53154TPAHenry Roberts1969-10-21—68560785237955 Sage Ct, Chandler, AZ0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61937TPAGebriel Cunningham1941-02-13——9113 Highland Ave, Tampa, FL, 336680.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54553TPASara Campbell1942-12-26—29496064195159 Desert Sky Blvd, Gilbert, AZ, 852610.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
14,474 rows, page 32 of 290PreviousNext