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-137198ENRChristian A Mejia1997-12-24UHC-16395-85—2684 Ridge Rd, Miami, FL, 331100.50Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-405322CLMDick Jimenez1941-09-12UHC-48141-593878462631792 Desert Sky Blvd, Sacramento, CA, 958590.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-100085ENRSara R Moore1951-12-04UHC-46190-7532096639252308 Park Pl # 539, Phoenix, AZ, 850230.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-118678ENRJesse M Reyes2006-02-10UHC-88973-0527221199433997 Canyon Rd, Mesa, AZ, 852150.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-109216ENRDenise Santos1938-08-19UHC-94172-0656527349928780 Indian School Rd, Tampa, FL, 336620.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-112080ENRNancy N Rios1945-11-03UHC-06953-5235298194847547 Highland Ave, Columbus, OH, 432860.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418017CLMGray Rodriguez1987-10-28——1022 Park Pl # 477, Fresno, CA, 937510.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-137514ENRAna F Jimenez1958-09-01UHC-89148-48—3228 Mountain View Dr, Charlotte, NC, 282780.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-418655CLMMaria Gonzales1946-04-21UHC-62081-02—6725 Bayshore Dr # 462, Glendale, AZ, 853300.50Date of birth reformattedMember ID reformattedUnit split from streetZIP+4 trimmed+3 more
TPA-50650TPAKimberly Russell1995-05-06——454 Jefferson Ave, Tempe, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114045ENRJustin Y Wright1949-03-15UHC-64046-6798786170761629 Main St, Nashville, TN, 372040.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-113172ENRMark F Washington1964-09-02UHC-44921-9491225151414833 Grand Ave # 987, Phoenix, AZ, 850620.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-22288PRVRaymond Banks2004-07-09UHC-53680-51—2102 Central Ave, Denver, CO, 802360.50Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
PRV-27341PRVAlan Mendez1999-04-23—27051002809237 Lincoln Way, Las Vegas, NV, 891350.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130429ENRDense Young1969-11-18UHC-62842-5350531369252167 Desert Sky Blvd, Tempe, AZ, 852680.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-130430ENRDense Young1969-11-18UHC-62842-5350531369252167 Desert Sky Blvd, Tempe, AZ, 852680.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-409379CLMCynthia Morgan1985-01-11——1084 Canyon Rd # 260, Charlotte, NC, 282710.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
CLM-407283CLMDylan Rojas1974-10-07—81228846904391 Camelback Rd, Austin, TX, 787620.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-410330CLMRonald I Watkins2008-06-26—949232041521 Washington St, Fresno, CA, 937920.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-418449CLMScott Alvarado—UHC-03782-0496492973885896 Hillcrest Rd # 565, Glendale, AZ, 853990.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
CLM-432078CLMTerry Ward1946-01-15UHC-07080-31—7505 Elm St, Tampa, FL, 336040.50Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-106766ENRCynthia Wheeler1967-04-23UHC-95456-0546421456105995 Jefferson Ave, San Antonio, TX, 782560.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-429015CLMBrenda Green1966-08-06—24646199234014 Canyon Rd, Eden Prairie, MN, 553480.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-134222ENRJanet Arnold—UHC-22906-0393892391461157 Main St, Tempe, AZ, 852270.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-128755ENRLauren I Herny1963-04-11UHC-79485-1473338056445723 Park Pl, Glendale, AZ, 853250.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127429ENRJean R Brown1941-01-10UHC-40230-1981072118531798 Hillcrest Rd, San Diego, CA, 921130.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-114041ENRJordan Thomas1963-10-14UHC-44081-33—5087 Ridge Rd Apt 28, Denver, CO, 802580.50Name split from “Last, First”Member ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-121951ENRJerry F Willlis1999-02-11UHC-87696-2348781867515985 Camelback Rd, Glendale, AZ, 853960.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-113102ENRTyler Welch—UHC-09460-0894523363768030 Apache Blvd, Houston, TX, 770870.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
TPA-55445TPAJnaice Hanson1966-12-14—85071437005303 Willow Ct, Tempe, AZ, 852710.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-130962ENRAllen Q Breenda1952-03-07UHC-73574-9791758856642354 Apache Blvd Apt 22, Atlanta, GA, 303450.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-51992TPASean Mureno1989-08-28——8250 Elm St, San Diego, CA, 921880.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-402733CLMJustin X Murphhy1997-05-06UHC-71276-28—176 Lake View Rd Apt 13, Gilbert, AZ, 852530.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413933CLMTim Olson1945-07-16UHC-86947-076262487152432 Union St, Sacramento, CA, 958460.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54099TPATeresa Greene1966-10-05—80967197276237 Oak St, San Diego, CA, 921780.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-408210CLMJanet Aguilar2006-05-27UHC-14912-0460436315348578 Ridge Rd, San Antonio, TX, 782030.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-406764CLMCamila Miller1961-02-11UHC-19495-23—7163 Main St, Plano, TX, 750210.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-428354CLMKeith Thompson1963-12-21UHC-58395-7182666933096960 Indian School Rd # 152, Jacksonville, FL, 322740.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412462CLMSamuel Wong1947-11-23UHC-13804-81—3726 Hillcrest Rd Apt 14, Fresno, CA, 937400.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-136773ENRRoger R Arnold1998-06-21UHC-95060-5078184410301890 Meadow Ln, Fresno, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408145CLMYuki C Wagnner—UHC-11396-966375562087123 Sage Ct, Nashville, TN0.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-141807ENRMateo Ortiz1968-01-20UHC-47672-9671040537849079 Grand Ave Apt 1, Austin, TX0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56675TPAMaria D Cruz1989-07-28—69164244911792 Forest Ave, Phoenix, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-26160PRVEvelyn Rios—UHC-61519-1497387309675133 Grand Ave # 470, Tucson, AZ, 857540.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-24985PRVJohn Contreras1945-12-13—45680266163814 Union St, Tucson, AZ, 857180.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-139877ENRDouglas Russell1997-07-01UHC-42827-2534552524313018 Harbor Blvd, Sacramento, CA, 958720.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-119114ENRMateo Perez2003-01-14UHC-46817-6190093943522630 Maple Ave, Tampa, FL, 336360.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113572ENRJose Y Ross2005-07-10UHC-02279-479205245106477 Willow Ct Apt 3, Austin, TX, 787270.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-419845CLMPaul Le1992-11-08UHC-35140-5535973078913605 Oak St # 834, Minneapolis, MN, 554550.50Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-422256CLMBobby Santos1965-03-28UHC-83369-97—7250 Apache Blvd, Dallas, TX, 752170.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 108 of 2,000PreviousNext