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-412134CLMBryan O Flores1969-04-28UHC-43147-53—8493 Market St, San Antonio, TX, 782730.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-403653CLMKle Salazar1988-04-26UHC-42261-8066531225163160 Valley View Dr, Phoenix, AZ, 850720.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-401675CLMDonald Hudson1990-02-28——6575 Elm St, Miami, FL, 331750.66SSN last four extractedCity re-casedGender normalisedWhitespace trimmed+1 more
CLM-426259CLMRussell C Mitchell1999-04-06UHC-20750-76—9101 Canyon Rd, Tampa, FL, 336870.66Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-417119CLMTerry Snyder2007-04-01UHC-52224-9078494364595679 Park Pl, Denver, CO, 802010.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-417056CLMScott Edwards1971-04-11UHC-59117-62—7568 Valley View Dr, Gilbert, AZ, 852850.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-418172CLMRachel Maldonado1992-09-16UHC-21658-41—7516 Meadow Ln, Scottsdale, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-405857CLMDylan Gibson1946-04-15UHC-91430-31—3146 Forest Ave, Phoenix, AZ, 850980.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-422617CLMStephanie Day1968-05-02UHC-13402-27—5173 Highland Ave, Atlanta, GA, 303610.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-409863CLMTerry Hall2007-01-15——6584 Harbor Blvd, Phoenix, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-423498CLMJordan Meyer1946-01-10UHC-72377-28—2555 Valley View Dr, Los Angeles, CA, 900600.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-401984CLMWalter Allen———6101 Hillcrest Rd, Nashville, TN, 372940.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-417710CLMNoah James1957-09-12UHC-65636-63—7565 Meadow Ln, Austin, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-417711CLMNoah James1957-09-12UHC-65636-63—7565 Meadow Ln, Austin, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-426349CLMMaria Jordan1979-04-01UHC-32080-45—7536 Central Ave, Atlanta, GA, 303850.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-405305CLMSophia Schultz—UHC-23034-25—2062 Jefferson Ave, Phoenix, AZ, 850190.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-403040CLMAmber Woods2002-02-01——7758 Sunset Blvd, Minneapolis, MN, 554940.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-421675CLMJustin Barnes1994-06-25—78349065672955 Elm St, Mesa, AZ, 852280.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-408156CLMAmy Freeman1944-10-01UHC-93204-0146776039202009 Elm St, Mesa, AZ, 852370.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-409356CLMCarol Csatro1957-07-18UHC-89014-71——0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-409929CLMWalter Little1983-11-18UHC-92544-5256142003685629 Park Pl, Austin, TX, 787460.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-420283CLMEvelyn Vega1982-12-09UHC-27495-63—9814 River Rd # 145, Scottsdale, AZ, 852340.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-418072CLMZachary Maldonado1987-02-22UHC-14103-56—3999 Union St, Houston, TX, 770830.66Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-426538CLMGraham Evelyn1974-05-13UHC-11403-48—8861 Mountain View Dr, Fresno, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-410650CLMHiroshi Lynch—UHC-75411-44—581 Cedar Ln, Tampa, FL, 336260.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402353CLMRalph Woods1967-07-26——6887 Spring St, Tampa, FL, 336710.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413802CLMCharlotte Kelly——98549998923950 Lincoln Way, Atlanta, GA, 303140.66Name split from “Last, First”Date of birth unreadablePhone reformattedWhitespace trimmed+1 more
CLM-431049CLMJanet Adams———9268 Church St, Denver, CO, 802540.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415568CLMBen P Singh1948-11-04——747 Ocean Ave, San Antonio, TX, 782860.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-415613CLMBeverly Hunter1996-11-15——121 Desert Sky Blvd, Plano, TX, 750410.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-430788CLMChristian Anderson1939-07-09UHC-03780-5894587871802042 Washington St, Orlando, FL, 328180.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-406587CLMKelly Gordon1941-07-19——8001 River Rd, Los Angeles, CA, 900200.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-423175CLMNathan Watkins1974-08-06UHC-86219-04—2794 Market St, Minneapolis, MN, 554610.66Street suffix standardisedAddress re-casedState code upper-casedGender normalised+1 more
CLM-421070CLMPaul Kelley1997-01-22—79323982528971 Ocean Ave, Tucson, AZ, 857630.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-417073CLMHannah Williams1972-04-05—68120214937890 Oak St, San Diego, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-421072CLMMason K Ortiz2008-02-08—82724329429428 Lake View Rd, Tempe, AZ, 852620.66Street suffix standardisedAddress re-casedState code upper-casedGender normalised+1 more
CLM-430960CLMAmber C Diaz1955-11-26UHC-29467-2594892644445873 Central Ave Apt 16, Dallas, TX, 752730.66Phone reformattedUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
CLM-421208CLMJeremy Sullivan1981-10-18UHC-15896-3752391767675808 Camelback Rd, Columbus, OH, 432370.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-403154CLMAustn Diaz1938-06-26UHC-30613-6353476109194682 Lake View Rd, Seattle, WA, 981140.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-428805CLMDouglas Stewart1987-03-07UHC-98736-6477341079764478 Cedar Ln, Dallas, TX, 752220.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-419658CLMKimberly Henderson—UHC-76058-1645091116855226 Desert Sky Blvd, Austin, TX, 787720.66Date of birth unreadablePhone reformattedCity re-casedState name converted to code+1 more
CLM-400192CLMAlbert Z Montgomery1971-02-03UHC-48037-67—7534 Cedar Ln, Glendale, AZ, 853840.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411495CLMEdwrd Ward1939-08-01——4128 Washington St, Atlanta, GA, 303010.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-403270CLMJulai J Simpson1946-02-27UHC-55962-37—4726 Mesa Dr, Nashville, TN, 372310.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-404561CLMDavid Daniels2001-05-25——9352 Maple Ave, Houston, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-416991CLMRachel Fisher1949-12-18UHC-38689-22—3418 Palm Dr, Seattle, WA, 981200.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-417522CLMJerry C Brown1976-02-05UHC-23768-79—2285 Church St, Tampa, FL0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-422824CLMWilliam Kelly2007-10-22UHC-90416-44——0.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-405692CLMSantiago A Mendoza1939-10-25——4106 Central Ave, San Diego, CA, 921240.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-414239CLMJeffrey Alvarado——2758519425374 Palm Dr, Charlotte, NC, 282680.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 174 of 657PreviousNext