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-411346CLMWill Dunn1953-06-10UHC-72312-697783642545702 Palm Dr, Atlanta, GA, 303190.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124863ENRRussell Valdez1968-04-09UHC-94337-1063682164555367 Pine Dr, Miami, FL, 331070.48Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
CLM-402869CLMJennifer Phillips—UHC-74884-632782826784338 Main St, Jacksonville, FL, 322680.48Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-420317CLMLori Black1953-07-21UHC-24306-3540895334364320 River Rd, Fresno, CA, 937430.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-406359CLMLucia Lynch1968-04-09UHC-33985-3956048615468941 Forest Ave, Atlanta, GA0.48Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-112853ENRGeorge Banks1987-07-19UHC-71568-86—8067 Washington St, Columbus, OH, 432090.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
PRV-27123PRVOmar Morgan1977-12-03UHC-44342-5355776678779037 River Rd, Sacramento, CA0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-407564CLMMelissa Valdez1954-02-10UHC-81960-04—962 Valley View Dr, Dallas, TX, 752280.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-416814CLMLori J Cruz1990-04-25UHC-87156-17—6582 Sage Ct # 449, Eden Prairie, MN, 553870.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-111925ENRSamantha Ward1944-06-01UHC-62356-3549345635456034 Ridge Rd, Miami, FL, 331860.48Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+4 more
ENR-130369ENREdward X Valdez2006-10-03UHC-62382-438678365610608 Church St Apt 2, Chandler, AZ0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-427645CLMSofia Arnold1973-09-13UHC-41265-386218378889423 Market St, Sacramento, CA, 958430.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-415950CLMJuan Butler1952-03-08UHC-52359-45—4309 Willow Ct, Plano, TX0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-130634ENRMariana I Campbell1992-06-07UHC-52447-0646395308183807 Hillcrest Rd, Seattle, WA, 981930.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132279ENRDiane P Stephens1971-04-01UHC-27084-1835860561082642 Highland Ave, Chandler, AZ0.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141081ENRRoy U Ortiz1995-04-07UHC-61154-1575666822156507 Bayshore Dr, Austin, TX0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128704ENRJoan L Sanchez1975-05-08UHC-91458-477865919001179 Highland Ave, Los Angeles, CA, 900830.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133540ENRSamantha L Bryant1996-10-03UHC-70891-5886253513567358 Indian School Rd, Seattle, WA, 981630.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110117ENRJohn D Bradley1973-03-13UHC-80398-485965673213349 River Rd, Chandler, AZ, 852660.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-107676ENRMarina X Vega1952-12-03UHC-12595-7446532512325684 Church St Apt 6, Tucson, AZ, 857490.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-425528CLMScott Johnston1965-08-10UHC-34433-48—7864 Oak St, Nashville, TN, 372090.48Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-101528ENRAmber Jimenez—UHC-80329-7778785245819003 Camelback Rd, Glendale, AZ0.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-104963ENRDJunk1995-01-26UHC-47283-1969993709302816 Hillcrest Rd, Fresno, CA0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123599ENRCox Mary1974-07-26UHC-49025-4154769803958749 Indian School Rd, Seattle, WA, 981510.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-102690ENRBrittany J Reyes2005-12-07UHC-09394-8264032404602192 Maple Ave, Austin, TX, 787370.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-109080ENRNatalie C Riley1951-12-26UHC-39071-7173394816499343 Ridge Rd, Seattle, WA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63647TPAPriya Dunn1959-05-05——7821 Oak St Apt 20, Las Vegas, NV, 891480.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-430627CLMEdward A Hunt1999-06-24—94633642192783 Bayshore Dr # 610, Atlanta, GA, 303850.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-113410ENRDenise Q Guerrero1997-11-18UHC-92483-2958471135104184 Highland Ave, Tucson, AZ, 857340.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25652PRVAnn Martinez2006-09-21UHC-19690-8520390828713769 Highland Ave, Houston, TX, 770300.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138813ENRAshley Rivera1996-08-18UHC-34802-9452244953652309 Apache Blvd Apt 22, Tempe, AZ, 852270.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-422114CLMGloria Brooks1946-03-27——9448 Cedar Ln Apt 27, Orlando, FL, 328130.48Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-113438ENRSarah Larson1993-05-11UHC-85512-5944676455316521 River Rd # 593, Dallas, TX, 752690.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-106896ENRViirginia W Gibson—UHC-99575-2043477816627772 Baseline Rd, Nashville, TN, 372960.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-131727ENREdward Carr1942-01-23UHC-78994-2092182583317910 Willow Ct, Fresno, CA, 937850.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-137987ENRBrandon J Castro1980-01-22UHC-80743-0479720904646905 Camelback Rd, Phoenix, AZ0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424176CLMPriya Ford1969-05-03UHC-66719-80—6295 Indian School Rd Apt 11, Denver, CO, 802560.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-52672TPAJanice Roberts1981-08-28—90057937771097 Mountain View Dr, Eden Prairie, MN0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110502ENRSara Sanders1970-11-07UHC-46950-5181321335452403 Spring St, Denver, CO0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-142524ENRBeverly Carlson1981-05-25UHC-50578-5033727374877248 Grand Ave, Austin, TX, 787470.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-126600ENRKaren Ruiz1943-08-01UHC-25421-2591932301215995 Sage Ct, Austin, TX, 787820.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405111CLMTerry Peterson1964-12-22—5813042921298 Desert Sky Blvd, Glendale, AZ0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-134164ENRScott Gardner—UHC-41805-6727475196047087 Ridge Rd, Glendale, AZ, 853120.48Date of birth reformattedDate of birth unreadablePhone reformattedMember ID reformatted+4 more
ENR-119095ENRBrandon A Toorres1955-11-27UHC-26652-2028688748404878 Canyon Rd, Chandler, AZ, 852670.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-20160PRVMadison F Cook1960-01-25—40140814788386 Spring St, Tucson, AZ, 857380.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
PRV-25574PRVGary K Burns1967-01-03—98673917883058 Church St, Mesa, AZ, 852120.48Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+4 more
ENR-124590ENREric D McDonald1977-06-16UHC-28490-61—712 Elm St, Tempe, AZ, 852270.48Name split from “Last, First”Middle initial moved out of first nameMember ID reformattedStreet suffix standardised+4 more
PRV-29222PRVMelissa Dominguez1955-10-15—9855304738953 Baseline Rd, Sacramento, CA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-414510CLMSamual Guerrero2004-08-11UHC-70261-2435622211194432 Willow Ct, Plano, TX, 750400.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25042PRVBeverly Evans1988-10-08—89090482109591 Valley View Dr, Las Vegas, NV, 891240.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
100,000 rows, page 71 of 2,000PreviousNext