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-412348CLMCatherine James1988-09-11UHC-83902-40—6878 Ridge Rd, Austin, TX, 787560.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-420787CLMJanice L Parker1999-11-16UHC-98137-03——0.66Name re-casedDate of birth reformattedPhone missing area codeGender normalised+1 more
CLM-430594CLMSusan Laarson1966-04-24—94078382318213 Indian School Rd # 994, Orlando, FL, 328590.66Name split from “Last, First”Unit split from streetCity re-casedWhitespace trimmed+1 more
CLM-401376CLMNicoole Simpson1969-11-11UHC-07493-84—802 Ridge Rd, Nashville, TN, 372330.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-423349CLMGerald T Ruiz1989-02-10UHC-14467-4523464812638019 Canyon Rd, Columbus, OH, 432510.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-421099CLMRyan Li1963-09-10——5648 Elm St, Fresno, CA, 937350.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-420306CLMSandra Jacskon1964-01-25UHC-78773-386288326945—0.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
CLM-409115CLMSean Y Phillips1946-11-03—2476165218—0.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-400862CLMBrenda K Mitchell1973-10-13UHC-31490-89—194 Willow Ct, Minneapolis, MN, 554390.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-427822CLMJean Phillips1983-12-07UHC-92483-07—1926 Cedar Ln, Gilbert, AZ, 852420.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-411880CLMJudy Gordon1989-01-19UHC-42217-51—3894 Broadway, Austin, TX, 787130.66Name re-casedTwo-digit birth yearAddress re-casedGender normalised+1 more
CLM-401131CLMAdam Torres1994-02-07UHC-94361-64—24 Jefferson Ave, Fresno, CA, 937900.66Name split from “Last, First”Street suffix standardisedAddress re-casedPlan code upper-cased+1 more
CLM-410937CLMDanielle W Olson1944-01-26——8945 Canyon Rd, Glendale, AZ, 853740.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-402287CLMOlivia Hart1976-10-26UHC-78547-4586383728539622 Highland Ave, Houston, TX, 770170.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
CLM-422964CLMKevin Hicks1977-01-14——7555 Pine Dr, Chandler, AZ, 852150.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-401556CLMSantiago H Rivera—UHC-93168-85—3442 Camelback Rd, Minneapolis, MN, 554430.66Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-423933CLMSara I Wallace1992-04-20—94076144541117 Baseline Rd, Tempe, AZ, 852020.66Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+1 more
CLM-427198CLMOlivia Maldonado1958-04-09—82879534257572 Desert Sky Blvd, Miami, FL0.66Phone reformattedCity re-casedState name converted to codeZIP missing+1 more
CLM-406655CLMAlexander Rose1978-06-08UHC-33854-74—2877 Washington St, Austin, TX, 787580.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-415231CLMJoseph G Flores1963-12-05UHC-55754-19—6339 Lincoln Way # 897, Phoenix, AZ0.66Name re-casedUnit split from streetZIP missingWhitespace trimmed+1 more
CLM-415232CLMJoseph G Flores1963-12-05UHC-55754-19—6339 Lincoln Way # 897, Phoenix, AZ0.66Name re-casedUnit split from streetZIP missingWhitespace trimmed+1 more
CLM-420012CLMTerry Cooper1960-07-24—78693469966679 Sunset Blvd, Fresno, CA, 937520.66Name re-casedPhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-409598CLMDebra Olson1973-11-04UHC-20571-5362472237648781 Indian School Rd, Orlando, FL, 328280.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-418631CLMAnthony T Fyelds2004-11-14——5227 Highland Ave, Jacksonville, FL, 322630.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-424151CLMFatima Fisher1971-07-19UHC-13643-768483242784740 Cedar Ln, Tucson, AZ, 857830.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
CLM-400039CLMLogan Knight1950-01-05—78846037302818 Jefferson Ave, Glendale, AZ, 853410.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-400040CLMLogan Knight1950-01-05—78846037302818 Jefferson Ave, Glendale, AZ, 853410.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-431233CLMJoan Rivera1989-12-18UHC-22799-76—7244 Oak St, Miami, FL, 331790.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-431232CLMJoan Rivera1989-12-18UHC-22799-76—7244 Oak St, Miami, FL, 331790.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-417471CLMBryan W Burke1977-05-20UHC-87931-70—3778 Oak St, Orlando, FL, 328920.66Middle initial moved out of first nameName re-casedPhone missing area codeWhitespace trimmed+1 more
CLM-417768CLMSusan Burns2000-04-10——6673 Cedar Ln, Tampa, FL, 336550.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-430029CLMMason Hoffman1975-10-25UHC-12915-20—4286 Ridge Rd, Minneapolis, MN, 554950.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-430986CLMVincent Foster1996-08-12UHC-05668-5375430693647007 Forest Ave, Las Vegas, NV, 891320.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-432728CLMJuan Hal1938-04-27—26887855373867 Hillcrest Rd, Houston, TX, 770200.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431546CLMChrstian Henry——7043997321—0.66Date of birth missingPhone reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-424639CLMChalres Griffin2003-10-08UHC-79368-12—6431 Oak St, Eden Prairie, MN, 553840.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-405724CLMWill Simpson1999-12-22——4472 Baseline Rd, Scottsdale, AZ, 852400.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-401652CLMLauren Parker1986-10-21UHC-44890-5484951082214890 Ocean Ave, San Antonio, TX, 782430.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-403530CLMMegan Davis1994-06-27UHC-00007-16—5918 Union St, Nashville, TN0.66Name re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-413227CLMAlexsi Logn1985-12-23——9010 Cedar Ln, San Antonio, TX, 782520.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-432366CLMMaria Russll1983-12-05—78368368179682 Meadow Ln # 706, Sacramento, CA, 958100.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-414374CLMKimberly H George1958-03-08——252 Harbor Blvd, Nashville, TN, 372960.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-424514CLMJames Delgado1967-08-17—50826353983875 Mountain View Dr, Orlando, FL, 328380.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-408712CLMJohn D Maldonado1993-03-17——5787 Apache Blvd # 608, Seattle, WA, 981280.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-401968CLMMatthew Carpenter1955-06-10UHC-33751-82—8003 Cedar Ln, Minneapolis, MN, 554580.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-401969CLMMatthew Carpenter1955-06-10UHC-33751-82—8003 Cedar Ln, Minneapolis, MN, 554580.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-424834CLMJoe Weaver1989-10-27UHC-65868-91—7990 Jefferson Ave, San Antonio, TX, 782450.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-426496CLMPual Marshall1962-10-12UHC-10623-89—980 Central Ave, Atlanta, GA, 303880.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-427297CLMChristine Wright1944-09-24UHC-27440-91—5140 Ridge Rd, Glendale, AZ, 853950.66Street suffix standardisedAddress re-casedState code upper-casedGender normalised+1 more
CLM-405458CLMMarilyn Fisher1985-04-16UHC-53466-536327881364—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
32,829 rows, page 197 of 657PreviousNext