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-60556TPAChuck Cook——89075721887669 Hillcrest Rd, Orlando, FL, 328120.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-51382TPAMaria B Davis1996-12-03——8013 Union St, Miami, FL, 331320.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-64059TPADaniel Wright1993-01-04——3838 Lincoln Way, Las Vegas, NV, 891670.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-63465TPAAhmed James1988-02-08UHC-42404-33—818 Jefferson Ave, Austin, TX, 787540.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62664TPAAustin Allen1939-03-24———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-60674TPAJoshua Fisher1995-07-05——4253 Meadow Ln, Los Angeles, CA, 900160.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53206TPABenjamin Watkins1942-03-15——8979 Valley View Dr, Phoenix, AZ, 850880.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53726TPADonald Fields1981-05-24——7784 Broadway, Houston, TX, 770760.82Phone missing area codeCity re-casedPlaceholder values cleared
TPA-62603TPAFrank Kelly2001-03-11UHC-37839-13——0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64191TPAJordan U Garza1949-11-27UHC-94287-98—5075 Harbor Blvd, Phoenix, AZ, 850410.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62538TPAPeter Fowler1970-09-13———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61285TPAAdam Edwards1967-10-25—56628147585370 Central Ave, Chandler, AZ0.82Date of birth reformattedZIP missingPlaceholder values cleared
TPA-52355TPASean Collins1995-06-27UHC-91688-56—3968 Elm St, Chandler, AZ, 852060.82Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-63801TPALuis Rogers1996-06-13——1887 Broadway, Las Vegas, NV, 891180.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61143TPAMicheel V Cole1958-07-12———0.82SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-61174TPACharles McCoy1959-02-27——7434 Maple Ave, Denver, CO, 802710.82Name re-casedGender normalisedPlaceholder values cleared
TPA-51556TPABradley Freeman1962-05-01UHC-66492-1884232573757726 Union St, Phoenix, AZ, 850340.82Phone reformattedState name converted to codePlaceholder values cleared
TPA-53841TPAWillie Rivera1960-07-07——9797 Lake View Rd, Los Angeles, CA, 900180.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58705TPADonna Wong1967-09-15——7147 Mountain View Dr, Glendale, AZ, 853960.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-60670TPAJacqueline Bennett1965-08-13—9808476254—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-52495TPAVictoria Evans1994-03-26—21180741339661 Forest Ave, Houston, TX, 770680.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-64334TPAIsabella Gordon———752 Mountain View Dr, Los Angeles, CA, 900620.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-50294TPAWillie Walsh1959-01-26——4995 Broadway, Los Angeles, CA, 900950.82State name converted to codePlan code upper-casedPlaceholder values cleared
TPA-52663TPADiego Baker1956-09-07——8180 Elm St, Atlanta, GA0.82Name re-casedZIP missingPlaceholder values cleared
TPA-56192TPAVictoria Reyes1942-11-19—71639562798842 Valley View Dr, Jacksonville, FL0.82Phone reformattedZIP missingPlaceholder values cleared
TPA-60360TPAJustin Johnson2006-12-05——1128 Sage Ct, Tampa, FL, 336690.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-61979TPAHelen Gray1997-02-18——6062 Canyon Rd # 813, Tucson, AZ, 857920.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-55769TPASean Hunter1963-07-21——6189 Maple Ave, Phoenix, AZ, 850380.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56917TPAChristian Jones1973-03-18UHC-06435-55—1376 Indian School Rd, Columbus, OH, 432870.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56712TPAPamela Varags1976-01-23——366 Willow Ct, San Diego, CA, 921450.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57019TPAEugene Hlal1955-04-03——8430 Palm Dr, Orlando, FL, 328680.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53697TPAJacqueline Adams1996-06-09———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-56241TPAJessica J Barnes1985-08-04———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-57695TPAGerald Ward1970-06-09——9556 Mesa Dr, San Diego, CA, 921000.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61777TPALarry A Evans1973-09-28UHC-51691-53—6969 Harbor Blvd, Mesa, AZ, 852650.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56400TPAJulia F Vasquez1965-12-05——7887 Indian School Rd, Minneapolis, MN, 554360.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60416TPAScott Smith1976-11-03UHC-03157-356786618333—0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60355TPATerry Wood1938-04-05—30980664209822 Meadow Ln, Gilbert, AZ, 852640.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-59349TPAMariana Park1948-07-02———0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-62857TPABenjamin Thompson1990-07-25——6807 Canyon Rd, Denver, CO, 802180.82Date of birth reformattedStreet suffix standardisedAddress re-cased
TPA-56273TPAWilliam Shaw1996-04-14——6955 Park Pl, Los Angeles, CA, 900620.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-57675TPARachel N Evans1992-12-22—64983562966573 Grand Ave, Eden Prairie, MN0.82Phone reformattedZIP missingPlaceholder values cleared
TPA-55243TPAAlbert Luna1957-11-14——908 Pine Dr, Columbus, OH, 432060.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58277TPADylan Graham1991-04-20—63321166265316 Harbor Blvd, Chandler, AZ, 852370.82Phone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-55658TPAKathryn Lawrence——40576601116151 Broadway, Columbus, OH, 432270.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-54655TPALogan Peters2005-10-27—37563733436343 Bayshore Dr, Tampa, FL, 336050.82Name re-casedGender normalisedPlaceholder values cleared
TPA-54097TPASara Cunningham1955-01-17——751 Palm Dr, Nashville, TN, 372780.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54466TPAGloria Fisher1976-08-13——3183 Mesa Dr, Tampa, FL, 336440.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55907TPAAbigail Walker1944-08-21——9062 Ridge Rd, Sacramento, CA, 958150.82City re-casedGender normalisedPlaceholder values cleared
TPA-59780TPALuis Tucker1953-09-13UHC-25918-17—4409 Hillcrest Rd, Atlanta, GA, 303070.82Street suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 210 of 290PreviousNext