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-123608ENRRyan P Rogers1988-02-01UHC-87700-6173722149038822 Cedar Ln, Atlanta, GA0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-142406ENRDiane P Perkins1983-03-17UHC-00538-2756531585274580 Hillcrest Rd, Glendale, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-119190ENRNicole Robertson1976-07-12UHC-67797-4747324638233505 Sage Ct, Los Angeles, CA0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-107623ENRJacob J Reed—UHC-01120-6358066391949349 Meadow Ln, Columbus, OH0.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122887ENRLinda Z Garrett1979-03-06UHC-28085-1836791340938977 Hillcrest Rd, Tempe, AZ, 852550.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-133683ENRLisa V Singh1998-06-03UHC-77375-17—3457 Mesa Dr, Miami, FL, 331010.48Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
ENR-137569ENRKatherine Padila1943-06-08UHC-78445-7594167746134199 Ridge Rd, Seattle, WA, 981160.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-139931ENRKyle Z Le—UHC-49171-75—3289 Church St, Eden Prairie, MN, 553700.48Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
ENR-130695ENRDonna G Holmes1958-03-17UHC-94194-3068022402418953 Main St, Glendale, AZ, 853080.48Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-109710ENRGerald Bailey1939-07-16UHC-38263-5538922748116098 Washington St, Plano, TX, 750640.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-120103ENRRuth B Wilson1970-07-22UHC-28608-66—1034 Camelback Rd, Jacksonville, FL, 322660.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-129741ENRXJunk1993-09-06UHC-00455-395858741769592 Jefferson Ave, Charlotte, NC, 282810.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131586ENRBenjamin U Carpenter—UHC-86121-26—8555 Baseline Rd, Columbus, OH, 432430.48Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+4 more
ENR-127578ENRLinda O Hart1952-12-22UHC-14871-1289697768708803 Canyon Rd, San Diego, CA0.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116981ENRDorothy Bishop1975-12-12UHC-06383-2577445837908850 Mesa Dr, Houston, TX, 770400.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132891ENRLinda V Reynolds2004-10-19UHC-41436-28—900 Ocean Ave, Tempe, AZ0.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129077ENRSharon E Rose2004-02-27UHC-55095-57270396571999 Lake View Rd Apt 16, Orlando, FL, 328390.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-140206ENRBarbara Stevens1976-08-17UHC-77280-772502990466720 Main St, Las Vegas, NV, 891500.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-117747ENRValentina Q Baker1998-03-24UHC-81231-4186665108991465 Apache Blvd, Scottsdale, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107598ENRDaniiel D Roberts2005-12-26UHC-94741-837797070570631 Sunset Blvd, Sacramento, CA, 958320.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-132914ENRScott T Gardner1989-04-26UHC-83945-7421466988213672 Lake View Rd, Dallas, TX0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120973ENRJulie R Rios—UHC-27625-4189542992765635 Lincoln Way, Los Angeles, CA, 900020.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-131666ENRDebra Howell—UHC-76247-6320189479669725 Mesa Dr, Austin, TX, 787430.48Name re-casedDate of birth missingPhone reformattedMember ID reformatted+4 more
ENR-114579ENRJordan W Morles1952-08-11UHC-10237-8461534108189688 Forest Ave, Atlanta, GA0.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-137893ENRCarl P Chapman1972-03-02UHC-14869-5723033573047757 Hillcrest Rd, Columbus, OH0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-134873ENRSamuel W Fisher1963-12-19UHC-86502-0922140069091226 Palm Dr, Denver, CO, 802980.48Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-112398ENRBobby Harper1991-12-14UHC-24069-932702784382516 Park Pl, Fresno, CA0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101242ENRRoger D Clark1985-04-20UHC-11754-6974851587321018 Grand Ave, Nashville, TN, 372210.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
ENR-100362ENRAlice R Hudson1997-06-04UHC-39004-6881121747535423 Bayshore Dr, Fresno, CA, 937140.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-142916ENRBruce Tran1939-06-10UHC-11511-51—8766 Apache Blvd, Orlando, FL, 328760.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-120093ENRTyler L Chapman2005-02-26UHC-17051-9934120875046201 Mountain View Dr, Sacramento, CA, 958110.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-124123ENRCarol Kelly—UHC-09522-4830183460501796 Maple Ave, Seattle, WA, 981140.48Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-116655ENRTeresa Taylor2007-08-11UHC-76093-8246851337493498 Bayshore Dr, Tampa, FL0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101107ENRBurke S Hannah2008-11-14UHC-00120-2326193414167092 Canyon Rd, Chandler, AZ, 852570.48Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
ENR-103299ENRAnna Chapman1947-10-17—31390615491007 Main St, Charlotte, NC, 282280.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-125589ENRArthur R Washington1978-04-20UHC-16202-7887880718254585 Mesa Dr, San Antonio, TX, 782140.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102974ENRLaura E Willis1946-03-19UHC-57630-6525167749923014 Jefferson Ave, San Diego, CA0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-116559ENRLisa Myers1975-08-10UHC-30198-6050928832106220 Willow Ct, Fresno, CA0.48Member ID reformattedState name converted to codeZIP missingEmail lower-cased+4 more
ENR-112697ENRWillie P Hoffman1963-05-05UHC-26483-1038293880585145 Mesa Dr # 515, Denver, CO, 802410.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-104911ENRDilan Arnold1964-03-17UHC-34868-1628250560907544 Pine Dr, Jacksonville, FL0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104451ENRAustin B Reid1941-04-21UHC-86036-5344336514051361 Pine Dr, Tampa, FL, 336310.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
ENR-104450ENRAustin B Reid1941-04-21UHC-86036-5344336514051361 Pine Dr, Tampa, FL, 336310.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
ENR-118655ENRKayla Alvarez1965-02-05UHC-80479-0320139704982707 Church St, Seattle, WA0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-114882ENRDebraJunk1947-12-10UHC-73580-7930665532369195 Hillcrest Rd, Sacramento, CA, 958700.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122884ENRShirley Griffin2008-09-22UHC-80810-02—3836 Oak St, Denver, CO, 802620.48Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-104860ENRWillie W Phillips1991-11-15UHC-87487-8722627242137567 Grand Ave, Charlotte, NC, 282650.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-110202ENRNoah Miller—UHC-00633-608687041115468 Bayshore Dr, Scottsdale, AZ, 852500.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124863ENRRussell Valdez1968-04-09UHC-94337-1063682164555367 Pine Dr, Miami, FL, 331070.48Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
ENR-112853ENRGeorge Banks1987-07-19UHC-71568-86—8067 Washington St, Columbus, OH, 432090.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-111925ENRSamantha Ward1944-06-01UHC-62356-3549345635456034 Ridge Rd, Miami, FL, 331860.48Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+4 more
43,101 rows, page 37 of 863PreviousNext