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-111713ENRMichelle Bowman1947-11-06UHC-20763-8032529429888737 Ridge Rd, Austin, TX, 787470.46Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-20652PRVHarold G Singh1949-12-22—58178026357435 Lake View Rd, San Antonio, TX, 782850.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-401362CLMCheryl Chen1997-10-27UHC-19223-3432133107973073 Park Pl, Plano, TX, 750930.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-132289ENRTyler Broosk1994-09-10UHC-33688-9568483920678696 Grand Ave, Charlotte, NC, 282620.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-26178PRVBeverly Z Soto—UHC-36735-6528233671235451 Camelback Rd, Fresno, CA0.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
ENR-124097ENREmily Boyd1998-06-24UHC-29831-34—547 Willow Ct, Tucson, AZ0.46Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-142920ENRPamela Gibson1970-11-19UHC-30740-5537136865724351 Hillcrest Rd, Glendale, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-403949CLMJohn W Perkins1943-11-03UHC-89638-3724637316249781 Harbor Blvd Apt 1, Houston, TX0.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-420194CLMBenjamin W Wood1948-01-20—59855889539764 Pine Dr, Charlotte, NC, 282930.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-126744ENRMelissa Ramos2002-06-10UHC-99031-0187637691087751 Bayshore Dr, Chandler, AZ, 852330.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-101232ENRJohn Z Taylor1971-08-28UHC-19378-1046738576518613 Washington St, Atlanta, GA, 303740.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-117366ENRMartin Philip1959-12-27UHC-41017-3429371865568416 Jefferson Ave, Jacksonville, FL, 322660.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
ENR-125200ENRJason B Garrett1947-05-05UHC-10837-5885199545003428 Highland Ave, Austin, TX, 787670.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-422936CLMSusan X Webb1952-10-06——2347 Lincoln Way # 613, Eden Prairie, MN, 553900.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-415050CLMVincent Gutierrez1979-05-28—68075365394765 Hillcrest Rd, Sacramento, CA, 958990.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-60197TPASean Webb2001-10-08—81021798803689 Willow Ct, Tucson, AZ, 857680.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-129857ENREmily E Obrien2007-07-06UHC-25966-2737331772573702 Elm St, Los Angeles, CA, 900670.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-117239ENRSarah S Hansen1960-08-17UHC-44827-08—4346 Cedar Ln, Las Vegas, NV, 891840.46Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+5 more
ENR-141812ENRArthur I Simpson1989-03-06UHC-42939-6491040174027971 Indian School Rd, Dallas, TX, 752220.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-29125PRVArjun X Crawford—UHC-35273-6141337618668223 Highland Ave, Eden Prairie, MN, 553720.46Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more
CLM-432158CLMAmber A Greene1989-06-27—2667403546239 Oak St, Scottsdale, AZ, 852900.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-25939PRVKayla Richards1976-01-10UHC-42568-6625353207642779 Pine Dr, Dallas, TX, 752560.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
TPA-58786TPAKimberly Morrison1991-05-06UHC-31666-5291122920316635 Palm Dr, Gilbert, AZ, 852390.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-108541ENRJordan L Cole1979-11-01UHC-83214-7857943943354226 Spring St, Minneapolis, MN, 554590.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-22070PRVLarry Myers2001-02-11—95990453056114 Church St, Atlanta, GA, 303270.46Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+5 more
CLM-429611CLMGary Graham1991-05-19UHC-98479-75—6136 Willow Ct, Los Angeles, CA, 900380.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-129620ENRPatrick Castro2008-08-26UHC-51479-9465422981431268 Washington St # 711, Fresno, CA, 937350.46Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-101300ENRDiane I Washington1971-08-01UHC-22655-7920376792316998 Bayshore Dr Apt 12, Plano, TX, 750680.46Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+5 more
ENR-142291ENRCarl Q McCoy—UHC-91013-9460982980216685 Sunset Blvd, Austin, TX, 787840.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
ENR-103053ENRAisha O Hanson1946-05-24UHC-09335-847092804776573 Bayshore Dr, Las Vegas, NV, 891190.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-102644ENRBenjamin T Johnston1948-02-17UHC-90631-9549761454155939 Cedar Ln, Orlando, FL0.46Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-400401CLMPayne Diego1962-04-18UHC-65200-0375780671669440 Mountain View Dr # 763, Scottsdale, AZ, 852130.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
TPA-61296TPATimothy Lawrence1973-06-15UHC-34368-5133442868085015 Park Pl, Tempe, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-111388ENRLori F Dominguez2000-09-04UHC-82440-569458088602730 Sage Ct, Miami, FL0.46Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
TPA-59180TPAElizabeth Schultz1967-12-24—90666732979384 Pine Dr, Fresno, CA, 937580.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-127101ENRNicholas Clark1963-11-09UHC-59054-9853357825417847 Highland Ave, San Diego, CA0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-119007ENRDonna Jacobs1980-04-28UHC-93706-5821572376451474 Hillcrest Rd Apt 37, Gilbert, AZ, 852240.46Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more
ENR-133600ENRDaniel A Ortiz2005-03-05UHC-04338-1489893725656892 Mesa Dr, Gilbert, AZ, 852080.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-51925TPAGloria V Ortega2007-02-20—62566424504707 Highland Ave, Tempe, AZ, 852520.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-23521PRVBeverly Z Harrison1962-03-11UHC-76087-4443364076088994 Cedar Ln, Sacramento, CA, 958360.46Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-23232PRVVirginia A Lynch2002-12-21UHC-46988-5354155574448501 Valley View Dr, Atlanta, GA, 303740.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-407419CLMRachel O Mnoz2004-03-17UHC-15937-0489850846667646 Bayshore Dr, Eden Prairie, MN, 553070.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-132828ENRJoshua Gray1994-04-12UHC-40679-0582498833391373 Lincoln Way # 696, Sacramento, CA, 958720.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
ENR-130831ENRMary L Reed1962-05-05UHC-27530-2826193827561552 Jefferson Ave Apt 28, San Diego, CA, 921850.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-103847ENRKimberly A Butler1938-02-21UHC-78911-7056957675458151 Mesa Dr Apt 15, Seattle, WA, 981800.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-131212ENRSamantha Y Delgado1956-05-27UHC-63618-4354571809272868 Apache Blvd, Scottsdale, AZ0.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-119280ENRBrittany N Harveey1969-03-05UHC-61789-324628849703862 Willow Ct, Tempe, AZ0.46Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+5 more
TPA-55353TPABrittany Fowler1995-11-07—29826975163562 Apache Blvd, Austin, TX, 787420.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-430138CLMRonald Butler—UHC-23449-9283947081746971 Lake View Rd, Las Vegas, NV, 891620.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
CLM-416622CLMWayne Bailey2007-07-10—70772900548816 Forest Ave Apt 19, Phoenix, AZ0.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
100,000 rows, page 48 of 2,000PreviousNext