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-60085TPAAna Bailey1955-11-03—65246790349425 Forest Ave, San Diego, CA, 921570.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54379TPAAnn Thompson1985-01-23—94133724762064 Pine Dr, Tempe, AZ, 852180.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61116TPAFrances Hanson1954-10-11—42158863753170 Valley View Dr, Glendale, AZ, 853680.80Name re-casedPhone reformattedSSN last four extractedPlaceholder values cleared
TPA-57230TPARtuh Mills1958-02-08——6603 Elm St, Nashville, TN, 372050.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-52149TPAKeith Baker1966-03-09——3446 Indian School Rd, Tampa, FL, 336510.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57088TPAArjun Torres1986-04-21—79782688164920 Cedar Ln, Orlando, FL0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-56667TPAMargaret Cox1995-02-01———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50539TPALisa Hawkins1973-04-02——910 Pine Dr, San Antonio, TX, 782120.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62751TPALogan Scott1988-08-15——9396 Cedar Ln, Nashville, TN, 372430.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58228TPABurce Gray1997-05-17——3961 Baseline Rd, Minneapolis, MN, 554100.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58227TPABurce Gray1997-05-17——3961 Baseline Rd, Minneapolis, MN, 554100.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60246TPALuis Nunez1978-02-27——967 Bayshore Dr, Tampa, FL, 336010.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-59907TPALarry Brwon1950-04-06UHC-42189-15—9380 Meadow Ln, Miami, FL, 331130.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52973TPAJeffrey Hoffman1975-03-12——697 Lincoln Way, Tucson, AZ, 857330.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52633TPAEmily Peters1962-08-09—51846788232414 Union St, Denver, CO, 802670.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50857TPACatherine Robinson1945-09-28——1847 Willow Ct, San Diego, CA, 921740.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56452TPAPatrick Long1952-01-17—62890513367892 Ridge Rd, San Antonio, TX, 782310.80Date of birth reformattedPhone reformattedState name converted to codePlaceholder values cleared
TPA-58374TPACarl Marshall1963-07-22—68945271111078 Forest Ave, Gilbert, AZ, 852460.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60372TPAArjun Howell1993-05-11——1436 River Rd, Scottsdale, AZ, 852790.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-54862TPARandy Howell1948-03-18——9138 Maple Ave, Tempe, AZ, 852640.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61449TPAKathryn Warren1959-03-12—31671364606289 Jefferson Ave, Los Angeles, CA, 900130.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58393TPABrian Jacobs1995-05-12——3380 Park Pl Apt 1, Phoenix, AZ, 850260.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-57416TPADiana Chen1971-06-13——3556 Meadow Ln, Eden Prairie, MN, 553130.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60998TPAKevin Wallace1941-08-01—21287802651250 Desert Sky Blvd, Houston, TX, 770220.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51990TPADonald Torres1997-12-14UHC-22457-76—8591 Central Ave, San Diego, CA, 921860.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64389TPAAlice Gibson1966-05-04——4012 Elm St, Eden Prairie, MN, 553180.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-64386TPAAnn Lewis1960-10-11UHC-05814-4381593435537741 Mesa Dr, Tampa, FL, 336810.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54082TPARobert Edwards2004-07-11———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54345TPAMartha Tucker1988-10-14——7665 Jefferson Ave, San Antonio, TX, 782410.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60117TPARuth Parker1984-06-02—56131527046694 Sage Ct, Chandler, AZ, 852630.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63799TPASteve Jones1946-11-19——472 Ridge Rd, Chandler, AZ, 852190.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56624TPACarlos Estrada1968-05-07UHC-54030-9690232428192063 Hillcrest Rd, San Diego, CA, 921650.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-50884TPACarlos Lawrence1957-09-19——6107 Mountain View Dr, Phoenix, AZ, 850150.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-56807TPAArjun G Martinez1938-06-17—5955349977210 Union St, Minneapolis, MN, 554360.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-53086TPAJoyce C Chen1986-05-01—6382529071—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64082TPAChristina Ruiz2005-02-21——1263 Ocean Ave, Eden Prairie, MN, 553180.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51686TPARaymond S Aguilar1951-04-03——1291 Highland Ave, Chandler, AZ, 852500.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57378TPAPeter Bennett1998-11-28——9378 Cedar Ln, Tempe, AZ, 852550.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52951TPAWayne Elliott1944-06-02—49166343042609 Central Ave, Tucson, AZ, 857260.80Phone reformattedCity re-casedZIP+4 trimmedPlaceholder values cleared
TPA-54440TPAAndrew Little1972-07-06——3646 Sunset Blvd, Tempe, AZ, 852170.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62842TPAArjun Hudson1999-04-14UHC-69955-67—4237 Sunset Blvd, Gilbert, AZ, 852970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54489TPAMariana Snyder1999-01-24——5485 Mesa Dr, Dallas, TX, 752750.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63902TPAJoan Jimenez1944-02-22——3952 Valley View Dr, San Diego, CA, 921600.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56934TPACarol Phillips1977-12-05—62658824798747 Apache Blvd, Plano, TX, 750760.80Two-digit birth yearPhone reformattedCity re-casedPlaceholder values cleared
TPA-60049TPADouglas Matthews1976-06-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54765TPAWillie B Gonzales2008-09-23UHC-76085-13—4425 Indian School Rd, Austin, TX, 787950.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58446TPARoger Palmer1996-09-07——8924 Sage Ct, Nashville, TN, 372510.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58445TPARoger Palmer1996-09-07——8924 Sage Ct, Nashville, TN, 372510.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52352TPARalph Castro1969-02-21——1774 Elm St, Mesa, AZ, 852270.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60414TPAArjun Jones1953-02-05——8013 Grand Ave, Denver, CO, 802930.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 194 of 290PreviousNext