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
TPA-56818TPAJack Wallace———3117 River Rd Apt 28, Plano, TX, 750450.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-20834PRVGloria Knight1987-09-01UHC-56784-2750064712724703 Lake View Rd, Charlotte, NC0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22820PRVJonathan M Patel1961-12-21—24783483804336 Desert Sky Blvd Apt 33, Glendale, AZ, 853810.38Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-106203ENRCharles F Rice—UHC-28560-6881821848637601 Spring St, Tampa, FL, 336620.38Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-106204ENRCharles F Rice—UHC-28560-6881821848637601 Spring St, Tampa, FL, 336620.38Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-123428ENRRalph Gibson1987-03-21UHC-51268-5556984475712194 Baseline Rd # 791, Miami, FL, 331430.38Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
CLM-419974CLMAnn M Weaver1980-11-21UHC-46632-1690923919682201 Apache Blvd, Miami, FL, 331570.38Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52459TPABrittany Simpson1979-05-16—25074181901635 Spring St, San Diego, CA0.38Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-102807ENRJulie Hansen—UHC-11629-444145977826667 Oak St, Eden Prairie, MN, 553360.38Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-142740ENRCamila L Kelly—UHC-54469-2360544538677640 Cedar Ln, Sacramento, CA0.38Date of birth unreadablePhone reformattedSSN last four extractedCity re-cased+3 more
ENR-119036ENRLucia C Russell1969-01-23UHC-13987-43—8135 Jefferson Ave, Fresno, CA, 937670.38Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
CLM-422865CLMSharon Q Reyes—UHC-18188-08—8929 Forest Ave # 477, San Antonio, TX, 782310.38Name re-casedDate of birth missingSSN last four extractedUnit split from street+3 more
CLM-431159CLMShirley Lee———429 Camelback Rd Apt 24, Chandler, AZ0.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406800CLMTeresa Hunt1976-08-13——6343 Lake View Rd, Chandler, AZ0.38Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-110207ENRFarnk B Anderson1941-10-02UHC-34079-9570883928993969 Apache Blvd, Tucson, AZ, 857840.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-130647ENRJake C Harvey1991-02-10UHC-30103-8034221327519345 Main St, San Diego, CA, 921680.38Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-402079CLMCarlos Lawrence—UHC-66269-8056124075216107 Mountain View Dr, Phoenix, AZ, 850150.38Name split from “Last, First”Date of birth unreadableMember ID reformattedStreet suffix standardised+3 more
CLM-402080CLMCarlos Lawrence—UHC-66269-8056124075216107 Mountain View Dr, Phoenix, AZ, 850150.38Name split from “Last, First”Date of birth unreadableMember ID reformattedStreet suffix standardised+3 more
CLM-418227CLMTerry Medina1965-02-08UHC-89474-9751843300479633 Sage Ct Apt 4, Eden Prairie, MN, 553160.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-117735ENRGeorge Gomeez—UHC-95429-8759891429935861 Highland Ave, Glendale, AZ0.38Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29215PRVRoger Reid1961-06-04UHC-97347-5631571275106939 Broadway, Minneapolis, MN, 554800.38Two-digit birth yearPhone reformattedMember ID reformattedSSN last four extracted+3 more
ENR-139456ENRBetty Anderson1953-07-18UHC-04639-9037068532051802 Palm Dr, Charlotte, NC, 282850.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20320PRVMaria E Harrison1998-01-02UHC-00391-3274747663322840 Oak St, Columbus, OH, 432970.38Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
PRV-20080PRVCarolyn Fernandez1976-01-27—76463137606529 Central Ave Apt 16, Houston, TX, 770550.38Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-416221CLMArthur Ryan1963-11-16UHC-21613-2570993497513760 Spring St, Los Angeles, CA, 900560.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-414368CLMHenry Sullivan—UHC-26067-06—1538 Harbor Blvd Apt 37, Los Angeles, CA, 900760.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54973TPASamuelJunk1967-07-12UHC-19679-79—6855 Church St, Tucson, AZ0.38Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-406858CLMBecky Yang———8845 Harbor Blvd Apt 8, Los Angeles, CA0.38Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408439CLMRalph Carpenter1967-06-11UHC-69808-22—9818 Baseline Rd, Jacksonville, FL0.38Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
ENR-125399ENRVincent C Dixon1985-07-10UHC-85495-0721631643677753 Pine Dr, Seattle, WA0.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114553ENRWilliam W Nelson1990-03-10UHC-80705-3566828913292497 Central Ave, Dallas, TX, 752130.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-113221ENRMarilyn Russell1985-11-07UHC-30013-20—879 Main St, Plano, TX, 750550.38Name split from “Last, First”Phone missing area codeSSN last four extractedStreet suffix standardised+3 more
ENR-103801ENRWei M Gardner2002-11-12UHC-60146-1784886403209666 Canyon Rd, Mesa, AZ, 852120.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-425448CLMLuis Garza1999-10-08——6467 Pine Dr, Nashville, TN, 372580.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-60623TPAAnn E Grant2000-11-02——3438 Hillcrest Rd, Los Angeles, CA, 900380.38Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedStreet suffix standardised+3 more
TPA-63951TPASaarh Cook2000-11-01——103 Grand Ave, Dallas, TX, 752190.38Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-134467ENRMarcus X Herrera—UHC-70801-8448057176539213 Cedar Ln, Denver, CO0.38Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-106398ENRPriya V Burton1971-02-22UHC-88178-1179632110405714 Park Pl Apt 24, Columbus, OH, 432290.38Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
CLM-425447CLMSarah Bailey1971-09-27UHC-07917-53—5551 Washington St # 479, Dallas, TX, 752280.38Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62155TPALinda L Smith1960-12-14——6026 Indian School Rd, Tampa, FL0.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-131291ENRLisa Wong1966-09-13UHC-10089-2059155788256788 Oak St Apt 39, Tucson, AZ0.38Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-112268ENRRyan Reynolds1936-06-06UHC-66475-4322649586327232 Palm Dr # 489, Plano, TX, 750880.38Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
ENR-127556ENRAngela Q Williamson1947-10-26UHC-83917-2233853730866565 Baseline Rd Apt 16, Phoenix, AZ, 850720.38Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
TPA-59694TPAKimberly Hoffman———3254 Jefferson Ave Apt 32, San Diego, CA, 921410.38Date of birth reformattedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
TPA-54426TPAEugene T Wallace1967-02-06—3775827333804 Grand Ave, Charlotte, NC, 282910.38Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
ENR-113140ENRLinda B Reid1978-11-23UHC-35716-5448623394306383 Market St, Tempe, AZ, 852420.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114005ENRAmanda B Hunt1946-08-22UHC-44646-26—88 Broadway, Jacksonville, FL, 322280.38Name re-casedTwo-digit birth yearPhone missing area codeAddress re-cased+3 more
ENR-114058ENRHarold U Nelson1971-09-18UHC-43965-263195965425918 Elm St # 112, Austin, TX, 787960.38Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-142324ENRJoseph O Davis2006-06-06UHC-17649-2127595158208059 Grand Ave, Scottsdale, AZ, 852200.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-101803ENRWei Davis1986-01-07UHC-37408-64—5765 Grand Ave, Los Angeles, CA, 900060.38Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
100,000 rows, page 25 of 2,000PreviousNext