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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-411324CLMAnthony Hall1961-08-28UHC-14093-9428537277876150 Ridge Rd, San Diego, CA0.68Two-digit birth yearPhone reformattedZIP missingPlaceholder values cleared
CLM-409555CLMSphia B Campbell1943-10-25UHC-35949-94—5762 Main St, Atlanta, GA, 303830.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-417688CLMPatricia Cooper1972-01-15——2892 Pine Dr Apt 22, Jacksonville, FL, 322810.68Unit split from streetCity re-casedZIP+4 trimmedPlaceholder values cleared
CLM-432453CLMDouglas Lucas1944-09-12——2791 Forest Ave, Las Vegas, NV, 891770.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432454CLMDouglas Lucas1944-09-12——2791 Forest Ave, Las Vegas, NV, 891770.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409496CLMKevin U Bell2005-12-22UHC-53553-918812532813—0.68Phone reformattedSSN last four extractedGender normalisedPlaceholder values cleared
CLM-411335CLMCarol Lewis1949-07-22UHC-11461-87—2415 Lincoln Way, Las Vegas, NV0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-409375CLMRalph Pierce1962-10-19—20634455707815 Desert Sky Blvd, Nashville, TN, 372510.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-424762CLMShirley Munoz1962-10-06UHC-28956-1053589224639750 Sage Ct, Fresno, CA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-424138CLMJuan Morris2008-10-17UHC-99012-31449580140750 Washington St, Houston, TX, 770430.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-409285CLMSandra Fox1971-01-19—23528751578751 Washington St, Las Vegas, NV0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
CLM-406854CLMGary Gonzales1973-01-28UHC-74556-13—8296 Park Pl, Gilbert, AZ, 852320.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-421113CLMEric Castillo1941-01-03UHC-84548-13——0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-400480CLMHiroshi Ortega1979-11-11UHC-36461-06—188 Elm St, Austin, TX, 787990.68Name split from “Last, First”City re-casedState name converted to codePlaceholder values cleared
CLM-402009CLMJulia Banks1999-05-12——2452 Canyon Rd, Fresno, CA, 937630.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404137CLMDylan Webb1993-04-28—63876728482218 Harbor Blvd, Eden Prairie, MN, 553240.68Phone reformattedStreet suffix standardisedAddress re-casedGender normalised
CLM-426126CLMLogan Lucas1974-09-21——6921 Harbor Blvd, Plano, TX, 750410.68Two-digit birth yearPhone missing area codeWhitespace trimmedPlaceholder values cleared
CLM-429196CLMSandra Barnes1941-11-11UHC-80935-128986438361—0.68SSN last four extractedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-429195CLMSandra Barnes1941-11-11UHC-80935-128986438361—0.68SSN last four extractedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421395CLMPaul Harriis1943-10-08UHC-51958-95—881 Forest Ave, Tucson, AZ, 857850.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406929CLMSantiago Gonzales2004-12-06——5989 Main St, Eden Prairie, MN, 553600.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-420104CLMAshley Park—UHC-77999-99——0.68Name re-casedDate of birth unreadablePhone missing area codePlaceholder values cleared
CLM-403350CLMJoshua Berry1960-10-16UHC-95503-74—8922 Mountain View Dr, Miami, FL, 331820.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-432277CLMTeresa Lawrence1946-08-03—7009155535191 Main St, Tucson, AZ, 857100.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-415531CLMLaura Q Ramos1995-07-22UHC-35531-4847586254749515 Jefferson Ave # 156, Tucson, AZ, 857540.68Member ID reformattedUnit split from streetGender normalisedPlaceholder values cleared
CLM-411381CLMJudy Miller1994-05-09——9313 River Rd, Tampa, FL, 336600.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-417126CLMJordan Carr1977-09-07UHC-85213-42—4252 Park Pl, Jacksonville, FL, 322010.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-423510CLMRaymond Collins1938-06-04UHC-19511-99—4114 Apache Blvd, Glendale, AZ, 853180.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-403713CLMDiana Meeyer—UHC-82280-7590751980265374 Sunset Blvd, Tucson, AZ0.68Date of birth unreadablePhone reformattedZIP missingPlaceholder values cleared
CLM-428212CLMCarl Murray1998-01-19—88578748031170 Elm St, Phoenix, AZ, 850480.68Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased
CLM-420913CLMRichard Franklin————0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-427642CLMShirley Simpson1987-07-05——873 Willow Ct, Eden Prairie, MN0.68Phone missing area codeZIP missingWhitespace trimmedPlaceholder values cleared
CLM-421054CLMDennis Sims1968-04-06——4238 Broadway, Eden Prairie, MN, 553520.68Two-digit birth yearAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-414738CLMYuki Foster—UHC-89406-61—3566 Lake View Rd, Sacramento, CA, 958470.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-400526CLMGeorge I Nichols1992-08-10UHC-59529-24——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-431421CLMNoah White1944-06-22UHC-99894-7526279253156884 River Rd # 263, Fresno, CA, 937590.68Phone reformattedUnit split from streetGender normalisedPlaceholder values cleared
CLM-408120CLMThomas Cox1986-04-10——1819 Mesa Dr, Seattle, WA, 981790.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-401788CLMAmanda J Wallace1942-12-28—94420448057313 Valley View Dr, Plano, TX, 750900.68Street suffix standardisedAddress re-casedState code upper-casedGender normalised
CLM-403525CLMJoseph M Wang1976-04-25UHC-31813-40—7202 River Rd, San Diego, CA, 921720.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-428224CLMKaren Fisehr—UHC-80767-69—3938 Camelback Rd, Austin, TX, 787300.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder 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-424234CLM—Junk1979-09-07—98127113063010 Hillcrest Rd, San Antonio, TX, 782420.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
CLM-411120CLMJessica Evans1974-08-13UHC-87523-8854060060532157 River Rd, Dallas, TX, 752420.68Two-digit birth yearStreet suffix standardisedAddress re-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-418330CLMBrittany Jensen1944-03-11——4147 Forest Ave, Minneapolis, MN, 554760.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-409510CLMJean Hunt2000-11-13UHC-31215-87—3757 Central Ave, Seattle, WA, 981750.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-422100CLMTyler Barnes1966-03-01UHC-63428-80—2446 Apache Blvd, Jacksonville, FL, 322190.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
CLM-422031CLMJulie Flores2005-12-02——354 Lake View Rd, Orlando, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-417210CLMWilliam Stewart1961-07-10UHC-93919-22—8811 Sage Ct, Scottsdale, AZ, 852470.68City re-casedState name converted to codeZIP+4 trimmedPlaceholder values cleared
32,829 rows, page 212 of 657PreviousNext