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-113685ENRAdam C Griffin1999-11-11UHC-17159-2727463296252417 River Rd Apt 10, Tempe, AZ0.36Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-416215CLMAlan Maldonado1940-09-18UHC-40405-9896486407403947 Willow Ct # 416, Fresno, CA, 937600.36Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+4 more
PRV-20809PRVPamela Fields1988-04-12——9331 Spring St, Charlotte, NC0.36Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-432017CLMNicholas Cunningham1971-07-18UHC-89997-78—7483 Canyon Rd, Phoenix, AZ0.36Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-113710ENRRobert P Allen1951-01-11UHC-77201-4878751274722090 Ridge Rd, Sacramento, CA, 958470.36Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132407ENRJacob F Kennedy1989-10-26UHC-53943-8842250213865274 Desert Sky Blvd, Houston, TX, 770960.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-106660ENRAustin V Berry2007-04-07UHC-63286-3253757017999431 Central Ave # 760, Eden Prairie, MN, 553290.36Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-104631ENRArjunJunk1987-02-05UHC-85265-58—3720 Indian School Rd # 596, Miami, FL, 331650.36Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
ENR-131090ENRFatima D Walker1977-09-21UHC-22421-4764536051671113 Mesa Dr Apt 23, Mesa, AZ, 852660.36Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
ENR-110546ENRDenise A Reed1970-06-23UHC-12612-9056394888799294 Canyon Rd, Dallas, TX, 752640.36Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132578ENRWayne Z Morrison1989-06-15UHC-36040-9021328380353423 Valley View Dr, Fresno, CA, 937850.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-406578CLMAbigail Hayes1945-12-15——2400 Sage Ct, Denver, CO0.36Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
ENR-136882ENRJack L Wheeler1946-03-14UHC-27972-26—1276 Central Ave, Tempe, AZ, 852270.36Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+4 more
TPA-56488TPANancy Elliott1990-02-03UHC-42872-8471724454079279 Oak St, Tampa, FL, 336070.36Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-411518CLMPeter A Wong——91663333861739 Central Ave, Tempe, AZ, 852830.36Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-140574ENRSofia Owens1972-08-15UHC-02113-98—3376 Central Ave, Denver, CO, 802190.36Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-413338CLMEvelyn Moore1940-10-11UHC-51694-7458071759407696 Apache Blvd, Eden Prairie, MN0.36Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-24917PRVAhmed Fisher1986-05-01UHC-68058-04505305669944 Elm St, Seattle, WA, 981490.36Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-139122ENRBryan L Ramos—UHC-78407-36—134 Market St, Fresno, CA0.36Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-50196TPAJanice C Santiago1940-08-07—4093028714210 Highland Ave, Tucson, AZ, 857890.36Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-55103TPAGabriel T Nguyen1949-04-25——5009 Jefferson Ave, Chandler, AZ0.36Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
TPA-63915TPAKathryn Campbell1983-12-01——3280 Valley View Dr Apt 8, Los Angeles, CA0.36Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-101305ENRTeresa Carr1996-07-04UHC-74109-3372521336131962 Palm Dr, Dallas, TX, 752360.36Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more
PRV-29068PRVAmanda G Gibson1938-02-15—75082921816501 Meadow Ln, Plano, TX0.36Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59012TPAWalter Patterson———3166 Mountain View Dr, Las Vegas, NV0.36Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
ENR-121031ENRJustin Gray1992-11-11UHC-29426-6079130682079262 Mesa Dr Apt 5, Columbus, OH0.36Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-112114ENRCamila F Peterson1993-05-18UHC-03136-6197063563298687 Forest Ave # 503, Atlanta, GA, 303540.36Two-digit birth yearPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-136733ENRJack Chen1959-04-17UHC-51556-1296961470991301 Apache Blvd, Gilbert, AZ0.36Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-136809ENRDeborah Johnston1963-05-04UHC-79873-3932653424611122 Central Ave, Los Angeles, CA, 900110.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124260ENRWayne Z Mils1997-11-07UHC-99004-2390370627795085 Lincoln Way, Charlotte, NC0.36Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405712CLMLis Richardson1990-06-10UHC-29830-20—7253 Elm St # 117, Los Angeles, CA, 900800.36Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-62345TPADot Henderson1972-05-25——894 Apache Blvd, Minneapolis, MN, 554490.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-126514ENRSusan Yang2000-01-13UHC-21009-4247698699353414 Church St Apt 12, Jacksonville, FL, 322950.36Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-127599ENRJoan Maldonado1990-12-10UHC-93987-6495474562091564 Ridge Rd, Tampa, FL, 336070.36Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401642CLMDonna G Perez—UHC-15786-23—8563 Palm Dr, Atlanta, GA0.36Name re-casedDate of birth unreadableSSN last four extractedStreet suffix standardised+4 more
CLM-409511CLMLogan Turner1972-06-01UHC-66944-79—3235 Central Ave, San Antonio, TX0.36Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-139163ENRBeverly Jackson1998-09-09—45993241314804 Main St, Charlotte, NC0.36Street suffix standardisedAddress re-casedState name converted to codeZIP missing+4 more
ENR-102402ENRKevin Wheeler1980-05-15UHC-66833-6492226334544944 Elm St, San Antonio, TX, 782060.36Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136837ENRRichard Y Moreno2000-05-08UHC-79139-87—1583 Elm St, Miami, FL, 331120.36Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
ENR-116859ENRMichelle Harvey—UHC-86276-8390087049496552 Valley View Dr, Orlando, FL, 328450.36Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-101194ENRBarbara Ryan1964-05-01UHC-96763-4232324038006299 Sunset Blvd Apt 25, San Diego, CA, 921480.38Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-412180CLMStephanie Y Ruiz1999-01-26UHC-28633-53—1752 Main St, Eden Prairie, MN, 553290.38Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-103499ENREmily Holmes—UHC-18501-42—1945 Spring St, Eden Prairie, MN, 553290.38Name split from “Last, First”Date of birth missingSSN last four extractedStreet suffix standardised+3 more
ENR-120643ENRSharon O Stevens1985-05-24UHC-10278-3176280940491993 Sage Ct # 947, Nashville, TN, 372500.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-422425CLMLawrence Sooto1974-08-02UHC-60682-8458239027906232 Willow Ct Apt 30, Tempe, AZ, 852690.38Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-117393ENRAdam E Guzman1971-10-10UHC-80900-4942832262442639 Elm St Apt 39, Plano, TX, 750480.38Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
ENR-127545ENRWilliam Freeman1954-03-22UHC-52307-498858555367765 Highland Ave Apt 26, Plano, TX, 750710.38Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
CLM-413461CLMNatalie Wang1942-05-17——5516 Market St Apt 23, Austin, TX, 787860.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413958CLMDiana Hamilton1951-05-28——6681 Apache Blvd Apt 22, Charlotte, NC, 282350.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-121166ENRHannah Simpson1996-01-10UHC-46037-7756837914567540 Camelback Rd # 831, Tucson, AZ, 857250.38Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
100,000 rows, page 22 of 2,000PreviousNext