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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-117277ENRNathan Cruz1986-12-27UHC-61858-818128952303—0.80Name split from “Last, First”Phone reformattedPlan code upper-casedPlaceholder values cleared
ENR-126825ENRMaary Wheeler1975-09-27UHC-61948-579787075309—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-406680CLMDorothy Elliott1959-12-25—4055707594—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-419411CLMDebra Cox1993-06-22UHC-62132-15——0.80Name split from “Last, First”Member ID reformattedWhitespace trimmedPlaceholder values cleared
ENR-112026ENRTucker P Andrea1967-03-14UHC-64341-8385770168148773 Church St, San Diego, CA, 921900.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
PRV-27891PRVJoe C Harvey1970-03-07UHC-23152-2060540236987400 Spring St, Orlando, FL, 328900.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61460TPARuth Z Ross1970-04-21—53925676513071 Canyon Rd, Phoenix, AZ, 850960.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51579TPATony Wells1940-09-03—88278429296559 Mesa Dr, Gilbert, AZ, 852720.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-401963CLMAlbert Fields1969-03-03UHC-51978-3296621192793255 Union St, Minneapolis, MN, 554200.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
ENR-111452ENRJcob Y Alvarez1972-05-12UHC-93064-1721893033666151 Union St, Atlanta, GA, 303580.80Name split from “Last, First”Phone reformattedState code upper-casedPlaceholder values cleared
ENR-140864ENRPhilip Bradely1947-05-21UHC-22562-1594129656488709 Palm Dr, Jacksonville, FL, 322100.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
CLM-418675CLMCarl Burke1952-04-12UHC-45011-1121525808979767 Willow Ct, Minneapolis, MN, 554640.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
ENR-126625ENRMateo Simpson1977-01-14UHC-30934-6651249014715376 Broadway, Los Angeles, CA, 900180.80Name split from “Last, First”Date of birth reformattedEmail lower-casedWhitespace trimmed
TPA-57111TPALisa Mills1942-08-12UHC-79129-20—4582 Pine Dr, Las Vegas, NV, 891070.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-137847ENRSofia G Silva1988-03-10UHC-76570-4024035630674216 Lincoln Way, Eden Prairie, MN, 553970.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-28779PRVKyle Powell1962-10-08—5249192176—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
ENR-105139ENRJack W Perkins1943-11-03UHC-89638-3724637316249781 Harbor Blvd, Houston, TX, 770590.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-53672TPAGloria Ferguson1941-07-02UHC-59505-65——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-417608CLMAshley Montgomery1948-10-22—9675824786—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-54038TPACynthia B Elliott2007-09-02——9248 Sage Ct, San Antonio, TX, 782000.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
ENR-125309ENRCharlotte Y Cok2004-05-18UHC-82764-2183837391327644 Harbor Blvd, Dallas, TX, 752710.80Name split from “Last, First”Date of birth reformattedPhone reformattedEmail lower-cased
CLM-415324CLMMargaret Burke1993-12-13——2687 Canyon Rd, Nashville, TN, 372220.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-416799CLMFrank Weber1956-03-02UHC-60254-75——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-429106CLMAnna Murphy1944-01-18—3474330116—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-411721CLMDenise H Ross1975-07-10UHC-51808-483056469510—0.80Name split from “Last, First”Date of birth reformattedMember ID reformattedPlaceholder values cleared
ENR-120943ENRPaul L Henry1949-12-23UHC-44952-3077790248976812 Elm St, Austin, TX, 787560.80Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed
ENR-133284ENRKayla Turner2001-02-19UHC-44844-82—3027 Harbor Blvd, Tampa, FL, 336840.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-126287ENRChrstian C Watkins1996-04-09UHC-91881-939836247126956 Palm Dr, Los Angeles, CA, 900960.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-61690TPARoy Lawrence1993-06-09———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-110729ENRYuki C Wagner1980-05-17—6375562087123 Sage Ct, Nashville, TN, 372050.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-402566CLMJanice Rose1987-12-14——6492 Palm Dr, Denver, CO, 802900.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
CLM-413345CLMLawrence Anderson2001-08-07UHC-75461-1958435695676884 Meadow Ln, San Diego, CA, 921300.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
ENR-132479ENRKmberly Martinez1941-03-08UHC-26260-4326876777524974 Camelback Rd, Columbus, OH, 432090.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
ENR-138764ENROmar O Boyd1939-02-16UHC-90001-1362924455015368 Lake View Rd, Tempe, AZ, 852570.80Name split from “Last, First”Phone reformattedEmail lower-casedWhitespace trimmed
ENR-111166ENRJacob S Porter1969-10-26UHC-09627-2225651222542981 Park Pl, Chandler, AZ, 852040.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
PRV-27935PRVAdam Mendoza1956-02-27UHC-49778-068238225670—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-27954PRVJanet Fernanndez1989-04-14——8060 Ridge Rd, San Diego, CA, 921890.80Name split from “Last, First”City re-casedEmail lower-casedPlaceholder values cleared
PRV-25942PRVDoris O Sims1942-11-10UHC-56700-5987683451725650 Valley View Dr, Plano, TX, 750970.80Name split from “Last, First”Phone reformattedMember ID reformattedPlaceholder values cleared
CLM-418648CLMBiilly Weaver1953-05-24UHC-92169-3565380225771760 Pine Dr, Sacramento, CA, 958740.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-138637ENRBilly V Myers1989-05-09UHC-86282-8793925081076003 Oak St, Charlotte, NC, 282250.80Name split from “Last, First”Phone reformattedCity re-casedWhitespace trimmed
CLM-404721CLMBenjamin Morgen1941-05-03—66261924308904 Main St, Fresno, CA, 937090.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
CLM-410692CLMLori Webb1991-07-01UHC-69037-61—2854 Maple Ave, Miami, FL, 331720.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-50710TPAJerry Walsh1994-09-24——6984 Union St, Tampa, FL, 336210.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58599TPABradley Santos2004-03-03—36240431388363 Sage Ct, Phoenix, AZ, 850790.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-60415TPAArjun Jones1953-02-05—8045062354—0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-118524ENRGeorge C Aguilar1944-01-11UHC-68065-7027725102919173 Church St, Miami, FL, 331640.80Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased
TPA-53651TPASusn Estrada1995-10-02——4654 Bayshore Dr, Gilbert, AZ, 852630.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
ENR-128519ENRBetty D Jimenez1979-11-25UHC-73897-8929687714653946 Willow Ct, Jacksonville, FL, 322380.80Name split from “Last, First”Phone reformattedMember ID reformattedWhitespace trimmed
CLM-417427CLMJonathan Lopez1975-09-28UHC-56956-03——0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
CLM-430197CLMJennifer Ross1956-10-05UHC-16794-057053257982—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
9,980 rows, page 168 of 200PreviousNext