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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-62805TPAPamela Gibsson1956-08-17UHC-70252-36—5051 Willow Ct, Phoenix, AZ, 850760.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-126405ENRKayla I Cole1978-01-06UHC-96523-8469298891491075 Sunset Blvd, San Antonio, TX, 782480.52Two-digit birth yearPhone reformattedState name converted to codeGender normalised+2 more
ENR-130627ENRCarolyn Y Porter1960-04-02UHC-22051-9296045202104594 River Rd, Sacramento, CA, 958150.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-52438TPAAlexis A Johnsson1980-05-11——6585 Church St, Dallas, TX, 752300.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-52439TPAAlexis A Johnsson1980-05-11——6585 Church St, Dallas, TX, 752300.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431174CLMVirginia Fernandez1973-06-03UHC-33328-148542792861—0.52Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more
CLM-412575CLMJoe Ford———1902 Highland Ave, Chandler, AZ, 852010.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-102557ENRLaura O Andrews1980-06-20UHC-68182-6526881387042321 Maple Ave Apt 2, Los Angeles, CA, 900910.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-105911ENRJesse Black1982-07-10UHC-62534-65—7388 Maple Ave, Dallas, TX, 752470.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-112612ENRBradley G Austin1938-05-07UHC-84381-5841167534797207 Washington St, Fresno, CA, 937380.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-123393ENRMaria V Wagner1983-05-02UHC-23015-9440591796344726 Valley View Dr Apt 13, Orlando, FL, 328770.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414974CLMKeith Vasquez2000-09-04UHC-43961-56—5742 Maple Ave, Columbus, OH, 432990.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-419817CLMDoris Elliott1948-06-26——7824 Lake View Rd, Chandler, AZ, 852220.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-105961ENRHeather O Griffin1987-08-11UHC-60659-3182482290928521 Palm Dr, Jacksonville, FL, 322780.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431450CLMAnna Weaver1965-12-26——400 Forest Ave, Scottsdale, AZ, 852210.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-125094ENRAnn O Fernandez1995-04-14UHC-94337-3198482790378664 Lake View Rd, Seattle, WA, 981120.52Name split from “Last, First”Date of birth reformattedState name converted to codeZIP+4 trimmed+2 more
TPA-62590TPACarol Pena1959-05-16UHC-65801-28—656 Maple Ave, Eden Prairie, MN, 553750.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-122678ENRFatima Reyes—UHC-25320-9583961708383893 Meadow Ln # 874, Charlotte, NC, 282040.52Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+2 more
PRV-27676PRVCarlos Estrada1969-05-14——4195 Ocean Ave, Denver, CO, 802810.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-106510ENRAnn Ryan2002-08-24UHC-62398-098399494266423 Oak St, Las Vegas, NV, 891350.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-113380ENRWilliam I Stevens—UHC-54815-5227543458465378 Palm Dr # 216, Los Angeles, CA, 900020.52Name re-casedDate of birth missingPhone reformattedUnit split from street+2 more
CLM-417167CLMMatthew Williamson1955-12-05——4340 Harbor Blvd, Houston, TX, 770520.52Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
ENR-127653ENRPatricia K Porter1986-09-25UHC-40405-0546329043928080 Forest Ave Apt 9, Denver, CO0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-21080PRVFatima Green1971-01-19UHC-56858-968975855235764 River Rd, Minneapolis, MN, 554420.52Name split from “Last, First”Date of birth reformattedCity re-casedState name converted to code+2 more
ENR-107906ENRLogan Q Carpenter1977-02-13UHC-39590-29—8727 Lincoln Way, Columbus, OH0.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-134053ENRLawrence A Aguilar2007-10-12UHC-50675-3466427266981029 Lake View Rd, Fresno, CA, 937640.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127477ENRAndrea V Peters1962-05-26UHC-05108-5292542790595022 Lake View Rd, Tampa, FL0.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-408569CLMTimothy Obrien1994-05-22UHC-68603-349698669011631 Sunset Blvd, Mesa, AZ, 852320.52Name split from “Last, First”Name re-casedPhone reformattedStreet suffix standardised+2 more
ENR-126963ENRAbby U Peters2003-10-20UHC-38914-38—8838 Elm St, Atlanta, GA0.52Two-digit birth yearState code upper-casedZIP missingGender normalised+2 more
ENR-141500ENRMaria Chavez1990-06-03UHC-13335-7056495863678628 Camelback Rd, Miami, FL, 331460.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-418417CLMRyan L Hunter1965-10-05UHC-48235-63—7479 Forest Ave Apt 28, Charlotte, NC, 282090.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430864CLMDonna Lucas1972-08-05UHC-67714-8435496133612603 Camelback Rd, Sacramento, CA, 958310.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133897ENRKile P Fields1951-05-23UHC-45606-1522977338887188 Broadway, Plano, TX, 750980.52Date of birth reformattedSSN last four extractedZIP+4 trimmedGender normalised+2 more
ENR-100468ENRPhilip N Le1980-02-05UHC-73994-3140162381176056 Union St, San Diego, CA, 921120.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-134835ENRRuth B Spencer2002-07-12UHC-50944-6347884323341966 Main St, Tempe, AZ, 852410.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-22159PRVChristina Meyer1958-09-22UHC-53968-3778537666729661 Maple Ave, Sacramento, CA, 958610.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423035CLMCamila J Guerrero1977-02-06——3791 Ridge Rd, Charlotte, NC, 282180.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420489CLMAbigail Peters——41453092938838 Elm St, Atlanta, GA, 303730.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126877ENRKeith Martiinez2000-09-23UHC-16946-7755548972935721 Spring St, Glendale, AZ, 853850.52Name split from “Last, First”Phone reformattedState name converted to codeEmail lower-cased+2 more
CLM-404361CLMIsabella Burns1948-08-20UHC-10907-04—709 Mountain View Dr, Atlanta, GA, 303970.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-113999ENRKenneth Hernandez1978-11-12UHC-86070-6553089974454079 Valley View Dr, Glendale, AZ, 853870.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-122760ENRWillie Hawkins1985-04-09UHC-80056-207353611040655 Indian School Rd # 286, San Antonio, TX, 782090.52Phone reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
PRV-24469PRVJoshua Gordon1958-12-25——4104 Union St, Jacksonville, FL, 322860.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-58173TPASusan Wang2008-01-18——4062 Central Ave # 224, Orlando, FL, 328470.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426785CLMAngela Ellis1949-03-02UHC-75200-9344637625832733 Baseline Rd # 743, Tampa, FL, 336900.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-419717CLMAmber Bradlye1985-11-09UHC-76447-81399719962661 Market St, Houston, TX, 770430.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-410623CLMKeith Campbell1962-05-19UHC-28637-30—5441 Meadow Ln # 306, Nashville, TN, 372340.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-125597ENRVincent Taylor1947-07-13UHC-79415-0744398953878637 Grand Ave, Tucson, AZ, 857220.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142812ENRAisha Burke1960-12-03UHC-42201-9195748805808632 Oak St, Plano, TX0.52Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
ENR-131843ENRJoshua V Perry1990-06-24UHC-65921-8085657037867612 Valley View Dr, Jacksonville, FL0.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
100,000 rows, page 159 of 2,000PreviousNext