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-52422TPAThomas Powell1965-12-19——1837 Palm Dr, Atlanta, GA, 303970.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-51952TPATerry Diaz1939-05-15——4080 Palm Dr, Plano, TX0.78Name re-casedDate of birth reformattedCity re-casedZIP missing+1 more
TPA-52839TPAKathleen I Moore1977-02-10UHC-73695-0345556668964834 Forest Ave, Los Angeles, CA, 900380.78Middle initial moved out of first nameName re-casedPhone reformattedWhitespace trimmed+1 more
TPA-64461TPAZachary Obrien1948-08-01UHC-85761-4720744500593899 Main St, Seattle, WA, 981290.78Name re-casedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-62429TPADylan Day1946-11-15——8287 Central Ave, Gilbert, AZ, 852750.78Date of birth reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-54324TPAWilliam Banks1961-03-01——6816 Spring St, Los Angeles, CA, 900310.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-62945TPAKyle Lane1981-11-07—74894653809320 Willow Ct, Dallas, TX, 752090.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-50409TPAMary Payne1948-01-25——2881 Apache Blvd, Seattle, WA, 981200.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-64261TPAJerry Weber2007-02-02—69857696701357 Union St, Eden Prairie, MN, 553170.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56655TPAVirginia Jackson1958-05-09——1576 Oak St, Austin, TX, 787740.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50004TPASophia Ramirez1974-07-12—71966814361154 Indian School Rd, Dallas, TX, 752850.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55411TPATerry Elliott1980-05-20——6936 Willow Ct, Tempe, AZ, 852600.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62539TPAAnn X Bowman1970-06-15——6414 Ridge Rd, Phoenix, AZ, 850230.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52709TPAAdam Collins1975-06-08——2667 Canyon Rd, Tucson, AZ, 857650.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53119TPARachel Jacobs1987-04-14UHC-12610-08—2993 Union St, San Antonio, TX, 782190.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-62697TPAHeather Gardner1996-07-12——3937 Elm St, Denver, CO, 802120.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51159TPALaryr Myers1944-11-25UHC-51103-97—4345 Maple Ave, Houston, TX, 770100.78Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-51843TPAAnna Willis1963-11-06——7346 Grand Ave, Seattle, WA, 981190.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62794TPALori Miller1942-02-11——138 Harbor Blvd, Nashville, TN, 372420.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53691TPABobby Anderson1978-03-09UHC-53467-0785345105433664 Harbor Blvd, Minneapolis, MN, 554910.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53299TPAEmily U Aguilar1985-08-05——1301 Willow Ct, Scottsdale, AZ, 852920.78Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+1 more
TPA-61703TPATeresa G Elliott1938-11-27——621 Grand Ave, Gilbert, AZ, 852590.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50597TPAMaria Bradley1976-11-21——7106 Ridge Rd, Austin, TX, 787700.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63108TPAKevin Burton1974-02-28—88460815036383 Mountain View Dr, Gilbert, AZ, 852460.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50436TPACamila Santos1951-11-20——4386 Lake View Rd, Seattle, WA0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-54666TPAAlexis Y Palmer1950-11-01—8103248489795 Highland Ave, San Antonio, TX, 782080.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56293TPAGabriel Hill1996-05-02—93596050613390 Main St, Dallas, TX, 752300.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58579TPAJonathan Silva2006-05-10—59054143898190 Cedar Ln, Fresno, CA, 937520.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64026TPAMark Henry1980-11-23——1685 Market St, Orlando, FL, 328160.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-63608TPAChristian Anderson1939-07-09UHC-03780-5894587871802042 Washington St, Orlando, FL, 328180.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54159TPAMegan Simpson1996-02-28UHC-32074-70—9117 Market St, Los Angeles, CA, 900910.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50986TPAJoshua Hernandez2006-01-02——8353 Sage Ct, Scottsdale, AZ, 852850.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61839TPAScott Le1960-06-05UHC-13697-19—586 Canyon Rd, Gilbert, AZ, 852160.78Date of birth reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+1 more
TPA-58349TPADavid Mason1938-07-25——4860 Mountain View Dr, Jacksonville, FL, 322550.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64381TPAJoyce Carter1958-01-15——6250 Maple Ave, San Diego, CA, 921300.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57204TPAJean Ortega2000-07-25——9182 Indian School Rd, Dallas, TX, 752460.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56347TPAAmber Welch1942-02-28UHC-68756-9277693795956817 Church St, Glendale, AZ, 853480.78Date of birth reformattedCity re-casedState name converted to codeWhitespace trimmed+1 more
TPA-53595TPALinda Munoz1988-01-13—76350410728437 Church St, Tampa, FL, 336270.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50688TPAThomas Lynch1939-04-20—58350699791768 Pine Dr, Tampa, FL, 336010.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58042TPAJanet Reyyes1951-06-01—20395258824791 Bayshore Dr # 323, Tucson, AZ, 857010.78Date of birth reformattedPhone reformattedUnit split from streetWhitespace trimmed+1 more
TPA-58898TPADenise Berry1943-01-02——6018 Maple Ave, Nashville, TN, 372610.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63335TPAGary Ryan1965-08-20——3177 Canyon Rd, Tucson, AZ, 857830.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61696TPAMason Weaver2008-02-06UHC-52861-29—5809 Harbor Blvd, Mesa, AZ, 852380.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60568TPAMegan Arnold1996-10-20——473 Jefferson Ave, Plano, TX, 750510.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58837TPAEvelin Delgado1961-10-05—3543686826495 Church St, Plano, TX, 750740.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62739TPALori Fluler1985-09-22——2591 Camelback Rd, Tampa, FL0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-59414TPAAisha Hughes2000-08-26——5338 Cedar Ln, Denver, CO, 802840.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58546TPAJeremy H Gomez1972-08-09——5315 Mesa Dr, Minneapolis, MN, 554620.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52667TPASteven Santiago1984-01-24——3471 Market St, Chandler, AZ, 852810.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57021TPARay Thomas1966-03-27—82746146357605 Harbor Blvd, Phoenix, AZ, 850070.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 154 of 290PreviousNext