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-109990ENRGary Day1974-05-27UHC-86503-9920481971475743 Hillcrest Rd # 228, Denver, CO, 802660.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-132941ENRPaul Q Porter1941-07-27UHC-28456-8424834595164240 Church St Apt 31, Plano, TX, 750250.48Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+4 more
CLM-409235CLMLogan Hamilton1972-01-12UHC-20469-9134478250107925 Pine Dr, Charlotte, NC, 282170.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-431143CLMVictoria Watson1965-04-28UHC-16748-1361529454365576 Sunset Blvd, Glendale, AZ, 853670.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-62097TPADonna Reynolds1941-10-22——6169 Elm St, Chandler, AZ0.48Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-110087ENRPatrick Morris1992-10-26UHC-18755-4553351513823131 Palm Dr, Eden Prairie, MN, 553810.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-108563ENRKevin Rice1953-10-21UHC-17571-2174081278857401 Pine Dr, Fresno, CA0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118702ENRAhmed U Ortiz1975-04-20UHC-09856-9343288619567257 Desert Sky Blvd, Glendale, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-133658ENRCamila Lynch1975-04-02UHC-24868-8164266106867308 Jefferson Ave, Jacksonville, FL0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-413779CLMGloria Ray—UHC-76213-90823277365864 Central Ave, Tucson, AZ, 857120.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
ENR-120589ENRFatima D Schmidt1958-12-15UHC-18800-64—8945 Jefferson Ave, Glendale, AZ, 853680.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
TPA-59695TPAKimberly G Hoffman1949-03-15——3254 Jefferson Ave, San Diego, CA0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-59696TPAKimberly G Hoffman1949-03-15——3254 Jefferson Ave, San Diego, CA0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-118482ENRChristopher E Evans1960-05-09UHC-90954-0653621823756340 Cedar Ln, San Diego, CA0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25543PRVAlexis Jimenez1971-09-20—49241282141687 Desert Sky Blvd, Miami, FL, 331060.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-427850CLMDlyan Cole2004-07-01UHC-93588-47—6513 Cedar Ln, Phoenix, AZ, 850860.48Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-141122ENRAngela Murray1987-06-24UHC-29472-0344871602066807 Cedar Ln, Austin, TX, 787880.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
TPA-52044TPAKathleen Obrien1988-02-05UHC-27159-7243663445119351 Elm St, Los Angeles, CA, 900750.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-416040CLMKathryn A Hayes1971-09-11UHC-11060-8955840577339284 Cedar Ln, Jacksonville, FL, 322610.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
ENR-116829ENRSentiago A Wong1969-01-19UHC-35346-77—4049 Washington St, Houston, TX0.48Middle initial moved out of first nameStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-423729CLMHarold Q Vasquez1944-08-02UHC-80565-93—1180 Sage Ct, Phoenix, AZ, 850280.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136471ENRTeresa Z Coleman2005-06-26UHC-01517-2781494498455737 Maple Ave # 982, Phoenix, AZ, 850290.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-410749CLMGloria A Luna2000-10-22UHC-66011-868468266485104 Ocean Ave, San Antonio, TX, 782210.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-427365CLMPeterJunk1976-01-23UHC-85220-8645048369056884 Maple Ave, Gilbert, AZ, 852650.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420572CLMAustin Matthews1998-04-17—790974151385 Union St # 715, Tampa, FL, 336150.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-125751ENRMaria M Banks1962-11-18—34399963316292 Church St, Los Angeles, CA0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424805CLMMarcus Griffin1955-02-22UHC-16047-81—6506 Spring St # 242, Phoenix, AZ0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-427009CLMKimberly Vargas1956-12-08UHC-25104-4294199865975780 Sage Ct, Tampa, FL0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-129065ENRSarah Phillips1981-01-22UHC-31199-5234437401281159 Spring St, Jacksonville, FL0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-107290ENRBradley Morrsion1982-11-11UHC-89051-374197127965461 Central Ave, Tucson, AZ, 857130.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-423792CLMSamantha Cox1974-01-03——7598 Oak St, Dallas, TX, 752910.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-412681CLMLuis Lee1965-04-28UHC-56887-73—7876 Bayshore Dr Apt 30, Phoenix, AZ0.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-24200PRVJennifer Vazquez1946-07-25—77144556581445 Market St, Los Angeles, CA, 900480.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-417543CLMSandra R Hart1950-09-18UHC-51984-99—9811 Maple Ave # 933, Orlando, FL0.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-134920ENRSofia N Davys1971-05-14UHC-61212-01—1769 Lincoln Way Apt 32, Plano, TX, 750210.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-62935TPAGeorge Hoewll1984-03-09—26189748289286 Baseline Rd, Mesa, AZ, 852070.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429587CLMLaura Ford1971-04-01——2828 Maple Ave Apt 8, Gilbert, AZ, 852830.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-25460PRVCamila B Sanders2003-07-23UHC-24398-4230779905417123 Cedar Ln, Tampa, FL, 336480.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-140062ENRGrace D Hughes1965-10-15UHC-78713-506717940564181 Central Ave, Tampa, FL, 336320.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-403206CLMJakob G Wong1982-10-02——1191 Camelback Rd Apt 17, Mesa, AZ, 852100.48Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
CLM-423315CLMMark Elliott1981-08-23UHC-53509-9927285563637325 Harbor Blvd, Minneapolis, MN0.48Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
ENR-134233ENRRoy Reed1975-08-05UHC-26068-8068825592844501 Indian School Rd, Fresno, CA, 937860.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-428703CLMKathryn Carlson1939-12-07UHC-76593-9555480832162320 Highland Ave, Las Vegas, NV, 891090.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-400534CLMCarl Jacobs1989-03-02——3975 Canyon Rd # 837, Gilbert, AZ, 852960.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-428219CLMAustin Welch—UHC-09700-727728276325278 Palm Dr, Gilbert, AZ0.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-106452ENRLaura N Green1971-08-01UHC-02350-8254127101727399 Church St, Glendale, AZ, 853170.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24387PRVPriya B Rice1957-12-11—20843303379320 Bayshore Dr # 865, Chandler, AZ, 852500.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-101617ENRBrandon O Adams1957-09-08UHC-04938-6938746827762111 Jefferson Ave, Eden Prairie, MN, 553570.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428711CLMPeter Black1991-07-06UHC-10895-5052979266999849 Palm Dr # 580, Miami, FL0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-403242CLMKeith G Cunningham1962-05-22—93871373186316 Central Ave, Charlotte, NC, 282240.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 55 of 2,000PreviousNext