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-408014CLMAna Ortega1951-06-23UHC-19282-90—2539 Palm Dr, Scottsdale, AZ, 852300.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-427134CLMCarolyn Sullivan1992-02-06UHC-26152-569034196631695 Indian School Rd Apt 18, Tempe, AZ, 852800.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-407270CLMPeter W Moore1945-10-03UHC-56208-0823576307561771 Canyon Rd, Miami, FL, 331400.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138846ENRDylan Fernandez2006-08-09UHC-35577-718673533307467 Indian School Rd # 103, Denver, CO, 802340.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-113463ENRJames I McDonald1959-03-20UHC-97198-994352519505209 Mountain View Dr, Fresno, CA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421876CLMMaria H Simpson2008-12-22UHC-29411-66—2468 Union St, Houston, TX, 770560.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102039ENRRonald J Crawforrd1946-11-23UHC-31165-9924644050258237 Apache Blvd Apt 16, San Antonio, TX, 782780.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-107536ENRKyle Dominguez1953-04-28UHC-47896-1928091348751431 Grand Ave Apt 7, Columbus, OH, 432170.48Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+4 more
TPA-60000TPAGregory G Le1939-12-05UHC-77243-5491581640623244 Spring St, San Diego, CA0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-115315ENRBruce Gordon—UHC-76548-6591289513401965 Apache Blvd, Austin, TX, 787120.48Name re-casedDate of birth missingPhone reformattedCity re-cased+4 more
ENR-135766ENRAlan Gray2005-10-03UHC-03446-3437628673994622 Jefferson Ave, Atlanta, GA, 303200.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-111708ENRAnthony Vaga1969-08-01UHC-69881-9662125479817684 Sage Ct, Charlotte, NC, 282070.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-413596CLMAmanda Y McCoy1969-01-12UHC-80480-018678939961428 Mesa Dr # 176, Houston, TX, 770160.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-109102ENRMarilyn Hudson1998-12-27UHC-41649-59—2271 Desert Sky Blvd, Charlotte, NC, 282320.48Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-126083ENRAnn Singh1944-09-18UHC-68432-8223232360491013 Camelback Rd # 671, Fresno, CA, 937200.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-129229ENRJacob O Herrera1943-08-15—92553739573774 Palm Dr, Plano, TX0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402888CLMMark Cole1958-09-01UHC-08276-88—9515 Sunset Blvd, Nashville, TN, 372860.48Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416152CLMNathan Le—UHC-58783-6452191340346482 Forest Ave, Las Vegas, NV, 891820.48Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
TPA-59737TPAJanet Ryan——95588061021484 Mesa Dr, San Antonio, TX, 782030.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136251ENRPhilip Perkins1944-08-04UHC-20874-7786280687296656 Union St # 806, Gilbert, AZ, 852210.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-420405CLMSara Harvey1984-02-18UHC-26372-6062454314628811 Church St, Denver, CO0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141329ENRBecky Q Jones1967-05-27UHC-46908-5375358338037642 Lincoln Way Apt 9, Seattle, WA, 981820.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-415767CLMMazon Castro1957-09-28UHC-01653-7276440396754926 Main St, Austin, TX, 787680.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-432175CLMAnthony Park2001-02-22UHC-76242-392763139632379 Oak St, Dallas, TX, 752310.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-50003TPAJames K Hunter1960-03-14——6535 Bayshore Dr, Orlando, FL, 328320.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
ENR-116879ENRJerry Romero1964-03-24UHC-98312-992679081891855 Lake View Rd, Tucson, AZ0.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-122069ENRPeter Gray1985-08-23UHC-33256-684647764297876 Spring St Apt 31, Los Angeles, CA0.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-431403CLMGary Matthews1945-11-13UHC-27209-5168186657924842 Pine Dr, Charlotte, NC, 282660.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
PRV-26050PRVCarol Ortega1996-01-15UHC-51717-7359678030695241 Central Ave, Tampa, FL0.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-415453CLMLawrence Richards1964-11-21UHC-84652-73—6040 Main St, Columbus, OH, 432360.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418564CLMGeorge Z Li1955-11-01—65225429579770 Jefferson Ave, Atlanta, GA, 303490.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102978ENRJoshua Johnson—UHC-72422-3066579505887815 Maple Ave, Tucson, AZ, 857260.48Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more
CLM-422951CLMBradley Bryant1990-12-16UHC-99924-03—3422 Lake View Rd, Atlanta, GA, 303700.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-119042ENRCarolyn I Herrera1965-07-04UHC-83872-6537570622837974 Washington St, Gilbert, AZ, 852610.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-400543CLMBryan Valdez1986-09-17—51898392145624 Canyon Rd, Columbus, OH, 432730.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104033ENRGerald C Cunningham1951-07-23UHC-47203-8178756775783051 Washington St, Scottsdale, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-428426CLMRachel CJunk1961-03-10——1832 Grand Ave, Seattle, WA, 981540.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-428427CLMRachel CJunk1961-03-10——1832 Grand Ave, Seattle, WA, 981540.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-22864PRVRaymond Payne1967-06-01UHC-06240-9538084789377626 Broadway, Denver, CO, 802720.48Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+4 more
ENR-132964ENRDiana Little1976-07-05UHC-64760-527043619723346 Jefferson Ave, Eden Prairie, MN, 553120.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-64070TPAVincent Riley1964-12-24——1651 Grand Ave, Atlanta, GA, 303810.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-403184CLMGabriel Yang1960-04-14UHC-81771-20—1130 Elm St, Columbus, OH0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-126849ENRRoger L Howard2001-08-11UHC-32346-5792055520679283 Lincoln Way, Nashville, TN, 372090.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-117362ENRDiana A Cooper1952-09-12UHC-80204-7279166805489763 Hillcrest Rd, Las Vegas, NV0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24148PRVPhilip Valdez1996-03-02UHC-84631-45—713 Camelback Rd Apt 24, Denver, CO, 802340.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-402040CLMMark Palmer2008-07-25—66045130546191 Oak St Apt 3, Gilbert, AZ, 852980.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-117076ENRLauren S Valdez1944-06-21UHC-73108-2376999244251720 Market St # 963, Tucson, AZ, 857660.48Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
TPA-54682TPACarlos Thompson2002-01-26——7115 Apache Blvd Apt 38, Tampa, FL, 336520.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-142565ENRAlice L Adams2003-11-05UHC-37979-98—2201 Canyon Rd, Gilbert, AZ, 852140.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
PRV-20830PRVTyler U Crawford1968-08-07UHC-49693-6472550150119252 Ridge Rd, Plano, TX, 750950.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 75 of 2,000PreviousNext