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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-420913CLMRichard Franklin————0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-400526CLMGeorge I Nichols1992-08-10UHC-59529-24——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421374CLMFrances R Grant1979-03-19——7335 Broadway, Los Angeles, CA, 900330.68Name split from “Last, First”Middle initial moved out of first nameState code upper-casedPlaceholder values cleared
CLM-410318CLMAngela Moreno1984-07-14—9135859151—0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-427332CLMCamila Phillips1977-11-17UHC-26863-57——0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-410521CLMMariana Porter1999-10-22UHC-32514-31—8211 Grand Ave, Chandler, AZ, 852610.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412315CLMCatherine Henderson1986-01-17UHC-95700-7576795638694276 Church St, Miami, FL, 331400.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-401839CLMHiroshi I Reynolds1965-06-21—39352960252054 Sunset Blvd, Sacramento, CA, 958970.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421779CLMRachel U Anderson1940-09-13—60151735088708 Union St, Las Vegas, NV, 891300.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-420833CLMDebra Estrada1964-10-01——3265 Elm St, Fresno, CA, 937530.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-425698CLMCynthia Porter1983-10-11UHC-55361-65—9877 Union St, Miami, FL, 331020.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
CLM-419397CLMNicole Barnes1993-01-26———0.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
CLM-431203CLMBradley Jones1962-03-17UHC-59050-8474757212606499 Bayshore Dr, Houston, TX, 770640.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412683CLMEthan Walsh1941-03-07——5428 Mountain View Dr, Tampa, FL, 336330.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-412684CLMEthan Walsh1941-03-07——5428 Mountain View Dr, Tampa, FL, 336330.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-406684CLMVirginia Hoffman1947-09-20—7588526273—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-411229CLMJacob Vasquez1985-05-07UHC-00788-94——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-413468CLMHannah Brown1961-10-21UHC-26443-88——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-421354CLMJacuqeline R Siingh1983-10-16—72683931728898 Forest Ave, Denver, CO, 802410.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-411659CLMSanchez Lisa1951-01-20—31877830383976 Mesa Dr, Gilbert, AZ, 852530.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-411608CLMLawrence Weaver1964-02-04UHC-26133-9892921200243519 Church St Apt 15, Tempe, AZ, 852190.68Name split from “Last, First”Date of birth reformattedUnit split from streetWhitespace trimmed
CLM-430038CLMTimothy Geoge1941-06-24UHC-62919-0124128137854259 Valley View Dr, San Diego, CA, 921940.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406802CLMJacob N Kinng1970-03-14—52367965887963 Lake View Rd # 297, Tempe, AZ, 852660.68Name split from “Last, First”Phone reformattedUnit split from streetPlaceholder values cleared
CLM-432151CLMTimothy Nunez—UHC-87616-0671092596993333 Church St, Los Angeles, CA, 900150.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-408344CLMAlexander Perez1993-06-05—75665441011775 Lincoln Way, Phoenix, AZ, 850030.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408373CLMCarl Pierce2006-11-15——8360 Sage Ct, Las Vegas, NV, 891450.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-412815CLMRalph Campbell1989-10-10UHC-69425-15—3390 Oak St, Tempe, AZ, 852410.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-400099CLMJoseph U Simpson1997-04-14——7986 Mountain View Dr, Sacramento, CA, 958220.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432797CLMStephen Murray1962-05-26UHC-92761-01—4148 Main St, Seattle, WA, 981010.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421082CLMRobert Guerrero1949-03-04UHC-68316-58—1020 Washington St # 978, Orlando, FL, 328340.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-426441CLMRyan Santos1943-02-27UHC-94423-25——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-412794CLMJuan B Carpenter2000-06-11UHC-33252-10——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-402007CLMPatricia Knight2007-09-18UHC-45826-06—3958 River Rd, Chandler, AZ, 852170.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-419128CLMEthan G Wood1959-11-23UHC-70586-1454390062352316 Washington St, Austin, TX, 787530.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-419588CLMKaren R Stewart——3985202442—0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-431208CLMSamanta Burton1966-06-09—96769263983599 Church St, Gilbert, AZ, 852860.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-427969CLMHannah Bell1960-01-21UHC-89444-279192858875—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-426685CLMNicole U Lee1974-01-26UHC-13335-65—7184 Hillcrest Rd, Dallas, TX, 752690.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408398CLMAhmed Wagner1981-01-01UHC-20384-48—212 Bayshore Dr, Seattle, WA, 981210.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430760CLMPaul Aguilar1977-02-06UHC-80837-0783480620361823 Willow Ct, Denver, CO, 802650.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409191CLMJerry Rojas1995-09-22——4528 Maple Ave, Mesa, AZ, 852930.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-409192CLMJerry Rojas1995-09-22——4528 Maple Ave, Mesa, AZ, 852930.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-417570CLMLucia Hernandez2003-08-05UHC-88709-1229660763261139 Mountain View Dr, Seattle, WA, 981460.68Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased
CLM-423341CLMRobert Watkins2001-07-07UHC-29270-37——0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-417008CLMCharles Porter2004-04-09UHC-37973-20—9313 Forest Ave, Sacramento, CA, 958290.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410060CLMYuki F Meyer1950-06-01UHC-39552-52——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-416574CLMEthan Welch1949-09-13UHC-59122-39—1962 Mesa Dr, San Antonio, TX, 782210.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-409876CLMJason Guerrero1949-07-19UHC-14738-35——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-402036CLMThomas Chavze1958-01-21UHC-08205-93—6626 Market St, Miami, FL, 331990.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-424731CLMPhilip Willis1968-02-27——8286 Bayshore Dr, Seattle, WA, 981340.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
3,226 rows, page 43 of 65PreviousNext