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-52650TPADon Martin1980-01-17—75646686414944 Sage Ct, Gilbert, AZ, 852490.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57782TPAMateo B Wallace1980-05-21——8602 Harbor Blvd, Denver, CO, 802280.78Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-57853TPAAaron Jenssen1969-05-08——5197 Baseline Rd, Scottsdale, AZ, 852270.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57750TPAAlexis Tran1938-01-26UHC-80596-076349166724238 Apache Blvd, Sacramento, CA, 958360.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-50565TPAGrace Alvarado1945-12-20——806 Desert Sky Blvd, Atlanta, GA, 303300.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55533TPARuth Perez2001-12-01——4458 Cedar Ln, San Antonio, TX, 782570.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55884TPARobert Jordan2006-08-03——6592 Highland Ave, Minneapolis, MN, 554310.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54447TPATherasa Diaz1904-08-20UHC-13273-5963035332115033 Oak St, Mesa, AZ, 852930.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-50662TPADenise Peters1980-10-22UHC-28393-22—9572 Mesa Dr Apt 10, San Antonio, TX, 782910.78Unit split from streetCity re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-59766TPAHiroshi U Schultz1978-07-23—9873904263—0.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-58791TPARaymond Ortiz1965-04-04——9314 Hillcrest Rd, Fresno, CA, 937760.78Date of birth reformattedState code upper-casedGender normalisedWhitespace trimmed+1 more
TPA-57766TPAMaria Simpson1979-12-26—58923063557887 Forest Ave, Tampa, FL, 336860.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50698TPAGloria X Chapman1945-07-20——9217 Elm St, Phoenix, AZ, 850550.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-59711TPAEric Hudosn2008-12-03UHC-87974-5973052046188745 Church St, Minneapolis, MN, 554220.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61941TPAChristina Lynch1942-03-08—54244811348964 Maple Ave, Charlotte, NC, 282300.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52075TPACamila Perez1965-07-28——3706 Jefferson Ave, San Antonio, TX, 782530.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62861TPADeborah McDonald1940-11-21UHC-58628-35—690 Broadway, Glendale, AZ0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-63216TPADanielle Young2004-09-22—97981983865918 Baseline Rd, Sacramento, CA, 958110.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59834TPAGrace Ryan1973-06-28——9392 Highland Ave, Mesa, AZ, 852100.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-60069TPAKelly Lawrence1982-05-23——2077 Cedar Ln, Mesa, AZ, 852930.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-53294TPADonna Ford1940-04-09——6615 Canyon Rd, Las Vegas, NV, 891570.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57888TPAMadison O Stephens1951-08-04UHC-13108-9848232491841893 Washington St, Chandler, AZ, 852430.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57315TPABobby Rice1938-01-19UHC-16174-4251034705948491 Desert Sky Blvd, Sacramento, CA, 958100.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-55128TPAValentina Otriz1958-09-28—34326196802148 Willow Ct, Columbus, OH, 432850.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59673TPAAnrew Ryan1938-11-04UHC-80498-57—5629 Pine Dr, Houston, TX, 770890.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50129TPAMartha Peters1975-04-12—36467369069204 Union St, Las Vegas, NV, 891570.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58843TPAIsabella Wallace1955-09-12—47547511136211 Jefferson Ave, Miami, FL, 331410.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61905TPADick Harvey1957-11-03—50099531135821 Meadow Ln, Glendale, AZ, 853570.78Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-53534TPAHenry Espinoza1967-08-19——5789 Apache Blvd, Seattle, WA, 981470.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-60716TPAAbigail Ellis1939-06-23——7316 Broadway Apt 5, Atlanta, GA, 303960.78Name re-casedUnit split from streetCity re-casedWhitespace trimmed+1 more
TPA-62355TPAObrien V Christopher1982-05-11——5265 Central Ave, Atlanta, GA, 303320.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60653TPAHenry Delgao1981-05-26——5525 Oak St, Minneapolis, MN, 554560.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50375TPALori Warren1976-12-09—39491038794758 Highland Ave, Los Angeles, CA, 900650.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59360TPAJimmy Gardner1962-10-04—23526272482078 Sunset Blvd, Nashville, TN0.78Date of birth reformattedPhone reformattedZIP missingWhitespace trimmed+1 more
TPA-61131TPASophia White1979-04-25——2873 Highland Ave, San Antonio, TX, 782680.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53515TPAJoshua Hayes1956-04-13—59185841283463 Mountain View Dr, San Diego, CA, 921490.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58241TPACarol Singh1997-02-14UHC-31898-22—5749 Canyon Rd, Las Vegas, NV, 891070.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53638TPAAlexis Lee1965-03-04——2188 Ocean Ave, Mesa, AZ, 852720.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51216TPAEgene Espinoza1945-12-11——4711 Mountain View Dr, Houston, TX, 770810.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-54298TPAScott D Morris1976-05-10——7172 Central Ave, Columbus, OH, 432230.78Name re-casedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-53410TPABecky Clark1990-06-12——9740 Oak St, Jacksonville, FL, 322080.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57092TPABryant Aisha1957-04-26—3532939439644 Ocean Ave, San Diego, CA, 921070.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57816TPACamila Andrews1983-02-08UHC-90086-43——0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-51335TPASean Howard2003-03-02—79656507321024 Lincoln Way, Gilbert, AZ, 852740.78Phone reformattedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-54491TPAJose Hamilton1945-01-19UHC-75302-49—2825 Spring St, Jacksonville, FL, 322870.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-54238TPAPatricia Phillips1963-07-20——3971 Jefferson Ave, Los Angeles, CA, 900100.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-57920TPASophia Robertson1962-08-17—27449786954173 Willow Ct, Fresno, CA, 937540.78Phone reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-61734TPARussell Jenkins1965-02-11——7939 Park Pl, Tempe, AZ, 852570.78Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+1 more
TPA-60539TPAVictoria G Smith1974-10-14——9563 River Rd, Los Angeles, CA, 900170.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61055TPAJoan Fowler1983-10-14——7025 Sage Ct, Fresno, CA, 937220.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 151 of 290PreviousNext