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-411717CLMAlex Bradley1945-09-17—93987790064988 Mountain View Dr, Denver, CO, 802880.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-428291CLMHannah Harris1962-05-09——4928 Bayshore Dr, Glendale, AZ, 853560.60Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-410782CLMJuan Hart1970-04-08UHC-11791-0792135135263203 Meadow Ln, Jacksonville, FL, 322570.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-422777CLMMichelle Burns1938-06-03UHC-94933-3031893267264095 Park Pl, Dallas, TX0.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407969CLMSamantha Weaver——8098140489419 Oak St, Scottsdale, AZ, 852360.60Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-420832CLMSean N Chapman2002-02-14UHC-35561-4059989981296702 Church St, Minneapolis, MN0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431870CLMMichael McDonald1982-07-05UHC-87977-2423120303406489 Camelback Rd, Gilbert, AZ0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408782CLMRussell C Delgado1982-08-10—36971113278347 Harbor Blvd # 889, Atlanta, GA, 303790.60Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
CLM-418968CLMBarbara Gibson1951-10-28UHC-17543-8343457338276723 Forest Ave # 649, Los Angeles, CA, 900630.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-432377CLMAmanda Yang1941-10-25UHC-99907-1825752234601855 Baseline Rd, Mesa, AZ, 852370.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-430831CLMJerry Stevens1997-06-17UHC-69450-0624445504414239 Union St, San Diego, CA, 921620.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430813CLMAndrea Harrison1956-06-22——1180 Meadow Ln, Phoenix, AZ, 850540.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416451CLMTerry Jenkins1973-05-04UHC-17173-5054484077844419 Maple Ave, Eden Prairie, MN, 553440.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-424344CLMHeather Vazquez1956-05-14UHC-60010-8368760949581445 Central Ave, Glendale, AZ, 853990.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-423833CLMChristine Pwell1984-11-14UHC-91272-7696198442211042 Maple Ave, Houston, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-423832CLMChristine Pwell1984-11-14UHC-91272-7696198442211042 Maple Ave, Houston, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-425000CLMVicky Graham1950-09-24—67962577261392 Forest Ave, San Antonio, TX, 782840.60Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419072CLMTimothy Clark1959-09-22UHC-35369-9438835908991801 Mountain View Dr # 856, Orlando, FL, 328740.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-413874CLMTeresa Meyer1962-09-10UHC-53988-8171581243929295 Apache Blvd, Las Vegas, NV, 891970.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-430285CLMDeborah Grodon1995-09-18——5176 Mesa Dr, San Diego, CA, 921580.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-409952CLMDouglas R Schultz1974-07-19—77231707733366 Elm St, Miami, FL, 331810.60Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-425089CLMWei B Rodriguez1944-09-20UHC-29509-85—8123 Mountain View Dr, Tempe, AZ, 852540.60Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
CLM-413083CLMHiroshi Rogers1986-08-07UHC-98848-9147461078803858 Baseline Rd, Miami, FL0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-402528CLMArthur Munoz2006-05-28UHC-53883-639609752681657 Sunset Blvd, Tempe, AZ, 852520.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-428478CLMBrandon Sanchez1967-08-24UHC-70694-4735658027092492 Grand Ave, Nashville, TN, 372570.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-431614CLMSean Hamilton1939-06-15——4965 Palm Dr, Seattle, WA, 981130.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-413178CLMLisa Clark1977-03-13UHC-08004-40—5429 Sunset Blvd, Atlanta, GA, 303360.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-411340CLMAnthony Hiill2003-07-19UHC-15437-9146442848957834 Palm Dr # 320, Mesa, AZ, 852660.60Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
CLM-427476CLMMargaret Gonzales1981-02-10UHC-59119-3283173111676102 Valley View Dr, Orlando, FL, 328070.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425131CLMWei Medina1952-10-25UHC-05721-07—4780 Lake View Rd Apt 4, Plano, TX, 750670.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-423491CLMMariana Flores1977-09-19UHC-75178-3579132730358810 Elm St, Gilbert, AZ, 852540.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-426345CLMOmar Weaver2002-02-28UHC-71491-8570397997084595 Sage Ct, Fresno, CA, 937820.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-415442CLMSamuel Castro1975-05-08UHC-99010-799047985083216 Indian School Rd, Dallas, TX, 752660.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-424288CLMMei Rogers1965-01-05UHC-26204-76—6945 Jefferson Ave, Miami, FL0.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-401479CLMRoger Ortiz1945-02-12UHC-02384-9636370142382298 Ocean Ave Apt 1, Tempe, AZ, 852010.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-407489CLMTimothy Nichols1989-07-13UHC-96375-5476351117288409 Bayshore Dr Apt 26, San Antonio, TX, 782680.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-406520CLMMelissa Q Montgomery1985-02-11—39852848491611 Spring St, Plano, TX, 750870.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-432080CLMScott Campbell1947-06-03—380342413515 Hillcrest Rd, Sacramento, CA, 958110.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-425054CLMMarkJunk1941-03-17—44544905336407 Spring St, Jacksonville, FL, 322320.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425350CLMDorothy Patterson1963-07-14UHC-01755-52—3384 Cedar Ln, Nashville, TN, 372660.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417977CLMPark Hiroshi——54643549214378 Apache Blvd, Gilbert, AZ, 852410.60Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-405785CLMPamela Jordan1982-06-16UHC-28186-7886569079252690 Highland Ave, Phoenix, AZ, 850480.60Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-428160CLMGrace Phillips1971-09-14UHC-93122-4638056084281782 Valley View Dr, Fresno, CA, 937040.60Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431810CLMSamuel Richards1984-02-14—26454537702173 Mountain View Dr, Phoenix, AZ, 850060.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-401266CLMMarilyn Long1982-08-17—46965150474829 Oak St, Atlanta, GA, 303570.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424255CLMScott N Anedrson1987-07-26—23140120794712 Hillcrest Rd, Glendale, AZ, 853480.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-418283CLMAbigail Aguilar1997-05-25UHC-54533-25—8621 Hillcrest Rd, Las Vegas, NV0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-411624CLMGeorge Day1963-09-28——6255 River Rd, Phoenix, AZ, 850950.60Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-420819CLMAshley Pena—UHC-93084-46—5362 Church St, Los Angeles, CA, 900170.60Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
CLM-401178CLMMark Gomez1962-09-20—48490564055250 Indian School Rd, Eden Prairie, MN, 553780.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
32,829 rows, page 73 of 657PreviousNext