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
CLM-402289CLMLauren Guzman1969-10-09UHC-74677-1480472475126579 Bayshore Dr, Dallas, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-407703CLMNatalie Singh1946-01-04——1116 Market St, Chandler, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-406932CLMAmber O Delgado1998-09-15UHC-52060-85—6469 Market St, Minneapolis, MN, 554010.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-107715ENRBenjamin W Brown1951-08-19UHC-16254-0688480624639444 Union St, Mesa, AZ, 852840.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-109109ENRMarilyn H Herrrera1959-02-03UHC-34250-0528437424609296 Ridge Rd, Orlando, FL, 328340.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426608CLMSarah Fisher1964-11-02UHC-62164-9883661733434209 Pine Dr, Fresno, CA, 937650.52Name split from “Last, First”Date of birth reformattedZIP+4 trimmedGender normalised+2 more
CLM-416321CLMGabriel Carr2007-02-14——2015 Jefferson Ave, Tempe, AZ, 852720.52Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+2 more
CLM-408729CLMFernandez Maria1962-12-10UHC-85600-60—9762 Forest Ave, Gilbert, AZ, 852550.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56299TPAJudith Gomez1944-02-18——7594 Pine Dr # 271, Denver, CO, 802310.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-114754ENRBryan Morrison1992-11-17UHC-63751-61—2645 Harbor Blvd Apt 40, Seattle, WA, 981550.52Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
TPA-63202TPABarbara C Carroll1966-01-23——7998 Harbor Blvd, San Diego, CA, 921160.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59221TPAArthur Kelley1973-10-12——5723 Washington St, Jacksonville, FL, 322020.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-115920ENRJess K Stephens1948-06-15UHC-76732-26—9811 Canyon Rd, Eden Prairie, MN, 553400.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-430828CLMSandra Jaackson1946-04-25UHC-53077-56—3183 Union St # 539, Fresno, CA, 937280.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431878CLMJeremy Dunncan1977-04-20——3976 Mountain View Dr, Fresno, CA, 937090.52SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-21151PRVKenneth Payne1973-10-27UHC-66838-75—4077 Grand Ave, Chandler, AZ, 852230.52Name re-casedTwo-digit birth yearSSN last four extractedState name converted to code+2 more
ENR-115117ENRJerry L Riey1941-10-02UHC-25201-66—4607 Pine Dr, Charlotte, NC, 282140.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-403856CLMShirley Fowler1997-01-19UHC-32210-23—6694 Sage Ct, San Diego, CA0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-52298TPAKeith Hernandez1998-11-21—43535180611394 Apache Blvd # 931, Scottsdale, AZ, 852390.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-117558ENRStephanie Knight1950-11-05UHC-08962-3852489639256930 Main St, Gilbert, AZ, 852840.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-420586CLMMargaret Carlson1983-05-22——4067 Ridge Rd, Plano, TX, 750030.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118552ENRBenjamin Moore—UHC-21155-1224564250658078 Meadow Ln, Jacksonville, FL, 322850.52Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+2 more
ENR-126172ENRAna TJunk1940-12-03UHC-78398-3248232537067129 Washington St, Orlando, FL, 328300.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-130984ENRBradley Z Lawrence1954-01-17UHC-30637-6329937092656725 Valley View Dr Apt 6, Atlanta, GA, 303650.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-138211ENRHeather Nelson1977-12-27UHC-32033-8893445338183480 Main St # 814, Plano, TX0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-142089ENRBobby T Bailey1943-08-01UHC-45632-4931460302802275 Baseline Rd, Plano, TX, 750320.52Middle initial moved out of first nameTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-426411CLMFrances Payne2003-01-05——2425 Willow Ct, Scottsdale, AZ, 852520.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-61323TPAJennifer Castro1950-04-02——1633 Sage Ct Apt 35, Jacksonville, FL, 322870.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57662TPAAustin C Richards1989-08-07——9292 Forest Ave, Seattle, WA, 981680.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-132080ENRJudy X Walker1964-12-08UHC-62518-6361757550141921 Grand Ave, Fresno, CA, 937280.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115901ENRSofia Anderson1967-01-26UHC-62309-8681541758395335 Forest Ave, Fresno, CA, 937620.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-27893PRVElijah Weaver1954-12-01UHC-12057-3639124032862757 Cedar Ln, Seattle, WA, 981800.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
ENR-123483ENRMichael Q Santiago1982-03-19UHC-18032-1224729443226144 Indian School Rd # 650, Atlanta, GA, 303130.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-59929TPACharlotte Welch2005-01-19——3149 Cedar Ln, Plano, TX, 750390.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-121827ENRBeverly D Wodos—UHC-61084-844206867407715 Willow Ct, Chandler, AZ, 852770.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126777ENRNick V Jones1987-04-25UHC-74859-2032967397392080 Valley View Dr, Nashville, TN0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-124107ENRPatricia I Edwards1990-08-27UHC-40472-1330179064481996 Elm St, Tampa, FL, 336610.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111833ENRJoan F Jacobs1985-03-01UHC-79278-16—4384 Cedar Ln, Miami, FL, 331330.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-139288ENRChrristian Ruiz2004-06-11UHC-87732-2765236601645969 Willow Ct, Gilbert, AZ, 852360.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422762CLMOmar Freeman1968-07-21UHC-21072-5871127394046603 Highland Ave, Seattle, WA, 981780.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-114511ENRDoris Yang1968-12-03UHC-09369-7922824482213736 Pine Dr, Phoenix, AZ, 850140.52Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-129111ENRKevin Reyes1938-04-09UHC-54672-045716478007172 Sage Ct, Seattle, WA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-129112ENRKevin Reyes1938-04-09UHC-54672-045716478007172 Sage Ct, Seattle, WA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117546ENRLogan Y Gonzales1986-07-13UHC-19729-25—6025 River Rd, Orlando, FL, 328990.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428152CLMGloria Yang1940-02-03UHC-03625-33—9382 Indian School Rd, Orlando, FL, 328710.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118590ENREmma Hudson1975-12-12UHC-78903-5596226915425153 Sunset Blvd, Phoenix, AZ, 850850.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-56601TPALaura Watkins1961-02-15——2762 Willow Ct, Mesa, AZ, 852310.52Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+2 more
CLM-413032CLMBrittany Lucas2000-03-27——1258 Park Pl, Plano, TX, 750170.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-121403ENRChristian Y Castillo1973-10-17UHC-97898-4469937274185226 Mountain View Dr, San Diego, CA, 921230.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-122077ENRAaron D Clark1940-11-08UHC-73956-3041581406151800 River Rd Apt 39, Charlotte, NC, 282020.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 182 of 2,000PreviousNext