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-414513CLMJonathan Sullivan1969-06-09UHC-02849-7666688858552307 Forest Ave, Charlotte, NC, 282590.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-405735CLMBeverly H Hughes1988-06-28UHC-84048-28—3148 Cedar Ln, Plano, TX, 750030.52Name split from “Last, First”Two-digit birth yearMember ID reformattedStreet suffix standardised+2 more
CLM-415631CLMSJunk1952-06-25UHC-75504-6440421611777190 Sunset Blvd # 502, Glendale, AZ, 853970.52Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-431236CLMJoshua M Gonzales2001-03-06UHC-38587-47—4712 Sunset Blvd, Phoenix, AZ0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-419922CLMRalph Fernandez1943-07-07——1007 Baseline Rd, Las Vegas, NV, 891070.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409811CLMJustin Warren1970-02-02UHC-50704-53—6843 Mountain View Dr, Glendale, AZ, 853500.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402354CLMAngela Williams1995-05-28——7312 Meadow Ln, Jacksonville, FL, 322010.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427485CLMKimberly P Robertson1940-11-18—51162235289549 Apache Blvd, Tempe, AZ, 852960.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422241CLMAdm B Young1992-07-07UHC-88914-9536442597029456 Mesa Dr, Tempe, AZ, 852770.52Middle initial moved out of first nameTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-424405CLMJohn Yang1986-09-23UHC-65125-01—8045 Church St, Phoenix, AZ, 850510.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411414CLMVincent Stewart1939-04-05——8497 Valley View Dr, Jacksonville, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-412378CLMLauren H Lyncch1993-07-24UHC-13897-33—1657 Ocean Ave, San Antonio, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-421638CLMWillie Wang1997-12-05UHC-59116-79—4236 Washington St, Eden Prairie, MN, 553900.52Two-digit birth yearCity re-casedZIP+4 trimmedGender normalised+2 more
CLM-425164CLMKayla W Le2002-03-09UHC-50548-50—2921 Market St, Miami, FL, 331800.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-414678CLMJohn Austin2004-08-01UHC-48708-1345380597159557 Forest Ave, Nashville, TN, 372890.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-426449CLMEvelyn Palmer——60923909248011 Church St, Tucson, AZ, 857580.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429845CLMDiane Huwell1970-06-20—32861414707422 Market St, Charlotte, NC, 282190.52Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+2 more
CLM-411722CLMWilliam Brooks——93873259182965 Oak St, San Diego, CA, 921010.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-426413CLMRachel Kennedy1975-07-09UHC-76272-4494262408818703 Park Pl, Phoenix, AZ, 850290.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-402592CLMOlivia Hughes1985-02-19UHC-11245-96—6459 Lake View Rd, Denver, CO, 802280.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-426169CLMJoan Long—UHC-83158-92—6094 Apache Blvd, Atlanta, GA, 303900.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-404967CLMSam Miller1940-11-09——5308 Grand Ave, Tucson, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-404968CLMSam Miller1940-11-09——5308 Grand Ave, Tucson, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-431602CLMBradley U Carpenter1948-08-08UHC-06430-16—9271 Mountain View Dr, Fresno, CA, 937390.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-432484CLMWei Marshall1979-11-21UHC-81522-17—9172 Sunset Blvd, Tempe, AZ0.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-409990CLMTimothy O Lucas1939-02-26UHC-65767-0879535802226117 Grand Ave, Las Vegas, NV0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416957CLMSantiago Lynch1998-06-15UHC-94650-0832531730922281 River Rd # 188, Las Vegas, NV, 891170.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418274CLMJacob Vazquez1971-07-14—55986488462247 Park Pl, Glendale, AZ, 853510.52Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised+2 more
CLM-404670CLMMargaret Smith1976-01-15UHC-25071-63—1446 Ridge Rd, Chandler, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-404669CLMMargaret Smith1976-01-15UHC-25071-63—1446 Ridge Rd, Chandler, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-411548CLMMartha Washington1951-06-12——8382 Palm Dr Apt 19, Glendale, AZ, 853940.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-407897CLMAlexis B Burton1975-10-05UHC-80754-22—6768 Oak St, Dallas, TX, 752780.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403593CLMMarilyn Hart1953-09-01—7133791846689 Spring St, Denver, CO, 802120.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-417104CLMWest Jacqueline2001-11-06UHC-85592-57—6379 Cedar Ln, Orlando, FL, 328380.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420468CLMJanet T Hicks1980-06-24UHC-23608-8442832261848500 Apache Blvd, Tucson, AZ, 857110.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
CLM-406804CLMAhmed Davis2003-01-10UHC-86559-6886161831163163 Church St, Glendale, AZ, 853910.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416397CLMAisha Chapman1961-09-18UHC-86057-3922546979444462 Cedar Ln # 123, Miami, FL, 331910.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-416976CLMContreras Mark1994-06-05——7677 Indian School Rd, Sacramento, CA, 958310.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416885CLMAisha Garcia—UHC-35298-4525760116746404 Union St, Sacramento, CA, 958760.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417150CLMMariaJunk1977-08-11—44776457507203 Central Ave, Los Angeles, CA, 900800.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415730CLMMadison Castro1952-02-01UHC-96414-21—8120 Main St, Jacksonville, FL, 322230.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401838CLMCaroolyn U Jimenez1942-02-17UHC-13964-61—7201 Meadow Ln, Houston, TX, 770540.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413391CLMJanice Butler1974-06-26UHC-65173-31—5465 Park Pl, San Antonio, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-425469CLMSteven Ramos1969-01-26——1184 Hillcrest Rd Apt 12, Sacramento, CA0.52Name re-casedUnit split from streetZIP missingGender normalised+2 more
CLM-404931CLMCynthia Chapman1978-05-02UHC-75673-50—8451 Willow Ct, Dallas, TX, 752090.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-427801CLM—Junk1993-07-11—42423609701303 Maple Ave, Mesa, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410260CLMDanielle Jenkins1949-07-28UHC-41018-56—5059 Oak St, Nashville, TN, 372150.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406610CLMSophia Carroll1979-02-23——5642 Desert Sky Blvd Apt 21, Atlanta, GA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-422749CLMJulie Banks1988-03-13——2818 River Rd Apt 11, Minneapolis, MN, 554190.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418200CLMLaura Guzman1971-04-20—88476831383197 Ridge Rd Apt 3, Plano, TX, 750220.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 53 of 657PreviousNext