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-134734ENRBryan Matthews1988-07-28UHC-23750-61—8907 Harbor Blvd, Plano, TX, 750850.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-121735ENRValentina Cooper1984-09-18UHC-46542-8829659399121898 Elm St, Mesa, AZ0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-139266ENRDanielle K Weaver—UHC-98676-066926129401724 Palm Dr, Atlanta, GA0.50Name re-casedDate of birth missingCity re-casedZIP missing+3 more
ENR-114388ENRHiroshi B Harrison1948-04-27UHC-09174-0953892439591277 Spring St, Fresno, CA, 937970.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-114040ENRBrandon Q Armstrong1959-11-13UHC-84467-90—2641 Apache Blvd # 334, Denver, CO, 802810.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-115513ENRJeffrey Vazquez2007-06-12UHC-94739-6553694954972458 Lincoln Way Apt 23, Houston, TX, 770610.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-127876ENRAmber G Moreno—UHC-25618-8030948507914874 Camelback Rd, Atlanta, GA, 303170.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-134056ENRJusitn I Rojas1950-01-27UHC-93944-4741030072715377 Cedar Ln, Mesa, AZ, 852600.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107350ENRJose B Lawrence1967-12-22UHC-16741-1523388996049696 Valley View Dr, Atlanta, GA, 303000.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104102ENRDiego Daniels1953-10-13UHC-77752-8623935792433198 Highland Ave, Eden Prairie, MN, 553570.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-117142ENRDiana V Lane1940-04-01UHC-50137-2876837049623196 Sunset Blvd, Eden Prairie, MN, 553780.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-118302ENRSamuel V Padilla1955-10-19UHC-58277-7330527143926345 Jefferson Ave, Minneapolis, MN, 554700.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-117757ENRKeith Woods1954-03-22UHC-83597-4626230733288189 River Rd # 524, Denver, CO, 802240.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-101385ENRAnthony Sanchez1983-04-09UHC-43379-6687553789388793 River Rd, Chandler, AZ, 852940.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124775ENRAhmed Kim2004-08-23—75372182194911 Forest Ave # 468, Nashville, TN, 372980.50Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
ENR-118987ENRMei B Bradley—UHC-98883-3396965361313322 Palm Dr, Denver, CO0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131939ENRJulia Maldonado1985-02-06UHC-81622-15—2094 Bayshore Dr, Nashville, TN, 372120.50Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more
ENR-122718ENRJoyce Santiago2000-08-25UHC-78000-992348295751832 Highland Ave # 934, Los Angeles, CA, 900080.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-137332ENRMartha Henderson1970-11-08UHC-50518-6321083410554102 Forest Ave, Chandler, AZ0.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-139174ENRLuis Y Stevens2002-07-18UHC-41015-83—7599 Grand Ave, Sacramento, CA, 958500.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100180ENRGabriel U Olson1967-05-06UHC-29339-5123491799072526 Ridge Rd, Eden Prairie, MN0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136804ENRJanice Hamilton1977-02-23UHC-98453-7639667201566541 Cedar Ln, Las Vegas, NV, 891370.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-129708ENRHannah White1953-06-08UHC-97230-8289130796274277 Palm Dr, Eden Prairie, MN, 553680.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-117590ENREvelyn Y Reyes1999-09-05UHC-54787-27692756032648 Mountain View Dr, Los Angeles, CA, 900350.50Middle initial moved out of first nameName re-casedDate of birth reformattedSSN last four extracted+3 more
ENR-137045ENRAlice Cruz1939-01-08UHC-28830-6847323834234350 Meadow Ln, Houston, TX, 770290.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-129239ENRJohn F Espinoza1999-03-28UHC-35989-4492732326322404 Elm St, Denver, CO, 802800.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-111958ENRLarry V Smith1953-11-11UHC-68077-8266470071871043 Park Pl Apt 30, Las Vegas, NV, 891070.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-108201ENRMariana B Luna1950-08-20UHC-89166-28—8589 Sage Ct Apt 14, Austin, TX, 787230.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-113228ENRAmber Hamilton1974-09-16UHC-67162-0187222770656618 Maple Ave, San Diego, CA, 921720.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124193ENRRuth Harrison2005-09-04UHC-44564-9535931363357712 Lake View Rd # 642, Orlando, FL, 328490.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-134772ENRZachary G Delgado1993-04-17UHC-61679-399088226788305 Elm St, Las Vegas, NV, 891680.50Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+3 more
ENR-129739ENRBrandon V Park1974-03-06UHC-98562-4892329959366348 Ocean Ave, Houston, TX, 770340.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-104355ENRShirley M Hanson2007-03-04—95731033111453 Camelback Rd, Tucson, AZ, 857810.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119348ENRMason U Pierce1970-10-14UHC-14486-4575841837265979 Maple Ave, San Antonio, TX, 782710.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100773ENRDon H Morris1942-04-15UHC-50338-69—8022 Elm St, San Antonio, TX0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-123494ENRBeverly Romero1963-02-22UHC-08319-0767841324517088 Ocean Ave, Miami, FL, 331820.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134303ENRAbigaail Nguyen1983-08-14UHC-73153-328667394037293 Harbor Blvd, Phoenix, AZ, 850900.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-133929ENRTyler E Warren1998-12-20UHC-28073-3374459828601338 Grand Ave, Chandler, AZ, 852410.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
ENR-141405ENRMelissa Dominguez1955-10-15UHC-07165-119855304738953 Baseline Rd, Sacramento, CA, 958390.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-106093ENRYuki Burns1954-07-12UHC-79691-4626480570261160 Jefferson Ave # 442, Austin, TX, 787030.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-134372ENRStephanie Singh1974-07-10UHC-26939-0353834498653553 Ocean Ave, San Diego, CA, 921570.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-129724ENRRobert Q Torres1954-09-05UHC-04834-0550234690115873 Lake View Rd # 793, Chandler, AZ, 852540.50Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-139195ENREdward E Davis1969-12-02UHC-71730-0522157097163287 River Rd # 623, Sacramento, CA0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-105665ENRGeorge V Crewford1976-11-08UHC-99216-3577290358255515 Park Pl Apt 30, Los Angeles, CA, 900500.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130309ENRCarolyn Butler1996-09-24UHC-60274-913125361293116 Meadow Ln Apt 3, Denver, CO, 802500.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-129456ENRDorothy Wood1950-05-01UHC-31545-27—7288 Mesa Dr, Jacksonville, FL, 322930.50Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-142717ENRDoris McDonald1977-06-19UHC-00910-815318250759566 Church St, Chandler, AZ, 852030.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105013ENRKathryn Z Edwards1960-06-06UHC-87671-7652995046134681 Ocean Ave, Atlanta, GA, 303820.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-107926ENRPriya Harvey1989-08-15UHC-41050-4759826117183080 Apache Blvd Apt 31, Dallas, TX0.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-137577ENRGabriel G Riley1973-07-26UHC-30685-6578861894837975 Washington St, Miami, FL, 331400.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 67 of 863PreviousNext