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-405578CLMRaymond U Burns1943-08-03UHC-29776-5747031694932658 Hillcrest Rd, Austin, TX0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-114100ENRKevin U Cunningham1942-10-27UHC-96334-5375367053544976 Cedar Ln # 439, Orlando, FL, 328130.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
TPA-55550TPAAustin Dean1970-06-23——4643 Church St # 208, San Diego, CA, 921760.50Name re-casedTwo-digit birth yearUnit split from streetCity re-cased+3 more
ENR-130333ENRMegan Delgado—UHC-77498-4637838648198796 Bayshore Dr, San Diego, CA0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141870ENRIsabella Rse1991-01-19UHC-86613-44773242316823 Bayshore Dr, San Diego, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129812ENRKimberly U Armstrong1958-04-08—35785936611214 Palm Dr, Tucson, AZ, 857390.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407691CLMEugene H Kelly1976-07-07UHC-59154-82—1751 Valley View Dr, Miami, FL, 331480.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-402625CLMMelissa Welch1986-07-15UHC-74121-25—3450 Maple Ave, Las Vegas, NV, 891570.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-422844CLMAna N Gilbert———5440 Valley View Dr, Austin, TX, 787250.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-121855ENRMarcus Nguyen1981-01-17UHC-61216-0860442112218499 Forest Ave, Houston, TX, 770370.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133296ENRJessica C Kennedy1986-12-27UHC-38650-3139491443442987 Ridge Rd, Mesa, AZ, 852880.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115527ENRLuis H Munoz1963-10-07UHC-84496-6556831135368503 Oak St, Atlanta, GA, 303540.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-136265ENRGrace Wong2000-12-03UHC-13056-4773566760103571 Spring St, Sacramento, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406860CLMGreen Luis1980-09-23—87441178991792 Mountain View Dr, San Antonio, TX, 782700.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
ENR-110939ENRAlex R Gutierrez1968-08-03UHC-03255-0265626872803809 Oak St, Sacramento, CA, 958110.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-114793ENRSantiago Mejia1961-06-28UHC-22049-7531448040211907 Highland Ave # 446, Miami, FL, 331860.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-431320CLMJoe Thomas2007-03-01UHC-54570-0576395330458252 Main St, Plano, TX, 750330.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54454TPABeverly P Austin———9889 Apache Blvd, Scottsdale, AZ, 852140.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
ENR-139933ENRFrank Powell1990-09-11UHC-17295-0226453655208797 Camelback Rd # 514, Columbus, OH, 432310.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-113914ENRPetrick Luna1983-10-03UHC-87231-0795991888872497 Baseline Rd, Jacksonville, FL, 322870.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-53699TPAJacqueline Adams1996-06-09—45172231825404 Spring St, Houston, TX, 770670.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121963ENRAmanda Woods1938-08-27UHC-77779-1385541380891989 Sage Ct, Atlanta, GA, 303760.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424897CLMFrank Roberts1981-06-11——7429 Washington St, Phoenix, AZ, 850500.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-117124ENRSantiago E Gray1951-10-02UHC-60144-43—2965 Camelback Rd, Atlanta, GA, 303820.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-422395CLMJoshua Payne1938-09-03—28931056975146 Cedar Ln, Sacramento, CA, 958710.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-119650ENRScott H Kim1962-07-02UHC-69089-1793228420754664 Spring St, Chandler, AZ, 852210.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-26308PRVChristine J Espinoza—UHC-16134-2241580557566095 Meadow Ln, Plano, TX, 750980.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113159ENRLisa U Hayes1997-11-16UHC-48433-5861323274113266 Mountain View Dr, Plano, TX, 750530.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-115937ENRKevin Q Burke—UHC-90271-7073637411207399 Church St, Denver, CO, 802460.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-410833CLMEdward Daniels1985-10-27UHC-52432-1133431721638035 Central Ave # 267, Tampa, FL, 336150.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-60987TPAHenry Fisher2005-06-18——409 Park Pl, Atlanta, GA, 303880.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-124186ENRJanice Weaver1973-10-17UHC-62096-42—1279 Oak St, Denver, CO, 802250.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51743TPAMartha Bell1965-09-21——1624 Palm Dr, Mesa, AZ, 852220.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
ENR-116661ENRLus Lee1965-04-28UHC-56887-7326458271807876 Bayshore Dr, Phoenix, AZ0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121418ENRMike Walker1974-05-01UHC-97961-6535477049335591 Harbor Blvd, Austin, TX0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129209ENRMaria Q Cunningham1959-10-20UHC-51601-8589880858327075 Pine Dr, Los Angeles, CA, 900080.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110684ENRPamela Jackson1959-03-14UHC-56346-66—7679 Mesa Dr, Charlotte, NC0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-64288TPAAna Mendoza1983-03-07——2702 Lake View Rd Apt 35, Atlanta, GA, 303070.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-429941CLMPatrick Sanders2005-09-06—35835405984835 Apache Blvd, San Diego, CA, 921930.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135821ENRJordan J Boyd1962-06-03UHC-82021-9853396548815668 Union St Apt 1, Minneapolis, MN, 554660.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-424239CLM—Junk1985-12-02UHC-44550-4352394438162515 Palm Dr, Tucson, AZ, 857670.50Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+3 more
ENR-120119ENREdward Olliver2006-04-20UHC-36016-9042946495562187 Sage Ct, Columbus, OH, 432060.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
TPA-56054TPAJean Edwards1956-04-04—45273664688902 Central Ave, Mesa, AZ, 852380.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415269CLMJesse Murray1963-12-17UHC-00502-6389484222682900 Lincoln Way, Jacksonville, FL, 322530.50Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+3 more
ENR-136647ENRBrittany Peterson1980-04-14UHC-26138-4930987477414303 Elm St, Eden Prairie, MN, 553620.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61760TPACharlotte Rogers1996-03-20——7069 Cedar Ln, Houston, TX0.50Street suffix standardisedAddress re-casedState code upper-casedZIP missing+3 more
CLM-409421CLMLuis Richards1969-08-21UHC-28814-43—6338 Indian School Rd, Gilbert, AZ, 852250.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-118824ENRHeather V Palmer2005-05-09UHC-37730-2147677896846747 Jefferson Ave, Los Angeles, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123804ENRLawson R Kathleen1941-07-17UHC-48976-7142853174932728 Valley View Dr Apt 10, Charlotte, NC, 282020.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-61388TPABill Ellis2001-02-14——8506 Sunset Blvd, Gilbert, AZ, 852720.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 121 of 2,000PreviousNext