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
CLM-409099CLMLuis Greene2000-06-15UHC-14290-02—5329 Lincoln Way Apt 17, Atlanta, GA, 303720.46Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+5 more
ENR-120123ENRAmy F Baker1967-05-15UHC-44725-6069399212714115 Palm Dr, Chandler, AZ, 852230.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-23494PRVEvelyn Gardner1992-09-28UHC-73149-1893263507463445 Mountain View Dr Apt 14, Mesa, AZ, 852500.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-131866ENRRichard N Chapman1999-11-01UHC-28200-7083145813415513 Desert Sky Blvd, Plano, TX, 750120.46Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-123941ENRGrace P Kim1952-04-02UHC-89018-0947645904772766 Sage Ct, Denver, CO0.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-423595CLMChristine Hoffman2003-05-09UHC-38010-16—5855 Spring St, Phoenix, AZ, 850220.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-417775CLMPatricia K Phillips1964-04-13UHC-42386-79—6649 Hillcrest Rd, Plano, TX, 750210.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-108228ENRShirley V Watson1942-01-18UHC-42611-87—5102 Main St, Austin, TX, 787070.46Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-138119ENRNatalie Kim1997-01-07UHC-69045-4949973632769655 Cedar Ln # 327, Phoenix, AZ, 850810.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
PRV-27875PRVRebecca D Mendoza2006-03-10UHC-41468-6086963900349585 Baseline Rd, Houston, TX, 770940.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-60163TPARaymond Turner1999-09-09—9878746251321 Grand Ave # 314, Denver, CO, 802080.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
PRV-23741PRVChapman Heather1981-12-02—67950817317036 Park Pl, Minneapolis, MN0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-59541TPAMateo Silva2008-01-02——4577 Camelback Rd Apt 22, Columbus, OH, 432100.46Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+5 more
CLM-406672CLMNicole V Burke1985-04-14UHC-61538-7490498542777663 River Rd, Orlando, FL0.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-111914ENRChristine D Barnes2006-01-22UHC-70917-3253226338615821 Washington St, Columbus, OH, 432900.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-21599PRVDenise Dunn1954-05-11UHC-66614-2637971970485263 Sunset Blvd # 365, Tempe, AZ0.46Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
ENR-134226ENRVictoria Rogers2008-05-10UHC-57091-1473438170181444 Indian School Rd, Plano, TX, 750290.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-110925ENRHelen Spencer1939-09-05UHC-12971-4239453721243371 Meadow Ln Apt 40, Orlando, FL, 328070.46Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more
TPA-57435TPABeverly Bannett1948-08-14UHC-99014-61—4158 Indian School Rd, Denver, CO, 802910.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-25658PRVAisha Stone1984-07-07UHC-36349-477474481889905 Main St, Houston, TX0.46Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
PRV-20936PRVGary Palmer1948-08-24—73188824644655 Meadow Ln, Los Angeles, CA, 900910.46Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-417459CLMIsabella Gutierrez1951-12-15UHC-20838-77—4325 Elm St, Fresno, CA, 937900.46Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-118764ENRJeremy J Ortega2002-08-07UHC-18231-8730098129354675 Indian School Rd, Charlotte, NC, 282780.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-415286CLMEdwards Janice1951-03-03UHC-49570-052073584379207 Park Pl, Dallas, TX, 752390.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-432482CLMLuis Jonees1948-05-16UHC-28777-7997780472512298 Sage Ct, Phoenix, AZ, 850960.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-139950ENRBrandon M Hamilton1965-04-13UHC-11844-8066792839388869 Mountain View Dr, Tucson, AZ0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-27501PRVObrien M Laura2000-08-16—44860016813657 Desert Sky Blvd Apt 36, Los Angeles, CA, 900290.46Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
ENR-119744ENRLaura Watkins1961-02-15UHC-86062-5429472844132762 Willow Ct Apt 17, Mesa, AZ, 852310.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-113079ENRKatherine B Larson1972-09-17UHC-24304-5049124070454444 Main St, Los Angeles, CA0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-20657PRVStephen Mason1949-01-20—72674423555037 Ocean Ave, Columbus, OH, 432240.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-123016ENRMelissa Hart1959-12-19—57192690511003 Apache Blvd, San Diego, CA, 921750.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-27711PRVKelly Carlson——56094767474379 Palm Dr Apt 19, Jacksonville, FL, 322810.46Name re-casedDate of birth unreadablePhone reformattedUnit split from street+5 more
PRV-21370PRVJesse Hernandez1989-02-19—79660251482786 Spring St, Fresno, CA0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-419689CLMRyan Wong1941-03-06UHC-57924-2347727071956303 River Rd, Atlanta, GA, 303370.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-124183ENRSantiago Z Dominguez1963-04-09UHC-05052-5759926377809297 Forest Ave, Dallas, TX, 752140.46Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+5 more
ENR-113586ENRJulia S Nguyen1969-11-02UHC-27419-7946580314785776 Meadow Ln Apt 20, Charlotte, NC, 282930.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
PRV-29234PRVRuth F Mejia1994-02-05UHC-04349-3752445071764936 Ocean Ave, Seattle, WA, 981300.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-418300CLMGloria Dean2002-02-17UHC-59777-5151855328393807 Meadow Ln, Plano, TX0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-100026ENRNancy O Campbell1991-05-20UHC-10392-0473323811593517 Baseline Rd # 391, Jacksonville, FL, 322660.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-432551CLMRobert Ramos1946-11-20UHC-34491-97—5876 Indian School Rd, San Antonio, TX, 782390.46Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-102206ENRArthur N Mason1975-07-11UHC-95789-7433739743675652 Jefferson Ave # 776, San Antonio, TX, 782660.46Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
ENR-110807ENRKathleen Wganer1990-12-17UHC-97845-1677163068609711 Spring St # 709, Tampa, FL, 336530.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-129468ENRTyler M Mason—UHC-65746-0572761996884287 Union St, San Diego, CA, 921340.46Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+5 more
ENR-127727ENRKatherine V Wagner1962-05-06UHC-22531-1376220184141301 Ocean Ave, Columbus, OH, 432730.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-136373ENRDoris X James1957-05-03—50856012261527 Elm St, Plano, TX, 750870.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
PRV-27059PRVGeorge B Gilbert1990-12-21UHC-16075-9681260493565038 Ocean Ave, Seattle, WA, 981650.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
PRV-26326PRVCarol Mason1947-06-16UHC-05630-6841586041551548 Grand Ave Apt 38, Los Angeles, CA0.46Name re-casedPhone reformattedMember ID reformattedUnit split from street+5 more
ENR-134771ENRAlan Smith2004-11-04UHC-62253-6492266687868017 Highland Ave, Glendale, AZ, 853460.46Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
ENR-137757ENRAnn Santiago1990-01-07UHC-72018-8943134141034669 Main St, Glendale, AZ, 853380.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-122059ENRFrank Weber1956-03-02UHC-60254-7580281704143595 Valley View Dr, Glendale, AZ, 853110.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
100,000 rows, page 44 of 2,000PreviousNext