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
PRV-21965PRVNunez Jacqueline1947-06-14UHC-70312-0645927463672269 Sage Ct, Glendale, AZ, 853420.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137796ENRHannah Howard1942-09-21UHC-78722-8146590463255163 Apache Blvd, Miami, FL0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-28667PRVAustin I Parker1952-07-03UHC-47167-0732680669713166 Spring St, Miami, FL, 331230.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62943TPAKyle A Lane1981-11-07UHC-74857-31—9320 Willow Ct # 758, Dallas, TX, 752090.50Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more
PRV-21966PRVJessica Johnson1979-10-05UHC-65449-185357954278222 Harbor Blvd, Las Vegas, NV0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110942ENRJulia Jensen1958-06-21UHC-89834-3838946187076824 Broadway, Phoenix, AZ, 850140.50Name split from “Last, First”Date of birth reformattedMember ID reformattedZIP+4 trimmed+3 more
PRV-27863PRVPaul Coleman—UHC-62015-2874181465808638 Main St Apt 16, Miami, FL, 331700.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-118077ENRVincent H Mills1977-06-11UHC-69802-9646024378862548 Market St, Glendale, AZ, 853090.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-116970ENRGerald M Pena1978-10-23UHC-42304-14—9382 Bayshore Dr # 723, Phoenix, AZ, 850380.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421574CLMMadison E Moore2001-01-14UHC-36940-63—6393 Grand Ave, Tempe, AZ, 852600.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-424059CLMKyle Black1992-11-16——7088 Hillcrest Rd, San Antonio, TX, 782450.50Name split from “Last, First”Date of birth reformattedCity re-casedState name converted to code+3 more
CLM-410377CLMArjun Lerson1991-01-24UHC-89929-2498544054541443 Mesa Dr, Plano, TX, 750590.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101769ENRJose B Olson2003-05-28UHC-32021-7697682704095299 Elm St, Jacksonville, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104885ENRAlexander J Marshall1969-09-02UHC-93972-2694554774689664 Highland Ave, Dallas, TX, 752300.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-132198ENRArthur Wright1982-02-07UHC-04266-22—8322 Main St, Tampa, FL, 336550.50Name re-casedTwo-digit birth yearSSN last four extractedCity re-cased+3 more
TPA-63768TPADot Castillo1973-03-26UHC-27256-0985299325399595 Harbor Blvd, Plano, TX, 750670.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-127491ENRPatrick Q Henderson1968-09-17UHC-63091-0470895609375981 Park Pl, Tampa, FL, 336450.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-63577TPAJanice West1955-07-13——6528 Main St, Scottsdale, AZ, 852350.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-118572ENRJessicca Wang2003-01-20UHC-04085-6146533254595652 Meadow Ln, Sacramento, CA, 958390.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-60482TPAAlan Schmidt1992-10-27—39330054755248 Canyon Rd Apt 26, Minneapolis, MN0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-108721ENRSingh S Brenda1999-05-10UHC-58435-5167624208777872 Indian School Rd, Glendale, AZ, 853890.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-103964ENRTerry D Lane1969-03-27UHC-59619-2774232454532703 Hillcrest Rd, Los Angeles, CA, 900710.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427903CLMRebecca Y Bennett1961-04-14UHC-24020-26—5489 Elm St, Tempe, AZ, 852840.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134800ENRCheryl Hernandez1999-11-11UHC-59365-232177932044275 Park Pl # 704, Atlanta, GA, 303760.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-429828CLMKelly Rivera1941-09-27UHC-23051-0835549542547314 Baseline Rd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131226ENRLaurn L Johnston1983-11-27UHC-59566-9567834631287541 Mountain View Dr Apt 20, San Antonio, TX, 782010.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125912ENRJack A Wallace1997-11-15UHC-74691-1088245007772153 Elm St, Gilbert, AZ, 852900.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122804ENRIsabella Cook2003-12-09UHC-20907-1940632236801808 Elm St, Eden Prairie, MN, 553860.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407063CLMChristopher Duncan2003-06-26UHC-75482-8787058895025806 Oak St, Dallas, TX, 752230.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61584TPAHeather Rios—UHC-67463-2364729547796475 Desert Sky Blvd # 668, Sacramento, CA, 958270.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
TPA-61585TPAHeather Rios—UHC-67463-2364729547796475 Desert Sky Blvd # 668, Sacramento, CA, 958270.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
CLM-429056CLMBilly F Wheeler1971-12-03—78745725007819 Willow Ct, Austin, TX, 787130.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60469TPADaniel Owens1995-09-12UHC-62595-38—2304 Church St, Minneapolis, MN0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115812ENRLauren Olsno1990-03-18UHC-21681-2564427615213523 Indian School Rd, Jacksonville, FL, 322600.50Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-403749CLMHenry F Litle1944-12-26UHC-93359-73—266 Camelback Rd, Atlanta, GA, 303610.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
ENR-142976ENRAmanda M Arnold1995-04-08UHC-03979-0153570081005631 Sage Ct, Eden Prairie, MN0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409643CLMGerald Nichols1956-12-02—2252722408592 Broadway, Los Angeles, CA, 900920.50Name re-casedPhone reformattedSSN last four extractedZIP+4 trimmed+3 more
PRV-29238PRVMichelle Gonzales1973-12-03UHC-28818-2861993423406915 Church St # 661, Sacramento, CA, 958870.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410672CLMJeffrey Simmons1977-03-08UHC-64891-4788094836266175 River Rd, Tempe, AZ, 852400.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400027CLMVincent Oliver1973-05-14UHC-16577-40—6938 Apache Blvd, San Diego, CA0.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121485ENRBarbara R Diaz1981-12-13UHC-33594-9636248805238743 Oak St, Gilbert, AZ, 852990.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107167ENRCheryl M Hill1949-12-23UHC-69418-0779598831433321 Mountain View Dr, Chandler, AZ, 852130.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51792TPACamila D Alvarado——53855790462575 Park Pl, Charlotte, NC, 282010.50Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-138427ENRJoseph I Riley1974-11-28UHC-21875-3451455022946915 Hillcrest Rd, Gilbert, AZ, 852230.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404938CLMAnn B Ryan2003-08-24—8399494266423 Oak St, Las Vegas, NV0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-417757CLMCarlos B Gibson1939-07-05—32331658208326 Cedar Ln, Tucson, AZ, 857720.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-427181CLMJacob J Patterson1994-09-20UHC-78868-43—3426 Maple Ave # 570, Dallas, TX, 752780.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-419195CLMBruce Santos1996-02-23—36023623724163 Ocean Ave, Miami, FL, 331220.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100770ENRVirginia K Hill1962-09-15UHC-08541-98—5020 Ridge Rd # 349, Tampa, FL, 336660.50Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
ENR-115609ENRJohn Y Sanders1999-07-08UHC-07416-2420163764927846 Mountain View Dr, Plano, TX, 750750.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 106 of 2,000PreviousNext