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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-122368ENRAbigail H Gomez1954-05-20UHC-76184-5423423804989733 Apache Blvd, Tempe, AZ, 852560.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135189ENRLinda Mendez1987-05-08UHC-91612-2295844148849362 Willow Ct, Tempe, AZ, 852260.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-103503ENRWayne Lawrence—UHC-78593-0549593151406617 Hillcrest Rd, Chandler, AZ, 852280.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114100ENRKevin U Cunningham1942-10-27UHC-96334-5375367053544976 Cedar Ln # 439, Orlando, FL, 328130.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-130333ENRMegan Delgado—UHC-77498-4637838648198796 Bayshore Dr, San Diego, CA0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141870ENRIsabella Rse1991-01-19UHC-86613-44773242316823 Bayshore Dr, San Diego, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129812ENRKimberly U Armstrong1958-04-08—35785936611214 Palm Dr, Tucson, AZ, 857390.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121855ENRMarcus Nguyen1981-01-17UHC-61216-0860442112218499 Forest Ave, Houston, TX, 770370.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133296ENRJessica C Kennedy1986-12-27UHC-38650-3139491443442987 Ridge Rd, Mesa, AZ, 852880.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115527ENRLuis H Munoz1963-10-07UHC-84496-6556831135368503 Oak St, Atlanta, GA, 303540.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-136265ENRGrace Wong2000-12-03UHC-13056-4773566760103571 Spring St, Sacramento, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110939ENRAlex R Gutierrez1968-08-03UHC-03255-0265626872803809 Oak St, Sacramento, CA, 958110.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114793ENRSantiago Mejia1961-06-28UHC-22049-7531448040211907 Highland Ave # 446, Miami, FL, 331860.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-139933ENRFrank Powell1990-09-11UHC-17295-0226453655208797 Camelback Rd # 514, Columbus, OH, 432310.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-113914ENRPetrick Luna1983-10-03UHC-87231-0795991888872497 Baseline Rd, Jacksonville, FL, 322870.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-121963ENRAmanda Woods1938-08-27UHC-77779-1385541380891989 Sage Ct, Atlanta, GA, 303760.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117124ENRSantiago E Gray1951-10-02UHC-60144-43—2965 Camelback Rd, Atlanta, GA, 303820.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-119650ENRScott H Kim1962-07-02UHC-69089-1793228420754664 Spring St, Chandler, AZ, 852210.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-113159ENRLisa U Hayes1997-11-16UHC-48433-5861323274113266 Mountain View Dr, Plano, TX, 750530.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-115937ENRKevin Q Burke—UHC-90271-7073637411207399 Church St, Denver, CO, 802460.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-124186ENRJanice Weaver1973-10-17UHC-62096-42—1279 Oak St, Denver, CO, 802250.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-116661ENRLus Lee1965-04-28UHC-56887-7326458271807876 Bayshore Dr, Phoenix, AZ0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121418ENRMike Walker1974-05-01UHC-97961-6535477049335591 Harbor Blvd, Austin, TX0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129209ENRMaria Q Cunningham1959-10-20UHC-51601-8589880858327075 Pine Dr, Los Angeles, CA, 900080.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110684ENRPamela Jackson1959-03-14UHC-56346-66—7679 Mesa Dr, Charlotte, NC0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-135821ENRJordan J Boyd1962-06-03UHC-82021-9853396548815668 Union St Apt 1, Minneapolis, MN, 554660.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-120119ENREdward Olliver2006-04-20UHC-36016-9042946495562187 Sage Ct, Columbus, OH, 432060.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-136647ENRBrittany Peterson1980-04-14UHC-26138-4930987477414303 Elm St, Eden Prairie, MN, 553620.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-118824ENRHeather V Palmer2005-05-09UHC-37730-2147677896846747 Jefferson Ave, Los Angeles, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123804ENRLawson R Kathleen1941-07-17UHC-48976-7142853174932728 Valley View Dr Apt 10, Charlotte, NC, 282020.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-113826ENRAhmed Z Burke1958-06-22UHC-38144-7238776477452720 Spring St Apt 19, Minneapolis, MN, 554350.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-113260ENRCarolyn Moore—UHC-65072-5222049560988841 Jefferson Ave, Nashville, TN, 372230.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-119166ENRAshley Alvarado1992-05-17UHC-25866-6358583078485400 Washington St, Atlanta, GA, 303770.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
ENR-123774ENRFields O Walter1938-08-18UHC-01743-6460369302649344 Camelback Rd, Fresno, CA0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
ENR-136539ENRLgan Q Tran1997-05-11UHC-26362-9072965001554762 Canyon Rd, Plano, TX, 750570.50Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-123558ENRAmanad Fisher1970-08-21UHC-11517-2825344436135090 Willow Ct # 652, Phoenix, AZ, 850070.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136039ENRLucia Gonzalez1978-07-05UHC-77260-8976320528213897 Bayshore Dr, Sacramento, CA, 958730.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100158ENRBobby Hoffman1987-01-23UHC-04901-7791084658003548 Camelback Rd Apt 34, Denver, CO, 802900.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-139290ENRDaniels Jeremy—UHC-69692-8136992279254069 Oak St, Denver, CO, 802190.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139952ENRMarilyn Ramirez1970-06-01UHC-67599-81—8681 Spring St, Charlotte, NC0.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-124663ENRRonald Long—UHC-17595-06—3301 Oak St, Charlotte, NC, 282700.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-100752ENRJose L Fower1999-10-17UHC-49377-6730323040236354 Forest Ave, Minneapolis, MN0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-116486ENRMei Gant1950-02-14UHC-98407-6273431918363793 Lake View Rd, San Diego, CA, 921680.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-108504ENRRyan Laura1993-01-22UHC-44301-7435074820259430 Sunset Blvd, Charlotte, NC0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120091ENRBobby Torres1945-05-09UHC-38502-0186560507886470 Lake View Rd, Glendale, AZ, 853570.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108636ENRBrenda Riley1954-12-20UHC-37821-1695622030552264 Park Pl Apt 19, Scottsdale, AZ, 852750.50Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+3 more
ENR-112923ENRKimberly H Hernandez—UHC-45537-9172880668341697 Desert Sky Blvd Apt 3, Chandler, AZ, 852540.50Date of birth reformattedDate of birth unreadablePhone reformattedUnit split from street+3 more
ENR-142960ENRWilliam Thomas1966-01-16UHC-30395-0455359493506199 Cedar Ln, Seattle, WA, 981730.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133557ENRChritian BJunk2007-07-24UHC-28089-14—9378 Willow Ct, Scottsdale, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-108830ENRKimberly Z Salazar1971-04-19UHC-10291-1665671889692158 Palm Dr, Sacramento, CA, 958540.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 61 of 863PreviousNext