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, flag “Date of birth missing”, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagDate of birth missingClear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-430682CLMDennis Delgado—UHC-37047-8437889847257235 Bayshore Dr, Fresno, CA, 937250.80Date of birth missingPhone reformattedMember ID reformattedPlaceholder values cleared
CLM-430681CLMDennis Delgado—UHC-37047-8437889847257235 Bayshore Dr, Fresno, CA, 937250.80Date of birth missingPhone reformattedMember ID reformattedPlaceholder values cleared
CLM-430933CLMJason Bennett—UHC-05560-6430748507989140 Lake View Rd, Tempe, AZ, 852960.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-426972CLMTimothy Floores——58642316329101 Baseline Rd, San Antonio, TX, 782600.80Date of birth missingPhone reformattedCity re-casedPlaceholder values cleared
CLM-406422CLMStephanie X Burns———2406 Indian School Rd, Charlotte, NC, 282310.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-400675CLMHannah Rice—UHC-84078-38——0.80Name re-casedDate of birth missingMember ID reformattedPlaceholder values cleared
CLM-407190CLMKimberly Robinson——7686883529—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
CLM-406425CLMElijah E Lawrence—UHC-97485-21——0.80Date of birth missingMember ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-401562CLMOmar Obrien———9372 Mountain View Dr, Tampa, FL, 336130.80Name re-casedDate of birth missingCity re-casedPlaceholder values cleared
CLM-429540CLMAhmed Senders———7646 Willow Ct, Atlanta, GA, 303100.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-404613CLMWei Y Schmidt—UHC-72575-7331894839401246 Apache Blvd, Houston, TX, 770220.80Date of birth missingCity re-casedWhitespace trimmedPlaceholder values cleared
CLM-405159CLMAlexis Fox—UHC-32649-3667545965657627 Indian School Rd, Gilbert, AZ, 852000.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
CLM-406263CLMDylan P Reid—UHC-31001-11—6707 Meadow Ln, Atlanta, GA, 303450.80Date of birth missingCity re-casedEmail lower-casedPlaceholder values cleared
CLM-430301CLMAndrea Martinez—UHC-02997-04——0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-402408CLMJustin J Brooks—UHC-41144-38——0.80Date of birth missingMember ID reformattedWhitespace trimmedPlaceholder values cleared
CLM-403865CLMMegan Richardson—UHC-70659-16——0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-426637CLMJesse P Moreno—UHC-10876-977536730803—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
CLM-410321CLMMark Evans—UHC-79386-51——0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-426893CLMAmanda Santiiago————0.80Name re-casedDate of birth missingWhitespace trimmedPlaceholder values cleared
CLM-402540CLMJames Delgado——2208398187—0.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
CLM-430474CLMHannah Morrison—UHC-56979-48—3111 Grand Ave, Austin, TX, 787280.82Date of birth missingCity re-casedPlaceholder values cleared
CLM-403460CLMMason Yang—UHC-23214-9353099657795607 Broadway, Seattle, WA, 981860.82Date of birth missingAddress re-casedPlaceholder values cleared
CLM-403461CLMMason Yang—UHC-23214-9353099657795607 Broadway, Seattle, WA, 981860.82Date of birth missingAddress re-casedPlaceholder values cleared
CLM-421039CLMEvelyn X Gray—UHC-85134-327259017365—0.82Date of birth missingPhone reformattedPlaceholder values cleared
CLM-413309CLMDiana Perry—UHC-40741-22——0.82Name re-casedDate of birth missingPlaceholder values cleared
CLM-401521CLMGloria Perry——6383412876—0.82Date of birth missingPhone reformattedPlaceholder values cleared
CLM-427826CLMNatalie Morgan——77093570535647 Hillcrest Rd, Nashville, TN, 372930.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-427758CLMDenny Kelly—UHC-02487-955688398896—0.82Date of birth missingPhone reformattedMember ID reformatted
CLM-427422CLMPriya Collins—UHC-11691-57——0.82Name re-casedDate of birth missingPlaceholder values cleared
CLM-420861CLMJoan Meyer————0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-414332CLMLina Weaver—UHC-83189-3850027178063756 Meadow Ln, Plano, TX, 750570.82Date of birth missingPhone reformattedPlaceholder values cleared
CLM-410508CLMSamuel Martinez—UHC-28309-59—6530 Cedar Ln, Glendale, AZ, 853030.82Name re-casedDate of birth missingPlaceholder values cleared
CLM-432247CLMFrank B Allen————0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-430193CLMKyle Knenedy—UHC-77184-965887905978—0.82Date of birth missingPhone reformattedPlaceholder values cleared
CLM-430194CLMKyle Knenedy—UHC-77184-965887905978—0.82Date of birth missingPhone reformattedPlaceholder values cleared
CLM-422559CLMLarry Foster————0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-414403CLMDanielle Ramirez—UHC-25825-422959054328—0.82Date of birth missingPhone reformattedPlaceholder values cleared
CLM-412710CLMRandy F Dixxon———6924 Willow Ct, Atlanta, GA, 303810.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-415717CLMPorter John—UHC-39257-537939670501—0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-413219CLMAlbert Fisher—UHC-40609-82——0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-416667CLMMatthew Cruz—UHC-91463-54—7979 Pine Dr, Eden Prairie, MN, 553740.82Date of birth missingCity re-casedPlaceholder values cleared
CLM-418986CLMAhmed Sanders—UHC-07701-0642099771322821 Sunset Blvd, Sacramento, CA, 958770.82Name re-casedDate of birth missingPlaceholder values cleared
CLM-431241CLMMariana N Cook————0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-426968CLMChris Delgado————0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-400062CLMChristian Ruz—UHC-95544-56——0.82Name re-casedDate of birth missingPlaceholder values cleared
CLM-421934CLMKenneth Ryan————0.82Date of birth missingPlan code upper-casedPlaceholder values cleared
CLM-411368CLMJonathan E Wheeler——9602096387—0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-400651CLMArjun Lucas————0.82Name re-casedDate of birth missingPlaceholder values cleared
CLM-424722CLMDaniel Garcia———645 Union St, Orlando, FL, 328050.82Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-424273CLMMcDonald Kathryn—UHC-36310-1284140399997145 Elm St, Phoenix, AZ, 850600.82Date of birth missingPhone reformattedPlaceholder values cleared
320 rows, page 6 of 7PreviousNext