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
TPA-51100TPAJanet Graham1965-01-05——7239 Lincoln Way, Phoenix, AZ, 850340.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-409649CLMElijah Owens1989-06-04UHC-32230-666147492074428 Church St, Scottsdale, AZ, 852760.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418800CLMMadison Vazquez1994-10-09UHC-54474-8726978149706427 Mesa Dr Apt 14, Miami, FL, 331090.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-138210ENRJuan L Hicks1960-08-11UHC-50167-56—8082 Hillcrest Rd, Fresno, CA0.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
PRV-26495PRVBrian Coleman1948-01-28—84978609124479 Ocean Ave, San Antonio, TX, 782520.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110219ENRJason Grant1946-01-06UHC-51451-9158959815457783 Indian School Rd # 964, Denver, CO, 802930.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-128258ENRJudy H Holmes1956-02-24UHC-57040-5548670300995051 Mesa Dr, Orlando, FL, 328220.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-108449ENRWei E Nelson1998-12-11UHC-33550-609702606900139 Main St, Minneapolis, MN, 554880.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62457TPABruce Porter1986-12-02UHC-09068-8190464166252200 Bayshore Dr, Fresno, CA, 937510.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-108181ENRPeter S Cox1954-07-02UHC-84520-2825250448209161 Baseline Rd, Tucson, AZ, 857600.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25158PRVJose Q Austin1965-08-18—70287089837293 Camelback Rd, Plano, TX, 750650.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403474CLMKtahryn Piarce1939-02-21UHC-95401-16—9528 Washington St, Tampa, FL0.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
PRV-22493PRVMateo C Fuller1997-07-09UHC-83792-6049454348558580 Indian School Rd, Tampa, FL, 336450.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-414372CLMBrian G Lynch1980-12-15——6503 Harbor Blvd, Jacksonville, FL, 322670.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
PRV-22843PRVCharlotte Salazar1975-09-06—74036800286582 Central Ave, Atlanta, GA, 303880.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-428569CLMAngela Burns1959-02-14UHC-19715-2249094473033613 Elm St Apt 24, Tucson, AZ, 857610.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-402554CLMHarold Soto1999-02-06UHC-32025-8466228330635478 Elm St, Miami, FL, 331230.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416381CLMJoshua Gibson1945-05-01UHC-44042-2994463886315857 Oak St, Nashville, TN0.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424309CLMLinda Moore1983-05-10UHC-97227-77—2502 Valley View Dr, Gilbert, AZ, 852330.48Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-126606ENRBeverly I Baker1997-08-08UHC-69779-08—5700 Maple Ave # 597, Atlanta, GA0.48Name re-casedDate of birth reformattedUnit split from streetCity re-cased+4 more
ENR-141875ENRJohn P White1999-05-07UHC-30249-9342952843898455 Market St, Atlanta, GA, 303810.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-134718ENRKathleen Y Soto2002-08-13UHC-94654-9240989811196214 Highland Ave, Columbus, OH, 432140.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-129395ENRAmanda Brooks1966-05-17UHC-53265-893354943327497 Canyon Rd, Nashville, TN0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-426814CLMKeith Watson1991-02-08UHC-99757-95—907 Central Ave # 294, San Antonio, TX, 782650.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-124610ENRGeorge E Shaw1984-10-02UHC-36004-77—6572 Bayshore Dr, Tucson, AZ, 857800.48Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
TPA-52179TPACharles Lane1953-12-13—83272443932643 Washington St, Seattle, WA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-125551ENREthan A Wilson2008-04-09UHC-71543-2965836097239614 Sunset Blvd, Austin, TX, 787140.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423751CLMKelly Harris1961-03-22UHC-15595-6469193970313408 Hillcrest Rd, Minneapolis, MN, 554900.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408489CLMMadison X Patel2000-01-10—84573459644495 Union St, Glendale, AZ0.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
PRV-22922PRVSharon Ellis1982-09-20—93644275628570 Maple Ave, Phoenix, AZ, 850850.48Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
TPA-63744TPASandra Richardson2008-03-12—91096377123793 Canyon Rd, Scottsdale, AZ, 852540.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-142111ENRWilliam U Wells1996-06-27UHC-43805-7293758783214905 Lake View Rd Apt 24, Phoenix, AZ0.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-53153TPAPamela Lucas1963-10-05UHC-08267-93—6958 Highland Ave Apt 37, San Antonio, TX0.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-413990CLMGabriel Luna1959-09-13UHC-01468-90—3187 Oak St, San Antonio, TX, 782780.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-62433TPAJudith Espiinoza1987-06-10—6165697187403 Spring St Apt 22, Mesa, AZ, 852490.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51244TPAEugene Chavez1944-12-06—53338108953313 Ocean Ave, Minneapolis, MN, 554430.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104396ENRBrian Vazquez1997-04-17UHC-47957-282274042354700 Willow Ct, Houston, TX, 770340.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-24867PRVKimberly Ramirez1961-09-17UHC-25631-3594244370758356 Park Pl, Dallas, TX, 752630.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-28457PRVMichael T Contreras1974-09-07UHC-41501-2942292086855364 Pine Dr, Houston, TX, 770580.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-55431TPAJuan Santiago1988-05-17—8593034625166 Union St, Plano, TX, 750370.48Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+4 more
CLM-425593CLMSandra Davis1965-02-20—4305948939680 Maple Ave, Houston, TX, 770460.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-425594CLMSandra Davis1965-02-20—4305948939680 Maple Ave, Houston, TX, 770460.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-136561ENRCharlotte B Riley2007-01-23UHC-92624-926864994338355 Valley View Dr, Tucson, AZ, 857820.48Middle initial moved out of first nameName re-casedMember ID reformattedStreet suffix standardised+4 more
ENR-121607ENRTerry Nunez1975-12-04UHC-45934-0138139451294095 Main St, Phoenix, AZ, 850990.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-141779ENRSara McCoy1938-02-24UHC-49462-8082555627657050 Forest Ave Apt 25, Charlotte, NC, 282810.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-61316TPAChristine Broooks1953-12-25—74323869893231 Cedar Ln, Seattle, WA, 981910.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-103192ENRDeborah D Lopez1956-08-23UHC-90944-8737937339508762 Ridge Rd, Austin, TX, 787910.48Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
ENR-132449ENRAndrew I Hunt2006-10-23UHC-82931-3255681748023243 Church St Apt 21, Dallas, TX, 752600.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-132448ENRAndrew I Hunt2006-10-23UHC-82931-3255681748023243 Church St Apt 21, Dallas, TX, 752600.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-124450ENRGloria T Berry2008-08-04UHC-91554-5876444995555979 Sage Ct, Mesa, AZ, 852160.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
100,000 rows, page 61 of 2,000PreviousNext