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-421551CLMKing Kevin1980-12-17UHC-00010-37—7344 Indian School Rd, Sacramento, CA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-407924CLMAnn P Howell1972-04-19UHC-08372-8884635179198998 Lake View Rd, San Antonio, TX, 782180.66Two-digit birth yearPhone reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-428586CLMArjun Gonzalez1947-02-08UHC-75702-24—3951 Park Pl, Atlanta, GA, 303690.66Name re-casedCity re-casedState name converted to codeGender normalised+1 more
CLM-422882CLMHannah Ramos1989-05-18UHC-00055-7739067553296381 Desert Sky Blvd # 492, Dallas, TX, 752070.66Name split from “Last, First”Phone reformattedUnit split from streetWhitespace trimmed+1 more
CLM-432126CLMRaymond Richardson1987-01-13——5745 Pine Dr, Gilbert, AZ, 852310.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-401246CLMAisha Holmes2002-05-07——6354 Lincoln Way, San Diego, CA0.66Date of birth reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-401245CLMAisha Holmes2002-05-07——6354 Lincoln Way, San Diego, CA0.66Date of birth reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-411302CLMDonald Anderson1955-04-02UHC-91846-26—6274 Highland Ave, Phoenix, AZ, 850290.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-428705CLMKathryn Carlson1939-12-07—55480832162320 Highland Ave, Las Vegas, NV, 891090.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-405094CLMValentina Alvarado1953-06-20UHC-32928-11—2353 Palm Dr, Orlando, FL, 328310.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-416594CLMJennifer Fernandez1960-01-01UHC-20507-63—4576 Main St, Tempe, AZ, 852380.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-426298CLMDebra L Rose1943-01-01UHC-79132-1656697007804826 Pine Dr, Houston, TX, 770850.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-426297CLMDebra L Rose1943-01-01UHC-79132-1656697007804826 Pine Dr, Houston, TX, 770850.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419607CLMIsabella Wood1988-12-17UHC-09077-92—7613 Willow Ct Apt 5, Denver, CO, 802180.66Unit split from streetState code upper-casedGender normalisedWhitespace trimmed+1 more
CLM-420623CLMWillie X Yang1982-02-18UHC-84264-2973847185513924 Jefferson Ave, Miami, FL0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-431541CLMPatricia Parker—UHC-37191-05—2919 Lake View Rd, Tucson, AZ, 857430.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-417535CLMJose Santos1992-05-20UHC-88954-5794967310684497 Mountain View Dr, Gilbert, AZ, 852060.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428353CLMKeith Thompson1963-12-21—82666933096960 Indian School Rd, Jacksonville, FL, 322740.66Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-430787CLMBrittany Henderson1992-12-05——8332 Union St, Dallas, TX, 752140.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415995CLMLawrence Padilla2007-01-14——5342 Lake View Rd Apt 6, Tucson, AZ, 857490.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-427115CLMJesse O Armstrong1982-08-05UHC-51454-6644530226072532 Oak St # 979, Scottsdale, AZ0.66Date of birth reformattedPhone reformattedUnit split from streetZIP missing+1 more
CLM-432612CLMJacob Espinoaz1943-03-01—21866311139827 Lake View Rd, San Diego, CA, 921300.66Two-digit birth yearPhone reformattedGender normalisedPlan code upper-cased+1 more
CLM-404583CLMDonna Austin1975-05-22——6301 Valley View Dr, Tucson, AZ0.66Date of birth reformattedCity re-casedZIP missingGender normalised+1 more
CLM-416031CLMMelissa Rodriguez1943-03-11——2585 Ocean Ave, Charlotte, NC, 282870.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-427588CLMBruce Vazquez1951-05-17UHC-72856-87—8774 Maple Ave, Gilbert, AZ, 852730.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-406796CLMGlorya Estrada1945-01-03UHC-90670-6891593946959236 Spring St, Houston, TX, 770130.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-408020CLMBlack Diana1987-07-10UHC-19098-18—1397 Ridge Rd, Tampa, FL0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-404043CLMRubert Wang1951-08-03UHC-24041-45—167 Harbor Blvd, Sacramento, CA, 958880.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-420117CLMJose Mejia1978-12-13UHC-36493-03—4197 Indian School Rd, Fresno, CA, 937110.66SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-432389CLMChristian Vargas1962-12-25UHC-00336-95—827 Sage Ct, Columbus, OH0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-424292CLMNicole L Hamiltton1984-12-11UHC-96718-8657779973112794 Bayshore Dr, Nashville, TN, 372710.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-406084CLMSantiago Phillips1962-11-01—54930255849067 Forest Ave, San Antonio, TX, 782420.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-421053CLMFrank Howard1984-09-13UHC-75968-9825146284494846 Elm St, Glendale, AZ0.66Phone reformattedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-427361CLMNathan Gilbert2008-01-10UHC-54667-70—9116 Sunset Blvd, Charlotte, NC, 282170.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-405749CLMRebecac Burton1945-09-24—20590145344816 Central Ave, Orlando, FL, 328730.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414691CLMMegan Burke1980-12-16UHC-39787-2829635275927111 Ocean Ave Apt 35, Seattle, WA, 981280.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-428102CLMCole Steven1982-09-07UHC-97690-65—5310 Sunset Blvd, Glendale, AZ, 853780.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412836CLMArjun Marshall1990-03-22——8882 Meadow Ln Apt 21, Austin, TX, 787270.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-431337CLMBrian Z Fox1969-01-20UHC-56910-9230143088394879 Spring St, Glendale, AZ, 853780.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-421480CLMBradley R Armstrong1989-03-14—86276849117832 Baseline Rd, Mesa, AZ, 852350.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-414305CLMCheryl T Jacobs1974-07-10UHC-69318-5283525380818057 Harbor Blvd, Minneapolis, MN, 554390.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-421717CLMJordan T Garza2008-05-17UHC-49606-8579581242988012 Bayshore Dr, Chandler, AZ0.66Phone reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-417900CLMMariana Ray1981-12-14UHC-30337-69—5557 Hillcrest Rd, Minneapolis, MN, 554170.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-403339CLMPaul Little1984-11-06UHC-44878-8221279819733698 Bayshore Dr, Los Angeles, CA, 900100.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-414483CLMJoan Torers1963-04-07——7239 Ridge Rd, Orlando, FL, 328940.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-418296CLMNicole Kim1945-01-20—22588633849473 Jefferson Ave # 832, Glendale, AZ, 853500.66Two-digit birth yearPhone reformattedUnit split from streetWhitespace trimmed+1 more
CLM-431361CLMKimberly Delgado1961-12-14——5493 River Rd, Dallas, TX, 752470.66Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+1 more
CLM-419514CLMCamila X Jensen1949-11-25UHC-66295-517405475384612 Central Ave, Fresno, CA, 937710.66Middle initial moved out of first namePhone reformattedCity re-casedGender normalised+1 more
CLM-402342CLMAisha Simmons1944-04-21UHC-46654-44—774 Lincoln Way, Phoenix, AZ, 850140.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-400367CLMGrace Burton1981-01-26UHC-52024-7528894499938064 Maple Ave # 552, Columbus, OH, 432790.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 175 of 657PreviousNext