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-136203ENRKyle D Berry1974-03-04UHC-50009-2574834006148080 Jefferson Ave, Chandler, AZ, 852260.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-100149ENRAhmed W Stevens—UHC-43336-1657727577507085 Union St, Denver, CO, 802310.60Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-122711ENRAlice Z Lwson1982-03-08UHC-22496-684876929965530 Apache Blvd, San Diego, CA, 921140.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-106559ENRMateo Snyder1989-11-28UHC-54482-1847540010257631 Apache Blvd, Las Vegas, NV, 891570.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-133260ENRDennis Daniels1972-02-10UHC-93018-8586446858633114 Elm St, Houston, TX, 770410.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-129765ENRRoger Bennett2000-03-02UHC-51537-0323126560606308 Spring St, Austin, TX, 787570.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141924ENRBardley F Padilla1942-06-09UHC-70138-1751289029421085 Mountain View Dr, Fresno, CA, 937580.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129053ENREmily Fuller1986-02-02UHC-95211-8934430814895531 Baseline Rd, Tampa, FL, 336710.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-104597ENRGabriel D Lee1950-08-03UHC-80814-1534374634226013 Camelback Rd, Denver, CO, 802480.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104796ENRHiroshi Rliey1962-01-23UHC-80208-0955925611618986 Washington St, Atlanta, GA, 303540.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-138856ENRDylan Ford1972-06-04UHC-15943-6968160454075936 Union St, Dallas, TX, 752550.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138466ENRBetty Wright1996-05-07UHC-97501-9660766401206345 Desert Sky Blvd, Miami, FL0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-121029ENRWayne X Robertson1965-06-04UHC-05398-9325345580387060 Hillcrest Rd, Nashville, TN, 372020.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-120883ENRDoris Y Meyer1961-05-19UHC-49829-2375124374391523 Lincoln Way, Columbus, OH, 432920.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-126978ENRBruce P Perkins—UHC-27600-5132449236418366 Lake View Rd, Los Angeles, CA, 900480.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-140209ENRWillie Soto2006-09-19UHC-53600-8797458166818204 Central Ave, Scottsdale, AZ, 852490.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108383ENRWei Mejia1960-05-08UHC-25353-07—5907 Canyon Rd, Eden Prairie, MN, 553300.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104568ENRSam Z Bowman1945-07-09UHC-16338-0868740625576349 Spring St, Gilbert, AZ, 852760.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-139761ENRJeremy Hunt1955-08-12UHC-59297-4361228579654716 Sunset Blvd, Jacksonville, FL0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-125749ENRBrittany Gardner2008-08-03UHC-64858-1970053552197746 Grand Ave, Mesa, AZ, 852790.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127621ENREvelyn X Gray1968-09-15UHC-85134-3272590173655902 Canyon Rd, Denver, CO, 802840.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131436ENRRuth Z Fox1997-01-01UHC-51091-444542466460339 Baseline Rd, Austin, TX, 787650.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-110218ENRSandra P Yang1961-10-20UHC-18320-2237949971514320 Ridge Rd, Tampa, FL0.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123231ENRCarolyn E Campbell1950-02-15UHC-91732-2382559730227292 Broadway, Denver, CO0.60Phone reformattedMember ID reformattedAddress re-casedCity re-cased+4 more
ENR-137024ENRJerry Dun1993-02-22UHC-45079-4367899216575397 River Rd, Charlotte, NC, 282960.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140758ENRJanice Z Marshall1985-02-22UHC-38497-7390586648195578 Bayshore Dr, Sacramento, CA, 958240.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-112238ENRKelly C West—UHC-89347-7791920043467793 Main St, San Diego, CA, 921870.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-120538ENRMartha Chen2005-12-04UHC-27434-0220267751334460 Desert Sky Blvd, Eden Prairie, MN0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127107ENRMelissa Raed1984-05-20UHC-64718-8436949198653282 Church St, Los Angeles, CA, 900470.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-133086ENRDeborah X Owens1969-09-28UHC-36207-2185429288727234 Highland Ave, Fresno, CA0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104506ENRRoger P Simmons1941-10-03UHC-17204-0377840837842486 Highland Ave, Tempe, AZ, 852510.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131308ENRBradley Mason1974-06-15UHC-79120-5393640107381000 Ridge Rd Apt 28, San Diego, CA, 921520.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-140668ENRJonathan Simmons1988-05-11UHC-03464-9579151502088022 Jefferson Ave # 194, Las Vegas, NV, 891940.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-142872ENRMei W McCoy—UHC-65566-677369226577599 Lincoln Way, Gilbert, AZ, 852620.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-142330ENRDanielle X Simpson1995-03-09UHC-91877-58—5969 Church St, Chandler, AZ, 852170.60Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more
ENR-125875ENRNatalie G Day1948-08-27UHC-79226-3564860681266862 Sage Ct, Tempe, AZ, 852480.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-109909ENRBell Melissa1952-08-08UHC-91197-5858044040434418 Canyon Rd # 223, Las Vegas, NV, 891700.60Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more
ENR-113813ENRAnn W Hudson1944-06-11UHC-45319-6048726901601546 Highland Ave, Nashville, TN0.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-110761ENRJoan Ferguson2003-08-28UHC-48591-6155854284667655 Union St, Glendale, AZ, 853920.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128967ENRJulie T Wilson1948-03-27UHC-63663-3170464505169556 Ocean Ave, Minneapolis, MN, 554160.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-132844ENRDiane W Wells1941-11-24UHC-04452-606145750929754 Apache Blvd, San Diego, CA, 921190.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-132099ENRKimberly Austin1982-01-28UHC-04038-3759467328691515 Maple Ave, Nashville, TN, 372910.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-113342ENRBruce Wason1956-10-01UHC-58660-37—8285 Ocean Ave, Mesa, AZ, 852890.60Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+4 more
ENR-109946ENRMike V Daniels1961-10-14UHC-40201-8772776971984583 Valley View Dr, San Antonio, TX, 782220.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-119139ENRIsabella A Sanchez1952-07-26UHC-07904-9195752664633413 Valley View Dr, San Antonio, TX, 782840.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-129682ENRMarcus Kleley1976-06-02UHC-47572-3586133377716515 Elm St, Eden Prairie, MN, 553060.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-117593ENRKathleen Gutierrez2005-02-19UHC-47968-8393120047448177 Palm Dr, Atlanta, GA, 303190.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-129039ENRSantiago P Johnston1951-11-11UHC-65660-3730964976862725 Washington St Apt 16, Chandler, AZ, 852840.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-129038ENRSantiago P Johnston1951-11-11UHC-65660-3730964976862725 Washington St Apt 16, Chandler, AZ, 852840.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-102374ENRJonathan O Rivera1992-08-01UHC-64480-79—728 Central Ave, Chandler, AZ, 852680.60Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
43,101 rows, page 132 of 863PreviousNext