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
CLM-412631CLMNancy Richardson2005-07-04UHC-90846-4878732415378986 Willow Ct, Houston, TX, 770060.36Street suffix standardisedAddress re-casedCity re-casedState name converted to code+4 more
PRV-21012PRVFrank Thompson1992-04-06—44693091827457 Spring St # 719, Tucson, AZ, 857100.36Phone reformattedUnit split from streetCity re-casedState name converted to code+4 more
ENR-134183ENRMateo M Burke2007-08-20UHC-43196-6145331865717355 Sunset Blvd, Los Angeles, CA, 900860.36Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-117687ENRJeremy X Armstrong1989-04-21UHC-07659-0471880705149463 Harbor Blvd, Plano, TX, 750510.36Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-420006CLMAngela Sims2005-08-22UHC-18156-019717849078429 Main St, Minneapolis, MN, 554540.36Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-141758ENRTyler D Garza1981-11-03UHC-04182-5161536947464587 Maple Ave, San Antonio, TX, 782070.36Middle initial moved out of first nameName re-casedTwo-digit birth yearStreet suffix standardised+4 more
ENR-136984ENRAngela Sanchez1942-02-16UHC-98746-7128637830896275 Oak St, Las Vegas, NV0.36Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129993ENREthan Rice1949-09-05UHC-54339-21—3615 Maple Ave, Mesa, AZ, 852310.36Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more
ENR-126136ENRElizabeth V Specner1989-01-14UHC-10467-3231752397326879 Willow Ct, Los Angeles, CA, 900620.36Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
TPA-63759TPAPaul Castillo1988-01-11—73549335325161 Mountain View Dr, Tucson, AZ, 857940.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107022ENRHansen M Brandon1979-03-20UHC-59196-0979594805574589 Mesa Dr Apt 31, Chandler, AZ0.36Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-23147PRVDennis Watkins—UHC-79949-2468563941997949 Jefferson Ave, San Diego, CA, 921970.36Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
TPA-50402TPAAaron Payne———9763 Indian School Rd, Glendale, AZ, 853750.36Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+4 more
PRV-23856PRVWayne T Pierce2007-03-17UHC-88124-9127750764468049 Highland Ave, Dallas, TX0.36Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-111651ENRSandra Q Chapman1995-06-04UHC-73111-9579561974012754 Meadow Ln, San Antonio, TX0.36Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24529PRVGeorge Hall2008-02-17——6086 Maple Ave, Dallas, TX, 752690.36Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+4 more
ENR-137928ENRGloria Espinoza1977-04-17UHC-19393-6743453532582480 Canyon Rd, Denver, CO, 802370.36Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
TPA-55172TPATyler Welch1965-03-01UHC-94529-6733542030892593 Spring St Apt 26, Gilbert, AZ, 852560.36Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-127828ENRRalph Y Wang1952-06-03UHC-12292-2883790414496583 Camelback Rd, Dallas, TX0.36Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21850PRVSusan Cruz1999-02-13UHC-91616-2986196542079775 Cedar Ln, Atlanta, GA, 303380.36Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-118151ENRTeresa S Adams2005-02-23UHC-94349-3951781297382357 Camelback Rd, Charlotte, NC, 282110.36Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
TPA-57634TPARuth Padilla1941-05-02——6925 Willow Ct Apt 14, Minneapolis, MN, 554890.36Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
ENR-129069ENRIsabella F Gomez1998-10-10UHC-64666-87—6632 Union St # 321, Jacksonville, FL, 322120.36Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-129070ENRIsabella F Gomez1998-10-10UHC-64666-87—6632 Union St # 321, Jacksonville, FL, 322120.36Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-113575ENRHelen E Phillips1969-10-04UHC-55904-1157471490731268 Church St # 703, Scottsdale, AZ0.36Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-116609ENRJanet J Young1976-05-24UHC-69097-8124257051943328 Oak St, Nashville, TN, 372800.36Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-129121ENRScott Kelly1956-05-11UHC-59219-4080984130565241 Pine Dr, Columbus, OH, 432870.36Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-417023CLMJeremy Singh1972-01-20UHC-23990-52—5535 Bayshore Dr, Atlanta, GA, 303870.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423180CLMKaren Campbell1942-01-28——4437 River Rd, Columbus, OH, 432640.36Date of birth reformattedPhone missing area codeSSN last four extractedStreet suffix standardised+4 more
ENR-120525ENRDennys J Dominguez1966-12-28UHC-79255-8977029387757029 Union St, San Diego, CA, 921710.36Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-125495ENRCarlos Howard1959-05-04UHC-62694-5497970378083073 Sage Ct, Fresno, CA0.36Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-426103CLMDiana V Walker1939-03-20UHC-90580-2726141525432920 Park Pl, Dallas, TX, 752360.36Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115615ENRIsabella Ramos1944-04-02UHC-87503-4490669012066189 Lake View Rd, Phoenix, AZ, 850840.36Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-134778ENRKevin Freeman—UHC-75530-98—7508 Oak St, Mesa, AZ, 852470.36Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
ENR-120057ENRJohnston Randy1978-02-22UHC-32459-3494224333865415 Pine Dr, Tempe, AZ, 852970.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133904ENRJulie Moore2003-01-20UHC-75274-2120672416564949 Sage Ct, Houston, TX, 770720.36Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-20823PRVBradley Hayes1943-07-10——8430 Forest Ave, Las Vegas, NV0.36Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-430053CLMJacqueline McCoy2007-09-05——3375 Willow Ct, Columbus, OH, 432460.36Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
ENR-121941ENRTherresa Mills1992-12-12UHC-05427-3348342119011162 Elm St # 189, Sacramento, CA0.36Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-138394ENRKaren A Lane1975-08-15UHC-33643-0169673699366015 Camelback Rd # 932, Eden Prairie, MN, 553780.36Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-106315ENRPatrick N Spencer2007-05-02UHC-96131-84—1958 Park Pl # 338, Nashville, TN, 372970.36Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
ENR-119386ENRAlbert Marquez2003-09-12UHC-18573-78—9035 Pine Dr # 233, Fresno, CA, 937650.36Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
ENR-133871ENRBetty E Morris1960-12-10UHC-99383-58—3269 Grand Ave, Eden Prairie, MN, 553420.36Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-135300ENRCamila E Rodriguez1945-09-18UHC-63430-90—4784 Baseline Rd, Phoenix, AZ0.36Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
CLM-411189CLMDot T Richardson1948-07-07——9509 Indian School Rd Apt 35, Charlotte, NC, 282780.36Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-103351ENRChristopher Y Perry1981-12-03UHC-95693-0744380764992218 Apache Blvd, Nashville, TN, 372330.36Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
ENR-114681ENRKevin L Soot1955-12-09UHC-69990-7841525977203195 Meadow Ln, San Antonio, TX, 782610.36Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-138629ENRTimothy V Jacobs1971-04-01UHC-40832-185884176875507 Bayshore Dr, Sacramento, CA, 958940.36Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
ENR-125950ENRHayes Bradley1967-08-21UHC-37877-1397997496407711 Mountain View Dr # 907, Orlando, FL, 328450.36Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-409048CLMRalph Simpson1938-03-20UHC-13940-20—4591 Park Pl, Phoenix, AZ, 850870.36Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 19 of 2,000PreviousNext