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-62649TPAValentina Scott—UHC-56762-01——0.78Name re-casedDate of birth unreadableEmail lower-casedWhitespace trimmed+1 more
TPA-62650TPAValentina Scott—UHC-56762-01——0.78Name re-casedDate of birth unreadableEmail lower-casedWhitespace trimmed+1 more
TPA-59116TPAJean Hill1962-12-26UHC-76210-9239557967468614 Ocean Ave, Las Vegas, NV, 891980.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60970TPAZachary Gibson2001-08-24——1442 Maple Ave, Austin, TX, 787960.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52574TPAJordan Munoz1960-08-21—64247777945593 Market St, Tucson, AZ, 857860.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-64450TPAJuan Morales1995-06-09——8572 Valley View Dr, Gilbert, AZ, 852530.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-53510TPANatalie Pierce1939-01-28——9679 Washington St, Glendale, AZ, 853150.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62695TPAThomas O Larson1938-07-09———0.78Date of birth reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more
TPA-62348TPAElijah G Gilbert1998-08-12—69584830297681 Canyon Rd, Charlotte, NC, 282070.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63559TPAKatherine Black1997-07-25—232267731945 Palm Dr, Tucson, AZ, 857650.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-58300TPAEthan Reid1958-02-10—7423328602123 Park Pl, Los Angeles, CA, 900170.78Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+1 more
TPA-56016TPAKelly Perez1990-08-15—22770781621759 Mountain View Dr, Los Angeles, CA, 900000.78Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+1 more
TPA-52175TPAJanice Tran1977-08-21—79093894444477 Broadway, San Antonio, TX, 782810.78Name re-casedSSN last four extractedAddress re-casedWhitespace trimmed+1 more
TPA-63934TPAJessica Hill1990-12-16——4977 Church St, Charlotte, NC, 282540.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52023TPADebra Marquez1996-03-18UHC-56584-90—4462 Forest Ave, Minneapolis, MN, 554830.78Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53385TPAMarcus Jones1952-02-04——9174 Indian School Rd, Tampa, FL, 336210.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62997TPAAilce Lynch1989-07-03——6986 Baseline Rd, Mesa, AZ, 852760.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-62615TPANatalie Phillips1986-10-11——1429 Cedar Ln, Gilbert, AZ, 852130.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59551TPAAlan Bradley1971-09-10——5458 Oak St, Tampa, FL, 336330.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61492TPADebra Marshall2003-04-13——5514 Canyon Rd, Seattle, WA, 981350.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56221TPACarol Gardner1997-04-28UHC-82456-8750890130892681 Washington St, Tampa, FL, 336670.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58163TPAKeith Simpson2007-11-19——6732 Church St, Fresno, CA, 937760.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-56000TPABobby Watson1949-06-19—52967799796761 Oak St, Phoenix, AZ, 850530.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-64296TPAJustin Crawford1961-04-08—48655041875349 Washington St, Scottsdale, AZ, 852970.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51055TPASarah Black2001-07-06—98959021028146 Bayshore Dr, Chandler, AZ, 852430.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59371TPAChristine U Ferguson2003-09-16UHC-41567-67—541 Sage Ct, Fresno, CA, 937280.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-64113TPAGabriel Hill1971-05-22——5941 Pine Dr, Nashville, TN, 372210.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62293TPADylan Cole2004-07-01———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-52682TPADorothy Mejia1939-12-02——8951 Pine Dr, Austin, TX, 787380.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-62651TPAValentina Scott1983-10-26——6070 Elm St, Gilbert, AZ, 852200.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-57288TPAHelen Mejia1987-01-20——9445 Desert Sky Blvd, Eden Prairie, MN, 553520.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60259TPAEvelyn Palmer1956-01-03—5335273349—0.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-54846TPAJeffrey Green1976-05-21——1429 Spring St, Denver, CO, 802990.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54470TPABrian Luna1995-05-26——40 Maple Ave, Tempe, AZ, 852590.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-50730TPAHolmes Charlotte1999-05-21—63687788254958 Sage Ct, Glendale, AZ, 853660.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64006TPAWilliam Vargas1981-12-28—527442106124 Forest Ave, Gilbert, AZ, 852070.78Name re-casedPhone reformattedEmail lower-casedGender normalised+1 more
TPA-51123TPACarolyn F Fuller1949-04-24——4866 Church St, San Diego, CA, 921200.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51097TPAJames Griffin1973-01-19——3450 Cedar Ln, Plano, TX, 750670.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57731TPAWlilie Woods1981-12-09——9597 Main St, Austin, TX, 787520.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-57063TPANancy Jones1950-05-18—98271856686297 Hillcrest Rd, Las Vegas, NV, 891980.78Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-64057TPAGabriel Rammos1968-12-09——8943 Hillcrest Rd, Las Vegas, NV, 891860.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-59613TPAPaul Welch1951-06-06——1850 Park Pl, Phoenix, AZ, 850710.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58897TPAMateo F Alvarez1994-06-14——8301 Lake View Rd, Denver, CO, 802120.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57280TPAJacob Hal2001-06-06——2618 Ridge Rd, Phoenix, AZ, 850940.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-55697TPAScott U Jordan1965-02-17——7935 Desert Sky Blvd Apt 5, Fresno, CA, 937440.78Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed+1 more
TPA-57481TPARoy Reyes1982-12-28———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-62750TPALogan Scott1988-08-15—50524341969396 Cedar Ln, Nashville, TN, 372430.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52353TPATheresa Hoffman1982-08-08——3909 Desert Sky Blvd, Sacramento, CA, 958390.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56260TPANancy S Price1979-11-07—78179453999716 Park Pl, Charlotte, NC, 282050.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50996TPAFrances Porter1949-01-13UHC-23993-16——0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
14,474 rows, page 153 of 290PreviousNext