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-431257CLMAndrew Lopez2007-07-26——6398 Spring St Apt 26, Scottsdale, AZ, 852510.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-120342ENRJames X Fernandez1994-08-23UHC-25043-6871855919458740 Palm Dr, Seattle, WA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-22026PRVPriya Cook1956-08-04—85939016068550 Cedar Ln, Eden Prairie, MN, 553260.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416586CLMHeen Mejya1987-01-20UHC-40105-27—9445 Desert Sky Blvd, Eden Prairie, MN0.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-410953CLMAlex Diaz2001-08-14——3718 Mountain View Dr, Eden Prairie, MN, 553180.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-427000CLMGeorge Estrada2008-02-27UHC-75585-02—5649 Harbor Blvd, San Antonio, TX, 782650.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-114341ENRDiane Lawson1992-01-09UHC-62696-5451783006779198 Mesa Dr, Chandler, AZ, 852960.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-128341ENRDonna T Aguilar1991-06-09UHC-53014-0227754350263600 Central Ave, San Diego, CA, 921640.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404695CLMCharles Chapman—UHC-47214-684886556297884 Canyon Rd, Tempe, AZ, 852660.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63491TPAJulie Wilson1948-09-17——6180 Canyon Rd Apt 16, Orlando, FL, 328390.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-422483CLMBobby Wilson1980-12-08——2048 Lake View Rd, San Antonio, TX, 782460.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-114824ENROmar V Thomas1983-02-04UHC-30987-3150397441893899 Union St # 135, Eden Prairie, MN0.52Name re-casedPhone reformattedUnit split from streetCity re-cased+2 more
PRV-26299PRVAlexis Hill1952-02-12UHC-64036-10—4089 River Rd, Tucson, AZ, 857880.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424162CLMMaggie Valdez1994-09-01UHC-29630-30—4234 Cedar Ln, Atlanta, GA, 303180.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-60063TPALaura Weber1941-09-14——3697 Highland Ave, Orlando, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
PRV-22006PRVCheryl Rivera1963-09-14——7489 Apache Blvd, Phoenix, AZ, 850390.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-60151TPATarry D Stone1976-06-03——7619 Ridge Rd # 100, Charlotte, NC, 282600.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-61443TPADiana Casttro1971-09-25——2883 Market St, Tampa, FL, 336280.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420026CLMKayla M Richards1976-01-10——2779 Pine Dr, Dallas, TX0.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-21823PRVJeremy Walker1958-05-11UHC-68255-8940376061147404 Lincoln Way, Seattle, WA0.52Name split from “Last, First”Phone reformattedZIP missingGender normalised+2 more
CLM-407422CLMMatthew X Valdez2002-06-14UHC-71925-83—4853 Maple Ave, Las Vegas, NV, 891990.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-114872ENRMark G Hicks1970-05-20UHC-81141-1570677171393440 Ocean Ave, Tucson, AZ, 857660.52Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+2 more
TPA-55660TPARobert Hall1946-03-22UHC-74797-86—1833 Oak St, Sacramento, CA, 958930.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55608TPAJerry E Porter1980-01-22——8480 Forest Ave, Tempe, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-140942ENRHelen O Warreen—UHC-83673-4852394320682410 Sage Ct, Chandler, AZ, 852190.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28170PRVMei Harris1945-10-08UHC-08874-1573140839752008 Maple Ave, Los Angeles, CA, 900370.52Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+2 more
TPA-54787TPAJesse Warren2008-11-17—46383016877100 Hillcrest Rd, Gilbert, AZ, 852430.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-62765TPAJean Johsnon1947-06-09——6754 Canyon Rd, Nashville, TN, 372770.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-409982CLMStephen W McCoy1976-03-10—46375248888878 Market St, Scottsdale, AZ, 852600.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402016CLMRaymond Hall1978-08-11——3690 Elm St, San Antonio, TX, 782980.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-117584ENRMichelle T Lee1954-10-11UHC-92235-7020721312805375 Hillcrest Rd, San Antonio, TX0.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-121928ENRAlbert G Stephens1949-04-17UHC-81418-5526766820752513 Lake View Rd, Seattle, WA, 981630.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100856ENRRussell Cox1996-09-22UHC-24189-1452387715084322 Market St, Jacksonville, FL, 322560.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-430399CLMKenneth Nguyen1982-03-28UHC-63340-98—1311 Palm Dr # 988, Tampa, FL, 336400.52Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431379CLMArjun Burtoon1938-05-13UHC-81734-92—4451 Grand Ave, Eden Prairie, MN, 553440.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-124630ENRJasno N Watson1999-06-27UHC-31272-9743221938048344 Harbor Blvd # 141, Columbus, OH, 432820.52Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-412669CLMWei Y Willis1982-11-23UHC-22401-11—3743 Willow Ct, Orlando, FL, 328650.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55372TPAStephanie Ruiz———1752 Main St, Eden Prairie, MN, 553290.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-423773CLMWayne V Thomas2006-10-19UHC-05470-01—5517 Harbor Blvd, Tampa, FL, 336640.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-60240TPADenise Young1969-11-18——2167 Desert Sky Blvd, Tempe, AZ0.52Date of birth reformattedState name converted to codeZIP missingGender normalised+2 more
TPA-62830TPASharon Ruiz1996-02-26—66688562602788 Washington St, Tampa, FL, 336090.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-131402ENRPayne T Jerry2007-09-09UHC-08650-2424640106368748 Harbor Blvd Apt 27, Denver, CO, 802830.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414640CLMDenise Sanchez1994-11-02UHC-02390-9937693882568771 Market St, Scottsdale, AZ, 852930.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133672ENRBrian Davis1966-07-20UHC-04570-35—6652 Park Pl # 207, Jacksonville, FL, 322140.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-29192PRVWayne Lopez2001-12-26—63960903218070 Highland Ave, Dallas, TX, 752960.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-432262CLMJulie N Knight1989-05-17—76299660269298 Lake View Rd # 668, Tucson, AZ, 857450.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-404036CLMChristina Jackson1962-06-02UHC-91939-2798932278567008 Sunset Blvd, Denver, CO, 802970.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-119271ENRMason L Alvarez1960-01-20UHC-46407-37—9794 Cedar Ln, Mesa, AZ, 852810.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-119270ENRMason L Alvarez1960-01-20UHC-46407-37—9794 Cedar Ln, Mesa, AZ, 852810.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-129459ENRMarcus Ward2004-03-13UHC-17912-6879554193686546 Jefferson Ave, Charlotte, NC, 282310.52Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more
100,000 rows, page 185 of 2,000PreviousNext