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-408650CLMJerry I Price1995-10-18——7498 Forest Ave Apt 3, San Antonio, TX, 782920.54Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-412253CLMJordan Wheeler1954-09-25UHC-10993-15—9746 Mesa Dr, Mesa, AZ, 852580.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-429854CLMAmanda Phillips1950-10-15—22290005133745 Canyon Rd # 260, Mesa, AZ, 852020.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-406827CLMSamuel Murphy1938-03-23UHC-88511-6964962997275850 Main St, San Diego, CA, 921140.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-406566CLMAnthony Rios1984-09-02UHC-38512-88—5354 Camelback Rd # 268, Gilbert, AZ, 852460.54Unit split from streetState code upper-casedZIP+4 trimmedGender normalised+1 more
CLM-429369CLMDona Cook1944-02-16UHC-09751-962563339851599 Washington St, Fresno, CA, 937120.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-431582CLMAaron Morris1945-05-07——6297 Lake View Rd # 445, Scottsdale, AZ, 852760.54Name re-casedTwo-digit birth yearUnit split from streetZIP+4 trimmed+1 more
CLM-411238CLMJoyce Q Spencer1948-01-17UHC-22576-11—5505 Baseline Rd, Orlando, FL, 328890.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-421240CLMAnthony Collins1995-05-10UHC-10472-57—6148 Washington St, Houston, TX, 770710.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-420102CLMLuis Cooper—UHC-43368-79—3847 Maple Ave # 829, San Diego, CA, 921390.54Date of birth unreadableUnit split from streetCity re-casedState name converted to code+1 more
CLM-430254CLMShirley Brooks1980-12-17UHC-51174-59—9743 Sage Ct, San Diego, CA, 921190.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-424414CLMIsabella Adams1984-04-08UHC-34881-59—5521 Church St, Jacksonville, FL, 322760.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-425122CLMSamantha Lawrence1940-04-12UHC-39266-73—7120 Washington St, Tucson, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-421261CLMDorothy Bradley1952-09-12UHC-61130-896219104998634 Canyon Rd, Seattle, WA, 981000.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-408076CLMThomas Espinoza—UHC-83698-81——0.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-421814CLMAbigail Allen1999-01-07UHC-78813-14—2171 Oak St # 361, Tampa, FL, 336830.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407560CLMBrandon Boyd1988-06-11UHC-74380-08—2563 Union St, Glendale, AZ, 853950.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-405352CLMSantiago Gardner1988-07-05——628 Oak St, San Antonio, TX0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-428446CLMMichael K Holmes1999-05-15——6651 Broadway, Dallas, TX, 752630.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-420917CLMSam Ward1988-04-23UHC-59135-15—2150 Church St, Gilbert, AZ0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-432461CLMMartha Z Williamson1995-08-06UHC-86118-06—364 Broadway # 411, Plano, TX, 750940.54Two-digit birth yearPhone missing area codeUnit split from streetWhitespace trimmed+1 more
CLM-430676CLMHiroshi Sims1972-10-22UHC-85479-92—393 Lincoln Way, Fresno, CA, 937660.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-412548CLMRachel D Coleman1949-10-19——935 Meadow Ln Apt 14, Atlanta, GA, 303760.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-429043CLMRaymond Mason1997-01-09——2597 Mountain View Dr, Austin, TX, 787470.54Name split from “Last, First”SSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
CLM-430240CLMAustin Robinson1955-04-05UHC-83901-9524399025971519 Ridge Rd, Tampa, FL, 336610.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-406467CLMElizabeth Fox2005-12-07——9575 Ocean Ave, Los Angeles, CA, 900570.54State name converted to codeZIP+4 trimmedGender normalisedPlan code upper-cased+1 more
CLM-431970CLMJohn Wood1978-07-17UHC-22176-7169539176432517 Park Pl, Mesa, AZ, 852130.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-404469CLMJesse Santos1981-06-19UHC-21978-49—8431 Palm Dr, Phoenix, AZ, 850860.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-432107CLMJohn F Cox——24096568539483 Desert Sky Blvd, Houston, TX, 770620.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408024CLMAngela Salazar—UHC-63436-6469964129685809 Mountain View Dr, Minneapolis, MN, 554060.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425288CLMAna Banks1964-10-09UHC-54583-9062179605332552 Union St, Houston, TX, 770450.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-419592CLMJess Lane1971-09-20UHC-38571-5675892106137112 Grand Ave # 411, Phoenix, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-417410CLMRobert M Soto1978-02-19—59665172371690 Church St, Miami, FL, 331320.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-428757CLMGabirel Sanders2006-05-23—96459396701842 Broadway, Jacksonville, FL, 322490.54Phone reformattedState name converted to codeZIP+4 trimmedEmail lower-cased+1 more
CLM-428758CLMGabirel Sanders2006-05-23—96459396701842 Broadway, Jacksonville, FL, 322490.54Phone reformattedState name converted to codeZIP+4 trimmedEmail lower-cased+1 more
CLM-403502CLMLori Duncan1965-10-18UHC-77386-40—2740 Oak St, Plano, TX, 750930.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-400905CLMAdam Walsh1956-08-01UHC-75549-6367562200016706 Lincoln Way, Denver, CO, 802210.56Two-digit birth yearState name converted to codeGender normalisedWhitespace trimmed
CLM-410152CLMHenry I Hunter—UHC-15194-32——0.56Name split from “Last, First”Date of birth missingGender normalisedPlaceholder values cleared
CLM-413141CLMSerah Olson2002-10-06UHC-21778-6775640190996116 Willow Ct, Fresno, CA, 937860.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
CLM-429646CLMMegan Garrett1944-02-14UHC-79469-26—3207 Cedar Ln, Los Angeles, CA, 900370.56Name split from “Last, First”Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-406874CLMJonathan Ferguson1945-06-13UHC-93124-89—8474 River Rd # 349, San Diego, CA, 921900.56Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased
CLM-416950CLMDenise X Padilla—UHC-97647-24—1651 Hillcrest Rd, Denver, CO0.56Date of birth unreadableState name converted to codeZIP missingPlaceholder values cleared
CLM-412075CLMRussell Williamson1947-11-06UHC-57475-82—1151 Maple Ave # 756, Miami, FL, 331200.56Two-digit birth yearUnit split from streetGender normalisedPlaceholder values cleared
CLM-409242CLMHannah Oliver1951-07-08UHC-60027-75—926 Oak St, Scottsdale, AZ0.56Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing
CLM-422545CLMEdward Dunn—UHC-83791-65—4734 Cedar Ln, Los Angeles, CA, 900610.56Name split from “Last, First”Date of birth missingGender normalisedPlaceholder values cleared
CLM-407677CLMPeter Kelly—UHC-28833-255439815708—0.56Name split from “Last, First”Date of birth unreadableGender normalisedPlaceholder values cleared
CLM-424393CLMJoyce Sandoval1952-02-20——8989 Spring St, Chandler, AZ, 852240.56Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised
CLM-413028CLMPeterson Marilyn1942-12-11UHC-78588-21—2853 River Rd, Phoenix, AZ, 850700.56Name split from “Last, First”Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-403649CLMBecky Q Williams1972-11-15UHC-01047-48—5115 Elm St, Dallas, TX0.56Name split from “Last, First”Phone missing area codeZIP missingPlaceholder values cleared
CLM-407083CLMBryan Carter1973-11-26—38595413102538 Valley View Dr, Austin, TX, 787200.56Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised
32,829 rows, page 61 of 657PreviousNext