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-26019PRVDaniel Q Soto1985-08-17—57481524571606 Broadway, Seattle, WA, 981750.64Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more
PRV-27597PRVBarbara Little1987-04-01UHC-84382-79—629 Spring St, Sacramento, CA, 958410.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
PRV-24003PRVTucker Pamela1974-08-08—21890757487360 Jefferson Ave, Atlanta, GA, 303850.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-25781PRVJacob K Arnold1945-11-04UHC-45585-1342991782124195 Jefferson Ave, Minneapolis, MN, 554270.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-22923PRVMelissa Reyes1989-06-10UHC-62424-6525796761128766 Hillcrest Rd, Los Angeles, CA, 900340.64Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more
PRV-22667PRVDoris Stewart1968-03-04UHC-07596-6461945110775776 Sage Ct, Minneapolis, MN, 554800.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-22695PRVJack W Delgado1978-12-01——928 Harbor Blvd, Tucson, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-27952PRVPirya Little1949-11-22—75281682429710 Desert Sky Blvd, Columbus, OH, 432130.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25331PRVDylan Watkins1957-02-07—62632978887577 Highland Ave, Glendale, AZ, 853780.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29573PRVMadison U Thomas1945-05-25—38538632899336 Maple Ave, Minneapolis, MN, 554400.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20676PRVOlivia Hart1976-10-26——9622 Highland Ave Apt 18, Houston, TX, 770170.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-24903PRVAlexander Perkins—UHC-60662-97716433639526 Camelback Rd, Plano, TX, 750580.64Name re-casedDate of birth unreadablePhone reformattedGender normalised+2 more
PRV-26770PRVBradley Rodriguez1956-08-20—44228750806966 Canyon Rd, Tampa, FL, 336200.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-23639PRVJeremy Vega1950-08-16UHC-56071-6567581859891820 Park Pl, Sacramento, CA0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26898PRVMat Bradley1974-06-22UHC-67838-8347760244058537 Baseline Rd, Glendale, AZ, 853000.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21419PRVMary Obrien1951-01-03——6414 Valley View Dr, Plano, TX, 750740.64Name split from “Last, First”Name re-casedStreet suffix standardisedAddress re-cased+2 more
PRV-28778PRVJack Pierce—UHC-70363-83—8375 Spring St, Eden Prairie, MN, 553370.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
PRV-20482PRVJames Russell——24656004848345 Church St, Denver, CO, 802830.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
PRV-21654PRVDorothy Herrera1952-04-24——6298 Broadway, Fresno, CA, 937670.64Date of birth reformattedPhone missing area codeZIP+4 trimmedEmail lower-cased+2 more
PRV-20720PRVBrandon Rivera2006-08-16UHC-83841-16—4526 Jefferson Ave, Gilbert, AZ, 852800.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
PRV-21402PRVThomas Kelly2007-01-02—22970691265871 Highland Ave, Charlotte, NC, 282610.64Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+2 more
PRV-22394PRVRebecca Z Burns1988-10-20—80173632343762 Cedar Ln, Eden Prairie, MN0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22505PRVAlyce Q Salazar2002-02-23UHC-78437-1520867410317779 Maple Ave, Mesa, AZ, 852230.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-25248PRVCarlos Thomas—UHC-95358-0958564351434110 Camelback Rd, Mesa, AZ, 852670.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
PRV-28646PRVRyan Price1972-08-09——6961 Market St, Mesa, AZ, 852900.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-20021PRVJeremy G Frnklin1974-09-25UHC-69691-36—3588 Jefferson Ave, Houston, TX, 770630.64Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+2 more
PRV-25339PRVAustin Thomas2004-05-28—20433201449416 Ocean Ave, Sacramento, CA, 958590.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-28942PRVEric Owens1963-08-24UHC-64461-9922777603431197 Willow Ct, Orlando, FL, 328720.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22229PRVAbigail Kelley——23257785143540 Harbor Blvd, Seattle, WA, 981720.64Date of birth unreadablePhone reformattedEmail lower-casedGender normalised+2 more
PRV-28636PRVMegan Elliott1999-03-18UHC-54964-91—2593 Harbor Blvd, Orlando, FL, 328220.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-22723PRVKlely C West1954-10-06—91920043467793 Main St, San Diego, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-25713PRVWalter Y Richards1971-02-20—56761544641942 Highland Ave, Chandler, AZ, 852510.64Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21079PRVOmar B Knight1954-03-18UHC-76996-5471952937406084 Grand Ave, Phoenix, AZ, 850900.64Name re-casedTwo-digit birth yearMember ID reformattedZIP+4 trimmed+2 more
PRV-21078PRVOmar B Knight1954-03-18UHC-76996-5471952937406084 Grand Ave, Phoenix, AZ, 850900.64Name re-casedTwo-digit birth yearMember ID reformattedZIP+4 trimmed+2 more
PRV-21448PRVBilly X Mendez1959-05-15—79381479361872 Willow Ct, Miami, FL, 331000.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-21450PRVPeter Wallace1974-02-10UHC-28274-4178158725061572 Lake View Rd, Tampa, FL, 336220.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21645PRVVincent Schmidt2007-12-17—81969188071891 Camelback Rd, Gilbert, AZ, 852270.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25263PRVWayne Castro1950-09-06——2524 Baseline Rd Apt 22, Sacramento, CA, 958620.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
PRV-29582PRVDoris Meyer1960-12-20——7944 Valley View Dr Apt 25, Plano, TX, 750360.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-27365PRVDebra N Schmidt1941-08-21UHC-39182-52—1984 Jefferson Ave, Tempe, AZ, 852320.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-21598PRVNathan Tucker1982-07-18—5058955843573 Union St, Houston, TX, 770090.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24248PRVJudith Wod2002-11-27UHC-06905-9520438513825083 Desert Sky Blvd # 551, Mesa, AZ, 852050.64Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
PRV-26117PRVRoger Carr1985-11-04—82535519505490 Sunset Blvd, Mesa, AZ, 852090.64Date of birth reformattedPhone reformattedState name converted to codeGender normalised+2 more
PRV-28497PRVKathrny Cooper2000-07-27——2987 Spring St, San Antonio, TX, 782360.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-27315PRVNicole Gilbert1951-01-25UHC-93489-4277028183606879 Market St, Orlando, FL, 328530.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28846PRVHannah Flores1954-07-12—59771601997702 Main St # 610, Minneapolis, MN, 554320.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-23274PRVMaria Gray1994-12-02UHC-06693-1632950022987226 Lincoln Way, Charlotte, NC, 282080.64Name re-casedTwo-digit birth yearPhone reformattedState code upper-cased+2 more
PRV-24567PRVJacob Medina1940-11-12UHC-52242-332084056695898 Jefferson Ave, Glendale, AZ, 853820.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-23086PRVAhmed Robertson1973-04-27——9758 Valley View Dr, Sacramento, CA, 958480.64Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-29248PRVFranklin Isabella1973-04-07UHC-14942-32—7906 Indian School Rd, San Diego, CA, 921540.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 46 of 192PreviousNext