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-425918CLMLisa Payne1977-09-12——6546 Pine Dr, Tucson, AZ0.66Street suffix standardisedAddress re-casedState code upper-casedZIP missing+1 more
CLM-400469CLMVirginia Gibson1959-11-11UHC-43822-8425368499392972 Jefferson Ave Apt 22, Orlando, FL, 328860.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-402181CLMCatherine Silva1991-10-18UHC-28183-55—1651 Oak St, Austin, TX0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-415316CLMSara K Scott1958-06-18——9443 Broadway # 572, Tempe, AZ, 852700.66Unit split from streetAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-409157CLMSteven Gilbert1963-12-04UHC-22739-27—2769 Lincoln Way, Tampa, FL, 336110.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-432116CLMAndrea J Gray1975-11-10——1001 Broadway, Gilbert, AZ0.66Name re-casedState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-420500CLMBruce Perkins1973-10-17UHC-27600-5132449236418366 Lake View Rd, Los Angeles, CA, 900480.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-409446CLMJoan Moore1972-11-12——5224 Grand Ave Apt 15, Scottsdale, AZ, 852360.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-414128CLMMichelle Wong1995-11-14UHC-62600-52—9654 Central Ave, Chandler, AZ, 852150.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-429780CLMSteve Santos1967-05-01——7119 Mountain View Dr, San Diego, CA, 921070.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-430048CLMMartha O Powell2008-12-24—22160682046225 Church St, Nashville, TN, 372140.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411598CLMMike F Li1994-02-04——9287 Jefferson Ave, Eden Prairie, MN0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-406942CLMNatalie Riley1951-12-26——9343 Ridge Rd, Seattle, WA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-404559CLMDavid Daniels2001-05-25——9352 Maple Ave Apt 6, Houston, TX, 770430.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-426034CLMKayla Cole2008-02-27UHC-60226-22—2740 Highland Ave, Nashville, TN, 372760.66Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-405194CLMJeremy Garrett1996-11-08UHC-85404-2693538643712455 Pine Dr, Nashville, TN, 372790.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-407514CLMTimothy S McDonald1984-02-20UHC-03894-18——0.66Name re-casedDate of birth reformattedPhone missing area codeGender normalised+1 more
CLM-411550CLMGbariel T Nguyen1949-04-25UHC-08946-13—5009 Jefferson Ave Apt 29, Chandler, AZ, 852120.66Unit split from streetCity re-casedState name converted to codeWhitespace trimmed+1 more
CLM-401099CLMMartha Padilla1940-01-26UHC-51567-53—3228 River Rd Apt 22, Tempe, AZ, 852020.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-416623CLMWayne Bailey2007-07-10UHC-22905-0170772900548816 Forest Ave # 794, Phoenix, AZ, 850170.66Name split from “Last, First”Unit split from streetCity re-casedPlan code upper-cased+1 more
CLM-424229CLMDiana Morgan1959-11-28——8762 Mesa Dr, San Antonio, TX, 782100.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-424350CLMEmma X Chapman1990-12-02UHC-69747-90—2569 Hillcrest Rd, Scottsdale, AZ, 852720.66Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
CLM-402030CLMRobert T Chen1981-09-28UHC-20989-0494440412523700 Willow Ct, Las Vegas, NV, 891390.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-415727CLMRandy Marshall2007-12-17UHC-21917-14—1355 Harbor Blvd, Los Angeles, CA, 900480.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428510CLMFrank Lawrence1945-09-08——6136 Harbor Blvd, Fresno, CA, 937240.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-407927CLMJeremy Reyes1973-02-03UHC-87372-54—5668 Church St, Tempe, AZ, 852760.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-415652CLMThheresa Young1940-01-10UHC-74149-85—97 Broadway Apt 2, Sacramento, CA, 958430.66Date of birth reformattedUnit split from streetAddress re-casedZIP+4 trimmed+1 more
CLM-427410CLMGloria Ward1968-09-02——2598 Hillcrest Rd, Miami, FL, 331660.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-430819CLMTimothy U Edwards1947-02-04——1203 Harbor Blvd, Las Vegas, NV, 891340.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430820CLMTimothy U Edwards1947-02-04——1203 Harbor Blvd, Las Vegas, NV, 891340.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-404766CLMJulie Payne1985-03-08UHC-29124-6397337487066265 Market St, Las Vegas, NV, 891150.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425071CLMJoen Fowler1983-10-14—71261095267025 Sage Ct, Fresno, CA, 937220.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-407772CLMBrian M Wang———2019 Valley View Dr Apt 10, Eden Prairie, MN, 553560.66Name re-casedDate of birth unreadableUnit split from streetWhitespace trimmed+1 more
CLM-424621CLMJack Austin1950-04-20UHC-01081-09—6937 Union St Apt 39, Orlando, FL, 328340.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-418327CLMScott Sims1974-05-06UHC-03945-1493542937683054 Maple Ave, San Antonio, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-403160CLMDiana Reid2000-02-01——9358 Desert Sky Blvd Apt 25, Sacramento, CA, 958440.66Name re-casedDate of birth reformattedUnit split from streetGender normalised+1 more
CLM-409371CLMGerald W Ramirez1975-05-28UHC-09097-49—7735 Ridge Rd, Nashville, TN, 372360.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-423274CLMScott Hughes1997-01-24UHC-27255-93—2208 River Rd, Orlando, FL, 328400.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-401820CLMJon Rivera1992-08-01—3459145090728 Central Ave, Chandler, AZ, 852680.66Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
CLM-410843CLMAlbert Santos1985-08-12UHC-10621-5066597909402953 Union St, Chandler, AZ, 852210.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425133CLMNicole Riley2000-12-27UHC-46627-03—4814 Main St, Nashville, TN, 372950.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-407208CLMRuse Brenda1958-08-04UHC-21607-0771473148996353 Apache Blvd, Miami, FL, 331440.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-420810CLMMariana Jackson1992-11-20UHC-36939-96—8346 Palm Dr, Austin, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-416642CLMMaggie Cole1973-09-02UHC-65282-20—6556 Lake View Rd, Las Vegas, NV, 891980.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-422321CLMTimothy Kelely1963-02-22UHC-22592-15—4707 Church St, Glendale, AZ, 853090.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407490CLMDoris G Murphy1953-03-22UHC-18676-02—9130 Lincoln Way, Tampa, FL, 336870.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-428839CLMSamantha Bell1970-12-02—64098905365505 Church St # 843, Tampa, FL, 336950.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-432263CLMBryan N Vargas1991-01-19——6311 Sunset Blvd, Las Vegas, NV, 891010.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411560CLMSamantha Simmons1997-02-10UHC-59590-89——0.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-420982CLMRaymond Mendez2005-06-03—7887098471—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
32,829 rows, page 155 of 657PreviousNext