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-423931CLMLori Q Yang1974-08-09—71747544655415 Forest Ave, Dallas, TX, 752730.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-412514CLMEmily U Ford1944-05-25UHC-79018-9677995068798358 Valley View Dr, Mesa, AZ, 852040.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
CLM-424673CLMSandra F Obrien1975-12-18UHC-04569-9344580893076992 Jefferson Ave # 177, Fresno, CA, 937770.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-420889CLMDoris Bradely1946-08-01——158 Cedar Ln, Orlando, FL, 328830.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-420773CLMHoffman Michelle1973-01-12UHC-99305-7643886494799864 Lake View Rd, Miami, FL, 331740.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-405472CLMJesse I Pierce1990-06-05UHC-18857-4323640394414975 Lincoln Way Apt 13, Houston, TX, 770670.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-423386CLMMatt Braldey1974-06-22—47760244058537 Baseline Rd # 435, Glendale, AZ, 853000.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-408937CLMAmanda Ortiz1971-11-28UHC-08539-42—9163 Desert Sky Blvd, Atlanta, GA, 303610.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410628CLMRonald Olson1939-10-04—69492076249584 Maple Ave, Dallas, TX, 752480.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411690CLMWei S Hunt1982-02-05UHC-22166-9875978689126483 Jefferson Ave # 783, Chandler, AZ, 852280.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-420268CLMBilly Valdez1968-12-02UHC-52318-42—1459 Hillcrest Rd, Glendale, AZ, 853100.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416694CLMDbebie D Webb1956-10-16UHC-83661-453873581411—0.64Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+2 more
CLM-412270CLMDavid W Hansen2004-02-20—83235979138251 Apache Blvd, Jacksonville, FL, 322550.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421504CLMWilliam Clark1986-07-21UHC-40657-9783694368927594 Cedar Ln, Tampa, FL, 336800.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412706CLMRandy Dixon1991-08-06UHC-17679-6983450200746924 Willow Ct, Atlanta, GA, 303810.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409657CLMChristina Grant1979-12-28UHC-88985-87——0.64Name re-casedDate of birth reformattedSSN last four extractedGender normalised+2 more
CLM-401252CLMCarlos Scott1943-08-20—3766814639—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more
CLM-403878CLMAndrea Brown1977-01-22—34475772232828 Desert Sky Blvd, San Diego, CA, 921050.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-415841CLMTeresa Little1971-08-18UHC-60625-51—5852 Sage Ct, Nashville, TN, 372340.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426060CLMCarolyn Sullivan1961-11-15UHC-71999-3264347681017997 Hillcrest Rd, Chandler, AZ, 852260.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-427390CLMElijah Wood1984-09-24UHC-55725-25—3073 Main St, Scottsdale, AZ, 852820.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-419148CLMLaura Morrs1955-05-12UHC-18122-11—6637 Washington St, San Antonio, TX, 782330.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410077CLMMary Padilla1975-11-16UHC-05792-9865159138317828 Cedar Ln, Gilbert, AZ, 852330.64Two-digit birth yearPhone reformattedMember ID reformattedState code upper-cased+2 more
CLM-423334CLMLauren Porter1962-08-04UHC-47113-19—1731 Harbor Blvd # 240, Orlando, FL, 328920.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-426458CLMDennis Warren1969-11-23UHC-83107-26—5204 Bayshore Dr, Dallas, TX, 752870.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-406436CLMWei Nelson1998-12-11UHC-33550-609702606900139 Main St, Minneapolis, MN, 554880.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407059CLMChristopher W Duncan2002-06-26UHC-75482-8787058895025806 Oak St Apt 23, Dallas, TX, 752230.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-423834CLMAlan Schmidt1992-10-27UHC-55876-27—5248 Canyon Rd, Minneapolis, MN, 554410.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422689CLMArthur Lawson1980-01-04UHC-45410-9923759445526245 Union St, Tampa, FL, 336370.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-403024CLMAlice Wallace1939-07-04——1501 Main St, Orlando, FL, 328750.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424853CLMTheresa A Padilla1944-12-07UHC-76628-92—5793 Hillcrest Rd, Columbus, OH, 432100.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-430353CLMDaniel Castillo1949-05-16UHC-74193-54—6991 Main St, Seattle, WA, 981710.64Name re-casedDate of birth reformattedState name converted to codeGender normalised+2 more
CLM-424118CLMJudy Watkins1973-04-08UHC-12017-247947686283—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-429913CLMJosh U Castro1977-01-11—70549163737336 Sunset Blvd Apt 8, Charlotte, NC, 282430.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-413746CLMHarod Obrien1984-03-24UHC-14045-716383919662259 Market St, Sacramento, CA, 958180.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421664CLMRebecca Gonzalez1944-09-04UHC-31410-51—8753 Ocean Ave, Nashville, TN, 372480.64Street suffix standardisedAddress re-casedGender normalisedPlan code upper-cased+2 more
CLM-430482CLMGeorge S Nelson1941-04-27UHC-72655-1356365443489584 Desert Sky Blvd, Fresno, CA, 937000.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421380CLMAlexis Hilll1952-02-12—61439043294089 River Rd, Tucson, AZ, 857880.64Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-429256CLMJeffrey Stewart1951-09-14—80966799389574 Maple Ave, Orlando, FL0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410755CLMMateo Cook—UHC-41125-17——0.64Name re-casedDate of birth missingPhone missing area codeMember ID reformatted+2 more
CLM-429934CLMWalter Flores1947-07-06UHC-24155-05—9510 Grand Ave, Los Angeles, CA, 900560.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421886CLMBrittany P Fuller1939-10-04—71650065231183 Elm St, Mesa, AZ, 852540.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-423911CLMRussell Ward1968-09-05UHC-88290-82—1653 Maple Ave, Glendale, AZ, 853230.64Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423621CLMBobby Cole1989-06-10UHC-51664-058076249165231 Desert Sky Blvd, Columbus, OH0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429269CLMAmada Q Day2003-05-12——16 Indian School Rd, Miami, FL, 331650.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-423448CLMRussell Wallace1958-10-21UHC-92159-02—7077 Washington St Apt 1, Fresno, CA, 937780.64Unit split from streetCity re-casedEmail lower-casedGender normalised+2 more
CLM-412634CLMMateo Estrada1981-01-25—90195657743838 Mountain View Dr, Glendale, AZ, 853440.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-423810CLMNatalie G Crawford1943-07-06UHC-94219-7980566902926101 Forest Ave, Miami, FL, 331440.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-421059CLMDeborah F Sandoval———6170 Sage Ct, Seattle, WA, 981910.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-421716CLMJessica U Gutierrez1975-10-27—68178621681699 Valley View Dr, Los Angeles, CA, 900680.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 118 of 657PreviousNext