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-51769TPABlack Jacqueline1989-08-17—78685493313673 Apache Blvd, Tucson, AZ, 857210.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57829TPAGracce Romero1978-08-24—63282091866656 Lincoln Way, Nashville, TN, 372370.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-64409TPAJoe D Scott1961-08-27—4127922854—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53355TPAEmma Wilson1975-01-23———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52478TPAScott Chavez1982-09-19———0.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-55625TPABrenda Long1955-11-11UHC-25071-999368388627—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53690TPABobby P Anderson1978-03-09—8534510543—0.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-54961TPAFrank Franklin2005-12-28———0.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-57555TPALucia White1991-07-18——4563 Lincoln Way, Sacramento, CA, 958530.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54641TPAMichelle Nunez1986-06-15—21499469098853 Union St, Tampa, FL, 336780.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62994TPAAlexis Price1997-10-10—2034729259300 Bayshore Dr, Atlanta, GA, 303580.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53127TPAJanice L Harvey1968-12-21—46934790546297 Sage Ct, Dallas, TX, 752970.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57476TPAElijah Richardson1951-04-02——3875 Park Pl, Orlando, FL, 328640.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-50320TPACheryl Parker1988-06-09—74626169928286 Bayshore Dr, Tampa, FL, 336490.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53962TPABetty Fields1990-09-12UHC-71045-0786725116194666 Broadway, Charlotte, NC, 282750.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50291TPABilly Jacobs1959-06-28—49132298788915 Willow Ct, Tampa, FL, 336140.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51328TPAPaul Holmes2003-04-23—88245946118385 Broadway, Columbus, OH, 432500.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-60243TPAKeith Reid1955-08-15—75065973424715 Jefferson Ave, Las Vegas, NV, 891740.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50679TPAChristine Jacobs1969-02-18UHC-30563-7552566235096688 Hillcrest Rd, Jacksonville, FL, 322680.92Phone reformattedCity re-casedState code upper-casedPlaceholder values cleared
TPA-51023TPAEdward Espinoza1949-08-10———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59707TPAJudy X Mason1953-08-20—8303258877—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-63885TPADorothy W Ruiz1984-01-14UHC-15485-4056422958593386 Lake View Rd, Denver, CO, 802900.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-61556TPAJoe Mills1948-12-08——8341 Market St, Seattle, WA, 981420.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-55175TPAAlcie Q Ortega1948-01-20—7567665648—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62389TPAOmar Ramos1979-11-28UHC-36972-06——0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57385TPABrayn Stevens1997-05-16UHC-77358-206423989218287 Lincoln Way, Eden Prairie, MN, 553670.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-52369TPARebecca Astin1983-03-26—33326784142519 Spring St, Atlanta, GA, 303540.92Phone reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-52362TPABilly Obrien1985-09-16—79426183214827 Meadow Ln, Tucson, AZ, 857820.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59587TPASamantha West1987-11-13—9849528150—0.92Name re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-52379TPACatherine Singh1967-05-16—3407958892—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51863TPANancy Oliver1944-10-25—23094238068923 Baseline Rd, Plano, TX, 750660.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62904TPASophia Stone1985-10-25—9769077903—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59661TPARebecca Fox2000-04-23——9718 Main St, Fresno, CA, 937890.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51012TPAPamela Jensen1984-10-04—6344775907—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62721TPARebecca G Fox2000-12-04UHC-05601-41—7732 Harbor Blvd, Eden Prairie, MN, 553710.92Name re-casedMember ID reformattedCity re-casedPlaceholder values cleared
TPA-55738TPAPaul Mejia1994-10-14—39761078956670 Cedar Ln, Minneapolis, MN, 554730.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-64197TPANicholas Kennedy1974-04-10———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53519TPABrian Schmidt1958-10-15UHC-76529-82—1569 Sunset Blvd, Tempe, AZ, 852960.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-55655TPADanielle Z Phillips1992-06-04—7368254868—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61193TPANathan Patterson1954-10-23—90544852415732 Harbor Blvd, Los Angeles, CA, 900660.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-58004TPAGloria Wells1956-09-12—5833700976—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-64047TPACarol U Rogers1947-04-05——5460 Bayshore Dr, Minneapolis, MN, 554950.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-54433TPAGerald Chavez1987-03-27—42682732566886 Central Ave, Seattle, WA, 981860.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
TPA-61764TPALawrence Wallae1975-10-13—84668651429318 Elm St, Nashville, TN, 372370.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
TPA-63361TPAJacob Dominguez1995-08-07—35145699183852 Elm St, Chandler, AZ, 852150.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-55336TPABrittany Hudson1974-11-22UHC-99834-9370770843361400 Palm Dr, San Diego, CA, 921640.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-64254TPAYuki Jacobs1940-04-28—6542597164—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57187TPACarol Ross1987-03-24——5318 Central Ave, Orlando, FL, 328450.92Name re-casedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-50038TPAJoshua Burke1994-09-03—32976273456405 Hillcrest Rd, Denver, CO, 802850.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63011TPASen Sims1945-02-08—45543370474081 Mesa Dr, Phoenix, AZ, 850200.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 235 of 290PreviousNext