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-426300CLMPatricia Phillips1959-06-18UHC-63412-3087737520431441 Harbor Blvd, Austin, TX, 787930.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-404344CLMAmy Hanson1938-10-03UHC-42412-56—8796 Bayshore Dr, Columbus, OH, 432400.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-410914CLMDiana Chapman2000-02-08——1885 Pine Dr, Dallas, TX, 752770.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412871CLMNancy L Tran1967-05-04UHC-46507-42—3686 Union St, Phoenix, AZ, 850100.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-422279CLMJuidth Palmer1997-02-02—58927228074983 Pine Dr, Orlando, FL, 328910.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-431187CLMJason Kelley1949-01-20UHC-48760-69—3706 Valley View Dr, Houston, TX0.66Name re-casedDate of birth reformattedZIP missingGender normalised+1 more
CLM-424302CLMJordan Wood—UHC-90845-168863070412289 Lake View Rd, Seattle, WA, 981080.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425190CLMEvelyn N Rice1967-10-20UHC-62137-527614620886456 Palm Dr Apt 31, San Antonio, TX, 782930.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-421476CLMAhmed Perkins1948-08-28UHC-16952-8447994825463105 Main St, Glendale, AZ, 853240.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-410187CLMKyle Dominguez1954-02-12——2026 Elm St, Minneapolis, MN, 554380.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412357CLMMarcus Cooper1952-08-23UHC-91372-60—1213 Indian School Rd, Glendale, AZ0.66Name split from “Last, First”City re-casedZIP missingWhitespace trimmed+1 more
CLM-431315CLMEdward Bruton2004-01-20UHC-96686-3583390891931763 Palm Dr, Mesa, AZ, 852440.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-405359CLMKeith P Guzman1998-01-10UHC-44567-2060271986956289 Main St, Phoenix, AZ, 850620.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
CLM-424435CLMDJunk1956-11-20UHC-07576-73—4566 Spring St, Tucson, AZ, 857610.66Date of birth reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared+1 more
CLM-407967CLMEvelyn Perry1955-01-16—79197568414210 Ridge Rd, Fresno, CA, 937340.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-410871CLMGerald Bennett1978-08-07UHC-84632-4151080651934382 Canyon Rd, Columbus, OH, 432340.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-411276CLMFrank Lawrence1979-09-09UHC-94025-69—8715 Grand Ave, Atlanta, GA, 303640.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-421295CLMHarrold Espinoza1984-09-28UHC-90072-37—3889 Canyon Rd, Glendale, AZ, 853020.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-417625CLMKeith Bell1989-12-22—31550234299563 Willow Ct, Tempe, AZ, 852680.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-405301CLMArthur McCoy1992-06-08UHC-19480-10—5703 Pine Dr, Plano, TX, 750950.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-432089CLMBrittany Garrett1970-01-05UHC-07264-35—3896 Hillcrest Rd # 801, Los Angeles, CA, 900310.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-432554CLMSandra Sccott1974-11-01——3389 Harbor Blvd, Las Vegas, NV, 891580.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-410653CLMScott Chapman1985-07-03UHC-81314-71—1910 Washington St, Scottsdale, AZ, 852970.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-416342CLMAmanda Watkins1955-12-16UHC-36888-3139773965226908 Pine Dr, Tampa, FL, 336550.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-404649CLMMary Wilson2008-01-16—95139095545888 Canyon Rd # 349, Los Angeles, CA, 900790.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-414564CLMGabriel Y Garza1957-01-11UHC-15449-7155952128595766 Baseline Rd, Charlotte, NC, 282920.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-426296CLMDorothy Smith2003-10-07UHC-01581-36—4335 Baseline Rd, Denver, CO, 802990.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-432806CLMCarlos K Payne—UHC-13103-9689738812683843 Broadway, Houston, TX, 770400.66Name re-casedDate of birth unreadableState name converted to codeWhitespace trimmed+1 more
CLM-432807CLMCarlos K Payne—UHC-13103-9689738812683843 Broadway, Houston, TX, 770400.66Name re-casedDate of birth unreadableState name converted to codeWhitespace trimmed+1 more
CLM-419284CLMGary C Powll1946-02-02UHC-27498-352497318290—0.66Middle initial moved out of first nameDate of birth reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-400863CLMJoan I Lane———573 Willow Ct, Plano, TX, 750010.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-422151CLMJason Espinoza1941-09-04—4345411814764 Indian School Rd, Dallas, TX, 752020.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-413167CLMLogan Phillips1966-04-21——3710 Mountain View Dr, Orlando, FL, 328510.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-423347CLMStephen Fernandez1944-08-17UHC-00238-9094834542675103 Lake View Rd, Phoenix, AZ, 850720.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-405618CLMWillie L Schmidt1978-04-21UHC-26025-53—5446 Forest Ave, Charlotte, NC, 282010.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-418720CLMRalph Bell1976-11-03——8457 Apache Blvd, Tempe, AZ, 852010.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-408810CLMEric Ford1971-07-12UHC-06150-22—5382 Willow Ct, Columbus, OH, 432950.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-427372CLMValentina Griffin1968-09-04UHC-04517-60—6018 Washington St, Nashville, TN, 372860.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-401170CLMAnna Lawrence—UHC-95417-06—9750 Sage Ct, Las Vegas, NV, 891120.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421988CLMJanice Riley2007-10-04—20132642997419 Spring St, San Antonio, TX, 782280.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-406219CLMFrank Armstrong1977-11-07UHC-73728-1447972285568373 Mesa Dr, Seattle, WA, 981000.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-411625CLMSofia Diaz1946-07-22UHC-68006-93—5821 Church St, San Antonio, TX, 782460.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-420851CLMJulia McDonald1990-11-24UHC-03252-2036066432577526 Hillcrest Rd, Plano, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-413478CLMNoah Moreno1950-01-19UHC-70253-94—2347 Bayshore Dr # 591, Charlotte, NC, 282830.66Name re-casedUnit split from streetCity re-casedGender normalised+1 more
CLM-421701CLMAlbert K Gonzalez1968-09-15UHC-36932-95—9216 Indian School Rd, Mesa, AZ, 852000.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-416234CLMWalter Garcia1973-08-07UHC-07415-31—723 Maple Ave, Miami, FL, 331170.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-402748CLMPatrick Grant1963-01-08UHC-33514-97—592 Apache Blvd, Atlanta, GA, 303720.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-422478CLMTeresa Fox1981-12-23UHC-90462-01—4557 Palm Dr, Orlando, FL, 328650.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-428587CLMJoseph E Porter2007-06-07——1656 Church St, Orlando, FL, 328330.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-402274CLMAdam Collyns1979-12-23UHC-52575-7746657211464869 Willow Ct # 683, Columbus, OH, 432900.66Phone reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
32,829 rows, page 189 of 657PreviousNext