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-117056ENRSen Holmes2003-08-13UHC-34874-0930738459417645 Apache Blvd, Dallas, TX, 752100.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21341PRVJesse F Fowler1998-12-11UHC-13704-8751346058294715 Sage Ct # 627, Miami, FL0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-405812CLMTerry James1977-02-05UHC-30688-05—851 Grand Ave, Denver, CO0.52Two-digit birth yearZIP missingGender normalisedPlan code upper-cased+2 more
CLM-429033CLMIsabella McDonald1965-02-03UHC-42587-12—4192 Willow Ct, Orlando, FL, 328160.52Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-413545CLMKelly Kelly1943-06-14——8272 Oak St Apt 15, Seattle, WA, 981580.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400056CLMSamantha Young1990-04-28—36074517385157 Harbor Blvd, San Antonio, TX, 782310.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140940ENRMaria Graham1961-02-20UHC-40957-36780603888728 Mountain View Dr # 653, Mesa, AZ, 852610.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-55327TPAHirohsi Hanson1939-12-11——6791 Baseline Rd, Minneapolis, MN, 554250.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-411481CLMSarah W Olson2000-06-19UHC-48451-84—5496 River Rd, Seattle, WA0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-21142PRVValentina Saalazar1971-07-20UHC-13048-6875582639697124 Desert Sky Blvd, Charlotte, NC, 282650.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-419985CLMMegan G Richards2007-12-04——5739 Oak St, Tempe, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
PRV-24298PRVJacob Watkins1948-01-23—98252317421221 Church St, Fresno, CA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-425953CLMKathleen A Gonzalez1977-04-13UHC-75427-62—5316 Spring St, Charlotte, NC, 282910.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-120370ENRMark Hunter1941-09-01UHC-16438-98—1443 Elm St, San Diego, CA, 921700.52Phone missing area codeSSN last four extractedCity re-casedGender normalised+2 more
TPA-56677TPAPaul Garza1980-09-17——9746 Forest Ave, Austin, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-100772ENRStephanie Campbell1960-03-15UHC-45143-3839978867908660 Central Ave, Atlanta, GA, 303680.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
PRV-27378PRVMary Simpson1957-08-17——9133 River Rd, Jacksonville, FL, 322210.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401863CLMEmily Warren1996-07-11UHC-27010-24—2811 Central Ave, Austin, TX0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-140264ENRBetty T Griffin1956-02-08UHC-23779-7539182744614989 Central Ave, Las Vegas, NV0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-122642ENRRobert K Sandoval1983-10-28UHC-65139-8329174411601782 Mountain View Dr, Fresno, CA, 937760.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402762CLMKathleen Medina1942-08-15UHC-06034-54—1063 Desert Sky Blvd, Glendale, AZ, 853490.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-122328ENRVictoria U Padilla1959-10-24UHC-11852-4572157318613519 Willow Ct, Seattle, WA, 981350.52Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+2 more
TPA-61520TPASamantha Wang1995-09-10——570 Ridge Rd, Charlotte, NC, 282020.52Name split from “Last, First”Date of birth reformattedState name converted to codeGender normalised+2 more
PRV-22171PRVDorothy Medina1967-10-19UHC-55197-73—1837 Pine Dr, Houston, TX, 770410.52Name re-casedPhone missing area codeState name converted to codeZIP+4 trimmed+2 more
ENR-122378ENRJuan George1969-10-12UHC-51548-976812589562416 Hillcrest Rd, Austin, TX, 787900.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21889PRVKennth Roberts1976-01-07——2936 Hillcrest Rd, Chandler, AZ, 852680.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-417803CLMCheryl Butler1972-02-27——7407 Ocean Ave, Atlanta, GA, 303200.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-125892ENREdward S Bradley1966-09-03UHC-46461-6427093487935113 Main St, San Antonio, TX, 782430.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-115636ENRTheresa W Cruz1962-06-06UHC-36360-26—8152 Camelback Rd # 212, Jacksonville, FL, 322800.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-139492ENRSamuel Castro1979-01-22UHC-38821-1937347182089315 Mountain View Dr, Tempe, AZ, 852410.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422560CLMLarry Foster1965-06-28——4669 Sunset Blvd, Tucson, AZ, 857330.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-423652CLMDavid A Long1966-04-07UHC-02750-47—5155 Maple Ave, Chandler, AZ, 852400.52Middle initial moved out of first nameTwo-digit birth yearZIP+4 trimmedEmail lower-cased+2 more
ENR-129306ENRAron E Vazquez1969-01-16UHC-12265-6239167808843443 River Rd, Sacramento, CA, 958030.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-129393ENRJudy A Carroll2006-05-24UHC-24401-9890482926202492 Mountain View Dr, San Diego, CA, 921570.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-129392ENRJudy A Carroll2006-05-24UHC-24401-9890482926202492 Mountain View Dr, San Diego, CA, 921570.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-130188ENRBeverly X Valdez1989-10-24UHC-20571-9620170337549115 Canyon Rd, Charlotte, NC, 282270.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432503CLMEvelyn Wright1986-04-13UHC-14032-27—7919 Harbor Blvd, Jacksonville, FL, 322360.52Two-digit birth yearPhone missing area codeCity re-casedState name converted to code+2 more
CLM-416531CLMFrances Black1973-01-08—76536437138621 Camelback Rd, Plano, TX, 750280.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-412822CLMBrandon Payne1981-10-08——3345 Apache Blvd, Seattle, WA, 981080.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400538CLMMatt Lawson1995-05-15UHC-09130-1261870710934892 Pine Dr # 147, Mesa, AZ, 852480.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-401834CLMVirginia Vazquez1995-03-27UHC-31745-21—1472 Willow Ct, Eden Prairie, MN0.52Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
PRV-25228PRVAdam I Lttle1943-08-22—55154240281689 Mountain View Dr, Nashville, TN, 372010.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405413CLMHannah Garrett—UHC-32176-42—478 Sunset Blvd, Minneapolis, MN0.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-23247PRVCamila Turner1990-05-10UHC-89373-5860096679299865 Mesa Dr, Charlotte, NC, 282180.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
ENR-109603ENRMaria I Estrada1953-05-25UHC-10803-9267237126565526 Valley View Dr, Jacksonville, FL0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109602ENRMaria I Estrada1953-05-25UHC-10803-9267237126565526 Valley View Dr, Jacksonville, FL0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427605CLMFrances Campbell1992-09-16UHC-98486-22456699213594 Washington St, Austin, TX, 787170.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-52646TPAHarold Carr1978-01-16——7475 Pine Dr, Denver, CO, 802470.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-413975CLMMary Knight1939-11-27UHC-60578-16—6718 Valley View Dr, Atlanta, GA, 303820.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405661CLMBrenda Harris1985-10-08UHC-30691-44—4126 Lake View Rd # 301, Plano, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
100,000 rows, page 174 of 2,000PreviousNext