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-127592ENRMaggie Dean2000-06-07UHC-39451-7951496111062873 Maple Ave Apt 39, Tampa, FL, 336740.50Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-117163ENRCatherine L Peters1960-04-22UHC-57239-936722681200387 Park Pl, Tucson, AZ, 857760.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116194ENRSalazar Logan2007-03-09UHC-81920-7585445009314954 Union St, Charlotte, NC, 282660.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142081ENRWayne Li1960-01-10UHC-00692-9461846141687279 Mountain View Dr, Jacksonville, FL, 322650.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-124382ENRAhmed P Silva1965-07-09UHC-49438-0525179856389183 Elm St # 922, Scottsdale, AZ, 852990.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-103274ENRDon Alvarado1955-01-02UHC-30276-2060675774308594 Central Ave, Austin, TX, 787690.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115209ENRGary King1974-08-05UHC-19513-9045346718576406 Camelback Rd Apt 27, Columbus, OH, 432110.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-117432ENRJonathan I Pierce—UHC-45594-5627471589964558 Ocean Ave, Chandler, AZ, 852370.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-125041ENRHannah I Hoffman1968-04-15UHC-34504-2128145441164655 Oak St, Atlanta, GA0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-122812ENRRoger V Howard1945-02-23UHC-89900-2588350599443622 Sage Ct, Austin, TX, 787700.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-120476ENRJerry Dunn1939-06-05UHC-68186-754936428640658 Washington St, Columbus, OH, 432950.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136493ENRArthur N Santos1994-07-02UHC-64643-1870434283009820 Market St, Fresno, CA, 937760.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-126388ENRElizabeth O Graham1997-12-27UHC-13821-547038848580342 River Rd, Plano, TX, 750350.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-100538ENRDavid T Padilla1952-11-13UHC-51025-4752890819985065 Hillcrest Rd, Tampa, FL, 336330.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
ENR-128625ENRLauren N Garza1939-08-06UHC-35044-2848456046017624 Church St, Phoenix, AZ, 850360.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122548ENRLawrence U Grant1966-01-19UHC-64977-8930080605463509 Sunset Blvd, Tempe, AZ, 852690.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-133408ENRLogan M Reed1959-07-22UHC-34426-6424227578978131 Highland Ave, Sacramento, CA, 958240.50Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-116397ENRCynthia X Dunn1973-06-23UHC-08495-0274124171915109 River Rd, Nashville, TN0.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114352ENRBoyd N Carl1942-12-18UHC-08601-3636422286708407 Washington St, Mesa, AZ, 852690.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101844ENRSophia W Pierce1973-09-23UHC-04501-4247666937776744 Desert Sky Blvd, Glendale, AZ, 853820.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-133452ENRDouglas L Arnold1991-03-01UHC-22169-6091872583614155 Lincoln Way, Tampa, FL, 336200.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106215ENRHarold B Ortega1974-01-26UHC-31718-0150557593039698 Ridge Rd, San Diego, CA, 921180.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-137090ENRCheryl Yang2003-02-03UHC-63563-1674729064483370 Bayshore Dr # 978, Jacksonville, FL, 322350.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-117855ENRLaura Mason1979-10-02UHC-27169-905362474745259 Central Ave, Los Angeles, CA, 900440.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-110079ENRPatricia G Aguilar1953-02-23UHC-00064-3292245344675789 River Rd, Nashville, TN, 372020.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-121673ENRSantiago White1956-03-09UHC-90732-5430154932849371 Canyon Rd Apt 16, Orlando, FL0.50Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-102346ENRJordan Armstrong1990-06-22UHC-21547-0472249671675162 Bayshore Dr, San Antonio, TX0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126447ENRKimberly G Reynolds1995-06-10UHC-53253-1180790700955724 Elm St, Austin, TX, 787410.50Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-142370ENRJacqueline O Sullivan1951-10-08UHC-00042-81—211 Ocean Ave, Glendale, AZ, 853720.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-122693ENRSean Nguyen2004-05-04UHC-10988-1083299016896219 Cedar Ln, Atlanta, GA, 303820.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-120232ENRCarolyn Fisher1959-11-11UHC-40205-9930171464991539 Apache Blvd, Tucson, AZ0.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101266ENRJustin Ortiz1956-12-05UHC-24168-0754667478248585 Maple Ave, Columbus, OH, 432630.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-110578ENRRachel O Romero1978-10-03UHC-05946-5360384439453385 Hillcrest Rd # 858, Jacksonville, FL0.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-133151ENRLarry Li2001-07-08UHC-08701-85—3403 Willow Ct # 558, Miami, FL, 331610.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-113407ENRAlice C Lane1961-02-10UHC-89889-4142226463361232 Mesa Dr # 773, Nashville, TN, 372880.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-128889ENRJanet W Aguilar1959-11-13UHC-58854-6235565633314575 Church St, Tucson, AZ, 857140.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-111298ENRCarol M Espinoza1980-12-21UHC-76825-6444560535086265 Palm Dr, Tempe, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-114714ENRDylan Vasquez2005-08-04UHC-72211-2164778012286703 Oak St, Atlanta, GA, 303600.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111949ENRJacob W Fowler1940-06-26UHC-65588-2744271175832147 Valley View Dr, Miami, FL, 331400.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139419ENRPatricia E Foster1974-04-19UHC-51732-0470838028432238 Spring St, Los Angeles, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110959ENRMelissa U Parker—UHC-58335-2542321372685230 Cedar Ln # 756, Sacramento, CA, 958330.50Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-105852ENRJerry P Wheeler1977-06-17——4541 Meadow Ln, Atlanta, GA, 303440.50Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-109144ENRSamantha Romero1995-12-10UHC-89166-23—3469 Mountain View Dr, Scottsdale, AZ, 852920.50Date of birth reformattedPhone missing area codeMember ID reformattedState name converted to code+3 more
ENR-120831ENRJulie Ellis2004-01-14UHC-65562-6452190714404689 Highland Ave, Atlanta, GA, 303020.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-106576ENRSamuel Cruz1982-01-09UHC-58921-6184872679469457 Church St, Scottsdale, AZ, 852330.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-109455ENRMason Mitchell1981-09-23UHC-11047-2283662974548653 Union St Apt 14, Minneapolis, MN, 554970.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-104077ENRJoshua Ferguson1965-08-06UHC-22094-518657131489352 Park Pl Apt 18, Fresno, CA, 937320.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-110150ENRSteven Y Park1941-01-23UHC-23541-9755067396698298 Main St # 622, Sacramento, CA, 958450.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125565ENRDebra Cox1993-06-22UHC-62132-1528290831258967 Desert Sky Blvd, Columbus, OH, 432970.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-139747ENRCynthia C Williams—UHC-21317-7245720671955152 Valley View Dr, Orlando, FL, 328960.50Name split from “Last, First”Date of birth missingPhone reformattedMember ID reformatted+3 more
43,101 rows, page 50 of 863PreviousNext