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-57200TPASantiago Edwards2001-03-24—36972427791283 Main St, Dallas, TX, 752480.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58192TPARuth Watson1963-01-03—44689745072307 Sunset Blvd, Jacksonville, FL, 322830.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50508TPAMaria Carroll2000-04-04—76580126403988 Camelback Rd, Austin, TX, 787050.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53878TPAChristian Ray——75823194775974 Grand Ave, Tampa, FL, 336460.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-64441TPARichard Lucas1947-06-12——6760 Hillcrest Rd, Las Vegas, NV, 891430.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54981TPAHeather B Carr1962-11-20—85080410453873 Mesa Dr, Scottsdale, AZ, 852200.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51248TPABenjamin Greane1994-06-08——1364 Oak St, Dallas, TX, 752860.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-63627TPAMatthew Cox1952-01-15—8509834923—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61237TPATeresa Powell1981-09-23——6134 Cedar Ln, Orlando, FL, 328630.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55400TPATerry Torres2008-07-25UHC-76846-3087446883211791 Main St, Chandler, AZ, 852680.80Phone reformattedSSN last four extractedCity re-casedPlaceholder values cleared
TPA-51979TPAAhmed Hill1939-10-14——6465 Spring St, Tempe, AZ, 852490.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61552TPAKelly Carlson1980-07-03—56094767474379 Palm Dr, Jacksonville, FL, 322810.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50793TPAJanet Johnson1980-02-22——4171 Lincoln Way, Los Angeles, CA, 900360.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50019TPAJeeremy Franklin1974-09-25UHC-69691-367618885265—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-59211TPADenise White1963-07-19——1157 Washington St, Columbus, OH, 432830.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60107TPAPatricia Marshall1981-06-08——7133 Cedar Ln, Houston, TX, 770720.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62676TPAAdam P Hicks1979-05-03——5348 Mountain View Dr, Denver, CO, 802820.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-55135TPAPatick Santos1980-05-01——2337 Lake View Rd, Tampa, FL, 336670.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59796TPAMartha Duncan1975-04-24——7161 Hillcrest Rd, San Diego, CA, 921350.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64290TPADebra Stevens1953-05-19—68843768121289 Lincoln Way, Denver, CO, 802110.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62961TPAStevens Valenitna1943-01-26——8592 Mountain View Dr, Houston, TX, 770110.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61831TPALinda Marquez1953-09-16UHC-26316-13—7510 Grand Ave, Denver, CO, 802990.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57818TPABrandon I Bell1955-12-08—9257678922—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50162TPAKatherine Payne1945-07-05—3453147322352 Meadow Ln, Miami, FL, 331910.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53100TPAAngela Sanders1975-04-10——2301 Grand Ave, Jacksonville, FL, 322170.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-55041TPAOlivia Cooleman1967-06-19UHC-80313-12—1107 Oak St, San Antonio, TX, 782500.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62942TPADenny Meyer1988-09-15UHC-24695-9028740458199097 Spring St, Seattle, WA, 981660.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56727TPABradley Jackson1949-08-27———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-51398TPAWood Gerald1992-07-05——3824 Harbor Blvd, Jacksonville, FL, 322630.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57397TPAKim Morrison1978-02-03——5491 Willow Ct, Plano, TX, 750300.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-58588TPARachel Freeman1975-12-07———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51447TPAJean Kelly2003-11-20—5893437985521 Broadway, Gilbert, AZ0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-52098TPALarry Reid1955-09-02UHC-25768-9653461195256846 Main St, Charlotte, NC, 282590.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-63845TPAChristine Robinson1972-06-05UHC-30697-65—9172 Meadow Ln, Las Vegas, NV, 891110.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61369TPAJudith Banks1949-01-10—96922584003720 Main St, Orlando, FL, 328900.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-57817TPAElizabeth Stephens1968-07-05——5950 Elm St, Mesa, AZ, 852820.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50269TPAKatherine Spencer1941-12-05———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-58497TPAMaria Moore1962-11-15——7527 Canyon Rd, Minneapolis, MN, 554720.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54140TPADonald Jamas1972-11-14——5823 Harbor Blvd, Austin, TX, 787690.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62131TPAJames Johnston1960-06-27——3248 Mesa Dr, Nashville, TN, 372960.80City re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63763TPAJose Ellis1963-01-01———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62367TPAElizabeth Gray1958-06-25—97675372653136 Sunset Blvd, Minneapolis, MN, 554880.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-56830TPADiane Morrison1956-04-09——8104 Mountain View Dr, Gilbert, AZ, 852510.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59034TPADorothy Fowler1990-02-06——2653 Lincoln Way, Phoenix, AZ, 850790.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60652TPAHenry W Delgado1981-05-26——5525 Oak St, Minneapolis, MN, 554560.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53034TPAPriya Barnes2006-09-24——7208 Indian School Rd, Austin, TX, 787090.80Date of birth reformattedZIP+4 trimmedEmail lower-casedPlaceholder values cleared
TPA-57032TPARachel Coleman1981-12-28—660953506793 Ocean Ave, Jacksonville, FL, 322620.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-60480TPAJustin Ryan1974-11-04——1898 Camelback Rd, Plano, TX, 750180.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59627TPABetty P Griffin1955-04-26——8221 Bayshore Dr, Sacramento, CA, 958610.80Date of birth reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-56745TPAPriya Berry1958-07-07———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 163 of 290PreviousNext