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-420196CLMSharon Woods2002-07-05UHC-33271-36—6811 Lake View Rd, Plano, TX0.66Date of birth reformattedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-415829CLMHeather Jones1988-04-22UHC-15154-41—7379 Broadway, Dallas, TX, 752910.66State code upper-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-420379CLMGeorge Weaver1961-03-13——6059 Bayshore Dr, San Antonio, TX, 782430.66Two-digit birth yearCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-411327CLMMelissa U Woong—UHC-05164-20—4112 Park Pl, Las Vegas, NV, 891450.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-407676CLMChristine H Carpenter1987-07-20UHC-18449-395964267462—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
CLM-420976CLMSophia Reid1993-12-11UHC-39328-57—1738 River Rd, Columbus, OH, 432840.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-428684CLMMaria Perez2004-11-22—29539911354071 Park Pl, Tempe, AZ, 852040.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-413171CLMSusan Thompson1978-07-14UHC-86388-83—3690 Cedar Ln, Mesa, AZ, 852910.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-416855CLMJeff Mendoza1965-08-12——3159 Canyon Rd, Dallas, TX, 752210.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-413644CLMLauren Hill1970-11-09——7973 Park Pl, Denver, CO, 802830.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-419947CLMArmstrong D Bradley1947-12-15UHC-69711-5749588183177778 Willow Ct, Eden Prairie, MN, 553310.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-419948CLMArmstrong D Bradley1947-12-15UHC-69711-5749588183177778 Willow Ct, Eden Prairie, MN, 553310.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-400755CLMElijah Brown—UHC-31375-51——0.66Name re-casedDate of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-404139CLMWillie Schmidt1942-05-12UHC-28576-15—446 Maple Ave, Houston, TX, 770300.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-423193CLMNicholas Jenkins1935-07-18UHC-11466-9536356353836227 Spring St # 643, Tucson, AZ, 857880.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-413540CLMJesse Pierce1947-07-27UHC-13009-43—4125 Canyon Rd Apt 29, Tucson, AZ, 857030.66Name re-casedUnit split from streetCity re-casedGender normalised+1 more
CLM-403983CLMSandra Price1965-04-25—26971041861307 Lincoln Way, Atlanta, GA, 303380.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-428002CLMHelen Garia1973-01-28—90826052008801 Forest Ave, Fresno, CA, 937200.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-426936CLMAshley Garza1971-09-10——6125 Park Pl, Plano, TX, 750860.66Name re-casedDate of birth reformattedPhone missing area codeGender normalised+1 more
CLM-418656CLMGary Tucker—UHC-38611-50—5434 Desert Sky Blvd, Orlando, FL, 328530.66Name re-casedDate of birth unreadableCity re-casedGender normalised+1 more
CLM-422773CLMJesse D Cunningham———9591 Palm Dr, Tempe, AZ, 852110.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407212CLMKimberly Mnuoz2007-12-22UHC-59562-45—5212 Spring St, Jacksonville, FL, 322370.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-422270CLMJim E Hanson1984-11-23—62225284626778 Ocean Ave, Miami, FL, 331170.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-415036CLMKeyth Fox1938-04-08——4939 Sage Ct, Tempe, AZ, 852770.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-413589CLMAhmed Hayes1995-10-10UHC-59600-2524077238461557 Baseline Rd, Fresno, CA, 937020.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-415605CLMJeffrey Black1965-06-10UHC-98383-43—3498 Ridge Rd, Tucson, AZ, 857790.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431562CLMBeverly George1939-04-15——9835 Palm Dr Apt 39, Plano, TX, 750880.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-426862CLMEugene M Crawford1954-05-05——4182 Highland Ave, Nashville, TN, 372480.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-402780CLMJohnston Carol1943-08-12——130 Elm St, Seattle, WA, 981430.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-411029CLMCarolyn K Chen2006-09-02——2822 Sunset Blvd, Glendale, AZ, 853140.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-400760CLMMei Parker1994-08-21UHC-57662-1366494609489632 Baseline Rd, Fresno, CA, 937610.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-406679CLMDon Torres1963-09-18UHC-28843-56—4999 Jefferson Ave, Charlotte, NC, 282400.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-418560CLMStephen Cox1997-04-01UHC-91227-85—9136 Broadway # 863, San Antonio, TX, 782080.66Date of birth reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
CLM-406462CLMEric Long———4296 River Rd, San Antonio, TX, 782730.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-409223CLMDouglas R Crawford1943-12-25UHC-51847-36——0.66Name re-casedTwo-digit birth yearPhone missing area codeMember ID reformatted+1 more
CLM-421973CLMDonald Cole1981-09-23UHC-18671-9447640196423084 Camelback Rd, Jacksonville, FL, 322520.66Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
CLM-428499CLMJose Powell1975-07-26UHC-57609-34—8444 Highland Ave, Chandler, AZ, 852860.66Name re-casedDate of birth reformattedSSN last four extractedZIP+4 trimmed+1 more
CLM-431473CLMHenry Jacobs1962-05-18UHC-84856-83—6411 Forest Ave, Las Vegas, NV, 891880.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
CLM-425136CLMHiroshi Carter1967-11-03——5104 Ocean Ave, Denver, CO, 802960.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402619CLMJulie Olson1972-11-08UHC-69723-76——0.66Date of birth reformattedSSN last four extractedGender normalisedWhitespace trimmed+1 more
CLM-413370CLMMarcus White1948-02-10——3172 Main St, Scottsdale, AZ, 852990.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-420422CLMVictoria Campbell1950-12-06UHC-88823-2244568980501779 Cedar Ln, San Antonio, TX, 782690.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-408433CLMRyan Diaz1991-04-01—32121051741621 Willow Ct # 290, Columbus, OH, 432950.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-430015CLMTimothy Gilbert1986-03-10—36950128417975 Camelback Rd, Nashville, TN, 372280.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-405129CLMSofia Obren1966-03-16UHC-11144-41—7485 Ridge Rd, Jacksonville, FL, 322860.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-420420CLMBruce Davis1963-02-04UHC-59299-76—7325 Willow Ct, Houston, TX, 770810.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-419783CLMLucia E Parker1955-11-12UHC-17810-44—5680 Elm St, Austin, TX, 787040.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429065CLMLauren Silva—UHC-22401-0624874984567322 Ocean Ave, Phoenix, AZ, 850990.66Date of birth missingPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-424335CLMWei Vazquez2006-01-12—58036746842703 River Rd # 829, Glendale, AZ, 853580.66Phone reformattedUnit split from streetCity re-casedGender normalised+1 more
CLM-423980CLMJerry Dominguez1959-04-24——8695 Indian School Rd # 260, Austin, TX, 787840.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
32,829 rows, page 178 of 657PreviousNext