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-110320ENRJoan Ellis2007-12-16—44977793183040 Willow Ct, Atlanta, GA0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121552ENRJeremy O Bizhop1971-03-21UHC-33995-1239680422037906 Lake View Rd, Minneapolis, MN, 554500.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-138765ENRMargaret Hanson1994-05-23UHC-18541-055189797677614 Lake View Rd, Charlotte, NC, 282680.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-138146ENRCatherine T Harrison—UHC-57587-4170157021168631 Bayshore Dr, Plano, TX, 750310.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-140894ENRArjun M West1942-08-06UHC-19962-7950585163657968 Main St, Jacksonville, FL0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-141753ENRBruce Sandoval1945-12-02UHC-23741-56—2479 Mesa Dr, Mesa, AZ, 852820.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-107420ENRNicholas Alvarado1951-11-27UHC-40551-4898962613574682 Baseline Rd, Eden Prairie, MN0.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-140212ENRSophia M Soto1949-02-25UHC-01510-2956224365618505 Ridge Rd # 709, Jacksonville, FL, 322870.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-107872ENRPhilip A Gibson1968-03-08UHC-90044-5470871592019675 Highland Ave Apt 23, Minneapolis, MN, 554480.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-122731ENRLuis C Payne—UHC-99621-9475428274229208 Baseline Rd Apt 19, Houston, TX, 770570.52Name re-casedDate of birth unreadablePhone reformattedUnit split from street+2 more
ENR-100229ENRAlexis M Jensen1969-07-01UHC-56840-4433651676146717 Pine Dr, Phoenix, AZ, 850670.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102046ENRRichard P Stewart1997-01-27UHC-90730-92—524 Mountain View Dr, Miami, FL0.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-107984ENRScott L Kim1949-12-21UHC-98455-8677247424073083 Ocean Ave, Tempe, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110873ENRMarcus P Parker1974-11-24UHC-90476-5892944086418429 Camelback Rd, Chandler, AZ, 852550.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-120454ENRSean A Fisher—UHC-79579-4171088553812407 Market St, San Diego, CA, 921480.52Date of birth unreadablePhone reformattedState name converted to codeGender normalised+2 more
ENR-139633ENRAlan P Gilbert———7071 Union St, Columbus, OH, 432980.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-116245ENRJeffrey C Cruz1953-02-14UHC-64784-69—6155 Ocean Ave # 695, Nashville, TN, 372110.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-112428ENRJoan Dominguez2006-01-28UHC-90621-1934738734363534 Canyon Rd # 389, Miami, FL, 331190.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-125705ENRPhilip Ferguson1991-08-28UHC-35676-8834826703248340 Desert Sky Blvd, Tucson, AZ, 857090.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142606ENRNathan A Palmer2006-09-05UHC-74591-49—4351 Elm St, Scottsdale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-138594ENRRussell T Simpson1976-04-09UHC-87350-8450163092469007 Palm Dr, Tampa, FL, 336430.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110428ENRFrank Franklin2003-09-11UHC-27271-2459145124967574 Broadway # 630, Phoenix, AZ, 850200.52Date of birth reformattedUnit split from streetAddress re-casedZIP+4 trimmed+2 more
ENR-135283ENREthan M Rogers1938-12-18UHC-76883-3286943895331672 Spring St # 140, San Antonio, TX, 782510.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-142248ENRLinda Reid1941-09-26UHC-59494-8930650053393931 Harbor Blvd, San Diego, CA, 921040.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-140080ENREthan Ramos—UHC-82654-9054198926946394 Main St, Eden Prairie, MN, 553270.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122451ENRCarlos Holmes1945-12-12UHC-63535-5297872314085894 Cedar Ln, Mesa, AZ, 852590.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-105101ENRArthur L Guzman1971-05-06UHC-34464-2563096284443255 Market St, Mesa, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-119566ENRCarolyn P Spencer2001-05-09UHC-57300-9333258926197047 Mesa Dr, Tucson, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-116059ENRMary S Ellis1954-11-08UHC-94061-2661969877675588 Palm Dr Apt 31, Jacksonville, FL, 322820.52Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
ENR-130365ENRRobert M Sanchez—UHC-14192-8447283196053138 Meadow Ln, Jacksonville, FL, 322540.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-143068ENRFrances E Mendez2000-10-09UHC-31146-68—6052 Market St, Nashville, TN, 372380.52SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-124291ENRJordan Y Hill1979-05-24UHC-65651-73—9487 Church St, Tampa, FL, 336950.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-119334ENRSamuel Y Vargas1949-09-18UHC-39371-85—3642 Apache Blvd, Atlanta, GA, 303740.52Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+2 more
ENR-120431ENRPaul C Lewis1972-03-11UHC-89738-3768373860458134 Harbor Blvd, Houston, TX, 770030.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-132892ENRLogan Parkar1994-07-10UHC-13216-29—7040 Willow Ct, Gilbert, AZ, 852350.52Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+2 more
ENR-137888ENRDaniel F Ward—UHC-94840-2030392098182104 Palm Dr, Denver, CO, 802940.52Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+2 more
ENR-105313ENRPriya S Pena2004-10-22UHC-70426-2390086855745528 Willow Ct, Mesa, AZ, 852270.52Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
ENR-129082ENRTimothy Harris1960-08-08UHC-02413-6936332749851631 Lincoln Way, Los Angeles, CA, 900030.52Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more
ENR-137523ENRBryan Q Fernandez2008-11-21UHC-35162-9337839171683502 Spring St, Fresno, CA, 937890.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-105032ENRBobby X Moreno1969-02-07UHC-17565-73—1957 Baseline Rd, Tampa, FL, 336270.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-124064ENRTimothy Schultz2002-01-10UHC-79336-3452142564233983 Cedar Ln, Scottsdale, AZ, 852220.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-124636ENRPatricia K Patel2001-03-24UHC-80415-3057894161592379 Apache Blvd, Mesa, AZ, 852200.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124506ENRAshley A Jensen1970-09-01UHC-25086-5345176940974415 Market St, San Diego, CA0.52Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-136568ENRChristina N Obrien1948-01-25UHC-57093-3345434135433904 Park Pl, Eden Prairie, MN, 553180.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-126932ENRKathleen B Rice—UHC-07246-9461751071219857 Main St, Tampa, FL, 336530.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-130655ENRMegan Q Snyder1964-08-06UHC-93058-5473746861796921 Camelback Rd, Sacramento, CA, 958970.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111654ENRBJunk2000-07-15UHC-49072-2453545991226548 Bayshore Dr, Mesa, AZ, 852450.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-119657ENRSteve C Nichols1945-05-04UHC-56677-0595525396073615 Sunset Blvd, Los Angeles, CA, 900380.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-111039ENRMason A Maldonado1982-10-08UHC-54625-23—1570 Union St # 121, Tampa, FL, 336040.52Two-digit birth yearMember ID reformattedUnit split from streetGender normalised+2 more
ENR-121888ENRMaatthew X Cruz1944-06-17UHC-91463-54—7979 Pine Dr # 573, Eden Prairie, MN, 553740.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 87 of 863PreviousNext