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
ENR-110449ENRJoyce Sanders1954-07-12UHC-76833-5291869993141135 Harbor Blvd Apt 16, San Antonio, TX, 782720.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-120813ENROmar F Dunn1981-11-14UHC-59784-8694780147415238 Union St, Chandler, AZ, 852300.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404227CLMJean Gonzales1989-11-19——6660 Lake View Rd, Sacramento, CA, 958530.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137156ENRVincent L West2003-01-17UHC-43500-5938637833658724 Central Ave Apt 7, Plano, TX, 750110.50Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136235ENRGary A Ross1970-06-13UHC-20327-4780153407476125 Sunset Blvd, Columbus, OH0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-136509ENRMelissa P Ford1981-04-14UHC-87445-8951234809521213 Washington St, Houston, TX, 770470.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-432156CLMKelly Gutierrez1990-10-16—89079175056693 Maple Ave, Las Vegas, NV0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-55048TPACarl Montgomery1963-08-11UHC-57349-54—1278 Lake View Rd, Seattle, WA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-105742ENRCarl A Hoffman1941-12-11UHC-12474-9990121726837522 Indian School Rd, Miami, FL, 331850.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-108463ENRJudith Olsoon1966-04-11UHC-31184-6835168610684157 Hillcrest Rd # 811, Phoenix, AZ, 850230.50Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+3 more
ENR-100666ENRJoyce B Knnedy1941-11-27UHC-84403-88—8996 Canyon Rd, Austin, TX, 787130.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-139439ENRLawrence Hoffman1971-02-10UHC-12016-6595394320235415 River Rd, Minneapolis, MN, 554160.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118387ENRMichelle Fileds1963-05-19UHC-78616-925967565808981 Main St, Gilbert, AZ0.50Date of birth reformattedPhone reformattedSSN last four extractedState name converted to code+3 more
ENR-121303ENRAisha Bryant1957-04-26UHC-82316-023532939439644 Ocean Ave, San Diego, CA, 921070.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-139312ENRArthur A Nichols1942-09-26UHC-48023-8995579254991576 Mountain View Dr, Columbus, OH0.50Two-digit birth yearPhone reformattedCity re-casedZIP missing+3 more
ENR-107077ENRMaria P Ramos1948-07-08UHC-85846-5046227164644261 Maple Ave, Tucson, AZ, 857070.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20207PRVBrandon Carlson1988-11-07UHC-05200-4447389373944875 Apache Blvd, Houston, TX, 770120.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-60312TPALarry Salazar1959-01-11——3354 Park Pl, Gilbert, AZ, 852570.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-108001ENRLinda V Fields1968-10-11UHC-49146-7890970737041120 Pine Dr, Phoenix, AZ, 850810.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-56976TPAJohn Ramos1941-03-16——8029 Park Pl # 157, San Antonio, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402270CLMCamila Martinez1995-03-24——3375 Mesa Dr, Atlanta, GA, 303750.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-412240CLMFrances Franklin1938-06-05UHC-89412-6845027941859513 Sage Ct, Dallas, TX, 752430.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-57988TPALucia N Montgmoery1947-12-09—65173901592513 Harbor Blvd, Houston, TX, 770840.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-142624ENRBrenda Medina1975-11-01UHC-58038-13—3908 Sage Ct, Sacramento, CA, 958620.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-54723TPARachel Guzman1992-09-27—86527527492817 Sunset Blvd # 161, Houston, TX, 770350.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130606ENRBetty Gray1982-10-01UHC-11992-1626895511811627 Mesa Dr, Miami, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109996ENRLaura I Chen2005-07-06UHC-72517-6854633912249250 Valley View Dr, Houston, TX, 770680.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-28502PRVVicky Nunez——79123793085348 Central Ave, Houston, TX, 770870.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-122070ENRAnthony Jackson1996-11-11UHC-47435-5370849711047175 Mesa Dr Apt 24, Dallas, TX, 752630.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-414360CLMNathan Fowler2000-07-09UHC-98829-17—8976 Pine Dr, Nashville, TN, 372330.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407206CLMShirley Cruz1978-01-23UHC-86255-78—7175 Ridge Rd, Glendale, AZ, 853550.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60891TPAPatrick Z Simpson1962-09-21——5005 Bayshore Dr Apt 35, Denver, CO, 802650.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-129692ENRDennis Collins2001-07-15UHC-50198-7326893598134690 Ocean Ave, Dallas, TX, 752800.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-140213ENRRuth V Snyder2002-08-13UHC-67308-5697145122618202 Highland Ave, Nashville, TN0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-27416PRV—Junk1940-02-18UHC-46209-5168529172153684 Church St, Charlotte, NC, 282020.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136439ENRCarlos Hayes1970-05-15UHC-95618-9864068643083353 Main St, Atlanta, GA0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-63092TPAAnna Olson1977-11-10——4540 Elm St, Las Vegas, NV, 891810.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-111816ENRWilliam Stone1939-11-11UHC-64855-0372493573385825 Spring St, Charlotte, NC0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28952PRVWillie I Sims1959-05-14UHC-08712-3138354952393094 Hillcrest Rd, Plano, TX, 750320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411154CLMJoyce N Pierce1945-02-01UHC-17185-78—3413 Spring St, Scottsdale, AZ, 852620.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-418204CLMTommy Barnes1958-12-14UHC-50248-95—4530 Ridge Rd, Plano, TX, 750410.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-430770CLMAndrea Kim1939-01-18UHC-58093-27—152 Market St, Houston, TX, 770220.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-122311ENRJacob J Smith—UHC-64359-98—4760 Canyon Rd, Atlanta, GA, 303610.50Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
CLM-401714CLMAndrea Holes1965-05-05——1113 River Rd, Atlanta, GA, 303360.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-62032TPAChristine W Ortega1969-09-22——3529 Market St, San Diego, CA, 921770.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423080CLMScott Sanchez2004-01-20UHC-28082-1481293409772598 Ocean Ave, Scottsdale, AZ, 852780.50Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-132191ENRJuan Carter1949-07-13UHC-46842-5859793099137349 Pine Dr, Charlotte, NC, 282290.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406195CLMFatima Perkins1992-04-14—6414426679107 Central Ave Apt 40, Jacksonville, FL, 322100.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-129801ENRJoe Z Obrien1938-06-20UHC-91026-532615953563832 Oak St, Jacksonville, FL, 322880.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-20690PRVAnn Alexander———8659 Ocean Ave, Columbus, OH, 432670.50Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
100,000 rows, page 112 of 2,000PreviousNext