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-401260CLMNancy Delgado1969-01-08——6958 Park Pl, Orlando, FL, 328160.34Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+5 more
ENR-105689ENRRandy B Tucker1981-03-15UHC-72020-5623636215479264 Mesa Dr Apt 32, Orlando, FL, 328400.34Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-105690ENRRandy B Tucker1981-03-15UHC-72020-5623636215479264 Mesa Dr Apt 32, Orlando, FL, 328400.34Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
TPA-63630TPAJulia Reyes———4574 Harbor Blvd, San Antonio, TX, 782140.34Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+5 more
TPA-56487TPAKeith Santos1994-12-12—9236565752153 Ridge Rd, Chandler, AZ0.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-409469CLMLaura S Dunn1976-02-22UHC-44881-0261665570958838 Park Pl # 812, Mesa, AZ0.34Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+5 more
ENR-118837ENRWayne James—UHC-68623-27986719952575 Willow Ct, Gilbert, AZ0.34Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-59438TPARonald Guerrero1953-09-22—81499493208347 Market St # 779, Scottsdale, AZ, 852620.34Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-124171ENRTheresa T Cooper1955-01-21UHC-72449-8240553674145258 Lake View Rd, Tempe, AZ0.34Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-402743CLMHarold T Welch1941-11-24UHC-33123-3625857332973308 Desert Sky Blvd, Chandler, AZ, 852890.34Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+5 more
CLM-401374CLMWillie Valdez1943-12-12UHC-40042-3359054630364034 River Rd, Minneapolis, MN, 554750.34Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+5 more
ENR-133391ENRCynthia H Santiago2006-03-09UHC-06856-30—5327 Maple Ave, Las Vegas, NV, 891110.34Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+5 more
PRV-20864PRVJuan S Silva1974-10-08—65128263895111 Mountain View Dr # 820, Las Vegas, NV, 891750.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
TPA-60621TPADoris Powell1975-10-28—89731659511164 Grand Ave, Las Vegas, NV0.34Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-426189CLMMark Marquez1953-02-28UHC-00810-9771064276615772 Sage Ct, San Antonio, TX, 782710.34Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-133731ENRAlan D Mejia1962-09-22—89063654848642 Union St, Gilbert, AZ0.34Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-401133CLMDiana Daan2003-02-25—79333796239896 Sage Ct # 654, Dallas, TX, 752710.34Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-425242CLMMegan M Butler—UHC-88806-5979941566648973 Church St, Atlanta, GA, 303510.34Name split from “Last, First”Date of birth unreadablePhone reformattedMember ID reformatted+5 more
ENR-112522ENRAbigail Montgomery1945-06-27UHC-74702-5973949978413460 Forest Ave, Minneapolis, MN, 554480.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-102473ENRAisha F Weaver1999-10-25UHC-45713-40—6879 Jefferson Ave, Las Vegas, NV, 891100.34Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-23965PRVJoshua M Yang2005-08-04UHC-41387-415506881599463 Palm Dr # 848, Plano, TX, 750400.34Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-118904ENRDiane Weaver1964-05-12UHC-06730-8465238492842791 Maple Ave Apt 3, Atlanta, GA, 303190.34Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-420341CLMHannah Roberts1971-11-23UHC-68689-28—8378 Bayshore Dr Apt 39, Tempe, AZ, 852090.34Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-126120ENRMei Y White1958-08-20UHC-19755-67—3997 Central Ave Apt 39, Eden Prairie, MN, 553290.34Middle initial moved out of first nameDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-400155CLMJustin Espinoza1972-09-14UHC-99989-03—2598 Elm St Apt 32, Eden Prairie, MN, 553170.34Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
TPA-60282TPAEmma Sullivan1967-11-11—74461316026436 Cedar Ln, Las Vegas, NV0.34Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-130259ENRScott Shaw1980-08-26UHC-01070-5090474426036262 Highland Ave # 769, Atlanta, GA0.34Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
PRV-26087PRVBradley Foster1992-10-12—36921833568231 Grand Ave, Tempe, AZ, 852900.34Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-142333ENRHiroshi P Medina1940-07-01UHC-21576-7731244137588974 Main St, San Antonio, TX, 782980.34Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-424921CLMFrances Davis1990-05-01——8923 Desert Sky Blvd, Plano, TX, 750190.34Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+5 more
PRV-28405PRVValentina Scott1983-10-26—34522603996070 Elm St, Gilbert, AZ, 852200.34Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+5 more
ENR-101398ENRSamantha Flores—UHC-62256-112182269409519 Lake View Rd, Eden Prairie, MN0.34Date of birth missingPhone reformattedMember ID reformattedSSN last four extracted+5 more
TPA-61812TPAVirginia Cox1964-12-25——6875 Camelback Rd # 275, Houston, TX0.34Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
PRV-21361PRVMary G Holmes1997-06-25——3467 Sunset Blvd, Las Vegas, NV0.34Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+5 more
ENR-115816ENRJordan Montgomery1968-01-10UHC-81385-3235529142245343 Spring St # 397, Gilbert, AZ, 852040.34Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+5 more
PRV-25773PRVJoose L Schultz1998-12-25UHC-22544-02—6038 Oak St, Orlando, FL, 328850.34Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-119374ENRJose R Carlson—UHC-41726-7236234645792996 Elm St, Fresno, CA, 937440.34Middle initial moved out of first nameDate of birth unreadablePhone reformattedStreet suffix standardised+5 more
CLM-417999CLMJoan Robertson2002-07-11——9644 Forest Ave, Houston, TX, 770090.34Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-126658ENRFrances W Hicks1979-09-05UHC-42723-225154535781284 Mountain View Dr, Tampa, FL, 336730.34Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-410566CLMChristine Gonzales1943-05-07——1128 Valley View Dr, Miami, FL, 331270.34Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
ENR-117544ENRAnthony G Lee—UHC-33113-687874653933276 Hillcrest Rd Apt 13, Charlotte, NC, 282620.34Date of birth missingPhone reformattedMember ID reformattedSSN last four extracted+5 more
ENR-127006ENRTheresa Y Mendoza1997-10-15UHC-04834-1074546173196953 Market St, Charlotte, NC0.34Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-63234TPAJessica Scott1971-03-12—22473019602188 Hillcrest Rd, Gilbert, AZ, 852740.34Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-64253TPADavid Myers1999-02-24UHC-12504-3858345929956706 Maple Ave, Glendale, AZ, 853710.34Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-431719CLMMari Armstrong1955-12-24—61294226579894 Ocean Ave # 688, Jacksonville, FL0.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
CLM-431720CLMMari Armstrong1955-12-24—61294226579894 Ocean Ave # 688, Jacksonville, FL0.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
ENR-106314ENRRoy Q Bennett1950-11-23UHC-17845-8046392175824687 Central Ave # 706, Scottsdale, AZ, 852700.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
CLM-407199CLMHenry Miller1963-04-22—39476735525024 Valley View Dr, Los Angeles, CA, 900430.34Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-60853TPASofia Banks1974-10-01—22563557378990 Sunset Blvd # 855, Gilbert, AZ, 852500.34Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more
PRV-28723PRVKayla Guerrero1974-04-05—30346344519734 Desert Sky Blvd, Nashville, TN, 372370.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
100,000 rows, page 10 of 2,000PreviousNext