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
PRV-27381PRVMateo V Dean2000-12-27UHC-92928-499219120581493 Forest Ave, Plano, TX, 750460.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-108846ENRCarl Owens2001-01-10UHC-24250-0282430716861298 Forest Ave, Minneapolis, MN0.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-404575CLMJudith Carroll1939-03-06UHC-51003-0122025383589103 Church St, Phoenix, AZ, 850750.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-111637ENR—Junk1981-08-16UHC-81108-8081740938482178 Apache Blvd # 803, Eden Prairie, MN, 553480.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-140915ENRDonald D Price1990-06-06UHC-98398-0146187926271458 Oak St, San Antonio, TX0.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-138859ENRRobert W Jacobs1971-01-14UHC-66748-2959384085707254 Central Ave, Atlanta, GA, 303350.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-409318CLM—Junk2003-09-10UHC-74908-5051994996513540 Forest Ave, Mesa, AZ, 852320.46Date of birth reformattedPhone reformattedCity re-casedState name converted to code+5 more
PRV-21711PRVRachal Campbell2005-02-19UHC-11063-3168241968923867 Cedar Ln, Las Vegas, NV, 891010.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-122842ENRBryan Gordon—UHC-04003-3772320213971344 Ocean Ave, Glendale, AZ, 853260.46Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more
ENR-107731ENRCamila A Perkins1961-05-20UHC-07700-4547190381366104 Spring St, Scottsdale, AZ, 852220.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-114943ENRCharlotte J Watson1969-08-27UHC-45410-024589482383429 Pine Dr, Atlanta, GA, 303560.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
ENR-114942ENRCharlotte J Watson1969-08-27UHC-45410-024589482383429 Pine Dr, Atlanta, GA, 303560.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
CLM-407790CLMJonathan O Maldonado2002-06-14UHC-46045-0992031302657897 Highland Ave, Scottsdale, AZ, 852210.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-406712CLMJessica Johnson1979-10-05——222 Harbor Blvd, Las Vegas, NV, 891220.46Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-107316ENRJack V Bowman1974-02-24UHC-76339-06—6010 Broadway, Plano, TX, 750130.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone missing area code+5 more
ENR-117208ENRHeather Reyes1945-01-26UHC-65077-067025427306786 Sunset Blvd, Atlanta, GA, 303510.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-119233ENRKevin D George1941-01-17UHC-63679-2187798915981143 Jefferson Ave, Houston, TX, 770300.46Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+5 more
PRV-21539PRVLawrence Hamilton1949-01-17—36622688278701 Sunset Blvd, Sacramento, CA0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-421829CLMSamantha West1987-11-13—98495281503597 Elm St, Las Vegas, NV0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-109316ENRJackie Gray—UHC-83000-1232579143145307 Baseline Rd, Denver, CO, 802630.46Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more
ENR-113200ENRTeresa Santos1959-12-22UHC-28319-239576359236194 Oak St, Dallas, TX, 752560.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-422533CLMJoan Harvey1994-03-15UHC-56570-62—2921 Forest Ave # 116, Tampa, FL, 336440.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-133966ENRKatherine King1947-06-28UHC-21776-912332893316339 Church St, Dallas, TX, 752430.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-124893ENRAdam H Lucas2003-03-21UHC-98067-3892295376834190 Union St, San Diego, CA0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-24390PRVEric Cooper1969-04-02UHC-23594-28—282 Union St, Phoenix, AZ, 850080.46Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+5 more
CLM-401059CLMCharles Hunter1989-06-08—52387368585023 Elm St Apt 17, Tempe, AZ, 852670.46Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
ENR-139448ENRHarold Lewis1983-03-15UHC-81818-9642726627326789 Elm St Apt 9, Atlanta, GA, 303210.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-110421ENRTyler Oliver1988-04-04UHC-80744-5623657740093506 Lincoln Way, San Diego, CA, 921390.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-28076PRVAnthony Oliver1962-09-24UHC-51791-985877572903697 Meadow Ln, Phoenix, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-105544ENRSofia Lawrence1986-02-24UHC-75151-1586963471692571 Bayshore Dr, Seattle, WA0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-125046ENRCarl Q White1943-02-06UHC-60657-2348970219168984 Ridge Rd, Orlando, FL, 328630.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-417561CLMMarcus J Allvarado1949-06-12UHC-99938-50—53 Union St, San Antonio, TX, 782720.46Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+5 more
ENR-109723ENRNatlie Wang2000-08-13UHC-11557-2748850654065773 Baseline Rd # 137, Minneapolis, MN0.46Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
PRV-27976PRVHudson K Alexander1964-03-17UHC-67582-644126394110965 Hillcrest Rd, Gilbert, AZ, 852900.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-139181ENRPat H Gutierrez1991-10-17UHC-55935-3563155927389066 Cedar Ln, Eden Prairie, MN0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-101426ENRSophia Munoz1977-05-22UHC-32629-2185499957376455 Ridge Rd, Scottsdale, AZ, 852560.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-113417ENRGabriel N Mnoz1986-01-14UHC-68548-7383885352933915 Park Pl, Atlanta, GA0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-140343ENRJulie A George1961-08-14UHC-62078-4389962424985628 Mountain View Dr, Seattle, WA, 981190.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-401177CLMJerry West2005-09-21UHC-63267-0123858819163779 Baseline Rd, Dallas, TX0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-105551ENRLogan Q Mendoza1997-07-19UHC-83159-6632645630545812 Jefferson Ave, Tucson, AZ, 857280.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
TPA-63862TPAAlbert P Howard2004-09-11—24264380106203 Park Pl, Gilbert, AZ0.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
CLM-410658CLMJacqueline Jenkins1954-01-08UHC-69211-438249375053995 Baseline Rd, Minneapolis, MN, 554520.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-400922CLMSantiago Reid1991-05-21UHC-51553-43—8160 Willow Ct, Sacramento, CA, 958740.46Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
TPA-63148TPABruce Patterson1944-07-05UHC-92614-9820382578389161 Lake View Rd, Mesa, AZ, 852610.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-123489ENRKelly K Park2003-01-04UHC-31870-5421546628012146 Willow Ct, Jacksonville, FL, 322780.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-113903ENRNathan M Wilson2007-10-13UHC-55606-8288258892258326 River Rd # 910, Miami, FL0.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-118480ENRDebra J Elliott—UHC-29655-4175195587735362 Park Pl, Nashville, TN, 372100.46Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+5 more
CLM-400358CLMLauren Hansen1979-04-21UHC-05841-1767378384671365 Valley View Dr, Minneapolis, MN0.46Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-118142ENRGregory Lopez2003-10-17UHC-68258-6536062175002870 Indian School Rd # 777, Tampa, FL0.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-119326ENREvelyn Burns1991-10-17UHC-64453-70—4461 Spring St, Tampa, FL, 336710.46Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+5 more
100,000 rows, page 43 of 2,000PreviousNext