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-423185CLMStephen Henry———5848 Forest Ave, Plano, TX, 750030.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53387TPANatalie N Wagner1965-07-26—79037885189743 Sunset Blvd, Orlando, FL, 328180.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
CLM-420071CLMChristine I Olson1984-12-03UHC-78090-69—7619 Pine Dr, Fresno, CA, 937380.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-63581TPAJesse Bryant1948-07-25——9551 Sunset Blvd, Los Angeles, CA, 900890.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-119500ENRAustin Wood—UHC-01868-34—5714 Cedar Ln, Atlanta, GA, 303560.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
ENR-113835ENRSofia P Welch2005-09-24UHC-60104-27—9888 Main St, Eden Prairie, MN, 553300.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
PRV-24569PRVJacob Greene—UHC-35926-2231496579459893 Meadow Ln # 312, Jacksonville, FL, 322110.54Date of birth unreadableUnit split from streetState name converted to codeWhitespace trimmed+1 more
ENR-100916ENRDylan B Scott1971-07-22UHC-89866-965498214267450 Pine Dr, Houston, TX, 770480.54Name split from “Last, First”Phone reformattedSSN last four extractedGender normalised+1 more
ENR-141252ENRLucia E Foster1941-02-06UHC-10708-39—9138 Lincoln Way, Las Vegas, NV0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-419920CLMDouglas E Wang1938-02-04——566 Pine Dr, San Diego, CA, 921450.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-104415ENRWayne H Wang1963-02-23UHC-60912-66—9494 Market St, Jacksonville, FL, 322930.54Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
PRV-21995PRVAlex Hunt2003-02-22——2344 Church St Apt 9, Miami, FL, 331660.54Name split from “Last, First”Unit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-410740CLMAnna Scott1966-07-27UHC-14025-28—5407 Harbor Blvd, San Diego, CA, 921010.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-105948ENRRuth M Grant—UHC-11219-5884425253696335 Forest Ave, Tempe, AZ, 852350.54Name split from “Last, First”Date of birth unreadablePhone reformattedCity re-cased+1 more
CLM-408650CLMJerry I Price1995-10-18——7498 Forest Ave Apt 3, San Antonio, TX, 782920.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-53326TPAJoe Turner1997-09-21——3679 Lincoln Way, Denver, CO0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-111682ENRMelissa W Willis2001-11-16UHC-20645-30—2108 Sage Ct, Atlanta, GA0.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-51202TPALuis W Wallace———6713 Main St, Columbus, OH, 432320.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-412253CLMJordan Wheeler1954-09-25UHC-10993-15—9746 Mesa Dr, Mesa, AZ, 852580.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-108221ENRJennifer D Reyes1991-01-16UHC-48924-0944372372675349 Valley View Dr, Plano, TX, 750060.54Name split from “Last, First”Middle initial moved out of first namePhone reformattedState name converted to code+1 more
TPA-60277TPAGerald Ruiz1989-02-10—23464812638019 Canyon Rd, Columbus, OH, 432510.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-112718ENRJoshua B Hoffman—UHC-75819-13—4968 Indian School Rd, Austin, TX, 787250.54Name re-casedDate of birth missingPhone missing area codeGender normalised+1 more
PRV-21882PRV—Junk1945-05-06UHC-12903-2582839461818733 Park Pl, Los Angeles, CA0.54Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared+1 more
ENR-117869ENRJoshua Cooper1962-10-20UHC-54359-8241352067448269 Pine Dr, Nashville, TN, 372340.54Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+1 more
ENR-106579ENRAndrew V Reyes1977-12-22UHC-82778-2076286172866345 Ridge Rd, Eden Prairie, MN, 553680.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118134ENRLinda Z Vargas1986-06-11UHC-27818-1691880994949669 Mountain View Dr # 288, Scottsdale, AZ, 852050.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429854CLMAmanda Phillips1950-10-15—22290005133745 Canyon Rd # 260, Mesa, AZ, 852020.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-52918TPABill Howard———9694 Bayshore Dr, Nashville, TN0.54Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-63443TPABrittany Ferguson1944-05-18UHC-92938-61—6556 Ocean Ave # 772, San Diego, CA, 921270.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-141571ENRSophia Jacobs1941-04-15UHC-74205-24—8862 Bayshore Dr Apt 26, Mesa, AZ, 852090.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-106331ENRAnthony Jackson1989-12-17UHC-88124-0393353858695099 Valley View Dr, Charlotte, NC, 282250.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-406827CLMSamuel Murphy1938-03-23UHC-88511-6964962997275850 Main St, San Diego, CA, 921140.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-57332TPANoah W Hall1946-05-18UHC-25198-97—7972 Forest Ave, Seattle, WA, 981190.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-137400ENREmma Y Alvarez1980-08-14UHC-46560-0369567289411553 Bayshore Dr, Houston, TX, 770980.54Name re-casedTwo-digit birth yearState name converted to codeEmail lower-cased+1 more
CLM-406566CLMAnthony Rios1984-09-02UHC-38512-88—5354 Camelback Rd # 268, Gilbert, AZ, 852460.54Unit split from streetState code upper-casedZIP+4 trimmedGender normalised+1 more
CLM-429369CLMDona Cook1944-02-16UHC-09751-962563339851599 Washington St, Fresno, CA, 937120.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-104187ENRGeorge J Willis1939-10-03UHC-36586-6477544868014974 Maple Ave, Phoenix, AZ0.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-128354ENRJuan H Gonzalez1998-07-01UHC-25304-69—1356 Baseline Rd, Glendale, AZ, 853160.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55082TPAKatherine Bowman———4963 Central Ave, Mesa, AZ0.54Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-107588ENRKelly Wong2007-06-01UHC-18814-7356645624927943 Pine Dr, Dallas, TX0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
TPA-53733TPAStephen Patel1961-07-20——8076 Highland Ave, Columbus, OH, 432900.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53732TPAStephen Patel1961-07-20——8076 Highland Ave, Columbus, OH, 432900.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-431582CLMAaron Morris1945-05-07——6297 Lake View Rd # 445, Scottsdale, AZ, 852760.54Name re-casedTwo-digit birth yearUnit split from streetZIP+4 trimmed+1 more
CLM-411238CLMJoyce Q Spencer1948-01-17UHC-22576-11—5505 Baseline Rd, Orlando, FL, 328890.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
TPA-62899TPAVirginia Ramos1989-04-27———0.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-421240CLMAnthony Collins1995-05-10UHC-10472-57—6148 Washington St, Houston, TX, 770710.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-128222ENRJulie M Singh1975-08-19UHC-47477-3482579441274749 Maple Ave, Fresno, CA, 937210.54Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedState name converted to code+1 more
TPA-54368TPANicole Hayes1939-04-16UHC-32516-68—695 Apache Blvd Apt 28, Plano, TX, 750900.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-124938ENRNoah Ford1992-05-17UHC-06491-63—1617 Market St, Chandler, AZ0.54Name split from “Last, First”Phone missing area codeZIP missingWhitespace trimmed+1 more
ENR-139067ENRChristian Duncan1986-08-20UHC-25272-9946231833492753 Mountain View Dr, Los Angeles, CA, 900020.54Name split from “Last, First”Two-digit birth yearPhone reformattedEmail lower-cased+1 more
100,000 rows, page 217 of 2,000PreviousNext