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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-50656TPAAmanda Lee1944-07-18——114 Mesa Dr, Atlanta, GA, 303380.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-53774TPASusan Murphy1996-06-03———0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58005TPARobert Franklin1956-02-12—7522231700—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
TPA-53575TPAYuki Wagner1980-05-17UHC-11396-966375562087123 Sage Ct, Nashville, TN, 372050.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-61232TPAAhmed Li1964-03-09—8592720573754 Elm St, Seattle, WA, 981040.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-51704TPATony Jenesn1983-08-12——4054 Church St, Tampa, FL, 336360.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-55034TPATran Brenda1994-10-17——9506 Lake View Rd Apt 23, Tucson, AZ, 857390.68Name re-casedUnit split from streetGender normalisedPlaceholder values cleared
TPA-63385TPABryan Weber1945-07-26UHC-47291-99—5198 Willow Ct, Fresno, CA0.68Name re-casedState name converted to codeZIP missingPlaceholder values cleared
TPA-62897TPABruce Q Wilson2007-09-09——2098 Baseline Rd, Tampa, FL, 336680.68City re-casedState name converted to codeGender normalisedPlaceholder values cleared
TPA-55552TPASarah Singh2004-10-21——6395 Bayshore Dr, Nashville, TN, 372240.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-61701TPATyler Patel1955-10-09UHC-72738-99—2695 Hillcrest Rd, Dallas, TX0.68Name split from “Last, First”Date of birth reformattedZIP missingPlaceholder values cleared
TPA-58984TPAJerry Martin1939-03-08——8116 Ridge Rd, Nashville, TN, 372560.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59615TPAJulie Carroll1953-12-25———0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59975TPADennis Hill1956-09-17——1492 Ridge Rd, Houston, TX, 770570.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59674TPAJuan Morrison1942-06-03—8823937301917 Cedar Ln, Jacksonville, FL, 322630.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
TPA-50018TPAJeremy Franklin1974-09-25——3588 Jefferson Ave, Houston, TX, 770630.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59568TPAStephen Mills2006-12-22—65887820492771 Willow Ct, Nashville, TN, 372450.68Two-digit birth yearPhone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-52260TPABilly Morgan1977-10-28——2010 Union St, Denver, CO, 802240.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50389TPAMarcus Wallace———7455 Palm Dr, Plano, TX, 750300.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50150TPAAnna Stevens1970-11-09UHC-64371-85—582 Union St, Orlando, FL, 328280.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63363TPAAusttin Li1943-07-11—81432750554095 Bayshore Dr, Scottsdale, AZ, 852620.68Two-digit birth yearZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-50328TPAGary Arnold1996-08-01—73621482744541 Baseline Rd, Dallas, TX, 752460.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-62594TPAHelen Snyder1967-06-25——4492 Ridge Rd, Atlanta, GA, 303330.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-59535TPAJeffrey Bradley———3300 Cedar Ln, Eden Prairie, MN, 553210.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52125TPAKayla Williamson2008-07-14——9478 Jefferson Ave, Columbus, OH, 432210.68SSN last four extractedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50976TPAAaron Z Chapman1967-06-11—80248730157379 Grand Ave, Minneapolis, MN0.68Phone reformattedState name converted to codeZIP missingPlaceholder values cleared
TPA-60391TPAJanet Hakins1996-03-26—56958963147647 Mesa Dr, Tucson, AZ, 857040.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63784TPATerry Williams1939-10-17UHC-02175-32—9227 Cedar Ln # 409, Nashville, TN, 372680.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57005TPAAlexander Johnston2006-02-24——3793 Lake View Rd Apt 3, Gilbert, AZ, 852470.68Unit split from streetZIP+4 trimmedEmail lower-casedPlaceholder values cleared
TPA-56904TPAGeorge F Salazar———1928 Palm Dr, San Antonio, TX, 782720.68Name re-casedDate of birth unreadableGender normalisedPlaceholder values cleared
TPA-57724TPAJoyce Snyder1961-01-07UHC-38342-05—7991 Meadow Ln, Glendale, AZ, 853500.68Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code
TPA-56793TPACaterine Lawrence1957-05-18——9836 Canyon Rd Apt 22, Chandler, AZ, 852490.68Name re-casedTwo-digit birth yearUnit split from streetPlaceholder values cleared
TPA-53265TPAVincent Meyer2005-07-25——7588 Camelback Rd, Dallas, TX, 752510.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-58881TPAJessica G Marquez1995-02-23——2107 Sunset Blvd, Gilbert, AZ, 852120.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64248TPADenise Mills1982-03-24———0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-54198TPAGerald Nichols1956-12-02——592 Broadway, Los Angeles, CA, 900920.68Name re-casedState name converted to codeGender normalisedPlaceholder values cleared
TPA-63785TPAAlexis Elliott1965-02-04——9576 Cedar Ln, Atlanta, GA, 303440.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55667TPAKimberly Mitchell1945-05-18—54694203962928 Ridge Rd, Phoenix, AZ, 850960.68ZIP+4 trimmedEmail lower-casedGender normalisedPlaceholder values cleared
TPA-58202TPASophia Roberts1942-06-05UHC-04642-04—3413 Valley View Dr, Austin, TX, 787200.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-61895TPAElijah Campbell1959-10-22———0.68Phone missing area codeGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52546TPAMartha Austin1992-04-23—32030480964820 Ocean Ave, Denver, CO, 802040.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-60677TPASue Vazquez2007-09-06UHC-84134-2232069877617588 Apache Blvd, Eden Prairie, MN, 553780.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-56963TPAJudy Williams1997-09-06—4322595626—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56962TPAJudy Williams1997-09-06—4322595626—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59354TPARandy L Lawrence———9077 Oak St, Las Vegas, NV, 891310.68Name re-casedDate of birth unreadableZIP+4 trimmedPlaceholder values cleared
TPA-64041TPAJuan Y Williams1981-08-04—84323270177824 Sunset Blvd, Los Angeles, CA, 900490.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61500TPADanielle Palmer2001-07-22UHC-01567-87—9568 Maple Ave, San Diego, CA, 921620.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53281TPASophia Back2005-12-01——5644 Hillcrest Rd, Dallas, TX, 752550.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-56874TPAMaosn Wong1991-01-03——4234 Willow Ct, Los Angeles, CA0.68State name converted to codeZIP missingWhitespace trimmedPlaceholder values cleared
TPA-63226TPAAshley D Parker1968-02-15——277 Park Pl, Tempe, AZ0.68Middle initial moved out of first nameName re-casedZIP missingPlaceholder values cleared
14,474 rows, page 99 of 290PreviousNext