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-125217ENRKeith B Berry2006-04-02UHC-31227-735234439026810 Valley View Dr, Mesa, AZ, 852620.34Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more
TPA-53923TPABrandon Hanson1958-11-20—66329745635096 Mesa Dr, Los Angeles, CA0.34Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-53924TPABrandon Hanson1958-11-20—66329745635096 Mesa Dr, Los Angeles, CA0.34Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-101241ENRTheresa J Santiago1976-03-28UHC-54775-9045453588899056 Bayshore Dr Apt 29, Phoenix, AZ, 850290.34Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
CLM-419862CLMWayne D Campbell1980-01-10UHC-79401-10—8279 Desert Sky Blvd # 844, Columbus, OH, 432310.34Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+5 more
CLM-419861CLMWayne D Campbell1980-01-10UHC-79401-10—8279 Desert Sky Blvd # 844, Columbus, OH, 432310.34Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+5 more
ENR-103982ENRTyler Kelley1962-11-01UHC-71559-7037091525392984 Hillcrest Rd, Tucson, AZ, 857510.34Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-133554ENRLarry K Grant1947-01-22UHC-85640-98—5685 Washington St, Austin, TX, 787850.34Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+5 more
CLM-403732CLMJessica Alexander1939-07-15UHC-53980-3660447014023491 Pine Dr # 497, Atlanta, GA, 303230.34Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more
PRV-27787PRVAnna Ruiz1956-06-02—48434393108106 Canyon Rd, Atlanta, GA, 303900.34Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-108485ENREmma C Mejia1988-07-09UHC-62351-2233223114363206 Baseline Rd, Tucson, AZ0.34Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-409064CLMGloria Murray1944-07-13UHC-15058-9244480560284605 Cedar Ln, Chandler, AZ, 852180.34Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-414299CLMMarilyn Hicks1943-02-26UHC-38790-5620298909594833 Mountain View Dr Apt 30, Austin, TX, 787990.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
ENR-130240ENRArjun Lucas1978-02-04UHC-66384-3866435241135563 Hillcrest Rd, Houston, TX0.34Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-119137ENRJoice A Tran1939-04-24UHC-45030-1354462905683124 Grand Ave # 749, Miami, FL, 331620.34Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+5 more
TPA-50477TPAHiroshi Hernandez——75855668281528 Central Ave, Chandler, AZ, 852980.34Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+5 more
TPA-58188TPALuis U Adams1983-06-10—72423373816541 Palm Dr, Phoenix, AZ, 850780.34Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-415884CLMChristopher Nguyen1994-01-27UHC-96313-1988781755001738 Meadow Ln # 202, Tempe, AZ0.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
ENR-121107ENRDiego Vasquez1958-07-25UHC-30867-0397428145558166 Meadow Ln, Miami, FL0.34Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-403574CLMSandra N Harper—UHC-48277-6880124660037685 Jefferson Ave, Denver, CO0.34Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more
ENR-112665ENRJoseph V Williams—UHC-89119-1355994030136312 Hillcrest Rd, Mesa, AZ, 852200.34Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more
PRV-22221PRVJeff Jensen——27646217896869 Willow Ct, Tempe, AZ, 852870.34Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-423468CLMAmy Jenkins1970-03-01UHC-40298-28—5235 Bayshore Dr, Eden Prairie, MN0.34Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-431940CLMDiego P Dominguez1985-01-01UHC-90646-41—3937 Lake View Rd, Austin, TX, 787840.34Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-123283ENRWilliam F Tucker1940-03-14UHC-99156-217072370717136 Elm St, Minneapolis, MN0.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-27979PRVElizabeth Z Stephens1940-06-08—84672065709528 Meadow Ln, Austin, TX0.34Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-129592ENRGeorge Flores1959-01-16UHC-44693-8870026948398251 Pine Dr Apt 10, Jacksonville, FL, 322800.34Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+5 more
CLM-401171CLMCarl Cole1943-08-19UHC-70721-5255129753817349 Ocean Ave, Denver, CO0.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-129194ENRKathleen M Grant1981-01-04UHC-82215-7745373919786912 Spring St, Eden Prairie, MN0.34Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-105285ENRTyler Wiliams2003-10-05UHC-13381-0782222006957374 Highland Ave, Seattle, WA, 981980.34Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-140945ENRStephen K Robertson1974-04-26UHC-28049-09—4568 Canyon Rd, Fresno, CA, 937350.34Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+5 more
ENR-140846ENRJean X McCy1963-12-09UHC-59244-395507371454343 Maple Ave, Tampa, FL0.34Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-105947ENRSingh Joyce1988-02-13UHC-26755-6365343011185016 Union St, Plano, TX, 750290.34Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-138932ENRRachel Lawson1999-11-24UHC-70107-8644265664755424 Washington St, Austin, TX, 787400.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-406211CLMPamela Hill1943-02-01UHC-49585-16—2806 Forest Ave, Fresno, CA, 937490.34Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+5 more
CLM-404808CLMMichelle I Fowler1981-09-08UHC-63795-99—2988 Central Ave, Phoenix, AZ, 850150.34Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-27943PRVIsabella Singh1949-11-14UHC-14951-40—8764 Baseline Rd # 853, Columbus, OH0.34Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+5 more
CLM-420830CLMSean N Chapman2002-02-14—59989981296702 Church St Apt 7, Minneapolis, MN0.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
PRV-24421PRVBradley Vasquez2002-07-21UHC-93444-3189825518198359 Market St Apt 29, Tampa, FL, 336070.34Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
CLM-426467CLMLuis Mendoza1994-01-21UHC-97432-0155161708522719 Church St, Chandler, AZ0.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-120967ENRJanice Owens1954-05-25UHC-11376-27—1736 Harbor Blvd, Jacksonville, FL, 322840.34Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-119996ENRAndy O Snyder1994-12-28UHC-14716-7826342780805242 River Rd, Eden Prairie, MN, 553580.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-407483CLMJeremy R Patel1990-06-20UHC-07309-1128187592339506 Meadow Ln, Miami, FL, 331640.34Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
CLM-407482CLMJeremy R Patel1990-06-20UHC-07309-1128187592339506 Meadow Ln, Miami, FL, 331640.34Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
TPA-62335TPANicholas Jackson1987-08-03—57736942181109 Maple Ave # 558, Chandler, AZ, 852600.34Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
ENR-132000ENRBryan R Romero1993-02-04UHC-78069-8693452252716621 Baseline Rd Apt 25, Gilbert, AZ, 852560.34Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+5 more
ENR-117510ENRLauren Barnes1972-07-01UHC-99671-0875196116132367 Grand Ave # 928, San Diego, CA, 921290.34Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
TPA-61321TPAJack Kennedy1955-03-14——1930 Valley View Dr, Orlando, FL, 328800.34Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
PRV-20638PRVBryan Payne1956-12-24——5689 Jefferson Ave, Seattle, WA, 981500.34Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+5 more
CLM-411279CLMPatricia Kennedy—UHC-91915-4144730833526142 Harbor Blvd, Los Angeles, CA, 900150.34Name re-casedDate of birth unreadableMember ID reformattedStreet suffix standardised+5 more
100,000 rows, page 9 of 2,000PreviousNext