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-119391ENRYuki G Foster1987-04-23UHC-89406-6198733321563566 Lake View Rd, Sacramento, CA, 958470.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415660CLMJerry Cox1957-06-05——1970 Baseline Rd, Columbus, OH, 432330.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
PRV-22012PRVDenise Ryan1976-07-02UHC-47417-6473020172775141 Baseline Rd, Eden Prairie, MN0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-107065ENRArjun Bradley1959-04-16UHC-26745-33—1459 Ocean Ave, Dallas, TX, 752540.50Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-101049ENRLida Bshop1974-01-25UHC-90214-7635065694522829 Pine Dr # 841, Tampa, FL, 336840.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429614CLMMason Carlson1946-09-16UHC-73897-98—9434 Willow Ct, Orlando, FL0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62193TPAWilliam Cook2002-03-27——221 Baseline Rd, Seattle, WA0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
CLM-414050CLMOmar D Nguyen1997-06-08UHC-18431-18—5478 Lake View Rd Apt 21, Tampa, FL, 336210.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
ENR-127140ENRChritian A Le1970-07-15UHC-11475-194538368457544 Central Ave, Seattle, WA, 981330.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-127100ENRJennifer Z Griffin1957-12-17UHC-36930-8074293756199526 Washington St, Denver, CO, 802060.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113370ENRPatrick J Hoffman1960-11-21UHC-10829-6731535287612406 Forest Ave, San Diego, CA, 921060.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-119741ENREugene Moreno1942-03-06UHC-59661-8124697209528528 Maple Ave # 368, Scottsdale, AZ0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-128416ENREmma L Vega1940-08-26UHC-61278-6349441182456288 Main St, Seattle, WA0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-22001PRVBenjamin B Davis1971-12-09—96378817784361 Cedar Ln, Las Vegas, NV, 891510.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419198CLMDeborah West1945-06-11UHC-15597-12—479 Oak St, San Diego, CA, 921070.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
PRV-23818PRVRichard Alvarez1969-07-23—81629298785615 Oak St, Tampa, FL, 336530.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62280TPAKelly Vazquez1940-03-23——5213 Jefferson Ave, Minneapolis, MN, 554800.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-104345ENRAnn M Dominguez1959-12-03UHC-89013-5755120548112671 Grand Ave, Los Angeles, CA, 900420.50Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-424286CLMAisha P Walker1952-12-22UHC-06107-1230025607597821 Ocean Ave, Atlanta, GA, 303050.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139022ENRJoseph Brooks1949-02-20UHC-78973-4749865664074944 Lake View Rd, Tampa, FL, 336580.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410876CLMHiroshi Elliott1970-05-26——9492 Maple Ave, Chandler, AZ, 852390.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-137293ENRDougles Knight1967-12-22UHC-58513-506564736279427 Central Ave, Chandler, AZ, 852410.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417935CLMJulie Myers1971-06-16UHC-98913-91—2119 Apache Blvd, Fresno, CA, 937060.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-104058ENRDeb L Ortega1968-01-13UHC-28296-5474621364194916 Market St # 596, Dallas, TX, 752190.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-415888CLMAlan Mills1998-02-18——6345 Church St # 156, Eden Prairie, MN0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405191CLMBenjamin Hunt1993-07-05UHC-46402-7049232716078179 Indian School Rd, Atlanta, GA, 303720.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-123893ENRAhmed I Adams2001-12-06UHC-61442-8264222621153121 Union St Apt 1, Las Vegas, NV, 891390.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-405544CLMWilliam S Rose1961-12-13UHC-42141-5689531027564362 Ocean Ave, Fresno, CA, 937620.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
TPA-63084TPAKimberly Hayes1991-10-13——1773 Ocean Ave Apt 40, Columbus, OH, 432810.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-132161ENRPeter Patel1945-04-20UHC-99963-636857987644981 Union St, Chandler, AZ, 852640.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-138097ENRArjun Hudson1999-04-14UHC-69955-6736638623444237 Sunset Blvd, Gilbert, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-413655CLMEmily Wallace2004-10-05—85582198144775 Camelback Rd, Denver, CO, 802110.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-105315ENRNicole Harris1955-08-04UHC-21324-9081298159763260 Cedar Ln, Fresno, CA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-431577CLMNatalie Ryan2004-06-05UHC-86274-6430955225149790 Washington St, Minneapolis, MN, 554210.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401713CLMMichael Clark2006-12-17UHC-54207-07—4197 Washington St, Nashville, TN, 372620.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-113613ENREmma F Simpson—UHC-99558-8796758758323337 Valley View Dr, Scottsdale, AZ, 852910.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-113099ENRBryan W Lawson2006-03-27UHC-80563-5064988139379354 Pine Dr, Houston, TX, 770710.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133166ENRLawrence U Gutierrez1960-06-19UHC-20067-8584995691597369 Forest Ave, Dallas, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123121ENRFatima Sanchez1985-06-10UHC-51322-7122040033244361 Elm St, Denver, CO, 802380.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-112860ENRValentina T Bryant2007-10-01——2973 Jefferson Ave, Mesa, AZ, 852180.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-114028ENRJonathan R Butler1952-01-17UHC-31719-3763661150929213 Valley View Dr, Orlando, FL, 328520.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-423065CLM—Junk1999-07-04UHC-76256-4162939632196379 Camelback Rd Apt 12, Eden Prairie, MN, 553820.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-142298ENRAlexis T Nunez1962-05-04UHC-93711-0929298321659582 Grand Ave, Denver, CO, 802100.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedState name converted to code+3 more
ENR-111111ENRMichael Alvarado1981-06-25UHC-14405-57—3038 Baseline Rd # 899, Houston, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-401775CLMTyler Taylor2000-06-06UHC-19451-2783157810859668 Hillcrest Rd, Charlotte, NC, 282710.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-26163PRVVictoria H Flores1944-02-20UHC-25370-9232679851597285 Apache Blvd # 886, Tempe, AZ, 852610.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-404633CLMDeborah Day1955-06-07——4202 Washington St, Tucson, AZ, 857180.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116602ENRAndrea T Sanders1976-03-15UHC-23556-4387566136606103 Market St, Columbus, OH0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-56266TPAZachary Jensen1970-03-16—80337542604197 Hillcrest Rd, Denver, CO, 802320.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53115TPAVictoria Davis1999-02-22——159 Highland Ave, Seattle, WA, 981900.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 100 of 2,000PreviousNext