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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-62075TPANicholas Kim1960-03-04——3831 Grand Ave, Miami, FL, 331190.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-51563TPAOlivia Daniels1944-04-16——6761 Jefferson Ave, Las Vegas, NV, 891830.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61810TPACamila E Kim1941-12-18——9411 Sunset Blvd, Columbus, OH, 432660.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50104TPAJonathan Black1952-12-24UHC-08559-01—6042 Forest Ave, Seattle, WA, 981840.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-54474TPASarah Edwards1941-04-27——7813 Main St, San Diego, CA, 921180.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64163TPAWilliam Wells1996-06-27—9375878321—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
TPA-58095TPAPhilip Larson1953-11-19——5533 Market St, Tucson, AZ, 857030.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50099TPAEvelyn Knight1989-08-28———0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51291TPAArjun Turner1984-09-08——8735 Valley View Dr, Phoenix, AZ, 850670.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-61762TPASofiia Davis1971-05-14——1258 Willow Ct, Eden Prairie, MN, 553890.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55945TPASara N Matthews1971-11-11—25284523676688 Highland Ave, Nashville, TN, 372750.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58449TPASamuel Salazar1980-09-13——8284 Harbor Blvd, Sacramento, CA, 958510.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55925TPACamila Marshall1940-01-08——3494 Ridge Rd, Miami, FL, 331280.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60126TPAMelissa Gardner1993-09-15——8347 Lincoln Way, Tucson, AZ, 857940.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-59155TPADennis Hansen1940-05-06—65844967284410 River Rd, Tampa, FL, 336670.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59156TPADennis Hansen1940-05-06—65844967284410 River Rd, Tampa, FL, 336670.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53692TPABobby Anderson1978-03-09——3664 Harbor Blvd # 951, Minneapolis, MN, 554910.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
TPA-64399TPAAysha I Crawford1997-04-11UHC-96544-64—5164 Meadow Ln, Fresno, CA, 937710.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
TPA-63640TPAKaren Young1971-06-26——2949 Hillcrest Rd, San Diego, CA, 921640.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52764TPAElijah Ryan1991-11-22UHC-60945-02—1873 Meadow Ln, Austin, TX, 787910.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52157TPAAmy McDonald1991-08-25—79178476223775 Valley View Dr, Sacramento, CA, 958490.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
TPA-53957TPAJacob Fowler1940-06-26——2147 Valley View Dr, Miami, FL, 331400.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61846TPAMatthew Warren1958-10-03——6845 Lake View Rd, San Diego, CA, 921540.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
TPA-56843TPALinda Green1970-08-10——8032 Valley View Dr, Los Angeles, CA, 900380.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57893TPAPaul Luucas1946-06-15——3616 Camelback Rd, Jacksonville, FL, 322620.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62043TPAOlivia Lynch1991-07-18——4811 Central Ave, Dallas, TX, 752430.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57661TPAKelly Morris1994-11-22——6358 Sage Ct, Orlando, FL, 328560.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50560TPAAnthony Johnson1959-04-12——4195 Meadow Ln, Orlando, FL, 328720.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50561TPAAnthony Johnson1959-04-12——4195 Meadow Ln, Orlando, FL, 328720.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56757TPAWalter Aguilar2001-02-15——2327 Ridge Rd, Dallas, TX, 752470.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57876TPAJoan Kennedy1999-02-03——1032 Highland Ave, Minneapolis, MN0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-54667TPAMartin Mei1966-04-22——9829 Hillcrest Rd, San Antonio, TX, 782280.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58675TPABryan Jenkins1945-05-18—78042105385150 Cedar Ln, San Diego, CA, 921390.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61586TPASamuel George2008-12-03——2754 Cedar Ln, Denver, CO, 802220.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51126TPAGregory Richardson1960-04-11——1687 Palm Dr, Dallas, TX, 752710.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-62720TPARebecca Fox2000-12-04UHC-05601-414408713521—0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-58886TPADiana Estrada1987-06-14——6741 Cedar Ln, Fresno, CA, 937060.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51363TPAJoe Stephens1975-03-11—3118285793302 Church St, Columbus, OH, 432370.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-60051TPAScott Maldonado1988-06-23——5599 Palm Dr, Atlanta, GA, 303170.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59479TPAAlexander Rivera1958-07-12——298 Washington St, Phoenix, AZ, 850870.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57211TPALaura Black1958-12-07——3594 Washington St, Houston, TX, 770920.68Name split from “Last, First”City re-casedZIP+4 trimmedPlaceholder values cleared
TPA-58052TPASara Y Grant1987-01-24——5202 Cedar Ln, Plano, TX, 750500.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-57538TPARussell Matthews——9684397875—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-59989TPAMateo Ray2006-10-13———0.68Name split from “Last, First”Date of birth reformattedSSN last four extractedPlaceholder values cleared
TPA-62393TPABlack Evelyn1953-10-02——8411 Union St, Columbus, OH, 432280.68Name split from “Last, First”Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-53761TPAJoshua O Sanchez1998-09-25—39449025547066 Lincoln Way, Dallas, TX, 752820.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
TPA-54873TPAMaria Kelly1970-02-25——478 Spring St, Minneapolis, MN, 554560.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53311TPABruce Sanchez1966-12-13—94094832069891 Highland Ave, Tempe, AZ, 852160.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
TPA-57849TPARoger Nelson1989-06-14——1103 Desert Sky Blvd, Tucson, AZ, 857330.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-55442TPAHarold Rogers2005-10-15——955 Lake View Rd, Eden Prairie, MN, 553010.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
1,488 rows, page 20 of 30PreviousNext