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

Claims, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-424575CLMAnn White1957-06-19——159 Hillcrest Rd, Nashville, TN, 372950.64Name split from “Last, First”Date of birth reformattedCity re-casedZIP+4 trimmed+2 more
CLM-427751CLMMelissa Simmons1993-10-05——3474 Sage Ct # 190, Atlanta, GA, 303810.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408332CLMJessica Vega1967-09-05——8510 Ridge Rd, Dallas, TX0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402890CLMGrace Hawkins1938-07-27——1559 Willow Ct, Fresno, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410883CLMSandra Z Dominguez1971-11-14——7249 Canyon Rd, Orlando, FL, 328180.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-422040CLMPatrick Nichols1945-08-01—58756904376749 Hillcrest Rd, Sacramento, CA, 958370.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413003CLMMateo Barnes1954-02-13——7827 Hillcrest Rd, Atlanta, GA, 303350.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-403342CLMRachel Gonzalez1973-10-17UHC-89828-42—2830 Valley View Dr, Orlando, FL, 328930.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421923CLMTheresa Henry1991-12-11——8184 Meadow Ln, San Diego, CA, 921750.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426113CLMEmily Lucas—UHC-93210-785197220647664 Hillcrest Rd, Atlanta, GA, 303250.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-426483CLMJennifer Z Williamson1977-01-02UHC-04711-3794041445315587 Apache Blvd, Denver, CO, 802900.64Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-403660CLMNahan Morrison1976-10-19——1788 Valley View Dr # 194, Seattle, WA0.64Name re-casedDate of birth reformattedUnit split from streetZIP missing+2 more
CLM-424986CLMLawrence Klly—UHC-38369-92—9622 Central Ave, Fresno, CA, 937980.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-411804CLMKeith Bll1942-12-10UHC-34516-56—2197 Oak St, Eden Prairie, MN, 553700.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404279CLMEthan B Dean1976-05-04UHC-25740-72—3661 Lincoln Way Apt 25, San Antonio, TX, 782240.64Name re-casedUnit split from streetCity re-casedGender normalised+2 more
CLM-407777CLMSteven N Jones1987-01-21UHC-14206-13—8824 Main St, Tempe, AZ, 852610.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426498CLMWayne Rodriguez1962-01-02UHC-24236-32—1949 Lake View Rd, Denver, CO0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430726CLMWesst Janice1955-07-13UHC-37336-21—6528 Main St, Scottsdale, AZ, 852350.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-401080CLMJoan Castillo1960-04-13UHC-72136-56—53 Apache Blvd, Seattle, WA, 981110.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-428886CLMAaron Salazar1961-10-18UHC-14420-33—5728 Willow Ct, Los Angeles, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-403680CLMSarah Alvarado1963-04-16UHC-19247-2720955816486407 Grand Ave Apt 35, Orlando, FL, 328930.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-409233CLMLogan Hamilton1972-01-12UHC-20469-9134478250107925 Pine Dr, Charlotte, NC, 282170.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401142CLMGarza Rebecca1976-06-04UHC-50074-12—5159 Mountain View Dr, Gilbert, AZ, 852720.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401141CLMGarza Rebecca1976-06-04UHC-50074-12—5159 Mountain View Dr, Gilbert, AZ, 852720.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-426275CLMAlan O Greene1943-11-23UHC-55208-95—9748 Oak St Apt 8, Columbus, OH, 432430.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-429764CLMDonald Payne1959-06-26UHC-97805-04—6405 Hillcrest Rd, Gilbert, AZ0.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405709CLMJean Sullivan1986-08-24UHC-24114-02635239551648 Ridge Rd, Austin, TX, 787330.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-403592CLMStevens H Kevin1947-11-12UHC-74291-02—2398 River Rd, San Antonio, TX, 782550.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432537CLMDoris McDonald1977-06-19——566 Church St, Chandler, AZ, 852030.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-425376CLMPhilip Tucker1982-02-21UHC-65487-8273263632699361 Jefferson Ave, Orlando, FL, 328730.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-424643CLMVincent Sullivan1973-06-20UHC-26763-5529775896488234 Jefferson Ave, San Antonio, TX, 782460.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423995CLMKarn Harrison1987-01-26—8458765434718 Canyon Rd, Jacksonville, FL, 322070.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427082CLMSofia Andrews1996-02-17UHC-65628-97—377 Spring St, Charlotte, NC, 282180.64Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410055CLMEmma Medina1946-10-22——1963 Mesa Dr, Atlanta, GA, 303330.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412009CLMGerald Jones1943-06-01——6618 Church St, Tempe, AZ, 852680.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426025CLMValentina Welch——81661646526400 Sunset Blvd, Denver, CO, 802890.64Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-405503CLMTony Mason1959-08-27UHC-71486-085229854900—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-420953CLMHiroshi Montgomery1976-04-17——1778 Ridge Rd Apt 21, Miami, FL0.64Name re-casedDate of birth reformattedUnit split from streetZIP missing+2 more
CLM-431559CLMBryan Payne1960-09-21UHC-76306-9034243407813458 Camelback Rd, Orlando, FL, 328600.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408095CLMGregory Guerrero1967-09-14UHC-16053-08—6620 Mountain View Dr # 623, Phoenix, AZ, 850010.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-429313CLMJoseph Hanson1999-12-05——3879 Mountain View Dr, Atlanta, GA, 303890.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426511CLMBryan Pena1961-08-26—48598015556885 Market St, Houston, TX0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-424917CLMJack Padilla1944-09-12—33144814952861 Mountain View Dr, San Antonio, TX0.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-428380CLMStephanie N Evans2005-06-17UHC-34729-41—8831 Baseline Rd, Houston, TX, 770920.64Street suffix standardisedAddress re-casedZIP+4 trimmedPlan code upper-cased+2 more
CLM-426799CLMScott Le1960-06-05—7588631704586 Canyon Rd # 235, Gilbert, AZ, 852160.64Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
CLM-411243CLMHenry Rodriguez1959-05-24UHC-67679-8762674142108981 Bayshore Dr, Atlanta, GA, 303130.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-425425CLMBarbaa S Park1982-05-01UHC-16638-84—4177 Pine Dr, Scottsdale, AZ, 852240.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400536CLMBrian Vargas1977-11-09UHC-94455-80—5424 Lincoln Way, Tucson, AZ, 857170.64Name re-casedTwo-digit birth yearMember ID reformattedGender normalised+2 more
CLM-422799CLMTerry Duncan—UHC-48122-4145030596193045 Highland Ave, Plano, TX, 750880.64Name split from “Last, First”Date of birth missingPhone reformattedMember ID reformatted+2 more
CLM-417374CLMSean Allen1945-02-02—51978880259540 Lake View Rd # 390, Denver, CO, 802930.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 113 of 657PreviousNext