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-403967CLMAhmed Bowman1944-07-28UHC-82494-64—666 Ridge Rd, Scottsdale, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136059ENRJesse Miller1943-04-13UHC-45991-1046248212791014 Jefferson Ave # 795, Seattle, WA, 981260.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-103675ENRMartha G Sanchez—UHC-34396-4572898754903891 Camelback Rd, Seattle, WA, 981860.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
PRV-24892PRVAlan Scott1949-04-18—66647921257774 Forest Ave, Chandler, AZ, 852820.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-430444CLMKevin Perez1988-03-13UHC-46387-4184639213592315 Ocean Ave, Orlando, FL0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-125627ENRCarolyn W Ortiz1983-01-27UHC-39963-2339582413994744 Cedar Ln, Miami, FL, 331790.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-142646ENRCheryl Gibson1999-05-15UHC-20991-8529448190186044 Willow Ct, Los Angeles, CA0.48Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+4 more
ENR-100070ENRKaren A Green1978-04-13UHC-50857-0697632882956560 Ocean Ave, Chandler, AZ, 852530.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-141819ENRLawrence U Scott1993-10-27UHC-71983-4231765233149111 Pine Dr, Chandler, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-104393ENRBen Stewart1945-06-25UHC-28478-4333147139602391 Willow Ct, Tempe, AZ0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428222CLMKelly Jensen1954-03-12UHC-89135-52—3420 Baseline Rd, Nashville, TN, 372130.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-136662ENRJeffrey B Hunter1974-07-13UHC-42787-3437040643623234 Sage Ct, San Diego, CA, 921760.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123609ENRSophia Q Robertson1962-08-17UHC-54909-8827449786957990 Church St, Atlanta, GA, 303950.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132323ENRScott M Singh—UHC-17288-4377920450301717 Hillcrest Rd, Sacramento, CA, 958330.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108330ENRJason P Perez1944-06-15UHC-44943-1195196515667980 Maple Ave, Fresno, CA0.48Name re-casedDate of birth reformattedPhone reformattedState name converted to code+4 more
CLM-418823CLMBruce Nichols1996-11-06——7232 Forest Ave, Mesa, AZ, 852360.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26886PRVMadisn D Kelly1952-05-25—42780036595238 Sage Ct, Nashville, TN, 372750.48Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
ENR-129787ENREvelyn J Marshall1991-07-27UHC-36370-75—2509 Spring St, Atlanta, GA, 303210.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116294ENRBrandon Munoz—UHC-58272-47—7696 Highland Ave, Tempe, AZ, 852650.48Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
ENR-140185ENRMateo Schultz1941-01-21UHC-87360-2667326005937638 Ocean Ave, Denver, CO, 802860.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123966ENRNoah Gutierrez2005-12-01UHC-54159-412576707157179 Meadow Ln, Miami, FL, 331010.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-101511ENRHarold P Austin1959-09-14UHC-07743-2753297378012299 Main St Apt 31, Tempe, AZ0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-20641PRVMateo Tran1990-12-01—4139778715849 Elm St, San Antonio, TX, 782070.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21875PRVTyler Dean2004-08-17—56687124794144 Canyon Rd, Seattle, WA, 981770.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-142774ENRArtthur X Howell1960-09-28UHC-88241-33—2865 Indian School Rd, Glendale, AZ0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-431680CLMAmber Walker1987-09-21UHC-16667-35—6375 River Rd, Miami, FL, 331580.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-24255PRVEthan Ramirez1970-07-10—87664456045724 Mountain View Dr, Tucson, AZ, 857110.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20212PRVCharlotte Bryannt1993-09-22UHC-51096-9785882005124266 Union St, Denver, CO, 802300.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-117822ENRKeith T Banks1959-07-01UHC-64031-6642064151388804 Camelback Rd, Las Vegas, NV, 891710.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-60537TPAGerald Foster1993-02-26—53492083258689 Jefferson Ave, Tucson, AZ, 857620.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-21496PRVElijah X Flores——51442825167879 Market St, Los Angeles, CA, 900400.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420626CLMMark Estrada1989-09-12UHC-34804-58—3650 Apache Blvd, Eden Prairie, MN, 553940.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-116553ENRJeremy J Vega1950-08-16UHC-56071-6567581859891820 Park Pl, Sacramento, CA, 958690.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
ENR-112201ENRDaniel T Pena1978-06-28UHC-03725-4325669909569596 Meadow Ln, Los Angeles, CA, 900350.48Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25801PRVRachel O Wagner1967-02-28UHC-69511-6968843017023551 Palm Dr, Columbus, OH, 432100.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28614PRVSandra T Howell1940-08-19—57080353651797 Meadow Ln, Mesa, AZ, 852660.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-100176ENRBetty Weaver1963-08-01UHC-27224-845137176082662 Palm Dr, Glendale, AZ0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61063TPABeverly Allen1963-01-04UHC-37163-0777052328432944 Willow Ct, Jacksonville, FL, 322470.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422830CLMTimothy Carpenter1970-04-07——8987 Hillcrest Rd, Mesa, AZ, 852170.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-57950TPAMitchellJunk1971-03-02——9358 Jefferson Ave Apt 37, Denver, CO, 802040.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-400514CLMKimberly S Henry1947-09-26—73693756075008 Desert Sky Blvd Apt 31, Miami, FL0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-108475ENRJason S Ortiz1967-02-28UHC-90014-4233349559526807 Highland Ave, Chandler, AZ0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130675ENRAshley M Henry1965-12-15UHC-55793-4130192325758367 Church St, Atlanta, GA0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-135931ENRPriya Collins1942-04-01UHC-11691-5797860285686339 Baseline Rd Apt 24, Mesa, AZ, 852460.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-408369CLMMason A Maldonado——27228623841570 Union St, Tampa, FL, 336040.48Name split from “Last, First”Date of birth unreadablePhone reformattedCity re-cased+4 more
TPA-58325TPAMdaison Vazquez1994-10-09——9099 Mesa Dr, Minneapolis, MN, 554800.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61262TPAJeffrey V Soto2006-08-10—31340556724743 Desert Sky Blvd, Fresno, CA, 937340.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59983TPARoger Ortega1939-04-19UHC-44775-27—9312 Market St # 328, Jacksonville, FL, 322100.48Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-430538CLMDennis F Watson1960-02-18UHC-66816-88—3612 Highland Ave # 335, Chandler, AZ, 852260.48Name split from “Last, First”Date of birth reformattedPhone missing area codeMember ID reformatted+4 more
ENR-106247ENRRebecca E Mitchell1966-11-10UHC-40679-6498231552162829 Central Ave # 788, Phoenix, AZ, 850450.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedUnit split from street+4 more
100,000 rows, page 66 of 2,000PreviousNext