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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-58800TPADouglas Luna1990-11-25UHC-38556-96—8652 Willow Ct # 507, Atlanta, GA, 303670.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-63454TPAStephan Herrera1951-05-18——1373 Park Pl, Minneapolis, MN0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-55401TPAJulia Espinoza1970-06-04UHC-84983-20—6137 Desert Sky Blvd, Chandler, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61101TPALarry Duncan1989-04-28——9313 Baseline Rd, Eden Prairie, MN, 553460.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-53020TPAMarcus Lee1973-01-19—68798967458291 River Rd Apt 34, Glendale, AZ, 853410.64Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+2 more
TPA-51325TPARichard Andrews1990-08-18——5035 Pine Dr, Glendale, AZ, 853370.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56776TPAJesse Schultz1973-12-12——1059 Sage Ct, San Antonio, TX, 782740.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59867TPADanielle Lawrence1983-10-12—76986632169652 Mesa Dr, Houston, TX, 770690.64Name split from “Last, First”Phone reformattedCity re-casedGender normalised+2 more
TPA-50355TPAWei Patterson1949-07-04—91833193134830 Elm St, San Antonio, TX, 782350.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56644TPAMariana Robertson2004-08-20——5340 Desert Sky Blvd, Denver, CO, 802110.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-58846TPAKimberly Clark1979-07-14UHC-11805-3888962627471289 Bayshore Dr, Minneapolis, MN, 554740.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-57521TPADylan Torres1986-09-23——9469 Market St Apt 20, Scottsdale, AZ, 852000.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-51748TPAJeremy Snyder1997-11-27UHC-72167-18—4178 Park Pl, Jacksonville, FL, 322090.64Name re-casedZIP+4 trimmedGender normalisedPlan code upper-cased+2 more
TPA-62728TPADylan Lynch1999-03-16——5219 Baseline Rd, Orlando, FL, 328660.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59693TPAParker Gerld1953-07-26UHC-73850-5954979612534446 Forest Ave, Dallas, TX, 752370.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63201TPAElijah Weaver1999-02-26——8717 Main St, Atlanta, GA, 303880.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54467TPAGloria Fisher1976-08-13—39361378083183 Mesa Dr, Tampa, FL, 336440.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56657TPACharles Hill1993-12-10UHC-05062-5925891623137232 Grand Ave, Denver, CO, 802390.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-63828TPAWayne Wallace1997-06-12——919 Ridge Rd, Las Vegas, NV, 891250.64Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-51399TPA—Junk1992-07-05—83763727723824 Harbor Blvd, Jacksonville, FL, 322630.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59168TPAJonathan Sanhez1941-08-06——6808 Lake View Rd, Tucson, AZ, 857880.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56301TPAAdam Chapman1985-07-19——8709 Sage Ct, Eden Prairie, MN, 553600.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-50199TPATheresa Cooper1980-01-11UHC-54625-21—2097 Central Ave, Los Angeles, CA, 900400.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61539TPARussell Maldonado1947-12-10—28591373696230 River Rd, Eden Prairie, MN, 553300.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-53482TPAStephen Morrison1955-04-04——8567 Spring St, San Diego, CA, 921110.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-63833TPACarolyn Andrews1981-11-16—79951777105721 Ocean Ave, Tucson, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61288TPAPaul Richards—UHC-65191-83—5432 Pine Dr, Las Vegas, NV, 891410.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-57946TPAChhristian I Jenkins1987-10-28UHC-59084-32—4808 Cedar Ln # 403, Nashville, TN, 372700.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56187TPAKeith Rios1962-08-24—80475260551341 Cedar Ln, Glendale, AZ, 853430.64Name split from “Last, First”Two-digit birth yearPhone reformattedEmail lower-cased+2 more
TPA-64320TPAKatherine Ross1956-08-01——942 Spring St, Mesa, AZ, 852440.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62358TPAAbigail Rios1979-05-26——5815 Bayshore Dr, San Antonio, TX0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-60490TPARalph M Fisher1989-03-18UHC-77097-62—5993 Bayshore Dr, Las Vegas, NV0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-60489TPARalph M Fisher1989-03-18UHC-77097-62—5993 Bayshore Dr, Las Vegas, NV0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-54414TPAHenry Shaaw—UHC-75336-6836483792966601 Indian School Rd, Tucson, AZ, 857030.64Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+2 more
TPA-54413TPAHenry Shaaw—UHC-75336-6836483792966601 Indian School Rd, Tucson, AZ, 857030.64Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+2 more
TPA-51256TPAElijha Porter—UHC-37005-15—1434 Canyon Rd, Columbus, OH, 432020.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56788TPAJack Barnas1979-04-24——3185 Washington St, Las Vegas, NV, 891250.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
TPA-57470TPABilly R Santiago1950-04-14—38878770279301 Maple Ave, San Diego, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-50843TPAChristina Nguyen2003-04-20——9150 Harbor Blvd, San Diego, CA, 921820.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-58293TPAEthan Weaver1967-06-05——8731 Washington St, Mesa, AZ, 852680.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58294TPAEthan Weaver1967-06-05——8731 Washington St, Mesa, AZ, 852680.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57663TPATyler Hughse1985-02-21—37830704683740 Willow Ct # 114, San Antonio, TX, 782520.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-54195TPAPeter Herrera1941-07-16——4776 Washington St, Sacramento, CA, 958430.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-53279TPATyler Fernandez1978-08-14—66723768264638 Mountain View Dr, Los Angeles, CA0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
TPA-53041TPAJoyce Jones1956-08-08——8268 Forest Ave Apt 14, Los Angeles, CA, 900340.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-64304TPAMateo Moreno2002-03-02—51230382631447 Ridge Rd, Tempe, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-53745TPATyler Thomas1948-08-01UHC-19916-1472372389776416 Pine Dr, San Antonio, TX, 782640.64Name re-casedTwo-digit birth yearCity re-casedGender normalised+2 more
TPA-59363TPAHelen Guerrero1991-08-23UHC-70876-54—3231 Baseline Rd, Glendale, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-64424TPARalph Fisher1941-07-02——9548 Harbor Blvd, Miami, FL, 331260.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-51728TPACharlotte Williams1995-11-16—29864929168125 Canyon Rd, Austin, TX, 787650.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 56 of 290PreviousNext