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-142760ENRJeremy O Pierce1955-06-26UHC-58693-807413043936959 Lincoln Way, Jacksonville, FL, 322830.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53808TPAJohn Lee1980-12-10——7726 Mesa Dr, Nashville, TN, 372980.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-29220PRVLauren Ryan—UHC-05185-183286179340514 Lake View Rd, Glendale, AZ, 853140.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-130010ENRZachary Black1942-11-02UHC-41546-11—292 Hillcrest Rd Apt 16, Denver, CO, 802780.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-58561TPAQJunk2001-03-04UHC-59973-8764356936274763 Church St Apt 38, Plano, TX, 750680.52Phone reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
ENR-111373ENRKayla S Scott1952-09-07UHC-27673-03—4856 Willow Ct Apt 38, Chandler, AZ, 852560.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-23150PRVAmanda Ortiz2003-09-19UHC-69544-44—7344 Baseline Rd, Seattle, WA, 981250.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-418712CLMJanice West1946-05-25UHC-30537-94—207 Meadow Ln, Chandler, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-413010CLMMary Y Powell—UHC-10162-8033260729682667 Indian School Rd Apt 37, Atlanta, GA, 303360.52Name re-casedDate of birth unreadablePhone reformattedUnit split from street+2 more
ENR-142811ENRAnn Lewis1960-10-11UHC-05814-4381593435537741 Mesa Dr, Tampa, FL, 336810.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-53720TPACynthia Lewis1959-05-07——9721 Apache Blvd, Gilbert, AZ, 852140.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52358TPAWayne Cunningham1947-05-12——1551 Lincoln Way # 746, Dallas, TX, 752650.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-132457ENRDiego Luucas1978-03-27UHC-75643-3064075794798646 Washington St, Denver, CO, 802020.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-112720ENRAnthony P Graham1963-10-09UHC-93791-0797875318108414 Highland Ave, Las Vegas, NV, 891650.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-132359ENRArjun Meyer2002-05-20UHC-42340-6664359503515146 Valley View Dr, Mesa, AZ, 852350.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112569ENRDouglas Tucker1992-08-22UHC-89410-8797699685325520 Desert Sky Blvd, Glendale, AZ, 853720.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-116991ENRKaren Snyder1983-11-04UHC-39600-5275696212068467 Camelback Rd, Scottsdale, AZ, 852370.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100663ENRCarol B Muphy—UHC-59734-8022165987055507 Elm St, Charlotte, NC, 282640.52Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-422620CLMDaniielle Lee1975-10-25UHC-50635-73—7026 Jefferson Ave Apt 14, Atlanta, GA, 303060.52Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-421052CLMFrank Howard1984-09-13UHC-75968-98—4846 Elm St, Glendale, AZ0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-400916CLMChristian Hudson1969-07-28UHC-86325-7275725039347305 Market St, Charlotte, NC, 282100.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
PRV-28223PRVRonald C Stone1938-12-18UHC-53111-7576095298552406 Apache Blvd, Gilbert, AZ, 852950.52Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+2 more
TPA-58441TPAKaren Rivera1984-05-22——9144 Ridge Rd Apt 12, Fresno, CA, 937790.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-50410TPAEmily Hudson1963-09-10——7372 Grand Ave, Fresno, CA0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-26904PRVElijah T Henderson1980-02-17UHC-24951-3922057840838438 Camelback Rd, Scottsdale, AZ0.52Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+2 more
TPA-59452TPAFrank Thompson1982-09-06——5660 Valley View Dr, Fresno, CA, 937300.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-118343ENRVargas Sean1992-06-05UHC-30722-6471682579691611 Lincoln Way, Mesa, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119795ENRHiroshi E Kelly1949-11-19UHC-22344-4167894532155959 Camelback Rd, San Antonio, TX0.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-55654TPASusan K Singh1992-06-09——2587 Ridge Rd, Sacramento, CA, 958230.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-119347ENRCynthia M King1956-04-22UHC-47003-5528099042071946 Jefferson Ave, Austin, TX, 787750.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-410002CLMPriya McDonald2007-08-25UHC-04817-13—5470 Market St Apt 30, Tucson, AZ, 857080.52Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
ENR-117182ENRNatalie L Elliott1978-11-20UHC-09220-5561087609236038 Desert Sky Blvd # 245, Miami, FL, 331770.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
CLM-408043CLMJoyce Andrews1954-12-28UHC-46410-68—1441 Park Pl, Tucson, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-428981CLMHelen H Bishop1992-01-16——1149 Forest Ave, Chandler, AZ, 852530.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-116437ENRDouglas E Simpson1967-03-11—40321371387773 Hillcrest Rd Apt 26, Orlando, FL, 328860.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-107745ENRStephanie Hunt1938-10-16UHC-49424-9345620207861688 Grand Ave, San Diego, CA, 921430.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-427562CLMRoy Morales1978-03-23UHC-84648-8075947304858768 Canyon Rd, San Antonio, TX, 782820.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-105151ENRLarry Welch2003-04-21UHC-16931-54—108 Sunset Blvd, Atlanta, GA, 303830.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50622TPABobby Jordan1994-07-21——7850 Market St, Charlotte, NC0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-141203ENRRobert Miller1984-11-03UHC-71350-3048776955364044 Market St, Minneapolis, MN, 554030.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100756ENRTheresa X Ortiz1985-08-24UHC-35785-1936750860995028 Cedar Ln, Scottsdale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-429267CLMTerry Russell1940-06-04UHC-49834-84—8387 Apache Blvd Apt 25, Charlotte, NC, 282040.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-125840ENRMei Munoz1964-12-03UHC-70129-3271051937988580 Lake View Rd Apt 2, Tucson, AZ0.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
CLM-409921CLMAlexis Ruiz1973-05-05——3858 Harbor Blvd, Sacramento, CA, 958280.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-418913CLMNatalie Gray1947-07-07UHC-63669-9781795708788297 Lincoln Way Apt 37, Charlotte, NC, 282150.52Name split from “Last, First”Unit split from streetCity re-casedGender normalised+2 more
ENR-141432ENRJulia B Daniels1957-03-11UHC-14003-41—507 Forest Ave # 375, Jacksonville, FL, 322780.52Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
CLM-427120CLMLisa Graham1956-08-06UHC-69384-55—6089 Apache Blvd, Eden Prairie, MN, 553770.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-113001ENRBryan Williams2007-08-09UHC-08951-3221983656683380 Park Pl # 671, Tempe, AZ, 852010.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-407651CLMJacob Mills1971-01-05UHC-03929-94—824 Elm St # 865, Seattle, WA0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-23211PRVSandra Morgan1939-05-20UHC-28897-69—1706 Palm Dr, Denver, CO, 802870.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
100,000 rows, page 163 of 2,000PreviousNext