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-428672CLMJordan Wood2004-05-05——7709 Park Pl, Dallas, TX0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-420290CLMSarah Adams2006-06-09UHC-57106-30—2699 Canyon Rd # 140, Fresno, CA, 937840.48Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
PRV-21278PRVRussell D Davis1962-06-08——1029 Spring St, Columbus, OH0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-108317ENRMegan U Baker1994-01-06UHC-45792-2859647080075007 Bayshore Dr, Nashville, TN, 372610.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
TPA-55063TPALucia Bailey1938-08-26——5146 Meadow Ln, Plano, TX, 750540.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
TPA-59329TPASteven R Price1939-01-16—80640485582043 Grand Ave, Houston, TX, 770620.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58929TPAGerald Gardner1952-06-01—34148827202245 Meadow Ln, Charlotte, NC0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61639TPAAhmed Carter1980-10-01—81232569936189 Valley View Dr, Atlanta, GA, 303310.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-406181CLMArjun Wang1953-11-17—34530242638871 Lincoln Way, Las Vegas, NV, 891610.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-411371CLMOlivia J Padilla1995-03-16UHC-81861-1261084928318451 Camelback Rd, Austin, TX0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-53474TPAJennifer Moore1994-12-06—41639017723483 Church St, San Diego, CA, 921520.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56548TPAPeeter Gilbert1961-12-23—31825301044458 Canyon Rd Apt 33, Tucson, AZ0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-103410ENRDanieelle Mendez1958-05-25UHC-12593-5959437951809769 Palm Dr, Gilbert, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140255ENRJudith Schultz1988-10-24UHC-26690-1627456626701867 Pine Dr, Houston, TX, 770770.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431050CLMLawrence E Hansen1988-02-04——2358 Meadow Ln Apt 21, Miami, FL, 331030.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-142487ENRKayla Z Maldondao1992-01-10UHC-94753-4245392964604114 Ridge Rd, Austin, TX, 787980.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-140863ENRPhilip H Bradley1947-05-21UHC-22562-1594129656488709 Palm Dr, Jacksonville, FL, 322100.48Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-105516ENRJoyce I Ferguson1979-11-03UHC-67185-92—7688 Park Pl, Orlando, FL, 328090.48Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
CLM-418649CLMBilly Weaver1953-05-24UHC-92169-3565380225771760 Pine Dr Apt 6, Sacramento, CA, 958740.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-55447TPABobby A Schultz1958-07-18——1371 Maple Ave, Seattle, WA, 981980.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-409612CLMVirginia Martin1953-05-18——5201 Apache Blvd, Orlando, FL, 328750.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-128369ENRKathleen Riley1959-03-10UHC-28508-5453440582686739 Central Ave, Las Vegas, NV, 891600.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122405ENRPatrick W Patel—UHC-39683-2239639545502331 Apache Blvd, Houston, TX, 770990.48Middle initial moved out of first nameDate of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-107555ENRNathan D Yang1987-01-17UHC-14113-0143762067187782 Oak St, Minneapolis, MN0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-111528ENREmma Nunez—UHC-01335-7471072115085096 Washington St, Fresno, CA, 937970.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133060ENRHowell Michael1990-10-17UHC-61004-0633922350797155 Palm Dr, Tempe, AZ, 852070.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-112752ENRKelly E Flores1971-04-25UHC-51326-6432324492634492 Park Pl, Scottsdale, AZ, 852580.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-414633CLMKelly Kim1957-09-20—94275666307517 Main St, Seattle, WA, 981680.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-100298ENRKelly U Rodriguez1976-02-12UHC-32227-1880686344361765 Cedar Ln Apt 21, Jacksonville, FL, 322980.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-430090CLMWalter Burns———739 Valley View Dr, Seattle, WA, 981830.48Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+4 more
ENR-133550ENRChristine Brooks1953-12-25UHC-05235-3274323869893231 Cedar Ln, Seattle, WA0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133549ENRChristine Brooks1953-12-25UHC-05235-3274323869893231 Cedar Ln, Seattle, WA0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416424CLMMelissa Anderson—UHC-00123-9532760357608861 Canyon Rd, Atlanta, GA, 303620.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-140092ENRSandra Q White2005-05-03UHC-13421-4094854492742142 Indian School Rd, Atlanta, GA, 303800.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-418900CLMHeather Vazquez1986-11-05——3112 Grand Ave, Orlando, FL, 328230.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-418901CLMHeather Vazquez1986-11-05——3112 Grand Ave, Orlando, FL, 328230.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-421283CLMShirley L Morris1985-03-17UHC-89888-33—7543 Canyon Rd, Atlanta, GA, 303750.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24613PRVAisha G Anderson1978-10-20UHC-70821-83—2830 Indian School Rd, Plano, TX0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-106742ENRJames Henderson1975-12-19UHC-00613-9047865083816458 Meadow Ln # 469, Glendale, AZ, 853050.48Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+4 more
ENR-107472ENRBrandon K Phillips1981-09-27UHC-77750-5729281385215208 Pine Dr, Houston, TX, 770610.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114362ENRChristine H Black1998-05-15UHC-98661-8732025716236515 Central Ave, Gilbert, AZ, 852230.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58416TPAMark Hoffman1993-10-18——7240 Union St, Nashville, TN, 372280.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102545ENROmar X Dixon1973-07-09UHC-94376-275108418557636 Meadow Ln Apt 29, Tempe, AZ, 852800.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-417823CLMLarry Lynhc1992-07-16—98199216874992 Valley View Dr, San Antonio, TX, 782750.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-132602ENRSara Davis1977-04-06UHC-11295-0131448875258848 Willow Ct Apt 18, Las Vegas, NV, 891720.48Name re-casedPhone reformattedSSN last four extractedUnit split from street+4 more
ENR-132603ENRSara Davis1977-04-06UHC-11295-0131448875258848 Willow Ct Apt 18, Las Vegas, NV, 891720.48Name re-casedPhone reformattedSSN last four extractedUnit split from street+4 more
ENR-113375ENRCarol S Kim2007-10-18UHC-04642-403627918851565 Meadow Ln # 962, Tucson, AZ, 857280.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-421026CLMShirley F Graham2005-11-13UHC-24244-7542153227009296 Maple Ave, Sacramento, CA, 958510.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139180ENRJulie Pena1994-12-14UHC-64751-1982964318399289 Ridge Rd, Atlanta, GA, 303090.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21295PRVJose Jackson1981-11-23—75865410922459 Ridge Rd # 269, Dallas, TX, 752440.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
100,000 rows, page 80 of 2,000PreviousNext