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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-411452CLMTheresa Jimenez1971-10-04UHC-78147-56—3652 River Rd, Fresno, CA, 937770.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-430731CLMFrank Allen2008-06-15UHC-12886-83—770 Sage Ct, Las Vegas, NV, 891390.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-413143CLMCarter Chriistina1943-10-03—5076300680—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-424276CLMDeborah Vargas1944-06-26UHC-22202-05—4953 Apache Blvd, Minneapolis, MN, 554730.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-416603CLMGloria Jenkins1969-01-04UHC-95347-85—7685 Church St, Houston, TX, 770820.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-419396CLMBarbara Medina1986-07-03UHC-96837-25—4638 Elm St, Seattle, WA, 981640.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-422974CLMMelissa Owens—UHC-20322-63—7251 Sunset Blvd, San Antonio, TX, 782220.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-416631CLMDylan Butler1971-06-18———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-407058CLMBenjamin Yang—UHC-59355-41—8627 Washington St, Phoenix, AZ, 850840.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-415402CLMScott G Guzan1989-02-04UHC-03230-143716428266—0.68Name split from “Last, First”Member ID reformattedGender normalisedPlaceholder values cleared
CLM-415842CLMJeffrey Evans1997-04-07UHC-04470-22—9743 Sunset Blvd, Jacksonville, FL, 322210.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-426371CLMHeather Pena——91555613406554 Baseline Rd, Tucson, AZ, 857080.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-432789CLMNancy G Miller1953-09-11UHC-43773-5477950037813880 Desert Sky Blvd, Dallas, TX0.68Phone reformattedZIP missingGender normalisedWhitespace trimmed
CLM-430284CLMAlexis X Morrison1981-10-24UHC-67872-19—9552 Forest Ave # 901, Austin, TX, 787120.68Unit split from streetCity re-casedGender normalisedPlaceholder values cleared
CLM-431448CLMAnthony Perkins1988-06-09UHC-29134-84—5905 Elm St, Las Vegas, NV, 891130.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406750CLMJerry O Greene1998-10-19UHC-64557-68—8041 Highland Ave, San Diego, CA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-405823CLMCarolyn Luna1947-05-20UHC-73667-01—3808 Forest Ave, Chandler, AZ0.68Name re-casedZIP missingGender normalisedPlaceholder values cleared
CLM-414478CLMJordan Porter2001-04-17UHC-69300-4185959719572631 Highland Ave, Austin, TX, 787070.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-409868CLMSantiago Garza1994-07-26——4439 Highland Ave Apt 19, Atlanta, GA, 303150.68Name re-casedUnit split from streetState name converted to codePlaceholder values cleared
CLM-401478CLMMei Wells1984-12-27UHC-20975-64—7414 Forest Ave, Columbus, OH0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-422379CLMDavid Hicks1957-12-18——3403 Sage Ct, San Diego, CA, 921590.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-422490CLMKevin M Gordon1971-10-03——1023 Ridge Rd, Gilbert, AZ, 852270.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-417656CLMMatthew P Rice1999-03-22——6058 Apache Blvd, Houston, TX, 770660.68SSN last four extractedGender normalisedPlan code upper-casedPlaceholder values cleared
CLM-416516CLMChristian Ferguson1949-08-19UHC-15332-76—7562 Indian School Rd, Fresno, CA, 937330.68Name re-casedPhone missing area codeState name converted to codePlaceholder values cleared
CLM-413284CLMJon I Pierce—UHC-45594-56—4558 Ocean Ave, Chandler, AZ, 852370.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-416120CLMHenry Kennedy1990-11-13UHC-66605-39—9248 Palm Dr, Sacramento, CA, 958600.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-415881CLMMei Luna1959-07-22UHC-88565-33—6214 Pine Dr, Dallas, TX, 752850.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-417019CLMJean L Andrews1940-07-07UHC-62623-6130163280584756 Jefferson Ave, Miami, FL, 331510.68Name re-casedTwo-digit birth yearState name converted to codePlaceholder values cleared
CLM-409008CLMJacqueline Williams1947-08-08——7124 Camelback Rd, Tucson, AZ, 857560.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-432355CLMMariana Morrison1987-05-16—7865220817—0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-407158CLMDylan Stewart1969-11-13——1139 Willow Ct, Mesa, AZ, 852540.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-424741CLMSantiago Peterson1979-11-22——5981 Jefferson Ave Apt 34, Dallas, TX, 752820.68Name re-casedTwo-digit birth yearUnit split from streetPlaceholder values cleared
CLM-409045CLMDoris Ford1985-08-03——4869 Meadow Ln, Mesa, AZ, 852590.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
CLM-416517CLMChristian Ferguson1949-08-19——7562 Indian School Rd, Fresno, CA0.68Date of birth reformattedZIP missingGender normalisedPlaceholder values cleared
CLM-432363CLMAmy Sanchez1972-07-02UHC-63205-9246587172867045 Desert Sky Blvd, Sacramento, CA, 958920.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408839CLMAhmed Vasquez1956-06-02UHC-88338-81—6948 Camelback Rd, Gilbert, AZ, 852820.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-404429CLMJohn Morris1958-12-27——5012 Ridge Rd, Miami, FL, 331060.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-423447CLMMadison Hawkins—UHC-18827-8063654324043643 Forest Ave, Gilbert, AZ, 852310.68Date of birth missingPhone reformattedGender normalisedPlaceholder values cleared
CLM-428214CLMJoan K Hart2000-04-24—57429709248881 Lake View Rd Apt 24, Jacksonville, FL, 322150.68Phone reformattedUnit split from streetGender normalisedPlaceholder values cleared
CLM-432019CLMNicholas Cunningham1971-07-18UHC-89997-7898484488427483 Canyon Rd, Phoenix, AZ, 850890.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432020CLMNicholas Cunningham1971-07-18UHC-89997-7898484488427483 Canyon Rd, Phoenix, AZ, 850890.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-402314CLMCharlotte Matthews2007-07-19UHC-58416-57—9592 Harbor Blvd, Nashville, TN, 372730.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-412019CLMHeather Lynch1961-05-07UHC-96264-48—8994 Broadway, Fresno, CA, 937860.68Name split from “Last, First”City re-casedState name converted to codePlaceholder values cleared
CLM-407038CLMIsabella Gomez1977-02-04UHC-25379-2589924536422400 Willow Ct # 239, Austin, TX, 787220.68Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-410193CLMChristina Burton—UHC-38322-16——0.68Date of birth unreadableMember ID reformattedGender normalisedPlaceholder values cleared
CLM-412511CLMKyle Jensen1954-08-01——5279 Spring St, Las Vegas, NV, 891310.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-416860CLMAmber Jackson1940-04-15——6024 Market St # 790, Plano, TX, 750520.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-417156CLMJesse Dean1985-05-24UHC-90899-50—8179 Ridge Rd, Chandler, AZ, 852060.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-409029CLMVirginia A Porter2005-02-24UHC-89599-46——0.68Middle initial moved out of first nameName re-casedTwo-digit birth yearPlaceholder values cleared
CLM-405788CLMStephen Lewis1958-03-04——3109 Church St, Jacksonville, FL, 322620.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
32,829 rows, page 211 of 657PreviousNext