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-414980CLMEugene Wallace1942-06-16UHC-99190-1422073350968878 Baseline Rd, Jacksonville, FL, 322190.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-416913CLMRaymond Stewart2008-08-23UHC-81012-14—7962 Hillcrest Rd, Tampa, FL, 336180.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-413939CLMAlbert Marshall1991-07-04—21967059398011 Maple Ave Apt 6, Plano, TX, 750580.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-413221CLMJanice Weber1972-01-16—29046259174750 Grand Ave, Tucson, AZ, 857150.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-412112CLMBenjamin Shaw1992-05-24UHC-42535-6063591949244124 Bayshore Dr, San Antonio, TX, 782980.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428863CLMArthur Johnson1954-04-15UHC-46807-70895433447458 Spring St, Houston, TX, 770350.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-417875CLMMadison Stephens1951-08-04——1893 Washington St, Chandler, AZ, 852430.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-406161CLMNoah Bryant1967-08-07—36693184065278 Mountain View Dr # 784, Columbus, OH, 432560.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-412875CLMDonna F Le1965-02-06UHC-38557-9338391334526110 Valley View Dr Apt 10, Chandler, AZ, 852620.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-418818CLMJoseph Evans1996-07-02UHC-53901-4795749169167198 Oak St, Tempe, AZ, 852360.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-422814CLMNatalie Ferguson1942-05-16UHC-75951-2355167531468350 Hillcrest Rd, Tempe, AZ, 852060.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418946CLMPat Ford1991-01-12—90433071446567 Mountain View Dr, Mesa, AZ, 852350.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-421146CLMMaria Hoffman2000-05-27UHC-58570-09—6203 Indian School Rd, Tampa, FL, 336580.48Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405109CLMTerry Peterson1964-12-22—5813042921298 Desert Sky Blvd, Glendale, AZ, 853930.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-404879CLMGary P Burton1988-01-22UHC-41264-81—4869 Church St, Gilbert, AZ0.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423199CLMSara Wallace1970-10-27UHC-48359-676659671601298 Ridge Rd Apt 25, Minneapolis, MN, 554710.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
CLM-403750CLMHenry Little1944-12-26UHC-93359-732435746946266 Camelback Rd, Atlanta, GA, 303610.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-408820CLMZachary Hudson1945-08-22—23671285794326 Palm Dr, Houston, TX0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-432509CLMKevin Johnston1956-06-01—38853791828262 Maple Ave # 382, Fresno, CA, 937520.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-425753CLMAbigail Grant1953-02-13UHC-92965-8322282811127908 Hillcrest Rd Apt 30, Tempe, AZ, 852530.48Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+4 more
CLM-421517CLMDylan Burns1947-12-02UHC-47416-3777042383738794 Harbor Blvd, Nashville, TN, 372730.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416714CLMElijah Torres1968-03-21UHC-90396-64—7315 Church St Apt 32, Eden Prairie, MN, 553330.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-422095CLM—Junk1967-09-18UHC-42415-0353550543218889 Bayshore Dr, Dallas, TX, 752010.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407594CLMBetty X Tucker1958-07-15—82994521313595 Central Ave, Tucson, AZ0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-415480CLMCatherine Lawrence—UHC-09218-8637070437299836 Canyon Rd, Chandler, AZ, 852490.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-417575CLMElizabeth Baker1994-09-04UHC-60905-95—9587 Park Pl, San Antonio, TX, 782370.48Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-410638CLMEugene Petrson1942-11-20UHC-76324-6186797252282480 Ocean Ave, Minneapolis, MN, 554890.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403186CLMYuki A Herrera2004-09-05——1268 Palm Dr, Minneapolis, MN, 554690.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-428430CLMJohn Lewis1949-04-11——2158 Sunset Blvd, Las Vegas, NV, 891210.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-403967CLMAhmed Bowman1944-07-28UHC-82494-64—666 Ridge Rd, Scottsdale, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430444CLMKevin Perez1988-03-13UHC-46387-4184639213592315 Ocean Ave, Orlando, FL0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-428222CLMKelly Jensen1954-03-12UHC-89135-52—3420 Baseline Rd, Nashville, TN, 372130.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-418823CLMBruce Nichols1996-11-06——7232 Forest Ave, Mesa, AZ, 852360.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431680CLMAmber Walker1987-09-21UHC-16667-35—6375 River Rd, Miami, FL, 331580.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-420626CLMMark Estrada1989-09-12UHC-34804-58—3650 Apache Blvd, Eden Prairie, MN, 553940.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-422830CLMTimothy Carpenter1970-04-07——8987 Hillcrest Rd, Mesa, AZ, 852170.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-400514CLMKimberly S Henry1947-09-26—73693756075008 Desert Sky Blvd Apt 31, Miami, FL0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-408369CLMMason A Maldonado——27228623841570 Union St, Tampa, FL, 336040.48Name split from “Last, First”Date of birth unreadablePhone reformattedCity re-cased+4 more
CLM-430538CLMDennis F Watson1960-02-18UHC-66816-88—3612 Highland Ave # 335, Chandler, AZ, 852260.48Name split from “Last, First”Date of birth reformattedPhone missing area codeMember ID reformatted+4 more
CLM-432628CLMMargaret B Vasquez1962-10-26UHC-19632-9755856107207899 Church St, Scottsdale, AZ0.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-430551CLMAlexander J Lawrence1974-03-07——4292 Grand Ave, Jacksonville, FL, 322790.48Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-405435CLMByan Stevens1944-01-04UHC-77346-2626256394066962 Maple Ave, Phoenix, AZ, 850370.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-415695CLMKelly Montgomery1962-05-24UHC-89838-7035370156958917 Valley View Dr, Sacramento, CA0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-425945CLMDiego W Turner1988-02-28UHC-92924-96—8225 Union St, Tampa, FL, 336440.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-430643CLMLucia T Butler1985-05-14UHC-50319-68—5723 Desert Sky Blvd, Gilbert, AZ, 852470.48Two-digit birth yearMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-409487CLMPriya K Weber1977-01-08UHC-74953-20—7071 Forest Ave, Glendale, AZ, 853980.48Middle initial moved out of first nameName re-casedMember ID reformattedStreet suffix standardised+4 more
CLM-416363CLMOmar Meidna1955-05-19UHC-37490-97—3433 Meadow Ln, Orlando, FL, 328540.48Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
CLM-421800CLM—Junk1967-12-18UHC-60213-7773599021021681 River Rd # 342, Scottsdale, AZ, 852210.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-408317CLMAaron Murphy1951-03-16UHC-20453-66—8883 Canyon Rd # 127, Nashville, TN, 372360.48Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
CLM-430130CLMAmanda Grant1985-09-24—57740671086065 Willow Ct, Jacksonville, FL, 322770.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
32,829 rows, page 17 of 657PreviousNext