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-131702ENRBetty W Perez1993-11-02UHC-48568-7364042208797980 Sage Ct, Houston, TX, 770450.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138358ENRAlice R Gibson1952-08-03UHC-06859-9295695657043399 Palm Dr, Los Angeles, CA0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-121858ENRMarcus Johnston1957-01-12UHC-13149-5042343056557914 Meadow Ln, Las Vegas, NV, 891670.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140952ENRMarilyn Hart1964-01-17UHC-50479-15—448 Highland Ave, Eden Prairie, MN, 553760.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-113849ENRKaren Jones2002-07-28UHC-76594-767426539630203 Washington St, Los Angeles, CA, 900290.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-142250ENRCarol X Hoffman1961-10-11UHC-22754-1861554332542719 Elm St, Mesa, AZ, 852490.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
ENR-106297ENRWilliam Fox1961-11-11UHC-95380-9737534896702561 Spring St, Charlotte, NC, 282430.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-136311ENRAmy Fernandez1948-03-16UHC-54769-5128972047603078 Lake View Rd, Los Angeles, CA, 900290.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124285ENRJulia N Jackson1986-05-03UHC-00538-0377790585409856 Maple Ave, San Antonio, TX0.50Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101932ENRMary B Simmons1941-09-06UHC-87003-6655594995805610 River Rd, San Diego, CA0.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-106566ENRJanet D Rios1994-08-18UHC-21359-1244438763822984 Canyon Rd, Orlando, FL, 328010.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-128695ENRNancy Williamson1948-03-24UHC-86218-7582451174668444 Apache Blvd # 354, Fresno, CA, 937810.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-139692ENRWayne Z Wells1995-08-28UHC-44029-8620152920381864 Oak St Apt 8, Nashville, TN, 372100.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-114201ENRDorothy Q Mason1997-01-28UHC-16584-13—8937 Desert Sky Blvd, Glendale, AZ, 853400.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135387ENRMartha P Jenkins1987-01-15UHC-38108-7329447690828650 Apache Blvd, Sacramento, CA, 958210.50Name re-casedPhone reformattedSSN last four extractedState name converted to code+3 more
ENR-117485ENRAlbert Chavez1977-02-08UHC-43543-7532060296936905 Maple Ave Apt 25, Fresno, CA, 937830.50Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-139771ENRJuan Owens1990-04-23UHC-80301-1596653142579414 Hillcrest Rd # 736, Orlando, FL, 328190.50Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+3 more
ENR-112646ENRChristina Allen1957-02-22UHC-12140-6832334749325023 Apache Blvd, Charlotte, NC, 282050.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-143021ENRTyler S Anderson2002-09-16UHC-60331-66—7392 Main St, Sacramento, CA0.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-107863ENRRoger Gonzalez1979-03-28UHC-13173-01—4584 Central Ave, Los Angeles, CA, 900570.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-107864ENRRoger Gonzalez1979-03-28UHC-13173-01—4584 Central Ave, Los Angeles, CA, 900570.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-102909ENRChristina Y Bradley1958-08-26UHC-61892-189852474058934 Apache Blvd Apt 11, Plano, TX, 750780.50Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+3 more
ENR-100667ENRHiroshi I Payne1973-06-23UHC-37270-0680925245006131 Apache Blvd, Austin, TX, 787770.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114182ENRHarold Fox1946-07-09UHC-10508-0569782674728814 Elm St, Columbus, OH, 432420.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-133661ENRWayne B Hansen1992-06-27UHC-73085-8535078871409844 Mountain View Dr, San Diego, CA, 921310.50Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+3 more
ENR-132948ENRRyan Davis1968-07-03UHC-16030-43—3316 Hillcrest Rd, Sacramento, CA0.50Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-108351ENRCamila D Murphy1983-01-06UHC-75358-9757421915063039 Pine Dr, Glendale, AZ, 853030.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123103ENRJeffrey K Singh2008-10-28UHC-30073-4990545889423844 Cedar Ln, Las Vegas, NV0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-126934ENRAlan P Rice1997-11-15UHC-77693-5071261019391231 Desert Sky Blvd, Phoenix, AZ, 850870.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126933ENRAlan P Rice1997-11-15UHC-77693-5071261019391231 Desert Sky Blvd, Phoenix, AZ, 850870.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112399ENRBobby Harper1991-12-14UHC-24069-932702784382516 Park Pl, Fresno, CA, 937010.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135409ENRDaniel Y Jensen1974-09-12UHC-77446-0591780225373605 Baseline Rd, Chandler, AZ, 852390.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129074ENRMarcus P Lewis1981-05-06UHC-53639-0439398273892066 Main St, Atlanta, GA, 303430.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-140635ENRKenneth H Garrett1999-04-11UHC-93400-7681870029901710 Harbor Blvd, Minneapolis, MN, 554460.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-108920ENRJean Myers1977-02-04UHC-89681-8842873382554776 Pine Dr, Orlando, FL, 328670.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-121350ENRAlan O Maldonado1940-09-18UHC-40405-9896486407403947 Willow Ct # 239, Fresno, CA, 937600.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-117222ENRSophia Ferguson1956-12-12UHC-38535-7461887158195698 Baseline Rd, San Antonio, TX, 782250.50Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-111440ENRMason B Thmas1975-02-27UHC-72107-5080428543759032 Hillcrest Rd, San Antonio, TX, 782830.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-128702ENRHenry Sean2006-09-22UHC-61982-6027387177204054 Apache Blvd Apt 38, Jacksonville, FL, 322720.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-104768ENRLawrence V Estrada1944-10-22UHC-71464-1825765326334645 Harbor Blvd, Columbus, OH, 432900.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-107762ENRKevin Franklin1974-07-23UHC-68794-8549839752828025 Valley View Dr, Gilbert, AZ, 852420.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109417ENRShirley Cruz1978-10-23UHC-86255-788457280068814 Baseline Rd, Glendale, AZ, 853140.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-117186ENRAnn Barnes2002-11-15UHC-79988-6183946090819185 Central Ave, Charlotte, NC0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104160ENRVincent T Brooks1946-11-09UHC-04330-6842829036531195 Ridge Rd, Eden Prairie, MN0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133868ENRNathan A Alvarez1999-11-21UHC-29311-4373841716143534 Mesa Dr, Seattle, WA, 981760.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105673ENRPatryck Willis1966-07-03UHC-50932-4941144048271850 Cedar Ln, Denver, CO, 802330.50Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+3 more
ENR-116893ENRMichael V Harrison—UHC-04868-2495774260607551 Lake View Rd, Los Angeles, CA, 900950.50Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-125096ENRDebra S Coleman1946-01-26UHC-23801-02—9237 Washington St, Miami, FL, 331470.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-100971ENRRonald Perez1980-01-07UHC-12194-3546982270133180 Elm St, Charlotte, NC, 282840.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-109063ENRAmber O Delgado1998-09-15UHC-52060-8571689812176469 Market St # 734, Minneapolis, MN, 554010.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 69 of 863PreviousNext