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-421024CLMJustin G Griffin1966-09-20———0.68Middle initial moved out of first nameDate of birth reformattedGender normalisedPlaceholder values cleared
CLM-400162CLMCynthia L Peterson1984-03-27——5694 Central Ave, Nashville, TN, 372270.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-411608CLMLawrence Weaver1964-02-04UHC-26133-9892921200243519 Church St Apt 15, Tempe, AZ, 852190.68Name split from “Last, First”Date of birth reformattedUnit split from streetWhitespace trimmed
CLM-430038CLMTimothy Geoge1941-06-24UHC-62919-0124128137854259 Valley View Dr, San Diego, CA, 921940.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-400030CLMAlexander Dixon1982-05-07UHC-80497-622185770010—0.68Two-digit birth yearPhone reformattedSSN last four extractedPlaceholder values cleared
CLM-414658CLMSandra Taylor2006-11-26UHC-73410-51—93 Church St, Austin, TX0.68Name re-casedState name converted to codeZIP missingPlaceholder values cleared
CLM-402387CLMSofia Collins1946-10-12——603 Elm St, San Diego, CA, 921760.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-432327CLMAustinJunk1990-12-19UHC-66555-53—7141 Willow Ct, Houston, TX, 770860.68City re-casedGender normalisedPlaceholder values clearedNo usable name (quarantined)
CLM-423724CLMMei F Armstrong1992-06-21UHC-83413-64—6233 Canyon Rd, Plano, TX, 750710.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-406802CLMJacob N Kinng1970-03-14—52367965887963 Lake View Rd # 297, Tempe, AZ, 852660.68Name split from “Last, First”Phone reformattedUnit split from streetPlaceholder values cleared
CLM-432151CLMTimothy Nunez—UHC-87616-0671092596993333 Church St, Los Angeles, CA, 900150.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-428937CLMCamila Walker1964-02-22——5646 Jefferson Ave, San Antonio, TX, 782950.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-432285CLMChristian Wheeler1976-08-08UHC-84072-99—6628 Lincoln Way, Tampa, FL, 336200.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-417036CLMHarold Guerrero1963-05-17UHC-12102-2028428641281994 Pine Dr, Austin, TX, 787800.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-425915CLMRuth Ross1970-04-21——3071 Canyon Rd, Phoenix, AZ, 850960.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406501CLMLawrence Mitchell1940-07-19—64258153505724 Hillcrest Rd, Columbus, OH, 432210.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-407847CLMBobby Dixon1958-01-25UHC-60044-9065043331802777 Washington St, Dallas, TX, 752780.68Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised
CLM-432543CLMPaul P Kelly1989-01-13UHC-35201-48—7184 Apache Blvd, Seattle, WA, 981180.68SSN last four extractedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-412742CLMEric C Nunez1974-11-03UHC-04177-63—1621 Valley View Dr, Chandler, AZ, 852010.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-401765CLMWalter Wang1947-09-13——5093 Grand Ave # 799, Plano, TX, 750900.68Date of birth reformattedUnit split from streetGender normalisedPlaceholder values cleared
CLM-408344CLMAlexander Perez1993-06-05—75665441011775 Lincoln Way, Phoenix, AZ, 850030.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404244CLMMathew Carroll1999-01-17——223 Market St, San Diego, CA, 921250.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-417349CLMDiana Bell1949-01-04UHC-46851-26—6694 Canyon Rd, San Diego, CA0.68Two-digit birth yearZIP missingWhitespace trimmedPlaceholder values cleared
CLM-413851CLMKaren Wong2001-09-25UHC-75927-48—6744 Union St, Tempe, AZ, 852630.68Name re-casedStreet suffix standardisedAddress re-casedGender normalised
CLM-413852CLMKaren Wong2001-09-25UHC-75927-48—6744 Union St, Tempe, AZ, 852630.68Name re-casedStreet suffix standardisedAddress re-casedGender normalised
CLM-418883CLMAmanda Campbell1968-08-28UHC-76091-6229348740315649 Camelback Rd # 792, Mesa, AZ, 852950.68Phone reformattedUnit split from streetGender normalisedPlaceholder values cleared
CLM-409418CLMAnan Hicks2000-07-28UHC-76951-41—4474 Valley View Dr Apt 24, Minneapolis, MN, 554040.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408373CLMCarl Pierce2006-11-15——8360 Sage Ct, Las Vegas, NV, 891450.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-420384CLMRonald P Espinoza1971-03-13——5055 Highland Ave Apt 21, Nashville, TN, 372810.68Middle initial moved out of first nameName re-casedUnit split from streetPlaceholder values cleared
CLM-412815CLMRalph Campbell1989-10-10UHC-69425-15—3390 Oak St, Tempe, AZ, 852410.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-422477CLMTeresa R Fox1981-12-23UHC-90462-0195176926554557 Palm Dr, Orlando, FL, 328650.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-400099CLMJoseph U Simpson1997-04-14——7986 Mountain View Dr, Sacramento, CA, 958220.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-401934CLMAlbert Miller1940-02-09UHC-57977-59—5580 Hillcrest Rd, Orlando, FL, 328700.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-427824CLMDonna Ramos1995-10-06——7499 Baseline Rd Apt 27, Tempe, AZ0.68Unit split from streetZIP missingWhitespace trimmedPlaceholder values cleared
CLM-427825CLMDonna Ramos1995-10-06——7499 Baseline Rd Apt 27, Tempe, AZ0.68Unit split from streetZIP missingWhitespace trimmedPlaceholder values cleared
CLM-424591CLMPaul Estrada1983-07-26——5930 Ridge Rd, Seattle, WA, 981130.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-405499CLMAlexis G Howell1974-10-20UHC-49365-8074726199346614 Union St, Columbus, OH, 432220.68Name re-casedTwo-digit birth yearState name converted to codePlaceholder values cleared
CLM-432797CLMStephen Murray1962-05-26UHC-92761-01—4148 Main St, Seattle, WA, 981010.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-414383CLMKayla N Kelley1951-11-09UHC-25348-74—1189 Meadow Ln, Phoenix, AZ, 850490.68Middle initial moved out of first nameName re-casedTwo-digit birth yearPlaceholder values cleared
CLM-423983CLMMargaret Robinson1938-03-15UHC-05602-98—3266 Elm St, Tucson, AZ, 857820.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-428916CLMKathryn Cooper2000-07-27UHC-35430-35—2987 Spring St, San Antonio, TX, 782360.68Name re-casedState name converted to codeGender normalisedPlaceholder values cleared
CLM-416122CLMCarl Schmidt1963-05-09UHC-97348-98—1359 Pine Dr, Mesa, AZ, 852540.68Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased
CLM-421082CLMRobert Guerrero1949-03-04UHC-68316-58—1020 Washington St # 978, Orlando, FL, 328340.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-419545CLMZachary Evans1988-09-27——724 Forest Ave, Scottsdale, AZ0.68ZIP missingGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421685CLMJustin Maldonado—UHC-51965-78—199 Washington St, Miami, FL, 331530.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-429666CLMJack Robertson1976-04-13——1846 Main St, Glendale, AZ, 853030.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-426441CLMRyan Santos1943-02-27UHC-94423-25——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-421679CLMYukki Gonzales1983-06-23——7979 Pine Dr, Charlotte, NC, 282440.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-425182CLMHenry Ruiz1973-01-02UHC-65473-878145226501662 Willow Ct, Las Vegas, NV, 891540.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-412794CLMJuan B Carpenter2000-06-11UHC-33252-10——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
32,829 rows, page 214 of 657PreviousNext