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-408677CLMJanice Burton1955-04-03——5988 Baseline Rd, Seattle, WA, 981790.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412919CLMDonna Edwards1999-01-16UHC-67089-1182453614636844 Union St, Austin, TX, 787370.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-430208CLMPaul R Carpenter—UHC-05394-1678996299403274 Desert Sky Blvd, Plano, TX, 750440.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410431CLMKatherine Hansen——88420036869220 Lake View Rd, Los Angeles, CA, 900640.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416831CLMPriya Reynolds1995-05-20——3380 Camelback Rd, Tucson, AZ, 857540.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404921CLMJeszica Tores1971-07-02——1126 Elm St, Atlanta, GA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403118CLMDoris H Weber1959-08-24——851 Mountain View Dr Apt 40, Chandler, AZ, 852360.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405853CLMKelly Aguilar——24327054255312 Ridge Rd, San Antonio, TX, 782460.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401601CLMMichelle Greene1957-03-15—61571875953486 Camelback Rd, Eden Prairie, MN, 553410.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-423350CLMGerald T Ruiz1989-02-10UHC-14467-4523464812638019 Canyon Rd, Columbus, OH, 432510.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-431112CLMPatricia Burns1954-03-14UHC-97556-3981425349148332 Washington St, San Diego, CA, 921770.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-401818CLMCarlos Wood2002-12-16UHC-66810-53—7823 Market St, Eden Prairie, MN0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432591CLMChristine Sims1992-06-03UHC-77833-6380887245205333 Bayshore Dr # 847, Los Angeles, CA, 900250.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-401031CLMKelly A Robertson1953-07-20UHC-92382-3495977595149873 Mountain View Dr, Tucson, AZ, 857860.64Middle initial moved out of first nameName re-casedMember ID reformattedState name converted to code+2 more
CLM-406487CLMSteven Schmidt1995-02-05UHC-49596-7973972638558944 Central Ave, Orlando, FL, 328700.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-400109CLMPriya Griffin1949-11-04UHC-95233-699116045800229 Elm St, Atlanta, GA, 303600.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-429926CLMMariana Sullivan1995-08-21UHC-13963-60—2901 Central Ave, Columbus, OH, 432000.64Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-405827CLMFields Mayr1988-03-05UHC-83147-5567235711529296 Oak St, Gilbert, AZ, 852480.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-404909CLMKathryn Carpenter1943-01-12——9041 Palm Dr, Gilbert, AZ, 852160.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-408157CLMAmy Freeman—UHC-93204-01—2646 Desert Sky Blvd, Sacramento, CA, 958950.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-411213CLMStephanie Z Torres2006-11-14UHC-99975-09—3934 Forest Ave, Mesa, AZ, 852950.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-415001CLMAlan J Hfofman1971-07-28UHC-60711-4356243247995888 Church St, Mesa, AZ, 852470.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405734CLMBeverly Hughes1988-06-28——3148 Cedar Ln, Plano, TX, 750030.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-419812CLMMargaret G Chavez1972-11-16—928203869127 Sage Ct, Seattle, WA, 981310.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-429959CLMJerry Dean1977-11-14——5719 Lincoln Way, Charlotte, NC0.64Name re-casedPhone missing area codeCity re-casedZIP missing+2 more
CLM-429242CLMGeorge Q Howell————0.64Name re-casedDate of birth unreadableEmail lower-casedGender normalised+2 more
CLM-421841CLMPhilip Owens2004-08-19——391 Sunset Blvd, Fresno, CA, 937970.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400393CLMEthan Lewis1948-02-25UHC-22221-92—5473 Lincoln Way, Houston, TX, 770410.64Name split from “Last, First”City re-casedGender normalisedPlan code upper-cased+2 more
CLM-422341CLMAlbert Gardner1993-09-01UHC-51913-363099985364232 Jefferson Ave, Mesa, AZ, 852990.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-419473CLMMargaret Bryant1978-09-05UHC-57103-4893668167049466 Church St, Gilbert, AZ, 852270.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428011CLMMichael Williams1957-11-18UHC-52094-0578670112676144 Palm Dr, Glendale, AZ, 853940.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426849CLMKathryn J Thompson1988-02-25UHC-66658-75—9214 Forest Ave, Minneapolis, MN, 554160.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418064CLMSantiago Martinez1959-06-09UHC-34421-479322157494225 Harbor Blvd, Minneapolis, MN, 554330.64Name re-casedPhone reformattedState name converted to codeEmail lower-cased+2 more
CLM-405830CLMBarbara Wallace1984-12-25UHC-80497-3578072979473506 Willow Ct, Phoenix, AZ, 850810.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419698CLMRalph Fisher1980-10-06UHC-03677-05—4339 Elm St # 241, Charlotte, NC, 282680.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431831CLMMaria Hart1957-06-22——6164 Oak St, Tempe, AZ, 852630.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424384CLMSteve Campbell1987-11-27—72571928354595 Union St # 765, Plano, TX, 750990.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430357CLMRyan Morgan1999-03-04UHC-41447-0927869293044448 Church St, Chandler, AZ, 852320.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-419444CLMJoe Bishop1966-10-26UHC-58513-779089607735—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-431164CLMRachel Walker1993-07-16UHC-21829-60—5745 Willow Ct, Denver, CO, 802510.64Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+2 more
CLM-420957CLMDennis Baker1960-04-15UHC-04952-257579563538954 Sunset Blvd Apt 19, Scottsdale, AZ, 852880.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-423230CLMJudith Hicks1972-05-26UHC-95621-67—7709 Desert Sky Blvd, Sacramento, CA, 958010.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-422289CLMDanielle Kennedy1951-09-09UHC-96120-7071559470203051 Camelback Rd, Tampa, FL, 336010.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-408441CLMSean V Sanders2004-02-05UHC-48053-23—3327 Grand Ave, Scottsdale, AZ, 852640.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424789CLMStephanie B Jenkins1972-11-19UHC-66957-9542660982111363 Sunset Blvd, Columbus, OH, 432520.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-424262CLMLawrence Carpenter1948-04-25——132 Valley View Dr, Columbus, OH, 432810.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-417297CLMLawrence Chapman1975-10-20——3172 Ocean Ave, Austin, TX, 787700.64State code upper-casedZIP+4 trimmedEmail lower-casedGender normalised+2 more
CLM-425335CLMMarcus Porter1949-11-29—2345966785958 Market St # 936, Fresno, CA, 937840.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430851CLMGabriel Snyder1939-07-15——3508 Broadway, Miami, FL0.64Name re-casedDate of birth reformattedPhone missing area codeCity re-cased+2 more
CLM-421752CLMLinda T Johnon——87872457193980 Baseline Rd, Columbus, OH, 432150.64Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
32,829 rows, page 143 of 657PreviousNext