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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-51760TPAKenneth Payne1973-10-27——4077 Grand Ave, Chandler, AZ, 852230.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63678TPAKelly Chapman1971-01-12—3194442943—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-60401TPAJoan S Knight1997-11-15—94147038453802 Highland Ave, Fresno, CA, 937960.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55682TPALucia Little2008-01-04—95421856455507 Mesa Dr, Miami, FL, 331150.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56984TPAAbigail Olson1945-07-07UHC-32653-354863715490—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-64371TPAJulie Medina2004-05-05UHC-60078-04—7323 Apache Blvd, Austin, TX, 787430.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52066TPAJoshua Brown1993-10-09—3207121797—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58246TPARalph T Marshall1975-02-01———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-64076TPAMelissa Medina1972-12-23——670 Sage Ct, Glendale, AZ, 853590.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54193TPALuis Sullivan1950-06-03—3872678215—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57667TPAPaul Woods2007-09-24———0.92Name re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-58352TPAAmber Marquez1957-08-13—46541485274020 Meadow Ln, San Antonio, TX, 782560.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50741TPAJacqueline Taylor1976-10-27———0.92Name re-casedDate of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-54714TPAGregory Hudson1954-02-04UHC-41204-86——0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51030TPAJames Chen1961-02-13—8594009501—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60336TPAGabriel Bell1976-12-08—47728469417713 Market St, Tampa, FL, 336340.92Date of birth reformattedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-58268TPAAlexis Jimenez1971-09-20——1687 Desert Sky Blvd, Miami, FL, 331060.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-50232TPABobby Alexander2000-12-16—3163077428—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55569TPAYuki Hoffman1940-03-10—64937410974114 River Rd, Tampa, FL, 336480.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51559TPADebra Pierce1964-04-26—6934782506—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63457TPAVirginia Wheeler1991-07-17—8278888238—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61741TPAPeter Garrett2000-01-10UHC-91659-773872256359—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50315TPACharlotte Bryant1993-09-22—85882005124266 Union St, Denver, CO, 802300.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-60822TPAMark Scott1987-01-02——5120 Willow Ct, Gilbert, AZ, 852680.92Date of birth reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-62524TPAScott Kelley1995-07-25——9189 Canyon Rd, Seattle, WA, 981000.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52895TPAEugene Cox1983-02-14——28 Spring St, Miami, FL, 331050.92Name re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-59799TPANoah Woods1969-10-02———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63866TPAKimberly Mills1955-12-07——9137 Main St, Gilbert, AZ, 852080.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-63865TPAKimberly Mills1955-12-07——9137 Main St, Gilbert, AZ, 852080.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-50734TPAArthur Mason1975-07-11—33739743675652 Jefferson Ave, San Antonio, TX, 782660.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-55153TPADonna Stephens1984-03-07—5458276708—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-57673TPAEmily Harris1967-10-25UHC-11654-18—5568 Apache Blvd, Orlando, FL, 328600.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57976TPAAisha Hayes1948-06-25UHC-52123-64—5403 Lincoln Way, Dallas, TX, 752740.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-52671TPAJose Ruiz1939-09-22——1145 Mountain View Dr, Sacramento, CA, 958990.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
TPA-63411TPAMari Greene1981-03-10——2309 Market St, Las Vegas, NV, 891670.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54574TPASamuel White1941-08-22UHC-37086-816317019537—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57907TPACarlos Gordon2005-06-11———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63342TPADenise Robinson1985-07-14—8283268484—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
TPA-63637TPAButler Hannah1987-06-26UHC-70941-53—5044 Union St, San Antonio, TX, 782120.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
TPA-63391TPAHelen Y Murphy1940-04-15—2637328246—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62366TPAHelen Garcia1973-01-28———0.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56541TPAMary C Clark2004-05-11—3718954354343 Broadway, Los Angeles, CA, 900350.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52836TPAElizabeth McDonald1992-08-18UHC-98519-7791936162448972 Broadway, Tucson, AZ, 857190.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56389TPACarlos Perry2003-05-14—5754178557—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52020TPASophia Howell1997-04-28—49246747922377 Apache Blvd, San Diego, CA, 921440.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56063TPAAlexander Williamson1968-05-24——5393 Ridge Rd, Las Vegas, NV, 891460.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-55480TPATimothy Walsh1990-01-06——1204 Maple Ave, Charlotte, NC, 282110.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51977TPAJohn West1938-01-22—77499196688348 Market St, Austin, TX, 787480.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60608TPAAlice Gonzales2004-02-05—3229531258—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-62635TPAAna Carr1981-08-17—58983739193689 Pine Dr, Los Angeles, CA, 900740.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 228 of 290PreviousNext