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-111986ENRSofia C Evans1941-08-25UHC-68436-7992984543894963 Lake View Rd, Houston, TX, 770940.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-61129TPAJordan Mason1963-03-07——9391 Valley View Dr, Nashville, TN, 372910.50Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+3 more
ENR-119212ENRSandra Soto2001-10-01UHC-82070-0221297142869307 Mesa Dr Apt 32, Denver, CO, 802800.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-126242ENRWayne Davis1956-05-25UHC-67278-96—4681 Oak St, Eden Prairie, MN, 553090.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428000CLMDaniel E Gilbert1938-08-24—26584411569403 Market St, Tampa, FL, 336240.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119554ENRLiz George1960-05-24UHC-90127-8368746656612879 Sunset Blvd, Chandler, AZ, 852100.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-106540ENRAustin Jordan1951-04-05UHC-02354-94—4762 Church St Apt 30, Eden Prairie, MN, 553400.50Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
PRV-27502PRVWillie Suullivan2005-02-28UHC-03086-9043369757066475 Elm St, Tampa, FL, 336360.50Name split from “Last, First”Two-digit birth yearMember ID reformattedStreet suffix standardised+3 more
CLM-409411CLMKathleen Watson1959-07-27—58473427513553 Mountain View Dr, San Diego, CA, 921950.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23151PRVMichael L Graham1991-04-09UHC-80630-5571288805445523 Main St, Plano, TX0.50Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+3 more
ENR-122939ENRNicholas I Montgomery1976-12-24UHC-07349-5827472172898660 Baseline Rd # 774, San Antonio, TX, 782500.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
ENR-103235ENRDenny Lopez1962-10-07UHC-83888-9577042787582194 Church St, Seattle, WA, 981060.50Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+3 more
ENR-112429ENRSara B Ramos1998-09-02UHC-90845-0265681511764731 Sage Ct, San Diego, CA, 921680.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26789PRVCarol Pierce1957-02-09UHC-80359-2482151225177677 Baseline Rd, Fresno, CA, 937730.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-142908ENRJoyyce U Snyder1993-12-04UHC-73911-6640224665008349 Willow Ct, Fresno, CA, 937290.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-414310CLMElijah S Stone1944-04-03——250 Washington St # 399, Tempe, AZ0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-410890CLMKatherine Bell1997-07-13—90279140608466 Bayshore Dr, Tempe, AZ, 852650.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420406CLMSara Harvey1984-02-18—62454314628811 Church St, Denver, CO, 802570.50Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+3 more
CLM-431145CLMCharles M Hoffman1986-03-16UHC-28425-9688495584701089 Bayshore Dr, Jacksonville, FL, 322690.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-116637ENRSharon Jordan1940-10-09UHC-95905-1141888701619743 Ridge Rd, Jacksonville, FL, 322070.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401096CLMEmma Reyes1992-04-17UHC-53606-4324646150506614 Lake View Rd, Sacramento, CA, 958270.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-415943CLMAbby B Olson1944-07-07UHC-32653-3548637154904859 Hillcrest Rd, Nashville, TN, 372640.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-115991ENRLucia T Reid2007-05-10UHC-97211-9170095422042443 Washington St, Chandler, AZ, 852450.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112706ENRElijah Owens—UHC-32230-666147492074428 Church St, Scottsdale, AZ, 852760.50Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
ENR-112679ENRVirginia T Rice—UHC-60262-0957945767836678 Lincoln Way, Fresno, CA, 937260.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-404747CLMMateo Rivera1977-04-04UHC-03884-6353744703696701 Church St, Austin, TX0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-52323TPARaymond Simmons1972-02-03—57040474185242 Desert Sky Blvd, Nashville, TN, 372040.50Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+3 more
ENR-137936ENRGloria Chapman1938-10-11UHC-10323-5847826301964425 Mesa Dr # 964, Denver, CO, 802910.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-133226ENROmar Castro1951-12-07UHC-27170-0794163829387219 Oak St, Miami, FL, 331800.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-432695CLMDenise Rogers1996-05-21UHC-63267-3639351286842232 Forest Ave, Las Vegas, NV, 891360.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116567ENRJerry Burke1976-08-18UHC-38441-26—8032 Valley View Dr, Nashville, TN, 372480.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-410325CLMKeith Torres—UHC-89886-91—8102 Main St, Houston, TX, 770180.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405096CLMMarilyn Romero1954-08-02UHC-22595-4055590005692973 Main St, Eden Prairie, MN, 553380.50Name split from “Last, First”Member ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-430741CLMSamantha Payne2001-06-24UHC-99063-40—4292 Washington St, Gilbert, AZ, 852000.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134734ENRBryan Matthews1988-07-28UHC-23750-61—8907 Harbor Blvd, Plano, TX, 750850.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-121735ENRValentina Cooper1984-09-18UHC-46542-8829659399121898 Elm St, Mesa, AZ0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-139266ENRDanielle K Weaver—UHC-98676-066926129401724 Palm Dr, Atlanta, GA0.50Name re-casedDate of birth missingCity re-casedZIP missing+3 more
CLM-431609CLMCarolyn Flores1964-05-16——2384 Apache Blvd Apt 34, Los Angeles, CA, 900370.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406812CLMVincent Lewis1977-02-13UHC-59903-8976945085507484 Bayshore Dr, Glendale, AZ0.50Name split from “Last, First”Date of birth reformattedMember ID reformattedZIP missing+3 more
TPA-55813TPANoah Hawkins1976-10-12—47037774603221 Union St, San Antonio, TX, 782860.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114388ENRHiroshi B Harrison1948-04-27UHC-09174-0953892439591277 Spring St, Fresno, CA, 937970.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-400293CLMValentina Austin1980-11-05UHC-16705-3642589318396663 Highland Ave, Gilbert, AZ0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428168CLMKevin D Matthews1966-08-15UHC-84075-27—6609 Mesa Dr, Houston, TX, 770740.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114040ENRBrandon Q Armstrong1959-11-13UHC-84467-90—2641 Apache Blvd # 334, Denver, CO, 802810.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-422159CLMSantiago Johnston1951-11-11——2725 Washington St, Chandler, AZ, 852840.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-405996CLMDonna Moore1983-06-07UHC-26588-3822096558485727 Lake View Rd, Plano, TX, 750900.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-425309CLMArthur Carter1953-09-20UHC-46569-38—7582 Washington St, Chandler, AZ, 852720.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-115513ENRJeffrey Vazquez2007-06-12UHC-94739-6553694954972458 Lincoln Way Apt 23, Houston, TX, 770610.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
TPA-59057TPADanielle Vazquez1948-10-27——8681 Grand Ave Apt 37, Atlanta, GA, 303860.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-421241CLMWeber K Frances1963-02-15UHC-72878-47—4716 Camelback Rd Apt 35, Los Angeles, CA, 900130.50Name re-casedTwo-digit birth yearUnit split from streetState name converted to code+3 more
100,000 rows, page 133 of 2,000PreviousNext