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-108281ENRJudith Jacobs1941-10-18UHC-48697-9254937819615550 Lake View Rd, Gilbert, AZ, 852250.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-131472ENRPeter F Chavez1986-01-16UHC-11335-2033358786543309 Baseline Rd, Columbus, OH0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-109652ENRSantiago Elliott1989-06-01UHC-52585-76—5848 Elm St Apt 22, Orlando, FL, 328320.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-110609ENRJoyce C Andrews1954-12-28UHC-46410-6880026684151441 Park Pl, Tucson, AZ, 857970.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101169ENRRandy G Sanchez1958-11-11UHC-33973-6695573424871774 Willow Ct, Orlando, FL0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-125796ENRJanet N Mdeina1946-07-22UHC-79714-3441477602284997 Main St, Seattle, WA, 981040.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116201ENRAlice L Alvarez2007-10-06UHC-16932-0787042903981521 Harbor Blvd, Eden Prairie, MN, 553730.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-110943ENRAlex Gilbert1959-12-23UHC-21575-5683668448754963 Mesa Dr Apt 15, Las Vegas, NV, 891360.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-137552ENRStephen Gordon1988-03-22UHC-82600-0672442219385705 Meadow Ln, Seattle, WA, 981450.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-123420ENRVirginia Wagner1996-02-14UHC-84809-433396212520992 Cedar Ln, Tucson, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101429ENRGrace N Young1959-12-03UHC-64513-4137397652233752 Mesa Dr, Tempe, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-131054ENRJorddan Rice1965-09-13UHC-17038-9489268281078671 Forest Ave, Sacramento, CA, 958660.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-135869ENRKeith Wheeler1952-02-22UHC-48227-16—1930 Park Pl, Scottsdale, AZ, 852890.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-134964ENRMason A Reid1994-02-25UHC-94678-8283288058414264 Palm Dr # 906, Seattle, WA, 981650.60Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
ENR-117526ENRBrandon X Rojas1940-05-16UHC-05735-9733531940715141 Union St, Seattle, WA, 981270.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-100459ENRBen K Flores1965-12-08UHC-64309-293015918723735 Central Ave, Gilbert, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-121647ENROlivia Maldonado1959-04-02UHC-73748-4787166597683376 Washington St, Gilbert, AZ, 852850.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-133194ENRLinda H Willis1997-05-06UHC-42566-3480946455044422 Union St, Denver, CO, 802600.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-117447ENRSteven Carter1959-02-25UHC-12003-5478324958724229 Apache Blvd # 743, Columbus, OH, 432110.60Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-110634ENRMary Hunter1948-03-07UHC-79113-0475725565149548 Palm Dr, Plano, TX, 750010.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-111516ENRKathy X Harris1996-05-02UHC-29359-2953325266897651 Ocean Ave, Charlotte, NC0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-137237ENRVictoria T Evans1962-08-16UHC-91282-0945745297045865 Palm Dr, Tempe, AZ, 852300.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118547ENREthan E Mills1938-07-25UHC-93643-9642457385966811 Park Pl, Plano, TX, 750810.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-103621ENRBrandon Y Obrrien1985-10-23UHC-52239-7683198276052492 Forest Ave, Las Vegas, NV, 891310.60Name split from “Last, First”Name re-casedDate of birth reformattedPhone reformatted+4 more
ENR-112448ENRJerry Anderson2006-12-25UHC-02296-6675570093465218 Lake View Rd, San Antonio, TX, 782270.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-128675ENRBrittany P Fuller1939-10-04UHC-65472-1471650065238574 Market St, San Antonio, TX, 782460.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-132753ENRJennifer Sanchez1947-03-13UHC-17356-5971768150413948 Canyon Rd, Mesa, AZ, 852540.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-107160ENREmma S Lopez1940-08-10UHC-18654-2723640209179378 Union St, Nashville, TN0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138090ENRJoe B Welch2003-03-10UHC-01942-3644734010888568 Ocean Ave, Phoenix, AZ, 850710.60Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
ENR-104064ENRStevens Amber1992-09-18UHC-79182-1276562640373816 Mesa Dr, Charlotte, NC, 282330.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-113265ENRCheryl Y Carroll1967-02-19UHC-80042-9860047804116440 Union St, San Antonio, TX, 782130.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-105039ENRWayne M Lawrence1938-02-18UHC-40777-2649177980036921 Sage Ct, Jacksonville, FL, 322000.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127610ENRShirley F Graham2005-11-13UHC-24244-7542153227009296 Maple Ave, Sacramento, CA, 958510.60Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
ENR-107752ENRNicole Perry1988-11-01UHC-68070-7447571058792531 Sunset Blvd, Glendale, AZ, 853050.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-142416ENRJerry Y Watson1983-04-17UHC-82208-7368338210247251 Grand Ave, Sacramento, CA, 958400.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-119958ENRAmber R Burke1994-03-09UHC-16041-55—8073 Sunset Blvd, Austin, TX, 787580.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133517ENRPeter G Fox2000-02-11UHC-43855-3237894760215462 Forest Ave, Houston, TX, 770830.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-102300ENRJoan O Larson1998-08-21UHC-90608-232823842901605 Oak St, Tampa, FL, 336660.60Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-135270ENRMelissa N Bennett1966-01-21UHC-74500-76—9773 Indian School Rd, Los Angeles, CA0.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-111896ENRKathleen V Clark1999-06-28UHC-53597-0866425139127249 Spring St, Las Vegas, NV0.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-106189ENRAmy Fuller1982-08-24UHC-70500-6274927607626125 Pine Dr, Tucson, AZ, 857460.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116384ENRKevin P Lewis1972-06-28UHC-47662-482736147265772 Willow Ct, Los Angeles, CA, 900650.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-139648ENRJonathan Y Singh1983-09-11UHC-90837-1153581529188741 Baseline Rd, Charlotte, NC, 282590.60Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-123377ENRSteve M Guerrero1966-09-27UHC-23579-5565628493001690 Union St # 111, San Diego, CA, 921920.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-138462ENRCarolyn R Ortega1998-06-15UHC-89704-7324958262228513 Sage Ct, Charlotte, NC, 282180.60Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-112331ENRDouglas G Cooper1977-09-17UHC-28409-1984477694617523 Oak St, Nashville, TN0.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131277ENRRyan E Myerrs1952-06-28UHC-22890-6852251742933563 River Rd # 355, Plano, TX, 750310.60Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more
ENR-115738ENRElijah M Ortega1950-01-09UHC-94724-9547659249864503 Oak St, Phoenix, AZ, 850450.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-103212ENRStephen Perkins1944-11-02UHC-79590-6721482628996701 Valley View Dr, San Antonio, TX, 782410.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-116836ENRRobert B Dixon2000-10-05UHC-69644-6357458044477749 Meadow Ln, Denver, CO, 802340.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
43,101 rows, page 130 of 863PreviousNext