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-405693CLMBradley Vazquez1943-01-07——9117 Meadow Ln, Atlanta, GA, 303680.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-407320CLMJason H Fowler1940-08-26UHC-57273-8794372453817152 Willow Ct, Dallas, TX, 752390.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414195CLMSantiago Aguilar1970-06-16UHC-15363-0688148119367696 Bayshore Dr, San Antonio, TX, 782410.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429232CLMSoia J Alvarez1970-01-10—40971604513305 Mesa Dr, Orlando, FL, 328020.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-400783CLMFatima Cook1975-03-18——3264 Lake View Rd, Sacramento, CA, 958120.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-431376CLMLogan Porter1973-10-07—31471835041265 Valley View Dr, Mesa, AZ, 852080.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-404717CLMSam Johnston1978-02-08—32327512981434 Palm Dr, Las Vegas, NV, 891120.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-420828CLMPauul S Butler1962-03-16——528 Mesa Dr, Seattle, WA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-404458CLMKelly Baker2006-08-28—27868597564218 Sunset Blvd, San Diego, CA, 921800.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414279CLMZachary Watkins1962-03-15UHC-26709-9271268536309266 Ridge Rd, Atlanta, GA, 303220.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409762CLMAlexander Bryant1972-10-17UHC-16087-5030766362258443 Indian School Rd, Seattle, WA, 981240.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412362CLMMarcus Hall1969-12-13UHC-13563-26—3635 Valley View Dr, Gilbert, AZ, 852430.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-432507CLMKevin Johnston1956-06-01UHC-81285-763885379182—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-428943CLMLarry O Burton1965-02-07UHC-16584-63—782 Pine Dr, Chandler, AZ, 852710.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-420708CLMDennis Torres1989-07-28——8678 Highland Ave Apt 6, Fresno, CA, 937320.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-415763CLMKatherie Le2004-05-21UHC-75014-1965545768509865 Market St, Tempe, AZ, 852240.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419030CLMNatalie Ramos1958-04-23UHC-54434-24—7803 Washington St, Phoenix, AZ, 850460.64Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-415136CLMDoris J Wright1960-06-27UHC-04572-43—5738 Lake View Rd, Orlando, FL, 328410.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429442CLMKevin Mills1948-08-03—62542167977049 Ocean Ave # 714, San Diego, CA, 921290.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-413631CLMHannah Day1991-08-23UHC-89666-892932364050914 Indian School Rd, Minneapolis, MN, 554690.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419231CLMGabriel Esipnoza1939-11-25UHC-49887-40—6048 Lake View Rd, Glendale, AZ, 853300.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423409CLMNicole Arnold1979-05-10UHC-18919-1556233361843165 Mesa Dr, Chandler, AZ, 852310.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-428991CLMHeather Gomez2001-11-26UHC-98871-36—7113 Cedar Ln, Minneapolis, MN, 554350.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-402591CLMMartha Cox1979-02-18UHC-85585-1893490764771474 Oak St, Columbus, OH, 432320.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-428127CLMRoy Alexander1975-11-15—45631263212232 Harbor Blvd, Plano, TX, 750600.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424474CLMJudith C Ramirez1983-10-07UHC-46061-1260953965181586 Bayshore Dr, San Antonio, TX, 782060.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-426118CLMBrenda Wright1976-02-10UHC-18417-49—2852 Central Ave, Orlando, FL, 328350.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-401121CLMAisha Campbell1985-09-27—92426365247867 Grand Ave, Minneapolis, MN, 554550.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426424CLMBeverly Reed—UHC-18578-72—5652 Desert Sky Blvd, Tampa, FL, 336240.64Name re-casedDate of birth reformattedDate of birth unreadableZIP+4 trimmed+2 more
CLM-413879CLMEugene B Evans——51130293999216 Main St, Eden Prairie, MN, 553380.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400620CLMGary J Gutierrez1992-12-06——3140 Canyon Rd, Sacramento, CA, 958940.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425724CLMKimberly Valdze1978-01-20UHC-36608-2021226632695702 Mesa Dr, Sacramento, CA, 958650.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-412237CLMYuki D Boyd1993-05-18——1400 Maple Ave, Chandler, AZ, 852970.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-404015CLMTerry Cartar2003-06-11UHC-90297-29—721 Apache Blvd, Austin, TX, 787640.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422055CLMGreg Bishop1962-08-05—98445914368093 Canyon Rd, Atlanta, GA, 303660.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-402834CLMIsabella D Robertson1986-03-18UHC-58329-99—3669 Bayshore Dr, San Antonio, TX, 782520.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429150CLMCamila N Rios1963-11-18UHC-12493-59—3286 Indian School Rd Apt 18, Tempe, AZ, 852950.64Name re-casedUnit split from streetCity re-casedState name converted to code+2 more
CLM-421822CLMJeffrey Martin1952-12-20——4549 Harbor Blvd, Austin, TX0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-423228CLMJoyce Evans1958-08-12—30138113403579 Park Pl, San Diego, CA, 921080.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424402CLMAmy Parker1963-04-23UHC-88714-34—9756 Lincoln Way # 140, Los Angeles, CA0.64Name re-casedUnit split from streetCity re-casedZIP missing+2 more
CLM-421980CLMGrace Stephens1956-03-05—74966488401151 Palm Dr # 342, San Antonio, TX, 782660.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-406123CLMLogan Thompson1942-05-19UHC-52807-74—6607 Park Pl Apt 8, Las Vegas, NV, 891770.64Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
CLM-412664CLMSharon Jordan1940-10-09UHC-95905-11—9743 Ridge Rd, Jacksonville, FL, 322070.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-411928CLMDorothy W Williamson1958-10-05—69622285946047 Lincoln Way, Dallas, TX, 752100.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-425233CLMPal Lee1963-01-17——129 Canyon Rd, Dallas, TX, 752440.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-414752CLMAmber P Meyer1970-04-13UHC-41600-72—3676 Spring St, Glendale, AZ, 853560.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402974CLMFatima Webb1964-11-20——2690 Desert Sky Blvd, Los Angeles, CA0.64Name re-casedDate of birth reformattedCity re-casedZIP missing+2 more
CLM-406427CLMJean Peters1980-07-14UHC-92982-0144449156825944 Apache Blvd, Miami, FL0.64Date of birth reformattedPhone reformattedState name converted to codeZIP missing+2 more
CLM-413960CLMHarold N Peterson1991-07-04UHC-57880-32—9190 Camelback Rd, Chandler, AZ, 852750.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411300CLMKathryn Parker1945-08-28UHC-62847-1228121017136159 Broadway, Orlando, FL0.64Date of birth reformattedMember ID reformattedAddress re-casedZIP missing+2 more
32,829 rows, page 104 of 657PreviousNext