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-54788TPAAdam Lnua1941-11-08——6056 Main St, Tempe, AZ, 852960.76Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-50403TPABrandon Munoz1965-08-06—4199034858466 Desert Sky Blvd, Jacksonville, FL, 322530.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54102TPAPatrick O Jones1960-04-02—43792019904740 Canyon Rd, Charlotte, NC, 282450.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57637TPADebra C Matthews1973-10-28—35794595113697 Lake View Rd, Chandler, AZ, 852670.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54894TPAPat Alexander1967-08-09UHC-70757-96—1326 River Rd, Austin, TX, 787210.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63903TPARichard Clark1972-10-03—7992782888569 Forest Ave, Atlanta, GA, 303770.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58562TPAPatrick Andrews2001-03-04—64356936274763 Church St, Plano, TX, 750680.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57517TPARyan Mendoza1985-06-19—55494238803085 Baseline Rd, Los Angeles, CA, 900520.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54559TPADiana Obrien1971-09-07UHC-82105-0994588029635504 Indian School Rd, Fresno, CA, 937920.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60579TPAJerry Silva1958-10-15——8957 Camelback Rd, Chandler, AZ, 852430.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60748TPAHeather Lane1983-07-19—98367430517827 Valley View Dr, Scottsdale, AZ, 852130.76Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
TPA-52192TPAArthur Contreras1943-10-20—33399483943294 Baseline Rd, Jacksonville, FL, 322770.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56141TPASean Y Tucker1984-10-08——4906 Sage Ct, Gilbert, AZ, 852630.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63798TPASophia Daniels1983-05-06——9788 Jefferson Ave, Denver, CO, 802750.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54243TPABrenda Ross2000-06-04——5293 Grand Ave, Phoenix, AZ, 850220.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53177TPAFrank O Sanchez1941-11-17—82339393832748 Sage Ct, Seattle, WA, 981630.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50117TPAMadison Harris1945-01-13UHC-00473-04—1520 Ocean Ave, Austin, TX, 787540.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52940TPAAna Austin1942-09-19UHC-98418-4398195967007915 Hillcrest Rd, Dallas, TX, 752100.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60633TPAAngela Woods1978-01-03——3904 Canyon Rd, Scottsdale, AZ, 852260.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54744TPADorothy Garcia1949-05-15—82493234996761 Sunset Blvd, Denver, CO, 802990.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58155TPAGerald Ortega1979-09-05—27869487588711 Cedar Ln, Columbus, OH, 432910.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62841TPATom I Cruz1998-03-20UHC-85435-68—5054 Main St, Phoenix, AZ, 850850.76Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
TPA-55190TPAFrances Ford1945-03-03——9796 Market St, Las Vegas, NV, 891610.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55020TPAMadison Barnes1974-01-07—73068931427739 Forest Ave, Charlotte, NC, 282280.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51943TPAEmily Hicks1990-09-02——207 Camelback Rd, Seattle, WA, 981120.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53703TPAPatricia Q Banks2007-05-19—55942105954827 Willow Ct, San Antonio, TX, 782180.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55796TPAMatthew Rios1960-04-19——96 Baseline Rd, Phoenix, AZ, 850520.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54629TPAMarilyn Patterson1997-01-05—56887442569305 Meadow Ln, Orlando, FL, 328880.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51694TPAGregory Morris1940-02-01——4387 Washington St, Chandler, AZ, 852160.76Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-55895TPALauern H Shaw1997-08-15—60141690842823 Spring St, Los Angeles, CA, 900950.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51253TPADiana W Fisher1945-03-17—27858300536134 Canyon Rd, Charlotte, NC, 282960.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60377TPACynthia Little1978-08-01——5859 Camelback Rd, Glendale, AZ, 853350.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58142TPASara C Sanders1984-10-03——1296 Jefferson Ave, Gilbert, AZ, 852490.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50321TPAMatthew Johnston1986-08-07——5468 Market St, Columbus, OH, 432680.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54924TPANancy Wheeler1992-07-20—28386435863917 Forest Ave, Miami, FL, 331710.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51110TPALaarry Vasquez2003-04-24——5326 Lincoln Way, Jacksonville, FL, 322480.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51549TPAArjn Dunn1987-02-05—98726073553720 Indian School Rd, Miami, FL, 331650.76Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-61971TPAKyle Taylor1943-03-04——8402 Grand Ave, Eden Prairie, MN, 553890.76Street suffix standardisedAddress re-casedState code upper-casedEmail lower-cased+2 more
TPA-56205TPAIsabella Watkins1967-06-02——1407 Ocean Ave, Mesa, AZ, 852230.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60832TPACarlos Hoffman1963-08-01——559 Mesa Dr, Austin, TX, 787680.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63853TPANancy Henderson1987-10-03——6909 Harbor Blvd, Orlando, FL, 328390.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61785TPAKelly Mason1950-04-08—6127365124527 Jefferson Ave, Eden Prairie, MN, 553740.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-64394TPAJeremy Gardner2007-05-17——7452 Baseline Rd, Eden Prairie, MN, 553470.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51734TPAAlbert Sanders1943-07-28UHC-97542-95—313 Canyon Rd, Las Vegas, NV, 891060.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50484TPAAnthony Rose1996-09-22——7414 Desert Sky Blvd, Scottsdale, AZ, 852290.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63415TPAGregory Bowman1982-04-16—2076868116—0.76Name re-casedDate of birth reformattedPhone reformattedGender normalised+2 more
TPA-58460TPAMichelle Mason1990-12-28—92241318444639 Forest Ave, Seattle, WA, 981940.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64241TPALisa Nelson1971-08-13—49475616744376 Mesa Dr, Scottsdale, AZ, 852890.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62923TPAJohn Moore1996-04-11—40720618473523 Market St, Sacramento, CA, 958630.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-61278TPAJanet Tucker1972-06-26——4988 Indian School Rd, Minneapolis, MN, 554600.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
14,474 rows, page 115 of 290PreviousNext