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-423759CLMJudith F Oliver1994-10-18——7142 Forest Ave, Tampa, FL, 336770.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-431198CLMWayne Romero1945-03-26—44678681917933 Maple Ave, Seattle, WA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-423578CLMArthur Garrett1991-02-17UHC-98433-73—4997 Camelback Rd, Miami, FL, 331220.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-416884CLMDanielle Garza1996-10-19UHC-85381-1660628649363040 Spring St # 890, Glendale, AZ, 853710.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-415370CLMMichelle Gutierrez1979-03-25——7289 Lincoln Way, Jacksonville, FL, 322730.52SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-402992CLMCarl Morgan1992-08-12UHC-90910-902293914072459 Indian School Rd, Los Angeles, CA0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429946CLMNathan Stephens1963-05-09UHC-96209-03—4241 Mesa Dr, Minneapolis, MN, 554990.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-405470CLMNathan Obrien—UHC-35857-33—9887 Apache Blvd, Tempe, AZ, 852000.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-420649CLMRalph Nichols1962-06-14UHC-69144-34—5689 Lincoln Way, Chandler, AZ, 852690.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-405955CLMEugene Carlson1993-08-18UHC-73643-65—7646 Ridge Rd, Phoenix, AZ, 850510.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400384CLMSusan Freeman1948-01-26UHC-73337-8641825352458141 Pine Dr, Sacramento, CA, 958100.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-412198CLMMark Tran1961-04-26——427 Washington St, San Diego, CA, 921640.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-419612CLMCynthia Banks1996-04-05UHC-21793-89—8267 Ridge Rd, Minneapolis, MN, 554890.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430845CLMEmma Richardson1955-11-07UHC-56071-9865389119084375 Ridge Rd, Eden Prairie, MN, 553130.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408892CLMJean W Carr1969-06-27UHC-65157-91—901 Central Ave, Los Angeles, CA, 900950.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
CLM-410949CLMLawrence Ortega1984-07-09—96320233131931 Lake View Rd, Plano, TX, 750900.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-424519CLMCarlos Kelly1978-01-20UHC-55263-23—4048 Palm Dr, Jacksonville, FL, 322670.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-410062CLMJerry Flores1995-09-19—39860943299045 Indian School Rd, Glendale, AZ, 853900.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418712CLMJanice West1946-05-25UHC-30537-94—207 Meadow Ln, Chandler, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-413010CLMMary Y Powell—UHC-10162-8033260729682667 Indian School Rd Apt 37, Atlanta, GA, 303360.52Name re-casedDate of birth unreadablePhone reformattedUnit split from street+2 more
CLM-422620CLMDaniielle Lee1975-10-25UHC-50635-73—7026 Jefferson Ave Apt 14, Atlanta, GA, 303060.52Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-421052CLMFrank Howard1984-09-13UHC-75968-98—4846 Elm St, Glendale, AZ0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-400916CLMChristian Hudson1969-07-28UHC-86325-7275725039347305 Market St, Charlotte, NC, 282100.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-410002CLMPriya McDonald2007-08-25UHC-04817-13—5470 Market St Apt 30, Tucson, AZ, 857080.52Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
CLM-408043CLMJoyce Andrews1954-12-28UHC-46410-68—1441 Park Pl, Tucson, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-428981CLMHelen H Bishop1992-01-16——1149 Forest Ave, Chandler, AZ, 852530.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427562CLMRoy Morales1978-03-23UHC-84648-8075947304858768 Canyon Rd, San Antonio, TX, 782820.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429267CLMTerry Russell1940-06-04UHC-49834-84—8387 Apache Blvd Apt 25, Charlotte, NC, 282040.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-409921CLMAlexis Ruiz1973-05-05——3858 Harbor Blvd, Sacramento, CA, 958280.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-418913CLMNatalie Gray1947-07-07UHC-63669-9781795708788297 Lincoln Way Apt 37, Charlotte, NC, 282150.52Name split from “Last, First”Unit split from streetCity re-casedGender normalised+2 more
CLM-427120CLMLisa Graham1956-08-06UHC-69384-55—6089 Apache Blvd, Eden Prairie, MN, 553770.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-407651CLMJacob Mills1971-01-05UHC-03929-94—824 Elm St # 865, Seattle, WA0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425660CLMArthur Taylor1957-04-05UHC-31787-4995524618817573 Baseline Rd, Atlanta, GA, 303730.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413525CLMBenjamin Peters2006-10-23UHC-96567-22—8029 Mesa Dr, Houston, TX, 770140.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-425972CLMNatalie Johnston——51442237948028 Camelback Rd, Denver, CO, 802810.52Name split from “Last, First”Date of birth unreadablePhone reformattedZIP+4 trimmed+2 more
CLM-406342CLMAmber Tucker1995-05-03UHC-44715-06—8124 Camelback Rd, Sacramento, CA, 958010.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-406343CLMAmber Tucker1995-05-03UHC-44715-06—8124 Camelback Rd, Sacramento, CA, 958010.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-421114CLMKathryn Gutierrez2000-11-17UHC-77738-1928533338421505 Palm Dr # 577, Austin, TX, 787440.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420525CLMDenise Ramos1960-12-10UHC-80996-855257937763899 Forest Ave # 582, Denver, CO, 802560.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-426907CLMFrank Garcia1940-07-01UHC-99822-51—9059 Market St, Denver, CO, 802680.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415030CLMLori Campbell1985-03-01UHC-11917-9149344771663207 Valley View Dr, Orlando, FL, 328900.52Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-416732CLMKathryn I Henderson1953-11-28UHC-09847-52—4192 Market St, Las Vegas, NV, 891340.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406194CLMFatima R Perkins1992-04-14UHC-00138-756414426679107 Central Ave, Jacksonville, FL, 322100.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420322CLMJudith Price2003-12-14UHC-74259-56—1389 Highland Ave # 415, Mesa, AZ, 852690.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403966CLMMark Crawford—UHC-80518-14—9452 Mesa Dr, Eden Prairie, MN, 553980.52Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-421290CLMHelen Guerrero—UHC-70876-54—3231 Baseline Rd, Glendale, AZ, 853290.52Date of birth missingPhone missing area codeCity re-casedState name converted to code+2 more
CLM-411628CLMArthur Matthews1958-09-05——8260 Palm Dr, Plano, TX, 750350.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415879CLMBetty Hrat1993-04-17UHC-32493-85—4852 Union St, Charlotte, NC, 282290.52Name re-casedTwo-digit birth yearPhone missing area codeGender normalised+2 more
CLM-400297CLMDouglas George1985-12-18UHC-91044-29—9884 River Rd, Tempe, AZ, 852170.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-408807CLMWilson Beverly—UHC-39470-08—6056 Forest Ave, Jacksonville, FL, 322890.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
32,829 rows, page 46 of 657PreviousNext