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-109289ENRHannah Q Tuckre1957-11-08UHC-11072-9872179631727083 Market St, San Diego, CA, 921200.22Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+5 more
ENR-102176ENRFrank Li1974-10-04UHC-11541-0333461898987401 Indian School Rd, Jacksonville, FL0.22Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+5 more
PRV-27090PRVLaura Nunez1969-01-27—85847327553323 Harbor Blvd Apt 1, Fresno, CA, 937040.22Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+5 more
TPA-62821TPADenise Tran1994-09-08—83644703917545 Spring St, San Antonio, TX, 782640.22Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-118357ENRFatimaJunk1985-07-28UHC-18372-48—7311 Sage Ct Apt 9, Fresno, CA, 937910.22Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+5 more
CLM-403925CLMMartha Jimenez1966-11-05UHC-80991-11—6213 Oak St # 872, Fresno, CA0.22Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-107235ENRBarbara M Morrison—UHC-50934-4425366358278780 Sage Ct, Eden Prairie, MN, 553420.22Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+5 more
ENR-129211ENRDorothy P Kennedy2007-11-23UHC-82927-77—5085 Willow Ct, Phoenix, AZ, 850420.22Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+5 more
ENR-107622ENRJake J Reed1945-12-18UHC-01120-63—9349 Meadow Ln # 132, Columbus, OH, 432610.22Middle initial moved out of first nameDate of birth reformattedPhone missing area codeUnit split from street+5 more
CLM-409894CLMAnna U Montgomery1975-08-20UHC-65162-84—2502 Jefferson Ave, Charlotte, NC, 282380.22Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+5 more
PRV-20560PRVEvelyn Johnston1940-12-09—56638035555408 Willow Ct # 165, Plano, TX0.22Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+5 more
CLM-412338CLMShirley Harris1994-07-02UHC-79852-31—3593 Grand Ave, Plano, TX, 750060.22Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+5 more
CLM-405762CLMPeter Mendoza—UHC-10519-6373364882444978 Valley View Dr Apt 11, Austin, TX, 787660.22Name re-casedDate of birth unreadablePhone reformattedUnit split from street+5 more
ENR-100512ENRAlan N Richards—UHC-85240-22—7100 Spring St, Houston, TX, 770310.22Name split from “Last, First”Date of birth unreadableMember ID reformattedStreet suffix standardised+5 more
ENR-114588ENRNancy X Evans1955-07-19UHC-89861-3784292340037985 Market St, Dallas, TX, 752830.24Name split from “Last, First”Two-digit birth yearPhone reformattedSSN last four extracted+4 more
CLM-431689CLMJacqueline Richards2004-09-10——2754 Main St, Dallas, TX, 752980.24Name split from “Last, First”Phone missing area codeSSN last four extractedStreet suffix standardised+4 more
TPA-53157TPABilly Baker2008-03-22UHC-91951-4046498355187750 Sunset Blvd # 914, Seattle, WA, 981790.24Name split from “Last, First”Two-digit birth yearUnit split from streetStreet suffix standardised+4 more
ENR-118175ENRMason Vasquez1967-05-27UHC-71588-6364168591763053 Central Ave # 496, Los Angeles, CA, 900660.24Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+4 more
TPA-55523TPACharlotte Bryant2002-04-24——1933 Grand Ave # 600, Dallas, TX, 752550.24Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-102425ENRMike F Harrison1939-02-25UHC-19556-292267729842935 Main St # 964, Los Angeles, CA0.24Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-133717ENRJonathan M Reed2006-09-05UHC-76563-94—1453 Valley View Dr, Dallas, TX, 752080.24Name split from “Last, First”Two-digit birth yearCity re-casedState name converted to code+4 more
PRV-26752PRVBenjamin H Brooks2008-12-09UHC-58222-55—9416 Desert Sky Blvd Apt 17, San Diego, CA, 921480.24Two-digit birth yearPhone missing area codeUnit split from streetStreet suffix standardised+4 more
ENR-115058ENRIsabella Warren—UHC-43568-3381379538401834 Cedar Ln, Denver, CO, 802170.24Name re-casedDate of birth missingSSN last four extractedStreet suffix standardised+4 more
PRV-22591PRVMichelle Sullivan1950-10-26UHC-09307-18—2442 Market St # 859, Dallas, TX, 752550.24Name split from “Last, First”Phone missing area codeMember ID reformattedUnit split from street+4 more
PRV-22154PRVAmber Green1981-11-20UHC-91347-12—6965 Baseline Rd, Charlotte, NC, 282690.24Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-425685CLMAlexander G Mason—UHC-72900-81—1686 Oak St, Mesa, AZ0.24Middle initial moved out of first nameDate of birth missingStreet suffix standardisedAddress re-cased+4 more
ENR-110008ENRMei X Moreno—UHC-80082-09—7435 Church St, Houston, TX, 770340.24Name split from “Last, First”Date of birth unreadablePhone missing area codeStreet suffix standardised+4 more
TPA-63076TPADorothy Gray2001-09-19——1611 Market St # 488, Denver, CO0.24Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+4 more
PRV-25962PRVCarl Mruphy1955-08-03UHC-75191-4159934232433504 Harbor Blvd Apt 27, Tucson, AZ0.24Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-124066ENRBilly K Gardner1991-12-14UHC-78599-3639588165454565 Ocean Ave, San Antonio, TX, 782860.24Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-139538ENRSamantha N Howard1955-11-11UHC-54388-2741980411049210 Park Pl Apt 31, Phoenix, AZ0.24Middle initial moved out of first namePhone reformattedSSN last four extractedUnit split from street+4 more
CLM-409449CLMBobby Hernandez1974-07-03——6500 Harbor Blvd, Orlando, FL, 328490.24Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more
ENR-109232ENRBrenda Wells1997-08-04UHC-29827-1936677732493625 Willow Ct, Scottsdale, AZ, 852130.24Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
TPA-61532TPAStpehen Warren1955-06-13——5076 Apache Blvd, Scottsdale, AZ, 852670.24Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-112676ENRAlice Bennett1981-10-20UHC-05340-6441126566332277 Pine Dr # 829, Dallas, TX0.24Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-114189ENRNicole Richardson2008-09-22UHC-06257-82—2529 Canyon Rd Apt 30, Houston, TX0.24Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+4 more
CLM-405374CLMSara Ray1970-06-23——2228 Jefferson Ave, Las Vegas, NV0.24Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-128977ENREric Q Hudson2008-12-03UHC-87974-5973052046188745 Church St # 311, Minneapolis, MN0.24Middle initial moved out of first nameName re-casedUnit split from streetStreet suffix standardised+4 more
ENR-107514ENRLuis K Richardson1990-06-10UHC-29830-2087677523847253 Elm St # 531, Los Angeles, CA, 900800.24Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-129206ENRMaria I Jones1981-12-28UHC-59633-2460897853125204 Spring St, Chandler, AZ0.24Name split from “Last, First”Two-digit birth yearPhone reformattedSSN last four extracted+4 more
CLM-423736CLMAlanJunk1972-10-05UHC-77689-96—2288 Sunset Blvd, Eden Prairie, MN0.24Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+4 more
CLM-404452CLMRussell Davis1962-06-08UHC-21001-65—1029 Spring St, Columbus, OH, 432020.24Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+4 more
TPA-58574TPADebra Cox1993-06-22UHC-62132-15—8967 Desert Sky Blvd Apt 31, Columbus, OH0.24Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-408078CLMMelissa Gardner—UHC-81275-406383769295778 Apache Blvd Apt 17, Austin, TX0.24Date of birth missingPhone reformattedSSN last four extractedUnit split from street+4 more
ENR-105177ENRDenise G Holmes1959-01-03UHC-60464-6954084401573183 Highland Ave # 984, Dallas, TX, 752140.24Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-424881CLMMitchell Sarah1992-09-26UHC-43687-13—8532 Oak St # 782, Eden Prairie, MN0.24Name split from “Last, First”Two-digit birth yearUnit split from streetStreet suffix standardised+4 more
ENR-103412ENRKathleen Hanson—UHC-09595-2125956147101114 Grand Ave, Gilbert, AZ0.24Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-103411ENRKathleen Hanson—UHC-09595-2125956147101114 Grand Ave, Gilbert, AZ0.24Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-130028ENRLaura Anderson—UHC-17588-7164269076163129 Sage Ct # 297, Nashville, TN, 372920.24Name split from “Last, First”Date of birth missingPhone reformattedUnit split from street+4 more
CLM-407596CLMBeverly Phillips1945-08-19UHC-74481-70—996 River Rd, Nashville, TN, 372140.24Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+4 more
100,000 rows, page 3 of 2,000PreviousNext