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-408174CLMKen Kelly1966-06-27—48958813996640 Indian School Rd, Tucson, AZ, 857220.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409832CLMLauren Campbell1955-08-07UHC-32015-39—6268 Main St, Tucson, AZ, 857180.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-403532CLMMateo Kim1983-07-15—41439748121057 Mountain View Dr, Atlanta, GA, 303380.68Name re-casedPhone reformattedState name converted to codeGender normalised
CLM-426097CLMDaniielle Schultz1914-07-01UHC-73966-94—7494 Union St, Eden Prairie, MN0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-426941CLMCatherine Johnson1947-05-23——9299 Palm Dr, Seattle, WA, 981700.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-419769CLMCatherine Davis1961-02-12——6282 Ridge Rd, Miami, FL, 331470.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-418288CLMNatalie Stewart—UHC-71635-918013968414—0.68Date of birth unreadablePhone reformattedGender normalisedWhitespace trimmed
CLM-405662CLMBrenda Bennett1945-06-16——2887 Ridge Rd, San Antonio, TX, 782860.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-431043CLMDoris T Mendez1997-11-25UHC-89129-89—4014 Harbor Blvd, Miami, FL, 331780.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-409926CLMBrittany Crawford1950-05-27UHC-52699-22—9286 Highland Ave, Charlotte, NC, 282010.68Phone missing area codeMember ID reformattedGender normalisedPlaceholder values cleared
CLM-432216CLMPatrick G Lawrence—UHC-40638-05—3024 Canyon Rd, Minneapolis, MN, 554450.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-418097CLMVictoria I Peterson2004-03-17UHC-99908-60—3004 Valley View Dr, Dallas, TX, 752290.68Middle initial moved out of first nameStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-402808CLMJoyce P Guerrero1962-03-27UHC-29388-20—549 Washington St, Nashville, TN, 372200.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
CLM-402174CLMPyane Bryen1956-12-24———0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-411568CLMSantiago L Miller1951-02-23UHC-98037-769432530574963 Mountain View Dr, Sacramento, CA, 958930.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
CLM-424247CLMRichard Murphy1992-02-22UHC-66444-91—546 Lincoln Way, Chandler, AZ, 852230.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-401385CLMJean M Bennett1988-07-22UHC-16157-76—7675 Meadow Ln, Atlanta, GA, 303290.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-423888CLMJudy Montgomery1962-02-14—70038757486221 Central Ave, Eden Prairie, MN, 553880.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-422705CLMVirginia Cunningham1956-10-16——2093 Bayshore Dr, Charlotte, NC, 282970.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-422550CLMBobby Payne1988-08-17UHC-54861-76—7432 Palm Dr # 275, Columbus, OH, 432480.68Name re-casedSSN last four extractedUnit split from streetPlaceholder values cleared
CLM-429966CLMJulia L Boyd1948-03-02UHC-64928-9598873378364048 Union St, Dallas, TX, 752640.68Middle initial moved out of first namePhone reformattedGender normalisedWhitespace trimmed
CLM-407437CLMChristopher Adams1956-06-26——4764 Spring St, Atlanta, GA, 303330.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-414085CLMEvelyn Nguyen2003-06-09—20673588215532 Union St, Tucson, AZ, 857390.68City re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-408647CLMChristine G Rice1958-01-11UHC-59929-4662558141173788 Jefferson Ave, Houston, TX, 770400.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-424726CLMJerry Jordan1997-06-11UHC-64857-05—2771 Spring St # 470, Tempe, AZ0.68Name re-casedUnit split from streetZIP missingPlaceholder values cleared
CLM-431378CLMArjun Burton1938-05-13UHC-81734-9244860578714451 Grand Ave, Eden Prairie, MN, 553440.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
CLM-404016CLMTerry Carter2003-06-11UHC-90297-29—721 Apache Blvd, Austin, TX, 787640.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421210CLMSteven R Price1939-01-16UHC-78273-41—2043 Grand Ave, Houston, TX, 770620.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410931CLMDoris Simms1987-06-10UHC-19611-18—2883 Oak St, San Diego, CA0.68Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing
CLM-418324CLMOmar Moore—UHC-47663-422598112902—0.68Name re-casedDate of birth unreadableGender normalisedPlan code upper-cased
CLM-429856CLMKyle Austin1987-03-04UHC-55692-22—8976 Spring St Apt 11, Atlanta, GA, 303870.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-412223CLMPriya R Henry1997-12-11——6340 Mountain View Dr, Gilbert, AZ, 852390.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-431140CLMRoger Franklin————0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-401054CLMRebecca Kannedy1945-09-11UHC-19364-47—1156 Lake View Rd, Jacksonville, FL, 322970.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-426995CLMHarold Matthews1967-11-23UHC-47451-76—1371 Elm St, Nashville, TN, 372120.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-406888CLMPriya F Cook1956-08-04——8550 Cedar Ln, Eden Prairie, MN, 553260.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-425042CLMPatrick H Jordan1948-08-20UHC-27638-2990096363895088 Mesa Dr, San Antonio, TX, 782690.68Date of birth reformattedState name converted to codeGender normalisedPlaceholder values cleared
CLM-431848CLMRoy U James2008-11-12UHC-07344-395557193929—0.68Name re-casedSSN last four extractedGender normalisedPlaceholder values cleared
CLM-417751CLMHeather S Pierce1966-05-21——3017 Ocean Ave, Minneapolis, MN0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-408774CLMGary Jimenez1976-03-26UHC-29986-91——0.68SSN last four extractedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-405671CLMDiego E Johnston————0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-405218CLMCarol Davis1951-10-03—91553480328959 Cedar Ln, Nashville, TN, 372330.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412965CLMSusan George1989-04-05UHC-79821-24—1170 Spring St, Fresno, CA, 937390.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410997CLMAlvarez Mateo1941-05-08UHC-77283-6258946449298785 Meadow Ln, Los Angeles, CA, 900840.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-400148CLMJennifer Cole1962-10-12——5396 Elm St, Charlotte, NC, 282310.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-411118CLMKimberly E Duncan1998-07-10UHC-38947-74—5867 Forest Ave, Columbus, OH, 432290.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-427766CLMAnthony Harris2002-11-20—83643901456767 Palm Dr, Orlando, FL, 328330.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
CLM-406382CLMVincent Jenkins1960-10-26—5849638809789 Oak St, Tampa, FL, 336960.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-420010CLMEdward W Elliott1979-05-08UHC-33180-88—2976 Park Pl, Tempe, AZ, 852300.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-403100CLMRuht Black1962-11-09UHC-63053-4622280507833100 Washington St, Plano, TX, 750230.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
32,829 rows, page 209 of 657PreviousNext