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-409137CLMTeresa Munoz1989-10-02UHC-84425-4080676783483237 Palm Dr, Orlando, FL, 328900.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401530CLMHenry Patick1975-08-15UHC-39305-02—4132 Palm Dr, Glendale, AZ, 853500.62Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-404663CLMRoger Payne2005-04-06UHC-87094-7422866991522210 Ridge Rd, Chandler, AZ, 852100.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413029CLMMarilyn Peterson1942-12-11——2853 River Rd, Phoenix, AZ, 850700.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406628CLMAnthony Collins1966-02-19UHC-59860-58—1720 Pine Dr, Charlotte, NC, 282510.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427229CLMKevin Nguyen1977-12-18UHC-97416-9777961407333474 Palm Dr, Tempe, AZ, 852820.62Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-414198CLMNathan W Hudson1968-11-07UHC-52176-20—432 Main St, Atlanta, GA0.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-426473CLMDeboreh Castro1938-01-23—84270933483560 Church St # 317, Gilbert, AZ, 852560.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-403666CLMKenneth R Schultz1944-12-20UHC-13416-252282432552455 Washington St # 912, Nashville, TN, 372800.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-426837CLMJoe Bishop1967-10-04—62582594363979 Elm St, Gilbert, AZ, 852640.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403920CLMZachary G Carlson2003-10-23——6475 Jefferson Ave, Denver, CO, 802730.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-415058CLMRaymond Kim2002-05-10UHC-89856-22—1535 Main St, Tempe, AZ, 852970.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-404614CLMEugene Perkins1991-05-21UHC-74376-09—8300 Canyon Rd, San Antonio, TX, 782430.62Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
CLM-412183CLMKathryn Hart——61561471281868 Park Pl, Jacksonville, FL, 322150.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-431915CLMJuan Myers2000-11-12—96234495185401 Park Pl, Dallas, TX, 752810.62Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+3 more
CLM-407642CLMEdward Brouks1938-02-01UHC-00554-30—3916 Apache Blvd, Eden Prairie, MN, 553770.62Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-421106CLMStephen U Elliott1993-12-09—7068913399209 Maple Ave, Columbus, OH, 432320.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-421920CLMKevin Burke1985-11-22——5265 Main St, Eden Prairie, MN, 553870.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427016CLMHenry Alvarado1960-08-24UHC-71930-799898795800569 Highland Ave, Austin, TX, 787260.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-403816CLMJesse Alvarez1939-04-07UHC-20741-2564164467818496 Harbor Blvd, Scottsdale, AZ, 852710.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-427777CLMBilly Romero1992-09-22UHC-51311-1245131299006253 Church St, Mesa, AZ, 852940.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412896CLMGregory Delgado1968-04-21UHC-32595-6981667375324695 Lincoln Way, Austin, TX, 787420.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-420522CLMJudith Ford1949-12-12—80737444804607 Mountain View Dr, Miami, FL, 331470.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424571CLMEugene Nichols1980-03-11UHC-77317-26—1911 Palm Dr, Phoenix, AZ, 850310.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403371CLMJulia Dean1959-11-20—49841466586505 Highland Ave, Jacksonville, FL, 322730.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-424345CLMHeather Vazquez1956-05-14—68760949581445 Central Ave, Glendale, AZ, 853990.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406908CLMEmily X Greene1972-11-07UHC-54979-0129755597074133 Willow Ct, Chandler, AZ, 852860.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-430989CLMDennis Kelley2006-05-23—87960662951820 Pine Dr, Las Vegas, NV, 891380.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410035CLMBruce Campbell1973-08-02UHC-19587-40—9246 Indian School Rd, Seattle, WA, 981450.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-414092CLMJoseph S Freeman1986-11-01UHC-94064-0976522217783239 Mesa Dr, Orlando, FL, 328960.62Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+3 more
CLM-426924CLMSofia Gonzalez1989-06-16UHC-28733-5253236199922628 Washington St, Nashville, TN, 372340.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402654CLMAmy Murray1952-03-15UHC-24519-12—5657 Central Ave, San Diego, CA, 921440.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-409451CLMRachel Walker1986-02-06—76699102936585 Maple Ave, Chandler, AZ, 852660.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-420229CLMRaymond Elliott—UHC-34636-6284037590838816 Forest Ave, Denver, CO, 802840.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-420228CLMRaymond Elliott—UHC-34636-6284037590838816 Forest Ave, Denver, CO, 802840.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-421300CLMAmber Palmer1958-05-09UHC-28566-35—5064 Church St, Austin, TX, 787480.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430902CLMJean Scott2008-07-28UHC-21473-4782435013578015 River Rd, Minneapolis, MN, 554190.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-404563CLMKathryn Burns2002-02-02UHC-66794-952498568696933 Palm Dr, Glendale, AZ, 853400.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432635CLMJordan Rivera1972-02-16UHC-42809-73—9207 Park Pl, Fresno, CA, 937520.62Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-423235CLMDiana Perkins1972-04-01UHC-40992-4674697238767397 Church St, Nashville, TN, 372970.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421573CLMDiego Espinoza2002-04-14—44888055276566 Valley View Dr Apt 40, Miami, FL0.62Name re-casedPhone reformattedUnit split from streetCity re-cased+3 more
CLM-420364CLMAshley L Ramos1994-03-27—93859219021140 Forest Ave, Jacksonville, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417005CLMJoshua Crawford—UHC-22291-1024454746901591 Bayshore Dr, Glendale, AZ, 853140.62Name re-casedDate of birth missingPhone reformattedCity re-cased+3 more
CLM-409963CLMEthan Hill——22254078773252 Main St, Austin, TX, 787900.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-409865CLMCatherine Harper2000-10-15UHC-66620-68—5487 Ridge Rd, Charlotte, NC, 282230.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405814CLMJordan Munoz1960-08-21UHC-64719-86—5593 Market St, Tucson, AZ, 857860.62Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404266CLMChristina Y Phillips1944-10-12UHC-66533-38—5413 Canyon Rd, Scottsdale, AZ, 852300.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-428813CLMRalph X Tran1938-12-26UHC-19577-6631967390349090 Pine Dr, Sacramento, CA, 958760.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429565CLMRobert Robinson1988-10-05UHC-71882-3785872927056663 Bayshore Dr Apt 36, San Antonio, TX, 782880.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-400158CLMElizabeth Castro1995-05-22—44340976762577 Highland Ave, Atlanta, GA, 303140.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 77 of 657PreviousNext