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-102242ENRMichael Clark2006-12-17UHC-54207-0764954722154197 Washington St # 167, Nashville, TN, 372620.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-133091ENRPatrick S Parker1986-09-01UHC-14708-32—5982 Bayshore Dr, Tempe, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
ENR-104667ENRBradley H Wallace1970-04-28UHC-69793-4174498222142777 Market St, Minneapolis, MN, 554190.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116978ENRAndrea Cole2007-01-25UHC-40033-8281653478537899 Lake View Rd # 510, San Diego, CA, 921720.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-105192ENRJennifer B Schmidt—UHC-32919-7353570910431207 Washington St, Atlanta, GA, 303600.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-105546ENRFrank X Contreras1959-06-18UHC-79195-3062850320065259 Spring St, Mesa, AZ, 852740.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131092ENRWayne V Thomas2006-10-19UHC-05470-0192531660145517 Harbor Blvd, Tampa, FL, 336640.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-136358ENRElizabeth D Watson1978-02-03UHC-04911-9961975493386379 Washington St, Tampa, FL0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-127926ENRChris U Ferguson2003-09-16UHC-41567-677735311242541 Sage Ct, Fresno, CA, 937280.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130310ENRBrittany Tucker1999-05-07UHC-67588-0571434587236765 Central Ave, Los Angeles, CA, 900780.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139110ENRScott Martin2006-07-10UHC-42759-8172474117923618 Cedar Ln, Dallas, TX, 752140.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-137198ENRChristian A Mejia1997-12-24UHC-16395-85—2684 Ridge Rd, Miami, FL, 331100.50Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-100085ENRSara R Moore1951-12-04UHC-46190-7532096639252308 Park Pl # 539, Phoenix, AZ, 850230.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-118678ENRJesse M Reyes2006-02-10UHC-88973-0527221199433997 Canyon Rd, Mesa, AZ, 852150.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-109216ENRDenise Santos1938-08-19UHC-94172-0656527349928780 Indian School Rd, Tampa, FL, 336620.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-112080ENRNancy N Rios1945-11-03UHC-06953-5235298194847547 Highland Ave, Columbus, OH, 432860.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137514ENRAna F Jimenez1958-09-01UHC-89148-48—3228 Mountain View Dr, Charlotte, NC, 282780.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-114045ENRJustin Y Wright1949-03-15UHC-64046-6798786170761629 Main St, Nashville, TN, 372040.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-113172ENRMark F Washington1964-09-02UHC-44921-9491225151414833 Grand Ave # 987, Phoenix, AZ, 850620.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130429ENRDense Young1969-11-18UHC-62842-5350531369252167 Desert Sky Blvd, Tempe, AZ, 852680.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-130430ENRDense Young1969-11-18UHC-62842-5350531369252167 Desert Sky Blvd, Tempe, AZ, 852680.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-106766ENRCynthia Wheeler1967-04-23UHC-95456-0546421456105995 Jefferson Ave, San Antonio, TX, 782560.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-134222ENRJanet Arnold—UHC-22906-0393892391461157 Main St, Tempe, AZ, 852270.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-128755ENRLauren I Herny1963-04-11UHC-79485-1473338056445723 Park Pl, Glendale, AZ, 853250.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127429ENRJean R Brown1941-01-10UHC-40230-1981072118531798 Hillcrest Rd, San Diego, CA, 921130.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-114041ENRJordan Thomas1963-10-14UHC-44081-33—5087 Ridge Rd Apt 28, Denver, CO, 802580.50Name split from “Last, First”Member ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-121951ENRJerry F Willlis1999-02-11UHC-87696-2348781867515985 Camelback Rd, Glendale, AZ, 853960.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-113102ENRTyler Welch—UHC-09460-0894523363768030 Apache Blvd, Houston, TX, 770870.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-130962ENRAllen Q Breenda1952-03-07UHC-73574-9791758856642354 Apache Blvd Apt 22, Atlanta, GA, 303450.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136773ENRRoger R Arnold1998-06-21UHC-95060-5078184410301890 Meadow Ln, Fresno, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141807ENRMateo Ortiz1968-01-20UHC-47672-9671040537849079 Grand Ave Apt 1, Austin, TX0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-139877ENRDouglas Russell1997-07-01UHC-42827-2534552524313018 Harbor Blvd, Sacramento, CA, 958720.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-119114ENRMateo Perez2003-01-14UHC-46817-6190093943522630 Maple Ave, Tampa, FL, 336360.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113572ENRJose Y Ross2005-07-10UHC-02279-479205245106477 Willow Ct Apt 3, Austin, TX, 787270.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-115709ENRLawrence Q Ramirez1998-06-26UHC-12458-1155869179245181 Desert Sky Blvd, Scottsdale, AZ, 852680.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103215ENRHeather Howard1954-04-18UHC-56509-498185394398784 Forest Ave # 867, Houston, TX, 770480.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-104024ENRChristina U Meyer1955-03-22UHC-19804-1677862795882100 Meadow Ln # 291, Los Angeles, CA, 900390.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-126261ENRArjun T Jones1979-06-19UHC-20049-5376189943815653 Spring St, Mesa, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-136838ENRWilliam M Hughes1978-01-02UHC-08089-6982245637919230 Canyon Rd, Minneapolis, MN, 554260.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-115882ENRRandy Graham1965-11-03UHC-32783-4337024373084838 Highland Ave, Fresno, CA, 937850.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115883ENRRandy Graham1965-11-03UHC-32783-4337024373084838 Highland Ave, Fresno, CA, 937850.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105336ENRJonathan Reed—UHC-35512-9194673843381324 Camelback Rd Apt 1, Tucson, AZ, 857990.50Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+3 more
ENR-142637ENRKayla Bradley1979-03-19UHC-37557-8124795971568373 Church St # 326, Las Vegas, NV0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-111532ENRAlice Tran2006-04-18UHC-63134-9826320053235978 Market St, Gilbert, AZ, 852760.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-103048ENRKaren C Silva1950-07-12UHC-48582-8498033265671395 Maple Ave, Glendale, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-123151ENRKeith C Sanders—UHC-17016-66—6170 Willow Ct, Atlanta, GA, 303420.50Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-122449ENRThomas H Chen2004-08-09UHC-89520-2027697879655392 Jefferson Ave, Chandler, AZ0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-105819ENRRian Rojas1967-03-17UHC-73873-9391576745233825 Apache Blvd, San Diego, CA, 921250.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116433ENRWayne A Sanchez——23939875263186 Harbor Blvd, Los Angeles, CA0.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131867ENRSteven U Campbell1987-11-27UHC-83825-1772571928354595 Union St, Plano, TX, 750990.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
43,101 rows, page 55 of 863PreviousNext