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-420148CLMSusan Yang2000-01-13UHC-21009-42—3414 Church St, Jacksonville, FL0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-403691CLMGary V Weber1980-03-13UHC-46874-68—7590 Forest Ave, Seattle, WA, 981000.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414140CLMRaymond Banks1966-04-28UHC-72994-01—3219 Grand Ave, Eden Prairie, MN0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-412170CLMElizabeth Young1979-01-13UHC-34103-14—6703 Sage Ct, Miami, FL, 331330.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-428068CLMStephen X Rios1965-11-22——1021 Ocean Ave, Charlotte, NC, 282720.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420777CLMCarol Turner1968-07-17UHC-07012-53—6068 Main St, Mesa, AZ, 852300.52Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-400335CLMTerry Edwards1951-05-18—91463554921429 Desert Sky Blvd Apt 15, Miami, FL, 331690.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408467CLMJudy Payne1950-01-20——1141 Indian School Rd, Minneapolis, MN, 554020.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415266CLMAlbet W Richadrs1994-01-03—34650883913265 Church St, Chandler, AZ, 852460.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429008CLMPeter Garrett1989-03-09—67243641686303 Church St, Orlando, FL, 328310.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428187CLMVictoria Ramirez1987-10-14—48284578523413 Desert Sky Blvd Apt 7, Mesa, AZ, 852670.52Phone reformattedUnit split from streetState name converted to codeGender normalised+2 more
CLM-432103CLMKimberly Carlson—UHC-99272-77—8110 Highland Ave # 212, Mesa, AZ, 852140.52Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+2 more
CLM-425773CLMJoan J Soto1981-05-17—75788535561004 Apache Blvd, Los Angeles, CA, 900000.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402226CLMAlice Singh1983-02-16——4384 Main St, San Antonio, TX0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410012CLM—Junk1981-10-05UHC-80308-05—1263 Harbor Blvd, Gilbert, AZ, 852770.52Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-402492CLMDanielle Bishop1974-09-14——5050 Desert Sky Blvd, Houston, TX, 770670.52Name split from “Last, First”Date of birth reformattedCity re-casedZIP+4 trimmed+2 more
CLM-404273CLMAdam Clark1994-12-09UHC-19041-5720884205314456 Park Pl, Denver, CO, 802010.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431768CLMHiroshi B Day1998-11-02——9870 Apache Blvd Apt 30, Mesa, AZ, 852780.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418121CLMDonald Sullivan1972-02-12UHC-55880-2681742480369412 Main St Apt 14, Fresno, CA, 937090.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-415125CLMHarrison M Adm2008-10-07UHC-57645-54—2956 Sage Ct, Minneapolis, MN0.52Middle initial moved out of first nameName re-casedTwo-digit birth yearZIP missing+2 more
CLM-419334CLMGregory F James1971-03-22——8867 Hillcrest Rd # 519, Charlotte, NC, 282490.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420170CLMMaria G Armstrong1965-02-02UHC-58502-70—6800 Maple Ave, Tampa, FL, 336770.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
CLM-402268CLMSamantha Padilla———2359 Union St, Columbus, OH, 432140.52Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-422230CLMSamuel Perkins1969-08-26—6179691045514 Meadow Ln, Los Angeles, CA, 900330.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402930CLMGregory Morales1942-12-05UHC-11323-443389600893999 Jefferson Ave, Chandler, AZ, 852710.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427032CLMRebecca Garcia—UHC-03053-8750293876133630 Baseline Rd Apt 21, San Diego, CA, 921200.52Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+2 more
CLM-416312CLMKathleen Johnston1964-01-05—65960693611204 Highland Ave, Los Angeles, CA0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415910CLMJanice Owens———1736 Harbor Blvd, Jacksonville, FL0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-415911CLMJanice Owens———1736 Harbor Blvd, Jacksonville, FL0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-431654CLMKenneth Sims1975-11-15UHC-21958-69—4019 Baseline Rd, Minneapolis, MN, 554340.52Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-418817CLMHenry R Jordan1968-05-02—36124317723607 Ridge Rd, Tampa, FL, 336460.52Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+2 more
CLM-402498CLMNatalie Romero1970-11-09UHC-05876-8824395312141511 Baseline Rd, Glendale, AZ, 853390.52Name split from “Last, First”Date of birth reformattedMember ID reformattedState name converted to code+2 more
CLM-412332CLMJuan J Santiago1988-05-17UHC-94054-778593034625166 Union St, Plano, TX, 750370.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414881CLMJoan Matthews2006-02-15——2720 Bayshore Dr, Fresno, CA, 937740.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-416778CLMAdam Li1945-01-18UHC-03793-43—51 Oak St, Houston, TX, 770500.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411854CLMChristine Ortiz1975-01-27UHC-56393-98—9138 Apache Blvd, Glendale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-421795CLMAndrew Hunt2008-11-21UHC-90052-31—7960 Meadow Ln, Mesa, AZ0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410940CLMCarl Boyd1942-12-18UHC-08601-36—8407 Washington St, Mesa, AZ, 852690.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429791CLMAshley Coleman1950-09-15——4299 Washington St, Los Angeles, CA, 900570.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
CLM-410547CLMDanielle Ford2006-12-08UHC-47400-49—9012 Central Ave # 672, Plano, TX, 750810.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+2 more
CLM-402786CLMLuis Wallace1939-02-04UHC-03439-0344559311126713 Main St, Columbus, OH, 432320.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-417747CLMCharles Richardson1963-11-23UHC-92117-87—9013 Highland Ave # 714, Minneapolis, MN, 554830.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414661CLMSusan Carr2005-06-19UHC-11023-15—5207 Pine Dr, Las Vegas, NV, 891770.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-417885CLMBetty Patel1959-02-07UHC-54842-23—1321 River Rd, Charlotte, NC, 282910.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-430497CLMEric Harris1989-03-15UHC-75275-07—2516 Ridge Rd, Los Angeles, CA, 900640.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408787CLMJacob D Hoffman1997-03-25——6402 Willow Ct, Chandler, AZ, 852360.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-418790CLMElijah Ruiz1981-01-18UHC-16462-6124141508051368 Grand Ave, Mesa, AZ, 852490.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418435CLMMichelle Kennedy1950-05-17UHC-09693-8263548128815675 Cedar Ln, Austin, TX, 787800.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-422973CLMMelissa Owens1972-03-18UHC-20322-63—7251 Sunset Blvd # 673, San Antonio, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403669CLMLawrence Estrada1944-10-22UHC-71464-18—4645 Harbor Blvd, Columbus, OH, 432900.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
32,829 rows, page 41 of 657PreviousNext