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-128104ENRBruce Jensen1965-06-05UHC-93320-87—1824 Park Pl, Scottsdale, AZ, 852430.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-102472ENRPamela Ruiz—UHC-56632-9889470616182604 Baseline Rd, Gilbert, AZ, 852560.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-426518CLMClark Peetr1938-10-16——3744 Sunset Blvd, Eden Prairie, MN, 553750.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-53408TPARonald Harrison2004-05-22UHC-33242-35—8077 Maple Ave, Denver, CO, 802670.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29285PRVLogan W Clark1996-08-06UHC-45189-8834156870633642 Meadow Ln, Las Vegas, NV0.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
PRV-29284PRVLogan W Clark1996-08-06UHC-45189-8834156870633642 Meadow Ln, Las Vegas, NV0.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
ENR-113031ENRElijah Hanson2003-03-04UHC-11708-392764045252119 Indian School Rd Apt 8, Jacksonville, FL, 322000.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136027ENRJessica Snyder1947-04-25UHC-52061-5020459912787810 Ocean Ave, Glendale, AZ, 853570.50Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+3 more
PRV-28728PRVAlexis Singh2007-12-05—89959326296744 Desert Sky Blvd, Las Vegas, NV, 891520.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-419359CLMSamantha Burns1993-07-27—49367076219661 Main St, Nashville, TN, 372480.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119701ENRAnthony Ross1940-11-24UHC-19608-1944888916209648 Highland Ave # 746, Las Vegas, NV, 891420.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
CLM-404862CLMAhmed Vazquez1955-08-09UHC-66130-9391425412726035 Oak St, Fresno, CA, 937230.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422411CLMJoseph Carter—UHC-97279-2925373839193938 Desert Sky Blvd, Chandler, AZ, 852310.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-142417ENRAnn L Reid1952-10-15UHC-19399-4432734292975406 Jefferson Ave, Tucson, AZ, 857480.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-112254ENRDennis J Medina1967-07-25UHC-69245-1433880396397642 Mesa Dr # 472, Jacksonville, FL, 322380.50Middle initial moved out of first nameName re-casedDate of birth reformattedUnit split from street+3 more
ENR-100464ENRRalph B Little1941-02-04UHC-15915-5484878061623843 Elm St, Tucson, AZ0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-104405ENRMei U Guzman1948-06-07UHC-54129-7748475781755967 Grand Ave, Mesa, AZ, 852060.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-50669TPADonna Myers1972-10-07——6906 Desert Sky Blvd, Houston, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-50273TPAJacqueline Lawwrence2007-06-11—52480023028326 Desert Sky Blvd, Eden Prairie, MN, 553000.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53687TPADoris George1947-01-18——9649 Canyon Rd, Plano, TX, 750960.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108697ENRGerrald Banks2008-05-13UHC-39464-7421888079538023 Oak St, Chandler, AZ0.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-432250CLMCatherine Romero1952-02-09——9615 Camelback Rd, Tempe, AZ, 852630.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-22113PRVChristine Marshall1978-11-02—53078156233165 Elm St, Houston, TX, 770950.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-26959PRVLarry Cox1983-06-01—95537066584973 Grand Ave # 668, Tampa, FL0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-27092PRVRalph Espinoza1938-09-14UHC-65631-51—2235 Highland Ave Apt 26, Tempe, AZ, 852110.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-426346CLMCarolyn Wilson1964-04-24UHC-81583-7547568962872570 Valley View Dr Apt 30, Jacksonville, FL, 322430.50SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-102242ENRMichael Clark2006-12-17UHC-54207-0764954722154197 Washington St # 167, Nashville, TN, 372620.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-133091ENRPatrick S Parker1986-09-01UHC-14708-32—5982 Bayshore Dr, Tempe, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
CLM-418967CLMCharles Sullivan1963-10-07——3599 Maple Ave, Orlando, FL, 328580.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-410406CLMMei Rose1951-02-06UHC-33521-18—6585 Forest Ave, Atlanta, GA, 303140.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405859CLMSara King1996-12-15UHC-68504-05—4661 Central Ave, Tucson, AZ, 857060.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-104667ENRBradley H Wallace1970-04-28UHC-69793-4174498222142777 Market St, Minneapolis, MN, 554190.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116978ENRAndrea Cole2007-01-25UHC-40033-8281653478537899 Lake View Rd # 510, San Diego, CA, 921720.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-423537CLMMegan Jimenez1951-04-18UHC-30141-5290794920537961 Maple Ave, Minneapolis, MN0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409286CLMKyle Webb1991-06-22UHC-73310-75—3288 Lake View Rd, Mesa, AZ, 852700.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-105192ENRJennifer B Schmidt—UHC-32919-7353570910431207 Washington St, Atlanta, GA, 303600.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-421478CLMAhmed Cunningham1967-12-02UHC-90142-4158132237739547 Baseline Rd, Dallas, TX, 752380.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-105546ENRFrank X Contreras1959-06-18UHC-79195-3062850320065259 Spring St, Mesa, AZ, 852740.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131092ENRWayne V Thomas2006-10-19UHC-05470-0192531660145517 Harbor Blvd, Tampa, FL, 336640.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-136358ENRElizabeth D Watson1978-02-03UHC-04911-9961975493386379 Washington St, Tampa, FL0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50638TPAKayla Sims1987-05-14—32762880517655 Washington St, Atlanta, GA, 303710.50Name re-casedPhone reformattedSSN last four extractedZIP+4 trimmed+3 more
CLM-429988CLMRaymond Wood1988-01-25UHC-06749-57—2432 Camelback Rd # 413, Miami, FL, 331430.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406571CLMJean Ward1942-05-13—79024415022434 River Rd # 772, San Diego, CA, 921460.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-127926ENRChris U Ferguson2003-09-16UHC-41567-677735311242541 Sage Ct, Fresno, CA, 937280.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426032CLMDanielle Palmre2001-07-22UHC-01567-87—9568 Maple Ave, San Diego, CA, 921620.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130310ENRBrittany Tucker1999-05-07UHC-67588-0571434587236765 Central Ave, Los Angeles, CA, 900780.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139110ENRScott Martin2006-07-10UHC-42759-8172474117923618 Cedar Ln, Dallas, TX, 752140.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-410432CLMCatherine Bennett1945-01-20——9312 Indian School Rd, Orlando, FL0.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-431778CLMAshley Carter1951-02-25——970 Mesa Dr Apt 36, Dallas, TX, 752600.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
PRV-22920PRVBilly F Mendez1978-12-26——3385 Desert Sky Blvd, Chandler, AZ0.50Name re-casedDate of birth reformattedPhone missing area codeState name converted to code+3 more
100,000 rows, page 107 of 2,000PreviousNext