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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-138630ENRKevin Mills1948-08-03UHC-92487-7262542167977712 Mountain View Dr # 836, Scottsdale, AZ, 852090.46Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
ENR-103640ENRTheresa M Weaver2001-03-15UHC-34492-5667424342581689 Indian School Rd, Tampa, FL, 336820.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-127999ENRAlan Lynch1993-06-03—84626093348507 Bayshore Dr, Tampa, FL, 336620.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-130771ENRPamla Y Hunt2001-10-27UHC-01030-0383180264678873 River Rd, Plano, TX, 750420.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
ENR-107224ENRSandra E Owens1978-11-16UHC-89246-6288538569826957 Bayshore Dr, Seattle, WA, 981750.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-114125ENRAlice A McDonald1963-06-01UHC-51908-0295891909584905 Jefferson Ave, Tucson, AZ, 857220.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
ENR-131356ENRRoger Fox1990-07-18UHC-96985-7064041481005466 Maple Ave # 686, Tampa, FL, 336800.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-125315ENRMari O Campbell1986-11-08UHC-54075-9220868460933520 Lincoln Way, Charlotte, NC, 282190.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
ENR-119598ENRLawrence Carter1993-01-26UHC-42533-01—1881 Jefferson Ave, Scottsdale, AZ, 852060.46Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
ENR-119597ENRLawrence Carter1993-01-26UHC-42533-01—1881 Jefferson Ave, Scottsdale, AZ, 852060.46Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
ENR-102299ENRAngela Fowler1969-11-24UHC-91761-7040555815161269 Sage Ct, Tempe, AZ, 852830.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-128634ENRHaroold Rivera1954-10-21UHC-92156-9567672508502799 Cedar Ln # 734, Orlando, FL, 328490.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-134939ENRWillie Franklin1974-09-24UHC-39455-06—5953 Bayshore Dr, Dallas, TX, 752260.46Date of birth reformattedPhone missing area codeSSN last four extractedStreet suffix standardised+5 more
ENR-108846ENRCarl Owens2001-01-10UHC-24250-0282430716861298 Forest Ave, Minneapolis, MN0.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-111637ENR—Junk1981-08-16UHC-81108-8081740938482178 Apache Blvd # 803, Eden Prairie, MN, 553480.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-140915ENRDonald D Price1990-06-06UHC-98398-0146187926271458 Oak St, San Antonio, TX0.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-138859ENRRobert W Jacobs1971-01-14UHC-66748-2959384085707254 Central Ave, Atlanta, GA, 303350.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-122842ENRBryan Gordon—UHC-04003-3772320213971344 Ocean Ave, Glendale, AZ, 853260.46Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more
ENR-107731ENRCamila A Perkins1961-05-20UHC-07700-4547190381366104 Spring St, Scottsdale, AZ, 852220.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-114943ENRCharlotte J Watson1969-08-27UHC-45410-024589482383429 Pine Dr, Atlanta, GA, 303560.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-114942ENRCharlotte J Watson1969-08-27UHC-45410-024589482383429 Pine Dr, Atlanta, GA, 303560.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-107316ENRJack V Bowman1974-02-24UHC-76339-06—6010 Broadway, Plano, TX, 750130.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone missing area code+5 more
ENR-117208ENRHeather Reyes1945-01-26UHC-65077-067025427306786 Sunset Blvd, Atlanta, GA, 303510.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-119233ENRKevin D George1941-01-17UHC-63679-2187798915981143 Jefferson Ave, Houston, TX, 770300.46Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+5 more
ENR-109316ENRJackie Gray—UHC-83000-1232579143145307 Baseline Rd, Denver, CO, 802630.46Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more
ENR-113200ENRTeresa Santos1959-12-22UHC-28319-239576359236194 Oak St, Dallas, TX, 752560.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-133966ENRKatherine King1947-06-28UHC-21776-912332893316339 Church St, Dallas, TX, 752430.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-124893ENRAdam H Lucas2003-03-21UHC-98067-3892295376834190 Union St, San Diego, CA0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-139448ENRHarold Lewis1983-03-15UHC-81818-9642726627326789 Elm St Apt 9, Atlanta, GA, 303210.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-110421ENRTyler Oliver1988-04-04UHC-80744-5623657740093506 Lincoln Way, San Diego, CA, 921390.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-105544ENRSofia Lawrence1986-02-24UHC-75151-1586963471692571 Bayshore Dr, Seattle, WA0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-125046ENRCarl Q White1943-02-06UHC-60657-2348970219168984 Ridge Rd, Orlando, FL, 328630.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-109723ENRNatlie Wang2000-08-13UHC-11557-2748850654065773 Baseline Rd # 137, Minneapolis, MN0.46Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-139181ENRPat H Gutierrez1991-10-17UHC-55935-3563155927389066 Cedar Ln, Eden Prairie, MN0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-101426ENRSophia Munoz1977-05-22UHC-32629-2185499957376455 Ridge Rd, Scottsdale, AZ, 852560.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-113417ENRGabriel N Mnoz1986-01-14UHC-68548-7383885352933915 Park Pl, Atlanta, GA0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-140343ENRJulie A George1961-08-14UHC-62078-4389962424985628 Mountain View Dr, Seattle, WA, 981190.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-105551ENRLogan Q Mendoza1997-07-19UHC-83159-6632645630545812 Jefferson Ave, Tucson, AZ, 857280.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-123489ENRKelly K Park2003-01-04UHC-31870-5421546628012146 Willow Ct, Jacksonville, FL, 322780.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-113903ENRNathan M Wilson2007-10-13UHC-55606-8288258892258326 River Rd # 910, Miami, FL0.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-118480ENRDebra J Elliott—UHC-29655-4175195587735362 Park Pl, Nashville, TN, 372100.46Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+5 more
ENR-118142ENRGregory Lopez2003-10-17UHC-68258-6536062175002870 Indian School Rd # 777, Tampa, FL0.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-119326ENREvelyn Burns1991-10-17UHC-64453-70—4461 Spring St, Tampa, FL, 336710.46Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+5 more
ENR-120123ENRAmy F Baker1967-05-15UHC-44725-6069399212714115 Palm Dr, Chandler, AZ, 852230.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-131866ENRRichard N Chapman1999-11-01UHC-28200-7083145813415513 Desert Sky Blvd, Plano, TX, 750120.46Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-123941ENRGrace P Kim1952-04-02UHC-89018-0947645904772766 Sage Ct, Denver, CO0.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-108228ENRShirley V Watson1942-01-18UHC-42611-87—5102 Main St, Austin, TX, 787070.46Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-138119ENRNatalie Kim1997-01-07UHC-69045-4949973632769655 Cedar Ln # 327, Phoenix, AZ, 850810.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-111914ENRChristine D Barnes2006-01-22UHC-70917-3253226338615821 Washington St, Columbus, OH, 432900.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-134226ENRVictoria Rogers2008-05-10UHC-57091-1473438170181444 Indian School Rd, Plano, TX, 750290.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
43,101 rows, page 23 of 863PreviousNext