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
CLM-432581CLMZachary Mitchell—UHC-77378-2042690499415449 Jefferson Ave, Charlotte, NC, 282780.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130138ENRKyle K Smith—UHC-64566-5263443570571315 Park Pl, San Diego, CA0.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-134669ENRStephen K Garza1982-04-22UHC-48291-2594569652871800 Central Ave, Minneapolis, MN, 554170.50Name re-casedTwo-digit birth yearPhone reformattedState code upper-cased+3 more
ENR-117953ENRLaura E Mendez—UHC-60316-2329959500175085 Bayshore Dr # 518, Phoenix, AZ, 850460.50Name re-casedDate of birth reformattedDate of birth unreadableUnit split from street+3 more
CLM-410180CLMDylan Simpson——46726818354745 Lake View Rd Apt 3, Minneapolis, MN, 554750.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-413974CLMMargaret Gardner1978-11-20UHC-83781-04—9118 Cedar Ln, Orlando, FL, 328640.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55936TPALarry H Freeman1973-10-19——8114 Sage Ct, Tampa, FL, 336880.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-114634ENRDonald Yang—UHC-31855-28—9167 Washington St, Columbus, OH0.50Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407339CLMMari I Estrada1953-05-25UHC-10803-9267237126565526 Valley View Dr # 559, Jacksonville, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54523TPAGeorge King1943-04-06——3734 Grand Ave Apt 30, Denver, CO, 802180.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
ENR-121748ENRRonald Rojas1943-10-01UHC-59380-9080839655186395 Valley View Dr, Miami, FL, 331990.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-20248PRVGrace D Rodriguez1994-03-14——4481 Sage Ct, San Antonio, TX, 782170.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-138781ENRAlexis Elliott1987-05-15UHC-17159-1420899791461711 Canyon Rd, Tempe, AZ, 852600.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-63555TPASarah Evans——7863518033834 Cedar Ln, Eden Prairie, MN, 553560.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130682ENRMartha Ellis1946-03-14UHC-51149-9384376706063183 Grand Ave, San Antonio, TX, 782560.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429344CLMGloria A Howard2000-02-07UHC-86207-58—3701 Ridge Rd, Mesa, AZ, 852060.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407348CLMGeorge Murphy1998-10-14UHC-12080-5196480525072791 Elm St # 190, Fresno, CA, 937780.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-107937ENRMason M King—UHC-51740-5020370328993044 Ridge Rd, Eden Prairie, MN, 553560.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-123356ENRTheresa L Garza1942-10-28UHC-29869-56—877 Cedar Ln, Atlanta, GA, 303190.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-103455ENRRonald G Vazzquez1988-04-12UHC-64583-35—8925 Meadow Ln, Los Angeles, CA, 900010.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-124044ENRRaymond X Ray1945-12-26UHC-65599-3543956080211736 Desert Sky Blvd, Charlotte, NC0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427123CLMJeremy Chen2007-05-25——2206 Spring St, Fresno, CA0.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-56156TPAMary I Ruiz2009-03-26——4939 Ocean Ave, San Antonio, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-118131ENRKimberly Q Jordan—UHC-39395-0758473858996477 Palm Dr, Charlotte, NC, 282070.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403778CLMRaymmond Vasquez1997-10-05UHC-16882-1054696785762095 Cedar Ln Apt 12, Tampa, FL, 336690.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
ENR-132317ENRMei Miller1991-09-01UHC-81458-8260599989007675 Central Ave, Atlanta, GA, 303310.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-427906CLMEmma Q Clark2005-11-07—78269770888762 River Rd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125785ENRHannah Morales2008-03-17UHC-26431-5563631609433620 Main St, Atlanta, GA, 303160.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62339TPAElliott Barbara1941-02-08—93679118776512 Canyon Rd, Columbus, OH, 432510.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112374ENRIsabella Berry1945-04-01UHC-10949-4768639285508659 Sage Ct, Tucson, AZ, 857220.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402814CLMBrandon Y Obrien1985-10-23——2492 Forest Ave, Las Vegas, NV, 891310.50Name split from “Last, First”Name re-casedStreet suffix standardisedAddress re-cased+3 more
TPA-64058TPALauren Jackson2004-04-04—89034567517895 Harbor Blvd, Houston, TX0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423328CLMOmar Ortiz1956-02-23——2029 Ridge Rd, Nashville, TN, 372390.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-109709ENRBarbara C Gibson2001-09-07UHC-31992-3624924704312335 Willow Ct, Gilbert, AZ, 852880.50Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+3 more
ENR-101628ENRKimberly Harris1959-04-24UHC-10041-7383286810334215 Cedar Ln, Columbus, OH, 432290.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101629ENRKimberly Harris1959-04-24UHC-10041-7383286810334215 Cedar Ln, Columbus, OH, 432290.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123188ENRDavid Andrews1950-09-02UHC-01919-1869540093483567 Sunset Blvd, Jacksonville, FL0.50Name re-casedPhone reformattedCity re-casedState name converted to code+3 more
ENR-114781ENRKathy Q West1968-04-18UHC-48148-9966834759013928 Camelback Rd # 253, Glendale, AZ, 853390.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-134293ENRHelen G Simmons1950-06-12UHC-26724-97—8767 Grand Ave, Charlotte, NC, 282970.50Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-136553ENRCheryl Wagner1962-03-27UHC-60739-1635334849787207 Spring St, Dallas, TX0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432638CLMNicole Stewart1966-03-23UHC-66328-57—4480 Desert Sky Blvd, San Antonio, TX, 782430.50Name re-casedCity re-casedState name converted to codeZIP+4 trimmed+3 more
CLM-429805CLMJessica L Hunt1980-04-27UHC-73352-6577641915393711 Valley View Dr, Miami, FL, 331710.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61082TPACarolyn Daniels1946-12-25—78677929675483 Cedar Ln, Austin, TX, 787160.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-134525ENRNicole U Lopez1973-08-28UHC-36882-5045875070354900 Mountain View Dr, Eden Prairie, MN, 553660.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-58396TPAJudith Burns1978-04-16——8847 Pine Dr, Nashville, TN, 372580.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-408995CLMAln D Burke1979-06-18——7703 Willow Ct Apt 11, Glendale, AZ, 853100.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-129517ENRDaniel Morales2006-06-28UHC-50469-96—5695 Willow Ct, Fresno, CA0.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108433ENRYuki B Stephens1996-12-08UHC-92550-7173893084065123 Baseline Rd, Las Vegas, NV, 891630.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-112559ENRRandy Kennedy1954-11-01UHC-29773-4197322743145003 Union St, Las Vegas, NV, 891590.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-109318ENRLaaura S Stone1984-10-19UHC-63188-72—7846 Willow Ct, Seattle, WA, 981900.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
100,000 rows, page 87 of 2,000PreviousNext