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-107977ENRGeorge Munoz1956-12-23UHC-84709-9137174744181291 Cedar Ln # 923, Tampa, FL, 336050.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-423289CLMHansen Richaard1959-10-08—35058924021452 Cedar Ln Apt 10, Nashville, TN, 372150.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-142214ENRDiane Gordon1974-08-21UHC-37282-96—9704 Sage Ct, Plano, TX0.48Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-126177ENRSamuel N Marquez1995-12-04UHC-23159-562459718161927 Church St, Phoenix, AZ, 850930.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
PRV-29590PRVVirginia W Guerrero1939-07-02UHC-49764-5865274883667836 Ocean Ave, Miami, FL0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104038ENRMegan K Gordon2001-04-14UHC-50440-1779844458145144 Maple Ave Apt 28, Tampa, FL, 336630.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-56825TPAMelissa Espinoza1983-01-01—87572534364879 Jefferson Ave, Tucson, AZ, 857170.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-134863ENRStephen Q Alvarado1990-04-08UHC-69270-127345033997580 Grand Ave, Scottsdale, AZ, 852170.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
ENR-132811ENRGregory V Weaver1940-03-01UHC-54753-15—2147 Hillcrest Rd, Denver, CO0.48Name re-casedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-108837ENRLori J Lucas—UHC-00588-8624481535129365 Palm Dr, Denver, CO, 802880.48Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+4 more
ENR-140211ENRAlexander Fowler1941-11-14UHC-53266-8227951817755555 Bayshore Dr, Sacramento, CA, 958440.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405594CLMCatherine Morrison2008-01-27UHC-23703-76—4880 Ocean Ave, Charlotte, NC, 282730.48Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410455CLMPatrick H Sanchez1955-04-09—21998659888588 Church St, Dallas, TX, 752150.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-20733PRVJulia Ortega——36238245459413 Jefferson Ave, Denver, CO, 802810.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-101665ENRVirginia L Thomas1988-05-17UHC-94590-1591257012931797 Lake View Rd, Gilbert, AZ, 852350.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141060ENRPeggy Watson2007-04-27UHC-53720-0475224041245608 Elm St, Orlando, FL, 328830.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-112945ENROlivia Tran1980-03-18UHC-76853-38—3305 Indian School Rd, Mesa, AZ, 852930.48Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+4 more
ENR-121209ENRChaarles Hunt1970-07-25UHC-19975-8724392835903754 Union St Apt 40, Orlando, FL, 328690.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-103106ENRAlbert I Lane1994-01-16UHC-80551-4568956720623769 Pine Dr, Denver, CO0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-113363ENRWilliam Cnotreras2002-04-08UHC-63728-0420253225153013 Grand Ave, Seattle, WA, 981160.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-419117CLMCynthia B Turner1951-09-10UHC-24518-0228894185638782 Hillcrest Rd, Miami, FL, 331070.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-128496ENRCamila I Adams1985-01-02UHC-65667-704819527172918 Canyon Rd # 488, Tampa, FL, 336970.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-127981ENRCamila G Jaackson1961-05-15UHC-96379-7930785141759839 Lincoln Way, Chandler, AZ, 852210.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-21247PRVTereas N George1971-06-02—49856032091320 Ridge Rd, San Diego, CA, 921240.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130789ENRMatt Roberts1981-08-12UHC-34127-6592138639355944 Bayshore Dr, Las Vegas, NV, 891880.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-137121ENRMichael N Carpenter1995-07-11UHC-99707-65—8019 Market St Apt 13, Plano, TX, 750010.48Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+4 more
PRV-21555PRVArjun Bradley1959-04-16—74195737648435 Bayshore Dr, Gilbert, AZ0.48Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
CLM-426967CLMChristine Delgado1940-08-24UHC-79906-7823281456336770 Baseline Rd, Minneapolis, MN, 554250.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-431227CLMDiego Moreno1957-09-05UHC-06269-7058691190578878 Central Ave, Chandler, AZ, 852680.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-26096PRVCarl Rivera1980-12-03UHC-16910-1739024279615451 Grand Ave Apt 3, Eden Prairie, MN0.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-122318ENRAlice Bailey1960-05-04UHC-91287-1572448406971607 Union St, Phoenix, AZ, 850290.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407730CLMBeverly Padilla1954-10-26UHC-35803-1553953481706136 Park Pl Apt 4, Mesa, AZ, 852250.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-108233ENRMadison Aguilar2001-03-02UHC-63465-6224069336502689 Forest Ave # 113, Mesa, AZ, 852580.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
PRV-26004PRVAmber Wells1939-12-20UHC-53150-30—7373 Jefferson Ave, Chandler, AZ0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-104192ENRPhilip Gray1948-10-06UHC-41519-2585741702249035 Willow Ct, Seattle, WA, 981640.48Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-20694PRVHioshi Lawrence2005-09-10—90755995308338 Cedar Ln # 163, Tucson, AZ, 857970.48Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-127587ENRDebra L Garza1984-04-28UHC-51147-7679837859456588 Ocean Ave, Columbus, OH0.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-136386ENRDeborah O Perkins2002-08-22UHC-87285-0552979698482868 Mesa Dr, Seattle, WA0.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-405644CLMStephen Chavez1993-06-01—43798277883236 Jefferson Ave, San Antonio, TX, 782470.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-119040ENRPatricia K Obrien1968-08-18UHC-18106-84—5502 Valley View Dr, Orlando, FL, 328510.48Name split from “Last, First”Middle initial moved out of first nameName re-casedDate of birth reformatted+4 more
ENR-114090ENRKeith B Olson2006-03-05UHC-20417-559494048924500 Highland Ave, Sacramento, CA, 958280.48Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+4 more
CLM-432741CLMBarbara Marquez2002-02-02UHC-40992-9141755186629446 Hillcrest Rd, San Diego, CA, 921930.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-121148ENRGary G Diaz1989-06-16UHC-46839-1642331480814178 Baseline Rd, Chandler, AZ, 852250.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22859PRVPriyaJunk1949-04-22—57553886317499 Market St, Las Vegas, NV, 891010.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124727ENRLarry Chapman1981-11-16UHC-75031-6025425245943349 Union St, Eden Prairie, MN, 553900.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421780CLMKyle Burs1946-02-23UHC-52612-93—7723 Hillcrest Rd, Tucson, AZ, 857250.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-139467ENRHannah Howell1938-12-24UHC-33142-049762549223550 Palm Dr, Plano, TX, 750330.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-412753CLMPriya Spencer2007-01-27UHC-46670-649653775496252 Apache Blvd, Houston, TX, 770150.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-138703ENRChristopher Davis1986-04-14UHC-15407-2730030321396306 Jefferson Ave, Atlanta, GA, 303010.48Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-109258ENRJeremy K Mitchell2003-04-22UHC-39524-3022950395347007 Camelback Rd, Nashville, TN, 372060.48Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
100,000 rows, page 57 of 2,000PreviousNext