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-117136ENRHannah B Simmons—UHC-61478-1259579112752317 Church St, Fresno, CA, 937780.50Name split from “Last, First”Date of birth missingPhone reformattedMember ID reformatted+3 more
ENR-132829ENRWei L Medina1925-10-25UHC-05721-07—4780 Lake View Rd, Plano, TX, 750670.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-101833ENRRobert S Campbell1972-06-02UHC-60444-5742939605842785 Willow Ct, Charlotte, NC, 282530.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-112846ENRDeborah S Berry1940-01-16UHC-77773-4258678505652880 Pine Dr, Gilbert, AZ, 852570.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-118147ENRMarcus T West1999-09-26UHC-07676-7523067476447751 Union St, Mesa, AZ, 852220.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107259ENRLarry Kim1988-06-21UHC-54455-5663350730103283 Church St, Atlanta, GA, 303730.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101923ENRJuhn Simpson1959-02-04UHC-44690-09275837808112 Highland Ave, Austin, TX, 787080.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-118050ENRButler Sara1957-12-03UHC-52657-1622833938077267 Grand Ave, Columbus, OH, 432060.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-107738ENRDeborah U Carter1952-02-25UHC-61116-0226948215889650 Indian School Rd Apt 33, Scottsdale, AZ0.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-127586ENRMichael Rodriguez—UHC-88992-5127326058129899 Indian School Rd, Columbus, OH, 432470.50Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+3 more
ENR-137605ENRJesse H Wilson1996-10-24UHC-96437-4981882054617802 Camelback Rd, Seattle, WA, 981570.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120885ENRBrittany Knight1941-02-07UHC-00515-0467248320089018 Maple Ave, Orlando, FL, 328820.50Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
ENR-122275ENRBradley Q Sims2006-09-04UHC-24731-14—5554 Cedar Ln, Atlanta, GA0.50Phone missing area codeCity re-casedState code upper-casedZIP missing+3 more
ENR-107556ENRChristopher Kelley1959-08-12UHC-48024-3345334849419760 Highland Ave, Sacramento, CA0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142927ENRAustin O Lopez1977-09-24UHC-10967-1563771948295139 Ocean Ave Apt 30, Charlotte, NC, 282150.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-127127ENRTheresa Murray1974-08-13UHC-57458-8963093095807975 Hillcrest Rd Apt 9, San Diego, CA, 921570.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-101145ENRCatherine E Ford1988-07-03UHC-79361-303644097615975 Main St, Gilbert, AZ, 852870.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-134462ENRHelen W Munoz1951-03-02UHC-11640-3895258437126368 Washington St, Gilbert, AZ, 852630.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-124743ENRHannah N Andrews1976-03-21UHC-25949-039595671574113 Elm St, Columbus, OH, 432450.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-138145ENRKenneth E Woods1963-12-26UHC-80979-49—6704 Sage Ct, Seattle, WA, 981710.50Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+3 more
ENR-128876ENRTurnner I Alexander1965-08-27UHC-98406-32—429 Pine Dr, Sacramento, CA, 958970.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-113320ENRSara F Padilla1982-02-02UHC-35197-2851835844263359 Church St # 715, Tempe, AZ, 852400.50Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-103097ENRDiana Hudson——53898029204568 Elm St, Tempe, AZ, 852810.50Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-113356ENRIsabella Le—UHC-22656-20—7791 Desert Sky Blvd, Orlando, FL, 328460.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-116561ENRChristopher Chavez1944-04-25UHC-85547-1447698150005415 Forest Ave, Los Angeles, CA, 900430.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140103ENRBill Z Moreno1963-03-16—43765062753740 Valley View Dr, Seattle, WA, 981100.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-106922ENRLaura W Davis1997-07-10UHC-05707-4698636121571357 Maple Ave, Los Angeles, CA, 900790.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130343ENRRalph Lyncch2004-10-21UHC-37719-32—2485 Church St, Mesa, AZ, 852860.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-119955ENRMari D Cruz1989-07-28UHC-50333-6069164244911792 Forest Ave Apt 2, Phoenix, AZ, 850830.50Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
ENR-133488ENRKimberly Bryant1999-01-19UHC-33003-665967351509767 River Rd Apt 12, Scottsdale, AZ, 852920.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-124490ENRDouglas F Day1946-08-13UHC-15264-5455539472483209 Washington St, Orlando, FL, 328140.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133327ENRNancy Gybson—UHC-33101-1953446994598766 Indian School Rd, Las Vegas, NV, 891490.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135669ENRRalph Turner1971-04-25UHC-77031-5896982980671371 Apache Blvd, Houston, TX, 770070.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135513ENRMariana Williamson—UHC-04332-28—8477 River Rd Apt 35, Gilbert, AZ, 852580.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
ENR-120514ENRLori Roberts1999-01-04UHC-78605-1736147022119741 Canyon Rd, Houston, TX, 770710.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-111888ENRBrittany Z Wheeler1971-09-05UHC-55556-4596170438301233 Forest Ave, Miami, FL, 331620.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115962ENRDaniel Y James1948-12-17UHC-82075-2489399835626549 Spring St Apt 29, Gilbert, AZ, 852790.50Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-114054ENRMason P Carter—UHC-49290-1748061236804253 Mountain View Dr, Houston, TX, 770950.50Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+3 more
ENR-134309ENRStephen Meyer1960-04-21UHC-55817-7452962262599395 Sage Ct, Jacksonville, FL0.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-131686ENRPhilip Warren1964-04-26UHC-00906-326237643552416 Meadow Ln, Nashville, TN, 372600.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113182ENRJean J Williamson1954-07-12UHC-15361-5665087190785902 Apache Blvd, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111224ENRVincent J Stevens1975-10-05UHC-60712-5947239524321528 Baseline Rd # 847, Sacramento, CA, 958450.50Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+3 more
ENR-136021ENRWayyne Castillo1957-03-05UHC-95042-5963872668708324 Desert Sky Blvd, San Antonio, TX, 782470.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-106951ENRSophia Schultz1979-05-28UHC-23034-2523387509242062 Jefferson Ave, Phoenix, AZ, 850190.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131805ENRJack K Mendez1985-06-04UHC-80621-1246857546529614 Highland Ave, Jacksonville, FL, 322750.50Date of birth reformattedPhone reformattedMember ID reformattedState name converted to code+3 more
ENR-108203ENRElijah E Ryan1991-11-22UHC-60945-0292699428841873 Meadow Ln # 811, Austin, TX, 787910.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-101832ENRHeather H Le1960-09-15UHC-10593-3565954861905299 Desert Sky Blvd Apt 33, Austin, TX, 787400.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-100433ENREmma Tucker—UHC-98732-6094946553232705 Valley View Dr, San Antonio, TX, 782290.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115349ENRJoseph P Lee1974-05-25UHC-49849-9554641746125814 Sage Ct, Scottsdale, AZ, 852540.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-130515ENRRachel Schmidt1990-01-10UHC-48968-9440237574044772 Sage Ct # 163, San Antonio, TX, 782540.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
43,101 rows, page 63 of 863PreviousNext