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-55873TPAMarilyn Porter1945-10-24—71593876841787 Mountain View Dr # 933, Gilbert, AZ, 852990.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-51254TPASarah Reed1980-11-17——6096 Hillcrest Rd, Tempe, AZ, 852420.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62395TPACarl K Austin1951-01-09——8305 Broadway Apt 28, San Diego, CA, 921420.80Unit split from streetEmail lower-casedPlan code upper-casedPlaceholder values cleared
TPA-60433TPADebra Hall1943-04-06———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58386TPAGabriel Wong1950-02-27——3548 Harbor Blvd, Tampa, FL, 336360.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-58752TPADoris Hoffman1938-11-04———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50570TPAHelen K Morris2002-02-12——2782 Park Pl, Denver, CO, 802930.80Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed
TPA-51463TPARachle Hughes1969-06-06——3782 Meadow Ln, Glendale, AZ, 853280.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51533TPAJoseph Wang1976-04-25———0.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
TPA-52664TPAMaria Garcia1947-07-16——7132 Sage Ct, Tempe, AZ0.80Name re-casedDate of birth reformattedZIP missingPlaceholder values cleared
TPA-57331TPASamantha Henderson1945-01-13——2943 Canyon Rd, Jacksonville, FL, 322660.80Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased
TPA-51146TPAEmma J Romero1974-01-25——1356 Jefferson Ave, Minneapolis, MN, 554860.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60501TPAJennifer Vargas1989-11-03——2753 River Rd, Plano, TX, 750580.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64300TPALori Luna2005-04-02——6738 Mesa Dr, Atlanta, GA, 303280.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51594TPAMargaret Rice2007-03-25——6974 Mesa Dr, Tucson, AZ, 857290.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60834TPACarlos Hoffman1963-08-01———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-62938TPAHarold Butler1939-08-28—7384268489151 Valley View Dr, Seattle, WA, 981450.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52986TPAChristina Weber1991-07-10—75057811035850 Mountain View Dr, Tampa, FL, 336000.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64034TPACahrles Burke1944-01-12—67464967417974 Meadow Ln, Austin, TX, 787700.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58240TPABilly Weaver1953-05-24—65380225771760 Pine Dr Apt 32, Sacramento, CA, 958740.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-54049TPAScott Jacobs1954-07-22——9154 Cedar Ln, Seattle, WA, 981020.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50229TPACarolyn Wilson1948-05-14—35168529772995 Pine Dr, Charlotte, NC, 282540.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-64152TPAHelen Rivera1960-06-28—92498985842648 Sunset Blvd, Mesa, AZ, 852670.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50114TPABarb Nchols1983-11-17——2632 Meadow Ln, Phoenix, AZ, 850000.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55961TPAIsabella U Payne1990-06-09——2458 Forest Ave, Houston, TX, 770190.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59170TPABarbara Thompson1967-10-28—6273534245—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-57618TPAMartha Henderson2008-10-26UHC-24638-5738963772686710 Washington St, Minneapolis, MN, 554370.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51675TPAEmma Coleman1992-05-06—92856031348276 Oak St, Tempe, AZ, 852150.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-55750TPARivera Barbara1996-04-26——3211 Main St, Plano, TX, 750770.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61859TPAPaul Bailey1944-02-13——8032 Church St, Mesa, AZ, 852080.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-62548TPAWaltar Bowman1971-04-16——9491 Apache Blvd, Houston, TX, 770350.80Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased
TPA-53666TPAJack Williams1945-08-05UHC-49650-74—9245 Jefferson Ave, Nashville, TN, 372980.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-64271TPAJonathan Schultz1945-06-08——3118 Pine Dr, Charlotte, NC, 282980.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56127TPAPriya O Gonzales1946-02-20—64467229018243 Hillcrest Rd, Nashville, TN, 372810.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51521TPABetty Alvarez1972-04-14——5477 Mountain View Dr, Scottsdale, AZ, 852230.80City re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58037TPARonald Price1983-08-01——280 Spring St, Gilbert, AZ, 852000.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-53363TPALuis Burns2000-08-08——3270 Oak St, Denver, CO, 802190.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60255TPAJanet Dixon2007-10-04——2945 Lincoln Way, Houston, TX, 770780.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56946TPAEric Q Andrews1996-10-25——9487 Apache Blvd, Glendale, AZ, 853480.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57800TPAHelen Bailey1953-03-28UHC-99440-30—6658 Maple Ave, Seattle, WA, 981720.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-58019TPAHarold K Mejia1969-10-17—51633202942037 Desert Sky Blvd, Las Vegas, NV, 891090.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55073TPALinda Smith1989-09-17—89094506786905 Hillcrest Rd, Tempe, AZ, 852220.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59458TPAMegan Berry1943-10-26—70576943096422 Highland Ave, Sacramento, CA, 958880.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-59852TPAFrank Fernandez1960-04-04UHC-46561-13—6763 Mesa Dr, Glendale, AZ, 853230.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62816TPAMatoe Welch1945-11-08——5941 Apache Blvd, San Antonio, TX, 782790.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52777TPAArjun Sanders1961-05-25UHC-60332-28—1118 Oak St, Miami, FL, 331900.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-56928TPAKaren Woods1944-07-03——9357 Indian School Rd, Plano, TX, 750140.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55013TPABilly Alexander1946-04-05UHC-77283-8748148170401182 Central Ave, Tampa, FL, 336940.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-64416TPAFrances Meyer1984-11-08——4342 Main St, Phoenix, AZ, 850910.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58323TPALarry Chapman1981-11-16——3349 Union St, Eden Prairie, MN, 553900.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 172 of 290PreviousNext