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-50048TPAWayne Vazquez1982-02-20—4867805798149 Lincoln Way, San Diego, CA, 921540.78Two-digit birth yearPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-64263TPACheryl Obrien1938-08-14UHC-58364-11—7836 Union St, Chandler, AZ, 852530.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58591TPASteven Holmes1944-09-14UHC-82541-14—554 Bayshore Dr, San Diego, CA, 921850.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56207TPASophia Hart1944-01-04——4177 Grand Ave, Las Vegas, NV, 891090.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-58927TPAAsshley Lawson1942-07-23——5048 Canyon Rd, Fresno, CA, 937340.78Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-59255TPASamuel Bennett1946-07-10UHC-99610-72—4248 Lincoln Way, Fresno, CA, 937540.78Name re-casedMember ID reformattedCity re-casedGender normalised+1 more
TPA-51308TPADigo West1962-07-26UHC-45695-22—3822 Baseline Rd, Dallas, TX, 752350.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50367TPASofia Chavez1996-12-23—48166723973709 Sunset Blvd, Los Angeles, CA, 900670.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50771TPAKatherine Russell1954-11-01——2576 Hillcrest Rd, Houston, TX, 770170.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62090TPALuri I Armstrong1939-08-17—2402251345319 River Rd, Charlotte, NC, 282250.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64133TPABilly Andrews1960-09-05—22998633984549 Bayshore Dr, Tempe, AZ, 852980.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61830TPAWayne Miller1938-11-24—59368455651462 Union St, Tucson, AZ, 857490.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52927TPARonald Collins1949-05-08——4782 Mountain View Dr, Los Angeles, CA, 900020.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58459TPAJackie Nelson1956-08-17——9235 Jefferson Ave, Los Angeles, CA, 900260.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59798TPAKayla Walsh1967-03-10UHC-98490-89—8522 Lake View Rd, Tucson, AZ, 857050.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60769TPALawrence Ortiz1977-03-25UHC-54477-49—3355 Highland Ave, Dallas, TX0.78Name re-casedDate of birth reformattedCity re-casedZIP missing+1 more
TPA-51172TPAAmber Graham1969-10-14——1919 Park Pl, Scottsdale, AZ, 852530.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55213TPASean Campbell1961-07-27——8834 Mountain View Dr, Tampa, FL, 336140.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-61912TPADonald Anderson1955-05-15——860 Sage Ct, Scottsdale, AZ, 852910.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51898TPAYuki Carter1955-09-25UHC-07808-7552497977474834 Central Ave, San Diego, CA, 921220.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59549TPARandy Lynch1996-09-27UHC-19138-60—269 Canyon Rd, Eden Prairie, MN, 553360.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55746TPADiana Jordan1997-12-17——2158 Ridge Rd, Columbus, OH, 432500.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54965TPAMaria Singh1987-02-18—42128766313060 Lincoln Way, Austin, TX, 787900.78Date of birth reformattedPhone reformattedCity re-casedState name converted to code+1 more
TPA-56145TPASharon Scott1977-06-19——463 Pine Dr, San Diego, CA, 921020.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50607TPABrenda Wallace1975-02-03—69823481339142 Church St, Minneapolis, MN, 554530.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63212TPAMichelle Oliver1978-02-16UHC-82552-09—8192 Indian School Rd, Sacramento, CA, 958990.78Name re-casedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-63105TPAJose Long1944-05-15—4948987766684 Park Pl, San Diego, CA, 921330.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52972TPALori Lucas1953-12-09UHC-00588-8624481535129365 Palm Dr, Denver, CO, 802880.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58223TPAScott Hicks1975-05-21——3977 Washington St, Seattle, WA, 981490.78Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-61660TPAAlan Price1973-10-17——1978 Cedar Ln, Scottsdale, AZ0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-51751TPAMcHael Marshall1971-09-20—38574207655910 Main St, Denver, CO, 802500.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58525TPAMadisn Rodriguez1987-03-20——1469 Mountain View Dr, San Antonio, TX, 782150.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57691TPADylan Harvey1976-03-10——5090 Ridge Rd, Phoenix, AZ, 850570.78Name re-casedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-53228TPABrenda Perkins1980-01-27—98844859626181 Cedar Ln, Sacramento, CA, 958940.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63829TPAArthur Boyd1978-06-22——6927 Lincoln Way, San Diego, CA, 921940.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-53885TPAGregory Guerrero1985-01-16——7166 Jefferson Ave, Phoenix, AZ, 850750.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53884TPAGregory Guerrero1985-01-16——7166 Jefferson Ave, Phoenix, AZ, 850750.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58645TPARodriguez Emma2006-11-25——894 River Rd, Phoenix, AZ, 850000.78Name re-casedDate of birth reformattedPhone missing area codeWhitespace trimmed+1 more
TPA-58787TPAKimberly Morrison1990-05-06——6635 Palm Dr, Gilbert, AZ, 852390.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62732TPAKeith Miller1959-07-13——355 Meadow Ln, Miami, FL, 331250.78Street suffix standardisedAddress re-casedPlan code upper-casedWhitespace trimmed+1 more
TPA-57632TPAMarilyn Holms1944-08-12———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-55977TPAHeather Ramirez1985-09-07—67566956873843 Main St, Plano, TX, 750500.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58451TPATimothy O Clark1959-09-22—38835908991801 Mountain View Dr, Orlando, FL, 328740.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55273TPADiane D Gibson1946-05-12——8335 Mesa Dr, Eden Prairie, MN, 553870.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64199TPAKenneth Gilbert1970-06-12——3202 Canyon Rd, Glendale, AZ, 853670.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52558TPANicholas Edwards1983-06-03UHC-13752-6652673663572706 Broadway, Tucson, AZ, 857240.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-52557TPANicholas Edwards1983-06-03UHC-13752-6652673663572706 Broadway, Tucson, AZ, 857240.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-52956TPAAnna Adams2003-09-24—6932030709504 Ridge Rd, Minneapolis, MN, 554880.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61412TPAAlexis Mitchell1973-02-06—43371159771919 Park Pl Apt 13, Jacksonville, FL, 322090.78Name re-casedDate of birth reformattedPhone reformattedUnit split from street+1 more
TPA-59833TPAGrace Ryan1973-06-28——9392 Highland Ave, Mesa, AZ, 852100.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 131 of 290PreviousNext