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-413873CLMTeressa Meyer1962-09-10——9295 Apache Blvd, Las Vegas, NV, 891970.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404455CLMLarry F Martin2001-01-13UHC-92470-7887434531114620 Valley View Dr, San Antonio, TX, 782560.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
CLM-401193CLMKathleen Cox——34260411602530 Mountain View Dr, Jacksonville, FL, 322160.66Date of birth missingPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-404386CLMVJunk1955-05-06—98784422705141 Mesa Dr, Orlando, FL, 328490.66Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared+1 more
CLM-411925CLMZachary Knight1959-07-23UHC-03561-97—6436 Grand Ave, Charlotte, NC, 282900.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-408896CLMSofia Vazquez1971-05-03UHC-95246-52—6152 Apache Blvd, Seattle, WA, 981970.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-408523CLMJulia Z Castro1940-09-04UHC-69783-77—1770 Pine Dr # 439, Sacramento, CA, 958420.66Name re-casedSSN last four extractedUnit split from streetWhitespace trimmed+1 more
CLM-408155CLMElijah Allen1943-12-01—6168902010425 Main St, Tucson, AZ, 857920.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-406399CLMAndrea Stone1993-07-09UHC-78915-54—3159 Jefferson Ave, Eden Prairie, MN, 553380.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-411306CLMRonald Riec1946-09-19UHC-31859-37—2525 Forest Ave, Mesa, AZ, 852890.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-403354CLMJeremy Torres1982-06-17UHC-01486-09—8802 Jefferson Ave, Plano, TX, 750170.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-420877CLMKenneth Gonzales1994-09-09——2617 Cedar Ln Apt 26, Chandler, AZ, 852160.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422303CLMPatricia Hernandez1977-03-19UHC-44396-50—6739 Ocean Ave Apt 12, Dallas, TX, 752360.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421224CLMLogan Howard2004-10-26——3883 Bayshore Dr, Austin, TX, 787450.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-411918CLMJulia Adams1962-04-13——4202 Cedar Ln, Atlanta, GA, 303860.66Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-413707CLMSantiago Moure1963-11-19——3960 Spring St, Nashville, TN0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-414939CLMWilliam Warren1983-04-21UHC-39909-15—7504 Ocean Ave, San Diego, CA, 921510.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-420896CLMDeniel Hernandez1951-02-04UHC-42476-16—2788 Ocean Ave, Minneapolis, MN, 554230.66Name re-casedDate of birth reformattedPhone missing area codeZIP+4 trimmed+1 more
CLM-403728CLMKaren Y Williamson1989-01-28UHC-19624-9161281066486240 Elm St, Columbus, OH, 432390.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-403282CLMJudith Gilbert1955-10-23UHC-52805-667376544676—0.66Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+1 more
CLM-410641CLMBenjamin G Tarn1956-10-03—68328131988544 Indian School Rd, Mesa, AZ, 852330.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-404894CLMWei Harrison—UHC-67650-364509689142—0.66Name split from “Last, First”Date of birth unreadablePhone reformattedWhitespace trimmed+1 more
CLM-429081CLMJoyce Baker1946-03-28UHC-28092-57—9688 Mesa Dr, San Antonio, TX, 782860.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404084CLMJacqueline Black—UHC-52048-1478685493313673 Apache Blvd, Tucson, AZ, 857210.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-425056CLMNicholas S Arnold1980-06-27UHC-28133-87—9623 Forest Ave, Chandler, AZ, 852590.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-432300CLMLara Dunn1946-12-16UHC-26938-12—8726 Apache Blvd, Plano, TX, 750920.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-413140CLMJohnny S Gomez1972-08-27UHC-33926-12—8803 Pine Dr, Tempe, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-413770CLMMaria Mills2002-02-20UHC-87139-7995589961134692 Park Pl, Columbus, OH, 432110.66Date of birth reformattedPhone reformattedSSN last four extractedZIP+4 trimmed+1 more
CLM-409979CLMTimothy B Bennett1999-12-06UHC-36770-15—8571 Bayshore Dr, San Diego, CA, 921780.66Middle initial moved out of first nameStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421943CLMRyan Nunez1950-10-06UHC-12863-6469531164203715 River Rd, Sacramento, CA, 958190.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-419676CLMAbigail P Armstrong2006-10-06UHC-16262-32—9469 Apache Blvd, Dallas, TX, 752310.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-426099CLMGrace Contreras1974-01-01UHC-41914-44—3704 Elm St, Orlando, FL, 328870.66Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-406931CLMAmmber O Delgado1998-09-15UHC-52060-8571689812176469 Market St Apt 22, Minneapolis, MN, 554010.66Phone reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
CLM-402312CLMLucia Espinoza1971-11-16UHC-13836-28—2739 Union St Apt 5, Columbus, OH, 432070.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-406575CLMJustin G Cooper——22886196777406 Spring St, Miami, FL, 331430.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-409353CLMJanet Cole1950-04-16UHC-14286-74—9793 Desert Sky Blvd, Scottsdale, AZ, 852820.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-414295CLMCamila I Ortiz2008-06-21——8674 Cedar Ln, Houston, TX, 770470.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419944CLMRob Price1967-04-12UHC-60747-77—1156 Meadow Ln, Atlanta, GA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-425639CLMHeather Meyer—UHC-17486-97—9200 Harbor Blvd, Charlotte, NC, 282520.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-407510CLMJudy Rose1991-12-22UHC-66936-9645388509882851 Sunset Blvd, Minneapolis, MN, 554170.66Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+1 more
CLM-430582CLMNancy O Carpenter1980-06-07UHC-82726-77—7629 Ocean Ave # 431, Dallas, TX, 752460.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-421242CLMSamuel Hart1982-03-15UHC-45207-32—3954 Desert Sky Blvd Apt 8, Tucson, AZ, 857440.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-403131CLMAishaJunk1945-08-08UHC-81067-89—593 Harbor Blvd, Nashville, TN, 372450.66Date of birth reformattedMember ID reformattedState name converted to codePlaceholder values cleared+1 more
CLM-418295CLMAngela C Matthews1953-01-07—8466837684—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
CLM-429744CLMTyler Munoz1972-05-15UHC-99999-10—3918 Indian School Rd, Los Angeles, CA, 900310.66Date of birth reformattedMember ID reformattedState name converted to codeGender normalised+1 more
CLM-402830CLMBruce Marshall1955-08-22UHC-40229-12—14 Meadow Ln, Charlotte, NC, 282020.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410369CLMAaron Laron1995-06-15—43934930467090 Union St, Minneapolis, MN, 554180.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-415803CLMBrian Daniels1991-04-27UHC-77710-3529851996751346 Grand Ave # 369, Mesa, AZ, 852530.66Name re-casedDate of birth reformattedPhone reformattedUnit split from street+1 more
CLM-431962CLMRalph Andrews1985-06-10——3086 Desert Sky Blvd, Fresno, CA, 937280.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415441CLMEric Cole1986-10-13UHC-82550-3578498532455747 Washington St, Dallas, TX, 752990.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
32,829 rows, page 184 of 657PreviousNext