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, junk only, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-402618CLM—Junk1972-11-08UHC-69723-76—2676 Hillcrest Rd, Jacksonville, FL, 322510.56Street suffix standardisedAddress re-casedGender normalisedNo usable name (quarantined)
CLM-423280CLM—Junk1942-11-23UHC-80279-32—3751 Forest Ave # 346, Los Angeles, CA, 900610.56Unit split from streetZIP+4 trimmedPlaceholder values clearedNo usable name (quarantined)
CLM-404098CLMVirginiaJunk1981-04-11——8224 Maple Ave Apt 17, Fresno, CA, 937510.56Unit split from streetGender normalisedPlaceholder values clearedNo usable name (quarantined)
CLM-420676CLMBJunk1941-11-04UHC-90971-37—3733 Forest Ave, Tempe, AZ, 852400.56Street suffix standardisedAddress re-casedGender normalisedNo usable name (quarantined)
CLM-423766CLMIsabelllaJunk1952-04-22UHC-16836-61—577 Willow Ct, Tempe, AZ, 852600.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402000CLMAnna UJunk1956-08-26UHC-44369-3150744158208585 Desert Sky Blvd, San Antonio, TX, 782760.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429353CLM—Junk1999-03-05—80851227485971 Camelback Rd, San Diego, CA, 921560.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-432527CLM—Junk1995-06-04UHC-48415-05—5289 Jefferson Ave, Atlanta, GA, 303680.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425054CLMMarkJunk1941-03-17—44544905336407 Spring St, Jacksonville, FL, 322320.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420172CLMJoseJunk2001-01-14UHC-54396-76—238 Harbor Blvd, Columbus, OH, 432560.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430002CLMChristopher LJunk1967-09-11UHC-33800-1791926670583042 Sage Ct, Plano, TX, 750140.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-410790CLM—Junk1956-04-26UHC-38202-11—361 Palm Dr, Orlando, FL, 328970.62Date of birth reformattedPhone missing area codeCity re-casedState code upper-cased+3 more
CLM-408957CLM—Junk1988-07-02——6828 Oak St, Sacramento, CA, 958780.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-432223CLMQJunk1974-02-04UHC-41356-3331075608704275 Union St, Mesa, AZ, 852060.62Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-422211CLMVincentJunk1986-08-06—60197590136852 Union St, Phoenix, AZ, 850970.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-432437CLM—Junk1987-08-11UHC-33009-4827790756255506 Maple Ave, Tucson, AZ, 857420.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-413366CLMTeresaJunk2002-02-28UHC-70614-27—421 Camelback Rd, Fresno, CA, 937100.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-424856CLMJoshua DJunk1994-08-01—71354028249767 Sunset Blvd, Phoenix, AZ, 850040.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402676CLMWJunk1993-02-22UHC-11771-60—3287 Bayshore Dr, Orlando, FL, 328870.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431390CLM—Junk1957-01-13UHC-15907-3720123180413649 Ridge Rd, Fresno, CA, 937180.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-417353CLMIsabella HJunk1941-05-22——9391 Ridge Rd, Sacramento, CA, 958680.64Street suffix standardisedAddress re-casedPlan code upper-casedWhitespace trimmed+2 more
CLM-407843CLM—Junk1968-09-13UHC-72065-17—3206 Meadow Ln, Scottsdale, AZ, 852050.64Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-407842CLM—Junk1968-09-13UHC-72065-17—3206 Meadow Ln, Scottsdale, AZ, 852050.64Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-404456CLMBrittany KJunk1943-04-15UHC-13360-017207147632199 Grand Ave, Scottsdale, AZ, 852680.64Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
CLM-429055CLMJoeJunk2003-03-10UHC-01942-36—8568 Ocean Ave, Phoenix, AZ, 850710.64Date of birth reformattedMember ID reformattedZIP+4 trimmedWhitespace trimmed+2 more
CLM-422702CLMJJunk1991-09-09UHC-86266-54—7229 Harbor Blvd, Dallas, TX, 752890.64Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-407018CLMDavdJunk1964-01-25UHC-48679-36—4431 Harbor Blvd, Charlotte, NC, 282020.64Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-419969CLM—Junk1950-01-23UHC-98453-38—1973 Harbor Blvd, Glendale, AZ, 853850.64Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+2 more
CLM-413353CLMSarahJunk1998-07-05——5026 Hillcrest Rd, Mesa, AZ, 852860.64Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-419470CLM—Junk1997-02-12——5330 Park Pl, Miami, FL, 331860.64Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+2 more
CLM-411774CLMEric XJunk1950-09-19UHC-64477-90—6054 Forest Ave, Las Vegas, NV, 891460.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-408818CLM—Junk1967-12-27—77055299034392 Elm St, Scottsdale, AZ, 852790.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409345CLM—Junk1980-06-04UHC-22345-18—2722 Grand Ave, Scottsdale, AZ, 852240.64Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-402072CLM—Junk2002-08-25—6695645536—0.64Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+2 more
CLM-411891CLMRyanJunk1965-12-23UHC-60653-8571763955105944 Lake View Rd, Sacramento, CA, 958860.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430323CLM—Junk1956-01-06——2593 Spring St, Charlotte, NC, 282320.64Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-403387CLM—Junk1948-06-07UHC-54129-77—5967 Grand Ave, Mesa, AZ, 852060.66Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared+1 more
CLM-404435CLMCharlotteJunk1981-10-02UHC-46549-708648823337948 Valley View Dr, Glendale, AZ, 853030.66Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared+1 more
CLM-413691CLMDianeJunk1996-07-02UHC-87387-0761243576569757 Ridge Rd, Charlotte, NC, 282850.66Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-420324CLMDianaJunk1996-05-28———0.66Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared+1 more
CLM-430249CLMBettyJunk1959-02-22——6648 Mountain View Dr, Tucson, AZ, 857100.66Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared+1 more
CLM-404173CLM—Junk1957-12-22UHC-14266-65—5404 Market St, Houston, TX, 770690.66Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-430425CLMJacquelineJunk1990-02-14UHC-51173-49—6121 Cedar Ln # 799, Las Vegas, NV, 891100.66Unit split from streetCity re-casedWhitespace trimmedPlaceholder values cleared+1 more
CLM-421955CLMHannahJunk1957-11-20UHC-14893-54—2563 Forest Ave, Charlotte, NC, 282770.66Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
CLM-404386CLMVJunk1955-05-06—98784422705141 Mesa Dr, Orlando, FL, 328490.66Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared+1 more
CLM-403131CLMAishaJunk1945-08-08UHC-81067-89—593 Harbor Blvd, Nashville, TN, 372450.66Date of birth reformattedMember ID reformattedState name converted to codePlaceholder values cleared+1 more
CLM-404128CLMCherylJunk2002-12-17UHC-92867-0164330423723156 Baseline Rd, Sacramento, CA, 958960.66Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
CLM-420158CLM—Junk1946-11-05UHC-87019-89—3708 Apache Blvd, Scottsdale, AZ0.66Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared+1 more
CLM-424435CLMDJunk1956-11-20UHC-07576-73—4566 Spring St, Tucson, AZ, 857610.66Date of birth reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared+1 more
CLM-401579CLMLisaJunk1947-01-24—20325376801205 Apache Blvd, Minneapolis, MN, 554270.66Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared+1 more
155 rows, page 2 of 4PreviousNext