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-425672CLMPaul Richardson—UHC-64897-23—2787 Park Pl, Tampa, FL, 336690.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-424701CLMSarah Guzman1958-02-16UHC-06472-19—2816 Sage Ct, San Antonio, TX, 782820.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
CLM-403093CLMSharon Olson1999-08-10UHC-00596-77—8016 Willow Ct, Houston, TX, 770600.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-417231CLMHiroshi Vazquez1939-07-09UHC-36775-70—1689 Grand Ave, Dallas, TX, 752580.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403229CLMMegan Perkins1985-09-03——3220 Camelback Rd Apt 8, Seattle, WA, 981960.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-410694CLMDavid Woods2007-12-12—57167532619773 Washington St Apt 24, San Antonio, TX, 782830.52Two-digit birth yearPhone reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-401259CLMNancy Delgado1969-01-08——6958 Park Pl, Orlando, FL, 328160.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414594CLM—Junk1963-06-14UHC-45096-59—3449 Forest Ave, Plano, TX, 750170.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-408906CLMKevin Rice2000-08-06——8670 Main St, Chandler, AZ, 852650.52SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416966CLMAlice Baliey1959-05-04UHC-91287-15—1607 Union St, Phoenix, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-404399CLMNoah Vasquez1962-02-27UHC-16757-75—8356 Camelback Rd # 449, San Antonio, TX0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-428687CLMCynthia V Fuller1974-01-03UHC-17057-28—2479 Park Pl, Charlotte, NC0.52Name re-casedTwo-digit birth yearZIP missingGender normalised+2 more
CLM-405720CLMMary Schmidt1977-05-21——6452 Harbor Blvd, Miami, FL, 331320.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-407303CLMKayla Graham1955-06-10——1485 Baseline Rd, Columbus, OH, 432880.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-427302CLMLogan Vargas1965-06-07UHC-17983-8681192874032581 River Rd, Las Vegas, NV, 891390.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404533CLMHiroshi Kelley1950-10-21——2695 Indian School Rd Apt 9, Phoenix, AZ, 850040.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416795CLMElijah Tucker1958-10-28UHC-81872-55—6906 Harbor Blvd, Plano, TX0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-401659CLMTimothy Carpenter1991-02-01——9850 Mesa Dr, San Antonio, TX, 782520.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421708CLMLauren D Montgomery1963-12-10—74283554492528 Desert Sky Blvd Apt 4, Minneapolis, MN, 554950.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418237CLMEdward C Peterson1965-05-18UHC-86064-90—1428 Maple Ave, Orlando, FL, 328890.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400471CLMMei Harvey1954-12-02——4291 Harbor Blvd, Orlando, FL, 328210.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-404756CLMJesse Gardner1984-12-15UHC-82310-034489826754149 Forest Ave, Los Angeles, CA, 900480.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427294CLMCheryl M Pena1992-06-08UHC-77349-09—5459 Valley View Dr, Minneapolis, MN, 554800.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-411109CLMAdam Rogers1991-02-14UHC-08320-64—550 Valley View Dr, Tampa, FL, 336790.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-431256CLMAndrew Lopez2007-07-26——6398 Spring St Apt 26, Scottsdale, AZ, 852510.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431257CLMAndrew Lopez2007-07-26——6398 Spring St Apt 26, Scottsdale, AZ, 852510.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-416586CLMHeen Mejya1987-01-20UHC-40105-27—9445 Desert Sky Blvd, Eden Prairie, MN0.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-410953CLMAlex Diaz2001-08-14——3718 Mountain View Dr, Eden Prairie, MN, 553180.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-427000CLMGeorge Estrada2008-02-27UHC-75585-02—5649 Harbor Blvd, San Antonio, TX, 782650.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-404695CLMCharles Chapman—UHC-47214-684886556297884 Canyon Rd, Tempe, AZ, 852660.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-422483CLMBobby Wilson1980-12-08——2048 Lake View Rd, San Antonio, TX, 782460.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-424162CLMMaggie Valdez1994-09-01UHC-29630-30—4234 Cedar Ln, Atlanta, GA, 303180.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-420026CLMKayla M Richards1976-01-10——2779 Pine Dr, Dallas, TX0.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-407422CLMMatthew X Valdez2002-06-14UHC-71925-83—4853 Maple Ave, Las Vegas, NV, 891990.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-409982CLMStephen W McCoy1976-03-10—46375248888878 Market St, Scottsdale, AZ, 852600.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402016CLMRaymond Hall1978-08-11——3690 Elm St, San Antonio, TX, 782980.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-430399CLMKenneth Nguyen1982-03-28UHC-63340-98—1311 Palm Dr # 988, Tampa, FL, 336400.52Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-431379CLMArjun Burtoon1938-05-13UHC-81734-92—4451 Grand Ave, Eden Prairie, MN, 553440.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-412669CLMWei Y Willis1982-11-23UHC-22401-11—3743 Willow Ct, Orlando, FL, 328650.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-423773CLMWayne V Thomas2006-10-19UHC-05470-01—5517 Harbor Blvd, Tampa, FL, 336640.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-414640CLMDenise Sanchez1994-11-02UHC-02390-9937693882568771 Market St, Scottsdale, AZ, 852930.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432262CLMJulie N Knight1989-05-17—76299660269298 Lake View Rd # 668, Tucson, AZ, 857450.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-404036CLMChristina Jackson1962-06-02UHC-91939-2798932278567008 Sunset Blvd, Denver, CO, 802970.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-400080CLMJonathan X Price1980-05-14UHC-44743-3290392114086450 Jefferson Ave, Eden Prairie, MN, 553690.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-432056CLMNicholas Hill1939-12-25UHC-19819-24—7755 Canyon Rd Apt 38, Los Angeles, CA, 900890.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-405694CLMKenneth Meedina1992-03-26——4894 Ocean Ave, Las Vegas, NV, 891120.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-400032CLMLauren Williams2002-07-08——3118 Sunset Blvd, Mesa, AZ, 852930.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416679CLMDorothy W Wagner1999-11-07UHC-27472-49—1607 Forest Ave Apt 18, Tucson, AZ, 857330.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-407488CLMMason Ramirez1964-05-03UHC-58089-01—3165 Spring St, Fresno, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-427463CLMMaria Z Patterson1984-10-12UHC-97217-21—2117 Lake View Rd Apt 27, San Antonio, TX, 782360.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 52 of 657PreviousNext