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-415372CLMJennifer Hansen1966-04-08UHC-70639-44—5187 Main St, Atlanta, GA, 303450.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404735CLMAnna Mason1972-01-02UHC-45165-10—1783 Main St, Austin, TX, 787970.66Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+1 more
CLM-428401CLMElijah Z Le1964-09-23UHC-95173-48—9800 Elm St, Fresno, CA, 937090.66Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414059CLMRussell Le1946-09-18UHC-78818-189612759075509 Central Ave, Dallas, TX0.66Phone reformattedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-416949CLMJanice K Johnson1970-03-24——1070 Apache Blvd, San Diego, CA, 921980.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-421139CLMArthur T Parker1971-03-13——680 Park Pl, Chandler, AZ0.66Name re-casedDate of birth reformattedState name converted to codeZIP missing+1 more
CLM-411994CLMMaria Hoffman2004-02-01—41728522977344 Apache Blvd, Gilbert, AZ, 852950.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-413342CLMSamantha L Fowler1956-09-06——2054 Valley View Dr, San Diego, CA, 921670.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-417801CLMGloria Crawford1997-12-04UHC-50434-74829615156969 Mesa Dr, Los Angeles, CA, 900610.66Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414833CLMMary Clark2004-05-11UHC-63821-243718954354343 Broadway, Los Angeles, CA0.66Name re-casedPhone reformattedState name converted to codeZIP missing+1 more
CLM-415800CLMAlan Ramos1999-04-02—76253689763586 Bayshore Dr, Chandler, AZ, 852550.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-419041CLMMartha Moore2008-06-02UHC-35380-559028019585511 Baseline Rd, Denver, CO, 802970.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425453CLMScott Gibson2004-06-02——5853 Lake View Rd, Miami, FL, 331530.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-428055CLMBarbara D Rojas1989-01-04UHC-46818-78—5644 Forest Ave, Nashville, TN, 372870.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-405313CLMGeorge Sims1997-01-02UHC-90175-749832619092461 Jefferson Ave, Plano, TX0.66Name re-casedPhone reformattedState name converted to codeZIP missing+1 more
CLM-429538CLMJeffrey Phillips1977-06-27UHC-08341-30—8994 Highland Ave, Phoenix, AZ, 850650.66Name split from “Last, First”City re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-411729CLMLucia Ryan1987-05-06UHC-61623-91—5920 Elm St, Columbus, OH, 432940.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-427617CLMMadison Taylor———3153 Oak St, Fresno, CA, 937510.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-427276CLMMrai Stewart2006-12-26UHC-45508-5220988527719251 Pine Dr, Eden Prairie, MN0.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-400935CLMBrandon Gonzales1966-05-07UHC-09464-72—1764 Ocean Ave, Plano, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-406339CLMFrak Guzman2006-10-09UHC-66444-28—1500 Spring St, Fresno, CA, 937230.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-409360CLMSsan Scott1971-09-12——6472 Main St, San Diego, CA0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-412071CLMKevin Mejia1989-03-13UHC-05080-57—6452 Ridge Rd Apt 39, Minneapolis, MN, 554860.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-407552CLMSamantha W Greene1976-09-02——1516 Highland Ave, San Diego, CA, 921510.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-423483CLMDonna Holmes1958-03-17UHC-94194-3068022402418953 Main St, Glendale, AZ, 853080.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-408183CLMAlice Wang1938-03-05UHC-19783-63—9104 River Rd, Austin, TX, 787390.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421840CLMBilly Hamilton1962-12-26UHC-77514-1654690134692692 Meadow Ln, Phoenix, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-415034CLMBenjamin Garcia1939-10-07UHC-62566-50—5928 Market St, Jacksonville, FL, 322540.66Name re-casedMember ID reformattedState name converted to codeZIP+4 trimmed+1 more
CLM-424537CLMBen Thomas2000-07-14UHC-38480-2962034206901402 Hillcrest Rd, Tempe, AZ, 852480.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-410375CLMArjun Larson1991-01-24UHC-89929-2498544054541443 Mesa Dr, Plano, TX0.66Two-digit birth yearPhone reformattedCity re-casedState code upper-cased+1 more
CLM-407354CLMMarilyn West1965-09-17UHC-51771-8590533293455435 Apache Blvd, San Diego, CA, 921560.66Phone reformattedSSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
CLM-407355CLMMarilyn West1965-09-17UHC-51771-8590533293455435 Apache Blvd, San Diego, CA, 921560.66Phone reformattedSSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
CLM-400532CLMChristian W Carpenter1947-09-17——8062 Canyon Rd, Los Angeles, CA, 900820.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-419101CLMJulia Alexander1993-08-02UHC-68877-99—5257 Elm St, Gilbert, AZ, 852250.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-406556CLMNicholas Larson1993-08-09UHC-90661-50—9895 Sunset Blvd, Minneapolis, MN0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-419273CLMVincent E Graham1962-12-07——4569 Oak St, Chandler, AZ, 852080.66Phone missing area codeCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-410752CLMZachary Shaw1965-07-13UHC-32514-98—6728 Market St # 237, Mesa, AZ, 852830.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-413841CLMAustin Nelson1974-06-14—47045371639886 Park Pl, Nashville, TN, 372610.66Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+1 more
CLM-416100CLMYuki A Marquez1975-11-13UHC-38069-86—5165 Mountain View Dr, Houston, TX, 770770.66Two-digit birth yearCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-420469CLMPhilip Holmes1963-12-14UHC-83762-30—9662 Indian School Rd, Gilbert, AZ, 852550.66Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408345CLMBrenda Stephens1963-11-26UHC-21755-58—5273 Church St, Tempe, AZ, 852560.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-424873CLMAlice Porter1985-07-23—75095728115235 Lake View Rd, Tempe, AZ, 852320.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-418356CLMSteven Wset1968-04-02UHC-27799-40358505506816 Mesa Dr, Gilbert, AZ, 852680.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-425575CLMElijah Lynch1952-11-08UHC-37755-5078648436833236 Camelback Rd, Austin, TX, 787480.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-429032CLMIsabella McDonald1965-02-03UHC-42587-12—4192 Willow Ct, Orlando, FL, 328160.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411119CLMJessca Evans1974-08-13—54060060532157 River Rd, Dallas, TX, 752420.66Street suffix standardisedAddress re-casedState code upper-casedGender normalised+1 more
CLM-409475CLMEmily T Little1940-02-24——6250 Willow Ct, Las Vegas, NV, 891380.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-422025CLMRyan I Edwards2000-05-08UHC-79280-234973042142638 Church St, Gilbert, AZ, 852600.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-420325CLMLawrence Nichols1979-03-14——5355 Forest Ave, Atlanta, GA, 303500.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-412810CLMSantiago Wong1969-01-19UHC-35346-77—4049 Washington St, Houston, TX, 770810.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
32,829 rows, page 193 of 657PreviousNext