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-50329TPAJonathan Bryant1980-03-06—20675263096901 Baseline Rd, Plano, TX, 750330.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55008TPALori Jordan1985-05-24——3367 Ocean Ave, Mesa, AZ, 852090.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57862TPAGregory Lynch1968-08-02—77278902884885 Lincoln Way, Atlanta, GA, 303950.78Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-56028TPABrittany Munoz1960-04-02—80257404136223 Central Ave, Chandler, AZ, 852680.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60933TPACharles Reid1969-06-14——3202 Lincoln Way, Tempe, AZ, 852110.78Date of birth reformattedState code upper-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-55971TPARoy Miller1942-04-16UHC-46524-24—5054 Camelback Rd, Austin, TX, 787150.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61564TPAJacob Mitchell2005-05-03—38059457553700 Hillcrest Rd, Eden Prairie, MN, 553060.78Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+1 more
TPA-59650TPADonald Griffin1954-05-14—33727609073360 Mountain View Dr, Austin, TX, 787040.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63261TPARichard S Murray2000-05-02——958 Pine Dr, Seattle, WA, 981870.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53805TPAHannah Freeman1989-01-10——1191 Palm Dr, Orlando, FL, 328290.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53030TPALauren Moore1988-05-28——8085 Spring St, Tempe, AZ, 852170.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64046TPAEdwadr Santos1980-10-27—87951160927324 River Rd, Charlotte, NC, 282490.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58733TPAFrances Henry2001-02-07—9734465938—0.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-58020TPASarah Knight1982-04-06—82286739167683 Sunset Blvd, Minneapolis, MN, 554990.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55826TPADavid Lynch1959-02-27—90299032524340 River Rd, Tempe, AZ, 852320.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62521TPAKeith Thompson1963-12-21——6960 Indian School Rd, Jacksonville, FL, 322740.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52318TPACarrl Keennedy1947-07-22——7406 Ridge Rd, Columbus, OH, 432590.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51162TPAJohn R Carter1961-02-03—57778890631434 Union St, Tempe, AZ, 852410.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54124TPAMarcus Howell1970-01-07—8037894745521 Mountain View Dr, Denver, CO, 802400.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57170TPATheresa Herrera1945-04-08——4862 Indian School Rd, Tempe, AZ0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-55149TPAValentina L Burke1940-09-27——5368 Elm St, Gilbert, AZ0.78Name re-casedDate of birth reformattedState code upper-casedZIP missing+1 more
TPA-52221TPAJoyce Riec1943-05-25——2028 Baseline Rd, Mesa, AZ, 852730.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59871TPAAlexis Ross2001-04-24——2335 Baseline Rd, Atlanta, GA, 303860.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52183TPASaar Padilla1982-07-06—9568711550690 Main St, Tampa, FL, 336830.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54428TPASmantha Weber1989-05-20—6716634990—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-55950TPARichard Boyd2001-08-07——1939 Willow Ct, Austin, TX, 787420.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55951TPARichard Boyd2001-08-07——1939 Willow Ct, Austin, TX, 787420.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61324TPABenjamin G Turner1986-11-22—86143034768717 Desert Sky Blvd, San Antonio, TX, 782090.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57960TPAJanet Dixon2002-09-08UHC-87234-89—6173 Jefferson Ave, Jacksonville, FL, 322290.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55399TPARalph Fox1970-06-04——2658 Indian School Rd, Orlando, FL, 328000.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57001TPAAmy Rogers1981-05-19—56481794578328 Palm Dr, Tucson, AZ, 857530.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63887TPAAnna Weaver1965-12-26UHC-31781-97——0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-62167TPAAnthony Oliver1962-09-24——697 Meadow Ln Apt 9, Phoenix, AZ, 850260.78Name re-casedUnit split from streetPlan code upper-casedWhitespace trimmed+1 more
TPA-58751TPAEric McDonald2006-08-23—75027900874372 Central Ave, Minneapolis, MN, 554640.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53330TPABrian Patterson1992-09-23——6786 Pine Dr, Scottsdale, AZ, 852660.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51260TPAChristina Crawford1956-06-26——5106 Desert Sky Blvd, Eden Prairie, MN, 553100.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56831TPARalph Knight1949-10-18——9517 Maple Ave, Denver, CO, 802300.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63704TPARoy Mejia1976-09-15UHC-51314-74—3909 Indian School Rd, San Diego, CA, 921670.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-56147TPAMason Rios1950-09-14—22082205288770 Washington St Apt 33, Glendale, AZ, 853400.78Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+1 more
TPA-63924TPASophia Gonzales1944-04-12—90932071639811 Ocean Ave, Minneapolis, MN, 554540.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50977TPAMcHael Stone1974-01-26——7918 Meadow Ln, Miami, FL, 331290.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52879TPAMichael Jordan2000-11-24—21251258781678 Oak St, San Antonio, TX, 782930.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62818TPAJessica Petersno2006-07-07——8905 Indian School Rd, Scottsdale, AZ, 852960.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-52658TPAIsabella M Sanders1986-05-19—56491047948404 Desert Sky Blvd, San Antonio, TX, 782210.78Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-62914TPAMarcus Turner1939-12-12——8916 Palm Dr, San Antonio, TX, 782570.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57837TPAGerald Sandoval1994-01-28—46056884171877 Mesa Dr, Mesa, AZ, 852120.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62884TPAHeather Nelson1977-12-27UHC-32033-88—3480 Main St, Plano, TX, 750590.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54832TPAAlan Morgan1976-06-02——9755 Elm St, Glendale, AZ, 853980.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60172TPAShirley Fields1946-02-13—7246872445—0.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-56699TPALawrence Rice1962-11-14——7553 Harbor Blvd, Tampa, FL, 336320.78Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
14,474 rows, page 136 of 290PreviousNext