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-432448CLMChristina Cooper1958-05-08UHC-08660-1979493040456821 Sage Ct, Miami, FL, 331790.62Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-422397CLMBetty Riley2003-08-15—31676316739568 Grand Ave, Sacramento, CA0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-403880CLMJulie Morgan1969-02-27UHC-84290-6497596529997947 Sage Ct, Gilbert, AZ, 852900.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415108CLMVirginia Jackson1958-05-09UHC-96033-9930259902881576 Oak St # 749, Austin, TX, 787740.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406720CLMMartha Parker1947-12-24——9880 Forest Ave, Phoenix, AZ, 850950.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-423229CLMMichelle Kelley1963-08-16UHC-79555-07—8397 Pine Dr, Minneapolis, MN, 554380.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400289CLMSantiago Valdez2000-02-24UHC-41588-9584223653556743 Hillcrest Rd, Charlotte, NC, 282660.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432456CLMKattherine Ross1957-08-01UHC-97525-84—942 Spring St, Mesa, AZ, 852440.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416973CLMJose Williamson1947-04-24—51772438566243 Ridge Rd, Tucson, AZ, 857510.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416972CLMJose Williamson1947-04-24—51772438566243 Ridge Rd, Tucson, AZ, 857510.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400611CLMSamuel Hoffman1995-05-28UHC-48552-8157052672428568 Elm St, Las Vegas, NV, 891590.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428994CLMJack Pena2004-03-20—65599103764207 Baseline Rd Apt 23, Phoenix, AZ, 850830.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-427048CLMBeverly Andrews1967-12-18——2649 Canyon Rd, Nashville, TN, 372990.62Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-404406CLMAlice X Morris1995-06-09UHC-55977-0168096029529349 Ocean Ave, Chandler, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421879CLMCatherine Peterson1954-08-10UHC-33326-0262588367654080 Canyon Rd, Phoenix, AZ, 850570.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424574CLMGary Knight1974-09-02—64695597952037 Camelback Rd, Sacramento, CA0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-404385CLMGregory K Smith1984-03-20——6641 Mesa Dr # 209, Seattle, WA, 981500.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-427580CLMRalph Peterson1995-08-04——1958 Market St, Sacramento, CA, 958830.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-425624CLMMason McDonald1974-03-23—86895198162651 Mountain View Dr, Glendale, AZ, 853360.62Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-430966CLMDiana Richards1941-10-18UHC-14537-4948379530262214 Camelback Rd, Dallas, TX, 752310.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431075CLMBrenda Carpenter1993-02-15——7814 Willow Ct, Columbus, OH, 432170.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422407CLMJack Garza1966-10-12UHC-71666-675512424663363 Bayshore Dr, Las Vegas, NV, 891780.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-402027CLMDenise Johnston2008-03-09UHC-49425-51—6538 Palm Dr, Gilbert, AZ, 852100.62Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
CLM-414191CLMAmber Ross1973-10-05—42163686759468 Pine Dr, Las Vegas, NV, 891780.62Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-402037CLMThomas Chavez1959-01-21UHC-08205-9363969103346626 Market St # 710, Miami, FL, 331990.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-428197CLMGary Jenkins1988-12-04UHC-39155-9568271509499616 Desert Sky Blvd, Los Angeles, CA, 900060.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-414282CLMRebecca Carpenter1995-11-21UHC-36683-87—5423 Camelback Rd, Tampa, FL, 336550.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423314CLMMark Elliott1981-08-23UHC-53509-9927285563637325 Harbor Blvd, Minneapolis, MN, 554700.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-428996CLMJustin Rice1948-06-02UHC-64295-91—2262 Union St, Jacksonville, FL, 322540.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427680CLMFrank Hansen1998-04-09UHC-07640-6292189931131390 Mesa Dr, Los Angeles, CA, 900800.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414044CLMStephen L Lawson1974-09-03UHC-40167-9789421148025405 Valley View Dr # 813, Denver, CO, 802440.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-406087CLMBrandon Hill1984-07-26UHC-22856-4221541264359744 Maple Ave, Scottsdale, AZ, 852230.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-430132CLMZachary W Harvey1982-02-22UHC-43673-22—7636 Canyon Rd Apt 15, Miami, FL, 331760.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-430720CLMMaria West1995-08-02—29237541127111 Forest Ave, Las Vegas, NV, 891250.62Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-409470CLMEmily Burns1967-05-03UHC-65846-6428933968583055 Desert Sky Blvd, Charlotte, NC, 282650.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429393CLMAmber Bishop—UHC-03362-7520522930035736 Sage Ct, Dallas, TX, 752360.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-403556CLMMarilyn G Hayes1971-05-03UHC-81234-7674120049259800 Grand Ave Apt 30, Charlotte, NC, 282070.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-413701CLMVincent Ruiz1975-11-21—21485799124505 Indian School Rd, Plano, TX, 750290.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-400431CLMCarroll Bradley2004-12-02——1790 Highland Ave, Columbus, OH, 432330.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422848CLMAna Gilert1979-03-17UHC-96425-46—3101 Ridge Rd, Houston, TX, 770680.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422847CLMAna Gilert1979-03-17UHC-96425-46—3101 Ridge Rd, Houston, TX, 770680.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421928CLMNancy Howard1994-02-07—38064225531720 Willow Ct, Las Vegas, NV, 891120.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-402815CLMVictoria Weber1939-05-02—96336934516370 Mountain View Dr, Mesa, AZ, 852710.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404708CLMYuki Espinoza1950-06-16UHC-32418-962243679502387 Harbor Blvd, Charlotte, NC, 282060.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405245CLMKeith Hernandez1998-11-21UHC-09533-29—1394 Apache Blvd, Scottsdale, AZ, 852390.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-404246CLMJon Sullivan1975-02-24—87675595107173 Desert Sky Blvd, Denver, CO, 802470.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-400748CLMShirley Williamson1962-04-25UHC-89515-8394663800484586 Church St, Tampa, FL, 336190.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-418011CLMMadison E Walsh1939-05-02UHC-80205-2068281600527858 Desert Sky Blvd, Gilbert, AZ, 852180.62Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-402097CLMBrittany R Taylor1982-05-25UHC-75127-09—6710 Valley View Dr, Mesa, AZ, 852990.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412531CLMKaren E Wagner1995-02-07——3199 Market St, Nashville, TN, 372130.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 92 of 657PreviousNext