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

All sources, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-412398CLMScott Gilbert1940-05-12—24826285481979 Pine Dr, Houston, TX, 770780.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-412399CLMScott Gilbert1940-05-12—24826285481979 Pine Dr, Houston, TX, 770780.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-432713CLMHarold Hanson1959-12-11UHC-26394-1973740360958336 Hillcrest Rd, Plano, TX, 750750.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-121523ENRGabriel Roberts1987-01-14UHC-34367-6424465961256997 Washington St, Eden Prairie, MN, 553990.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
PRV-24833PRVLuis B Simmons2003-04-13UHC-91105-479167153948—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50884TPACarlos Lawrence1957-09-19——6107 Mountain View Dr, Phoenix, AZ, 850150.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-409015CLMBradley Bell1989-10-15UHC-18863-186273622857—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-409700CLMWilliam Walsh1983-03-25UHC-07070-34—8684 Spring St, Mesa, AZ, 852960.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-428728CLMHeather Gardner1996-07-12——3937 Elm St, Denver, CO, 802120.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-54489TPAMariana Snyder1999-01-24——5485 Mesa Dr, Dallas, TX, 752750.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60049TPADouglas Matthews1976-06-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-413294CLMAndrew H Montgomery1944-07-27UHC-31571-5544099799384498 Sunset Blvd, Columbus, OH, 432960.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63706TPAMadison Dunn2008-10-06—87882284831892 Market St, Seattle, WA, 981840.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25500PRVRyna L Hernandez1959-01-19—5727094583—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55602TPAMateo Y Mitchell1983-09-13—2917080633—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-417171CLMJoe Graham1951-01-08———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-28213PRVJesse Q Chapman1968-06-27—62252448402417 Willow Ct, Denver, CO, 802270.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-137308ENRRonald Ferguson1953-03-03UHC-32246-73217956006050 Hillcrest Rd, San Diego, CA, 921780.80Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased
ENR-129210ENRMadison Hall2003-03-14UHC-21997-556544386534—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-404045CLMRobert Wang1951-08-03—2386650626—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-403009CLMGeorge J Fernandez1951-05-09—34964697839283 Main St, Phoenix, AZ, 850140.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57427TPAJean Collins1971-03-07—3415528863—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
ENR-122708ENRMatthew Dunn2008-11-24UHC-78000-287806051992—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-137974ENRRussell Lee1969-11-26UHC-11734-936108866920244 Mesa Dr, Glendale, AZ, 853500.80Name split from “Last, First”Phone reformattedPlan code upper-casedWhitespace trimmed
CLM-413245CLMYuki Sullivan1941-10-26UHC-25113-7384897502962742 Camelback Rd, Las Vegas, NV, 891250.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
CLM-429505CLMJudith Sanchez1953-05-23UHC-37863-857573912801—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-132640ENRMedison D Henry1991-08-08UHC-35104-9124438411967269 Highland Ave, Los Angeles, CA, 900830.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-142210ENRAlan Warren1946-09-10UHC-64777-9432134039997316 Valley View Dr, Chandler, AZ, 852850.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-60980TPAIsabella L Harrt1975-03-17UHC-19333-94—4604 Jefferson Ave, Glendale, AZ, 853720.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-428519CLMCarolyn Long1953-09-13—7446688772—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26803PRVKeith Dominguez1941-02-08UHC-93982-603457970629—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62350TPAChristine I Young1978-10-04——8138 Spring St, Tampa, FL, 336180.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57014TPADorys Anderson1940-06-16—47646832275796 Broadway, Sacramento, CA, 958280.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-123839ENRAbigail U Jacobs1955-11-22UHC-00074-376488929693670 Harbor Blvd, Miami, FL, 331960.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-406155CLMJanet Turner1938-12-18UHC-84100-905975361492856 Central Ave, Sacramento, CA, 958790.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-120682ENRBruce B Hudson1961-11-11UHC-80355-8747926303096612 Mesa Dr, Los Angeles, CA, 900350.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
CLM-413702CLMCarol Owens1976-05-19UHC-59852-07——0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
CLM-424678CLMAnn Berry2003-05-28UHC-79552-37—7288 Broadway, Eden Prairie, MN, 553640.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
ENR-102503ENRKyle Z Phillips1964-08-19UHC-74042-1671323627444114 Cedar Ln, Chandler, AZ, 852350.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
CLM-420738CLMCarol Rogers1973-06-14UHC-29452-5664376766426820 Hillcrest Rd, Minneapolis, MN, 554270.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-24605PRVLri Foster1993-05-17—47963265218427 River Rd, Eden Prairie, MN, 553390.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
ENR-129808ENRMichelle M Burns1938-06-03UHC-94933-3031893267266585 Bayshore Dr, San Antonio, TX, 782450.80Name split from “Last, First”Date of birth reformattedCity re-casedEmail lower-cased
CLM-423598CLMAmy Myers1950-09-21UHC-78281-86—5533 Valley View Dr, Charlotte, NC, 282230.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-421866CLMNancy T Wong2006-05-23—8725633120—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-125497ENRAmber Payne1974-01-05UHC-74098-987958717331—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-415359CLMBobby Gilbert1980-02-07——8460 Indian School Rd, San Diego, CA, 921600.82Name split from “Last, First”City re-casedPlaceholder values cleared
PRV-23282PRVJacob Kelly1990-05-14—2818663241—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
ENR-122073ENRPaemla Park1998-03-23UHC-12081-8324920472512695 Church St, Phoenix, AZ, 850350.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
CLM-416324CLMJoan Carr2004-03-05UHC-03224-303346212733—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
ENR-138465ENRNathan O James1963-11-15UHC-07435-2578865906135933 Mesa Dr, Phoenix, AZ, 850130.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
9,980 rows, page 177 of 200PreviousNext