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, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-52564TPAEugene Foster1959-03-24UHC-01745-6968568869846273 Central Ave, Sacramento, CA, 958330.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425990CLMDebra Marshall2003-04-13UHC-06922-26—5514 Canyon Rd, Seattle, WA, 981350.48Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+4 more
ENR-113646ENRAlbert E Dixon—UHC-57246-8720438156945441 Market St, Mesa, AZ, 852330.48Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more
PRV-27234PRVEugene A Robertson2001-11-10UHC-32080-4855365635218505 Palm Dr Apt 22, Columbus, OH, 432650.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-121911ENRSandra D Burton1964-05-14UHC-01994-0594054878068931 Lake View Rd, Sacramento, CA, 958310.48Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
CLM-409856CLMEric Fisher1942-10-10UHC-76932-93—799 Lake View Rd, Chandler, AZ, 852440.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57015TPALori Gibson1960-08-15—81742595758161 Ridge Rd, Austin, TX, 787150.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-142407ENRAustin Mitchell1991-12-18UHC-30117-5363644755338198 Lake View Rd, Minneapolis, MN, 554500.48Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-101108ENRStephen Castro2002-08-08UHC-57755-7765931233264293 Spring St Apt 4, Jacksonville, FL, 322440.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-122522ENRMartha Davsi2007-05-17UHC-17115-1957722097529349 Hillcrest Rd, Dallas, TX, 752580.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-128264ENRMaria Salazar1973-12-13UHC-61139-77—2905 Harbor Blvd, Las Vegas, NV, 891920.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-122166ENRAlbert L Santtos1956-12-07UHC-81733-66—8286 Harbor Blvd, Mesa, AZ, 852460.48Middle initial moved out of first nameName re-casedDate of birth reformattedPhone missing area code+4 more
CLM-405886CLMEthan R Robertson——53633028244600 Canyon Rd, Seattle, WA, 981060.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
PRV-24966PRVDanielle Garza—UHC-79202-9696486310912118 Desert Sky Blvd, Charlotte, NC, 282410.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-423457CLMJustin Shaw1942-04-02UHC-89927-08—5769 Oak St, Las Vegas, NV, 891120.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138301ENRSandra Barnes1941-11-11UHC-80935-1289864383617153 Bayshore Dr, Houston, TX, 770310.48Name split from “Last, First”Date of birth reformattedMember ID reformattedSSN last four extracted+4 more
ENR-139943ENRSophia Welch1938-07-16UHC-08969-8783031981369297 Church St, San Diego, CA, 921710.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-415689CLM—Junk1946-11-15UHC-44057-3155230880241746 Mountain View Dr, Phoenix, AZ, 850030.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127833ENRAlexis Payne1960-09-09UHC-05678-368432121327309 Indian School Rd, Phoenix, AZ, 850620.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-133150ENRShirley Thomas1950-01-03UHC-75591-4089149420534157 Jefferson Ave # 452, San Diego, CA, 921550.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-20746PRVDiana Bennett1964-09-14UHC-02217-1664898802257866 Sunset Blvd, Minneapolis, MN, 554870.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24853PRVJoshua M Gibson1945-05-01UHC-44042-2994463886315857 Oak St, Nashville, TN, 372540.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107859ENRBrandon Price—UHC-79134-7170124714745569 Desert Sky Blvd, Orlando, FL, 328540.48Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
ENR-114089ENRKeith B Olson2006-03-05UHC-20417-559494048924500 Highland Ave, Sacramento, CA, 958280.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27444PRVJonathan Dixon1985-03-13UHC-49534-8972669208686319 Ridge Rd, Minneapolis, MN, 554110.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-137373ENRTyler Y Peters2001-11-01UHC-32643-22—1544 Market St Apt 35, Fresno, CA, 937380.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-407204CLMJanet Boyd1976-01-03—7848160075711 Desert Sky Blvd, Nashville, TN, 372710.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-109380ENRJohn S Torres2008-07-24UHC-17063-4883637360478454 Forest Ave, Tucson, AZ, 857460.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102162ENRGarrett W Susan2002-01-01UHC-37392-4049389651974354 Willow Ct # 729, Tempe, AZ, 852770.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-135994ENRLisa F Evans1994-05-23UHC-03457-4461169619113982 Willow Ct, Los Angeles, CA, 900560.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21642PRVCarol Gonzalez1955-10-09UHC-52139-69—6918 Desert Sky Blvd # 784, Minneapolis, MN0.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-115767ENRAlexander S Andrews1968-12-21UHC-09924-1059064016159048 Central Ave, Chandler, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401868CLMNicholas K Andrews1985-11-19——4409 Lincoln Way, Dallas, TX0.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401869CLMNicholas K Andrews1985-11-19——4409 Lincoln Way, Dallas, TX0.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-412689CLMIsabella P Wilson—UHC-32664-9827859961028501 Spring St, San Diego, CA, 921130.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-126564ENRWei Gomez2005-03-13UHC-05045-7826097431523593 Ocean Ave Apt 16, Austin, TX, 787080.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-133355ENRStephen Cox1959-07-01UHC-59464-9927696475162758 Mountain View Dr, Gilbert, AZ, 852270.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-130966ENRAbigail F Vazquez—UHC-89341-2438333534536140 Pine Dr, Austin, TX, 787470.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
PRV-25032PRVJudith B Cunningham1999-05-20—81070944772252 Mesa Dr, Minneapolis, MN0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118094ENRCarlos Carpennter2008-06-12UHC-93262-814753030901833 Canyon Rd # 692, Scottsdale, AZ, 852070.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-420023CLMAshley Grrett1975-10-05UHC-61998-34—5074 Sage Ct, Phoenix, AZ, 850000.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131276ENRMari Q Jenkins2006-04-01UHC-85849-8971182763842486 Mountain View Dr # 977, Jacksonville, FL, 322320.48Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more
ENR-129823ENRCarlos I Evans1979-12-27UHC-89882-1666171408769503 Desert Sky Blvd, Plano, TX, 750670.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-129822ENRCarlos I Evans1979-12-27UHC-89882-1666171408769503 Desert Sky Blvd, Plano, TX, 750670.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-109324ENRNathan Schultz1968-02-18UHC-02679-1344380455964204 Highland Ave, Miami, FL, 331440.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-411339CLMAnthony Hill2003-07-19UHC-15437-91—7834 Palm Dr Apt 26, Mesa, AZ0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
PRV-25707PRVGloria Q Ross1983-08-24UHC-95778-7441842472814616 Forest Ave, Minneapolis, MN, 554980.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133743ENRStephanie Chapman——62568836107839 Main St, Gilbert, AZ, 852620.48Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
ENR-111047ENRJacob Aams—UHC-55116-7563249901185341 Oak St, Minneapolis, MN, 554560.48Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-103688ENRWillie G Rodriguez1970-07-01UHC-23786-8638141487458066 Camelback Rd, Plano, TX, 750910.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 60 of 2,000PreviousNext