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

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-53837TPARichard Q Perkins1996-10-09UHC-20022-04—5545 Grand Ave, Jacksonville, FL, 322240.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59578TPATyler Shaaw2000-01-22—5016323481—0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-50461TPAHenry Gray1950-12-21———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-50682TPAMegan Peters1991-08-14——5630 Park Pl Apt 36, Tucson, AZ, 857580.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-58995TPASam Tores1954-08-20——5874 Sunset Blvd, Austin, TX, 787170.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-62610TPAJoseph Pena1945-01-07UHC-35846-37—7383 Church St, Denver, CO0.82Name re-casedZIP missingPlaceholder values cleared
TPA-55362TPAElizabeth Young1979-01-13UHC-34103-14—6703 Sage Ct, Miami, FL, 331330.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54860TPAJacob Phillips1996-11-10—5396455044—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-63949TPASean Cunningham1949-09-07—9739336958—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-60778TPAOlivia Wheeler1965-10-28——8573 Ridge Rd, Mesa, AZ, 852170.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63228TPARachel Fowler1983-05-20UHC-83408-02—8542 Forest Ave, Minneapolis, MN0.82ZIP missingEmail lower-casedPlaceholder values cleared
TPA-56439TPAMaria Wheeler1978-02-11UHC-63171-7828634580136718 Broadway, Austin, TX, 787780.82Two-digit birth yearAddress re-casedPlaceholder values cleared
TPA-57643TPAIsabella Cook2003-12-09——1808 Elm St, Eden Prairie, MN, 553860.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60867TPADoorthy Fox1960-10-15UHC-34920-655793449713—0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-53412TPAKelly Scott1976-02-12—23199540143517 River Rd, Columbus, OH, 432320.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50344TPAAdam R Simpson2005-10-07UHC-19865-62—5333 Harbor Blvd, Phoenix, AZ, 850000.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-60523TPACamila Bennett1992-08-15———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-53538TPACarlos Stone1982-01-01UHC-21036-35—3927 Lincoln Way, Atlanta, GA, 303450.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-52975TPAMichael I Olson1956-12-01—8359858016—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-61382TPAEugene Freeman1961-12-23—85438374395162 Lincoln Way, Scottsdale, AZ, 852510.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50195TPANicole Chen————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-50806TPALucia Turner2001-01-12——7359 Willow Ct, Charlotte, NC, 282400.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59490TPABrian Q Hunt1994-05-23——1019 Harbor Blvd, Austin, TX, 787160.82Middle initial moved out of first nameWhitespace trimmedPlaceholder values cleared
TPA-58526TPAAmber Munoz1984-08-17—55852731899780 Maple Ave, Chandler, AZ, 852750.82Date of birth reformattedPhone reformattedGender normalised
TPA-52978TPADiana James1952-05-22——3640 Sage Ct, Glendale, AZ, 853580.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-53078TPAJesse Hudson——80069282387065 Lincoln Way, Los Angeles, CA, 900250.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-62497TPAAna Adams1944-07-09——9369 Ocean Ave, Phoenix, AZ, 850850.82Name re-casedPhone missing area codePlaceholder values cleared
TPA-63656TPANoah Ferguson1964-06-17UHC-63143-64—4294 Mountain View Dr, Dallas, TX, 752340.82Name re-casedState name converted to codePlaceholder values cleared
TPA-63301TPAZachary Harvy1982-02-22UHC-43673-22—7636 Canyon Rd, Miami, FL, 331760.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61478TPAJoan Brooks1997-11-12———0.82Name re-casedSSN last four extractedPlaceholder values cleared
TPA-55060TPAAlice Foster1955-05-09UHC-43864-94——0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-53572TPAEmma U Scott1979-11-19—43384643403917 Lake View Rd, Tampa, FL, 336070.82Phone reformattedGender normalisedWhitespace trimmed
TPA-51461TPADylan Day1968-03-05—4364032927522 Indian School Rd, Denver, CO, 802140.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-58658TPAMei Munoz1964-12-03——8580 Lake View Rd, Tucson, AZ, 857160.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-58330TPAWei Bradley1967-03-01——1936 Jefferson Ave, Austin, TX, 787800.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62186TPABruce Vazquez1951-05-17—83196691368774 Maple Ave, Gilbert, AZ, 852730.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-58957TPAMary Wheeler1975-09-27——4043 Pine Dr Apt 6, Seattle, WA, 981330.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-64438TPAAna Adams1999-09-22——8157 Harbor Blvd, Orlando, FL, 328870.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52129TPAMarcus Payne1962-12-06UHC-10387-43—8525 Main St, Austin, TX, 787490.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58537TPAPriya Murrya1978-02-02——995 Washington St, Miami, FL, 331560.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56615TPARob Bowman2000-09-24———0.82Name split from “Last, First”Email lower-casedPlaceholder values cleared
TPA-58766TPARonald Burton———8308 Washington St, Denver, CO, 802430.82Date of birth reformattedDate of birth unreadablePlaceholder values cleared
TPA-59175TPADiana Burns2006-11-17UHC-40188-1093174211582843 Jefferson Ave, Miami, FL, 331200.82Phone reformattedZIP+4 trimmedPlaceholder values cleared
TPA-50545TPAKaren Martinez1972-11-01———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-63841TPARichard Medina1972-05-09UHC-46415-439364135708—0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-59121TPAEdward Jacobs1954-03-15———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-58847TPAMadison B Henderson1985-12-16——2197 Highland Ave, San Diego, CA0.82Name re-casedZIP missingPlaceholder values cleared
TPA-63533TPAPatricia Mendez1987-03-22——6039 Highland Ave, Tucson, AZ, 857670.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-58452TPAMary Diaz1973-09-23—54297558977006 Highland Ave, Seattle, WA, 981110.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-55521TPAKaren Wagner1995-02-07——3199 Market St, Nashville, TN, 372130.82Street suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 205 of 290PreviousNext