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-23125PRVRojas D Christian1958-05-15—52996987034017 Main St, Las Vegas, NV, 891610.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28685PRVChristine Moore1954-06-10—92442750638018 Maple Ave, Scottsdale, AZ, 852670.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27865PRVCarl O Ray1963-08-05—79136112331930 Harbor Blvd, Mesa, AZ, 852080.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22215PRVHannah Dean1988-08-19UHC-24263-6637128327749624 Maple Ave, Dallas, TX, 752170.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-23398PRVMarilyn Gonzales1966-11-14——5305 Forest Ave, Sacramento, CA, 958480.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20623PRVLori G Mejia——48046599258436 Palm Dr, Tempe, AZ, 852510.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24464PRVEdward Garcia1942-12-09UHC-82255-2148186025445691 Lincoln Way, Austin, TX, 787860.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
PRV-26344PRVDanielle Weaver1975-04-25—28694328402761 Maple Ave Apt 38, Houston, TX, 770110.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-21724PRVDorothy Wagner1953-08-05—24249755384345 Market St, Columbus, OH, 432070.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20790PRVLinda T Weaver1945-04-12UHC-05696-3759340933698132 Grand Ave, Seattle, WA, 981450.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23093PRVCharlotte Ruiz1955-09-20UHC-93692-6588389239986948 Broadway Apt 19, Scottsdale, AZ, 852170.64Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
PRV-24459PRVAnthony U Hayes1946-09-03UHC-47136-4292964205291648 Baseline Rd, Houston, TX, 770030.64Middle initial moved out of first nameDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
PRV-29409PRVJordan D Thomas1948-03-05—89336605625317 Jefferson Ave, Sacramento, CA, 958950.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24318PRVMary Young1996-07-16—54966465534728 Market St, San Antonio, TX, 782370.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28249PRVMei Clark1987-03-09UHC-15546-2076589629294102 Sunset Blvd, Glendale, AZ, 853290.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25452PRVKaren A Arnold1955-08-18UHC-28271-3872967390823188 Washington St # 792, Phoenix, AZ, 850270.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-29002PRVMaria Schmidt1957-04-28UHC-24260-2394899146058387 Willow Ct, Columbus, OH, 432000.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27853PRVNancy Richards1948-06-12—81295667028910 Mountain View Dr, Dallas, TX, 752340.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20692PRVPeter Vazquez2002-04-11UHC-44962-1182285979558624 Cedar Ln, Tempe, AZ, 852190.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25950PRVHenry Roberts——2096128754709 Camelback Rd, Phoenix, AZ, 850590.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25376PRVEmma Cook1960-02-23UHC-78970-78—2069 Willow Ct, Houston, TX, 770960.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27361PRVAshley Moore1966-04-16UHC-92997-4227390359235502 River Rd, Nashville, TN0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-20574PRVSarah D Grant1999-01-04—35432335514672 Canyon Rd, Minneapolis, MN, 554130.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-20165PRVAmy Wong1972-07-16UHC-19081-1686844642075871 Baseline Rd, Glendale, AZ, 853200.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25663PRVMarcus Rodriguez—UHC-13361-972205693909439 Desert Sky Blvd, Dallas, TX, 752950.64Name re-casedDate of birth reformattedDate of birth unreadableState name converted to code+2 more
PRV-29358PRVTheresa Sims1984-01-16UHC-55226-1952188513179244 Canyon Rd, Jacksonville, FL, 322610.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23714PRVJosh Herrera1971-03-17—30027436177826 Mesa Dr, Denver, CO, 802280.64Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
PRV-22825PRVScott Howell2004-09-04UHC-80139-4822294350451885 Meadow Ln, Houston, TX, 770710.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-26663PRVJohn Reeys1952-07-07—68042013685780 Jefferson Ave, Plano, TX, 750820.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-27096PRVBrian Oliver1950-01-27—42979863646033 Bayshore Dr, Glendale, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24920PRVHelen V Mejia1987-01-20—96087193959445 Desert Sky Blvd, Eden Prairie, MN, 553520.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20901PRVGabriel R Yang1960-04-14UHC-81771-2087066040641130 Elm St, Columbus, OH, 432100.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28054PRVChristopher Tucker1938-10-15—27148926376081 Mountain View Dr, Phoenix, AZ, 850010.64Name re-casedPhone reformattedCity re-casedState name converted to code+2 more
PRV-24388PRVJanice Li1942-05-02UHC-15517-5039653454848397 Broadway, Denver, CO, 802010.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
PRV-22130PRVBrenda Rose1958-08-04—71473148996353 Apache Blvd, Miami, FL0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21730PRVThomas U Armstrong1993-12-04UHC-87670-0796229377471436 Elm St, Austin, TX, 787090.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-21070PRVStephen Cook2001-11-05——4900 Bayshore Dr Apt 33, Tempe, AZ, 852400.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-21763PRVJohn V Richards—UHC-96441-759347378156—0.64Middle initial moved out of first nameDate of birth unreadablePhone reformattedMember ID reformatted+2 more
PRV-27131PRVJason Chavez1954-06-07—6389763999825 Forest Ave, Tampa, FL, 336940.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-26473PRVNoah Clark1959-02-15UHC-79330-6795024492811599 Central Ave, Las Vegas, NV, 891170.64Member ID reformattedCity re-casedState name converted to codeZIP+4 trimmed+2 more
PRV-26086PRVJim Wright1993-08-27UHC-88515-1163785524598840 Cedar Ln, Columbus, OH, 432250.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-21058PRVCheryl Scott1971-07-23—87434400209254 Union St, Miami, FL, 331960.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-29161PRVKayla Brooks1994-05-18UHC-31508-8927798183874646 Camelback Rd, Seattle, WA, 981380.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21332PRVGeorge Kim1946-06-06UHC-68057-2840337844244350 Church St, Denver, CO, 802360.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-23269PRVMargaret Roberts1962-05-20UHC-10370-0832165258866363 Highland Ave, Los Angeles, CA, 900390.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20605PRVWalter Ortega1960-11-18UHC-32319-1575898641663191 Elm St, San Antonio, TX, 782960.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20646PRVChristine Bowman1953-10-18—5648121289125 Spring St, Nashville, TN, 372330.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24310PRVVincent Austin1943-10-28—28243382779755 Sage Ct, Dallas, TX, 752170.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-28566PRVMarc Hudson1977-06-02——4570 Oak St, Minneapolis, MN0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
PRV-27465PRVLucia Williams1996-04-13——7236 Central Ave, San Antonio, TX, 782470.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
9,596 rows, page 51 of 192PreviousNext