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-52235TPAArthur Greene2006-06-20—37035981624014 Cedar Ln, Atlanta, GA, 303920.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-62362TPAJose G Williams1949-06-05——4096 Oak St Apt 23, Las Vegas, NV, 891250.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-61815TPAKimberly Stewart1998-11-18——7738 Harbor Blvd, Denver, CO, 802430.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58203TPAGloria Bery2008-08-04—76444995555979 Sage Ct, Mesa, AZ, 852160.80Date of birth reformattedPhone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-59301TPAJoseph Bradley1997-05-12———0.80Two-digit birth yearPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-53840TPAWillie Rivera1960-07-07—37167640229797 Lake View Rd, Los Angeles, CA, 900180.80Date of birth reformattedCity re-casedState name converted to codePlaceholder values cleared
TPA-59956TPABrian Gray1996-10-24——6673 Valley View Dr, Seattle, WA, 981130.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-50390TPADonald Morrison1970-11-26——6285 Park Pl, Denver, CO, 802830.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54138TPAAngela Wang1967-03-01——8641 Valley View Dr, Orlando, FL, 328870.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50960TPAChristina Bradley1958-08-26—9852474058934 Apache Blvd, Plano, TX, 750780.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-51128TPAKally Lawson1976-01-10—88883849922654 Sunset Blvd, Miami, FL, 331920.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61357TPAAmber Jordan1985-02-17——1088 Sunset Blvd, Seattle, WA, 981860.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57627TPAScott Gonzales1994-01-25—44277066297746 Pine Dr, Tampa, FL, 336420.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-54587TPASandra Powell1958-01-16——2109 Central Ave, Eden Prairie, MN, 553390.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-57836TPAGerald T Sandoval—UHC-41043-56—1877 Mesa Dr, Mesa, AZ, 852120.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-62801TPAKevin Willis1978-08-28——8245 Valley View Dr, San Diego, CA, 921010.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55426TPAGabriel Romero1952-06-22———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-61170TPARoy Spencer1981-07-16——7299 Main St, Fresno, CA, 937580.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-59706TPAJeffrey Dominguez1962-05-18——6186 Baseline Rd, Sacramento, CA, 958510.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50749TPAAndrea Holmes1965-05-05——1113 River Rd, Atlanta, GA, 303360.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56304TPAJeremy Ortega2002-08-07——4675 Indian School Rd, Charlotte, NC, 282780.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52704TPACatherine E Taylor1965-12-12—82840898757245 Hillcrest Rd, Chandler, AZ, 852530.80Gender normalisedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-62712TPAGeorge C Hicks1998-07-23——2519 Forest Ave, Sacramento, CA, 958680.80State code upper-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-50339TPAMargaret Pena1985-10-06—9358328314978 Market St, Eden Prairie, MN, 553190.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55303TPAKenneth Harrison1961-04-04——1680 Lake View Rd, Las Vegas, NV, 891770.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53910TPAPaul Warren1988-02-11—65589863934438 Willow Ct, Los Angeles, CA, 900340.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-63937TPAPatricia Parker1956-07-15——2919 Lake View Rd, Tucson, AZ, 857430.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-52082TPALucia Jenkins1993-12-04——1182 Main St, Glendale, AZ, 853170.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55235TPAAhmed Hicks1956-08-28——8970 Union St, Jacksonville, FL, 322820.80Date of birth reformattedCity re-casedGender normalisedPlaceholder values cleared
TPA-60279TPAJonathan Burke1994-02-09——2114 Spring St, Dallas, TX0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-56186TPAKaren Lucas1976-10-28—81691945947119 Palm Dr # 319, Dallas, TX, 752610.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-53057TPANicholas Bradlley1954-07-23——9694 Broadway, Las Vegas, NV, 891120.80Name split from “Last, First”Date of birth reformattedAddress re-casedPlaceholder values cleared
TPA-52222TPAPatricia Grant1962-11-13——2725 Hillcrest Rd, Mesa, AZ, 852640.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52613TPAJack Harris1949-11-01——3975 Cedar Ln, Plano, TX, 750930.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54409TPASteven Nelson1964-01-11UHC-42830-85—960 Apache Blvd, Chandler, AZ, 852110.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58521TPASara Gibson1955-12-02—95929434737592 Indian School Rd, Dallas, TX, 752820.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55091TPAElizabeth Crawford2002-07-18—6113531127—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50970TPABruce Fisher1991-10-14——1939 Pine Dr, Charlotte, NC, 282680.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-56360TPAGeorge Torres1964-05-20—92941626494804 Market St, Mesa, AZ, 852670.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-62784TPAAndrea Griffin1985-06-07—98265628555822 Bayshore Dr, Charlotte, NC, 282030.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64367TPAMadison Ramos2002-07-03——5080 Bayshore Dr, Las Vegas, NV0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-59581TPAHiroshi Flores1966-10-20———0.80Name re-casedDate of birth reformattedSSN last four extractedPlaceholder values cleared
TPA-59457TPAMegan Beerry1943-10-26——6422 Highland Ave, Sacramento, CA0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-64071TPABeverly Singh1958-07-28UHC-78091-79—8154 Sunset Blvd, Seattle, WA, 981320.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61104TPAColeman Steven1943-09-27———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-51844TPAPriya Rodriguez1950-11-12—68898219013100 Apache Blvd, Seattle, WA, 981740.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63225TPAAshley Parker1968-02-15UHC-65675-266409045682277 Park Pl, Tempe, AZ, 852750.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62855TPACynthia Ramirez————0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
TPA-62571TPAMichael Holmes1999-05-15—47262860456651 Broadway # 297, Dallas, TX, 752630.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-62924TPAHiroshi Holmes1973-11-23——1266 Lincoln Way, Phoenix, AZ, 850510.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 191 of 290PreviousNext