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-52390TPADaniel Williams1993-11-01——8390 Park Pl, Minneapolis, MN, 554080.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59831TPABetty Rilley2003-08-15——9568 Grand Ave, Sacramento, CA, 958620.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-54434TPAThomas Arnold1982-09-17UHC-19975-4335871088226875 Lake View Rd, Denver, CO, 802610.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61753TPASara Cruz1962-05-20—66338575045142 Central Ave, Chandler, AZ, 852840.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56607TPABrenda Wilson1972-01-28——3725 Central Ave, Tampa, FL, 336440.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-53163TPAMason Harper1996-05-08UHC-52064-23—6142 Hillcrest Rd, Fresno, CA0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-50778TPAAnn Reyes1967-04-16—91992935135760 Oak St, Gilbert, AZ, 852810.78Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-60550TPAAisha Gilbert1971-08-08—50395668807169 Mountain View Dr, Sacramento, CA, 958490.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53476TPANoah Edwards1972-07-04—94788141477980 Baseline Rd, Houston, TX, 770750.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54726TPARussell Roberts1996-12-25——6249 Union St, Atlanta, GA, 303050.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54883TPAMegan Burke1939-06-11UHC-10284-6952458444565123 Camelback Rd, Phoenix, AZ, 850990.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53563TPAJonathan Ferguson1989-10-14——7819 Cedar Ln, Seattle, WA, 981200.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60009TPAShirley Hunter1958-03-17—83446627224214 Spring St, San Diego, CA, 921730.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56159TPAJuan Green2008-05-03——539 Indian School Rd, Charlotte, NC, 282400.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62966TPAAlbert B Flores2002-11-06——4970 Mesa Dr, Phoenix, AZ, 850930.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53663TPAGloria Le1940-08-28——1542 Highland Ave, Scottsdale, AZ, 852950.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53867TPAJack Pierce1958-12-15———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-59467TPABrittany O Medina1995-11-10——8502 Baseline Rd, Glendale, AZ, 853110.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60109TPAAmanda Kelly2001-05-04—53523524232294 Sunset Blvd, Phoenix, AZ, 850900.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-50941TPAAlice F Singh—UHC-74636-7765251469124384 Main St, San Antonio, TX, 782330.78Date of birth unreadablePhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-54717TPAAshley Hayas1970-03-20——2850 Valley View Dr, Chandler, AZ, 852300.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50625TPADaniel Lee1956-02-05—57974998678813 Palm Dr, Tempe, AZ, 852240.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60575TPAMarcus Ramireez1979-04-23——8995 Sage Ct, Mesa, AZ, 852980.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52359TPAWayne Cunningham1948-05-12—71641984846837 Cedar Ln, San Antonio, TX, 782610.78Name split from “Last, First”Date of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-63127TPAShirley I Cunningham1973-12-10——3784 Central Ave, Seattle, WA, 981670.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51986TPADouglas Gilbert1994-10-23——7249 Market St, San Antonio, TX, 782160.78Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-54814TPAGloria Gordon1952-09-04——9544 Camelback Rd, Orlando, FL, 328490.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58199TPACharles Armstrong1998-09-13—51649224141851 Maple Ave # 602, Seattle, WA, 981840.78Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+1 more
TPA-59974TPAJanet Delgado1962-11-11——886 River Rd, Denver, CO, 802060.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63791TPARussell K Williamson1990-12-09UHC-62850-78—8828 Ocean Ave, Eden Prairie, MN, 553850.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58177TPACamila Howell1993-08-02UHC-03133-67—882 Harbor Blvd, Phoenix, AZ, 850360.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-50514TPADiego Bishop1959-12-25——6395 Jefferson Ave, Eden Prairie, MN, 553450.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52080TPARoebrt Perkins1968-11-24UHC-38217-2469552736937520 Ocean Ave, Jacksonville, FL, 322400.78Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-53993TPADenise Morris1992-06-21—20767653505438 Mesa Dr, Sacramento, CA, 958180.78Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-56481TPACynthia King1956-04-22——1443 Valley View Dr, Charlotte, NC, 282130.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61415TPANatalie Reid1987-10-19——2154 Meadow Ln, Minneapolis, MN, 554550.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64283TPAJesse Daniels1960-11-24——5751 Elm St # 500, Charlotte, NC, 282380.78Name re-casedDate of birth reformattedUnit split from streetCity re-cased+1 more
TPA-64234TPAVictoria Dunn2001-10-11—37276562338891 Canyon Rd, Tampa, FL, 336200.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50981TPALaura Alvarado2006-01-12——9722 Hillcrest Rd, Seattle, WA, 981160.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55517TPAJon B Parker1952-09-07——8769 Lincoln Way, Seattle, WA, 981740.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-51921TPAJensen Gregory2005-08-16——3096 Pine Dr, Scottsdale, AZ0.78Name re-casedState code upper-casedZIP missingWhitespace trimmed+1 more
TPA-55942TPAWilliam Fowler1940-08-11——9182 Bayshore Dr, San Diego, CA, 921860.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62216TPARoy Bunrs1996-01-06——1170 Church St, Denver, CO, 802960.78Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-54166TPAMarilyn Tucker2002-02-22——9692 Apache Blvd, Tempe, AZ, 852210.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61763TPAWayne Williams1985-03-11—92632537555571 Sunset Blvd, Mesa, AZ, 852720.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55747TPAArthur Sinngh—UHC-71237-80——0.78Name re-casedDate of birth unreadableMember ID reformattedWhitespace trimmed+1 more
TPA-51613TPADiego George2000-06-14——4258 Sage Ct, Minneapolis, MN, 554240.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57151TPADylan Rogers1953-07-20—81094344779893 Sunset Blvd, Denver, CO0.78Date of birth reformattedPhone reformattedState code upper-casedZIP missing+1 more
TPA-57971TPAMadisn Salazar1984-11-24—71465055891081 Pine Dr, Tempe, AZ, 852200.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57655TPAJudy Z Pierce1991-02-15—71064101672875 Maple Ave, San Antonio, TX, 782390.78Phone reformattedZIP+4 trimmedPlan code upper-casedWhitespace trimmed+1 more
14,474 rows, page 145 of 290PreviousNext