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-132867ENRSara Hoffman1944-11-21UHC-72647-5740950913714871 Forest Ave, Fresno, CA0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-120188ENRBradley Lopez2005-02-24UHC-46200-3945023811755000 Central Ave, Denver, CO, 802350.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122283ENROlivia J Padilla2001-03-03UHC-79554-605407022348847 Market St, Tempe, AZ, 852660.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134092ENRRussell R Mendoza1989-07-06UHC-92121-3480489923222400 Hillcrest Rd # 119, Tempe, AZ, 852150.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-102331ENRMaria Castro1997-07-28UHC-91369-52—3820 Mountain View Dr, Eden Prairie, MN, 553860.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101015ENRWei Patterson1949-07-04UHC-24216-6191833193134830 Elm St, San Antonio, TX, 782350.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-100809ENREd Williamson1960-06-18UHC-60200-8090575056344053 Church St, Chandler, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131415ENRScott Bryant1964-06-07UHC-34466-6055665454727703 Spring St, Fresno, CA, 937310.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121009ENRPriya S Morales1938-05-26UHC-40542-3640346261647223 Sunset Blvd, Chandler, AZ, 852330.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104575ENRDanielle Q Bradley1946-04-12UHC-12229-4123547822403413 Broadway, Tampa, FL0.62Two-digit birth yearPhone reformattedAddress re-casedCity re-cased+3 more
ENR-124551ENRJoseph N McCoy1967-03-26UHC-16425-9779262885525635 Meadow Ln # 710, Tucson, AZ, 857950.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-119819ENRAlbert Tran2004-12-08—74184279782632 Cedar Ln # 907, Austin, TX, 787790.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-140611ENRJustin Le1977-05-22UHC-43468-0447992296621662 Market St, Phoenix, AZ, 850490.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101714ENRVirginia Ruiz2002-06-11UHC-83107-1327487144312822 Elm St, Las Vegas, NV, 891750.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-125582ENRShirley A Shaw1981-11-18UHC-36002-7071841815212333 Apache Blvd, Jacksonville, FL, 322690.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-119049ENRRaymond Y Ward1973-06-13UHC-67172-9646363695593959 Sunset Blvd, Las Vegas, NV, 891970.62Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118836ENRStephanie Mejia1984-11-12UHC-10286-0156484769843840 Highland Ave, Glendale, AZ, 853830.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125396ENREthan Gilbert1997-06-26UHC-51622-7481790013923637 Main St, Atlanta, GA, 303230.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-125395ENREthan Gilbert1997-06-26UHC-51622-7481790013923637 Main St, Atlanta, GA, 303230.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-124048ENRLarry S Morgan1970-12-27UHC-28354-9464557264786551 Lincoln Way, San Diego, CA, 921340.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110632ENRGregory Franklin2000-06-12—90237271375586 Pine Dr, Los Angeles, CA, 900530.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120505ENRRichaard I Stone1951-11-11UHC-97487-1354833006845628 Grand Ave, Chandler, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138196ENRBarndon Santos1965-05-10UHC-60608-3972034353081113 Broadway, Houston, TX, 770910.62Name split from “Last, First”Phone reformattedMember ID reformattedAddress re-cased+3 more
ENR-142535ENRStephen Valdez1975-03-18UHC-30831-4077473037363115 Park Pl Apt 17, Denver, CO, 802510.62Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-114762ENRCarlos Spencer1952-05-26UHC-03040-3557228193711250 Sage Ct, Minneapolis, MN, 554290.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114600ENRMichael R Davis1954-08-05UHC-14997-2090646316289821 Hillcrest Rd, Tampa, FL0.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-102839ENRJames O Marshall2006-09-03UHC-35247-8135464439912554 Willow Ct, San Antonio, TX, 782400.62Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-120729ENRJoyce Hunter2006-07-08UHC-09705-6296483273043697 Main St, Plano, TX, 750420.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128963ENROlivia Davis1995-11-18UHC-46336-8323848026725346 Elm St, Columbus, OH, 432810.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-133011ENRTyler V Mills1994-07-04UHC-15931-6141925153189120 Market St, Columbus, OH, 432720.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128859ENRRoy G Willis1996-05-27UHC-62931-0687577663447433 Indian School Rd, Miami, FL, 331010.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-103348ENREmma A Perez1997-09-25UHC-52568-4750221447025635 Oak St, Gilbert, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105184ENRTimothy Aronld1957-04-13—77198716227089 Mesa Dr, Charlotte, NC, 282270.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-116467ENRCarlos Y Guerrero1960-03-11UHC-84016-21697585936953 Grand Ave, Gilbert, AZ, 852410.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103398ENRHelen Allen1961-06-07UHC-39252-8498655206561340 Main St, Tucson, AZ, 857320.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-116845ENRJudy X Ryan2006-04-20UHC-02874-7986291330494017 Ocean Ave # 262, Plano, TX, 750880.62Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-142458ENRDick Hall1968-05-21UHC-80730-4836537939981642 Mountain View Dr, Dallas, TX0.62Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-140535ENRBoyd Sara1989-11-16UHC-00830-9488283561363848 Bayshore Dr, Las Vegas, NV, 891010.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-120107ENRRebeccaJunk1958-11-12UHC-46812-6788223717427931 Washington St, Atlanta, GA, 303120.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116069ENRMark U Tran1961-04-26UHC-77913-357622754588427 Washington St, San Diego, CA, 921640.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115583ENRJordan Perkins1951-03-03UHC-84504-7294748226349661 Mesa Dr, Charlotte, NC, 282310.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-101304ENRRalph Y Vargas1969-06-27UHC-63428-9751441471515769 Cedar Ln, Tempe, AZ, 852790.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128353ENRSamantha Dominguez1983-01-27UHC-55189-2631030232381012 Bayshore Dr # 259, Columbus, OH, 432490.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-133577ENRAlexis O Vasquez1968-08-12UHC-44563-4377192505886026 Ocean Ave, Chandler, AZ, 852410.62Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-133578ENRAlexis O Vasquez1968-08-12UHC-44563-4377192505886026 Ocean Ave, Chandler, AZ, 852410.62Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-130248ENRChristine James2004-08-08UHC-20756-554473361752264 Lake View Rd, Charlotte, NC0.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-112889ENRCheryl Welch1938-01-06UHC-07157-2841482870966366 Hillcrest Rd Apt 27, Miami, FL, 331540.62Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-128719ENRHelen Mills1972-02-09UHC-72226-5669193391848254 Cedar Ln, San Diego, CA, 921270.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-111145ENRLawrence L Morrison1965-09-14UHC-89838-1684052759472495 Pine Dr, Miami, FL, 331990.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-134240ENRArjun Bradley2006-08-16UHC-09600-5898070226003080 Valley View Dr # 905, Chandler, AZ, 852730.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
43,101 rows, page 136 of 863PreviousNext