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-61987TPASantiago Sandoval1959-10-12——8497 Camelback Rd, San Antonio, TX, 782130.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-55952TPAEugne Hanson1955-06-03——4699 Washington St, Atlanta, GA, 303240.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62075TPANicholas Kim1960-03-04——3831 Grand Ave, Miami, FL, 331190.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-52356TPADanielle N Ellis1990-10-07—43361290165780 Meadow Ln, Sacramento, CA, 958250.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-53648TPAAlice B Owens1997-06-09———0.68Middle initial moved out of first nameDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-54071TPAWaine Bryant1958-12-15UHC-65701-10—7704 Jefferson Ave, Eden Prairie, MN, 553410.68Two-digit birth yearCity re-casedZIP+4 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-53395TPAWayne Matthews2002-04-24——3219 Desert Sky Blvd, Los Angeles, CA, 900270.68Two-digit birth yearStreet 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-52897TPADavid Wallace1969-09-17——1145 Valley View Dr, Phoenix, AZ, 850470.68ZIP+4 trimmedEmail lower-casedGender normalisedPlaceholder 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-63093TPARichard Carpenter1973-01-14UHC-63811-16—1751 Elm St, Fresno, CA, 937660.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64163TPAWilliam Wells1996-06-27—9375878321—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
TPA-59819TPAAlbert H Gardner1993-09-01——232 Jefferson Ave, Mesa, AZ, 852990.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder 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-61780TPASusan Guzman1959-06-14——9558 Desert Sky Blvd, Miami, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-50099TPAEvelyn Knight1989-08-28———0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53734TPAVirginia Jenkkins1985-02-17——3009 Park Pl, Denver, CO, 802900.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-51981TPARichard Little1942-10-15——2180 Baseline Rd Apt 37, San Antonio, TX, 782300.68Phone missing area codeUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-58024TPAGerald Henderson1955-08-11——7915 Forest Ave, Gilbert, AZ, 852180.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56426TPAAshley Alvarado1992-05-17UHC-25866-63—5400 Washington St, Atlanta, GA, 303770.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
TPA-52627TPAJimmy Hamilton1994-09-27——2485 Mountain View Dr, Los Angeles, CA, 900400.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder 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-52236TPAArthur Greene2006-06-20———0.68Name re-casedTwo-digit birth yearSSN last four extractedPlaceholder 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-62727TPARyan Washington1986-04-02UHC-71334-4444320455157264 Lincoln Way Apt 7, Glendale, AZ, 853610.68Unit split from streetStreet 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-54926TPAJulia Morgan1987-02-28UHC-28771-049206669929419 Willow Ct, Minneapolis, MN, 554190.68Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed
TPA-51920TPAPatrick Gutierrez1993-10-02——6794 Cedar Ln, Mesa, AZ0.68State name converted to codeZIP missingWhitespace trimmedPlaceholder values cleared
TPA-55980TPATerry Schmidt1993-06-16——4118 Pine Dr, Miami, FL, 331960.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52779TPABilly Austin1944-10-09——386 Ocean Ave, San Diego, CA, 921710.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder 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-62304TPAAmanda Ford1946-05-22——251 Baseline Rd, Tucson, AZ, 857260.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
TPA-61049TPADanielle Henry1950-11-16———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56661TPAAaron Peters2003-03-09——7769 Church St Apt 22, Charlotte, NC, 282420.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59369TPASean Le———465 Willow Ct, Austin, TX, 787430.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder 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-54748TPASamuel Marshall2008-01-11——185 Union St, Columbus, OH, 432420.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
TPA-56409TPANicole A Myres1997-10-22——1400 Union St # 661, Eden Prairie, MN, 553550.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52013TPAJennifer P Carr1949-11-05UHC-46410-65—2820 Hillcrest Rd, San Antonio, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
TPA-51479TPAWayne Luna1942-05-16——9591 Jefferson Ave, Denver, CO, 802320.68Two-digit birth yearStreet 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-54623TPAMei Little——32665804638602 Central Ave, Eden Prairie, MN, 553100.68Date of birth missingState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-54543TPABrian Hall1946-06-06UHC-70681-11—7724 Ridge Rd # 458, Dallas, TX, 752810.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 95 of 290PreviousNext