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

Provider network, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-20841PRVKaren White1986-12-06UHC-50270-0596056629019809 Ridge Rd, Jacksonville, FL, 322850.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27937PRVTeresa Porter1948-04-03—27839766169635 Maple Ave, Eden Prairie, MN0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23139PRVCarolyn H Wong1977-01-09—91842508152259 Highland Ave, Sacramento, CA, 958400.48Middle initial moved out of first nameName re-casedTwo-digit birth yearStreet suffix standardised+4 more
PRV-26764PRVCharlotte Hanson1963-05-10—79942572412618 Ridge Rd, Denver, CO, 802720.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25397PRVTerry A Medina1965-02-08——9633 Sage Ct, Eden Prairie, MN, 553160.48Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
PRV-27234PRVEugene A Robertson2001-11-10UHC-32080-4855365635218505 Palm Dr Apt 22, Columbus, OH, 432650.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-24966PRVDanielle Garza—UHC-79202-9696486310912118 Desert Sky Blvd, Charlotte, NC, 282410.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
PRV-20746PRVDiana Bennett1964-09-14UHC-02217-1664898802257866 Sunset Blvd, Minneapolis, MN, 554870.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24853PRVJoshua M Gibson1945-05-01UHC-44042-2994463886315857 Oak St, Nashville, TN, 372540.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27444PRVJonathan Dixon1985-03-13UHC-49534-8972669208686319 Ridge Rd, Minneapolis, MN, 554110.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-21642PRVCarol Gonzalez1955-10-09UHC-52139-69—6918 Desert Sky Blvd # 784, Minneapolis, MN0.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
PRV-25032PRVJudith B Cunningham1999-05-20—81070944772252 Mesa Dr, Minneapolis, MN0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25707PRVGloria Q Ross1983-08-24UHC-95778-7441842472814616 Forest Ave, Minneapolis, MN, 554980.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26495PRVBrian Coleman1948-01-28—84978609124479 Ocean Ave, San Antonio, TX, 782520.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25158PRVJose Q Austin1965-08-18—70287089837293 Camelback Rd, Plano, TX, 750650.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22493PRVMateo C Fuller1997-07-09UHC-83792-6049454348558580 Indian School Rd, Tampa, FL, 336450.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-22843PRVCharlotte Salazar1975-09-06—74036800286582 Central Ave, Atlanta, GA, 303880.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-22922PRVSharon Ellis1982-09-20—93644275628570 Maple Ave, Phoenix, AZ, 850850.48Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
PRV-24867PRVKimberly Ramirez1961-09-17UHC-25631-3594244370758356 Park Pl, Dallas, TX, 752630.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28457PRVMichael T Contreras1974-09-07UHC-41501-2942292086855364 Pine Dr, Houston, TX, 770580.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23720PRVJustin Lawrence1945-06-12UHC-56970-09—1593 Spring St, Miami, FL0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22742PRVDanielle Anderson——42772724308155 Church St, Charlotte, NC, 282840.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21100PRVSofia Oliver1982-08-21UHC-82300-20—3300 Meadow Ln, Las Vegas, NV, 891490.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
PRV-28879PRVSofia Y Bowman1964-11-20UHC-32544-4959563841393843 Baseline Rd, Scottsdale, AZ, 852290.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-27065PRVAisha Gilbert1971-08-08—50395668808619 Elm St Apt 13, Houston, TX, 770470.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-20566PRVKatherine Montgomery1996-08-07UHC-26954-3793255450906855 Sunset Blvd, Tempe, AZ0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21243PRVMarilyn Wyllis1997-06-15UHC-30752-1282729270438924 Grand Ave, Atlanta, GA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27056PRVLisa Wnog1966-09-13UHC-10089-2059155788256788 Oak St, Tucson, AZ, 857220.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-27837PRVRalph Kelley1975-09-22UHC-28952-8283958799041320 Pine Dr, Tempe, AZ0.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
PRV-20802PRVAlan Brown2004-01-08UHC-69982-03—740 Central Ave Apt 13, Phoenix, AZ, 850770.48Name split from “Last, First”Member ID reformattedUnit split from streetStreet suffix standardised+4 more
PRV-25996PRVMelissa I Gibson1965-07-09—29821108859252 Mesa Dr, Mesa, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-24354PRVGeorge M Bell———3580 Spring St, Seattle, WA, 981500.48Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+4 more
PRV-27681PRVLauren Peters1984-07-16—22528577911420 Oak St, Glendale, AZ, 853920.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-24892PRVAlan Scott1949-04-18—66647921257774 Forest Ave, Chandler, AZ, 852820.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-26886PRVMadisn D Kelly1952-05-25—42780036595238 Sage Ct, Nashville, TN, 372750.48Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
PRV-20641PRVMateo Tran1990-12-01—4139778715849 Elm St, San Antonio, TX, 782070.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21875PRVTyler Dean2004-08-17—56687124794144 Canyon Rd, Seattle, WA, 981770.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-24255PRVEthan Ramirez1970-07-10—87664456045724 Mountain View Dr, Tucson, AZ, 857110.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20212PRVCharlotte Bryannt1993-09-22UHC-51096-9785882005124266 Union St, Denver, CO, 802300.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-21496PRVElijah X Flores——51442825167879 Market St, Los Angeles, CA, 900400.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25801PRVRachel O Wagner1967-02-28UHC-69511-6968843017023551 Palm Dr, Columbus, OH, 432100.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28614PRVSandra T Howell1940-08-19—57080353651797 Meadow Ln, Mesa, AZ, 852660.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-25679PRVWayne Lopez1988-09-08—48463262611771 Canyon Rd, Jacksonville, FL, 322180.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-22628PRVMei Johnston1938-01-05—50931517173813 Sunset Blvd, Charlotte, NC, 282430.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23054PRVKenneth V Sanders—UHC-49739-30—5503 Jefferson Ave, Nashville, TN, 372740.48Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
PRV-23479PRVJulie J Wilson—UHC-76381-4128594761319127 Pine Dr # 522, Columbus, OH, 432490.48Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more
PRV-23044PRVAmber Perez1943-10-25UHC-24581-9940130117686547 Union St, Nashville, TN, 372440.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-20138PRVDebra W Davis1986-02-13——1252 Church St Apt 30, Orlando, FL0.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-27712PRVCarl Sims1953-05-05——2766 Desert Sky Blvd, Plano, TX, 750780.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26571PRVRuth W Ford1973-12-26UHC-28799-2972195637123627 Desert Sky Blvd # 189, Tempe, AZ, 852170.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
9,596 rows, page 7 of 192PreviousNext