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-22943PRVRonald A Scott—UHC-68475-54—9242 Grand Ave, Phoenix, AZ, 850100.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29107PRVKevin Hoffman2006-10-27UHC-32542-8489280827003210 Park Pl, Miami, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-20981PRVWilliam Cruz1964-02-18—85041050998853 Baseline Rd Apt 15, Chandler, AZ, 852090.68Phone reformattedUnit split from streetGender normalisedPlaceholder values cleared
PRV-21323PRVKenneth Jordan————0.68Date of birth unreadablePhone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-29386PRVSamantha Fuller1941-11-24—24570971604633 Cedar Ln, Charlotte, NC, 282220.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20403PRVAlbert P Clrk1977-05-15———0.68Name re-casedPhone missing area codeGender normalisedPlaceholder values cleared
PRV-23702PRVMadison Richards1946-11-09—42094733204785 Cedar Ln, Gilbert, AZ, 852760.68Phone reformattedState name converted to codeGender normalisedPlaceholder values cleared
PRV-26388PRVSantiagoJunk1972-01-21—2417300455172 Jefferson Ave, Glendale, AZ, 853630.68Phone reformattedState name converted to codePlaceholder values clearedNo usable name (quarantined)
PRV-29574PRVOlivia Roes1987-06-10UHC-89527-37—483 Mesa Dr, Miami, FL, 331610.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23691PRVEmily Murray1992-02-20UHC-96474-996767586829—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
PRV-26951PRVPamela Johnston1979-07-12UHC-19171-30—4813 Oak St, Orlando, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-26643PRVSofia Hicks1952-05-23—95370664471685 Church St, Phoenix, AZ, 850600.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-23185PRVPameela Simpson1941-05-06—69522141743913 Baseline Rd, Scottsdale, AZ0.68Two-digit birth yearPhone reformattedZIP missingPlaceholder values cleared
PRV-22094PRVCharles Richards1999-10-04UHC-80345-1631933321987872 Hillcrest Rd, San Antonio, TX, 782010.68Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed
PRV-24970PRVJanice Medina1981-01-11—61045172078146 Lincoln Way, Tucson, AZ, 857360.68Phone reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-28183PRVKye L Weber1987-08-09UHC-48005-0396836459389279 Forest Ave, San Diego, CA0.68City re-casedZIP missingGender normalisedPlaceholder values cleared
PRV-21331PRVChristopher Mendez1967-07-10UHC-51704-1277092344232371 Union St, Gilbert, AZ, 852810.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-26436PRVAisha Hernandez2005-10-20——4692 Jefferson Ave, San Diego, CA, 921390.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23291PRV—Junk1957-02-01UHC-03087-94—1165 Oak St, Tucson, AZ, 857860.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
PRV-26793PRVJefffrey Payne1966-11-15———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27320PRVDylan Harper1993-07-23UHC-06152-8663823687272458 Palm Dr, Tampa, FL, 336430.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26118PRVDonald U Li1938-05-07UHC-27526-41—3587 Desert Sky Blvd, Phoenix, AZ, 850480.68Name split from “Last, First”Middle initial moved out of first nameWhitespace trimmedPlaceholder values cleared
PRV-29048PRVPatricia King1967-06-23UHC-26700-9448727818685936 Willow Ct, Dallas, TX, 752460.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
PRV-20867PRVLarry Z Fields1965-01-26UHC-33543-82—9784 Forest Ave, Houston, TX, 770600.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
PRV-20866PRVLarry Z Fields1965-01-26UHC-33543-82—9784 Forest Ave, Houston, TX, 770600.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
PRV-22177PRVMadison O Garrett1942-04-18UHC-53981-253276414185—0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-25696PRVTheresa A McDonald——7657923963—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
PRV-26107PRVVirginia Butelr2007-10-13UHC-66385-7123735124512022 Spring St, Las Vegas, NV, 891630.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21259PRVPatrick Gutierrez1993-10-02UHC-38230-55—6794 Cedar Ln, Mesa, AZ, 852750.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-29506PRVJula Feilds1992-07-08UHC-03539-69—7380 Bayshore Dr, Phoenix, AZ, 850500.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24708PRVZachary Rogers1980-11-20UHC-85497-8752037766224290 Ridge Rd, Eden Prairie, MN, 553100.68Phone reformattedStreet suffix standardisedAddress re-casedGender normalised
PRV-23764PRVJason Lopez1994-12-09UHC-54594-3259142591325705 Desert Sky Blvd # 743, Minneapolis, MN, 554590.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21960PRVDonald Castillo1942-07-26—51834242882970 Market St, Phoenix, AZ0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
PRV-25743PRVKayla McDonald2004-09-08UHC-78221-664042634903—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-28805PRVEmily Smith2002-12-16—5906622794709 Spring St, Miami, FL, 331130.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-26536PRVPamela I Lucas1970-12-01—29278289821073 Church St, Las Vegas, NV, 891860.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-26273PRVCarol Rose1975-01-26UHC-39091-36—4217 Willow Ct, Tampa, FL, 336390.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28557PRVCarlos Webb1949-12-20—87830401237922 Canyon Rd, Tempe, AZ, 852420.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
PRV-24620PRVBradley X Vazquez1989-07-07UHC-39551-6139794797211527 Cedar Ln, Plano, TX, 750440.68Two-digit birth yearPhone reformattedState name converted to codePlaceholder values cleared
PRV-25694PRVLaura Z Morris1955-05-12UHC-18122-11—6637 Washington St, San Antonio, TX, 782330.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25765PRVJames Long1972-08-16—28978388446078 Mountain View Dr, Nashville, TN, 372510.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-22056PRVCarol R Clark1989-01-03——6078 Lincoln Way, Columbus, OH, 432260.68Name re-casedTwo-digit birth yearPhone missing area codePlaceholder values cleared
PRV-28365PRVDinaa Freemna2005-02-21UHC-59043-73—8283 Ocean Ave, San Diego, CA, 921710.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29469PRVMichelle Z Alvarez——98827350279370 Hillcrest Rd, Tempe, AZ, 852350.68Middle initial moved out of first nameDate of birth missingPhone reformattedPlaceholder values cleared
PRV-22652PRVEugene Collins2005-05-18—86435028921653 Highland Ave # 905, Tempe, AZ, 852210.68Phone reformattedUnit split from streetGender normalisedPlaceholder values cleared
PRV-25069PRVMei Wilson1978-03-11UHC-28950-12—3147 Lincoln Way, Charlotte, NC0.68Two-digit birth yearZIP missingWhitespace trimmedPlaceholder values cleared
PRV-24191PRVStephen B Hayes1945-03-09——5994 Willow Ct, Scottsdale, AZ, 852640.68Two-digit birth yearCity re-casedState name converted to codePlaceholder values cleared
PRV-29225PRVMaosn Q Stone1983-10-10——5591 Park Pl, Glendale, AZ, 853920.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-23544PRVKathleen Bryant1993-08-19——5236 Mesa Dr, Scottsdale, AZ, 852880.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20171PRVRoger Bell1986-11-02UHC-49797-359578753466—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 72 of 192PreviousNext