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-54539TPALucia Q Owens1974-11-22——2627 Desert Sky Blvd, Scottsdale, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63576TPAHiroshi G Wright1959-12-12——2169 Main St Apt 32, Chandler, AZ, 852720.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-59475TPAVirginia Schmidt1967-09-09—89331983979250 Forest Ave, Seattle, WA, 981460.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64202TPAGabrriel Z Estrada1993-02-15UHC-77015-81—2383 Palm Dr, Eden Prairie, MN, 553120.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-60370TPAJoseph Reid1944-04-11——9792 Pine Dr, Minneapolis, MN, 554640.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62431TPAJack Bishop—UHC-95340-02—411 Washington St, San Antonio, TX, 782800.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-52538TPAElijah Sims1991-05-19—33546682492636 Highland Ave, Sacramento, CA, 958890.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-64372TPACharlotte Ross2004-10-21——3803 Willow Ct, Houston, TX, 770170.62Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-56105TPANicholas Bowman1965-06-26—97272304828128 Harbor Blvd, Nashville, TN0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50363TPAAngela Yang1970-01-18—98160192787662 Oak St, Austin, TX, 787020.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-58604TPAPhilip Ferguson——34826703248344 Park Pl, Houston, TX, 770360.62Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57436TPAMike Barnes1951-12-12—28837898988521 Desert Sky Blvd Apt 9, Jacksonville, FL, 322200.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-64208TPAValentina Diaz1942-03-10—83941472638551 Indian School Rd Apt 35, Mesa, AZ, 852380.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-58306TPABobby Berry1941-04-01UHC-07304-7138459841496469 Valley View Dr, Glendale, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61456TPAMariana Fernandez1951-12-05—38971270543623 Pine Dr Apt 30, Charlotte, NC, 282080.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-51153TPADeb Johnson1978-06-01—53395646222676 Grand Ave, Tampa, FL, 336810.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64166TPABrittany Garrett1970-01-05UHC-07264-3557036833883896 Hillcrest Rd, Los Angeles, CA, 900310.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58370TPALius Murphy1981-02-20UHC-01298-90—299 Sage Ct, Jacksonville, FL, 322780.62Date of birth reformattedPhone missing area codeMember ID reformattedState name converted to code+3 more
TPA-53739TPAEvelyn Valdez1959-09-19——607 Highland Ave Apt 38, San Antonio, TX, 782550.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-56731TPABradley Lopez2005-02-24——5000 Central Ave, Denver, CO, 802350.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62228TPAAisha Burns1974-10-07——4453 Forest Ave, Dallas, TX, 752440.62Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-55053TPAMartha Ellis1950-12-09——2887 Highland Ave, Charlotte, NC, 282920.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-63152TPAAshley Coleman1950-09-15—89386169224299 Washington St, Los Angeles, CA, 900570.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58870TPALoan Gardner1946-06-26—58987065656261 Washington St, San Antonio, TX, 782560.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-59027TPAMartha Salazar1982-06-10——1310 Forest Ave, Orlando, FL, 328590.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60011TPAAlan Ward1988-11-21—44652293107662 Mountain View Dr, Sacramento, CA0.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
TPA-50532TPASteven Lewis1941-11-08—96146925905518 Harbor Blvd, Fresno, CA0.62Name re-casedPhone reformattedCity re-casedZIP missing+3 more
TPA-58377TPAAmanda Campbell1968-08-28——5649 Camelback Rd, Mesa, AZ, 852950.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51935TPABenjamin Bowman1992-05-21——8468 Willow Ct, Columbus, OH, 432690.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61485TPAChristian Salazar2005-12-25——6140 Elm St, Columbus, OH, 432020.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54016TPAFrances Simpsno2006-12-03—34478944354657 Forest Ave Apt 35, Plano, TX, 750840.62Name re-casedPhone reformattedUnit split from streetState code upper-cased+3 more
TPA-55337TPABenjamin Shaw1993-05-24—63591949242003 Central Ave, Jacksonville, FL, 322160.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52893TPAWalter Matthews1978-05-04—26067549246009 Spring St, San Antonio, TX, 782150.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-52509TPAOlivia U Chavez1973-01-15——5964 Meadow Ln, Atlanta, GA0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54557TPAChristian Griffin2008-04-24——3553 Highland Ave Apt 33, Glendale, AZ, 853510.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61041TPAPatricia Martin1947-04-24——1060 Desert Sky Blvd, San Antonio, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64294TPAAlan Estrada1981-01-01——7463 Canyon Rd, Dallas, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53501TPADylen B Santiago1991-06-20—38444094528719 Pine Dr, Atlanta, GA, 303680.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59176TPADoris Bradley1946-08-01——158 Cedar Ln, Orlando, FL0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60787TPADouglas Yang—UHC-55719-11—1930 Indian School Rd, Eden Prairie, MN, 553140.62Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-51358TPAKatherine S Williamson1974-04-22—37831714595607 Central Ave, Plano, TX, 750750.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55838TPASusan King1980-11-07——7530 Apache Blvd, Scottsdale, AZ, 852120.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51809TPASharon Santos1990-01-28UHC-46936-5990598486216404 Bayshore Dr, Denver, CO, 802720.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59608TPAEric Walsh1948-09-23—47495353192093 Indian School Rd, Tucson, AZ, 857560.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61685TPAMark Morgan1981-04-13——2340 Pine Dr, Tampa, FL, 336070.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63186TPAPatrick Gutierrez1991-10-17UHC-55935-3563155927389066 Cedar Ln, Eden Prairie, MN, 553900.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50081TPAAlbeert Z Montgomery1971-02-03——7534 Cedar Ln, Glendale, AZ, 853840.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61416TPAJose Morrison2003-05-08——8078 Forest Ave, Atlanta, GA, 303010.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-52620TPAGregory Webb1977-01-26——462 Meadow Ln, Miami, FL0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62141TPAMargaret Gonzales—UHC-59119-32—6102 Valley View Dr, Orlando, FL, 328070.62Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+3 more
14,474 rows, page 44 of 290PreviousNext