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-56223TPAFatima Y Nunez———9002 Maple Ave, Glendale, AZ, 853070.54Date of birth missingState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
ENR-116023ENRSaraah O Sulivan1968-10-17UHC-55633-98—4140 Highland Ave, San Diego, CA, 921550.54SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-52929TPAPamela Q Black1969-01-06——8059 Park Pl, Denver, CO, 802570.54Name split from “Last, First”Phone missing area codeState name converted to codeWhitespace trimmed+1 more
ENR-128020ENRNoah Cook1966-08-22UHC-73381-7775522847247531 Oak St, Austin, TX, 787330.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-126085ENRArjun X Guerrero1991-07-07UHC-90114-99—9583 Jefferson Ave, Columbus, OH, 432650.54Two-digit birth yearState name converted to codeEmail lower-casedGender normalised+1 more
PRV-23736PRVGerald M Pena1978-10-23UHC-42304-14—9382 Bayshore Dr, Phoenix, AZ, 850380.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-53599TPALerry Patterson1993-11-15——8912 Ocean Ave # 624, San Antonio, TX0.54Phone missing area codeUnit split from streetZIP missingWhitespace trimmed+1 more
CLM-428051CLMEthan Williamson1984-12-10——2609 Palm Dr, Seattle, WA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-116807ENRJuan B Carpenter2000-06-11UHC-33252-10—5866 Church St, Columbus, OH, 432370.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-130128ENRCheryl C Harrison1954-12-16UHC-63017-8939930841243389 Meadow Ln, Los Angeles, CA, 900370.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-102382ENRKayla V Oliver1968-06-25UHC-52302-689247620522159 Meadow Ln, Sacramento, CA, 958180.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
TPA-56606TPABurke I Charles———3100 Lake View Rd, Atlanta, GA, 303020.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
TPA-56605TPABurke I Charles———3100 Lake View Rd, Atlanta, GA, 303020.54Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+1 more
ENR-119708ENREugene Wallace1942-06-16UHC-99190-1422073350968878 Baseline Rd, Jacksonville, FL, 322190.54Two-digit birth yearPhone reformattedState name converted to codeEmail lower-cased+1 more
TPA-61299TPAPeter G Fox2000-02-11UHC-43855-3237894760215462 Forest Ave, Houston, TX, 770830.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-119258ENRKathleen Andrews1960-05-22UHC-09149-8730920807634573 Baseline Rd # 273, Phoenix, AZ, 850360.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-142527ENRHiroshi B Russell—UHC-16259-545902349183203 Oak St, Phoenix, AZ, 850300.54Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-101297ENRKenneth I Wong1994-06-21UHC-77202-56—6751 Central Ave, Chandler, AZ, 852500.54Two-digit birth yearState name converted to codeZIP+4 trimmedEmail lower-cased+1 more
PRV-24482PRVDouglas Q Hunt1965-02-04UHC-18462-4060023160717565 Canyon Rd, Tucson, AZ, 857710.54Name re-casedTwo-digit birth yearZIP+4 trimmedGender normalised+1 more
ENR-104008ENRRuth Black1963-11-09UHC-63053-4622280507833100 Washington St, Plano, TX0.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-24174PRVStephanie Graham1961-05-16—48866029035498 Spring St, Austin, TX, 787400.54Two-digit birth yearState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
ENR-140998ENRDonna Morris2003-07-27UHC-81537-6253368510737992 Elm St Apt 3, Nashville, TN0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-137581ENRRoger C Gomez2000-11-06UHC-26333-1859732571583214 Sage Ct, Tempe, AZ0.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-417401CLMKyle Lynch1947-10-15UHC-65995-18—7672 Washington St, Phoenix, AZ, 850180.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55039TPABen Montgomery2002-01-13——1185 Central Ave, Glendale, AZ, 853060.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-411617CLMChristopher E Peterson2001-06-01UHC-41454-7148270861888720 Grand Ave Apt 24, Phoenix, AZ, 850900.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410140CLMIsabella Le1954-04-14UHC-22656-2092981766397791 Desert Sky Blvd, Orlando, FL, 328460.54SSN last four extractedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-27140PRVJerry O Jenkins———5012 Broadway, Houston, TX0.54Name re-casedDate of birth unreadableZIP missingGender normalised+1 more
CLM-406309CLMJoseph Thompson1944-11-23———0.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
PRV-26371PRVPaul Jordan1958-10-24UHC-04379-22—3424 Apache Blvd, Los Angeles, CA, 900200.54Name split from “Last, First”Two-digit birth yearPhone missing area codeCity re-cased+1 more
CLM-400635CLMStephen Ramirez2005-10-17UHC-34622-69—4006 Maple Ave # 169, Mesa, AZ, 852330.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-405207CLMFatima Richardson1959-12-19UHC-74401-31—3512 Elm St, Phoenix, AZ, 850060.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-54270TPATom Walsh1959-02-19——6258 Mountain View Dr, Charlotte, NC, 282640.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-105916ENRGregory Mitchell1973-05-09UHC-64045-83—199 Highland Ave, Glendale, AZ, 853660.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-408176CLMRobert Maldonado———7388 Palm Dr, Orlando, FL, 328440.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
ENR-125232ENRKim P Karen1993-01-13UHC-31368-1926141325658068 Mountain View Dr, Dallas, TX, 752060.54Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+1 more
ENR-103710ENRCatherine Z Cook1990-06-20—67932464193042 Cedar Ln, Los Angeles, CA, 900940.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-103312ENRStephanie T Garcia1940-02-21UHC-63671-8394070018398820 Central Ave # 550, Sacramento, CA, 958570.54Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+1 more
ENR-122203ENRMichelle Chavez1992-04-26UHC-36979-40—5832 Sunset Blvd, Scottsdale, AZ, 852880.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-24122PRVTyler Q Alvarado1993-03-01UHC-30206-42—1297 Valley View Dr, Gilbert, AZ, 852640.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-129488ENRJose Vargas1990-12-04UHC-62704-9733959898868971 Main St, Tempe, AZ, 852030.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-422296CLMWei Tucker1979-12-27—23568943245189 Valley View Dr, Nashville, TN0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-60932TPACharles Reid1996-06-14——3202 Lincoln Way, Tempe, AZ, 852110.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-418600CLMDebborah Simpson1939-04-23—39670308665622 Forest Ave, Nashville, TN, 372850.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-419417CLMJimmy Long1972-08-16UHC-80524-88—6078 Mountain View Dr, Nashville, TN, 372510.54Two-digit birth yearPhone missing area codeGender normalisedWhitespace trimmed+1 more
ENR-116675ENRIsabella N Torres2008-09-07UHC-07446-4036583956387978 Ridge Rd, Tucson, AZ, 857850.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-416379CLMLarry Perez1982-05-22UHC-26253-8537598617626800 Main St # 229, Gilbert, AZ, 852330.54Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-123051ENRZachary Romero1992-04-13UHC-18836-747353258273283 Camelback Rd, Eden Prairie, MN, 553270.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-105936ENRMartha D Yang1957-02-23UHC-83060-1558681465743884 Oak St, Orlando, FL0.54Date of birth reformattedSSN last four extractedState name converted to codeZIP missing+1 more
ENR-112279ENREddie Z Morales1992-03-08UHC-12549-9630377575915801 Forest Ave, Tampa, FL, 336850.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
100,000 rows, page 201 of 2,000PreviousNext