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-414203CLMMeyer Justin—UHC-91993-915996239149420 Forest Ave, Tucson, AZ, 857680.66Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+1 more
CLM-427149CLMMichael Castilo1993-10-10——4631 Sage Ct, Denver, CO, 802760.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-409915CLMGerald Reyes1994-04-26UHC-79915-5865285665213662 Grand Ave, Gilbert, AZ, 852090.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-400753CLMChristina Peters1943-10-27——474 Canyon Rd, Mesa, AZ, 852750.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-410978CLMLauren Perez1949-06-06UHC-37524-53—7080 Main St, Fresno, CA, 937000.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-401465CLMBarbara Ruiz1989-09-07——2288 River Rd, Chandler, AZ, 852370.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404507CLMNathan Clark—UHC-59130-67—9074 Hillcrest Rd, Denver, CO, 802020.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-410198CLMArthur Alvarez1957-11-13——8552 Grand Ave, Columbus, OH, 432180.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429990CLMArthur Nichols—UHC-48023-8995579254991576 Mountain View Dr Apt 25, Columbus, OH, 432080.66Name re-casedDate of birth unreadableUnit split from streetCity re-cased+1 more
CLM-408171CLMBruce Sanchez1938-09-19UHC-50815-51—7349 Highland Ave, Eden Prairie, MN, 553440.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-400691CLMCharlote Bryant1993-09-22UHC-51096-97—4266 Union St, Denver, CO0.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-403432CLMRachel W Maldonaod1940-03-05UHC-51088-81—1474 Ridge Rd, Sacramento, CA0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-430942CLMMichelle Bowman1971-10-24UHC-64949-3439674067077317 Oak St, Tampa, FL, 336390.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-418225CLMMariana Reid1995-07-20——7707 Central Ave, Tempe, AZ, 852680.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-402196CLMSusan Morris1958-03-10—80029430296814 Baseline Rd, Jacksonville, FL, 322910.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-412446CLMRachl V Gibon2008-01-16UHC-55095-3358397979166950 Elm St, Glendale, AZ, 853570.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-419629CLMDiego Holmes2001-07-14UHC-44088-2127573530636248 Baseline Rd, Los Angeles, CA, 900610.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-422790CLMSharon Garza—UHC-74021-28—9247 Highland Ave, Columbus, OH, 432980.66Name re-casedDate of birth unreadablePhone missing area codeWhitespace trimmed+1 more
CLM-420616CLMJonathan Z Snyder——94146948538015 Oak St, Tampa, FL, 336830.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-426105CLMDonald Washington1999-02-07UHC-45902-95—732 Church St, Glendale, AZ, 853150.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-403084CLMTyler S Kelley1962-11-01UHC-71559-7037091525392984 Hillcrest Rd, Tucson, AZ, 857510.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-421453CLMRoanld Guerrero—UHC-63884-96—8347 Market St, Scottsdale, AZ, 852620.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-429074CLMCammila P Andrews—UHC-07406-7624029340596437 Broadway Apt 4, Charlotte, NC, 282350.66Date of birth unreadableUnit split from streetAddress re-casedCity re-cased+1 more
CLM-406239CLMSharon Kelly1943-08-28—4456755720—0.66Date of birth reformattedSSN last four extractedEmail lower-casedGender normalised+1 more
CLM-430141CLMSandra Reynolds—UHC-28203-5654996318793725 Apache Blvd, Jacksonville, FL, 322260.66Date of birth unreadableMember ID reformattedGender normalisedWhitespace trimmed+1 more
CLM-406687CLMVirginia Hofmfan1947-09-20UHC-79617-30—4417 Spring St, Plano, TX, 750000.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-425492CLMKathleen Jordan—UHC-29134-814562653540—0.66Name split from “Last, First”Date of birth unreadablePhone reformattedWhitespace trimmed+1 more
CLM-415524CLMPhilip Garrett1960-12-03UHC-23280-93—5689 Cedar Ln, Tucson, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-407567CLMJeremy Munoz—UHC-03662-518197310687—0.66Name re-casedDate of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-412963CLMAmanda Montgomery1969-03-19——6520 Harbor Blvd, Plano, TX0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-410200CLMDanielle Bell1959-12-08——7586 Spring St, Orlando, FL, 328070.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419005CLMYuki Harvey1941-01-22UHC-96441-04—334 Mountain View Dr, Miami, FL, 331670.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-404547CLMTeresa Washington1954-06-04——7191 Church St Apt 4, San Antonio, TX, 782790.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-413546CLMIsabella Payne1990-06-09UHC-66895-5093061518802458 Forest Ave Apt 15, Houston, TX, 770190.66Date of birth reformattedPhone reformattedUnit split from streetGender normalised+1 more
CLM-413547CLMIsabella Payne1990-06-09UHC-66895-5093061518802458 Forest Ave Apt 15, Houston, TX, 770190.66Date of birth reformattedPhone reformattedUnit split from streetGender normalised+1 more
CLM-415444CLMTyler J Rojas———4070 Main St, Scottsdale, AZ, 852630.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-428744CLMWilliam Shaw1971-12-02UHC-72752-11—5065 Lake View Rd, Los Angeles, CA, 900250.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-410743CLMGregory Hudson1954-02-04—53563688208058 Main St, Nashville, TN, 372620.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431987CLMEmily Taylor1946-06-08UHC-53019-81—6234 Elm St, Charlotte, NC, 282380.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-404757CLMJesse Gardner1984-12-15——7386 Central Ave Apt 12, Glendale, AZ, 853580.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-423119CLMReed Barbara1968-01-07UHC-47110-21—3533 Ridge Rd, Miami, FL, 331800.66Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430987CLMJulie Guerrero1976-02-13—90088934943375 Apache Blvd, Sacramento, CA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-412103CLMLawrence Rodriguez1939-09-17——2258 Church St, Nashville, TN, 372770.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-430093CLMJean Nelson1987-09-12UHC-20738-64—5776 Ridge Rd, Charlotte, NC, 282360.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-427620CLMRobert Bryant2006-01-01UHC-52468-82—7872 Ridge Rd, Las Vegas, NV, 891210.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-408865CLMMichelle Bowman1947-11-06——8737 Ridge Rd # 410, Austin, TX, 787470.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-424195CLMDavid Lynch—UHC-56000-70——0.66Name re-casedDate of birth missingGender normalisedWhitespace trimmed+1 more
CLM-408281CLMBetty Williamson2006-04-21——9404 Camelback Rd, Seattle, WA, 981110.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-403226CLMYuki M Richardson1982-02-08—61443306882434 Forest Ave, Eden Prairie, MN0.66Name split from “Last, First”Phone reformattedZIP missingWhitespace trimmed+1 more
CLM-404435CLMCharlotteJunk1981-10-02UHC-46549-708648823337948 Valley View Dr, Glendale, AZ, 853030.66Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared+1 more
32,829 rows, page 161 of 657PreviousNext