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-130897ENRDenise E Riley1978-11-12UHC-35670-8362242321858523 Jefferson Ave, Atlanta, GA, 303410.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-132728ENRBrittany Alvaredo1991-09-17UHC-89357-1759758267667794 Baseline Rd # 601, Phoenix, AZ, 850440.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-128052ENRDennis Robinson1991-08-17UHC-88911-2151932289126591 Jefferson Ave, Chandler, AZ, 852600.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-132102ENRBrandon J Schmidt1957-04-09UHC-43499-7197075114432141 Union St, Denver, CO, 802920.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-125147ENRLinda Guerrero1974-03-06UHC-56786-6379691259761155 Cedar Ln, Gilbert, AZ, 852980.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-134622ENRNoah Q Lee2005-12-17UHC-90337-3232379195469849 Highland Ave, Fresno, CA, 937810.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-123633ENRJackie N Sanders1951-07-10UHC-15346-562998888429737 Grand Ave, Glendale, AZ, 853350.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-122980ENRRaymond Fox2000-10-21UHC-82222-3734661704087089 Mesa Dr, Eden Prairie, MN, 553060.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108291ENRBobby M Jimenez1963-03-15UHC-23688-8889148905048735 Ridge Rd, San Diego, CA, 921690.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-110629ENRAisha Myers1995-02-19UHC-16370-77—5623 Sage Ct, Fresno, CA, 937440.60Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+4 more
ENR-140731ENRDenise Q Reid1966-07-03UHC-47159-4628736485575411 Church St, San Antonio, TX, 782360.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116657ENRKatherine D Black2003-06-08UHC-30092-48—4617 Grand Ave, Dallas, TX, 752540.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-126553ENRJoyce Q Wallace1979-09-26UHC-34860-6425127209632416 Cedar Ln, Houston, TX, 770080.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-142508ENRKelly U Davis1946-10-01UHC-02360-0785925710844206 Valley View Dr, Miami, FL, 331870.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-100098ENRValentina D Warren1959-11-17UHC-64240-8173753669019049 Maple Ave, Dallas, TX, 752250.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-112079ENRKyle Ross1970-08-03UHC-21941-2524490009186425 Baseline Rd, Fresno, CA, 937360.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-110470ENRJulia X Soto1986-12-17UHC-52203-0156966916719040 Mountain View Dr, Minneapolis, MN, 554860.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-107057ENRElijah Schultz1982-05-16UHC-61716-8158865197666187 Pine Dr, Tampa, FL, 336700.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-127665ENRDick Lucas1961-05-16UHC-76193-7794896321232788 Mesa Dr, Tampa, FL, 336510.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-130691ENRTeresa Simmons1949-01-11UHC-70791-2989491902922740 Mesa Dr, Columbus, OH, 432030.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101749ENRAngela I Hawkins1940-08-24UHC-86812-105688248155975 Lincoln Way, Minneapolis, MN, 554320.60Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-103665ENRBilly Nunez2006-01-11UHC-35702-0321499337354262 Washington St # 384, Eden Prairie, MN, 553850.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-122316ENRShirley Q Wang1946-08-25UHC-63251-2850072181099684 Ridge Rd, Mesa, AZ, 852440.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120946ENRMargaret R Lane1979-04-20UHC-85163-67—2784 Spring St, Plano, TX, 750150.60Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-118783ENRRay Q Lawrence1949-08-08UHC-59874-28—9838 Canyon Rd, Seattle, WA, 981090.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-112755ENRCarlos R Chaevz1943-08-28UHC-88199-2725068688342256 Sunset Blvd, Orlando, FL, 328510.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-115135ENRSteven N Harrison1963-10-16UHC-95603-45—5754 Church St, Chandler, AZ, 852370.60Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-105401ENRAnthhony M Perkins1961-05-03UHC-47503-4067772481811854 Ocean Ave, Glendale, AZ, 853390.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-114036ENREmily A Anderson1953-02-16UHC-77460-1950595453423066 Sage Ct, Mesa, AZ, 852490.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-142578ENRTimothy Stone1960-01-08UHC-53904-9772434744128244 Jefferson Ave, San Diego, CA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128731ENRSarah Wilson1957-02-01UHC-97990-0632527329201295 Pine Dr, Dallas, TX, 752570.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101059ENRAlice Knight—UHC-58125-2147082625316465 Pine Dr, Orlando, FL, 328590.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-141886ENRSean Q Watson1998-06-23UHC-89921-8793070443329192 Apache Blvd, Columbus, OH, 432180.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-106262ENRPamela U Rychardson1941-03-21UHC-65975-5276337919007954 Spring St, Las Vegas, NV, 891730.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108389ENRAmber X Bishop1982-11-04UHC-24337-5056970828601127 Meadow Ln, Fresno, CA, 937190.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-104808ENRBilly Weber1989-01-02UHC-14482-4456966397133418 Indian School Rd, Los Angeles, CA, 900860.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127647ENRDeborah Sandoval—UHC-24249-1751573427706170 Sage Ct, Seattle, WA, 981910.60Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-106367ENRBeverly N Sanchez—UHC-48016-6772435020872047 Washington St, Plano, TX, 750960.60Name re-casedDate of birth reformattedDate of birth unreadableMember ID reformatted+4 more
ENR-136396ENRJordan E Flores1944-07-12UHC-62790-3076250320407559 Hillcrest Rd, Minneapolis, MN, 554790.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-103413ENRNathan M McCoy1970-12-06UHC-35142-11826345542477 Sunset Blvd, Tampa, FL, 336860.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-128287ENRJoe F Lucas1988-09-18UHC-29310-4026335644648962 Main St, Tempe, AZ, 852590.60Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+4 more
ENR-124953ENREmma Mitchell1962-01-22UHC-83138-42—857 Cedar Ln, Jacksonville, FL, 322350.60Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-127262ENRRebecca D Henry1995-05-02UHC-09021-9496796708978916 Spring St, Los Angeles, CA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-106647ENRDiana O Hrrison1966-08-06UHC-09874-0340131855297744 Central Ave, Gilbert, AZ, 852640.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-107584ENRHeather T Weaver2004-10-18UHC-86273-1226838725641990 Highland Ave, Phoenix, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-111813ENRDebra Brooks1988-11-28UHC-12059-1288179425273518 Harbor Blvd, Charlotte, NC, 282940.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-126759ENRZachary Hicks1939-09-26UHC-79456-8538139708574637 Maple Ave, Chandler, AZ, 852050.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-130945ENRJonathan Castillo1970-02-18UHC-98958-7593428115658032 Camelback Rd, Fresno, CA, 937300.60Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-135708ENREric Coleman1984-11-17UHC-48581-7663151567906859 Maple Ave, Tampa, FL, 336050.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-123309ENRLawrence Dixn1944-10-03UHC-77814-3540386376072001 Grand Ave, Scottsdale, AZ, 852810.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
43,101 rows, page 117 of 863PreviousNext