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-126866ENRJose Gibson1990-06-22UHC-92557-223799991748253 Oak St, San Diego, CA, 921940.54Date of birth reformattedPhone reformattedSSN last four extractedZIP+4 trimmed+1 more
CLM-423835CLMAlan Schmidt1992-10-27——5248 Canyon Rd, Minneapolis, MN, 554410.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-409696CLMCarlos Chavez1943-08-28—25068688342256 Sunset Blvd, Orlando, FL, 328510.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-118283ENRChristina F Owens1984-12-01UHC-32060-5551132120852607 Spring St, Miami, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-124632ENRSean Dean2007-04-28UHC-44580-15—592 Bayshore Dr Apt 1, Houston, TX, 770790.54Name split from “Last, First”Date of birth reformattedUnit split from streetState name converted to code+1 more
CLM-414720CLMLiz S Gutierrez—UHC-77937-50—7839 Willow Ct, San Antonio, TX, 782140.54Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-110378ENRKyle P Mason1952-03-09UHC-06799-9485455931915448 Ocean Ave, Denver, CO0.54Name split from “Last, First”Phone reformattedZIP missingGender normalised+1 more
CLM-425961CLMMartha Ellis1988-04-26UHC-36344-06—6810 Grand Ave, Denver, CO0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
PRV-21754PRVHelen Oliver1953-06-11UHC-09294-96——0.54Name split from “Last, First”Phone missing area codeMember ID reformattedGender normalised+1 more
ENR-131767ENRJordan I Sims1976-10-19UHC-55681-8939330769526337 Main St, San Antonio, TX, 782180.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52029TPAAlexander Allen1972-06-07——6316 Spring St, Tucson, AZ, 857130.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-427894CLMAaron Knight1983-07-13——8293 Spring St, Nashville, TN, 372190.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-57846TPAWei Shaw1947-06-24——5446 Market St, Plano, TX0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-101256ENRCristian B Knight—UHC-56122-73—5667 Broadway, San Antonio, TX0.54Date of birth missingCity re-casedState name converted to codeZIP missing+1 more
TPA-63824TPABrittany Jenkins1948-10-02—84557394594783 Ocean Ave, Charlotte, NC, 282730.54Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+1 more
ENR-133088ENRDiego O Anderson1988-08-17UHC-62497-7782966170564945 Canyon Rd Apt 30, Houston, TX, 770120.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-142944ENRHelan Grant1960-12-26UHC-36560-363578612308135 Lake View Rd, Tucson, AZ, 857600.54Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
ENR-101208ENRJoe H Romero1978-01-13UHC-67411-72—6458 Highland Ave, Jacksonville, FL, 322740.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-112415ENRAhmed T Le2003-06-10UHC-34122-14—1420 Washington St, Las Vegas, NV, 891250.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-120045ENREmily Contreras1984-11-12UHC-92691-0540198514431247 Baseline Rd, San Antonio, TX, 782200.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-128714ENRTerry Hawkins1953-07-21UHC-65368-0998851141929206 Spring St Apt 28, San Antonio, TX, 782770.54Name re-casedPhone reformattedUnit split from streetState name converted to code+1 more
ENR-108993ENREugene Fisher1969-09-25UHC-45550-4240971579538143 Baseline Rd Apt 36, Chandler, AZ, 852580.54Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+1 more
ENR-125239ENRCheryl C Woods1970-12-19UHC-99601-9892047318916217 Lake View Rd, Minneapolis, MN, 554480.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-124976ENRCharles Sullivan1963-10-07UHC-02731-7882666772593599 Maple Ave, Orlando, FL, 328580.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
TPA-53533TPAJoe Coleman1952-07-16—21361320675241 Cedar Ln, Mesa, AZ0.54Two-digit birth yearPhone reformattedState name converted to codeZIP missing+1 more
TPA-59596TPAKatherine Wilson1991-03-22——9140 Union St, Nashville, TN, 372720.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-429562CLMStephanie Yang2002-09-03——6020 Ocean Ave, Charlotte, NC, 282500.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
TPA-51804TPAChritsina Austin1968-05-12——1879 Forest Ave Apt 39, Orlando, FL, 328800.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-115600ENRRger X Montgomery—UHC-06433-8938321141968238 Sunset Blvd, Miami, FL0.54Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+1 more
CLM-414692CLMDanielle Frranklin1970-02-18UHC-03800-71—7777 Market St, Jacksonville, FL, 322250.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-414693CLMDanielle Frranklin1970-02-18UHC-03800-71—7777 Market St, Jacksonville, FL, 322250.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-419989CLMJulia Mason1972-01-02——2791 Elm St, Plano, TX, 750380.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-141190ENRChristna Bowman1990-10-08UHC-26516-085475891740722 Cedar Ln, Austin, TX, 787240.54Name split from “Last, First”Two-digit birth yearPhone reformattedSSN last four extracted+1 more
ENR-115418ENRZachary Henry—UHC-50301-6356064210924745 Palm Dr, Glendale, AZ, 853310.54Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+1 more
PRV-28938PRVLinda Thomas2008-07-21——1820 Valley View Dr, Mesa, AZ, 852150.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-120890ENRYuki Hughes2004-12-26UHC-05636-4052988387374661 Market St, Columbus, OH, 432070.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-106326ENRAnn T Blel1956-02-23UHC-51687-65—712 Indian School Rd, Mesa, AZ, 852580.54Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-117859ENRPauul A Bradley2005-01-19UHC-81814-3782531653943539 Ocean Ave # 665, San Antonio, TX0.54SSN last four extractedUnit split from streetCity re-casedZIP missing+1 more
CLM-431392CLMJerry Roberts2005-11-21———0.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
ENR-101898ENRGerald Roberts—UHC-67087-6184996437284789 Baseline Rd # 864, Seattle, WA, 981560.54Name re-casedDate of birth missingPhone reformattedUnit split from street+1 more
ENR-140220ENRFrances L Burke2000-04-23UHC-81574-0676674353442627 Desert Sky Blvd, Mesa, AZ, 852700.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-141497ENRLaura J Nichols—UHC-18482-5151933024106981 Willow Ct, Denver, CO, 802810.54Name re-casedDate of birth missingMember ID reformattedSSN last four extracted+1 more
ENR-100838ENRHarold McDonald2006-09-18UHC-00925-1081652950931397 Bayshore Dr, Orlando, FL, 328320.54Name split from “Last, First”Date of birth reformattedState name converted to codeGender normalised+1 more
ENR-109157ENRPriya P Webb1983-06-28UHC-01077-3239529175512650 Oak St # 165, Chandler, AZ, 852140.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-25134PRVAndy Johnson1988-02-15——845 Pine Dr, Plano, TX, 750130.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-140874ENRJoshua J Watson1989-01-28UHC-57517-2972738536785300 Lake View Rd, Atlanta, GA, 303660.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-403240CLMKayla Ferguson2005-06-19UHC-37431-5165349575063533 Grand Ave, Las Vegas, NV, 891180.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
TPA-61706TPAThomas Sims1971-03-19——4750 Grand Ave Apt 26, Orlando, FL, 328980.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-113650ENRSamuel X Wislon1965-03-08UHC-34455-894118906679866 Forest Ave, Tempe, AZ, 852900.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-126632ENRMartha Y Nichols1989-04-27UHC-63051-72—1787 Jefferson Ave, Mesa, AZ, 852400.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
100,000 rows, page 210 of 2,000PreviousNext