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-60434TPAJulia Park1956-11-04—23744881443535 Pine Dr, Tampa, FL0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55872TPAPaul Patel1942-11-22——8622 Bayshore Dr, Tucson, AZ, 857410.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-53310TPAAbby Kelley1987-10-27——3540 Harbor Blvd, Seattle, WA, 981720.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-55100TPAJack Carter1997-04-23—69394006909198 Mountain View Dr Apt 21, Tucson, AZ, 857540.64Name re-casedPhone reformattedUnit split from streetCity re-cased+2 more
TPA-53087TPAHeather Vazquez1979-12-04UHC-76947-93—5238 Harbor Blvd, Chandler, AZ, 852580.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61645TPAJenen Helen1974-11-10—31267374215779 Market St, Charlotte, NC, 282440.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52870TPAYuki Santiago1941-04-09——6081 Sage Ct, San Antonio, TX, 782910.64Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
TPA-57619TPAArjun Holmes1978-11-22——5851 Main St # 229, Glendale, AZ, 853330.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61901TPAJuan Hunter1965-09-22——5057 Valley View Dr Apt 18, Chandler, AZ, 852490.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61358TPAAmber Jordan1985-02-17——1088 Sunset Blvd, Seattle, WA, 981860.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58896TPACarlos R Wells2000-05-14UHC-40662-0282395878563686 Sunset Blvd, Los Angeles, CA, 900080.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61800TPAEmma Rios2004-03-22UHC-29326-42—124 Ridge Rd, San Diego, CA, 921770.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
TPA-60508TPAFatima Carroll1945-03-08——3295 Market St, San Diego, CA, 921240.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-53303TPAJustin Little1966-06-17—65791153377591 Cedar Ln, Houston, TX, 770070.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56019TPASantiago Moore1963-11-19——3960 Spring St, Nashville, TN, 372310.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56136TPAWilliam Thomes1963-02-12——6444 Ridge Rd # 541, Scottsdale, AZ, 852800.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-54047TPAMadison Garza1979-04-02UHC-61120-69—1278 Sage Ct, Denver, CO, 802800.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-63674TPAChristoppher Graham1994-10-28—6759348647—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
TPA-54627TPAChristine Gonzales1942-05-07—43967990451128 Valley View Dr # 687, Miami, FL, 331270.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-54393TPASoophia Richardson1946-07-02—72032370012328 Church St, Plano, TX, 750040.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
TPA-50953TPALawrence Montgomery1986-11-18——201 Church St, Phoenix, AZ, 850430.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-50946TPAHeather Valdez1966-03-06——8589 Mountain View Dr, Tampa, FL0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-61413TPADonna Reed1985-11-09——9147 Park Pl, Jacksonville, FL0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
TPA-56671TPACynthia Bailey1957-02-16—55953502569112 Market St, Gilbert, AZ, 852470.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51664TPASusan Kim1987-02-04—93857230409058 Camelback Rd, Minneapolis, MN, 554560.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-50648TPASofia Chen1996-09-25——7943 Washington St Apt 15, Phoenix, AZ, 850060.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-52531TPABrenda Alexander2002-05-17——3685 Harbor Blvd, Denver, CO0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-57184TPALarry Perez1982-05-22——6800 Main St, Gilbert, AZ, 852330.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-55912TPAAlice Black1995-09-01—48874272558121 Ocean Ave, Los Angeles, CA, 900400.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63874TPAChristina Silva1989-01-20—55249320054021 Maple Ave, Las Vegas, NV, 891610.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-58663TPAArthur Schultz1964-06-24—52679353441911 Bayshore Dr Apt 23, Minneapolis, MN, 554830.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-57858TPAVirginia Y Wagner1996-02-14——992 Cedar Ln, Tucson, AZ, 857210.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56017TPANicholas Powell—UHC-23532-8222130069358378 Church St, Miami, FL, 331530.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
TPA-53525TPASamantha Nunez1990-02-28UHC-31120-1453654747173542 Hillcrest Rd, Los Angeles, CA0.64Name re-casedPhone reformattedZIP missingGender normalised+2 more
TPA-58338TPAEvans Joseph1997-07-02——7198 Oak St, Tempe, AZ, 852360.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
TPA-59586TPAKaen Mills1992-07-13—41699095064749 Highland Ave, Denver, CO, 802340.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62261TPAMark Lopez1954-09-19——810 Mesa Dr, Sacramento, CA0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55349TPACamila M Morgan1992-07-21——2671 Lake View Rd, Orlando, FL0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62999TPATheresa Carter1968-12-13——4683 Palm Dr, Chandler, AZ, 852620.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58714TPAOlivia Fuller2000-11-15——3435 Ridge Rd, Plano, TX, 750790.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53136TPAJose Kim2000-04-08——7840 River Rd, Eden Prairie, MN, 553380.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61473TPAKevin Ortega1950-11-09——7358 Oak St, Houston, TX0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-57000TPALarry I Mendoza1972-11-08—59434357273521 Maple Ave # 694, Charlotte, NC, 282030.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-58237TPALuis Johnston2006-07-26—5328839680273 Elm St, Atlanta, GA, 303000.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63181TPAShyrley Banks1947-01-01——125 Lake View Rd, Charlotte, NC, 282550.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-55155TPACarolyn Fisher1951-05-24—51533106417001 Baseline Rd, Eden Prairie, MN, 553780.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-55156TPACarolyn Fisher1951-05-24—51533106417001 Baseline Rd, Eden Prairie, MN, 553780.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-62270TPAEimly Lane1943-08-08——3213 Bayshore Dr, Tucson, AZ, 857940.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63369TPAVirginia Stewart1982-10-17—22999291341770 Church St, Tucson, AZ, 857150.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64235TPAJulie Knight1989-05-17——9298 Lake View Rd Apt 17, Tucson, AZ, 857450.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 49 of 290PreviousNext