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-22530PRVRachel Ford2006-09-06—24246921249233 Pine Dr, Minneapolis, MN, 554860.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-29397PRVElizabeth P Owens1949-09-17UHC-81340-308548711123163 Oak St, Houston, TX, 770260.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-22368PRVYuki Dominguez1982-09-13—57335522652794 Camelback Rd, Nashville, TN, 372910.70ZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-24187PRVJacqueline J Montgomery1946-10-28—65987983714351 Harbor Blvd, Eden Prairie, MN, 553440.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-20310PRVMason H Sanchez2001-03-12UHC-57803-7944233468519677 Camelback Rd, Tempe, AZ, 852400.70Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-29168PRVDaniel A Fowler1974-12-04——9441 Broadway, Atlanta, GA, 303000.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
PRV-28112PRVGrace Wong1999-12-03UHC-13056-47——0.70SSN last four extractedGender normalisedPlaceholder values cleared
PRV-27511PRVNathan R Clark1941-01-15UHC-81651-122929846918—0.70Middle initial moved out of first nameGender normalisedPlaceholder values cleared
PRV-23071PRVLucia S Mendoza1978-09-11—7059742980—0.70Name split from “Last, First”Middle initial moved out of first namePlaceholder values cleared
PRV-28991PRVJudith Morgan—UHC-85227-494493674179112 Meadow Ln # 869, Chandler, AZ, 852230.70Date of birth unreadableUnit split from streetPlaceholder values cleared
PRV-27409PRVGary Delgado1945-02-08——8879 Valley View Dr, Fresno, CA, 937670.70ZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-27608PRVDouglas B Sims1987-01-18UHC-75923-17——0.70Phone missing area codeGender normalisedPlaceholder values cleared
PRV-20977PRVBruce G Cooper1967-06-28—8924544397—0.70Two-digit birth yearGender normalisedPlaceholder values cleared
PRV-24693PRVKayla E Simmns1946-05-05—47790480635269 Ridge Rd # 318, Gilbert, AZ, 852230.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
PRV-28246PRVMegan Z Marquaz1990-06-14UHC-86538-0279646739884790 Washington St, Mesa, AZ, 852380.70Two-digit birth yearZIP+4 trimmedPlaceholder values cleared
PRV-27948PRVMary T Gibson2003-10-10UHC-23222-2227639010424420 Desert Sky Blvd, Atlanta, GA, 303390.70Street suffix standardisedAddress re-casedState name converted to code
PRV-22413PRVCamila W Sandoval1983-09-18UHC-60824-5945921791675221 Broadway Apt 16, Seattle, WA, 981420.70Middle initial moved out of first namePhone reformattedUnit split from street
PRV-28376PRVVirginia Kim1945-08-11——4941 Mesa Dr, Las Vegas, NV, 891320.70Phone missing area codeGender normalisedPlaceholder values cleared
PRV-29205PRVMei Thomas1976-12-22UHC-27268-6124871909345547 Union St, Sacramento, CA, 958710.70ZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-25990PRVBryan B Scott1944-04-17UHC-74488-4676525084259632 Lincoln Way, Tempe, AZ, 852020.70Street suffix standardisedAddress re-casedGender normalised
PRV-24232PRVNancy Wright1984-01-05—60737732181451 Grand Ave, Seattle, WA, 981110.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
PRV-23440PRVSamantha Welch1970-08-20—43088651833081 Jefferson Ave, San Antonio, TX, 782340.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-25379PRVPatrikk C Ortega1990-09-09—83156547253527 Canyon Rd, Atlanta, GA, 303060.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-26069PRVOmar Allen1997-07-16UHC-06383-6577546761555570 Lincoln Way, Charlotte, NC, 282980.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
PRV-28092PRVJoyce Chapman2007-02-23UHC-27758-5735144924777447 Canyon Rd, Tempe, AZ, 852220.70ZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-24538PRVMariana R Valdez1982-11-22UHC-75813-69—1961 Apache Blvd, Dallas, TX0.70State name converted to codeZIP missingPlaceholder values cleared
PRV-25879PRVAnn Singh1944-09-18UHC-68432-82—1013 Camelback Rd, Fresno, CA, 937200.70Phone missing area codeGender normalisedPlaceholder values cleared
PRV-22312PRVDenise Q Lane——38636161408532 Sage Ct, Houston, TX, 770410.70Middle initial moved out of first nameDate of birth unreadablePlaceholder values cleared
PRV-25750PRVJeremy H Gomez—UHC-62554-77—5315 Mesa Dr, Minneapolis, MN, 554620.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
PRV-26606PRVDylan Gibson2002-01-13UHC-54125-6467570981808165 Meadow Ln, Jacksonville, FL, 322640.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28955PRVKimberly Vega1961-03-18UHC-98431-6381225070269577 Spring St, Nashville, TN, 372170.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25740PRVNah Roberts1953-07-09UHC-09396-3868583620985412 Main St, Mesa, AZ, 852160.72Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-29221PRVJennifer Schmidt2003-07-05UHC-29055-6560647506353969 Camelback Rd, Los Angeles, CA, 900960.72Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25302PRVDiane Contreras1963-08-17UHC-13930-9546684530807134 Sage Ct, Fresno, CA, 937040.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-22461PRVStephen Reyes1960-07-03—66677248356423 Harbor Blvd, Mesa, AZ, 852690.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-26144PRVYuki Simpson1971-08-19UHC-94703-7723589920905732 Maple Ave, Austin, TX, 787560.72Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
PRV-20176PRVDaniel Burton1962-04-20—75443226568924 Canyon Rd, Phoenix, AZ, 850210.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-22204PRVJordan W Cooper1966-09-05UHC-56687-7676121268162256 Apache Blvd, Houston, TX, 770300.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-21860PRVWilliam V Snyder1941-06-07—91028468231256 Baseline Rd, Mesa, AZ, 852660.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-20054PRVYuki Fuller2003-01-01—2093282988656 Ridge Rd, Austin, TX, 787130.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-27919PRVJustin D Welch1981-03-05UHC-40931-8937551871516794 Market St, San Antonio, TX, 782890.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-25886PRVKyle J Garrett1972-02-20—50865789151381 Apache Blvd, Jacksonville, FL, 322990.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23183PRVEric Pierce1955-08-25—82865885638456 Canyon Rd, Gilbert, AZ, 852790.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-26638PRVZachary George1982-02-19UHC-68384-52—8626 Ridge Rd, Seattle, WA, 981230.72Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24378PRVKathryn Gonzalez1988-08-13UHC-91606-7660199827294472 Main St, Minneapolis, MN, 554830.72Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-24924PRVCarol Rodriguez1997-06-02UHC-46306-6686544782545317 Forest Ave, Nashville, TN, 372270.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23444PRVJanet E Ryan1951-06-25UHC-07664-4852948629511077 Sage Ct, Minneapolis, MN, 554350.72Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-25988PRVAlexis Armstrong1996-08-18—60158688881658 Canyon Rd, Austin, TX, 787330.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-22887PRVNunez Alan2003-08-05—94333058226551 Maple Ave, Tampa, FL, 336440.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28222PRVBrown Mary2006-08-18UHC-47472-4541379864072062 Willow Ct, Tampa, FL, 336380.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
9,596 rows, page 76 of 192PreviousNext