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-420969CLMMelissa Marshall1998-06-13UHC-73960-39—4529 Grand Ave, Minneapolis, MN, 554920.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407655CLMRebecca Hernandez1991-06-24UHC-72721-9864635401788063 Market St Apt 38, Denver, CO, 802570.64Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
CLM-408200CLMTheresa Trores1990-03-18—39894963204431 Highland Ave, San Antonio, TX, 782020.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-431643CLMBrian Burke1969-10-08UHC-98758-75—1203 Church St, San Diego, CA, 921960.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-423311CLMJuan Graham———8033 Jefferson Ave, Jacksonville, FL, 322070.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424622CLMJack Austin1950-04-20——6937 Union St # 121, Orlando, FL, 328340.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-417189CLMFrances Moreno1978-09-23UHC-65118-03—8207 Harbor Blvd, Fresno, CA0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403321CLMCarol Gilbert1968-12-05UHC-48276-15—6850 Maple Ave, Fresno, CA, 937250.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410015CLMNoah Estrada2005-04-15—77498601656764 Hillcrest Rd, Scottsdale, AZ, 852660.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-403558CLMDunn Arjun1987-02-05——3720 Indian School Rd, Miami, FL, 331650.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-400789CLMAlie Knight1958-06-21UHC-58125-2147082625316465 Pine Dr, Orlando, FL0.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-414369CLMCharles N Evans1943-08-02—86253771541969 Church St, Jacksonville, FL, 322570.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-400717CLMAndrea Collins1997-07-26UHC-59606-22—7314 Mountain View Dr, Houston, TX, 770740.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419696CLMJonathan Peters1994-07-26——4899 Indian School Rd, Los Angeles, CA, 900660.64Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
CLM-405864CLMArthur Cole2001-05-02UHC-98978-1567154179761857 Forest Ave, Miami, FL, 331740.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-402093CLMNatalie Graham1969-01-02UHC-06183-55—8770 Oak St, Jacksonville, FL, 322280.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405592CLMRachel Hansen1985-08-15——2713 Sunset Blvd, Gilbert, AZ, 852440.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-414530CLMNicole Myers1997-10-22UHC-92949-48—1400 Union St, Eden Prairie, MN, 553550.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400036CLMOmar Williams1994-03-17—75778383436733 Grand Ave, Miami, FL, 331780.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428230CLMBryan Foster2001-12-01UHC-42145-764513496968636 Ocean Ave, Fresno, CA, 937090.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430383CLMKaren Mitchell1949-09-02——5453 Spring St, Los Angeles, CA, 900750.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-417581CLMHenry Graham1969-04-04UHC-16030-05815263347946 Grand Ave Apt 17, Plano, TX, 750230.64Date of birth reformattedPhone reformattedUnit split from streetGender normalised+2 more
CLM-423597CLMWayne Nelson2003-08-18—64032766044213 Spring St, Charlotte, NC, 282930.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-428545CLMMegan Morgan1997-09-07UHC-81877-49—9294 Lake View Rd, Tempe, AZ, 852520.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401364CLMDonald Johnston1945-11-27UHC-99698-015666986636942 Harbor Blvd, Glendale, AZ, 853560.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426488CLMSean Jones1947-05-03—32077780858932 Hillcrest Rd, Mesa, AZ, 852860.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408494CLMDonna Allen1979-06-17——8751 Bayshore Dr # 900, Charlotte, NC, 282990.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430316CLMEthan Weber——34278240173382 Lincoln Way, Miami, FL, 331610.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412361CLMBobby Schultz1958-07-18——1371 Maple Ave, Seattle, WA, 981980.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-427848CLMSean Mason1981-04-12—81150068739549 Harbor Blvd, Chandler, AZ, 852300.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-425213CLMRonald Reed1957-07-28UHC-55114-2762955203856289 Baseline Rd, Tucson, AZ, 857830.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428660CLMKevn Rojas1993-01-19UHC-91709-03—7298 Oak St, Tampa, FL, 336740.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-405717CLMEd Vazquez1995-04-15—4845612350121 Willow Ct, Chandler, AZ, 852280.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401496CLMAlan A Maatthews2000-07-24UHC-27608-394844132956148 Pine Dr, Tucson, AZ0.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
CLM-424737CLMBradley Watkins2008-04-01UHC-12179-4557739872944441 Valley View Dr, Atlanta, GA, 303290.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431454CLMJose S Jensen1953-01-13UHC-42670-96—2719 Ocean Ave, Nashville, TN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-430346CLMHiroshi Tran1986-02-04—28737013223262 Lincoln Way, Austin, TX, 787380.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410808CLMNicole N Richardson2008-09-22UHC-06257-8272570764852529 Canyon Rd, Houston, TX, 770640.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400521CLMDanielle Fuller1963-03-07—25726061228088 Central Ave, Phoenix, AZ, 850570.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428679CLMMike Rios1961-08-23UHC-88156-15—9120 Lake View Rd, Los Angeles, CA, 900970.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411609CLMLawrence Weaver1964-02-04UHC-26133-98—3519 Church St, Tempe, AZ, 852190.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400910CLMTerry L Gibson——22125550505213 Spring St, Seattle, WA, 981590.64Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424546CLMMichael Gutierrez1953-06-19——5232 Willow Ct, Sacramento, CA, 958270.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-417897CLMBrian Hamilton1939-06-26—51646346528951 Market St, Atlanta, GA, 303410.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424509CLMBruce Cruz1918-12-23—72749641635953 Elm St, Los Angeles, CA, 900080.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-423961CLMAisha Y Gilbert1971-08-08—50395668808619 Elm St, Houston, TX0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423962CLMAisha Y Gilbert1971-08-08—50395668808619 Elm St, Houston, TX0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408003CLMDennis Gilbert1970-04-09—54187243985790 Jefferson Ave, Denver, CO, 802910.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426230CLMJack Graham1992-03-15UHC-08139-793918864067436 Market St, Las Vegas, NV, 891390.64Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-402616CLMPaul Lopez1947-02-01UHC-63875-61—5959 Sage Ct, Tampa, FL, 336740.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
32,829 rows, page 105 of 657PreviousNext