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
PRV-23054PRVKenneth V Sanders—UHC-49739-30—5503 Jefferson Ave, Nashville, TN, 372740.48Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
CLM-431539CLMWilliam Webb1986-01-20UHC-85317-5339384438462004 Willow Ct, San Diego, CA, 921210.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-417221CLMGregory Dixon1989-11-13UHC-47337-39—4750 Highland Ave, Glendale, AZ, 853140.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124050ENRChristine D Silva1994-08-04UHC-39736-97—6004 Mesa Dr # 184, Orlando, FL, 328940.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-103534ENRAnn Wallace1937-08-24UHC-77936-0450639457142695 Washington St, Sacramento, CA, 958830.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-412382CLMScott Carroll—UHC-81901-5284475948082169 River Rd, San Diego, CA, 921250.48Name re-casedDate of birth missingPhone reformattedMember ID reformatted+4 more
ENR-125788ENRDylan O Robinson2007-07-15UHC-25806-4050432195823396 Maple Ave Apt 14, Orlando, FL, 328190.48Name re-casedPhone reformattedSSN last four extractedUnit split from street+4 more
CLM-406912CLMPriya Barnes———4086 Ocean Ave, Tampa, FL0.48Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
CLM-431939CLMDiego P Dominguez1985-01-01—66672321383937 Lake View Rd, Austin, TX0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23479PRVJulie J Wilson—UHC-76381-4128594761319127 Pine Dr # 522, Columbus, OH, 432490.48Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more
ENR-102434ENRBrandon M Fox2005-04-28UHC-96771-85—267 Camelback Rd, Plano, TX0.48Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
ENR-125365ENRChristina Morgan2007-03-17UHC-99715-0660079237225927 Cedar Ln, Phoenix, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-63047TPACheryl Lnua1999-12-26—94385159395148 Harbor Blvd, Atlanta, GA0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54561TPAAnna Dunn1979-05-15—25747823741087 Hillcrest Rd, Miami, FL, 331550.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422253CLMRuth Ford1973-12-26UHC-28799-2972195637123627 Desert Sky Blvd # 429, Tempe, AZ, 852170.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-130377ENRSarah T Long1977-08-16UHC-37791-6461862739112128 Ocean Ave, Nashville, TN, 372840.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23044PRVAmber Perez1943-10-25UHC-24581-9940130117686547 Union St, Nashville, TN, 372440.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-139179ENRLuis Hernandez1948-08-16UHC-35955-6560347927173548 River Rd Apt 19, Denver, CO, 802680.48Name split from “Last, First”Member ID reformattedUnit split from streetStreet suffix standardised+4 more
PRV-20138PRVDebra W Davis1986-02-13——1252 Church St Apt 30, Orlando, FL0.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-64284TPAJose Banks1997-11-05——5571 Main St, Dallas, TX, 752750.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27712PRVCarl Sims1953-05-05——2766 Desert Sky Blvd, Plano, TX, 750780.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132451ENRJerry Thompson—UHC-70094-7035641480888380 Ridge Rd, Seattle, WA0.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-136770ENRDonald Santos—UHC-53519-2151151610802431 Indian School Rd, Columbus, OH, 432920.48Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
ENR-106648ENRDavid Lynch1973-03-08UHC-33248-8936779030608297 Forest Ave, Tampa, FL0.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-411367CLMJonathan Wheeler2007-10-20——8429 Hillcrest Rd # 900, Scottsdale, AZ, 852850.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-116649ENRMaria F Perry1979-04-28UHC-32511-5625397482666760 Willow Ct, Sacramento, CA, 958850.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-26571PRVRuth W Ford1973-12-26UHC-28799-2972195637123627 Desert Sky Blvd # 189, Tempe, AZ, 852170.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-61933TPAEugene Henderson1959-02-22—22150165063030 Ocean Ave Apt 21, Scottsdale, AZ, 852960.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-132607ENRJoan U Garcia1956-02-10UHC-53327-82—5420 Market St, Eden Prairie, MN, 553740.48Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
ENR-141839ENRPatricia Rice1951-11-26UHC-18805-9091162159648745 Mesa Dr # 267, Los Angeles, CA, 900860.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-22545PRVWalter H Fuller1957-07-01UHC-25159-1824679847131122 Camelback Rd, Atlanta, GA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422595CLMTeresa H West1965-11-01UHC-07289-33—5088 Main St Apt 27, Mesa, AZ, 852450.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-123564ENRNick Washington1968-08-08UHC-18391-8747968706166609 Highland Ave, Phoenix, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410773CLMAbigail Johnston2002-06-09UHC-13519-7570442967875319 Meadow Ln, Dallas, TX0.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104970ENRMason Marquez1998-12-04UHC-73096-6164660299642385 Elm St, Mesa, AZ, 852280.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-50075TPARichard Kelley1961-01-10UHC-55573-1875436172071539 Spring St, Atlanta, GA0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56994TPADiane A Hunter1963-01-01—89837748268372 Lake View Rd, Plano, TX, 750120.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-426268CLMBryan Y Bradley1987-05-12—21260932095040 Oak St Apt 38, Miami, FL, 331610.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
ENR-132023ENRCharlotte Matthews1979-09-26UHC-91604-7692346709347380 Lincoln Way, Miami, FL, 331800.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-414920CLMDon Hamilton—UHC-49782-3834530841194473 Canyon Rd, Columbus, OH, 432910.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-405249CLMKathryn T Lawson1984-08-08UHC-85546-13—6848 Harbor Blvd, Phoenix, AZ, 850010.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59621TPAStephanie Campblel1952-03-26—66537421246703 River Rd Apt 29, Denver, CO0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-64268TPAMatthews Rachel1985-04-21—73637749368619 Lincoln Way, Los Angeles, CA, 900840.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140296ENRKathleen Z Fisher1953-08-12UHC-98423-3297562695555400 Sunset Blvd, Nashville, TN, 372190.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-53990TPACheryl Stepehns2008-06-25——8534 Valley View Dr Apt 5, Austin, TX0.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-102646ENRRandy Booyd1984-06-23UHC-69182-3372883103348961 Baseline Rd # 693, Fresno, CA, 937150.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-132380ENRStephanie B Jenkins1972-11-19UHC-66957-95—3598 Hillcrest Rd, Tempe, AZ, 852730.48Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-415339CLMMargaret N Foster1970-07-13—97324949987591 Cedar Ln, Minneapolis, MN, 554180.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-114444ENRDebra Fernandez1977-09-23UHC-61165-2660431785863489 Ridge Rd, Jacksonville, FL, 322360.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-120770ENRRussell Harrsion—UHC-05513-689875500866460 Palm Dr, Dallas, TX, 752390.48Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+4 more
100,000 rows, page 68 of 2,000PreviousNext