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-55755TPACynthia Mejia1957-06-17——8021 Spring St, Austin, TX0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-50033TPATerry Reid1980-07-06——3199 Highland Ave, Glendale, AZ, 853690.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51680TPABobby X Moreno1969-02-07—6764933408—0.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
TPA-59160TPAChristian Elliott1972-07-07UHC-57110-89——0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-54789TPAKyle Jensen1978-03-08——7993 Maple Ave, Jacksonville, FL, 322810.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57446TPAJulia X Powell2005-04-04——6540 Sunset Blvd, Glendale, AZ, 853550.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55529TPAElizabeth Ward1947-08-04——1229 Willow Ct, Seattle, WA, 981730.80Date of birth reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-62579TPABetty Shaw1991-09-25——8709 Pine Dr, Scottsdale, AZ, 852890.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56283TPARachel Kelley1977-08-18——7186 Oak St, Orlando, FL, 328830.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50189TPAJack Roberts1985-02-01——2800 Lake View Rd, Atlanta, GA, 303350.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
TPA-56191TPAHarold I Allen1982-05-24UHC-32188-3274660870164801 Mountain View Dr, Atlanta, GA, 303500.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-54481TPAEdwward Robinson1999-06-06UHC-97690-56—3550 Maple Ave, Miami, FL, 331360.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55321TPAKyle Harvey1976-10-27——4135 Sage Ct, San Diego, CA, 921960.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52728TPAJustin Parker1994-05-17——2669 Highland Ave, Glendale, AZ, 853270.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57278TPAJulia T Hansen1986-07-22UHC-54398-04—2065 Mountain View Dr, Phoenix, AZ, 850190.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63675TPAKayla Fowler1995-02-26—54459476872690 Willow Ct, Gilbert, AZ, 852840.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-62803TPARussell Lee1969-11-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60350TPAEvelyn Hill——53998795743867 Desert Sky Blvd, San Antonio, TX, 782650.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-61620TPAGerald Harrison1965-08-14—61435716626815 Market St, Miami, FL, 331900.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61039TPAJoe Cox1997-10-04——9489 Mountain View Dr, Plano, TX, 750390.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-57981TPAKayla Perez1964-12-11——5951 Forest Ave, Plano, TX, 750250.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55373TPARussell Armstrong1968-04-21—9105869820—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-60333TPARalph R Bailey1968-01-10—50330353069827 Elm St, Houston, TX, 770970.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62559TPASara Murray1944-05-25——9636 Spring St, Columbus, OH, 432410.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54438TPAFrances Ramirez1973-08-18——5692 Union St, Charlotte, NC, 282320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60959TPAOlivia Nunez1941-10-20—7642945244—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55736TPAMichelle Soto1966-06-26——5905 Maple Ave, Dallas, TX, 752110.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51316TPAPatricia Miller1943-02-16——1760 Pine Dr, Denver, CO, 802570.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58054TPASharon K Mendoza1971-11-23——8627 Willow Ct, Jacksonville, FL, 322940.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50923TPAArthur P Reynolds1984-05-13——9016 Elm St, Tampa, FL, 336960.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52878TPAWalterJunk1997-01-14—4662055415—0.80Date of birth reformattedPhone reformattedPlaceholder values clearedNo usable name (quarantined)
TPA-59590TPALarry Hnson1959-07-28——5391 Mountain View Dr, Seattle, WA, 981330.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-54816TPARiichard Vasuez1944-10-03——8197 Lake View Rd, Plano, TX, 750230.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57208TPAKimberly Ramirez1961-09-17——8356 Park Pl, Dallas, TX, 752630.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62877TPAIsabella Patel1966-07-12UHC-81273-52—7874 Lincoln Way, Las Vegas, NV, 891410.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59686TPAAlexander E Snyder1992-07-21——9767 Union St, Atlanta, GA, 303130.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-51646TPAHeather Walsh1942-10-11———0.80Name split from “Last, First”Date of birth reformattedEmail lower-casedWhitespace trimmed
TPA-62557TPANicholas Santos1973-05-25——6211 Main St Apt 5, Mesa, AZ, 852370.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-56721TPAKathryn Contreras1952-04-19——6059 Ridge Rd, Columbus, OH, 432520.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51644TPAMei Hansen1974-12-15——4449 Indian School Rd, Seattle, WA, 981450.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57575TPAFrances N Moreno1978-09-23——3535 Grand Ave, Tempe, AZ, 852890.80Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed
TPA-55691TPAGonzalez Melissa1975-01-07——4070 Union St, Jacksonville, FL, 322560.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-53615TPANicholas Williamson1986-07-06——4949 Canyon Rd, Minneapolis, MN, 554720.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54173TPABrian Thomas1993-09-01——983 Oak St, Charlotte, NC, 282050.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51729TPAArjun Ray1963-03-12——5602 Camelback Rd, Atlanta, GA, 303050.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50392TPAAlbert Henderson2008-10-03——4658 Maple Ave, Scottsdale, AZ, 852400.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50393TPAAlbert Henderson2008-10-03——4658 Maple Ave, Scottsdale, AZ, 852400.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52795TPAMegan Bakar1994-01-06UHC-45792-2859647080075007 Bayshore Dr, Nashville, TN, 372610.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54061TPASophia Morris2002-02-22—77445687191447 Broadway, Jacksonville, FL0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
TPA-58948TPAJessica McCoy1952-01-10—36841789562580 Hillcrest Rd, Jacksonville, FL, 322870.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
14,474 rows, page 187 of 290PreviousNext