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-430095CLMJean O Nelson1987-09-12UHC-20738-64—5776 Ridge Rd, Charlotte, NC, 282360.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-414674CLMRachel Ray1956-09-26——4441 Palm Dr, Fresno, CA0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-402907CLMPeter Brooks1965-09-18—24746979062138 Union St, Seattle, WA, 981640.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400842CLMNancy Lane1944-12-15UHC-50508-5180128626617624 Main St, Columbus, OH0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424868CLMHiroshi Brooks1990-08-15UHC-65032-3343857371302677 Washington St, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-423629CLMJoan Knight1997-11-15UHC-05751-1594147038453802 Highland Ave, Fresno, CA, 937960.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-422993CLMBetty G Gomez1977-06-09—3774138090347 Main St, Tampa, FL, 336320.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-423634CLMCarol M Franklin1938-04-22UHC-98866-30—8103 Union St, Tempe, AZ, 852920.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-407545CLMJuan Tran2007-06-20—4312024556354 Central Ave Apt 33, Plano, TX0.50Name re-casedPhone reformattedUnit split from streetZIP missing+3 more
CLM-406320CLMStephanie Vargas1954-12-15—78781452465974 Desert Sky Blvd, Fresno, CA, 937450.50Name split from “Last, First”Two-digit birth yearCity re-casedState code upper-cased+3 more
CLM-426792CLMScott Vazquez1997-04-28UHC-50406-7633057329097201 Sunset Blvd, Charlotte, NC, 282250.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426791CLMScott Vazquez1997-04-28UHC-50406-7633057329097201 Sunset Blvd, Charlotte, NC, 282250.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407023CLMRuth Weaver1986-01-08UHC-27012-03—7988 Mesa Dr Apt 4, San Antonio, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-424854CLMThomas Butler—UHC-27322-9623427843497572 Central Ave, Scottsdale, AZ, 852420.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-411426CLMTim Rice1953-04-19—98140069207553 Desert Sky Blvd, Tucson, AZ, 857230.50Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-429063CLMMichael Mills1996-08-15——1624 Mountain View Dr Apt 5, Nashville, TN, 372730.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408448CLMJoshua Walsh1988-08-25UHC-33244-92—3529 Union St # 381, Eden Prairie, MN, 553490.50Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
CLM-404482CLMMaria Fields2000-02-10—45638138069137 Ocean Ave, Sacramento, CA, 958380.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418056CLMBrittany W Nunez2006-06-06UHC-13686-8957480793582966 Cedar Ln, Seattle, WA, 981950.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405960CLMJudy P Wells1938-01-11UHC-84471-0328720051969036 Valley View Dr, Tempe, AZ, 852110.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-432583CLMMateo Caarlson1937-10-22—5974108821805 Ocean Ave, Atlanta, GA, 303820.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405155CLMGregory Hunt1978-09-14UHC-84710-60—4621 Sage Ct, Scottsdale, AZ0.50Date of birth reformattedMember ID reformattedSSN last four extractedZIP missing+3 more
CLM-401606CLMMartha Simmons2002-02-09——1191 Park Pl # 792, Atlanta, GA, 303060.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-407003CLMGrace Lawrence1990-02-28UHC-55097-42—5929 Central Ave, Glendale, AZ0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432319CLMJustin Powell1983-02-13UHC-42263-27—2150 Spring St, Columbus, OH, 432550.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-412069CLMRuth Dunn2002-12-22——1310 Apache Blvd, Tampa, FL, 336230.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-406629CLMWilliam Howard1946-05-27—63221577719694 Bayshore Dr, Nashville, TN, 372770.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402399CLMBeth Jimenez1945-05-25UHC-65211-83—8362 Hillcrest Rd # 155, Columbus, OH0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408511CLMBobby I Dominguez2005-12-21UHC-26590-88—1263 Canyon Rd Apt 7, Dallas, TX, 752650.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-410849CLMCharlotte Kennedy2008-05-19—22730032891168 Apache Blvd, San Diego, CA, 921460.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-421557CLMDonald Stewart———5415 Highland Ave, Minneapolis, MN, 554980.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422632CLMHeather Hudson1938-03-05—9293965350359 Jefferson Ave, Fresno, CA, 937710.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-426350CLMMaria R Jordan1979-04-01——7536 Central Ave, Atlanta, GA, 303850.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432163CLMJordan Thoomas1948-03-05UHC-00688-86—5317 Jefferson Ave, Sacramento, CA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-416985CLMKenneth Henry2001-05-17UHC-27427-73—4427 Forest Ave, Dallas, TX0.50Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+3 more
CLM-421393CLMMason Miller1955-12-23UHC-52836-22—825 Mountain View Dr, Houston, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402885CLMNoah Chapman2002-04-15——397 Palm Dr, Phoenix, AZ0.52Name split from “Last, First”Date of birth reformattedPhone missing area codeCity re-cased+2 more
CLM-417906CLMAmanda I Fsher1970-08-21UHC-11517-28—5090 Willow Ct # 378, Phoenix, AZ, 850070.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-401956CLMAshley Murphy1952-10-12——1854 Oak St, Las Vegas, NV, 891560.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-407497CLMMartha Weaver1987-08-11UHC-63216-91—7449 Jefferson Ave, Scottsdale, AZ, 852260.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-424698CLMRonald Valdez1978-10-18UHC-61056-5572874688169019 Central Ave, Jacksonville, FL, 322340.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416196CLMCarol Dunn1959-09-09UHC-98857-51—5140 Apache Blvd, Fresno, CA, 937310.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429152CLMSusan Hanson1982-10-01UHC-29460-4527152302714755 Maple Ave Apt 23, Minneapolis, MN, 554880.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-428027CLMCarl Russell1970-11-28UHC-40882-68—3970 Palm Dr, Dallas, TX, 752040.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-412842CLMGeorge P Evans1942-02-04UHC-58786-7186256003364569 Mesa Dr, Scottsdale, AZ, 852960.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-418020CLMJessica Gordon———7519 Pine Dr, Sacramento, CA, 958100.52Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429084CLMMariena Williamson1967-04-01—48588576832955 Church St, Fresno, CA0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-400624CLMHarold E Martin1989-10-04—89026719451613 Highland Ave, Seattle, WA, 981250.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-413734CLMFrank Austni1964-07-03UHC-35904-15—93 Oak St Apt 26, Austin, TX, 787510.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400880CLMJanet Wright1966-09-20UHC-45348-02—4019 Maple Ave, Minneapolis, MN, 554150.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 39 of 657PreviousNext