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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-62199TPAGary Jordan2005-01-08UHC-93960-98——0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50112TPACharlotte Ortyz2002-10-16——7944 Canyon Rd, Columbus, OH, 432390.92Name re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-60874TPACarlos Kelley1953-04-04—96432785433081 Pine Dr, Houston, TX, 770770.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-59571TPAIsabella P Santos1985-12-02———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56755TPASamantha Clark1944-06-24——9047 Sunset Blvd, Scottsdale, AZ, 852340.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51994TPAHiroshi Li1965-02-27—38936863924513 Lincoln Way, Nashville, TN, 372080.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-51234TPAGloria Flores1949-06-18UHC-00099-58—700 Willow Ct, Chandler, AZ, 852220.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-55239TPASofia Soto1974-05-18——884 Sunset Blvd, Columbus, OH, 432390.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-60147TPAKaren Green1953-06-27—67261323241578 Camelback Rd, Dallas, TX, 752980.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63183TPAJason V Ortega1996-12-07——7545 Apache Blvd, San Antonio, TX, 782490.92State code upper-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-63668TPARaymond Alvarado1940-05-14——1325 Market St, Dallas, TX, 752300.92Name re-casedDate of birth reformattedState code upper-casedPlaceholder values cleared
TPA-60515TPAStephen Z Ellis1973-08-25—5682406552157 Harbor Blvd, Los Angeles, CA, 900830.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-60405TPADoris Torres1988-08-17—52439115237807 Sunset Blvd, Phoenix, AZ, 850710.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50833TPAGloria Meyer1988-01-23—52223901868279 Willow Ct, Dallas, TX, 752120.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57199TPAHeather Hill1993-10-17—3409033399—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53646TPABanks Brenda1977-01-16—3395057655—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62602TPAMei Torres1961-08-22—28793285707477 Oak St, Fresno, CA, 937300.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-51866TPAAdam F Clark1994-12-09—20884205314456 Park Pl, Denver, CO, 802010.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50548TPADanielle Wang1982-04-12——5970 Elm St, Glendale, AZ, 853940.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-53058TPADouglas R Peterson1980-05-13———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52630TPASteven Ortega1941-03-27UHC-06063-03——0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60339TPASamuel G Ramirez2001-06-06——8485 Broadway, Tampa, FL, 336960.92Name re-casedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53338TPAKeith O Hunter1991-09-08——8517 Mountain View Dr, Tucson, AZ, 857310.92Name re-casedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-60509TPARichard E Thmas2006-07-12—9483876321461 Pine Dr, Austin, TX, 787340.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50215TPAMartha Parker1981-02-15UHC-19603-976026444202—0.92Name re-casedMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-54678TPAWillie Gibson1994-04-23——3603 Harbor Blvd, Tampa, FL, 336950.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-60529TPAAlice Meyer1980-10-04UHC-24459-46—7448 Mesa Dr, Chandler, AZ, 852720.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-57942TPAGregry N Henry1975-02-12UHC-22017-6148827646309087 Broadway, Houston, TX, 770620.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
TPA-53856TPARandy Hernandez1980-10-19UHC-00866-60—8338 Lincoln Way, Atlanta, GA, 303920.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-58983TPAJerry Martin1939-03-08——8116 Ridge Rd, Nashville, TN, 372560.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57563TPASantiago Ferguson1970-12-15UHC-71174-76—2728 Hillcrest Rd, Fresno, CA, 937410.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-59978TPADaniel Guerrero1946-06-03—39730182888761 Jefferson Ave, Austin, TX, 787230.92Phone reformattedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-59945TPAWilliam Miller1998-08-23—4062911484—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55218TPAAhmed George1989-04-19———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63350TPAGabriel Price1985-07-23—50460170983420 Elm St, Las Vegas, NV, 891030.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-55976TPAArjun Reid1965-02-05———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62458TPAJoshua S Hicks1958-02-27——4761 Lincoln Way, Fresno, CA, 937990.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50984TPAJennifer Silva1938-10-06—5738831960—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55217TPAJuan Freeman1958-02-23UHC-45689-44—4017 Forest Ave, Orlando, FL, 328230.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52297TPAPaul Fernnadez1989-03-22——3114 Broadway, Scottsdale, AZ, 852040.92Address re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-52085TPALori Payne1983-12-05—9366677228—0.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-62215TPASteve E Cole1970-03-07—29651893408077 Willow Ct, Tempe, AZ, 852580.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56102TPAMargaret Hunt1941-10-25——7240 Union St, Gilbert, AZ, 852080.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-60613TPATyler Silva1993-01-21—2304632573—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60851TPALuis M Hamilton1969-07-08UHC-40559-32—7639 Broadway, Glendale, AZ, 853400.92Name re-casedDate of birth reformattedAddress re-casedPlaceholder values cleared
TPA-59809TPAEthan Oliver1938-11-05——646 Ridge Rd, Sacramento, CA, 958000.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51612TPADiego George2000-06-14—2675091606—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56911TPAJose James1982-09-26———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52357TPAMery Ramirez1961-03-28—68462051371794 Cedar Ln, Jacksonville, FL, 322770.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-59098TPACarol Rogers1973-06-14——6820 Hillcrest Rd, Minneapolis, MN, 554270.92Date of birth reformattedCity re-casedPlan code upper-casedPlaceholder values cleared
14,474 rows, page 233 of 290PreviousNext