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-123306ENRSophia B Martinez1950-04-27UHC-22861-85—9261 Lake View Rd # 553, Mesa, AZ, 852580.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-108540ENRJordan V Garcia1983-04-26UHC-92335-5159899092978139 Harbor Blvd, Chandler, AZ, 852670.38Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20686PRVSean K Jenkins1946-04-18——2326 Desert Sky Blvd, Chandler, AZ0.38Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-127902ENRElizabeth L Santiago1974-02-24UHC-79914-4446341656651713 Ridge Rd Apt 35, Mesa, AZ, 852740.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54255TPAChristian Weber2008-09-04——9393 Cedar Ln # 333, Plano, TX0.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-138365ENRGeorge Q Howell1984-03-09UHC-38278-4826189748289286 Baseline Rd, Mesa, AZ, 852070.38Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-126730ENRIsabella Garza1975-04-25UHC-80809-16—1755 Mesa Dr, San Antonio, TX0.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-142863ENRRobert T Ray1986-11-19UHC-38009-7570185010119442 Pine Dr # 634, Seattle, WA, 981280.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410113CLMGerald Chavez—UHC-99698-9142682732566886 Central Ave, Seattle, WA, 981860.38Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-26434PRVCarl F Santos——3092747997967 Valley View Dr, Tempe, AZ, 852270.38Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-23288PRVEugene Welch1972-12-05UHC-25678-6041595879296531 Jefferson Ave, Scottsdale, AZ, 852910.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-56748TPAPamela Wilson1942-07-21UHC-01249-689678349119175 Camelback Rd, San Antonio, TX0.38Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+3 more
ENR-108987ENRRoy J Dunn2005-06-22UHC-64037-8146878033684764 Ocean Ave, Glendale, AZ0.38Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-432411CLMEdward Michell2000-06-12UHC-60479-18—6374 Park Pl, Mesa, AZ, 852190.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408131CLMIsabella Stephens—UHC-87565-33—7416 Lincoln Way, Gilbert, AZ, 852960.38Date of birth unreadableMember ID reformattedState name converted to codeZIP+4 trimmed+3 more
CLM-419389CLMShirley Gutierrez———2473 Willow Ct, San Antonio, TX, 782760.38Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432434CLMAlexis Z Gonzalez1939-04-25UHC-47144-9223184952366187 Jefferson Ave, Chandler, AZ0.38Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-116330ENRJudy K Jimenez—UHC-73726-1537399748862760 Mesa Dr, Gilbert, AZ, 852970.38Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55834TPAWillie Hicks1962-04-17UHC-95705-04—5869 Lincoln Way, Los Angeles, CA, 900310.38Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+3 more
CLM-430891CLMChris K Yang1961-08-27——6043 Church St, Chandler, AZ, 852890.38Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-411819CLMChristina Mendoza1999-08-17UHC-20663-15—4058 Washington St, Tempe, AZ, 852590.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103027ENRSofia Chapman1999-03-14UHC-10483-0746048580907739 Spring St Apt 30, Sacramento, CA, 958030.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-110536ENREvelyn Griffin—UHC-10238-5290179963495030 Market St Apt 32, Columbus, OH, 432690.38Name split from “Last, First”Date of birth unreadablePhone reformattedMember ID reformatted+3 more
ENR-101689ENRKelly K James1949-07-15UHC-76653-0348991691121768 Maple Ave # 797, Eden Prairie, MN0.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-27706PRVRichard Espinoza1957-05-16——2683 Mesa Dr, Seattle, WA, 981610.38Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-121000ENRDaniel K Ramirez1992-09-15UHC-57427-666727715403815 Sunset Blvd Apt 19, Miami, FL, 331280.38Middle initial moved out of first nameDate of birth reformattedPhone reformattedSSN last four extracted+3 more
TPA-57994TPAVictoria I Peterson2004-03-17——3004 Valley View Dr, Dallas, TX, 752290.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126348ENRDebra Coleman1972-03-28UHC-55489-2554528178956947 Ocean Ave, Tempe, AZ0.38Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423084CLMAna Knight1992-08-10UHC-00835-26—4791 Harbor Blvd, Glendale, AZ0.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-114047ENRDavid W Bruoks1969-07-04UHC-65781-992547589030974 Cedar Ln, Gilbert, AZ, 852020.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-116426ENRJessica Le2001-02-20UHC-95382-2739671320552209 Hillcrest Rd # 758, Glendale, AZ0.38Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-412305CLMSharon Davis——53942510765576 Highland Ave, Fresno, CA0.38Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-101503ENRHenry V Mills1966-08-19UHC-95628-4448978361995038 Hillcrest Rd Apt 11, Mesa, AZ, 852610.38Middle initial moved out of first nameTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-105930ENRNathan W Clark1967-04-01UHC-59130-67—9074 Hillcrest Rd, Denver, CO, 802020.38Middle initial moved out of first nameDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-128781ENRKatherine Garrett1995-02-20UHC-28181-3132545854376193 Pine Dr, San Antonio, TX, 782590.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106238ENRDan Butler—UHC-11269-2047379567655515 Maple Ave, Las Vegas, NV0.38Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-117763ENRKelly Kelly1943-06-14UHC-69020-5777343481128272 Oak St, Seattle, WA0.38Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-422061CLMGeorge R Mason———4247 Desert Sky Blvd, Charlotte, NC0.38Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-28987PRVAhmed Freeman1940-09-12——1848 Pine Dr Apt 28, Las Vegas, NV, 891800.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-24507PRVKathryn Contreras1952-04-19UHC-21639-91—6059 Ridge Rd, Columbus, OH, 432520.38Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-120218ENRPamela O Phillips1968-06-17UHC-46853-3968895599986594 Maple Ave, Columbus, OH, 432620.38Name split from “Last, First”Two-digit birth yearPhone reformattedSSN last four extracted+3 more
ENR-105123ENRSofia H Oliver1982-08-21UHC-82300-20—3300 Meadow Ln Apt 23, Las Vegas, NV, 891490.38Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
CLM-409125CLMJennifer Bradley1986-09-17UHC-27870-3248684099638203 Park Pl, Houston, TX0.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-131188ENRJerry Moore1945-05-22UHC-78611-442328302156200 Hillcrest Rd, Mesa, AZ0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63461TPASantiago Hansen———8566 Central Ave, San Antonio, TX, 782960.38Name re-casedDate of birth missingState name converted to codeZIP+4 trimmed+3 more
ENR-134469ENRIsabella P Le1964-04-04UHC-19469-80—670 Mountain View Dr, Tampa, FL, 336060.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-413411CLMVincent Thompson2006-03-08UHC-83627-9338455797283650 Sage Ct, Charlotte, NC, 282710.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111892ENRAnna J Allen1977-07-07UHC-01802-26—4429 Mesa Dr Apt 26, Tempe, AZ, 852890.38Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-131746ENRMei King1976-07-28UHC-86475-6168074464146872 Washington St, Tucson, AZ, 857260.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62742TPAGrace Rios1940-12-04UHC-55558-64—2070 Ridge Rd, Seattle, WA0.38Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 27 of 2,000PreviousNext