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-424396CLMRandy Porter1939-08-26——5279 Washington St, Fresno, CA, 937050.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-423951CLMAnn Reed1969-04-14UHC-75559-7956971652216501 Maple Ave, Chandler, AZ, 852020.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430869CLMCheryl Chavez1952-01-05UHC-41463-71—988 Camelback Rd, Sacramento, CA, 958890.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-423345CLMMadison Kelly1952-05-25UHC-20054-54—5238 Sage Ct, Nashville, TN, 372750.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-430129CLMMelissa Maldonado1971-06-16UHC-80701-58—7835 Church St, San Antonio, TX, 782720.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-409731CLMElijah K Castillo1953-09-23UHC-83539-8147070232922305 Oak St, Chandler, AZ, 852930.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-407993CLMSamantha D Nunez1990-02-28UHC-31120-14—3542 Hillcrest Rd, Los Angeles, CA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-424134CLMMarilyn P Ross1968-11-15UHC-88869-4247147161244816 Mesa Dr, Charlotte, NC, 282980.66Phone reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-430063CLMBenjamni Taylor1965-12-19—90283459918247 Lake View Rd, Gilbert, AZ, 852170.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431469CLMKim Heather—UHC-33481-45——0.66Name re-casedDate of birth unreadableMember ID reformattedGender normalised+1 more
CLM-418268CLMLucia Jensen1961-09-25UHC-79734-63—217 Park Pl, San Diego, CA, 921240.66Name re-casedDate of birth reformattedPhone missing area codeGender normalised+1 more
CLM-417646CLMDiana S Bailey1999-12-01UHC-96404-93—7001 Central Ave, San Antonio, TX, 782460.66SSN last four extractedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-420852CLMJean Espinoza1942-05-24—48931417893118 Jefferson Ave, Jacksonville, FL, 322610.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-429002CLMJessica E Peterson2006-07-07—84570611338905 Indian School Rd Apt 23, Scottsdale, AZ, 852960.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-403459CLMJudy Patel1967-02-01UHC-05568-9967367402822365 Grand Ave # 289, Tucson, AZ, 857420.66Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+1 more
CLM-400497CLMJudith Gonzales1995-04-21——144 Canyon Rd, Seattle, WA, 981950.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-428708CLMAlexander Charlotte1966-07-09UHC-38582-598152173038—0.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
CLM-413691CLMDianeJunk1996-07-02UHC-87387-0761243576569757 Ridge Rd, Charlotte, NC, 282850.66Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-404183CLMSofia Carr2005-07-11——6550 Main St, Sacramento, CA, 958650.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-425419CLMSamantha Palmer2008-02-16UHC-09047-81—523 Lake View Rd, Los Angeles, CA, 900490.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-419250CLMFatima Henderson1970-11-22UHC-17129-93—7774 Church St, Dallas, TX, 752550.66Two-digit birth yearCity re-casedState name converted to codeWhitespace trimmed+1 more
CLM-417939CLMJaniice Greene1986-08-15UHC-32981-0659378205153408 Spring St, Sacramento, CA, 958290.66Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+1 more
CLM-430043CLMMei B Walsh1980-04-15——6193 Church St, Orlando, FL, 328060.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-402094CLMNataalie Graham1969-01-02UHC-06183-5538882610898770 Oak St, Jacksonville, FL, 322280.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-400464CLMDavid Coleman1950-03-23UHC-62709-80—2925 Main St, Scottsdale, AZ, 852860.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-424316CLMEmily Ortega1946-07-20—94257853815771 Grand Ave, Las Vegas, NV, 891790.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-400492CLMRoy Butler1975-12-16UHC-98340-50—9411 Desert Sky Blvd, Glendale, AZ, 853100.66Date of birth reformattedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-414187CLMSarah Bennett1976-11-09——9583 Market St, San Antonio, TX, 782390.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422208CLMThomas Shirley1948-01-12UHC-72311-42—9291 Mountain View Dr, Miami, FL, 331270.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-415923CLMMarcus B Alexander1987-11-15UHC-89293-82—1390 Valley View Dr Apt 6, Tempe, AZ, 852940.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-427981CLMAbigail R Rios1979-05-26UHC-06532-92—5815 Bayshore Dr # 723, San Antonio, TX, 782960.66Date of birth reformattedUnit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-419171CLMFrank Y Ramos1926-04-07UHC-76600-5763874822808980 Ridge Rd, Los Angeles, CA, 900720.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-410133CLMAndrew Little1972-07-06——3646 Sunset Blvd # 675, Tempe, AZ, 852170.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-420030CLMFoster Doris1950-02-27UHC-91756-7978755849935527 Pine Dr, Las Vegas, NV, 891540.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-421944CLMDouglas Soto1984-12-21——5646 Canyon Rd, Fresno, CA, 937080.66Date of birth reformattedSSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
CLM-426595CLMJudy L Robinson1984-04-18UHC-50698-8821258193281766 Maple Ave, Jacksonville, FL0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-417923CLMDanielle E Martinez1968-05-07UHC-20534-6594920448252953 Valley View Dr, Plano, TX, 750950.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-415163CLMCarol U Pena1995-03-26UHC-31476-15—2755 Palm Dr, Jacksonville, FL0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-416924CLMPaul U Lawson2005-04-09UHC-29000-24—2360 Mesa Dr, Eden Prairie, MN, 553720.66Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-414716CLMBrandon Fernandez—UHC-58402-8070998751604574 Canyon Rd, Seattle, WA, 981860.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-428844CLMHarrison Henry1986-07-18UHC-33101-68—7019 Washington St, Chandler, AZ, 852340.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-415109CLMVirginia Jackson1958-05-09UHC-96033-9930259902881576 Oak St, Austin, TX, 787740.66SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-411336CLMJacqueline Burke1969-12-10——9478 Harbor Blvd, San Diego, CA, 921220.66Name re-casedTwo-digit birth yearState code upper-casedGender normalised+1 more
CLM-420636CLMJackie Munoz1995-02-03——7856 Mountain View Dr Apt 30, Miami, FL, 331230.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-431857CLMKathleen Lane2005-05-21UHC-17661-7954063347402331 Spring St, Phoenix, AZ0.66City re-casedState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-409782CLMMei A Johnson1978-02-23——4634 River Rd, Plano, TX, 750890.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-425388CLMShilrey Cruz1951-11-28—76863684597029 Ridge Rd, Tampa, FL0.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-430895CLMKatherine Ellis1945-08-02—34283657351385 Jefferson Ave, Eden Prairie, MN, 553220.66Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-421617CLMVictoria Fields1943-08-20——4522 Mesa Dr, Minneapolis, MN, 554730.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-408953CLMHeather Porter2004-08-24UHC-28711-8348797365054648 Baseline Rd, Charlotte, NC, 282270.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
32,829 rows, page 164 of 657PreviousNext