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-429659CLMBetty P Peters1971-02-24—25238203696038 Market St, Scottsdale, AZ, 852290.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-404397CLMSamantha Castillo1972-09-18UHC-23757-474294026965398 Meadow Ln Apt 27, Atlanta, GA, 303020.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-404282CLMAisha Fowler1946-04-20——1357 Cedar Ln, Nashville, TN, 372040.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-424149CLMAngela Wuods1978-01-03——6025 Oak St, Minneapolis, MN, 554070.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-413442CLMLuis Hunter1997-11-24UHC-49762-132293013474189 Ocean Ave # 953, Plano, TX, 750220.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421710CLMSophia Ray——7377922231707 Valley View Dr, Austin, TX, 787370.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429485CLMSteve King1969-01-20—21997798715493 Meadow Ln, Los Angeles, CA, 900190.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-427635CLMHiroshi Moore1950-09-08UHC-19734-64—952 Union St, Glendale, AZ, 853880.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-410059CLMMeyer Yuki1950-06-01UHC-39552-52—7772 Harbor Blvd, Seattle, WA, 981220.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409078CLMRobert N Tren1978-03-12UHC-15067-68—6155 Spring St, Plano, TX0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422276CLMJanet Morgan1968-04-24UHC-17766-52—2596 Sunset Blvd Apt 39, Chandler, AZ, 852280.50Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-428847CLMKelly Contreras2004-02-22——6369 Maple Ave, Eden Prairie, MN, 553460.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-415614CLMTerry Singh1956-05-20UHC-09840-40—7381 Main St, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402896CLMBradley Q Hayes1943-07-10—24639068138430 Forest Ave, Las Vegas, NV, 891180.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-415567CLMBenjamin P Singh1948-11-04UHC-04897-534392169084747 Ocean Ave, San Antonio, TX, 782860.50Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+3 more
CLM-406424CLMLawrence Elijah1960-10-13UHC-97485-2127827581357475 Cedar Ln, Phoenix, AZ, 850910.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
CLM-406568CLMJonathan Weaver1979-02-25UHC-19398-18—1511 Palm Dr, Tucson, AZ, 857930.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404577CLMScott D Richardson1980-05-06—98345416009172 Canyon Rd, Chandler, AZ, 852430.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432581CLMZachary Mitchell—UHC-77378-2042690499415449 Jefferson Ave, Charlotte, NC, 282780.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410180CLMDylan Simpson——46726818354745 Lake View Rd Apt 3, Minneapolis, MN, 554750.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-413974CLMMargaret Gardner1978-11-20UHC-83781-04—9118 Cedar Ln, Orlando, FL, 328640.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407339CLMMari I Estrada1953-05-25UHC-10803-9267237126565526 Valley View Dr # 559, Jacksonville, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-429344CLMGloria A Howard2000-02-07UHC-86207-58—3701 Ridge Rd, Mesa, AZ, 852060.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407348CLMGeorge Murphy1998-10-14UHC-12080-5196480525072791 Elm St # 190, Fresno, CA, 937780.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-427123CLMJeremy Chen2007-05-25——2206 Spring St, Fresno, CA0.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-403778CLMRaymmond Vasquez1997-10-05UHC-16882-1054696785762095 Cedar Ln Apt 12, Tampa, FL, 336690.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
CLM-427906CLMEmma Q Clark2005-11-07—78269770888762 River Rd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402814CLMBrandon Y Obrien1985-10-23——2492 Forest Ave, Las Vegas, NV, 891310.50Name split from “Last, First”Name re-casedStreet suffix standardisedAddress re-cased+3 more
CLM-423328CLMOmar Ortiz1956-02-23——2029 Ridge Rd, Nashville, TN, 372390.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-432638CLMNicole Stewart1966-03-23UHC-66328-57—4480 Desert Sky Blvd, San Antonio, TX, 782430.50Name re-casedCity re-casedState name converted to codeZIP+4 trimmed+3 more
CLM-429805CLMJessica L Hunt1980-04-27UHC-73352-6577641915393711 Valley View Dr, Miami, FL, 331710.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-408995CLMAln D Burke1979-06-18——7703 Willow Ct Apt 11, Glendale, AZ, 853100.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-416270CLMEmyly Brown1943-12-10UHC-53245-33—8526 Valley View Dr, Eden Prairie, MN, 553320.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-421847CLMOlivia Powell1960-07-13UHC-19972-8648161255493983 Bayshore Dr, Columbus, OH0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412624CLMVincent U George1996-04-01UHC-05005-6540122944191886 Market St, Miami, FL0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-409818CLMArthur H Spencer1942-06-07—87794577731104 Mesa Dr Apt 31, Minneapolis, MN, 554230.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-407563CLMMelissa Vaaldez1954-02-10UHC-81960-04—962 Valley View Dr Apt 26, Dallas, TX0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401067CLMNathan Delgado1947-12-17UHC-06879-352056078663425 Desert Sky Blvd, Dallas, TX, 752870.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415916CLMJulie Rios1994-08-06UHC-27625-4189542992765635 Lincoln Way, Los Angeles, CA, 900020.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401200CLMKatherine Fields1960-04-02UHC-27585-35—7998 Spring St, Mesa, AZ, 852050.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-405570CLMJudy Guerrero2000-09-26—36890522787102 Oak St, Tucson, AZ, 857490.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402302CLMEmma Castillo1966-01-03UHC-15311-16—6915 Oak St, Los Angeles, CA, 900150.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430638CLMBeverly Davis1975-07-12UHC-26050-1745569803573508 Grand Ave, Dallas, TX, 752950.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430276CLMEugene Cruz1988-03-02UHC-78205-34—1352 Cedar Ln # 525, Tucson, AZ, 857080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-430277CLMEugene Cruz1988-03-02UHC-78205-34—1352 Cedar Ln # 525, Tucson, AZ, 857080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-418248CLMLinda Warren1947-03-14UHC-15412-53—2937 Sunset Blvd, Atlanta, GA0.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-429051CLMWilliam Hall1975-07-16——1847 Pine Dr, Scottsdale, AZ, 852720.50Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+3 more
CLM-430120CLMKenneth Austin1999-05-12UHC-79067-7622955983209530 Forest Ave Apt 40, Miami, FL, 331210.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-431042CLMDoris T Mendez1997-11-25UHC-89129-8937098177024014 Harbor Blvd Apt 40, Miami, FL, 331780.50Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+3 more
CLM-431677CLMChristopher Q Willis—UHC-10720-18—269 Indian School Rd, Jacksonville, FL0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 23 of 657PreviousNext