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-109144ENRSamantha Romero1995-12-10UHC-89166-23—3469 Mountain View Dr, Scottsdale, AZ, 852920.50Date of birth reformattedPhone missing area codeMember ID reformattedState name converted to code+3 more
CLM-418813CLMMariana Ferguson1992-09-24UHC-69580-2640950104913155 Pine Dr # 264, Jacksonville, FL, 322950.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-421966CLMJeffrey Harrison———6635 Canyon Rd, Las Vegas, NV, 891890.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-120831ENRJulie Ellis2004-01-14UHC-65562-6452190714404689 Highland Ave, Atlanta, GA, 303020.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-61122TPASofia Guerrero1958-11-24——748 Cedar Ln Apt 31, Eden Prairie, MN, 553810.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-422191CLMAlexander Wells1997-01-06UHC-49517-10—5592 Broadway, Los Angeles, CA, 900670.50Name re-casedTwo-digit birth yearAddress re-casedCity re-cased+3 more
CLM-411619CLMOlivia G Espinoza1998-06-06UHC-99981-1867297381634233 Apache Blvd # 461, Fresno, CA, 937300.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-408445CLMBobby Jacobs1942-09-25UHC-37001-9829494386311545 Jefferson Ave # 934, San Antonio, TX, 782850.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-417970CLMFrances Y Hanson—UHC-45521-79—6548 Willow Ct, Phoenix, AZ, 850410.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-106576ENRSamuel Cruz1982-01-09UHC-58921-6184872679469457 Church St, Scottsdale, AZ, 852330.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-409746CLMBruce Rios1943-12-01—37286992504181 Baseline Rd, Charlotte, NC0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-23638PRVHiroshi S Mason1963-11-06—85423560094512 Willow Ct Apt 27, Columbus, OH, 432430.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-418156CLMAnthony O Simmons1986-12-03UHC-84844-4145528123838393 Pine Dr, Plano, TX, 750530.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109455ENRMason Mitchell1981-09-23UHC-11047-2283662974548653 Union St Apt 14, Minneapolis, MN, 554970.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-26911PRVJack J Smith1950-07-24UHC-36697-2995668242154569 Spring St, San Antonio, TX, 782470.50Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+3 more
CLM-415572CLMDennis Dominguez1966-12-28UHC-79255-89—7029 Union St, San Diego, CA, 921710.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-64060TPAMichael McDonald1982-07-05——6489 Camelback Rd Apt 17, Gilbert, AZ, 852450.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408777CLMGary Jimenez1976-03-26UHC-29986-9164080899604951 Jefferson Ave Apt 10, Tampa, FL, 336390.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25956PRVLaura Cooper2007-11-04—35965640231831 Willow Ct, San Diego, CA, 921060.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
TPA-55535TPAMateo Brown1938-02-04——5088 Sunset Blvd, Jacksonville, FL, 322960.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-104077ENRJoshua Ferguson1965-08-06UHC-22094-518657131489352 Park Pl Apt 18, Fresno, CA, 937320.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
TPA-63176TPAAadm Sanders2005-02-09——5341 Ridge Rd, Tempe, AZ, 852060.50Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-110150ENRSteven Y Park1941-01-23UHC-23541-9755067396698298 Main St # 622, Sacramento, CA, 958450.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125565ENRDebra Cox1993-06-22UHC-62132-1528290831258967 Desert Sky Blvd, Columbus, OH, 432970.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406794CLMJulie Pena———59 Mountain View Dr, Tucson, AZ, 857390.50Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-63897TPAHeather Kim2006-01-04——4203 Harbor Blvd # 558, Tempe, AZ, 852550.50Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+3 more
CLM-423348CLMStephen Fernandez1944-08-17UHC-00238-9094834542675103 Lake View Rd, Phoenix, AZ, 850720.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
PRV-21941PRVLori Q Lane2006-03-28UHC-27982-3283045970425174 Church St Apt 34, Atlanta, GA, 303920.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-139747ENRCynthia C Williams—UHC-21317-7245720671955152 Valley View Dr, Orlando, FL, 328960.50Name split from “Last, First”Date of birth missingPhone reformattedMember ID reformatted+3 more
PRV-29356PRVYuki R Hunt1998-12-09—58244162145754 Main St # 170, Tucson, AZ, 857800.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130195ENRDennnis Phillips1996-12-07UHC-63082-947066237718725 Grand Ave, Orlando, FL0.50Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+3 more
TPA-53556TPAMelissa Gardner1949-02-05—6383769295778 Apache Blvd, Austin, TX, 787580.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-60793TPAElijah Jackson1991-08-23—68088792512903 Lake View Rd # 551, Fresno, CA, 937860.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-123269ENRLauren Scott2002-02-27UHC-72511-19—4131 Central Ave Apt 12, San Antonio, TX, 782350.50Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
PRV-26820PRVWatkins N Amber1976-10-16UHC-11916-1129546106599383 Baseline Rd, Tempe, AZ, 852920.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-61515TPADorothy Peterson1947-10-04——1631 Camelback Rd, Phoenix, AZ, 850620.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
ENR-142727ENRNanky X Marquez1974-07-23UHC-40161-6479674285829403 Sage Ct, Glendale, AZ, 853830.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
PRV-20441PRVBilly Lopez1955-10-08—41539725203626 Sage Ct Apt 22, Seattle, WA, 981250.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-142323ENRAsiha Gardner1969-09-06UHC-26182-0882978646188538 Hillcrest Rd # 265, Sacramento, CA, 958840.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-142228ENRDiane Fowler1962-09-21UHC-21142-8063622364892837 Park Pl, Tampa, FL, 336650.50Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-102517ENRRachel T Burns1978-10-24UHC-77800-01787281137847 Union St, Columbus, OH, 432550.50Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-63467TPAEvelyn F Hudson1989-06-07——1021 Grand Ave, Plano, TX, 750340.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-102504ENREmma Munoz1994-09-16UHC-82412-8131452833982062 Jefferson Ave, Dallas, TX, 752130.50Two-digit birth yearPhone reformattedMember ID reformattedSSN last four extracted+3 more
ENR-122868ENRPaul I Woods2007-09-24UHC-41066-5756697062308824 Spring St, Scottsdale, AZ, 852960.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128535ENRNancy Graham1959-03-19UHC-43007-2270946051289784 Sunset Blvd Apt 36, Jacksonville, FL, 322120.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-101808ENRNathan Montgomery2000-04-18UHC-06179-3697955008801072 Pine Dr, Phoenix, AZ, 850530.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423114CLMJonathan V Santiago1966-04-23——3230 Market St, San Diego, CA, 921850.50Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+3 more
ENR-102562ENRLarry G Burke—UHC-43331-5294282235911754 Ridge Rd # 291, Mesa, AZ, 852900.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
ENR-136586ENRKyle Weber1987-08-09UHC-48005-0396836459389279 Forest Ave, San Diego, CA, 921820.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-54301TPACharlotte Greene———9599 Park Pl, San Antonio, TX, 782600.50Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 98 of 2,000PreviousNext