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-414651CLMAlbert Brooks1974-06-08UHC-42974-77—3371 Elm St, Tempe, AZ, 852590.68Phone missing area codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-432485CLMJack Jacobs———7442 Washington St, Glendale, AZ, 853240.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-425067CLMDanielle Henry1950-11-16UHC-92098-20——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-401053CLMRebecca Kennedy1945-09-11——1156 Lake View Rd, Jacksonville, FL, 322970.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-416595CLMJames Rojas1946-10-27UHC-49912-5931482608507984 Camelback Rd, Nashville, TN, 372060.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-409592CLMEvelyn O Olson2005-11-27—65938570168984 Jefferson Ave, Jacksonville, FL, 322760.68Middle initial moved out of first nameGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-422294CLMArmstrong Noah1955-08-18UHC-54510-4928265073881551 Desert Sky Blvd, Chandler, AZ, 852110.68Name split from “Last, First”Phone reformattedZIP+4 trimmedPlaceholder values cleared
CLM-413441CLMBruce Garza———2756 Ocean Ave, Miami, FL, 331130.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-418611CLMDouglas Day1946-08-13UHC-15264-5455539472483209 Washington St Apt 3, Orlando, FL, 328140.68Phone reformattedUnit split from streetGender normalisedPlaceholder values cleared
CLM-414326CLMLuis Miller1998-03-25——6417 Apache Blvd, Fresno, CA, 937950.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-414729CLMAnggela Perkins———2249 Mountain View Dr, Mesa, AZ, 852980.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421450CLMAna Valdez1946-07-18UHC-83154-98—7974 Elm St, Columbus, OH, 432240.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406817CLMJennifer Turner1959-12-20UHC-61460-3628242362029073 Harbor Blvd, Austin, TX, 787420.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-406818CLMJennifer Turner1959-12-20UHC-61460-3628242362029073 Harbor Blvd, Austin, TX, 787420.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-409142CLMJackie Morales1954-06-28UHC-25443-28—92 Maple Ave, Phoenix, AZ, 850390.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-409871CLMAna Cunninghaam1972-03-03UHC-35095-35—1845 Desert Sky Blvd, Scottsdale, AZ, 852990.68Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased
CLM-408260CLMPamela Hicks1951-06-04UHC-52905-09—5492 Highland Ave, Seattle, WA, 981980.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-421341CLMGloria Martinez1959-09-01UHC-12879-76—840 Central Ave # 941, Las Vegas, NV0.68Name re-casedUnit split from streetZIP missingPlaceholder values cleared
CLM-400888CLMFatima L Kennedy1989-05-07UHC-77591-05—8239 Central Ave, San Antonio, TX, 782930.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408385CLMDenise Olson1951-05-11UHC-65886-442374533779—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-428032CLMLawrence Johnston1981-05-16——5252 Highland Ave # 413, Tempe, AZ, 852400.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-427196CLMWilliam Rose1964-03-08UHC-55154-36—5030 Cedar Ln, Phoenix, AZ, 850350.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-427811CLMSteven George1984-07-09UHC-26902-16—6220 Lincoln Way, Seattle, WA, 981280.68Date of birth reformattedState name converted to codeGender normalisedPlaceholder values cleared
CLM-415870CLMTerry Gomez2002-01-21UHC-97945-44—875 Grand Ave, Eden Prairie, MN, 553590.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-425156CLMMry P Olson1959-05-05UHC-41659-11—853 Forest Ave, Orlando, FL, 328300.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-429674CLMRachel Baker2006-10-24——4703 Ocean Ave # 214, Tucson, AZ, 857070.68Unit split from streetState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-401082CLMJames Bryant2000-12-16UHC-67105-34—8331 Mesa Dr, Glendale, AZ, 853770.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-401081CLMJames Bryant2000-12-16UHC-67105-34—8331 Mesa Dr, Glendale, AZ, 853770.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-415085CLMNathan Salazar1968-03-03UHC-92123-2184483588973670 Meadow Ln, Los Angeles, CA, 900040.68Phone reformattedState name converted to codeGender normalisedPlaceholder values cleared
CLM-431575CLMCatherine Wright1952-12-03UHC-46069-4836930479914260 Lake View Rd, Jacksonville, FL, 322560.68Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed
CLM-428063CLMCarolyn Henry1941-09-17UHC-10251-23—924 River Rd, Dallas, TX, 752560.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-407160CLMDylan Stewart1969-11-13UHC-17496-87—1139 Willow Ct, Mesa, AZ, 852540.68Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased
CLM-412149CLMRoger Bishop1958-03-26UHC-15509-764324305118695 Canyon Rd, Austin, TX, 787980.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-427689CLMTimothy Pena1965-11-13——1439 Park Pl, Sacramento, CA, 958870.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410472CLMCheryl Collins1992-04-14UHC-48515-8347832513555401 Church St, Los Angeles, CA, 900770.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-400610CLMRoger P Tran—UHC-00583-1876165715742965 Camelback Rd, San Antonio, TX, 782380.68Name re-casedDate of birth missingGender normalisedPlaceholder values cleared
CLM-406472CLMLauren Jordan1995-07-18——3684 Ridge Rd, Minneapolis, MN, 554920.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-408012CLMHenry Espinoza1967-08-19——5789 Apache Blvd, Seattle, WA, 981470.68Name split from “Last, First”Two-digit birth yearState code upper-casedWhitespace trimmed
CLM-408011CLMHenry Espinoza1967-08-19——5789 Apache Blvd, Seattle, WA, 981470.68Name split from “Last, First”Two-digit birth yearState code upper-casedWhitespace trimmed
CLM-410962CLMMarttha Patel1948-05-04——7106 Harbor Blvd Apt 2, Las Vegas, NV, 891840.68Name split from “Last, First”Date of birth reformattedUnit split from streetPlaceholder values cleared
CLM-421523CLMSuusan Maldonado1997-06-14—84283364871448 Camelback Rd, Miami, FL, 331290.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-414081CLMRichard Welch1944-11-08——765 Jefferson Ave, Phoenix, AZ, 850630.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-416412CLMAmber B Bryant1989-11-09UHC-16604-78——0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-408941CLMSusan Garrett1939-08-02UHC-86282-68—4507 Ridge Rd, Denver, CO, 802560.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-415543CLMEugene Roberts1991-08-14——5606 Lincoln Way, San Antonio, TX, 782850.68Date of birth reformattedState name converted to codeZIP+4 trimmedPlaceholder values cleared
CLM-413503CLMMariana R Lee1972-01-02UHC-21542-39—6393 Main St, Austin, TX, 787060.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-419664CLMBeverly Lynch1991-04-16UHC-58484-01—7879 Washington St, Sacramento, CA, 958670.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-419249CLMMarcus Carroll1943-06-03—2709835662—0.68Name split from “Last, First”Phone reformattedSSN last four extractedPlaceholder values cleared
CLM-402921CLMGerald Hudson1950-12-20—20251009021693 Market St, Tampa, FL, 336740.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430535CLMEthan T Ramos1996-07-20UHC-82654-905419892694—0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
32,829 rows, page 207 of 657PreviousNext