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-402702CLMJudy Turner1957-08-03UHC-54618-59—5845 Central Ave, Denver, CO, 802960.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415981CLMChris Harvey1997-03-09UHC-40603-083793261896—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-415338CLMMargaret N Foster1970-07-13UHC-64307-2397324949983524 Broadway, Dallas, TX, 752760.64Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-404998CLMSara Padilla1982-07-06UHC-32625-799568711550690 Main St, Tampa, FL, 336830.64Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-428464CLMMegan Edwards2006-06-04—65867940404207 Spring St, Phoenix, AZ, 850580.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413897CLMMason V Vasqez1967-05-27——3053 Central Ave, Los Angeles, CA, 900660.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-403245CLMKenneth Martinez1966-11-26UHC-66774-91—6621 Sage Ct, Fresno, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410283CLMSantiago Watson1962-07-25UHC-78715-9582280348579573 Sage Ct # 487, Los Angeles, CA, 900240.64Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-429521CLMWalker Alexander—UHC-93561-044286287492545 Desert Sky Blvd, Gilbert, AZ, 852140.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-427855CLMSara Hawkins1986-02-02—92629010221415 Ocean Ave, Atlanta, GA, 303370.64Two-digit birth yearPhone reformattedState code upper-casedGender normalised+2 more
CLM-420282CLMMaria Cox1940-09-01UHC-85402-44835519884649 Highland Ave, Plano, TX, 750440.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416954CLMOlivia Padilla2001-03-03UHC-79554-60—847 Market St, Tempe, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-427190CLMPriya Rodriguez1963-11-16UHC-00786-9367238061497200 Indian School Rd, Las Vegas, NV, 891540.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426047CLMKathryn Gray1969-12-14UHC-34431-13—6391 Camelback Rd, Scottsdale, AZ, 852130.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424892CLMCheryl Thomas2004-07-05UHC-65987-5534585429948717 Ridge Rd, Houston, TX, 770470.64Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-412401CLMPamela West1961-07-26——2946 Sage Ct, Austin, TX, 787940.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-430488CLMSarah K Sanchez1943-03-13——7645 Sage Ct, Fresno, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-417489CLMGloria Nelson1954-09-08UHC-36758-70—8017 Main St, Nashville, TN, 372060.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-431355CLMDaniel Fowler1974-12-04UHC-99397-30—9441 Broadway, Atlanta, GA, 303000.64Name split from “Last, First”Member ID reformattedCity re-casedGender normalised+2 more
CLM-413107CLMHenry X Hanson—UHC-69978-70—8735 Bayshore Dr, Houston, TX, 770670.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-414952CLMKathryn T Gonzalez1988-08-13UHC-91606-76—4472 Main St, Minneapolis, MN, 554830.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-410422CLMEthan Grant1983-09-09——9820 Highland Ave, Austin, TX, 787530.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-412123CLMJeffreey G Gonzalez1980-02-24UHC-50032-3542252639234581 Meadow Ln, Austin, TX, 787440.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-413201CLMJacqueline Little1987-12-24UHC-07892-65—8051 Camelback Rd, Eden Prairie, MN, 553030.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-411205CLMHelen S Robinson1996-03-10UHC-80098-32—1332 Hillcrest Rd, Atlanta, GA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-412274CLMJames E Watkins1998-10-19—57929202574317 Union St, Tucson, AZ, 857010.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413837CLMDylan Rivera1988-12-22UHC-21374-4035286397052045 Meadow Ln, Glendale, AZ, 853490.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-429401CLMTerry Z Fernandez1991-06-18UHC-71155-96—2920 Pine Dr, Atlanta, GA, 303300.64Date of birth reformattedPhone missing area codeMember ID reformattedState code upper-cased+2 more
CLM-407197CLMBrandon Murpphy—UHC-35997-9586197636095643 Valley View Dr, Houston, TX, 770690.64Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
CLM-416211CLMTheresa Hawkins2007-04-19UHC-64409-7645924378449763 Central Ave, Austin, TX, 787410.64Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+2 more
CLM-401690CLMDorothy Jacobs1942-02-04UHC-33416-5543220116562626 River Rd, Fresno, CA, 937710.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421576CLMMichael Hanson1983-07-01UHC-75772-3321127051713342 Sage Ct, Fresno, CA, 937380.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-402980CLMWei M Grza1952-02-20UHC-23414-2573533099465913 Meadow Ln, Houston, TX, 770350.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-408186CLMJen M Hernandez1993-04-16UHC-59220-89—2179 Pine Dr, Los Angeles, CA, 900730.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-419923CLMRuth Stone1994-03-21UHC-84684-4771034095328778 Sunset Blvd Apt 28, Nashville, TN, 372660.64Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-415008CLMWilson Brenda1972-01-28UHC-84051-8474958899943725 Central Ave, Tampa, FL, 336440.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402552CLMSara P Riley1968-11-24—56047079042720 Forest Ave, Tucson, AZ, 857430.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404047CLMAlan M Diaz1979-12-10UHC-23825-89—9173 Sunset Blvd, Las Vegas, NV, 891100.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432301CLMJohn Gutierrez1954-03-15UHC-13252-62—470 Ridge Rd, Austin, TX, 787480.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414327CLMTheresa Mills2000-03-14—50655590502359 Market St, Tucson, AZ, 857140.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428143CLMMei Tran1998-11-01UHC-37090-4849978536009864 Hillcrest Rd, Columbus, OH, 432630.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428144CLMMei Tran1998-11-01UHC-37090-4849978536009864 Hillcrest Rd, Columbus, OH, 432630.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419314CLMKayla McDonald2004-09-08—40426349033292 Church St, Atlanta, GA0.64Phone reformattedState code upper-casedZIP missingGender normalised+2 more
CLM-408963CLMGerald Sanders1971-07-11—76647264204583 Palm Dr, Miami, FL0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-409677CLMMargaret Hernadnez2008-07-14UHC-56059-24—7702 Main St # 989, Miami, FL, 331280.64Name re-casedDate of birth reformattedUnit split from streetGender normalised+2 more
CLM-424688CLMGeorge Wright1952-09-05UHC-78782-5993058996247428 Spring St, Houston, TX, 770690.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408211CLMMichael Wallace1939-08-27——1586 Cedar Ln, Los Angeles, CA, 900490.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414178CLMElizabeth Howard2001-12-10——6188 Church St, San Antonio, TX, 782140.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412863CLMAmber Riley1998-12-12UHC-46144-7753981406653250 Forest Ave, Jacksonville, FL0.64Date of birth reformattedPhone reformattedMember ID reformattedState name converted to code+2 more
CLM-412864CLMAmber Riley1998-12-12UHC-46144-7753981406653250 Forest Ave, Jacksonville, FL0.64Date of birth reformattedPhone reformattedMember ID reformattedState name converted to code+2 more
32,829 rows, page 127 of 657PreviousNext