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-133373ENRRuth W Rsoe1997-12-20UHC-90723-3595293172428340 Maple Ave, Dallas, TX, 752120.58Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+5 more
ENR-140682ENRDiane Olson1981-07-11—63856909354637 Lake View Rd, Jacksonville, FL, 322570.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-109587ENRAna Z Burns1979-01-27UHC-41549-618255969663226 Ocean Ave # 137, Orlando, FL, 328610.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-141996ENRDan H Davis1954-12-06UHC-79577-8149576676457703 Central Ave, San Diego, CA, 921730.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-130063ENRAisha N Miller1988-01-27UHC-69383-4285198616494292 Valley View Dr, Jacksonville, FL, 322040.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-140500ENRIsabella J Tucker1943-02-17UHC-25776-7074288779519827 Sage Ct, Atlanta, GA, 303050.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-123312ENRCarlos G Thomas1955-02-15UHC-95358-0958564351434110 Camelback Rd Apt 17, Mesa, AZ, 852670.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-123049ENRTylr I Perry1976-09-27UHC-30693-8122095573406993 Palm Dr, Los Angeles, CA0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-133419ENRSteven G Spencer1948-07-11UHC-81845-8849793425002764 Apache Blvd Apt 31, Tampa, FL, 336850.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-104480ENRMartha V Sandoval1971-07-21UHC-24262-0673799573542698 Cedar Ln, Gilbert, AZ0.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-120378ENRFrank J Hamilton1980-02-22UHC-91957-1493092039851346 Church St, Seattle, WA, 981840.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-141559ENRJoe S Chen1950-06-26UHC-82668-0254971889986167 Lincoln Way, Mesa, AZ, 852100.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-134018ENREthan Stone1989-12-27UHC-37228-6048622818105814 Grand Ave, Fresno, CA, 937760.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-141881ENRMarilyn R Bradley1966-09-13UHC-97072-127474024779901 Forest Ave, Seattle, WA, 981660.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-139972ENRRebecca G Silvva1993-06-26UHC-00553-9398363148709351 Harbor Blvd, San Antonio, TX, 782920.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-134067ENRCheryl T Reed1984-06-12UHC-67483-066153693348984 Meadow Ln # 979, Nashville, TN, 372070.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-137025ENRDorothy Ortega—UHC-76525-4456391451883937 Cedar Ln, Chandler, AZ, 852610.58Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more
ENR-127407ENRIsabella L Yang1991-12-21UHC-46102-0535690972206288 Highland Ave, Tempe, AZ, 852300.58Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-134317ENRRoy Q Wilson1988-06-24UHC-47553-1139683267458944 Hillcrest Rd, Los Angeles, CA, 900080.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-103589ENRKatherine Hill1979-09-20UHC-53855-277516947971983 Spring St # 199, Fresno, CA, 937310.58Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
ENR-140651ENRKelly Chapman1970-01-12UHC-53409-7831944429433677 Apache Blvd, Tampa, FL, 336340.58Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-124076ENRJulie B Riley1941-02-10UHC-35425-25—6520 Central Ave, Gilbert, AZ, 852440.58Phone missing area codeSSN last four extractedZIP+4 trimmed
ENR-129455ENRTeresa Fox1981-12-23UHC-90462-0195176926554557 Palm Dr, Orlando, FL0.58Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-111952ENRDnna Z Schmidt1983-02-23UHC-88832-0421176057906092 Meadow Ln, San Antonio, TX, 782500.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-141080ENRNicholas B Perkins1956-11-05UHC-71520-8049934299351304 Meadow Ln, Plano, TX, 750990.58Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
ENR-119576ENREdward L Hoffman1955-06-26UHC-40660-955806293986972 Market St, Las Vegas, NV, 891130.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-126808ENRAnthony Henry1962-05-02UHC-43116-07—1673 Desert Sky Blvd, Atlanta, GA, 303530.58Name split from “Last, First”ZIP+4 trimmedGender normalised
ENR-114031ENRAshley T Ford2003-12-13—53831251947109 Forest Ave, Sacramento, CA, 958460.58Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+5 more
ENR-112661ENRBradley Williams1983-10-13UHC-17279-1087045290686914 Desert Sky Blvd, Columbus, OH, 432320.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-129711ENRLori W Valdez1985-03-18UHC-39983-48—1140 Main St Apt 40, Charlotte, NC, 282730.58Phone missing area codeUnit split from streetGender normalised
ENR-141202ENRJennifer X Wong1956-10-21UHC-55121-8842447429483291 Sunset Blvd, Gilbert, AZ, 852590.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-118208ENRYkui M Bell1965-12-01UHC-62559-2536464766926643 Oak St, Chandler, AZ, 852190.58Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-124972ENRYuki A Boyd1947-07-04UHC-23434-8288431870224553 Oak St, Eden Prairie, MN, 553670.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-130387ENRLogan L Greene1965-08-04UHC-51467-5621651076837931 Canyon Rd, Minneapolis, MN, 554760.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-134628ENRAaron N Barnes1945-11-27UHC-75608-1180928184509539 River Rd, Columbus, OH, 432700.58Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
ENR-102579ENRBanks Sanntiago1956-06-22UHC-38992-7283945785553079 Highland Ave, Scottsdale, AZ, 852240.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-104019ENRAaron M Harper1938-07-05UHC-31201-4228623805586894 Pine Dr, Minneapolis, MN, 554500.58Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
ENR-126721ENRMei Vargas1953-01-11UHC-17211-7371847500348958 Lincoln Way, Austin, TX, 787760.58State name converted to codeZIP+4 trimmedGender normalised
ENR-139504ENRIsabella A Young1939-10-21UHC-89513-149314143522289 Baseline Rd, Sacramento, CA, 958040.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-117395ENRBenjamin Carpenter1988-11-08UHC-14500-0755839114463338 Church St, Las Vegas, NV, 891640.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-117700ENRLarry Freemman1973-10-19UHC-74769-2559421311438114 Sage Ct Apt 15, Tampa, FL, 336880.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-129827ENRAlan J Wang1945-05-20UHC-56363-2755593672706676 Spring St, Jacksonville, FL0.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-139863ENRJacqueline R Gomez1967-02-17UHC-57063-1692547037631869 Palm Dr, Charlotte, NC, 282460.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-139862ENRJacqueline R Gomez1967-02-17UHC-57063-1692547037631869 Palm Dr, Charlotte, NC, 282460.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-113292ENRMary N Russell1942-12-23UHC-42213-4230942058326848 Jefferson Ave, Las Vegas, NV0.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-121399ENRMei F Espinoza2003-05-05UHC-99638-5437282465927842 Baseline Rd, Gilbert, AZ, 852590.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-100261ENRJanice X Rivera1975-04-23UHC-27879-128125380707708 Baseline Rd, Denver, CO, 802570.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-141652ENRDaniel R Ellis1968-05-25UHC-34394-18—9425 Sunset Blvd, San Antonio, TX, 782260.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-137037ENRNancy M Tuckeer1973-10-22UHC-74469-7332921284553950 Valley View Dr, Houston, TX, 770940.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-127075ENRLinda P Banks1986-12-22UHC-50474-5128081825508760 Camelback Rd, Scottsdale, AZ, 852890.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
43,101 rows, page 113 of 863PreviousNext