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-419974CLMAnn M Weaver1980-11-21UHC-46632-1690923919682201 Apache Blvd, Miami, FL, 331570.38Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422865CLMSharon Q Reyes—UHC-18188-08—8929 Forest Ave # 477, San Antonio, TX, 782310.38Name re-casedDate of birth missingSSN last four extractedUnit split from street+3 more
CLM-431159CLMShirley Lee———429 Camelback Rd Apt 24, Chandler, AZ0.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406800CLMTeresa Hunt1976-08-13——6343 Lake View Rd, Chandler, AZ0.38Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-402079CLMCarlos Lawrence—UHC-66269-8056124075216107 Mountain View Dr, Phoenix, AZ, 850150.38Name split from “Last, First”Date of birth unreadableMember ID reformattedStreet suffix standardised+3 more
CLM-402080CLMCarlos Lawrence—UHC-66269-8056124075216107 Mountain View Dr, Phoenix, AZ, 850150.38Name split from “Last, First”Date of birth unreadableMember ID reformattedStreet suffix standardised+3 more
CLM-418227CLMTerry Medina1965-02-08UHC-89474-9751843300479633 Sage Ct Apt 4, Eden Prairie, MN, 553160.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-416221CLMArthur Ryan1963-11-16UHC-21613-2570993497513760 Spring St, Los Angeles, CA, 900560.38Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-414368CLMHenry Sullivan—UHC-26067-06—1538 Harbor Blvd Apt 37, Los Angeles, CA, 900760.38Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406858CLMBecky Yang———8845 Harbor Blvd Apt 8, Los Angeles, CA0.38Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408439CLMRalph Carpenter1967-06-11UHC-69808-22—9818 Baseline Rd, Jacksonville, FL0.38Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
CLM-425448CLMLuis Garza1999-10-08——6467 Pine Dr, Nashville, TN, 372580.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-425447CLMSarah Bailey1971-09-27UHC-07917-53—5551 Washington St # 479, Dallas, TX, 752280.38Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405049CLMTimothy Lopez—UHC-58975-8151367266199308 Meadow Ln, Nashville, TN, 372710.38Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431121CLMBradley G Clark——44642953671924 Sage Ct Apt 17, Tampa, FL0.38Date of birth unreadablePhone reformattedUnit split from streetState name converted to code+3 more
CLM-415653CLMChristine Valdez1942-10-24UHC-97505-59—220 Pine Dr, Seattle, WA, 981070.38SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-409866CLMCatherine Harper2000-10-15UHC-66620-68—5487 Ridge Rd Apt 35, Charlotte, NC, 282230.38Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413769CLMBeth Contreras—UHC-92452-26—5635 Sunset Blvd, Fresno, CA, 937190.38Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+3 more
CLM-428210CLMBeverrly Gonzalez———6102 Camelback Rd # 289, Seattle, WA, 981220.38Name split from “Last, First”Date of birth missingUnit split from streetStreet suffix standardised+3 more
CLM-428321CLMCheryl Reynolds—UHC-05597-29—2655 Market St, Minneapolis, MN, 554820.38Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-419690CLMCharles Ray1954-11-10——8155 Harbor Blvd, Mesa, AZ, 852820.38Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-416006CLM—Junk1983-07-26—32043183131048 Hillcrest Rd, Las Vegas, NV, 891880.38Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422797CLMShirley Hunter1958-03-17UHC-87251-2083446627224214 Spring St, San Diego, CA, 921730.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408222CLMSarah Spencer2001-06-11—72968220041763 Ridge Rd Apt 17, Eden Prairie, MN, 553160.38Name split from “Last, First”Phone reformattedSSN last four extractedUnit split from street+3 more
CLM-426981CLMDebra Moore2001-07-06UHC-69722-62—2923 Washington St, Glendale, AZ0.38Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-410844CLMAlbert O Santos1985-08-12—66597909402953 Union St, Chandler, AZ, 852210.38Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410089CLMAisha Chen1944-10-03—74099945295831 Sage Ct, Sacramento, CA0.38Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
CLM-403019CLMNancy S Vazquez1967-08-27UHC-61543-39—4030 Maple Ave Apt 21, Scottsdale, AZ, 852070.38Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-429248CLMDiana Bradley1967-01-01UHC-18488-6096589870052234 Oak St, Austin, TX0.38Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-416908CLMMariana Montgomery1976-07-26UHC-28635-58—2287 Main St # 803, Las Vegas, NV, 891880.38Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-429879CLMJulie Pena1994-12-14——9289 Ridge Rd, Atlanta, GA, 303090.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410113CLMGerald Chavez—UHC-99698-9142682732566886 Central Ave, Seattle, WA, 981860.38Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-432411CLMEdward Michell2000-06-12UHC-60479-18—6374 Park Pl, Mesa, AZ, 852190.38Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408131CLMIsabella Stephens—UHC-87565-33—7416 Lincoln Way, Gilbert, AZ, 852960.38Date of birth unreadableMember ID reformattedState name converted to codeZIP+4 trimmed+3 more
CLM-419389CLMShirley Gutierrez———2473 Willow Ct, San Antonio, TX, 782760.38Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432434CLMAlexis Z Gonzalez1939-04-25UHC-47144-9223184952366187 Jefferson Ave, Chandler, AZ0.38Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-430891CLMChris K Yang1961-08-27——6043 Church St, Chandler, AZ, 852890.38Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-411819CLMChristina Mendoza1999-08-17UHC-20663-15—4058 Washington St, Tempe, AZ, 852590.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423084CLMAna Knight1992-08-10UHC-00835-26—4791 Harbor Blvd, Glendale, AZ0.38Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-412305CLMSharon Davis——53942510765576 Highland Ave, Fresno, CA0.38Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-422061CLMGeorge R Mason———4247 Desert Sky Blvd, Charlotte, NC0.38Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-409125CLMJennifer Bradley1986-09-17UHC-27870-3248684099638203 Park Pl, Houston, TX0.38Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-413411CLMVincent Thompson2006-03-08UHC-83627-9338455797283650 Sage Ct, Charlotte, NC, 282710.38Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424983CLMMarilyn James1952-06-17UHC-01639-27—1285 Palm Dr, Glendale, AZ, 853670.38Name split from “Last, First”Two-digit birth yearSSN last four extractedStreet suffix standardised+3 more
CLM-431969CLMRandy Foster2000-01-18UHC-46657-20—8906 Palm Dr, Denver, CO, 802150.38Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418539CLMAshley Thompson1999-11-22UHC-62776-77—8765 Central Ave, Eden Prairie, MN0.38Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-400767CLMJudith Bradley1951-09-25UHC-02771-2641842221616045 Lake View Rd # 177, Las Vegas, NV0.38Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410563CLMMei Nelson1998-05-06UHC-81996-0993758332686349 Indian School Rd # 558, San Antonio, TX, 782630.38Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-404041CLMBruce Meyer1964-03-22UHC-94064-25—1979 Jefferson Ave # 151, Houston, TX, 770310.38Name split from “Last, First”Two-digit birth yearUnit split from streetStreet suffix standardised+3 more
CLM-413132CLMSteven Kelly1988-03-01——1297 Spring St, Scottsdale, AZ0.38Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 7 of 657PreviousNext