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-63815TPADorothy Lopez1994-01-02——2090 Ocean Ave, Tampa, FL, 336680.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55381TPAWayne T Greene1964-05-20—47854799225071 Cedar Ln, Nashville, TN, 372790.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-55382TPAWayne T Greene1964-05-20—47854799225071 Cedar Ln, Nashville, TN, 372790.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-64088TPABrenda Wallace2007-02-21—33461892461270 Park Pl, Orlando, FL, 328800.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61383TPAJonathan Reed2006-09-05—64191798461453 Valley View Dr, Dallas, TX, 752080.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61944TPABeverly Andrews1967-12-18—51663472462649 Canyon Rd, Nashville, TN, 372990.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58310TPATyler Vargas1980-01-13UHC-54913-5443463158746278 Highland Ave, Atlanta, GA, 303400.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62065TPALisa Obrien2004-10-24—96775053553140 Lake View Rd, Tucson, AZ, 857300.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-56613TPALaura Stone1995-02-17—86140985419078 Canyon Rd, Tampa, FL, 336580.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-50450TPABobby O Garcia1940-10-09—37679331813222 Valley View Dr, Minneapolis, MN0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63753TPADebra Burton1998-08-18——639 Cedar Ln, Plano, TX, 750740.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61596TPAJulia Carlson1963-11-18—75064523814096 Central Ave, Gilbert, AZ, 852150.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-53596TPAWalter Clark1938-04-23—46228315916835 Oak St, San Diego, CA, 921320.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54580TPAJoe Lane1974-01-10—23675181151430 Camelback Rd, Austin, TX, 787970.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-55761TPAAnthony Johnston1976-01-26—23758990846353 Cedar Ln, Tampa, FL, 336190.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58320TPAJuan Allen1966-06-19—90742231528205 Washington St, Tampa, FL, 336880.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54578TPAPatrick Sanchez1955-04-09——8588 Church St, Dallas, TX, 752150.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59204TPARussell G Bell—UHC-91116-5829879687582688 Jefferson Ave, Atlanta, GA, 303800.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
TPA-62731TPACarlos Bryant1954-09-18—29199491506753 Hillcrest Rd, Tampa, FL, 336090.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57640TPAJames D Garrett1961-02-17—58890313397858 Spring St, Sacramento, CA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-60102TPAAaron Chapman1951-03-18—94432513068759 Lake View Rd, San Antonio, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-56815TPAKathryn Dunn2003-01-17—75893259666922 Park Pl, Denver, CO, 802610.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-51354TPAMarcus Fields1996-03-03—61330795378621 Oak St, Nashville, TN, 372410.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-51351TPADiana F Rid2000-02-01——9358 Desert Sky Blvd, Sacramento, CA0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51352TPADiana F Rid2000-02-01——9358 Desert Sky Blvd, Sacramento, CA0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50602TPANicole Simpson1969-11-11UHC-07493-843016101518802 Ridge Rd, Nashville, TN, 372330.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58611TPARoy Obrien2008-09-19UHC-39363-948718344031—0.60Name split from “Last, First”Name re-casedDate of birth reformattedPhone reformatted+4 more
TPA-51105TPAMary Johnston1950-06-19—2632233036612 Desert Sky Blvd, Nashville, TN, 372910.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-53335TPANicole T Munoz1973-06-26—43041538507046 Ocean Ave, Los Angeles, CA, 900270.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61782TPARachel D Fowler1961-06-04—98381921538131 Sunset Blvd, Phoenix, AZ, 850690.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-52997TPAGrace C Kelly1992-06-04—76650604945725 Maple Ave, San Diego, CA, 921220.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-55719TPAKelly Jimenez1960-05-09—86723578289175 Forest Ave, Dallas, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-50772TPAKenneth Marshall2003-03-20——7655 Camelback Rd, Las Vegas, NV, 891900.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51381TPAJanet Jenkins1976-05-08—97948676035208 Main St, Phoenix, AZ, 850040.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-52330TPAChristine Hicks1996-10-24—30897766094361 Canyon Rd, Scottsdale, AZ, 852770.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-56170TPARebacca Cooper1954-10-28—79792226924303 Forest Ave, Glendale, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-63402TPAMriana Garrett2003-11-15UHC-39140-7282973563536949 Sunset Blvd, Mesa, AZ, 852580.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-61773TPASandra Martin2003-11-26——5929 Indian School Rd, Columbus, OH, 432270.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54948TPADaniel Austin1967-05-16——7940 Mesa Dr, Scottsdale, AZ, 852480.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-60954TPADorothy Lawrence1976-12-02——28 Ocean Ave, Tucson, AZ, 857900.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53667TPAAhmed Spencer1994-06-20UHC-74337-10—317 Park Pl Apt 14, Mesa, AZ, 852440.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-62653TPAMartha Davis1983-01-03—72373251121368 Harbor Blvd, San Antonio, TX, 782710.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50198TPAMei Harvey1954-12-02——4291 Harbor Blvd Apt 12, Orlando, FL0.60Name re-casedDate of birth reformattedUnit split from streetCity re-cased+4 more
TPA-61276TPAPeter Cunningham1949-04-19UHC-72694-614467887589331 Church St, Nashville, TN, 372930.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
TPA-54509TPAWei Berry1983-09-09——1615 Indian School Rd, Eden Prairie, MN, 553420.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54048TPALauren K Sullivan1986-10-09—8836385689381 Park Pl, Tampa, FL, 336970.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-58799TPADouglas Luna1990-11-25—33671838888652 Willow Ct, Atlanta, GA, 303670.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61880TPADoris Bradley1942-01-11—41986251641142 Palm Dr, Austin, TX, 787710.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-56814TPARaymond Martinez1964-07-23UHC-76339-6832565815475764 Desert Sky Blvd, Scottsdale, AZ, 852440.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-52759TPAFrank Armsrtong1977-11-07—47972285568373 Mesa Dr, Seattle, WA, 981000.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
14,474 rows, page 31 of 290PreviousNext