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-57919TPAJulie Ortiz2006-09-17——2497 Ocean Ave, Seattle, WA0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-52924TPADeborah Riley1947-04-26——1951 Lincoln Way, Atlanta, GA, 303150.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-58270TPAMartha R Bennett1948-03-18———0.82Date of birth reformattedPhone missing area codePlaceholder values cleared
TPA-51980TPALisa Silva2002-04-16——6174 Willow Ct, Columbus, OH, 432350.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58484TPARalph Gilbert1953-12-01UHC-18514-9424395310362350 Highland Ave, Houston, TX, 770570.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54450TPAHoffman J Patrick1960-11-21———0.82Middle initial moved out of first nameName re-casedPlaceholder values cleared
TPA-50504TPAShirley Griffin1997-10-19—63899413046768 Main St, Tucson, AZ, 857600.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62709TPAPriya L Phillips1984-06-03——1868 Hillcrest Rd, Miami, FL, 331560.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50804TPABetty T Peters———7521 Camelback Rd, Sacramento, CA, 958810.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-53660TPAGary West1998-01-17——6358 Ocean Ave, Columbus, OH, 432780.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50255TPARoger Bell1986-11-02——7058 Meadow Ln, Miami, FL, 331330.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-52187TPARaymond Greene1961-03-25——3175 Sage Ct, Los Angeles, CA, 900590.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58467TPAAngela Murray2004-11-25——53 Elm St, Nashville, TN, 372150.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50608TPABrenda Z Wallace1975-02-03UHC-12466-97—9142 Church St, Minneapolis, MN0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-63196TPAMark Nelson1957-10-06——3833 Desert Sky Blvd, Las Vegas, NV, 891260.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-56510TPAEugene I Crwaford1980-09-21UHC-23406-39——0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
TPA-62035TPAAlexander W King1974-02-01——2968 Main St, Phoenix, AZ, 850710.82Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-55360TPALori Foster1982-11-06———0.82Email lower-casedGender normalisedPlaceholder values cleared
TPA-52482TPAWong Laura1951-08-09——4997 Meadow Ln, Sacramento, CA, 958670.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52434TPAKelly I Stevens1958-08-25——8166 Ocean Ave, Houston, TX, 770060.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64325TPARachel Carter1953-11-18——6729 Grand Ave, San Diego, CA, 921640.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-52091TPARobert Gray2002-09-01——3886 Mesa Dr, San Diego, CA, 921650.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58486TPAKJunk1956-03-13———0.82Date of birth reformattedPlaceholder values clearedNo usable name (quarantined)
TPA-60731TPAJulie Alexander1995-01-22——6091 Highland Ave, Miami, FL, 331030.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61647TPAHeather Pena2004-03-26——6554 Baseline Rd, Tucson, AZ, 857080.82Two-digit birth yearCity re-casedPlaceholder values cleared
TPA-54054TPAMatthew Romero1972-07-08——138 Market St, Tempe, AZ, 852260.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54912TPABrian Reynolds1959-05-10——3126 Grand Ave, Miami, FL, 331320.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56907TPAOmar Lawrence1940-02-24——3227 Spring St, San Antonio, TX, 782260.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53537TPACarlos Stone1982-01-01UHC-21036-35—3927 Lincoln Way, Atlanta, GA, 303450.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-61343TPAIsabella U Miller1992-03-22——7287 Lincoln Way, Mesa, AZ, 852940.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-64108TPACheryl Gibson2006-02-01——6384 Sunset Blvd, Sacramento, CA, 958190.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50909TPAThomas Morales1965-01-26UHC-74441-7176584090035241 Jefferson Ave, Denver, CO, 802740.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51666TPAKenneth Mitchell1972-10-10——5912 Willow Ct, Austin, TX0.82Date of birth reformattedZIP missingPlaceholder values cleared
TPA-55754TPACharlotte Payne1980-02-28UHC-82916-23—421 Main St, Tampa, FL, 336690.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55304TPAKenneth Harrison1961-04-04——1680 Lake View Rd, Las Vegas, NV, 891770.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-63367TPASantiago Aguilar1979-04-18——4797 Indian School Rd, Charlotte, NC0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-62006TPAJeffrey Lawrence1977-08-09——2828 Highland Ave, Dallas, TX, 752120.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59041TPACarl Rivera1980-12-03——5451 Grand Ave, Eden Prairie, MN, 553700.82Name re-casedState name converted to codePlaceholder values cleared
TPA-61821TPAAnthony Ramos1938-10-17———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-60132TPABenjamin C Barrnes1943-11-28UHC-74392-69—8722 Ridge Rd Apt 28, Sacramento, CA, 958620.82Date of birth reformattedUnit split from streetPlaceholder values cleared
TPA-50369TPARoy G Fisher1967-07-02—6277456138—0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51676TPAPatrick Santiago2000-03-24——3196 Grand Ave, Minneapolis, MN, 554110.82City re-casedState name converted to codePlaceholder values cleared
TPA-63870TPAVincent Herrera1954-11-26——6704 Lincoln Way, Charlotte, NC0.82Name re-casedZIP missingPlaceholder values cleared
TPA-50717TPANathan M Armstrong1942-02-06—63379056995140 Highland Ave, Orlando, FL, 328430.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-57871TPAAlexander Wood1960-12-15——5121 Jefferson Ave, Scottsdale, AZ, 852120.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60275TPAMadison Kelly1952-05-25——5238 Sage Ct, Nashville, TN, 372750.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-51021TPADiana A Hudson————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-53676TPAArthur Cooper1979-03-09——1558 Valley View Dr, San Diego, CA, 921290.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60159TPAAanda Cole2005-10-28——593 Cedar Ln, Seattle, WA, 981420.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59725TPAJack Lyttle1989-06-17——7673 Pine Dr, Las Vegas, NV0.82ZIP missingWhitespace trimmedPlaceholder values cleared
14,474 rows, page 204 of 290PreviousNext