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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-59133TPALauren Johnson1955-02-23UHC-97366-6325496165958349 Harbor Blvd, Minneapolis, MN, 554400.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51339TPAJudith Pena1939-08-25—56151052681931 Baseline Rd, Denver, CO, 802650.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-59128TPAJulia Garza1951-12-07UHC-69609-7728791806899030 Indian School Rd, Las Vegas, NV, 891620.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63121TPARobert Brooks1999-02-24—58055955755314 Palm Dr, Fresno, CA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-63120TPARobert Brooks1999-02-24—58055955755314 Palm Dr, Fresno, CA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-59247TPALori Ruiz2004-02-12—81668449855235 Forest Ave, Miami, FL0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-60021TPABruce Wells1977-11-17—54579983257373 Pine Dr, Charlotte, NC0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51019TPAMei Robinson1985-01-21—9764485448197 Hillcrest Rd, Gilbert, AZ, 852160.60Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-62913TPADeniel Alexander1961-03-27—6504839090100 Oak St, Nashville, TN0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54879TPACynthia Capman1998-12-22—74339277675035 Camelback Rd, Glendale, AZ, 853410.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-62890TPANathan Peters1984-03-14——7611 Spring St, Gilbert, AZ0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62891TPANathan Peters1984-03-14——7611 Spring St, Gilbert, AZ0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62382TPALauren Castillo1995-02-27—58383029531958 Highland Ave, Austin, TX, 787340.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63310TPAJoe Rojas1982-01-06—85142025827841 Sage Ct, Phoenix, AZ, 850470.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-58147TPABobby Munoz1963-06-04—78070254951341 Palm Dr, Miami, FL, 331960.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54123TPAJustin Russell1972-06-26——2618 Church St, Nashville, TN, 372210.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-52529TPAChristopher Austin1944-12-09—54962834308029 Highland Ave, Austin, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-55836TPAKatherine Gomez2007-07-28—75536359232883 Hillcrest Rd, Jacksonville, FL, 322130.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50059TPAAmber O Schultz2006-02-21—84696481881979 Washington St Apt 2, Miami, FL, 331760.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-55334TPABrittany Hudson1974-11-22—70770843361400 Palm Dr, San Diego, CA, 921640.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63944TPAHelen Davis1942-02-26——9545 Apache Blvd, Dallas, TX, 752400.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59915TPAJeremy Fernandez1952-09-27UHC-18768-7689671088121634 Market St, Dallas, TX, 752770.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56484TPACharlotte Smith2008-06-03UHC-00797-6194589130849825 Elm St, Eden Prairie, MN0.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
TPA-59502TPASara G Howard1967-04-09—97022987464495 Union St, San Antonio, TX, 782440.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54514TPADonna Hoffman——44026569975099 Canyon Rd, Columbus, OH, 432640.60Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
TPA-61705TPAJesse Freeman2001-09-26—34329210753400 Grand Ave Apt 8, Tucson, AZ, 857530.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-57100TPABetty T Green1957-02-08——7997 Lake View Rd, Jacksonville, FL0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63590TPASean Nguyen1944-06-06——6330 Oak St Apt 33, Dallas, TX, 752620.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-52011TPALauren Miller1990-11-25——8723 Oak St, Las Vegas, NV, 891880.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54696TPANatalie Weaver1964-07-22UHC-79092-3780343516305692 Sunset Blvd, Minneapolis, MN, 554760.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55669TPADot Z Rios2001-08-04UHC-82541-55—4551 Maple Ave, Seattle, WA, 981850.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59470TPASofia Z Cooper1959-06-14——4007 Washington St # 866, Sacramento, CA, 958120.60Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+4 more
TPA-52888TPAGerald Lopez2004-11-18—37792686703691 Jefferson Ave, Jacksonville, FL, 322880.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55695TPAKevin Rivera1943-08-09—3653984769881 Spring St, Eden Prairie, MN, 553860.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-55077TPAVirginia Harvey2008-05-20—85876769217773 Main St, Dallas, TX0.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-55078TPAVirginia Harvey2008-05-20—85876769217773 Main St, Dallas, TX0.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-63780TPADeebra Bennett1984-09-06——4676 River Rd, Minneapolis, MN, 554090.60Name re-casedDate of birth reformattedCity re-casedZIP+4 trimmed+4 more
TPA-60299TPAElijah Henderson1980-02-17—22057840838438 Camelback Rd, Scottsdale, AZ, 852360.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-50894TPAFrank Marquez1977-05-01—75887064989017 Hillcrest Rd Apt 11, Columbus, OH, 432780.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-63860TPACarolyn Payne1978-06-09—76663393745657 Bayshore Dr, Orlando, FL0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59082TPALauren Gutierrez1942-10-10—44090837695474 Indian School Rd, Chandler, AZ, 852200.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59083TPALauren Gutierrez1942-10-10—44090837695474 Indian School Rd, Chandler, AZ, 852200.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54494TPAShirley James1958-03-17—22970234144874 Canyon Rd, Tempe, AZ, 852120.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-62234TPANatalie Cooper1985-11-25—61873175428026 Sunset Blvd # 892, Columbus, OH, 432000.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-57553TPATheresa RJunk1994-05-11——9544 Elm St, Tempe, AZ, 852470.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50066TPAAustin Wong1960-08-26—57194346472723 Grand Ave, Houston, TX, 770240.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-63552TPAKathleen Fisher1953-08-12—97562695555400 Sunset Blvd, Nashville, TN, 372190.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62789TPAVictoria Nunez1991-02-24—79123793085348 Central Ave, Houston, TX, 770870.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-56652TPAGloria G Wagner1996-10-14—2969507994928 Forest Ave, Plano, TX, 750510.60Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
TPA-59512TPASantiago Gonzales1989-11-03—61690542402699 Ocean Ave, Miami, FL, 331780.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
14,474 rows, page 33 of 290PreviousNext