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, flag “Date of birth reformatted”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth reformattedClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-54571TPAMargaret L Owens1976-07-02——549 Oak St, Tampa, FL, 336380.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56919TPACamila Dunn2007-12-05—4307541468—0.92Date of birth reformattedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-60635TPALaura Patterson2006-10-22—9648179466—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50197TPADebra Davis1986-02-13UHC-91305-53—1252 Church St, Orlando, FL, 328620.92Date of birth reformattedMember ID reformattedWhitespace trimmedPlaceholder values cleared
TPA-54127TPAEric Freeman1962-05-09—3566904311—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50848TPACarol Richardson2010-02-20—3386124631—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55979TPASteven G Carr1967-12-04——3232 Willow Ct, Houston, TX, 770570.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50784TPAWalter Harris1955-10-03———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56758TPADouglas Mattheews1946-05-26——3945 Broadway, Plano, TX, 750660.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-52240TPASophia Wilson1958-10-14——962 Palm Dr, Jacksonville, FL, 322430.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-61336TPAMoreno Scott1943-03-17——2645 Park Pl, Sacramento, CA, 958410.92Date of birth reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-50211TPASofia Wheeler1982-11-09—6262228452—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61327TPARyan Barnes1957-09-02—85737908664816 Desert Sky Blvd, Gilbert, AZ, 852480.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58632TPAHannah Morales2008-03-17———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59639TPADenny Gardner1974-04-10——2179 Broadway, Columbus, OH, 432790.92Name re-casedDate of birth reformattedAddress re-casedPlaceholder values cleared
TPA-50852TPAWalter Palmer1979-12-15—7997496707—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-52159TPAAisha Berry1976-03-07——2814 Oak St, Columbus, OH, 432260.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56252TPARalph Wang1957-12-03—9104336575—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50214TPAGary Reynolds1964-07-28———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50807TPAMadison Greene1958-03-25—27658433456827 Ridge Rd, Jacksonville, FL, 322170.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58640TPAKaren R Stewart2000-02-02——6295 Lincoln Way, Tempe, AZ, 852280.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55845TPAMaria Dean2007-10-07———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50506TPAAlexander R Castro1957-10-01——1906 Broadway, Los Angeles, CA, 900970.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-51051TPAJoyce Carr1976-08-01UHC-88883-3380940627385711 Broadway, Nashville, TN, 372000.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63235TPAHannah Miller1957-10-12———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51085TPASarra Riley1968-11-24—5604707904—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54200TPAAisha Stephens1996-04-17—70650440942778 Valley View Dr, Minneapolis, MN, 554350.92Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed
TPA-54233TPAYuki Lynch1963-06-01—9205577136—0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53569TPAShirley Welch1944-11-10——5380 Washington St, Miami, FL, 331470.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-54000TPAEugene I Jones1966-02-20——1907 Broadway, Chandler, AZ, 852950.92Date of birth reformattedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54605TPAShaw Sean1971-12-01———0.92Name re-casedDate of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-51769TPABlack Jacqueline1989-08-17—78685493313673 Apache Blvd, Tucson, AZ, 857210.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-53355TPAEmma Wilson1975-01-23———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55625TPABrenda Long1955-11-11UHC-25071-999368388627—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder 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-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-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-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-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-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-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
4,728 rows, page 79 of 95PreviousNext