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-54822TPAArjun C Schmidt1992-12-03——1003 Indian School Rd, Mesa, AZ, 852210.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-56438TPAJoshua Ford——47743646197167 Camelback Rd, Tampa, FL, 336410.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63871TPAJosh Crawford1966-05-13—86550141357519 Elm St, Denver, CO0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-59801TPASamantha Gibson1977-09-18——8088 Washington St, San Diego, CA, 921530.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-61430TPAJordan Lawrence2002-09-13——7239 Ocean Ave, Los Angeles, CA, 900710.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-60195TPABarbara Simmons1958-11-02——5646 Indian School Rd, Las Vegas, NV, 891240.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
TPA-62151TPABeverly G Santos1984-03-21——7505 Ocean Ave, Fresno, CA, 937360.66Middle initial moved out of first nameName re-casedSSN last four extractedWhitespace trimmed+1 more
TPA-55541TPAEmily Black1949-02-19——8359 Desert Sky Blvd, Jacksonville, FL, 322870.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-50441TPAPaul Romero1980-02-23UHC-06985-27—3849 Baseline Rd, Los Angeles, CA, 900600.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51608TPASamantha Guzman1969-12-26——5202 Market St Apt 14, Los Angeles, CA, 900400.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-58079TPABboby E Rodriguez1967-01-04UHC-12282-59—2655 Bayshore Dr, Phoenix, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-58905TPAKaren Ruiz1943-08-01UHC-25421-25—5995 Sage Ct, Austin, TX, 787820.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60353TPARaymmond Coleman1973-12-01——3854 Elm St, Charlotte, NC, 282270.66Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-59705TPARaymond Wonng1994-04-14——6869 Union St, Los Angeles, CA, 900380.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62344TPAJames Q Owens1966-02-24—22753310399781 Harbor Blvd, Phoenix, AZ, 850160.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-59935TPAJonathan Garrett1961-02-22——5631 Church St, Denver, CO, 802500.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62614TPANatalie Phillips1986-10-11—85541804231429 Cedar Ln, Gilbert, AZ, 852130.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58366TPAKathryn Duncan1966-07-24UHC-43519-9589575587038671 Forest Ave, Atlanta, GA, 303360.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50568TPAAhmed Schultz2005-09-27UHC-98286-73—6157 Hillcrest Rd, Las Vegas, NV, 891730.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50567TPAAhmed Schultz2005-09-27UHC-98286-73—6157 Hillcrest Rd, Las Vegas, NV, 891730.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50278TPAGary J Gutierrez1992-12-06—38134189682995 Market St, Eden Prairie, MN, 553250.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-62949TPAAlice Luna1969-09-27UHC-88465-55—158 Park Pl, Glendale, AZ, 853650.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52059TPAYuki Espinoza1951-06-16——387 Harbor Blvd, Charlotte, NC, 282060.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-57346TPAMatthew Munoz——84541279289083 Main St, Las Vegas, NV, 891380.66Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50994TPAWalter Washington———8243 Union St, Los Angeles, CA, 900330.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-50180TPAFatima Kim1966-06-26——8544 Camelback Rd, Sacramento, CA, 958820.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54780TPARebecca Vasquez2002-07-27——8831 Canyon Rd, Glendale, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-57900TPAMariana Ray1981-12-14—44350632905557 Hillcrest Rd, Minneapolis, MN, 554170.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
TPA-53912TPAElizabeth Clark1991-06-26—4893974558878 Pine Dr, San Diego, CA, 921200.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-51301TPAArjun Kim1946-10-17UHC-00642-5767958146768237 Meadow Ln, Nashville, TN, 372910.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52835TPAKenneth Roberts1977-01-07UHC-87369-7963130188622936 Hillcrest Rd, Chandler, AZ, 852680.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-52761TPATimothy Berry1976-03-12UHC-17139-84—422 Meadow Ln, Minneapolis, MN, 554140.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-63540TPASharon Davis1995-09-05——8337 Canyon Rd, Plano, TX, 750660.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53902TPABrandon Jacobs1955-08-05——9500 Grand Ave, Orlando, FL, 328250.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51359TPARalph Clark1960-06-27——6348 Indian School Rd, Scottsdale, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-64213TPAAlexis Hicks1950-12-06——7538 Market St Apt 33, Seattle, WA, 981650.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57689TPALawrence Russell1981-02-16——7206 Valley View Dr, Miami, FL, 331120.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-63893TPAIsabella Sims1954-11-28UHC-25234-7723864066176026 Baseline Rd, Dallas, TX, 752600.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-59921TPAJerry V Howard1964-11-01—76053091717324 Meadow Ln, Los Angeles, CA, 900660.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51547TPAMarilyn Hayes1971-05-03——9800 Grand Ave, Charlotte, NC0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-57382TPAAisha Bailey1993-03-09——2687 Camelback Rd, Tampa, FL, 336150.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-59812TPAHeather Cox1957-09-25——613 Ridge Rd, Los Angeles, CA, 900080.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-57235TPAKenneth Montgomery1985-06-02——476 Harbor Blvd, Tucson, AZ, 857040.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-62168TPAWillie Valdez1988-02-17——5816 Washington St, Charlotte, NC0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-51913TPAAlexis Edawrds1976-03-25——561 Indian School Rd, San Antonio, TX, 782010.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55489TPAAlexis Watkins1946-10-08UHC-25813-01——0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-51914TPAGregory Nichols1965-12-14—73668724426469 Central Ave, Minneapolis, MN, 554640.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-58917TPASarah Adams2006-06-09——2699 Canyon Rd, Fresno, CA, 937840.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-60644TPAJoe Reyes1982-01-09——1612 Church St, Dallas, TX, 752190.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-61268TPANancy Vega2000-02-12UHC-73844-7167151204153291 Mesa Dr, Glendale, AZ, 853210.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
14,474 rows, page 83 of 290PreviousNext