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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-103208ENRBrandon N Jenkins1994-08-01UHC-34796-8165593482791660 Palm Dr, Scottsdale, AZ, 852090.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-108656ENRJose O Roberts1942-07-12UHC-90725-1692535122211301 Elm St # 711, Jacksonville, FL0.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-127592ENRMaggie Dean2000-06-07UHC-39451-7951496111062873 Maple Ave Apt 39, Tampa, FL, 336740.50Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more
PRV-23482PRVBilly Lawson1989-05-13—32079843062366 Oak St, Columbus, OH0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-117163ENRCatherine L Peters1960-04-22UHC-57239-936722681200387 Park Pl, Tucson, AZ, 857760.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431123CLMJacob Allen1999-06-02—67721576416532 Ridge Rd, Tampa, FL, 336260.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-404992CLMAndrew Wooods2001-06-02UHC-24692-84—4197 Union St Apt 15, Eden Prairie, MN, 553360.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-116194ENRSalazar Logan2007-03-09UHC-81920-7585445009314954 Union St, Charlotte, NC, 282660.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54757TPALaura W Powell1969-05-21—76877045133187 Harbor Blvd, Eden Prairie, MN, 553560.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430941CLMMichelle Bowman1971-10-24UHC-64949-34—7317 Oak St, Tampa, FL0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-427691CLMPriya Howell1942-08-10UHC-99815-1961668651955682 River Rd # 860, San Antonio, TX, 782880.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-53441TPAJordan Ferguson1969-08-05—97467056485600 Palm Dr, Eden Prairie, MN, 553360.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-142081ENRWayne Li1960-01-10UHC-00692-9461846141687279 Mountain View Dr, Jacksonville, FL, 322650.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-124382ENRAhmed P Silva1965-07-09UHC-49438-0525179856389183 Elm St # 922, Scottsdale, AZ, 852990.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-103274ENRDon Alvarado1955-01-02UHC-30276-2060675774308594 Central Ave, Austin, TX, 787690.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115209ENRGary King1974-08-05UHC-19513-9045346718576406 Camelback Rd Apt 27, Columbus, OH, 432110.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-414695CLMJohn Sims1979-06-09UHC-98485-4298723946087970 Main St, San Diego, CA, 921380.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403918CLMWayne Marshall—UHC-10389-4233991881216503 Highland Ave, Los Angeles, CA, 900220.50Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-20002PRVLaura Alvarado1939-03-06—20820463444347 Church St, Plano, TX, 750860.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-117432ENRJonathan I Pierce—UHC-45594-5627471589964558 Ocean Ave, Chandler, AZ, 852370.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-125041ENRHannah I Hoffman1968-04-15UHC-34504-2128145441164655 Oak St, Atlanta, GA0.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-407692CLMArthur Espinoza2003-07-16—45335708469292 Indian School Rd # 446, Tampa, FL, 336900.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-63460TPASarah Sanchez1943-03-13—58332417037645 Sage Ct Apt 27, Fresno, CA0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-401992CLMElizabeth Hamilton1950-12-01UHC-48977-8678547423644500 Maple Ave, Seattle, WA, 981960.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-122812ENRRoger V Howard1945-02-23UHC-89900-2588350599443622 Sage Ct, Austin, TX, 787700.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
TPA-61541TPARaymond Hicks2007-09-22—84378696787323 Baseline Rd Apt 5, Orlando, FL, 328250.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-120476ENRJerry Dunn1939-06-05UHC-68186-754936428640658 Washington St, Columbus, OH, 432950.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136493ENRArthur N Santos1994-07-02UHC-64643-1870434283009820 Market St, Fresno, CA, 937760.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
CLM-417950CLMWeber Laura1944-09-22UHC-07611-10—5370 Sage Ct, Sacramento, CA, 958420.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126388ENRElizabeth O Graham1997-12-27UHC-13821-547038848580342 River Rd, Plano, TX, 750350.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-100538ENRDavid T Padilla1952-11-13UHC-51025-4752890819985065 Hillcrest Rd, Tampa, FL, 336330.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
TPA-53298TPAKelly Nunez——69342794392972 Washington St, Phoenix, AZ, 850250.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-418726CLMCatherine Smith1969-04-03UHC-24248-3333090310796032 Market St, Dallas, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-418727CLMCatherine Smith1969-04-03UHC-24248-3333090310796032 Market St, Dallas, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-128625ENRLauren N Garza1939-08-06UHC-35044-2848456046017624 Church St, Phoenix, AZ, 850360.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122548ENRLawrence U Grant1966-01-19UHC-64977-8930080605463509 Sunset Blvd, Tempe, AZ, 852690.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-23342PRVDoris McCoy1984-08-26—66447601057393 River Rd, Gilbert, AZ0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133408ENRLogan M Reed1959-07-22UHC-34426-6424227578978131 Highland Ave, Sacramento, CA, 958240.50Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-411061CLMPriya P Rivera1991-01-18UHC-73259-4163167684227262 Ocean Ave, Orlando, FL, 328800.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-21435PRVRobert Crawford2006-02-15UHC-52692-5759893242854891 Meadow Ln, Sacramento, CA, 958370.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-116397ENRCynthia X Dunn1973-06-23UHC-08495-0274124171915109 River Rd, Nashville, TN0.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27810PRVTeresa Elliott1939-11-27UHC-87593-18—621 Grand Ave, Gilbert, AZ, 852590.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-114352ENRBoyd N Carl1942-12-18UHC-08601-3636422286708407 Washington St, Mesa, AZ, 852690.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101844ENRSophia W Pierce1973-09-23UHC-04501-4247666937776744 Desert Sky Blvd, Glendale, AZ, 853820.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-420529CLMDiego Jimenez2005-03-07UHC-89670-4090747188856107 Palm Dr, Houston, TX, 770970.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-410145CLMThereza M Diaz1940-08-20UHC-13273-59—1367 Highland Ave # 759, Nashville, TN, 372150.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408630CLMTheresa Munoz1941-06-25UHC-11208-80—5154 Harbor Blvd, Tampa, FL, 336710.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-133452ENRDouglas L Arnold1991-03-01UHC-22169-6091872583614155 Lincoln Way, Tampa, FL, 336200.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423064CLMHannah R Santos1999-07-04UHC-76256-4162939632196379 Camelback Rd, Eden Prairie, MN, 553820.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429822CLMEthan Munoz1976-07-13UHC-06062-99—866 Harbor Blvd Apt 28, Tucson, AZ, 857430.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 96 of 2,000PreviousNext