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-427421CLMGrace Watkins1979-12-27——9798 Central Ave, Los Angeles, CA, 900380.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-415740CLMJonathan L Li1953-03-23UHC-13181-99—5572 Mesa Dr, Charlotte, NC0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-427405CLMBetty Hwell1946-06-14UHC-12924-59—8049 Highland Ave, Gilbert, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-414868CLMDorothy Hudson1988-11-08UHC-18183-88—3077 Meadow Ln, Minneapolis, MN, 554370.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-423325CLMAustin D Wong1979-03-20UHC-43391-4422367910959008 Willow Ct, Las Vegas, NV0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-427061CLMAamnda Singh1946-10-03——2132 Baseline Rd, Dallas, TX, 752740.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-407324CLMMichael Ray1942-10-25UHC-73727-67—6408 Desert Sky Blvd, Dallas, TX0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-426687CLMFrances B Ross1987-12-11——379 Washington St, Las Vegas, NV, 891880.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-424720CLMJoan Weber—UHC-41593-57—2151 Canyon Rd, Los Angeles, CA0.54Date of birth unreadableZIP missingGender normalisedWhitespace trimmed+1 more
CLM-425112CLMRichard West1945-06-02UHC-77633-09—7522 Desert Sky Blvd, Glendale, AZ0.54Name re-casedTwo-digit birth yearZIP missingGender normalised+1 more
CLM-414957CLMTyler S Torres2002-11-05UHC-22537-44—9062 Oak St Apt 26, Tampa, FL0.54Unit split from streetCity re-casedState name converted to codeZIP missing+1 more
CLM-427480CLMWayne X Castillo1957-03-05UHC-95042-59——0.54Middle initial moved out of first nameTwo-digit birth yearPhone missing area codeWhitespace trimmed+1 more
CLM-427481CLMWayne X Castillo1957-03-05UHC-95042-59——0.54Middle initial moved out of first nameTwo-digit birth yearPhone missing area codeWhitespace trimmed+1 more
CLM-400603CLMKatherine B Spencer1941-12-05UHC-92145-04—7159 Jefferson Ave, Eden Prairie, MN0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
CLM-420075CLMVictoria Salazar1970-06-13UHC-74312-4941784079619172 Lake View Rd, Los Angeles, CA, 900710.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-430706CLMAhmed Cooper1942-03-08UHC-91936-3184472841138482 Valley View Dr # 486, Los Angeles, CA, 900280.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-412113CLMChristopher Jenkins1982-09-18UHC-46541-04—9681 Forest Ave, Dallas, TX0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-401698CLMSteve G Jensen1981-11-03—30235078895564 Washington St, Minneapolis, MN, 554300.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-416403CLMHarold Rojas—UHC-16881-88—4310 Ridge Rd, Fresno, CA, 937940.54Date of birth unreadablePhone missing area codeState name converted to codeWhitespace trimmed+1 more
CLM-416402CLMHarold Rojas—UHC-16881-88—4310 Ridge Rd, Fresno, CA, 937940.54Date of birth unreadablePhone missing area codeState name converted to codeWhitespace trimmed+1 more
CLM-423923CLMGeorgeJunk1990-12-21—81260493565038 Ocean Ave, Seattle, WA, 981650.54Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared+1 more
CLM-430168CLMLawrence I Ray—UHC-62884-26—475 Pine Dr, Jacksonville, FL, 322130.54Name split from “Last, First”Date of birth unreadableZIP+4 trimmedWhitespace trimmed+1 more
CLM-410359CLMAhmed Riley2007-03-13UHC-08481-83—5024 Hillcrest Rd, Jacksonville, FL, 322830.54Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-401749CLMKelly Harper2003-03-10UHC-75619-5332434229248799 Jefferson Ave, San Diego, CA0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-419004CLMReynolds Wei1973-07-01UHC-28141-19—2782 Apache Blvd, Scottsdale, AZ, 852970.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-405259CLMFrank Padilla1964-02-14UHC-18739-5464031681583588 River Rd, Minneapolis, MN0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-402301CLMLawrece K Johnston1952-10-18UHC-57335-96—5968 Park Pl, Chandler, AZ, 852230.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-411393CLMLori Jordan1985-05-24UHC-12979-7072149276073367 Ocean Ave, Mesa, AZ, 852090.54Name split from “Last, First”City re-casedState name converted to codeGender normalised+1 more
CLM-412928CLMJustin Tran1940-01-10UHC-70251-56—7628 Pine Dr, Las Vegas, NV, 891290.54SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-407999CLMJean Waatkins1990-03-21——5101 Mountain View Dr, Seattle, WA0.54Name split from “Last, First”State name converted to codeZIP missingWhitespace trimmed+1 more
CLM-424915CLMDebra R Knight1991-04-27UHC-42617-07—4546 Church St, Tampa, FL, 336440.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-401974CLMJustin Myers1972-03-15——1634 Apache Blvd, San Diego, CA, 921890.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-416636CLMAnn G Stewart1946-07-10——6460 Valley View Dr, Gilbert, AZ, 852950.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-407143CLMDylan Watkins2007-10-27——343 Bayshore Dr, Seattle, WA, 981910.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-414983CLMHenry Gray1948-10-20——9612 Jefferson Ave, Charlotte, NC0.54Name split from “Last, First”Two-digit birth yearCity re-casedZIP missing+1 more
CLM-422571CLMValentina Wong—UHC-87911-51——0.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-426420CLMWei Nichols———8744 Sunset Blvd, Chandler, AZ0.54Date of birth missingState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-407424CLMPriya Ortiz1946-06-05——3345 Baseline Rd, Tucson, AZ, 857830.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-423584CLMHaroold O Howell—UHC-51378-7448443126282564 Valley View Dr, Tucson, AZ0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-411784CLMBarbara M Yang2003-08-06——2610 Palm Dr # 245, Sacramento, CA0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-408406CLMMarilyn N Meyer1969-04-26—43388749147037 Forest Ave, Fresno, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-428872CLMWalter Carlson1955-10-26UHC-39159-1942954065492773 Mountain View Dr, Phoenix, AZ, 850670.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-418083CLMLaura Banks1969-10-15——5289 Lake View Rd Apt 14, Scottsdale, AZ, 852730.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-421813CLMCamila Lawrence1967-10-12——6983 Grand Ave Apt 8, Sacramento, CA0.54Unit split from streetState code upper-casedZIP missingGender normalised+1 more
CLM-401673CLMGrace Valdez2002-08-14UHC-35478-16—2005 Elm St # 888, Jacksonville, FL, 322980.54Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+1 more
CLM-406231CLMVictoria Z Schmidt1988-06-12UHC-00189-2453776272444939 Church St, Gilbert, AZ, 852760.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-425234CLMDavid Nguyen1992-12-28——7691 Washington St # 884, Jacksonville, FL, 322880.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-408850CLMMarriana Mason1965-12-17UHC-25369-28—7478 Mountain View Dr, Jacksonville, FL, 322700.54Name split from “Last, First”ZIP+4 trimmedGender normalisedPlan code upper-cased+1 more
CLM-406588CLMTyler Young1981-07-21UHC-00161-11—7471 Ocean Ave, Tampa, FL, 336570.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-424593CLMPaul D Estrada—UHC-63153-8195868793665930 Ridge Rd, Seattle, WA0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
32,829 rows, page 58 of 657PreviousNext