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-402722CLMGerald C Jonees1951-11-21UHC-35765-0858042215175976 Harbor Blvd, Atlanta, GA, 303370.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-400006CLMJsse Black2004-10-05UHC-94495-51—3456 Bayshore Dr, Nashville, TN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-421594CLMMaria Salazar1973-12-13UHC-61139-77—2905 Harbor Blvd, Las Vegas, NV, 891920.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-406082CLMFernandez R George1959-03-23UHC-61162-85—5931 Union St, Columbus, OH0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-405056CLMAshley Morrison1987-09-22UHC-68018-3865159298295044 Maple Ave, Phoenix, AZ, 850560.64Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401770CLMKathleen Nelson2002-03-19UHC-00781-1035654825557481 Mesa Dr, Nashville, TN, 372870.64Two-digit birth yearPhone reformattedMember ID reformattedGender normalised+2 more
CLM-429238CLMSandra Brown2005-02-05UHC-38120-34—4287 Central Ave, Mesa, AZ, 852780.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414336CLMLucia V Welch1983-09-18—59456306771802 Spring St, Mesa, AZ, 852130.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410215CLMGary West1940-04-16——5456 Cedar Ln, Eden Prairie, MN, 553980.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-421362CLMAngela Oliver1994-06-04UHC-69117-8427681895509075 Desert Sky Blvd, Tucson, AZ, 857380.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414756CLMSandra Simmons1967-02-27——469 Elm St, Seattle, WA, 981810.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-431938CLMNatalie Nguyen1999-08-14UHC-95171-023027117996391 Willow Ct, Nashville, TN, 372670.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432367CLMTeresa Woods1968-09-17UHC-42550-0576545107284912 Hillcrest Rd, Chandler, AZ, 852210.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426953CLMGerald Dean1964-08-14UHC-07212-83—6063 Ridge Rd, San Diego, CA, 921960.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400647CLMDouglas L Russell1972-05-10UHC-97092-57—2814 Washington St Apt 32, Denver, CO, 802370.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418715CLMJazon Watson1999-06-27UHC-31272-9743221938048344 Harbor Blvd, Columbus, OH0.64Name split from “Last, First”Phone reformattedCity re-casedState code upper-cased+2 more
CLM-415574CLMCharles Russell1956-03-23UHC-91688-4929567299515776 Indian School Rd, Gilbert, AZ, 852930.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-407582CLMRobert Obrien1956-09-11—41686320562522 Bayshore Dr Apt 32, Phoenix, AZ, 850270.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-431964CLMFrances E Williamson1960-12-08UHC-12909-32—3123 Mountain View Dr, Nashville, TN, 372780.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-418256CLMMark Y Green—UHC-96867-75—9414 Pine Dr, Sacramento, CA, 958810.64Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406844CLMVirginia Clark1948-02-25UHC-21787-94—670 Sage Ct, Glendale, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-426042CLMSara Willis1952-11-05—31042399683782 Valley View Dr Apt 35, Scottsdale, AZ, 852450.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-418182CLMMaria Q Medina1938-06-17——6083 Baseline Rd, San Antonio, TX0.64Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
CLM-430377CLMParker Brenda1959-12-24UHC-50412-36—6506 Elm St Apt 21, Austin, TX, 787750.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-410134CLMAndrew Little1972-07-06UHC-11547-9739035315357344 Oak St, Chandler, AZ, 852760.64Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-404814CLMBobby Z Rivera1978-07-28——6527 Washington St, Scottsdale, AZ, 852360.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-407216CLMTheresa Espinoza1979-02-20UHC-67186-1438791014658697 Mountain View Dr, Orlando, FL, 328730.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423224CLMSharon Dean2005-09-11——1782 Valley View Dr, Charlotte, NC, 282020.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-408701CLMJacqueline Pierce1939-11-08UHC-89578-7463260088184171 Ocean Ave, Tempe, AZ, 852850.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420779CLMBenjamin Gibson1990-11-28——559 Canyon Rd Apt 35, Columbus, OH, 432810.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432375CLMDebra Aguilar1995-07-07UHC-12963-51—6008 Sage Ct Apt 24, Gilbert, AZ, 852940.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-401774CLMTyler Taylor2000-06-06UHC-19451-27—9668 Hillcrest Rd, Charlotte, NC, 282710.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-418634CLMAbigail C Harrison1961-11-20——8701 River Rd, Houston, TX, 770260.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413883CLMNicholas W Dixon1948-06-27UHC-09024-5093393036348495 Canyon Rd, Fresno, CA, 937050.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405737CLMChristopher A Austin1944-12-09—54962834308029 Highland Ave Apt 12, Austin, TX, 787150.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-415220CLMLawrence Q Rice1963-11-14—25248959917553 Harbor Blvd, Tampa, FL, 336320.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-406689CLMCharles Larson2003-10-06UHC-12794-9268646227901567 River Rd, Austin, TX, 787910.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-415346CLMMargaret Obrien———4073 Market St, Atlanta, GA, 303110.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-413882CLMNicholas Dixon1947-06-27UHC-09024-50—8495 Canyon Rd, Fresno, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-421490CLMEugene Diaz2001-07-02UHC-33392-38—6968 Main St, Atlanta, GA, 303670.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-418719CLMJohn Henderson1977-06-20UHC-90386-3340960662005437 Meadow Ln, Mesa, AZ, 852150.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416851CLMJames White——85699661472410 Canyon Rd, Chandler, AZ, 852240.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-410103CLMJoseph Herrera1959-04-21——5215 Indian School Rd, Las Vegas, NV, 891490.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-402651CLMCarl Rivera1970-04-01—24074861632998 Canyon Rd, Charlotte, NC, 282120.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426179CLMJose Hunetr2001-02-17——9111 Maple Ave, Seattle, WA, 981000.64SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-402318CLMLaura Alvarado2006-01-21——9722 Hillcrest Rd, Seattle, WA, 981160.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-402317CLMLaura Alvarado2006-01-21——9722 Hillcrest Rd, Seattle, WA, 981160.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-418474CLMJacqueline Mason1993-07-08UHC-70522-46—5140 Cedar Ln, Minneapolis, MN0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409777CLMAbigail Jenkins——72178800875428 Apache Blvd, San Diego, CA, 921850.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425031CLMObrien E Wayne1973-01-20UHC-06710-3545978046841154 Mountain View Dr Apt 37, Denver, CO, 802930.64Name split from “Last, First”Name re-casedDate of birth reformattedUnit split from street+2 more
32,829 rows, page 135 of 657PreviousNext